1 DROP TABLE IF EXISTS /*_*/user_groups_tmp
;
3 CREATE TABLE /*$wgDBprefix*/user_groups_tmp (
4 ug_user
int unsigned
NOT NULL default 0,
5 ug_group
varbinary(255) NOT NULL default '',
6 ug_expiry
varbinary(14) NULL default NULL,
7 PRIMARY KEY (ug_user
, ug_group
)
10 INSERT OR IGNORE INTO /*_*/user_groups_tmp (
14 FROM /*_*/user_groups
;
16 DROP TABLE /*_*/user_groups
;
18 ALTER TABLE /*_*/user_groups_tmp
RENAME TO /*_*/user_groups
;
20 CREATE INDEX /*i*/ug_group
ON /*_*/user_groups (ug_group
);
21 CREATE INDEX /*i*/ug_expiry
ON /*_*/user_groups (ug_expiry
);