مــــلــــوكـــه
07-19-2013, 04:27 PM
السلام عليكم ورحمه الله وبركاته
وبكل صراحه الموضوع اتعبني كثيراً فقد استغرق اكثر من 7 ساعات
هذي جميع الجداول في قاعدة بيانات المنتدى سكربت vBulletin في النسخه 4.0 .... ولا انصح للنسخ القديمه بإستخدام أوامر البناء ....
عند حذف جدول في قاعدة البيانات بالغلط قم بزراعت الأوامر المذكوره ادناه
يستحسن الترقيه بعد زراعه أمر بناء لتجنب المشاكل
أوامر بناء قواعد البيانات
access رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `adminutil` (
`title` varchar(50) NOT NULL default '',
`text` mediumtext,
PRIMARY KEY (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
album
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `attachmentviews` (
`attachmentid` int(10) unsigned NOT NULL default '0',
KEY `postid` (`attachmentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
avatar
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `cacheevent` (
`cacheid` varbinary(64) NOT NULL,
`event` varbinary(50) NOT NULL,
PRIMARY KEY (`cacheid`,`event`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
calendar
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `deletionlog` (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('post','thread','visitormessage','groupmessag e','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
رمز PHP:
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
رمز 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:
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:
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`,`calendar id`)
) 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:
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
رمز PHP:
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 رمز 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 '',
`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
رمز 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:
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:
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:
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
رمز 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:
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:
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:
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:
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:
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:
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:
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:
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
رمز PHP:
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
رمز 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:
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:
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:
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:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `moderation` (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessa ge','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:
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:
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:
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:
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:
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 رمز PHP:
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 رمز 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:
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:
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:
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:
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:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز 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:
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:
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:
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:
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:
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:
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:
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:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 ;
رمز PHP:
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
رمز PHP:
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 ;
rsslog
رمز PHP:
CREATE TABLE `rsslog` (
`rssfeedid` int(10) unsigned NOT NULL default '0',
`itemid` int(10) unsigned NOT NULL default '0',
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`uniquehash` char(32) NOT NULL default '',
`contenthash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`threadactiontime` int(10) unsigned NOT NULL default '0',
`threadactioncomplete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`,`itemid`,`itemtype`),
UNIQUE KEY `uniquehash` (`uniquehash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
searchcore
رمز PHP:
CREATE TABLE `searchcore` (
`searchcoreid` int(10) unsigned NOT NULL auto_increment,
`contenttypeid` int(10) unsigned NOT NULL,
`primaryid` int(10) unsigned NOT NULL,
`groupcontenttypeid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL,
`ipaddress` int(10) unsigned NOT NULL,
`searchgroupid` int(10) unsigned NOT NULL,
PRIMARY KEY (`searchcoreid`),
UNIQUE KEY `contentunique` (`contenttypeid`,`primaryid`),
KEY `groupid` (`groupcontenttypeid`,`groupid`),
KEY `ipaddress` (`ipaddress`),
KEY `dateline` (`dateline`),
KEY `userid` (`userid`),
KEY `searchgroupid` (`searchgroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
searchcore_text
رمز PHP:
CREATE TABLE `searchcore_text` (
`searchcoreid` int(10) unsigned NOT NULL,
`keywordtext` mediumtext,
`title` varchar(254) NOT NULL default '',
PRIMARY KEY (`searchcoreid`),
FULLTEXT KEY `text` (`title`,`keywordtext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
searchgroup
رمز PHP:
CREATE TABLE `searchgroup` (
`searchgroupid` int(10) unsigned NOT NULL auto_increment,
`contenttypeid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL,
PRIMARY KEY (`searchgroupid`),
UNIQUE KEY `groupunique` (`contenttypeid`,`groupid`),
KEY `dateline` (`dateline`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
searchgroup_text رمز PHP:
CREATE TABLE `searchgroup_text` (
`searchgroupid` int(10) unsigned NOT NULL,
`title` varchar(254) NOT NULL,
PRIMARY KEY (`searchgroupid`),
FULLTEXT KEY `grouptitle` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
searchlog
رمز PHP:
CREATE TABLE `searchlog` (
`searchlogid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` varchar(15) NOT NULL default '',
`searchhash` varchar(32) NOT NULL,
`sortby` varchar(15) NOT NULL default '',
`sortorder` enum('asc','desc') NOT NULL default 'asc',
`searchtime` float unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '0',
`criteria` text NOT NULL,
`results` mediumblob,
PRIMARY KEY (`searchlogid`),
KEY `search` (`userid`,`searchhash`,`sortby`,`sortorder`),
KEY `userfloodcheck` (`userid`,`dateline`),
KEY `ipfloodcheck` (`ipaddress`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
session
رمز PHP:
CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` char(15) NOT NULL default '',
`idhash` char(32) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`location` char(255) NOT NULL default '',
`useragent` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` smallint(5) unsigned NOT NULL default '0',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`bypass` tinyint(4) NOT NULL default '0',
`profileupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`),
KEY `user_activity` (`userid`,`lastactivity`),
KEY `guest_lookup` (`idhash`,`host`,`userid`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
setting
رمز PHP:
CREATE TABLE `setting` (
`varname` varchar(100) NOT NULL default '',
`grouptitle` varchar(50) NOT NULL default '',
`value` mediumtext,
`defaultvalue` mediumtext,
`optioncode` mediumtext,
`displayorder` smallint(5) unsigned NOT NULL default '0',
`advanced` smallint(6) NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`datatype` enum('free','number','boolean','bitfield','usernam e','integer','posint') NOT NULL default 'free',
`product` varchar(25) NOT NULL default '',
`validationcode` text,
`blacklist` smallint(6) NOT NULL default '0',
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
settinggroup
رمز PHP:
CREATE TABLE `settinggroup` (
`grouptitle` char(50) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`grouptitle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
sigparsed
رمز PHP:
CREATE TABLE `sigparsed` (
`userid` int(10) unsigned NOT NULL default '0',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`signatureparsed` mediumtext,
`hasimages` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`styleid`,`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
sigpic
رمز PHP:
CREATE TABLE `sigpic` (
`userid` int(10) unsigned NOT NULL default '0',
`filedata` mediumblob,
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`visible` smallint(6) NOT NULL default '1',
`filesize` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
smilie
رمز PHP:
CREATE TABLE `smilie` (
`smilieid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`smilietext` char(20) NOT NULL default '',
`smiliepath` char(100) NOT NULL default '',
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`smilieid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
socialgroup
رمز PHP:
CREATE TABLE `socialgroup` (
`groupid` int(10) unsigned NOT NULL auto_increment,
`socialgroupcategoryid` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL default '',
`description` text,
`creatoruserid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`members` int(10) unsigned NOT NULL default '0',
`picturecount` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(255) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`lastgmid` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '0',
`deleted` int(10) unsigned NOT NULL default '0',
`moderation` int(10) unsigned NOT NULL default '0',
`type` enum('public','moderated','inviteonly') NOT NULL default 'public',
`moderatedmembers` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastdiscussionid` int(10) unsigned NOT NULL default '0',
`discussions` int(10) unsigned default '0',
`lastdiscussion` varchar(255) NOT NULL default '',
`lastupdate` int(10) unsigned NOT NULL default '0',
`transferowner` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`),
KEY `creatoruserid` (`creatoruserid`),
KEY `dateline` (`dateline`),
KEY `members` (`members`),
KEY `picturecount` (`picturecount`),
KEY `visible` (`visible`),
KEY `lastpost` (`lastpost`),
KEY `socialgroupcategoryid` (`socialgroupcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
socialgroupcategory
رمز PHP:
CREATE TABLE `socialgroupcategory` (
`socialgroupcategoryid` int(10) unsigned NOT NULL auto_increment,
`creatoruserid` int(10) unsigned NOT NULL,
`title` varchar(250) NOT NULL,
`description` text NOT NULL,
`displayorder` int(10) unsigned NOT NULL,
`lastupdate` int(10) unsigned NOT NULL,
`groups` int(10) unsigned default '0',
PRIMARY KEY (`socialgroupcategoryid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
socialgroupicon
رمز PHP:
CREATE TABLE `socialgroupicon` (
`groupid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned default '0',
`filedata` mediumblob,
`extension` varchar(20) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`thumbnail_filedata` mediumblob,
`thumbnail_width` int(10) unsigned NOT NULL default '0',
`thumbnail_height` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
socialgroupmember
رمز PHP:
CREATE TABLE `socialgroupmember` (
`userid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`type` enum('member','moderated','invited') NOT NULL default 'member',
PRIMARY KEY (`groupid`,`userid`),
KEY `groupid` (`groupid`,`type`),
KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
spamlog
رمز PHP:
CREATE TABLE `spamlog` (
`postid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
stats
رمز PHP:
CREATE TABLE `stats` (
`dateline` int(10) unsigned NOT NULL default '0',
`nuser` mediumint(8) unsigned NOT NULL default '0',
`nthread` mediumint(8) unsigned NOT NULL default '0',
`npost` mediumint(8) unsigned NOT NULL default '0',
`ausers` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
strikes
رمز PHP:
CREATE TABLE `strikes` (
`striketime` int(10) unsigned NOT NULL default '0',
`strikeip` char(15) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
KEY `striketime` (`striketime`),
KEY `strikeip` (`strikeip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
style
رمز PHP:
CREATE TABLE `style` (
`styleid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`parentid` smallint(6) NOT NULL default '0',
`parentlist` varchar(250) NOT NULL default '',
`templatelist` mediumtext,
`csscolors` mediumtext,
`css` mediumtext,
`stylevars` mediumtext,
`newstylevars` mediumtext,
`replacements` mediumtext,
`editorstyles` mediumtext,
`userselect` smallint(5) unsigned NOT NULL default '1',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
stylevar
رمز PHP:
CREATE TABLE `stylevar` (
`stylevarid` varchar(250) NOT NULL,
`styleid` smallint(6) NOT NULL default '-1',
`value` mediumblob NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
UNIQUE KEY `stylevarinstance` (`stylevarid`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
stylevardfn
رمز PHP:
CREATE TABLE `stylevardfn` (
`stylevarid` varchar(250) NOT NULL,
`styleid` smallint(6) NOT NULL default '-1',
`parentid` smallint(6) NOT NULL,
`parentlist` varchar(250) NOT NULL default '0',
`stylevargroup` varchar(250) NOT NULL,
`product` varchar(25) NOT NULL default 'vbulletin',
`datatype` varchar(25) NOT NULL default 'string',
`validation` varchar(250) NOT NULL,
`failsafe` mediumblob NOT NULL,
`units` enum('','%','px','pt','em','ex','pc','in','cm','mm ') NOT NULL default '',
`uneditable` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`stylevarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
subscribediscussion
رمز PHP:
CREATE TABLE `subscribediscussion` (
`subscribediscussionid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`),
KEY `discussionid` (`discussionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribeevent
رمز PHP:
CREATE TABLE `subscribeevent` (
`subscribeeventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`lastreminder` int(10) unsigned NOT NULL default '0',
`reminder` int(10) unsigned NOT NULL default '3600',
PRIMARY KEY (`subscribeeventid`),
UNIQUE KEY `subindex` (`userid`,`eventid`),
KEY `eventid` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribeforum
رمز PHP:
CREATE TABLE `subscribeforum` (
`subscribeforumid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribeforumid`),
UNIQUE KEY `subindex` (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribegroup
رمز PHP:
CREATE TABLE `subscribegroup` (
`subscribegroupid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`emailupdate` enum('daily','weekly','none') NOT NULL default 'none',
PRIMARY KEY (`subscribegroupid`),
UNIQUE KEY `usergroup` (`userid`,`groupid`),
KEY `groupid` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribethread
رمز PHP:
CREATE TABLE `subscribethread` (
`subscribethreadid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`emailupdate` smallint(5) unsigned NOT NULL default '0',
`folderid` int(10) unsigned NOT NULL default '0',
`canview` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`subscribethreadid`),
UNIQUE KEY `threadid` (`threadid`,`userid`),
KEY `userid` (`userid`,`folderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscription
رمز PHP:
CREATE TABLE `subscription` (
`subscriptionid` smallint(5) unsigned NOT NULL auto_increment,
`varname` varchar(100) NOT NULL default '',
`cost` mediumtext,
`forums` mediumtext,
`nusergroupid` smallint(6) NOT NULL default '0',
`membergroupids` varchar(255) NOT NULL default '',
`active` smallint(5) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
`adminoptions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscriptionlog
رمز PHP:
CREATE TABLE `subscriptionlog` (
`subscriptionlogid` mediumint(8) unsigned NOT NULL auto_increment,
`subscriptionid` smallint(6) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`pusergroupid` smallint(6) NOT NULL default '0',
`status` smallint(6) NOT NULL default '0',
`regdate` int(10) unsigned NOT NULL default '0',
`expirydate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionlogid`),
KEY `userid` (`userid`,`subscriptionid`),
KEY `subscriptionid` (`subscriptionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscriptionpermission رمز PHP:
CREATE TABLE `subscriptionpermission` (
`subscriptionpermissionid` int(10) unsigned NOT NULL auto_increment,
`subscriptionid` int(10) unsigned NOT NULL default '0',
`usergroupid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionpermissionid`),
UNIQUE KEY `subscriptionid` (`subscriptionid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
tachyforumcounter
رمز PHP:
CREATE TABLE `tachyforumcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`threadcount` mediumint(8) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tachyforumpost
رمز PHP:
CREATE TABLE `tachyforumpost` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`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(5) unsigned NOT NULL default '0',
`lastprefixid` varchar(25) NOT NULL default '',
PRIMARY KEY (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tachythreadcounter
رمز PHP:
CREATE TABLE `tachythreadcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tachythreadpost
رمز PHP:
CREATE TABLE `tachythreadpost` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tag
رمز PHP:
CREATE TABLE `tag` (
`tagid` int(10) unsigned NOT NULL auto_increment,
`tagtext` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`canonicaltagid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`),
UNIQUE KEY `tagtext` (`tagtext`),
KEY `canonicaltagid` (`canonicaltagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
tagcontent
رمز PHP:
CREATE TABLE `tagcontent` (
`tagid` int(10) unsigned NOT NULL default '0',
`contenttypeid` int(10) unsigned NOT NULL,
`contentid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`,`contenttypeid`,`contentid`),
KEY `id_type_user` (`contentid`,`contenttypeid`,`userid`),
KEY `user` (`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tagsearch
رمز PHP:
CREATE TABLE `tagsearch` (
`tagid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `tagid` (`tagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
template
رمز PHP:
CREATE TABLE `template` (
`templateid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(6) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext,
`template_un` mediumtext,
`templatetype` enum('template','stylevar','css','replacement') NOT NULL default 'template',
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`product` varchar(25) NOT NULL default '',
`mergestatus` enum('none','merged','conflicted') NOT NULL default 'none',
PRIMARY KEY (`templateid`),
UNIQUE KEY `title` (`title`,`styleid`,`templatetype`),
KEY `styleid` (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
templatehistory
رمز PHP:
CREATE TABLE `templatehistory` (
`templatehistoryid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`templatehistoryid`),
KEY `title` (`title`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
templatemerge
رمز PHP:
CREATE TABLE `templatemerge` (
`templateid` int(10) unsigned NOT NULL default '0',
`template` mediumtext NOT NULL,
`version` varchar(30) NOT NULL default '',
`savedtemplateid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`templateid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
thread
رمز PHP:
CREATE TABLE `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`prefixid` varchar(25) NOT NULL default '',
`firstpostid` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`hiddencount` int(10) unsigned NOT NULL default '0',
`deletedcount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
`taglist` mediumtext,
`keywords` mediumtext,
PRIMARY KEY (`threadid`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
KEY `forumid_lastpost` (`forumid`,`lastpost`),
KEY `lastpost` (`lastpost`),
KEY `dateline` (`dateline`),
KEY `prefixid` (`prefixid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
threadrate رمز PHP:
CREATE TABLE `threadrate` (
`threadrateid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`threadrateid`),
KEY `threadid` (`threadid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
threadread رمز PHP:
CREATE TABLE `threadread` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
threadredirect
رمز PHP:
CREATE TABLE `threadredirect` (
`threadid` int(10) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
threadviews
رمز PHP:
CREATE TABLE `threadviews` (
`threadid` int(10) unsigned NOT NULL default '0',
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
upgradelog
رمز PHP:
CREATE TABLE `upgradelog` (
`upgradelogid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`steptitle` varchar(250) NOT NULL default '',
`step` smallint(5) unsigned NOT NULL default '0',
`startat` int(10) unsigned NOT NULL default '0',
`perpage` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`upgradelogid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
user
رمز PHP:
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` char(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` char(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` char(50) NOT NULL default '',
`homepage` char(100) NOT NULL default '',
`icq` char(20) NOT NULL default '',
`aim` char(20) NOT NULL default '',
`yahoo` char(32) NOT NULL default '',
`msn` char(100) NOT NULL default '',
`skype` char(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`usertitle` char(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` char(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '33570831',
`birthday` char(10) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` char(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(3) NOT NULL default '',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
`adminoptions` int(10) unsigned NOT NULL default '0',
`profilevisits` int(10) unsigned NOT NULL default '0',
`friendcount` int(10) unsigned NOT NULL default '0',
`friendreqcount` int(10) unsigned NOT NULL default '0',
`vmunreadcount` int(10) unsigned NOT NULL default '0',
`vmmoderatedcount` int(10) unsigned NOT NULL default '0',
`socgroupinvitecount` int(10) unsigned NOT NULL default '0',
`socgroupreqcount` int(10) unsigned NOT NULL default '0',
`pcunreadcount` int(10) unsigned NOT NULL default '0',
`pcmoderatedcount` int(10) unsigned NOT NULL default '0',
`gmmoderatedcount` int(10) unsigned NOT NULL default '0',
`assetposthash` varchar(32) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
useractivation رمز PHP:
CREATE TABLE `useractivation` (
`useractivationid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`activationid` varchar(40) NOT NULL default '',
`type` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`emailchange` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`useractivationid`),
UNIQUE KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
userban
رمز PHP:
CREATE TABLE `userban` (
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`adminid` int(10) unsigned NOT NULL default '0',
`bandate` int(10) unsigned NOT NULL default '0',
`liftdate` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `liftdate` (`liftdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
userchangelog
رمز PHP:
CREATE TABLE `userchangelog` (
`changeid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`fieldname` varchar(250) NOT NULL default '',
`newvalue` varchar(250) NOT NULL default '',
`oldvalue` varchar(250) NOT NULL default '',
`adminid` int(10) unsigned NOT NULL default '0',
`change_time` int(10) unsigned NOT NULL default '0',
`change_uniq` varchar(32) NOT NULL default '',
PRIMARY KEY (`changeid`),
KEY `userid` (`userid`,`change_time`),
KEY `change_time` (`change_time`),
KEY `change_uniq` (`change_uniq`),
KEY `fieldname` (`fieldname`,`change_time`),
KEY `adminid` (`adminid`,`change_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
usercss
رمز PHP:
CREATE TABLE `usercss` (
`userid` int(10) unsigned NOT NULL default '0',
`selector` varchar(30) NOT NULL default '',
`property` varchar(30) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`userid`,`selector`,`property`),
KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
usercsscache
رمز PHP:
CREATE TABLE `usercsscache` (
`userid` int(10) unsigned NOT NULL default '0',
`cachedcss` text,
`buildpermissions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
userfield
رمز PHP:
CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`temp` mediumtext,
`field1` mediumtext,
`field2` mediumtext,
`field3` mediumtext,
`field4` mediumtext,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
usergroup
رمز PHP:
CREATE TABLE `usergroup` (
`usergroupid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`usertitle` char(100) NOT NULL default '',
`passwordexpires` smallint(5) unsigned NOT NULL default '0',
`passwordhistory` smallint(5) unsigned NOT NULL default '0',
`pmquota` smallint(5) unsigned NOT NULL default '0',
`pmsendmax` smallint(5) unsigned NOT NULL default '5',
`opentag` char(100) NOT NULL default '',
`closetag` char(100) NOT NULL default '',
`canoverride` smallint(5) unsigned NOT NULL default '0',
`ispublicgroup` smallint(5) unsigned NOT NULL default '0',
`forumpermissions` int(10) unsigned NOT NULL default '0',
`pmpermissions` int(10) unsigned NOT NULL default '0',
`calendarpermissions` int(10) unsigned NOT NULL default '0',
`wolpermissions` int(10) unsigned NOT NULL default '0',
`adminpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions2` int(10) unsigned NOT NULL default '0',
`genericoptions` int(10) unsigned NOT NULL default '0',
`signaturepermissions` int(10) unsigned NOT NULL default '0',
`visitormessagepermissions` int(10) unsigned NOT NULL default '0',
`attachlimit` int(10) unsigned NOT NULL default '0',
`avatarmaxwidth` smallint(5) unsigned NOT NULL default '0',
`avatarmaxheight` smallint(5) unsigned NOT NULL default '0',
`avatarmaxsize` int(10) unsigned NOT NULL default '0',
`profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxheight` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxsize` int(10) unsigned NOT NULL default '0',
`sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxsize` int(10) unsigned NOT NULL default '0',
`sigmaximages` smallint(5) unsigned NOT NULL default '0',
`sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0',
`sigmaxchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxrawchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxlines` smallint(5) unsigned NOT NULL default '0',
`usercsspermissions` int(10) unsigned NOT NULL default '0',
`albumpermissions` int(10) unsigned NOT NULL default '0',
`albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxsize` int(10) unsigned NOT NULL default '0',
`albummaxpics` int(10) unsigned NOT NULL default '0',
`albummaxsize` int(10) unsigned NOT NULL default '0',
`socialgrouppermissions` int(10) unsigned NOT NULL default '0',
`pmthrottlequantity` int(10) unsigned NOT NULL default '0',
`groupiconmaxsize` int(10) unsigned NOT NULL default '0',
`maximumsocialgroups` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
ملاحظة:
يوجد في آخر كل أمر الترميز latin1 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
وبكل صراحه الموضوع اتعبني كثيراً فقد استغرق اكثر من 7 ساعات
هذي جميع الجداول في قاعدة بيانات المنتدى سكربت vBulletin في النسخه 4.0 .... ولا انصح للنسخ القديمه بإستخدام أوامر البناء ....
عند حذف جدول في قاعدة البيانات بالغلط قم بزراعت الأوامر المذكوره ادناه
يستحسن الترقيه بعد زراعه أمر بناء لتجنب المشاكل
أوامر بناء قواعد البيانات
access رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `adminutil` (
`title` varchar(50) NOT NULL default '',
`text` mediumtext,
PRIMARY KEY (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
album
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `attachmentviews` (
`attachmentid` int(10) unsigned NOT NULL default '0',
KEY `postid` (`attachmentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
avatar
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `cacheevent` (
`cacheid` varbinary(64) NOT NULL,
`event` varbinary(50) NOT NULL,
PRIMARY KEY (`cacheid`,`event`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
calendar
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `deletionlog` (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('post','thread','visitormessage','groupmessag e','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
رمز PHP:
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
رمز 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:
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:
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`,`calendar id`)
) 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:
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
رمز PHP:
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 رمز 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 '',
`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
رمز 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:
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:
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:
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
رمز 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:
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:
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:
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:
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:
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:
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:
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:
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
رمز PHP:
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
رمز 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:
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:
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:
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:
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
رمز PHP:
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
رمز PHP:
CREATE TABLE `moderation` (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessa ge','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:
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:
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:
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:
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:
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 رمز PHP:
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 رمز 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:
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:
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:
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:
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:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز 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:
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:
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:
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:
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:
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:
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:
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:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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
رمز PHP:
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 ;
رمز PHP:
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
رمز PHP:
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 ;
rsslog
رمز PHP:
CREATE TABLE `rsslog` (
`rssfeedid` int(10) unsigned NOT NULL default '0',
`itemid` int(10) unsigned NOT NULL default '0',
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`uniquehash` char(32) NOT NULL default '',
`contenthash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`threadactiontime` int(10) unsigned NOT NULL default '0',
`threadactioncomplete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`,`itemid`,`itemtype`),
UNIQUE KEY `uniquehash` (`uniquehash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
searchcore
رمز PHP:
CREATE TABLE `searchcore` (
`searchcoreid` int(10) unsigned NOT NULL auto_increment,
`contenttypeid` int(10) unsigned NOT NULL,
`primaryid` int(10) unsigned NOT NULL,
`groupcontenttypeid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL,
`ipaddress` int(10) unsigned NOT NULL,
`searchgroupid` int(10) unsigned NOT NULL,
PRIMARY KEY (`searchcoreid`),
UNIQUE KEY `contentunique` (`contenttypeid`,`primaryid`),
KEY `groupid` (`groupcontenttypeid`,`groupid`),
KEY `ipaddress` (`ipaddress`),
KEY `dateline` (`dateline`),
KEY `userid` (`userid`),
KEY `searchgroupid` (`searchgroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
searchcore_text
رمز PHP:
CREATE TABLE `searchcore_text` (
`searchcoreid` int(10) unsigned NOT NULL,
`keywordtext` mediumtext,
`title` varchar(254) NOT NULL default '',
PRIMARY KEY (`searchcoreid`),
FULLTEXT KEY `text` (`title`,`keywordtext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
searchgroup
رمز PHP:
CREATE TABLE `searchgroup` (
`searchgroupid` int(10) unsigned NOT NULL auto_increment,
`contenttypeid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL,
PRIMARY KEY (`searchgroupid`),
UNIQUE KEY `groupunique` (`contenttypeid`,`groupid`),
KEY `dateline` (`dateline`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
searchgroup_text رمز PHP:
CREATE TABLE `searchgroup_text` (
`searchgroupid` int(10) unsigned NOT NULL,
`title` varchar(254) NOT NULL,
PRIMARY KEY (`searchgroupid`),
FULLTEXT KEY `grouptitle` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
searchlog
رمز PHP:
CREATE TABLE `searchlog` (
`searchlogid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` varchar(15) NOT NULL default '',
`searchhash` varchar(32) NOT NULL,
`sortby` varchar(15) NOT NULL default '',
`sortorder` enum('asc','desc') NOT NULL default 'asc',
`searchtime` float unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '0',
`criteria` text NOT NULL,
`results` mediumblob,
PRIMARY KEY (`searchlogid`),
KEY `search` (`userid`,`searchhash`,`sortby`,`sortorder`),
KEY `userfloodcheck` (`userid`,`dateline`),
KEY `ipfloodcheck` (`ipaddress`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
session
رمز PHP:
CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` char(15) NOT NULL default '',
`idhash` char(32) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`location` char(255) NOT NULL default '',
`useragent` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` smallint(5) unsigned NOT NULL default '0',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`bypass` tinyint(4) NOT NULL default '0',
`profileupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`),
KEY `user_activity` (`userid`,`lastactivity`),
KEY `guest_lookup` (`idhash`,`host`,`userid`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;
setting
رمز PHP:
CREATE TABLE `setting` (
`varname` varchar(100) NOT NULL default '',
`grouptitle` varchar(50) NOT NULL default '',
`value` mediumtext,
`defaultvalue` mediumtext,
`optioncode` mediumtext,
`displayorder` smallint(5) unsigned NOT NULL default '0',
`advanced` smallint(6) NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`datatype` enum('free','number','boolean','bitfield','usernam e','integer','posint') NOT NULL default 'free',
`product` varchar(25) NOT NULL default '',
`validationcode` text,
`blacklist` smallint(6) NOT NULL default '0',
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
settinggroup
رمز PHP:
CREATE TABLE `settinggroup` (
`grouptitle` char(50) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`grouptitle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
sigparsed
رمز PHP:
CREATE TABLE `sigparsed` (
`userid` int(10) unsigned NOT NULL default '0',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`signatureparsed` mediumtext,
`hasimages` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`styleid`,`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
sigpic
رمز PHP:
CREATE TABLE `sigpic` (
`userid` int(10) unsigned NOT NULL default '0',
`filedata` mediumblob,
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`visible` smallint(6) NOT NULL default '1',
`filesize` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
smilie
رمز PHP:
CREATE TABLE `smilie` (
`smilieid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`smilietext` char(20) NOT NULL default '',
`smiliepath` char(100) NOT NULL default '',
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`smilieid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
socialgroup
رمز PHP:
CREATE TABLE `socialgroup` (
`groupid` int(10) unsigned NOT NULL auto_increment,
`socialgroupcategoryid` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL default '',
`description` text,
`creatoruserid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`members` int(10) unsigned NOT NULL default '0',
`picturecount` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(255) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`lastgmid` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '0',
`deleted` int(10) unsigned NOT NULL default '0',
`moderation` int(10) unsigned NOT NULL default '0',
`type` enum('public','moderated','inviteonly') NOT NULL default 'public',
`moderatedmembers` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastdiscussionid` int(10) unsigned NOT NULL default '0',
`discussions` int(10) unsigned default '0',
`lastdiscussion` varchar(255) NOT NULL default '',
`lastupdate` int(10) unsigned NOT NULL default '0',
`transferowner` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`),
KEY `creatoruserid` (`creatoruserid`),
KEY `dateline` (`dateline`),
KEY `members` (`members`),
KEY `picturecount` (`picturecount`),
KEY `visible` (`visible`),
KEY `lastpost` (`lastpost`),
KEY `socialgroupcategoryid` (`socialgroupcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
socialgroupcategory
رمز PHP:
CREATE TABLE `socialgroupcategory` (
`socialgroupcategoryid` int(10) unsigned NOT NULL auto_increment,
`creatoruserid` int(10) unsigned NOT NULL,
`title` varchar(250) NOT NULL,
`description` text NOT NULL,
`displayorder` int(10) unsigned NOT NULL,
`lastupdate` int(10) unsigned NOT NULL,
`groups` int(10) unsigned default '0',
PRIMARY KEY (`socialgroupcategoryid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
socialgroupicon
رمز PHP:
CREATE TABLE `socialgroupicon` (
`groupid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned default '0',
`filedata` mediumblob,
`extension` varchar(20) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`thumbnail_filedata` mediumblob,
`thumbnail_width` int(10) unsigned NOT NULL default '0',
`thumbnail_height` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
socialgroupmember
رمز PHP:
CREATE TABLE `socialgroupmember` (
`userid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`type` enum('member','moderated','invited') NOT NULL default 'member',
PRIMARY KEY (`groupid`,`userid`),
KEY `groupid` (`groupid`,`type`),
KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
spamlog
رمز PHP:
CREATE TABLE `spamlog` (
`postid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
stats
رمز PHP:
CREATE TABLE `stats` (
`dateline` int(10) unsigned NOT NULL default '0',
`nuser` mediumint(8) unsigned NOT NULL default '0',
`nthread` mediumint(8) unsigned NOT NULL default '0',
`npost` mediumint(8) unsigned NOT NULL default '0',
`ausers` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
strikes
رمز PHP:
CREATE TABLE `strikes` (
`striketime` int(10) unsigned NOT NULL default '0',
`strikeip` char(15) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
KEY `striketime` (`striketime`),
KEY `strikeip` (`strikeip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
style
رمز PHP:
CREATE TABLE `style` (
`styleid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`parentid` smallint(6) NOT NULL default '0',
`parentlist` varchar(250) NOT NULL default '',
`templatelist` mediumtext,
`csscolors` mediumtext,
`css` mediumtext,
`stylevars` mediumtext,
`newstylevars` mediumtext,
`replacements` mediumtext,
`editorstyles` mediumtext,
`userselect` smallint(5) unsigned NOT NULL default '1',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
stylevar
رمز PHP:
CREATE TABLE `stylevar` (
`stylevarid` varchar(250) NOT NULL,
`styleid` smallint(6) NOT NULL default '-1',
`value` mediumblob NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
UNIQUE KEY `stylevarinstance` (`stylevarid`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
stylevardfn
رمز PHP:
CREATE TABLE `stylevardfn` (
`stylevarid` varchar(250) NOT NULL,
`styleid` smallint(6) NOT NULL default '-1',
`parentid` smallint(6) NOT NULL,
`parentlist` varchar(250) NOT NULL default '0',
`stylevargroup` varchar(250) NOT NULL,
`product` varchar(25) NOT NULL default 'vbulletin',
`datatype` varchar(25) NOT NULL default 'string',
`validation` varchar(250) NOT NULL,
`failsafe` mediumblob NOT NULL,
`units` enum('','%','px','pt','em','ex','pc','in','cm','mm ') NOT NULL default '',
`uneditable` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`stylevarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
subscribediscussion
رمز PHP:
CREATE TABLE `subscribediscussion` (
`subscribediscussionid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`),
KEY `discussionid` (`discussionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribeevent
رمز PHP:
CREATE TABLE `subscribeevent` (
`subscribeeventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`lastreminder` int(10) unsigned NOT NULL default '0',
`reminder` int(10) unsigned NOT NULL default '3600',
PRIMARY KEY (`subscribeeventid`),
UNIQUE KEY `subindex` (`userid`,`eventid`),
KEY `eventid` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribeforum
رمز PHP:
CREATE TABLE `subscribeforum` (
`subscribeforumid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribeforumid`),
UNIQUE KEY `subindex` (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribegroup
رمز PHP:
CREATE TABLE `subscribegroup` (
`subscribegroupid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`emailupdate` enum('daily','weekly','none') NOT NULL default 'none',
PRIMARY KEY (`subscribegroupid`),
UNIQUE KEY `usergroup` (`userid`,`groupid`),
KEY `groupid` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscribethread
رمز PHP:
CREATE TABLE `subscribethread` (
`subscribethreadid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`emailupdate` smallint(5) unsigned NOT NULL default '0',
`folderid` int(10) unsigned NOT NULL default '0',
`canview` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`subscribethreadid`),
UNIQUE KEY `threadid` (`threadid`,`userid`),
KEY `userid` (`userid`,`folderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscription
رمز PHP:
CREATE TABLE `subscription` (
`subscriptionid` smallint(5) unsigned NOT NULL auto_increment,
`varname` varchar(100) NOT NULL default '',
`cost` mediumtext,
`forums` mediumtext,
`nusergroupid` smallint(6) NOT NULL default '0',
`membergroupids` varchar(255) NOT NULL default '',
`active` smallint(5) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
`adminoptions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscriptionlog
رمز PHP:
CREATE TABLE `subscriptionlog` (
`subscriptionlogid` mediumint(8) unsigned NOT NULL auto_increment,
`subscriptionid` smallint(6) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`pusergroupid` smallint(6) NOT NULL default '0',
`status` smallint(6) NOT NULL default '0',
`regdate` int(10) unsigned NOT NULL default '0',
`expirydate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionlogid`),
KEY `userid` (`userid`,`subscriptionid`),
KEY `subscriptionid` (`subscriptionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
subscriptionpermission رمز PHP:
CREATE TABLE `subscriptionpermission` (
`subscriptionpermissionid` int(10) unsigned NOT NULL auto_increment,
`subscriptionid` int(10) unsigned NOT NULL default '0',
`usergroupid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionpermissionid`),
UNIQUE KEY `subscriptionid` (`subscriptionid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
tachyforumcounter
رمز PHP:
CREATE TABLE `tachyforumcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`threadcount` mediumint(8) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tachyforumpost
رمز PHP:
CREATE TABLE `tachyforumpost` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`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(5) unsigned NOT NULL default '0',
`lastprefixid` varchar(25) NOT NULL default '',
PRIMARY KEY (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tachythreadcounter
رمز PHP:
CREATE TABLE `tachythreadcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tachythreadpost
رمز PHP:
CREATE TABLE `tachythreadpost` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tag
رمز PHP:
CREATE TABLE `tag` (
`tagid` int(10) unsigned NOT NULL auto_increment,
`tagtext` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`canonicaltagid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`),
UNIQUE KEY `tagtext` (`tagtext`),
KEY `canonicaltagid` (`canonicaltagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
tagcontent
رمز PHP:
CREATE TABLE `tagcontent` (
`tagid` int(10) unsigned NOT NULL default '0',
`contenttypeid` int(10) unsigned NOT NULL,
`contentid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`,`contenttypeid`,`contentid`),
KEY `id_type_user` (`contentid`,`contenttypeid`,`userid`),
KEY `user` (`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
tagsearch
رمز PHP:
CREATE TABLE `tagsearch` (
`tagid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `tagid` (`tagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
template
رمز PHP:
CREATE TABLE `template` (
`templateid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(6) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext,
`template_un` mediumtext,
`templatetype` enum('template','stylevar','css','replacement') NOT NULL default 'template',
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`product` varchar(25) NOT NULL default '',
`mergestatus` enum('none','merged','conflicted') NOT NULL default 'none',
PRIMARY KEY (`templateid`),
UNIQUE KEY `title` (`title`,`styleid`,`templatetype`),
KEY `styleid` (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
templatehistory
رمز PHP:
CREATE TABLE `templatehistory` (
`templatehistoryid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`templatehistoryid`),
KEY `title` (`title`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
templatemerge
رمز PHP:
CREATE TABLE `templatemerge` (
`templateid` int(10) unsigned NOT NULL default '0',
`template` mediumtext NOT NULL,
`version` varchar(30) NOT NULL default '',
`savedtemplateid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`templateid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
thread
رمز PHP:
CREATE TABLE `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`prefixid` varchar(25) NOT NULL default '',
`firstpostid` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`hiddencount` int(10) unsigned NOT NULL default '0',
`deletedcount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
`taglist` mediumtext,
`keywords` mediumtext,
PRIMARY KEY (`threadid`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
KEY `forumid_lastpost` (`forumid`,`lastpost`),
KEY `lastpost` (`lastpost`),
KEY `dateline` (`dateline`),
KEY `prefixid` (`prefixid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
threadrate رمز PHP:
CREATE TABLE `threadrate` (
`threadrateid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`threadrateid`),
KEY `threadid` (`threadid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
threadread رمز PHP:
CREATE TABLE `threadread` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
threadredirect
رمز PHP:
CREATE TABLE `threadredirect` (
`threadid` int(10) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
threadviews
رمز PHP:
CREATE TABLE `threadviews` (
`threadid` int(10) unsigned NOT NULL default '0',
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
upgradelog
رمز PHP:
CREATE TABLE `upgradelog` (
`upgradelogid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`steptitle` varchar(250) NOT NULL default '',
`step` smallint(5) unsigned NOT NULL default '0',
`startat` int(10) unsigned NOT NULL default '0',
`perpage` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`upgradelogid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
user
رمز PHP:
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` char(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` char(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` char(50) NOT NULL default '',
`homepage` char(100) NOT NULL default '',
`icq` char(20) NOT NULL default '',
`aim` char(20) NOT NULL default '',
`yahoo` char(32) NOT NULL default '',
`msn` char(100) NOT NULL default '',
`skype` char(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`usertitle` char(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` char(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '33570831',
`birthday` char(10) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` char(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(3) NOT NULL default '',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
`adminoptions` int(10) unsigned NOT NULL default '0',
`profilevisits` int(10) unsigned NOT NULL default '0',
`friendcount` int(10) unsigned NOT NULL default '0',
`friendreqcount` int(10) unsigned NOT NULL default '0',
`vmunreadcount` int(10) unsigned NOT NULL default '0',
`vmmoderatedcount` int(10) unsigned NOT NULL default '0',
`socgroupinvitecount` int(10) unsigned NOT NULL default '0',
`socgroupreqcount` int(10) unsigned NOT NULL default '0',
`pcunreadcount` int(10) unsigned NOT NULL default '0',
`pcmoderatedcount` int(10) unsigned NOT NULL default '0',
`gmmoderatedcount` int(10) unsigned NOT NULL default '0',
`assetposthash` varchar(32) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
useractivation رمز PHP:
CREATE TABLE `useractivation` (
`useractivationid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`activationid` varchar(40) NOT NULL default '',
`type` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`emailchange` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`useractivationid`),
UNIQUE KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
userban
رمز PHP:
CREATE TABLE `userban` (
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`adminid` int(10) unsigned NOT NULL default '0',
`bandate` int(10) unsigned NOT NULL default '0',
`liftdate` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `liftdate` (`liftdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
userchangelog
رمز PHP:
CREATE TABLE `userchangelog` (
`changeid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`fieldname` varchar(250) NOT NULL default '',
`newvalue` varchar(250) NOT NULL default '',
`oldvalue` varchar(250) NOT NULL default '',
`adminid` int(10) unsigned NOT NULL default '0',
`change_time` int(10) unsigned NOT NULL default '0',
`change_uniq` varchar(32) NOT NULL default '',
PRIMARY KEY (`changeid`),
KEY `userid` (`userid`,`change_time`),
KEY `change_time` (`change_time`),
KEY `change_uniq` (`change_uniq`),
KEY `fieldname` (`fieldname`,`change_time`),
KEY `adminid` (`adminid`,`change_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
usercss
رمز PHP:
CREATE TABLE `usercss` (
`userid` int(10) unsigned NOT NULL default '0',
`selector` varchar(30) NOT NULL default '',
`property` varchar(30) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`userid`,`selector`,`property`),
KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
usercsscache
رمز PHP:
CREATE TABLE `usercsscache` (
`userid` int(10) unsigned NOT NULL default '0',
`cachedcss` text,
`buildpermissions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
userfield
رمز PHP:
CREATE TABLE `userfield` (
`userid` int(10) unsigned NOT NULL default '0',
`temp` mediumtext,
`field1` mediumtext,
`field2` mediumtext,
`field3` mediumtext,
`field4` mediumtext,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
usergroup
رمز PHP:
CREATE TABLE `usergroup` (
`usergroupid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`usertitle` char(100) NOT NULL default '',
`passwordexpires` smallint(5) unsigned NOT NULL default '0',
`passwordhistory` smallint(5) unsigned NOT NULL default '0',
`pmquota` smallint(5) unsigned NOT NULL default '0',
`pmsendmax` smallint(5) unsigned NOT NULL default '5',
`opentag` char(100) NOT NULL default '',
`closetag` char(100) NOT NULL default '',
`canoverride` smallint(5) unsigned NOT NULL default '0',
`ispublicgroup` smallint(5) unsigned NOT NULL default '0',
`forumpermissions` int(10) unsigned NOT NULL default '0',
`pmpermissions` int(10) unsigned NOT NULL default '0',
`calendarpermissions` int(10) unsigned NOT NULL default '0',
`wolpermissions` int(10) unsigned NOT NULL default '0',
`adminpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions` int(10) unsigned NOT NULL default '0',
`genericpermissions2` int(10) unsigned NOT NULL default '0',
`genericoptions` int(10) unsigned NOT NULL default '0',
`signaturepermissions` int(10) unsigned NOT NULL default '0',
`visitormessagepermissions` int(10) unsigned NOT NULL default '0',
`attachlimit` int(10) unsigned NOT NULL default '0',
`avatarmaxwidth` smallint(5) unsigned NOT NULL default '0',
`avatarmaxheight` smallint(5) unsigned NOT NULL default '0',
`avatarmaxsize` int(10) unsigned NOT NULL default '0',
`profilepicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxheight` smallint(5) unsigned NOT NULL default '0',
`profilepicmaxsize` int(10) unsigned NOT NULL default '0',
`sigpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`sigpicmaxsize` int(10) unsigned NOT NULL default '0',
`sigmaximages` smallint(5) unsigned NOT NULL default '0',
`sigmaxsizebbcode` smallint(5) unsigned NOT NULL default '0',
`sigmaxchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxrawchars` smallint(5) unsigned NOT NULL default '0',
`sigmaxlines` smallint(5) unsigned NOT NULL default '0',
`usercsspermissions` int(10) unsigned NOT NULL default '0',
`albumpermissions` int(10) unsigned NOT NULL default '0',
`albumpicmaxwidth` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxheight` smallint(5) unsigned NOT NULL default '0',
`albumpicmaxsize` int(10) unsigned NOT NULL default '0',
`albummaxpics` int(10) unsigned NOT NULL default '0',
`albummaxsize` int(10) unsigned NOT NULL default '0',
`socialgrouppermissions` int(10) unsigned NOT NULL default '0',
`pmthrottlequantity` int(10) unsigned NOT NULL default '0',
`groupiconmaxsize` int(10) unsigned NOT NULL default '0',
`maximumsocialgroups` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
ملاحظة:
يوجد في آخر كل أمر الترميز latin1 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك