CREATE TABLE Users (
  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  fname VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL
);
CREATE TABLE Products (  
  id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,  
  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
);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Product 1', 'product1.jpg', 'This is product 1', 1.99, 5, 0);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Product 2', 'product2.jpg', 'This is product 2', 13.99, 3, 1);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Product 3', 'product3.jpg', 'This is product 3', 12.99, 2, 1);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Product 4', 'product4.jpg', 'This is product 4', 11.99, 2, 1);
INSERT INTO Products(name, img, description, price, rating, stock)
VALUES('Product 5', 'product5.jpg', 'This is product 5', 111.99, 1, 0);
    -- WHERE NOT EXISTS 
    -- (SELECT login FROM Users WHERE login='test');