Stamping upgrade scripts for LP#818740
authorThomas Berezansky <tsbere@mvlc.org>
Tue, 9 Aug 2011 18:14:18 +0000 (14:14 -0400)
committerThomas Berezansky <tsbere@mvlc.org>
Tue, 9 Aug 2011 18:14:18 +0000 (14:14 -0400)
Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/upgrade/0595.data.org-setting-ui.patron_search.result_cap.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-ui.patron_search.result_cap.sql [deleted file]

index a8c2e9f..b386c5b 100644 (file)
@@ -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');
 
     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 ('0594', :eg_version); -- phasefx/miker
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0595', :eg_version); -- phasefx/tsbere
 
 CREATE TABLE config.bib_source (
        id              SERIAL  PRIMARY KEY,
 
 CREATE TABLE config.bib_source (
        id              SERIAL  PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/0595.data.org-setting-ui.patron_search.result_cap.sql b/Open-ILS/src/sql/Pg/upgrade/0595.data.org-setting-ui.patron_search.result_cap.sql
new file mode 100644 (file)
index 0000000..0751d45
--- /dev/null
@@ -0,0 +1,30 @@
+-- Evergreen DB patch 0595.data.org-setting-ui.patron_search.result_cap.sql
+--
+-- New org setting ui.patron_search.result_cap
+--
+BEGIN;
+
+-- check whether patch can be applied
+SELECT evergreen.upgrade_deps_block_check('0595', :eg_version);
+
+INSERT INTO config.org_unit_setting_type ( name, label, description, datatype )
+    VALUES (
+        'ui.patron_search.result_cap',
+        oils_i18n_gettext(
+            'ui.patron_search.result_cap',
+            'GUI: Cap results in Patron Search at this number.',
+            'coust',
+            'label'
+        ),
+        oils_i18n_gettext(
+            'ui.patron_search.result_cap',
+            'So for example, if you search for John Doe, normally you would get'
+            || ' at most 50 results.  This setting allows you to raise or lower'
+            || ' that limit.',
+            'coust',
+            'description'
+        ),
+        'integer'
+    );
+
+COMMIT;
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-ui.patron_search.result_cap.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-ui.patron_search.result_cap.sql
deleted file mode 100644 (file)
index aacc6c9..0000000
+++ /dev/null
@@ -1,30 +0,0 @@
--- Evergreen DB patch XXXX.data.org-setting-ui.patron_search.result_cap.sql
---
--- New org setting ui.patron_search.result_cap
---
-BEGIN;
-
--- check whether patch can be applied
-SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
-
-INSERT INTO config.org_unit_setting_type ( name, label, description, datatype )
-    VALUES (
-        'ui.patron_search.result_cap',
-        oils_i18n_gettext(
-            'ui.patron_search.result_cap',
-            'GUI: Cap results in Patron Search at this number.',
-            'coust',
-            'label'
-        ),
-        oils_i18n_gettext(
-            'ui.patron_search.result_cap',
-            'So for example, if you search for John Doe, normally you would get'
-            || ' at most 50 results.  This setting allows you to raise or lower'
-            || ' that limit.',
-            'coust',
-            'description'
-        ),
-        'integer'
-    );
-
-COMMIT;