CREATE TABLE `goods_record1` (          
                 `recordId` int(10) NOT NULL,          
                 `price` bigint(10) default NULL,      
                 `volume` bigint(10) default NULL,     
                 `date` date default NULL,             
                 `goodsId` int(10) default NULL,       
                 PRIMARY KEY  (`recordId`)             
               ) ENGINE=InnoDB DEFAULT CHARSET=latin1 