CREATE TABLE recipe (
   id int(8) unsigned NOT NULL auto_increment,
   letter varchar(8) NOT NULL default'',
   name varchar(255) NOT NULL default '',
   definition text NOT NULL,
   state char(1) NOT NULL default 'D',
   comments smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY (id),
   UNIQUE id (id),
   KEY letter (letter),
   KEY name (name),
   FULLTEXT KEY search (name,definition)
);