· 10 years ago · Sep 10, 2016, 10:24 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.10
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:8889
6-- Generation Time: Sep 09, 2016 at 04:48 PM
7-- Server version: 5.5.42
8-- PHP Version: 5.6.10
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `ci_bootstrap_3`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `admin_groups`
21--
22
23CREATE TABLE `admin_groups` (
24 `id` mediumint(8) unsigned NOT NULL,
25 `name` varchar(20) NOT NULL,
26 `description` varchar(100) NOT NULL
27) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
28
29--
30-- Dumping data for table `admin_groups`
31--
32
33INSERT INTO `admin_groups` (`id`, `name`, `description`) VALUES
34(1, 'webmaster', 'Webmaster'),
35(2, 'admin', 'Administrator'),
36(3, 'manager', 'Manager'),
37(4, 'staff', 'Staff');
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `admin_login_attempts`
43--
44
45CREATE TABLE `admin_login_attempts` (
46 `id` int(11) unsigned NOT NULL,
47 `ip_address` varchar(15) NOT NULL,
48 `login` varchar(100) NOT NULL,
49 `time` int(11) unsigned DEFAULT NULL
50) ENGINE=InnoDB DEFAULT CHARSET=utf8;
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `admin_users`
56--
57
58CREATE TABLE `admin_users` (
59 `id` int(11) unsigned NOT NULL,
60 `ip_address` varchar(15) NOT NULL,
61 `username` varchar(100) DEFAULT NULL,
62 `password` varchar(255) NOT NULL,
63 `salt` varchar(255) DEFAULT NULL,
64 `email` varchar(100) DEFAULT NULL,
65 `activation_code` varchar(40) DEFAULT NULL,
66 `forgotten_password_code` varchar(40) DEFAULT NULL,
67 `forgotten_password_time` int(11) unsigned DEFAULT NULL,
68 `remember_code` varchar(40) DEFAULT NULL,
69 `created_on` int(11) unsigned NOT NULL,
70 `last_login` int(11) unsigned DEFAULT NULL,
71 `active` tinyint(1) unsigned DEFAULT NULL,
72 `first_name` varchar(50) DEFAULT NULL,
73 `last_name` varchar(50) DEFAULT NULL
74) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
75
76--
77-- Dumping data for table `admin_users`
78--
79
80INSERT INTO `admin_users` (`id`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`) VALUES
81(1, '127.0.0.1', 'webmaster', '$2y$08$/X5gzWjesYi78GqeAv5tA.dVGBVP7C1e1PzqnYCVe5s1qhlDIPPES', NULL, NULL, NULL, NULL, NULL, NULL, 1451900190, 1473432282, 1, 'Webmaster', ''),
82(2, '127.0.0.1', 'admin', '$2y$08$7Bkco6JXtC3Hu6g9ngLZDuHsFLvT7cyAxiz1FzxlX5vwccvRT7nKW', NULL, NULL, NULL, NULL, NULL, NULL, 1451900228, 1462275803, 1, 'Admin', ''),
83(3, '127.0.0.1', 'manager', '$2y$08$snzIJdFXvg/rSHe0SndIAuvZyjktkjUxBXkrrGdkPy1K6r5r/dMLa', NULL, NULL, NULL, NULL, NULL, NULL, 1451900430, 1462275670, 1, 'Manager', ''),
84(4, '127.0.0.1', 'staff', '$2y$08$NigAXjN23CRKllqe3KmjYuWXD5iSRPY812SijlhGeKfkrMKde9da6', NULL, NULL, NULL, NULL, NULL, NULL, 1451900439, 1462277956, 1, 'Staff', ''),
85(5, '::1', 'test', '$2y$08$ePZMyZvymQzmt/JhWmw8jOahwNv5fUz6QH1frQa.dhFoHSobI6v5q', NULL, NULL, NULL, NULL, NULL, NULL, 1462284130, NULL, 1, 'test', 'test'),
86(6, '::1', 'super luke', '$2y$08$nZ2PR7.dMnAyfuQGkJAULe/j68RlRVKASTEGrqYt9TgYZMQu1n.N2', NULL, NULL, NULL, NULL, NULL, NULL, 1462286753, 1462286795, 1, 'Tanawa Tsamo', 'Mariu'),
87(7, '::1', 'testadmin', '$2y$08$AkvCHeAdF.xfjzAG/m1fLeaZ4McicEZ98DoE1KOmRVO2GoPmMKwf2', NULL, NULL, NULL, NULL, NULL, NULL, 1462373692, 1466367139, 1, 'test', 'admin'),
88(8, '::1', 'teststaff', '$2y$08$jEuyZi4wPV/DtvI9c1gU4uGa2lwSZwhho55KYTnYBdfUT.MwufzDa', NULL, NULL, NULL, NULL, NULL, NULL, 1462373707, 1466367116, 1, 'test', 'staff');
89
90-- --------------------------------------------------------
91
92--
93-- Table structure for table `admin_users_groups`
94--
95
96CREATE TABLE `admin_users_groups` (
97 `id` int(11) unsigned NOT NULL,
98 `user_id` int(11) unsigned NOT NULL,
99 `group_id` mediumint(8) unsigned NOT NULL
100) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
101
102--
103-- Dumping data for table `admin_users_groups`
104--
105
106INSERT INTO `admin_users_groups` (`id`, `user_id`, `group_id`) VALUES
107(1, 1, 1),
108(2, 2, 2),
109(3, 3, 3),
110(4, 4, 4),
111(5, 5, 2),
112(6, 6, 4),
113(7, 7, 2),
114(8, 8, 4);
115
116-- --------------------------------------------------------
117
118--
119-- Table structure for table `api_access`
120--
121
122CREATE TABLE `api_access` (
123 `id` int(11) unsigned NOT NULL,
124 `key` varchar(40) NOT NULL DEFAULT '',
125 `controller` varchar(50) NOT NULL DEFAULT '',
126 `date_created` datetime DEFAULT NULL,
127 `date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
128) ENGINE=InnoDB DEFAULT CHARSET=utf8;
129
130-- --------------------------------------------------------
131
132--
133-- Table structure for table `api_keys`
134--
135
136CREATE TABLE `api_keys` (
137 `id` int(11) NOT NULL,
138 `user_id` int(11) NOT NULL,
139 `key` varchar(40) NOT NULL,
140 `level` int(2) NOT NULL,
141 `ignore_limits` tinyint(1) NOT NULL DEFAULT '0',
142 `is_private_key` tinyint(1) NOT NULL DEFAULT '0',
143 `ip_addresses` text,
144 `date_created` int(11) NOT NULL
145) ENGINE=InnoDB DEFAULT CHARSET=utf8;
146
147-- --------------------------------------------------------
148
149--
150-- Table structure for table `api_limits`
151--
152
153CREATE TABLE `api_limits` (
154 `id` int(11) NOT NULL,
155 `uri` varchar(255) NOT NULL,
156 `count` int(10) NOT NULL,
157 `hour_started` int(11) NOT NULL,
158 `api_key` varchar(40) NOT NULL
159) ENGINE=InnoDB DEFAULT CHARSET=utf8;
160
161-- --------------------------------------------------------
162
163--
164-- Table structure for table `api_logs`
165--
166
167CREATE TABLE `api_logs` (
168 `id` int(11) NOT NULL,
169 `uri` varchar(255) NOT NULL,
170 `method` varchar(6) NOT NULL,
171 `params` text,
172 `api_key` varchar(40) NOT NULL,
173 `ip_address` varchar(45) NOT NULL,
174 `time` int(11) NOT NULL,
175 `rtime` float DEFAULT NULL,
176 `authorized` varchar(1) NOT NULL,
177 `response_code` smallint(3) DEFAULT '0'
178) ENGINE=InnoDB DEFAULT CHARSET=utf8;
179
180-- --------------------------------------------------------
181
182--
183-- Table structure for table `demo_blog_categories`
184--
185
186CREATE TABLE `demo_blog_categories` (
187 `id` int(11) NOT NULL,
188 `pos` int(11) NOT NULL DEFAULT '0',
189 `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL
190) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
191
192--
193-- Dumping data for table `demo_blog_categories`
194--
195
196INSERT INTO `demo_blog_categories` (`id`, `pos`, `title`) VALUES
197(1, 1, 'Category 1'),
198(2, 2, 'Category 2'),
199(3, 3, 'Category 3');
200
201-- --------------------------------------------------------
202
203--
204-- Table structure for table `demo_blog_posts`
205--
206
207CREATE TABLE `demo_blog_posts` (
208 `id` int(11) NOT NULL,
209 `category_id` int(11) NOT NULL DEFAULT '1',
210 `author_id` int(11) NOT NULL,
211 `title` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
212 `image_url` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
213 `content_brief` text COLLATE utf8_unicode_ci NOT NULL,
214 `content` text COLLATE utf8_unicode_ci NOT NULL,
215 `publish_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
216 `status` enum('draft','active','hidden') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'draft'
217) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
218
219--
220-- Dumping data for table `demo_blog_posts`
221--
222
223INSERT INTO `demo_blog_posts` (`id`, `category_id`, `author_id`, `title`, `image_url`, `content_brief`, `content`, `publish_time`, `status`) VALUES
224(1, 1, 2, 'Blog Post 1', '', '<p>\r\n Blog Post 1 Content Brief</p>\r\n', '<p>\r\n Blog Post 1 Content</p>\r\n', '2015-09-25 22:00:00', 'active');
225
226-- --------------------------------------------------------
227
228--
229-- Table structure for table `demo_blog_posts_tags`
230--
231
232CREATE TABLE `demo_blog_posts_tags` (
233 `id` int(11) NOT NULL,
234 `post_id` int(11) NOT NULL,
235 `tag_id` int(11) NOT NULL
236) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
237
238--
239-- Dumping data for table `demo_blog_posts_tags`
240--
241
242INSERT INTO `demo_blog_posts_tags` (`id`, `post_id`, `tag_id`) VALUES
243(1, 1, 2),
244(2, 1, 1),
245(3, 1, 3);
246
247-- --------------------------------------------------------
248
249--
250-- Table structure for table `demo_blog_tags`
251--
252
253CREATE TABLE `demo_blog_tags` (
254 `id` int(11) NOT NULL,
255 `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL
256) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
257
258--
259-- Dumping data for table `demo_blog_tags`
260--
261
262INSERT INTO `demo_blog_tags` (`id`, `title`) VALUES
263(1, 'Tag 1'),
264(2, 'Tag 2');
265
266-- --------------------------------------------------------
267
268--
269-- Table structure for table `demo_cover_photos`
270--
271
272CREATE TABLE `demo_cover_photos` (
273 `id` int(11) NOT NULL,
274 `pos` int(11) NOT NULL DEFAULT '0',
275 `image_url` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
276 `status` enum('active','hidden') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active'
277) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
278
279--
280-- Dumping data for table `demo_cover_photos`
281--
282
283INSERT INTO `demo_cover_photos` (`id`, `pos`, `image_url`, `status`) VALUES
284(1, 2, '45296-2.jpg', 'active'),
285(2, 1, '2934f-1.jpg', 'active'),
286(3, 3, '3717d-3.jpg', 'active');
287
288-- --------------------------------------------------------
289
290--
291-- Table structure for table `groups`
292--
293
294CREATE TABLE `groups` (
295 `id` mediumint(8) unsigned NOT NULL,
296 `name` varchar(20) NOT NULL,
297 `description` varchar(100) NOT NULL
298) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
299
300--
301-- Dumping data for table `groups`
302--
303
304INSERT INTO `groups` (`id`, `name`, `description`) VALUES
305(1, 'members', 'General User');
306
307-- --------------------------------------------------------
308
309--
310-- Table structure for table `login_attempts`
311--
312
313CREATE TABLE `login_attempts` (
314 `id` int(11) unsigned NOT NULL,
315 `ip_address` varchar(15) NOT NULL,
316 `login` varchar(100) NOT NULL,
317 `time` int(11) unsigned DEFAULT NULL
318) ENGINE=InnoDB DEFAULT CHARSET=utf8;
319
320-- --------------------------------------------------------
321
322--
323-- Table structure for table `moulibex`
324--
325
326CREATE TABLE `moulibex` (
327 `id` bigint(20) unsigned NOT NULL,
328 `type_presta` text NOT NULL,
329 `mois` varchar(20) NOT NULL,
330 `valeur` float NOT NULL
331) ENGINE=InnoDB DEFAULT CHARSET=latin1;
332
333-- --------------------------------------------------------
334
335--
336-- Table structure for table `suivi_convert`
337--
338
339CREATE TABLE `suivi_convert` (
340 `id` bigint(20) unsigned NOT NULL,
341 `cout_direct` float NOT NULL,
342 `nom_serveur` varchar(50) NOT NULL,
343 `application` varchar(120) NOT NULL,
344 `environnement` varchar(120) NOT NULL,
345 `mois_concerne` date NOT NULL,
346 `prod_horsprod` varchar(120) NOT NULL,
347 `clone` varchar(120) NOT NULL,
348 `id_scope_du_serveur` varchar(120) NOT NULL,
349 `nna` varchar(4) NOT NULL,
350 `cle_repartition_eac` int(11) NOT NULL,
351 `otp` varchar(120) NOT NULL,
352 `lpp` varchar(120) NOT NULL,
353 `statut_serveur` varchar(50) NOT NULL,
354 `type_os` varchar(50) NOT NULL,
355 `commenditaire_eac` varchar(50) NOT NULL,
356 `plateau_du_serveur` varchar(120) NOT NULL,
357 `pe_serveur` varchar(120) NOT NULL,
358 `chaine_de_service` varchar(120) NOT NULL,
359 `application_rcs` varchar(120) NOT NULL,
360 `service_de _disponibilite_serveur` varchar(50) NOT NULL,
361 `reserve_1` float NOT NULL,
362 `reserve_2` float NOT NULL,
363 `reserve_3` float NOT NULL,
364 `oahpsb` float NOT NULL,
365 `oahpsc` float NOT NULL,
366 `osc` float NOT NULL,
367 `shvaf_standard` float NOT NULL,
368 `shvaf_securise` float NOT NULL,
369 `shva_puissance` float NOT NULL,
370 `shvif_standard` float NOT NULL,
371 `shvif_securise` float NOT NULL,
372 `shvi_puissance` float NOT NULL,
373 `shvciif_standard` float NOT NULL,
374 `shvcii_puissance` float NOT NULL,
375 `shvcppaf_standard` float NOT NULL,
376 `shvcppa_puissance` float NOT NULL,
377 `shvcppif_standard` float NOT NULL,
378 `shvcppi_puissance` float NOT NULL,
379 `shdes` float NOT NULL,
380 `shds` float NOT NULL,
381 `shdm` float NOT NULL,
382 `shdl` float NOT NULL,
383 `shdel` float NOT NULL,
384 `shdp_intel` float NOT NULL,
385 `shdp_autre` float NOT NULL,
386 `shdrs` float NOT NULL,
387 `sbmsf` float NOT NULL,
388 `sbmsf_option` float NOT NULL,
389 `sbm_classic` float NOT NULL,
390 `sbmco_image` float NOT NULL,
391 `sbm_premium` float NOT NULL,
392 `sbmpo_image` float NOT NULL,
393 `sbmpo_performance` float NOT NULL,
394 `sbmpoi_performance` float NOT NULL,
395 `sbmst_masqué` float NOT NULL,
396 `smbd_go` float NOT NULL,
397 `sms_go` float NOT NULL,
398 `smhd_go` float NOT NULL,
399 `smthd_go` float NOT NULL,
400 `smejh_go` float NOT NULL,
401 `archivage` float NOT NULL,
402 `rs_datacenter` float NOT NULL,
403 `h_scientifique` float NOT NULL,
404 `date_importation` date NOT NULL,
405 `type_fichier` varchar(20) NOT NULL,
406 `type_previsionnel` varchar(40) NOT NULL,
407 `oahpac` float NOT NULL,
408 `oahpsp` float NOT NULL,
409 `sbm_basic` float NOT NULL,
410 `commentaire` text NOT NULL,
411 `categorie` varchar(30) NOT NULL
412) ENGINE=InnoDB DEFAULT CHARSET=utf8;
413
414-- --------------------------------------------------------
415
416--
417-- Table structure for table `suivi_stockage`
418--
419
420CREATE TABLE `suivi_stockage` (
421 `id` bigint(20) unsigned NOT NULL,
422 `cout_direct` float NOT NULL,
423 `nom_serveur` varchar(50) NOT NULL,
424 `application` varchar(120) NOT NULL,
425 `environnement` varchar(120) NOT NULL,
426 `mois_concerne` date NOT NULL,
427 `prod_horsprod` varchar(120) NOT NULL,
428 `clone` varchar(120) NOT NULL,
429 `id_scope_du_serveur` varchar(120) NOT NULL,
430 `nna` varchar(4) NOT NULL,
431 `cle_repartition_eac` int(11) NOT NULL,
432 `otp` varchar(120) NOT NULL,
433 `lpp` varchar(120) NOT NULL,
434 `statut_serveur` varchar(50) NOT NULL,
435 `type_os` varchar(50) NOT NULL,
436 `commenditaire_eac` varchar(50) NOT NULL,
437 `plateau_du_serveur` varchar(120) NOT NULL,
438 `pe_serveur` varchar(120) NOT NULL,
439 `chaine_de_service` varchar(120) NOT NULL,
440 `application_rcs` varchar(120) NOT NULL,
441 `service_de _disponibilite_serveur` varchar(50) NOT NULL,
442 `reserve_1` float NOT NULL,
443 `reserve_2` float NOT NULL,
444 `reserve_3` float NOT NULL,
445 `oahpsb` float NOT NULL,
446 `oahpsc` float NOT NULL,
447 `osc` float NOT NULL,
448 `shvaf_standard` float NOT NULL,
449 `shvaf_securise` float NOT NULL,
450 `shva_puissance` float NOT NULL,
451 `shvif_standard` float NOT NULL,
452 `shvif_securise` float NOT NULL,
453 `shvi_puissance` float NOT NULL,
454 `shvciif_standard` float NOT NULL,
455 `shvcii_puissance` float NOT NULL,
456 `shvcppaf_standard` float NOT NULL,
457 `shvcppa_puissance` float NOT NULL,
458 `shvcppif_standard` float NOT NULL,
459 `shvcppi_puissance` float NOT NULL,
460 `shdes` float NOT NULL,
461 `shds` float NOT NULL,
462 `shdm` float NOT NULL,
463 `shdl` float NOT NULL,
464 `shdel` float NOT NULL,
465 `shdp_intel` float NOT NULL,
466 `shdp_autre` float NOT NULL,
467 `shdrs` float NOT NULL,
468 `sbmsf` float NOT NULL,
469 `sbmsf_option` float NOT NULL,
470 `sbm_classic` float NOT NULL,
471 `sbmco_image` float NOT NULL,
472 `sbm_premium` float NOT NULL,
473 `sbmpo_image` float NOT NULL,
474 `sbmpo_performance` float NOT NULL,
475 `sbmpoi_performance` float NOT NULL,
476 `sbmst_masqué` float NOT NULL,
477 `smbd_go` float NOT NULL,
478 `sms_go` float NOT NULL,
479 `smhd_go` float NOT NULL,
480 `smthd_go` float NOT NULL,
481 `smejh_go` float NOT NULL,
482 `archivage` float NOT NULL,
483 `rs_datacenter` float NOT NULL,
484 `h_scientifique` float NOT NULL,
485 `date_importation` date NOT NULL,
486 `type_fichier` varchar(20) NOT NULL,
487 `type_previsionnel` varchar(40) NOT NULL,
488 `oahpac` float NOT NULL,
489 `oahpsp` float NOT NULL,
490 `sbm_basic` float NOT NULL,
491 `commentaire` text NOT NULL,
492 `categorie` varchar(30) NOT NULL
493) ENGINE=InnoDB DEFAULT CHARSET=utf8;
494
495-- --------------------------------------------------------
496
497--
498-- Table structure for table `suivi_stockage_type_fichier`
499--
500
501CREATE TABLE `suivi_stockage_type_fichier` (
502 `id` bigint(20) unsigned NOT NULL,
503 `suivi_stockage_id` int(11) DEFAULT NULL,
504 `type_fichier_id` int(11) DEFAULT NULL
505) ENGINE=InnoDB DEFAULT CHARSET=latin1;
506
507-- --------------------------------------------------------
508
509--
510-- Table structure for table `table2`
511--
512
513CREATE TABLE `table2` (
514 `id` int(11) NOT NULL,
515 `sname` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
516 `app` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
517 `otp` int(11) DEFAULT NULL,
518 `mc` int(11) DEFAULT NULL,
519 `pname` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
520 `uoh` int(11) DEFAULT NULL,
521 `uospo` int(11) DEFAULT NULL,
522 `uosc` int(11) DEFAULT NULL,
523 `uoso` int(11) DEFAULT NULL,
524 `uosp` int(11) DEFAULT NULL,
525 `type` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
526 `ddi` date DEFAULT NULL,
527 `dm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
528) ENGINE=InnoDB AUTO_INCREMENT=4891 DEFAULT CHARSET=utf8;
529
530--
531-- Dumping data for table `table2`
532--
533
534INSERT INTO `table2` (`id`, `sname`, `app`, `otp`, `mc`, `pname`, `uoh`, `uospo`, `uosc`, `uoso`, `uosp`, `type`, `ddi`, `dm`) VALUES
535(1, 'TEST1', 'SIMM', 1, 0, 'REDA', 2, 1, 1, NULL, 1, 'R6', '2016-03-14', '2016-03-13 23:00:00'),
536(2, 'TEST2', 'AEL', 1, 0, 'REDA', 2, 2, 2, NULL, 2, 'R2', '2016-03-16', '2016-03-13 23:00:00'),
537(3, 'TEST 3', 'AEL', 3, 0, 'REDA', 9, 3, 3, NULL, 3, 'R3', '2016-03-14', '2016-04-18 14:23:58'),
538(4815, 'NOEYYB1', 'SIMM', 981, 0, 'Payen', 1, NULL, 5, NULL, 32, '1', '2016-05-25', '2016-05-23 12:01:00'),
539(4816, 'NOEYYB2', 'SIMM', 981, 0, 'Payen', 1, NULL, 10, NULL, 12, '2', NULL, '2016-05-23 12:01:00'),
540(4817, 'NOEYYBA', 'SIMM', 180, 0, 'Mant', 2, NULL, 1, NULL, 442, '3', NULL, '2016-05-23 12:01:00'),
541(4818, 'NOEYYBB', 'SIMM', 180, 0, 'Mant', 0, NULL, 5, NULL, 1000, '4', NULL, '2016-05-23 12:01:00'),
542(4819, 'NOEYYBC', 'SIMM', 180, 0, 'Mant', 1, NULL, 5, NULL, 23, '5', NULL, '2016-05-23 12:01:00'),
543(4820, 'PCYYY9U', 'AEL', 120, 0, 'Reda', 10, NULL, 1, NULL, 23, '6', NULL, '2016-05-23 12:01:00'),
544(4821, 'PCYYY9V', 'AEL', 120, 0, 'Reda', 10, NULL, 2, NULL, 11, '7', NULL, '2016-05-23 12:01:00'),
545(4822, 'PCYYY9W', 'AEL', 120, 0, 'Reda', 10, NULL, 3, NULL, 32, '8', NULL, '2016-05-23 12:01:00'),
546(4823, 'NOEYYB2', 'SIMM', 981, 0, 'Payen', 1, NULL, 10, NULL, 12, '2', NULL, '2016-05-23 12:01:00'),
547(4824, 'NOEYYBA', 'SIMM', 180, 0, 'Mant', 2, NULL, 1, NULL, 442, '3', NULL, '2016-05-23 12:01:00'),
548(4825, 'NOEYYBB', 'SIMM', 180, 0, 'Mant', 0, NULL, 5, NULL, 1000, '4', NULL, '2016-05-23 12:01:00'),
549(4826, 'NOEYYBC', 'SIMM', 180, 0, 'Mant', 1, NULL, 5, NULL, 23, '5', NULL, '2016-05-23 12:01:00'),
550(4827, 'PCYYY9U', 'AEL', 120, 0, 'Reda', 10, NULL, 1, NULL, 23, '6', NULL, '2016-05-23 12:01:00'),
551(4828, 'PCYYY9V', 'AEL', 120, 0, 'Reda', 10, NULL, 2, NULL, 11, '7', NULL, '2016-05-23 12:01:00'),
552(4829, 'PCYYY9W', 'AEL', 120, 0, 'Reda', 10, NULL, 3, NULL, 32, '8', NULL, '2016-05-23 12:01:00'),
553(4830, 'NOEYYB2', 'SIMM', 981, 0, 'Payen', 1, NULL, 10, NULL, 12, '2', NULL, '2016-05-23 12:01:00'),
554(4831, 'NOEYYBA', 'SIMM', 180, 0, 'Mant', 2, NULL, 1, NULL, 442, '3', NULL, '2016-05-23 12:01:00'),
555(4832, 'NOEYYBB', 'SIMM', 180, 0, 'Mant', 0, NULL, 5, NULL, 1000, '4', NULL, '2016-05-23 12:01:00'),
556(4833, 'NOEYYB1', 'SIMM', 981, 0, 'Payen', 1, 5, 32, NULL, 1, 'R2', '2016-01-10', '2016-05-23 13:03:03'),
557(4834, 'NOEYYB2', 'SIMM', 981, 0, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-05-23 13:03:03'),
558(4835, 'NOEYYBA', 'SIMM', 180, 0, 'Mant', 2, 1, 442, NULL, 3, 'R2', '2016-01-12', '2016-05-23 13:03:03'),
559(4836, 'NOEYYBB', 'SIMM', 180, 0, 'Mant', 0, 5, 1000, NULL, 4, 'R2', '2016-01-13', '2016-05-23 13:03:03'),
560(4837, 'NOEYYBC', 'SIMM', 180, 0, 'Mant', 1, 5, 23, NULL, 5, 'R2', '2016-01-14', '2016-05-23 13:03:03'),
561(4838, 'PCYYY9U', 'AEL', 120, 0, 'Reda', 10, 1, 23, NULL, 6, 'R2', '2016-01-15', '2016-05-23 13:03:03'),
562(4839, 'PCYYY9V', 'AEL', 120, 0, 'Reda', 10, 2, 11, NULL, 7, 'R2', '2016-01-16', '2016-05-23 13:03:03'),
563(4840, 'PCYYY9W', 'AEL', 120, 0, 'Reda', 10, 3, 32, NULL, 8, 'R2', '2016-01-17', '2016-05-23 13:03:03'),
564(4841, 'NOEYYB2', 'SIMM', 981, 0, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-05-23 13:03:03'),
565(4842, 'NOEYYBA', 'SIMM', 180, 0, 'Mant', 2, 1, 442, NULL, 3, 'R2', '2016-01-12', '2016-05-23 13:03:03'),
566(4843, 'NOEYYBB', 'SIMM', 180, 0, 'Mant', 0, 5, 1000, NULL, 4, 'R2', '2016-01-13', '2016-05-23 13:03:03'),
567(4844, 'NOEYYBC', 'SIMM', 180, 0, 'Mant', 1, 5, 23, NULL, 5, 'R2', '2016-01-14', '2016-05-23 13:03:03'),
568(4845, 'PCYYY9U', 'AEL', 120, 0, 'Reda', 10, 1, 23, NULL, 6, 'R2', '2016-01-15', '2016-05-23 13:03:03'),
569(4846, 'PCYYY9V', 'AEL', 120, 0, 'Reda', 10, 2, 11, NULL, 7, 'R2', '2016-01-16', '2016-05-23 13:03:03'),
570(4847, 'PCYYY9W', 'AEL', 120, 0, 'Reda', 10, 3, 32, NULL, 8, 'R2', '2016-01-17', '2016-05-23 13:03:03'),
571(4848, 'NOEYYB2', 'SIMM', 981, 0, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-05-23 13:03:03'),
572(4849, 'NOEYYBA', 'SIMM', 180, 0, 'Mant', 2, 1, 442, NULL, 3, 'R2', '2016-01-12', '2016-05-23 13:03:03'),
573(4850, 'NOEYYBB', 'SIMM', 180, 0, 'Mant', 0, 5, 1000, NULL, 4, 'R2', '2016-01-13', '2016-05-23 13:03:03'),
574(4851, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 09:51:25'),
575(4852, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 09:51:25'),
576(4854, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:30:44'),
577(4855, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:30:44'),
578(4857, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:39:15'),
579(4858, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:39:15'),
580(4860, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:40:05'),
581(4861, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:40:05'),
582(4863, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:44:00'),
583(4864, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:44:00'),
584(4866, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:45:04'),
585(4867, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:45:04'),
586(4869, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:46:53'),
587(4870, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:46:53'),
588(4872, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:56:26'),
589(4873, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:56:26'),
590(4875, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 11:56:47'),
591(4876, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 11:56:47'),
592(4877, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 13:22:39'),
593(4878, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 13:22:39'),
594(4880, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 13:26:31'),
595(4881, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 13:26:31'),
596(4883, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 13:31:40'),
597(4884, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 13:31:40'),
598(4886, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 13:34:33'),
599(4887, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 13:34:33'),
600(4889, 'SIMM', 'NOEYYB1', 981, NULL, 'Payen', 1, 5, 32, NULL, 1, 'R1', '2016-01-10', '2016-07-21 13:37:10'),
601(4890, 'SIMM', 'NOEYYB2', 981, NULL, 'Payen', 1, 10, 12, NULL, 2, 'R2', '2016-01-11', '2016-07-21 13:37:10');
602
603-- --------------------------------------------------------
604
605--
606-- Table structure for table `table_conversion`
607--
608
609CREATE TABLE `table_conversion` (
610 `id` bigint(20) unsigned NOT NULL,
611 `libelle` varchar(64) NOT NULL,
612 `libelle_abrevation` varchar(20) NOT NULL,
613 `categorie` varchar(64) NOT NULL,
614 `cout_uo` float NOT NULL
615) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8;
616
617--
618-- Dumping data for table `table_conversion`
619--
620
621INSERT INTO `table_conversion` (`id`, `libelle`, `libelle_abrevation`, `categorie`, `cout_uo`) VALUES
622(2, 'Coûts directs', 'cout_direct', 'Cout', 0),
623(3, 'Serveur virtualisé AIX Fixe Std', 'shvaf_standard', 'Hosting virtualisé', 0),
624(4, 'Serveur virtualisé INTEL Fixe Std', 'shvif_standard', 'Hosting virtualisé', 0),
625(5, 'Serveur virtualisé INTEL Variable (Puis)', 'shvi_puissance', 'Hosting virtualisé', 0),
626(6, 'Appli.Host. Pilotage Applicatif Classic', 'oahpac', 'Aplication Hosting', 1),
627(7, 'Appli.Host. Pilotage Applicatif Premium', 'oahpsp', 'Aplication Hosting', 0),
628(8, 'Serveur dédié Small Fixe Std', 'shds', 'Hosting Dédié', 0),
629(9, 'Serveur dédié Intel Variable (Puissance)', 'shdp_intel', 'Hosting Dédié', 0),
630(10, 'Protection de données Bas Débit', 'smbd_go', 'Sauvegarde', 0),
631(11, 'Protection de données Standard', 'sms_go', 'Sauvegarde', 0),
632(12, 'Protection de données Haut Débit', 'smhd_go', 'Sauvegarde', 0),
633(13, 'Protection de données Très Haut Débit', 'smthd_go', 'Sauvegarde', 0),
634(14, 'Opt° protect° données Externalisat° jour. ou hebdo', 'smejh_go', 'Sauvegarde', 0),
635(15, 'Archivage de données', 'archivage', 'Archivage', 0),
636(16, 'Stockage de Données Premium', 'sbm_premium', 'Stockage de données', 1),
637(17, 'Stockage de Données Classic', 'sbm_classic', 'Stockage de données', 100),
638(18, 'Stockage de Données Premium Option Image', 'sbmpo_image', 'Stockage de données', 1),
639(19, 'Stockage de Données Premium Option Performance +', 'sbmpo_performance', 'Stockage de données', 1),
640(20, 'Stockage de Données Basic', 'sbm_basic', 'Stockage de données', 1),
641(21, 'Serveur virtualisé AIX Variable (Puiss)', 'shva_puissance', 'Hosting virtualisé', 0),
642(22, 'Appli.Host. Pilotage Serveur Classic', 'oahpsc', 'Aplication Hosting', 0),
643(23, 'Sauvegarde en Temps Masqué ', 'sbmst_masqué', 'Stockage de données', 1),
644(24, 'Sauvegarde en Temps Masqué Premium', 'sbmst_masqué_premium', 'Stockage de données', 1),
645(47, 'Serveur "Virtuel +" Critical Cloud privé et public INTEL Fixe', 'shvciif_standard', 'Hosting virtualisé', 0),
646(48, 'Serveur "Virtuel+" Critical INTEL Variable (Puis', '', 'Hosting virtualisé', 0),
647(49, 'Serveur "Virtuel +" standart Cloud privé et public INTEL Fixe', 'shvciif_standard', 'Hosting virtualisé', 0),
648(50, 'Serveur "Virtuel +" Cloud privé et public AIX Fixe', 'shvcppaf_standard', 'Hosting virtualisé', 0),
649(51, 'Serveur "Virtuel +" Cloud privé et public AIX Variable', 'shvcppa_puissance', 'Hosting virtualisé', 0),
650(52, 'Serveur "Virtuel +" Cloud interne Fixe', 'svcif', 'Hosting virtualisé', 0),
651(53, 'Serveur "Virtuel +" Cloud interne Variable', 'svciv', 'Hosting virtualisé', 0),
652(54, 'Serveur "Virtuel +" Serveur managé', 'svsm', 'Hosting virtualisé', 0),
653(78, 'Serveur dédié XSmall Fixe Std', 'shdes', 'Hosting Dédié', 0),
654(79, 'Serveur dédié Medium Fixe Std', 'shdm', 'Hosting Dédié', 0),
655(80, 'Serveur dédié Large Fixe Std', 'shdl', 'Hosting Dédié', 0),
656(81, 'Serveur dédié Extra Large Fixe Std', 'shdel', 'Hosting Dédié', 0),
657(82, 'Serveur dédié Majoration Zone Sécurisée', 'shdp_intel', 'Hosting Dédié', 0),
658(83, 'Serveur dédié Autre Variable (Puissance)', 'shdp_autre', 'Hosting Dédié', 0),
659(84, 'Location Courte Durée', 'lcd', 'Location', 0),
660(85, 'I/Q Poste Trav.avec fourn. Plateforme I/Q Mineure', 'iptafpi_mineure', 'Intégration/Qualification', 0),
661(86, 'I/Q Poste Trav.avec fourn. Plateforme I/Q Majeure', 'iptafpi_majeure', 'Intégration/Qualification', 0),
662(87, 'I/Q Poste Trav.sans fourn. Plateforme I/Q Mineure', 'iptsfp_mineure', 'Intégration/Qualification', 0),
663(88, 'I/Q Poste de travail', 'ipt', 'Intégration/Qualification', 0),
664(89, 'I/Q Serveur avec fourn. Plateforme I/Q Mineure', 'isafpi_mineure', 'Intégration/Qualification', 0),
665(90, 'I/Q Serveur avec fourn. Plateforme I/Q Majeure', 'isafpi_majeure', 'Intégration/Qualification', 0),
666(91, 'I/Q Serveur sans fourn. Plateforme I/Q Mineure', 'issfpi_mineure', 'Intégration/Qualification', 0),
667(92, 'Insertion en exploitation - Sécurisation renforcée', 'ieesr', 'Intégration/Qualification', 0),
668(93, 'Insertion en exploitation – Contrôle', 'ieec', 'Intégration/Qualification', 0),
669(94, 'Réservation Surface par m2', 'rspm', 'Physical Hosting', 0),
670(95, 'Raccord Datacenter Standard Hors Dist ', 'rdshd', 'Physical Hosting', 0),
671(96, 'Raccord Datacenter Standard Dist', 'rdsd', 'Physical Hosting', 0),
672(97, 'Raccord Datacenter Sécurisé D1 Hors Dist', 'rdsd1hd', 'Physical Hosting', 0),
673(98, 'Raccord Datacenter Sécurisé D1 Dist', 'rdsd1d', 'Physical Hosting', 0),
674(99, 'Raccord Datacenter Sécurisé D2 Hors Dist', 'rdsd2hd', 'Physical Hosting', 0),
675(100, 'Raccord Datacenter Sécurisé D2 Dist', 'rdsd2d', 'Physical Hosting', 0),
676(101, 'HEBergement de Super calculateur HPC SCientifique', 'hschs', 'Physical Hosting', 0);
677
678-- --------------------------------------------------------
679
680--
681-- Table structure for table `test`
682--
683
684CREATE TABLE `test` (
685 `id` bigint(20) unsigned NOT NULL,
686 `value` int(11) NOT NULL,
687 `mois` date NOT NULL,
688 `groupe` varchar(10) NOT NULL,
689 `string_test` varchar(20) NOT NULL
690) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
691
692--
693-- Dumping data for table `test`
694--
695
696INSERT INTO `test` (`id`, `value`, `mois`, `groupe`, `string_test`) VALUES
697(1, 1, '0000-01-01', 'A', 'aze'),
698(2, 2, '0000-02-00', 'A', 'eza'),
699(3, 3, '0000-03-00', 'B', 'ert'),
700(4, 4, '0000-04-00', 'B', 'ert'),
701(5, 5, '0000-05-01', 'B', 'qsd'),
702(6, 6, '0000-01-01', 'A', 'qsd'),
703(7, 6, '0000-01-01', 'A', 'qsd'),
704(8, 3, '0000-00-00', '', ''),
705(9, 3, '0000-00-00', '', ''),
706(10, 8, '0000-00-00', '', '');
707
708-- --------------------------------------------------------
709
710--
711-- Table structure for table `test_table`
712--
713
714CREATE TABLE `test_table` (
715 `col1` varchar(20) NOT NULL,
716 `col2` varchar(20) NOT NULL,
717 `col3` varchar(20) NOT NULL,
718 `col4` varchar(11) NOT NULL
719) ENGINE=InnoDB DEFAULT CHARSET=latin1;
720
721--
722-- Dumping data for table `test_table`
723--
724
725INSERT INTO `test_table` (`col1`, `col2`, `col3`, `col4`) VALUES
726('1 1', '1 2', '1 3', '1 4'),
727('2 1', '2 2', '2 3', '2 4'),
728('1 1', '1 2', '1 3', '1 4'),
729('2 1', '2 2', '2 3', '2 4');
730
731-- --------------------------------------------------------
732
733--
734-- Table structure for table `top_odi_wicket_takers`
735--
736
737CREATE TABLE `top_odi_wicket_takers` (
738 `player` varchar(255) NOT NULL DEFAULT '',
739 `wickets` int(11) DEFAULT NULL
740) ENGINE=InnoDB DEFAULT CHARSET=latin1;
741
742--
743-- Dumping data for table `top_odi_wicket_takers`
744--
745
746INSERT INTO `top_odi_wicket_takers` (`player`, `wickets`) VALUES
747('CJ Anderson', 25),
748('Imran Tahir', 25),
749('JH Davey', 21),
750('M Morkel', 21),
751('MA Starc', 34),
752('ST Finn', 27),
753('TA Boult', 36),
754('TG Southee', 28),
755('UT Yadav', 22),
756('Wahab Riaz', 25);
757
758-- --------------------------------------------------------
759
760--
761-- Table structure for table `type_fichier`
762--
763
764CREATE TABLE `type_fichier` (
765 `id` bigint(20) unsigned NOT NULL,
766 `name` varchar(20) NOT NULL
767) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
768
769--
770-- Dumping data for table `type_fichier`
771--
772
773INSERT INTO `type_fichier` (`id`, `name`) VALUES
774(1, 'Fisher'),
775(2, 'Moulibex');
776
777-- --------------------------------------------------------
778
779--
780-- Table structure for table `uploaded_file`
781--
782
783CREATE TABLE `uploaded_file` (
784 `id` bigint(20) unsigned NOT NULL,
785 `fichier` varchar(100) NOT NULL,
786 `mois_c` varchar(20) NOT NULL,
787 `date_import` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
788 `commentaire` text NOT NULL
789) ENGINE=InnoDB DEFAULT CHARSET=latin1;
790
791-- --------------------------------------------------------
792
793--
794-- Table structure for table `uploaded_file1`
795--
796
797CREATE TABLE `uploaded_file1` (
798 `id` bigint(20) unsigned NOT NULL,
799 `fichier` varchar(100) NOT NULL,
800 `application` varchar(50) NOT NULL,
801 `previsionnel` varchar(50) NOT NULL,
802 `date_import` date NOT NULL,
803 `commentaire` text NOT NULL
804) ENGINE=InnoDB DEFAULT CHARSET=latin1;
805
806-- --------------------------------------------------------
807
808--
809-- Table structure for table `users`
810--
811
812CREATE TABLE `users` (
813 `id` int(11) unsigned NOT NULL,
814 `ip_address` varchar(15) NOT NULL,
815 `username` varchar(100) DEFAULT NULL,
816 `password` varchar(255) NOT NULL,
817 `salt` varchar(255) DEFAULT NULL,
818 `email` varchar(100) NOT NULL,
819 `activation_code` varchar(40) DEFAULT NULL,
820 `forgotten_password_code` varchar(40) DEFAULT NULL,
821 `forgotten_password_time` int(11) unsigned DEFAULT NULL,
822 `remember_code` varchar(40) DEFAULT NULL,
823 `created_on` int(11) unsigned NOT NULL,
824 `last_login` int(11) unsigned DEFAULT NULL,
825 `active` tinyint(1) unsigned DEFAULT NULL,
826 `first_name` varchar(50) DEFAULT NULL,
827 `last_name` varchar(50) DEFAULT NULL,
828 `company` varchar(100) DEFAULT NULL,
829 `phone` varchar(20) DEFAULT NULL
830) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
831
832--
833-- Dumping data for table `users`
834--
835
836INSERT INTO `users` (`id`, `ip_address`, `username`, `password`, `salt`, `email`, `activation_code`, `forgotten_password_code`, `forgotten_password_time`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`) VALUES
837(1, '127.0.0.1', 'member', '$2y$08$kkqUE2hrqAJtg.pPnAhvL.1iE7LIujK5LZ61arONLpaBBWh/ek61G', NULL, 'member@member.com', NULL, NULL, NULL, NULL, 1451903855, 1451905011, 1, 'Member', 'One', NULL, NULL),
838(2, '::1', NULL, '$2y$08$wukx4fmRjX5fql8JEsCkceIw.zHhH6/7o932Sj6HIxe6jG0Rf13pO', NULL, 'tanawa_m@epita.fr', NULL, NULL, NULL, NULL, 1462180943, 1462180986, 1, 'Tanawa Tsamo', 'Marius', NULL, NULL);
839
840-- --------------------------------------------------------
841
842--
843-- Table structure for table `users_groups`
844--
845
846CREATE TABLE `users_groups` (
847 `id` int(11) unsigned NOT NULL,
848 `user_id` int(11) unsigned NOT NULL,
849 `group_id` mediumint(8) unsigned NOT NULL
850) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
851
852--
853-- Dumping data for table `users_groups`
854--
855
856INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
857(1, 1, 1),
858(2, 2, 1);
859
860-- --------------------------------------------------------
861
862--
863-- Stand-in structure for view `v`
864--
865CREATE TABLE `v` (
866`id` bigint(20) unsigned
867,`value` int(11)
868,`mois` date
869,`groupe` varchar(10)
870,`string_test` varchar(20)
871);
872
873-- --------------------------------------------------------
874
875--
876-- Structure for view `v`
877--
878DROP TABLE IF EXISTS `v`;
879
880CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select `test`.`id` AS `id`,`test`.`value` AS `value`,`test`.`mois` AS `mois`,`test`.`groupe` AS `groupe`,`test`.`string_test` AS `string_test` from `test` where (`test`.`string_test` = 'qsd');
881
882--
883-- Indexes for dumped tables
884--
885
886--
887-- Indexes for table `admin_groups`
888--
889ALTER TABLE `admin_groups`
890 ADD PRIMARY KEY (`id`);
891
892--
893-- Indexes for table `admin_login_attempts`
894--
895ALTER TABLE `admin_login_attempts`
896 ADD PRIMARY KEY (`id`);
897
898--
899-- Indexes for table `admin_users`
900--
901ALTER TABLE `admin_users`
902 ADD PRIMARY KEY (`id`);
903
904--
905-- Indexes for table `admin_users_groups`
906--
907ALTER TABLE `admin_users_groups`
908 ADD PRIMARY KEY (`id`);
909
910--
911-- Indexes for table `api_access`
912--
913ALTER TABLE `api_access`
914 ADD PRIMARY KEY (`id`);
915
916--
917-- Indexes for table `api_keys`
918--
919ALTER TABLE `api_keys`
920 ADD PRIMARY KEY (`id`);
921
922--
923-- Indexes for table `api_limits`
924--
925ALTER TABLE `api_limits`
926 ADD PRIMARY KEY (`id`);
927
928--
929-- Indexes for table `api_logs`
930--
931ALTER TABLE `api_logs`
932 ADD PRIMARY KEY (`id`);
933
934--
935-- Indexes for table `demo_blog_categories`
936--
937ALTER TABLE `demo_blog_categories`
938 ADD PRIMARY KEY (`id`);
939
940--
941-- Indexes for table `demo_blog_posts`
942--
943ALTER TABLE `demo_blog_posts`
944 ADD PRIMARY KEY (`id`);
945
946--
947-- Indexes for table `demo_blog_posts_tags`
948--
949ALTER TABLE `demo_blog_posts_tags`
950 ADD PRIMARY KEY (`id`);
951
952--
953-- Indexes for table `demo_blog_tags`
954--
955ALTER TABLE `demo_blog_tags`
956 ADD PRIMARY KEY (`id`);
957
958--
959-- Indexes for table `demo_cover_photos`
960--
961ALTER TABLE `demo_cover_photos`
962 ADD PRIMARY KEY (`id`);
963
964--
965-- Indexes for table `groups`
966--
967ALTER TABLE `groups`
968 ADD PRIMARY KEY (`id`);
969
970--
971-- Indexes for table `login_attempts`
972--
973ALTER TABLE `login_attempts`
974 ADD PRIMARY KEY (`id`);
975
976--
977-- Indexes for table `moulibex`
978--
979ALTER TABLE `moulibex`
980 ADD PRIMARY KEY (`id`),
981 ADD UNIQUE KEY `id` (`id`);
982
983--
984-- Indexes for table `suivi_convert`
985--
986ALTER TABLE `suivi_convert`
987 ADD PRIMARY KEY (`id`),
988 ADD UNIQUE KEY `id` (`id`);
989
990--
991-- Indexes for table `suivi_stockage`
992--
993ALTER TABLE `suivi_stockage`
994 ADD PRIMARY KEY (`id`),
995 ADD UNIQUE KEY `id` (`id`);
996
997--
998-- Indexes for table `suivi_stockage_type_fichier`
999--
1000ALTER TABLE `suivi_stockage_type_fichier`
1001 ADD PRIMARY KEY (`id`),
1002 ADD UNIQUE KEY `id` (`id`);
1003
1004--
1005-- Indexes for table `table2`
1006--
1007ALTER TABLE `table2`
1008 ADD PRIMARY KEY (`id`),
1009 ADD KEY `mc` (`mc`);
1010
1011--
1012-- Indexes for table `table_conversion`
1013--
1014ALTER TABLE `table_conversion`
1015 ADD PRIMARY KEY (`id`),
1016 ADD UNIQUE KEY `id` (`id`),
1017 ADD UNIQUE KEY `libelle` (`libelle`);
1018
1019--
1020-- Indexes for table `test`
1021--
1022ALTER TABLE `test`
1023 ADD PRIMARY KEY (`id`),
1024 ADD UNIQUE KEY `id` (`id`);
1025
1026--
1027-- Indexes for table `top_odi_wicket_takers`
1028--
1029ALTER TABLE `top_odi_wicket_takers`
1030 ADD PRIMARY KEY (`player`);
1031
1032--
1033-- Indexes for table `type_fichier`
1034--
1035ALTER TABLE `type_fichier`
1036 ADD PRIMARY KEY (`id`),
1037 ADD UNIQUE KEY `id` (`id`);
1038
1039--
1040-- Indexes for table `uploaded_file`
1041--
1042ALTER TABLE `uploaded_file`
1043 ADD PRIMARY KEY (`id`),
1044 ADD UNIQUE KEY `id` (`id`);
1045
1046--
1047-- Indexes for table `uploaded_file1`
1048--
1049ALTER TABLE `uploaded_file1`
1050 ADD PRIMARY KEY (`id`),
1051 ADD UNIQUE KEY `id` (`id`);
1052
1053--
1054-- Indexes for table `users`
1055--
1056ALTER TABLE `users`
1057 ADD PRIMARY KEY (`id`);
1058
1059--
1060-- Indexes for table `users_groups`
1061--
1062ALTER TABLE `users_groups`
1063 ADD PRIMARY KEY (`id`);
1064
1065--
1066-- AUTO_INCREMENT for dumped tables
1067--
1068
1069--
1070-- AUTO_INCREMENT for table `admin_groups`
1071--
1072ALTER TABLE `admin_groups`
1073 MODIFY `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
1074--
1075-- AUTO_INCREMENT for table `admin_login_attempts`
1076--
1077ALTER TABLE `admin_login_attempts`
1078 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
1079--
1080-- AUTO_INCREMENT for table `admin_users`
1081--
1082ALTER TABLE `admin_users`
1083 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
1084--
1085-- AUTO_INCREMENT for table `admin_users_groups`
1086--
1087ALTER TABLE `admin_users_groups`
1088 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
1089--
1090-- AUTO_INCREMENT for table `api_access`
1091--
1092ALTER TABLE `api_access`
1093 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
1094--
1095-- AUTO_INCREMENT for table `api_keys`
1096--
1097ALTER TABLE `api_keys`
1098 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1099--
1100-- AUTO_INCREMENT for table `api_limits`
1101--
1102ALTER TABLE `api_limits`
1103 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1104--
1105-- AUTO_INCREMENT for table `api_logs`
1106--
1107ALTER TABLE `api_logs`
1108 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1109--
1110-- AUTO_INCREMENT for table `demo_blog_categories`
1111--
1112ALTER TABLE `demo_blog_categories`
1113 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
1114--
1115-- AUTO_INCREMENT for table `demo_blog_posts`
1116--
1117ALTER TABLE `demo_blog_posts`
1118 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
1119--
1120-- AUTO_INCREMENT for table `demo_blog_posts_tags`
1121--
1122ALTER TABLE `demo_blog_posts_tags`
1123 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
1124--
1125-- AUTO_INCREMENT for table `demo_blog_tags`
1126--
1127ALTER TABLE `demo_blog_tags`
1128 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
1129--
1130-- AUTO_INCREMENT for table `demo_cover_photos`
1131--
1132ALTER TABLE `demo_cover_photos`
1133 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
1134--
1135-- AUTO_INCREMENT for table `groups`
1136--
1137ALTER TABLE `groups`
1138 MODIFY `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
1139--
1140-- AUTO_INCREMENT for table `login_attempts`
1141--
1142ALTER TABLE `login_attempts`
1143 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
1144--
1145-- AUTO_INCREMENT for table `moulibex`
1146--
1147ALTER TABLE `moulibex`
1148 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
1149--
1150-- AUTO_INCREMENT for table `suivi_convert`
1151--
1152ALTER TABLE `suivi_convert`
1153 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
1154--
1155-- AUTO_INCREMENT for table `suivi_stockage`
1156--
1157ALTER TABLE `suivi_stockage`
1158 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
1159--
1160-- AUTO_INCREMENT for table `suivi_stockage_type_fichier`
1161--
1162ALTER TABLE `suivi_stockage_type_fichier`
1163 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
1164--
1165-- AUTO_INCREMENT for table `table2`
1166--
1167ALTER TABLE `table2`
1168 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4891;
1169--
1170-- AUTO_INCREMENT for table `table_conversion`
1171--
1172ALTER TABLE `table_conversion`
1173 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=102;
1174--
1175-- AUTO_INCREMENT for table `test`
1176--
1177ALTER TABLE `test`
1178 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
1179--
1180-- AUTO_INCREMENT for table `type_fichier`
1181--
1182ALTER TABLE `type_fichier`
1183 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
1184--
1185-- AUTO_INCREMENT for table `uploaded_file`
1186--
1187ALTER TABLE `uploaded_file`
1188 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
1189--
1190-- AUTO_INCREMENT for table `uploaded_file1`
1191--
1192ALTER TABLE `uploaded_file1`
1193 MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT;
1194--
1195-- AUTO_INCREMENT for table `users`
1196--
1197ALTER TABLE `users`
1198 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
1199--
1200-- AUTO_INCREMENT for table `users_groups`
1201--
1202ALTER TABLE `users_groups`
1203 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;