Помощ за Сял-а :)

[stoqnski]

Имам този СЯЛ :

CREATE TABLE websites (
id INT(11) UNSIGNED AUTO_INCREMENT NOT NULL,
name VARCHAR(40) NOT NULL,
url VARCHAR(60) NOT NULL,
description VARCHAR(255) NOT NULL,
votes INT(11) UNSIGNED NOT NULL DEFAULT 0,
hits INT(11 UNSIGNED NOT NULL DEFAULT 0,
password CHAR(40) NOT NULL,
PRIMARY KEY(id)
);

Но като го импотирам ми давам тази грешка :

Грешка
SQL заявка: 

CREATE TABLE websites(

id INT( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL ,
name VARCHAR( 40 ) NOT NULL ,
url VARCHAR( 60 ) NOT NULL ,
description VARCHAR( 255 ) NOT NULL ,
votes INT( 11 ) UNSIGNED NOT NULL DEFAULT 0,
hits INT( 11 UNSIGNED NOT NULL DEFAULT 0, PASSWORD CHAR( 40 ) NOT NULL , PRIMARY KEY ( id ) ) 

MySQL отговори:  

#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 'UNSIGNED NOT NULL DEFAULT 0,
password CHAR(40) NOT NULL,
PRIMARY KEY(id)
)' at line 7

Някой може ли да ми го оправи (сял-а) ?

 

[skatebord]

CREATE TABLE websites (
id INT(11) UNSIGNED AUTO_INCREMENT NOT NULL,
name VARCHAR(40) NOT NULL,
url VARCHAR(60) NOT NULL,
description VARCHAR(255) NOT NULL,
votes INT(11) UNSIGNED NOT NULL DEFAULT 0,
hits INT(11) UNSIGNED NOT NULL DEFAULT 0,
password CHAR(40) NOT NULL,
PRIMARY KEY(id)
);

 

[stoqnski]

CREATE TABLE websites (
id INT(11) UNSIGNED AUTO_INCREMENT NOT NULL,
name VARCHAR(40) NOT NULL,
url VARCHAR(60) NOT NULL,
description VARCHAR(255) NOT NULL,
votes INT(11) UNSIGNED NOT NULL DEFAULT 0,
hits INT(11) UNSIGNED NOT NULL DEFAULT 0,
password CHAR(40) NOT NULL,
PRIMARY KEY(id)
);

+1