[sql]errore

[eliJS]

Cos'ha di sbagliato questo codice?

CREATE TABLE com (
  uid int(4) NOT NULL auto_increment,
  title varchar(150) NOT NULL default '',
  story varchar(150) NOT NULL default '',
  writer varchar(100) NOT NULL default '',
  inker varchar(100) NOT NULL default '',
  penciler varchar(100) NOT NULL default '',
  colorist varchar(100) NOT NULL default '',
  cover varchar(100) NOT NULL default '',
  price decimal(4,2) NOT NULL default '0.00',
  part varchar(20) NOT NULL default '',
  user1 varchar(100) NOT NULL default '',
  user2 varchar(100) NOT NULL default '',
  link1 varchar(150) NOT NULL default '',
  link2 varchar(150) NOT NULL default '',
  image varchar(150) NOT NULL default '',
  issue int(3) NOT NULL default '0',
  volume int(2) NOT NULL default '0',
  type varchar(50) NOT NULL default '',
  publisher varchar(50) NOT NULL default '',
  condition varchar(50) NOT NULL default '',
  format varchar(50) NOT NULL default '',
  plot text NOT NULL,
  value decimal(4,2) NOT NULL default '0.00',
  date date NOT NULL default '0000-00-00',
  bm varchar(10) NOT NULL default '',
  PRIMARY KEY  (uid),
  KEY uid (uid)
) TYPE=MyISAM; 

l'errore è:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition varchar(50) NOT NULL default '', format varchar(50) NOT NULL defaul' at line 21

[piero.mac]

condition

e' una reserved word ... parola riservata. Meglio cambiarla.

[eliJS]

grazie, non me n'ero accorto