كيفكم ..
اسعد الله صباحكم ومسائكم بكل خير
اذا تبي جدول معين .. بإمكانك اختصار البحث بواسطة الضغط على
Ctrl + F ثم اكتب اسم الجدول وبيظهر لك مباشرة
اسعد الله صباحكم ومسائكم بكل خير
هذي جميع الجداول في قاعدة بيانات المنتدى سكربت vBulletin في النسخه 5 .. ولا انصح للنسخ القديمه بإستخدام أوامر البناء .. وعدد الجداول 202 وهذا الموضوع يعتبر إستكمالا لـ
زراعه الجداول المحذوفه في قاعدة البيانات SQL vb4
زراعه الجداول المحذوفه في قاعدة البيانات SQL vb3
زراعه الجداول المحذوفه في قاعدة البيانات SQL vb4
زراعه الجداول المحذوفه في قاعدة البيانات SQL vb3
اذا تبي جدول معين .. بإمكانك اختصار البحث بواسطة الضغط على
Ctrl + F ثم اكتب اسم الجدول وبيظهر لك مباشرة
access
ad
adcriteria
adminhelp
administrator
adminlog
adminmessage
adminutil
announcement
announcementread
apiclient
apilog
attach
attachmentcategory
attachmentcategoryuser
attachmentpermission
attachmenttype
attachmentviews
avatar
bbcode
bbcode_video
bookmarksite
cache
cacheevent
cacheevent_log
calendar
calendarcustomfield
calendarmoderator
calendarpermission
channel
channelprefixset
closure
contentpriority
contenttype
cpsession
cron
cronlog
customavatar
customprofile
customprofilepic
datastore
deletionlog
discussion
discussionread
editlog
event
externalcache
faq
filedata
forumpermission
gallery
groupintopic
holiday
hook
humanverify
hvanswer
hvquestion
icon
imagecategory
imagecategorypermission
indexqueue
infraction
infractionban
infractiongroup
infractionlevel
language
link
mailqueue
mapiposthash
messagefolder
moderation
moderator
moderatorlog
node
noderead
nodestatreplies
nodestats
nodevisits
nodevote
notice
noticecriteria
noticedismissed
package
page
pagetemplate
passwordhistory
paymentapi
paymentinfo
paymenttransaction
permission
photo
phrase
phrasetype
picturecomment
picturecomment_hash
picturelegacy
podcast
podcastitem
poll
polloption
pollvote
prefix
prefixpermission
prefixset
privatemessage
product
productcode
productdependency
profileblockprivacy
profilefield
profilefieldcategory
profilevisitor
ranks
reminder
report
reputation
reputationlevel
routenew
rssfeed
rsslog
screenlayout
searchlog
searchtowords_a
searchtowords_b
searchtowords_c
searchtowords_d
searchtowords_e
searchtowords_f
searchtowords_g
searchtowords_h
searchtowords_i
searchtowords_j
searchtowords_k
searchtowords_l
searchtowords_m
searchtowords_n
searchtowords_o
searchtowords_other
searchtowords_p
searchtowords_q
searchtowords_r
searchtowords_s
searchtowords_t
searchtowords_u
searchtowords_v
searchtowords_w
searchtowords_x
searchtowords_y
searchtowords_z
sentto
session
setting
settinggroup
sigparsed
sigpic
site
smilie
spamlog
stats
strikes
style
stylevar
stylevardfn
subscribediscussion
subscribeevent
subscribegroup
subscription
subscriptionlog
subscriptionpermission
tag
tagnode
tagsearch
template
templatehistory
templatemerge
text
thread_post
upgradelog
user
useractivation
userban
userchangelog
usercss
usercsscache
userfield
usergroup
usergroupleader
usergrouprequest
userlist
usernote
userpromotion
userstylevar
usertextfield
usertitle
video
videoitem
widget
widgetchannelconfig
widgetdefinition
widgetinstance
widgetuserconfig
words
ملاحظة:
يوجد في آخر كل أمر الترميز latin1 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
+
نوع التخزين الحالي في بعض الجداول هو InnoDB واذا السيرفر مايدعم InnoDB استبدلها الى MyISAM
PHP:
CREATE TABLE IF NOT EXISTS `access` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`nodeid` smallint(5) unsigned NOT NULL DEFAULT '0',
`accessmask` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`,`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1566 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`args` mediumtext,
PRIMARY KEY (`adminmessageid`),
KEY `script_action` (`script`,`action`),
KEY `varname` (`varname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `adminutil` (
`title` varchar(50) NOT NULL DEFAULT '',
`text` mediumtext,
PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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,
`nodeid` int(11) NOT NULL DEFAULT '0',
`views` int(10) unsigned NOT NULL DEFAULT '0',
`announcementoptions` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`announcementid`),
KEY `nodeid` (`nodeid`),
KEY `startdate` (`enddate`,`nodeid`,`startdate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `apiclient` (
`apiclientid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`secret` varchar(32) NOT NULL DEFAULT '',
`apiaccesstoken` varchar(32) NOT NULL DEFAULT '',
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`clienthash` varchar(32) NOT NULL DEFAULT '',
`clientname` varchar(250) NOT NULL DEFAULT '',
`clientversion` varchar(50) NOT NULL DEFAULT '',
`platformname` varchar(250) NOT NULL DEFAULT '',
`platformversion` varchar(50) NOT NULL DEFAULT '',
`uniqueid` varchar(250) NOT NULL DEFAULT '',
`initialipaddress` varchar(15) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL,
`lastactivity` int(10) unsigned NOT NULL,
PRIMARY KEY (`apiclientid`),
KEY `clienthash` (`clienthash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `apilog` (
`apilogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`apiclientid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`method` varchar(32) NOT NULL DEFAULT '',
`paramget` mediumtext,
`parampost` mediumtext,
`ipaddress` varchar(15) NOT NULL DEFAULT '',
PRIMARY KEY (`apilogid`),
KEY `apiclientid` (`apiclientid`,`method`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `attach` (
`nodeid` int(10) unsigned NOT NULL,
`filedataid` int(10) unsigned NOT NULL,
`visible` smallint(6) NOT NULL DEFAULT '1',
`counter` int(10) unsigned NOT NULL DEFAULT '0',
`posthash` varchar(32) NOT NULL DEFAULT '',
`filename` varchar(255) NOT NULL DEFAULT '',
`caption` text,
`reportthreadid` int(10) unsigned NOT NULL DEFAULT '0',
`settings` mediumtext,
KEY `attach_nodeid` (`nodeid`),
KEY `attach_filedataid` (`filedataid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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(255) 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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `attachmentviews` (
`attachmentid` int(10) unsigned NOT NULL DEFAULT '0',
KEY `postid` (`attachmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
PHP:
CREATE TABLE IF NOT EXISTS `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 '',
`utf8encode` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`bookmarksiteid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
PHP:
CREATE TABLE IF NOT EXISTS `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` mediumtext,
PRIMARY KEY (`cacheid`),
KEY `expires` (`expires`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `cacheevent` (
`cacheid` varbinary(64) NOT NULL,
`event` varbinary(50) NOT NULL,
PRIMARY KEY (`cacheid`,`event`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `cacheevent_log` (
`event` varbinary(50) NOT NULL,
`eventtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`event`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `channel` (
`nodeid` int(10) unsigned NOT NULL,
`styleid` smallint(6) NOT NULL DEFAULT '0',
`options` int(10) unsigned NOT NULL DEFAULT '1728',
`daysprune` smallint(6) NOT NULL DEFAULT '0',
`newcontentemail` text,
`defaultsortfield` varchar(50) NOT NULL DEFAULT 'lastcontent',
`defaultsortorder` enum('asc','desc') NOT NULL DEFAULT 'desc',
`imageprefix` varchar(100) NOT NULL DEFAULT '',
`guid` char(150) DEFAULT NULL,
`filedataid` int(11) DEFAULT NULL,
`category` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `channelprefixset` (
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`prefixsetid` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`nodeid`,`prefixsetid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `closure` (
`parent` int(10) unsigned NOT NULL,
`child` int(10) unsigned NOT NULL,
`depth` smallint(6) DEFAULT NULL,
`displayorder` smallint(6) NOT NULL DEFAULT '0',
`publishdate` int(11) DEFAULT NULL,
UNIQUE KEY `closure_uniq` (`parent`,`child`),
KEY `parent_2` (`parent`,`depth`,`publishdate`,`child`),
KEY `publishdate` (`publishdate`,`child`),
KEY `child` (`child`,`depth`),
KEY `displayorder` (`displayorder`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `contentpriority` (
`contenttypeid` varchar(20) NOT NULL,
`sourceid` int(10) unsigned NOT NULL,
`prioritylevel` double(2,1) unsigned NOT NULL,
PRIMARY KEY (`contenttypeid`,`sourceid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`extension` varchar(10) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `customprofile` (
`customprofileid` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) DEFAULT NULL,
`thumbnail` varchar(255) DEFAULT NULL,
`userid` int(11) NOT NULL,
`themeid` int(11) DEFAULT NULL,
`font_family` varchar(255) DEFAULT NULL,
`fontsize` varchar(20) DEFAULT NULL,
`title_text_color` varchar(20) DEFAULT NULL,
`page_background_color` varchar(20) DEFAULT NULL,
`page_background_image` varchar(255) DEFAULT NULL,
`page_background_repeat` varchar(20) DEFAULT NULL,
`module_text_color` varchar(20) DEFAULT NULL,
`module_link_color` varchar(20) DEFAULT NULL,
`module_background_color` varchar(20) DEFAULT NULL,
`module_background_image` varchar(255) DEFAULT NULL,
`module_background_repeat` varchar(20) DEFAULT NULL,
`module_border` varchar(20) DEFAULT NULL,
`content_text_color` varchar(20) DEFAULT NULL,
`content_link_color` varchar(20) DEFAULT NULL,
`content_background_color` varchar(20) DEFAULT NULL,
`content_background_image` varchar(255) DEFAULT NULL,
`content_background_repeat` varchar(20) DEFAULT NULL,
`content_border` varchar(20) DEFAULT NULL,
`button_text_color` varchar(20) DEFAULT NULL,
`button_background_color` varchar(20) DEFAULT NULL,
`button_background_image` varchar(255) DEFAULT NULL,
`button_background_repeat` varchar(20) DEFAULT NULL,
`button_border` varchar(20) DEFAULT NULL,
`moduleinactive_text_color` varchar(20) DEFAULT NULL,
`moduleinactive_link_color` varchar(20) DEFAULT NULL,
`moduleinactive_background_color` varchar(20) DEFAULT NULL,
`moduleinactive_background_image` varchar(255) DEFAULT NULL,
`moduleinactive_background_repeat` varchar(20) DEFAULT NULL,
`moduleinactive_border` varchar(20) DEFAULT NULL,
`headers_text_color` varchar(20) DEFAULT NULL,
`headers_link_color` varchar(20) DEFAULT NULL,
`headers_background_color` varchar(20) DEFAULT NULL,
`headers_background_image` varchar(255) DEFAULT NULL,
`headers_background_repeat` varchar(20) DEFAULT NULL,
`headers_border` varchar(20) DEFAULT NULL,
`page_link_color` varchar(20) DEFAULT NULL,
PRIMARY KEY (`customprofileid`),
KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `datastore` (
`title` char(50) NOT NULL DEFAULT '',
`data` mediumtext,
`unserialize` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `deletionlog` (
`primaryid` int(10) unsigned NOT NULL DEFAULT '0',
`type` enum('post','thread','visitormessage','groupmessage','picturecomment') NOT NULL DEFAULT 'post',
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`reason` varchar(125) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`postid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `event` (
`eventid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`event` mediumtext,
`title` varchar(250) NOT NULL DEFAULT '',
`allowsmilies` smallint(6) NOT NULL DEFAULT '1',
`recurring` smallint(6) NOT NULL DEFAULT '0',
`recuroption` char(6) NOT NULL DEFAULT '',
`calendarid` int(10) unsigned NOT NULL DEFAULT '0',
`customfields` mediumtext,
`visible` smallint(6) NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`utc` decimal(4,2) NOT NULL DEFAULT '0.00',
`dst` smallint(6) NOT NULL DEFAULT '1',
`dateline_from` int(10) unsigned NOT NULL DEFAULT '0',
`dateline_to` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`eventid`),
KEY `userid` (`userid`),
KEY `calendarid` (`calendarid`),
KEY `visible` (`visible`),
KEY `daterange` (`dateline_to`,`dateline_from`,`visible`,`calendarid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`publicview` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`filedataid`),
KEY `filesize` (`filesize`),
KEY `filehash` (`filehash`),
KEY `userid` (`userid`),
KEY `refcount` (`refcount`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `gallery` (
`nodeid` int(10) unsigned NOT NULL,
`caption` varchar(512) DEFAULT NULL,
PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `groupintopic` (
`userid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`nodeid` int(10) unsigned NOT NULL,
UNIQUE KEY `userid` (`userid`,`groupid`,`nodeid`),
KEY `userid_2` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `hook` (
`hookid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`product` varchar(25) NOT NULL DEFAULT 'vbulletin',
`hookname` varchar(30) NOT NULL DEFAULT '',
`title` varchar(50) NOT NULL DEFAULT '',
`active` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hookorder` tinyint(3) unsigned NOT NULL DEFAULT '10',
`template` varchar(30) NOT NULL DEFAULT '',
`arguments` text NOT NULL,
PRIMARY KEY (`hookid`),
KEY `product` (`product`,`active`,`hookorder`),
KEY `hookorder` (`hookorder`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
PHP:
CREATE TABLE IF NOT EXISTS `imagecategorypermission` (
`imagecategoryid` smallint(5) unsigned NOT NULL DEFAULT '0',
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
KEY `imagecategoryid` (`imagecategoryid`,`usergroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `infraction` (
`infractionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`infractionlevelid` int(10) unsigned NOT NULL DEFAULT '0',
`nodeid` 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',
`channelid` 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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
PHP:
CREATE TABLE IF NOT EXISTS `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_hooks` 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,
`phrasegroup_vb5blog` mediumtext,
`phrasegroup_navbarlinks` mediumtext NOT NULL,
PRIMARY KEY (`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `link` (
`nodeid` int(10) unsigned NOT NULL,
`filedataid` int(10) unsigned NOT NULL DEFAULT '0',
`url` varchar(255) DEFAULT NULL,
`url_title` varchar(255) DEFAULT NULL,
`meta` mediumtext,
PRIMARY KEY (`nodeid`),
KEY `filedataid` (`filedataid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `mapiposthash` (
`posthashid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`posthash` varchar(32) NOT NULL DEFAULT '',
`filedataid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`posthashid`),
KEY `posthash` (`posthash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `messagefolder` (
`folderid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL,
`title` varchar(512) DEFAULT NULL,
`titlephrase` varchar(250) DEFAULT NULL,
PRIMARY KEY (`folderid`),
KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `moderation` (
`primaryid` int(10) unsigned NOT NULL DEFAULT '0',
`type` enum('thread','reply','visitormessage','groupmessage','picturecomment') NOT NULL DEFAULT 'thread',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `moderator` (
`moderatorid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`nodeid` 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`,`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`action` varchar(250) NOT NULL DEFAULT '',
`type` smallint(5) unsigned NOT NULL DEFAULT '0',
`nodetitle` 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 `nodeid` (`nodeid`),
KEY `product` (`product`),
KEY `id1` (`id1`),
KEY `id2` (`id2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `node` (
`nodeid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`routeid` int(10) unsigned NOT NULL,
`contenttypeid` smallint(6) NOT NULL,
`publishdate` int(11) DEFAULT NULL,
`unpublishdate` int(11) DEFAULT NULL,
`userid` int(10) unsigned DEFAULT NULL,
`groupid` int(10) unsigned DEFAULT NULL,
`authorname` varchar(100) DEFAULT NULL,
`description` varchar(1024) DEFAULT NULL,
`keywords` varchar(1024) DEFAULT NULL,
`title` varchar(512) DEFAULT NULL,
`htmltitle` varchar(512) DEFAULT NULL,
`parentid` int(11) NOT NULL,
`urlident` varchar(512) DEFAULT NULL,
`displayorder` smallint(6) DEFAULT NULL,
`starter` int(11) NOT NULL DEFAULT '0',
`created` int(11) DEFAULT NULL,
`lastcontent` int(11) NOT NULL DEFAULT '0',
`lastcontentid` int(11) NOT NULL DEFAULT '0',
`lastcontentauthor` varchar(100) NOT NULL DEFAULT '',
`lastauthorid` int(10) unsigned NOT NULL DEFAULT '0',
`lastprefixid` varchar(25) NOT NULL DEFAULT '',
`textcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
`textunpubcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
`totalcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
`totalunpubcount` mediumint(8) unsigned NOT NULL DEFAULT '0',
`ipaddress` char(15) NOT NULL DEFAULT '',
`showpublished` smallint(5) unsigned NOT NULL DEFAULT '0',
`oldid` int(10) unsigned DEFAULT NULL,
`oldcontenttypeid` int(10) unsigned DEFAULT NULL,
`nextupdate` int(11) DEFAULT NULL,
`lastupdate` int(11) DEFAULT NULL,
`featured` smallint(6) NOT NULL DEFAULT '0',
`CRC32` varchar(10) NOT NULL DEFAULT '',
`taglist` mediumtext,
`inlist` smallint(5) unsigned NOT NULL DEFAULT '1',
`protected` smallint(5) unsigned NOT NULL DEFAULT '0',
`setfor` int(11) NOT NULL DEFAULT '0',
`votes` smallint(5) unsigned NOT NULL DEFAULT '0',
`hasphoto` smallint(6) NOT NULL DEFAULT '0',
`hasvideo` smallint(6) NOT NULL DEFAULT '0',
`deleteuserid` int(10) unsigned DEFAULT NULL,
`deletereason` varchar(125) DEFAULT NULL,
`open` smallint(6) NOT NULL DEFAULT '1',
`showopen` smallint(6) NOT NULL DEFAULT '1',
`sticky` tinyint(1) NOT NULL DEFAULT '0',
`approved` tinyint(1) NOT NULL DEFAULT '1',
`showapproved` tinyint(1) NOT NULL DEFAULT '1',
`viewperms` tinyint(4) NOT NULL DEFAULT '2',
`commentperms` tinyint(4) NOT NULL DEFAULT '1',
`hasowner` tinyint(1) NOT NULL DEFAULT '0',
`nodeoptions` smallint(5) unsigned NOT NULL DEFAULT '138',
`prefixid` varchar(25) NOT NULL DEFAULT '',
`iconid` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`nodeid`),
KEY `node_lastauthorid` (`lastauthorid`),
KEY `node_lastcontent` (`lastcontent`),
KEY `node_textcount` (`textcount`),
KEY `node_ip` (`ipaddress`),
KEY `node_pubdate` (`publishdate`,`nodeid`),
KEY `node_parent` (`parentid`),
KEY `node_nextupdate` (`nextupdate`),
KEY `node_lastupdate` (`lastupdate`),
KEY `node_user` (`userid`),
KEY `node_oldinfo` (`oldcontenttypeid`,`oldid`),
KEY `node_urlident` (`urlident`),
KEY `node_sticky` (`sticky`),
KEY `node_starter` (`starter`),
KEY `node_approved` (`approved`),
KEY `node_showapproved` (`showapproved`),
KEY `node_ctypid_userid_dispo_idx` (`contenttypeid`,`userid`,`displayorder`),
KEY `node_setfor_pubdt_idx` (`setfor`,`publishdate`),
KEY `prefixid` (`prefixid`,`nodeid`),
KEY `nodeid` (`nodeid`,`contenttypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
PHP:
CREATE TABLE IF NOT EXISTS `noderead` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`readtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`,`nodeid`),
KEY `readtime` (`readtime`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `nodestatreplies` (
`nodeid` int(10) unsigned NOT NULL,
`replies` int(10) unsigned NOT NULL,
PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `nodestats` (
`nodestatsid` int(10) NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL,
`replies` int(10) unsigned NOT NULL,
`visitors` int(10) unsigned NOT NULL,
PRIMARY KEY (`nodestatsid`),
UNIQUE KEY `nodeid` (`nodeid`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `nodevisits` (
`nodevisitid` int(10) NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL,
`visitorid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL,
`totalcount` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`nodevisitid`),
UNIQUE KEY `nodeid` (`nodeid`,`visitorid`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `nodevote` (
`nodevoteid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`userid` int(10) unsigned DEFAULT NULL,
`votedate` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`nodevoteid`),
UNIQUE KEY `nodeid` (`nodeid`,`userid`),
KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `page` (
`pageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parentid` int(10) unsigned NOT NULL,
`pagetemplateid` int(10) unsigned NOT NULL,
`title` varchar(200) NOT NULL,
`metakeywords` varchar(200) NOT NULL,
`metadescription` varchar(200) NOT NULL,
`routeid` int(10) unsigned NOT NULL,
`moderatorid` int(10) unsigned NOT NULL,
`displayorder` int(11) NOT NULL,
`pagetype` enum('default','custom') NOT NULL DEFAULT 'custom',
`guid` char(150) DEFAULT NULL,
PRIMARY KEY (`pageid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
PHP:
CREATE TABLE IF NOT EXISTS `pagetemplate` (
`pagetemplateid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`screenlayoutid` int(10) unsigned NOT NULL,
`content` text NOT NULL,
`guid` char(150) DEFAULT NULL,
PRIMARY KEY (`pagetemplateid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `permission` (
`permissionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`forumpermissions` int(10) unsigned NOT NULL DEFAULT '0',
`moderatorpermissions` int(10) unsigned NOT NULL DEFAULT '0',
`createpermissions` int(10) unsigned NOT NULL DEFAULT '0',
`edit_time` int(10) unsigned NOT NULL DEFAULT '0',
`require_moderate` smallint(5) unsigned NOT NULL DEFAULT '0',
`maxtags` smallint(5) unsigned NOT NULL DEFAULT '0',
`maxstartertags` smallint(5) unsigned NOT NULL DEFAULT '0',
`maxothertags` smallint(5) unsigned NOT NULL DEFAULT '0',
`maxattachments` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`permissionid`),
UNIQUE KEY `perm_group_node` (`groupid`,`nodeid`),
KEY `perm_nodeid` (`nodeid`),
KEY `perm_groupid` (`groupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=57 ;
PHP:
CREATE TABLE IF NOT EXISTS `photo` (
`nodeid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filedataid` int(10) unsigned NOT NULL,
`caption` varchar(512) DEFAULT NULL,
`height` smallint(5) unsigned NOT NULL DEFAULT '0',
`width` smallint(5) unsigned NOT NULL DEFAULT '0',
`style` varchar(512) DEFAULT NULL,
PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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`),
KEY `languageid` (`languageid`,`fieldname`),
FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14289 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `poll` (
`nodeid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`options` text,
`active` smallint(6) NOT NULL DEFAULT '1',
`numberoptions` smallint(5) unsigned NOT NULL DEFAULT '0',
`timeout` int(10) unsigned NOT NULL DEFAULT '0',
`multiple` smallint(5) unsigned NOT NULL DEFAULT '0',
`votes` smallint(5) unsigned NOT NULL DEFAULT '0',
`public` smallint(6) NOT NULL DEFAULT '0',
`lastvote` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `polloption` (
`polloptionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`title` text,
`votes` int(10) unsigned NOT NULL DEFAULT '0',
`voters` text,
PRIMARY KEY (`polloptionid`),
KEY `nodeid` (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `pollvote` (
`pollvoteid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL DEFAULT '0',
`pollid` int(10) unsigned NOT NULL DEFAULT '0',
`polloptionid` 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 DEFAULT '0',
PRIMARY KEY (`pollvoteid`),
UNIQUE KEY `nodeid` (`nodeid`,`userid`,`polloptionid`),
KEY `polloptionid` (`polloptionid`),
KEY `pollid` (`pollid`,`voteoption`),
KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `prefixpermission` (
`prefixid` varchar(25) NOT NULL DEFAULT '',
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
KEY `prefixsetid` (`prefixid`,`usergroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `prefixset` (
`prefixsetid` varchar(25) NOT NULL DEFAULT '',
`displayorder` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`prefixsetid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `privatemessage` (
`nodeid` int(10) unsigned NOT NULL,
`msgtype` enum('message','notification','request') NOT NULL DEFAULT 'message',
`about` enum('vote','vote_reply','rate','reply','follow','following','vm','comment','threadcomment','moderate','owner_to','moderator_to','owner_from','moderator','member','member_to','subscriber_to','subscriber','sg_owner_to','sg_moderator_to','sg_owner_from','sg_moderator','sg_subscriber','sg_subscriber_to','sg_member','sg_member_to') DEFAULT NULL,
`aboutid` int(11) DEFAULT NULL,
`deleted` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`nodeid`),
KEY `deleted` (`deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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`),
KEY `active` (`active`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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` smallint(5) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`visitorid`,`userid`),
KEY `userid` (`userid`,`visible`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `report` (
`nodeid` int(10) unsigned NOT NULL,
`reportnodeid` int(10) unsigned NOT NULL DEFAULT '0',
`closed` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`nodeid`),
KEY `reportnodeid` (`reportnodeid`,`closed`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `reputation` (
`reputationid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nodeid` 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_nodeid` (`whoadded`,`nodeid`),
KEY `userid` (`userid`),
KEY `multi` (`nodeid`,`userid`),
KEY `dateline` (`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `reputationlevel` (
`reputationlevelid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`minimumreputation` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`reputationlevelid`),
KEY `reputationlevel` (`minimumreputation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
PHP:
CREATE TABLE IF NOT EXISTS `routenew` (
`routeid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`redirect301` int(10) unsigned DEFAULT NULL,
`prefix` varchar(200) NOT NULL,
`regex` varchar(200) NOT NULL,
`class` varchar(100) DEFAULT NULL,
`controller` varchar(100) NOT NULL,
`action` varchar(100) NOT NULL,
`template` varchar(100) NOT NULL,
`arguments` mediumtext NOT NULL,
`contentid` int(10) unsigned NOT NULL,
`guid` char(150) DEFAULT NULL,
PRIMARY KEY (`routeid`),
UNIQUE KEY `regex` (`regex`),
KEY `prefix` (`prefix`),
KEY `route_name` (`name`),
KEY `route_class_cid` (`class`,`contentid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`nodeid` 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('topic','announcement') NOT NULL DEFAULT 'topic',
`topicactiondelay` 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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `rsslog` (
`rssfeedid` int(10) unsigned NOT NULL DEFAULT '0',
`itemid` int(10) unsigned NOT NULL DEFAULT '0',
`itemtype` enum('topic','announcement') NOT NULL DEFAULT 'topic',
`uniquehash` char(32) NOT NULL DEFAULT '',
`contenthash` char(32) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`topicactiontime` int(10) unsigned NOT NULL DEFAULT '0',
`topicactioncomplete` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`rssfeedid`,`itemid`,`itemtype`),
UNIQUE KEY `uniquehash` (`uniquehash`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `screenlayout` (
`screenlayoutid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`varname` varchar(20) NOT NULL,
`title` varchar(200) NOT NULL,
`displayorder` smallint(5) unsigned NOT NULL,
`columncount` tinyint(3) unsigned NOT NULL,
`template` varchar(200) NOT NULL,
`admintemplate` varchar(200) NOT NULL,
PRIMARY KEY (`screenlayoutid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
PHP:
CREATE TABLE IF NOT EXISTS `searchlog` (
`searchlogid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` smallint(5) unsigned NOT NULL DEFAULT '0',
`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',
`json` text NOT NULL,
`results` mediumblob,
`results_count` int(11) NOT NULL,
PRIMARY KEY (`searchlogid`),
KEY `search` (`userid`,`searchhash`,`sortby`,`sortorder`),
KEY `userfloodcheck` (`userid`,`dateline`),
KEY `ipfloodcheck` (`ipaddress`,`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_a` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_b` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_c` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_d` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_e` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_f` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_g` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_h` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_i` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_j` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_k` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_l` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_m` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_n` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_o` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_other` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_p` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_q` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_r` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_s` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_t` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_u` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_v` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_w` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_x` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_y` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `searchtowords_z` (
`wordid` int(11) NOT NULL,
`nodeid` int(11) NOT NULL,
`is_title` tinyint(1) NOT NULL DEFAULT '0',
`score` int(11) NOT NULL DEFAULT '0',
`position` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `wordid` (`wordid`,`nodeid`),
UNIQUE KEY `nodeid` (`nodeid`,`wordid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `sentto` (
`nodeid` int(11) NOT NULL,
`userid` int(11) NOT NULL,
`folderid` int(11) NOT NULL,
`deleted` smallint(6) NOT NULL DEFAULT '0',
`msgread` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`nodeid`,`userid`,`folderid`),
KEY `nodeid` (`nodeid`),
KEY `userid` (`userid`),
KEY `folderid` (`folderid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`apiclientid` int(10) unsigned NOT NULL DEFAULT '0',
`apiaccesstoken` varchar(32) NOT NULL DEFAULT '',
`wol` char(255) NOT NULL DEFAULT '',
`pagekey` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`sessionhash`),
KEY `last_activity` (`lastactivity`) USING BTREE,
KEY `user_activity` (`userid`,`lastactivity`) USING BTREE,
KEY `guest_lookup` (`idhash`,`host`,`userid`),
KEY `apiaccesstoken` (`apiaccesstoken`),
KEY `pagekey` (`pagekey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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','username','integer','posint') NOT NULL DEFAULT 'free',
`product` varchar(25) NOT NULL DEFAULT '',
`validationcode` text,
`blacklist` smallint(6) NOT NULL DEFAULT '0',
`ispublic` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`varname`),
KEY `ispublic` (`ispublic`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `site` (
`siteid` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`headernavbar` mediumtext,
`footernavbar` mediumtext,
PRIMARY KEY (`siteid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
PHP:
CREATE TABLE IF NOT EXISTS `spamlog` (
`postid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`postid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `strikes` (
`striketime` int(10) unsigned NOT NULL DEFAULT '0',
`strikeip` char(39) NOT NULL DEFAULT '',
`ip_4` int(10) unsigned NOT NULL DEFAULT '0',
`ip_3` int(10) unsigned NOT NULL DEFAULT '0',
`ip_2` int(10) unsigned NOT NULL DEFAULT '0',
`ip_1` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
KEY `striketime` (`striketime`),
KEY `strikeip` (`strikeip`),
KEY `ip` (`ip_4`,`ip_3`,`ip_2`,`ip_1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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,
`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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`oldid` int(10) unsigned DEFAULT NULL,
`oldtypeid` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`,`oldtypeid`),
KEY `discussionid` (`discussionid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `tagnode` (
`tagid` int(10) unsigned NOT NULL DEFAULT '0',
`nodeid` 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`,`nodeid`),
KEY `id_type_user` (`nodeid`,`userid`),
KEY `id_type_node` (`nodeid`),
KEY `id_type_tag` (`tagid`),
KEY `user` (`userid`),
KEY `dateline` (`dateline`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `tagsearch` (
`tagid` int(10) unsigned NOT NULL DEFAULT '0',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
KEY `tagid` (`tagid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=338 ;
PHP:
CREATE TABLE IF NOT EXISTS `templatehistory` (
`templatehistoryid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`styleid` smallint(6) 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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `text` (
`nodeid` int(10) unsigned NOT NULL,
`previewtext` varchar(2048) DEFAULT NULL,
`previewimage` varchar(256) DEFAULT NULL,
`previewvideo` text,
`imageheight` smallint(6) DEFAULT NULL,
`imagewidth` smallint(6) DEFAULT NULL,
`rawtext` mediumtext,
`pagetextimages` text,
`moderated` smallint(6) DEFAULT NULL,
`pagetext` mediumtext,
`htmlstate` enum('off','on','on_nl2br') DEFAULT NULL,
`allowsmilie` smallint(6) NOT NULL DEFAULT '0',
`showsignature` smallint(6) NOT NULL DEFAULT '0',
`attach` smallint(5) unsigned NOT NULL DEFAULT '0',
`infraction` smallint(5) unsigned NOT NULL DEFAULT '0',
`reportnodeid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `thread_post` (
`nodeid` int(10) unsigned NOT NULL,
`threadid` int(10) unsigned NOT NULL,
`postid` int(10) unsigned NOT NULL,
PRIMARY KEY (`nodeid`),
UNIQUE KEY `thread_post` (`threadid`,`postid`),
KEY `threadid` (`threadid`),
KEY `postid` (`postid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`only` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`upgradelogid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
PHP:
CREATE TABLE IF NOT EXISTS `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 '',
`google` char(32) NOT NULL DEFAULT '',
`status` mediumtext,
`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',
`privacy_options` mediumtext,
`notification_options` int(10) unsigned NOT NULL DEFAULT '134217722',
`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 '0',
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
`salt` char(30) 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 '',
`fbuserid` varchar(255) NOT NULL DEFAULT '',
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) NOT NULL DEFAULT '',
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`fbaccesstoken` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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 '',
`ipaddress` int(10) unsigned NOT NULL DEFAULT '0',
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=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `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=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `usercsscache` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`cachedcss` text,
`buildpermissions` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `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;
PHP:
CREATE TABLE IF NOT EXISTS `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',
`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',
`systemgroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`usergroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
PHP:
CREATE TABLE IF NOT EXISTS `usergroupleader` (
`usergroupleaderid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`usergroupleaderid`),
KEY `ugl` (`userid`,`usergroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `usergrouprequest` (
`usergrouprequestid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`reason` varchar(250) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`usergrouprequestid`),
UNIQUE KEY `userid` (`userid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `userlist` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`relationid` int(10) unsigned NOT NULL DEFAULT '0',
`type` enum('buddy','ignore','follow') NOT NULL DEFAULT 'buddy',
`friend` enum('yes','no','pending','denied') NOT NULL DEFAULT 'no',
PRIMARY KEY (`userid`,`relationid`,`type`),
KEY `relationid` (`relationid`,`type`,`friend`),
KEY `userid` (`userid`,`type`,`friend`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `usernote` (
`usernoteid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`posterid` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`message` mediumtext,
`title` varchar(255) NOT NULL DEFAULT '',
`allowsmilies` smallint(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`usernoteid`),
KEY `userid` (`userid`),
KEY `posterid` (`posterid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `userpromotion` (
`userpromotionid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` int(10) unsigned NOT NULL DEFAULT '0',
`joinusergroupid` int(10) unsigned NOT NULL DEFAULT '0',
`reputation` int(11) NOT NULL DEFAULT '0',
`date` int(10) unsigned NOT NULL DEFAULT '0',
`posts` int(10) unsigned NOT NULL DEFAULT '0',
`strategy` smallint(6) NOT NULL DEFAULT '0',
`type` smallint(6) NOT NULL DEFAULT '2',
PRIMARY KEY (`userpromotionid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `userstylevar` (
`stylevarid` varchar(250) NOT NULL,
`userid` int(10) NOT NULL DEFAULT '-1',
`value` mediumblob NOT NULL,
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `stylevarinstance` (`stylevarid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `usertextfield` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`subfolders` mediumtext,
`pmfolders` mediumtext,
`buddylist` mediumtext,
`ignorelist` mediumtext,
`signature` mediumtext,
`searchprefs` mediumtext,
`rank` mediumtext,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `usertitle` (
`usertitleid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`minposts` int(10) unsigned NOT NULL DEFAULT '0',
`title` char(250) NOT NULL DEFAULT '',
PRIMARY KEY (`usertitleid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
PHP:
CREATE TABLE IF NOT EXISTS `video` (
`nodeid` int(10) unsigned NOT NULL,
PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `videoitem` (
`videoitemid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nodeid` int(10) unsigned NOT NULL,
`provider` varchar(255) DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`videoitemid`),
KEY `nodeid` (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
PHP:
CREATE TABLE IF NOT EXISTS `widget` (
`widgetid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`template` varchar(200) NOT NULL,
`admintemplate` varchar(200) NOT NULL,
`icon` varchar(200) NOT NULL,
`isthirdparty` tinyint(3) unsigned NOT NULL,
`category` varchar(100) NOT NULL DEFAULT 'uncategorized',
`cloneable` tinyint(3) unsigned NOT NULL DEFAULT '1',
`canbemultiple` tinyint(3) unsigned NOT NULL DEFAULT '1',
`product` varchar(25) NOT NULL DEFAULT 'vbulletin',
`guid` char(150) DEFAULT NULL,
PRIMARY KEY (`widgetid`),
KEY `product` (`product`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;
PHP:
CREATE TABLE IF NOT EXISTS `widgetchannelconfig` (
`widgetinstanceid` int(10) unsigned NOT NULL,
`nodeid` int(10) unsigned NOT NULL,
`channelconfig` blob NOT NULL,
UNIQUE KEY `widgetinstanceid` (`widgetinstanceid`,`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `widgetdefinition` (
`widgetid` int(10) unsigned NOT NULL,
`field` varchar(50) NOT NULL,
`name` varchar(50) NOT NULL,
`label` varchar(200) NOT NULL,
`defaultvalue` blob NOT NULL,
`isusereditable` tinyint(4) NOT NULL DEFAULT '1',
`isrequired` tinyint(4) NOT NULL DEFAULT '0',
`displayorder` smallint(6) NOT NULL,
`validationtype` enum('force_datatype','regex','method') NOT NULL,
`validationmethod` varchar(200) NOT NULL,
`product` varchar(25) NOT NULL DEFAULT 'vbulletin',
`data` text NOT NULL,
KEY `widgetid` (`widgetid`),
KEY `product` (`product`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `widgetinstance` (
`widgetinstanceid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`parent` int(10) unsigned NOT NULL DEFAULT '0',
`pagetemplateid` int(10) unsigned NOT NULL,
`widgetid` int(10) unsigned NOT NULL,
`displaysection` tinyint(3) unsigned NOT NULL,
`displayorder` smallint(5) unsigned NOT NULL,
`adminconfig` blob NOT NULL,
PRIMARY KEY (`widgetinstanceid`),
KEY `pagetemplateid` (`pagetemplateid`,`widgetid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=87 ;
PHP:
CREATE TABLE IF NOT EXISTS `widgetuserconfig` (
`widgetinstanceid` int(10) unsigned NOT NULL,
`userid` int(10) unsigned NOT NULL,
`userconfig` blob NOT NULL,
UNIQUE KEY `widgetinstanceid` (`widgetinstanceid`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
PHP:
CREATE TABLE IF NOT EXISTS `words` (
`wordid` int(11) NOT NULL AUTO_INCREMENT,
`word` varchar(50) NOT NULL,
PRIMARY KEY (`wordid`),
UNIQUE KEY `word` (`word`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
يوجد في آخر كل أمر الترميز latin1 اذا كان الترميز لديك يختلف عن المذكور قم بتغييره الى الترميز الإفتراضي لديك
+
نوع التخزين الحالي في بعض الجداول هو InnoDB واذا السيرفر مايدعم InnoDB استبدلها الى MyISAM
كذا انتهينا من الموضوع والحمد لله ،،
نقلا عن الاخ GENX2