مو لازم باك اب
هذي الجداول يفترض تفريغها وليس حذفها عموما هذه هي قم بزرعها في القاعدة وستحل المشكلة :
كود PHP:
CREATE TABLE session (
sessionhash CHAR(32) NOT NULL DEFAULT '',
userid INT UNSIGNED NOT NULL DEFAULT '0',
host CHAR(15) NOT NULL DEFAULT '',
idhash CHAR(32) NOT NULL DEFAULT '',
lastactivity INT UNSIGNED NOT NULL DEFAULT '0',
location CHAR(255) NOT NULL DEFAULT '',
useragent CHAR(100) NOT NULL DEFAULT '',
styleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
languageid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
loggedin SMALLINT UNSIGNED NOT NULL DEFAULT '0',
inforum SMALLINT UNSIGNED NOT NULL DEFAULT '0',
inthread INT UNSIGNED NOT NULL DEFAULT '0',
incalendar SMALLINT UNSIGNED NOT NULL DEFAULT '0',
badlocation SMALLINT UNSIGNED NOT NULL DEFAULT '0',
bypass TINYINT NOT NULL DEFAULT '0',
profileupdate SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (sessionhash)
)
كود 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=158 ;
كود PHP:
CREATE TABLE `search` (
`searchid` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`ipaddress` char(15) NOT NULL default '',
`personal` smallint(5) unsigned NOT NULL default '0',
`query` varchar(200) NOT NULL default '',
`searchuser` varchar(200) NOT NULL default '',
`forumchoice` mediumtext,
`prefixchoice` mediumtext,
`sortby` varchar(200) NOT NULL default '',
`sortorder` varchar(4) NOT NULL default '',
`searchtime` float NOT NULL default '0',
`showposts` smallint(5) unsigned NOT NULL default '0',
`orderedids` mediumtext,
`announceids` mediumtext,
`dateline` int(10) unsigned NOT NULL default '0',
`searchterms` mediumtext,
`displayterms` mediumtext,
`searchhash` varchar(32) NOT NULL default '',
`titleonly` smallint(5) unsigned NOT NULL default '0',
`completed` smallint(5) unsigned NOT NULL default '1',
PRIMARY KEY (`searchid`),
UNIQUE KEY `searchunique` (`searchhash`,`sortby`,`sortorder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
كود PHP:
CREATE TABLE `word` (
`wordid` int(10) unsigned NOT NULL auto_increment,
`title` char(50) NOT NULL default '',
PRIMARY KEY (`wordid`),
UNIQUE KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;