w11BAEWv

1CREATE  TABLE IF NOT EXISTS `category` (
2  `categoryID` INT NOT NULL AUTO_INCREMENT ,
3  `catName` VARCHAR(48) NOT NULL ,
4  `catParent` INT NOT NULL ,
5  PRIMARY KEY (`categoryID`) )
6ENGINE = InnoDB;
7
8CREATE  TABLE IF NOT EXISTS `product` (
9  `productID` INT NOT NULL AUTO_INCREMENT ,
10  `prodName` VARCHAR(72) NOT NULL ,
11  `prodDesc` VARCHAR(1024) NOT NULL ,
12  `prodPrice` DECIMAL(6,2) NOT NULL ,
13  `prodStock` INT NOT NULL ,
14  `prodImage` VARCHAR(32) NOT NULL ,
15  PRIMARY KEY (`productID`) )
16ENGINE = InnoDB;
17
18CREATE  TABLE IF NOT EXISTS `category_product` (
19  `category_categoryID` INT NOT NULL ,
20  `product_productID` INT NOT NULL ,
21  PRIMARY KEY (`category_categoryID`, `product_productID`) )
22ENGINE = InnoDB;