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