انتقال

[mrsmhn]

سلام دوستان
نکاتی که گفته بودید را رعایت کردم ولی باز پیغام خطا از خودش در می کنه.پیغامش اینه:

Error
SQL query:

CREATE TABLE IF NOT EXISTS "mos_sitebanner"(

"bid"int( 11 ) NOT NULL ,
"cid"int( 11 ) NOT NULL default '0',
"type"varchar( 10 ) COLLATE latin1_general_ci NOT NULL default 'banner',
"name"varchar( 50 ) COLLATE latin1_general_ci NOT NULL default '',
"imptotal"int( 11 ) NOT NULL default '0',
"impmade"int( 11 ) NOT NULL default '0',
"clicks"int( 11 ) NOT NULL default '0',
"imageurl"varchar( 100 ) COLLATE latin1_general_ci NOT NULL default '',
"clickurl"varchar( 200 ) COLLATE latin1_general_ci NOT NULL default '',
"date"datetime default NULL ,
"showBanner"tinyint( 1 ) NOT NULL default '0',
"checked_out"tinyint( 1 ) NOT NULL default '0',
"checked_out_time"datetime NOT NULL default '0000-00-00 00:00:00',
"editor"varchar( 50 ) COLLATE latin1_general_ci default NULL ,
"custombannercode"text COLLATE latin1_general_ci,
PRIMARY KEY ( "bid" ) ,
KEY "viewbanner"( "showBanner" )
) AUTO_INCREMENT =14;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"mos_sitebanner" (
"bid" int(11) NOT NULL,
"cid" int(11) NOT NULL default '0' at line 1