CREATE TABLE my_table (
  c1 date NOT NULL,
  c2 varchar(32) NOT NULL default '',
  c3 varchar(5) NOT NULL default '',
  c4 tinyint(4) NOT NULL default '0',
  c5 datetime NOT NULL,
  c6 varchar(32) NOT NULL default '',
  c7 varchar(32) NOT NULL default '',
  c8 varchar(12) NOT NULL default '',
  c9 varchar(32) NOT NULL default '',
  c10 varchar(16) NOT NULL default '',
  c11 varchar(96) character set latin1 collate latin1_bin NOT NULL default 'N/A',
  c12 int(11) NOT NULL default '0',
  c13 varchar(32) NOT NULL default '',
  c14 int(10) unsigned default NULL,
  c15 int(10) unsigned default NULL,
  c16 varchar(28) character set latin1 collate latin1_bin NOT NULL default 'N/A',
  c17 tinyint(4) NOT NULL default '0',
  c18 decimal(9,6) default NULL,
  KEY datestamp_idx (c1)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;