رمز PHP:
كود PHP:
CREATE TABLE `discussionread` ( 
  `userid` int(10) unsigned NOT NULL, 
  `discussionid` int(10) unsigned NOT NULL, 
  `readtime` int(10) unsigned NOT NULL, 
  PRIMARY KEY  (`userid`,`discussionid`), 
  KEY `readtime` (`readtime`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
editlog
رمز PHP:
كود PHP:
CREATE TABLE `editlog` ( 
  `postid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `username` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `reason` varchar(200) NOT NULL default '', 
  `hashistory` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`postid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
event
رمز PHP:
كود PHP:
CREATE TABLE `event` ( 
  `eventid` int(10) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `event` mediumtext, 
  `title` varchar(250) NOT NULL default '', 
  `allowsmilies` smallint(6) NOT NULL default '1', 
  `recurring` smallint(6) NOT NULL default '0', 
  `recuroption` char(6) NOT NULL default '', 
  `calendarid` int(10) unsigned NOT NULL default '0', 
  `customfields` mediumtext, 
  `visible` smallint(6) NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `utc` decimal(4,2) NOT NULL default '0.00', 
  `dst` smallint(6) NOT NULL default '1', 
  `dateline_from` int(10) unsigned NOT NULL default '0', 
  `dateline_to` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`eventid`), 
  KEY `userid` (`userid`), 
  KEY `calendarid` (`calendarid`), 
  KEY `visible` (`visible`), 
  KEY `daterange` (`dateline_to`,`dateline_from`,`visible`,`calendarid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
externalcache رمز PHP:

CREATE TABLE `externalcache` ( 
`cachehash` char(32) NOT NULL default '', 
`text` mediumtext, 
`headers` mediumtext, 
`dateline` int(10) unsigned NOT NULL default '0', 
`forumid` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY (`cachehash`), 
KEY `dateline` (`dateline`,`cachehash`), 
KEY `forumid` (`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 

faq
رمز PHP:
كود PHP:
CREATE TABLE `faq` ( 
  `faqname` varchar(250) character set latin1 collate latin1_bin NOT NULL default '', 
  `faqparent` varchar(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  (`faqname`), 
  KEY `faqparent` (`faqparent`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
forum

رمز PHP:
كود PHP:
                          CREATE TABLE `forum` ( 
  `forumid` smallint(5) unsigned NOT NULL auto_increment, 
  `styleid` smallint(5) unsigned NOT NULL default '0', 
  `title` varchar(100) NOT NULL default '', 
  `title_clean` varchar(100) NOT NULL default '', 
  `description` text, 
  `description_clean` text, 
  `options` int(10) unsigned NOT NULL default '0', 
  `showprivate` tinyint(3) unsigned NOT NULL default '0', 
  `displayorder` smallint(6) NOT NULL default '0', 
  `replycount` int(10) unsigned NOT NULL default '0', 
  `lastpost` int(11) 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(6) NOT NULL default '0', 
  `lastprefixid` varchar(25) NOT NULL default '', 
  `threadcount` mediumint(8) unsigned NOT NULL default '0', 
  `daysprune` smallint(6) NOT NULL default '0', 
  `newpostemail` text, 
  `newthreademail` text, 
  `parentid` smallint(6) NOT NULL default '0', 
  `parentlist` varchar(250) NOT NULL default '', 
  `password` varchar(50) NOT NULL default '', 
  `link` varchar(200) NOT NULL default '', 
  `childlist` text, 
  `defaultsortfield` varchar(50) NOT NULL default 'lastpost', 
  `defaultsortorder` enum('asc','desc') NOT NULL default 'desc', 
  `imageprefix` varchar(100) NOT NULL default '', 
  `vbseo_moderatepingbacks` int(10) unsigned NOT NULL default '1', 
  `vbseo_moderatetrackbacks` int(10) unsigned NOT NULL default '1', 
  `vbseo_moderaterefbacks` int(10) unsigned NOT NULL default '1', 
  `forumhomeicon` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
forumpermission

رمز PHP:
كود PHP:
                          CREATE TABLE `forumpermission` ( 
  `forumpermissionid` int(10) unsigned NOT NULL auto_increment, 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  `forumpermissions` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`forumpermissionid`), 
  UNIQUE KEY `ugid_fid` (`usergroupid`,`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
forumprefixset
رمز PHP:
كود PHP:
CREATE TABLE `forumprefixset` ( 
  `forumid` int(10) unsigned NOT NULL default '0', 
  `prefixsetid` varchar(25) NOT NULL default '', 
  PRIMARY KEY  (`forumid`,`prefixsetid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
forumread

رمز PHP:
كود PHP:
                          CREATE TABLE `forumread` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `readtime` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`forumid`,`userid`), 
  KEY `readtime` (`readtime`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
groupmessage


رمز PHP:
كود PHP:
                          CREATE TABLE `groupmessage` ( 
  `gmid` int(10) unsigned NOT NULL auto_increment, 
  `discussionid` 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 '', 
  `pagetext` mediumtext, 
  `ipaddress` int(10) unsigned NOT NULL default '0', 
  `allowsmilie` smallint(5) unsigned NOT NULL default '0', 
  `reportthreadid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`gmid`), 
  KEY `postuserid` (`postuserid`,`discussionid`,`state`), 
  KEY `discussionid` (`discussionid`,`dateline`,`state`), 
  FULLTEXT KEY `gm_ft` (`title`,`pagetext`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
groupmessage_hash

رمز PHP:
كود PHP:
                          CREATE TABLE `groupmessage_hash` ( 
  `postuserid` int(10) unsigned NOT NULL default '0', 
  `groupid` 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;  
groupread

رمز PHP:
كود PHP:
                          CREATE TABLE `groupread` ( 
  `userid` int(10) unsigned NOT NULL, 
  `groupid` int(10) unsigned NOT NULL, 
  `readtime` int(10) unsigned NOT NULL, 
  PRIMARY KEY  (`userid`,`groupid`), 
  KEY `readtime` (`readtime`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
holiday
رمز PHP:
كود PHP:
                          CREATE TABLE `holiday` ( 
  `holidayid` int(10) unsigned NOT NULL auto_increment, 
  `varname` varchar(100) NOT NULL default '', 
  `recurring` smallint(5) unsigned NOT NULL default '0', 
  `recuroption` char(6) NOT NULL default '', 
  `allowsmilies` smallint(6) NOT NULL default '1', 
  PRIMARY KEY  (`holidayid`), 
  KEY `varname` (`varname`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
humanverify

رمز PHP:
كود PHP:
CREATE TABLE `humanverify` ( 
  `hash` char(32) NOT NULL default '', 
  `answer` mediumtext, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `viewed` smallint(5) unsigned NOT NULL default '0', 
  KEY `hash` (`hash`), 
  KEY `dateline` (`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
hvanswer
رمز PHP:
كود PHP:
CREATE TABLE `hvanswer` ( 
  `answerid` int(11) NOT NULL auto_increment, 
  `questionid` int(11) NOT NULL default '0', 
  `answer` varchar(255) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`answerid`), 
  KEY `questionid` (`questionid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
hvquestion رمز PHP:
كود PHP:
CREATE TABLE `hvquestion` ( 
  `questionid` int(10) unsigned NOT NULL auto_increment, 
  `regex` varchar(255) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`questionid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
icon
رمز PHP:
كود PHP:
CREATE TABLE `icon` ( 
  `iconid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(100) NOT NULL default '', 
  `iconpath` varchar(100) NOT NULL default '', 
  `imagecategoryid` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` smallint(5) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`iconid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
imagecategory
رمز PHP:
كود PHP:
CREATE TABLE `imagecategory` ( 
  `imagecategoryid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(255) NOT NULL default '', 
  `imagetype` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`imagecategoryid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
imagecategorypermission
رمز PHP:
كود PHP:
CREATE TABLE `imagecategorypermission` ( 
  `imagecategoryid` smallint(5) unsigned NOT NULL default '0', 
  `usergroupid` smallint(5) unsigned NOT NULL default '0', 
  KEY `imagecategoryid` (`imagecategoryid`,`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
infraction
رمز PHP:
كود PHP:
CREATE TABLE `infraction` ( 
  `infractionid` int(10) unsigned NOT NULL auto_increment, 
  `infractionlevelid` int(10) unsigned NOT NULL default '0', 
  `postid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `whoadded` int(10) unsigned NOT NULL default '0', 
  `points` int(10) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `note` varchar(255) NOT NULL default '', 
  `action` smallint(5) unsigned NOT NULL default '0', 
  `actiondateline` int(10) unsigned NOT NULL default '0', 
  `actionuserid` int(10) unsigned NOT NULL default '0', 
  `actionreason` varchar(255) NOT NULL default '0', 
  `expires` int(10) unsigned NOT NULL default '0', 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `customreason` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`infractionid`), 
  KEY `expires` (`expires`,`action`), 
  KEY `userid` (`userid`,`action`), 
  KEY `infractonlevelid` (`infractionlevelid`), 
  KEY `postid` (`postid`), 
  KEY `threadid` (`threadid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
infractionban

رمز PHP:
كود PHP:
CREATE TABLE `infractionban` ( 
  `infractionbanid` int(10) unsigned NOT NULL auto_increment, 
  `usergroupid` int(11) NOT NULL default '0', 
  `banusergroupid` int(10) unsigned NOT NULL default '0', 
  `amount` int(10) unsigned NOT NULL default '0', 
  `period` char(5) NOT NULL default '', 
  `method` enum('points','infractions') NOT NULL default 'infractions', 
  PRIMARY KEY  (`infractionbanid`), 
  KEY `usergroupid` (`usergroupid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
infractiongroup

رمز PHP:
كود PHP:
                          CREATE TABLE `infractiongroup` ( 
  `infractiongroupid` int(10) unsigned NOT NULL auto_increment, 
  `usergroupid` int(11) NOT NULL default '0', 
  `orusergroupid` smallint(5) unsigned NOT NULL default '0', 
  `pointlevel` int(10) unsigned NOT NULL default '0', 
  `override` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`infractiongroupid`), 
  KEY `usergroupid` (`usergroupid`,`pointlevel`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
infractionlevel
رمز PHP:
كود PHP:
CREATE TABLE `infractionlevel` ( 
  `infractionlevelid` int(10) unsigned NOT NULL auto_increment, 
  `points` int(10) unsigned NOT NULL default '0', 
  `expires` int(10) unsigned NOT NULL default '0', 
  `period` enum('H','D','M','N') NOT NULL default 'H', 
  `warning` smallint(5) unsigned NOT NULL default '0', 
  `extend` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`infractionlevelid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
language رمز PHP:
كود PHP:

CREATE TABLE `language` ( 
  `languageid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(50) NOT NULL default '', 
  `userselect` smallint(5) unsigned NOT NULL default '1', 
  `options` smallint(5) unsigned NOT NULL default '1', 
  `languagecode` varchar(12) NOT NULL default '', 
  `charset` varchar(15) NOT NULL default '', 
  `imagesoverride` varchar(150) NOT NULL default '', 
  `dateoverride` varchar(50) NOT NULL default '', 
  `timeoverride` varchar(50) NOT NULL default '', 
  `registereddateoverride` varchar(50) NOT NULL default '', 
  `calformat1override` varchar(50) NOT NULL default '', 
  `calformat2override` varchar(50) NOT NULL default '', 
  `logdateoverride` varchar(50) NOT NULL default '', 
  `locale` varchar(20) NOT NULL default '', 
  `decimalsep` char(1) NOT NULL default '.', 
  `thousandsep` char(1) NOT NULL default ',', 
  `phrasegroup_global` mediumtext, 
  `phrasegroup_cpglobal` mediumtext, 
  `phrasegroup_cppermission` mediumtext, 
  `phrasegroup_forum` mediumtext, 
  `phrasegroup_calendar` mediumtext, 
  `phrasegroup_attachment_image` mediumtext, 
  `phrasegroup_style` mediumtext, 
  `phrasegroup_logging` mediumtext, 
  `phrasegroup_cphome` mediumtext, 
  `phrasegroup_promotion` mediumtext, 
  `phrasegroup_user` mediumtext, 
  `phrasegroup_help_faq` mediumtext, 
  `phrasegroup_sql` mediumtext, 
  `phrasegroup_subscription` mediumtext, 
  `phrasegroup_language` mediumtext, 
  `phrasegroup_bbcode` mediumtext, 
  `phrasegroup_stats` mediumtext, 
  `phrasegroup_diagnostic` mediumtext, 
  `phrasegroup_maintenance` mediumtext, 
  `phrasegroup_profilefield` mediumtext, 
  `phrasegroup_thread` mediumtext, 
  `phrasegroup_timezone` mediumtext, 
  `phrasegroup_banning` mediumtext, 
  `phrasegroup_reputation` mediumtext, 
  `phrasegroup_wol` mediumtext, 
  `phrasegroup_threadmanage` mediumtext, 
  `phrasegroup_pm` mediumtext, 
  `phrasegroup_cpuser` mediumtext, 
  `phrasegroup_accessmask` mediumtext, 
  `phrasegroup_cron` mediumtext, 
  `phrasegroup_moderator` mediumtext, 
  `phrasegroup_cpoption` mediumtext, 
  `phrasegroup_cprank` mediumtext, 
  `phrasegroup_cpusergroup` mediumtext, 
  `phrasegroup_holiday` mediumtext, 
  `phrasegroup_posting` mediumtext, 
  `phrasegroup_poll` mediumtext, 
  `phrasegroup_fronthelp` mediumtext, 
  `phrasegroup_register` mediumtext, 
  `phrasegroup_search` mediumtext, 
  `phrasegroup_showthread` mediumtext, 
  `phrasegroup_postbit` mediumtext, 
  `phrasegroup_forumdisplay` mediumtext, 
  `phrasegroup_messaging` mediumtext, 
  `phrasegroup_inlinemod` mediumtext, 
  `phrasegroup_plugins` mediumtext, 
  `phrasegroup_cprofilefield` mediumtext, 
  `phrasegroup_reputationlevel` mediumtext, 
  `phrasegroup_infraction` mediumtext, 
  `phrasegroup_infractionlevel` mediumtext, 
  `phrasegroup_notice` mediumtext, 
  `phrasegroup_prefix` mediumtext, 
  `phrasegroup_prefixadmin` mediumtext, 
  `phrasegroup_album` mediumtext, 
  `phrasegroup_socialgroups` mediumtext, 
  PRIMARY KEY  (`languageid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
mailqueue