ALTER TABLE `{database_up}actlogs` CHANGE `forumid` `forumid` INT NOT NULL
ALTER TABLE `{database_up}actlogs` ADD INDEX ( `acttime` ) 
ALTER TABLE `{database_up}actlogs` ADD INDEX ( `forumid` ) 
ALTER TABLE `{database_up}apclog` ADD INDEX ( `addtime` ) 
ALTER TABLE `{database_up}forumdata` CHANGE `id` `id` INT NOT NULL 
ALTER TABLE `{database_up}forumdata` ADD INDEX ( `id` ) 
ALTER TABLE `{database_up}forumdata` ADD INDEX ( `showorder` ) 
ALTER TABLE `{database_up}polls` CHANGE `id` `id` INT NOT NULL 
ALTER TABLE `{database_up}polls` CHANGE `forumid` `forumid` INT NOT NULL 
ALTER TABLE `{database_up}polls` ADD INDEX ( `id` ) 
ALTER TABLE `{database_up}polls` ADD INDEX ( `forumid` ) 
ALTER TABLE `{database_up}posts` CHANGE `timestamp` `timestamp` INT NOT NULL 
ALTER TABLE `{database_up}posts` CHANGE `changtime` `changtime` INT NOT NULL 
ALTER TABLE `{database_up}posts` CHANGE `forumid` `forumid` INT NOT NULL 
ALTER TABLE `{database_up}posts` CHANGE `tid` `tid` INT NOT NULL 
ALTER TABLE `{database_up}posts` ADD INDEX ( `forumid` ) 
ALTER TABLE `{database_up}posts` ADD INDEX ( `tid` ) 
ALTER TABLE `{database_up}posts` ADD INDEX ( `id` ) 
ALTER TABLE `{database_up}posts` ADD INDEX ( `changtime` ) 
ALTER TABLE `{database_up}posts` ADD INDEX ( `timestamp` ) 
ALTER TABLE `{database_up}potlog` ADD INDEX ( `ptimestamp` ) 
ALTER TABLE `{database_up}primsg` ADD INDEX ( `id` ) 
ALTER TABLE `{database_up}primsg` ADD INDEX ( `prtime` ) 
ALTER TABLE `{database_up}primsg` ADD FULLTEXT `belong` (`belong` ) 
ALTER TABLE `{database_up}primsg` ADD FULLTEXT `sendto` (`sendto` ) 
ALTER TABLE `{database_up}search` ADD INDEX ( `id` ) 
ALTER TABLE `{database_up}threads` CHANGE `tid` `tid` INT NOT NULL 
ALTER TABLE `{database_up}threads` CHANGE `forumid` `forumid` INT NOT NULL 
ALTER TABLE `{database_up}threads` CHANGE `changetime` `changetime` INT NOT NULL 
ALTER TABLE `{database_up}threads` ADD INDEX ( `id` ) 
ALTER TABLE `{database_up}threads` ADD INDEX ( `tid` ) 
ALTER TABLE `{database_up}threads` ADD INDEX ( `forumid` ) 
ALTER TABLE `{database_up}threads` ADD INDEX ( `hits` ) 
ALTER TABLE `{database_up}threads` ADD INDEX ( `replys` ) 
ALTER TABLE `{database_up}threads` ADD INDEX ( `changetime` ) 
ALTER TABLE `{database_up}threads` ADD INDEX ( `time` ) 
ALTER TABLE `{database_up}usergroup` ADD INDEX ( `id` ) 
ALTER TABLE `{database_up}usergroup` ADD INDEX ( `showsort` )  
ALTER TABLE `{database_up}userlist` CHANGE `ugnum` `ugnum` INT NOT NULL 
ALTER TABLE `{database_up}userlist` CHANGE `point` `point` INT NOT NULL 
ALTER TABLE `{database_up}userlist` CHANGE `money` `money` INT NOT NULL 
ALTER TABLE `{database_up}userlist` ADD FULLTEXT `username` (`username` ) 
ALTER TABLE `{database_up}userlist` ADD INDEX ( `postamount` ) 
ALTER TABLE `{database_up}userlist` ADD INDEX ( `point` ) 
ALTER TABLE `{database_up}userlist` ADD INDEX ( `ugnum` ) 
ALTER TABLE `{database_up}userlist` ADD INDEX ( `money` ) 