| سالجان |
10-03-2019 10:09 AM |
قاعدة البيانات SQL vb3 _2
CREATE TABLE `mailqueue
كود:
رمز PHP:
كود PHP:
`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
رمز PHP:
كود PHP:
CREATE TABLE `moderation` (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('thread','reply','visitormessage','groupmessage','picturecomment') NOT NULL default 'thread',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
moderator
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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 رمز PHP:
كود PHP:
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
رمز PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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;
pmtext
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
CREATE TABLE `pmthrottle` (
`userid` int(10) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL,
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
podcast
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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:
كود 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
رمز PHP:
كود PHP:
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 ;
|
