-
Notifications
You must be signed in to change notification settings - Fork 0
/
seed.sql
57 lines (47 loc) · 6.92 KB
/
seed.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
INSERT INTO sellers (username, hashed_password) VALUES ('jarryl', '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824');
INSERT INTO sellers (username, hashed_password) VALUES ('alvis', '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824');
INSERT INTO sellers (username, hashed_password) VALUES ('joey', '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824');
INSERT INTO users (username, hashed_password) VALUES ('joseph', '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824');
INSERT INTO users (username, hashed_password) VALUES ('harry', '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824');
INSERT INTO users (username, hashed_password) VALUES ('polly', '2cf24dba5fb0a30e26e83b2ac5b9e29e1b161e5c1fa7425e73043362938b9824');
INSERT INTO categories (category_name) VALUES ('food');
INSERT INTO categories (category_name) VALUES ('apparel');
INSERT INTO categories (category_name) VALUES ('tech');
INSERT INTO categories (category_name) VALUES ('games');
INSERT INTO categories (category_name) VALUES ('flowers');
INSERT INTO categories (category_name) VALUES ('beauty');
INSERT INTO categories (category_name) VALUES ('household');
INSERT INTO categories (category_name) VALUES ('pets');
INSERT INTO categories (category_name) VALUES ('sports');
INSERT INTO categories (category_name) VALUES ('hobbies');
INSERT INTO categories (category_name) VALUES ('automotive');
INSERT INTO shops (shop_name, image_url, about, category_id, seller_id) VALUES ('Jarryl', 'https://i2.wp.com/www.techgrapple.com/wp-content/uploads/2016/03/John-Lennon-Quote-FaceBook-Cover.jpg?resize=851%2C315&ssl=1', 'This is jarry''s shop', 2, 1);
INSERT INTO shops (shop_name, image_url, about, category_id, seller_id) VALUES ('Alvis', 'https://i.pinimg.com/originals/a7/d0/61/a7d061a54f31db9330dec99b28aab1ca.jpg', 'This is alvis''s shop', 1, 2);
INSERT INTO shops (shop_name, image_url, about, category_id, seller_id) VALUES ('Joey', 'https://3.bp.blogspot.com/-XI6_2cUTWQs/U-_hjqaDoNI/AAAAAAAAA1w/Eo4rhC_JiUk/s1600/youcovers.com_facebook%2Bcovers-photos-67.png', 'This is joey''s shop', 3, 3);
INSERT INTO reviews (review, rating, shop_id, user_id) VALUES ('seller was quick to respond, and patiently answered all my enquiries.', 4, 1, 3);
INSERT INTO reviews (review, rating, shop_id, user_id) VALUES ('seller took a long time to ship my items out.', 3, 1, 2);
INSERT INTO reviews (review, rating, shop_id, user_id) VALUES ('best cookies I''ve ever tried.', 5, 2, 3);
INSERT INTO reviews (review, rating, shop_id, user_id) VALUES ('seller never replied to my enquiry.', 1, 2, 1);
INSERT INTO reviews (review, rating, shop_id, user_id) VALUES ('quality of the headphone was okay.', 4, 3, 1);
INSERT INTO reviews (review, rating, shop_id, user_id) VALUES ('can''t expect much for the price I paid.', 2, 3, 2);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('My Smelly Socks', 'Socks, very smelly socks', 'https://thumbs.dreamstime.com/b/dirty-sock-bad-stench-sloppy-clothes-stinky-toe-grey-object-washing-cartoon-flat-illustration-green-wave-smelly-feet-175743396.jpg', 5, 3.20, 1, 2);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('Jacket', 'Stay warm', 'https://cdn.shopify.com/s/files/1/2694/4876/products/vne-98431-front-1.jpg?v=1587813320', 10, 2.00, 1, 2);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('Bjj Gi', 'I have no staph infection, i swear', 'https://www.bjjee.com/wp-content/uploads/2015/07/chris-haeuter.jpg', 15, 13.50, 1, 2);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('Cookies', 'Delicious homemade cookies', 'https://ak.picdn.net/shutterstock/videos/30274741/thumb/1.jpg', 1, 3.00, 2, 1);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('Ice Cream', 'You scream, i scream for ice cream', 'https://www.tasteofhome.com/wp-content/uploads/2018/08/waffle-cone-ice-creams.jpg', 7, 1.50, 2, 1);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('Cakes', 'Grab a slice', 'https://www.glorioustreats.com/wp-content/uploads/2018/05/top-down-view-of-strawberry-shortcake-cake-on-white-metal-cake-stand.jpg', 1, 12.70, 2, 1);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('Headphones', 'Disappear into a world of your own', 'https://massdrop-s3.imgix.net/product-images/massdrop-x-sennheiser-hd-58x-jubilee-headphones/FP/jbCgVcPdRXZC1YRI2oZ3_3qKeFvWGRbQ3wreRhIVc_58x_clear.png?bg=f0f0f0', 20, 120.30, 3, 3);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('iPhone', 'Give me all your money', 'https://www.smartgeneration.it/wp-content/uploads/2019/03/IPHONE-X-SILVER.jpg', 100, 1234.15, 3, 3);
INSERT INTO listings (listing_name, listing_details, image_url, quantity, price, shop_id, category_id) VALUES ('Film Camera', 'Capture the world', 'https://d2h1pu99sxkfvn.cloudfront.net/b0/5471486/372139983_eKTJQcOatS/P0.jpg', 1, 300.00, 3, 3);
INSERT INTO enquiries (item_name, enquirer_id, enquirer_name, email_address, query, shop_id) VALUES ('Jacket', 2, 'harry', 'h@gmail.com', 'What sizes do you have available?', 1);
INSERT INTO enquiries (item_name, enquirer_id, enquirer_name, email_address, query, shop_id) VALUES ('Cakes', 2, 'harry', 'h@gmail.com', 'What flavours do you have available?', 2);
INSERT INTO enquiries (item_name, enquirer_id, enquirer_name, email_address, query, shop_id) VALUES ('iPhone', 1, 'joseph', 'j@gmail.com', 'What''s the storage on this?', 3);
INSERT INTO enquiries (item_name, enquirer_id, enquirer_name, email_address, query, shop_id) VALUES ('My Smelly Socks', 1, 'joseph', 'j@gmail.com', 'Why are you selling this??', 1);
INSERT INTO enquiries (item_name, enquirer_id, enquirer_name, email_address, query, shop_id) VALUES ('Cookies', 3, 'polly', 'p@gmail.com', 'Do you have gluten-free options?', 2);
INSERT INTO enquiries (item_name, enquirer_id, enquirer_name, email_address, query, shop_id) VALUES ('Film Camera', 3, 'polly', 'p@gmail.com', 'Is this secondhand?', 3);
INSERT INTO responses (enquirer_id, respondent_id, enquiry_id, response) VALUES (2, 1, 1, 'S, M, L');
INSERT INTO responses (enquirer_id, respondent_id, enquiry_id, response) VALUES (2, 2, 2, 'Vanilla, Chocolate, and Matcha');
INSERT INTO responses (enquirer_id, respondent_id, enquiry_id, response) VALUES (1, 3, 3, '256gb');
INSERT INTO responses (enquirer_id, respondent_id, enquiry_id, response) VALUES (1, 1, 4, 'Why not?');
INSERT INTO responses (enquirer_id, respondent_id, enquiry_id, response) VALUES (3, 2, 5, 'Yes, we have alternatives for you to choose from!');
INSERT INTO responses (enquirer_id, respondent_id, enquiry_id, response) VALUES (3, 3, 6, 'Yes. Lightly used for a year.');