From 6f599fa7378cb4c59d81d927b96d42235ab81fcb Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 28 Jul 2011 12:34:28 -0400 Subject: [PATCH] Stamped upgrade for user/dbs/oclcnumbers Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...reness.sql => 0587.maintain_control_numbers_with_OCLC_awareness.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{xxxx.maintain_control_numbers_with_OCLC_awareness.sql => 0587.maintain_control_numbers_with_OCLC_awareness.sql} (98%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index bbc447567f..9b11ed685f 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -57,7 +57,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0583'); -- miker/gmcharlt +INSERT INTO config.upgrade_log (version) VALUES ('0587'); -- dbs/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.maintain_control_numbers_with_OCLC_awareness.sql b/Open-ILS/src/sql/Pg/upgrade/0587.maintain_control_numbers_with_OCLC_awareness.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/xxxx.maintain_control_numbers_with_OCLC_awareness.sql rename to Open-ILS/src/sql/Pg/upgrade/0587.maintain_control_numbers_with_OCLC_awareness.sql index 784744de72..ce7638c37f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.maintain_control_numbers_with_OCLC_awareness.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0587.maintain_control_numbers_with_OCLC_awareness.sql @@ -1,5 +1,7 @@ BEGIN; +INSERT INTO config.upgrade_log (version) VALUES ('0587'); -- dbs/berick + CREATE OR REPLACE FUNCTION maintain_control_numbers() RETURNS TRIGGER AS $func$ use strict; use MARC::Record; -- 2.11.0