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

[محمود الغرايبه]

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

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

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

يستحسن الترقيه بعد زراعه أمر بناء لتجنب المشاكل
الجزء الاول


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

access

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;

adminhelp

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 ;

administrator

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;

adminlog

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 ;

adminmessage

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 ;

[محمود الغرايبه]

الجزء الثاني
adminutil

CREATE TABLE `adminutil` ( 
`title` varchar(50) NOT NULL default '', 
`text` mediumtext, 
PRIMARY KEY  (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

album

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 ;

albumpicture

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;

albumupdate

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;

announcement

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 ;

[محمود الغرايبه]

الجزء الثالث

announcementread

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;

attachment

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 ;

attachmentpermission

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 ;

attachmenttype

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;

[Raed Saadeh]

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