blob: 7fc89416097397f03a7ce7e2b2b211bddb50f33a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
DROP TABLE IF EXISTS /*_*/user_groups_tmp;
CREATE TABLE /*$wgDBprefix*/user_groups_tmp (
ug_user int unsigned NOT NULL default 0,
ug_group varbinary(255) NOT NULL default '',
ug_expiry varbinary(14) NULL default NULL,
PRIMARY KEY (ug_user, ug_group)
);
INSERT OR IGNORE INTO /*_*/user_groups_tmp (
ug_user, ug_group )
SELECT
ug_user, ug_group
FROM /*_*/user_groups;
DROP TABLE /*_*/user_groups;
ALTER TABLE /*_*/user_groups_tmp RENAME TO /*_*/user_groups;
CREATE INDEX /*i*/ug_group ON /*_*/user_groups (ug_group);
CREATE INDEX /*i*/ug_expiry ON /*_*/user_groups (ug_expiry);
|