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 user_rights (
9 user_id
int(5) unsigned
NOT NULL,
10 user_rights tinyblob
NOT NULL default '',
11 UNIQUE KEY user_id (user_id
)
14 INSERT INTO user_rights
SELECT user_id
,user_rights
FROM user;
16 ALTER TABLE user DROP COLUMN user_rights
;