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