· 5 years ago · Mar 22, 2020, 04:58 PM
1DROP TABLE IF EXISTS `camera_photos_like`;
2CREATE TABLE IF NOT EXISTS `camera_photos_like` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `user_id` int(11) NOT NULL,
5 `camera_id` int(11) NOT NULL,
6 PRIMARY KEY (`id`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
8
9-- --------------------------------------------------------
10
11--
12-- Structure de la table `camera_photos_view`
13--
14
15DROP TABLE IF EXISTS `camera_photos_view`;
16CREATE TABLE IF NOT EXISTS `camera_photos_view` (
17 `id` int(11) NOT NULL AUTO_INCREMENT,
18 `user_id` int(11) NOT NULL,
19 `camera_id` int(11) NOT NULL,
20 PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `cloudcms_antibtf`
27--
28
29DROP TABLE IF EXISTS `cloudcms_antibtf`;
30CREATE TABLE IF NOT EXISTS `cloudcms_antibtf` (
31 `id` int(11) NOT NULL AUTO_INCREMENT,
32 `ip` varchar(255) NOT NULL,
33 `tentatives` int(11) NOT NULL,
34 `expiretime` int(11) NOT NULL,
35 PRIMARY KEY (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
37
38-- --------------------------------------------------------
39
40--
41-- Structure de la table `cloudcms_api`
42--
43
44DROP TABLE IF EXISTS `cloudcms_api`;
45CREATE TABLE IF NOT EXISTS `cloudcms_api` (
46 `cms` varchar(255) NOT NULL DEFAULT 'HabboZoneCMS',
47 `server` enum('open','close') NOT NULL DEFAULT 'open',
48 PRIMARY KEY (`cms`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1;
50
51--
52-- Déchargement des données de la table `cloudcms_api`
53--
54
55INSERT INTO `cloudcms_api` (`cms`, `server`) VALUES
56('HabboCityCMS', 'open');
57
58-- --------------------------------------------------------
59
60--
61-- Structure de la table `cloudcms_articles`
62--
63
64DROP TABLE IF EXISTS `cloudcms_articles`;
65CREATE TABLE IF NOT EXISTS `cloudcms_articles` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `title` varchar(80) NOT NULL,
68 `snippet` varchar(100) NOT NULL,
69 `content` text NOT NULL,
70 `img` varchar(500) NOT NULL,
71 `timepost` int(11) NOT NULL,
72 `user_id` int(11) NOT NULL,
73 `disabled` enum('0','1') NOT NULL DEFAULT '0',
74 PRIMARY KEY (`id`)
75) ENGINE=MyISAM DEFAULT CHARSET=latin1;
76
77-- --------------------------------------------------------
78
79--
80-- Structure de la table `cloudcms_articles_comments`
81--
82
83DROP TABLE IF EXISTS `cloudcms_articles_comments`;
84CREATE TABLE IF NOT EXISTS `cloudcms_articles_comments` (
85 `id` int(11) NOT NULL AUTO_INCREMENT,
86 `article_id` int(11) NOT NULL,
87 `content` varchar(100) NOT NULL,
88 `user_id` int(11) NOT NULL,
89 `timepost` int(11) NOT NULL,
90 `disabled` enum('0','1') NOT NULL DEFAULT '0',
91 PRIMARY KEY (`id`)
92) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
93
94-- --------------------------------------------------------
95
96--
97-- Structure de la table `cloudcms_articles_reactions`
98--
99
100DROP TABLE IF EXISTS `cloudcms_articles_reactions`;
101CREATE TABLE IF NOT EXISTS `cloudcms_articles_reactions` (
102 `id` int(11) NOT NULL AUTO_INCREMENT,
103 `article_id` int(11) NOT NULL,
104 `user_id` int(11) NOT NULL,
105 `react_id` int(11) NOT NULL,
106 PRIMARY KEY (`id`)
107) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
108
109-- --------------------------------------------------------
110
111--
112-- Structure de la table `cloudcms_badges`
113--
114
115DROP TABLE IF EXISTS `cloudcms_badges`;
116CREATE TABLE IF NOT EXISTS `cloudcms_badges` (
117 `id` int(11) NOT NULL AUTO_INCREMENT,
118 `badgeid1` varchar(15) NOT NULL,
119 `badgeid2` varchar(15) NOT NULL,
120 `badgeid3` varchar(15) NOT NULL,
121 `stock` int(11) NOT NULL DEFAULT 10,
122 `prix` int(11) NOT NULL,
123 `disabled` enum('0','1') NOT NULL DEFAULT '0',
124 PRIMARY KEY (`id`)
125) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
126
127
128-- --------------------------------------------------------
129
130--
131-- Structure de la table `cloudcms_coffres`
132--
133
134DROP TABLE IF EXISTS `cloudcms_coffres`;
135CREATE TABLE IF NOT EXISTS `cloudcms_coffres` (
136 `id` int(11) NOT NULL AUTO_INCREMENT,
137 `title` varchar(50) NOT NULL,
138 `image` text NOT NULL,
139 `caresses` int(11) NOT NULL,
140 `winwins` int(11) NOT NULL,
141 `diamants` int(11) NOT NULL,
142 `respects` int(11) NOT NULL,
143 `price` int(11) NOT NULL,
144 `stock` int(11) NOT NULL DEFAULT 0,
145 `disabled` enum('0','1') NOT NULL DEFAULT '0',
146 PRIMARY KEY (`id`)
147) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
148
149--
150-- Déchargement des données de la table `cloudcms_coffres`
151--
152
153INSERT INTO `cloudcms_coffres` (`id`, `title`, `image`, `caresses`, `winwins`, `diamants`, `respects`, `price`, `stock`, `disabled`) VALUES
154(1, 'Coffre Renne', 'https://www.habbocity.me/swfs/c_images/upload/y42Dvadaa6ieWt3.png', 150, 400, 30, 150, 500, 5, '0'),
155(2, 'Coffre Habberge', 'https://www.habbocity.me/swfs/c_images/upload/1LH1z2ZmZmTsJJV.png', 75, 1500, 10, 75, 300, 15, '0'),
156(3, 'Coffre Gigantesque', 'https://www.habbocity.me/swfs/c_images/upload/Tmcosa7rXpsabLG.png', 320, 6499, 90000, 149, 800, 15, '0'),
157(4, 'Coffre minuscule', 'https://www.habbocity.me/swfs/c_images/upload/1cJtDDw3fcUrc7g.png', 30, 100, 4000, 15, 45, 15, '0'),
158(5, 'Coffre Classique', 'https://www.habbocity.me/swfs/c_images/upload/qV03SaTZlAF88ph.png', 29, 399, 2000, 29, 75, 15, '0'),
159(6, 'Coffre Diamants', 'https://www.habbocity.me/swfs/c_images/upload/Ws0X1rxgKO3MfN5.png', 5, 5, 30000, 5, 320, 15, '0');
160
161-- --------------------------------------------------------
162
163--
164-- Structure de la table `cloudcms_confirmations`
165--
166
167DROP TABLE IF EXISTS `cloudcms_confirmations`;
168CREATE TABLE IF NOT EXISTS `cloudcms_confirmations` (
169 `id` int(11) NOT NULL AUTO_INCREMENT,
170 `user_id` int(11) NOT NULL,
171 `type` enum('mail','password') NOT NULL,
172 `email` varchar(255) NOT NULL,
173 `code` varchar(6) NOT NULL,
174 `expiretime` int(11) NOT NULL,
175 PRIMARY KEY (`id`)
176) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
177
178-- --------------------------------------------------------
179
180--
181-- Structure de la table `cloudcms_forums`
182--
183
184DROP TABLE IF EXISTS `cloudcms_forums`;
185CREATE TABLE IF NOT EXISTS `cloudcms_forums` (
186 `id` int(11) NOT NULL AUTO_INCREMENT,
187 `categorie` int(11) NOT NULL,
188 `title` varchar(150) NOT NULL,
189 `content` text NOT NULL,
190 `timepost` int(11) NOT NULL,
191 `user_id` int(11) NOT NULL,
192 `user_id_edit` int(11) NOT NULL DEFAULT 0,
193 `edittime` int(11) NOT NULL DEFAULT 0,
194 `statut` enum('1','2') NOT NULL DEFAULT '1',
195 `epingle` enum('0','1') NOT NULL DEFAULT '0',
196 `disabled` enum('0','1') NOT NULL DEFAULT '0',
197 PRIMARY KEY (`id`)
198) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
199
200-- --------------------------------------------------------
201
202--
203-- Structure de la table `cloudcms_forum_coms`
204--
205
206DROP TABLE IF EXISTS `cloudcms_forum_coms`;
207CREATE TABLE IF NOT EXISTS `cloudcms_forum_coms` (
208 `id` int(11) NOT NULL AUTO_INCREMENT,
209 `forum_id` int(11) NOT NULL,
210 `user_id` int(11) NOT NULL,
211 `content` varchar(150) NOT NULL,
212 `timepost` int(11) NOT NULL,
213 `user_id_edit` int(11) NOT NULL DEFAULT 0,
214 `edittime` int(11) NOT NULL DEFAULT 0,
215 `disabled` enum('0','1') NOT NULL DEFAULT '0',
216 PRIMARY KEY (`id`)
217) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
218
219-- --------------------------------------------------------
220
221--
222-- Structure de la table `cloudcms_forum_coms_reactions`
223--
224
225DROP TABLE IF EXISTS `cloudcms_forum_coms_reactions`;
226CREATE TABLE IF NOT EXISTS `cloudcms_forum_coms_reactions` (
227 `id` int(11) NOT NULL AUTO_INCREMENT,
228 `user_id` int(11) NOT NULL,
229 `com_id` int(11) NOT NULL,
230 `react_id` int(11) NOT NULL,
231 PRIMARY KEY (`id`)
232) ENGINE=MyISAM DEFAULT CHARSET=latin1;
233
234-- --------------------------------------------------------
235
236--
237-- Structure de la table `cloudcms_forum_reactions`
238--
239
240DROP TABLE IF EXISTS `cloudcms_forum_reactions`;
241CREATE TABLE IF NOT EXISTS `cloudcms_forum_reactions` (
242 `id` int(11) NOT NULL AUTO_INCREMENT,
243 `user_id` int(11) NOT NULL,
244 `forum_id` int(11) NOT NULL,
245 `react_id` int(11) NOT NULL,
246 PRIMARY KEY (`id`)
247) ENGINE=MyISAM DEFAULT CHARSET=latin1;
248
249-- --------------------------------------------------------
250
251--
252-- Structure de la table `cloudcms_forum_view`
253--
254
255DROP TABLE IF EXISTS `cloudcms_forum_view`;
256CREATE TABLE IF NOT EXISTS `cloudcms_forum_view` (
257 `id` int(11) NOT NULL AUTO_INCREMENT,
258 `user_id` int(11) NOT NULL,
259 `forum_id` int(11) NOT NULL,
260 PRIMARY KEY (`id`)
261) ENGINE=MyISAM DEFAULT CHARSET=latin1;
262
263-- --------------------------------------------------------
264
265--
266-- Structure de la table `cloudcms_logs`
267--
268
269DROP TABLE IF EXISTS `cloudcms_logs`;
270CREATE TABLE IF NOT EXISTS `cloudcms_logs` (
271 `id` int(11) NOT NULL AUTO_INCREMENT,
272 `user_id` int(11) NOT NULL,
273 `timeact` int(11) NOT NULL,
274 `action` varchar(400) NOT NULL,
275 PRIMARY KEY (`id`)
276) ENGINE=MyISAM DEFAULT CHARSET=latin1;
277
278-- --------------------------------------------------------
279
280--
281-- Structure de la table `cloudcms_notifications`
282--
283
284DROP TABLE IF EXISTS `cloudcms_notifications`;
285CREATE TABLE IF NOT EXISTS `cloudcms_notifications` (
286 `id` int(11) NOT NULL AUTO_INCREMENT,
287 `user_id` int(11) NOT NULL,
288 `title` varchar(100) NOT NULL,
289 `text` text NOT NULL,
290 `timepost` int(11) NOT NULL,
291 PRIMARY KEY (`id`)
292) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
293
294-- --------------------------------------------------------
295
296--
297-- Structure de la table `cloudcms_pincode`
298--
299
300DROP TABLE IF EXISTS `cloudcms_pincode`;
301CREATE TABLE IF NOT EXISTS `cloudcms_pincode` (
302 `id` int(11) NOT NULL AUTO_INCREMENT,
303 `user_id` int(11) NOT NULL,
304 `tentative` int(11) NOT NULL,
305 PRIMARY KEY (`id`)
306) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
307
308-- --------------------------------------------------------
309
310--
311-- Structure de la table `cloudcms_reports`
312--
313
314CREATE TABLE `cloudcms_reports` (
315 `id` int(11) NOT NULL,
316 `user_id` int(11) NOT NULL,
317 `type` enum('news','forum') NOT NULL DEFAULT 'news',
318 `page_id` int(11) NOT NULL,
319 `com_id` int(11) NOT NULL,
320 `signalement` varchar(255) NOT NULL,
321 `disabled` enum('0','1') NOT NULL DEFAULT '0'
322) ENGINE=MyISAM DEFAULT CHARSET=latin1;
323
324ALTER TABLE `cloudcms_reports`
325 ADD PRIMARY KEY (`id`);
326
327-- --------------------------------------------------------
328
329--
330-- Structure de la table `cloudcms_support`
331--
332
333DROP TABLE IF EXISTS `cloudcms_support`;
334CREATE TABLE IF NOT EXISTS `cloudcms_support` (
335 `id` int(11) NOT NULL AUTO_INCREMENT,
336 `title` varchar(150) NOT NULL,
337 `type` enum('1','2','3','4','9','10','12','11') NOT NULL DEFAULT '1',
338 `importance` enum('1','2','3','4','5') NOT NULL DEFAULT '1',
339 `content` text NOT NULL,
340 `timepost` int(11) NOT NULL,
341 `user_id` int(11) NOT NULL,
342 `user_id_team` int(11) NOT NULL DEFAULT 1,
343 `statut` enum('1','2','3') NOT NULL DEFAULT '1',
344 PRIMARY KEY (`id`)
345) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
346
347-- --------------------------------------------------------
348
349--
350-- Structure de la table `cloudcms_support_rep`
351--
352
353DROP TABLE IF EXISTS `cloudcms_support_rep`;
354CREATE TABLE IF NOT EXISTS `cloudcms_support_rep` (
355 `id` int(11) NOT NULL AUTO_INCREMENT,
356 `ticket_id` int(11) NOT NULL,
357 `user_id` int(11) NOT NULL,
358 `content` varchar(255) NOT NULL,
359 PRIMARY KEY (`id`)
360) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
361
362-- --------------------------------------------------------
363
364--
365-- Structure de la table `cloudcms_transactions`
366--
367
368DROP TABLE IF EXISTS `cloudcms_transactions`;
369CREATE TABLE IF NOT EXISTS `cloudcms_transactions` (
370 `id` int(11) NOT NULL AUTO_INCREMENT,
371 `user_id` int(11) NOT NULL,
372 `content` text NOT NULL,
373 `timepost` int(11) NOT NULL,
374 PRIMARY KEY (`id`)
375) ENGINE=MyISAM DEFAULT CHARSET=latin1;
376
377-- --------------------------------------------------------
378
379--
380-- Structure de la table `cloudcms_tweets`
381--
382
383DROP TABLE IF EXISTS `cloudcms_tweets`;
384CREATE TABLE IF NOT EXISTS `cloudcms_tweets` (
385 `id` int(11) NOT NULL AUTO_INCREMENT,
386 `user_id` int(11) NOT NULL,
387 `content` varchar(255) NOT NULL,
388 `timepost` int(11) NOT NULL,
389 PRIMARY KEY (`id`)
390) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
391
392-- --------------------------------------------------------
393
394--
395-- Structure de la table `cloudcms_tweets_like`
396--
397
398DROP TABLE IF EXISTS `cloudcms_tweets_like`;
399CREATE TABLE IF NOT EXISTS `cloudcms_tweets_like` (
400 `id` int(11) NOT NULL AUTO_INCREMENT,
401 `tweet_id` int(11) NOT NULL,
402 `user_id` int(11) NOT NULL,
403 PRIMARY KEY (`id`)
404) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
405
406-- --------------------------------------------------------
407
408--
409-- Structure de la table `cloudcms_tweets_rt`
410--
411
412DROP TABLE IF EXISTS `cloudcms_tweets_rt`;
413CREATE TABLE IF NOT EXISTS `cloudcms_tweets_rt` (
414 `id` int(11) NOT NULL AUTO_INCREMENT,
415 `tweet_id` int(11) NOT NULL,
416 `user_id` int(11) NOT NULL,
417 PRIMARY KEY (`id`)
418) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
419
420-- --------------------------------------------------------
421
422--
423-- Structure de la table `cloudcms_vipclub`
424--
425
426DROP TABLE IF EXISTS `cloudcms_vipclub`;
427CREATE TABLE IF NOT EXISTS `cloudcms_vipclub` (
428 `id` int(11) NOT NULL AUTO_INCREMENT,
429 `user_id` int(11) NOT NULL,
430 `starttime` int(11) NOT NULL,
431 `expiretime` int(11) NOT NULL,
432 PRIMARY KEY (`id`)
433) ENGINE=MyISAM DEFAULT CHARSET=latin1;
434
435-- --------------------------------------------------------
436
437--
438-- Structure de la table `users`
439--
440
441DROP TABLE IF EXISTS `users`;
442CREATE TABLE IF NOT EXISTS `users` (
443 `id` int(11) NOT NULL AUTO_INCREMENT,
444 `username` varchar(125) NOT NULL,
445 `password` varchar(255) DEFAULT NULL,
446 `password_lastchange` int(11) DEFAULT NULL,
447 `usepincode` enum('0','1') DEFAULT '0',
448 `pincode` varchar(4) DEFAULT NULL,
449 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
450 `mail_verified` enum('0','1') NOT NULL DEFAULT '0',
451 `auth_ticket` varchar(60) NOT NULL,
452 `rank` int(1) UNSIGNED DEFAULT 1,
453 `rank_vip` int(1) DEFAULT 1,
454 `credits` int(11) DEFAULT 50000,
455 `vip_points` int(11) DEFAULT 0,
456 `jetons` int(11) NOT NULL DEFAULT 0,
457 `activity_points` int(11) DEFAULT 0,
458 `pointsgame` int(11) NOT NULL DEFAULT 0,
459 `look` char(255) DEFAULT NULL,
460 `gender` enum('M','F') DEFAULT 'M',
461 `motto` char(50) DEFAULT NULL,
462 `fonction` varchar(255) NOT NULL DEFAULT 'Membre',
463 `fonction2` varchar(255) NOT NULL DEFAULT 'Membre',
464 `orga_name` varchar(255) NOT NULL DEFAULT 'Aucune',
465 `account_created` char(12) DEFAULT '0',
466 `last_online` int(11) DEFAULT 0,
467 `online` enum('0','1') DEFAULT '0',
468 `ip_last` varchar(45) DEFAULT '',
469 `ip_reg` varchar(45) DEFAULT NULL,
470 `home_room` int(10) DEFAULT 0,
471 `is_muted` enum('0','1') DEFAULT '0',
472 `block_newfriends` enum('0','1') DEFAULT '0',
473 `hide_online` enum('0','1') DEFAULT '0',
474 `hide_inroom` enum('0','1') DEFAULT '0',
475 `vip` enum('0','1') DEFAULT '1',
476 `volume` varchar(15) DEFAULT '100,100,100',
477 `last_change` int(20) DEFAULT 0,
478 `machine_id` varchar(125) DEFAULT '',
479 `focus_preference` enum('0','1') DEFAULT '0',
480 `chat_preference` enum('0','1') DEFAULT '0',
481 `pets_muted` enum('0','1') DEFAULT '0',
482 `bots_muted` enum('0','1') DEFAULT '0',
483 `advertising_report_blocked` enum('0','1') DEFAULT '0',
484 `gotw_points` int(11) DEFAULT 0,
485 `ignore_invites` enum('0','1') DEFAULT '0',
486 `time_muted` double DEFAULT 0,
487 `allow_gifts` enum('0','1') DEFAULT '1',
488 `trading_locked` double DEFAULT 0,
489 `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
490 `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
491 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
492 `disabled` enum('0','1') NOT NULL DEFAULT '0',
493 PRIMARY KEY (`id`),
494 UNIQUE KEY `id` (`id`)
495) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
496
497-- --------------------------------------------------------
498
499--
500-- Structure de la table `ranks`
501--
502
503DROP TABLE IF EXISTS `ranks`;
504CREATE TABLE IF NOT EXISTS `ranks` (
505 `id` int(11) NOT NULL AUTO_INCREMENT,
506 `name` varchar(80) NOT NULL,
507 `badgeid` varchar(50) NOT NULL DEFAULT 'ADM',
508 `title` varchar(50) NOT NULL,
509 `tab_colour` enum('red','green','pixeldarkblue','orange','blue','settings','pixellightblue') NOT NULL DEFAULT 'red',
510 PRIMARY KEY (`id`)
511) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
512
513--
514-- Déchargement des données de la table `ranks`
515--
516
517INSERT INTO `ranks` (`id`, `name`, `badgeid`, `title`, `tab_colour`) VALUES
518(1, 'Utilisateur', 'VIP', 'Utilisateur', 'red'),
519(2, 'VIP', 'VIP', 'Utilisateur VIP', 'green'),
520(3, 'ASSISTANCE DISCORD', 'ADM', 'ASSISTANCE DISCORD', 'orange'),
521(4, 'FORUM', 'ADM', 'FORUM', 'settings'),
522(5, 'ASSISTANCE', 'ADM', 'ASSISTANCE', 'pixellightblue'),
523(6, 'SÉCURITÉ', 'ADM', 'SÉCURITÉ', 'pixellightblue'),
524(7, 'CASINO', 'ADM', 'CASINO', 'pixellightblue'),
525(8, 'ARCHITECTURE', 'ADM', 'ARCHITECTURE', 'pixellightblue'),
526(9, 'ANIMATION', 'ADM', 'ANIMATION', 'pixellightblue'),
527(10, 'ÉVÉNEMENTIEL', 'ADM', 'ÉVÉNEMENTIEL', 'pixellightblue'),
528(11, 'COMMUNICATION', 'ADM', 'COMMUNICATION', 'pixellightblue'),
529(12, 'VIDÉO', 'ADM', 'VIDÉO', 'pixellightblue'),
530(13, 'GRAPHISME', 'ADM', 'GRAPHISME', 'pixellightblue'),
531(14, 'PIXEL ARTISTES', 'ADM', 'PIXEL ARTISTES', 'pixellightblue'),
532(15, 'POSTE SPÉCIAUX', 'ADM', 'POSTE SPÉCIAUX', 'pixellightblue'),
533(16, 'DIRECTION', 'ADM', 'DIRECTION', 'blue');