-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathMockedData.txt
83 lines (74 loc) · 9.25 KB
/
MockedData.txt
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
INSERT INTO "Events" (event_name, description, start_date, finish_date, latitude, longitude, location, picture, cancelled, "createdAt", "updatedAt") VALUES
('Clean la Barceloneta', 'Bacon ipsum dolor amet fatback tenderloin cow strip steak drumstick biltong beef ribs pancetta ribeye shank swine. Pastrami pork flank, shankle burgdoggen turducken sirloin bacon ground round alcatra jowl leberkas meatloaf. Porchetta beef ribs swine corned beef burgdoggen meatball, chuck andouille alcatra bacon chicken jowl. Pig meatball pork loin frankfurter bresaola t-bone jowl. Flank capicola jowl swine, biltong cupim tenderloin spare ribs brisket meatball cow. Salami meatball kielbasa beef ribs.', '2020-05-22 01:28:00.84+01', '2020-05-22 01:28:00.84+01', 0, 0, 'Barcelona', 'https://images.unsplash.com/photo-1569254983547-44dc559f038f?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1351&q=80', false, NOW(), NOW()),
('Mass haircut for charity', 'Gumbo beet greens corn soko endive gumbo gourd. Parsley shallot courgette tatsoi pea sprouts fava bean collard greens dandelion okra wakame tomato. Dandelion cucumber earthnut pea peanut soko zucchini.', '2020-07-22T00:28:00.840Z', '2020-07-23T00:28:00.840Z', 0, 0, 'Munich', 'https://images.unsplash.com/photo-1518398046578-8cca57782e17?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=500&q=60', false, NOW(), NOW()),
('Help clean the English Garden', 'Turnip greens yarrow ricebean rutabaga endive cauliflower sea lettuce kohlrabi amaranth water spinach avocado daikon napa cabbage asparagus winter purslane kale. Celery potato scallion desert raisin horseradish spinach carrot soko. Lotus root water spinach fennel kombu maize bamboo shoot green bean swiss chard seakale pumpkin onion chickpea gram corn pea. Brussels sprout coriander water chestnut gourd swiss chard wakame kohlrabi beetroot carrot watercress. Corn amaranth salsify bunya nuts nori azuki bean chickweed potato bell pepper artichoke.', '2020-06-22T00:28:00.840Z', '2020-07-22T00:28:00.840Z', 0, 0, 'Munich', 'https://images.unsplash.com/photo-1588744349807-e5f0e99abed0?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1353&q=80', false, NOW(), NOW()),
('Donate blood', 'Nori grape silver beet broccoli kombu beet greens fava bean potato quandong celery. Bunya nuts black-eyed pea prairie turnip leek lentil turnip greens parsnip. Sea lettuce lettuce water chestnut eggplant winter purslane fennel azuki bean earthnut pea sierra leone bologi leek soko chicory celtuce parsley jícama salsify.', '2020-06-22T00:28:00.840Z', '2020-07-22T00:28:00.840Z', 0, 0, 'Australia', 'https://images.unsplash.com/photo-1579154341184-22069e4614d2?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1350&q=80', false, NOW(), NOW()),
('Art workshop for people in risk of exclusion', 'Celery quandong swiss chard chicory earthnut pea potato. Salsify taro catsear garlic gram celery bitterleaf wattle seed collard greens nori. Grape wattle seed kombu beetroot horseradish carrot squash brussels sprout chard.', '2020-06-22T00:28:00.840Z', '2020-07-22T00:28:00.840Z', 0, 0, 'Madrid', 'https://images.unsplash.com/photo-1519430044529-9a9a57177865?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1361&q=80', false, NOW(), NOW()),
('Introduction to Mexican culture', 'Celery quandong swiss chard chicory earthnut pea potato. Salsify taro catsear garlic gram celery bitterleaf wattle seed collard greens nori. Grape wattle seed kombu beetroot horseradish carrot squash brussels sprout chard.', '2020-06-29T00:28:00.840Z', '2020-07-29T00:28:00.840Z', 0, 0, 'London', 'https://images.unsplash.com/photo-1512813195386-6cf811ad3542?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1350&q=80', false, NOW(), NOW());
INSERT INTO "Orgs" (reg_number, phone_number, verified, org_name, about, email, password, address, profile_pic, active, notes, "createdAt", "updatedAt") VALUES
('1234DEQWT5FW4E', '4465685234534', true, 'Greenpeace', 'We believe that a billion acts of courage can spark a brighter tomorrow', 'greenpeace@greenpeace.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', 'allgreen 23, Manchester', 'https://i.imgur.com/qUGKiKv.png', true, 'No notes yet', NOW(), NOW()),
('6543WGDVWEAR23', '6543654324432', true, 'Children Care', 'No child should be left unattended', 'childrencare@childrencare.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', 'children road 24, Barcelona', 'https://images.unsplash.com/photo-1536429504175-6964eee46cd4?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=700&q=60', true, 'No notes yet', NOW(), NOW()),
('FREWAF5643263F', '6657651432543', true, 'Help the aged', 'Do not let your grandparents down', 'helptheaged@help.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', 'aged road 38, Paris', 'https://images.unsplash.com/photo-1422015347944-9dd46d16bd0b?ixlib=rb-1.2.1&auto=format&fit=crop&w=2250&q=80', true, 'No notes yet', NOW(), NOW()),
('GTREE7788CEWCC', '6586244556776', true, 'Bruce Grove Association', 'Taking care of the parties is what we do best', 'brucegrove@association.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', 'bruce grove 10, London', 'https://images.unsplash.com/photo-1563761739882-53d952647dcb?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1575&q=80', true, 'No notes yet', NOW(), NOW()),
('PV67653422FVTS', '7632353255777', true, 'Blank Keyboards Association', 'Psychologically helping those who have problems with regular keyboards', 'blankkeyboards@leonard.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', 'keyboard street 5, Munich', 'https://images.unsplash.com/photo-1529236183275-4fdcf2bc987e?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=700&q=60', true, 'No notes yet', NOW(), NOW()),
('REWR764843JJ76', '7687548937689', true, 'Animal Rescue Center', 'Taking care of animals is our passion', 'animals_are_great@lovingdonkies.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', 'Happy animal road 5, Bratislava', 'https://images.unsplash.com/photo-1522731135058-7999f3549ba6?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=700&q=60', true, 'No notes yet', NOW(), NOW());
INSERT INTO "Users" (user_name, about_me, email, password, address, profile_pic, active, karma, "createdAt", "updatedAt") VALUES
('Alejandro', 'I like reading, riding horses, painting', 'alejandro@yahoo.es', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', '72 Great avenue', 'https://images.unsplash.com/photo-1527980965255-d3b416303d12?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=800&q=80', 'true', -69, NOW(), NOW() ),
('Leonard', 'Im not that good at ping pong', 'leonard@yahoo.de', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', '3 ping pong street', 'https://images.unsplash.com/photo-1518928286447-dc161b7cd6fb?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1351&q=80', 'true', 1, NOW(), NOW() ),
('Mark', 'I like cleaning things', 'mark@yahoo.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', '1 mark street', 'https://images.unsplash.com/photo-1537815749002-de6a533c64db?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=500&q=60', 'true', 1, NOW(), NOW() ),
('Jessica', 'I like helping the ones in need', 'jessi@yahoo.com', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', '1 king street', 'https://images.unsplash.com/photo-1531927557220-a9e23c1e4794?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=634&q=80', 'true', 1, NOW(), NOW() ),
('Gerardine', 'Girlpower to make the world a better place', 'gerardine@yahoo.es', '$2b$10$U1Kw2wHxqA.TcaGCrFfvuOKmBvCOOwLV6IAhtTqHeTL.N0Zt3lerq', '1 Gerardine street', 'https://i.imgur.com/jMeRWuV.png', 'true', 1, NOW(), NOW() );
INSERT INTO "UsersEvents" ("createdAt", "updatedAt", "UserId", "EventId") VALUES
(NOW(), NOW(), 1, 2),
(NOW(), NOW(), 2, 3),
(NOW(), NOW(), 3, 4),
(NOW(), NOW(), 2, 4),
(NOW(), NOW(), 2, 5),
(NOW(), NOW(), 1, 5),
(NOW(), NOW(), 1, 1),
(NOW(), NOW(), 5, 6),
(NOW(), NOW(), 4, 2);
INSERT INTO "Tags" ("createdAt", "updatedAt", tag_name) VALUES
(NOW(), NOW(),'Hunger'),
(NOW(), NOW(),'Animals'),
(NOW(), NOW(),'Ecologism'),
(NOW(), NOW(),'Beach'),
(NOW(), NOW(),'Childcare'),
(NOW(), NOW(),'Ocean'),
(NOW(), NOW(),'Homeless'),
(NOW(), NOW(),'Food'),
(NOW(), NOW(),'Culture'),
(NOW(), NOW(),'Migrants'),
(NOW(), NOW(),'Healthcare');
INSERT INTO "TagsEvents" ("createdAt", "updatedAt","TagId", "EventId") VALUES
(NOW(), NOW(), 4, 1),
(NOW(), NOW(), 6, 1),
(NOW(), NOW(), 7, 2),
(NOW(), NOW(), 3, 3),
(NOW(), NOW(), 5, 4),
(NOW(), NOW(), 11, 4),
(NOW(), NOW(), 7, 5),
(NOW(), NOW(), 8, 6),
(NOW(), NOW(), 9, 6),
(NOW(), NOW(), 10, 6);
INSERT INTO "TagsOrgs" ("createdAt", "updatedAt","TagId", "OrgId") VALUES
(NOW(), NOW(), 1, 1),
(NOW(), NOW(), 2, 2),
(NOW(), NOW(), 3, 3),
(NOW(), NOW(), 5, 4),
(NOW(), NOW(), 4, 5);
INSERT INTO "EventsOrg" ("createdAt", "updatedAt", "OrgId", "EventId") VALUES
(NOW(), NOW(), 1, 1),
(NOW(), NOW(), 2, 2),
(NOW(), NOW(), 3, 3),
(NOW(), NOW(), 5, 4),
(NOW(), NOW(), 4, 5),
(NOW(), NOW(), 4, 6);
INSERT INTO "TagsUsers" ("createdAt", "updatedAt", "TagId", "UserId") VALUES
(NOW(), NOW(), 1, 1),
(NOW(), NOW(), 2, 2),
(NOW(), NOW(), 3, 3),
(NOW(), NOW(), 5, 4),
(NOW(), NOW(), 4, 5),
(NOW(), NOW(), 4, 1),
(NOW(), NOW(), 3, 1);