summaryrefslogtreecommitdiff
path: root/maintenance/oracle/archives/patch-ufg_group-length-increase.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/oracle/archives/patch-ufg_group-length-increase.sql')
-rw-r--r--maintenance/oracle/archives/patch-ufg_group-length-increase.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/maintenance/oracle/archives/patch-ufg_group-length-increase.sql b/maintenance/oracle/archives/patch-ufg_group-length-increase.sql
new file mode 100644
index 00000000..a48b8bff
--- /dev/null
+++ b/maintenance/oracle/archives/patch-ufg_group-length-increase.sql
@@ -0,0 +1,9 @@
+define mw_prefix='{$wgDBprefix}';
+
+/*$mw$*/
+BEGIN
+ EXECUTE IMMEDIATE 'ALTER TABLE &mw_prefix.user_former_groups MODIFY ufg_group VARCHAR2(32) NOT NULL';
+EXCEPTION WHEN OTHERS THEN
+ IF (SQLCODE = -01442) THEN NULL; ELSE RAISE; END IF;
+END;
+/*$mw$*/