discussionread
رمز 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 ;