سوق العرب | معهد سكيورتى العرب | وظائف خالية

نسخة كاملة: زراعه الجداول المحذوفه في قاعدة البيانات SQL vb4
أنت حالياً تتصفح نسخة خفيفة من المنتدى . مشاهدة نسخة كاملة مع جميع الأشكال الجمالية.
السلام عليكم ورحمة الله وبركاته :


أوامر بناء قواعد البيانات

access
كود :
CREATE TABLE `access` (
  `userid` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(5) unsigned NOT NULL default '0',
  `accessmask` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

action

كود :
CREATE TABLE `action` (
  `actionid` int(10) unsigned NOT NULL auto_increment,
  `routeid` int(10) unsigned NOT NULL,
  `packageid` int(10) unsigned NOT NULL,
  `controller` varbinary(50) NOT NULL,
  `useraction` varchar(50) NOT NULL,
  `classaction` varbinary(50) NOT NULL,
  PRIMARY KEY  (`actionid`),
  UNIQUE KEY `useraction` (`routeid`,`useraction`),
  UNIQUE KEY `classaction` (`packageid`,`controller`,`classaction`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ad


كود :
CREATE TABLE `ad` (
  `adid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `adlocation` varchar(250) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  `active` smallint(5) unsigned NOT NULL default '0',
  `snippet` mediumtext,
  PRIMARY KEY  (`adid`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


adcriteria


كود :
CREATE TABLE `adcriteria` (
  `adid` 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  (`adid`,`criteriaid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

adminhelp



كود :
CREATE TABLE `adminhelp` (
  `adminhelpid` int(10) unsigned NOT NULL auto_increment,
  `script` varchar(50) NOT NULL default '',
  `action` varchar(25) NOT NULL default '',
  `optionname` varchar(100) NOT NULL default '',
  `displayorder` smallint(5) unsigned NOT NULL default '1',
  `volatile` smallint(5) unsigned NOT NULL default '0',
  `product` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`adminhelpid`),
  UNIQUE KEY `phraseunique` (`script`,`action`,`optionname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

administrator

كود :
CREATE TABLE `administrator` (
  `userid` int(10) unsigned NOT NULL default '0',
  `adminpermissions` int(10) unsigned NOT NULL default '0',
  `navprefs` mediumtext,
  `cssprefs` varchar(250) NOT NULL default '',
  `notes` mediumtext,
  `dismissednews` text,
  `languageid` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

adminlog

كود :
CREATE TABLE `adminlog` (
  `adminlogid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `script` varchar(50) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `extrainfo` varchar(200) NOT NULL default '',
  `ipaddress` char(15) NOT NULL default '',
  PRIMARY KEY  (`adminlogid`),
  KEY `script_action` (`script`,`action`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

adminmessage



كود :
CREATE TABLE `adminmessage` (
  `adminmessageid` int(10) unsigned NOT NULL auto_increment,
  `varname` varchar(250) NOT NULL default '',
  `dismissable` smallint(5) unsigned NOT NULL default '0',
  `script` varchar(50) NOT NULL default '',
  `action` varchar(20) NOT NULL default '',
  `execurl` mediumtext,
  `method` enum('get','post') NOT NULL default 'post',
  `dateline` int(10) unsigned NOT NULL default '0',
  `status` enum('undone','done','dismissed') NOT NULL default 'undone',
  `statususerid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`adminmessageid`),
  KEY `script_action` (`script`,`action`),
  KEY `varname` (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

adminutil

كود :
CREATE TABLE `adminutil` (
  `title` varchar(50) NOT NULL default '',
  `text` mediumtext,
  PRIMARY KEY  (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

album


كود :
CREATE TABLE `album` (
  `albumid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `createdate` int(10) unsigned NOT NULL default '0',
  `lastpicturedate` int(10) unsigned NOT NULL default '0',
  `visible` int(10) unsigned NOT NULL default '0',
  `moderation` int(10) unsigned NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `description` mediumtext,
  `state` enum('public','private','profile') NOT NULL default 'public',
  `coverattachmentid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`albumid`),
  KEY `userid` (`userid`,`lastpicturedate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

albumupdate

كود :
CREATE TABLE `albumupdate` (
  `albumid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`albumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

announcement



كود :
CREATE TABLE `announcement` (
  `announcementid` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `startdate` int(10) unsigned NOT NULL default '0',
  `enddate` int(10) unsigned NOT NULL default '0',
  `pagetext` mediumtext,
  `forumid` smallint(6) NOT NULL default '0',
  `views` int(10) unsigned NOT NULL default '0',
  `announcementoptions` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`announcementid`),
  KEY `forumid` (`forumid`),
  KEY `startdate` (`enddate`,`forumid`,`startdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

announcementread



كود :
CREATE TABLE `announcementread` (
  `announcementid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`announcementid`,`userid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

attachment

كود :
CREATE TABLE `attachment` (
  `attachmentid` int(10) unsigned NOT NULL auto_increment,
  `contenttypeid` int(10) unsigned NOT NULL default '0',
  `contentid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `filedataid` int(10) unsigned NOT NULL default '0',
  `state` enum('visible','moderation') NOT NULL default 'visible',
  `counter` int(10) unsigned NOT NULL default '0',
  `posthash` varchar(32) NOT NULL default '',
  `filename` varchar(100) NOT NULL default '',
  `caption` text,
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  `settings` mediumtext,
  PRIMARY KEY  (`attachmentid`),
  KEY `contenttypeid` (`contenttypeid`,`contentid`,`attachmentid`),
  KEY `contentid` (`contentid`),
  KEY `userid` (`userid`,`contenttypeid`),
  KEY `posthash` (`posthash`,`userid`),
  KEY `filedataid` (`filedataid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

attachmentcategory


كود :
CREATE TABLE `attachmentcategory` (
  `categoryid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `parentid` int(10) unsigned NOT NULL default '0',
  `displayorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`categoryid`),
  KEY `userid` (`userid`,`parentid`,`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

attachmentcategoryuser


كود :
CREATE TABLE `attachmentcategoryuser` (
  `filedataid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `categoryid` int(10) unsigned NOT NULL default '0',
  `filename` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`filedataid`,`userid`),
  KEY `categoryid` (`categoryid`,`userid`,`filedataid`),
  KEY `userid` (`userid`,`categoryid`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

attachmentpermission


كود :
CREATE TABLE `attachmentpermission` (
  `attachmentpermissionid` int(10) unsigned NOT NULL auto_increment,
  `extension` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
  `usergroupid` int(10) unsigned NOT NULL default '0',
  `size` int(10) unsigned NOT NULL default '0',
  `width` smallint(5) unsigned NOT NULL default '0',
  `height` smallint(5) unsigned NOT NULL default '0',
  `attachmentpermissions` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`attachmentpermissionid`),
  UNIQUE KEY `extension` (`extension`,`usergroupid`),
  KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

attachmenttype

كود :
CREATE TABLE `attachmenttype` (
  `extension` char(20) character set latin1 collate latin1_bin NOT NULL default '',
  `mimetype` varchar(255) NOT NULL default '',
  `size` int(10) unsigned NOT NULL default '0',
  `width` smallint(5) unsigned NOT NULL default '0',
  `height` smallint(5) unsigned NOT NULL default '0',
  `display` smallint(5) unsigned NOT NULL default '0',
  `contenttypes` mediumtext,
  PRIMARY KEY  (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

attachmentviews

كود :
CREATE TABLE `attachmentviews` (
  `attachmentid` int(10) unsigned NOT NULL default '0',
  KEY `postid` (`attachmentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

avatar


كود :
CREATE TABLE `avatar` (
  `avatarid` smallint(5) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `minimumposts` int(10) unsigned NOT NULL default '0',
  `avatarpath` varchar(100) NOT NULL default '',
  `imagecategoryid` smallint(5) unsigned NOT NULL default '0',
  `displayorder` smallint(5) unsigned NOT NULL default '1',
  PRIMARY KEY  (`avatarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

bbcode

كود :
CREATE TABLE `bbcode` (
  `bbcodeid` smallint(5) unsigned NOT NULL auto_increment,
  `bbcodetag` varchar(200) NOT NULL default '',
  `bbcodereplacement` mediumtext,
  `bbcodeexample` varchar(200) NOT NULL default '',
  `bbcodeexplanation` mediumtext,
  `twoparams` smallint(6) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `buttonimage` varchar(250) NOT NULL default '',
  `options` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`bbcodeid`),
  UNIQUE KEY `uniquetag` (`bbcodetag`,`twoparams`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

bbcode_video


كود :
CREATE TABLE `bbcode_video` (
  `providerid` int(10) unsigned NOT NULL auto_increment,
  `tagoption` varchar(50) NOT NULL default '',
  `provider` varchar(50) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `regex_url` varchar(254) NOT NULL default '',
  `regex_scrape` varchar(254) NOT NULL default '',
  `embed` mediumtext,
  `priority` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`providerid`),
  UNIQUE KEY `tagoption` (`tagoption`),
  KEY `priority` (`priority`),
  KEY `provider` (`provider`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

block


كود :
CREATE TABLE `block` (
  `blockid` int(10) unsigned NOT NULL auto_increment,
  `blocktypeid` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` mediumtext,
  `url` varchar(100) NOT NULL default '',
  `cachettl` int(11) NOT NULL default '0',
  `displayorder` smallint(6) NOT NULL default '0',
  `active` smallint(6) NOT NULL default '0',
  `configcache` mediumblob,
  PRIMARY KEY  (`blockid`),
  KEY `blocktypeid` (`blocktypeid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

blockconfig

كود :
CREATE TABLE `blockconfig` (
  `blockid` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `value` mediumtext,
  `serialized` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`blockid`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

blocktype


كود :
CREATE TABLE `blocktype` (
  `blocktypeid` int(10) unsigned NOT NULL auto_increment,
  `productid` varchar(25) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` mediumtext,
  `allowcache` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`blocktypeid`),
  UNIQUE KEY `name` (`name`),
  KEY `productid` (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

bookmarksite


كود :
CREATE TABLE `bookmarksite` (
  `bookmarksiteid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `iconpath` varchar(250) NOT NULL default '',
  `active` smallint(5) unsigned NOT NULL default '0',
  `displayorder` int(10) unsigned NOT NULL default '0',
  `url` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`bookmarksiteid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

cache

كود :
CREATE TABLE `cache` (
  `cacheid` varbinary(64) NOT NULL,
  `expires` int(10) unsigned NOT NULL,
  `created` int(10) unsigned NOT NULL,
  `locktime` int(10) unsigned NOT NULL,
  `serialized` enum('0','1') NOT NULL default '0',
  `data` blob,
  PRIMARY KEY  (`cacheid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

cacheevent

كود :
CREATE TABLE `cacheevent` (
  `cacheid` varbinary(64) NOT NULL,
  `event` varbinary(50) NOT NULL,
  PRIMARY KEY  (`cacheid`,`event`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

calendar

كود :
CREATE TABLE `calendar` (
  `calendarid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` varchar(100) NOT NULL default '',
  `displayorder` smallint(6) NOT NULL default '0',
  `neweventemail` text,
  `moderatenew` smallint(6) NOT NULL default '0',
  `startofweek` smallint(6) NOT NULL default '0',
  `options` int(10) unsigned NOT NULL default '0',
  `cutoff` smallint(5) unsigned NOT NULL default '0',
  `eventcount` smallint(5) unsigned NOT NULL default '0',
  `birthdaycount` smallint(5) unsigned NOT NULL default '0',
  `startyear` smallint(5) unsigned NOT NULL default '2000',
  `endyear` smallint(5) unsigned NOT NULL default '2006',
  `holidays` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`calendarid`),
  KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

calendarcustomfield



كود :
CREATE TABLE `calendarcustomfield` (
  `calendarcustomfieldid` int(10) unsigned NOT NULL auto_increment,
  `calendarid` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `description` mediumtext,
  `options` mediumtext,
  `allowentry` smallint(6) NOT NULL default '1',
  `required` smallint(6) NOT NULL default '0',
  `length` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`calendarcustomfieldid`),
  KEY `calendarid` (`calendarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

calendarmoderator


كود :
CREATE TABLE `calendarmoderator` (
  `calendarmoderatorid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `calendarid` int(10) unsigned NOT NULL default '0',
  `neweventemail` smallint(6) NOT NULL default '0',
  `permissions` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`calendarmoderatorid`),
  KEY `userid` (`userid`,`calendarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

calendarpermission



كود :
CREATE TABLE `calendarpermission` (
  `calendarpermissionid` int(10) unsigned NOT NULL auto_increment,
  `calendarid` int(10) unsigned NOT NULL default '0',
  `usergroupid` smallint(5) unsigned NOT NULL default '0',
  `calendarpermissions` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`calendarpermissionid`),
  KEY `calendarid` (`calendarid`),
  KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

contentpriority


كود :
CREATE TABLE `contentpriority` (
  `contenttypeid` varchar(20) NOT NULL,
  `sourceid` int(10) unsigned NOT NULL,
  `prioritylevel` double(2,1) unsigned NOT NULL,
  PRIMARY KEY  (`contenttypeid`,`sourceid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

contenttype
كود :
CREATE TABLE `contenttype` (
  `contenttypeid` int(10) unsigned NOT NULL auto_increment,
  `class` varbinary(50) NOT NULL,
  `packageid` int(10) unsigned NOT NULL,
  `canplace` enum('0','1') NOT NULL default '0',
  `cansearch` enum('0','1') NOT NULL default '0',
  `cantag` enum('0','1') default '0',
  `canattach` enum('0','1') default '0',
  `isaggregator` enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (`contenttypeid`),
  UNIQUE KEY `packageclass` (`packageid`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

cpsession

كود :
CREATE TABLE `cpsession` (
  `userid` int(10) unsigned NOT NULL default '0',
  `hash` varchar(32) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`hash`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

cron
كود :
CREATE TABLE `cron` (
  `cronid` int(10) unsigned NOT NULL auto_increment,
  `nextrun` int(10) unsigned NOT NULL default '0',
  `weekday` smallint(6) NOT NULL default '0',
  `day` smallint(6) NOT NULL default '0',
  `hour` smallint(6) NOT NULL default '0',
  `minute` varchar(100) NOT NULL default '',
  `filename` char(50) NOT NULL default '',
  `loglevel` smallint(6) NOT NULL default '0',
  `active` smallint(6) NOT NULL default '1',
  `varname` varchar(100) NOT NULL default '',
  `volatile` smallint(5) unsigned NOT NULL default '0',
  `product` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`cronid`),
  UNIQUE KEY `varname` (`varname`),
  KEY `nextrun` (`nextrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

cronlog


كود :
CREATE TABLE `cronlog` (
  `cronlogid` int(10) unsigned NOT NULL auto_increment,
  `varname` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `description` mediumtext,
  `type` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cronlogid`),
  KEY `varname` (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

customavatar


كود :
CREATE TABLE `customavatar` (
  `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',
  `filedata_thumb` mediumblob,
  `width_thumb` int(10) unsigned NOT NULL default '0',
  `height_thumb` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

customprofilepic


كود :
CREATE TABLE `customprofilepic` (
  `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;

datastore

كود :
CREATE TABLE `datastore` (
  `title` char(50) NOT NULL default '',
  `data` mediumtext,
  `unserialize` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

deletionlog

كود :
CREATE TABLE `deletionlog` (
  `primaryid` int(10) unsigned NOT NULL default '0',
  `type` enum('post','thread','visitormessage','groupmessage','picturecomment') NOT NULL default 'post',
  `userid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `reason` varchar(125) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`primaryid`,`type`),
  KEY `type` (`type`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

discussion

كود :
CREATE TABLE `discussion` (
  `discussionid` int(10) unsigned NOT NULL auto_increment,
  `groupid` int(10) unsigned NOT NULL,
  `firstpostid` int(10) unsigned NOT NULL,
  `lastpostid` int(10) unsigned NOT NULL,
  `lastpost` int(10) unsigned NOT NULL,
  `lastposter` varchar(255) NOT NULL,
  `lastposterid` int(10) unsigned NOT NULL,
  `visible` int(10) unsigned NOT NULL default '0',
  `deleted` int(10) unsigned NOT NULL default '0',
  `moderation` int(10) unsigned NOT NULL default '0',
  `subscribers` enum('0','1') default '0',
  PRIMARY KEY  (`discussionid`),
  KEY `groupid` (`groupid`,`lastpost`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

discussionread


كود :
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



كود :
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


كود :
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


كود :
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


كود :
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;

filedata


كود :
CREATE TABLE `filedata` (
  `filedataid` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `thumbnail_dateline` int(10) unsigned NOT NULL default '0',
  `filedata` mediumblob,
  `filesize` int(10) unsigned NOT NULL default '0',
  `filehash` char(32) NOT NULL default '',
  `thumbnail` mediumblob,
  `thumbnail_filesize` int(10) unsigned NOT NULL default '0',
  `extension` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
  `refcount` int(10) unsigned NOT NULL default '0',
  `width` smallint(5) unsigned NOT NULL default '0',
  `height` smallint(5) unsigned NOT NULL default '0',
  `thumbnail_width` smallint(5) unsigned NOT NULL default '0',
  `thumbnail_height` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`filedataid`),
  KEY `filesize` (`filesize`),
  KEY `filehash` (`filehash`),
  KEY `userid` (`userid`),
  KEY `refcount` (`refcount`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

forum
كود :
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 '',
  `lastposterid` int(10) unsigned NOT NULL default '0',
  `lastpostid` int(10) unsigned NOT NULL default '0',
  `lastthread` varchar(250) NOT NULL default '',
  `lastthreadid` int(10) unsigned NOT NULL default '0',
  `lasticonid` smallint(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 '',
  PRIMARY KEY  (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

forumpermission



كود :
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


كود :
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


كود :
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


كود :
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

groupmessage_hash

كود :
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


كود :
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

كود :
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


كود :
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



كود :
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



كود :
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


كود :
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



كود :
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

كود :
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;

indexqueue

كود :
CREATE TABLE `indexqueue` (
  `queueid` int(10) unsigned NOT NULL auto_increment,
  `contenttype` varchar(45) NOT NULL,
  `newid` int(10) unsigned NOT NULL,
  `id2` int(10) unsigned NOT NULL,
  `package` varchar(64) NOT NULL,
  `operation` varchar(64) NOT NULL,
  `data` text NOT NULL,
  PRIMARY KEY  (`queueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

infraction


كود :
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

كود :
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

كود :
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


كود :
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

كود :
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,
  `phrasegroup_advertising` mediumtext,
  `phrasegroup_tagscategories` mediumtext,
  `phrasegroup_contenttypes` mediumtext,
  `phrasegroup_vbblock` mediumtext,
  `phrasegroup_vbblocksettings` mediumtext,
  PRIMARY KEY  (`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

mailqueue

كود :
CREATE TABLE `mailqueue` (
  `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


كود :
CREATE TABLE `moderation` (
  `primaryid` int(10) unsigned NOT NULL default '0',
  `type` enum('thread','reply','visitormessage','groupmessage','picturecomment') NOT NULL default 'thread',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`primaryid`,`type`),
  KEY `type` (`type`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

moderator

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

moderatorlog

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

notice

كود :
CREATE TABLE `notice` (
  `noticeid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  `persistent` smallint(5) unsigned NOT NULL default '0',
  `active` smallint(5) unsigned NOT NULL default '0',
  `dismissible` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`noticeid`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

noticecriteria
كود :
CREATE TABLE `noticecriteria` (
  `noticeid` int(10) unsigned NOT NULL default '0',
  `criteriaid` varchar(250) NOT NULL default '',
  `condition1` varchar(250) NOT NULL default '',
  `condition2` varchar(250) NOT NULL default '',
  `condition3` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`noticeid`,`criteriaid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

noticedismissed


كود :
CREATE TABLE `noticedismissed` (
  `noticeid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`noticeid`,`userid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

package
كود :
CREATE TABLE `package` (
  `packageid` int(10) unsigned NOT NULL auto_increment,
  `productid` varchar(25) NOT NULL,
  `class` varbinary(50) NOT NULL,
  PRIMARY KEY  (`packageid`),
  UNIQUE KEY `class` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

passwordhistory
كود :
CREATE TABLE `passwordhistory` (
  `userid` int(10) unsigned NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `passworddate` date NOT NULL default '0000-00-00',
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

paymentapi

كود :
CREATE TABLE `paymentapi` (
  `paymentapiid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `currency` varchar(250) NOT NULL default '',
  `recurring` smallint(6) NOT NULL default '0',
  `classname` varchar(250) NOT NULL default '',
  `active` smallint(6) NOT NULL default '0',
  `settings` mediumtext,
  PRIMARY KEY  (`paymentapiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

paymentinfo


كود :
CREATE TABLE `paymentinfo` (
  `paymentinfoid` int(10) unsigned NOT NULL auto_increment,
  `hash` varchar(32) NOT NULL default '',
  `subscriptionid` smallint(5) unsigned NOT NULL default '0',
  `subscriptionsubid` smallint(5) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `completed` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`paymentinfoid`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

paymenttransaction
كود :
CREATE TABLE `paymenttransaction` (
  `paymenttransactionid` int(10) unsigned NOT NULL auto_increment,
  `paymentinfoid` int(10) unsigned NOT NULL default '0',
  `transactionid` varchar(250) NOT NULL default '',
  `state` smallint(5) unsigned NOT NULL default '0',
  `amount` double unsigned NOT NULL default '0',
  `currency` varchar(5) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `paymentapiid` int(10) unsigned NOT NULL default '0',
  `request` 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

كود :
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


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

picturecomment

كود :
CREATE TABLE `picturecomment` (
  `commentid` int(10) unsigned NOT NULL auto_increment,
  `filedataid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `postuserid` int(10) unsigned NOT NULL default '0',
  `postusername` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `state` enum('visible','moderation','deleted') NOT NULL default 'visible',
  `title` varchar(255) NOT NULL default '',
  `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 `filedataid` (`filedataid`,`userid`,`dateline`,`state`),
  KEY `postuserid` (`postuserid`,`filedataid`,`userid`,`state`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

picturecomment_hash


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

picturelegacy

كود :
CREATE TABLE `picturelegacy` (
  `type` enum('album','group') NOT NULL default 'album',
  `primaryid` int(10) unsigned NOT NULL default '0',
  `pictureid` int(10) unsigned NOT NULL default '0',
  `attachmentid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`type`,`primaryid`,`pictureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

plugin

كود :
CREATE TABLE `plugin` (
  `pluginid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `hookname` varchar(250) NOT NULL default '',
  `phpcode` 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


كود :
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


كود :
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

كود :
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



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

podcast


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

podcastitem


كود :
CREATE TABLE `podcastitem` (
  `postid` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `length` int(10) unsigned NOT NULL default '0',
  `explicit` smallint(5) unsigned NOT NULL default '0',
  `keywords` varchar(255) NOT NULL default '',
  `subtitle` varchar(255) NOT NULL default '',
  `author` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

poll


كود :
CREATE TABLE `poll` (
  `pollid` int(10) unsigned NOT NULL auto_increment,
  `question` varchar(100) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `options` 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

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

post



كود :
CREATE TABLE `post` (
  `postid` int(10) unsigned NOT NULL auto_increment,
  `threadid` int(10) unsigned NOT NULL default '0',
  `parentid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `userid` int(10) unsigned NOT NULL default '0',
  `title` varchar(250) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `pagetext` mediumtext,
  `allowsmilie` smallint(6) NOT NULL default '0',
  `showsignature` smallint(6) NOT NULL default '0',
  `ipaddress` char(15) NOT NULL default '',
  `iconid` smallint(5) unsigned NOT NULL default '0',
  `visible` smallint(6) NOT NULL default '0',
  `attach` smallint(5) unsigned NOT NULL default '0',
  `infraction` smallint(5) unsigned NOT NULL default '0',
  `reportthreadid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`postid`),
  KEY `userid` (`userid`),
  KEY `threadid` (`threadid`,`userid`),
  KEY `threadid_visible_dateline` (`threadid`,`visible`,`dateline`,`userid`,`postid`),
  KEY `dateline` (`dateline`),
  KEY `ipaddress` (`ipaddress`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

postedithistory

كود :
CREATE TABLE `postedithistory` (
  `postedithistoryid` int(10) unsigned NOT NULL auto_increment,
  `postid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `iconid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `reason` varchar(200) NOT NULL default '',
  `original` smallint(6) NOT NULL default '0',
  `pagetext` mediumtext,
  PRIMARY KEY  (`postedithistoryid`),
  KEY `postid` (`postid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

posthash


كود :
CREATE TABLE `posthash` (
  `userid` int(10) unsigned NOT NULL default '0',
  `threadid` int(10) unsigned NOT NULL default '0',
  `postid` int(10) unsigned NOT NULL default '0',
  `dupehash` char(32) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  KEY `userid` (`userid`,`dupehash`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

postlog



كود :
CREATE TABLE `postlog` (
  `postid` int(10) unsigned NOT NULL default '0',
  `useragent` char(100) NOT NULL default '',
  `ip` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`postid`),
  KEY `dateline` (`dateline`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

postparsed

كود :
CREATE TABLE `postparsed` (
  `postid` int(10) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `styleid` smallint(5) unsigned NOT NULL default '0',
  `languageid` smallint(5) unsigned NOT NULL default '0',
  `hasimages` smallint(6) NOT NULL default '0',
  `pagetext_html` mediumtext,
  PRIMARY KEY  (`postid`,`styleid`,`languageid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

prefix



كود :
CREATE TABLE `prefix` (
  `prefixid` varchar(25) NOT NULL default '',
  `prefixsetid` varchar(25) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  `options` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prefixid`),
  KEY `prefixsetid` (`prefixsetid`,`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

prefixpermission


كود :
CREATE TABLE `prefixpermission` (
  `prefixid` varchar(25) NOT NULL default '',
  `usergroupid` smallint(5) unsigned NOT NULL default '0',
  KEY `prefixsetid` (`prefixid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

prefixset


كود :
CREATE TABLE `prefixset` (
  `prefixsetid` varchar(25) NOT NULL default '',
  `displayorder` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prefixsetid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

product

كود :
CREATE TABLE `product` (
  `productid` varchar(25) NOT NULL default '',
  `title` varchar(50) NOT NULL default '',
  `description` varchar(250) NOT NULL default '',
  `version` varchar(25) NOT NULL default '',
  `active` smallint(5) unsigned NOT NULL default '1',
  `url` varchar(250) NOT NULL default '',
  `versioncheckurl` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

productcode

كود :
CREATE TABLE `productcode` (
  `productcodeid` int(10) unsigned NOT NULL auto_increment,
  `productid` varchar(25) NOT NULL default '',
  `version` varchar(25) NOT NULL default '',
  `installcode` mediumtext,
  `uninstallcode` mediumtext,
  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','textarea','checkbox','select_multiple') NOT NULL default 'input',
  `data` mediumtext,
  `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` mediumtext,
  `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 '',
  `text` mediumtext,
  `duedate` int(10) unsigned NOT NULL default '0',
  `adminonly` smallint(5) unsigned NOT NULL default '1',
  `completedby` int(10) unsigned NOT NULL default '0',
  `completedtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`reminderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

reputation

كود :
CREATE TABLE `reputation` (
  `reputationid` int(10) unsigned NOT NULL auto_increment,
  `postid` int(10) unsigned NOT NULL default '1',
  `userid` int(10) unsigned NOT NULL default '1',
  `reputation` int(11) NOT NULL default '0',
  `whoadded` int(10) unsigned NOT NULL default '0',
  `reason` varchar(250) default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`reputationid`),
  UNIQUE KEY `whoadded_postid` (`whoadded`,`postid`),
  KEY `userid` (`userid`),
  KEY `multi` (`postid`,`userid`),
  KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

reputationlevel



كود :
CREATE TABLE `reputationlevel` (
  `reputationlevelid` int(10) unsigned NOT NULL auto_increment,
  `minimumreputation` int(11) NOT NULL default '0',
  PRIMARY KEY  (`reputationlevelid`),
  KEY `reputationlevel` (`minimumreputation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

كود :
CREATE TABLE `route` (
  `routeid` int(10) unsigned NOT NULL auto_increment,
  `userrequest` varchar(50) NOT NULL,
  `packageid` int(10) unsigned NOT NULL,
  `class` varbinary(50) NOT NULL,
  PRIMARY KEY  (`routeid`),
  UNIQUE KEY `userrequest` (`userrequest`),
  UNIQUE KEY `packageid` (`packageid`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

rssfeed

كود :
CREATE TABLE `rssfeed` (
  `rssfeedid` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(250) NOT NULL default '',
  `url` text,
  `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` mediumtext,
  `bodytemplate` mediumtext,
  `searchwords` mediumtext,
  `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 ;


ملاح
روابط المرجعيات