From 21e74a9bf002b5ba885e0a17ae95b5bfbbf6f427 Mon Sep 17 00:00:00 2001 From: dbs Date: Fri, 16 Jul 2010 19:55:37 +0000 Subject: [PATCH] It is important to update the upgrade_log to prevent collisions and such. Updating config.upgrade_log to 0340. git-svn-id: svn://svn.open-ils.org/ILS/trunk@16967 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/0340.schema.serials_remove_owner.sql | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7e6b3f106..69664c832 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -68,7 +68,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0339'); -- dbs +INSERT INTO config.upgrade_log (version) VALUES ('0340'); -- dbs CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/0340.schema.serials_remove_owner.sql b/Open-ILS/src/sql/Pg/upgrade/0340.schema.serials_remove_owner.sql index e2fb634dc..493918cf3 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0340.schema.serials_remove_owner.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0340.schema.serials_remove_owner.sql @@ -2,6 +2,8 @@ -- Adjust the table and affected functions accordingly BEGIN; +INSERT INTO config.upgrade_log (version) VALUES ('0340'); -- dbs + ALTER TABLE serial.record_entry DROP COLUMN owner; CREATE OR REPLACE FUNCTION maintain_control_numbers() RETURNS TRIGGER AS $func$ -- 2.11.0