##
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;
####
m/`\w+\s+\w+[\s+\w+]+`/ # backticks