1 -- Split user table into two parts:
4 -- The later contains only the permissions of the user. This way,
5 -- you can store the accounts for several wikis in one central
6 -- database but keep user rights local to the wiki.
8 CREATE TABLE /*$wgDBprefix*/user_rights (
10 ur_user
int unsigned
NOT NULL,
12 -- Comma-separated list of permission keys
13 ur_rights tinyblob
NOT NULL,
15 UNIQUE KEY ur_user (ur_user
)
17 ) /*$wgDBTableOptions*/;
19 INSERT INTO /*$wgDBprefix*/user_rights
SELECT user_id
,user_rights
FROM /*$wgDBprefix*/user;
21 ALTER TABLE /*$wgDBprefix*/user DROP COLUMN user_rights
;