1 CREATE TABLE /*_*/user_former_groups_tmp (
2 ufg_user
int unsigned
NOT NULL default 0,
3 ufg_group
varbinary(255) NOT NULL default ''
4 ) /*$wgDBTableOptions*/;
6 INSERT INTO /*_*/user_former_groups_tmp
7 SELECT ufg_user
, ufg_group
8 FROM /*_*/user_former_groups
;
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
);