1 CREATE TABLE /*_*/user_former_groups_tmp (
2 ug_user int unsigned NOT NULL default 0,
3 ug_group varbinary(32) NOT NULL default ''
4 ) /*$wgDBTableOptions*/;
6 INSERT INTO /*_*/user_former_groups_tmp
7 SELECT ug_user, ug_group
10 DROP TABLE /*_*/user_former_groups;
12 ALTER TABLE /*_*/user_former_groups_tmp RENAME TO /*_*/user_former_groups;
14 CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group);