ارور دیتابیس در انجمن

[i-whost]

کوئری زیر اجرا کنید

CREATE TABLE search (
searchid INT UNSIGNED NOT NULL AUTO_INCREMENT,
userid INT UNSIGNED NOT NULL DEFAULT ’0′,
ipaddress CHAR(15) NOT NULL DEFAULT ”,
personal SMALLINT 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 UNSIGNED NOT NULL DEFAULT ’0′,
orderedids MEDIUMTEXT,
announceids MEDIUMTEXT,
dateline INT UNSIGNED NOT NULL DEFAULT ’0′,
searchterms MEDIUMTEXT,
displayterms MEDIUMTEXT,
searchhash VARCHAR(32) NOT NULL DEFAULT ”,
titleonly SMALLINT UNSIGNED NOT NULL DEFAULT ’0′,
completed SMALLINT UNSIGNED NOT NULL DEFAULT ’1′,
PRIMARY KEY (searchid),
UNIQUE KEY searchunique (searchhash, sortby, sortorder)
);