Stamping upgrade script for Simple Reporter (permission ID adjusted)

Signed-off-by: Mike Rylander <mrylander@gmail.com>

diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 12f7e53..fc6c692 100644 (file)
--- 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 a06d641..985a1d6 100644 (file)
--- 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'));