/*INSERT INTO Users(username, password) VALUES('testfname', 'test');
INSERT INTO Users(username, password) VALUES('test@test.com', 'testpassword');
*/

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


INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(1, 'Luffy Wanted Poster ', 5 , 'images/luffy_bounty.gif', 'Captain of the Straw Hats', 4.99, 0);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(2, 'Zoro Wanted Poster', 5 , 'images/zoro_bounty.gif', 'Second in command of The Straw Hat Pirates', 4.99, 0);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(3, 'Nami Wanted Poster', 5 , 'images/nami_bounty.gif', 'Navigator of The Straw Hat Pirates', 4.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(4, 'Usopp Wanted Poster', 3 , 'images/usopp_bounty.gif', 'The Straw Hats Sniper', 4.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(5, 'Sanji Wanted Poster', 4 , 'images/sanji_bounty.gif', 'Cook of The Straw Hat Pirates', 4.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(6, 'Tony Tony Chopper Wanted Poster', 5 , 'images/chopper_bounty.gif', 'Doctor of The Straw Hat Pirates', 4.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(7, 'Nico Robin', 4 , 'images/robin_bounty.gif', 'Archaeologist of The Straw Hat Pirates', 4.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(8, 'Franky', 3 , 'images/franky_bounty.gif', 'Shipwright of The Straw Hat Pirates', 4.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(9, 'Brook', 4 , 'images/brook_bounty.gif', 'Musician of The Straw Hat Pirates', 4.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(10, 'Jinbe', 4 , 'images/jinbe_bounty.gif', 'Helmsman of The Straw Hat Pirates', 4.99, 1);


INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(11, 'Charlotte Katekuri', 4 , 'images/katekuri_figure.gif', 'Second Son of the Charlotte Family with his trident Mogura', 21.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(12, 'Zoro', 5 , 'images/zoro_figure.gif', 'Zoro with Wado Ichimonji, Shisui, and Sandai Kitetsu', 24.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(13, 'Luffy', 4 , 'images/luffy_figure.gif', 'Armament Haki Luffy', 79.99, 1);


INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(14, 'Straw Hats Flag', 5 , 'images/flag.gif', 'Straw Hat Pirates Jolly Roger', 12.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(15, 'Volume 89', 5 , 'images/volume_89.gif', 'Volume 89', 8.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(16, 'Volume 92', 5 , 'images/volume_92.gif', 'Volume 92', 8.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(17, 'Volumes 1-23', 5 , 'images/volume_1-23.jpeg', 'Volume 92', 168.99, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(18, 'Boa Hancock Funko Pop', 5 , 'images/boa_pop.jpeg', 'Captain of the Kuja Pirates and former Warlord of the Sea', 20.00, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(19, 'Roronoa Zoro Funko Pop', 5 , 'images/zoro_pop.jpeg', 'Luffys right hand man, and second in command of The Straw Hat Pirates', 19.00, 1);

INSERT INTO Products(id, title, rating, img, description, price, stock) VALUES(20, 'Monkey D. Luffy Funko Pop', 4 , 'images/luffy_pop.jpeg', 'Captain of The Straw Hat Pirates', 16.00, 1);
*/
