#createProductTable.sql
#Table structure for table 'my_Product'

DROP TABLE IF EXISTS my_Product;
CREATE TABLE my_Product
(
	'product_id' INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	'product_name' VARCHAR(40) NOT NULL,
	'product_category_code' VARCHAR(3) NOT NULL,
	'product_price' DECIMAL(6,2) NOT NULL,
	'product_quantity' INT NOT NULL,
	'product_image_url' VARCHAR(30) NOT NULL
);
