-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathseed.sql
60 lines (58 loc) · 11.5 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
57
58
59
60
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('c90e8efd-35f7-42d0-97a8-a621ac176768', 'jkeuleya', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Jean-Michel', 'Keuleyan', 'MAN', 'xxx', '48.8965568,2.3163477', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); #42
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('8801f84a-81e7-4bf3-b433-88684240a851', 'user1', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Alain', 'Lussier', 'MAN', 'xxx', '48.894092,2.314158', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Porte de Clichy
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('4c142618-5720-45de-bd00-7de76428fb05', 'user2', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Marc', 'Varden', 'MAN', 'xxx', '48.892725,2.327201', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Guy Moquet
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('cc003c50-17d0-4c46-9abe-53dec3a4b5c9', 'user3', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Paul', 'Fouquet', 'MAN', 'xxx', '48.887645,2.325382', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # La Fourche
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('f3a80b83-755f-48d3-af4a-43af10ac112a', 'user4', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Catherine', 'Fremont', 'WOMAN', 'xxx', '48.876048,2.324591', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Saint Lazare
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('234bc097-e7f1-4d51-8691-cb38a9e7088c', 'user5', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Pauline', 'Labbe', 'WOMAN', 'xxx', '48.880885,2.355140', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Gare du Nord
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('a279879b-8c26-4e04-a82d-465fd9b0b7d7', 'user6', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Chloe', 'Girard', 'WOMAN', 'xxx', '48.868987,2.340585', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Bourse
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('b8a2bd25-917b-4717-9606-906cb7a59fd0', 'user7', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Gaetan', 'Brousseau', 'MAN', 'xxx', '48.866228,2.323621', NULL, 'HOMO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Concorde
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('16abf513-ed05-4997-a85f-e783c8c7f920', 'user8', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Laurie', 'Voisine', 'WOMAN', 'xxx', '48.861780,2.346970', NULL, 'HOMO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Chatelet
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('8f1556fc-e53f-46a5-9c65-8ddd29d3d716', 'user9', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Gautier', 'Frappier', 'MAN', 'xxx', '48.839001, 2.330632', NULL, 'HOMO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Raspail
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('2b2ba1c4-a3c1-4216-837e-1668f0b3b975', 'user10', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Deborah', 'Francoeur', 'WOMAN', 'xxx', '48.791482,2.402023', NULL, 'HOMO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Vitry (banlieue)
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('f00aec2f-6793-47a1-9226-8ca33149142d', 'user11', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Axel', 'Cormier', 'MAN', 'xxx', '48.801722,2.124218', NULL, 'BI', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Versailles (banlieue)
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('eab91049-8d88-454c-823a-b09571e3a551', 'user12', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Sixtine', 'Cantin', 'WOMAN', 'xxx', '48.986869,2.441039', NULL, 'BI', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Gonesse (banlieue)
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('03a37c25-ceaf-4212-a8da-ea01b4c6f541', 'user13', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Remi', 'Dennis', 'MAN', 'xxx', '48.962067,2.554927', NULL, 'BI', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Villepinte (banlieue)
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('24c9a3f4-90fa-4490-8e44-f4d74f1bfb35', 'user14', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Julie', 'Hervieux', 'WOMAN', 'xxx', '48.791964,2.452215', NULL, 'BI', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Créteil (banlieue)
INSERT INTO `sql8193488`.`users` (`id`, `username`, `password`, `mail`, `firstname`, `lastname`, `gender`, `bio`, `location`, `picture`, `orientation`, `score`, `status`, `last_visit`, `register_date`) VALUES ('41093145-40c7-4a9b-ac5a-3a6a1664b24b', 'user15', '$2a$06$Jh4jkBWTBglDLjPfHggeH.eFZF0hwcfoDG6fx/34bmpEmWYY7xz.6', '[email protected]', 'Sarah', 'Heureux', 'WOMAN', 'xxx', '48.727412,2.362808', NULL, 'HETERO', '0', 'CONFIRMED', NULL, CURRENT_TIMESTAMP); # Orly ADP (banlieue)
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (1, 'first');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (2, 'second');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (3, 'third');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (4, 'fourth');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (5, 'fifth');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (6, 'sixth');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (7, 'seventh');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (8, 'eighth');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (9, 'nineth');
INSERT INTO `sql8193488`.`tags`(`id`, `name`) VALUES (10, 'tenth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('c90e8efd-35f7-42d0-97a8-a621ac176768', 'first');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('c90e8efd-35f7-42d0-97a8-a621ac176768', 'second');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('8801f84a-81e7-4bf3-b433-88684240a851', 'third');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('8801f84a-81e7-4bf3-b433-88684240a851', 'fourth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('4c142618-5720-45de-bd00-7de76428fb05', 'fifth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('4c142618-5720-45de-bd00-7de76428fb05', 'sixth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('cc003c50-17d0-4c46-9abe-53dec3a4b5c9', 'seventh');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('cc003c50-17d0-4c46-9abe-53dec3a4b5c9', 'eighth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('f3a80b83-755f-48d3-af4a-43af10ac112a', 'nineth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('f3a80b83-755f-48d3-af4a-43af10ac112a', 'tenth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('234bc097-e7f1-4d51-8691-cb38a9e7088c', 'first');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('234bc097-e7f1-4d51-8691-cb38a9e7088c', 'second');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('a279879b-8c26-4e04-a82d-465fd9b0b7d7', 'third');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('a279879b-8c26-4e04-a82d-465fd9b0b7d7', 'fourth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('b8a2bd25-917b-4717-9606-906cb7a59fd0', 'fifth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('b8a2bd25-917b-4717-9606-906cb7a59fd0', 'sixth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('16abf513-ed05-4997-a85f-e783c8c7f920', 'seventh');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('16abf513-ed05-4997-a85f-e783c8c7f920', 'eighth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('8f1556fc-e53f-46a5-9c65-8ddd29d3d716', 'nineth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('8f1556fc-e53f-46a5-9c65-8ddd29d3d716', 'tenth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('2b2ba1c4-a3c1-4216-837e-1668f0b3b975', 'first');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('2b2ba1c4-a3c1-4216-837e-1668f0b3b975', 'second');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('f00aec2f-6793-47a1-9226-8ca33149142d', 'third');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('f00aec2f-6793-47a1-9226-8ca33149142d', 'fourth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('eab91049-8d88-454c-823a-b09571e3a551', 'fifth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('eab91049-8d88-454c-823a-b09571e3a551', 'sixth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('03a37c25-ceaf-4212-a8da-ea01b4c6f541', 'seventh');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('03a37c25-ceaf-4212-a8da-ea01b4c6f541', 'eighth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('24c9a3f4-90fa-4490-8e44-f4d74f1bfb35', 'nineth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('24c9a3f4-90fa-4490-8e44-f4d74f1bfb35', 'tenth');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('41093145-40c7-4a9b-ac5a-3a6a1664b24b', 'first');
INSERT INTO `sql8193488`.`user_tags`(`user`, `tag`) VALUES ('41093145-40c7-4a9b-ac5a-3a6a1664b24b', 'second');