SQlite syntax error, cant find it -


sorry noob question, i'm used mysql.

this sqlite query apparently has syntax error, can't find - see it?

create table `dash_viewports_dvi` ( `id_dvi` integer unsigned primary key not null autoincrement,   `panel_count_dvi` integer unsigned not null default 5,   `panel_size_dvi` integer unsigned not null default 6,   `name_dvi` text not null ); 

it's sqlite v. 3.7.13.

the error "near "autoincrement": syntax error".

autoincrementing fields must signed:

id_dvi integer primary key autoincrement, 

Comments