ALTER TABLE `{database_up}userlist` ADD `userid` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST 
ALTER TABLE `{database_up}posts` ADD `usrid` MEDIUMINT( 8 ) NOT NULL AFTER `username` 
ALTER TABLE `{database_up}onlinestat` ADD `onusrid` MEDIUMINT( 8 ) NOT NULL AFTER `username` 
ALTER TABLE `{database_up}onlinestat` DROP PRIMARY KEY ,ADD PRIMARY KEY ( `onusrid` ) 