CREATE TABLE IF NOT EXISTS `ShopProduct` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`ShopId` int(11) NOT NULL, 
`ParentId` int(11) NULL, 
`Name` VARCHAR(200)  NULL ,
`Code` VARCHAR(200)  NULL ,
`Description` TEXT  NULL ,
`Type` INT  NULL ,
`Status` INT  NULL ,
`Price` float NULL ,
`PriceTime` float NULL ,
`PriceDelay` int NULL ,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 