quickie.. query from version 3 into version 4.1?

[adi willow]

hi all.. having a newbie prob.

We recently upgraded servers which are now using 4.1 compared to our version 3 on the old server.

Anyway, i'm trying to run a query in version 4 which came from version 3, and are having trouble with these lines..

CREATE TABLE address_book (
address_book_id int(11) DEFAULT '' NOT NULL auto_increment,

Obviously this query worked fine with 3, but version 4 rejects it with an error of ! I managed to get round it by removing the auto_increment but, but that isnt a workable solution.

What i really need is the version 4 equivalent of the above query so it doesnt get rejected.. can anyone help?

The simpler the better :D

Or, perhaps a simple utility that will convert a version 4 to a version 4? and that wont take me ages to learn :D

cheers
adi