· 6 years ago · Oct 26, 2019, 01:56 AM
1-- MySQL dump 10.13 Distrib 5.1.73, for redhat-linux-gnu (x86_64)
2--
3-- Host: localhost Database: fearless1
4-- ------------------------------------------------------
5-- Server version 5.1.73
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 `account`
20--
21
22DROP TABLE IF EXISTS `account`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `account` (
26 `uuid` varchar(64) DEFAULT NULL,
27 `created_on` datetime DEFAULT NULL,
28 `modified_on` datetime DEFAULT NULL,
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `active` tinyint(1) DEFAULT NULL,
31 `description` text,
32 `name` varchar(32) NOT NULL,
33 `max_credit` float DEFAULT NULL,
34 `credit` float DEFAULT NULL,
35 `parent_id` int(11) DEFAULT NULL,
36 PRIMARY KEY (`id`),
37 UNIQUE KEY `name` (`name`),
38 KEY `parent_id` (`parent_id`),
39 CONSTRAINT `account_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `account` (`id`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Table structure for table `accounts_tags`
45--
46
47DROP TABLE IF EXISTS `accounts_tags`;
48/*!40101 SET @saved_cs_client = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `accounts_tags` (
51 `id` int(11) NOT NULL AUTO_INCREMENT,
52 `account_id` int(11) NOT NULL,
53 `tag_id` int(11) NOT NULL,
54 PRIMARY KEY (`id`,`account_id`,`tag_id`),
55 KEY `account_id` (`account_id`),
56 KEY `tag_id` (`tag_id`),
57 CONSTRAINT `accounts_tags_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`),
58 CONSTRAINT `accounts_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Table structure for table `asset`
64--
65
66DROP TABLE IF EXISTS `asset`;
67/*!40101 SET @saved_cs_client = @@character_set_client */;
68/*!40101 SET character_set_client = utf8 */;
69CREATE TABLE `asset` (
70 `uuid` varchar(64) DEFAULT NULL,
71 `created_on` datetime DEFAULT NULL,
72 `modified_on` datetime DEFAULT NULL,
73 `id` int(11) NOT NULL AUTO_INCREMENT,
74 `key` varchar(32) NOT NULL,
75 `name` varchar(64) DEFAULT NULL,
76 `fullname` varchar(255) DEFAULT NULL,
77 `description` varchar(255) DEFAULT NULL,
78 `fileinfo` varchar(255) DEFAULT NULL,
79 `ext` varchar(32) DEFAULT NULL,
80 `content_type` varchar(64) DEFAULT NULL,
81 `version` int(11) DEFAULT NULL,
82 `content_size` bigint(20) DEFAULT NULL,
83 `task_id` varchar(64) DEFAULT NULL,
84 `ready` tinyint(1) DEFAULT NULL,
85 `path` varchar(255) DEFAULT NULL,
86 `repository_id` int(11) DEFAULT NULL,
87 `owner_id` int(11) DEFAULT NULL,
88 `asset_id` int(11) DEFAULT NULL,
89 `collection_id` int(11) NOT NULL,
90 PRIMARY KEY (`id`),
91 KEY `repository_id` (`repository_id`),
92 KEY `owner_id` (`owner_id`),
93 KEY `asset_id` (`asset_id`),
94 KEY `collection_id` (`collection_id`),
95 CONSTRAINT `asset_ibfk_1` FOREIGN KEY (`repository_id`) REFERENCES `repository` (`id`),
96 CONSTRAINT `asset_ibfk_2` FOREIGN KEY (`owner_id`) REFERENCES `user` (`id`),
97 CONSTRAINT `asset_ibfk_3` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
98 CONSTRAINT `asset_ibfk_4` FOREIGN KEY (`collection_id`) REFERENCES `collection` (`id`)
99) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
100/*!40101 SET character_set_client = @saved_cs_client */;
101
102--
103-- Table structure for table `assets_accounts`
104--
105
106DROP TABLE IF EXISTS `assets_accounts`;
107/*!40101 SET @saved_cs_client = @@character_set_client */;
108/*!40101 SET character_set_client = utf8 */;
109CREATE TABLE `assets_accounts` (
110 `id` int(11) NOT NULL AUTO_INCREMENT,
111 `asset_id` int(11) NOT NULL,
112 `account_id` int(11) NOT NULL,
113 PRIMARY KEY (`id`,`asset_id`,`account_id`),
114 KEY `asset_id` (`asset_id`),
115 KEY `account_id` (`account_id`),
116 CONSTRAINT `assets_accounts_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
117 CONSTRAINT `assets_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Table structure for table `assets_assets`
123--
124
125DROP TABLE IF EXISTS `assets_assets`;
126/*!40101 SET @saved_cs_client = @@character_set_client */;
127/*!40101 SET character_set_client = utf8 */;
128CREATE TABLE `assets_assets` (
129 `id` int(11) NOT NULL AUTO_INCREMENT,
130 `asset_a_id` int(11) DEFAULT NULL,
131 `asset_b_id` int(11) DEFAULT NULL,
132 PRIMARY KEY (`id`),
133 KEY `asset_a_id` (`asset_a_id`),
134 KEY `asset_b_id` (`asset_b_id`),
135 CONSTRAINT `assets_assets_ibfk_1` FOREIGN KEY (`asset_a_id`) REFERENCES `asset` (`id`),
136 CONSTRAINT `assets_assets_ibfk_2` FOREIGN KEY (`asset_b_id`) REFERENCES `asset` (`id`)
137) ENGINE=InnoDB DEFAULT CHARSET=utf8;
138/*!40101 SET character_set_client = @saved_cs_client */;
139
140--
141-- Table structure for table `assets_tags`
142--
143
144DROP TABLE IF EXISTS `assets_tags`;
145/*!40101 SET @saved_cs_client = @@character_set_client */;
146/*!40101 SET character_set_client = utf8 */;
147CREATE TABLE `assets_tags` (
148 `id` int(11) NOT NULL AUTO_INCREMENT,
149 `asset_id` int(11) NOT NULL,
150 `tag_id` int(11) NOT NULL,
151 PRIMARY KEY (`id`,`asset_id`,`tag_id`),
152 KEY `asset_id` (`asset_id`),
153 KEY `tag_id` (`tag_id`),
154 CONSTRAINT `assets_tags_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
155 CONSTRAINT `assets_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
156) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
157/*!40101 SET character_set_client = @saved_cs_client */;
158
159--
160-- Table structure for table `assets_tasks`
161--
162
163DROP TABLE IF EXISTS `assets_tasks`;
164/*!40101 SET @saved_cs_client = @@character_set_client */;
165/*!40101 SET character_set_client = utf8 */;
166CREATE TABLE `assets_tasks` (
167 `id` int(11) NOT NULL AUTO_INCREMENT,
168 `asset_id` int(11) NOT NULL,
169 `task_id` int(11) NOT NULL,
170 PRIMARY KEY (`id`,`asset_id`,`task_id`),
171 KEY `asset_id` (`asset_id`),
172 KEY `task_id` (`task_id`),
173 CONSTRAINT `assets_tasks_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
174 CONSTRAINT `assets_tasks_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
175) ENGINE=InnoDB DEFAULT CHARSET=utf8;
176/*!40101 SET character_set_client = @saved_cs_client */;
177
178--
179-- Table structure for table `client`
180--
181
182DROP TABLE IF EXISTS `client`;
183/*!40101 SET @saved_cs_client = @@character_set_client */;
184/*!40101 SET character_set_client = utf8 */;
185CREATE TABLE `client` (
186 `id` int(11) NOT NULL AUTO_INCREMENT,
187 `uuid` varchar(64) DEFAULT NULL,
188 `created_on` datetime DEFAULT NULL,
189 `modified_on` datetime DEFAULT NULL,
190 `name` varchar(64) NOT NULL,
191 PRIMARY KEY (`id`),
192 UNIQUE KEY `name` (`name`)
193) ENGINE=InnoDB DEFAULT CHARSET=utf8;
194/*!40101 SET character_set_client = @saved_cs_client */;
195
196--
197-- Table structure for table `client_users`
198--
199
200DROP TABLE IF EXISTS `client_users`;
201/*!40101 SET @saved_cs_client = @@character_set_client */;
202/*!40101 SET character_set_client = utf8 */;
203CREATE TABLE `client_users` (
204 `id` int(11) NOT NULL AUTO_INCREMENT,
205 `client_id` int(11) DEFAULT NULL,
206 `user_id` int(11) DEFAULT NULL,
207 PRIMARY KEY (`id`),
208 KEY `client_id` (`client_id`),
209 KEY `user_id` (`user_id`),
210 CONSTRAINT `client_users_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
211 CONSTRAINT `client_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
212) ENGINE=InnoDB DEFAULT CHARSET=utf8;
213/*!40101 SET character_set_client = @saved_cs_client */;
214
215--
216-- Table structure for table `clients_accounts`
217--
218
219DROP TABLE IF EXISTS `clients_accounts`;
220/*!40101 SET @saved_cs_client = @@character_set_client */;
221/*!40101 SET character_set_client = utf8 */;
222CREATE TABLE `clients_accounts` (
223 `id` int(11) NOT NULL AUTO_INCREMENT,
224 `client_id` int(11) NOT NULL,
225 `account_id` int(11) NOT NULL,
226 PRIMARY KEY (`id`,`client_id`,`account_id`),
227 KEY `client_id` (`client_id`),
228 KEY `account_id` (`account_id`),
229 CONSTRAINT `clients_accounts_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
230 CONSTRAINT `clients_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
231) ENGINE=InnoDB DEFAULT CHARSET=utf8;
232/*!40101 SET character_set_client = @saved_cs_client */;
233
234--
235-- Table structure for table `clients_tags`
236--
237
238DROP TABLE IF EXISTS `clients_tags`;
239/*!40101 SET @saved_cs_client = @@character_set_client */;
240/*!40101 SET character_set_client = utf8 */;
241CREATE TABLE `clients_tags` (
242 `id` int(11) NOT NULL AUTO_INCREMENT,
243 `client_id` int(11) NOT NULL,
244 `tag_id` int(11) NOT NULL,
245 PRIMARY KEY (`id`,`client_id`,`tag_id`),
246 KEY `client_id` (`client_id`),
247 KEY `tag_id` (`tag_id`),
248 CONSTRAINT `clients_tags_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
249 CONSTRAINT `clients_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
250) ENGINE=InnoDB DEFAULT CHARSET=utf8;
251/*!40101 SET character_set_client = @saved_cs_client */;
252
253--
254-- Table structure for table `collection`
255--
256
257DROP TABLE IF EXISTS `collection`;
258/*!40101 SET @saved_cs_client = @@character_set_client */;
259/*!40101 SET character_set_client = utf8 */;
260CREATE TABLE `collection` (
261 `uuid` varchar(64) DEFAULT NULL,
262 `created_on` datetime DEFAULT NULL,
263 `modified_on` datetime DEFAULT NULL,
264 `id` int(11) NOT NULL AUTO_INCREMENT,
265 `schema` text,
266 `name` varchar(128) DEFAULT NULL,
267 `description` varchar(255) DEFAULT NULL,
268 `container` tinyint(1) DEFAULT NULL,
269 `holdAssets` tinyint(1) DEFAULT NULL,
270 `version` int(11) DEFAULT NULL,
271 `template` varchar(64) DEFAULT NULL,
272 `owner_id` int(11) DEFAULT NULL,
273 `parent_id` int(11) DEFAULT NULL,
274 `path` varchar(255) NOT NULL,
275 `url` varchar(255) DEFAULT NULL,
276 `repository_id` int(11) NOT NULL,
277 `number_of_assets` int(11) DEFAULT NULL,
278 `collection_size` int(11) DEFAULT NULL,
279 PRIMARY KEY (`id`),
280 KEY `owner_id` (`owner_id`),
281 KEY `parent_id` (`parent_id`),
282 KEY `repository_id` (`repository_id`),
283 CONSTRAINT `collection_ibfk_1` FOREIGN KEY (`owner_id`) REFERENCES `user` (`id`),
284 CONSTRAINT `collection_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `collection` (`id`),
285 CONSTRAINT `collection_ibfk_3` FOREIGN KEY (`repository_id`) REFERENCES `repository` (`id`)
286) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
287/*!40101 SET character_set_client = @saved_cs_client */;
288
289--
290-- Table structure for table `collections_tags`
291--
292
293DROP TABLE IF EXISTS `collections_tags`;
294/*!40101 SET @saved_cs_client = @@character_set_client */;
295/*!40101 SET character_set_client = utf8 */;
296CREATE TABLE `collections_tags` (
297 `id` int(11) NOT NULL AUTO_INCREMENT,
298 `collection_id` int(11) NOT NULL,
299 `tag_id` int(11) NOT NULL,
300 PRIMARY KEY (`id`,`collection_id`,`tag_id`),
301 KEY `collection_id` (`collection_id`),
302 KEY `tag_id` (`tag_id`),
303 CONSTRAINT `collections_tags_ibfk_1` FOREIGN KEY (`collection_id`) REFERENCES `collection` (`id`),
304 CONSTRAINT `collections_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
305) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
306/*!40101 SET character_set_client = @saved_cs_client */;
307
308--
309-- Table structure for table `comment`
310--
311
312DROP TABLE IF EXISTS `comment`;
313/*!40101 SET @saved_cs_client = @@character_set_client */;
314/*!40101 SET character_set_client = utf8 */;
315CREATE TABLE `comment` (
316 `id` int(11) NOT NULL AUTO_INCREMENT,
317 `uuid` varchar(64) DEFAULT NULL,
318 `created_on` datetime DEFAULT NULL,
319 `modified_on` datetime DEFAULT NULL,
320 `item` varchar(256) NOT NULL,
321 `content` text NOT NULL,
322 `tag` varchar(64) DEFAULT NULL,
323 `user_id` int(11) DEFAULT NULL,
324 PRIMARY KEY (`id`),
325 KEY `user_id` (`user_id`),
326 CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
327) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
328/*!40101 SET character_set_client = @saved_cs_client */;
329
330--
331-- Table structure for table `comments_tags`
332--
333
334DROP TABLE IF EXISTS `comments_tags`;
335/*!40101 SET @saved_cs_client = @@character_set_client */;
336/*!40101 SET character_set_client = utf8 */;
337CREATE TABLE `comments_tags` (
338 `id` int(11) NOT NULL AUTO_INCREMENT,
339 `comment_id` int(11) NOT NULL,
340 `tag_id` int(11) NOT NULL,
341 PRIMARY KEY (`id`,`comment_id`,`tag_id`),
342 KEY `comment_id` (`comment_id`),
343 KEY `tag_id` (`tag_id`),
344 CONSTRAINT `comments_tags_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `comment` (`id`),
345 CONSTRAINT `comments_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
346) ENGINE=InnoDB DEFAULT CHARSET=utf8;
347/*!40101 SET character_set_client = @saved_cs_client */;
348
349--
350-- Table structure for table `date`
351--
352
353DROP TABLE IF EXISTS `date`;
354/*!40101 SET @saved_cs_client = @@character_set_client */;
355/*!40101 SET character_set_client = utf8 */;
356CREATE TABLE `date` (
357 `id` int(11) NOT NULL AUTO_INCREMENT,
358 `uuid` varchar(64) DEFAULT NULL,
359 `created_on` datetime DEFAULT NULL,
360 `modified_on` datetime DEFAULT NULL,
361 `start` datetime NOT NULL,
362 `end` datetime NOT NULL,
363 `accpeted` tinyint(1) DEFAULT NULL,
364 `client_id` int(11) DEFAULT NULL,
365 `user_id` int(11) DEFAULT NULL,
366 `task_id` int(11) DEFAULT NULL,
367 `project_id` int(11) DEFAULT NULL,
368 `shot_id` int(11) DEFAULT NULL,
369 `sequence_id` int(11) DEFAULT NULL,
370 `scene_id` int(11) DEFAULT NULL,
371 `repository_id` int(11) DEFAULT NULL,
372 `collection_id` int(11) DEFAULT NULL,
373 `asset_id` int(11) DEFAULT NULL,
374 `report_id` int(11) DEFAULT NULL,
375 `ticket_id` int(11) DEFAULT NULL,
376 `account_id` int(11) DEFAULT NULL,
377 `document_id` int(11) DEFAULT NULL,
378 `departement_id` int(11) DEFAULT NULL,
379 PRIMARY KEY (`id`),
380 KEY `client_id` (`client_id`),
381 KEY `user_id` (`user_id`),
382 KEY `task_id` (`task_id`),
383 KEY `project_id` (`project_id`),
384 KEY `shot_id` (`shot_id`),
385 KEY `sequence_id` (`sequence_id`),
386 KEY `scene_id` (`scene_id`),
387 KEY `repository_id` (`repository_id`),
388 KEY `collection_id` (`collection_id`),
389 KEY `asset_id` (`asset_id`),
390 KEY `report_id` (`report_id`),
391 KEY `ticket_id` (`ticket_id`),
392 KEY `account_id` (`account_id`),
393 KEY `document_id` (`document_id`),
394 KEY `departement_id` (`departement_id`),
395 CONSTRAINT `date_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
396 CONSTRAINT `date_ibfk_10` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
397 CONSTRAINT `date_ibfk_11` FOREIGN KEY (`report_id`) REFERENCES `report` (`id`),
398 CONSTRAINT `date_ibfk_12` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`),
399 CONSTRAINT `date_ibfk_13` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`),
400 CONSTRAINT `date_ibfk_14` FOREIGN KEY (`document_id`) REFERENCES `document` (`id`),
401 CONSTRAINT `date_ibfk_15` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`),
402 CONSTRAINT `date_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
403 CONSTRAINT `date_ibfk_3` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
404 CONSTRAINT `date_ibfk_4` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
405 CONSTRAINT `date_ibfk_5` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
406 CONSTRAINT `date_ibfk_6` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`),
407 CONSTRAINT `date_ibfk_7` FOREIGN KEY (`scene_id`) REFERENCES `scene` (`id`),
408 CONSTRAINT `date_ibfk_8` FOREIGN KEY (`repository_id`) REFERENCES `repository` (`id`),
409 CONSTRAINT `date_ibfk_9` FOREIGN KEY (`collection_id`) REFERENCES `collection` (`id`)
410) ENGINE=InnoDB DEFAULT CHARSET=utf8;
411/*!40101 SET character_set_client = @saved_cs_client */;
412
413--
414-- Table structure for table `dates_tags`
415--
416
417DROP TABLE IF EXISTS `dates_tags`;
418/*!40101 SET @saved_cs_client = @@character_set_client */;
419/*!40101 SET character_set_client = utf8 */;
420CREATE TABLE `dates_tags` (
421 `id` int(11) NOT NULL AUTO_INCREMENT,
422 `date_id` int(11) NOT NULL,
423 `tag_id` int(11) NOT NULL,
424 PRIMARY KEY (`id`,`date_id`,`tag_id`),
425 KEY `date_id` (`date_id`),
426 KEY `tag_id` (`tag_id`),
427 CONSTRAINT `dates_tags_ibfk_1` FOREIGN KEY (`date_id`) REFERENCES `date` (`id`),
428 CONSTRAINT `dates_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
429) ENGINE=InnoDB DEFAULT CHARSET=utf8;
430/*!40101 SET character_set_client = @saved_cs_client */;
431
432--
433-- Table structure for table `departement`
434--
435
436DROP TABLE IF EXISTS `departement`;
437/*!40101 SET @saved_cs_client = @@character_set_client */;
438/*!40101 SET character_set_client = utf8 */;
439CREATE TABLE `departement` (
440 `id` int(11) NOT NULL AUTO_INCREMENT,
441 `uuid` varchar(64) DEFAULT NULL,
442 `created_on` datetime DEFAULT NULL,
443 `modified_on` datetime DEFAULT NULL,
444 `name` varchar(64) NOT NULL,
445 PRIMARY KEY (`id`)
446) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
447/*!40101 SET character_set_client = @saved_cs_client */;
448
449--
450-- Table structure for table `departements_accounts`
451--
452
453DROP TABLE IF EXISTS `departements_accounts`;
454/*!40101 SET @saved_cs_client = @@character_set_client */;
455/*!40101 SET character_set_client = utf8 */;
456CREATE TABLE `departements_accounts` (
457 `id` int(11) NOT NULL AUTO_INCREMENT,
458 `departement_id` int(11) NOT NULL,
459 `account_id` int(11) NOT NULL,
460 PRIMARY KEY (`id`,`departement_id`,`account_id`),
461 KEY `departement_id` (`departement_id`),
462 KEY `account_id` (`account_id`),
463 CONSTRAINT `departements_accounts_ibfk_1` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`),
464 CONSTRAINT `departements_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
465) ENGINE=InnoDB DEFAULT CHARSET=utf8;
466/*!40101 SET character_set_client = @saved_cs_client */;
467
468--
469-- Table structure for table `departements_tags`
470--
471
472DROP TABLE IF EXISTS `departements_tags`;
473/*!40101 SET @saved_cs_client = @@character_set_client */;
474/*!40101 SET character_set_client = utf8 */;
475CREATE TABLE `departements_tags` (
476 `id` int(11) NOT NULL AUTO_INCREMENT,
477 `departement_id` int(11) NOT NULL,
478 `tag_id` int(11) NOT NULL,
479 PRIMARY KEY (`id`,`departement_id`,`tag_id`),
480 KEY `departement_id` (`departement_id`),
481 KEY `tag_id` (`tag_id`),
482 CONSTRAINT `departements_tags_ibfk_1` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`),
483 CONSTRAINT `departements_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
484) ENGINE=InnoDB DEFAULT CHARSET=utf8;
485/*!40101 SET character_set_client = @saved_cs_client */;
486
487--
488-- Table structure for table `document`
489--
490
491DROP TABLE IF EXISTS `document`;
492/*!40101 SET @saved_cs_client = @@character_set_client */;
493/*!40101 SET character_set_client = utf8 */;
494CREATE TABLE `document` (
495 `id` int(11) NOT NULL AUTO_INCREMENT,
496 `uuid` varchar(64) DEFAULT NULL,
497 `created_on` datetime DEFAULT NULL,
498 `modified_on` datetime DEFAULT NULL,
499 `title` varchar(255) DEFAULT NULL,
500 `data` text NOT NULL,
501 `user_id` int(11) DEFAULT NULL,
502 `asset_id` int(11) DEFAULT NULL,
503 `project_id` int(11) DEFAULT NULL,
504 `task_id` int(11) DEFAULT NULL,
505 `account_id` int(11) DEFAULT NULL,
506 `ticket_id` int(11) DEFAULT NULL,
507 `client_id` int(11) DEFAULT NULL,
508 `shot_id` int(11) DEFAULT NULL,
509 `sequence_id` int(11) DEFAULT NULL,
510 `review_id` int(11) DEFAULT NULL,
511 PRIMARY KEY (`id`),
512 UNIQUE KEY `title` (`title`),
513 KEY `user_id` (`user_id`),
514 KEY `asset_id` (`asset_id`),
515 KEY `project_id` (`project_id`),
516 KEY `task_id` (`task_id`),
517 KEY `account_id` (`account_id`),
518 KEY `ticket_id` (`ticket_id`),
519 KEY `client_id` (`client_id`),
520 KEY `shot_id` (`shot_id`),
521 KEY `sequence_id` (`sequence_id`),
522 KEY `review_id` (`review_id`),
523 CONSTRAINT `document_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
524 CONSTRAINT `document_ibfk_10` FOREIGN KEY (`review_id`) REFERENCES `review` (`id`),
525 CONSTRAINT `document_ibfk_2` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
526 CONSTRAINT `document_ibfk_3` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
527 CONSTRAINT `document_ibfk_4` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
528 CONSTRAINT `document_ibfk_5` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`),
529 CONSTRAINT `document_ibfk_6` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`),
530 CONSTRAINT `document_ibfk_7` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
531 CONSTRAINT `document_ibfk_8` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
532 CONSTRAINT `document_ibfk_9` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`)
533) ENGINE=InnoDB DEFAULT CHARSET=utf8;
534/*!40101 SET character_set_client = @saved_cs_client */;
535
536--
537-- Table structure for table `documents_tags`
538--
539
540DROP TABLE IF EXISTS `documents_tags`;
541/*!40101 SET @saved_cs_client = @@character_set_client */;
542/*!40101 SET character_set_client = utf8 */;
543CREATE TABLE `documents_tags` (
544 `id` int(11) NOT NULL AUTO_INCREMENT,
545 `document_id` int(11) NOT NULL,
546 `tag_id` int(11) NOT NULL,
547 PRIMARY KEY (`id`,`document_id`,`tag_id`),
548 KEY `document_id` (`document_id`),
549 KEY `tag_id` (`tag_id`),
550 CONSTRAINT `documents_tags_ibfk_1` FOREIGN KEY (`document_id`) REFERENCES `document` (`id`),
551 CONSTRAINT `documents_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
552) ENGINE=InnoDB DEFAULT CHARSET=utf8;
553/*!40101 SET character_set_client = @saved_cs_client */;
554
555--
556-- Table structure for table `expert`
557--
558
559DROP TABLE IF EXISTS `expert`;
560/*!40101 SET @saved_cs_client = @@character_set_client */;
561/*!40101 SET character_set_client = utf8 */;
562CREATE TABLE `expert` (
563 `id` int(11) NOT NULL AUTO_INCREMENT,
564 `uuid` varchar(64) DEFAULT NULL,
565 `created_on` datetime DEFAULT NULL,
566 `modified_on` datetime DEFAULT NULL,
567 `name` varchar(128) NOT NULL,
568 PRIMARY KEY (`id`),
569 UNIQUE KEY `name` (`name`)
570) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;
571/*!40101 SET character_set_client = @saved_cs_client */;
572
573--
574-- Table structure for table `experts_accounts`
575--
576
577DROP TABLE IF EXISTS `experts_accounts`;
578/*!40101 SET @saved_cs_client = @@character_set_client */;
579/*!40101 SET character_set_client = utf8 */;
580CREATE TABLE `experts_accounts` (
581 `id` int(11) NOT NULL AUTO_INCREMENT,
582 `expert_id` int(11) NOT NULL,
583 `account_id` int(11) NOT NULL,
584 PRIMARY KEY (`id`,`expert_id`,`account_id`),
585 KEY `expert_id` (`expert_id`),
586 KEY `account_id` (`account_id`),
587 CONSTRAINT `experts_accounts_ibfk_1` FOREIGN KEY (`expert_id`) REFERENCES `expert` (`id`),
588 CONSTRAINT `experts_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
589) ENGINE=InnoDB DEFAULT CHARSET=utf8;
590/*!40101 SET character_set_client = @saved_cs_client */;
591
592--
593-- Table structure for table `experts_tags`
594--
595
596DROP TABLE IF EXISTS `experts_tags`;
597/*!40101 SET @saved_cs_client = @@character_set_client */;
598/*!40101 SET character_set_client = utf8 */;
599CREATE TABLE `experts_tags` (
600 `id` int(11) NOT NULL AUTO_INCREMENT,
601 `expert_id` int(11) NOT NULL,
602 `tag_id` int(11) NOT NULL,
603 PRIMARY KEY (`id`,`expert_id`,`tag_id`),
604 KEY `expert_id` (`expert_id`),
605 KEY `tag_id` (`tag_id`),
606 CONSTRAINT `experts_tags_ibfk_1` FOREIGN KEY (`expert_id`) REFERENCES `expert` (`id`),
607 CONSTRAINT `experts_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
608) ENGINE=InnoDB DEFAULT CHARSET=utf8;
609/*!40101 SET character_set_client = @saved_cs_client */;
610
611--
612-- Table structure for table `group`
613--
614
615DROP TABLE IF EXISTS `group`;
616/*!40101 SET @saved_cs_client = @@character_set_client */;
617/*!40101 SET character_set_client = utf8 */;
618CREATE TABLE `group` (
619 `id` int(11) NOT NULL AUTO_INCREMENT,
620 `uuid` varchar(64) DEFAULT NULL,
621 `created_on` datetime DEFAULT NULL,
622 `modified_on` datetime DEFAULT NULL,
623 `name` varchar(32) NOT NULL,
624 `typ` varchar(32) NOT NULL,
625 PRIMARY KEY (`id`),
626 UNIQUE KEY `name` (`name`)
627) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
628/*!40101 SET character_set_client = @saved_cs_client */;
629
630--
631-- Table structure for table `group_roles`
632--
633
634DROP TABLE IF EXISTS `group_roles`;
635/*!40101 SET @saved_cs_client = @@character_set_client */;
636/*!40101 SET character_set_client = utf8 */;
637CREATE TABLE `group_roles` (
638 `id` int(11) NOT NULL AUTO_INCREMENT,
639 `role_id` int(11) DEFAULT NULL,
640 `group_id` int(11) DEFAULT NULL,
641 PRIMARY KEY (`id`),
642 KEY `role_id` (`role_id`),
643 KEY `group_id` (`group_id`),
644 CONSTRAINT `group_roles_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
645 CONSTRAINT `group_roles_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`)
646) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8;
647/*!40101 SET character_set_client = @saved_cs_client */;
648
649--
650-- Table structure for table `groups_tags`
651--
652
653DROP TABLE IF EXISTS `groups_tags`;
654/*!40101 SET @saved_cs_client = @@character_set_client */;
655/*!40101 SET character_set_client = utf8 */;
656CREATE TABLE `groups_tags` (
657 `id` int(11) NOT NULL AUTO_INCREMENT,
658 `group_id` int(11) NOT NULL,
659 `tag_id` int(11) NOT NULL,
660 PRIMARY KEY (`id`,`group_id`,`tag_id`),
661 KEY `group_id` (`group_id`),
662 KEY `tag_id` (`tag_id`),
663 CONSTRAINT `groups_tags_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`),
664 CONSTRAINT `groups_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
665) ENGINE=InnoDB DEFAULT CHARSET=utf8;
666/*!40101 SET character_set_client = @saved_cs_client */;
667
668--
669-- Table structure for table `project`
670--
671
672DROP TABLE IF EXISTS `project`;
673/*!40101 SET @saved_cs_client = @@character_set_client */;
674/*!40101 SET character_set_client = utf8 */;
675CREATE TABLE `project` (
676 `uuid` varchar(64) DEFAULT NULL,
677 `created_on` datetime DEFAULT NULL,
678 `modified_on` datetime DEFAULT NULL,
679 `id` int(11) NOT NULL AUTO_INCREMENT,
680 `active` tinyint(1) DEFAULT NULL,
681 `status` int(11) DEFAULT NULL,
682 `name` varchar(64) NOT NULL,
683 `last_plan` varchar(64) DEFAULT NULL,
684 `description` text,
685 `client_id` int(11) DEFAULT NULL,
686 `start` datetime NOT NULL,
687 `end` datetime NOT NULL,
688 `duration` float DEFAULT NULL,
689 `effort` float NOT NULL,
690 `effort_left` float DEFAULT NULL,
691 `effort_done` float DEFAULT NULL,
692 `length` float DEFAULT NULL,
693 `complete` int(11) DEFAULT NULL,
694 `lead_id` int(11) NOT NULL,
695 `creator_id` int(11) DEFAULT NULL,
696 `director_id` int(11) DEFAULT NULL,
697 `working_days` varchar(128) DEFAULT NULL,
698 `is_stereoscopic` tinyint(1) DEFAULT NULL,
699 `fps` float DEFAULT NULL,
700 `project_id` int(11) DEFAULT NULL,
701 `calculate_number_of_tasks` int(11) DEFAULT NULL,
702 PRIMARY KEY (`id`),
703 UNIQUE KEY `name` (`name`),
704 KEY `client_id` (`client_id`),
705 KEY `lead_id` (`lead_id`),
706 KEY `creator_id` (`creator_id`),
707 KEY `director_id` (`director_id`),
708 KEY `project_id` (`project_id`),
709 CONSTRAINT `project_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
710 CONSTRAINT `project_ibfk_2` FOREIGN KEY (`lead_id`) REFERENCES `user` (`id`),
711 CONSTRAINT `project_ibfk_3` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`),
712 CONSTRAINT `project_ibfk_4` FOREIGN KEY (`director_id`) REFERENCES `user` (`id`),
713 CONSTRAINT `project_ibfk_5` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`)
714) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
715/*!40101 SET character_set_client = @saved_cs_client */;
716
717--
718-- Table structure for table `project_reports`
719--
720
721DROP TABLE IF EXISTS `project_reports`;
722/*!40101 SET @saved_cs_client = @@character_set_client */;
723/*!40101 SET character_set_client = utf8 */;
724CREATE TABLE `project_reports` (
725 `project_id` int(11) NOT NULL,
726 `report_id` int(11) NOT NULL,
727 PRIMARY KEY (`project_id`,`report_id`),
728 KEY `report_id` (`report_id`),
729 CONSTRAINT `project_reports_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
730 CONSTRAINT `project_reports_ibfk_2` FOREIGN KEY (`report_id`) REFERENCES `report` (`id`)
731) ENGINE=InnoDB DEFAULT CHARSET=utf8;
732/*!40101 SET character_set_client = @saved_cs_client */;
733
734--
735-- Table structure for table `project_users`
736--
737
738DROP TABLE IF EXISTS `project_users`;
739/*!40101 SET @saved_cs_client = @@character_set_client */;
740/*!40101 SET character_set_client = utf8 */;
741CREATE TABLE `project_users` (
742 `id` int(11) NOT NULL AUTO_INCREMENT,
743 `project_id` int(11) DEFAULT NULL,
744 `user_id` int(11) DEFAULT NULL,
745 PRIMARY KEY (`id`),
746 KEY `project_id` (`project_id`),
747 KEY `user_id` (`user_id`),
748 CONSTRAINT `project_users_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
749 CONSTRAINT `project_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
750) ENGINE=InnoDB DEFAULT CHARSET=utf8;
751/*!40101 SET character_set_client = @saved_cs_client */;
752
753--
754-- Table structure for table `project_watchers`
755--
756
757DROP TABLE IF EXISTS `project_watchers`;
758/*!40101 SET @saved_cs_client = @@character_set_client */;
759/*!40101 SET character_set_client = utf8 */;
760CREATE TABLE `project_watchers` (
761 `id` int(11) NOT NULL AUTO_INCREMENT,
762 `project_id` int(11) DEFAULT NULL,
763 `user_id` int(11) DEFAULT NULL,
764 PRIMARY KEY (`id`),
765 KEY `project_id` (`project_id`),
766 KEY `user_id` (`user_id`),
767 CONSTRAINT `project_watchers_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
768 CONSTRAINT `project_watchers_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
769) ENGINE=InnoDB DEFAULT CHARSET=utf8;
770/*!40101 SET character_set_client = @saved_cs_client */;
771
772--
773-- Table structure for table `projects_accounts`
774--
775
776DROP TABLE IF EXISTS `projects_accounts`;
777/*!40101 SET @saved_cs_client = @@character_set_client */;
778/*!40101 SET character_set_client = utf8 */;
779CREATE TABLE `projects_accounts` (
780 `id` int(11) NOT NULL AUTO_INCREMENT,
781 `project_id` int(11) NOT NULL,
782 `account_id` int(11) NOT NULL,
783 PRIMARY KEY (`id`,`project_id`,`account_id`),
784 KEY `project_id` (`project_id`),
785 KEY `account_id` (`account_id`),
786 CONSTRAINT `projects_accounts_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
787 CONSTRAINT `projects_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
788) ENGINE=InnoDB DEFAULT CHARSET=utf8;
789/*!40101 SET character_set_client = @saved_cs_client */;
790
791--
792-- Table structure for table `projects_tags`
793--
794
795DROP TABLE IF EXISTS `projects_tags`;
796/*!40101 SET @saved_cs_client = @@character_set_client */;
797/*!40101 SET character_set_client = utf8 */;
798CREATE TABLE `projects_tags` (
799 `id` int(11) NOT NULL AUTO_INCREMENT,
800 `project_id` int(11) NOT NULL,
801 `tag_id` int(11) NOT NULL,
802 PRIMARY KEY (`id`,`project_id`,`tag_id`),
803 KEY `project_id` (`project_id`),
804 KEY `tag_id` (`tag_id`),
805 CONSTRAINT `projects_tags_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
806 CONSTRAINT `projects_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
807) ENGINE=InnoDB DEFAULT CHARSET=utf8;
808/*!40101 SET character_set_client = @saved_cs_client */;
809
810--
811-- Table structure for table `report`
812--
813
814DROP TABLE IF EXISTS `report`;
815/*!40101 SET @saved_cs_client = @@character_set_client */;
816/*!40101 SET character_set_client = utf8 */;
817CREATE TABLE `report` (
818 `id` int(11) NOT NULL AUTO_INCREMENT,
819 `uuid` varchar(64) DEFAULT NULL,
820 `created_on` datetime DEFAULT NULL,
821 `modified_on` datetime DEFAULT NULL,
822 `data` text NOT NULL,
823 `user_id` int(11) DEFAULT NULL,
824 `project_id` int(11) DEFAULT NULL,
825 `asset_id` int(11) DEFAULT NULL,
826 `client_id` int(11) DEFAULT NULL,
827 `shot_id` int(11) DEFAULT NULL,
828 `sequence_id` int(11) DEFAULT NULL,
829 `task_id` int(11) DEFAULT NULL,
830 PRIMARY KEY (`id`),
831 KEY `user_id` (`user_id`),
832 KEY `project_id` (`project_id`),
833 KEY `asset_id` (`asset_id`),
834 KEY `client_id` (`client_id`),
835 KEY `shot_id` (`shot_id`),
836 KEY `sequence_id` (`sequence_id`),
837 KEY `task_id` (`task_id`),
838 CONSTRAINT `report_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
839 CONSTRAINT `report_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
840 CONSTRAINT `report_ibfk_3` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
841 CONSTRAINT `report_ibfk_4` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
842 CONSTRAINT `report_ibfk_5` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
843 CONSTRAINT `report_ibfk_6` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`),
844 CONSTRAINT `report_ibfk_7` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
845) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
846/*!40101 SET character_set_client = @saved_cs_client */;
847
848--
849-- Table structure for table `reports_tags`
850--
851
852DROP TABLE IF EXISTS `reports_tags`;
853/*!40101 SET @saved_cs_client = @@character_set_client */;
854/*!40101 SET character_set_client = utf8 */;
855CREATE TABLE `reports_tags` (
856 `id` int(11) NOT NULL AUTO_INCREMENT,
857 `report_id` int(11) NOT NULL,
858 `tag_id` int(11) NOT NULL,
859 PRIMARY KEY (`id`,`report_id`,`tag_id`),
860 KEY `report_id` (`report_id`),
861 KEY `tag_id` (`tag_id`),
862 CONSTRAINT `reports_tags_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `report` (`id`),
863 CONSTRAINT `reports_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
864) ENGINE=InnoDB DEFAULT CHARSET=utf8;
865/*!40101 SET character_set_client = @saved_cs_client */;
866
867--
868-- Table structure for table `repositories_tags`
869--
870
871DROP TABLE IF EXISTS `repositories_tags`;
872/*!40101 SET @saved_cs_client = @@character_set_client */;
873/*!40101 SET character_set_client = utf8 */;
874CREATE TABLE `repositories_tags` (
875 `id` int(11) NOT NULL AUTO_INCREMENT,
876 `repository_id` int(11) NOT NULL,
877 `tag_id` int(11) NOT NULL,
878 PRIMARY KEY (`id`,`repository_id`,`tag_id`),
879 KEY `repository_id` (`repository_id`),
880 KEY `tag_id` (`tag_id`),
881 CONSTRAINT `repositories_tags_ibfk_1` FOREIGN KEY (`repository_id`) REFERENCES `repository` (`id`),
882 CONSTRAINT `repositories_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
883) ENGINE=InnoDB DEFAULT CHARSET=utf8;
884/*!40101 SET character_set_client = @saved_cs_client */;
885
886--
887-- Table structure for table `repository`
888--
889
890DROP TABLE IF EXISTS `repository`;
891/*!40101 SET @saved_cs_client = @@character_set_client */;
892/*!40101 SET character_set_client = utf8 */;
893CREATE TABLE `repository` (
894 `id` int(11) NOT NULL AUTO_INCREMENT,
895 `uuid` varchar(64) DEFAULT NULL,
896 `created_on` datetime DEFAULT NULL,
897 `modified_on` datetime DEFAULT NULL,
898 `name` varchar(32) NOT NULL,
899 `path` varchar(255) NOT NULL,
900 `windows_path` varchar(255) DEFAULT NULL,
901 `osx_path` varchar(255) DEFAULT NULL,
902 `ftp_path` varchar(255) DEFAULT NULL,
903 `sftp_path` varchar(255) DEFAULT NULL,
904 `webdav_path` varchar(255) DEFAULT NULL,
905 `project_id` int(11) DEFAULT NULL,
906 `owner_id` int(11) DEFAULT NULL,
907 PRIMARY KEY (`id`),
908 UNIQUE KEY `name` (`name`),
909 UNIQUE KEY `path` (`path`),
910 KEY `project_id` (`project_id`),
911 KEY `owner_id` (`owner_id`),
912 CONSTRAINT `repository_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
913 CONSTRAINT `repository_ibfk_2` FOREIGN KEY (`owner_id`) REFERENCES `user` (`id`)
914) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
915/*!40101 SET character_set_client = @saved_cs_client */;
916
917--
918-- Table structure for table `review`
919--
920
921DROP TABLE IF EXISTS `review`;
922/*!40101 SET @saved_cs_client = @@character_set_client */;
923/*!40101 SET character_set_client = utf8 */;
924CREATE TABLE `review` (
925 `id` int(11) NOT NULL AUTO_INCREMENT,
926 `uuid` varchar(64) DEFAULT NULL,
927 `created_on` datetime DEFAULT NULL,
928 `modified_on` datetime DEFAULT NULL,
929 `task_id` int(11) DEFAULT NULL,
930 `asset_id` int(11) DEFAULT NULL,
931 `reviewer_id` int(11) NOT NULL,
932 PRIMARY KEY (`id`),
933 KEY `task_id` (`task_id`),
934 KEY `asset_id` (`asset_id`),
935 KEY `reviewer_id` (`reviewer_id`),
936 CONSTRAINT `review_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
937 CONSTRAINT `review_ibfk_2` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
938 CONSTRAINT `review_ibfk_3` FOREIGN KEY (`reviewer_id`) REFERENCES `user` (`id`)
939) ENGINE=InnoDB DEFAULT CHARSET=utf8;
940/*!40101 SET character_set_client = @saved_cs_client */;
941
942--
943-- Table structure for table `review_tags`
944--
945
946DROP TABLE IF EXISTS `review_tags`;
947/*!40101 SET @saved_cs_client = @@character_set_client */;
948/*!40101 SET character_set_client = utf8 */;
949CREATE TABLE `review_tags` (
950 `id` int(11) NOT NULL AUTO_INCREMENT,
951 `review_id` int(11) NOT NULL,
952 `tag_id` int(11) NOT NULL,
953 PRIMARY KEY (`id`,`review_id`,`tag_id`),
954 KEY `review_id` (`review_id`),
955 KEY `tag_id` (`tag_id`),
956 CONSTRAINT `review_tags_ibfk_1` FOREIGN KEY (`review_id`) REFERENCES `review` (`id`),
957 CONSTRAINT `review_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
958) ENGINE=InnoDB DEFAULT CHARSET=utf8;
959/*!40101 SET character_set_client = @saved_cs_client */;
960
961--
962-- Table structure for table `role`
963--
964
965DROP TABLE IF EXISTS `role`;
966/*!40101 SET @saved_cs_client = @@character_set_client */;
967/*!40101 SET character_set_client = utf8 */;
968CREATE TABLE `role` (
969 `id` int(11) NOT NULL AUTO_INCREMENT,
970 `uuid` varchar(64) DEFAULT NULL,
971 `created_on` datetime DEFAULT NULL,
972 `modified_on` datetime DEFAULT NULL,
973 `name` varchar(32) NOT NULL,
974 PRIMARY KEY (`id`),
975 UNIQUE KEY `name` (`name`)
976) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;
977/*!40101 SET character_set_client = @saved_cs_client */;
978
979--
980-- Table structure for table `roles_tags`
981--
982
983DROP TABLE IF EXISTS `roles_tags`;
984/*!40101 SET @saved_cs_client = @@character_set_client */;
985/*!40101 SET character_set_client = utf8 */;
986CREATE TABLE `roles_tags` (
987 `id` int(11) NOT NULL AUTO_INCREMENT,
988 `role_id` int(11) NOT NULL,
989 `tag_id` int(11) NOT NULL,
990 PRIMARY KEY (`id`,`role_id`,`tag_id`),
991 KEY `role_id` (`role_id`),
992 KEY `tag_id` (`tag_id`),
993 CONSTRAINT `roles_tags_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
994 CONSTRAINT `roles_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
995) ENGINE=InnoDB DEFAULT CHARSET=utf8;
996/*!40101 SET character_set_client = @saved_cs_client */;
997
998--
999-- Table structure for table `scene`
1000--
1001
1002DROP TABLE IF EXISTS `scene`;
1003/*!40101 SET @saved_cs_client = @@character_set_client */;
1004/*!40101 SET character_set_client = utf8 */;
1005CREATE TABLE `scene` (
1006 `id` int(11) NOT NULL AUTO_INCREMENT,
1007 `uuid` varchar(64) DEFAULT NULL,
1008 `created_on` datetime DEFAULT NULL,
1009 `modified_on` datetime DEFAULT NULL,
1010 PRIMARY KEY (`id`)
1011) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1012/*!40101 SET character_set_client = @saved_cs_client */;
1013
1014--
1015-- Table structure for table `sequence`
1016--
1017
1018DROP TABLE IF EXISTS `sequence`;
1019/*!40101 SET @saved_cs_client = @@character_set_client */;
1020/*!40101 SET character_set_client = utf8 */;
1021CREATE TABLE `sequence` (
1022 `id` int(11) NOT NULL AUTO_INCREMENT,
1023 `uuid` varchar(64) DEFAULT NULL,
1024 `created_on` datetime DEFAULT NULL,
1025 `modified_on` datetime DEFAULT NULL,
1026 `number` int(11) NOT NULL,
1027 `name` varchar(64) NOT NULL,
1028 `code` varchar(64) NOT NULL,
1029 `note` varchar(255) DEFAULT NULL,
1030 `asset_id` int(11) DEFAULT NULL,
1031 `project_id` int(11) DEFAULT NULL,
1032 `collection_id` int(11) DEFAULT NULL,
1033 PRIMARY KEY (`id`),
1034 KEY `asset_id` (`asset_id`),
1035 KEY `project_id` (`project_id`),
1036 KEY `collection_id` (`collection_id`),
1037 CONSTRAINT `sequence_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
1038 CONSTRAINT `sequence_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
1039 CONSTRAINT `sequence_ibfk_3` FOREIGN KEY (`collection_id`) REFERENCES `collection` (`id`)
1040) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1041/*!40101 SET character_set_client = @saved_cs_client */;
1042
1043--
1044-- Table structure for table `sequences_accounts`
1045--
1046
1047DROP TABLE IF EXISTS `sequences_accounts`;
1048/*!40101 SET @saved_cs_client = @@character_set_client */;
1049/*!40101 SET character_set_client = utf8 */;
1050CREATE TABLE `sequences_accounts` (
1051 `id` int(11) NOT NULL AUTO_INCREMENT,
1052 `sequence_id` int(11) NOT NULL,
1053 `account_id` int(11) NOT NULL,
1054 PRIMARY KEY (`id`,`sequence_id`,`account_id`),
1055 KEY `sequence_id` (`sequence_id`),
1056 KEY `account_id` (`account_id`),
1057 CONSTRAINT `sequences_accounts_ibfk_1` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`),
1058 CONSTRAINT `sequences_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
1059) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1060/*!40101 SET character_set_client = @saved_cs_client */;
1061
1062--
1063-- Table structure for table `sequences_departements`
1064--
1065
1066DROP TABLE IF EXISTS `sequences_departements`;
1067/*!40101 SET @saved_cs_client = @@character_set_client */;
1068/*!40101 SET character_set_client = utf8 */;
1069CREATE TABLE `sequences_departements` (
1070 `id` int(11) NOT NULL AUTO_INCREMENT,
1071 `sequence_id` int(11) DEFAULT NULL,
1072 `departement_id` int(11) DEFAULT NULL,
1073 PRIMARY KEY (`id`),
1074 KEY `sequence_id` (`sequence_id`),
1075 KEY `departement_id` (`departement_id`),
1076 CONSTRAINT `sequences_departements_ibfk_1` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`),
1077 CONSTRAINT `sequences_departements_ibfk_2` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`)
1078) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1079/*!40101 SET character_set_client = @saved_cs_client */;
1080
1081--
1082-- Table structure for table `sequences_tags`
1083--
1084
1085DROP TABLE IF EXISTS `sequences_tags`;
1086/*!40101 SET @saved_cs_client = @@character_set_client */;
1087/*!40101 SET character_set_client = utf8 */;
1088CREATE TABLE `sequences_tags` (
1089 `id` int(11) NOT NULL AUTO_INCREMENT,
1090 `sequence_id` int(11) NOT NULL,
1091 `tag_id` int(11) NOT NULL,
1092 PRIMARY KEY (`id`,`sequence_id`,`tag_id`),
1093 KEY `sequence_id` (`sequence_id`),
1094 KEY `tag_id` (`tag_id`),
1095 CONSTRAINT `sequences_tags_ibfk_1` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`),
1096 CONSTRAINT `sequences_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
1097) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1098/*!40101 SET character_set_client = @saved_cs_client */;
1099
1100--
1101-- Table structure for table `shot`
1102--
1103
1104DROP TABLE IF EXISTS `shot`;
1105/*!40101 SET @saved_cs_client = @@character_set_client */;
1106/*!40101 SET character_set_client = utf8 */;
1107CREATE TABLE `shot` (
1108 `id` int(11) NOT NULL AUTO_INCREMENT,
1109 `uuid` varchar(64) DEFAULT NULL,
1110 `created_on` datetime DEFAULT NULL,
1111 `modified_on` datetime DEFAULT NULL,
1112 `cut_in` int(11) DEFAULT NULL,
1113 `cut_out` int(11) DEFAULT NULL,
1114 `number` int(11) NOT NULL,
1115 `name` varchar(64) NOT NULL,
1116 `code` varchar(64) NOT NULL,
1117 `timerate` int(11) DEFAULT NULL,
1118 `project_id` int(11) DEFAULT NULL,
1119 `asset_id` int(11) DEFAULT NULL,
1120 `collection_id` int(11) DEFAULT NULL,
1121 PRIMARY KEY (`id`),
1122 KEY `project_id` (`project_id`),
1123 KEY `asset_id` (`asset_id`),
1124 KEY `collection_id` (`collection_id`),
1125 CONSTRAINT `shot_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
1126 CONSTRAINT `shot_ibfk_2` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
1127 CONSTRAINT `shot_ibfk_3` FOREIGN KEY (`collection_id`) REFERENCES `collection` (`id`)
1128) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1129/*!40101 SET character_set_client = @saved_cs_client */;
1130
1131--
1132-- Table structure for table `shots_accounts`
1133--
1134
1135DROP TABLE IF EXISTS `shots_accounts`;
1136/*!40101 SET @saved_cs_client = @@character_set_client */;
1137/*!40101 SET character_set_client = utf8 */;
1138CREATE TABLE `shots_accounts` (
1139 `id` int(11) NOT NULL AUTO_INCREMENT,
1140 `shot_id` int(11) NOT NULL,
1141 `account_id` int(11) NOT NULL,
1142 PRIMARY KEY (`id`,`shot_id`,`account_id`),
1143 KEY `shot_id` (`shot_id`),
1144 KEY `account_id` (`account_id`),
1145 CONSTRAINT `shots_accounts_ibfk_1` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
1146 CONSTRAINT `shots_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
1147) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1148/*!40101 SET character_set_client = @saved_cs_client */;
1149
1150--
1151-- Table structure for table `shots_departements`
1152--
1153
1154DROP TABLE IF EXISTS `shots_departements`;
1155/*!40101 SET @saved_cs_client = @@character_set_client */;
1156/*!40101 SET character_set_client = utf8 */;
1157CREATE TABLE `shots_departements` (
1158 `id` int(11) NOT NULL AUTO_INCREMENT,
1159 `shot_id` int(11) DEFAULT NULL,
1160 `departement_id` int(11) DEFAULT NULL,
1161 PRIMARY KEY (`id`),
1162 KEY `shot_id` (`shot_id`),
1163 KEY `departement_id` (`departement_id`),
1164 CONSTRAINT `shots_departements_ibfk_1` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
1165 CONSTRAINT `shots_departements_ibfk_2` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`)
1166) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1167/*!40101 SET character_set_client = @saved_cs_client */;
1168
1169--
1170-- Table structure for table `shots_scenes`
1171--
1172
1173DROP TABLE IF EXISTS `shots_scenes`;
1174/*!40101 SET @saved_cs_client = @@character_set_client */;
1175/*!40101 SET character_set_client = utf8 */;
1176CREATE TABLE `shots_scenes` (
1177 `id` int(11) NOT NULL AUTO_INCREMENT,
1178 `shot_id` int(11) NOT NULL,
1179 `scene_id` int(11) NOT NULL,
1180 PRIMARY KEY (`id`,`shot_id`,`scene_id`),
1181 KEY `shot_id` (`shot_id`),
1182 KEY `scene_id` (`scene_id`),
1183 CONSTRAINT `shots_scenes_ibfk_1` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
1184 CONSTRAINT `shots_scenes_ibfk_2` FOREIGN KEY (`scene_id`) REFERENCES `scene` (`id`)
1185) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1186/*!40101 SET character_set_client = @saved_cs_client */;
1187
1188--
1189-- Table structure for table `shots_sequences`
1190--
1191
1192DROP TABLE IF EXISTS `shots_sequences`;
1193/*!40101 SET @saved_cs_client = @@character_set_client */;
1194/*!40101 SET character_set_client = utf8 */;
1195CREATE TABLE `shots_sequences` (
1196 `id` int(11) NOT NULL AUTO_INCREMENT,
1197 `shot_id` int(11) NOT NULL,
1198 `sequence_id` int(11) NOT NULL,
1199 PRIMARY KEY (`id`,`shot_id`,`sequence_id`),
1200 KEY `shot_id` (`shot_id`),
1201 KEY `sequence_id` (`sequence_id`),
1202 CONSTRAINT `shots_sequences_ibfk_1` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
1203 CONSTRAINT `shots_sequences_ibfk_2` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`)
1204) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1205/*!40101 SET character_set_client = @saved_cs_client */;
1206
1207--
1208-- Table structure for table `shots_tags`
1209--
1210
1211DROP TABLE IF EXISTS `shots_tags`;
1212/*!40101 SET @saved_cs_client = @@character_set_client */;
1213/*!40101 SET character_set_client = utf8 */;
1214CREATE TABLE `shots_tags` (
1215 `id` int(11) NOT NULL AUTO_INCREMENT,
1216 `shot_id` int(11) NOT NULL,
1217 `tag_id` int(11) NOT NULL,
1218 PRIMARY KEY (`id`,`shot_id`,`tag_id`),
1219 KEY `shot_id` (`shot_id`),
1220 KEY `tag_id` (`tag_id`),
1221 CONSTRAINT `shots_tags_ibfk_1` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
1222 CONSTRAINT `shots_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
1223) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1224/*!40101 SET character_set_client = @saved_cs_client */;
1225
1226--
1227-- Table structure for table `tag`
1228--
1229
1230DROP TABLE IF EXISTS `tag`;
1231/*!40101 SET @saved_cs_client = @@character_set_client */;
1232/*!40101 SET character_set_client = utf8 */;
1233CREATE TABLE `tag` (
1234 `uuid` varchar(64) DEFAULT NULL,
1235 `created_on` datetime DEFAULT NULL,
1236 `modified_on` datetime DEFAULT NULL,
1237 `id` int(11) NOT NULL AUTO_INCREMENT,
1238 `name` varchar(128) NOT NULL,
1239 `description` varchar(512) DEFAULT NULL,
1240 `parent_id` int(11) DEFAULT NULL,
1241 PRIMARY KEY (`id`),
1242 UNIQUE KEY `name` (`name`),
1243 KEY `parent_id` (`parent_id`),
1244 CONSTRAINT `tag_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `tag` (`id`)
1245) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
1246/*!40101 SET character_set_client = @saved_cs_client */;
1247
1248--
1249-- Table structure for table `task`
1250--
1251
1252DROP TABLE IF EXISTS `task`;
1253/*!40101 SET @saved_cs_client = @@character_set_client */;
1254/*!40101 SET character_set_client = utf8 */;
1255CREATE TABLE `task` (
1256 `uuid` varchar(64) DEFAULT NULL,
1257 `created_on` datetime DEFAULT NULL,
1258 `modified_on` datetime DEFAULT NULL,
1259 `id` int(11) NOT NULL AUTO_INCREMENT,
1260 `project_id` int(11) NOT NULL,
1261 `title` varchar(128) NOT NULL,
1262 `note` varchar(512) DEFAULT NULL,
1263 `description` varchar(512) DEFAULT NULL,
1264 `gauge` varchar(64) DEFAULT NULL,
1265 `start` datetime DEFAULT NULL,
1266 `computed_start` datetime DEFAULT NULL,
1267 `computed_end` datetime DEFAULT NULL,
1268 `end` datetime DEFAULT NULL,
1269 `duration` float DEFAULT NULL,
1270 `effort` float DEFAULT NULL,
1271 `effort_left` float DEFAULT NULL,
1272 `effort_done` float DEFAULT NULL,
1273 `length` float DEFAULT NULL,
1274 `criticalness` float DEFAULT NULL,
1275 `onstart_charge` float DEFAULT NULL,
1276 `active` tinyint(1) DEFAULT NULL,
1277 `onend_charge` float DEFAULT NULL,
1278 `milestone` tinyint(1) DEFAULT NULL,
1279 `parent_id` int(11) DEFAULT NULL,
1280 `priority` int(11) DEFAULT NULL,
1281 `complete` int(11) DEFAULT NULL,
1282 `computed_complete` int(11) DEFAULT NULL,
1283 PRIMARY KEY (`id`),
1284 KEY `project_id` (`project_id`),
1285 KEY `parent_id` (`parent_id`),
1286 CONSTRAINT `task_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
1287 CONSTRAINT `task_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `task` (`id`)
1288) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1289/*!40101 SET character_set_client = @saved_cs_client */;
1290
1291--
1292-- Table structure for table `task_alternative`
1293--
1294
1295DROP TABLE IF EXISTS `task_alternative`;
1296/*!40101 SET @saved_cs_client = @@character_set_client */;
1297/*!40101 SET character_set_client = utf8 */;
1298CREATE TABLE `task_alternative` (
1299 `id` int(11) NOT NULL AUTO_INCREMENT,
1300 `task_id` int(11) DEFAULT NULL,
1301 `user_id` int(11) DEFAULT NULL,
1302 PRIMARY KEY (`id`),
1303 KEY `task_id` (`task_id`),
1304 KEY `user_id` (`user_id`),
1305 CONSTRAINT `task_alternative_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
1306 CONSTRAINT `task_alternative_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
1307) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1308/*!40101 SET character_set_client = @saved_cs_client */;
1309
1310--
1311-- Table structure for table `task_relations`
1312--
1313
1314DROP TABLE IF EXISTS `task_relations`;
1315/*!40101 SET @saved_cs_client = @@character_set_client */;
1316/*!40101 SET character_set_client = utf8 */;
1317CREATE TABLE `task_relations` (
1318 `task_a_id` int(11) DEFAULT NULL,
1319 `task_b_id` int(11) DEFAULT NULL,
1320 KEY `task_a_id` (`task_a_id`),
1321 KEY `task_b_id` (`task_b_id`),
1322 CONSTRAINT `task_relations_ibfk_1` FOREIGN KEY (`task_a_id`) REFERENCES `task` (`id`),
1323 CONSTRAINT `task_relations_ibfk_2` FOREIGN KEY (`task_b_id`) REFERENCES `task` (`id`)
1324) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1325/*!40101 SET character_set_client = @saved_cs_client */;
1326
1327--
1328-- Table structure for table `task_responsible`
1329--
1330
1331DROP TABLE IF EXISTS `task_responsible`;
1332/*!40101 SET @saved_cs_client = @@character_set_client */;
1333/*!40101 SET character_set_client = utf8 */;
1334CREATE TABLE `task_responsible` (
1335 `id` int(11) NOT NULL AUTO_INCREMENT,
1336 `task_id` int(11) DEFAULT NULL,
1337 `user_id` int(11) DEFAULT NULL,
1338 PRIMARY KEY (`id`),
1339 KEY `task_id` (`task_id`),
1340 KEY `user_id` (`user_id`),
1341 CONSTRAINT `task_responsible_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
1342 CONSTRAINT `task_responsible_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
1343) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1344/*!40101 SET character_set_client = @saved_cs_client */;
1345
1346--
1347-- Table structure for table `task_users`
1348--
1349
1350DROP TABLE IF EXISTS `task_users`;
1351/*!40101 SET @saved_cs_client = @@character_set_client */;
1352/*!40101 SET character_set_client = utf8 */;
1353CREATE TABLE `task_users` (
1354 `id` int(11) NOT NULL AUTO_INCREMENT,
1355 `task_id` int(11) DEFAULT NULL,
1356 `user_id` int(11) DEFAULT NULL,
1357 PRIMARY KEY (`id`),
1358 KEY `task_id` (`task_id`),
1359 KEY `user_id` (`user_id`),
1360 CONSTRAINT `task_users_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
1361 CONSTRAINT `task_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
1362) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
1363/*!40101 SET character_set_client = @saved_cs_client */;
1364
1365--
1366-- Table structure for table `task_watchers`
1367--
1368
1369DROP TABLE IF EXISTS `task_watchers`;
1370/*!40101 SET @saved_cs_client = @@character_set_client */;
1371/*!40101 SET character_set_client = utf8 */;
1372CREATE TABLE `task_watchers` (
1373 `id` int(11) NOT NULL AUTO_INCREMENT,
1374 `task_id` int(11) DEFAULT NULL,
1375 `user_id` int(11) DEFAULT NULL,
1376 PRIMARY KEY (`id`),
1377 KEY `task_id` (`task_id`),
1378 KEY `user_id` (`user_id`),
1379 CONSTRAINT `task_watchers_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
1380 CONSTRAINT `task_watchers_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
1381) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1382/*!40101 SET character_set_client = @saved_cs_client */;
1383
1384--
1385-- Table structure for table `tasks_accounts`
1386--
1387
1388DROP TABLE IF EXISTS `tasks_accounts`;
1389/*!40101 SET @saved_cs_client = @@character_set_client */;
1390/*!40101 SET character_set_client = utf8 */;
1391CREATE TABLE `tasks_accounts` (
1392 `id` int(11) NOT NULL AUTO_INCREMENT,
1393 `task_id` int(11) NOT NULL,
1394 `account_id` int(11) NOT NULL,
1395 PRIMARY KEY (`id`,`task_id`,`account_id`),
1396 KEY `task_id` (`task_id`),
1397 KEY `account_id` (`account_id`),
1398 CONSTRAINT `tasks_accounts_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
1399 CONSTRAINT `tasks_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
1400) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1401/*!40101 SET character_set_client = @saved_cs_client */;
1402
1403--
1404-- Table structure for table `tasks_tags`
1405--
1406
1407DROP TABLE IF EXISTS `tasks_tags`;
1408/*!40101 SET @saved_cs_client = @@character_set_client */;
1409/*!40101 SET character_set_client = utf8 */;
1410CREATE TABLE `tasks_tags` (
1411 `id` int(11) NOT NULL AUTO_INCREMENT,
1412 `task_id` int(11) NOT NULL,
1413 `tag_id` int(11) NOT NULL,
1414 PRIMARY KEY (`id`,`task_id`,`tag_id`),
1415 KEY `task_id` (`task_id`),
1416 KEY `tag_id` (`tag_id`),
1417 CONSTRAINT `tasks_tags_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
1418 CONSTRAINT `tasks_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
1419) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1420/*!40101 SET character_set_client = @saved_cs_client */;
1421
1422--
1423-- Table structure for table `ticket`
1424--
1425
1426DROP TABLE IF EXISTS `ticket`;
1427/*!40101 SET @saved_cs_client = @@character_set_client */;
1428/*!40101 SET character_set_client = utf8 */;
1429CREATE TABLE `ticket` (
1430 `id` int(11) NOT NULL AUTO_INCREMENT,
1431 `uuid` varchar(64) DEFAULT NULL,
1432 `created_on` datetime DEFAULT NULL,
1433 `modified_on` datetime DEFAULT NULL,
1434 `project_id` int(11) DEFAULT NULL,
1435 `shot_id` int(11) DEFAULT NULL,
1436 `sequence_id` int(11) DEFAULT NULL,
1437 `ticket_type` varchar(32) DEFAULT NULL,
1438 `name` varchar(64) NOT NULL,
1439 `task_id` int(11) DEFAULT NULL,
1440 `asset_id` int(11) DEFAULT NULL,
1441 `ticketer_id` int(11) NOT NULL,
1442 PRIMARY KEY (`id`),
1443 KEY `project_id` (`project_id`),
1444 KEY `shot_id` (`shot_id`),
1445 KEY `sequence_id` (`sequence_id`),
1446 KEY `task_id` (`task_id`),
1447 KEY `asset_id` (`asset_id`),
1448 KEY `ticketer_id` (`ticketer_id`),
1449 CONSTRAINT `ticket_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`),
1450 CONSTRAINT `ticket_ibfk_2` FOREIGN KEY (`shot_id`) REFERENCES `shot` (`id`),
1451 CONSTRAINT `ticket_ibfk_3` FOREIGN KEY (`sequence_id`) REFERENCES `sequence` (`id`),
1452 CONSTRAINT `ticket_ibfk_4` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`),
1453 CONSTRAINT `ticket_ibfk_5` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`),
1454 CONSTRAINT `ticket_ibfk_6` FOREIGN KEY (`ticketer_id`) REFERENCES `user` (`id`)
1455) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1456/*!40101 SET character_set_client = @saved_cs_client */;
1457
1458--
1459-- Table structure for table `tickets_tags`
1460--
1461
1462DROP TABLE IF EXISTS `tickets_tags`;
1463/*!40101 SET @saved_cs_client = @@character_set_client */;
1464/*!40101 SET character_set_client = utf8 */;
1465CREATE TABLE `tickets_tags` (
1466 `id` int(11) NOT NULL AUTO_INCREMENT,
1467 `ticket_id` int(11) NOT NULL,
1468 `tag_id` int(11) NOT NULL,
1469 PRIMARY KEY (`id`,`ticket_id`,`tag_id`),
1470 KEY `ticket_id` (`ticket_id`),
1471 KEY `tag_id` (`tag_id`),
1472 CONSTRAINT `tickets_tags_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`),
1473 CONSTRAINT `tickets_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
1474) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1475/*!40101 SET character_set_client = @saved_cs_client */;
1476
1477--
1478-- Table structure for table `user`
1479--
1480
1481DROP TABLE IF EXISTS `user`;
1482/*!40101 SET @saved_cs_client = @@character_set_client */;
1483/*!40101 SET character_set_client = utf8 */;
1484CREATE TABLE `user` (
1485 `uuid` varchar(64) DEFAULT NULL,
1486 `created_on` datetime DEFAULT NULL,
1487 `modified_on` datetime DEFAULT NULL,
1488 `id` int(11) NOT NULL AUTO_INCREMENT,
1489 `email` varchar(64) NOT NULL,
1490 `paypal` varchar(64) DEFAULT NULL,
1491 `password` varbinary(1137) NOT NULL,
1492 `avatar` text,
1493 `token` varchar(64) DEFAULT NULL,
1494 `firstname` varchar(64) DEFAULT NULL,
1495 `job` varchar(64) DEFAULT NULL,
1496 `persian_firstname` varchar(64) DEFAULT NULL,
1497 `alias` varchar(64) DEFAULT NULL,
1498 `lastname` varchar(64) DEFAULT NULL,
1499 `persian_lastname` varchar(64) DEFAULT NULL,
1500 `hasFrequentPayment` tinyint(1) DEFAULT NULL,
1501 `payment_type` varchar(64) DEFAULT NULL,
1502 `lastLogIn` datetime DEFAULT NULL,
1503 `age` int(11) DEFAULT NULL,
1504 `efficiency` float DEFAULT NULL,
1505 `effectiveness` float DEFAULT NULL,
1506 `cell` varchar(16) DEFAULT NULL,
1507 `address` varchar(512) DEFAULT NULL,
1508 `budget_account` int(11) DEFAULT NULL,
1509 `bank` varchar(64) DEFAULT NULL,
1510 `bank_account_number` varchar(64) DEFAULT NULL,
1511 `debit_card_number` varchar(64) DEFAULT NULL,
1512 `daily_working_hours` int(11) DEFAULT NULL,
1513 `weeklymax` int(11) DEFAULT NULL,
1514 `monthly_working_hours` int(11) DEFAULT NULL,
1515 `monthly_present_hours` float DEFAULT NULL,
1516 `off_days` varchar(32) DEFAULT NULL,
1517 `latest_session_id` varchar(64) DEFAULT NULL,
1518 `active` tinyint(1) DEFAULT NULL,
1519 `fulltime` tinyint(1) DEFAULT NULL,
1520 `is_client` tinyint(1) DEFAULT NULL,
1521 `rate` float DEFAULT NULL,
1522 `monthly_salary` float DEFAULT NULL,
1523 `extra_payment` float DEFAULT NULL,
1524 `retention` float DEFAULT NULL,
1525 `payroll_tax` float DEFAULT NULL,
1526 `insurance_deductions` float DEFAULT NULL,
1527 PRIMARY KEY (`id`),
1528 UNIQUE KEY `email` (`email`),
1529 UNIQUE KEY `paypal` (`paypal`),
1530 UNIQUE KEY `token` (`token`)
1531) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1532/*!40101 SET character_set_client = @saved_cs_client */;
1533
1534--
1535-- Table structure for table `user_documents`
1536--
1537
1538DROP TABLE IF EXISTS `user_documents`;
1539/*!40101 SET @saved_cs_client = @@character_set_client */;
1540/*!40101 SET character_set_client = utf8 */;
1541CREATE TABLE `user_documents` (
1542 `user_id` int(11) NOT NULL,
1543 `document_id` int(11) NOT NULL,
1544 PRIMARY KEY (`user_id`,`document_id`),
1545 KEY `document_id` (`document_id`),
1546 CONSTRAINT `user_documents_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1547 CONSTRAINT `user_documents_ibfk_2` FOREIGN KEY (`document_id`) REFERENCES `document` (`id`)
1548) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1549/*!40101 SET character_set_client = @saved_cs_client */;
1550
1551--
1552-- Table structure for table `user_leaves`
1553--
1554
1555DROP TABLE IF EXISTS `user_leaves`;
1556/*!40101 SET @saved_cs_client = @@character_set_client */;
1557/*!40101 SET character_set_client = utf8 */;
1558CREATE TABLE `user_leaves` (
1559 `user_id` int(11) NOT NULL,
1560 `date_id` int(11) NOT NULL,
1561 PRIMARY KEY (`user_id`,`date_id`),
1562 KEY `date_id` (`date_id`),
1563 CONSTRAINT `user_leaves_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1564 CONSTRAINT `user_leaves_ibfk_2` FOREIGN KEY (`date_id`) REFERENCES `date` (`id`)
1565) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1566/*!40101 SET character_set_client = @saved_cs_client */;
1567
1568--
1569-- Table structure for table `user_offdays`
1570--
1571
1572DROP TABLE IF EXISTS `user_offdays`;
1573/*!40101 SET @saved_cs_client = @@character_set_client */;
1574/*!40101 SET character_set_client = utf8 */;
1575CREATE TABLE `user_offdays` (
1576 `user_id` int(11) NOT NULL,
1577 `date_id` int(11) NOT NULL,
1578 PRIMARY KEY (`user_id`,`date_id`),
1579 KEY `date_id` (`date_id`),
1580 CONSTRAINT `user_offdays_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1581 CONSTRAINT `user_offdays_ibfk_2` FOREIGN KEY (`date_id`) REFERENCES `date` (`id`)
1582) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1583/*!40101 SET character_set_client = @saved_cs_client */;
1584
1585--
1586-- Table structure for table `user_reports`
1587--
1588
1589DROP TABLE IF EXISTS `user_reports`;
1590/*!40101 SET @saved_cs_client = @@character_set_client */;
1591/*!40101 SET character_set_client = utf8 */;
1592CREATE TABLE `user_reports` (
1593 `user_id` int(11) NOT NULL,
1594 `report_id` int(11) NOT NULL,
1595 PRIMARY KEY (`user_id`,`report_id`),
1596 KEY `report_id` (`report_id`),
1597 CONSTRAINT `user_reports_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1598 CONSTRAINT `user_reports_ibfk_2` FOREIGN KEY (`report_id`) REFERENCES `report` (`id`)
1599) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1600/*!40101 SET character_set_client = @saved_cs_client */;
1601
1602--
1603-- Table structure for table `user_shifts`
1604--
1605
1606DROP TABLE IF EXISTS `user_shifts`;
1607/*!40101 SET @saved_cs_client = @@character_set_client */;
1608/*!40101 SET character_set_client = utf8 */;
1609CREATE TABLE `user_shifts` (
1610 `user_id` int(11) NOT NULL,
1611 `date_id` int(11) NOT NULL,
1612 PRIMARY KEY (`user_id`,`date_id`),
1613 KEY `date_id` (`date_id`),
1614 CONSTRAINT `user_shifts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1615 CONSTRAINT `user_shifts_ibfk_2` FOREIGN KEY (`date_id`) REFERENCES `date` (`id`)
1616) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1617/*!40101 SET character_set_client = @saved_cs_client */;
1618
1619--
1620-- Table structure for table `user_vacations`
1621--
1622
1623DROP TABLE IF EXISTS `user_vacations`;
1624/*!40101 SET @saved_cs_client = @@character_set_client */;
1625/*!40101 SET character_set_client = utf8 */;
1626CREATE TABLE `user_vacations` (
1627 `user_id` int(11) NOT NULL,
1628 `date_id` int(11) NOT NULL,
1629 PRIMARY KEY (`user_id`,`date_id`),
1630 KEY `date_id` (`date_id`),
1631 CONSTRAINT `user_vacations_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1632 CONSTRAINT `user_vacations_ibfk_2` FOREIGN KEY (`date_id`) REFERENCES `date` (`id`)
1633) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1634/*!40101 SET character_set_client = @saved_cs_client */;
1635
1636--
1637-- Table structure for table `users_accounts`
1638--
1639
1640DROP TABLE IF EXISTS `users_accounts`;
1641/*!40101 SET @saved_cs_client = @@character_set_client */;
1642/*!40101 SET character_set_client = utf8 */;
1643CREATE TABLE `users_accounts` (
1644 `user_id` int(11) NOT NULL,
1645 `account_id` int(11) NOT NULL,
1646 PRIMARY KEY (`user_id`,`account_id`),
1647 KEY `account_id` (`account_id`),
1648 CONSTRAINT `users_accounts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1649 CONSTRAINT `users_accounts_ibfk_2` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`)
1650) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1651/*!40101 SET character_set_client = @saved_cs_client */;
1652
1653--
1654-- Table structure for table `users_assets`
1655--
1656
1657DROP TABLE IF EXISTS `users_assets`;
1658/*!40101 SET @saved_cs_client = @@character_set_client */;
1659/*!40101 SET character_set_client = utf8 */;
1660CREATE TABLE `users_assets` (
1661 `id` int(11) NOT NULL AUTO_INCREMENT,
1662 `user_id` int(11) DEFAULT NULL,
1663 `asset_id` int(11) DEFAULT NULL,
1664 PRIMARY KEY (`id`),
1665 KEY `user_id` (`user_id`),
1666 KEY `asset_id` (`asset_id`),
1667 CONSTRAINT `users_assets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1668 CONSTRAINT `users_assets_ibfk_2` FOREIGN KEY (`asset_id`) REFERENCES `asset` (`id`)
1669) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1670/*!40101 SET character_set_client = @saved_cs_client */;
1671
1672--
1673-- Table structure for table `users_departements`
1674--
1675
1676DROP TABLE IF EXISTS `users_departements`;
1677/*!40101 SET @saved_cs_client = @@character_set_client */;
1678/*!40101 SET character_set_client = utf8 */;
1679CREATE TABLE `users_departements` (
1680 `user_id` int(11) NOT NULL,
1681 `departement_id` int(11) NOT NULL,
1682 PRIMARY KEY (`user_id`,`departement_id`),
1683 KEY `departement_id` (`departement_id`),
1684 CONSTRAINT `users_departements_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1685 CONSTRAINT `users_departements_ibfk_2` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`)
1686) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1687/*!40101 SET character_set_client = @saved_cs_client */;
1688
1689--
1690-- Table structure for table `users_expertise`
1691--
1692
1693DROP TABLE IF EXISTS `users_expertise`;
1694/*!40101 SET @saved_cs_client = @@character_set_client */;
1695/*!40101 SET character_set_client = utf8 */;
1696CREATE TABLE `users_expertise` (
1697 `user_id` int(11) NOT NULL,
1698 `expert_id` int(11) NOT NULL,
1699 PRIMARY KEY (`user_id`,`expert_id`),
1700 KEY `expert_id` (`expert_id`),
1701 CONSTRAINT `users_expertise_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1702 CONSTRAINT `users_expertise_ibfk_2` FOREIGN KEY (`expert_id`) REFERENCES `expert` (`id`)
1703) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1704/*!40101 SET character_set_client = @saved_cs_client */;
1705
1706--
1707-- Table structure for table `users_groups`
1708--
1709
1710DROP TABLE IF EXISTS `users_groups`;
1711/*!40101 SET @saved_cs_client = @@character_set_client */;
1712/*!40101 SET character_set_client = utf8 */;
1713CREATE TABLE `users_groups` (
1714 `id` int(11) NOT NULL AUTO_INCREMENT,
1715 `user_id` int(11) DEFAULT NULL,
1716 `group_id` int(11) DEFAULT NULL,
1717 PRIMARY KEY (`id`),
1718 KEY `user_id` (`user_id`),
1719 KEY `group_id` (`group_id`),
1720 CONSTRAINT `users_groups_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1721 CONSTRAINT `users_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`)
1722) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1723/*!40101 SET character_set_client = @saved_cs_client */;
1724
1725--
1726-- Table structure for table `users_tags`
1727--
1728
1729DROP TABLE IF EXISTS `users_tags`;
1730/*!40101 SET @saved_cs_client = @@character_set_client */;
1731/*!40101 SET character_set_client = utf8 */;
1732CREATE TABLE `users_tags` (
1733 `user_id` int(11) NOT NULL,
1734 `tag_id` int(11) NOT NULL,
1735 PRIMARY KEY (`user_id`,`tag_id`),
1736 KEY `tag_id` (`tag_id`),
1737 CONSTRAINT `users_tags_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
1738 CONSTRAINT `users_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
1739) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1740/*!40101 SET character_set_client = @saved_cs_client */;
1741
1742--
1743-- Table structure for table `version`
1744--
1745
1746DROP TABLE IF EXISTS `version`;
1747/*!40101 SET @saved_cs_client = @@character_set_client */;
1748/*!40101 SET character_set_client = utf8 */;
1749CREATE TABLE `version` (
1750 `id` int(11) NOT NULL AUTO_INCREMENT,
1751 `uuid` varchar(64) DEFAULT NULL,
1752 `created_on` datetime DEFAULT NULL,
1753 `modified_on` datetime DEFAULT NULL,
1754 `take_name` varchar(255) NOT NULL,
1755 `number` int(11) DEFAULT NULL,
1756 `is_published` tinyint(1) DEFAULT NULL,
1757 `task_id` int(11) DEFAULT NULL,
1758 PRIMARY KEY (`id`),
1759 KEY `task_id` (`task_id`),
1760 CONSTRAINT `version_ibfk_1` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
1761) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1762/*!40101 SET character_set_client = @saved_cs_client */;
1763
1764--
1765-- Table structure for table `versions_tags`
1766--
1767
1768DROP TABLE IF EXISTS `versions_tags`;
1769/*!40101 SET @saved_cs_client = @@character_set_client */;
1770/*!40101 SET character_set_client = utf8 */;
1771CREATE TABLE `versions_tags` (
1772 `id` int(11) NOT NULL AUTO_INCREMENT,
1773 `version_id` int(11) NOT NULL,
1774 `tag_id` int(11) NOT NULL,
1775 PRIMARY KEY (`id`,`version_id`,`tag_id`),
1776 KEY `version_id` (`version_id`),
1777 KEY `tag_id` (`tag_id`),
1778 CONSTRAINT `versions_tags_ibfk_1` FOREIGN KEY (`version_id`) REFERENCES `version` (`id`),
1779 CONSTRAINT `versions_tags_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`)
1780) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1781/*!40101 SET character_set_client = @saved_cs_client */;
1782/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1783
1784/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1785/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1786/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1787/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1788/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1789/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1790/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1791
1792-- Dump completed on 2019-10-07 21:03:49