رمز PHP:
كود PHP:
  `mailqueueid` int(10) unsigned NOT NULL auto_increment, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `toemail` mediumtext, 
  `fromemail` mediumtext, 
  `subject` mediumtext, 
  `message` mediumtext, 
  `header` mediumtext, 
  PRIMARY KEY  (`mailqueueid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
moderation
رمز PHP:
كود PHP:
CREATE TABLE `moderation` ( 
  `primaryid` int(10) unsigned NOT NULL default '0', 
  `type` enum('thread','reply','visitormessage','groupmessage','picturecomment') NOT NULL default 'thread', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`primaryid`,`type`), 
  KEY `type` (`type`,`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
moderator

رمز PHP:
كود PHP:
                          CREATE TABLE `moderator` ( 
  `moderatorid` smallint(5) unsigned NOT NULL auto_increment, 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(6) NOT NULL default '0', 
  `permissions` int(10) unsigned NOT NULL default '0', 
  `permissions2` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`moderatorid`), 
  UNIQUE KEY `userid_forumid` (`userid`,`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
moderatorlog

رمز PHP:
كود PHP:
                          CREATE TABLE `moderatorlog` ( 
  `moderatorlogid` int(10) unsigned NOT NULL auto_increment, 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `forumid` smallint(5) unsigned NOT NULL default '0', 
  `threadid` int(10) unsigned NOT NULL default '0', 
  `postid` int(10) unsigned NOT NULL default '0', 
  `pollid` int(10) unsigned NOT NULL default '0', 
  `attachmentid` int(10) unsigned NOT NULL default '0', 
  `action` varchar(250) NOT NULL default '', 
  `type` smallint(5) unsigned NOT NULL default '0', 
  `threadtitle` varchar(250) NOT NULL default '', 
  `ipaddress` char(15) NOT NULL default '', 
  `product` varchar(25) NOT NULL default '', 
  `id1` int(10) unsigned NOT NULL default '0', 
  `id2` int(10) unsigned NOT NULL default '0', 
  `id3` int(10) unsigned NOT NULL default '0', 
  `id4` int(10) unsigned NOT NULL default '0', 
  `id5` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`moderatorlogid`), 
  KEY `threadid` (`threadid`), 
  KEY `product` (`product`), 
  KEY `id1` (`id1`), 
  KEY `id2` (`id2`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
notice


رمز PHP:
كود PHP:
                          CREATE TABLE `notice` ( 
  `noticeid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `displayorder` int(10) unsigned NOT NULL default '0', 
  `persistent` smallint(5) unsigned NOT NULL default '0', 
  `active` smallint(5) unsigned NOT NULL default '0', 
  `dismissible` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`noticeid`), 
  KEY `active` (`active`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
noticecriteria
رمز PHP:
كود PHP:
CREATE TABLE `noticecriteria` ( 
  `noticeid` int(10) unsigned NOT NULL default '0', 
  `criteriaid` varchar(250) NOT NULL default '', 
  `condition1` varchar(250) NOT NULL default '', 
  `condition2` varchar(250) NOT NULL default '', 
  `condition3` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`noticeid`,`criteriaid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
noticedismissed
رمز PHP:
كود PHP:
CREATE TABLE `noticedismissed` ( 
  `noticeid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`noticeid`,`userid`), 
  KEY `userid` (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
passwordhistory
رمز PHP:
كود PHP:
CREATE TABLE `passwordhistory` ( 
  `userid` int(10) unsigned NOT NULL default '0', 
  `password` varchar(50) NOT NULL default '', 
  `passworddate` date NOT NULL default '0000-00-00', 
  KEY `userid` (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
paymentapi
رمز PHP:
كود PHP:
CREATE TABLE `paymentapi` ( 
  `paymentapiid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `currency` varchar(250) NOT NULL default '', 
  `recurring` smallint(6) NOT NULL default '0', 
  `classname` varchar(250) NOT NULL default '', 
  `active` smallint(6) NOT NULL default '0', 
  `settings` mediumtext, 
  PRIMARY KEY  (`paymentapiid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
paymentinfo
رمز PHP:
كود PHP:
CREATE TABLE `paymentinfo` ( 
  `paymentinfoid` int(10) unsigned NOT NULL auto_increment, 
  `hash` varchar(32) NOT NULL default '', 
  `subscriptionid` smallint(5) unsigned NOT NULL default '0', 
  `subscriptionsubid` smallint(5) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `completed` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`paymentinfoid`), 
  KEY `hash` (`hash`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
paymenttransaction
رمز PHP:
كود PHP:
CREATE TABLE `paymenttransaction` ( 
  `paymenttransactionid` int(10) unsigned NOT NULL auto_increment, 
  `paymentinfoid` int(10) unsigned NOT NULL default '0', 
  `transactionid` varchar(250) NOT NULL default '', 
  `state` smallint(5) unsigned NOT NULL default '0', 
  `amount` double unsigned NOT NULL default '0', 
  `currency` varchar(5) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `paymentapiid` int(10) unsigned NOT NULL default '0', 
  `request` mediumtext, 
  `reversed` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`paymenttransactionid`), 
  KEY `dateline` (`dateline`), 
  KEY `transactionid` (`transactionid`), 
  KEY `paymentapiid` (`paymentapiid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
phrase
رمز PHP:
كود PHP:
CREATE TABLE `phrase` ( 
  `phraseid` int(10) unsigned NOT NULL auto_increment, 
  `languageid` smallint(6) NOT NULL default '0', 
  `varname` varchar(250) character set latin1 collate latin1_bin NOT NULL default '', 
  `fieldname` varchar(20) NOT NULL default '', 
  `text` mediumtext, 
  `product` varchar(25) NOT NULL default '', 
  `username` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `version` varchar(30) NOT NULL default '', 
  PRIMARY KEY  (`phraseid`), 
  UNIQUE KEY `name_lang_type` (`varname`,`languageid`,`fieldname`), 
  KEY `languageid` (`languageid`,`fieldname`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
phrasetype رمز PHP:
كود PHP:

CREATE TABLE `phrasetype` ( 
  `fieldname` char(20) NOT NULL default '', 
  `title` char(50) NOT NULL default '', 
  `editrows` smallint(5) unsigned NOT NULL default '0', 
  `product` varchar(25) NOT NULL default '', 
  `special` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`fieldname`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
picture


رمز PHP:
CREATE TABLE `picture` ( 
`pictureid` int(10) unsigned NOT NULL auto_increment, 
`userid` int(10) unsigned NOT NULL default '0', 
`caption` text, 
`extension` varchar(20) character set latin1 collate latin1_bin NOT NULL default '', 
`filedata` mediumblob, 
`filesize` int(10) unsigned NOT NULL default '0', 
`width` smallint(5) unsigned NOT NULL default '0', 
`height` smallint(5) unsigned NOT NULL default '0', 
`thumbnail` mediumblob, 
`thumbnail_filesize` int(10) unsigned NOT NULL default '0', 
`thumbnail_width` smallint(5) unsigned NOT NULL default '0', 
`thumbnail_height` smallint(5) unsigned NOT NULL default '0', 
`thumbnail_dateline` int(10) unsigned NOT NULL default '0', 
`idhash` varchar(32) NOT NULL default '', 
`reportthreadid` int(10) unsigned NOT NULL default '0', 
`state` enum('visible','moderation') NOT NULL default 'visible', 
PRIMARY KEY (`pictureid`), 
KEY `userid` (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 

picturecomment
رمز PHP:
كود PHP:
CREATE TABLE `picturecomment` ( 
  `commentid` int(10) unsigned NOT NULL auto_increment, 
  `pictureid` 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(6) NOT NULL default '1', 
  `reportthreadid` int(10) unsigned NOT NULL default '0', 
  `messageread` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`commentid`), 
  KEY `pictureid` (`pictureid`,`dateline`,`state`), 
  KEY `postuserid` (`postuserid`,`pictureid`,`state`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
picturecomment_hash

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

رمز PHP:
كود PHP:
CREATE TABLE `plugin` ( 
  `pluginid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `hookname` varchar(250) NOT NULL default '', 
  `phpcode` text, 
  `product` varchar(25) NOT NULL default '', 
  `devkey` varchar(25) NOT NULL default '', 
  `active` smallint(6) NOT NULL default '0', 
  `executionorder` smallint(5) unsigned NOT NULL default '5', 
  PRIMARY KEY  (`pluginid`), 
  KEY `active` (`active`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
pm

رمز PHP:
كود PHP:
                          CREATE TABLE `pm` ( 
  `pmid` int(10) unsigned NOT NULL auto_increment, 
  `pmtextid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `folderid` smallint(6) NOT NULL default '0', 
  `messageread` smallint(5) unsigned NOT NULL default '0', 
  `parentpmid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`pmid`), 
  KEY `pmtextid` (`pmtextid`), 
  KEY `userid` (`userid`,`folderid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
pmreceipt

رمز PHP:
كود PHP:
                          CREATE TABLE `pmreceipt` ( 
  `pmid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned NOT NULL default '0', 
  `touserid` int(10) unsigned NOT NULL default '0', 
  `tousername` varchar(100) NOT NULL default '', 
  `title` varchar(250) NOT NULL default '', 
  `sendtime` int(10) unsigned NOT NULL default '0', 
  `readtime` int(10) unsigned NOT NULL default '0', 
  `denied` smallint(5) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`pmid`), 
  KEY `userid` (`userid`,`readtime`), 
  KEY `touserid` (`touserid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
pmtext
رمز PHP:
كود PHP:
CREATE TABLE `pmtext` ( 
  `pmtextid` int(10) unsigned NOT NULL auto_increment, 
  `fromuserid` int(10) unsigned NOT NULL default '0', 
  `fromusername` varchar(100) NOT NULL default '', 
  `title` varchar(250) NOT NULL default '', 
  `message` mediumtext, 
  `touserarray` mediumtext, 
  `iconid` smallint(5) unsigned NOT NULL default '0', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `showsignature` smallint(5) unsigned NOT NULL default '0', 
  `allowsmilie` smallint(5) unsigned NOT NULL default '1', 
  `reportthreadid` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`pmtextid`), 
  KEY `fromuserid` (`fromuserid`,`dateline`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
pmthrottle


رمز PHP:
كود PHP:
                          CREATE TABLE `pmthrottle` ( 
  `userid` int(10) unsigned NOT NULL, 
  `dateline` int(10) unsigned NOT NULL, 
  KEY `userid` (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
podcast


رمز PHP:
كود PHP:
                          CREATE TABLE `podcast` ( 
  `forumid` int(10) unsigned NOT NULL default '0', 
  `author` varchar(255) NOT NULL default '', 
  `category` varchar(255) NOT NULL default '', 
  `image` varchar(255) NOT NULL default '', 
  `explicit` smallint(6) NOT NULL default '0', 
  `enabled` smallint(6) NOT NULL default '1', 
  `keywords` varchar(255) NOT NULL default '', 
  `owneremail` varchar(255) NOT NULL default '', 
  `ownername` varchar(255) NOT NULL default '', 
  `subtitle` varchar(255) NOT NULL default '', 
  `summary` mediumtext, 
  `categoryid` smallint(6) NOT NULL default '0', 
  PRIMARY KEY  (`forumid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
podcastitem

رمز PHP:
كود PHP:
CREATE TABLE `podcastitem` ( 
  `postid` int(10) unsigned NOT NULL default '0', 
  `url` varchar(255) NOT NULL default '', 
  `length` int(10) unsigned NOT NULL default '0', 
  `explicit` smallint(5) unsigned NOT NULL default '0', 
  `keywords` varchar(255) NOT NULL default '', 
  `subtitle` varchar(255) NOT NULL default '', 
  `author` varchar(255) NOT NULL default '', 
  PRIMARY KEY  (`postid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;  
poll
رمز PHP:
كود PHP:
CREATE TABLE `poll` ( 
  `pollid` int(10) unsigned NOT NULL auto_increment, 
  `question` varchar(100) NOT NULL default '', 
  `dateline` int(10) unsigned NOT NULL default '0', 
  `options` text, 
  `votes` text, 
  `active` smallint(6) NOT NULL default '1', 
  `numberoptions` smallint(5) unsigned NOT NULL default '0', 
  `timeout` smallint(5) unsigned NOT NULL default '0', 
  `multiple` smallint(5) unsigned NOT NULL default '0', 
  `voters` smallint(5) unsigned NOT NULL default '0', 
  `public` smallint(6) NOT NULL default '0', 
  `lastvote` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`pollid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;  
pollvote

رمز PHP:
كود PHP:
CREATE TABLE `pollvote` ( 
  `pollvoteid` int(10) unsigned NOT NULL auto_increment, 
  `pollid` int(10) unsigned NOT NULL default '0', 
  `userid` int(10) unsigned default NULL, 
  `votedate` int(10) unsigned NOT NULL default '0', 
  `voteoption` int(10) unsigned NOT NULL default '0', 
  `votetype` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`pollvoteid`), 
  UNIQUE KEY `pollid` (`pollid`,`userid`,`votetype`), 
  KEY `userid` (`userid`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;