/* project2.sql */



/* 1a. create an sql table for my products */
CREATE TABLE Project2Products(
    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
);

/* 1b. products for my products table */
INSERT INTO Project2Products(name, img, description, price, rating, stock)
VALUES
("Unresolved despite aids Version 2, 2005", "enrico-david.jpg", "Art by Enrico David - Charcoal, linseed oil, cobalt oil, aluminum kebab skewers, screws, acrylic paint on canvas", 100, 5, 1),
("Selfie, 2014", "nicole-eisenman.jpg", "Art by Nicole Eisenman - Oil on canvas", 200, 5, 1),
("Portrait of a Curator (In Memory of Beryl Wright), 2009", "kerry-james.jpg", "Art by Kerry James Marshall - Acrylic on PVC panel", 300, 5, 1),
("Maurice Payne, 2008", "david-hockney.jpg", "Art by David Hockney - Computer drawing in colors, printed on wove paper, with full margins", 400, 5, 1),
("Siren, 2021", "dennis-campay.jpg", "Art by Donnis Campay - Mixed Media", 500, 5, 0);



