create table `table_name`(
   `field_name1` type1 not null default 'x',
   `field_name2` type2 default null,
   ...
   primary key (`pk_name`),
   key `key_name` (`field_name1`, `field_name2`)
) engine=other things here;