CREATE TABLE `goods_record` (                                                                                                     
                `recordId` int(10) NOT NULL,                                                                                                    
                `price` float default NULL,                                                                                                     
                `volume` bigint(10) default NULL,                                                                                               
                `date` date default NULL,                                                                                                       
                `goodsId` int(10) default NULL,                                                                                                 
                PRIMARY KEY  (`recordId`),                                                                                                      
                KEY `FK_goods_record` (`goodsId`),                                                                                              
                CONSTRAINT `FK_goods_record` FOREIGN KEY (`goodsId`) REFERENCES `goods1` (`goodsId`)                                            
              ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC COMMENT='InnoDB free: 10240 kB; (`goodsId`) REFER `data/goods1`(`good'  
