خطأ
إستعلام-SQL:
CREATE TABLE rssfeed(
rssfeedid INT UNSIGNED NOT NULL AUTO_INCREMENT ,
title VARCHAR( 250 ) NOT NULL ,
url VARCHAR( 250 ) NOT NULL ,
port SMALLINT UNSIGNED NOT NULL DEFAULT '80',
ttl SMALLINT UNSIGNED NOT NULL DEFAULT '1500',
maxresults SMALLINT NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL ,
forumid SMALLINT UNSIGNED NOT NULL ,
iconid SMALLINT UNSIGNED NOT NULL ,
titletemplate MEDIUMTEXT NOT NULL ,
bodytemplate MEDIUMTEXT NOT NULL ,
searchwords MEDIUMTEXT NOT NULL ,
itemtype ENUM( 'thread', 'announcement' ) NOT NULL DEFAULT 'thread',
threadactiondelay SMALLINT UNSIGNED NOT NULL ,
endannouncement INT UNSIGNED NOT NULL ,
options INT UNSIGNED NOT NULL ,
lastrun INT UNSIGNED NOT NULL ,
PRIMARY KEY ( rssfeedid ) ,
KEY lastrun( lastrun )
)
MySQL قال:
#1050 - Table 'rssfeed' already exists