use aburt

CREATE TABLE Products(
    prod_id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
    prod_name VARCHAR(127) DEFAULT NULL,
    prod_img VARCHAR(127) DEFAULT NULL,
    prod_description VARCHAR(511) DEFAULT NULL,
    prod_price DECIMAL(10,2) DEFAULT NULL,
    prod_rating TINYINT UNSIGNED DEFAULT NULL,
    prod_sku CHAR(32) DEFAULT NULL,
    prod_stock INT(10) UNSIGNED
);


insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Crab Rave','crabrave.PNG','"Crab Rave" is a house song composed by Irish electronic music producer Noisestorm and released by Monstercat in 2018.',57.86,5,'92115',4
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Big Chungus','chungus.PNG','Big Chungus refers to an image of the cartoon character Bugs Bunny, usually captioned with the phrase "Big Chungus" and presented as a game for PlayStation 4 console. The word "chungus" was coined by video game journalist Jim Sterling several years before the meme became popular.',100.00,4,'26288',9
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Man\'s not hot','mansnothot.PNG','"Man\'s Not Hot", also known as The Ting Goes, refers to a viral video by English comedian Michael Dapaah from his web series #SWIL.'429.99,5,'47752',3
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Mocking Spongebob','spongebob.PNG','Mocking SpongeBob, also known as Spongemock, refers to an image macro featuring cartoon character SpongeBob SquarePants in which people use a picture of SpongeBob to indicate a mocking tone towards an opinion or point of view.',24.99,4,'33384',1
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Damn Gina','damngina.PNG','Distracted Boyfriend, also known as Man Looking at Other Woman, is an object labeling stock photo series in which a man looks at the backside of a woman walking by while another woman, presumably his romantic partner, looks on disapprovingly',154.23,3,'15310',0
);

insert into Products (prod_name,prod_img,prod_description,prod_price,prod_rating,prod_sku,prod_stock) VALUES (
    'Trumpet Boy','trumpetboy.PNG','Trumpet Boy is the nickname given to a boy playing the brass instrument within earshot of a girl. Upon surfacing online in January 2018, the image went viral and spawned a series of image macros and object labeled jokes.',789.99,2,'21213',6
);
