محب الرسول
23-02-2013, 08:16 PM
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','groupmessa ge','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','usernam e','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 ; subscribeforum
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; tachyforumpost
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 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
بالتوفيق للجميع وان شاء الله
عن قريب رح نزل شرح خاص بجداول قاعدة البيانات للجيل الثالث
التنسيق اخدلي وقت كثير بتمنى يفيدكم
تحياتي
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','groupmessa ge','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','usernam e','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 ; subscribeforum
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; tachyforumpost
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 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
بالتوفيق للجميع وان شاء الله
عن قريب رح نزل شرح خاص بجداول قاعدة البيانات للجيل الثالث
التنسيق اخدلي وقت كثير بتمنى يفيدكم
تحياتي