CREATE TABLE `goods2` (                  
          `goodsId` int(10) NOT NULL,            
          `goodsCode` varchar(10) default NULL,  
          `goodsName` varchar(10) default NULL,  
          PRIMARY KEY  (`goodsId`)               
        ) ENGINE=InnoDB DEFAULT CHARSET=latin1   