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

[محب الرسول]

mailqueue

CREATE TABLE `mailqueue` (
  `mailqueueid` int(10) unsigned NOT NULL auto_increment,
  `dateline` int(10) unsigned NOT NULL default '0',
  `toemail` medium****,
  `fromemail` medium****,
  `subject` medium****,
  `message` medium****,
  `header` medium****,
  PRIMARY KEY  (`mailqueueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

moderation

CREATE TABLE `moderation` (
  `primaryid` int(10) unsigned NOT NULL default '0',
  `type` enum('thread','reply','visitormessage','groupmessage','picturecomment') NOT NULL default 'thread',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`primaryid`,`type`),
  KEY `type` (`type`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

moderator

CREATE TABLE `moderator` (
  `moderatorid` smallint(5) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(6) NOT NULL default '0',
  `permissions` int(10) unsigned NOT NULL default '0',
  `permissions2` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`moderatorid`),
  UNIQUE KEY `userid_forumid` (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

moderatorlog

CREATE TABLE `moderatorlog` (
  `moderatorlogid` int(10) unsigned NOT NULL auto_increment,
  `dateline` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(5) unsigned NOT NULL default '0',
  `threadid` int(10) unsigned NOT NULL default '0',
  `postid` int(10) unsigned NOT NULL default '0',
  `pollid` int(10) unsigned NOT NULL default '0',
  `attachmentid` int(10) unsigned NOT NULL default '0',
  `action` varchar(250) NOT NULL default '',
  `type` smallint(5) unsigned NOT NULL default '0',
  `threadtitle` varchar(250) NOT NULL default '',
  `ipaddress` char(15) NOT NULL default '',
  `product` varchar(25) NOT NULL default '',
  `id1` int(10) unsigned NOT NULL default '0',
  `id2` int(10) unsigned NOT NULL default '0',
  `id3` int(10) unsigned NOT NULL default '0',
  `id4` int(10) unsigned NOT NULL default '0',
  `id5` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`moderatorlogid`),
  KEY `threadid` (`threadid`),
  KEY `product` (`product`),
  KEY `id1` (`id1`),
  KEY `id2` (`id2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

notice

CREATE TABLE `notice` (
  `noticeid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  `persistent` smallint(5) unsigned NOT NULL default '0',
  `active` smallint(5) unsigned NOT NULL default '0',
  `dismissible` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`noticeid`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

noticecriteria

CREATE TABLE `noticecriteria` (
  `noticeid` int(10) unsigned NOT NULL default '0',
  `criteriaid` varchar(250) NOT NULL default '',
  `condition1` varchar(250) NOT NULL default '',
  `condition2` varchar(250) NOT NULL default '',
  `condition3` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`noticeid`,`criteriaid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

noticedismissed

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

package

CREATE TABLE `package` (
  `packageid` int(10) unsigned NOT NULL auto_increment,
  `productid` varchar(25) NOT NULL,
  `class` varbinary(50) NOT NULL,
  PRIMARY KEY  (`packageid`),
  UNIQUE KEY `class` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

passwordhistory

CREATE TABLE `passwordhistory` (
  `userid` int(10) unsigned NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `passworddate` date NOT NULL default '0000-00-00',
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

paymentapi

CREATE TABLE `paymentapi` (
  `paymentapiid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `currency` varchar(250) NOT NULL default '',
  `recurring` smallint(6) NOT NULL default '0',
  `classname` varchar(250) NOT NULL default '',
  `active` smallint(6) NOT NULL default '0',
  `settings` medium****,
  PRIMARY KEY  (`paymentapiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

paymentinfo

CREATE TABLE `paymentinfo` (
  `paymentinfoid` int(10) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `subscriptionid` smallint(5) unsigned NOT NULL default '0',
  `subscriptionsubid` smallint(5) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `completed` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`paymentinfoid`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

paymenttransaction

CREATE TABLE `paymenttransaction` (
  `paymenttransactionid` int(10) unsigned NOT NULL auto_increment,
  `paymentinfoid` int(10) unsigned NOT NULL default '0',
  `transactionid` varchar(250) NOT NULL default '',
  `state` smallint(5) unsigned NOT NULL default '0',
  `amount` double unsigned NOT NULL default '0',
  `currency` varchar(5) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `paymentapiid` int(10) unsigned NOT NULL default '0',
  `request` medium****,
  `reversed` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`paymenttransactionid`),
  KEY `dateline` (`dateline`),
  KEY `transactionid` (`transactionid`),
  KEY `paymentapiid` (`paymentapiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

phrase

CREATE TABLE `phrase` (
  `phraseid` int(10) unsigned NOT NULL auto_increment,
  `languageid` smallint(6) NOT NULL default '0',
  `varname` varchar(250) character set latin1 collate latin1_bin NOT NULL default '',
  `fieldname` varchar(20) NOT NULL default '',
  `****` medium****,
  `product` varchar(25) NOT NULL default '',
  `username` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `version` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`phraseid`),
  UNIQUE KEY `name_lang_type` (`varname`,`languageid`,`fieldname`),
  KEY `languageid` (`languageid`,`fieldname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

phrasetype

CREATE TABLE `phrasetype` (
  `fieldname` char(20) NOT NULL default '',
  `title` char(50) NOT NULL default '',
  `editrows` smallint(5) unsigned NOT NULL default '0',
  `product` varchar(25) NOT NULL default '',
  `special` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`fieldname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

picturecomment

CREATE TABLE `picturecomment` (
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `filedataid` int(10) unsigned NOT NULL default '0',
  `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(6) NOT NULL default '1',
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  `messageread` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`commentid`),
  KEY `filedataid` (`filedataid`,`userid`,`dateline`,`state`),
  KEY `postuserid` (`postuserid`,`filedataid`,`userid`,`state`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

picturecomment_hash

CREATE TABLE `picturelegacy` (
  `type` enum('album','group') NOT NULL default 'album',
  `primaryid` int(10) unsigned NOT NULL default '0',
  `pictureid` int(10) unsigned NOT NULL default '0',
  `attachmentid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`type`,`primaryid`,`pictureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

plugin

CREATE TABLE `plugin` (
  `pluginid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `hookname` varchar(250) NOT NULL default '',
  `phpcode` ****,
  `product` varchar(25) NOT NULL default '',
  `devkey` varchar(25) NOT NULL default '',
  `active` smallint(6) NOT NULL default '0',
  `executionorder` smallint(5) unsigned NOT NULL default '5',
  PRIMARY KEY  (`pluginid`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

pm

CREATE TABLE `pm` (
  `pmid` int(10) unsigned NOT NULL auto_increment,
  `pm****id` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `folderid` smallint(6) NOT NULL default '0',
  `messageread` smallint(5) unsigned NOT NULL default '0',
  `parentpmid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pmid`),
  KEY `pm****id` (`pm****id`),
  KEY `userid` (`userid`,`folderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

pmreceipt

CREATE TABLE `pmreceipt` (
  `pmid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `touserid` int(10) unsigned NOT NULL default '0',
  `tousername` varchar(100) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `sendtime` int(10) unsigned NOT NULL default '0',
  `readtime` int(10) unsigned NOT NULL default '0',
  `denied` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pmid`),
  KEY `userid` (`userid`,`readtime`),
  KEY `touserid` (`touserid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

pm****

CREATE TABLE `pm****` (
  `pm****id` int(10) unsigned NOT NULL auto_increment,
  `fromuserid` int(10) unsigned NOT NULL default '0',
  `fromusername` varchar(100) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `message` medium****,
  `touserarray` medium****,
  `iconid` smallint(5) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `showsignature` smallint(5) unsigned NOT NULL default '0',
  `allowsmilie` smallint(5) unsigned NOT NULL default '1',
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pm****id`),
  KEY `fromuserid` (`fromuserid`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

pmthrottle

CREATE TABLE `pmthrottle` (
  `userid` int(10) unsigned NOT NULL,
  `dateline` int(10) unsigned NOT NULL,
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

podcast

CREATE TABLE `podcast` (
  `forumid` int(10) unsigned NOT NULL default '0',
  `author` varchar(255) NOT NULL default '',
  `category` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  `explicit` smallint(6) NOT NULL default '0',
  `enabled` smallint(6) NOT NULL default '1',
  `keywords` varchar(255) NOT NULL default '',
  `owneremail` varchar(255) NOT NULL default '',
  `ownername` varchar(255) NOT NULL default '',
  `subtitle` varchar(255) NOT NULL default '',
  `summary` medium****,
  `categoryid` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

podcastitem

CREATE TABLE `podcastitem` (
  `postid` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `length` int(10) unsigned NOT NULL default '0',
  `explicit` smallint(5) unsigned NOT NULL default '0',
  `keywords` varchar(255) NOT NULL default '',
  `subtitle` varchar(255) NOT NULL default '',
  `author` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

poll

CREATE TABLE `poll` (
  `pollid` int(10) unsigned NOT NULL auto_increment,
  `question` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `options` ****,
  `votes` ****,
  `active` smallint(6) NOT NULL default '1',
  `numberoptions` smallint(5) unsigned NOT NULL default '0',
  `timeout` smallint(5) unsigned NOT NULL default '0',
  `multiple` smallint(5) unsigned NOT NULL default '0',
  `voters` smallint(5) unsigned NOT NULL default '0',
  `public` smallint(6) NOT NULL default '0',
  `lastvote` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pollid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

pollvote

CREATE TABLE `pollvote` (
  `pollvoteid` int(10) unsigned NOT NULL auto_increment,
  `pollid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned default NULL,
  `votedate` int(10) unsigned NOT NULL default '0',
  `voteoption` int(10) unsigned NOT NULL default '0',
  `votetype` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pollvoteid`),
  UNIQUE KEY `pollid` (`pollid`,`userid`,`votetype`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

post

CREATE TABLE `post` (
  `postid` int(10) unsigned NOT NULL auto_increment,
  `threadid` int(10) unsigned NOT NULL default '0',
  `parentid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `title` varchar(250) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `page****` medium****,
  `allowsmilie` smallint(6) NOT NULL default '0',
  `showsignature` smallint(6) NOT NULL default '0',
  `ipaddress` char(15) NOT NULL default '',
  `iconid` smallint(5) unsigned NOT NULL default '0',
  `visible` smallint(6) NOT NULL default '0',
  `attach` smallint(5) unsigned NOT NULL default '0',
  `infraction` smallint(5) unsigned NOT NULL default '0',
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`postid`),
  KEY `userid` (`userid`),
  KEY `threadid` (`threadid`,`userid`),
  KEY `threadid_visible_dateline` (`threadid`,`visible`,`dateline`,`userid`,`postid`),
  KEY `dateline` (`dateline`),
  KEY `ipaddress` (`ipaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

postedithistory

CREATE TABLE `postedithistory` (
  `postedithistoryid` int(10) unsigned NOT NULL auto_increment,
  `postid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `iconid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `reason` varchar(200) NOT NULL default '',
  `original` smallint(6) NOT NULL default '0',
  `page****` medium****,
  PRIMARY KEY  (`postedithistoryid`),
  KEY `postid` (`postid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

posthash

CREATE TABLE `posthash` (
  `userid` int(10) unsigned NOT NULL default '0',
  `threadid` int(10) unsigned NOT NULL default '0',
  `postid` int(10) unsigned NOT NULL default '0',
  `dupehash` char(32) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  KEY `userid` (`userid`,`dupehash`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

postlog

CREATE TABLE `postlog` (
  `postid` int(10) unsigned NOT NULL default '0',
  `useragent` char(100) NOT NULL default '',
  `ip` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`postid`),
  KEY `dateline` (`dateline`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

postparsed

CREATE TABLE `postparsed` (
  `postid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `styleid` smallint(5) unsigned NOT NULL default '0',
  `languageid` smallint(5) unsigned NOT NULL default '0',
  `hasimages` smallint(6) NOT NULL default '0',
  `page****_html` medium****,
  PRIMARY KEY  (`postid`,`styleid`,`languageid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

prefix

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`),
  UNIQUE KEY `whoadded_postid` (`whoadded`,`postid`),
  KEY `userid` (`userid`),
  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 ; 

CREATE TABLE `route` (
  `routeid` int(10) unsigned NOT NULL auto_increment,
  `userrequest` varchar(50) NOT NULL,
  `packageid` int(10) unsigned NOT NULL,
  `class` varbinary(50) NOT NULL,
  PRIMARY KEY  (`routeid`),
  UNIQUE KEY `userrequest` (`userrequest`),
  UNIQUE KEY `packageid` (`packageid`,`class`)
) 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; 

searchcore

CREATE TABLE `searchcore` (
  `searchcoreid` int(10) unsigned NOT NULL auto_increment,
  `contenttypeid` int(10) unsigned NOT NULL,
  `primaryid` int(10) unsigned NOT NULL,
  `groupcontenttypeid` int(10) unsigned NOT NULL,
  `groupid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL,
  `ipaddress` int(10) unsigned NOT NULL,
  `searchgroupid` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`searchcoreid`),
  UNIQUE KEY `contentunique` (`contenttypeid`,`primaryid`),
  KEY `groupid` (`groupcontenttypeid`,`groupid`),
  KEY `ipaddress` (`ipaddress`),
  KEY `dateline` (`dateline`),
  KEY `userid` (`userid`),
  KEY `searchgroupid` (`searchgroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

searchcore_****

CREATE TABLE `searchcore_****` (
  `searchcoreid` int(10) unsigned NOT NULL,
  `keyword****` medium****,
  `title` varchar(254) NOT NULL default '',
  PRIMARY KEY  (`searchcoreid`),
  FULL**** KEY `****` (`title`,`keyword****`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

searchgroup

CREATE TABLE `searchgroup` (
  `searchgroupid` int(10) unsigned NOT NULL auto_increment,
  `contenttypeid` int(10) unsigned NOT NULL,
  `groupid` int(10) unsigned NOT NULL,
  `dateline` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL,
  PRIMARY KEY  (`searchgroupid`),
  UNIQUE KEY `groupunique` (`contenttypeid`,`groupid`),
  KEY `dateline` (`dateline`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

searchgroup_****

CREATE TABLE `searchgroup_****` (
  `searchgroupid` int(10) unsigned NOT NULL,
  `title` varchar(254) NOT NULL,
  PRIMARY KEY  (`searchgroupid`),
  FULL**** KEY `grouptitle` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

searchlog

CREATE TABLE `searchlog` (
  `searchlogid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `ipaddress` varchar(15) NOT NULL default '',
  `searchhash` varchar(32) NOT NULL,
  `sortby` varchar(15) NOT NULL default '',
  `sortorder` enum('asc','desc') NOT NULL default 'asc',
  `searchtime` float unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `completed` smallint(5) unsigned NOT NULL default '0',
  `criteria` **** NOT NULL,
  `results` mediumblob,
  PRIMARY KEY  (`searchlogid`),
  KEY `search` (`userid`,`searchhash`,`sortby`,`sortorder`),
  KEY `userfloodcheck` (`userid`,`dateline`),
  KEY `ipfloodcheck` (`ipaddress`,`dateline`)
) 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`),
  KEY `user_activity` (`userid`,`lastactivity`),
  KEY `guest_lookup` (`idhash`,`host`,`userid`)
) 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`)
) 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; 

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****,
  `newstylevars` medium****,
  `replacements` medium****,
  `editorstyles` medium****,
  `userselect` smallint(5) unsigned NOT NULL default '1',
  `displayorder` smallint(5) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

stylevar

CREATE TABLE `stylevar` (
  `stylevarid` varchar(250) NOT NULL,
  `styleid` smallint(6) NOT NULL default '-1',
  `value` mediumblob NOT NULL,
  `dateline` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  UNIQUE KEY `stylevarinstance` (`stylevarid`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

stylevardfn

CREATE TABLE `stylevardfn` (
  `stylevarid` varchar(250) NOT NULL,
  `styleid` smallint(6) NOT NULL default '-1',
  `parentid` smallint(6) NOT NULL,
  `parentlist` varchar(250) NOT NULL default '0',
  `stylevargroup` varchar(250) NOT NULL,
  `product` varchar(25) NOT NULL default 'vbulletin',
  `datatype` varchar(25) NOT NULL default 'string',
  `validation` varchar(250) NOT NULL,
  `failsafe` mediumblob NOT NULL,
  `units` enum('','%','px','pt','em','ex','pc','in','cm','mm') NOT NULL default '',
  `uneditable` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`stylevarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

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 `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 '',
  `lastposterid` int(10) unsigned NOT NULL default '0',
  `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 '',
  `lastposterid` int(10) unsigned NOT NULL default '0',
  `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',
  `canonicaltagid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`tagid`),
  UNIQUE KEY `tag****` (`tag****`),
  KEY `canonicaltagid` (`canonicaltagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

tagcontent

CREATE TABLE `tagcontent` (
  `tagid` int(10) unsigned NOT NULL default '0',
  `contenttypeid` int(10) unsigned NOT NULL,
  `contentid` 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`,`contenttypeid`,`contentid`),
  KEY `id_type_user` (`contentid`,`contenttypeid`,`userid`),
  KEY `user` (`userid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

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; 

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 '',
  `mergestatus` enum('none','merged','conflicted') NOT NULL default 'none',
  PRIMARY KEY  (`templateid`),
  UNIQUE KEY `title` (`title`,`styleid`,`templatetype`),
  KEY `styleid` (`styleid`)
) 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 ; 

templatemerge

CREATE TABLE `templatemerge` (
  `templateid` int(10) unsigned NOT NULL default '0',
  `template` medium**** NOT NULL,
  `version` varchar(30) NOT NULL default '',
  `savedtemplateid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`templateid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

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 '',
  `lastposterid` int(10) unsigned NOT NULL default '0',
  `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****,
  `keywords` medium****,
  PRIMARY KEY  (`threadid`),
  KEY `postuserid` (`postuserid`),
  KEY `pollid` (`pollid`),
  KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
  KEY `forumid_lastpost` (`forumid`,`lastpost`),
  KEY `lastpost` (`lastpost`),
  KEY `dateline` (`dateline`),
  KEY `prefixid` (`prefixid`,`forumid`)
) 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 '33570831',
  `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',
  `assetposthash` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`userid`),
  KEY `usergroupid` (`usergroupid`),
  KEY `username` (`username`),
  KEY `birthday` (`birthday`,`showbirthday`),
  KEY `birthday_search` (`birthday_search`),
  KEY `referrerid` (`referrerid`)
) 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****,
  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` char(100) NOT NULL default '',
  `closetag` char(100) NOT NULL default '',
  `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',
  PRIMARY KEY  (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

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

بالتوفيق للجميع وان شاء الله
عن قريب رح نزل شرح خاص بجداول قاعدة البيانات للجيل الثالث
التنسيق اخدلي وقت كثير بتمنى يفيدكم
تحياتي

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

بارك الله فيك اخي

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

اللهم صل على محمد وآل محمد وعجل فرجهم ياكريم
مجهود رائع
جزاك الله خير

[صدى المهدي]

اللهم صل على محمد وال محمد
احسنتم ويبارك الله بكم
شكرا لكم