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