I tried to quote but there is a bug in vB in that it stops quoting everything after the first code/etc. block, so I can't see it.

I don't think you're supposed to specify a default on auto_increment -- you can set it to anything you want (DEFAULT 12345) and it always inserts the next highest number. One would think the AUTO_INCREMENT would be exempt from the NOT NULL error since it is a 'special case'.