محب الرسول
23-02-2013, 08:20 PM
CREATE TABLE `prefix` (
`prefixid` varchar(25) NOT NULL default '',
`prefixsetid` varchar(25) NOT NULL default '',
`displayorder` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`prefixid`),
KEY `prefixsetid` (`prefixsetid`,`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; prefixpermission
CREATE TABLE `prefixpermission` (
`prefixid` varchar(25) NOT NULL default '',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
KEY `prefixsetid` (`prefixid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;prefixset
CREATE TABLE `prefixset` (
`prefixsetid` varchar(25) NOT NULL default '',
`displayorder` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`prefixsetid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; product
CREATE TABLE `product` (
`productid` varchar(25) NOT NULL default '',
`title` varchar(50) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`version` varchar(25) NOT NULL default '',
`active` smallint(5) unsigned NOT NULL default '1',
`url` varchar(250) NOT NULL default '',
`versioncheckurl` varchar(250) NOT NULL default '',
PRIMARY KEY (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; productcode
CREATE TABLE `productcode` (
`productcodeid` int(10) unsigned NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`version` varchar(25) NOT NULL default '',
`installcode` medium****,
`uninstallcode` medium****,
PRIMARY KEY (`productcodeid`),
KEY `productid` (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; productdependency
CREATE TABLE `productdependency` (
`productdependencyid` int(11) NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`dependencytype` varchar(25) NOT NULL default '',
`parentproductid` varchar(25) NOT NULL default '',
`minversion` varchar(50) NOT NULL default '',
`maxversion` varchar(50) NOT NULL default '',
PRIMARY KEY (`productdependencyid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; profileblockprivacy
CREATE TABLE `profileblockprivacy` (
`userid` int(10) unsigned NOT NULL,
`blockid` varchar(255) NOT NULL,
`requirement` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`blockid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; profilefield
CREATE TABLE `profilefield` (
`profilefieldid` smallint(5) unsigned NOT NULL auto_increment,
`profilefieldcategoryid` smallint(5) unsigned NOT NULL default '0',
`required` smallint(6) NOT NULL default '0',
`hidden` smallint(6) NOT NULL default '0',
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`displayorder` smallint(6) NOT NULL default '0',
`editable` smallint(6) NOT NULL default '1',
`type` enum('input','select','radio','****area','checkbox ','select_multiple') NOT NULL default 'input',
`data` medium****,
`height` smallint(6) NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`searchable` smallint(6) NOT NULL default '0',
`memberlist` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`form` smallint(6) NOT NULL default '0',
`html` smallint(6) NOT NULL default '0',
`perline` smallint(6) NOT NULL default '0',
PRIMARY KEY (`profilefieldid`),
KEY `editable` (`editable`),
KEY `profilefieldcategoryid` (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; profilefieldcategory
CREATE TABLE `profilefieldcategory` (
`profilefieldcategoryid` smallint(5) unsigned NOT NULL auto_increment,
`displayorder` smallint(6) NOT NULL default '0',
`location` varchar(25) NOT NULL default '',
`allowprivacy` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; profilevisitor
CREATE TABLE `profilevisitor` (
`userid` int(10) unsigned NOT NULL default '0',
`visitorid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`visitorid`,`userid`),
KEY `userid` (`userid`,`visible`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; ranks
CREATE TABLE `ranks` (
`rankid` smallint(5) unsigned NOT NULL auto_increment,
`minposts` int(10) unsigned NOT NULL default '0',
`ranklevel` smallint(5) unsigned NOT NULL default '0',
`rankimg` medium****,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`stack` smallint(5) unsigned NOT NULL default '0',
`display` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`rankid`),
KEY `grouprank` (`usergroupid`,`minposts`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; reminder
CREATE TABLE `reminder` (
`reminderid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`****` medium****,
`duedate` int(10) unsigned NOT NULL default '0',
`adminonly` smallint(5) unsigned NOT NULL default '1',
`completedby` int(10) unsigned NOT NULL default '0',
`completedtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`reminderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;reputation
CREATE TABLE `reputation` (
`reputationid` int(10) unsigned NOT NULL auto_increment,
`postid` int(10) unsigned NOT NULL default '1',
`userid` int(10) unsigned NOT NULL default '1',
`reputation` int(11) NOT NULL default '0',
`whoadded` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`reputationid`),
KEY `userid` (`userid`),
KEY `whoadded_postid` (`whoadded`,`postid`),
KEY `multi` (`postid`,`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; reputationlevel
CREATE TABLE `reputationlevel` (
`reputationlevelid` int(10) unsigned NOT NULL auto_increment,
`minimumreputation` int(11) NOT NULL default '0',
PRIMARY KEY (`reputationlevelid`),
KEY `reputationlevel` (`minimumreputation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; rssfeed
CREATE TABLE `rssfeed` (
`rssfeedid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`url` ****,
`port` smallint(5) unsigned NOT NULL default '80',
`ttl` smallint(5) unsigned NOT NULL default '1500',
`maxresults` smallint(6) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`prefixid` varchar(25) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`titletemplate` medium****,
`bodytemplate` medium****,
`searchwords` medium****,
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`threadactiondelay` smallint(5) unsigned NOT NULL default '0',
`endannouncement` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastrun` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`),
KEY `lastrun` (`lastrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; rsslog
CREATE TABLE `rsslog` (
`rssfeedid` int(10) unsigned NOT NULL default '0',
`itemid` int(10) unsigned NOT NULL default '0',
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`uniquehash` char(32) NOT NULL default '',
`contenthash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`threadactiontime` int(10) unsigned NOT NULL default '0',
`threadactioncomplete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`,`itemid`,`itemtype`),
UNIQUE KEY `uniquehash` (`uniquehash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; search
CREATE TABLE `search` (
`searchid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
`personal` smallint(5) unsigned NOT NULL default '0',
`query` varchar(200) NOT NULL default '',
`searchuser` varchar(200) NOT NULL default '',
`forumchoice` medium****,
`prefixchoice` medium****,
`sortby` varchar(200) NOT NULL default '',
`sortorder` varchar(4) NOT NULL default '',
`searchtime` float NOT NULL default '0',
`showposts` smallint(5) unsigned NOT NULL default '0',
`orderedids` medium****,
`announceids` medium****,
`dateline` int(10) unsigned NOT NULL default '0',
`searchterms` medium****,
`displayterms` medium****,
`searchhash` varchar(32) NOT NULL default '',
`titleonly` smallint(5) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`searchid`),
UNIQUE KEY `searchunique` (`searchhash`,`sortby`,`sortorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; session
CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` char(15) NOT NULL default '',
`idhash` char(32) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`location` char(255) NOT NULL default '',
`useragent` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` smallint(5) unsigned NOT NULL default '0',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`bypass` tinyint(4) NOT NULL default '0',
`profileupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1; setting
CREATE TABLE `setting` (
`varname` varchar(100) NOT NULL default '',
`grouptitle` varchar(50) NOT NULL default '',
`value` medium****,
`defaultvalue` medium****,
`optioncode` medium****,
`displayorder` smallint(5) unsigned NOT NULL default '0',
`advanced` smallint(6) NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`datatype` enum('free','number','boolean','bitfield','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`),
FULL**** KEY `name` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; socialgroupcategory
CREATE TABLE `socialgroupcategory` (
`socialgroupcategoryid` int(10) unsigned NOT NULL auto_increment,
`creatoruserid` int(10) unsigned NOT NULL,
`title` varchar(250) NOT NULL,
`description` **** NOT NULL,
`displayorder` int(10) unsigned NOT NULL,
`lastupdate` int(10) unsigned NOT NULL,
`groups` int(10) unsigned default '0',
PRIMARY KEY (`socialgroupcategoryid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; socialgroupicon
CREATE TABLE `socialgroupicon` (
`groupid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned default '0',
`filedata` mediumblob,
`extension` varchar(20) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`thumbnail_filedata` mediumblob,
`thumbnail_width` int(10) unsigned NOT NULL default '0',
`thumbnail_height` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; socialgroupmember
CREATE TABLE `socialgroupmember` (
`userid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`type` enum('member','moderated','invited') NOT NULL default 'member',
PRIMARY KEY (`groupid`,`userid`),
KEY `groupid` (`groupid`,`type`),
KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; socialgrouppicture
CREATE TABLE `socialgrouppicture` (
`groupid` int(10) unsigned NOT NULL default '0',
`pictureid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`,`pictureid`),
KEY `groupid` (`groupid`,`dateline`),
KEY `pictureid` (`pictureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; spamlog
CREATE TABLE `spamlog` (
`postid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; stats
CREATE TABLE `stats` (
`dateline` int(10) unsigned NOT NULL default '0',
`nuser` mediumint(8) unsigned NOT NULL default '0',
`nthread` mediumint(8) unsigned NOT NULL default '0',
`npost` mediumint(8) unsigned NOT NULL default '0',
`ausers` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; strikes
CREATE TABLE `strikes` (
`striketime` int(10) unsigned NOT NULL default '0',
`strikeip` char(15) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
KEY `striketime` (`striketime`),
KEY `strikeip` (`strikeip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; style
CREATE TABLE `style` (
`styleid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`parentid` smallint(6) NOT NULL default '0',
`parentlist` varchar(250) NOT NULL default '',
`templatelist` medium****,
`csscolors` medium****,
`css` medium****,
`stylevars` medium****,
`replacements` medium****,
`editorstyles` medium****,
`userselect` smallint(5) unsigned NOT NULL default '1',
`displayorder` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; subscribediscussion
CREATE TABLE `subscribediscussion` (
`subscribediscussionid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`),
KEY `discussionid` (`discussionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; subscribeevent
CREATE TABLE `subscribeevent` (
`subscribeeventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`lastreminder` int(10) unsigned NOT NULL default '0',
`reminder` int(10) unsigned NOT NULL default '3600',
PRIMARY KEY (`subscribeeventid`),
UNIQUE KEY `subindex` (`userid`,`eventid`),
KEY `eventid` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 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 `subscriptionpermission` (
`subscriptionpermissionid` int(10) unsigned NOT NULL auto_increment,
`subscriptionid` int(10) unsigned NOT NULL default '0',
`usergroupid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionpermissionid`),
UNIQUE KEY `subscriptionid` (`subscriptionid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; tachyforumcounter
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 '',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastthread` varchar(250) NOT NULL default '',
`lastthreadid` int(10) unsigned NOT NULL default '0',
`lasticonid` smallint(5) unsigned NOT NULL default '0',
`lastprefixid` varchar(25) NOT NULL default '',
PRIMARY KEY (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tachythreadcounter
CREATE TABLE `tachythreadcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tachythreadpost
CREATE TABLE `tachythreadpost` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastpostid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tag
CREATE TABLE `tag` (
`tagid` int(10) unsigned NOT NULL auto_increment,
`tag****` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`),
UNIQUE KEY `tag****` (`tag****`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; tagsearch
CREATE TABLE `tagsearch` (
`tagid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `tagid` (`tagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tagthread
CREATE TABLE `tagthread` (
`tagid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`,`threadid`),
KEY `threadid` (`threadid`,`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; template
CREATE TABLE `template` (
`templateid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(6) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` medium****,
`template_un` medium****,
`templatetype` enum('template','stylevar','css','replacement') NOT NULL default 'template',
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`templateid`),
UNIQUE KEY `title` (`title`,`styleid`,`templatetype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; templatehistory
CREATE TABLE `templatehistory` (
`templatehistoryid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` medium****,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`templatehistoryid`),
KEY `title` (`title`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; thread
CREATE TABLE `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`prefixid` varchar(25) NOT NULL default '',
`firstpostid` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`hiddencount` int(10) unsigned NOT NULL default '0',
`deletedcount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
`taglist` medium****,
`vbseo_linkbacks_no` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
KEY `lastpost` (`lastpost`,`forumid`),
KEY `dateline` (`dateline`),
KEY `prefixid` (`prefixid`,`forumid`),
FULL**** KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; threadrate
CREATE TABLE `threadrate` (
`threadrateid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`threadrateid`),
KEY `threadid` (`threadid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; threadread
CREATE TABLE `threadread` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; threadredirect
CREATE TABLE `threadredirect` (
`threadid` int(10) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; threadviews
CREATE TABLE `threadviews` (
`threadid` int(10) unsigned NOT NULL default '0',
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; upgradelog
CREATE TABLE `upgradelog` (
`upgradelogid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`steptitle` varchar(250) NOT NULL default '',
`step` smallint(5) unsigned NOT NULL default '0',
`startat` int(10) unsigned NOT NULL default '0',
`perpage` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`upgradelogid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; user
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` char(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` char(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` char(50) NOT NULL default '',
`homepage` char(100) NOT NULL default '',
`icq` char(20) NOT NULL default '',
`aim` char(20) NOT NULL default '',
`yahoo` char(32) NOT NULL default '',
`msn` char(100) NOT NULL default '',
`skype` char(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`usertitle` char(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` char(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '33554447',
`birthday` char(10) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` char(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(3) NOT NULL default '',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
`adminoptions` int(10) unsigned NOT NULL default '0',
`profilevisits` int(10) unsigned NOT NULL default '0',
`friendcount` int(10) unsigned NOT NULL default '0',
`friendreqcount` int(10) unsigned NOT NULL default '0',
`vmunreadcount` int(10) unsigned NOT NULL default '0',
`vmmoderatedcount` int(10) unsigned NOT NULL default '0',
`socgroupinvitecount` int(10) unsigned NOT NULL default '0',
`socgroupreqcount` int(10) unsigned NOT NULL default '0',
`pcunreadcount` int(10) unsigned NOT NULL default '0',
`pcmoderatedcount` int(10) unsigned NOT NULL default '0',
`gmmoderatedcount` int(10) unsigned NOT NULL default '0',
`mwaextraadmin3_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') default NULL,
`mwaextraadmin3_imageresizer_maxwidth` smallint(5) unsigned default NULL,
`mwaextraadmin3_imageresizer_maxheight` smallint(5) unsigned default NULL,
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `lastactivity` (`lastactivity`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; useractivation
CREATE TABLE `useractivation` (
`useractivationid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`activationid` varchar(40) NOT NULL default '',
`type` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`emailchange` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`useractivationid`),
UNIQUE KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
userban
CREATE TABLE `userban` (
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`adminid` int(10) unsigned NOT NULL default '0',
`bandate` int(10) unsigned NOT NULL default '0',
`liftdate` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `liftdate` (`liftdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; userchangelog
CREATE TABLE `userchangelog` (
`changeid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`fieldname` varchar(250) NOT NULL default '',
`newvalue` varchar(250) NOT NULL default '',
`oldvalue` varchar(250) NOT NULL default '',
`adminid` int(10) unsigned NOT NULL default '0',
`change_time` int(10) unsigned NOT NULL default '0',
`change_uniq` varchar(32) NOT NULL default '',
PRIMARY KEY (`changeid`),
KEY `userid` (`userid`,`change_time`),
KEY `change_time` (`change_time`),
KEY `change_uniq` (`change_uniq`),
KEY `fieldname` (`fieldname`,`change_time`),
KEY `adminid` (`adminid`,`change_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; usercss
CREATE TABLE `usercss` (
`userid` int(10) unsigned NOT NULL default '0',
`selector` varchar(30) NOT NULL default '',
`property` varchar(30) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`userid`,`selector`,`property`),
KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usercsscache
CREATE TABLE `usercsscache` (
`userid` int(10) unsigned NOT NULL default '0',
`cachedcss` ****,
`buildpermissions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; userfield
CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`temp` medium****,
`field1` medium****,
`field2` medium****,
`field3` medium****,
`field4` medium****,
`field631` medium**** NOT NULL,
`field632` medium**** NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usergroup
CREATE TABLE `usergroup` (
`usergroupid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`usertitle` char(100) NOT NULL default '',
`passwordexpires` smallint(5) unsigned NOT NULL default '0',
`passwordhistory` smallint(5) unsigned NOT NULL default '0',
`pmquota` smallint(5) unsigned NOT NULL default '0',
`pmsendmax` smallint(5) unsigned NOT NULL default '5',
`opentag` ****,
`closetag` ****,
`canoverride` smallint(5) unsigned NOT NULL default '0',
`ispublicgroup` smallint(5) unsigned NOT NULL default '0',
`forumpermissions` int(10) unsigned NOT NULL default '0',
`pmpermissions` int(10) unsigned NOT NULL default '0',
`calendarpermissions` int(10) unsigned NOT NULL default '0',
`wolpermissions` int(10) unsigned NOT NULL default '0',
`adminpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions2` int(10) unsigned NOT NULL default '0',
`genericoptions` int(10) unsigned NOT NULL default '0',
`signaturepermissions` int(10) unsigned NOT NULL default '0',
`visitormessagepermissions` int(10) unsigned NOT NULL default '0',
`attachlimit` int(10) unsigned NOT NULL default '0',
`avatarmaxwidth` smallint(5) unsigned NOT NULL default '0',
`avatarmaxheight` smallint(5) unsigned NOT NULL default '0',
`avatarmaxsize` int(10) unsigned NOT NULL default '0',
`profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxheight` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxsize` int(10) unsigned NOT NULL default '0',
`sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxsize` int(10) unsigned NOT NULL default '0',
`sigmaximages` smallint(5) unsigned NOT NULL default '0',
`sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0',
`sigmaxchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxrawchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxlines` smallint(5) unsigned NOT NULL default '0',
`usercsspermissions` int(10) unsigned NOT NULL default '0',
`albumpermissions` int(10) unsigned NOT NULL default '0',
`albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxsize` int(10) unsigned NOT NULL default '0',
`albummaxpics` int(10) unsigned NOT NULL default '0',
`albummaxsize` int(10) unsigned NOT NULL default '0',
`socialgrouppermissions` int(10) unsigned NOT NULL default '0',
`pmthrottlequantity` int(10) unsigned NOT NULL default '0',
`groupiconmaxsize` int(10) unsigned NOT NULL default '0',
`maximumsocialgroups` int(10) unsigned NOT NULL default '0',
`maxnewthread` int(10) unsigned NOT NULL default '0',
`maxnewtime` int(11) NOT NULL default '0',
`maxnewpost` int(11) NOT NULL default '0',
`maxnewposttime` int(11) NOT NULL default '0',
PRIMARY KEY (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; usergroupleader
CREATE TABLE `usergroupleader` (
`usergroupleaderid` smallint(5) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`usergroupleaderid`),
KEY `ugl` (`userid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; usergrouprequest
CREATE TABLE `usergrouprequest` (
`usergrouprequestid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`reason` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`usergrouprequestid`),
UNIQUE KEY `userid` (`userid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; userlist
CREATE TABLE `userlist` (
`userid` int(10) unsigned NOT NULL default '0',
`relationid` int(10) unsigned NOT NULL default '0',
`type` enum('buddy','ignore') NOT NULL default 'buddy',
`friend` enum('yes','no','pending','denied') NOT NULL default 'no',
PRIMARY KEY (`userid`,`relationid`,`type`),
KEY `relationid` (`relationid`,`type`,`friend`),
KEY `userid` (`userid`,`type`,`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usernote
CREATE TABLE `usernote` (
`usernoteid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`posterid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`message` medium****,
`title` varchar(255) NOT NULL default '',
`allowsmilies` smallint(6) NOT NULL default '0',
PRIMARY KEY (`usernoteid`),
KEY `userid` (`userid`),
KEY `posterid` (`posterid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; userpromotion
CREATE TABLE `userpromotion` (
`userpromotionid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` int(10) unsigned NOT NULL default '0',
`joinusergroupid` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`strategy` smallint(6) NOT NULL default '0',
`type` smallint(6) NOT NULL default '2',
PRIMARY KEY (`userpromotionid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; user****field
CREATE TABLE `user****field` (
`userid` int(10) unsigned NOT NULL default '0',
`subfolders` medium****,
`pmfolders` medium****,
`buddylist` medium****,
`ignorelist` medium****,
`signature` medium****,
`searchprefs` medium****,
`rank` medium****,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usertitle
CREATE TABLE `usertitle` (
`usertitleid` smallint(5) unsigned NOT NULL auto_increment,
`minposts` int(10) unsigned NOT NULL default '0',
`title` char(250) NOT NULL default '',
PRIMARY KEY (`usertitleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; visitormessage
CREATE TABLE `visitormessage` (
`vmid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`postuserid` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`state` enum('visible','moderation','deleted') NOT NULL default 'visible',
`title` varchar(255) NOT NULL default '',
`page****` medium****,
`ipaddress` int(10) unsigned NOT NULL default '0',
`allowsmilie` smallint(5) unsigned NOT NULL default '0',
`reportthreadid` int(10) unsigned NOT NULL default '0',
`messageread` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`vmid`),
KEY `postuserid` (`postuserid`,`userid`,`state`),
KEY `userid` (`userid`,`dateline`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; visitormessage_hash
CREATE TABLE `visitormessage_hash` (
`postuserid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dupehash` varchar(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `postuserid` (`postuserid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; word
CREATE TABLE `word` (
`wordid` int(10) unsigned NOT NULL auto_increment,
`title` char(50) NOT NULL default '',
PRIMARY KEY (`wordid`),
UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ملاحظة:
يوجد في آخر كل أمر الترميز latin1 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
بالتوفيق للجميع
`prefixid` varchar(25) NOT NULL default '',
`prefixsetid` varchar(25) NOT NULL default '',
`displayorder` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`prefixid`),
KEY `prefixsetid` (`prefixsetid`,`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; prefixpermission
CREATE TABLE `prefixpermission` (
`prefixid` varchar(25) NOT NULL default '',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
KEY `prefixsetid` (`prefixid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;prefixset
CREATE TABLE `prefixset` (
`prefixsetid` varchar(25) NOT NULL default '',
`displayorder` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`prefixsetid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; product
CREATE TABLE `product` (
`productid` varchar(25) NOT NULL default '',
`title` varchar(50) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`version` varchar(25) NOT NULL default '',
`active` smallint(5) unsigned NOT NULL default '1',
`url` varchar(250) NOT NULL default '',
`versioncheckurl` varchar(250) NOT NULL default '',
PRIMARY KEY (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; productcode
CREATE TABLE `productcode` (
`productcodeid` int(10) unsigned NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`version` varchar(25) NOT NULL default '',
`installcode` medium****,
`uninstallcode` medium****,
PRIMARY KEY (`productcodeid`),
KEY `productid` (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; productdependency
CREATE TABLE `productdependency` (
`productdependencyid` int(11) NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`dependencytype` varchar(25) NOT NULL default '',
`parentproductid` varchar(25) NOT NULL default '',
`minversion` varchar(50) NOT NULL default '',
`maxversion` varchar(50) NOT NULL default '',
PRIMARY KEY (`productdependencyid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; profileblockprivacy
CREATE TABLE `profileblockprivacy` (
`userid` int(10) unsigned NOT NULL,
`blockid` varchar(255) NOT NULL,
`requirement` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`blockid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; profilefield
CREATE TABLE `profilefield` (
`profilefieldid` smallint(5) unsigned NOT NULL auto_increment,
`profilefieldcategoryid` smallint(5) unsigned NOT NULL default '0',
`required` smallint(6) NOT NULL default '0',
`hidden` smallint(6) NOT NULL default '0',
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`displayorder` smallint(6) NOT NULL default '0',
`editable` smallint(6) NOT NULL default '1',
`type` enum('input','select','radio','****area','checkbox ','select_multiple') NOT NULL default 'input',
`data` medium****,
`height` smallint(6) NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`searchable` smallint(6) NOT NULL default '0',
`memberlist` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`form` smallint(6) NOT NULL default '0',
`html` smallint(6) NOT NULL default '0',
`perline` smallint(6) NOT NULL default '0',
PRIMARY KEY (`profilefieldid`),
KEY `editable` (`editable`),
KEY `profilefieldcategoryid` (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; profilefieldcategory
CREATE TABLE `profilefieldcategory` (
`profilefieldcategoryid` smallint(5) unsigned NOT NULL auto_increment,
`displayorder` smallint(6) NOT NULL default '0',
`location` varchar(25) NOT NULL default '',
`allowprivacy` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; profilevisitor
CREATE TABLE `profilevisitor` (
`userid` int(10) unsigned NOT NULL default '0',
`visitorid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`visitorid`,`userid`),
KEY `userid` (`userid`,`visible`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; ranks
CREATE TABLE `ranks` (
`rankid` smallint(5) unsigned NOT NULL auto_increment,
`minposts` int(10) unsigned NOT NULL default '0',
`ranklevel` smallint(5) unsigned NOT NULL default '0',
`rankimg` medium****,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`stack` smallint(5) unsigned NOT NULL default '0',
`display` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`rankid`),
KEY `grouprank` (`usergroupid`,`minposts`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; reminder
CREATE TABLE `reminder` (
`reminderid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`****` medium****,
`duedate` int(10) unsigned NOT NULL default '0',
`adminonly` smallint(5) unsigned NOT NULL default '1',
`completedby` int(10) unsigned NOT NULL default '0',
`completedtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`reminderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;reputation
CREATE TABLE `reputation` (
`reputationid` int(10) unsigned NOT NULL auto_increment,
`postid` int(10) unsigned NOT NULL default '1',
`userid` int(10) unsigned NOT NULL default '1',
`reputation` int(11) NOT NULL default '0',
`whoadded` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`reputationid`),
KEY `userid` (`userid`),
KEY `whoadded_postid` (`whoadded`,`postid`),
KEY `multi` (`postid`,`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; reputationlevel
CREATE TABLE `reputationlevel` (
`reputationlevelid` int(10) unsigned NOT NULL auto_increment,
`minimumreputation` int(11) NOT NULL default '0',
PRIMARY KEY (`reputationlevelid`),
KEY `reputationlevel` (`minimumreputation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; rssfeed
CREATE TABLE `rssfeed` (
`rssfeedid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`url` ****,
`port` smallint(5) unsigned NOT NULL default '80',
`ttl` smallint(5) unsigned NOT NULL default '1500',
`maxresults` smallint(6) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`prefixid` varchar(25) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`titletemplate` medium****,
`bodytemplate` medium****,
`searchwords` medium****,
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`threadactiondelay` smallint(5) unsigned NOT NULL default '0',
`endannouncement` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastrun` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`),
KEY `lastrun` (`lastrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; rsslog
CREATE TABLE `rsslog` (
`rssfeedid` int(10) unsigned NOT NULL default '0',
`itemid` int(10) unsigned NOT NULL default '0',
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`uniquehash` char(32) NOT NULL default '',
`contenthash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`threadactiontime` int(10) unsigned NOT NULL default '0',
`threadactioncomplete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`,`itemid`,`itemtype`),
UNIQUE KEY `uniquehash` (`uniquehash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; search
CREATE TABLE `search` (
`searchid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
`personal` smallint(5) unsigned NOT NULL default '0',
`query` varchar(200) NOT NULL default '',
`searchuser` varchar(200) NOT NULL default '',
`forumchoice` medium****,
`prefixchoice` medium****,
`sortby` varchar(200) NOT NULL default '',
`sortorder` varchar(4) NOT NULL default '',
`searchtime` float NOT NULL default '0',
`showposts` smallint(5) unsigned NOT NULL default '0',
`orderedids` medium****,
`announceids` medium****,
`dateline` int(10) unsigned NOT NULL default '0',
`searchterms` medium****,
`displayterms` medium****,
`searchhash` varchar(32) NOT NULL default '',
`titleonly` smallint(5) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`searchid`),
UNIQUE KEY `searchunique` (`searchhash`,`sortby`,`sortorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; session
CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` char(15) NOT NULL default '',
`idhash` char(32) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`location` char(255) NOT NULL default '',
`useragent` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` smallint(5) unsigned NOT NULL default '0',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`bypass` tinyint(4) NOT NULL default '0',
`profileupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1; setting
CREATE TABLE `setting` (
`varname` varchar(100) NOT NULL default '',
`grouptitle` varchar(50) NOT NULL default '',
`value` medium****,
`defaultvalue` medium****,
`optioncode` medium****,
`displayorder` smallint(5) unsigned NOT NULL default '0',
`advanced` smallint(6) NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`datatype` enum('free','number','boolean','bitfield','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`),
FULL**** KEY `name` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; socialgroupcategory
CREATE TABLE `socialgroupcategory` (
`socialgroupcategoryid` int(10) unsigned NOT NULL auto_increment,
`creatoruserid` int(10) unsigned NOT NULL,
`title` varchar(250) NOT NULL,
`description` **** NOT NULL,
`displayorder` int(10) unsigned NOT NULL,
`lastupdate` int(10) unsigned NOT NULL,
`groups` int(10) unsigned default '0',
PRIMARY KEY (`socialgroupcategoryid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; socialgroupicon
CREATE TABLE `socialgroupicon` (
`groupid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned default '0',
`filedata` mediumblob,
`extension` varchar(20) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`thumbnail_filedata` mediumblob,
`thumbnail_width` int(10) unsigned NOT NULL default '0',
`thumbnail_height` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; socialgroupmember
CREATE TABLE `socialgroupmember` (
`userid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`type` enum('member','moderated','invited') NOT NULL default 'member',
PRIMARY KEY (`groupid`,`userid`),
KEY `groupid` (`groupid`,`type`),
KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; socialgrouppicture
CREATE TABLE `socialgrouppicture` (
`groupid` int(10) unsigned NOT NULL default '0',
`pictureid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`,`pictureid`),
KEY `groupid` (`groupid`,`dateline`),
KEY `pictureid` (`pictureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; spamlog
CREATE TABLE `spamlog` (
`postid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; stats
CREATE TABLE `stats` (
`dateline` int(10) unsigned NOT NULL default '0',
`nuser` mediumint(8) unsigned NOT NULL default '0',
`nthread` mediumint(8) unsigned NOT NULL default '0',
`npost` mediumint(8) unsigned NOT NULL default '0',
`ausers` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; strikes
CREATE TABLE `strikes` (
`striketime` int(10) unsigned NOT NULL default '0',
`strikeip` char(15) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
KEY `striketime` (`striketime`),
KEY `strikeip` (`strikeip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; style
CREATE TABLE `style` (
`styleid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`parentid` smallint(6) NOT NULL default '0',
`parentlist` varchar(250) NOT NULL default '',
`templatelist` medium****,
`csscolors` medium****,
`css` medium****,
`stylevars` medium****,
`replacements` medium****,
`editorstyles` medium****,
`userselect` smallint(5) unsigned NOT NULL default '1',
`displayorder` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; subscribediscussion
CREATE TABLE `subscribediscussion` (
`subscribediscussionid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`),
KEY `discussionid` (`discussionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; subscribeevent
CREATE TABLE `subscribeevent` (
`subscribeeventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`lastreminder` int(10) unsigned NOT NULL default '0',
`reminder` int(10) unsigned NOT NULL default '3600',
PRIMARY KEY (`subscribeeventid`),
UNIQUE KEY `subindex` (`userid`,`eventid`),
KEY `eventid` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 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 `subscriptionpermission` (
`subscriptionpermissionid` int(10) unsigned NOT NULL auto_increment,
`subscriptionid` int(10) unsigned NOT NULL default '0',
`usergroupid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionpermissionid`),
UNIQUE KEY `subscriptionid` (`subscriptionid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; tachyforumcounter
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 '',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastthread` varchar(250) NOT NULL default '',
`lastthreadid` int(10) unsigned NOT NULL default '0',
`lasticonid` smallint(5) unsigned NOT NULL default '0',
`lastprefixid` varchar(25) NOT NULL default '',
PRIMARY KEY (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tachythreadcounter
CREATE TABLE `tachythreadcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tachythreadpost
CREATE TABLE `tachythreadpost` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastpostid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tag
CREATE TABLE `tag` (
`tagid` int(10) unsigned NOT NULL auto_increment,
`tag****` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`),
UNIQUE KEY `tag****` (`tag****`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; tagsearch
CREATE TABLE `tagsearch` (
`tagid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `tagid` (`tagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; tagthread
CREATE TABLE `tagthread` (
`tagid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`,`threadid`),
KEY `threadid` (`threadid`,`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; template
CREATE TABLE `template` (
`templateid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(6) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` medium****,
`template_un` medium****,
`templatetype` enum('template','stylevar','css','replacement') NOT NULL default 'template',
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`templateid`),
UNIQUE KEY `title` (`title`,`styleid`,`templatetype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; templatehistory
CREATE TABLE `templatehistory` (
`templatehistoryid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` medium****,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`templatehistoryid`),
KEY `title` (`title`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; thread
CREATE TABLE `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`prefixid` varchar(25) NOT NULL default '',
`firstpostid` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`hiddencount` int(10) unsigned NOT NULL default '0',
`deletedcount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
`taglist` medium****,
`vbseo_linkbacks_no` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
KEY `lastpost` (`lastpost`,`forumid`),
KEY `dateline` (`dateline`),
KEY `prefixid` (`prefixid`,`forumid`),
FULL**** KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; threadrate
CREATE TABLE `threadrate` (
`threadrateid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`threadrateid`),
KEY `threadid` (`threadid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; threadread
CREATE TABLE `threadread` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; threadredirect
CREATE TABLE `threadredirect` (
`threadid` int(10) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; threadviews
CREATE TABLE `threadviews` (
`threadid` int(10) unsigned NOT NULL default '0',
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; upgradelog
CREATE TABLE `upgradelog` (
`upgradelogid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`steptitle` varchar(250) NOT NULL default '',
`step` smallint(5) unsigned NOT NULL default '0',
`startat` int(10) unsigned NOT NULL default '0',
`perpage` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`upgradelogid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; user
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` char(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` char(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` char(50) NOT NULL default '',
`homepage` char(100) NOT NULL default '',
`icq` char(20) NOT NULL default '',
`aim` char(20) NOT NULL default '',
`yahoo` char(32) NOT NULL default '',
`msn` char(100) NOT NULL default '',
`skype` char(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`usertitle` char(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` char(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '33554447',
`birthday` char(10) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` char(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(3) NOT NULL default '',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
`adminoptions` int(10) unsigned NOT NULL default '0',
`profilevisits` int(10) unsigned NOT NULL default '0',
`friendcount` int(10) unsigned NOT NULL default '0',
`friendreqcount` int(10) unsigned NOT NULL default '0',
`vmunreadcount` int(10) unsigned NOT NULL default '0',
`vmmoderatedcount` int(10) unsigned NOT NULL default '0',
`socgroupinvitecount` int(10) unsigned NOT NULL default '0',
`socgroupreqcount` int(10) unsigned NOT NULL default '0',
`pcunreadcount` int(10) unsigned NOT NULL default '0',
`pcmoderatedcount` int(10) unsigned NOT NULL default '0',
`gmmoderatedcount` int(10) unsigned NOT NULL default '0',
`mwaextraadmin3_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') default NULL,
`mwaextraadmin3_imageresizer_maxwidth` smallint(5) unsigned default NULL,
`mwaextraadmin3_imageresizer_maxheight` smallint(5) unsigned default NULL,
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `lastactivity` (`lastactivity`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; useractivation
CREATE TABLE `useractivation` (
`useractivationid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`activationid` varchar(40) NOT NULL default '',
`type` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`emailchange` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`useractivationid`),
UNIQUE KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
userban
CREATE TABLE `userban` (
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`adminid` int(10) unsigned NOT NULL default '0',
`bandate` int(10) unsigned NOT NULL default '0',
`liftdate` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `liftdate` (`liftdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; userchangelog
CREATE TABLE `userchangelog` (
`changeid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`fieldname` varchar(250) NOT NULL default '',
`newvalue` varchar(250) NOT NULL default '',
`oldvalue` varchar(250) NOT NULL default '',
`adminid` int(10) unsigned NOT NULL default '0',
`change_time` int(10) unsigned NOT NULL default '0',
`change_uniq` varchar(32) NOT NULL default '',
PRIMARY KEY (`changeid`),
KEY `userid` (`userid`,`change_time`),
KEY `change_time` (`change_time`),
KEY `change_uniq` (`change_uniq`),
KEY `fieldname` (`fieldname`,`change_time`),
KEY `adminid` (`adminid`,`change_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; usercss
CREATE TABLE `usercss` (
`userid` int(10) unsigned NOT NULL default '0',
`selector` varchar(30) NOT NULL default '',
`property` varchar(30) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`userid`,`selector`,`property`),
KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usercsscache
CREATE TABLE `usercsscache` (
`userid` int(10) unsigned NOT NULL default '0',
`cachedcss` ****,
`buildpermissions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; userfield
CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`temp` medium****,
`field1` medium****,
`field2` medium****,
`field3` medium****,
`field4` medium****,
`field631` medium**** NOT NULL,
`field632` medium**** NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usergroup
CREATE TABLE `usergroup` (
`usergroupid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`usertitle` char(100) NOT NULL default '',
`passwordexpires` smallint(5) unsigned NOT NULL default '0',
`passwordhistory` smallint(5) unsigned NOT NULL default '0',
`pmquota` smallint(5) unsigned NOT NULL default '0',
`pmsendmax` smallint(5) unsigned NOT NULL default '5',
`opentag` ****,
`closetag` ****,
`canoverride` smallint(5) unsigned NOT NULL default '0',
`ispublicgroup` smallint(5) unsigned NOT NULL default '0',
`forumpermissions` int(10) unsigned NOT NULL default '0',
`pmpermissions` int(10) unsigned NOT NULL default '0',
`calendarpermissions` int(10) unsigned NOT NULL default '0',
`wolpermissions` int(10) unsigned NOT NULL default '0',
`adminpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions2` int(10) unsigned NOT NULL default '0',
`genericoptions` int(10) unsigned NOT NULL default '0',
`signaturepermissions` int(10) unsigned NOT NULL default '0',
`visitormessagepermissions` int(10) unsigned NOT NULL default '0',
`attachlimit` int(10) unsigned NOT NULL default '0',
`avatarmaxwidth` smallint(5) unsigned NOT NULL default '0',
`avatarmaxheight` smallint(5) unsigned NOT NULL default '0',
`avatarmaxsize` int(10) unsigned NOT NULL default '0',
`profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxheight` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxsize` int(10) unsigned NOT NULL default '0',
`sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxsize` int(10) unsigned NOT NULL default '0',
`sigmaximages` smallint(5) unsigned NOT NULL default '0',
`sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0',
`sigmaxchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxrawchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxlines` smallint(5) unsigned NOT NULL default '0',
`usercsspermissions` int(10) unsigned NOT NULL default '0',
`albumpermissions` int(10) unsigned NOT NULL default '0',
`albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxsize` int(10) unsigned NOT NULL default '0',
`albummaxpics` int(10) unsigned NOT NULL default '0',
`albummaxsize` int(10) unsigned NOT NULL default '0',
`socialgrouppermissions` int(10) unsigned NOT NULL default '0',
`pmthrottlequantity` int(10) unsigned NOT NULL default '0',
`groupiconmaxsize` int(10) unsigned NOT NULL default '0',
`maximumsocialgroups` int(10) unsigned NOT NULL default '0',
`maxnewthread` int(10) unsigned NOT NULL default '0',
`maxnewtime` int(11) NOT NULL default '0',
`maxnewpost` int(11) NOT NULL default '0',
`maxnewposttime` int(11) NOT NULL default '0',
PRIMARY KEY (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; usergroupleader
CREATE TABLE `usergroupleader` (
`usergroupleaderid` smallint(5) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`usergroupleaderid`),
KEY `ugl` (`userid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; usergrouprequest
CREATE TABLE `usergrouprequest` (
`usergrouprequestid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`reason` varchar(250) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`usergrouprequestid`),
UNIQUE KEY `userid` (`userid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; userlist
CREATE TABLE `userlist` (
`userid` int(10) unsigned NOT NULL default '0',
`relationid` int(10) unsigned NOT NULL default '0',
`type` enum('buddy','ignore') NOT NULL default 'buddy',
`friend` enum('yes','no','pending','denied') NOT NULL default 'no',
PRIMARY KEY (`userid`,`relationid`,`type`),
KEY `relationid` (`relationid`,`type`,`friend`),
KEY `userid` (`userid`,`type`,`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usernote
CREATE TABLE `usernote` (
`usernoteid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`posterid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`message` medium****,
`title` varchar(255) NOT NULL default '',
`allowsmilies` smallint(6) NOT NULL default '0',
PRIMARY KEY (`usernoteid`),
KEY `userid` (`userid`),
KEY `posterid` (`posterid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; userpromotion
CREATE TABLE `userpromotion` (
`userpromotionid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` int(10) unsigned NOT NULL default '0',
`joinusergroupid` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`strategy` smallint(6) NOT NULL default '0',
`type` smallint(6) NOT NULL default '2',
PRIMARY KEY (`userpromotionid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; user****field
CREATE TABLE `user****field` (
`userid` int(10) unsigned NOT NULL default '0',
`subfolders` medium****,
`pmfolders` medium****,
`buddylist` medium****,
`ignorelist` medium****,
`signature` medium****,
`searchprefs` medium****,
`rank` medium****,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; usertitle
CREATE TABLE `usertitle` (
`usertitleid` smallint(5) unsigned NOT NULL auto_increment,
`minposts` int(10) unsigned NOT NULL default '0',
`title` char(250) NOT NULL default '',
PRIMARY KEY (`usertitleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; visitormessage
CREATE TABLE `visitormessage` (
`vmid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`postuserid` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`state` enum('visible','moderation','deleted') NOT NULL default 'visible',
`title` varchar(255) NOT NULL default '',
`page****` medium****,
`ipaddress` int(10) unsigned NOT NULL default '0',
`allowsmilie` smallint(5) unsigned NOT NULL default '0',
`reportthreadid` int(10) unsigned NOT NULL default '0',
`messageread` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`vmid`),
KEY `postuserid` (`postuserid`,`userid`,`state`),
KEY `userid` (`userid`,`dateline`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; visitormessage_hash
CREATE TABLE `visitormessage_hash` (
`postuserid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dupehash` varchar(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `postuserid` (`postuserid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; word
CREATE TABLE `word` (
`wordid` int(10) unsigned NOT NULL auto_increment,
`title` char(50) NOT NULL default '',
PRIMARY KEY (`wordid`),
UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; ملاحظة:
يوجد في آخر كل أمر الترميز latin1 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
بالتوفيق للجميع