From b3ebb9c9264c595e70cfb7daa74917b14de06d60 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 2 Mar 2016 20:28:33 -0500 Subject: [PATCH] LP#1392396: stamp DB update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ew_user_created_notice.sql => 0968.data.new_user_created_notice.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.new_user_created_notice.sql => 0968.data.new_user_created_notice.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 71ff514cb2..1ec157b2e3 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 ('0967', :eg_version); -- jboyer/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0968', :eg_version); -- jstompro/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.new_user_created_notice.sql b/Open-ILS/src/sql/Pg/upgrade/0968.data.new_user_created_notice.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.new_user_created_notice.sql rename to Open-ILS/src/sql/Pg/upgrade/0968.data.new_user_created_notice.sql index 3b5f13c99e..6bff0068f9 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.new_user_created_notice.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0968.data.new_user_created_notice.sql @@ -1,5 +1,7 @@ BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0968', :eg_version); -- jstompro/gmcharlt + --create hook for actor.usr.create_date INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ('au.created', 'au', 'A user was created', 't'); -- 2.11.0