اوامر sql لزراعه الجداول المحذوفة من المنتديات

هذي جميع الجداول في قاعدة بيانات المنتدى سكربت vBulletin في النسخه 3.8 .... بعض الجداول تستخدم في 3.7 ولا انصح للنسخ القديمه بإستخدام أوامر البناء ....

عند حذف جدول في قاعدة البيانات بالغلط قم بزراعت الأوامر المذكوره ادناه

عدد الجداول 158 جدول

يستحسن الترقيه بعد زراعه أمر بناء لتجنب المشاكل
[COLOR="Red"][SIZE="4"] الجزء الاول[/SIZE][/COLOR]


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

access

[CODE]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; [/CODE]


adminhelp

[CODE]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 ; [/CODE]

administrator
[CODE]
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; [/CODE]


adminlog

[CODE]
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 ; [/CODE]

adminmessage

[CODE]
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 ; [/CODE]

[COLOR="Red"][SIZE="5"]الجزء الثاني [/SIZE][/COLOR]
adminutil
[CODE]CREATE TABLE `adminutil` (
`title` varchar(50) NOT NULL default '',
`text` mediumtext,
PRIMARY KEY (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; [/CODE]
album
[CODE]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 ; [/CODE]
albumpicture
[CODE]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; [/CODE]
albumupdate
[CODE]
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; [/CODE]
announcement
[CODE]

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 ;[/CODE]

الجزء الثالث

announcementread

[CODE]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; [/CODE]


attachment

[CODE]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 ; [/CODE]


attachmentpermission


[CODE]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 ; [/CODE]


attachmenttype

[CODE]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; [/CODE]

مشكور يا غالي يعطيك العافية