From a3c5eb0642a150003cf5841ec96ad131d51ae399 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Fri, 24 Mar 2023 14:52:56 -0400 Subject: [PATCH] Remove Gender Patron Statistical Category in DB Upgrade Signed-off-by: Jason Stephenson --- .../Pg/version-upgrade/cwmars-3.7.3-3.7.4-upgrade-db.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.7.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.7.4-upgrade-db.sql index 76c1c6058e..00f6352a7c 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.7.4-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.7.4-upgrade-db.sql @@ -172,3 +172,17 @@ VALUES END $$; + +\qecho Remove Gender Patron Statistical Category +BEGIN; + +DELETE FROM actor.stat_cat_entry_usr_map +WHERE stat_cat = 1; + +DELETE FROM actor.stat_cat_entry +WHERE stat_cat = 1; + +DELETE FROM actor.stat_cat +WHERE id = 1; + +COMMIT; -- 2.11.0