From b4737a6d750bca90912133b107d11ed4cbceaa14 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 1 Apr 2020 11:11:06 -0400 Subject: [PATCH] add pre-3.4.2 upgrade script --- Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.4.2-upgrade.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.4.2-upgrade.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.4.2-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.4.2-upgrade.sql new file mode 100644 index 0000000000..bccd3efee1 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-3.4.2-upgrade.sql @@ -0,0 +1,6 @@ +begin; + +-- remove duplicate rows from actor.workstation settings +delete from actor.workstation_setting t1 using actor.workstation_setting t2 where t1.id < t2.id and t1.workstation = t2.workstation and t1.name = t2.name; + +commit; -- 2.11.0