IIRC, you can't auto-increment a column other than the primary key. I could be wrong but that's my recollection.

Edit: Sorry, I looked in my book and the syntax for your primary key assignment looks fine. Perhaps the mistake is that you aren't assigning a table name