 إحصائية
العضو |
|
|
المنتدى :
احباب الحسين لتطوير منتديـــــvb4.0.0ــات
لزراعه الجداول المحذوفه في قاعدة البيانات للجيل الرابع Vb4
mailqueue
|
|
|
CREATE TABLE `mailqueue` (
`mailqueueid` int(10) unsigned NOT NULL auto_increment,
`dateline` int(10) unsigned NOT NULL default '0',
`toemail` medium****,
`fromemail` medium****,
`subject` medium****,
`message` medium****,
`header` medium****,
PRIMARY KEY (`mailqueueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
moderation
|
|
|
CREATE TABLE `moderation` (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessage','picturecomment') NOT NULL default 'thread',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
moderator
|
|
|
CREATE TABLE `moderator` (
`moderatorid` smallint(5) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(6) NOT NULL default '0',
`permissions` int(10) unsigned NOT NULL default '0',
`permissions2` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`moderatorid`),
UNIQUE KEY `userid_forumid` (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
moderatorlog
|
|
|
CREATE TABLE `moderatorlog` (
`moderatorlogid` int(10) unsigned NOT NULL auto_increment,
`dateline` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`attachmentid` int(10) unsigned NOT NULL default '0',
`action` varchar(250) NOT NULL default '',
`type` smallint(5) unsigned NOT NULL default '0',
`threadtitle` varchar(250) NOT NULL default '',
`ipaddress` char(15) NOT NULL default '',
`product` varchar(25) NOT NULL default '',
`id1` int(10) unsigned NOT NULL default '0',
`id2` int(10) unsigned NOT NULL default '0',
`id3` int(10) unsigned NOT NULL default '0',
`id4` int(10) unsigned NOT NULL default '0',
`id5` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`moderatorlogid`),
KEY `threadid` (`threadid`),
KEY `product` (`product`),
KEY `id1` (`id1`),
KEY `id2` (`id2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
notice
|
|
|
CREATE TABLE `notice` (
`noticeid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`displayorder` int(10) unsigned NOT NULL default '0',
`persistent` smallint(5) unsigned NOT NULL default '0',
`active` smallint(5) unsigned NOT NULL default '0',
`dismissible` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`noticeid`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
noticecriteria
|
|
|
CREATE TABLE `noticecriteria` (
`noticeid` int(10) unsigned NOT NULL default '0',
`criteriaid` varchar(250) NOT NULL default '',
`condition1` varchar(250) NOT NULL default '',
`condition2` varchar(250) NOT NULL default '',
`condition3` varchar(250) NOT NULL default '',
PRIMARY KEY (`noticeid`,`criteriaid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
noticedismissed
|
|
|
CREATE TABLE `noticedismissed` (
`noticeid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`noticeid`,`userid`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
package
|
|
|
CREATE TABLE `package` (
`packageid` int(10) unsigned NOT NULL auto_increment,
`productid` varchar(25) NOT NULL,
`class` varbinary(50) NOT NULL,
PRIMARY KEY (`packageid`),
UNIQUE KEY `class` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
passwordhistory
|
|
|
CREATE TABLE `passwordhistory` (
`userid` int(10) unsigned NOT NULL default '0',
`password` varchar(50) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
paymentapi
|
|
|
CREATE TABLE `paymentapi` (
`paymentapiid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`currency` varchar(250) NOT NULL default '',
`recurring` smallint(6) NOT NULL default '0',
`classname` varchar(250) NOT NULL default '',
`active` smallint(6) NOT NULL default '0',
`settings` medium****,
PRIMARY KEY (`paymentapiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
paymentinfo
|
|
|
CREATE TABLE `paymentinfo` (
`paymentinfoid` int(10) unsigned NOT NULL auto_increment,
`hash` varchar(32) NOT NULL default '',
`subscriptionid` smallint(5) unsigned NOT NULL default '0',
`subscriptionsubid` smallint(5) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`completed` smallint(6) NOT NULL default '0',
PRIMARY KEY (`paymentinfoid`),
KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
paymenttransaction
|
|
|
CREATE TABLE `paymenttransaction` (
`paymenttransactionid` int(10) unsigned NOT NULL auto_increment,
`paymentinfoid` int(10) unsigned NOT NULL default '0',
`transactionid` varchar(250) NOT NULL default '',
`state` smallint(5) unsigned NOT NULL default '0',
`amount` double unsigned NOT NULL default '0',
`currency` varchar(5) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`paymentapiid` int(10) unsigned NOT NULL default '0',
`request` medium****,
`reversed` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`paymenttransactionid`),
KEY `dateline` (`dateline`),
KEY `transactionid` (`transactionid`),
KEY `paymentapiid` (`paymentapiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
phrase
|
|
|
CREATE TABLE `phrase` (
`phraseid` int(10) unsigned NOT NULL auto_increment,
`languageid` smallint(6) NOT NULL default '0',
`varname` varchar(250) character set latin1 collate latin1_bin NOT NULL default '',
`fieldname` varchar(20) NOT NULL default '',
`****` medium****,
`product` varchar(25) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`version` varchar(30) NOT NULL default '',
PRIMARY KEY (`phraseid`),
UNIQUE KEY `name_lang_type` (`varname`,`languageid`,`fieldname`),
KEY `languageid` (`languageid`,`fieldname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
phrasetype
|
|
|
CREATE TABLE `phrasetype` (
`fieldname` char(20) NOT NULL default '',
`title` char(50) NOT NULL default '',
`editrows` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
`special` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`fieldname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
picturecomment
|
|
|
CREATE TABLE `picturecomment` (
`commentid` int(10) unsigned NOT NULL auto_increment,
`filedataid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`postuserid` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`state` enum('visible','moderation','deleted') NOT NULL default 'visible',
`title` varchar(255) NOT NULL default '',
`page****` medium****,
`ipaddress` int(10) unsigned NOT NULL default '0',
`allowsmilie` smallint(6) NOT NULL default '1',
`reportthreadid` int(10) unsigned NOT NULL default '0',
`messageread` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`commentid`),
KEY `filedataid` (`filedataid`,`userid`,`dateline`,`state`),
KEY `postuserid` (`postuserid`,`filedataid`,`userid`,`state`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
picturecomment_hash
|
|
|
CREATE TABLE `picturelegacy` (
`type` enum('album','group') NOT NULL default 'album',
`primaryid` int(10) unsigned NOT NULL default '0',
`pictureid` int(10) unsigned NOT NULL default '0',
`attachmentid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`type`,`primaryid`,`pictureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
plugin
|
|
|
CREATE TABLE `plugin` (
`pluginid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`hookname` varchar(250) NOT NULL default '',
`phpcode` ****,
`product` varchar(25) NOT NULL default '',
`devkey` varchar(25) NOT NULL default '',
`active` smallint(6) NOT NULL default '0',
`executionorder` smallint(5) unsigned NOT NULL default '5',
PRIMARY KEY (`pluginid`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
pm
|
|
|
CREATE TABLE `pm` (
`pmid` int(10) unsigned NOT NULL auto_increment,
`pm****id` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`folderid` smallint(6) NOT NULL default '0',
`messageread` smallint(5) unsigned NOT NULL default '0',
`parentpmid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pmid`),
KEY `pm****id` (`pm****id`),
KEY `userid` (`userid`,`folderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
pmreceipt
|
|
|
CREATE TABLE `pmreceipt` (
`pmid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`touserid` int(10) unsigned NOT NULL default '0',
`tousername` varchar(100) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`sendtime` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
`denied` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pmid`),
KEY `userid` (`userid`,`readtime`),
KEY `touserid` (`touserid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
pm****
|
|
|
CREATE TABLE `pm****` (
`pm****id` int(10) unsigned NOT NULL auto_increment,
`fromuserid` int(10) unsigned NOT NULL default '0',
`fromusername` varchar(100) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`message` medium****,
`touserarray` medium****,
`iconid` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`showsignature` smallint(5) unsigned NOT NULL default '0',
`allowsmilie` smallint(5) unsigned NOT NULL default '1',
`reportthreadid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pm****id`),
KEY `fromuserid` (`fromuserid`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
pmthrottle
|
|
|
CREATE TABLE `pmthrottle` (
`userid` int(10) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL,
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
podcast
|
|
|
CREATE TABLE `podcast` (
`forumid` int(10) unsigned NOT NULL default '0',
`author` varchar(255) NOT NULL default '',
`category` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`explicit` smallint(6) NOT NULL default '0',
`enabled` smallint(6) NOT NULL default '1',
`keywords` varchar(255) NOT NULL default '',
`owneremail` varchar(255) NOT NULL default '',
`ownername` varchar(255) NOT NULL default '',
`subtitle` varchar(255) NOT NULL default '',
`summary` medium****,
`categoryid` smallint(6) NOT NULL default '0',
PRIMARY KEY (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
podcastitem
|
|
|
CREATE TABLE `podcastitem` (
`postid` int(10) unsigned NOT NULL default '0',
`url` varchar(255) NOT NULL default '',
`length` int(10) unsigned NOT NULL default '0',
`explicit` smallint(5) unsigned NOT NULL default '0',
`keywords` varchar(255) NOT NULL default '',
`subtitle` varchar(255) NOT NULL default '',
`author` varchar(255) NOT NULL default '',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
poll
|
|
|
CREATE TABLE `poll` (
`pollid` int(10) unsigned NOT NULL auto_increment,
`question` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`options` ****,
`votes` ****,
`active` smallint(6) NOT NULL default '1',
`numberoptions` smallint(5) unsigned NOT NULL default '0',
`timeout` smallint(5) unsigned NOT NULL default '0',
`multiple` smallint(5) unsigned NOT NULL default '0',
`voters` smallint(5) unsigned NOT NULL default '0',
`public` smallint(6) NOT NULL default '0',
`lastvote` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pollid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
pollvote
|
|
|
CREATE TABLE `pollvote` (
`pollvoteid` int(10) unsigned NOT NULL auto_increment,
`pollid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned default NULL,
`votedate` int(10) unsigned NOT NULL default '0',
`voteoption` int(10) unsigned NOT NULL default '0',
`votetype` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pollvoteid`),
UNIQUE KEY `pollid` (`pollid`,`userid`,`votetype`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
post
|
|
|
CREATE TABLE `post` (
`postid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`parentid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`page****` medium****,
`allowsmilie` smallint(6) NOT NULL default '0',
`showsignature` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`visible` smallint(6) NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`infraction` smallint(5) unsigned NOT NULL default '0',
`reportthreadid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`),
KEY `userid` (`userid`),
KEY `threadid` (`threadid`,`userid`),
KEY `threadid_visible_dateline` (`threadid`,`visible`,`dateline`,`userid`,`postid`),
KEY `dateline` (`dateline`),
KEY `ipaddress` (`ipaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
postedithistory
|
|
|
CREATE TABLE `postedithistory` (
`postedithistoryid` int(10) unsigned NOT NULL auto_increment,
`postid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`iconid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`reason` varchar(200) NOT NULL default '',
`original` smallint(6) NOT NULL default '0',
`page****` medium****,
PRIMARY KEY (`postedithistoryid`),
KEY `postid` (`postid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
posthash
|
|
|
CREATE TABLE `posthash` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`dupehash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `userid` (`userid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
postlog
|
|
|
CREATE TABLE `postlog` (
`postid` int(10) unsigned NOT NULL default '0',
`useragent` char(100) NOT NULL default '',
`ip` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`),
KEY `dateline` (`dateline`),
KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
postparsed
|
|
|
CREATE TABLE `postparsed` (
`postid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`hasimages` smallint(6) NOT NULL default '0',
`page****_html` medium****,
PRIMARY KEY (`postid`,`styleid`,`languageid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
prefix
|
|
|
CREATE TABLE `prefix` (
`prefixid` varchar(25) NOT NULL default '',
`prefixsetid` varchar(25) NOT NULL default '',
`displayorder` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`prefixid`),
KEY `prefixsetid` (`prefixsetid`,`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
prefixpermission
|
|
|
CREATE TABLE `prefixpermission` (
`prefixid` varchar(25) NOT NULL default '',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
KEY `prefixsetid` (`prefixid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
prefixset
|
|
|
CREATE TABLE `prefixset` (
`prefixsetid` varchar(25) NOT NULL default '',
`displayorder` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`prefixsetid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
product
|
|
|
CREATE TABLE `product` (
`productid` varchar(25) NOT NULL default '',
`title` varchar(50) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`version` varchar(25) NOT NULL default '',
`active` smallint(5) unsigned NOT NULL default '1',
`url` varchar(250) NOT NULL default '',
`versioncheckurl` varchar(250) NOT NULL default '',
PRIMARY KEY (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
productcode
|
|
|
CREATE TABLE `productcode` (
`productcodeid` int(10) unsigned NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`version` varchar(25) NOT NULL default '',
`installcode` medium****,
`uninstallcode` medium****,
PRIMARY KEY (`productcodeid`),
KEY `productid` (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
productdependency
|
|
|
CREATE TABLE `productdependency` (
`productdependencyid` int(11) NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`dependencytype` varchar(25) NOT NULL default '',
`parentproductid` varchar(25) NOT NULL default '',
`minversion` varchar(50) NOT NULL default '',
`maxversion` varchar(50) NOT NULL default '',
PRIMARY KEY (`productdependencyid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
profileblockprivacy
|
|
|
CREATE TABLE `profileblockprivacy` (
`userid` int(10) unsigned NOT NULL,
`blockid` varchar(255) NOT NULL,
`requirement` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`blockid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
profilefield
|
|
|
CREATE TABLE `profilefield` (
`profilefieldid` smallint(5) unsigned NOT NULL auto_increment,
`profilefieldcategoryid` smallint(5) unsigned NOT NULL default '0',
`required` smallint(6) NOT NULL default '0',
`hidden` smallint(6) NOT NULL default '0',
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`displayorder` smallint(6) NOT NULL default '0',
`editable` smallint(6) NOT NULL default '1',
`type` enum('input','select','radio','****area','checkbox','select_multiple') NOT NULL default 'input',
`data` medium****,
`height` smallint(6) NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`searchable` smallint(6) NOT NULL default '0',
`memberlist` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`form` smallint(6) NOT NULL default '0',
`html` smallint(6) NOT NULL default '0',
`perline` smallint(6) NOT NULL default '0',
PRIMARY KEY (`profilefieldid`),
KEY `editable` (`editable`),
KEY `profilefieldcategoryid` (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
profilefieldcategory
|
|
|
CREATE TABLE `profilefieldcategory` (
`profilefieldcategoryid` smallint(5) unsigned NOT NULL auto_increment,
`displayorder` smallint(6) NOT NULL default '0',
`location` varchar(25) NOT NULL default '',
`allowprivacy` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
profilevisitor
|
|
|
CREATE TABLE `profilevisitor` (
`userid` int(10) unsigned NOT NULL default '0',
`visitorid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`visitorid`,`userid`),
KEY `userid` (`userid`,`visible`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
ranks
|
|
|
CREATE TABLE `ranks` (
`rankid` smallint(5) unsigned NOT NULL auto_increment,
`minposts` int(10) unsigned NOT NULL default '0',
`ranklevel` smallint(5) unsigned NOT NULL default '0',
`rankimg` medium****,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`stack` smallint(5) unsigned NOT NULL default '0',
`display` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`rankid`),
KEY `grouprank` (`usergroupid`,`minposts`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
reminder
|
|
|
CREATE TABLE `reminder` (
`reminderid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`****` medium****,
`duedate` int(10) unsigned NOT NULL default '0',
`adminonly` smallint(5) unsigned NOT NULL default '1',
`completedby` int(10) unsigned NOT NULL default '0',
`completedtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`reminderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
reputation
|
|
|
CREATE TABLE `reputation` (
`reputationid` int(10) unsigned NOT NULL auto_increment,
`postid` int(10) unsigned NOT NULL default '1',
`userid` int(10) unsigned NOT NULL default '1',
`reputation` int(11) NOT NULL default '0',
`whoadded` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`reputationid`),
UNIQUE KEY `whoadded_postid` (`whoadded`,`postid`),
KEY `userid` (`userid`),
KEY `multi` (`postid`,`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
reputationlevel
|
|
|
CREATE TABLE `reputationlevel` (
`reputationlevelid` int(10) unsigned NOT NULL auto_increment,
`minimumreputation` int(11) NOT NULL default '0',
PRIMARY KEY (`reputationlevelid`),
KEY `reputationlevel` (`minimumreputation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
|
|
|
CREATE TABLE `route` (
`routeid` int(10) unsigned NOT NULL auto_increment,
`userrequest` varchar(50) NOT NULL,
`packageid` int(10) unsigned NOT NULL,
`class` varbinary(50) NOT NULL,
PRIMARY KEY (`routeid`),
UNIQUE KEY `userrequest` (`userrequest`),
UNIQUE KEY `packageid` (`packageid`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
rssfeed
|
|
|
CREATE TABLE `rssfeed` (
`rssfeedid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`url` ****,
`port` smallint(5) unsigned NOT NULL default '80',
`ttl` smallint(5) unsigned NOT NULL default '1500',
`maxresults` smallint(6) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`prefixid` varchar(25) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`titletemplate` medium****,
`bodytemplate` medium****,
`searchwords` medium****,
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`threadactiondelay` smallint(5) unsigned NOT NULL default '0',
`endannouncement` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastrun` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`),
KEY `lastrun` (`lastrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
rsslog
|
|
|
CREATE TABLE `rsslog` (
`rssfeedid` int(10) unsigned NOT NULL default '0',
`itemid` int(10) unsigned NOT NULL default '0',
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`uniquehash` char(32) NOT NULL default '',
`contenthash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`threadactiontime` int(10) unsigned NOT NULL default '0',
`threadactioncomplete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`,`itemid`,`itemtype`),
UNIQUE KEY `uniquehash` (`uniquehash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
searchcore
|
|
|
CREATE TABLE `searchcore` (
`searchcoreid` int(10) unsigned NOT NULL auto_increment,
`contenttypeid` int(10) unsigned NOT NULL,
`primaryid` int(10) unsigned NOT NULL,
`groupcontenttypeid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL,
`ipaddress` int(10) unsigned NOT NULL,
`searchgroupid` int(10) unsigned NOT NULL,
PRIMARY KEY (`searchcoreid`),
UNIQUE KEY `contentunique` (`contenttypeid`,`primaryid`),
KEY `groupid` (`groupcontenttypeid`,`groupid`),
KEY `ipaddress` (`ipaddress`),
KEY `dateline` (`dateline`),
KEY `userid` (`userid`),
KEY `searchgroupid` (`searchgroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
searchcore_****
|
|
|
CREATE TABLE `searchcore_****` (
`searchcoreid` int(10) unsigned NOT NULL,
`keyword****` medium****,
`title` varchar(254) NOT NULL default '',
PRIMARY KEY (`searchcoreid`),
FULL**** KEY `****` (`title`,`keyword****`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
searchgroup
|
|
|
CREATE TABLE `searchgroup` (
`searchgroupid` int(10) unsigned NOT NULL auto_increment,
`contenttypeid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL,
PRIMARY KEY (`searchgroupid`),
UNIQUE KEY `groupunique` (`contenttypeid`,`groupid`),
KEY `dateline` (`dateline`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
searchgroup_****
|
|
|
CREATE TABLE `searchgroup_****` (
`searchgroupid` int(10) unsigned NOT NULL,
`title` varchar(254) NOT NULL,
PRIMARY KEY (`searchgroupid`),
FULL**** KEY `grouptitle` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
searchlog
|
|
|
CREATE TABLE `searchlog` (
`searchlogid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` varchar(15) NOT NULL default '',
`searchhash` varchar(32) NOT NULL,
`sortby` varchar(15) NOT NULL default '',
`sortorder` enum('asc','desc') NOT NULL default 'asc',
`searchtime` float unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '0',
`criteria` **** NOT NULL,
`results` mediumblob,
PRIMARY KEY (`searchlogid`),
KEY `search` (`userid`,`searchhash`,`sortby`,`sortorder`),
KEY `userfloodcheck` (`userid`,`dateline`),
KEY `ipfloodcheck` (`ipaddress`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
session
|
|
|
CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` char(15) NOT NULL default '',
`idhash` char(32) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`location` char(255) NOT NULL default '',
`useragent` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` smallint(5) unsigned NOT NULL default '0',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`bypass` tinyint(4) NOT NULL default '0',
`profileupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`),
KEY `user_activity` (`userid`,`lastactivity`),
KEY `guest_lookup` (`idhash`,`host`,`userid`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
|
setting
|
|
|
CREATE TABLE `setting` (
`varname` varchar(100) NOT NULL default '',
`grouptitle` varchar(50) NOT NULL default '',
`value` medium****,
`defaultvalue` medium****,
`optioncode` medium****,
`displayorder` smallint(5) unsigned NOT NULL default '0',
`advanced` smallint(6) NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`datatype` enum('free','number','boolean','bitfield','username','integer','posint') NOT NULL default 'free',
`product` varchar(25) NOT NULL default '',
`validationcode` ****,
`blacklist` smallint(6) NOT NULL default '0',
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
settinggroup
|
|
|
CREATE TABLE `settinggroup` (
`grouptitle` char(50) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`grouptitle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
sigparsed
|
|
|
CREATE TABLE `sigparsed` (
`userid` int(10) unsigned NOT NULL default '0',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`signatureparsed` medium****,
`hasimages` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`styleid`,`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
sigpic
|
|
|
CREATE TABLE `sigpic` (
`userid` int(10) unsigned NOT NULL default '0',
`filedata` mediumblob,
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`visible` smallint(6) NOT NULL default '1',
`filesize` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
smilie
|
|
|
CREATE TABLE `smilie` (
`smilieid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`smilie****` char(20) NOT NULL default '',
`smiliepath` char(100) NOT NULL default '',
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`smilieid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
socialgroup
|
|
|
CREATE TABLE `socialgroup` (
`groupid` int(10) unsigned NOT NULL auto_increment,
`socialgroupcategoryid` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL default '',
`description` ****,
`creatoruserid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`members` int(10) unsigned NOT NULL default '0',
`picturecount` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(255) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`lastgmid` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '0',
`deleted` int(10) unsigned NOT NULL default '0',
`moderation` int(10) unsigned NOT NULL default '0',
`type` enum('public','moderated','inviteonly') NOT NULL default 'public',
`moderatedmembers` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastdiscussionid` int(10) unsigned NOT NULL default '0',
`discussions` int(10) unsigned default '0',
`lastdiscussion` varchar(255) NOT NULL default '',
`lastupdate` int(10) unsigned NOT NULL default '0',
`transferowner` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`),
KEY `creatoruserid` (`creatoruserid`),
KEY `dateline` (`dateline`),
KEY `members` (`members`),
KEY `picturecount` (`picturecount`),
KEY `visible` (`visible`),
KEY `lastpost` (`lastpost`),
KEY `socialgroupcategoryid` (`socialgroupcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
socialgroupcategory
|
|
|
CREATE TABLE `socialgroupcategory` (
`socialgroupcategoryid` int(10) unsigned NOT NULL auto_increment,
`creatoruserid` int(10) unsigned NOT NULL,
`title` varchar(250) NOT NULL,
`description` **** NOT NULL,
`displayorder` int(10) unsigned NOT NULL,
`lastupdate` int(10) unsigned NOT NULL,
`groups` int(10) unsigned default '0',
PRIMARY KEY (`socialgroupcategoryid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
socialgroupicon
|
|
|
CREATE TABLE `socialgroupicon` (
`groupid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned default '0',
`filedata` mediumblob,
`extension` varchar(20) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`thumbnail_filedata` mediumblob,
`thumbnail_width` int(10) unsigned NOT NULL default '0',
`thumbnail_height` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
socialgroupmember
|
|
|
CREATE TABLE `socialgroupmember` (
`userid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`type` enum('member','moderated','invited') NOT NULL default 'member',
PRIMARY KEY (`groupid`,`userid`),
KEY `groupid` (`groupid`,`type`),
KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
spamlog
|
|
|
CREATE TABLE `spamlog` (
`postid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
stats
|
|
|
CREATE TABLE `stats` (
`dateline` int(10) unsigned NOT NULL default '0',
`nuser` mediumint(8) unsigned NOT NULL default '0',
`nthread` mediumint(8) unsigned NOT NULL default '0',
`npost` mediumint(8) unsigned NOT NULL default '0',
`ausers` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
strikes
|
|
|
CREATE TABLE `strikes` (
`striketime` int(10) unsigned NOT NULL default '0',
`strikeip` char(15) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
KEY `striketime` (`striketime`),
KEY `strikeip` (`strikeip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
style
|
|
|
CREATE TABLE `style` (
`styleid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`parentid` smallint(6) NOT NULL default '0',
`parentlist` varchar(250) NOT NULL default '',
`templatelist` medium****,
`csscolors` medium****,
`css` medium****,
`stylevars` medium****,
`newstylevars` medium****,
`replacements` medium****,
`editorstyles` medium****,
`userselect` smallint(5) unsigned NOT NULL default '1',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
stylevar
|
|
|
CREATE TABLE `stylevar` (
`stylevarid` varchar(250) NOT NULL,
`styleid` smallint(6) NOT NULL default '-1',
`value` mediumblob NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
UNIQUE KEY `stylevarinstance` (`stylevarid`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
stylevardfn
|
|
|
CREATE TABLE `stylevardfn` (
`stylevarid` varchar(250) NOT NULL,
`styleid` smallint(6) NOT NULL default '-1',
`parentid` smallint(6) NOT NULL,
`parentlist` varchar(250) NOT NULL default '0',
`stylevargroup` varchar(250) NOT NULL,
`product` varchar(25) NOT NULL default 'vbulletin',
`datatype` varchar(25) NOT NULL default 'string',
`validation` varchar(250) NOT NULL,
`failsafe` mediumblob NOT NULL,
`units` enum('','%','px','pt','em','ex','pc','in','cm','mm') NOT NULL default '',
`uneditable` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`stylevarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
subscribediscussion
|
|
|
CREATE TABLE `subscribediscussion` (
`subscribediscussionid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`),
KEY `discussionid` (`discussionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
subscribeevent
|
|
|
CREATE TABLE `subscribeevent` (
`subscribeeventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`lastreminder` int(10) unsigned NOT NULL default '0',
`reminder` int(10) unsigned NOT NULL default '3600',
PRIMARY KEY (`subscribeeventid`),
UNIQUE KEY `subindex` (`userid`,`eventid`),
KEY `eventid` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
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 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
بالتوفيق للجميع وان شاء الله
عن قريب رح نزل شرح خاص بجداول قاعدة البيانات للجيل الثالث
التنسيق اخدلي وقت كثير بتمنى يفيدكم
تحياتي
g.vhui hg[]h,g hglp`,ti td rhu]m hgfdhkhj gg[dg hgvhfu Vb4 g.vhui hglp`,ti hgfdhkhj hg[]h,g hgvhfu
|
|
|
23-02-2013, 08:16 PM
العرض العادي
