CREATE TABLE IF NOT EXISTS `ShopBill` ( 
`Id` int(11) NOT NULL AUTO_INCREMENT, 
`CommandId` INT  NOT NULL,
`DateCreated` DATE  NOT NULL,
`Price` VARCHAR(200)  NOT NULL,
`Status` INT  NOT NULL,
`DatePay` DATE  NOT NULL,
PRIMARY KEY (`Id`),
CONSTRAINT `ShopCommand_ShopBill` FOREIGN KEY (`CommandId`) REFERENCES `ShopCommand`(`Id`)
) ENGINE=InnoDB  DEFAULT CHARACTER SET `utf8`; 