[درس] شرح + جميع الجداول المحذوفه في قاعدة البيانات SQL vb5

Linuxawy.G

:: مشرف عام ::
15 يونيو 2010
259
1
0
كيفكم ..

اسعد الله صباحكم ومسائكم بكل خير


هذي جميع الجداول في قاعدة بيانات المنتدى سكربت vBulletin في النسخه 5 .. ولا انصح للنسخ القديمه بإستخدام أوامر البناء .. وعدد الجداول 202 وهذا الموضوع يعتبر إستكمالا لـ

زراعه الجداول المحذوفه في قاعدة البيانات SQL vb4
زراعه الجداول المحذوفه في قاعدة البيانات SQL vb3​


اذا تبي جدول معين .. بإمكانك اختصار البحث بواسطة الضغط على
Ctrl + F ثم اكتب اسم الجدول وبيظهر لك مباشرة


access

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;
ad

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 ;
adcriteria

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;
adminhelp

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 ;
administrator

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;
adminlog

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 ;
adminmessage

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 ;
adminutil

PHP:
CREATE TABLE IF NOT EXISTS `adminutil` (
  `title` varchar(50) NOT NULL DEFAULT '',
  `text` mediumtext,
  PRIMARY KEY (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
announcement

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 ;
announcementread

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;
apiclient

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 ;
apilog

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 ;
attach

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;
attachmentcategory

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 ;
attachmentcategoryuser

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;
attachmentpermission

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 ;
attachmenttype

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;
attachmentviews

PHP:
CREATE TABLE IF NOT EXISTS `attachmentviews` (
  `attachmentid` int(10) unsigned NOT NULL DEFAULT '0',
  KEY `postid` (`attachmentid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
avatar

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 ;
bbcode

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 ;
bbcode_video

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 ;
bookmarksite

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 ;
cache

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;
cacheevent

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;
cacheevent_log

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;
calendar

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 ;
calendarcustomfield

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 ;
calendarmoderator

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 ;
calendarpermission

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 ;
channel

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;
channelprefixset

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;
closure

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;
contentpriority

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;
contenttype

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 ;
cpsession

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;
cron

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 ;
cronlog

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 ;
customavatar

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;
customprofile

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 ;
customprofilepic

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;
datastore

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;
deletionlog

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;
discussion

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 ;
discussionread

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;
editlog

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;
event

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 ;
externalcache

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;
faq

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;
filedata

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 ;
forumpermission

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 ;
gallery

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;
groupintopic

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;
holiday

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 ;
hook

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 ;
humanverify

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;
hvanswer

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 ;
hvquestion

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 ;
icon

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 ;
imagecategory

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 ;
imagecategorypermission

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;
indexqueue

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 ;
infraction

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 ;
infractionban

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 ;
infractiongroup

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 ;
infractionlevel

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 ;
language

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 ;
link

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;
mailqueue

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 ;
mapiposthash

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 ;
messagefolder

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 ;
moderation

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;
moderator

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 ;
moderatorlog

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 ;
node

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 ;
noderead

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;
nodestatreplies

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;
nodestats

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 ;
nodevisits


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 ;
nodevote

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 ;
notice

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 ;
noticecriteria

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;
noticedismissed

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;
package

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 ;
page

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 ;
pagetemplate

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 ;
passwordhistory

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;
paymentapi

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 ;
paymentinfo

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 ;
paymenttransaction

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 ;
permission

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 ;
photo

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 ;
phrase

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 ;
phrasetype

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;
picturecomment

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 ;
picturecomment_hash

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;
picturelegacy

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;
podcast

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;
podcastitem

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;
poll

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 ;
polloption

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 ;
pollvote

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 ;
prefix

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;
prefixpermission

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;
prefixset

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;
privatemessage

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;
product

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;
productcode

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 ;
productdependency

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 ;
profileblockprivacy

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;
profilefield

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 ;
profilefieldcategory

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 ;
profilevisitor


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;
ranks

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 ;
reminder

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 ;
report

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;
reputation

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 ;
reputationlevel

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 ;
routenew

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 ;
rssfeed

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 ;
rsslog

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;
screenlayout

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 ;
searchlog

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 ;
searchtowords_a

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;
searchtowords_b

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;
searchtowords_c

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;
searchtowords_d

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;
searchtowords_e

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;
searchtowords_f

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;
searchtowords_g

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;
searchtowords_h

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;
searchtowords_i

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;
searchtowords_j

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;
searchtowords_k

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;
searchtowords_l

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;
searchtowords_m

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;
searchtowords_n

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;
searchtowords_o

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;
searchtowords_other

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;
searchtowords_p

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;
searchtowords_q

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;
searchtowords_r

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;
searchtowords_s

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;
searchtowords_t

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;
searchtowords_u

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;
searchtowords_v

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;
searchtowords_w

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;
searchtowords_x

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;
searchtowords_y

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;
searchtowords_z

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;
sentto

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;
session

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;
setting

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;
settinggroup

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;
sigparsed

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;
sigpic

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;
site

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 ;
smilie

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 ;
spamlog

PHP:
CREATE TABLE IF NOT EXISTS `spamlog` (
  `postid` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`postid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
stats

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;
strikes

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;
style

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 ;
stylevar

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;
stylevardfn

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;
subscribediscussion

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 ;
subscribeevent

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 ;
subscribegroup

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 ;
subscription

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 ;
subscriptionlog

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 ;
subscriptionpermission

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 ;
tag

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 ;
tagnode

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;
tagsearch

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;
template

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 ;
templatehistory

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 ;
templatemerge

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;
text

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;
thread_post

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;
upgradelog

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 ;
user

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 ;
useractivation

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 ;
userban

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;
userchangelog

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 ;
usercss

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;
usercsscache

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;
userfield

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;
usergroup

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 ;
usergroupleader

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 ;
usergrouprequest

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 ;
userlist

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;
usernote

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 ;
userpromotion

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 ;
userstylevar

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;
usertextfield

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;
usertitle

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 ;
video

PHP:
CREATE TABLE IF NOT EXISTS `video` (
  `nodeid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`nodeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
videoitem

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 ;
widget

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 ;
widgetchannelconfig

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;
widgetdefinition

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;
widgetinstance

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 ;
widgetuserconfig

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;
words

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





 

web4ar.com

عضو جديد
6 مارس 2013
27
0
0
33
جزاك الله كل خير مشكورررر