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'
2006-12-13
08:25:38
·
2 answers
·
asked by
Rj
3