From d316f103283b731cae326f61f8f3a36a1c7b4fa3 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Wed, 19 Aug 2015 13:52:07 -0400 Subject: [PATCH] LP 1485794: Stamping web staff client sprint2 upgrade scripts. Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ema.marc-tag-tables.sql => 0933.schema.marc-tag-tables.sql} | 3 +++ ...a.marc21-tag-tables.sql => 0934.data.marc21-tag-tables.sql} | 2 ++ ...ble-permissions.sql => 0935.data.tag-table-permissions.sql} | 2 +- ...trs.sql => 0936.schema.fix_ingest_of_xpath_based_attrs.sql} | 2 +- ....sql => 0937.schema.teach_record_attributes_about_skos.sql} | 2 ++ ...me_rda_attributes.sql => 0938.data.some_rda_attributes.sql} | 2 ++ 7 files changed, 12 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{lp1427287_1of3.schema.marc-tag-tables.sql => 0933.schema.marc-tag-tables.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{lp1427287_2of3.data.marc21-tag-tables.sql => 0934.data.marc21-tag-tables.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{lp1427287_3of3.data.tag-table-permissions.sql => 0935.data.tag-table-permissions.sql} (75%) rename Open-ILS/src/sql/Pg/upgrade/{lp1442796_1of1.schema.fix_ingest_of_xpath_based_attrs.sql => 0936.schema.fix_ingest_of_xpath_based_attrs.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{lp1442815_1of2.schema.teach_record_attributes_about_skos.sql => 0937.schema.teach_record_attributes_about_skos.sql} (71%) rename Open-ILS/src/sql/Pg/upgrade/{lp1442815_2of2.data.some_rda_attributes.sql => 0938.data.some_rda_attributes.sql} (99%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 02cea6886d..9eeb5426e1 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0932', :eg_version); -- kmlussier/dyrcona +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0938', :eg_version); -- gmcharlt/miker/berick/phasefx/dyrcona CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/lp1427287_1of3.schema.marc-tag-tables.sql b/Open-ILS/src/sql/Pg/upgrade/0933.schema.marc-tag-tables.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/lp1427287_1of3.schema.marc-tag-tables.sql rename to Open-ILS/src/sql/Pg/upgrade/0933.schema.marc-tag-tables.sql index 1c3282474a..a236048118 100644 --- a/Open-ILS/src/sql/Pg/upgrade/lp1427287_1of3.schema.marc-tag-tables.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0933.schema.marc-tag-tables.sql @@ -1,5 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0933', :eg_version); + + CREATE TABLE config.marc_format ( id SERIAL PRIMARY KEY, code TEXT NOT NULL, diff --git a/Open-ILS/src/sql/Pg/upgrade/lp1427287_2of3.data.marc21-tag-tables.sql b/Open-ILS/src/sql/Pg/upgrade/0934.data.marc21-tag-tables.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/lp1427287_2of3.data.marc21-tag-tables.sql rename to Open-ILS/src/sql/Pg/upgrade/0934.data.marc21-tag-tables.sql index aafee0b6c1..0ba2f64f6a 100644 --- a/Open-ILS/src/sql/Pg/upgrade/lp1427287_2of3.data.marc21-tag-tables.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0934.data.marc21-tag-tables.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0934', :eg_version); + INSERT INTO config.marc_format(id, code, name) VALUES (1, 'marc21', 'MARC 21'); SELECT SETVAL('config.marc_format_id_seq', 100); ALTER SEQUENCE config.marc_field_id_seq RESTART WITH 1; diff --git a/Open-ILS/src/sql/Pg/upgrade/lp1427287_3of3.data.tag-table-permissions.sql b/Open-ILS/src/sql/Pg/upgrade/0935.data.tag-table-permissions.sql similarity index 75% rename from Open-ILS/src/sql/Pg/upgrade/lp1427287_3of3.data.tag-table-permissions.sql rename to Open-ILS/src/sql/Pg/upgrade/0935.data.tag-table-permissions.sql index b841299e41..9c11899747 100644 --- a/Open-ILS/src/sql/Pg/upgrade/lp1427287_3of3.data.tag-table-permissions.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0935.data.tag-table-permissions.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('ZZZZ', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0935', :eg_version); INSERT INTO permission.perm_list ( code, description ) VALUES ( 'ADMIN_TAG_TABLE', oils_i18n_gettext( '', diff --git a/Open-ILS/src/sql/Pg/upgrade/lp1442796_1of1.schema.fix_ingest_of_xpath_based_attrs.sql b/Open-ILS/src/sql/Pg/upgrade/0936.schema.fix_ingest_of_xpath_based_attrs.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/lp1442796_1of1.schema.fix_ingest_of_xpath_based_attrs.sql rename to Open-ILS/src/sql/Pg/upgrade/0936.schema.fix_ingest_of_xpath_based_attrs.sql index 530a16ecdf..46cd257cb6 100644 --- a/Open-ILS/src/sql/Pg/upgrade/lp1442796_1of1.schema.fix_ingest_of_xpath_based_attrs.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0936.schema.fix_ingest_of_xpath_based_attrs.sql @@ -3,7 +3,7 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0936', :eg_version); CREATE OR REPLACE FUNCTION metabib.reingest_record_attributes (rid BIGINT, pattr_list TEXT[] DEFAULT NULL, prmarc TEXT DEFAULT NULL, rdeleted BOOL DEFAULT TRUE) RETURNS VOID AS $func$ DECLARE diff --git a/Open-ILS/src/sql/Pg/upgrade/lp1442815_1of2.schema.teach_record_attributes_about_skos.sql b/Open-ILS/src/sql/Pg/upgrade/0937.schema.teach_record_attributes_about_skos.sql similarity index 71% rename from Open-ILS/src/sql/Pg/upgrade/lp1442815_1of2.schema.teach_record_attributes_about_skos.sql rename to Open-ILS/src/sql/Pg/upgrade/0937.schema.teach_record_attributes_about_skos.sql index 0b8de3448b..515dad68e5 100644 --- a/Open-ILS/src/sql/Pg/upgrade/lp1442815_1of2.schema.teach_record_attributes_about_skos.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0937.schema.teach_record_attributes_about_skos.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0937', :eg_version); + ALTER TABLE config.record_attr_definition ADD COLUMN vocabulary TEXT; diff --git a/Open-ILS/src/sql/Pg/upgrade/lp1442815_2of2.data.some_rda_attributes.sql b/Open-ILS/src/sql/Pg/upgrade/0938.data.some_rda_attributes.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/lp1442815_2of2.data.some_rda_attributes.sql rename to Open-ILS/src/sql/Pg/upgrade/0938.data.some_rda_attributes.sql index d05d43bb11..bbc05437c2 100644 --- a/Open-ILS/src/sql/Pg/upgrade/lp1442815_2of2.data.some_rda_attributes.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0938.data.some_rda_attributes.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0938', :eg_version); + INSERT INTO config.record_attr_definition (name, label, format, xpath, vocabulary) VALUES ( 'content_type', oils_i18n_gettext('content_type', 'Content Type', 'ccvm', 'label'), 'marcxml', -- 2.43.2