زراعه الجداول المحذوفه في قاعدة البيانات SQL vb3

س

سالجان

New member
26 فبراير 2019
1,000
0
0
24
زراعه الجداول المحذوفه في قاعدة البيانات SQL vb3

السلام عليكم ورحمه الله وبركاته

وبكل صراحه الموضوع اتعبني كثيراً فقد استغرق اكثر من 7 ساعات

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

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

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

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



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

كود: 
access
رمز PHP:
كود PHP:
                       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=utf8;  
adminhelp

رمز PHP:
كود PHP:
                       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=utf8 AUTO_INCREMENT=1 ;  
administrator
رمز PHP:
كود PHP:
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=utf8;  
adminlog
رمز PHP:
كود PHP:
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=utf8 AUTO_INCREMENT=1 ;  
adminmessage

رمز PHP:
كود PHP:
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=utf8 AUTO_INCREMENT=1 ;  
adminutil

رمز PHP:
كود PHP:
                       CREATE TABLE `adminutil` ( 
  `title` varchar(50) NOT NULL default '', 
  `text` mediumtext, 
  PRIMARY KEY  (`title`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;  
album

رمز PHP:
كود PHP:
                       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=utf8 AUTO_INCREMENT=1 ;  
albumpicture

رمز PHP:
كود PHP:
                       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=utf8;  
albumupdate
رمز PHP:
كود PHP:
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=utf8;  
announcement رمز PHP:
كود PHP:
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=utf8 AUTO_INCREMENT=1 ;  
announcementread


رمز PHP:
كود PHP:
                       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=utf8;  
attachment

رمز PHP:
كود PHP:
                       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 utf8 collate utf8_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=utf8 AUTO_INCREMENT=1 ;  
attachmentpermission

رمز PHP:
كود PHP:
                       CREATE TABLE `attachmentpermission` ( 
  `attachmentpermissionid` int(10) unsigned NOT NULL auto_increment, 
  `extension` varchar(20) character set utf8 collate utf8_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=utf8 AUTO_INCREMENT=1 ;  
attachmenttype

رمز PHP:
كود PHP:
                       CREATE TABLE `attachmenttype` ( 
  `extension` char(20) character set utf8 collate utf8_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=utf8;  
attachmentviews


رمز PHP:
كود PHP:
                       CREATE TABLE `attachmentviews` ( 
  `attachmentid` int(10) unsigned NOT NULL default '0', 
  KEY `postid` (`attachmentid`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;  
avatar

رمز PHP:
كود PHP:
                       CREATE TABLE `avatar` ( 
  `avatarid` smallint(5) unsigned NOT NULL auto_increment, 
  `title` varchar(100) NOT NULL default '', 
  `minimumposts` int(10) unsigned NOT NULL default '0', 
  `avatarpath` varchar(100) NOT NULL default '', 
  `imagecategoryid` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` smallint(5) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`avatarid`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
bbcode

رمز PHP:
كود PHP:
CREATE TABLE `bbcode` ( 
  `bbcodeid` smallint(5) unsigned NOT NULL auto_increment, 
  `bbcodetag` varchar(200) NOT NULL default '', 
  `bbcodereplacement` mediumtext, 
  `bbcodeexample` varchar(200) NOT NULL default '', 
  `bbcodeexplanation` mediumtext, 
  `twoparams` smallint(6) NOT NULL default '0', 
  `title` varchar(100) NOT NULL default '', 
  `buttonimage` varchar(250) NOT NULL default '', 
  `options` int(10) unsigned NOT NULL default '1', 
  PRIMARY KEY  (`bbcodeid`), 
  UNIQUE KEY `uniquetag` (`bbcodetag`,`twoparams`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
bookmarksite
رمز PHP:
كود PHP:
CREATE TABLE `bookmarksite` ( 
  `bookmarksiteid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(250) NOT NULL default '', 
  `iconpath` varchar(250) NOT NULL default '', 
  `active` smallint(5) unsigned NOT NULL default '0', 
  `displayorder` int(10) unsigned NOT NULL default '0', 
  `url` varchar(250) NOT NULL default '', 
  PRIMARY KEY  (`bookmarksiteid`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
calendar
رمز PHP:
[PHP]
كود PHP:
CREATE TABLE `calendar` ( 
  `calendarid` int(10) unsigned NOT NULL auto_increment, 
  `title` varchar(255) NOT NULL default '', 
  `description` varchar(100) NOT NULL default '', 
  `displayorder` smallint(6) NOT NULL default '0', 
  `neweventemail` text, 
  `moderatenew` smallint(6) NOT NULL default '0', 
  `startofweek` smallint(6) NOT NULL default '0', 
  `options` int(10) unsigned NOT NULL default '0', 
  `cutoff` smallint(5) unsigned NOT NULL default '0', 
  `eventcount` smallint(5) unsigned NOT NULL default '0', 
  `birthdaycount` smallint(5) unsigned NOT NULL default '0', 
  `startyear` smallint(5) unsigned NOT NULL default '2000', 
  `endyear` smallint(5) unsigned NOT NULL default '2006', 
  `holidays` int(10) unsigned NOT NULL default '0', 
  PRIMARY KEY  (`calendarid`), 
  KEY `displayorder` (`displayorder`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;  
[/PHP
 
يجب تسجيل الدخول أو التسجيل كي تتمكن من الرد هنا.
أعلى أسفل