CREATE TABLE 1_ticklist (
  id int(10) unsigned NOT NULL auto_increment,
  sym char(5) NOT NULL default '',
  zeit timestamp(14) NOT NULL,
  kurs mediumint(8) unsigned NOT NULL default '0',
  volumen mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY zeitid (zeit,id)
) TYPE=MyISAM PACK_KEYS=1 COMMENT='Tickerliste';