From 225b9c84332d4db282e12c398515e539fbed96d5 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 25 Apr 2017 09:55:00 -0400 Subject: [PATCH] LP#1545115: consolidate schema update scripts into one Signed-off-by: Galen Charlton --- .../upgrade/XXXX.schema.policy_matrix_description_field.sql | 11 +++++++++++ .../Pg/upgrade/xxxx.schema.add_description_circ_matrix.sql | 6 ------ .../Pg/upgrade/xxxx.schema.add_description_hold_matrix.sql | 6 ------ 3 files changed, 11 insertions(+), 12 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.policy_matrix_description_field.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_circ_matrix.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_hold_matrix.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.policy_matrix_description_field.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.policy_matrix_description_field.sql new file mode 100644 index 0000000000..dda68a1d19 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.policy_matrix_description_field.sql @@ -0,0 +1,11 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +ALTER TABLE config.hold_matrix_matchpoint + ADD COLUMN description TEXT; + +ALTER TABLE config.circ_matrix_matchpoint + ADD COLUMN description TEXT; + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_circ_matrix.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_circ_matrix.sql deleted file mode 100644 index a461c4b095..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_circ_matrix.sql +++ /dev/null @@ -1,6 +0,0 @@ -BEGIN; - -ALTER TABLE config.circ_matrix_matchpoint - ADD COLUMN description TEXT; - -COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_hold_matrix.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_hold_matrix.sql deleted file mode 100644 index f65fc133a1..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_description_hold_matrix.sql +++ /dev/null @@ -1,6 +0,0 @@ -BEGIN; - -ALTER TABLE config.hold_matrix_matchpoint - ADD COLUMN description TEXT; - -COMMIT; -- 2.11.0