المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : اوامر sql لزراعه الجداول المحذوفة من المنتديات



محمود الغرايبه
22-03-2011, 12:39 AM
هذي جميع الجداول في قاعدة بيانات المنتدى سكربت 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','dismisse d') 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 ;

محمود الغرايبه
22-03-2011, 12:45 AM
الجزء الثاني
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','profi le') 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`,`startdat e`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

محمود الغرايبه
22-03-2011, 01:22 AM
الجزء الثالث

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
22-03-2011, 02:22 PM
مشكور يا غالي يعطيك العافية