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