prefix_3_title_rich لزراعه الجداول المحذوفه في قاعدة البيانات vb3

[محب الرسول]

CREATE TABLE `prefix` ( 
  `prefixid` varchar(25) NOT NULL default '', 
  `prefixsetid` varchar(25) NOT NULL default '', 
  `displayorder` int(10) unsigned NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`prefixid`), 
  KEY `prefixsetid` (`prefixsetid`,`displayorder`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

prefixpermission

CREATE TABLE `prefixpermission` ( 
  `prefixid` varchar(25) NOT NULL default '', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  KEY `prefixsetid` (`prefixid`,`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

prefixset

CREATE TABLE `prefixset` ( 
  `prefixsetid` varchar(25) NOT NULL default '', 
  `displayorder` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`prefixsetid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

product

CREATE TABLE `product` ( 
  `productid` varchar(25) NOT NULL default '', 
  `title` varchar(50) NOT NULL default '', 
  `description` varchar(250) NOT NULL default '', 
  `version` varchar(25) NOT NULL default '', 
  `active` smallint(5) unsigned NOT NULL default '1', 
  `url` varchar(250) NOT NULL default '', 
  `versioncheckurl` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`productid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

productcode

CREATE TABLE `productcode` ( 
  `productcodeid` int(10) unsigned NOT NULL auto_increment, 
  `productid` varchar(25) NOT NULL default '', 
  `version` varchar(25) NOT NULL default '', 
  `installcode` medium****, 
  `uninstallcode` medium****, 
  PRIMARY KEY  (`productcodeid`), 
  KEY `productid` (`productid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

productdependency

CREATE TABLE `productdependency` ( 
  `productdependencyid` int(11) NOT NULL auto_increment, 
  `productid` varchar(25) NOT NULL default '', 
  `dependencytype` varchar(25) NOT NULL default '', 
  `parentproductid` varchar(25) NOT NULL default '', 
  `minversion` varchar(50) NOT NULL default '', 
  `maxversion` varchar(50) NOT NULL default '', 
  PRIMARY KEY  (`productdependencyid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

profileblockprivacy

CREATE TABLE `profileblockprivacy` ( 
  `userid` int(10) unsigned NOT NULL, 
  `blockid` varchar(255) NOT NULL, 
  `requirement` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`blockid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

profilefield

CREATE TABLE `profilefield` ( 
  `profilefieldid` smallint(5) unsigned NOT NULL auto_increment, 
  `profilefieldcategoryid` smallint(5) unsigned NOT NULL default '0', 
  `required` smallint(6) NOT NULL default '0', 
  `hidden` smallint(6) NOT NULL default '0', 
  `maxlength` smallint(6) NOT NULL default '250', 
  `size` smallint(6) NOT NULL default '25', 
  `displayorder` smallint(6) NOT NULL default '0', 
  `editable` smallint(6) NOT NULL default '1', 
  `type` enum('input','select','radio','****area','checkbox','select_multiple') NOT NULL default 'input', 
  `data` medium****, 
  `height` smallint(6) NOT NULL default '0', 
  `def` smallint(6) NOT NULL default '0', 
  `optional` smallint(5) unsigned NOT NULL default '0', 
  `searchable` smallint(6) NOT NULL default '0', 
  `memberlist` smallint(6) NOT NULL default '0', 
  `regex` varchar(255) NOT NULL default '', 
  `form` smallint(6) NOT NULL default '0', 
  `html` smallint(6) NOT NULL default '0', 
  `perline` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`profilefieldid`), 
  KEY `editable` (`editable`), 
  KEY `profilefieldcategoryid` (`profilefieldcategoryid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

profilefieldcategory

CREATE TABLE `profilefieldcategory` ( 
  `profilefieldcategoryid` smallint(5) unsigned NOT NULL auto_increment, 
  `displayorder` smallint(6) NOT NULL default '0', 
  `location` varchar(25) NOT NULL default '', 
  `allowprivacy` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`profilefieldcategoryid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

profilevisitor

CREATE TABLE `profilevisitor` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `visitorid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `visible` int(10) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`visitorid`,`userid`), 
  KEY `userid` (`userid`,`visible`,`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

ranks

CREATE TABLE `ranks` ( 
  `rankid` smallint(5) unsigned NOT NULL auto_increment, 
  `minposts` int(10) unsigned NOT NULL default '0', 
  `ranklevel` smallint(5) unsigned NOT NULL default '0', 
  `rankimg` medium****, 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `type` smallint(5) unsigned NOT NULL default '0', 
  `stack` smallint(5) unsigned NOT NULL default '0', 
  `display` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`rankid`), 
  KEY `grouprank` (`usergroupid`,`minposts`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

reminder

CREATE TABLE `reminder` ( 
  `reminderid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `title` varchar(50) NOT NULL default '', 
  `****` medium****, 
  `duedate` int(10) unsigned NOT NULL default '0', 
  `adminonly` smallint(5) unsigned NOT NULL default '1', 
  `completedby` int(10) unsigned NOT NULL default '0', 
  `completedtime` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`reminderid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

reputation

CREATE TABLE `reputation` ( 
  `reputationid` int(10) unsigned NOT NULL auto_increment, 
  `postid` int(10) unsigned NOT NULL default '1', 
  `userid` int(10) unsigned NOT NULL default '1', 
  `reputation` int(11) NOT NULL default '0', 
  `whoadded` int(10) unsigned NOT NULL default '0', 
  `reason` varchar(250) default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`reputationid`), 
  KEY `userid` (`userid`), 
  KEY `whoadded_postid` (`whoadded`,`postid`), 
  KEY `multi` (`postid`,`userid`), 
  KEY `dateline` (`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

reputationlevel

CREATE TABLE `reputationlevel` ( 
  `reputationlevelid` int(10) unsigned NOT NULL auto_increment, 
  `minimumreputation` int(11) NOT NULL default '0', 
  PRIMARY KEY  (`reputationlevelid`), 
  KEY `reputationlevel` (`minimumreputation`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

rssfeed

CREATE TABLE `rssfeed` ( 
  `rssfeedid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `url` ****, 
  `port` smallint(5) unsigned NOT NULL default '80', 
  `ttl` smallint(5) unsigned NOT NULL default '1500', 
  `maxresults` smallint(6) NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `prefixid` varchar(25) NOT NULL default '', 
  `iconid` smallint(5) unsigned NOT NULL default '0', 
  `titletemplate` medium****, 
  `bodytemplate` medium****, 
  `searchwords` medium****, 
  `itemtype` enum('thread','announcement') NOT NULL default 'thread', 
  `threadactiondelay` smallint(5) unsigned NOT NULL default '0', 
  `endannouncement` int(10) unsigned NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '0', 
  `lastrun` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`rssfeedid`), 
  KEY `lastrun` (`lastrun`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

rsslog

CREATE TABLE `rsslog` ( 
  `rssfeedid` int(10) unsigned NOT NULL default '0', 
  `itemid` int(10) unsigned NOT NULL default '0', 
  `itemtype` enum('thread','announcement') NOT NULL default 'thread', 
  `uniquehash` char(32) NOT NULL default '', 
  `contenthash` char(32) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `threadactiontime` int(10) unsigned NOT NULL default '0', 
  `threadactioncomplete` tinyint(3) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`rssfeedid`,`itemid`,`itemtype`), 
  UNIQUE KEY `uniquehash` (`uniquehash`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

search

CREATE TABLE `search` ( 
  `searchid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `ipaddress` char(15) NOT NULL default '', 
  `personal` smallint(5) unsigned NOT NULL default '0', 
  `query` varchar(200) NOT NULL default '', 
  `searchuser` varchar(200) NOT NULL default '', 
  `forumchoice` medium****, 
  `prefixchoice` medium****, 
  `sortby` varchar(200) NOT NULL default '', 
  `sortorder` varchar(4) NOT NULL default '', 
  `searchtime` float NOT NULL default '0', 
  `showposts` smallint(5) unsigned NOT NULL default '0', 
  `orderedids` medium****, 
  `announceids` medium****, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `searchterms` medium****, 
  `displayterms` medium****, 
  `searchhash` varchar(32) NOT NULL default '', 
  `titleonly` smallint(5) unsigned NOT NULL default '0', 
  `completed` smallint(5) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`searchid`), 
  UNIQUE KEY `searchunique` (`searchhash`,`sortby`,`sortorder`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

session

CREATE TABLE `session` ( 
  `sessionhash` char(32) NOT NULL default '', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `host` char(15) NOT NULL default '', 
  `idhash` char(32) NOT NULL default '', 
  `lastactivity` int(10) unsigned NOT NULL default '0', 
  `location` char(255) NOT NULL default '', 
  `useragent` char(100) NOT NULL default '', 
  `styleid` smallint(5) unsigned NOT NULL default '0', 
  `languageid` smallint(5) unsigned NOT NULL default '0', 
  `loggedin` smallint(5) unsigned NOT NULL default '0', 
  `inforum` smallint(5) unsigned NOT NULL default '0', 
  `inthread` int(10) unsigned NOT NULL default '0', 
  `incalendar` smallint(5) unsigned NOT NULL default '0', 
  `badlocation` smallint(5) unsigned NOT NULL default '0', 
  `bypass` tinyint(4) NOT NULL default '0', 
  `profileupdate` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`sessionhash`) 
) ENGINE=MEMORY DEFAULT CHARSET=latin1; 

setting

CREATE TABLE `setting` ( 
  `varname` varchar(100) NOT NULL default '', 
  `grouptitle` varchar(50) NOT NULL default '', 
  `value` medium****, 
  `defaultvalue` medium****, 
  `optioncode` medium****, 
  `displayorder` smallint(5) unsigned NOT NULL default '0', 
  `advanced` smallint(6) NOT NULL default '0', 
  `volatile` smallint(5) unsigned NOT NULL default '0', 
  `datatype` enum('free','number','boolean','bitfield','username','integer','posint') NOT NULL default 'free', 
  `product` varchar(25) NOT NULL default '', 
  `validationcode` ****, 
  `blacklist` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`varname`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

settinggroup

CREATE TABLE `settinggroup` ( 
  `grouptitle` char(50) NOT NULL default '', 
  `displayorder` smallint(5) unsigned NOT NULL default '0', 
  `volatile` smallint(5) unsigned NOT NULL default '0', 
  `product` varchar(25) NOT NULL default '', 
  PRIMARY KEY  (`grouptitle`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

sigparsed

CREATE TABLE `sigparsed` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `styleid` smallint(5) unsigned NOT NULL default '0', 
  `languageid` smallint(5) unsigned NOT NULL default '0', 
  `signatureparsed` medium****, 
  `hasimages` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`styleid`,`languageid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

sigpic

CREATE TABLE `sigpic` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `filedata` mediumblob, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `filename` varchar(100) NOT NULL default '', 
  `visible` smallint(6) NOT NULL default '1', 
  `filesize` int(10) unsigned NOT NULL default '0', 
  `width` smallint(5) unsigned NOT NULL default '0', 
  `height` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

smilie

CREATE TABLE `smilie` ( 
  `smilieid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` char(100) NOT NULL default '', 
  `smilie****` char(20) NOT NULL default '', 
  `smiliepath` char(100) NOT NULL default '', 
  `imagecategoryid` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` smallint(5) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`smilieid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

socialgroup

CREATE TABLE `socialgroup` ( 
  `groupid` int(10) unsigned NOT NULL auto_increment, 
  `socialgroupcategoryid` int(10) unsigned NOT NULL, 
  `name` varchar(255) NOT NULL default '', 
  `description` ****, 
  `creatoruserid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `members` int(10) unsigned NOT NULL default '0', 
  `picturecount` int(10) unsigned NOT NULL default '0', 
  `lastpost` int(10) unsigned NOT NULL default '0', 
  `lastposter` varchar(255) NOT NULL default '', 
  `lastposterid` int(10) unsigned NOT NULL default '0', 
  `lastgmid` int(10) unsigned NOT NULL default '0', 
  `visible` int(10) unsigned NOT NULL default '0', 
  `deleted` int(10) unsigned NOT NULL default '0', 
  `moderation` int(10) unsigned NOT NULL default '0', 
  `type` enum('public','moderated','inviteonly') NOT NULL default 'public', 
  `moderatedmembers` int(10) unsigned NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '0', 
  `lastdiscussionid` int(10) unsigned NOT NULL default '0', 
  `discussions` int(10) unsigned default '0', 
  `lastdiscussion` varchar(255) NOT NULL default '', 
  `lastupdate` int(10) unsigned NOT NULL default '0', 
  `transferowner` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`groupid`), 
  KEY `creatoruserid` (`creatoruserid`), 
  KEY `dateline` (`dateline`), 
  KEY `members` (`members`), 
  KEY `picturecount` (`picturecount`), 
  KEY `visible` (`visible`), 
  KEY `lastpost` (`lastpost`), 
  KEY `socialgroupcategoryid` (`socialgroupcategoryid`), 
  FULL**** KEY `name` (`name`,`description`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

socialgroupcategory

CREATE TABLE `socialgroupcategory` ( 
  `socialgroupcategoryid` int(10) unsigned NOT NULL auto_increment, 
  `creatoruserid` int(10) unsigned NOT NULL, 
  `title` varchar(250) NOT NULL, 
  `description` **** NOT NULL, 
  `displayorder` int(10) unsigned NOT NULL, 
  `lastupdate` int(10) unsigned NOT NULL, 
  `groups` int(10) unsigned default '0', 
  PRIMARY KEY  (`socialgroupcategoryid`), 
  KEY `displayorder` (`displayorder`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

socialgroupicon

CREATE TABLE `socialgroupicon` ( 
  `groupid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned default '0', 
  `filedata` mediumblob, 
  `extension` varchar(20) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `width` int(10) unsigned NOT NULL default '0', 
  `height` int(10) unsigned NOT NULL default '0', 
  `thumbnail_filedata` mediumblob, 
  `thumbnail_width` int(10) unsigned NOT NULL default '0', 
  `thumbnail_height` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`groupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

socialgroupmember

CREATE TABLE `socialgroupmember` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `groupid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `type` enum('member','moderated','invited') NOT NULL default 'member', 
  PRIMARY KEY  (`groupid`,`userid`), 
  KEY `groupid` (`groupid`,`type`), 
  KEY `userid` (`userid`,`type`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

socialgrouppicture

CREATE TABLE `socialgrouppicture` ( 
  `groupid` int(10) unsigned NOT NULL default '0', 
  `pictureid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`groupid`,`pictureid`), 
  KEY `groupid` (`groupid`,`dateline`), 
  KEY `pictureid` (`pictureid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

spamlog

CREATE TABLE `spamlog` ( 
  `postid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`postid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

stats

CREATE TABLE `stats` ( 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `nuser` mediumint(8) unsigned NOT NULL default '0', 
  `nthread` mediumint(8) unsigned NOT NULL default '0', 
  `npost` mediumint(8) unsigned NOT NULL default '0', 
  `ausers` mediumint(8) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

strikes

CREATE TABLE `strikes` ( 
  `striketime` int(10) unsigned NOT NULL default '0', 
  `strikeip` char(15) NOT NULL default '', 
  `username` varchar(100) NOT NULL default '', 
  KEY `striketime` (`striketime`), 
  KEY `strikeip` (`strikeip`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

style

CREATE TABLE `style` ( 
  `styleid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `parentid` smallint(6) NOT NULL default '0', 
  `parentlist` varchar(250) NOT NULL default '', 
  `templatelist` medium****, 
  `csscolors` medium****, 
  `css` medium****, 
  `stylevars` medium****, 
  `replacements` medium****, 
  `editorstyles` medium****, 
  `userselect` smallint(5) unsigned NOT NULL default '1', 
  `displayorder` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`styleid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscribediscussion

CREATE TABLE `subscribediscussion` ( 
  `subscribediscussionid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL, 
  `discussionid` int(10) unsigned NOT NULL, 
  `emailupdate` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`subscribediscussionid`), 
  UNIQUE KEY `userdiscussion` (`userid`,`discussionid`), 
  KEY `discussionid` (`discussionid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscribeevent

CREATE TABLE `subscribeevent` ( 
  `subscribeeventid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `eventid` int(10) unsigned NOT NULL default '0', 
  `lastreminder` int(10) unsigned NOT NULL default '0', 
  `reminder` int(10) unsigned NOT NULL default '3600', 
  PRIMARY KEY  (`subscribeeventid`), 
  UNIQUE KEY `subindex` (`userid`,`eventid`), 
  KEY `eventid` (`eventid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscribefom

CREATE TABLE `subscribeforum` ( 
  `subscribeforumid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `emailupdate` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`subscribeforumid`), 
  UNIQUE KEY `subindex` (`userid`,`forumid`), 
  KEY `forumid` (`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscribegroup

CREATE TABLE `subscribegroup` ( 
  `subscribegroupid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL, 
  `groupid` int(10) unsigned NOT NULL, 
  `emailupdate` enum('daily','weekly','none') NOT NULL default 'none', 
  PRIMARY KEY  (`subscribegroupid`), 
  UNIQUE KEY `usergroup` (`userid`,`groupid`), 
  KEY `groupid` (`groupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscribethread

CREATE TABLE `subscribethread` ( 
  `subscribethreadid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `emailupdate` smallint(5) unsigned NOT NULL default '0', 
  `folderid` int(10) unsigned NOT NULL default '0', 
  `canview` smallint(5) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`subscribethreadid`), 
  UNIQUE KEY `threadid` (`threadid`,`userid`), 
  KEY `userid` (`userid`,`folderid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscription

CREATE TABLE `subscription` ( 
  `subscriptionid` smallint(5) unsigned NOT NULL auto_increment, 
  `varname` varchar(100) NOT NULL default '', 
  `cost` medium****, 
  `forums` medium****, 
  `nusergroupid` smallint(6) NOT NULL default '0', 
  `membergroupids` varchar(255) NOT NULL default '', 
  `active` smallint(5) unsigned NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '0', 
  `displayorder` smallint(5) unsigned NOT NULL default '1', 
  `adminoptions` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`subscriptionid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscriptionlog

CREATE TABLE `subscriptionlog` ( 
  `subscriptionlogid` mediumint(8) unsigned NOT NULL auto_increment, 
  `subscriptionid` smallint(6) NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `pusergroupid` smallint(6) NOT NULL default '0', 
  `status` smallint(6) NOT NULL default '0', 
  `regdate` int(10) unsigned NOT NULL default '0', 
  `expirydate` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`subscriptionlogid`), 
  KEY `userid` (`userid`,`subscriptionid`), 
  KEY `subscriptionid` (`subscriptionid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

subscriptionpermission

CREATE TABLE `subscriptionpermission` ( 
  `subscriptionpermissionid` int(10) unsigned NOT NULL auto_increment, 
  `subscriptionid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`subscriptionpermissionid`), 
  UNIQUE KEY `subscriptionid` (`subscriptionid`,`usergroupid`), 
  KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

tachyfomcounter

CREATE TABLE `tachyforumcounter` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `threadcount` mediumint(8) unsigned NOT NULL default '0', 
  `replycount` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

tachyfompost

CREATE TABLE `tachyforumpost` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` int(10) unsigned NOT NULL default '0', 
  `lastpost` int(10) unsigned NOT NULL default '0', 
  `lastposter` varchar(100) NOT NULL default '', 
  `lastpostid` int(10) unsigned NOT NULL default '0', 
  `lastthread` varchar(250) NOT NULL default '', 
  `lastthreadid` int(10) unsigned NOT NULL default '0', 
  `lasticonid` smallint(5) unsigned NOT NULL default '0', 
  `lastprefixid` varchar(25) NOT NULL default '', 
  PRIMARY KEY  (`userid`,`forumid`), 
  KEY `forumid` (`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

tachythreadcounter

CREATE TABLE `tachythreadcounter` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `replycount` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`threadid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

tachythreadpost

CREATE TABLE `tachythreadpost` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `lastpost` int(10) unsigned NOT NULL default '0', 
  `lastposter` varchar(100) NOT NULL default '', 
  `lastpostid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`threadid`), 
  KEY `threadid` (`threadid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

tag

CREATE TABLE `tag` ( 
  `tagid` int(10) unsigned NOT NULL auto_increment, 
  `tag****` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`tagid`), 
  UNIQUE KEY `tag****` (`tag****`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

tagsearch

CREATE TABLE `tagsearch` ( 
  `tagid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  KEY `tagid` (`tagid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

tagthread

CREATE TABLE `tagthread` ( 
  `tagid` int(10) unsigned NOT NULL default '0', 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`tagid`,`threadid`), 
  KEY `threadid` (`threadid`,`userid`), 
  KEY `dateline` (`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

template

CREATE TABLE `template` ( 
  `templateid` int(10) unsigned NOT NULL auto_increment, 
  `styleid` smallint(6) NOT NULL default '0', 
  `title` varchar(100) NOT NULL default '', 
  `template` medium****, 
  `template_un` medium****, 
  `templatetype` enum('template','stylevar','css','replacement') NOT NULL default 'template', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `version` varchar(30) NOT NULL default '', 
  `product` varchar(25) NOT NULL default '', 
  PRIMARY KEY  (`templateid`), 
  UNIQUE KEY `title` (`title`,`styleid`,`templatetype`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

templatehistory

CREATE TABLE `templatehistory` ( 
  `templatehistoryid` int(10) unsigned NOT NULL auto_increment, 
  `styleid` smallint(5) unsigned NOT NULL default '0', 
  `title` varchar(100) NOT NULL default '', 
  `template` medium****, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `version` varchar(30) NOT NULL default '', 
  `comment` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`templatehistoryid`), 
  KEY `title` (`title`,`styleid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

thread

CREATE TABLE `thread` ( 
  `threadid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `prefixid` varchar(25) NOT NULL default '', 
  `firstpostid` int(10) unsigned NOT NULL default '0', 
  `lastpostid` int(10) unsigned NOT NULL default '0', 
  `lastpost` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `pollid` int(10) unsigned NOT NULL default '0', 
  `open` smallint(6) NOT NULL default '0', 
  `replycount` int(10) unsigned NOT NULL default '0', 
  `hiddencount` int(10) unsigned NOT NULL default '0', 
  `deletedcount` int(10) unsigned NOT NULL default '0', 
  `postusername` varchar(100) NOT NULL default '', 
  `postuserid` int(10) unsigned NOT NULL default '0', 
  `lastposter` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `views` int(10) unsigned NOT NULL default '0', 
  `iconid` smallint(5) unsigned NOT NULL default '0', 
  `notes` varchar(250) NOT NULL default '', 
  `visible` smallint(6) NOT NULL default '0', 
  `sticky` smallint(6) NOT NULL default '0', 
  `votenum` smallint(5) unsigned NOT NULL default '0', 
  `votetotal` smallint(5) unsigned NOT NULL default '0', 
  `attach` smallint(5) unsigned NOT NULL default '0', 
  `similar` varchar(55) NOT NULL default '', 
  `taglist` medium****, 
  `vbseo_linkbacks_no` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`threadid`), 
  KEY `postuserid` (`postuserid`), 
  KEY `pollid` (`pollid`), 
  KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`), 
  KEY `lastpost` (`lastpost`,`forumid`), 
  KEY `dateline` (`dateline`), 
  KEY `prefixid` (`prefixid`,`forumid`), 
  FULL**** KEY `title` (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

threadrate

CREATE TABLE `threadrate` ( 
  `threadrateid` int(10) unsigned NOT NULL auto_increment, 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `vote` smallint(6) NOT NULL default '0', 
  `ipaddress` char(15) NOT NULL default '', 
  PRIMARY KEY  (`threadrateid`), 
  KEY `threadid` (`threadid`,`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

threadread

CREATE TABLE `threadread` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `readtime` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`,`threadid`), 
  KEY `readtime` (`readtime`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

threadredirect

CREATE TABLE `threadredirect` ( 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `expires` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`threadid`), 
  KEY `expires` (`expires`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

threadviews

CREATE TABLE `threadviews` ( 
  `threadid` int(10) unsigned NOT NULL default '0', 
  KEY `threadid` (`threadid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

upgradelog

CREATE TABLE `upgradelog` ( 
  `upgradelogid` int(10) unsigned NOT NULL auto_increment, 
  `script` varchar(50) NOT NULL default '', 
  `steptitle` varchar(250) NOT NULL default '', 
  `step` smallint(5) unsigned NOT NULL default '0', 
  `startat` int(10) unsigned NOT NULL default '0', 
  `perpage` smallint(5) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`upgradelogid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

user

CREATE TABLE `user` ( 
  `userid` int(10) unsigned NOT NULL auto_increment, 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `membergroupids` char(250) NOT NULL default '', 
  `displaygroupid` smallint(5) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `password` char(32) NOT NULL default '', 
  `passworddate` date NOT NULL default '0000-00-00', 
  `email` char(100) NOT NULL default '', 
  `styleid` smallint(5) unsigned NOT NULL default '0', 
  `parentemail` char(50) NOT NULL default '', 
  `homepage` char(100) NOT NULL default '', 
  `icq` char(20) NOT NULL default '', 
  `aim` char(20) NOT NULL default '', 
  `yahoo` char(32) NOT NULL default '', 
  `msn` char(100) NOT NULL default '', 
  `skype` char(32) NOT NULL default '', 
  `showvbcode` smallint(5) unsigned NOT NULL default '0', 
  `showbirthday` smallint(5) unsigned NOT NULL default '2', 
  `usertitle` char(250) NOT NULL default '', 
  `customtitle` smallint(6) NOT NULL default '0', 
  `joindate` int(10) unsigned NOT NULL default '0', 
  `daysprune` smallint(6) NOT NULL default '0', 
  `lastvisit` int(10) unsigned NOT NULL default '0', 
  `lastactivity` int(10) unsigned NOT NULL default '0', 
  `lastpost` int(10) unsigned NOT NULL default '0', 
  `lastpostid` int(10) unsigned NOT NULL default '0', 
  `posts` int(10) unsigned NOT NULL default '0', 
  `reputation` int(11) NOT NULL default '10', 
  `reputationlevelid` int(10) unsigned NOT NULL default '1', 
  `timezoneoffset` char(4) NOT NULL default '', 
  `pmpopup` smallint(6) NOT NULL default '0', 
  `avatarid` smallint(6) NOT NULL default '0', 
  `avatarrevision` int(10) unsigned NOT NULL default '0', 
  `profilepicrevision` int(10) unsigned NOT NULL default '0', 
  `sigpicrevision` int(10) unsigned NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '33554447', 
  `birthday` char(10) NOT NULL default '', 
  `birthday_search` date NOT NULL default '0000-00-00', 
  `maxposts` smallint(6) NOT NULL default '-1', 
  `startofweek` smallint(6) NOT NULL default '1', 
  `ipaddress` char(15) NOT NULL default '', 
  `referrerid` int(10) unsigned NOT NULL default '0', 
  `languageid` smallint(5) unsigned NOT NULL default '0', 
  `emailstamp` int(10) unsigned NOT NULL default '0', 
  `threadedmode` smallint(5) unsigned NOT NULL default '0', 
  `autosubscribe` smallint(6) NOT NULL default '-1', 
  `pmtotal` smallint(5) unsigned NOT NULL default '0', 
  `pmunread` smallint(5) unsigned NOT NULL default '0', 
  `salt` char(3) NOT NULL default '', 
  `ipoints` int(10) unsigned NOT NULL default '0', 
  `infractions` int(10) unsigned NOT NULL default '0', 
  `warnings` int(10) unsigned NOT NULL default '0', 
  `infractiongroupids` varchar(255) NOT NULL default '', 
  `infractiongroupid` smallint(5) unsigned NOT NULL default '0', 
  `adminoptions` int(10) unsigned NOT NULL default '0', 
  `profilevisits` int(10) unsigned NOT NULL default '0', 
  `friendcount` int(10) unsigned NOT NULL default '0', 
  `friendreqcount` int(10) unsigned NOT NULL default '0', 
  `vmunreadcount` int(10) unsigned NOT NULL default '0', 
  `vmmoderatedcount` int(10) unsigned NOT NULL default '0', 
  `socgroupinvitecount` int(10) unsigned NOT NULL default '0', 
  `socgroupreqcount` int(10) unsigned NOT NULL default '0', 
  `pcunreadcount` int(10) unsigned NOT NULL default '0', 
  `pcmoderatedcount` int(10) unsigned NOT NULL default '0', 
  `gmmoderatedcount` int(10) unsigned NOT NULL default '0', 
  `mwaextraadmin3_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') default NULL, 
  `mwaextraadmin3_imageresizer_maxwidth` smallint(5) unsigned default NULL, 
  `mwaextraadmin3_imageresizer_maxheight` smallint(5) unsigned default NULL, 
  PRIMARY KEY  (`userid`), 
  KEY `usergroupid` (`usergroupid`), 
  KEY `username` (`username`), 
  KEY `birthday` (`birthday`,`showbirthday`), 
  KEY `birthday_search` (`birthday_search`), 
  KEY `referrerid` (`referrerid`), 
  KEY `lastactivity` (`lastactivity`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

useractivation

CREATE TABLE `useractivation` ( 
  `useractivationid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `activationid` varchar(40) NOT NULL default '', 
  `type` smallint(5) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `emailchange` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`useractivationid`), 
  UNIQUE KEY `userid` (`userid`,`type`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

userban

CREATE TABLE `userban` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `displaygroupid` smallint(5) unsigned NOT NULL default '0', 
  `usertitle` varchar(250) NOT NULL default '', 
  `customtitle` smallint(6) NOT NULL default '0', 
  `adminid` int(10) unsigned NOT NULL default '0', 
  `bandate` int(10) unsigned NOT NULL default '0', 
  `liftdate` int(10) unsigned NOT NULL default '0', 
  `reason` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`userid`), 
  KEY `liftdate` (`liftdate`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

userchangelog

CREATE TABLE `userchangelog` ( 
  `changeid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `fieldname` varchar(250) NOT NULL default '', 
  `newvalue` varchar(250) NOT NULL default '', 
  `oldvalue` varchar(250) NOT NULL default '', 
  `adminid` int(10) unsigned NOT NULL default '0', 
  `change_time` int(10) unsigned NOT NULL default '0', 
  `change_uniq` varchar(32) NOT NULL default '', 
  PRIMARY KEY  (`changeid`), 
  KEY `userid` (`userid`,`change_time`), 
  KEY `change_time` (`change_time`), 
  KEY `change_uniq` (`change_uniq`), 
  KEY `fieldname` (`fieldname`,`change_time`), 
  KEY `adminid` (`adminid`,`change_time`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

usercss

CREATE TABLE `usercss` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `selector` varchar(30) NOT NULL default '', 
  `property` varchar(30) NOT NULL default '', 
  `value` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`userid`,`selector`,`property`), 
  KEY `property` (`property`,`userid`,`value`(20)) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

usercsscache

CREATE TABLE `usercsscache` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `cachedcss` ****, 
  `buildpermissions` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

userfield

CREATE TABLE `userfield` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `temp` medium****, 
  `field1` medium****, 
  `field2` medium****, 
  `field3` medium****, 
  `field4` medium****, 
  `field631` medium**** NOT NULL, 
  `field632` medium**** NOT NULL, 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

usergroup

CREATE TABLE `usergroup` ( 
  `usergroupid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` char(100) NOT NULL default '', 
  `description` varchar(250) NOT NULL default '', 
  `usertitle` char(100) NOT NULL default '', 
  `passwordexpires` smallint(5) unsigned NOT NULL default '0', 
  `passwordhistory` smallint(5) unsigned NOT NULL default '0', 
  `pmquota` smallint(5) unsigned NOT NULL default '0', 
  `pmsendmax` smallint(5) unsigned NOT NULL default '5', 
  `opentag` ****, 
  `closetag` ****, 
  `canoverride` smallint(5) unsigned NOT NULL default '0', 
  `ispublicgroup` smallint(5) unsigned NOT NULL default '0', 
  `forumpermissions` int(10) unsigned NOT NULL default '0', 
  `pmpermissions` int(10) unsigned NOT NULL default '0', 
  `calendarpermissions` int(10) unsigned NOT NULL default '0', 
  `wolpermissions` int(10) unsigned NOT NULL default '0', 
  `adminpermissions` int(10) unsigned NOT NULL default '0', 
  `genericpermissions` int(10) unsigned NOT NULL default '0', 
  `genericpermissions2` int(10) unsigned NOT NULL default '0', 
  `genericoptions` int(10) unsigned NOT NULL default '0', 
  `signaturepermissions` int(10) unsigned NOT NULL default '0', 
  `visitormessagepermissions` int(10) unsigned NOT NULL default '0', 
  `attachlimit` int(10) unsigned NOT NULL default '0', 
  `avatarmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `avatarmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `avatarmaxsize` int(10) unsigned NOT NULL default '0', 
  `profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `profilepicmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `profilepicmaxsize` int(10) unsigned NOT NULL default '0', 
  `sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `sigpicmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `sigpicmaxsize` int(10) unsigned NOT NULL default '0', 
  `sigmaximages` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxchars` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxrawchars` smallint(5) unsigned NOT NULL default '0', 
  `sigmaxlines` smallint(5) unsigned NOT NULL default '0', 
  `usercsspermissions` int(10) unsigned NOT NULL default '0', 
  `albumpermissions` int(10) unsigned NOT NULL default '0', 
  `albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0', 
  `albumpicmaxheight` smallint(5) unsigned NOT NULL default '0', 
  `albumpicmaxsize` int(10) unsigned NOT NULL default '0', 
  `albummaxpics` int(10) unsigned NOT NULL default '0', 
  `albummaxsize` int(10) unsigned NOT NULL default '0', 
  `socialgrouppermissions` int(10) unsigned NOT NULL default '0', 
  `pmthrottlequantity` int(10) unsigned NOT NULL default '0', 
  `groupiconmaxsize` int(10) unsigned NOT NULL default '0', 
  `maximumsocialgroups` int(10) unsigned NOT NULL default '0', 
  `maxnewthread` int(10) unsigned NOT NULL default '0', 
  `maxnewtime` int(11) NOT NULL default '0', 
  `maxnewpost` int(11) NOT NULL default '0', 
  `maxnewposttime` int(11) NOT NULL default '0', 
  PRIMARY KEY  (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

usergroupleader

CREATE TABLE `usergroupleader` ( 
  `usergroupleaderid` smallint(5) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`usergroupleaderid`), 
  KEY `ugl` (`userid`,`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

usergrouprequest

CREATE TABLE `usergrouprequest` ( 
  `usergrouprequestid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `reason` varchar(250) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`usergrouprequestid`), 
  UNIQUE KEY `userid` (`userid`,`usergroupid`), 
  KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

userlist

CREATE TABLE `userlist` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `relationid` int(10) unsigned NOT NULL default '0', 
  `type` enum('buddy','ignore') NOT NULL default 'buddy', 
  `friend` enum('yes','no','pending','denied') NOT NULL default 'no', 
  PRIMARY KEY  (`userid`,`relationid`,`type`), 
  KEY `relationid` (`relationid`,`type`,`friend`), 
  KEY `userid` (`userid`,`type`,`friend`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

usernote

CREATE TABLE `usernote` ( 
  `usernoteid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `posterid` int(10) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `message` medium****, 
  `title` varchar(255) NOT NULL default '', 
  `allowsmilies` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`usernoteid`), 
  KEY `userid` (`userid`), 
  KEY `posterid` (`posterid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

userpromotion

CREATE TABLE `userpromotion` ( 
  `userpromotionid` int(10) unsigned NOT NULL auto_increment, 
  `usergroupid` int(10) unsigned NOT NULL default '0', 
  `joinusergroupid` int(10) unsigned NOT NULL default '0', 
  `reputation` int(11) NOT NULL default '0', 
  `date` int(10) unsigned NOT NULL default '0', 
  `posts` int(10) unsigned NOT NULL default '0', 
  `strategy` smallint(6) NOT NULL default '0', 
  `type` smallint(6) NOT NULL default '2', 
  PRIMARY KEY  (`userpromotionid`), 
  KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

user****field

CREATE TABLE `user****field` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `subfolders` medium****, 
  `pmfolders` medium****, 
  `buddylist` medium****, 
  `ignorelist` medium****, 
  `signature` medium****, 
  `searchprefs` medium****, 
  `rank` medium****, 
  PRIMARY KEY  (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

usertitle

CREATE TABLE `usertitle` ( 
  `usertitleid` smallint(5) unsigned NOT NULL auto_increment, 
  `minposts` int(10) unsigned NOT NULL default '0', 
  `title` char(250) NOT NULL default '', 
  PRIMARY KEY  (`usertitleid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

visitormessage

CREATE TABLE `visitormessage` ( 
  `vmid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `postuserid` int(10) unsigned NOT NULL default '0', 
  `postusername` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `state` enum('visible','moderation','deleted') NOT NULL default 'visible', 
  `title` varchar(255) NOT NULL default '', 
  `page****` medium****, 
  `ipaddress` int(10) unsigned NOT NULL default '0', 
  `allowsmilie` smallint(5) unsigned NOT NULL default '0', 
  `reportthreadid` int(10) unsigned NOT NULL default '0', 
  `messageread` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`vmid`), 
  KEY `postuserid` (`postuserid`,`userid`,`state`), 
  KEY `userid` (`userid`,`dateline`,`state`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

visitormessage_hash

CREATE TABLE `visitormessage_hash` ( 
  `postuserid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `dupehash` varchar(32) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  KEY `postuserid` (`postuserid`,`dupehash`), 
  KEY `dateline` (`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

word

CREATE TABLE `word` ( 
  `wordid` int(10) unsigned NOT NULL auto_increment, 
  `title` char(50) NOT NULL default '', 
  PRIMARY KEY  (`wordid`), 
  UNIQUE KEY `title` (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

ملاحظة:
يوجد في آخر كل أمر الترميز latin1 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
بالتوفيق للجميع

[محـب الحسين]

مشكور ياغالي وحياك الله ... نرتقب جديدك بشغف ... تقديري

[احزان كربلاء]

جزاك الله خيرا

[عاشقة ام الحسنين]

اللهم صل على محمد وال محمد وعجل فرجهم ياكريم
.الله يعطيك العافيه
تسلم الايادي
كل الشكر لك