From 29078c6aa882fafe1c809f9f88a07394f45bbcf9 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 13 Oct 2009 13:58:37 +0000 Subject: [PATCH] Fix the upgrade script that adds ingest normalizer schema changes git-svn-id: svn://svn.open-ils.org/ILS/trunk@14397 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- ...0032.ingest-normalizers.sql => 0032.schema.ingest-normalizers.sql} | 4 ++++ 1 file changed, 4 insertions(+) rename Open-ILS/src/sql/Pg/upgrade/{0032.ingest-normalizers.sql => 0032.schema.ingest-normalizers.sql} (88%) diff --git a/Open-ILS/src/sql/Pg/upgrade/0032.ingest-normalizers.sql b/Open-ILS/src/sql/Pg/upgrade/0032.schema.ingest-normalizers.sql similarity index 88% rename from Open-ILS/src/sql/Pg/upgrade/0032.ingest-normalizers.sql rename to Open-ILS/src/sql/Pg/upgrade/0032.schema.ingest-normalizers.sql index 2fdd6cd5f5..8412ccfcde 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0032.ingest-normalizers.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0032.schema.ingest-normalizers.sql @@ -1,3 +1,6 @@ +-- ARG! need to rid ourselves of the broken table definition ... this mechanism is not ideal, sorry. +DROP TABLE config.index_normalizer CASCADE; + BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('0032'); -- miker @@ -25,6 +28,7 @@ $func$ LANGUAGE SQL STRICT IMMUTABLE; CREATE TABLE config.index_normalizer ( id SERIAL PRIMARY KEY, name TEXT UNIQUE NOT NULL, + name TEXT UNIQUE NOT NULL, func TEXT NOT NULL, param_count INT NOT NULL DEFAULT 0 ); -- 2.11.0