| سالجان |
10-03-2019 10:06 AM |
قاعدة البيانات SQL vb3 _1
discussionread
كود:
رمز PHP:
كود PHP:
CREATE TABLE `discussionread` (
`userid` int(10) unsigned NOT NULL,
`discussionid` int(10) unsigned NOT NULL,
`readtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`userid`,`discussionid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
editlog
رمز PHP:
كود PHP:
CREATE TABLE `editlog` (
`postid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`reason` varchar(200) NOT NULL default '',
`hashistory` smallint(6) NOT NULL default '0',
PRIMARY KEY (`postid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
event
رمز PHP:
كود PHP:
CREATE TABLE `event` (
`eventid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`event` mediumtext,
`title` varchar(250) NOT NULL default '',
`allowsmilies` smallint(6) NOT NULL default '1',
`recurring` smallint(6) NOT NULL default '0',
`recuroption` char(6) NOT NULL default '',
`calendarid` int(10) unsigned NOT NULL default '0',
`customfields` mediumtext,
`visible` smallint(6) NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`utc` decimal(4,2) NOT NULL default '0.00',
`dst` smallint(6) NOT NULL default '1',
`dateline_from` int(10) unsigned NOT NULL default '0',
`dateline_to` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`eventid`),
KEY `userid` (`userid`),
KEY `calendarid` (`calendarid`),
KEY `visible` (`visible`),
KEY `daterange` (`dateline_to`,`dateline_from`,`visible`,`calendarid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
externalcache رمز PHP:
CREATE TABLE `externalcache` (
`cachehash` char(32) NOT NULL default '',
`text` mediumtext,
`headers` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`forumid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`cachehash`),
KEY `dateline` (`dateline`,`cachehash`),
KEY `forumid` (`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
faq
رمز PHP:
كود PHP:
CREATE TABLE `faq` (
`faqname` varchar(250) character set latin1 collate latin1_bin NOT NULL default '',
`faqparent` varchar(50) NOT NULL default '',
`displayorder` smallint(5) unsigned NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`product` varchar(25) NOT NULL default '',
PRIMARY KEY (`faqname`),
KEY `faqparent` (`faqparent`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
forum
رمز PHP:
كود PHP:
CREATE TABLE `forum` (
`forumid` smallint(5) unsigned NOT NULL auto_increment,
`styleid` smallint(5) unsigned NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`title_clean` varchar(100) NOT NULL default '',
`description` text,
`description_clean` text,
`options` int(10) unsigned NOT NULL default '0',
`showprivate` tinyint(3) unsigned NOT NULL default '0',
`displayorder` smallint(6) NOT NULL default '0',
`replycount` int(10) unsigned NOT NULL default '0',
`lastpost` int(11) NOT NULL default '0',
`lastposter` varchar(100) NOT NULL default '',
`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
رمز PHP:
كود PHP:
CREATE TABLE `forumpermission` (
`forumpermissionid` int(10) unsigned NOT NULL auto_increment,
`forumid` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
`forumpermissions` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`forumpermissionid`),
UNIQUE KEY `ugid_fid` (`usergroupid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
forumprefixset
رمز PHP:
كود PHP:
CREATE TABLE `forumprefixset` (
`forumid` int(10) unsigned NOT NULL default '0',
`prefixsetid` varchar(25) NOT NULL default '',
PRIMARY KEY (`forumid`,`prefixsetid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
forumread
رمز PHP:
كود PHP:
CREATE TABLE `forumread` (
`userid` int(10) unsigned NOT NULL default '0',
`forumid` smallint(5) unsigned NOT NULL default '0',
`readtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`forumid`,`userid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
groupmessage
رمز PHP:
كود PHP:
CREATE TABLE `groupmessage` (
`gmid` int(10) unsigned NOT NULL auto_increment,
`discussionid` int(10) unsigned NOT NULL default '0',
`postuserid` int(10) unsigned NOT NULL default '0',
`postusername` varchar(100) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
`state` enum('visible','moderation','deleted') NOT NULL default 'visible',
`title` varchar(255) NOT NULL default '',
`pagetext` mediumtext,
`ipaddress` int(10) unsigned NOT NULL default '0',
`allowsmilie` smallint(5) unsigned NOT NULL default '0',
`reportthreadid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`gmid`),
KEY `postuserid` (`postuserid`,`discussionid`,`state`),
KEY `discussionid` (`discussionid`,`dateline`,`state`),
FULLTEXT KEY `gm_ft` (`title`,`pagetext`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
groupmessage_hash
رمز PHP:
كود PHP:
CREATE TABLE `groupmessage_hash` (
`postuserid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`dupehash` varchar(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `postuserid` (`postuserid`,`dupehash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
groupread
رمز PHP:
كود PHP:
CREATE TABLE `groupread` (
`userid` int(10) unsigned NOT NULL,
`groupid` int(10) unsigned NOT NULL,
`readtime` int(10) unsigned NOT NULL,
PRIMARY KEY (`userid`,`groupid`),
KEY `readtime` (`readtime`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
holiday
رمز PHP:
كود PHP:
CREATE TABLE `holiday` (
`holidayid` int(10) unsigned NOT NULL auto_increment,
`varname` varchar(100) NOT NULL default '',
`recurring` smallint(5) unsigned NOT NULL default '0',
`recuroption` char(6) NOT NULL default '',
`allowsmilies` smallint(6) NOT NULL default '1',
PRIMARY KEY (`holidayid`),
KEY `varname` (`varname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
humanverify
رمز PHP:
كود PHP:
CREATE TABLE `humanverify` (
`hash` char(32) NOT NULL default '',
`answer` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`viewed` smallint(5) unsigned NOT NULL default '0',
KEY `hash` (`hash`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
hvanswer
رمز PHP:
كود PHP:
CREATE TABLE `hvanswer` (
`answerid` int(11) NOT NULL auto_increment,
`questionid` int(11) NOT NULL default '0',
`answer` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`answerid`),
KEY `questionid` (`questionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
hvquestion رمز PHP:
كود PHP:
CREATE TABLE `hvquestion` (
`questionid` int(10) unsigned NOT NULL auto_increment,
`regex` varchar(255) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`questionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
icon
رمز PHP:
كود PHP:
CREATE TABLE `icon` (
`iconid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`iconpath` varchar(100) NOT NULL default '',
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`iconid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
imagecategory
رمز PHP:
كود PHP:
CREATE TABLE `imagecategory` (
`imagecategoryid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`imagetype` smallint(5) unsigned NOT NULL default '0',
`displayorder` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`imagecategoryid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
imagecategorypermission
رمز PHP:
كود PHP:
CREATE TABLE `imagecategorypermission` (
`imagecategoryid` smallint(5) unsigned NOT NULL default '0',
`usergroupid` smallint(5) unsigned NOT NULL default '0',
KEY `imagecategoryid` (`imagecategoryid`,`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
infraction
رمز PHP:
كود PHP:
CREATE TABLE `infraction` (
`infractionid` int(10) unsigned NOT NULL auto_increment,
`infractionlevelid` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`whoadded` int(10) unsigned NOT NULL default '0',
`points` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`note` varchar(255) NOT NULL default '',
`action` smallint(5) unsigned NOT NULL default '0',
`actiondateline` int(10) unsigned NOT NULL default '0',
`actionuserid` int(10) unsigned NOT NULL default '0',
`actionreason` varchar(255) NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`customreason` varchar(255) NOT NULL default '',
PRIMARY KEY (`infractionid`),
KEY `expires` (`expires`,`action`),
KEY `userid` (`userid`,`action`),
KEY `infractonlevelid` (`infractionlevelid`),
KEY `postid` (`postid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
infractionban
رمز PHP:
كود PHP:
CREATE TABLE `infractionban` (
`infractionbanid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` int(11) NOT NULL default '0',
`banusergroupid` int(10) unsigned NOT NULL default '0',
`amount` int(10) unsigned NOT NULL default '0',
`period` char(5) NOT NULL default '',
`method` enum('points','infractions') NOT NULL default 'infractions',
PRIMARY KEY (`infractionbanid`),
KEY `usergroupid` (`usergroupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
infractiongroup
رمز PHP:
كود PHP:
CREATE TABLE `infractiongroup` (
`infractiongroupid` int(10) unsigned NOT NULL auto_increment,
`usergroupid` int(11) NOT NULL default '0',
`orusergroupid` smallint(5) unsigned NOT NULL default '0',
`pointlevel` int(10) unsigned NOT NULL default '0',
`override` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`infractiongroupid`),
KEY `usergroupid` (`usergroupid`,`pointlevel`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
infractionlevel
رمز PHP:
كود PHP:
CREATE TABLE `infractionlevel` (
`infractionlevelid` int(10) unsigned NOT NULL auto_increment,
`points` int(10) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
`period` enum('H','D','M','N') NOT NULL default 'H',
`warning` smallint(5) unsigned NOT NULL default '0',
`extend` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`infractionlevelid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
language رمز PHP:
كود PHP:
CREATE TABLE `language` (
`languageid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`userselect` smallint(5) unsigned NOT NULL default '1',
`options` smallint(5) unsigned NOT NULL default '1',
`languagecode` varchar(12) NOT NULL default '',
`charset` varchar(15) NOT NULL default '',
`imagesoverride` varchar(150) NOT NULL default '',
`dateoverride` varchar(50) NOT NULL default '',
`timeoverride` varchar(50) NOT NULL default '',
`registereddateoverride` varchar(50) NOT NULL default '',
`calformat1override` varchar(50) NOT NULL default '',
`calformat2override` varchar(50) NOT NULL default '',
`logdateoverride` varchar(50) NOT NULL default '',
`locale` varchar(20) NOT NULL default '',
`decimalsep` char(1) NOT NULL default '.',
`thousandsep` char(1) NOT NULL default ',',
`phrasegroup_global` mediumtext,
`phrasegroup_cpglobal` mediumtext,
`phrasegroup_cppermission` mediumtext,
`phrasegroup_forum` mediumtext,
`phrasegroup_calendar` mediumtext,
`phrasegroup_attachment_image` mediumtext,
`phrasegroup_style` mediumtext,
`phrasegroup_logging` mediumtext,
`phrasegroup_cphome` mediumtext,
`phrasegroup_promotion` mediumtext,
`phrasegroup_user` mediumtext,
`phrasegroup_help_faq` mediumtext,
`phrasegroup_sql` mediumtext,
`phrasegroup_subscription` mediumtext,
`phrasegroup_language` mediumtext,
`phrasegroup_bbcode` mediumtext,
`phrasegroup_stats` mediumtext,
`phrasegroup_diagnostic` mediumtext,
`phrasegroup_maintenance` mediumtext,
`phrasegroup_profilefield` mediumtext,
`phrasegroup_thread` mediumtext,
`phrasegroup_timezone` mediumtext,
`phrasegroup_banning` mediumtext,
`phrasegroup_reputation` mediumtext,
`phrasegroup_wol` mediumtext,
`phrasegroup_threadmanage` mediumtext,
`phrasegroup_pm` mediumtext,
`phrasegroup_cpuser` mediumtext,
`phrasegroup_accessmask` mediumtext,
`phrasegroup_cron` mediumtext,
`phrasegroup_moderator` mediumtext,
`phrasegroup_cpoption` mediumtext,
`phrasegroup_cprank` mediumtext,
`phrasegroup_cpusergroup` mediumtext,
`phrasegroup_holiday` mediumtext,
`phrasegroup_posting` mediumtext,
`phrasegroup_poll` mediumtext,
`phrasegroup_fronthelp` mediumtext,
`phrasegroup_register` mediumtext,
`phrasegroup_search` mediumtext,
`phrasegroup_showthread` mediumtext,
`phrasegroup_postbit` mediumtext,
`phrasegroup_forumdisplay` mediumtext,
`phrasegroup_messaging` mediumtext,
`phrasegroup_inlinemod` mediumtext,
`phrasegroup_plugins` mediumtext,
`phrasegroup_cprofilefield` mediumtext,
`phrasegroup_reputationlevel` mediumtext,
`phrasegroup_infraction` mediumtext,
`phrasegroup_infractionlevel` mediumtext,
`phrasegroup_notice` mediumtext,
`phrasegroup_prefix` mediumtext,
`phrasegroup_prefixadmin` mediumtext,
`phrasegroup_album` mediumtext,
`phrasegroup_socialgroups` mediumtext,
PRIMARY KEY (`languageid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
mailqueue
|
