1ALTER TABLE {PREFIX}authors ADD userlevel INT(4) UNSIGNED DEFAULT '0';
2UPDATE {PREFIX}authors SET userlevel = 255 WHERE authorid = 1;
3UPDATE {PREFIX}authors SET userlevel = 1 WHERE authorid > 1;
4
5ALTER TABLE {PREFIX}config  ADD authorid  INT UNSIGNED NOT NULL DEFAULT '0';
6CREATE INDEX configauthorid_idx ON {PREFIX}config (authorid);
7
8ALTER TABLE {PREFIX}config  DROP PRIMARY KEY;
9ALTER TABLE {PREFIX}config  ADD PRIMARY KEY (name, authorid);
10
11ALTER TABLE {PREFIX}plugins  ADD authorid  INT UNSIGNED DEFAULT '0';
12CREATE INDEX pluginauthorid_idx ON {PREFIX}plugins (authorid);
13
14ALTER TABLE {PREFIX}images  ADD authorid  INT UNSIGNED DEFAULT '0';
15CREATE INDEX imagesauthorid_idx ON {PREFIX}images (authorid);
16