Does it show you that error? Because it compiles fine for me...
EDIT: Try now, i've tried changing something but even before it was compiling fine.
He means the table creation query. If you make a column auto_increment you must defined it as PRIMARY KEY or to add an index to it(in this case PRIMARY KEY will be perfect)