dft

public text v1 · immutable

#374390

·published 2007-02-27 15:31 UTC

 326 #
    327 # Table structure for table 'Features'
    328 #
    329 DROP TABLE IF EXISTS Features;
    330 CREATE TABLE Features (
    331   ID int(3) DEFAULT '0' NOT NULL auto_increment,
    332   Feature_en varchar(30) DEFAULT '' NOT NULL,
    333   Feature_fr varchar(30) DEFAULT '' NOT NULL,
    334   ImageName varchar(30),
    335   BilingualImage char(3),
    336   Display char(3),
    337   PRIMARY KEY (ID)
    338 );

ERROR:

ERROR 1067 (42000): Invalid default value for 'ID'
ERROR 1146 (42S02): Table 'itv.Features' doesn't exist
ERROR 1146 (42S02): Table 'itv.Features' doesn't exist