Why am I getting this MySQL error and how do I fix it?

Question

SQL query:

CREATE TABLE tickets(
ticket int( 10 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT ,
author varchar( 100 ) DEFAULT '' NOT NULL ,
recipient varchar( 100 ) DEFAULT '' NOT NULL ,
subject varchar( 100 ) DEFAULT '' NOT NULL ,
attachment tinyint( 1 ) unsigned DEFAULT '0' NOT NULL ,
timestamp int( 10 ) unsigned DEFAULT '0' NOT NULL ,
TYPE varchar( 15 ) DEFAULT '' NOT NULL ,
assignment int( 10 ) unsigned DEFAULT '0' NOT NULL ,
parent int( 10 ) unsigned DEFAULT '0' NOT NULL ,
activity int( 10 ) unsigned DEFAULT '0' NOT NULL ,
priority tinyint( 1 ) unsigned DEFAULT '1' NOT NULL ,
cc varchar( 100 ) DEFAULT '' NOT NULL ,
body text NOT NULL ,
PRIMARY KEY ( ticket ) ,
KEY parent( parent ) ,
KEY TYPE ( TYPE )
);

MySQL said: Documentation
#1067 - Invalid default value for 'ticket'

Answer 1

For an AUTO_INCREMENT, you should not put a default value.

Try this instead:

ticket int(10) NOTNULL AUTO_INCREMENT PRIMARY KEY,

Answer 2

As you are using auto_increment to generate a unique number it cannot have a default of 0 as the default will be set by the auto_increment