-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsite.sql
182 lines (173 loc) · 10.5 KB
/
site.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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
USE peacles;
INSERT INTO user(id,username, email, password, phone, bio, profile_pic, roles, discr) VALUES
(1,"Sushi Taste","[email protected]", '$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0123456789,"The best Sushi restaurant in Gentilly ;3", NULL,'["ROLE_RESTO"]', "resto"),
(2,"Kebab de Paris", "[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0234567891, "Le premier Kebab avez zéro wesh", NULL,'["ROLE_RESTO"]', "resto"),
(3,"Ramesh food","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0723865423, "Indian kitchen, 10e tip minimum", NULL,'["ROLE_RESTO"]', "resto"),
(4,"La Revanche","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0654678201, "Jeux de société autours d'un verre, qu'a t'il de mieux?", NULL,'["ROLE_RESTO"]', "resto"),
(5,"Le Frog","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0789986565, "L'auberge de Marilou", NULL,'["ROLE_RESTO"]', "resto"),
(6,"Hippopotamus","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0612121212, "Hippo bio",NULL,'["ROLE_RESTO"]', "resto"),
(7,"Dans la cuisine","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0754235421, "Ici vous pourrez stalker vos profs pour leur parler de vos notes", NULL,'["ROLE_RESTO"]', "resto"),
(8,"La Frange","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Etes vous assez courageux pour tenter notre ambiance speciale?", NULL,'["ROLE_RESTO"]', "resto"),
(9,"Le Jap de Montrouge","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Qui a dit qu'il n'y a pas de jap a Montrouge?", NULL,'["ROLE_RESTO"]', "resto"),
(10,"Petit Lyon","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Ambiance lyonnaise", NULL,'["ROLE_RESTO"]', "resto"),
(11,"Des coupes de Champagne","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321,"Anniversaire? Funerailles? Buvez du champagne!", NULL,'["ROLE_RESTO"]', "resto"),
(12,"Smallworld","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321,"Anniversaires pour les enfants", NULL,'["ROLE_RESTO"]', "resto"),
(13,"Cinnaniv","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Cinema et anniversaire", NULL,'["ROLE_RESTO"]', "resto"),
(14,"IT","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Meilleur italien", NULL,'["ROLE_RESTO"]', "resto"),
(15,"Chai 33","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321,"Chai 33", NULL,'["ROLE_RESTO"]', "resto"),
(16,"Sushi world","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321,"Sushi World for sushi people", NULL,'["ROLE_RESTO"]', "resto"),
(17,"Veganista","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321,"Vegans forever(non)", NULL,'["ROLE_RESTO"]', "resto"),
(18,"Guiness Tavern","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321,"Bar en plein centreville", NULL,'["ROLE_RESTO"]', "resto"),
(19,"MnMs bar","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321,"M&Ms bar YES WE EXIST", NULL,'["ROLE_RESTO"]', "resto"),
(20,"Le paraids du fruit","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Parce que nous pouvons", NULL,'["ROLE_RESTO"]', "resto"),
(21,"Boulevard of bananas","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Bananas bananas bananas", NULL,'["ROLE_RESTO"]', "resto"),
(22,"Madeleines","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Madeleines bio (very original ye)", NULL,'["ROLE_RESTO"]', "resto"),
(23,"Canada dry","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Canada dry drinks only", NULL,'["ROLE_RESTO"]', "resto"),
(24,"Chipotle","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Chiiiiiipooooootle", NULL,'["ROLE_RESTO"]', "resto"),
(25,"Le Max","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Bar/Café | Come to see us", NULL,'["ROLE_RESTO"]', "resto"),
(26,"Jazz bar","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Good mysic and tasty food", NULL,'["ROLE_RESTO"]', "resto"),
(27,"Kebab Planet","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Kebabs forever", NULL,'["ROLE_RESTO"]', "resto"),
(28,"Sushi Planet","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "We are everywhere.Litterally.", NULL,'["ROLE_RESTO"]', "resto"),
(29,"Kinoa","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Quinoa? NO! Kinoa!", NULL,'["ROLE_RESTO"]', "resto"),
(30,"Locco Coco","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Esto Coco es un pocco locco", NULL,'["ROLE_RESTO"]', "resto"),
(31,"Chupa chups","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Have a birthday in a huge chupa chups", NULL,'["ROLE_RESTO"]', "resto"),
(32,"Tastes Good","[email protected]",'$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi',0987654321, "Calm and nice cafe", NULL,'["ROLE_RESTO"]', "resto"),
(33, "Frederic", "[email protected]", '$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Marilou lover", NULL, '["ROLE_CLIENT"]',"client"),
(34, "Megumin", "[email protected]", '$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "EXPLOSION", NULL, '["ROLE_CLIENT"]', "client"),
(35, "Snowden", "[email protected]", '$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0000000001, "___", NULL, '["ROLE_CLIENT"]', "client"),
(36, "Felix", "[email protected]", '$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Anime, reddit, love", NULL, '["ROLE_CLIENT"]', "client"),
(37, "Stalker", "[email protected]", '$2b$10$1QCAh0geIle.ci32HiBzKOj3HZw9Nv.rFwIEHESweugqmlY5wAFNi', 0987654321, "Here just to watch", NULL, '["ROLE_CLIENT"]', "client");
INSERT INTO client(id, bday) VALUES
(33,'2008-5-31'),
(34,'2000-11-11'),
(35,'2003-11-17'),
(36,'2008-11-11'),
(37,'1997-12-11');
INSERT INTO restaurant(id,address, min_age, min_seats, max_seats) VALUES
(1,"38 Rue Léon Savoye Sevran", 0, 10, 16),
(2,"1 Rue de la Butte aux Cailles Paris", 0, 10, 16),
(3,"1795 Hollywood Boulevard Los Angeles", 0, 10, 16),
(4,"Rue 12.202, Djako Daho, Cotonou", 0, 10, 16),
(5,"18, Boulevard Steinmetz, Ganhi", 0, 10, 16),
(6,"Bosques de la Pradera, 37500 León, GUA", 0, 10, 16),
(7,"31 Avenue du Président Nelson Mandela Arcueil", 0, 10, 16),
(8,"59 Gravelly Hill North Birmingham", 18, 10, 16),
(9,"9 Nelson Road, Birmingham",0, 10, 16),
(10,"1 Rue Victor Cousin Paris",0, 10, 16),
(11,"Strømsveien, 0663 Oslo,",18, 10, 16),
(12,"Seterbratveien 49, 1271 Oslo",0, 10, 16),
(13,"9 Rue Jean François de la Pérouse", 0, 10, 16),
(14,"4 Avenue de l'Europe Massy",0, 10, 16),
(15,"11 Avenue de Champagne Les Ulis",0, 10, 16),
(16,"3137 Rosedale Boulevard, Louisville, KY 40220",0, 10, 16),
(17,"15159 Jackal Street Northwest Ramsey",18, 10, 16),
(18,"Akinuro",0, 10, 16),
(19,"Otawara, Préfecture de Tochigi",18, 10, 16),
(20,"5560 Wellesley Drive Brents Junction,",18, 10, 16),
(21,"Harbury Crescent, Manchester M22 8LY",18, 10, 16),
(22,"Ex Ferrovia Spoleto Norcia, 06041 Cerreto di Spoleto PG",18, 10, 16),
(23,"27 Rue de la Violoune Cuzion",18, 10, 16),
(24,"222 Rue Paul Bert Lyon",18, 10, 16),
(25,"13 Villa des Fleurs Montrouge",18, 10, 16),
(26,"58 Rue de la Madeleine, Lyon ",18, 10, 16),
(27,"13 Rue Arthur Rimbaud Lyon",18, 10, 16),
(28,"15 Rue André Theuriet Aulnay-sous-Bois",18, 10, 16),
(29,"Via G. Bruni 53014 Monteroni d'Arbia SI",18, 10, 16),
(30,"Boulevard Bicentenario, 98605 Guadalupe, ZAC",18, 10, 16),
(31,"9 Place de l'Astrolabe Ottawa",18, 10, 16),
(32,"Madore Avenue, Coquitlam, Colombie-Britannique V3L 3P4",18, 10, 16);
INSERT INTO location(id_resto_id,latitude,longitude) VALUES
(1, 48.81494480, 2.33214620),
(27,45.7877,4.793589999999995),
(31,45.4979789,-75.4724051),
(14,48.7269,2.283),
(10,48.7267,2.2781099999999697),
(4,34.1015991,-118.3311477),
(20,34.16173274637727,-118.6794143518539),
(17,45.24756093829076,-93.47788270321803),
(23,46.48298110262296,1.6089467983692884),
(11,48.84837753127895,2.3430558439577),
(15,48.6891,2.173400000000015),
(25,48.8154898,2.3144544),
(26,45.7466,4.847790000000032),
(24,45.756863604747835,45.756863604747835),
(2,48.942279106023705,2.511052040283971),
(28,48.925161233164644,2.485700713262986),
(3,48.82786494869241,2.3515300804535855),
(29,43.222888,11.4223699),
(22,42.82167572165322,12.938305106530606),
(8,52.51841544495091,-1.8476753622215938),
(9,52.509067,-1.8873575),
(18,35.731042,139.217028),
(19,36.81888619346535,140.01569508226567),
(13,59.82582897537723,10.834417290156352),
(12,59.9140455056452,10.803042484262619),
(5,6.36541302234957,2.3937746694025464),
(6,6.357922153387492,2.43718067892587),
(32,49.246107449704425,-122.86041006761792),
(30,22.741574616993194,-102.50166815960807),
(7,21.08590578148778,-101.6588071207857),
(16,38.214543785288356,-85.64949658591269),
(21,53.389975710793586,-2.2652649695452283);
INSERT INTO specialty(id, cuisine) VALUES
(1,"thai"),
(2,"sushi"),
(3,"japanese"),
(4,"chinese"),
(5,"indian"),
(6,"russian"),
(7,"fruits"),
(8,"bar"),
(9,"libanese"),
(10,"nightclub"),
(11,"salads"),
(12,"kebab"),
(13,"tunisian"),
(14,"children"),
(15,"fastfood"),
(16,"luxury"),
(17,"jus"),
(18,"italian"),
(19,"music"),
(20,"games"),
(21,"outdoor"),
(22,"indoor"),
(23,"breakfast"),
(24,"dinner"),
(25,"sports"),
(26,"french"),
(27,"pub"),
(28,"coffee"),
(29,"tea"),
(30,"burger"),
(31,"healthy"),
(32,"fun"),
(33,"calm"),
(34, "wine");
INSERT INTO restaurant_specialty(restaurant_id, specialty_id) VALUES
(14, 18),
(14, 34),
(14, 17),
(5, 32),
(5, 27),
(1, 2),
(9,2),
(16,2),
(28,2),
(29, 15),
(29,31),
(29,11),
(4,8),
(4,20),
(4, 34),
(2, 15),
(14, 15),
(19, 15),
(20, 15),
(27, 15),
(20, 11),
(15, 8),
(15, 19),
(15,23),
(15, 24),
(15, 26);