From 267ebcc752db3c571daa70fa3e8ea66ece614568 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 16 Dec 2013 06:03:33 -0500 Subject: [PATCH] 2.5.0 includes "Long Overdue", which adds its own copy status, so we change our existing config.copy_status from "Long Overdue" to "Long Overdue (Legacy)" --- Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql index 3394d3a6c2..c5cbc82bc1 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-pre-2.3-2.4.0-upgrade-db.sql @@ -4,6 +4,9 @@ BEGIN; DROP SCHEMA troup CASCADE; DROP SCHEMA tcpls CASCADE; +-- change the existing Long Overdue copy status to make room for the new one +UPDATE config.copy_status SET name = 'Long Overdue (Legacy)' WHERE name = 'Long Overdue'; + -- drop a function with dependencies that get removed DROP FUNCTION search.staged_fts(integer,integer,text,integer[],text[],text[],text[],text[],text[],text[],text,real,text,boolean,boolean,boolean,integer,integer,integer); DROP AGGREGATE agg_tsvector(public.tsvector); -- 2.11.0