При выполнении запроса 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 'release varchar(10) NOT NULL, id_rel int(1) NOT NULL, tire tinyint(5) NOT NU' at line 22
SQL-запрос :
CREATE TABLE content (
id_content varchar(10) NOT NULL,
name varchar(100) NOT NULL default 'Не известно',
rus varchar(100) NOT NULL,
find_name varchar(255) NOT NULL,
name_word tinyint(2) unsigned NOT NULL,
rus_word tinyint(2) unsigned NOT NULL,
year int(3) NOT NULL,
color enum('','Black and White','Color') NOT NULL,
link_pic varchar(100) NOT NULL,
image varchar(100) NOT NULL,
budget int(10) NOT NULL,
first_box int(10) NOT NULL,
gross_box int(10) NOT NULL,
currency varchar(30) NOT NULL,
rating int(10) unsigned NOT NULL,
view enum('ok','no') NOT NULL default 'ok',
id_film int(3) unsigned NOT NULL auto_increment,
search_rating int(3) NOT NULL,
vote int(5) NOT NULL,
num_vote int(5) NOT NULL,
release varchar(10) NOT NULL,
id_rel int(5) NOT NULL,
tire tinyint(1) NOT NULL,
type varchar(20) NOT NULL,
flag set('','wallpaper','poster','kadr','trailer','site','sinopsys','info','product','news','review','events','cert') NOT NULL,
is_product tinyint(1) unsigned,
is_wallpaper tinyint(1) unsigned,
is_kadr tinyint(1) unsigned,
is_poster tinyint(1) unsigned,
is_trailer tinyint(1) unsigned,
PRIMARY KEY (id_content),
KEY id_film (id_film),
KEY view (view),
KEY year (year),
KEY color (color),
KEY id_rel (id_rel),
KEY name_word (name_word,rus_word),
KEY tire (tire),
KEY is_product (is_product),
KEY is_wallpaper (is_wallpaper),
KEY is_kadr (is_kadr),
KEY is_poster (is_poster),
KEY is_trailer (is_trailer),
KEY name (name,rus,find_name)
);
