| سالجان |
10-03-2019 10:13 AM |
قاعدة البيانات SQL vb3_4
[CODE]customavatar
كود:
customavatar
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
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
رمز PHP:
كود PHP:
CREATE TABLE `deletionlog` (
`primaryid` int(10) unsigned NOT NULL default '0',
`type` enum('post','thread','visitormessage','groupmessage','picturecomment') NOT NULL default 'post',
`userid` int(10) unsigned NOT NULL default '0',
`username` varchar(100) NOT NULL default '',
`reason` varchar(125) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`primaryid`,`type`),
KEY `type` (`type`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
discussion
رمز PHP:
كود PHP:
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 ;
|
