#reset.sql


#createProductTable.sql
#Table structure for table `my_Product`
DROP TABLE IF EXISTS `my_Product`;
CREATE TABLE `my_Product` (
  `product_id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `name` VARCHAR(40) NOT NULL,
  `catCode` VARCHAR(3) NOT NULL,
  `price` DECIMAL(6,2) NOT NULL,
  `quantity` INT NOT NULL,
  `image_file` VARCHAR(30) NOT NULL
);

INSERT INTO my_Product (product_id, name, catCode, price, quantity, image_file) VALUES
(1, 'Flat Iron', 'HC', 29.99, 15, 'flatIron.jpg'),
(2, 'Blow Dryer', 'HC', 32.50, 8, 'blowDryer.jpg'),
(3, 'Urban Beard Beard Oil', 'HC', 12.50, 15, 'urbanBeardOil.jpg'),
(4, 'Tangle Teezer Detangler Brush', 'HC', 15.50, 12, 'tangleTeezerBrush.jpg'),
(5, 'The Curology Face Cleanser', 'SC', 23.00, 10, 'faceCleanser.jpg'),
(6, 'Hawaiian Tropic Sunscreen Lotion', 'SC', 7.50, 12, 'htSunscreen.jpg'),
(7, 'Vaseline Petroleum Jelly', 'SC', 3.40, 13, 'vaselineJelly.jpg'),
(8, 'CeraVe Daily Moisturizing Lotion', 'SC', 18.99, 18, 'ceraveLotion.jpg'),
(9, 'The Ordinary Skincare Set', 'SC', 27.00, 15, 'ordinarySkincareSet.jpg'),
(10, 'Swanson Supplements', 'HW', 7.50, 15, 'swansonVitamins.jpg'),
(11, 'Tenzo Matcha Green Tea Powder', 'HW', 13.49, 10, 'tenzoTeaPowder.jpg'),
(12, 'Essie Nail Polish', 'BE', 8.86, 20, 'essieNailPolish.jpg'),
(13, 'Fenty Cream Lip Gloss', 'BE', 30.00, 12, 'fentyLipGloss.jpg'),
(14, 'Chanel Perfume', 'FR', 160.00, 15, 'chanelPerfume.jpg');


#createOrderTable.sql
#Table structure for table `my_Order`
DROP TABLE IF EXISTS `my_Order`;
CREATE TABLE `my_Order`
(
  `order_id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `customer_id` INT NOT NULL,
  `order_status` VARCHAR(2) NOT NULL,
  `date_time` DATETIME NOT NULL
);


#createOrderItemTable.sql
#Table structure for table `my_OrderItem`
DROP TABLE IF EXISTS `my_OrderItem`;
CREATE TABLE `my_OrderItem`
(
  `order_item_id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `order_item_name` VARCHAR(40) NOT NULL,
  `order_item_status` VARCHAR(2) NOT NULL,
  `order_id` INT NOT NULL,
  `product_id` INT NOT NULL,
  `quantity` INT NOT NULL,
  `price` DECIMAL(6,2) NOT NULL
);