-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathinsertHackingProducts.sql
22 lines (15 loc) · 2.12 KB
/
insertHackingProducts.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
USE denoProduction;
INSERT INTO `denoProduction`.`categories` (`id`, `category`) VALUES ('1', 'outfits');
INSERT INTO `denoProduction`.`categories` (`id`, `category`) VALUES ('2', 'tools');
INSERT INTO `denoProduction`.`hackingProducts` (`id`, `price`, `imageFile`, `dateAdded`, `title`, `description`, `category`, `quantity`)
VALUES ('1', '10', '[\"https://res.cloudinary.com/dchpyunul/image/upload/v1595087406/denoshop/hackingProducts/outfits/300-300-max_fuhw8x.jpg\"]', '2020-07-05 05:15:49', 'Deno Cap', 'Elegant and simple cap empower your imagination.', 'outfits', '20');
INSERT INTO `denoProduction`.`hackingProducts` (`id`, `price`, `imageFile`, `dateAdded`, `title`, `description`, `category`, `quantity`)
VALUES ('2', '40', '[\"https://res.cloudinary.com/dchpyunul/image/upload/v1595087407/denoshop/hackingProducts/outfits/300-300-maxout_kakwk7.jpg\"]', '2020-07-05 05:15:49', 'Deno Hoodie', 'The hoodie you need to keep youself cozy while coding.', 'outfits', '40');
INSERT INTO `denoProduction`.`hackingProducts` (`id`, `price`, `imageFile`, `dateAdded`, `title`, `description`, `category`, `quantity`)
VALUES ('3', '20', '[\"https://res.cloudinary.com/dchpyunul/image/upload/v1595087413/denoshop/hackingProducts/tools/300-300-maxar_wydfde.jpg\"]', '2020-07-05 05:15:49', 'Arduino', 'The old but powerful micro-controller that every hacker should have!', 'tools', '240');
INSERT INTO `denoProduction`.`hackingProducts` (`id`, `price`, `imageFile`, `dateAdded`, `title`, `description`, `category`, `quantity`)
VALUES ('4', '50', '[\"https://res.cloudinary.com/dchpyunul/image/upload/v1595087415/denoshop/hackingProducts/tools/300-300-maxRa_vopg5q.jpg\"]', '2020-07-05 05:15:49', 'Raspberry Pi 4', 'Powerful but affordable credit-card size computer we all love!', 'tools', '430');
INSERT INTO `denoProduction`.`ProductRatings` (`id`, `hackingProductId`) VALUES ('1', '1');
INSERT INTO `denoProduction`.`ProductRatings` (`id`, `hackingProductId`) VALUES ('2', '2');
INSERT INTO `denoProduction`.`ProductRatings` (`id`, `hackingProductId`) VALUES ('3', '3');
INSERT INTO `denoProduction`.`ProductRatings` (`id`, `hackingProductId`) VALUES ('4', '4');