diff options
Diffstat (limited to 'maintenance/sqlite/archives/patch-ufg_group-length-increase-255.sql')
-rw-r--r-- | maintenance/sqlite/archives/patch-ufg_group-length-increase-255.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/maintenance/sqlite/archives/patch-ufg_group-length-increase-255.sql b/maintenance/sqlite/archives/patch-ufg_group-length-increase-255.sql new file mode 100644 index 00000000..edd0a3dc --- /dev/null +++ b/maintenance/sqlite/archives/patch-ufg_group-length-increase-255.sql @@ -0,0 +1,15 @@ + CREATE TABLE /*_*/user_former_groups_tmp ( + ufg_user int unsigned NOT NULL default 0, + ufg_group varbinary(255) NOT NULL default '' +) /*$wgDBTableOptions*/; + +INSERT INTO /*_*/user_former_groups_tmp + SELECT ufg_user, ufg_group + FROM /*_*/user_former_groups; + +DROP TABLE /*_*/user_former_groups; + +ALTER TABLE /*_*/user_former_groups_tmp RENAME TO /*_*/user_former_groups; + +CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group); + |