CREATE TABLE Users (
    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fname VARCHAR(225) NOT NULL,
    email VARCHAR(255) NOT NULL, 
    username VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
);

CREATE TABLE Products (
    id INT(30) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(127) DEFAULT NULL, 
    img VARCHAR(127) DEFAULT NULL, 
    description VARCHAR(225) DEFAULT NULL,
    price decimal(10, 2) DEFAULT NULL,
    rating TINYINT UNSIGNED DEFAULT NULL,
    stock TINYINT(8) UNSIGNED
);

INSERT INTO Products(name, img, description, price, rating, stock) 
values(
    ('Alita Battle Angel','./images/alitabattleangel.jpg', 'In the epic adventure of hope and empowerment cyborg. Alita searches for clues about her past when she was awoken in the future world like no other.', '15.99', 5, 1),
    ('Avengers: Infinity War', './images/avengersinfinitywar.jpeg', 'A cinematic ten years of making the entire Marvel Univers, The "Avengers: Infinity War" brings the ultimate showdown of all time. The Avengers and their Super Hero allies must be willing to sacrifice all in an attempt to defeat the all powerful Thanos.', '19.99', 4, 1),
    ('In Time', './images/intime.jpeg', 'The plot revolves around the interesting idea that time is the new currency and rules the world like the Dollar once used to. The poor must fight for their lives to live their days, the rich are practically immortal to survive through time.', '9.99', 5, 1),
    ('Maze Runner', './images/mazerunner.jpeg', 'In the heart-pounding survival thriller based on the selling novel, Thomas wakes up trapped in the never changing maze with a group of boys who have no memory of the out side world. Facing the obstacles in every turn with the grievers that roam the concrete at night, Thomas and the others must race through the maze to find the way out before it is too late', '9.99', 3, 1),
    ('Passengers', './images/passengers.jpg', 'Aurora and Jim were onboard a spaceship transporting them to a new life on a nother planet which takes 90 years to reach their destination. Although, the trip takes a deadly turn when their hibernation pods anonymously wake them up. As they try to unravelt he mystery behind the malfunciton, they discover that the ship itself is in danger. There were a total of 5,000 of sleeping passenger at state, Jim and Aurora can save them all.', '9.99', 4, 1),
    ('Spider Man: Far From Home', './images/spidermanfarfromhome.jpg', 'The events of Avengers: Endgame has passed, Spider-Man must step up to take on new threats in a world that has changed forever.', '19.99', 4, 1),
    ('Thor', './images/thor.jpg', 'The world has many heroes, but only one is a god. The arrogant warrior Thor is banished to Earth from his homeworld of Asgard, he must regain his lost powers by fighting. The mighty Thor was pursued by an invasion force as he must rist tot he battle and learn what it takes to become a true hero.', '14.99', 4, 1),
    ('Transformers: The Last Knight', './images/transformersthelastknight.jpg', 'A deadly threat fro Earths history reappears, and a hunt for a lost artifact takes place between Autobots and Decepticons, while Optimus Prime encounters his creator in space and awakes him into the truth.', '19,99', 5, 1)
);


