1 CREATE TABLE /*_*/user_groups_tmp (
2 ug_user
int unsigned
NOT NULL default 0,
3 ug_group
varbinary(255) NOT NULL default ''
4 ) /*$wgDBTableOptions*/;
6 INSERT INTO /*_*/user_groups_tmp
7 SELECT ug_user
, ug_group
10 DROP TABLE /*_*/user_groups
;
12 ALTER TABLE /*_*/user_groups_tmp
RENAME TO /*_*/user_groups
;
14 CREATE UNIQUE INDEX /*i*/ug_user_group
ON /*_*/user_groups (ug_user
,ug_group
);
15 CREATE INDEX /*i*/ug_group
ON /*_*/user_groups (ug_group
);