From d3bf88739ea88768d92831062219f76f58b6a1e3 Mon Sep 17 00:00:00 2001
From: Dan Scott <dscott@laurentian.ca>
Date: Sun, 4 Mar 2012 12:28:51 -0500
Subject: [PATCH] Number the autosuggest normalization upgrade script
Signed-off-by: Dan Scott <dscott@laurentian.ca>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
...-normalize.sql => 0679.schema.autosuggest.search-normalize.sql} | 7 ++++++-
2 files changed, 7 insertions(+), 2 deletions(-)
rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.autosuggest.search-normalize.sql => 0679.schema.autosuggest.search-normalize.sql} (96%)
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 66d37a8d12..4c1bc1e89b 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -86,7 +86,7 @@ CREATE TRIGGER no_overlapping_deps
BEFORE INSERT OR UPDATE ON config.db_patch_dependencies
FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates');
-INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0678', :eg_version); -- berick/miker
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0679', :eg_version); -- berick/miker
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.autosuggest.search-normalize.sql b/Open-ILS/src/sql/Pg/upgrade/0679.schema.autosuggest.search-normalize.sql
similarity index 96%
rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.autosuggest.search-normalize.sql
rename to Open-ILS/src/sql/Pg/upgrade/0679.schema.autosuggest.search-normalize.sql
index 4aca7139c7..d82af47df9 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.autosuggest.search-normalize.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/0679.schema.autosuggest.search-normalize.sql
@@ -1,6 +1,11 @@
BEGIN;
-SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
+SELECT evergreen.upgrade_deps_block_check('0679', :eg_version);
+
+-- Address typo in column name
+ALTER TABLE config.metabib_class ADD COLUMN buoyant BOOL DEFAULT FALSE NOT NULL;
+UPDATE config.metabib_class SET buoyant = bouyant;
+ALTER TABLE config.metabib_class DROP COLUMN bouyant;
CREATE OR REPLACE FUNCTION oils_tsearch2 () RETURNS TRIGGER AS $$
DECLARE
--
2.11.0