From 3341913654605eff25ec1360fe15bff6a6a6f172 Mon Sep 17 00:00:00 2001 From: gmc Date: Fri, 13 May 2011 13:25:27 +0000 Subject: [PATCH] for upgrade, let prefix and suffix in audit be null Signed-off-by: Galen Charlton git-svn-id: svn://svn.open-ils.org/ILS/trunk@20466 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../sql/Pg/upgrade/0531.schema.auditor_affixes.sql | 8 ++------ 1 files changed, 2 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0531.schema.auditor_affixes.sql b/Open-ILS/src/sql/Pg/upgrade/0531.schema.auditor_affixes.sql index 5cb11d0..b8d010f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0531.schema.auditor_affixes.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0531.schema.auditor_affixes.sql @@ -3,11 +3,7 @@ BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('0531'); --gmc ALTER TABLE auditor.asset_call_number_history - ADD COLUMN prefix INT NOT NULL DEFAULT -1, - ADD COLUMN suffix INT NOT NULL DEFAULT -1; - -ALTER TABLE auditor.asset_call_number_history - ALTER COLUMN prefix DROP DEFAULT, - ALTER COLUMN suffix DROP DEFAULT; + ADD COLUMN prefix INT, + ADD COLUMN suffix INT; COMMIT; -- 1.7.2.5