getting help with that first table

[qnc]

[sql]
CREATE TABLE works_info (
work_ID BLOB NOT NULL AUTO_INCREMENT ,
work_name VARCHAR( 255 ) NOT NULL ,
work_URL VARCHAR( 255 ) NOT NULL ,
authour_ID BLOB,
type_ID BLOB,
work_descript LONGTEXT,
sub_date DATE NOT NULL ,
PRIMARY KEY ( work_ID ) ,
UNIQUE (
work_name ,
work_URL
),
FULLTEXT (
work_descript
)
) COMMENT = 'first movie database'
[/sql]

tried to make this table to go with

http://www.phpbuilder.com/board/showthread.php?s=&postid=10577798#post10577798

but got
#1063 - Incorrect column specifier for column 'work_ID'
which on
http://dev.mysql.com/doc/mysql/en/Error-handling.html

says

Error: 1063 SQLSTATE: 42000 (ER_WRONG_FIELD_SPEC) Message: Incorrect column specifier for column '%s'

i will look up in my books tonight what I did wrong but wanted to get some comments here any suggestions.

I am using
phpMyAdmin 2.6.0-pl3
and
MySQL 4.0.22-standard

If that helps

[devinemke]

you have work_ID as an AUTO_INCREMENT BLOB primary key? that doesn't make much sense. i assume you want that to be an integer field of some type.

[qnc]

Yes like a unique identifer for each work when I tried mediumint it said error and I ran out of pateince in trying different options so I came to the boards.

Is that the only thing that is set up wrong also how do I set it up properly

I presume that this atble was not set up and so I just put in the CREATE....