CREATE TABLE IF NOT EXISTS Products (
	id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	name VARCHAR(127) DEFAULT NULL,
	img VARCHAR(127) DEFAULT NULL,
	description VARCHAR(255) DEFAULT NULL,
	price DECIMAL(10,2) DEFAULT NULL,
	rating TINYINT UNSIGNED DEFAULT NULL,
	stock TINYINT UNSIGNED,
	PRIMARY KEY (id)
);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Cleanser', 'clean.jpg', 'On Wednesdays, we wash our face in pink', 8.49, 4, 0);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Toner', 'toner.jpg', 'Balance in luxury', 10.49, 5, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Essence', 'ess.jpg', 'Let it glow', 193.49, 3, 0);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Serum', 'serum.jpg', 'You can handle the truth', 24.99, 1, 1);

INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Moisturizer', 'moi.png', 'Restore your life with this', 12.99, 2, 1);


