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;