From 15ecabc43187a85e9913adb880832f430a7d6ed2 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 24 Mar 2022 15:17:39 -0400 Subject: [PATCH] Stamping upgrade script for Simple Reporter (permission ID adjusted) Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...XXX.schema.simple_reporter.sql => 1320.schema.simple_reporter.sql} | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.simple_reporter.sql => 1320.schema.simple_reporter.sql} (95%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 12f7e53117..fc6c692886 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,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 ('1319', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1320', :eg_version); -- jboyer/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.simple_reporter.sql b/Open-ILS/src/sql/Pg/upgrade/1320.schema.simple_reporter.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.simple_reporter.sql rename to Open-ILS/src/sql/Pg/upgrade/1320.schema.simple_reporter.sql index a06d641d41..985a1d6212 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.simple_reporter.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1320.schema.simple_reporter.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); -- jboyer / / +SELECT evergreen.upgrade_deps_block_check('1320', :eg_version); -- jboyer / / ALTER TABLE reporter.template_folder ADD COLUMN simple_reporter BOOLEAN DEFAULT FALSE; ALTER TABLE reporter.report_folder ADD COLUMN simple_reporter BOOLEAN DEFAULT FALSE; @@ -22,7 +22,7 @@ $$ LANGUAGE SQL; -- Hey committer, make sure this id is good to go and also in 950.data.seed-values.sql INSERT INTO permission.perm_list (id, code, description) VALUES - ( 636, 'RUN_SIMPLE_REPORTS', oils_i18n_gettext(636, + ( 638, 'RUN_SIMPLE_REPORTS', oils_i18n_gettext(638, 'Build and run simple reports', 'ppl', 'description')); -- 2.11.0