Merge "Improve sorting on SpecialWanted*-Pages"

[mediawiki.git] / maintenance / sqlite / archives / patch-ufg_group-length-increase-255.sql

 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);