-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdump.sql
394 lines (275 loc) · 81.2 KB
/
dump.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
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
INSERT INTO public.directus_folders (id, name, parent) VALUES ('48e39cd0-878d-4850-a6d5-5f903bd0c2fb', 'public', NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('9dcbb848-a25a-4e75-af0a-abbd1c4555ea', 'members', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('8890baa5-447e-45a3-a573-95c76830e876', 'news', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('24a99ee1-4eee-48e1-9960-d51b5a105016', 'partners', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('82caf9c9-995b-404f-ba7e-76f704a6dd3e', 'association', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('07d9aa98-227f-4d9a-916f-e19f30cda26a', 'commissions', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('2fd1d075-83a4-40b7-902e-b46a0d861dfe', 'gallery', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('18e98463-e2a4-4c82-965f-b598cb9e6370', 'icbd', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_folders (id, name, parent) VALUES ('c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', 'subsonic', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_users (id) VALUES ('49733485-a937-4776-a34b-914ed2b5ce16') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('96528949-66cf-46f0-9f58-a8a751cab0bf', 'local', '96528949-66cf-46f0-9f58-a8a751cab0bf.svg', 'hands.svg', 'Hands', 'image/svg+xml', '82caf9c9-995b-404f-ba7e-76f704a6dd3e', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:09:21.274+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:34:21.152+00', NULL, 642, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 15:34:21.146+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('a611dfcb-e0fe-4676-906a-ea30de498271', 'local', 'a611dfcb-e0fe-4676-906a-ea30de498271.svg', 'github.svg', 'GitHub', 'image/svg+xml', '82caf9c9-995b-404f-ba7e-76f704a6dd3e', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:09:09.069+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:34:14.169+00', NULL, 823, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 15:34:14.162+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('e1b6e938-b822-4753-bbba-ed11f1298eb3', 'local', 'e1b6e938-b822-4753-bbba-ed11f1298eb3.svg', 'material-symbols--file-copy-rounded.svg', 'Material Symbols File Copy Rounded', 'image/svg+xml', '82caf9c9-995b-404f-ba7e-76f704a6dd3e', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:10:37.779+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:34:06.812+00', NULL, 429, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 15:34:06.804+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('be745b5d-038e-49bb-b28f-f39d1849edd4', 'local', 'be745b5d-038e-49bb-b28f-f39d1849edd4.svg', 'instagram.svg', 'Instagram', 'image/svg+xml', '82caf9c9-995b-404f-ba7e-76f704a6dd3e', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:08:59.057+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:33:49.49+00', NULL, 1288, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 15:33:49.484+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('5c869681-4ad8-4699-a6f8-a3f069ba9771', 'local', '5c869681-4ad8-4699-a6f8-a3f069ba9771.svg', 'discord.svg', 'Discord', 'image/svg+xml', '82caf9c9-995b-404f-ba7e-76f704a6dd3e', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-09-23 13:51:12.413+00', NULL, '2024-09-23 13:51:12.432+00', NULL, 861, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-09-23 13:51:12.431+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('43d267e0-1f39-493a-a671-a2ca451b160b', 'local', '43d267e0-1f39-493a-a671-a2ca451b160b.png', 'save-the-date.png', 'Save the Date', 'image/png', '82caf9c9-995b-404f-ba7e-76f704a6dd3e', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-09-16 10:51:36.14+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-09-16 12:29:05.059+00', NULL, 62535, 600, 200, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-09-16 10:51:36.159+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('76c2e55a-6348-457f-a335-cf60e91b2950', 'local', '76c2e55a-6348-457f-a335-cf60e91b2950.svg', 'clic_color_info.svg', 'Clic Color Info', 'image/svg+xml', '82caf9c9-995b-404f-ba7e-76f704a6dd3e', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-08-17 07:10:12.783912+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:26:11.853+00', NULL, 27331, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-26 19:34:49.409417+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('2cf29857-7d6c-4710-9284-e1aae31942e5', 'local', '2cf29857-7d6c-4710-9284-e1aae31942e5.svg', 'banner.svg', 'Banner Ictravel', 'image/svg+xml', '07d9aa98-227f-4d9a-916f-e19f30cda26a', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:11:14.864+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:33:29.397+00', NULL, 232728, 1080, 432, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:33:29.389+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('fe5116dc-ff64-42a5-a9ec-379532ca1aad', 'local', 'fe5116dc-ff64-42a5-a9ec-379532ca1aad.png', 'banner polygl0ts.png', 'Banner Polygl0ts', 'image/png', '07d9aa98-227f-4d9a-916f-e19f30cda26a', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:11:24.79+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:33:19.497+00', NULL, 224045, 1000, 400, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:33:19.489+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('395b452e-e8de-4a74-8744-85daa9e8264e', 'local', '395b452e-e8de-4a74-8744-85daa9e8264e.png', 'FrancIC la LAN.png', 'Sans Titre', 'image/png', '2fd1d075-83a4-40b7-902e-b46a0d861dfe', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:14:05.521+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:33:02.66+00', NULL, 2630603, 2048, 1536, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:33:02.651+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('be009ec0-41ad-478e-b596-55973e5a70ba', 'local', 'be009ec0-41ad-478e-b596-55973e5a70ba.png', 'Sans titre.png', 'Franc Ic La Lan', 'image/png', '2fd1d075-83a4-40b7-902e-b46a0d861dfe', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:14:40.618+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:32:29.198+00', NULL, 3620624, 1920, 1080, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:32:29.192+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('d6feb68f-94d8-4ea6-b5a9-fc02f0028c50', 'local', 'd6feb68f-94d8-4ea6-b5a9-fc02f0028c50.png', 'mail_header.png', 'Pastic', 'image/png', '2fd1d075-83a4-40b7-902e-b46a0d861dfe', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:15:41.407+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:32:06.114+00', NULL, 591692, 1920, 680, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:32:06.103+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('caeec171-0314-4bfc-b042-66ffb7f5fab0', 'local', 'caeec171-0314-4bfc-b042-66ffb7f5fab0.svg', 'IC Boost Day Logo Color SVG.svg', 'Ic Boost Day Logo Color Svg', 'image/svg+xml', '18e98463-e2a4-4c82-965f-b598cb9e6370', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:05:52.805+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:18:28.017+00', NULL, 52580, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 15:18:28.012+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('38492627-8ca5-4980-87d2-9bffdfdfc3cd', 'local', '38492627-8ca5-4980-87d2-9bffdfdfc3cd.svg', 'clic_color.svg', 'Clic Color', 'image/svg+xml', '18e98463-e2a4-4c82-965f-b598cb9e6370', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:06:08.109+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:18:20.258+00', NULL, 5051, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 15:18:20.252+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('6891541c-f335-4374-ae61-0fa480b43b47', 'local', '6891541c-f335-4374-ae61-0fa480b43b47.png', 'faculte_ic.png', 'Faculte Ic', 'image/png', '18e98463-e2a4-4c82-965f-b598cb9e6370', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:06:23.587+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:18:10.512+00', NULL, 37158, 640, 199, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:18:10.503+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('df7992b2-955e-4b18-b0d5-45d58da4e373', 'local', 'df7992b2-955e-4b18-b0d5-45d58da4e373.jpg', 'apps.9740.67611127219854234.0a5f5ed1-3c93-46bb-a0cc-22e900e79598.jpg', 'Apps.9740.67611127219854234.0a5f5ed1 3c93 46bb A0cc 22e900e79598', 'image/jpeg', '9dcbb848-a25a-4e75-af0a-abbd1c4555ea', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-08-17 07:10:12.780387+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:25:57.872+00', NULL, 134537, 1920, 1080, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-06-26 19:54:29.59841+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('eb4d7ae6-bb29-458d-a3ef-0b8470f16931', 'local', 'eb4d7ae6-bb29-458d-a3ef-0b8470f16931.jpg', 'apps.43922.70110853215030129.c1993ea8-ba45-45c6-9e14-ba63fc9d1852.jpg', 'Apps.43922.70110853215030129.c1993ea8 Ba45 45c6 9e14 Ba63fc9d1852', 'image/jpeg', '9dcbb848-a25a-4e75-af0a-abbd1c4555ea', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-08-17 07:10:12.777234+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:25:57.872+00', NULL, 112024, 1920, 1080, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-06-26 19:54:29.58415+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('c44d5d98-9bbc-4351-975c-88b1f8b67d9c', 'local', 'c44d5d98-9bbc-4351-975c-88b1f8b67d9c.jpg', 'apps.49477.71802554219234428.1e128826-bd72-4f27-b5b4-d204d17c8692.jpg', 'Apps.49477.71802554219234428.1e128826 Bd72 4f27 B5b4 D204d17c8692', 'image/jpeg', '9dcbb848-a25a-4e75-af0a-abbd1c4555ea', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-08-17 07:10:12.778792+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:25:57.872+00', NULL, 122965, 1920, 1080, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-06-26 19:54:29.575931+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('77eb9ef9-3549-4788-a9aa-5d567cc3fd9f', 'local', '77eb9ef9-3549-4788-a9aa-5d567cc3fd9f.jpg', 'apps.53167.64302060751336384.06dcc399-689f-4591-91ef-d0720a2cc135.jpg', 'Apps.53167.64302060751336384.06dcc399 689f 4591 91ef D0720a2cc135', 'image/jpeg', '9dcbb848-a25a-4e75-af0a-abbd1c4555ea', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-08-17 07:10:12.775324+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:25:57.872+00', NULL, 17459, 480, 270, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-06-26 19:54:29.566365+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('525d475c-24a0-45cb-947f-c70eca52c3b6', 'local', '525d475c-24a0-45cb-947f-c70eca52c3b6.jpg', 'apps.60051.71235344842593874.68f78909-514c-463a-90da-25844a0d69c7.jpg', 'Apps.60051.71235344842593874.68f78909 514c 463a 90da 25844a0d69c7', 'image/jpeg', '9dcbb848-a25a-4e75-af0a-abbd1c4555ea', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-08-17 07:10:12.77321+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:25:57.872+00', NULL, 17916, 480, 270, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-06-26 19:53:54.269471+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('46794bc9-9e31-4f52-bc43-4a60b9d54b7f', 'local', '46794bc9-9e31-4f52-bc43-4a60b9d54b7f.png', 'site.png', 'Ag', 'image/png', '8890baa5-447e-45a3-a573-95c76830e876', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:03:33.342+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:17:10.901+00', NULL, 407444, 1080, 466, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:17:10.894+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('2fcabc29-c727-43f1-871c-d508b8e04e34', 'local', '2fcabc29-c727-43f1-871c-d508b8e04e34.jpg', 'AG.jpg', 'Site', 'image/jpeg', '8890baa5-447e-45a3-a573-95c76830e876', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:04:08.233+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 15:16:53.675+00', NULL, 22952, 1080, 540, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2025-01-14 15:16:53.669+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('3f53fb20-e623-42f0-8ad1-68bbc0ea923d', 'local', '3f53fb20-e623-42f0-8ad1-68bbc0ea923d.svg', 'epfl-logo.svg', 'Epfl Logo', 'image/svg+xml', '24a99ee1-4eee-48e1-9960-d51b5a105016', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-08-17 07:10:12.785238+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:27:01.291+00', NULL, 1254, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-26 19:32:59.318131+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('f7711867-b53f-4043-acf5-6de4560d3ae1', 'local', 'f7711867-b53f-4043-acf5-6de4560d3ae1.png', 'Capture d’écran du 2024-10-29 16-40-10.png', 'Capture D’écran Du 2024 10 29 16 40 10', 'image/png', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 15:40:28.024+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:32.316+00', NULL, 248640, 802, 1237, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-10-29 15:40:28.05+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('0852efa6-92a1-40f1-8b77-37b5296f9050', 'local', '0852efa6-92a1-40f1-8b77-37b5296f9050.svg', 'dialexo_perso.svg', 'Dialexo Perso', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 14:59:42.018+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 41935, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-29 14:59:42.047+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('9f36c045-5cdf-48c9-b8b7-319a736a7f16', 'local', '9f36c045-5cdf-48c9-b8b7-319a736a7f16.svg', 'frénésie_perso.svg', 'Frénésie Perso', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 14:59:20.326+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 34728, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-29 14:59:20.355+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('f6b465f5-dc79-4355-a1ae-d719c9ce5ff0', 'local', 'f6b465f5-dc79-4355-a1ae-d719c9ce5ff0.svg', 'dialexo_perso.svg', 'Dialexo Perso', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 14:58:25.459+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 41935, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-29 14:58:25.482+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('f6e36f55-f424-4dc8-a5ae-57da905a24b3', 'local', 'f6e36f55-f424-4dc8-a5ae-57da905a24b3.svg', 'dj_nokap_perso.svg', 'Dj Nokap Perso', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 14:58:03.489+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 36099, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-29 14:58:03.507+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('7189d0e0-3897-4c1a-a6eb-9faba9eb0f5f', 'local', '7189d0e0-3897-4c1a-a6eb-9faba9eb0f5f.svg', 'lina_perso.svg', 'Lina Perso', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 14:57:49.894+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 31533, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-29 14:57:49.914+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('6dd45be7-1d9c-4820-86c8-91be62e609cd', 'local', '6dd45be7-1d9c-4820-86c8-91be62e609cd.svg', 'quartztz_perso.svg', 'Quartztz Perso', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 14:57:33.299+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 45078, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-29 14:57:33.315+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('ae26aaf5-21b6-4aea-8ece-d656597a8b5c', 'local', 'ae26aaf5-21b6-4aea-8ece-d656597a8b5c.svg', 'dialexo_perso.svg', 'Best Female Dj Ellen Allien 99624271', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-17 12:00:13.184+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 41935, 606, 606, NULL, NULL, NULL, NULL, NULL, '{}', NULL, NULL, NULL, NULL, '2024-10-29 14:57:12.422+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('7873c7f9-b586-4367-94ce-735cd1413298', 'local', '7873c7f9-b586-4367-94ce-735cd1413298.svg', 'subsonic typo.svg', 'Subsonic Typo', 'image/svg+xml', 'c1a3c999-6bf8-4ad9-bd41-62b7fa5394c8', '49733485-a937-4776-a34b-914ed2b5ce16', '2024-10-29 13:48:39.465+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:00:21.41+00', NULL, 7602, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-10-29 13:48:39.492+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('6d3a2e63-901d-4c27-afc1-d5f6035a1bf5', 'local', '6d3a2e63-901d-4c27-afc1-d5f6035a1bf5.svg', 'food.svg', 'Food', 'image/svg+xml', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:07:28.169+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:12:55.736+00', NULL, 834, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 13:07:28.193+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('0b7f4ae2-7b25-4792-aa75-ff0da0e0de0e', 'local', '0b7f4ae2-7b25-4792-aa75-ff0da0e0de0e.svg', 'meetup.svg', 'Meetup', 'image/svg+xml', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:07:17.944+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:12:55.736+00', NULL, 583, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 13:07:17.961+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('a5906cd1-e53e-4cf8-be3c-0bf616896ec7', 'local', 'a5906cd1-e53e-4cf8-be3c-0bf616896ec7.svg', 'paper.svg', 'Paper', 'image/svg+xml', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:07:08.578+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:12:55.736+00', NULL, 1288, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 13:07:08.597+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('02cc65c6-abfe-4f7d-a3b4-c3a8c0b52fe1', 'local', '02cc65c6-abfe-4f7d-a3b4-c3a8c0b52fe1.svg', 'hands.svg', 'Hands', 'image/svg+xml', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:06:59.266+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:12:55.736+00', NULL, 642, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 13:06:59.286+00') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_files (id, storage, filename_disk, filename_download, title, type, folder, uploaded_by, created_on, modified_by, modified_on, charset, filesize, width, height, duration, embed, description, location, tags, metadata, focal_point_x, focal_point_y, tus_id, tus_data, uploaded_on) VALUES ('50f5a1a3-8173-4dc6-8743-5b0c2c410605', 'local', '50f5a1a3-8173-4dc6-8743-5b0c2c410605.svg', 'tie.svg', 'Tie', 'image/svg+xml', '48e39cd0-878d-4850-a6d5-5f903bd0c2fb', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:06:52.088+00', '49733485-a937-4776-a34b-914ed2b5ce16', '2025-01-14 13:12:55.736+00', NULL, 376, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-01-14 13:06:52.109+00') ON CONFLICT DO NOTHING;
INSERT INTO public.association (id, name, email, phone, address, logo, preview_image, public_files) VALUES (1, 'CLIC', 'clic@epfl.ch', '+41 21 693 81 28', NULL, '76c2e55a-6348-457f-a335-cf60e91b2950', NULL, NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.association_poles (id, slug, mail) VALUES (1, 'presidency', 'presidence.clic@epfl.ch') ON CONFLICT DO NOTHING;
INSERT INTO public.association_poles (id, slug, mail) VALUES (2, 'it', 'it.clic@epfl.ch') ON CONFLICT DO NOTHING;
INSERT INTO public.members (id, name, surname, email, sciper, link, picture, poll_count) VALUES (1, 'John', 'Doe', NULL, NULL, NULL, 'eb4d7ae6-bb29-458d-a3ef-0b8470f16931', 0) ON CONFLICT DO NOTHING;
INSERT INTO public.members (id, name, surname, email, sciper, link, picture, poll_count) VALUES (2, 'Jack', 'Cooper', NULL, NULL, NULL, '525d475c-24a0-45cb-947f-c70eca52c3b6', 0) ON CONFLICT DO NOTHING;
INSERT INTO public.members (id, name, surname, email, sciper, link, picture, poll_count) VALUES (3, 'Tai', 'Lastimosa', NULL, NULL, NULL, 'df7992b2-955e-4b18-b0d5-45d58da4e373', 0) ON CONFLICT DO NOTHING;
INSERT INTO public.members (id, name, surname, email, sciper, link, picture, poll_count) VALUES (4, 'Droz', '(6-4)', NULL, NULL, NULL, '77eb9ef9-3549-4788-a9aa-5d567cc3fd9f', 0) ON CONFLICT DO NOTHING;
INSERT INTO public.members (id, name, surname, email, sciper, link, picture, poll_count) VALUES (5, 'Davis', '(6-4)', NULL, NULL, NULL, 'c44d5d98-9bbc-4351-975c-88b1f8b67d9c', 0) ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships (id, member, level, pole) VALUES (1, 1, 'committee', 1) ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships (id, member, level, pole) VALUES (2, 2, 'committee', 1) ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships (id, member, level, pole) VALUES (3, 3, 'committee', 2) ON CONFLICT DO NOTHING;
INSERT INTO public.languages (code, name) VALUES ('en-US', 'English') ON CONFLICT DO NOTHING;
INSERT INTO public.languages (code, name) VALUES ('fr-FR', 'Français') ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships_translations (id, association_memberships_id, languages_code, title) VALUES (1, 1, 'en-US', 'President') ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships_translations (id, association_memberships_id, languages_code, title) VALUES (2, 1, 'fr-FR', 'President') ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships_translations (id, association_memberships_id, languages_code, title) VALUES (3, 2, 'en-US', 'Co-President') ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships_translations (id, association_memberships_id, languages_code, title) VALUES (4, 2, 'fr-FR', 'Co-Présidente') ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships_translations (id, association_memberships_id, languages_code, title) VALUES (5, 3, 'en-US', 'IT Manager') ON CONFLICT DO NOTHING;
INSERT INTO public.association_memberships_translations (id, association_memberships_id, languages_code, title) VALUES (6, 3, 'fr-FR', 'Responsable Informatique') ON CONFLICT DO NOTHING;
INSERT INTO public.commissions (id, email, slug, logo, name) VALUES (1, '6_4@epfl.ch', '6-4', NULL, 'The 6-4') ON CONFLICT DO NOTHING;
INSERT INTO public.partner_category (id, rank) VALUES (1, 0) ON CONFLICT DO NOTHING;
INSERT INTO public.partner_category (id, rank) VALUES (2, 1) ON CONFLICT DO NOTHING;
INSERT INTO public.partners (id, name, logo, link, start, "end", commission, category) VALUES (2, 'EPFL', '3f53fb20-e623-42f0-8ad1-68bbc0ea923d', 'https://epfl.ch', '2024-06-01', '2030-06-01', NULL, 2) ON CONFLICT DO NOTHING;
INSERT INTO public.partners (id, name, logo, link, start, "end", commission, category) VALUES (1, 'CLIC', '76c2e55a-6348-457f-a335-cf60e91b2950', 'https://clic.epfl.ch', '2024-06-01', '2030-06-01', NULL, 1) ON CONFLICT DO NOTHING;
INSERT INTO public.association_poles_translations (id, association_poles_id, languages_code, name, description) VALUES (1, 1, 'en-US', 'Presidency', 'The role of the co-presidents is to coordinate the association internally and represent it externally. They ensure cohesion within their committee and with the CLIC commissions, and that the association is moving in the right direction, according to the goals set and the vision of the association.
Without going into too much detail, this involves ensuring compliance with the association''s official documents, chairing committee meetings and general assemblies, ensuring a good distribution of the tasks, and supporting committee members where necessary.
These are very rewarding, all-round jobs that require a constant global vision!') ON CONFLICT DO NOTHING;
INSERT INTO public.association_poles_translations (id, association_poles_id, languages_code, name, description) VALUES (2, 1, 'fr-FR', 'Présidence', 'Le duo des co-président·e·s a pour rôle de coordonner l’association en interne et de la représenter à l’externe. Elles/ils veillent à une bonne cohésion au sein de leur comité et avec les commissions de la CLIC, et à ce que l''association avance dans la bonne direction, selon les buts fixés et la vision de l''association.
Sans trop rentrer dans les détails, il s''agit de s’assurer du respect des documents officiels de l’association, diriger les réunions du comité et les assemblées générales, veiller à une bonne répartition des tâches, et accompagner les membres du comité si besoin.
Ce sont des postes très enrichissants et touche-à-tout qui demandent une vision globale constante !') ON CONFLICT DO NOTHING;
INSERT INTO public.association_poles_translations (id, association_poles_id, languages_code, name, description) VALUES (3, 2, 'en-US', 'IT', 'The IT department looks after the association''s IT infrastructure. It''s a department in constant motion, with no shortage of ideas and projects! Its day-to-day work ranges from adding new tools and applications to the CLIC committee''s artillery (or even the IC student''s), to developing our magnificent website on which you are reading these lines.
### System administrator
Often abbreviated to sysadmin, the system administrator''s job is to set up, update and, above all, maintain IT services. In the case of CLIC, we have a small server hosted at Infomaniak on which our year-round services reside, whether they be internal tools (Mattermost, Nextcloud, etc.) or external (website) to the committee. Generally speaking, the management of this server is a very basic set of tasks, and above all an educational one for anyone interested in IT.
### Web development
The association''s website contains information on CLIC, its commissions, committees and team members. In the near future, we''d like to extend these functionalities to services for IC students, such as an equipment loan system, a registration system, a shared calendar for IC associations and commissions, etc. The possibilities are infinite...') ON CONFLICT DO NOTHING;
INSERT INTO public.association_poles_translations (id, association_poles_id, languages_code, name, description) VALUES (4, 2, 'fr-FR', 'IT', 'Le pôle informatique s''occupe de l''infrastructure informatique de l''association. C''est un département en perpétuel mouvement, qui ne manque pas d''idées et de projets ! Son travail quotidien va de l''ajout de nouveaux outils et applications à l''artillerie du comité CLIC (ou même des étudiants IC), au développement de notre magnifique site web sur lequel vous lisez ces lignes.
### Administrateur système
Souvent abrégé en sysadmin, l''administrateur système a pour mission de mettre en place, de mettre à jour et surtout de maintenir les services informatiques. Dans le cas du CLIC, nous disposons d''un petit serveur hébergé chez Infomaniak sur lequel résident nos services à l''année, qu''il s''agisse d''outils internes (Mattermost, Nextcloud, etc.) ou externes (site web) au comité. D''une manière générale, la gestion de ce serveur est un ensemble de tâches très basiques, et surtout éducatives pour toute personne intéressée par l''informatique.
### Développement web
Le site web de l''association contient des informations sur le CLIC, ses commissions, ses comités et les membres de l''équipe. Dans un futur proche, nous aimerions étendre ces fonctionnalités à des services pour les étudiants de l''IC, tels qu''un système de prêt de matériel, un système d''inscription, un calendrier partagé pour les associations et commissions de l''IC, etc. Les possibilités sont infinies...') ON CONFLICT DO NOTHING;
INSERT INTO public.social_links (id, link, logo, media_name, account_name) VALUES (1, 'https://t.me/clicepfl', NULL, 'Telegram', '@clicepfl') ON CONFLICT DO NOTHING;
INSERT INTO public.association_social_links (id, association_id, social_links_id) VALUES (1, 1, 1) ON CONFLICT DO NOTHING;
INSERT INTO public.association_translations (id, association_id, languages_code, description, banner) VALUES (1, 1, 'en-US', '# About
## What is CLIC ?
CLIC came into being in 2011, when the IC faculty was facing difficulties it couldn''t solve on its own. With the help of the delegates, who had to go beyond their role, the CDIC was born. It soon became the CLIC (because it''s classier). The association was mainly made of delegates, and worked in close collaboration with the coaching. The faculty, delighted with this collaboration, provided us with an office close to the administration for rapid communication. This was INN132, where we are still based.
As the problems were solved, it was time to think about the fun. A faculty dinner, a field trip, a bar at Balélec (BarIC), and other fun stuff were on the agenda. Then the years passed, and the events multiplied : December mulled wine, free breakfasts, faculty clothing sales, video game evenings and much more.
Then, like LudIC or LauzHack, events became commissions, then became big enough to stand on their own two feet, and were transformed into fully-fledged associations.
Today, CLIC has grown, but has not lost sight of its original mission: to bring the faculty to life with free or low-cost events, and to ensure that the monotony of classes and exams is regularly broken. In recent years, we have also tried to offer more serious content such as conferences, talks and contacts with industry, as these are also needs of IC faculty students.', '76c2e55a-6348-457f-a335-cf60e91b2950') ON CONFLICT DO NOTHING;
INSERT INTO public.association_translations (id, association_id, languages_code, description, banner) VALUES (2, 1, 'fr-FR', '# À propos
## Qu''est-ce que la CLIC ?
La CLIC est née en 2011, alors que la faculté IC rencontrait des difficultés qu’elle ne pouvait pas résoudre seule. Il fallait l’aide des délégués, mais ils devaient aller au-delà de leur rôle. C’est ainsi qu’est née la CDIC. Très rapidement devenue la CLIC (parce que c''est quand même plus classe), l’association était composée de délégués principalement, et travaillait en étroite collaboration avec le coaching. La Faculté, enchantée de cette collaboration, nous a fourni un bureau proche de l’administration pour une communication rapide. Il s’agissait du bureau INN132, où nous logeons d’ailleurs toujours.
Une fois les problèmes résolus, il devenait temps de penser au fun. Souper de faculté, voyage d’études, bar à Balélec (BarIC), et autres joyeusetés étaient dans l’agenda. Puis les années ont passé, et les événements se sont multipliés : vin chaud en décembre, petits-déjeuners gratuits, ventes d’habits de faculté, soirées jeux-vidéos et bien d’autres.
Ensuite, à l’image de la LudIC ou de LauzHack, des événements sont devenus des commissions, puis sont devenus assez grands pour battre de leurs propres ailes et se sont transformés en associations à part entière.
Aujourd’hui, la CLIC a bien grandi, mais ne perd pas de vue sa mission originale : faire vivre la faculté avec des événements gratuits ou à faible coût, et s’assurer de régulièrement casser la monotonie des cours et des examens. Depuis quelques années, nous tentons également de proposer en supplément du contenu plus sérieux comme des conférences, des talks ou des contacts avec l’industrie, car il s’agit aussi là de besoins des étudiants de la faculté IC.', '76c2e55a-6348-457f-a335-cf60e91b2950') ON CONFLICT DO NOTHING;
INSERT INTO public.commission_memberships (id, commission, member, level) VALUES (1, 1, 4, 'committee') ON CONFLICT DO NOTHING;
INSERT INTO public.commission_memberships (id, commission, member, level) VALUES (2, 1, 5, 'committee') ON CONFLICT DO NOTHING;
INSERT INTO public.commission_memberships_translations (id, commission_memberships_id, languages_code, title) VALUES (1, 1, 'en-US', 'Coordinator') ON CONFLICT DO NOTHING;
INSERT INTO public.commission_memberships_translations (id, commission_memberships_id, languages_code, title) VALUES (2, 1, 'fr-FR', 'Coordinateur') ON CONFLICT DO NOTHING;
INSERT INTO public.commission_memberships_translations (id, commission_memberships_id, languages_code, title) VALUES (3, 2, 'en-US', 'Coordinator') ON CONFLICT DO NOTHING;
INSERT INTO public.commission_memberships_translations (id, commission_memberships_id, languages_code, title) VALUES (4, 2, 'fr-FR', 'Coordinateur') ON CONFLICT DO NOTHING;
INSERT INTO public.commissions_translations (id, commissions_id, languages_code, small_description, description, banner) VALUES (1, 1, 'en-US', 'Comprised of freelance pilots, The 6-4 operates on a code unique among bounty hunters. Instead of selling their services to the highest bidder, Frontier freedom, on their terms, is a higher priority. ', 'The 6-4''s history prior to the Battle of Typhon is unknown. During the engagement, however, the 6-4 made their debut during the later stages of the battle following the reactivation of an IMC Interstellar Beacon by Jack Cooper. As part of Blackbird Squadron, given callsign Blackbird 6-4, they assisted Marauder Corps forces in chasing down and boarding the IMS Draconis, in an effort to secure the Ark.
During the air battle, the 6-4 would assist Pilot Cooper in taking control of the IMS Malta. They helped Cooper clear the infantry surrounding the ship''s anti air guns, then joined him on the ship to clear its main hangar and bridge. After the Malta changed course, they provided cover fire during Cooper''s battle with Viper. The 6-4 would keep control of the IMC battleship, and eventually proceed to utilise the Malta to prevent Cooper from being surrounded by IMC forces during his confrontation with Slone. The 6-4 were able to escape Typhon prior to its destruction at the hands of the IMC superweapon.
Sometime following the Battle of Typhon, members Droz and Davis left the 6-4 for presently unknown reasons, forming The Last Resort. ', '431a4d8a-046e-4bbc-a7e0-d9bc3cd51cde') ON CONFLICT DO NOTHING;
INSERT INTO public.commissions_translations (id, commissions_id, languages_code, small_description, description, banner) VALUES (2, 1, 'fr-FR', 'Composé de pilotes indépendants, les 6-4 fonctionne selon un code unique parmi les chasseurs de primes. Au lieu de vendre leurs services au plus offrant, la liberté de Frontier, selon leurs conditions, est une priorité absolue. ', 'L''histoire des 6-4 avant la bataille de Typhon
est inconnue. Au cours de l''engagement, cependant, les 6-4 a fait ses débuts
au cours des dernières phases de la bataille, suite à la réactivation d''une balise interstellaire de l''IMC par Jack Cooper.
balise interstellaire de l''IMC par Jack Cooper. Faisant partie de l''escadron Blackbird et portant l''indicatif Blackbird 6-4, ils ont aidé les forces du Marauder Corps à poursuivre et à aborder l''IMS Draconis, dans le but de sécuriser l''Arche.
Pendant la bataille aérienne, les 6-4 a aidé le pilote Cooper à prendre le contrôle de l''IMS Malta.
Ils ont aidé Cooper à se débarrasser de l''infanterie entourant les canons antiaériens du navire, puis l''ont rejoint sur le navire.
Ils l''ont ensuite rejoint sur le navire pour dégager le hangar principal et le pont.
Après que le Malte a changé de cap, ils ont fourni des tirs de couverture pendant le combat de Cooper contre Viper. Les 6-4 ont gardé le contrôle du cuirassé de l''IMC, et ont finalement utilisé le Malta pour empêcher Cooper d''être encerclé par les forces de l''IMC lors de sa confrontation avec Slone. Les 6-4 ont réussi à s''échapper de Typhon avant sa destruction par la super-arme de l''IMC.
Après la bataille de Typhon, Droz et Davis quittent le 6-4 pour des raisons inconnues à ce jour et forment The Last Resort.', '431a4d8a-046e-4bbc-a7e0-d9bc3cd51cde') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('6fca2524-46a0-4523-afda-dff8465ee316', 'fr-FR', 'association', 'association') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('b5783fb7-0e36-4860-986a-ce0a925afd7e', 'en-US', 'association', 'association') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('07dae072-42e3-471b-a158-8d88d79bba8e', 'fr-FR', 'by', 'par') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('0927aefd-c0bd-4615-8d32-3782d539e350', 'en-US', 'readMore', 'read more') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('0a18e5b7-19fa-468f-8721-fb6c5e6586e1', 'fr-FR', 'news', 'news') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('0d4bf19a-19d9-4992-8948-b46e551dcd72', 'en-US', 'commission', 'commission') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('0d9453b5-b866-485c-b97c-5188759b9a9b', 'en-US', 'committee', 'committee') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('107cafa9-dff7-466b-a656-47c0c7b91ecb', 'fr-FR', 'association', 'association') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('182bf381-fe71-4e88-8afe-f455162c22d1', 'fr-FR', 'committee', 'comité') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('23204f96-3693-4e6e-a3e0-be22ac98b62b', 'en-US', 'dateIndicator', 'on') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('31ac8e8d-8a67-4d73-ba3f-a0ae14c86634', 'en-US', 'association', 'association') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('3d3c7445-1659-4b6c-ae3f-366c28fc4d86', 'en-US', 'relatedContent', 'related content') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('40162d9d-51c8-4050-8e63-25c74cba90ad', 'en-US', 'contact', 'Contact us : ') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('4186e212-cee3-43ef-b958-d12669ea4702', 'en-US', 'commissions', 'commissions') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('48b5fbc7-4d20-428f-8017-dca1fbddb92d', 'fr-FR', 'timeIndicator', 'à') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('4cefbfc5-1dcd-4998-bc86-3ca1ed9f9d5a', 'en-US', 'news', 'news') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('51c213c4-8c5a-45cf-aaeb-a7474bc1da6b', 'en-US', 'partners', 'partners') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('58f126d8-08c6-4ef8-9661-f197ae1d75c6', 'en-US', 'bob-cassettes', 'Bob cassettes') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('6d459c95-0eca-44e2-bb09-fb1380285914', 'en-US', 'timeIndicator', 'at') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('6f438d0d-bc02-4079-bc85-454354e45237', 'en-US', 'by', 'by') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('7b1d7310-d3c4-4c64-b9d3-54b848c4dd2a', 'fr-FR', 'commission', 'commission') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('7d819173-4b7a-46a6-8b79-97a88ed6b160', 'fr-FR', 'coffee-filter', 'Filtres café') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('7f719165-8b7f-4567-a5ac-4b61569934bf', 'fr-FR', 'moreNews', 'plus de news') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('80c9327a-2043-4980-a8e2-64a53dfb652a', 'en-US', 'coffee-filter', 'Coffee filter') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('8b185a96-ad69-41c4-b40b-94c89976162a', 'fr-FR', 'readMore', 'lire plus') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('a914324c-16da-4bc8-8f4e-f07c60eca6ad', 'en-US', 'digitec', 'Digitec') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('abc26ae0-7b8d-4cd0-849b-87c3a2e3d1fe', 'fr-FR', 'need-to-order', 'Besoin de commander ?') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('b0cada77-a089-4d05-b268-7c4da8a00e90', 'en-US', 'pole', 'positions') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('b4445d8e-7e27-40ac-8919-869348eeb0a5', 'fr-FR', 'dateIndicator', 'le') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('b6d433f1-dfad-40cf-ba0e-9aa8c4f584fd', 'fr-FR', 'slogan', 'Association des étudiant.e.s en Informatique et Systèmes de communication') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('bbd1d417-142e-4872-b438-aec1e02a9a2e', 'fr-FR', 'digitec', 'Digitec') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('c0bc71c5-74cf-4935-92c0-d1398747a5e3', 'en-US', 'moreNews', 'more news') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('c52ed780-7b7d-4358-88c8-acde17ce8063', 'fr-FR', 'pole', 'pôles') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('c803e359-2b6a-44d7-8dfb-ff26e3a7a615', 'fr-FR', 'gallery', 'galerie') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('cb240957-bf9e-42a7-93b9-402cab0104c0', 'en-US', 'need-to-order', 'Need to order?') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('cb8efc84-68bc-4a28-9cb6-c6634597528b', 'br-FR', 'bob-cassettes', 'Cassettes Bob') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('d75f6d82-02cb-4a21-99c3-a62285f28e78', 'fr-FR', 'relatedContent', 'voir aussi ...') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('e12f32e4-7a06-4bbf-86f0-53ed45c05c85', 'fr-FR', 'contact', 'Nous contacter : ') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('e99c2922-927e-44c2-a865-496673d64620', 'fr-FR', 'commissions', 'commissions') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('efa360e8-5937-44b2-9ec5-ad9eb1a7f3fb', 'fr-FR', 'partners', 'partenaires') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('f7a64a82-6059-4a54-9d17-9c24a5a40252', 'en-US', 'slogan', 'Association of students in Computer science and Communication systems') ON CONFLICT DO NOTHING;
INSERT INTO public.directus_translations (id, language, key, value) VALUES ('fdb3302f-96c9-44c9-a00e-513828b9d426', 'en-US', 'gallery', 'gallery') ON CONFLICT DO NOTHING;
INSERT INTO public.news (id, user_created, date_created, date_updated, status, sort, slug, video_link) VALUES (1, '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 19:16:51.215+00', '2024-06-26 20:08:12.904+00', 'published', NULL, 'typhon-battle', NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.news (id, user_created, date_created, date_updated, status, sort, slug, video_link) VALUES (2, '49733485-a937-4776-a34b-914ed2b5ce16', '2024-06-26 20:07:32.92+00', '2024-06-26 20:08:27.676+00', 'published', NULL, 'fracture-operation', NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.news_translations (id, news_id, languages_code, title, description, content, banner) VALUES (1, 1, 'en-US', 'Battle of Typhon', 'The Battle of Typhon was an event, a conflict spread out over several days across the surface of Typhon.', 'The Battle of Typhon was an event, a conflict spread out over several days across the surface of Typhon, the planet the battle was named for. It was part of the Frontier Militia''s Operation: Broadsword - a large Frontier-wide push to remove the Interstellar Manufacturing Corporation from the Frontier.
The central objective and focus of the battle was the Fold Weapon, an ancient interstellar superweapon of alien origin with the power to annihilate a planet ON CONFLICT DO NOTHING; the IMC intended to use the Fold Weapon to obliterate Militia planets, beginning with the home world of Harmony, while the Militia - upon discovering the weapon''s existence - sought to prevent its use at all costs. While many Militia vessels were lost, the battle ended with the Militia successfully destroying the Fold Weapon, inadvertently devastating Typhon itself in the process. ', '0ed7b730-158b-4c78-9fb0-7340d2b4e0d9') ON CONFLICT DO NOTHING;
INSERT INTO public.news_translations (id, news_id, languages_code, title, description, content, banner) VALUES (2, 1, 'fr-FR', 'Bataille de Typhon', 'La bataille de Typhon est un événement, un conflit qui s''étend sur plusieurs jours à la surface de Typhon.', 'La bataille de Typhon est un événement, un conflit qui s''étend sur plusieurs jours à la surface de Typhon, la planète dont elle porte le nom. Elle s''inscrivait dans le cadre de l''opération "Broadsword" de la milice frontalière : Broadsword de la Milice de la Frontière - une vaste opération à l''échelle de la Frontière visant à éliminer l''Interstellar Manufacturing Corporation de la Frontière.
L''objectif central de la bataille était l''Arme de Pli, une ancienne super-arme interstellaire d''origine extraterrestre ayant le pouvoir d''anéantir une planète. L''IMC avait l''intention d''utiliser l''Arme de Pli pour anéantir les planètes de la Milice, en commençant par le monde d''Harmony, tandis que la Milice, après avoir découvert l''existence de l''arme, a cherché à empêcher son utilisation à tout prix. Bien que de nombreux vaisseaux de la Milice aient été perdus, la bataille s''est terminée par la destruction de l''Arme de Pli par la Milice, dévastant par inadvertance Typhon lui-même. ', '0ed7b730-158b-4c78-9fb0-7340d2b4e0d9') ON CONFLICT DO NOTHING;
INSERT INTO public.news_translations (id, news_id, languages_code, title, description, content, banner) VALUES (3, 2, 'en-US', 'Fracture Operation', 'The Fracture Operation, also known as The Refueling Raid, was an operation conducted by the Marauder Corps (M-COR) of the 1st Militia Fleet.', '# Prelude
The raid was conducted at the apex of the months of pursuit conducted by Marcus Graves. Low on fuel and supplies, the Militia First Fleet was forced into a confrontation at Site M41 on the Planet Victor, the only viable refuelling facility within three jumps of the Militia''s current location.
General Anderson was killed in action shortly before the battle, leading to the promotion of Sarah Briggs and Cheng "Bish" Lorck to field commanders of the M-COR.
# The Battle
The battle involved both naval and ground warfare, with Militia civilian vessels being targeted by the IMC Colonial Navy. Due to Site M41''s strategic significance as a refuelling station, the Militia Fleet''s main goals were to use the site''s fuel pumps to refuel their vessels.
However, IMC forces would mount a heavy defence at three rally points ON CONFLICT DO NOTHING; Alpha, Bravo and Charlie. Utilising Mobile Hardpoints to control of both Heavy Turrets and Fuel Pumps, ground troops would fight for control of the three main buildings, with the Militia fighting to keep air defences offline and the IMC fighting to shoot down as many Militia ships as possible.
Depending on outcome, it is possible that the Militia vessel Redeye was shot down. ', '6521a3b8-b039-4643-bf26-500221131805') ON CONFLICT DO NOTHING;
INSERT INTO public.news_translations (id, news_id, languages_code, title, description, content, banner) VALUES (4, 2, 'fr-FR', 'Opération Fracture', 'L''opération Fracture, également connue sous le nom de Raid de ravitaillement, est une opération menée par le Marauder Corps (M-COR) de la 1ère Flotte de la Milice.', '# Prélude
Le raid a été mené à l''apogée des mois de poursuite menés par Marcus Graves. À court de carburant et de provisions, la première flotte de la Milice a été contrainte de s''affronter sur le site M41 de la planète Victor, la seule installation de ravitaillement viable à moins de trois sauts de l''emplacement actuel de la Milice.
Le général Anderson a été tué au combat peu avant la bataille, ce qui a conduit à la promotion de Sarah Briggs et de Cheng "Bish" Lorck en tant que commandants de terrain du M-COR.
# La bataille
La bataille a impliqué une guerre navale et terrestre, les navires civils de la Milice étant pris pour cible par la marine coloniale de l''IMC. En raison de l''importance stratégique du site M41 en tant que station de ravitaillement, les principaux objectifs de la flotte de la Milice étaient d''utiliser les pompes à carburant du site pour ravitailler leurs navires.
Cependant, les forces de l''IMC allaient mettre en place une défense lourde à trois points de ralliement : Alpha, Bravo et Charlie. En utilisant des points d''appui mobiles pour contrôler les tourelles lourdes et les pompes à carburant, les troupes terrestres se battraient pour le contrôle des trois bâtiments principaux, la Milice s''efforçant de maintenir les défenses aériennes hors ligne et l''IMC d''abattre le plus grand nombre possible de vaisseaux de la Milice.
En fonction des résultats, il est possible que le vaisseau de la Milice Redeye ait été abattu. ', '6521a3b8-b039-4643-bf26-500221131805') ON CONFLICT DO NOTHING;
INSERT INTO public.partner_category_translations (id, partner_category_id, languages_code, name) VALUES (1, 1, 'en-US', 'Tier 1') ON CONFLICT DO NOTHING;
INSERT INTO public.partner_category_translations (id, partner_category_id, languages_code, name) VALUES (2, 1, 'fr-FR', 'Tier 1') ON CONFLICT DO NOTHING;
INSERT INTO public.partner_category_translations (id, partner_category_id, languages_code, name) VALUES (3, 2, 'en-US', 'Tier 2') ON CONFLICT DO NOTHING;
INSERT INTO public.partner_category_translations (id, partner_category_id, languages_code, name) VALUES (4, 2, 'fr-FR', 'Tier 2') ON CONFLICT DO NOTHING;
INSERT INTO public.artists (id, name, image, link, start_time, end_time) VALUES (2, 'Quartztz', '6dd45be7-1d9c-4820-86c8-91be62e609cd', NULL, NULL, NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.artists (id, name, image, link, start_time, end_time) VALUES (3, 'Lina', '7189d0e0-3897-4c1a-a6eb-9faba9eb0f5f', NULL, NULL, NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.artists (id, name, image, link, start_time, end_time) VALUES (4, 'DJ Nokap', 'f6e36f55-f424-4dc8-a5ae-57da905a24b3', NULL, NULL, NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.artists (id, name, image, link, start_time, end_time) VALUES (5, 'Frénésie', '9f36c045-5cdf-48c9-b8b7-319a736a7f16', NULL, NULL, NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.artists (id, name, image, link, start_time, end_time) VALUES (6, 'Lunar Impact', '0852efa6-92a1-40f1-8b77-37b5296f9050', NULL, NULL, NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.artists (id, name, image, link, start_time, end_time) VALUES (1, 'Dialexo', 'f6b465f5-dc79-4355-a1ae-d719c9ce5ff0', 'Test', '20:30:00', '22:00:00') ON CONFLICT DO NOTHING;
INSERT INTO public.association_partners (id, association_id, partners_id) VALUES (1, 1, 1) ON CONFLICT DO NOTHING;
INSERT INTO public.association_partners (id, association_id, partners_id) VALUES (2, 1, 2) ON CONFLICT DO NOTHING;
INSERT INTO public."ICBD" (id, logo, presentation_video, date, start_time, end_time, place, timetable) VALUES (1, 'caeec171-0314-4bfc-b042-66ffb7f5fab0', 'https://clic.epfl.ch/nextcloud/s/e6ECN9geQgmYypy/download/ICBD%20Promotional%20Video_IC-COM.mp4', '2025-03-11', '10:30:00', '18:00:00', 'BC Building', NULL) ON CONFLICT DO NOTHING;
INSERT INTO public."ICBD_files" (id, "ICBD_id", directus_files_id) VALUES (5, 1, '3f53fb20-e623-42f0-8ad1-68bbc0ea923d') ON CONFLICT DO NOTHING;
INSERT INTO public."ICBD_files" (id, "ICBD_id", directus_files_id) VALUES (6, 1, '38492627-8ca5-4980-87d2-9bffdfdfc3cd') ON CONFLICT DO NOTHING;
INSERT INTO public."ICBD_files" (id, "ICBD_id", directus_files_id) VALUES (7, 1, '6891541c-f335-4374-ae61-0fa480b43b47') ON CONFLICT DO NOTHING;
INSERT INTO public."ICBD_translations" (id, "ICBD_id", languages_code, description, registration_instructions) VALUES (2, 1, 'fr-FR', 'CLIC and the IC Faculty are proud to present the 5th edition of IC Boost Day, a day dedicated to your future career in Computer and Communication Sciences! Take part in mock coding interviews and CV reviews, join various talks and meet plenty of EPFL IC alumni! They will be here to answer all the questions you may have as a future EPFL alumnus, both during specific “meetup sessions” or during our famous networking lunch! ICBD is a unique opportunity to prepare for your professional future in the world of computer science and engineering.', '1. Register for each of the activities you''d like to take part in. All activities are free of charge, but a deposit of CHF 10 is required to ensure your participation. This is payable at the CLIC office (INN 132), by cash or camipro.
The caution must be paid as soon as possible to secure your place in the activities with a limited number of participants (mock interview and speed networking).
It''s first paid, first served!
We will however try our best to accomodate the following participants who registered for the full activity.
Thank you for understanding!
The deposit will be returned to you during the lunch if you only registered for talks/meetups, otherwise after the last activity you registered for!
2. Master courses will be recorded or cancelled on this date. We will keep the teachers of BA6 courses informed, but we cannot guarantee that courses will be cancelled.') ON CONFLICT DO NOTHING;
INSERT INTO public."ICBD_translations" (id, "ICBD_id", languages_code, description, registration_instructions) VALUES (1, 1, 'en-US', 'CLIC and the IC Faculty are proud to present the 5th edition of IC Boost Day, a day dedicated to your future career in Computer and Communication Sciences! Take part in mock coding interviews and CV reviews, join various talks and meet plenty of EPFL IC alumni! They will be here to answer all the questions you may have as a future EPFL alumnus, both during specific “meetup sessions” or during our famous networking lunch! ICBD is a unique opportunity to prepare for your professional future in the world of computer science and engineering.', '1. Register for each of the activities you''d like to take part in. All activities are free of charge, but a deposit of CHF 10 is required to ensure your participation. This is payable at the CLIC office (INN 132), by cash or camipro. The caution must be paid as soon as possible to secure your place in the activities with a limited number of participants (mock interview and speed networking).
It''s first paid, first served!
We will however try our best to accomodate the following participants who registered for the full activity.
Thank you for understanding!
The deposit will be returned to you during the lunch if you only registered for talks/meetups, otherwise after the last activity you registered for!
2. Master courses will be recorded or cancelled on this date. We will keep the teachers of BA6 courses informed, but we cannot guarantee that courses will be cancelled.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities (id, icon, timeslots, color) VALUES (1, '50f5a1a3-8173-4dc6-8743-5b0c2c410605', '[{"room":"BC 01","start_time":"10:15:00","end_time":"12:00:00"}]', '#FFC23B') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities (id, icon, timeslots, color) VALUES (2, '02cc65c6-abfe-4f7d-a3b4-c3a8c0b52fe1', '[{"room":"BC 33","start_time":"13:00:00","end_time":"14:00:00"},{"room":"BC Booth","start_time":"10:00:00","end_time":"17:00:00"}]', '#2ECDA7') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities (id, icon, timeslots, color) VALUES (3, 'a5906cd1-e53e-4cf8-be3c-0bf616896ec7', '[{"room":"BC 01","start_time":"12:00:00","end_time":"13:00:00"},{"room":"bc 070","start_time":"12:00:00","end_time":"13:00:00"}]', '#E35169') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities (id, icon, timeslots, color) VALUES (5, '0b7f4ae2-7b25-4792-aa75-ff0da0e0de0e', '[{"room":"BC 07","start_time":"16:00:00","end_time":"18:00:00"}]', '#E35169') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities (id, icon, timeslots, color) VALUES (4, '6d3a2e63-901d-4c27-afc1-d5f6035a1bf5', '[{"room":"BC 129","start_time":"12:00:00","end_time":"14:20:00"},{"room":"BC 133","start_time":"12:40:00","end_time":"16:00:00"}]', '#FFC23B') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_speakers (id, first_name, last_name, picture, company, linkedin) VALUES (1, 'Albert', 'Dupont', '0852efa6-92a1-40f1-8b77-37b5296f9050', 'EPFL', NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_speakers (id, first_name, last_name, picture, company, linkedin) VALUES (2, 'Margeritte', 'Choupette', '9f36c045-5cdf-48c9-b8b7-319a736a7f16', 'Swisscom', NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_speakers (id, first_name, last_name, picture, company, linkedin) VALUES (3, 'Philippe', 'Mormont', '6dd45be7-1d9c-4820-86c8-91be62e609cd', 'ELCA', NULL) ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_icbd_speakers (id, icbd_activities_id, icbd_speakers_id) VALUES (1, 1, 1) ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_icbd_speakers (id, icbd_activities_id, icbd_speakers_id) VALUES (2, 2, 1) ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_icbd_speakers (id, icbd_activities_id, icbd_speakers_id) VALUES (3, 2, 2) ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (1, 1, 'en-US', 'CV correction', 'blablabla') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (2, 1, 'fr-FR', 'Correction de CV', 'blablabla') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (3, 2, 'en-US', 'Mock traditional & coding Interviews', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (4, 2, 'fr-FR', 'Mock traditional & coding Interviews', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (5, 3, 'en-US', 'Networking Lunch', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (6, 3, 'fr-FR', 'Networking Lunch', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (7, 4, 'en-US', 'Super Activity', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (8, 4, 'fr-FR', 'Super Activity', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (9, 5, 'en-US', 'Harry Potter Projection', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_activities_translations (id, icbd_activities_id, languages_code, name, description) VALUES (10, 5, 'fr-FR', 'Harry Potter Projection', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim aeque doleamus animo, cum corpore dolemus, fieri tamen permagna accessio potest, si aliquod aeternum et infinitum impendere malum nobis opinemur. Quod idem licet transferre in voluptatem, ut.') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_phds (id, first_name, last_name, laboratory, picture) VALUES (1, 'Alex', 'Ipsum', 'DSCL', 'df7992b2-955e-4b18-b0d5-45d58da4e373') ON CONFLICT DO NOTHING;
INSERT INTO public.icbd_phds (id, first_name, last_name, laboratory, picture) VALUES (2, 'Cécile', 'Alphonse', 'Hopper', '525d475c-24a0-45cb-947f-c70eca52c3b6') ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'artists', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_memberships', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_memberships_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_partners', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_poles', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_poles_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_public_files', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_public_files_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_social_links', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'association_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'commission_memberships', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'commission_memberships_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'commissions', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'commissions_social_links', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'commissions_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'languages', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'members', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'news', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'news_commissions', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'news_partners', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'news_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'partner_category', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'partner_category_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'partners', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'save_the_date', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'save_the_date_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'std_cell', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'social_links', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'std_cell_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'subsonic', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'directus_files', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'directus_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'events', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'ICBD', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'ICBD_files', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'ICBD_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'icbd_speakers', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'icbd_phds', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'icbd_activities', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'icbd_activities_translations', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;
INSERT INTO directus_permissions (collection, action, fields, policy) SELECT 'icbd_activities_icbd_speakers', 'read', '*', id FROM directus_policies WHERE name ='$t:public_label' ON CONFLICT DO NOTHING;