9yLr4NWP

1CREATE TABLE IF NOT EXISTS product (
2  product_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
3  product_name VARCHAR(255) NOT NULL, 
4  description TEXT DEFAULT NULL,
5  quantity INT(11) DEFAULT NULL, 
6  price DECIMAL(15,4) NOT NULL,
7  PRIMARY KEY (product_id)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10CREATE TABLE IF NOT EXISTS product_category (
11  category_id INT(11) UNSIGNED NOT NULL,
12  product_id INT(11) UNSIGNED NOT NULL,
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14
15CREATE TABLE IF NOT EXISTS product_image(
16  image_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
17  product_id INT(11) UNSIGNED NOT NULL,
18  image VARCHAR(150) NOT NULL, 
19  PRIMARY KEY (image_id)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8;
21	
22ALTER TABLE product_category 
23ADD CONSTRAINT fk_product_category
24FOREIGN KEY (product_id) REFERENCES product(product_id) 
25ON UPDATE CASCADE 
26ON DELETE CASCADE; 
27
28ALTER TABLE product_image 
29ADD CONSTRAINT fk_product_image
30FOREIGN KEY (product_id) REFERENCES product(product_id) 
31ON UPDATE CASCADE 
32ON DELETE CASCADE;