LP#1764542: Fixing upgrade script stamping

Last commit deleted it, not changed it.  Repairing issue.

Signed-off-by: Ben Shum <ben@evergreener.net>

diff --git a/Open-ILS/src/sql/Pg/upgrade/1136.schema.lp1764542-mods33-update.sql b/Open-ILS/src/sql/Pg/upgrade/1136.schema.lp1764542-mods33-update.sql
new file mode 100644 (file)
index 0000000..9cf889e
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/1136.schema.lp1764542-mods33-update.sql
@@ -0,0 +1,12 @@
+BEGIN;
+
+SELECT evergreen.upgrade_deps_block_check('1136', :eg_version);
+
+-- update mods33 data entered by 1100 with a format of 'mods32'
+-- harmless if you have not run 1100 yet
+UPDATE config.metabib_field SET format = 'mods33' WHERE format = 'mods32' and id in (38, 39, 40, 41, 42, 43, 44, 46, 47, 48, 49, 50);
+
+-- change the default format to 'mods33'
+ALTER TABLE config.metabib_field ALTER COLUMN format SET DEFAULT 'mods33'::text;
+
+COMMIT;