· 7 years ago · Nov 25, 2018, 11:16 PM
1-- MySQL dump 10.13 Distrib 5.7.17, for Win64 (x86_64)
2--
3-- Host: localhost Database: openpms5
4-- ------------------------------------------------------
5-- Server version 5.7.20-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `comments`
20--
21
22DROP TABLE IF EXISTS `comments`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `comments` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `comment_content` varchar(255) NOT NULL,
28 `created_date` datetime NOT NULL,
29 `last_modified_date` datetime NOT NULL,
30 `created_by_id` int(11) NOT NULL,
31 `last_modified_by_id` int(11) NOT NULL,
32 `task_id` int(11) DEFAULT NULL,
33 PRIMARY KEY (`id`),
34 KEY `FK_comment_users_created_by` (`created_by_id`),
35 KEY `FK_comment_users_last_modified_by` (`last_modified_by_id`),
36 KEY `FKi7pp0331nbiwd2844kg78kfwb` (`task_id`),
37 CONSTRAINT `FK_comment_users_created_by` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`),
38 CONSTRAINT `FK_comment_users_last_modified_by` FOREIGN KEY (`last_modified_by_id`) REFERENCES `users` (`id`),
39 CONSTRAINT `FKi7pp0331nbiwd2844kg78kfwb` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `comments`
45--
46
47LOCK TABLES `comments` WRITE;
48/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
49/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `permissions`
54--
55
56DROP TABLE IF EXISTS `permissions`;
57/*!40101 SET @saved_cs_client = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `permissions` (
60 `id` bigint(20) NOT NULL AUTO_INCREMENT,
61 `created_date` datetime NOT NULL,
62 `last_modified_date` datetime NOT NULL,
63 `name` varchar(255) NOT NULL,
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `permissions`
70--
71
72LOCK TABLES `permissions` WRITE;
73/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
74INSERT INTO `permissions` VALUES (1,'2018-02-28 00:00:00','2018-02-28 00:00:00','task.create'),(2,'2018-02-28 00:00:00','2018-02-28 00:00:00','task.update'),(3,'2018-02-28 00:00:00','2018-02-28 00:00:00','task.delete'),(4,'2018-02-28 00:00:00','2018-02-28 00:00:00','task.read'),(5,'2018-02-28 00:00:00','2018-02-28 00:00:00','program.create'),(6,'2018-02-28 00:00:00','2018-02-28 00:00:00','project.create'),(7,'2018-02-28 00:00:00','2018-02-28 00:00:00','project.update'),(8,'2018-02-28 00:00:00','2018-02-28 00:00:00','project.delete'),(9,'2018-02-28 00:00:00','2018-02-28 00:00:00','project.read');
75/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `prj_user_notification`
80--
81
82DROP TABLE IF EXISTS `prj_user_notification`;
83/*!40101 SET @saved_cs_client = @@character_set_client */;
84/*!40101 SET character_set_client = utf8 */;
85CREATE TABLE `prj_user_notification` (
86 `id` int(11) NOT NULL,
87 `email` varchar(255) DEFAULT NULL,
88 `name` varchar(255) DEFAULT NULL,
89 `expected_start_date` datetime DEFAULT NULL,
90 PRIMARY KEY (`id`)
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92/*!40101 SET character_set_client = @saved_cs_client */;
93
94--
95-- Dumping data for table `prj_user_notification`
96--
97
98LOCK TABLES `prj_user_notification` WRITE;
99/*!40000 ALTER TABLE `prj_user_notification` DISABLE KEYS */;
100/*!40000 ALTER TABLE `prj_user_notification` ENABLE KEYS */;
101UNLOCK TABLES;
102
103--
104-- Table structure for table `programs`
105--
106
107DROP TABLE IF EXISTS `programs`;
108/*!40101 SET @saved_cs_client = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `programs` (
111 `id` int(11) NOT NULL AUTO_INCREMENT,
112 `created_date` datetime NOT NULL,
113 `description` text NOT NULL,
114 `last_modified_date` datetime NOT NULL,
115 `name` varchar(255) NOT NULL,
116 `short_name` varchar(5) NOT NULL,
117 `assigned_user_id` int(11) DEFAULT NULL,
118 PRIMARY KEY (`id`),
119 KEY `FK_programs_users` (`assigned_user_id`),
120 CONSTRAINT `FK_programs_users` FOREIGN KEY (`assigned_user_id`) REFERENCES `users` (`id`)
121) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
122/*!40101 SET character_set_client = @saved_cs_client */;
123
124--
125-- Dumping data for table `programs`
126--
127
128LOCK TABLES `programs` WRITE;
129/*!40000 ALTER TABLE `programs` DISABLE KEYS */;
130INSERT INTO `programs` VALUES (1,'2018-05-23 16:40:44','description for first program','2018-05-23 16:40:44','first program','FP1',22);
131/*!40000 ALTER TABLE `programs` ENABLE KEYS */;
132UNLOCK TABLES;
133
134--
135-- Table structure for table `project_file`
136--
137
138DROP TABLE IF EXISTS `project_file`;
139/*!40101 SET @saved_cs_client = @@character_set_client */;
140/*!40101 SET character_set_client = utf8 */;
141CREATE TABLE `project_file` (
142 `id` int(11) NOT NULL AUTO_INCREMENT,
143 `created_date` datetime NOT NULL,
144 `last_modified_date` datetime NOT NULL,
145 `name` varchar(255) NOT NULL,
146 `type` varchar(255) NOT NULL,
147 `created_by_id` int(11) NOT NULL,
148 `last_modified_by_id` int(11) NOT NULL,
149 `project_id` int(11) NOT NULL,
150 PRIMARY KEY (`id`),
151 KEY `FK_project_file_users_created_by` (`created_by_id`),
152 KEY `FK_project_file_users_last_modified_by` (`last_modified_by_id`),
153 KEY `FK_project_file_projects` (`project_id`),
154 CONSTRAINT `FK_project_file_projects` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
155 CONSTRAINT `FK_project_file_users_created_by` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`),
156 CONSTRAINT `FK_project_file_users_last_modified_by` FOREIGN KEY (`last_modified_by_id`) REFERENCES `users` (`id`)
157) ENGINE=InnoDB DEFAULT CHARSET=utf8;
158/*!40101 SET character_set_client = @saved_cs_client */;
159
160--
161-- Dumping data for table `project_file`
162--
163
164LOCK TABLES `project_file` WRITE;
165/*!40000 ALTER TABLE `project_file` DISABLE KEYS */;
166/*!40000 ALTER TABLE `project_file` ENABLE KEYS */;
167UNLOCK TABLES;
168
169--
170-- Table structure for table `project_priority`
171--
172
173DROP TABLE IF EXISTS `project_priority`;
174/*!40101 SET @saved_cs_client = @@character_set_client */;
175/*!40101 SET character_set_client = utf8 */;
176CREATE TABLE `project_priority` (
177 `id` int(11) NOT NULL AUTO_INCREMENT,
178 `active` tinyint(1) DEFAULT NULL,
179 `created_date` datetime NOT NULL,
180 `label` varchar(50) NOT NULL,
181 `last_modified_date` datetime NOT NULL,
182 `priority` varchar(50) NOT NULL,
183 `sort_order` int(11) DEFAULT NULL,
184 PRIMARY KEY (`id`)
185) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
186/*!40101 SET character_set_client = @saved_cs_client */;
187
188--
189-- Dumping data for table `project_priority`
190--
191
192LOCK TABLES `project_priority` WRITE;
193/*!40000 ALTER TABLE `project_priority` DISABLE KEYS */;
194INSERT INTO `project_priority` VALUES (1,1,'2018-02-22 00:00:00','Haute','2018-02-22 00:00:00','High',1),(2,1,'2018-02-22 00:00:00','Basse','2018-02-22 00:00:00','Low',3),(3,1,'2018-02-22 00:00:00','Normale','2018-02-22 00:00:00','Normal',2);
195/*!40000 ALTER TABLE `project_priority` ENABLE KEYS */;
196UNLOCK TABLES;
197
198--
199-- Table structure for table `project_status`
200--
201
202DROP TABLE IF EXISTS `project_status`;
203/*!40101 SET @saved_cs_client = @@character_set_client */;
204/*!40101 SET character_set_client = utf8 */;
205CREATE TABLE `project_status` (
206 `id` int(11) NOT NULL AUTO_INCREMENT,
207 `active` tinyint(1) DEFAULT NULL,
208 `created_date` datetime NOT NULL,
209 `label` varchar(50) NOT NULL,
210 `last_modified_date` datetime NOT NULL,
211 `sort_order` int(11) DEFAULT NULL,
212 `status` varchar(50) NOT NULL,
213 `color` varchar(10) DEFAULT NULL,
214 PRIMARY KEY (`id`)
215) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
216/*!40101 SET character_set_client = @saved_cs_client */;
217
218--
219-- Dumping data for table `project_status`
220--
221
222LOCK TABLES `project_status` WRITE;
223/*!40000 ALTER TABLE `project_status` DISABLE KEYS */;
224INSERT INTO `project_status` VALUES (1,1,'2018-02-22 00:00:00','Créé','2018-02-22 00:00:00',1,'Open','#6d6875'),(2,1,'2018-02-22 00:00:00','En cours','2018-02-22 00:00:00',2,'En Progress','#028090'),(3,1,'2018-02-22 00:00:00','Résolu','2018-02-22 00:00:00',3,'Resolved','#e9c46a'),(4,1,'2018-02-22 00:00:00','Fermé','2018-02-22 00:00:00',4,'Closed','#ff1654');
225/*!40000 ALTER TABLE `project_status` ENABLE KEYS */;
226UNLOCK TABLES;
227
228--
229-- Table structure for table `projects`
230--
231
232DROP TABLE IF EXISTS `projects`;
233/*!40101 SET @saved_cs_client = @@character_set_client */;
234/*!40101 SET character_set_client = utf8 */;
235CREATE TABLE `projects` (
236 `id` int(11) NOT NULL AUTO_INCREMENT,
237 `actual_end_date` date DEFAULT NULL,
238 `actual_start_date` date DEFAULT NULL,
239 `created_date` datetime NOT NULL,
240 `description` text NOT NULL,
241 `expected_end_date` date NOT NULL,
242 `expected_start_date` date NOT NULL,
243 `last_modified_date` datetime NOT NULL,
244 `name` varchar(255) NOT NULL,
245 `short_name` varchar(5) NOT NULL,
246 `assigned_user_id` int(11) NOT NULL,
247 `program_id` int(11) NOT NULL,
248 `project_priority_id` int(11) NOT NULL,
249 `project_status_id` int(11) NOT NULL,
250 `created_by_id` int(11) NOT NULL,
251 `last_modified_by_id` int(11) NOT NULL,
252 `budget` float DEFAULT NULL,
253 `proposed` bit(1) NOT NULL,
254 PRIMARY KEY (`id`),
255 KEY `FK_projects_users` (`assigned_user_id`),
256 KEY `FK_projects_programs` (`program_id`),
257 KEY `FK_projects_project_priority` (`project_priority_id`),
258 KEY `FK_projects_project_status` (`project_status_id`),
259 KEY `FK_projects_users_last_modified_by` (`last_modified_by_id`),
260 KEY `FK_projects_users_created_by` (`created_by_id`),
261 CONSTRAINT `FK_projects_programs` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`),
262 CONSTRAINT `FK_projects_project_priority` FOREIGN KEY (`project_priority_id`) REFERENCES `project_priority` (`id`),
263 CONSTRAINT `FK_projects_project_status` FOREIGN KEY (`project_status_id`) REFERENCES `project_status` (`id`),
264 CONSTRAINT `FK_projects_users` FOREIGN KEY (`assigned_user_id`) REFERENCES `users` (`id`),
265 CONSTRAINT `FK_projects_users_created_by` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`),
266 CONSTRAINT `FK_projects_users_last_modified_by` FOREIGN KEY (`last_modified_by_id`) REFERENCES `users` (`id`)
267) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
268/*!40101 SET character_set_client = @saved_cs_client */;
269
270--
271-- Dumping data for table `projects`
272--
273
274LOCK TABLES `projects` WRITE;
275/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
276INSERT INTO `projects` VALUES (1,NULL,NULL,'2018-05-23 16:42:14','description project 1','2018-05-24','2017-11-01','2018-05-24 15:21:01','projet num 1','p1_p1',21,1,2,1,25,25,NULL,'\0'),(2,'2018-05-25','2018-05-25','2018-05-25 01:58:46','description test ','2018-06-01','2018-05-11','2018-05-25 02:05:07','project name 2','ERT',26,1,2,4,25,25,NULL,'\0'),(3,NULL,NULL,'2018-11-25 15:14:21','description test ','2018-11-14','2018-11-08','2018-11-25 15:14:21','hello world test projet proposé','TEFT',19,1,1,2,25,25,3200,'\0'),(4,NULL,NULL,'2018-11-25 15:46:47','description test ','2018-11-28','2018-11-16','2018-11-25 15:46:47','hello world test projet proposé','TEF',19,1,2,1,25,25,2000,'\0'),(5,NULL,NULL,'2018-11-25 17:38:15','description','2018-11-24','2018-11-04','2018-11-25 17:38:15','spring tool set','TST',21,1,2,1,25,25,5000,'\0'),(6,NULL,NULL,'2018-11-25 17:57:22','description abc test iioo','2018-11-24','2018-11-13','2018-11-25 17:57:22','ABC project proposed','ABC',23,1,1,1,25,25,30000,'\0');
277/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
278UNLOCK TABLES;
279
280--
281-- Table structure for table `proposed_project_status`
282--
283
284DROP TABLE IF EXISTS `proposed_project_status`;
285/*!40101 SET @saved_cs_client = @@character_set_client */;
286/*!40101 SET character_set_client = utf8 */;
287CREATE TABLE `proposed_project_status` (
288 `id` int(11) NOT NULL AUTO_INCREMENT,
289 `active` tinyint(1) DEFAULT NULL,
290 `color` varchar(10) DEFAULT NULL,
291 `created_date` datetime NOT NULL,
292 `label` varchar(50) NOT NULL,
293 `last_modified_date` datetime NOT NULL,
294 `sort_order` int(11) DEFAULT NULL,
295 `status` varchar(50) NOT NULL,
296 PRIMARY KEY (`id`)
297) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
298/*!40101 SET character_set_client = @saved_cs_client */;
299
300--
301-- Dumping data for table `proposed_project_status`
302--
303
304LOCK TABLES `proposed_project_status` WRITE;
305/*!40000 ALTER TABLE `proposed_project_status` DISABLE KEYS */;
306INSERT INTO `proposed_project_status` VALUES (1,1,'#6d6875','2018-11-11 00:00:00','Valider','2018-11-11 00:00:00',1,'Validate'),(2,1,'#028090','2018-11-11 00:00:00','Anuuler','2018-11-11 00:00:00',1,'Cancel'),(3,1,'#ff1654','2018-11-13 00:00:00','Reporter','2018-11-13 00:00:00',1,'Postpone'),(4,1,'#ff34D2','2018-11-13 00:00:00','Créé','2018-11-13 00:00:00',1,'Created');
307/*!40000 ALTER TABLE `proposed_project_status` ENABLE KEYS */;
308UNLOCK TABLES;
309
310--
311-- Table structure for table `proposed_projects`
312--
313
314DROP TABLE IF EXISTS `proposed_projects`;
315/*!40101 SET @saved_cs_client = @@character_set_client */;
316/*!40101 SET character_set_client = utf8 */;
317CREATE TABLE `proposed_projects` (
318 `id` int(11) NOT NULL AUTO_INCREMENT,
319 `created_date` datetime NOT NULL,
320 `description` text NOT NULL,
321 `last_modified_date` datetime NOT NULL,
322 `name` varchar(255) NOT NULL,
323 `short_name` varchar(5) NOT NULL,
324 `created_by_id` int(11) NOT NULL,
325 `last_modified_by_id` int(11) NOT NULL,
326 `program_id` int(11) NOT NULL,
327 `proposed_project_status_id` int(11) DEFAULT NULL,
328 PRIMARY KEY (`id`),
329 KEY `FK_proposed_projects_users_created_by` (`created_by_id`),
330 KEY `FK_proposed_projects_users_last_modified_by` (`last_modified_by_id`),
331 KEY `FK_proposed_projects_programs` (`program_id`),
332 KEY `FK_proposed_projects_proposed_project_status` (`proposed_project_status_id`),
333 CONSTRAINT `FK_proposed_projects_programs` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`),
334 CONSTRAINT `FK_proposed_projects_proposed_project_status` FOREIGN KEY (`proposed_project_status_id`) REFERENCES `proposed_project_status` (`id`),
335 CONSTRAINT `FK_proposed_projects_users_created_by` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`),
336 CONSTRAINT `FK_proposed_projects_users_last_modified_by` FOREIGN KEY (`last_modified_by_id`) REFERENCES `users` (`id`)
337) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
338/*!40101 SET character_set_client = @saved_cs_client */;
339
340--
341-- Dumping data for table `proposed_projects`
342--
343
344LOCK TABLES `proposed_projects` WRITE;
345/*!40000 ALTER TABLE `proposed_projects` DISABLE KEYS */;
346INSERT INTO `proposed_projects` VALUES (1,'2018-11-11 00:00:00','this is a propoesed project :) ','2018-11-11 00:00:00','the name of the project','TNOP',22,22,1,1),(2,'2018-11-11 00:00:00','description of project number two','2018-11-11 00:00:00','name of second project','NOSP',22,22,1,1),(3,'2018-11-12 22:51:16','descripton test me plz hello','2018-11-12 22:51:16','test me plz hello world','TEST',25,25,1,2),(4,'2018-11-13 00:05:16','testetstetetetetetststsftfztdftee dhello','2018-11-13 00:05:16','testtesttest','test',25,25,1,3),(5,'2018-11-13 00:06:01','description of project number two edited','2018-11-13 00:06:01','name of second project','NOSP2',25,25,1,1),(6,'2018-11-13 00:06:29','description of project number two','2018-11-13 00:06:29','name of second project updated','NOSP',25,25,1,2),(7,'2018-11-13 00:18:49','testetstetetetetetststsftfztdftee dhello edit','2018-11-13 00:22:52','testtesttest edited','test',25,25,1,3),(8,'2018-11-25 14:25:40','description test ','2018-11-25 14:25:40','hello world test projet proposé','TEFT',25,25,1,4),(9,'2018-11-25 17:37:28','description','2018-11-25 17:37:28','spring tool set','TST',25,25,1,4),(10,'2018-11-25 17:55:27','description abc','2018-11-25 17:55:27','ABC project proposed','ABC',27,27,1,4);
347/*!40000 ALTER TABLE `proposed_projects` ENABLE KEYS */;
348UNLOCK TABLES;
349
350--
351-- Table structure for table `roles`
352--
353
354DROP TABLE IF EXISTS `roles`;
355/*!40101 SET @saved_cs_client = @@character_set_client */;
356/*!40101 SET character_set_client = utf8 */;
357CREATE TABLE `roles` (
358 `id` bigint(20) NOT NULL AUTO_INCREMENT,
359 `created_date` datetime NOT NULL,
360 `last_modified_date` datetime NOT NULL,
361 `name` varchar(255) NOT NULL,
362 PRIMARY KEY (`id`)
363) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
364/*!40101 SET character_set_client = @saved_cs_client */;
365
366--
367-- Dumping data for table `roles`
368--
369
370LOCK TABLES `roles` WRITE;
371/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
372INSERT INTO `roles` VALUES (1,'2018-02-28 00:00:00','2018-02-28 00:00:00','ROLE_MANAGER'),(2,'2018-02-28 00:00:00','2018-02-28 00:00:00','ROLE_USER'),(3,'2018-02-28 00:00:00','2018-02-28 00:00:00','ROLE_RESPONSABLE'),(4,'2018-03-06 00:00:00','2018-03-06 00:00:00','ROLE_ADMIN');
373/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
374UNLOCK TABLES;
375
376--
377-- Table structure for table `roles_permissions`
378--
379
380DROP TABLE IF EXISTS `roles_permissions`;
381/*!40101 SET @saved_cs_client = @@character_set_client */;
382/*!40101 SET character_set_client = utf8 */;
383CREATE TABLE `roles_permissions` (
384 `role_id` bigint(20) NOT NULL,
385 `permission_id` bigint(20) NOT NULL,
386 PRIMARY KEY (`role_id`,`permission_id`),
387 KEY `FK_roles_permissions_permission_id_to_roles` (`permission_id`),
388 KEY `FK_roles_permissions_role_id_to_permissions` (`role_id`),
389 CONSTRAINT `FK_roles_permissions_permission_id_to_roles` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`),
390 CONSTRAINT `FK_roles_permissions_role_id_to_permissions` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
391) ENGINE=InnoDB DEFAULT CHARSET=utf8;
392/*!40101 SET character_set_client = @saved_cs_client */;
393
394--
395-- Dumping data for table `roles_permissions`
396--
397
398LOCK TABLES `roles_permissions` WRITE;
399/*!40000 ALTER TABLE `roles_permissions` DISABLE KEYS */;
400INSERT INTO `roles_permissions` VALUES (1,1),(2,1),(2,2),(2,3),(2,4),(1,5),(1,6),(1,7),(1,8),(1,9);
401/*!40000 ALTER TABLE `roles_permissions` ENABLE KEYS */;
402UNLOCK TABLES;
403
404--
405-- Table structure for table `task_file`
406--
407
408DROP TABLE IF EXISTS `task_file`;
409/*!40101 SET @saved_cs_client = @@character_set_client */;
410/*!40101 SET character_set_client = utf8 */;
411CREATE TABLE `task_file` (
412 `id` int(11) NOT NULL AUTO_INCREMENT,
413 `created_date` datetime NOT NULL,
414 `last_modified_date` datetime NOT NULL,
415 `name` varchar(255) NOT NULL,
416 `type` varchar(255) NOT NULL,
417 `created_by_id` int(11) NOT NULL,
418 `last_modified_by_id` int(11) NOT NULL,
419 `task_id` int(11) NOT NULL,
420 PRIMARY KEY (`id`),
421 KEY `FK_task_file_users_created_by` (`created_by_id`),
422 KEY `FK_task_file_users_last_modified_by` (`last_modified_by_id`),
423 KEY `FK_task_file_tasks` (`task_id`),
424 CONSTRAINT `FK_task_file_tasks` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`),
425 CONSTRAINT `FK_task_file_users_created_by` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`),
426 CONSTRAINT `FK_task_file_users_last_modified_by` FOREIGN KEY (`last_modified_by_id`) REFERENCES `users` (`id`)
427) ENGINE=InnoDB DEFAULT CHARSET=utf8;
428/*!40101 SET character_set_client = @saved_cs_client */;
429
430--
431-- Dumping data for table `task_file`
432--
433
434LOCK TABLES `task_file` WRITE;
435/*!40000 ALTER TABLE `task_file` DISABLE KEYS */;
436/*!40000 ALTER TABLE `task_file` ENABLE KEYS */;
437UNLOCK TABLES;
438
439--
440-- Table structure for table `task_priority`
441--
442
443DROP TABLE IF EXISTS `task_priority`;
444/*!40101 SET @saved_cs_client = @@character_set_client */;
445/*!40101 SET character_set_client = utf8 */;
446CREATE TABLE `task_priority` (
447 `id` int(11) NOT NULL AUTO_INCREMENT,
448 `active` tinyint(1) DEFAULT NULL,
449 `created_date` datetime NOT NULL,
450 `label` varchar(50) NOT NULL,
451 `last_modified_date` datetime NOT NULL,
452 `priority` varchar(50) NOT NULL,
453 `sort_order` int(11) DEFAULT NULL,
454 PRIMARY KEY (`id`)
455) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
456/*!40101 SET character_set_client = @saved_cs_client */;
457
458--
459-- Dumping data for table `task_priority`
460--
461
462LOCK TABLES `task_priority` WRITE;
463/*!40000 ALTER TABLE `task_priority` DISABLE KEYS */;
464INSERT INTO `task_priority` VALUES (1,1,'2018-02-22 00:00:00','Haute','2018-02-22 00:00:00','High',1),(2,1,'2018-02-22 00:00:00','Basse','2018-02-22 00:00:00','Low',3),(3,1,'2018-02-22 00:00:00','Normale','2018-02-22 00:00:00','Normal',2);
465/*!40000 ALTER TABLE `task_priority` ENABLE KEYS */;
466UNLOCK TABLES;
467
468--
469-- Table structure for table `task_status`
470--
471
472DROP TABLE IF EXISTS `task_status`;
473/*!40101 SET @saved_cs_client = @@character_set_client */;
474/*!40101 SET character_set_client = utf8 */;
475CREATE TABLE `task_status` (
476 `id` int(11) NOT NULL AUTO_INCREMENT,
477 `active` tinyint(1) DEFAULT NULL,
478 `created_date` datetime NOT NULL,
479 `label` varchar(50) NOT NULL,
480 `last_modified_date` datetime NOT NULL,
481 `sort_order` int(11) DEFAULT NULL,
482 `status` varchar(50) NOT NULL,
483 `color` varchar(10) DEFAULT NULL,
484 PRIMARY KEY (`id`)
485) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
486/*!40101 SET character_set_client = @saved_cs_client */;
487
488--
489-- Dumping data for table `task_status`
490--
491
492LOCK TABLES `task_status` WRITE;
493/*!40000 ALTER TABLE `task_status` DISABLE KEYS */;
494INSERT INTO `task_status` VALUES (1,1,'2018-02-22 00:00:00','Créé','2018-02-22 00:00:00',1,'Open','#6d6875'),(2,1,'2018-02-22 00:00:00','En cours','2018-02-22 00:00:00',2,'En Progress','#028090'),(3,1,'2018-02-22 00:00:00','Résolu','2018-02-22 00:00:00',3,'Resolved','#e9c46a'),(4,1,'2018-02-22 00:00:00','Fermé','2018-02-22 00:00:00',4,'Closed','#ff1654');
495/*!40000 ALTER TABLE `task_status` ENABLE KEYS */;
496UNLOCK TABLES;
497
498--
499-- Table structure for table `tasks`
500--
501
502DROP TABLE IF EXISTS `tasks`;
503/*!40101 SET @saved_cs_client = @@character_set_client */;
504/*!40101 SET character_set_client = utf8 */;
505CREATE TABLE `tasks` (
506 `id` int(11) NOT NULL AUTO_INCREMENT,
507 `actual_end_date` date DEFAULT NULL,
508 `actual_start_date` date DEFAULT NULL,
509 `created_date` datetime NOT NULL,
510 `description` text NOT NULL,
511 `expected_end_date` date NOT NULL,
512 `expected_start_date` date NOT NULL,
513 `last_modified_date` datetime NOT NULL,
514 `name` varchar(255) NOT NULL,
515 `assigned_user_id` int(11) NOT NULL,
516 `project_id` int(11) NOT NULL,
517 `task_parent_id` int(11) DEFAULT NULL,
518 `task_priority_id` int(11) NOT NULL,
519 `task_status_id` int(11) NOT NULL,
520 `created_by_id` int(11) NOT NULL,
521 `last_modified_by_id` int(11) NOT NULL,
522 PRIMARY KEY (`id`),
523 KEY `FK_tasks_users` (`assigned_user_id`),
524 KEY `FK_tasks_projects` (`project_id`),
525 KEY `FK_tasks_tasks` (`task_parent_id`),
526 KEY `FK_tasks_task_priority` (`task_priority_id`),
527 KEY `FK_tasks_task_status` (`task_status_id`),
528 KEY `FK_tasks_users_created_by` (`created_by_id`),
529 KEY `FK_tasks_users_last_modified_by` (`last_modified_by_id`),
530 CONSTRAINT `FK_tasks_projects` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`),
531 CONSTRAINT `FK_tasks_task_priority` FOREIGN KEY (`task_priority_id`) REFERENCES `task_priority` (`id`),
532 CONSTRAINT `FK_tasks_task_status` FOREIGN KEY (`task_status_id`) REFERENCES `task_status` (`id`),
533 CONSTRAINT `FK_tasks_tasks` FOREIGN KEY (`task_parent_id`) REFERENCES `tasks` (`id`),
534 CONSTRAINT `FK_tasks_users` FOREIGN KEY (`assigned_user_id`) REFERENCES `users` (`id`),
535 CONSTRAINT `FK_tasks_users_created_by` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`),
536 CONSTRAINT `FK_tasks_users_last_modified_by` FOREIGN KEY (`last_modified_by_id`) REFERENCES `users` (`id`)
537) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
538/*!40101 SET character_set_client = @saved_cs_client */;
539
540--
541-- Dumping data for table `tasks`
542--
543
544LOCK TABLES `tasks` WRITE;
545/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
546INSERT INTO `tasks` VALUES (1,'2018-05-25','2018-05-25','2018-05-25 01:59:54','decsriotion ded','2018-06-09','2018-05-11','2018-05-25 02:04:11','first task',27,2,NULL,3,4,26,26);
547/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
548UNLOCK TABLES;
549
550--
551-- Table structure for table `users`
552--
553
554DROP TABLE IF EXISTS `users`;
555/*!40101 SET @saved_cs_client = @@character_set_client */;
556/*!40101 SET character_set_client = utf8 */;
557CREATE TABLE `users` (
558 `id` int(11) NOT NULL AUTO_INCREMENT,
559 `created_date` datetime NOT NULL,
560 `email` varchar(255) DEFAULT NULL,
561 `enabled` bit(1) NOT NULL,
562 `firstname` varchar(255) DEFAULT NULL,
563 `last_modified_date` datetime NOT NULL,
564 `lastname` varchar(255) DEFAULT NULL,
565 `password` varchar(255) DEFAULT NULL,
566 `phone_number` varchar(255) DEFAULT NULL,
567 `picture_path` varchar(255) DEFAULT NULL,
568 `username` varchar(255) DEFAULT NULL,
569 PRIMARY KEY (`id`)
570) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
571/*!40101 SET character_set_client = @saved_cs_client */;
572
573--
574-- Dumping data for table `users`
575--
576
577LOCK TABLES `users` WRITE;
578/*!40000 ALTER TABLE `users` DISABLE KEYS */;
579INSERT INTO `users` VALUES (19,'2017-06-09 03:15:55','ceffnerti@mlb.com','','Chiarra','2018-02-23 17:12:24','Effnert','ceffnerti','0699645573','/assets/dist/img/avatar.png','ceffnerti'),(20,'2017-10-24 11:06:12','bhaytoj@skyrock.com','','mlol','2017-09-08 16:37:26','lol','lol','0692455846','/assets/dist/img/avatar.png','lol'),(21,'2018-02-28 00:00:00','salim@gmail.com','','salim','2018-02-28 00:00:00','rahmani','salim','0645879532','/assets/dist/img/avatar5.png','salim'),(22,'2018-02-28 00:00:00','driss@gmail.com','','driss','2018-02-28 00:00:00','hanati','driss','0645879532','/assets/dist/img/avatar2.png','driss'),(23,'2018-03-05 02:23:14','test@test.com','','test','2018-03-05 02:23:14','user','password','0625184541','/assets/dist/img/avatar3.png','test'),(24,'2018-03-06 00:00:00','admin@admin.com','','admin','2018-03-06 00:00:00','Hanati','admin','0645287815','/assets/dist/img/avatar4.png','admin'),(25,'2018-03-06 00:00:00','manager@manager.com','','manager','2018-03-06 00:00:00','manager','manager','0645287815','/assets/dist/img/avatar.png','manager'),(26,'2018-03-06 00:00:00','responsable@responsable.com','','responsable','2018-03-06 00:00:00','responsable','responsable','0645287815','/assets/dist/img/driss.jpg','responsable'),(27,'2018-03-06 00:00:00','user@user.com','','user','2018-03-06 00:00:00','user','user','0645287815','/assets/dist/img/driss.jpg','user'),(28,'2018-03-09 02:04:53','user@email.com','','prenom','2018-03-09 02:04:53','nom','password','054651651','/assets/dist/img/default.png','username'),(35,'2018-04-26 16:21:34','hello@gmail.Com','','helloprenom','2018-04-26 16:22:21','hellonom','hellopassword','0515616515','/assets/dist/img/default.png','hellousername');
580/*!40000 ALTER TABLE `users` ENABLE KEYS */;
581UNLOCK TABLES;
582
583--
584-- Table structure for table `users_roles`
585--
586
587DROP TABLE IF EXISTS `users_roles`;
588/*!40101 SET @saved_cs_client = @@character_set_client */;
589/*!40101 SET character_set_client = utf8 */;
590CREATE TABLE `users_roles` (
591 `user_id` int(11) NOT NULL,
592 `role_id` bigint(20) NOT NULL,
593 PRIMARY KEY (`user_id`,`role_id`),
594 KEY `FK_roles_permissions_role_id_to_users` (`role_id`),
595 CONSTRAINT `FK_roles_permissions_role_id_to_users` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
596 CONSTRAINT `FK_roles_permissions_user_id_to_roles` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
597) ENGINE=InnoDB DEFAULT CHARSET=utf8;
598/*!40101 SET character_set_client = @saved_cs_client */;
599
600--
601-- Dumping data for table `users_roles`
602--
603
604LOCK TABLES `users_roles` WRITE;
605/*!40000 ALTER TABLE `users_roles` DISABLE KEYS */;
606INSERT INTO `users_roles` VALUES (21,1),(22,1),(25,1),(19,2),(20,2),(23,2),(27,2),(35,2),(21,3),(26,3),(24,4),(28,4),(35,4);
607/*!40000 ALTER TABLE `users_roles` ENABLE KEYS */;
608UNLOCK TABLES;
609/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
610
611/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
612/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
613/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
614/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
615/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
616/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
617/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
618
619-- Dump completed on 2018-11-25 23:45:38