CREATE TABLE `stock` (
  `symbol` varchar(5) default NULL,
  `date` date default NULL,
  `price` double default NULL,
  `quantity` double default NULL,
  `trans` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`trans`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1