 drop table if exists {PREFIX}categories ;
 drop table if exists {PREFIX}comments ;
 drop table if exists {PREFIX}settings ;
 drop table if exists {PREFIX}members ;
 drop table if exists {PREFIX}membergroups ;
 drop table if exists {PREFIX}email ;
 drop table if exists {PREFIX}sessions ;
 drop table if exists {PREFIX}ratings ;
 drop table if exists {PREFIX}switches ;
 drop table if exists {PREFIX}markup ;
 drop table if exists {PREFIX}modlog ;
 drop table if exists {PREFIX}attachments ;
 drop table if exists {PREFIX}helpcategory ;
 drop table if exists {PREFIX}helpitem ;
 drop table if exists {PREFIX}crons ;
 drop table if exists {PREFIX}im ;
 drop table if exists {PREFIX}pm ;
 drop table if exists {PREFIX}trader ;
 drop table if exists {PREFIX}polls ;
 drop table if exists {PREFIX}pollvotes ;
 drop table if exists {PREFIX}shouts ;
 drop table if exists {PREFIX}quotes ;
 drop table if exists {PREFIX}chat ;
 drop table if exists {PREFIX}calendar ;
 drop table if exists {PREFIX}reports ;
 create table {PREFIX}links
 (
     `id` int NOT NULL auto_increment,
       `title` varchar(255) NOT NULL,
       `description` text NOT NULL,
       `rating` real default '0' NOT NULL,
       `votes` int default '0' NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
       `catid` int default '0' NOT NULL,
       `sumofvotes` int default '0' NOT NULL,
       `time` int default '0' NOT NULL,
       `hits` int default '0' NOT NULL,
       `numcomments` int default '0' NOT NULL,
       `hide` tinyint(1) default '0' NOT NULL,
       `ownerid` int default '0' NOT NULL,
       `voterips` text NOT NULL,
       `voterids` text NOT NULL,
       `lastedit` int default '0' NOT NULL,
       `type` varchar(255) NOT NULL,
       `notify` text NOT NULL,
       `pendingedit` text NOT NULL,
       `alias` int default '0' NOT NULL,
       `expire` int default '0' NOT NULL,
       `ip` varchar(255) NOT NULL,
       `inalbum` tinyint(1) default '0' NOT NULL,
       `typeorder` int default '0' NOT NULL,
       `hitsoutips` text NOT NULL,
       `lastcomment` int default '0' NOT NULL,
       `related` text NOT NULL,
       `inhidden` tinyint(1) default '0' NOT NULL,
       `viewers` text NOT NULL,
       `threadviewers` text NOT NULL,
       `hitsouttemp` int default '0' NOT NULL,
       `origtype` varchar(255) NOT NULL,
       `importance` real default '0' NOT NULL,
       `parentids` text NOT NULL,
       `timesemailed` int default '0' NOT NULL,
       `message` text NOT NULL,
       `lastposterid` int default '0' NOT NULL,
       `lastpostername` varchar(255) NOT NULL,
       `sticky` int default '0' NOT NULL,
       `threadclosed` tinyint(1) default '0' NOT NULL,
       `ownername` varchar(255) NOT NULL,
       `threadposters` text NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `downloads` int default '0' NOT NULL,
       `funds` real default '0' NOT NULL,
       `deletionreason` varchar(255) NOT NULL,
       `movedto` int default '0' NOT NULL,
       `pollid` int default '0' NOT NULL,
       `deletedby` int default '0' NOT NULL,
       `posticon` varchar(255) NOT NULL,
       `timevalidated` int default '0' NOT NULL,
       `savedby` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}categories
 (
     `id` int NOT NULL auto_increment,
       `name` varchar(255) NOT NULL,
       `parent` int default '0' NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
       `description` text NOT NULL,
       `time` int default '0' NOT NULL,
       `parentnames` text NOT NULL,
       `parentids` text NOT NULL,
       `numlinks` int default '0' NOT NULL,
       `hide` tinyint(1) default '0' NOT NULL,
       `lastlinktime` int default '0' NOT NULL,
       `custom` varchar(255) NOT NULL,
       `lastedit` int default '0' NOT NULL,
       `moderators` text NOT NULL,
       `headerinfo` text NOT NULL,
       `related` text NOT NULL,
       `numsub` int default '0' NOT NULL,
       `type` varchar(255) NOT NULL,
       `permissions` text NOT NULL,
       `subscribers` text NOT NULL,
       `mixtypes` varchar(255) NOT NULL,
       `isalbum` tinyint(1) default '0' NOT NULL,
       `orderlinks` varchar(255) NOT NULL,
       `totalcomments` int default '0' NOT NULL,
       `alias` int default '0' NOT NULL,
       `catcols` varchar(255) NOT NULL,
       `sponsorlinks` text NOT NULL,
       `views` int default '0' NOT NULL,
       `customwrap` varchar(255) NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `reqlinks` int default '0' NOT NULL,
       `reqcoms` int default '0' NOT NULL,
       `reqlinksdelay` int default '0' NOT NULL,
       `priority` int default '0' NOT NULL,
       `levelsdeep` int default '0' NOT NULL,
       `lastposterid` int default '0' NOT NULL,
       `lastpostername` varchar(255) NOT NULL,
       `lastcommenttime` int default '0' NOT NULL,
       `lastthreadid` int default '0' NOT NULL,
       `lastthreadtitle` varchar(255) NOT NULL,
       `linkshere` int default '0' NOT NULL,
       `unvalidatedlinks` int default '0' NOT NULL,
       `unvalidatedcomments` int default '0' NOT NULL,
       `actaslink` varchar(255) NOT NULL,
       `countposts` text NOT NULL,
       `subcatshtml` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}comments
 (
     `id` int NOT NULL auto_increment,
       `linkid` int default '0' NOT NULL,
       `postername` varchar(255) NOT NULL,
       `message` text NOT NULL,
       `time` int default '0' NOT NULL,
       `linkname` varchar(255) NOT NULL,
       `validated` int default '0' NOT NULL,
       `ip` varchar(255) NOT NULL,
       `ownerid` int default '0' NOT NULL,
       `lastedit` int default '0' NOT NULL,
       `type` varchar(255) NOT NULL,
       `approved` int default '0' NOT NULL,
       `votes` int default '0' NOT NULL,
       `hide` int default '0' NOT NULL,
       `typeorder` int default '0' NOT NULL,
       `lasteditby` varchar(255) NOT NULL,
       `catid` int default '0' NOT NULL,
       `editreason` varchar(255) NOT NULL,
       `preventedit` tinyint(1) default '0' NOT NULL,
       `inhidden` tinyint(1) default '0' NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `deletionreason` varchar(255) NOT NULL,
       `usernoteon` int default '0' NOT NULL,
       `modnote` int default '0' NOT NULL,
       `filefield` varchar(255) NOT NULL,
       `title` varchar(255) NOT NULL,
       `deletedby` int default '0' NOT NULL,
       `parentids` text NOT NULL,
       `disablesmilies` tinyint(1) default '0' NOT NULL,
       `disablesig` tinyint(1) default '0' NOT NULL,
       `icon` varchar(255) NOT NULL,
       `originalmessage` text NOT NULL,
       `disablehtml` tinyint(1) default '0' NOT NULL,
       `disablewsn` tinyint(1) default '0' NOT NULL,
       `flagged` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}settings
 (
     `id` int NOT NULL auto_increment,
       `name` varchar(255) NOT NULL,
       `content` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}members
 (
     `id` int NOT NULL auto_increment,
       `name` varchar(255) NOT NULL,
       `time` int default '0' NOT NULL,
       `usergroup` int default '0' NOT NULL,
       `password` varchar(255) NOT NULL,
       `ip` varchar(255) NOT NULL,
       `totalhits` int default '0' NOT NULL,
       `email` varchar(255) NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
       `template` varchar(255) NOT NULL,
       `language` varchar(255) NOT NULL,
       `lastattempt` int default '0' NOT NULL,
       `allowemail` varchar(255) NOT NULL,
       `signature` text NOT NULL,
       `avatarname` varchar(255) NOT NULL,
       `stylesheet` varchar(255) NOT NULL,
       `allowuseremail` varchar(255) NOT NULL,
       `albumid` int default '0' NOT NULL,
       `failedattempts` int default '0' NOT NULL,
       `totalbytes` int default '0' NOT NULL,
       `funds` real default '0' NOT NULL,
       `notifyoflinks` varchar(255) NOT NULL,
       `lastvisit` int default '0' NOT NULL,
       `timezone` real default '0' NOT NULL,
       `rating` real default '0' NOT NULL,
       `pmfolders` text NOT NULL,
       `notifyofpms` varchar(255) NOT NULL,
       `acceptpms` varchar(255) NOT NULL,
       `cookieduration` int default '0' NOT NULL,
       `banned` text NOT NULL,
       `topics` int default '0' NOT NULL,
       `posts` int default '0' NOT NULL,
       `location` varchar(255) NOT NULL,
       `homepage` varchar(255) NOT NULL,
       `occupation` varchar(255) NOT NULL,
       `bio` text NOT NULL,
       `aim` varchar(255) NOT NULL,
       `icq` varchar(255) NOT NULL,
       `msn` varchar(255) NOT NULL,
       `yahoo` varchar(255) NOT NULL,
       `inactive` int default '0' NOT NULL,
       `timeonline` int default '0' NOT NULL,
       `totalpms` int default '0' NOT NULL,
       `buddies` text NOT NULL,
       `ignored` text NOT NULL,
       `isonline` int default '0' NOT NULL,
       `acceptims` varchar(255) NOT NULL,
       `adminpermissions` text NOT NULL,
       `referrer` int default '0' NOT NULL,
       `groupreverttime` int default '0' NOT NULL,
       `grouprevertto` int default '0' NOT NULL,
       `moderationpm` varchar(255) NOT NULL,
       `secondarygroups` text NOT NULL,
       `linksperpage` int default '0' NOT NULL,
       `commentsperpage` int default '0' NOT NULL,
       `shouts` int default '0' NOT NULL,
       `customtitle` varchar(255) NOT NULL,
       `shoutban` tinyint(1) default '0' NOT NULL,
       `topicbans` text NOT NULL,
       `forumbans` text NOT NULL,
       `visibility` text NOT NULL,
       `birthdate` date,
       `lastsession` int default '0' NOT NULL,
       `interests` text NOT NULL,
       `posteditor` varchar(255) NOT NULL,
       `forumaccess` text NOT NULL,
       `pmpopup` tinyint(1) default '0' NOT NULL,
       `pmnotify` varchar(255) NOT NULL,
       `modnotes` int default '0' NOT NULL,
       `guestnotes` int default '0' NOT NULL,
       `salt` varchar(255) NOT NULL,
       `lastmodnote` int default '0' NOT NULL,
       `newpms` int default '0' NOT NULL,
       `imflag` tinyint(1) default '0' NOT NULL,
       `orderalbums` varchar(255) NOT NULL,
       `lastguestnote` int default '0' NOT NULL,
       `autosubscribe` varchar(255) NOT NULL,
       `notifymethod` varchar(255) NOT NULL,
       `showavatars` varchar(255) NOT NULL,
       `showsigs` varchar(255) NOT NULL,
       `warninglevel` int default '0' NOT NULL,
       `chatcolor` text NOT NULL,
       `autosubscribepost` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}membergroups
 (
     `id` int NOT NULL auto_increment,
       `title` varchar(255) NOT NULL,
       `caneditown` tinyint(1) default '0' NOT NULL,
       `caneditall` tinyint(1) default '0' NOT NULL,
       `canvote` tinyint(1) default '0' NOT NULL,
       `isadmin` tinyint(1) default '0' NOT NULL,
       `canpost` tinyint(1) default '0' NOT NULL,
       `canemail` tinyint(1) default '0' NOT NULL,
       `validatecats` tinyint(1) default '0' NOT NULL,
       `validatecomments` tinyint(1) default '0' NOT NULL,
       `validatelinks` tinyint(1) default '0' NOT NULL,
       `validateedits` tinyint(1) default '0' NOT NULL,
       `cansubmitlinks` tinyint(1) default '0' NOT NULL,
       `cansubmitcategories` tinyint(1) default '0' NOT NULL,
       `cansubmitcomments` tinyint(1) default '0' NOT NULL,
       `caneditownlinks` tinyint(1) default '0' NOT NULL,
       `caneditowncategories` tinyint(1) default '0' NOT NULL,
       `caneditowncomments` tinyint(1) default '0' NOT NULL,
       `caneditownprofile` tinyint(1) default '0' NOT NULL,
       `caneditalllinks` tinyint(1) default '0' NOT NULL,
       `caneditallcategories` tinyint(1) default '0' NOT NULL,
       `caneditallcomments` tinyint(1) default '0' NOT NULL,
       `caneditallprofiles` tinyint(1) default '0' NOT NULL,
       `candownloadfiles` tinyint(1) default '0' NOT NULL,
       `canupload` tinyint(1) default '0' NOT NULL,
       `canviewip` tinyint(1) default '0' NOT NULL,
       `limitlinks` varchar(255) NOT NULL,
       `canemailmembers` tinyint(1) default '0' NOT NULL,
       `canusehtml` tinyint(1) default '0' NOT NULL,
       `limitlinksdaily` varchar(255) NOT NULL,
       `canalias` tinyint(1) default '0' NOT NULL,
       `candeleteown` tinyint(1) default '0' NOT NULL,
       `candeleteall` tinyint(1) default '0' NOT NULL,
       `candofulledit` tinyint(1) default '0' NOT NULL,
       `candeletecategories` tinyint(1) default '0' NOT NULL,
       `candeletecomments` tinyint(1) default '0' NOT NULL,
       `candeleteowncategories` tinyint(1) default '0' NOT NULL,
       `candeleteowncomments` tinyint(1) default '0' NOT NULL,
       `candeletemembers` tinyint(1) default '0' NOT NULL,
       `candeleteownmembers` tinyint(1) default '0' NOT NULL,
       `canaliascategories` tinyint(1) default '0' NOT NULL,
       `canviewpages` tinyint(1) default '0' NOT NULL,
       `caneditvotes` tinyint(1) default '0' NOT NULL,
       `numaliases` int default '0' NOT NULL,
       `canviewvotes` tinyint(1) default '0' NOT NULL,
       `canhideownlinks` tinyint(1) default '0' NOT NULL,
       `canhideowncategories` tinyint(1) default '0' NOT NULL,
       `canhideowncomments` tinyint(1) default '0' NOT NULL,
       `canhidealllinks` tinyint(1) default '0' NOT NULL,
       `canhideallcategories` tinyint(1) default '0' NOT NULL,
       `canhideallcomments` tinyint(1) default '0' NOT NULL,
       `canratecomments` tinyint(1) default '0' NOT NULL,
       `bytespermem` varchar(255) NOT NULL,
       `canpm` tinyint(1) default '0' NOT NULL,
       `canim` tinyint(1) default '0' NOT NULL,
       `canharddelete` tinyint(1) default '0' NOT NULL,
       `limitpms` varchar(255) NOT NULL,
       `limitpmsdaily` varchar(255) NOT NULL,
       `canviewdeleted` tinyint(1) default '0' NOT NULL,
       `cansubmitpolls` tinyint(1) default '0' NOT NULL,
       `candeletepolls` tinyint(1) default '0' NOT NULL,
       `candeleteownpolls` tinyint(1) default '0' NOT NULL,
       `caneditpolls` tinyint(1) default '0' NOT NULL,
       `caneditownpolls` tinyint(1) default '0' NOT NULL,
       `attachperpost` int default '0' NOT NULL,
       `attachperpm` int default '0' NOT NULL,
       `canviewshouts` tinyint(1) default '0' NOT NULL,
       `caneditshouts` tinyint(1) default '0' NOT NULL,
       `caneditownshouts` tinyint(1) default '0' NOT NULL,
       `candeleteshouts` tinyint(1) default '0' NOT NULL,
       `candeleteownshouts` tinyint(1) default '0' NOT NULL,
       `cansubmitshouts` tinyint(1) default '0' NOT NULL,
       `canpollvote` tinyint(1) default '0' NOT NULL,
       `customtitle` tinyint(1) default '0' NOT NULL,
       `canviewinvisible` tinyint(1) default '0' NOT NULL,
       `namestyle` varchar(255) NOT NULL,
       `canpmimportant` tinyint(1) default '0' NOT NULL,
       `canviewmodlog` tinyint(1) default '0' NOT NULL,
       `isleader` tinyint(1) default '0' NOT NULL,
       `cansubmitquotes` tinyint(1) default '0' NOT NULL,
       `validatequotes` tinyint(1) default '0' NOT NULL,
       `candeletequotes` tinyint(1) default '0' NOT NULL,
       `candeleteownquotes` tinyint(1) default '0' NOT NULL,
       `canreport` tinyint(1) default '0' NOT NULL,
       `canusesearch` tinyint(1) default '0' NOT NULL,
       `validateattachments` tinyint(1) default '0' NOT NULL,
       `caneditownquotes` tinyint(1) default '0' NOT NULL,
       `caneditallquotes` tinyint(1) default '0' NOT NULL,
       `canviewchat` tinyint(1) default '0' NOT NULL,
       `caneditownevents` tinyint(1) default '0' NOT NULL,
       `caneditallevents` tinyint(1) default '0' NOT NULL,
       `candeleteownevents` tinyint(1) default '0' NOT NULL,
       `candeleteevents` tinyint(1) default '0' NOT NULL,
       `cansubmitevents` tinyint(1) default '0' NOT NULL,
       `validateevents` tinyint(1) default '0' NOT NULL,
       `bulkpms` int default '0' NOT NULL,
       `issupermod` tinyint(1) default '0' NOT NULL,
       `cansuggestban` tinyint(1) default '0' NOT NULL,
       `shoutsperday` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}email
 (
     `id` int NOT NULL auto_increment,
       `to` text NOT NULL,
       `subject` text NOT NULL,
       `message` text NOT NULL,
       `headers` text NOT NULL,
       `timesent` int default '0' NOT NULL,
       `ip` varchar(255) NOT NULL,
       `replacement` text NOT NULL,
       `mime` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}sessions
 (
     `id` int NOT NULL auto_increment,
       `memberid` int default '0' NOT NULL,
       `location` varchar(255) NOT NULL,
       `time` int default '0' NOT NULL,
       `ip` varchar(255) NOT NULL,
       `browser` text NOT NULL,
       `starttime` int default '0' NOT NULL,
       `catid` int default '0' NOT NULL,
       `threadid` int default '0' NOT NULL,
       `areaname` varchar(255) NOT NULL,
       `lastsearch` int default '0' NOT NULL,
       `nopermission` tinyint(1) default '0' NOT NULL,
       `inchat` tinyint(1) default '0' NOT NULL,
       `name` varchar(255) NOT NULL,
       `isrobot` tinyint(1) default '0' NOT NULL,
       `lastchat` int default '0' NOT NULL,
       `groupnamestyle` varchar(255) NOT NULL,
       `acceptims` varchar(255) NOT NULL,
       `visibility` varchar(255) NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}ratings
 (
     `id` int NOT NULL auto_increment,
       `votevalue` int default '0' NOT NULL,
       `time` int default '0' NOT NULL,
       `memberid` int default '0' NOT NULL,
       `ip` varchar(255) NOT NULL,
       `custom` varchar(255) NOT NULL,
       `linkid` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}switches
 (
     `id` int NOT NULL auto_increment,
       `name` varchar(255) NOT NULL,
       `value` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}markup
 (
     `id` int NOT NULL auto_increment,
       `type` varchar(255) NOT NULL,
       `original` text NOT NULL,
       `replacement` text NOT NULL,
       `description` text NOT NULL,
       `originalclose` text NOT NULL,
       `replacementclose` text NOT NULL,
       `sortorder` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}modlog
 (
     `id` int NOT NULL auto_increment,
       `topicid` int default '0' NOT NULL,
       `postid` int default '0' NOT NULL,
       `type` varchar(255) NOT NULL,
       `nature` varchar(255) NOT NULL,
       `reason` text NOT NULL,
       `moderatorid` int default '0' NOT NULL,
       `source` int default '0' NOT NULL,
       `destination` int default '0' NOT NULL,
       `time` int default '0' NOT NULL,
       `catid` int default '0' NOT NULL,
       `memberid` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}attachments
 (
     `id` int NOT NULL auto_increment,
       `type` varchar(255) NOT NULL,
       `objectid` int default '0' NOT NULL,
       `filename` varchar(255) NOT NULL,
       `filetitle` varchar(255) NOT NULL,
       `filesize` int default '0' NOT NULL,
       `width` int default '0' NOT NULL,
       `height` int default '0' NOT NULL,
       `memberid` int default '0' NOT NULL,
       `time` int default '0' NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `field` varchar(255) NOT NULL,
       `downloads` int default '0' NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}helpcategory
 (
     `id` int NOT NULL auto_increment,
       `name` varchar(255) NOT NULL,
       `numsubjects` int default '0' NOT NULL,
       `priority` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}helpitem
 (
     `id` int NOT NULL auto_increment,
       `subject` varchar(255) NOT NULL,
       `helptext` text NOT NULL,
       `priority` int default '0' NOT NULL,
       `category` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}crons
 (
     `id` int NOT NULL auto_increment,
       `frequency` int default '0' NOT NULL,
       `nextrun` int default '0' NOT NULL,
       `filename` varchar(255) NOT NULL,
       `native` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}im
 (
     `id` int NOT NULL auto_increment,
       `toid` int default '0' NOT NULL,
       `fromid` int default '0' NOT NULL,
       `message` text NOT NULL,
       `time` int default '0' NOT NULL,
       `isread` tinyint(1) default '0' NOT NULL,
       `timeread` int default '0' NOT NULL,
       `deleted` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}pm
 (
     `id` int NOT NULL auto_increment,
       `toid` int default '0' NOT NULL,
       `fromid` int default '0' NOT NULL,
       `timeread` int default '0' NOT NULL,
       `message` text NOT NULL,
       `subject` varchar(255) NOT NULL,
       `time` int default '0' NOT NULL,
       `icon` varchar(255) NOT NULL,
       `folderid` varchar(255) NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `flag` int default '0' NOT NULL,
       `filefield` varchar(255) NOT NULL,
       `important` tinyint(1) default '0' NOT NULL,
       `replyto` tinyint(1) default '0' NOT NULL,
       `replied` tinyint(1) default '0' NOT NULL,
       `sentdeleted` tinyint(1) default '0' NOT NULL,
       `cc` varchar(255) NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}trader
 (
     `id` int NOT NULL auto_increment,
       `ratingof` int default '0' NOT NULL,
       `ratingby` int default '0' NOT NULL,
       `value` int default '0' NOT NULL,
       `summary` varchar(255) NOT NULL,
       `report` text NOT NULL,
       `time` int default '0' NOT NULL,
       `type` varchar(255) NOT NULL,
       `linkid` int default '0' NOT NULL,
       `morecomments` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}polls
 (
     `id` int NOT NULL auto_increment,
       `topicid` int default '0' NOT NULL,
       `catid` int default '0' NOT NULL,
       `question` text NOT NULL,
       `options` text NOT NULL,
       `time` int default '0' NOT NULL,
       `endtime` int default '0' NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `multi` int default '0' NOT NULL,
       `public` tinyint(1) default '0' NOT NULL,
       `totals` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}pollvotes
 (
     `id` int NOT NULL auto_increment,
       `pollid` int default '0' NOT NULL,
       `vote` int default '0' NOT NULL,
       `memberid` int default '0' NOT NULL,
       `ip` varchar(255) NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `membername` varchar(255) NOT NULL,
       `time` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}shouts
 (
     `id` int NOT NULL auto_increment,
       `ownerid` int default '0' NOT NULL,
       `time` int default '0' NOT NULL,
       `deleted` tinyint(1) default '0' NOT NULL,
       `message` text NOT NULL,
       `name` varchar(255) NOT NULL,
       `ip` varchar(255) NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}quotes
 (
     `content` text NOT NULL,
       `author` varchar(255) NOT NULL,
       `id` int NOT NULL auto_increment,
       `source` text NOT NULL,
       `ownerid` int default '0' NOT NULL,
       `ownername` varchar(255) NOT NULL,
       `validated` tinyint(1) default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}chat
 (
     `id` int NOT NULL auto_increment,
       `name` varchar(255) NOT NULL,
       `message` varchar(255) NOT NULL,
       `time` int default '0' NOT NULL,
       `ownerid` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}calendar
 (
     `id` int NOT NULL auto_increment,
       `ownerid` int default '0' NOT NULL,
       `title` varchar(255) NOT NULL,
       `description` text NOT NULL,
       `joined` text NOT NULL,
       `starttime` int default '0' NOT NULL,
       `endtime` int default '0' NOT NULL,
       `date` varchar(255) NOT NULL,
       `reminded` text NOT NULL,
 UNIQUE KEY id (id)
   );
   
   create table {PREFIX}reports
 (
     `id` int NOT NULL auto_increment,
       `type` varchar(255) NOT NULL,
       `objectid` int default '0' NOT NULL,
       `reporter` int default '0' NOT NULL,
       `action` varchar(255) NOT NULL,
       `time` int default '0' NOT NULL,
       `moderator` int default '0' NOT NULL,
       `discussionthread` int default '0' NOT NULL,
       `reason` text NOT NULL,
       `forumid` int default '0' NOT NULL,
       `parentids` varchar(255) NOT NULL,
       `topicid` int default '0' NOT NULL,
       `offender` int default '0' NOT NULL,
 UNIQUE KEY id (id)
   );
   
   INSERT INTO {PREFIX}members(id,name,time,usergroup,password,ip,totalhits,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,topics,posts,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,chatcolor,autosubscribepost) VALUES ('0', '{USERNAME}', '{TIME}', '3', '{PASSWORD}', '{IP}', '0', '{ACCOUNTEMAIL}', '1', '{OURTEMPLATESDIR}', '{OURDEFAULTLANG}', '0', '0', '', '', 'default', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', 'yes', '0', '0', '0', '0', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Administrator', '0', '', '', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', 'sdg', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0');
  INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('6', '3600', '1143836383', 'hourly.php', '1');
  INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('8', '86400', '1143919414', 'daily.php', '0');
  INSERT INTO {PREFIX}crons(id,frequency,nextrun,filename,native) VALUES ('9', '43200', '1143699073', '12hours.php', '0');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('1', 'wsncode', '[b]', '<b>', 'Put text in bold.', '[/b]', '</b>', '1');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('3', 'wsncode', '[i]', '<i>', 'Put text in italics.', '[/i]', '</i>', '2');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('10', 'smilie', ':D', '<img src="{TEMPLATESDIR}/images/smilies/biggrin.gif" border="0" alt="grin">', 'grin', '', '', '3');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('8', 'smilie', ':)', '<img src="{TEMPLATESDIR}/images/smilies/smile.gif" border="0" alt="smiling face">', 'smiling face', '', '', '1');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('9', 'smilie', '{semicolon})', '<img src="{TEMPLATESDIR}/images/smilies/wink.gif" border="0" alt="wink">', 'wink', '', '', '2');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('11', 'smilie', ':confused:', '<img src="{TEMPLATESDIR}/images/smilies/confused.gif" border="0" alt="confused">', 'confused', '', '', '8');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('12', 'smilie', ':cool:', '<img src="{TEMPLATESDIR}/images/smilies/cool.gif" border="0" alt="cool">', 'cool', '', '', '4');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('13', 'smilie', ':eek:', '<img src="{TEMPLATESDIR}/images/smilies/eek.gif" border="0" alt="shocked">', 'shocked', '', '', '9');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('14', 'smilie', ':eyebrow:', '<img src="{TEMPLATESDIR}/images/smilies/eyebrow.gif" border="0" alt="raised eyebrow">', 'raised eyebrow', '', '', '7');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('15', 'smilie', ':(', '<img src="{TEMPLATESDIR}/images/smilies/frown.gif" border="0" alt="sad">', 'sad', '', '', '13');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('16', 'smilie', ':mad:', '<img src="{TEMPLATESDIR}/images/smilies/mad.gif" border="0" alt="mad">', 'mad', '', '', '14');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('17', 'smilie', ':no:', '<img src="{TEMPLATESDIR}/images/smilies/no.gif" border="0" alt="shaking head">', 'shaking head', '', '', '10');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('18', 'smilie', ':nod:', '<img src="{TEMPLATESDIR}/images/smilies/nod.gif" border="0" alt="nod">', 'nod', '', '', '5');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('19', 'smilie', ':nono:', '<img src="{TEMPLATESDIR}/images/smilies/nono.gif" border="0" alt="disapproval">', 'disapproval', '', '', '11');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('20', 'smilie', ':rolleyes:', '<img src="{TEMPLATESDIR}/images/smilies/rolleyes.gif" border="0" alt="rolling eyes">', 'rolling eyes', '', '', '12');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('21', 'smilie', ':p', '<img src="{TEMPLATESDIR}/images/smilies/tongue.gif" border="0" alt="sticking out tongue">', 'sticking out tongue', '', '', '6');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('23', 'wsncode', '[quote={PARAM}]', '<div class="quote"><span class="quoteby">{PARAM} wrote:</span><br>', 'Quote text written by someone.', '[/quote]', '</div>', '4');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('24', 'wsncode', '[quote]', '<div class="quote">', 'Quote without attribution.', '[/quote]', '</div>', '5');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('25', 'wsncode', '[code]', '<div class="code">', 'Type code such as HTML, PHP, C++, etc.', '[/code]', '</div>', '9');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('26', 'wsncode', '[url={PARAM}]', '<a target="_blank" href={PARAM}>', 'Link text to a URL.', '[/url]', '</a>', '6');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('27', 'wsncode', '[url]', '<a target="_blank" href={CONTENT}>', 'Link a URL.', '[/url]', '</a>', '7');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('33', 'wsncode', '[color={PARAM}]', '<span style="color: {PARAM}">', 'Places text in specified color.', '[/color]', '</span>', '10');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('29', 'wsncode', '[size={PARAM}]', '<font size={PARAM}>', 'Set the size of text.', '[/size]', '</font>', '11');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('30', 'wsncode', '[*]', '<li>', 'Bullet point inside a list.', '', '', '13');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('31', 'wsncode', '[list]', '<ul>', 'List of bullet points.', '[/list]', '</ul>', '12');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('32', 'wsncode', '[u]', '<u>', 'Underline text', '[/u]', '</u>', '3');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('34', 'wsncode', '[font={PARAM}]', '<span style="font-family: {PARAM}">', 'Put text in the specified font.', '[/font]', '</span>', '15');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('35', 'wsncode', '[hr]', '<hr style="width: 100%{semicolon} height: 2px{semicolon}">', 'Horizontal rule.', '', '', '16');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('36', 'wsncode', '[numbered]', '<ol>', 'Numbered list.', '[/numbered]', '</ol>', '14');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('37', 'wsncode', '[center]', '<div style="text-align: center{semicolon}">', 'Center text.', '[/center]', '</div>', '17');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('38', 'wsncode', '[highlight={PARAM}]', '<span style="background-color: {PARAM}">', 'Set background color for text.', '[/highlight]', '</span>', '20');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('39', 'wsncode', '[indent={PARAM}]', '<div style="margin-left: {PARAM}px{semicolon}">', 'Indent by specified number of pixels.', '[/indent]', '</div>', '19');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('40', 'wsncode', '[right]', '<div style="text-align: right{semicolon}">', 'Align text to right.', '[/right]', '</div>', '18');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('42', 'wsncode', '[email]', '<a href="mailto:{CONTENT}">', 'Clickable email address.', '[/email]', '</a>', '21');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('43', 'wsncode', '[img]', '<img src="', 'Display an image from a URL.', '[/img]', '" border="0">', '8');
  INSERT INTO {PREFIX}markup(id,type,original,replacement,description,originalclose,replacementclose,sortorder) VALUES ('44', 'wsncode', '[strike]', '<strike>', 'Cross out text.', '[/strike]', '</strike>', '22');INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday) VALUES ('1','Guests','0','0','0','0','0','0','0','1','1','0','0','0','0','0','0','0','0','0','0','0','0','1','0','0','','0','0','','0','0','0','0','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','','0','0','0','','','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','','0','0','0','0','0','0','0','0','1','0','0','0','1','0','0','0','0','0','0','1','0','0','0'); 
INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday) VALUES ('2','Members','0','0','1','0','0','1','0','0','0','0','1','0','1','1','0','1','1','0','0','0','0','1','1','0','','1','0','','0','1','0','0','0','0','0','1','0','0','0','1','0','0','0','0','0','0','0','0','0','1','','1','1','0','','','0','1','0','1','0','0','4','4','1','0','1','0','1','0','1','1','0','','0','0','0','0','0','0','0','1','1','0','0','0','1','1','0','1','0','1','0','4','0','0','0'); 
INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday) VALUES ('3','Administrators','0','0','1','1','0','1','0','0','0','0','1','0','1','1','0','1','1','1','0','1','1','1','1','1','','1','0','','1','1','1','1','0','1','0','1','1','1','0','1','1','0','1','0','0','0','0','0','0','1','','1','1','1','','','1','1','1','1','1','1','5','5','1','1','1','1','1','1','1','1','1','admincolor','1','1','1','0','0','0','0','1','1','0','0','0','1','1','1','1','1','1','0','4','1','0','0'); 
INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday) VALUES ('4','Moderators','0','0','1','0','0','1','0','0','0','0','1','0','1','1','0','1','1','0','0','0','0','1','1','1','','1','0','','1','1','0','0','0','0','0','1','0','0','0','1','0','0','1','0','0','0','0','0','0','1','','1','1','0','','','1','1','0','1','0','0','4','4','1','0','1','0','1','1','1','1','0','modcolor','1','1','1','0','0','0','0','1','1','0','0','0','1','1','0','1','0','1','0','4','0','1','0'); 
INSERT INTO {PREFIX}membergroups(id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod,cansuggestban,shoutsperday) VALUES ('5','Sponsors','0','0','1','0','0','1','0','0','0','0','1','0','1','1','0','1','1','0','0','0','0','1','1','0','','1','0','','0','1','0','0','0','0','0','1','0','0','0','1','0','0','0','0','0','0','0','0','0','1','','1','1','0','','','0','1','0','1','0','0','5','5','1','0','1','0','1','1','1','1','0','sponsorcolor','0','0','0','0','0','0','0','1','1','0','0','0','1','1','0','1','0','1','0','4','0','0','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('213','detailhits','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('124','ulsearchadult','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('123','ulsearchlinktype',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('122','ulsearchmax','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('121','ulsearchid','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('120','ulsearch','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('119','sponsorrevert',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('118','sponsorusergroup',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('117','confirmvote','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('116','iplength','12'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('115','expirecookie','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('162','htmlautogeneratecat','forum{CATID}{PAGE}.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('114','accountemail','{ACCOUNTEMAIL}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('127','rewritenames','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('143','cookiepolicy','www.somesite.com/w3c/p3p.xml'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('126','restricthitsbyip','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('129','rewriteignorelinks','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('128','alloweddups',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('135','onlinedate','%x - %X'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('131','nohttp','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('152','smilieslinks',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('147','parsecodecomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('148','parsecodemembers','signature'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('149','smiliesmembers','signature'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('144','commentsperpage','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('145','parsecodelinks',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('146','parsecodecategories',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('132','submittervote','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('141','cookiedomain',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('142','cookieduration','100000000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('151','smiliescategories',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('150','smiliescomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('111','menustate','expanded'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('110','uniquetotal','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('108','totalmembers','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('113','mime','plain text'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('109','checkoutnum',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('112','queue','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('107','checkfordupdomain','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('140','cookiepath','/'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('139','htmlautogeneratesubs','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('138','htmlautogeneratedir','admin/htmloutput'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('137','htmlautogenerate','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('136','timeout','15'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('134','onlineusers','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('133','sendconfirmation','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('106','fixedwidth',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('102','compress','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('104','checkfordup','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('105','redirects','afterlink[,]index.php?action=displaycat&catid={TOPICCATID}|||aftercat[,]|||aftercom[,]comments.php?id={TOPICID}&page=last#post{POSTID}|||afterreg[,]|||aftereditlink[,]index.php?action=displaycat&catid={TOPICCATID}|||aftereditcat[,]catmanagement.php|||aftereditcom[,]comments.php?id={TOPICID}&findpost={POSTID}#post{POSTID}|||aftereditprofile[,]memberlist.php?action=profile&id={MEMBERID}|||afterlogin[,]|||afterlogout[,]|||afterresetpass[,]index.php?action=userlogin|||aftersubscribecom[,]comments.php?id={ID}|||aftersubscribecat[,]index.php?action=displaycat&catid={FORUMID}|||afterdellink[,]index.php?action=displaycat&catid={TOPICCATID}|||afterdelcat[,]index.php?action=displaycat&catid={PARENT}|||afterdelcom[,]comments.php?id={TOPICID}|||afterrate[,]comments.php?id={TOPICID}|||afterratefail[,]|||afteractivate[,]|||afterloginfail[,]index.php?action=userlogin|||afterresetfail[,]index.php?action=userlogin|||aftersearchfail[,]search.php|||aftersearchfailseconds[,]7|||aftereditavatar[,]memberlist.php?action=profile&id={MEMBERID}|||afterreportlink[,]|||afterreportpost[,]|||afteremaillink[,]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('103','searchperpage','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('101','totalmembers','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('97','backupdelay',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('96','logsearches','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('86','skiptocat',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('85','standardtable','cellspacing=&#34&6&#34& cellpadding=&#34&6&#34&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('84','secondsdelay','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('83','standardsize','30'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('82','modapprove','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('81','stylesheet','../styles/default'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('93','apacherewrite','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('92','orderlinks2','ORDER BY title ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('91','commenttypes','regular'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('90','mixcomments','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('89','maximageheight','2000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('88','maximagewidth','2000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('87','marknewupdates','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('99','lastdaily','1143833014'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('95','backupfile',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('94','lastupdate','1140751426'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('61','debittime','1108031491'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('220','sponsoruselink','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('63','sponsorlinktype',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('64','sponsorcharge',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('65','totalhits','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('66','totalhitsin','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('69','sponsoritem',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('67','lastautocron','1089756505'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('68','totallinks','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('70','totalcomments','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('71','avatarsize','50000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('72','avatarwidth','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('73','avatarheight','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('74','avatartypes','gif,jpg,jpeg,png'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('75','descriplength','75'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('76','cattypes','regular'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('78','mainmeta',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('79','maplevels','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('77','externallinks','target=&#34&_blank&#34&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('60','minvote','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('59','maxvote','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('58','dontcount','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('57','integration',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('56','censor',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('157','perqueue','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('54','memberlistorder','ORDER BY time DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('47','selectorlevels','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('55','expiretime','72'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('156','linebreakmembers','signature'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('155','linebreakcomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('154','linebreakcategories','description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('228','pagestoshow','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('153','linebreaklinks','description'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('52','resetscript',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('51','filesize','1000000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('50','filetypes','gif,jpg,jpeg,png,zip,gz,txt,lng,pdf'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('49','uploadpath','{UPLOADPATH}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('48','ratingdecimal','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('44','resettime','1143543048'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('43','resetfields',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('45','floodcheck','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('46','registration','direct'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('41','admindir','{OURADMINDIR}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('42','resetdelay','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('39','requiredmembers','name,password,email'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('38','requiredcomments','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('37','requiredcategories','name'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('34','bannedips',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('36','requiredlinks','title'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('33','maxsubcats','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('185','defaultlang','{OURDEFAULTLANG}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('30','allowhtml','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('29','linktypes','regular'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('26','clicktimer','60'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('25','condition',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('24','ordercomments','ORDER BY time ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('23','searchfields','title,description,message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('22','mixrecip','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('8','notify','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('9','myurl',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('10','perpage','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('11','marknew','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('12','dateformat','%b %d, %Y  - %I:%M %p'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('13','locale','english'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('14','templatesdir','{OURTEMPLATESDIR}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('17','excludedtoadmin',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('125','ulsearchcatmax','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('18','dirurl','{DIRURL}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('98','adminbypass','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('20','commentsdateformat','%b %d, %Y  - %I:%M %p'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('21','debug','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('7','email','{ACCOUNTEMAIL}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('163','htmlautogeneratelin','detail{LINKID}.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('6','ordercats','ORDER BY priority ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('5','orderlinks','ORDER BY lastcomment DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('4','subcatcols','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('3','catcols','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('159','rewritecategoryspace','-'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('160','linkcols','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('183','lastrotation','1143832783'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('161','passwordlength','7'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('164','htmlautogeneratecom','thread{LINKID}{PAGE}.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('194','htmlautogenerateabsurl',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('165','htmlautogeneratepagesep','-'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('166','jsexporttoplist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('167','jsexportnamelist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('168','backupname','backup.sql'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('169','trackviews','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('170','countalbums','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('171','customhead',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('172','customfoot','custom-html_footer'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('173','customindex',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('174','customcat',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('175','customitem',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('176','customcomments',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('179','hitstempdays','30'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('250','htmlautogenerateindex','index.htm'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('180','hitstempreset','1143202259'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('202','sponsorlinkrevert',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('203','sendsponsorendemail','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('204','sendexpirationemail','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('205','emailsig',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('206','searchcols','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('182','sendvalidation','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('181','attachmentmethod','random'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('190','categoryselector',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('184','currentletter','A'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('186','paypalemail',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('255','searchhighlightexclude',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('256','backuppath',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('226','optionscontent','&lt&option value=&#34&{FORUMID}&#34&&gt&{FORUMINDENT} {FORUMNAME}&lt&/option&gt&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('218','sponsorugcharge',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('219','sponsorugitem',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('221','sponsoruseug','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('222','waterthumbs',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('223','sponsorcatresults','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('224','sponsorsearchresults','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('225','sponsorseparate','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('207','offsetfromgmt','-8'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('208','defaulttimezone','-8'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('210','searchlax','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('211','defaultsearchtype','and'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('212','membersperpage','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('251','staticexporturllist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('252','staticexportnamelist',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('253','staticexporttime','1143655873'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('254','emailf','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('192','alternateemails',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('195','ipbanfrom','whole site'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('196','memberrating','$rating = ($this-&gt&topics * 2) + ($this-&gt&posts)'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('314','newestmember','{NEWESTMEMBER}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('197','searchlinksorder','ORDER BY lastcomment DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('199','searchcatsorder','ORDER BY numlinks DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('313','searchcomsorder','ORDER BY time DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('201','searchmemsorder','ORDER BY time DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('191','sitemaporder',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('214','spideragents','googlebot
Slurp
msnbot
Teoma
Jeeves
ZyBorg
Gigabot
WeatherBot
Mediapartners
BecomeBot
fast-search-engine.com
BigCliqueBOT
Amfibibot
noxtrumbot
aipbot
sohu-search
sherlock
Nutch
OmniExplorer_Bot
EasyDL
Miva'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('215','allowrevote','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('216','rewritelink','topic'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('217','rewritethread','thread'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('257','sigchars','1000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('258','siglines','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('260','comchars','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('209','ulsearchdefaultquery',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('187','catsperpage','300'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('188','adminips',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('189','securityimage','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('227','pmsperpage','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('229','requiredpms','message,subject'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('230','smiliespms','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('231','parsecodepms','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('232','linebreakpms','message'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('233','linkimportance','$importance = ($this-&gt&hitsoutpermonth() + $this-&gt&numcomments)  + 6'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('234','onlinemembersmax','0|||0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('235','onlineguestsmax','0|||0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('236','commenthits','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('237','searchhighlight','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('240','onlinetotalmax','0|||0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('239','sponsoruseppc','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('241','subscriptionexclusion',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('248','memberdecriment','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('242','sponsorbonuscutoff',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('243','sponsorbonuspercent',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('244','wordwrap','75'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('245','sitetitle','WSN Forum'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('246','sitedescription',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('247','maxusernamelength','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('261','comwords','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('262','illegaldomains',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('263','magickpath','/usr/bin/convert'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('264','graphicsprog','GD'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('265','thumbwidth','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('266','thumbheight','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('267','fixedsize','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('269','offlinereason',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('268','offline','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('270','orderalbum','ORDER BY lastcomment DESC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('271','topsearcheslength','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('272','perpagealbums','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('273','dontcountowner','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('319','contact','email'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('318','contactforum',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('288','resizewidth',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('296','numsimilar','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('317','shownoperm','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('275','ranks','New[,]0[,]10[,]posts[,][END]Junior Member[,]11[,]99[,]posts[,][END]Senior Member[,]100[,]99999[,]posts[,][END]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('322','registrationdefaults','name=[,]email=[,]signature=[,]customtitle=[,]stylesheet=[,]thetemplate=[,]thelanguage=[,]allowemail=yes[,]allowuseremail=no[,]notifyoflinks=no[,]acceptpms=yes[,]notifyofpms=yes[,]pmnotify=yes[,]moderationpm=no[,]autosubscribe=no[,]autosubscribepost=no[,]notifymethod=instant[,]cookieduration=2592000[,]acceptims=all[,]commentsperpage=[,]linksperpage=[,]location=[,]homepage=[,]occupation=[,]bio=[,]interests=[,]aim=[,]icq=[,]msn=[,]yahoo=[,]birthmonth=[,]birthday=[,]birthyear=[,]visibility=everyone[,]posteditor=plain[,]topics=0[,]posts=0[,]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('276','sessiondelete','15'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('277','nobotsearches','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('274','nobumping','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('278','quotespercent','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('279','resizeavatars','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('280','membersdateformat','%b %d, %Y'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('281','inactivecutoff','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('282','modusergroup','4'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('283','iminterval','20'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('284','pmharddelete','60'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('285','searchdelay','10'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('286','imdelete','30'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('287','imdimensions','width=300,height=300'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('289','resizeheight',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('290','usewater','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('291','watermark','9ce6514dce4d42de59afada3613d3ba5.wsn'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('292','resize','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('293','removeextensions','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('309','redirectduration','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('294','requiredpolls',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('315','nodouble','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('295','pagelist','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('297','similarincat','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('299','titlelength','50'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('308','editgrace','4'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('300','customtitlelength','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('301','autoipban','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('302','chmoddirectories','0777'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('303','banreasons','spam
flaming
trolling
low post quality
TOS violation'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('304','reports','email all'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('305','reportsforum',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('306','columnheader','style=&#34&background-image: url(&#39&{TEMPLATESDIR}/images/columnheader.png&#39&){semicolon} background-repeat: repeat-x{semicolon}&#34& class=&#34&columnheader&#34&'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('307','shoutsperpage','25'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('316','passencode','md5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('312','searchcommentfields','message,linkname'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('310','searchlimit','500'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('320','contactbanned','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('321','sendregconfirmation','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('324','totalsubcats','6'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('325','bannedtitle','banned'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('326','removeredirects','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('328','autoipbanexempt','172.128
172.192
172.208
202.67.66
202.67.68
202.67.72
202.67.80
202.67.96'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('327','allowallextensions','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('329','topiclistdateformat','%b %d, %Y &lt&br&gt& %I:%M %p'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('330','digesttime','1143832783'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('331','digestprogress','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('332','termsofservice','- The site administrators reserve the right to edit or remove any content you submit. Your content may also be reused in different places in different contexts around the site.
&lt&br&gt&&lt&br&gt&
- You may not submit illegal content.
&lt&br&gt&&lt&br&gt&
- Attempting to flood with many submissions is not allowed, nor are automated submissions are allowed.
&lt&br&gt&&lt&br&gt&
- Post posts may not be abusive.
&lt&br&gt&&lt&br&gt&
- Usage of the email features (if enabled) may not be abused to attempt to send spam.'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('333','bannedemails',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('334','throw404s',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('335','expirationwarningdays','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('336','sponsorexpirationwarningdays','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('337','topicedittimelimit','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('338','postedittimelimit','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('339','cookienameuserid','wsnuser'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('340','cookienamepass','wsnpass'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('341','posthistory','15'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('343','titlescheme','{LANG_NAVORIGIN}{LANG_TITLE_DIVIDER}{AREA}'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('342','subscribeunique','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('344','deletedmarkers','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('347','colsatt',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('346','attachcolumns','3'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('348','nobotsmostplaces','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('349','birthdaycache','[DAY:03-31][DAY:03-30][DAY:04-01]'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('350','autopromote',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('351','defaultnoaccess',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('352','maxcomchars','50000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('353','nocross','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('361','expirationdelete','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('354','warningips',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('355','ordercats2','ORDER BY name ASC'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('356','consecutiveshouts','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('357','feeduration','1'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('359','necroposts','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('358','modinherit',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('360','necrodays','0'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('362','votequery','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('363','otherreggroups',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('364','emailbirthdays','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('365','keeporiginals','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('366','warningpm','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('367','staticqueue',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('368','staticqueueitems',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('369','rewritelinkname','threads/{TOPICTITLE}-{TOPICID}.html'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('370','warningdemotelevel',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('371','warningdemotegroup','2'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('372','rewritethreadnames','no'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('373','sponsorugrequired',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('374','adbanner',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('376','chatdelay','5'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('375','sigimages','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('377','degradebrowsers','Safari'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('378','chatminutes','2000'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('379','chatlimit','75'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('380','chatactivity',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('381','calbdays','365'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('382','flagterms',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('383','regcookie','yes'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('384','bannedhosts',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('385','modwhiteboard',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('386','imgtags','100'); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('388','exemptreggroup',''); 
INSERT INTO {PREFIX}settings(id,name,content) VALUES ('387','watercorner','southeast'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('1','members','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('2','ratings','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('3','hits','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('4','comments','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('5','subscriptions','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('6','albums','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('7','getmeta','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('8','pm','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('9','wsncodes','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('10','smilies','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('11','showsubs','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('12','searchincat','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('13','catselector','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('14','onlineusers','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('15','styleselect','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('16','templateselect','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('17','linkcheckers','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('18','reports','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('19','sortcats','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('20','sortlinks','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('21','attachmentstree','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('22','requirerecip','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('23','tos','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('24','ims','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('25','inlinestyle','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('26','buddyignore','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('27','guestbook','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('28','usernotes','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('29','modnotify','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('30','similar','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('31','shoutbox','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('32','shoutbox','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('33','modcolumn','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('34','maintoplist','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('35','forumviews','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('36','posttypes','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('37','topictypes','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('38','birthdays','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('39','timeonline','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('40','contact','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('41','posthistory','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('42','memberratings','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('43','memberhits','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('44','quotes','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('45','help','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('46','quickregistration','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('47','posticons','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('48','warnings','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('50','attachments','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('51','coppa','0'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('52','revisions','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('53','chat','1'); 
INSERT INTO {PREFIX}switches(id,name,value) VALUES ('54','trader','0'); 

CREATE INDEX wsnindex ON {PREFIX}links (catid,lastcomment,title(5));
CREATE INDEX wsnindex ON {PREFIX}categories (priority);
CREATE INDEX wsnindex ON {PREFIX}comments (linkid,time);
CREATE INDEX wsnindex ON {PREFIX}members (id,time);
ALTER TABLE {PREFIX}links ADD FULLTEXT `titleindex` (`title`);
ALTER TABLE {PREFIX}comments ADD FULLTEXT `messageindex` (`message`);
