المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : جميع جداول قواعد بيانات الجيل الثالث لزراعتها ان كانت مفقوده ..


مدهش
2011-10-03, 03:26 AM
بسم الله الرحمن الرحيم

نقدم لكم اهم الجداول المحذوفه من قواعد البيانات للجيل الثالث

هذه جميع الجداول الموجوده في قواعد البيانات للجيل الثالت 3.8 وبعضها ل 3.7 ولا انصح بان يستخدمها احد للنسخ القديمه وهذه نستخدمها اذا قمنا بحذف جدول بلخطا فنجده هنا بإذن الله ونقوم بزراعته من جديد في قاعده البيانات
عدد الجداول 158 جدول

وعند زراعه اي امر بناء انصح بلترقيه لتجنب عدم حدوث مشاكل



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



access

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


adminhelp



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


administrator



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


adminlog



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


adminmessage




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


adminutil



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


album



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


albumpicture



CREATE TABLE `albumpicture` (
`albumid` int(10) unsigned NOT NULL default '0',
`pictureid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`albumid`,`pictureid`),
KEY `albumid` (`albumid`,`dateline`),
KEY `pictureid` (`pictureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


albumupdate



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


announcement


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


announcementread




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


attachment



CREATE TABLE `attachment` (
`attachmentid` int(10) unsigned NOT NULL auto_increment,
`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',
`filename` varchar(100) NOT NULL default '',
`filedata` mediumblob,
`visible` smallint(5) unsigned NOT NULL default '0',
`counter` int(10) unsigned NOT NULL default '0',
`filesize` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`filehash` char(32) NOT NULL default '',
`posthash` 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 '',
PRIMARY KEY (`attachmentid`),
KEY `filesize` (`filesize`),
KEY `filehash` (`filehash`),
KEY `userid` (`userid`),
KEY `posthash` (`posthash`,`userid`),
KEY `postid` (`postid`),
KEY `visible` (`visible`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


attachmentpermission



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


attachmenttype



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


attachmentviews




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


avatar



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


bbcode




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


bookmarksite



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


calendar



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


calendarcustomfield



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


calendarmoderator



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


calendarpermission



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


cpsession

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


cron



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


cronlog



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


customavatar



CREATE TABLE `customavatar` (
`userid` int(10) unsigned NOT NULL default '0',
`filedata` mediumblob,
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`visible` smallint(6) NOT NULL default '1',
`filesize` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
`filedata_thumb` mediumblob,
`width_thumb` int(10) unsigned NOT NULL default '0',
`height_thumb` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


customprofilepic



CREATE TABLE `customprofilepic` (
`userid` int(10) unsigned NOT NULL default '0',
`filedata` mediumblob,
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`visible` smallint(6) NOT NULL default '1',
`filesize` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


datastore



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


deletionlog



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


discussion



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


discussionread



CREATE TABLE `discussionread` (
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`readtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`userid`,`discussionid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


editlog



CREATE TABLE `editlog` (
`postid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`reason` varchar(200) NOT NULL default '',
`hashistory` smallint(6) NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


event



CREATE TABLE `event` (
`eventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`event` mediumtext,
`title` varchar(250) NOT NULL default '',
`allowsmilies` smallint(6) NOT NULL default '1',
`recurring` smallint(6) NOT NULL default '0',
`recuroption` char(6) NOT NULL default '',
`calendarid` int(10) unsigned NOT NULL default '0',
`customfields` mediumtext,
`visible` smallint(6) NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`utc` decimal(4,2) NOT NULL default '0.00',
`dst` smallint(6) NOT NULL default '1',
`dateline_from` int(10) unsigned NOT NULL default '0',
`dateline_to` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`eventid`),
KEY `userid` (`userid`),
KEY `calendarid` (`calendarid`),
KEY `visible` (`visible`),
KEY `daterange` (`dateline_to`,`dateline_from`,`visible`,`calendar id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


externalcache


CREATE TABLE `externalcache` (
`cachehash` char(32) NOT NULL default '',
`text` mediumtext,
`headers` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`cachehash`),
KEY `dateline` (`dateline`,`cachehash`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


faq



CREATE TABLE `faq` (
`faqname` varchar(250) character set latin1 collate latin1_bin NOT NULL default '',
`faqparent` varchar(50) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`faqname`),
KEY `faqparent` (`faqparent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


forum



CREATE TABLE `forum` (
`forumid` smallint(5) unsigned NOT NULL auto_increment,
`styleid` smallint(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`title_clean` varchar(100) NOT NULL default '',
`description` text,
`description_clean` text,
`options` int(10) unsigned NOT NULL default '0',
`showprivate` tinyint(3) unsigned NOT NULL default '0',
`displayorder` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`lastpost` int(11) NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastthread` varchar(250) NOT NULL default '',
`lastthreadid` int(10) unsigned NOT NULL default '0',
`lasticonid` smallint(6) NOT NULL default '0',
`lastprefixid` varchar(25) NOT NULL default '',
`threadcount` mediumint(8) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`newpostemail` text,
`newthreademail` text,
`parentid` smallint(6) NOT NULL default '0',
`parentlist` varchar(250) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
`link` varchar(200) NOT NULL default '',
`childlist` text,
`defaultsortfield` varchar(50) NOT NULL default 'lastpost',
`defaultsortorder` enum('asc','desc') NOT NULL default 'desc',
`imageprefix` varchar(100) NOT NULL default '',
`vbseo_moderatepingbacks` int(10) unsigned NOT NULL default '1',
`vbseo_moderatetrackbacks` int(10) unsigned NOT NULL default '1',
`vbseo_moderaterefbacks` int(10) unsigned NOT NULL default '1',
`forumhomeicon` varchar(250) NOT NULL default '',
PRIMARY KEY (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


forumpermission



CREATE TABLE `forumpermission` (
`forumpermissionid` int(10) unsigned NOT NULL auto_increment,
`forumid` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`forumpermissions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`forumpermissionid`),
UNIQUE KEY `ugid_fid` (`usergroupid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


forumprefixset



CREATE TABLE `forumprefixset` (
`forumid` int(10) unsigned NOT NULL default '0',
`prefixsetid` varchar(25) NOT NULL default '',
PRIMARY KEY (`forumid`,`prefixsetid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


forumread



CREATE TABLE `forumread` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`forumid`,`userid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


groupmessage




CREATE TABLE `groupmessage` (
`gmid` int(10) unsigned NOT NULL auto_increment,
`discussionid` int(10) unsigned NOT NULL default '0',
`postuserid` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`state` enum('visible','moderation','deleted') NOT NULL default 'visible',
`title` varchar(255) NOT NULL default '',
`pagetext` mediumtext,
`ipaddress` int(10) unsigned NOT NULL default '0',
`allowsmilie` smallint(5) unsigned NOT NULL default '0',
`reportthreadid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`gmid`),
KEY `postuserid` (`postuserid`,`discussionid`,`state`),
KEY `discussionid` (`discussionid`,`dateline`,`state`),
FULLTEXT KEY `gm_ft` (`title`,`pagetext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


groupmessage_hash



CREATE TABLE `groupmessage_hash` (
`postuserid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dupehash` varchar(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `postuserid` (`postuserid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


groupread



CREATE TABLE `groupread` (
`userid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`readtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`userid`,`groupid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


holiday


CREATE TABLE `holiday` (
`holidayid` int(10) unsigned NOT NULL auto_increment,
`varname` varchar(100) NOT NULL default '',
`recurring` smallint(5) unsigned NOT NULL default '0',
`recuroption` char(6) NOT NULL default '',
`allowsmilies` smallint(6) NOT NULL default '1',
PRIMARY KEY (`holidayid`),
KEY `varname` (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


humanverify




CREATE TABLE `humanverify` (
`hash` char(32) NOT NULL default '',
`answer` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`viewed` smallint(5) unsigned NOT NULL default '0',
KEY `hash` (`hash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


hvanswer



CREATE TABLE `hvanswer` (
`answerid` int(11) NOT NULL auto_increment,
`questionid` int(11) NOT NULL default '0',
`answer` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`answerid`),
KEY `questionid` (`questionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


hvquestion


CREATE TABLE `hvquestion` (
`questionid` int(10) unsigned NOT NULL auto_increment,
`regex` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`questionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


icon



CREATE TABLE `icon` (
`iconid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`iconpath` varchar(100) NOT NULL default '',
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`iconid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


imagecategory



CREATE TABLE `imagecategory` (
`imagecategoryid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`imagetype` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`imagecategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


imagecategorypermission



CREATE TABLE `imagecategorypermission` (
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
KEY `imagecategoryid` (`imagecategoryid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


infraction



CREATE TABLE `infraction` (
`infractionid` int(10) unsigned NOT NULL auto_increment,
`infractionlevelid` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`whoadded` int(10) unsigned NOT NULL default '0',
`points` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`note` varchar(255) NOT NULL default '',
`action` smallint(5) unsigned NOT NULL default '0',
`actiondateline` int(10) unsigned NOT NULL default '0',
`actionuserid` int(10) unsigned NOT NULL default '0',
`actionreason` varchar(255) NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`customreason` varchar(255) NOT NULL default '',
PRIMARY KEY (`infractionid`),
KEY `expires` (`expires`,`action`),
KEY `userid` (`userid`,`action`),
KEY `infractonlevelid` (`infractionlevelid`),
KEY `postid` (`postid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


infractionban




CREATE TABLE `infractionban` (
`infractionbanid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` int(11) NOT NULL default '0',
`banusergroupid` int(10) unsigned NOT NULL default '0',
`amount` int(10) unsigned NOT NULL default '0',
`period` char(5) NOT NULL default '',
`method` enum('points','infractions') NOT NULL default 'infractions',
PRIMARY KEY (`infractionbanid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


infractiongroup



CREATE TABLE `infractiongroup` (
`infractiongroupid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` int(11) NOT NULL default '0',
`orusergroupid` smallint(5) unsigned NOT NULL default '0',
`pointlevel` int(10) unsigned NOT NULL default '0',
`override` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`infractiongroupid`),
KEY `usergroupid` (`usergroupid`,`pointlevel`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


infractionlevel



CREATE TABLE `infractionlevel` (
`infractionlevelid` int(10) unsigned NOT NULL auto_increment,
`points` int(10) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
`period` enum('H','D','M','N') NOT NULL default 'H',
`warning` smallint(5) unsigned NOT NULL default '0',
`extend` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`infractionlevelid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


language



CREATE TABLE `language` (
`languageid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`userselect` smallint(5) unsigned NOT NULL default '1',
`options` smallint(5) unsigned NOT NULL default '1',
`languagecode` varchar(12) NOT NULL default '',
`charset` varchar(15) NOT NULL default '',
`imagesoverride` varchar(150) NOT NULL default '',
`dateoverride` varchar(50) NOT NULL default '',
`timeoverride` varchar(50) NOT NULL default '',
`registereddateoverride` varchar(50) NOT NULL default '',
`calformat1override` varchar(50) NOT NULL default '',
`calformat2override` varchar(50) NOT NULL default '',
`logdateoverride` varchar(50) NOT NULL default '',
`locale` varchar(20) NOT NULL default '',
`decimalsep` char(1) NOT NULL default '.',
`thousandsep` char(1) NOT NULL default ',',
`phrasegroup_global` mediumtext,
`phrasegroup_cpglobal` mediumtext,
`phrasegroup_cppermission` mediumtext,
`phrasegroup_forum` mediumtext,
`phrasegroup_calendar` mediumtext,
`phrasegroup_attachment_image` mediumtext,
`phrasegroup_style` mediumtext,
`phrasegroup_logging` mediumtext,
`phrasegroup_cphome` mediumtext,
`phrasegroup_promotion` mediumtext,
`phrasegroup_user` mediumtext,
`phrasegroup_help_faq` mediumtext,
`phrasegroup_sql` mediumtext,
`phrasegroup_subscription` mediumtext,
`phrasegroup_language` mediumtext,
`phrasegroup_bbcode` mediumtext,
`phrasegroup_stats` mediumtext,
`phrasegroup_diagnostic` mediumtext,
`phrasegroup_maintenance` mediumtext,
`phrasegroup_profilefield` mediumtext,
`phrasegroup_thread` mediumtext,
`phrasegroup_timezone` mediumtext,
`phrasegroup_banning` mediumtext,
`phrasegroup_reputation` mediumtext,
`phrasegroup_wol` mediumtext,
`phrasegroup_threadmanage` mediumtext,
`phrasegroup_pm` mediumtext,
`phrasegroup_cpuser` mediumtext,
`phrasegroup_accessmask` mediumtext,
`phrasegroup_cron` mediumtext,
`phrasegroup_moderator` mediumtext,
`phrasegroup_cpoption` mediumtext,
`phrasegroup_cprank` mediumtext,
`phrasegroup_cpusergroup` mediumtext,
`phrasegroup_holiday` mediumtext,
`phrasegroup_posting` mediumtext,
`phrasegroup_poll` mediumtext,
`phrasegroup_fronthelp` mediumtext,
`phrasegroup_register` mediumtext,
`phrasegroup_search` mediumtext,
`phrasegroup_showthread` mediumtext,
`phrasegroup_postbit` mediumtext,
`phrasegroup_forumdisplay` mediumtext,
`phrasegroup_messaging` mediumtext,
`phrasegroup_inlinemod` mediumtext,
`phrasegroup_plugins` mediumtext,
`phrasegroup_cprofilefield` mediumtext,
`phrasegroup_reputationlevel` mediumtext,
`phrasegroup_infraction` mediumtext,
`phrasegroup_infractionlevel` mediumtext,
`phrasegroup_notice` mediumtext,
`phrasegroup_prefix` mediumtext,
`phrasegroup_prefixadmin` mediumtext,
`phrasegroup_album` mediumtext,
`phrasegroup_socialgroups` mediumtext,
PRIMARY KEY (`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


mailqueue



CREATE TABLE `mailqueue` (
`mailqueueid` int(10) unsigned NOT NULL auto_increment,
`dateline` int(10) unsigned NOT NULL default '0',
`toemail` mediumtext,
`fromemail` mediumtext,
`subject` mediumtext,
`message` mediumtext,
`header` mediumtext,
PRIMARY KEY (`mailqueueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


moderation



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


moderator



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


moderatorlog



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


notice




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


noticecriteria



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


noticedismissed



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


passwordhistory



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


paymentapi



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


paymentinfo



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


paymenttransaction



CREATE TABLE `paymenttransaction` (
`paymenttransactionid` int(10) unsigned NOT NULL auto_increment,
`paymentinfoid` int(10) unsigned NOT NULL default '0',
`transactionid` varchar(250) NOT NULL default '',
`state` smallint(5) unsigned NOT NULL default '0',
`amount` double unsigned NOT NULL default '0',
`currency` varchar(5) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`paymentapiid` int(10) unsigned NOT NULL default '0',
`request` mediumtext,
`reversed` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`paymenttransactionid`),
KEY `dateline` (`dateline`),
KEY `transactionid` (`transactionid`),
KEY `paymentapiid` (`paymentapiid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


phrase



CREATE TABLE `phrase` (
`phraseid` int(10) unsigned NOT NULL auto_increment,
`languageid` smallint(6) NOT NULL default '0',
`varname` varchar(250) character set latin1 collate latin1_bin NOT NULL default '',
`fieldname` varchar(20) NOT NULL default '',
`text` mediumtext,
`product` varchar(25) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`version` varchar(30) NOT NULL default '',
PRIMARY KEY (`phraseid`),
UNIQUE KEY `name_lang_type` (`varname`,`languageid`,`fieldname`),
KEY `languageid` (`languageid`,`fieldname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


phrasetype



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


picture




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


picturecomment



CREATE TABLE `picturecomment` (
`commentid` int(10) unsigned NOT NULL auto_increment,
`pictureid` int(10) unsigned NOT NULL default '0',
`postuserid` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`state` enum('visible','moderation','deleted') NOT NULL default 'visible',
`title` varchar(255) NOT NULL default '',
`pagetext` mediumtext,
`ipaddress` int(10) unsigned NOT NULL default '0',
`allowsmilie` smallint(6) NOT NULL default '1',
`reportthreadid` int(10) unsigned NOT NULL default '0',
`messageread` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`commentid`),
KEY `pictureid` (`pictureid`,`dateline`,`state`),
KEY `postuserid` (`postuserid`,`pictureid`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


picturecomment_hash



CREATE TABLE `picturecomment_hash` (
`postuserid` int(10) unsigned NOT NULL default '0',
`pictureid` int(10) unsigned NOT NULL default '0',
`dupehash` varchar(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `postuserid` (`postuserid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


plugin




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


pm



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


pmreceipt



CREATE TABLE `pmreceipt` (
`pmid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`touserid` int(10) unsigned NOT NULL default '0',
`tousername` varchar(100) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`sendtime` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
`denied` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`pmid`),
KEY `userid` (`userid`,`readtime`),
KEY `touserid` (`touserid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



يتبع ..

مدهش
2011-10-03, 03:39 AM
pmtext



CREATE TABLE `pmtext` (
`pmtextid` int(10) unsigned NOT NULL auto_increment,
`fromuserid` int(10) unsigned NOT NULL default '0',
`fromusername` varchar(100) NOT NULL default '',
`title` varchar(250) NOT NULL default '',
`message` mediumtext,
`touserarray` mediumtext,
`iconid` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`showsignature` smallint(5) unsigned NOT NULL default '0',
`allowsmilie` smallint(5) unsigned NOT NULL default '1',
`reportthreadid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pmtextid`),
KEY `fromuserid` (`fromuserid`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


pmthrottle




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


podcast




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


podcastitem




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


poll
رمز PHP:

CREATE TABLE `poll` (
`pollid` int(10) unsigned NOT NULL auto_increment,
`question` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`options` text,
`votes` text,
`active` smallint(6) NOT NULL default '1',
`numberoptions` smallint(5) unsigned NOT NULL default '0',
`timeout` smallint(5) unsigned NOT NULL default '0',
`multiple` smallint(5) unsigned NOT NULL default '0',
`voters` smallint(5) unsigned NOT NULL default '0',
`public` smallint(6) NOT NULL default '0',
`lastvote` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`pollid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


pollvote




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


post



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


postedithistory



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


posthash



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


postindex



CREATE TABLE `postindex` (
`wordid` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`intitle` smallint(5) unsigned NOT NULL default '0',
`score` smallint(5) unsigned NOT NULL default '0',
UNIQUE KEY `wordid` (`wordid`,`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


postlog



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


postparsed



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


prefix



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


prefixpermission




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


prefixset



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


product



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


productcode



CREATE TABLE `productcode` (
`productcodeid` int(10) unsigned NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`version` varchar(25) NOT NULL default '',
`installcode` mediumtext,
`uninstallcode` mediumtext,
PRIMARY KEY (`productcodeid`),
KEY `productid` (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


productdependency



CREATE TABLE `productdependency` (
`productdependencyid` int(11) NOT NULL auto_increment,
`productid` varchar(25) NOT NULL default '',
`dependencytype` varchar(25) NOT NULL default '',
`parentproductid` varchar(25) NOT NULL default '',
`minversion` varchar(50) NOT NULL default '',
`maxversion` varchar(50) NOT NULL default '',
PRIMARY KEY (`productdependencyid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


profileblockprivacy



CREATE TABLE `profileblockprivacy` (
`userid` int(10) unsigned NOT NULL,
`blockid` varchar(255) NOT NULL,
`requirement` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`blockid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


profilefield



CREATE TABLE `profilefield` (
`profilefieldid` smallint(5) unsigned NOT NULL auto_increment,
`profilefieldcategoryid` smallint(5) unsigned NOT NULL default '0',
`required` smallint(6) NOT NULL default '0',
`hidden` smallint(6) NOT NULL default '0',
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`displayorder` smallint(6) NOT NULL default '0',
`editable` smallint(6) NOT NULL default '1',
`type` enum('input','select','radio','textarea','checkbox ','select_multiple') NOT NULL default 'input',
`data` mediumtext,
`height` smallint(6) NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`searchable` smallint(6) NOT NULL default '0',
`memberlist` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`form` smallint(6) NOT NULL default '0',
`html` smallint(6) NOT NULL default '0',
`perline` smallint(6) NOT NULL default '0',
PRIMARY KEY (`profilefieldid`),
KEY `editable` (`editable`),
KEY `profilefieldcategoryid` (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


profilefieldcategory



CREATE TABLE `profilefieldcategory` (
`profilefieldcategoryid` smallint(5) unsigned NOT NULL auto_increment,
`displayorder` smallint(6) NOT NULL default '0',
`location` varchar(25) NOT NULL default '',
`allowprivacy` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`profilefieldcategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


profilevisitor



CREATE TABLE `profilevisitor` (
`userid` int(10) unsigned NOT NULL default '0',
`visitorid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '1',
PRIMARY KEY (`visitorid`,`userid`),
KEY `userid` (`userid`,`visible`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


ranks



CREATE TABLE `ranks` (
`rankid` smallint(5) unsigned NOT NULL auto_increment,
`minposts` int(10) unsigned NOT NULL default '0',
`ranklevel` smallint(5) unsigned NOT NULL default '0',
`rankimg` mediumtext,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`stack` smallint(5) unsigned NOT NULL default '0',
`display` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`rankid`),
KEY `grouprank` (`usergroupid`,`minposts`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


reminder



CREATE TABLE `reminder` (
`reminderid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`text` mediumtext,
`duedate` int(10) unsigned NOT NULL default '0',
`adminonly` smallint(5) unsigned NOT NULL default '1',
`completedby` int(10) unsigned NOT NULL default '0',
`completedtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`reminderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


reputation



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


reputationlevel



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


rssfeed



CREATE TABLE `rssfeed` (
`rssfeedid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`url` text,
`port` smallint(5) unsigned NOT NULL default '80',
`ttl` smallint(5) unsigned NOT NULL default '1500',
`maxresults` smallint(6) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`prefixid` varchar(25) NOT NULL default '',
`iconid` smallint(5) unsigned NOT NULL default '0',
`titletemplate` mediumtext,
`bodytemplate` mediumtext,
`searchwords` mediumtext,
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`threadactiondelay` smallint(5) unsigned NOT NULL default '0',
`endannouncement` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastrun` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`),
KEY `lastrun` (`lastrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


rsslog



CREATE TABLE `rsslog` (
`rssfeedid` int(10) unsigned NOT NULL default '0',
`itemid` int(10) unsigned NOT NULL default '0',
`itemtype` enum('thread','announcement') NOT NULL default 'thread',
`uniquehash` char(32) NOT NULL default '',
`contenthash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`threadactiontime` int(10) unsigned NOT NULL default '0',
`threadactioncomplete` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`rssfeedid`,`itemid`,`itemtype`),
UNIQUE KEY `uniquehash` (`uniquehash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


search



CREATE TABLE `search` (
`searchid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
`personal` smallint(5) unsigned NOT NULL default '0',
`query` varchar(200) NOT NULL default '',
`searchuser` varchar(200) NOT NULL default '',
`forumchoice` mediumtext,
`prefixchoice` mediumtext,
`sortby` varchar(200) NOT NULL default '',
`sortorder` varchar(4) NOT NULL default '',
`searchtime` float NOT NULL default '0',
`showposts` smallint(5) unsigned NOT NULL default '0',
`orderedids` mediumtext,
`announceids` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`searchterms` mediumtext,
`displayterms` mediumtext,
`searchhash` varchar(32) NOT NULL default '',
`titleonly` smallint(5) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`searchid`),
UNIQUE KEY `searchunique` (`searchhash`,`sortby`,`sortorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


session




CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`host` char(15) NOT NULL default '',
`idhash` char(32) NOT NULL default '',
`lastactivity` int(10) unsigned NOT NULL default '0',
`location` char(255) NOT NULL default '',
`useragent` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`loggedin` smallint(5) unsigned NOT NULL default '0',
`inforum` smallint(5) unsigned NOT NULL default '0',
`inthread` int(10) unsigned NOT NULL default '0',
`incalendar` smallint(5) unsigned NOT NULL default '0',
`badlocation` smallint(5) unsigned NOT NULL default '0',
`bypass` tinyint(4) NOT NULL default '0',
`profileupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sessionhash`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1;


setting



CREATE TABLE `setting` (
`varname` varchar(100) NOT NULL default '',
`grouptitle` varchar(50) NOT NULL default '',
`value` mediumtext,
`defaultvalue` mediumtext,
`optioncode` mediumtext,
`displayorder` smallint(5) unsigned NOT NULL default '0',
`advanced` smallint(6) NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`datatype` enum('free','number','boolean','bitfield','usernam e','integer','posint') NOT NULL default 'free',
`product` varchar(25) NOT NULL default '',
`validationcode` text,
`blacklist` smallint(6) NOT NULL default '0',
PRIMARY KEY (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


settinggroup




CREATE TABLE `settinggroup` (
`grouptitle` char(50) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`grouptitle`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


sigparsed



CREATE TABLE `sigparsed` (
`userid` int(10) unsigned NOT NULL default '0',
`styleid` smallint(5) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`signatureparsed` mediumtext,
`hasimages` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`styleid`,`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


sigpic



CREATE TABLE `sigpic` (
`userid` int(10) unsigned NOT NULL default '0',
`filedata` mediumblob,
`dateline` int(10) unsigned NOT NULL default '0',
`filename` varchar(100) NOT NULL default '',
`visible` smallint(6) NOT NULL default '1',
`filesize` int(10) unsigned NOT NULL default '0',
`width` smallint(5) unsigned NOT NULL default '0',
`height` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


smilie



CREATE TABLE `smilie` (
`smilieid` smallint(5) unsigned NOT NULL auto_increment,
`title` char(100) NOT NULL default '',
`smilietext` char(20) NOT NULL default '',
`smiliepath` char(100) NOT NULL default '',
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`smilieid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


socialgroup



CREATE TABLE `socialgroup` (
`groupid` int(10) unsigned NOT NULL auto_increment,
`socialgroupcategoryid` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL default '',
`description` text,
`creatoruserid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`members` int(10) unsigned NOT NULL default '0',
`picturecount` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(255) NOT NULL default '',
`lastposterid` int(10) unsigned NOT NULL default '0',
`lastgmid` int(10) unsigned NOT NULL default '0',
`visible` int(10) unsigned NOT NULL default '0',
`deleted` int(10) unsigned NOT NULL default '0',
`moderation` int(10) unsigned NOT NULL default '0',
`type` enum('public','moderated','inviteonly') NOT NULL default 'public',
`moderatedmembers` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`lastdiscussionid` int(10) unsigned NOT NULL default '0',
`discussions` int(10) unsigned default '0',
`lastdiscussion` varchar(255) NOT NULL default '',
`lastupdate` int(10) unsigned NOT NULL default '0',
`transferowner` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`),
KEY `creatoruserid` (`creatoruserid`),
KEY `dateline` (`dateline`),
KEY `members` (`members`),
KEY `picturecount` (`picturecount`),
KEY `visible` (`visible`),
KEY `lastpost` (`lastpost`),
KEY `socialgroupcategoryid` (`socialgroupcategoryid`),
FULLTEXT KEY `name` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


socialgroupcategory



CREATE TABLE `socialgroupcategory` (
`socialgroupcategoryid` int(10) unsigned NOT NULL auto_increment,
`creatoruserid` int(10) unsigned NOT NULL,
`title` varchar(250) NOT NULL,
`description` text NOT NULL,
`displayorder` int(10) unsigned NOT NULL,
`lastupdate` int(10) unsigned NOT NULL,
`groups` int(10) unsigned default '0',
PRIMARY KEY (`socialgroupcategoryid`),
KEY `displayorder` (`displayorder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


socialgroupicon



CREATE TABLE `socialgroupicon` (
`groupid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned default '0',
`filedata` mediumblob,
`extension` varchar(20) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`thumbnail_filedata` mediumblob,
`thumbnail_width` int(10) unsigned NOT NULL default '0',
`thumbnail_height` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


socialgroupmember



CREATE TABLE `socialgroupmember` (
`userid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`type` enum('member','moderated','invited') NOT NULL default 'member',
PRIMARY KEY (`groupid`,`userid`),
KEY `groupid` (`groupid`,`type`),
KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


socialgrouppicture




CREATE TABLE `socialgrouppicture` (
`groupid` int(10) unsigned NOT NULL default '0',
`pictureid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`groupid`,`pictureid`),
KEY `groupid` (`groupid`,`dateline`),
KEY `pictureid` (`pictureid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


spamlog



CREATE TABLE `spamlog` (
`postid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


stats

CREATE TABLE `stats` (
`dateline` int(10) unsigned NOT NULL default '0',
`nuser` mediumint(8) unsigned NOT NULL default '0',
`nthread` mediumint(8) unsigned NOT NULL default '0',
`npost` mediumint(8) unsigned NOT NULL default '0',
`ausers` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


strikes



CREATE TABLE `strikes` (
`striketime` int(10) unsigned NOT NULL default '0',
`strikeip` char(15) NOT NULL default '',
`username` varchar(100) NOT NULL default '',
KEY `striketime` (`striketime`),
KEY `strikeip` (`strikeip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


style




CREATE TABLE `style` (
`styleid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`parentid` smallint(6) NOT NULL default '0',
`parentlist` varchar(250) NOT NULL default '',
`templatelist` mediumtext,
`csscolors` mediumtext,
`css` mediumtext,
`stylevars` mediumtext,
`replacements` mediumtext,
`editorstyles` mediumtext,
`userselect` smallint(5) unsigned NOT NULL default '1',
`displayorder` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscribediscussion



CREATE TABLE `subscribediscussion` (
`subscribediscussionid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribediscussionid`),
UNIQUE KEY `userdiscussion` (`userid`,`discussionid`),
KEY `discussionid` (`discussionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscribeevent



CREATE TABLE `subscribeevent` (
`subscribeeventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`eventid` int(10) unsigned NOT NULL default '0',
`lastreminder` int(10) unsigned NOT NULL default '0',
`reminder` int(10) unsigned NOT NULL default '3600',
PRIMARY KEY (`subscribeeventid`),
UNIQUE KEY `subindex` (`userid`,`eventid`),
KEY `eventid` (`eventid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscribeforum



CREATE TABLE `subscribeforum` (
`subscribeforumid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`emailupdate` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`subscribeforumid`),
UNIQUE KEY `subindex` (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscribegroup



CREATE TABLE `subscribegroup` (
`subscribegroupid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`emailupdate` enum('daily','weekly','none') NOT NULL default 'none',
PRIMARY KEY (`subscribegroupid`),
UNIQUE KEY `usergroup` (`userid`,`groupid`),
KEY `groupid` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscribethread



CREATE TABLE `subscribethread` (
`subscribethreadid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`emailupdate` smallint(5) unsigned NOT NULL default '0',
`folderid` int(10) unsigned NOT NULL default '0',
`canview` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`subscribethreadid`),
UNIQUE KEY `threadid` (`threadid`,`userid`),
KEY `userid` (`userid`,`folderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscription



CREATE TABLE `subscription` (
`subscriptionid` smallint(5) unsigned NOT NULL auto_increment,
`varname` varchar(100) NOT NULL default '',
`cost` mediumtext,
`forums` mediumtext,
`nusergroupid` smallint(6) NOT NULL default '0',
`membergroupids` varchar(255) NOT NULL default '',
`active` smallint(5) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
`adminoptions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscriptionlog



CREATE TABLE `subscriptionlog` (
`subscriptionlogid` mediumint(8) unsigned NOT NULL auto_increment,
`subscriptionid` smallint(6) NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`pusergroupid` smallint(6) NOT NULL default '0',
`status` smallint(6) NOT NULL default '0',
`regdate` int(10) unsigned NOT NULL default '0',
`expirydate` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionlogid`),
KEY `userid` (`userid`,`subscriptionid`),
KEY `subscriptionid` (`subscriptionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


subscriptionpermission




CREATE TABLE `subscriptionpermission` (
`subscriptionpermissionid` int(10) unsigned NOT NULL auto_increment,
`subscriptionid` int(10) unsigned NOT NULL default '0',
`usergroupid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`subscriptionpermissionid`),
UNIQUE KEY `subscriptionid` (`subscriptionid`,`usergroupid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


tachyforumcounter



CREATE TABLE `tachyforumcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`threadcount` mediumint(8) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


tachyforumpost



CREATE TABLE `tachyforumpost` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastthread` varchar(250) NOT NULL default '',
`lastthreadid` int(10) unsigned NOT NULL default '0',
`lasticonid` smallint(5) unsigned NOT NULL default '0',
`lastprefixid` varchar(25) NOT NULL default '',
PRIMARY KEY (`userid`,`forumid`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


tachythreadcounter



CREATE TABLE `tachythreadcounter` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


tachythreadpost



CREATE TABLE `tachythreadpost` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`lastpostid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


tag



CREATE TABLE `tag` (
`tagid` int(10) unsigned NOT NULL auto_increment,
`tagtext` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`),
UNIQUE KEY `tagtext` (`tagtext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


tagsearch



CREATE TABLE `tagsearch` (
`tagid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `tagid` (`tagid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


tagthread



CREATE TABLE `tagthread` (
`tagid` int(10) unsigned NOT NULL default '0',
`threadid` 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`,`threadid`),
KEY `threadid` (`threadid`,`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


template



CREATE TABLE `template` (
`templateid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(6) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext,
`template_un` mediumtext,
`templatetype` enum('template','stylevar','css','replacement') NOT NULL default 'template',
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`templateid`),
UNIQUE KEY `title` (`title`,`styleid`,`templatetype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


templatehistory



CREATE TABLE `templatehistory` (
`templatehistoryid` int(10) unsigned NOT NULL auto_increment,
`styleid` smallint(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`template` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`version` varchar(30) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`templatehistoryid`),
KEY `title` (`title`,`styleid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


thread




CREATE TABLE `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`prefixid` varchar(25) NOT NULL default '',
`firstpostid` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`pollid` int(10) unsigned NOT NULL default '0',
`open` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`hiddencount` int(10) unsigned NOT NULL default '0',
`deletedcount` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`postuserid` int(10) unsigned NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` smallint(5) unsigned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`visible` smallint(6) NOT NULL default '0',
`sticky` smallint(6) NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`attach` smallint(5) unsigned NOT NULL default '0',
`similar` varchar(55) NOT NULL default '',
`taglist` mediumtext,
`vbseo_linkbacks_no` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `postuserid` (`postuserid`),
KEY `pollid` (`pollid`),
KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
KEY `lastpost` (`lastpost`,`forumid`),
KEY `dateline` (`dateline`),
KEY `prefixid` (`prefixid`,`forumid`),
FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


threadrate



CREATE TABLE `threadrate` (
`threadrateid` int(10) unsigned NOT NULL auto_increment,
`threadid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` smallint(6) NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
PRIMARY KEY (`threadrateid`),
KEY `threadid` (`threadid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


threadread



CREATE TABLE `threadread` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`threadid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


threadredirect




CREATE TABLE `threadredirect` (
`threadid` int(10) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`threadid`),
KEY `expires` (`expires`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


threadviews



CREATE TABLE `threadviews` (
`threadid` int(10) unsigned NOT NULL default '0',
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


upgradelog




CREATE TABLE `upgradelog` (
`upgradelogid` int(10) unsigned NOT NULL auto_increment,
`script` varchar(50) NOT NULL default '',
`steptitle` varchar(250) NOT NULL default '',
`step` smallint(5) unsigned NOT NULL default '0',
`startat` int(10) unsigned NOT NULL default '0',
`perpage` smallint(5) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`upgradelogid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


user



CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`membergroupids` char(250) NOT NULL default '',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`password` char(32) NOT NULL default '',
`passworddate` date NOT NULL default '0000-00-00',
`email` char(100) NOT NULL default '',
`styleid` smallint(5) unsigned NOT NULL default '0',
`parentemail` char(50) NOT NULL default '',
`homepage` char(100) NOT NULL default '',
`icq` char(20) NOT NULL default '',
`aim` char(20) NOT NULL default '',
`yahoo` char(32) NOT NULL default '',
`msn` char(100) NOT NULL default '',
`skype` char(32) NOT NULL default '',
`showvbcode` smallint(5) unsigned NOT NULL default '0',
`showbirthday` smallint(5) unsigned NOT NULL default '2',
`usertitle` char(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`joindate` int(10) unsigned NOT NULL default '0',
`daysprune` smallint(6) NOT NULL default '0',
`lastvisit` int(10) unsigned NOT NULL default '0',
`lastactivity` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`lastpostid` int(10) unsigned NOT NULL default '0',
`posts` int(10) unsigned NOT NULL default '0',
`reputation` int(11) NOT NULL default '10',
`reputationlevelid` int(10) unsigned NOT NULL default '1',
`timezoneoffset` char(4) NOT NULL default '',
`pmpopup` smallint(6) NOT NULL default '0',
`avatarid` smallint(6) NOT NULL default '0',
`avatarrevision` int(10) unsigned NOT NULL default '0',
`profilepicrevision` int(10) unsigned NOT NULL default '0',
`sigpicrevision` int(10) unsigned NOT NULL default '0',
`options` int(10) unsigned NOT NULL default '33554447',
`birthday` char(10) NOT NULL default '',
`birthday_search` date NOT NULL default '0000-00-00',
`maxposts` smallint(6) NOT NULL default '-1',
`startofweek` smallint(6) NOT NULL default '1',
`ipaddress` char(15) NOT NULL default '',
`referrerid` int(10) unsigned NOT NULL default '0',
`languageid` smallint(5) unsigned NOT NULL default '0',
`emailstamp` int(10) unsigned NOT NULL default '0',
`threadedmode` smallint(5) unsigned NOT NULL default '0',
`autosubscribe` smallint(6) NOT NULL default '-1',
`pmtotal` smallint(5) unsigned NOT NULL default '0',
`pmunread` smallint(5) unsigned NOT NULL default '0',
`salt` char(3) NOT NULL default '',
`ipoints` int(10) unsigned NOT NULL default '0',
`infractions` int(10) unsigned NOT NULL default '0',
`warnings` int(10) unsigned NOT NULL default '0',
`infractiongroupids` varchar(255) NOT NULL default '',
`infractiongroupid` smallint(5) unsigned NOT NULL default '0',
`adminoptions` int(10) unsigned NOT NULL default '0',
`profilevisits` int(10) unsigned NOT NULL default '0',
`friendcount` int(10) unsigned NOT NULL default '0',
`friendreqcount` int(10) unsigned NOT NULL default '0',
`vmunreadcount` int(10) unsigned NOT NULL default '0',
`vmmoderatedcount` int(10) unsigned NOT NULL default '0',
`socgroupinvitecount` int(10) unsigned NOT NULL default '0',
`socgroupreqcount` int(10) unsigned NOT NULL default '0',
`pcunreadcount` int(10) unsigned NOT NULL default '0',
`pcmoderatedcount` int(10) unsigned NOT NULL default '0',
`gmmoderatedcount` int(10) unsigned NOT NULL default '0',
`mwaextraadmin3_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') default NULL,
`mwaextraadmin3_imageresizer_maxwidth` smallint(5) unsigned default NULL,
`mwaextraadmin3_imageresizer_maxheight` smallint(5) unsigned default NULL,
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `lastactivity` (`lastactivity`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


useractivation



CREATE TABLE `useractivation` (
`useractivationid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`activationid` varchar(40) NOT NULL default '',
`type` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`emailchange` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`useractivationid`),
UNIQUE KEY `userid` (`userid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


userban



CREATE TABLE `userban` (
`userid` int(10) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`displaygroupid` smallint(5) unsigned NOT NULL default '0',
`usertitle` varchar(250) NOT NULL default '',
`customtitle` smallint(6) NOT NULL default '0',
`adminid` int(10) unsigned NOT NULL default '0',
`bandate` int(10) unsigned NOT NULL default '0',
`liftdate` int(10) unsigned NOT NULL default '0',
`reason` varchar(250) NOT NULL default '',
PRIMARY KEY (`userid`),
KEY `liftdate` (`liftdate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


userchangelog



CREATE TABLE `userchangelog` (
`changeid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`fieldname` varchar(250) NOT NULL default '',
`newvalue` varchar(250) NOT NULL default '',
`oldvalue` varchar(250) NOT NULL default '',
`adminid` int(10) unsigned NOT NULL default '0',
`change_time` int(10) unsigned NOT NULL default '0',
`change_uniq` varchar(32) NOT NULL default '',
PRIMARY KEY (`changeid`),
KEY `userid` (`userid`,`change_time`),
KEY `change_time` (`change_time`),
KEY `change_uniq` (`change_uniq`),
KEY `fieldname` (`fieldname`,`change_time`),
KEY `adminid` (`adminid`,`change_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


usercss



CREATE TABLE `usercss` (
`userid` int(10





انتهي ..

موفقين

م

أبو عمار
2011-12-10, 07:06 AM
بارك الله وأحسن الله إليك
سلمت وسلمت يمناك
لا خلا ولا عدم
جاري الحفظ للإستفادة ، منه مستقبلا

بالتوفيق