CREATE SCHEMA `petstore` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ;
CREATE TABLE `petstore`.`t_product` (
`p_id` INT NOT NULL AUTO_INCREMENT,
`p_name` VARCHAR(45) NOT NULL,
`p_price` FLOAT NOT NULL,
PRIMARY KEY (`p_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;