load_me_in_database.sql

/* PURGING ALL ITEM OLD DATA */
DROP TABLE itemidingame;
DROP TABLE itemvariations;

CREATE TABLE IF NOT EXISTS itemvariations (
    item varchar(50) NOT NULL,
    variationid int NOT NULL,
    variationname varchar(255) NOT NULL,
    FOREIGN KEY (item) REFERENCES itemsmetadata(`name`)
)ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS itemidingame (
    item varchar(50) NOT NULL,
    id int NOT NULL,
    FOREIGN KEY (item) REFERENCES itemsmetadata(`name`)
)ENGINE=InnoDB;
/* SHOES */

/* DELETE DATA FROM ITEMS METADATA */
DELETE FROM `itemsoncharters`;
DELETE FROM `inventory` WHERE `name` in (select `name` from itemsmetadata where `type` = 'clothing-shoes' or `type` = 'clothing-pants');
DELETE FROM `itemsmetadata` WHERE `type` = 'clothing-shoes' or `type` = 'clothing-pants';


/* Air Jordan 11 */
INSERT INTO `itemsmetadata` (`name`, `image`, `descriptiontitle`, `description`, `type`, `unit`, `weight`) VALUES (
 'AirJordan11',
 'AirJordan11.png',
 'Air Jordan 11 ',
 'Inspired by classic Jordan sneakers, these low-tops up your comfort with an extra-soft leather toe. Underfoot is soft, smooth foam with rubber pods in just the right spots for traction while webbing loops make lacing quick and easy.',
 'clothing-shoes', 'UNT', '900'
);

INSERT INTO `itemsmetadata` (`name`, `image`, `descriptiontitle`, `description`, `type`, `unit`, `weight`) VALUES (
 'NikeAirMax95',
 'NikeAirMax95.png',
 'Nike Air Max95',
 'Taking inspiration from the human body and 90s track aesthetics, the Air Max 95 mixes unbelievable comfort with fast-paced style. The wavy side panels add natural flow to any outfit while visible Nike Air in the heel and forefoot delivers performance comfort.',
 'clothing-shoes', 'UNT', '900'
);


INSERT INTO `itemidingame` (`item`, `id`) VALUES ('AirJordan11', '16');
INSERT INTO `itemidingame` (`item`, `id`) VALUES ('NikeAirMax95', '17');

INSERT INTO `itemvariations` (`item`, `variationid`, `variationname`) VALUES ('AirJordan11', '0', 'black & red');
INSERT INTO `itemvariations` (`item`, `variationid`, `variationname`) VALUES ('AirJordan11', '1', 'white');

INSERT INTO `itemvariations` (`item`, `variationid`, `variationname`) VALUES ('NikeAirMax95', '0', 'white & green');



/* PANTS */

INSERT INTO `itemsmetadata` (`name`, `image`, `descriptiontitle`, `description`, `type`, `unit`, `weight`) VALUES (
 'CroppedPants',
 'CroppedPants.png',
 'Cropped Pants',
 'The crop pant is not your traditional pair of womens dress slacks or work pants. Rather, these pants are elegantly tailored with a slim fit that falls to just above the ankle.',
 'clothing-pants', 'UNT', '1200'
);

INSERT INTO `itemidingame` (`item`, `id`) VALUES ('CroppedPants', '16');
INSERT INTO `itemvariations` (`item`, `variationid`, `variationname`) VALUES ('CroppedPants', '0', 'Brown');


INSERT INTO `itemsmetadata` (`name`, `image`, `descriptiontitle`, `description`, `type`, `unit`, `weight`) VALUES (
 'BaggyTrack',
 'BaggyTrack.png',
 'Baggy Track',
 'Track Pants are like Joggers but are usually made from materials like polyester that is smooth, soft, comfortable and wrinkle-free. These are usually worn for track events.',
 'clothing-pants', 'UNT', '1500'
);

INSERT INTO `itemidingame` (`item`, `id`) VALUES ('BaggyTrack', '17');
INSERT INTO `itemvariations` (`item`, `variationid`, `variationname`) VALUES ('BaggyTrack', '0', 'Black');