| سالجان |
10-03-2019 10:14 AM |
قاعدة البيانات SQL vb3 _4
كود:
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 ;
|
