· 8 years ago · Apr 11, 2018, 01:18 AM
1-- MySQL dump 10.13 Distrib 5.5.35, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: redmine
4-- ------------------------------------------------------
5-- Server version 5.5.35-0+wheezy1
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 `attachments`
20--
21
22DROP TABLE IF EXISTS `attachments`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `attachments` (
26 `id` int(11) NOT NULL AUTO_INCREMENT,
27 `container_id` int(11) DEFAULT NULL,
28 `container_type` varchar(30) DEFAULT NULL,
29 `filename` varchar(255) NOT NULL DEFAULT '',
30 `disk_filename` varchar(255) NOT NULL DEFAULT '',
31 `filesize` int(11) NOT NULL DEFAULT '0',
32 `content_type` varchar(255) DEFAULT '',
33 `digest` varchar(40) NOT NULL DEFAULT '',
34 `downloads` int(11) NOT NULL DEFAULT '0',
35 `author_id` int(11) NOT NULL DEFAULT '0',
36 `created_on` datetime DEFAULT NULL,
37 `description` varchar(255) DEFAULT NULL,
38 `disk_directory` varchar(255) DEFAULT NULL,
39 PRIMARY KEY (`id`),
40 KEY `index_attachments_on_author_id` (`author_id`),
41 KEY `index_attachments_on_created_on` (`created_on`),
42 KEY `index_attachments_on_container_id_and_container_type` (`container_id`,`container_type`)
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44/*!40101 SET character_set_client = @saved_cs_client */;
45
46--
47-- Dumping data for table `attachments`
48--
49
50LOCK TABLES `attachments` WRITE;
51/*!40000 ALTER TABLE `attachments` DISABLE KEYS */;
52/*!40000 ALTER TABLE `attachments` ENABLE KEYS */;
53UNLOCK TABLES;
54
55--
56-- Table structure for table `auth_sources`
57--
58
59DROP TABLE IF EXISTS `auth_sources`;
60/*!40101 SET @saved_cs_client = @@character_set_client */;
61/*!40101 SET character_set_client = utf8 */;
62CREATE TABLE `auth_sources` (
63 `id` int(11) NOT NULL AUTO_INCREMENT,
64 `type` varchar(30) NOT NULL DEFAULT '',
65 `name` varchar(60) NOT NULL DEFAULT '',
66 `host` varchar(60) DEFAULT NULL,
67 `port` int(11) DEFAULT NULL,
68 `account` varchar(255) DEFAULT NULL,
69 `account_password` varchar(255) DEFAULT '',
70 `base_dn` varchar(255) DEFAULT NULL,
71 `attr_login` varchar(30) DEFAULT NULL,
72 `attr_firstname` varchar(30) DEFAULT NULL,
73 `attr_lastname` varchar(30) DEFAULT NULL,
74 `attr_mail` varchar(30) DEFAULT NULL,
75 `onthefly_register` tinyint(1) NOT NULL DEFAULT '0',
76 `tls` tinyint(1) NOT NULL DEFAULT '0',
77 `filter` varchar(255) DEFAULT NULL,
78 `timeout` int(11) DEFAULT NULL,
79 PRIMARY KEY (`id`),
80 KEY `index_auth_sources_on_id_and_type` (`id`,`type`)
81) ENGINE=InnoDB DEFAULT CHARSET=latin1;
82/*!40101 SET character_set_client = @saved_cs_client */;
83
84--
85-- Dumping data for table `auth_sources`
86--
87
88LOCK TABLES `auth_sources` WRITE;
89/*!40000 ALTER TABLE `auth_sources` DISABLE KEYS */;
90/*!40000 ALTER TABLE `auth_sources` ENABLE KEYS */;
91UNLOCK TABLES;
92
93--
94-- Table structure for table `boards`
95--
96
97DROP TABLE IF EXISTS `boards`;
98/*!40101 SET @saved_cs_client = @@character_set_client */;
99/*!40101 SET character_set_client = utf8 */;
100CREATE TABLE `boards` (
101 `id` int(11) NOT NULL AUTO_INCREMENT,
102 `project_id` int(11) NOT NULL,
103 `name` varchar(255) NOT NULL DEFAULT '',
104 `description` varchar(255) DEFAULT NULL,
105 `position` int(11) DEFAULT '1',
106 `topics_count` int(11) NOT NULL DEFAULT '0',
107 `messages_count` int(11) NOT NULL DEFAULT '0',
108 `last_message_id` int(11) DEFAULT NULL,
109 `parent_id` int(11) DEFAULT NULL,
110 PRIMARY KEY (`id`),
111 KEY `boards_project_id` (`project_id`),
112 KEY `index_boards_on_last_message_id` (`last_message_id`)
113) ENGINE=InnoDB DEFAULT CHARSET=latin1;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `boards`
118--
119
120LOCK TABLES `boards` WRITE;
121/*!40000 ALTER TABLE `boards` DISABLE KEYS */;
122/*!40000 ALTER TABLE `boards` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `changes`
127--
128
129DROP TABLE IF EXISTS `changes`;
130/*!40101 SET @saved_cs_client = @@character_set_client */;
131/*!40101 SET character_set_client = utf8 */;
132CREATE TABLE `changes` (
133 `id` int(11) NOT NULL AUTO_INCREMENT,
134 `changeset_id` int(11) NOT NULL,
135 `action` varchar(1) NOT NULL DEFAULT '',
136 `path` text NOT NULL,
137 `from_path` text,
138 `from_revision` varchar(255) DEFAULT NULL,
139 `revision` varchar(255) DEFAULT NULL,
140 `branch` varchar(255) DEFAULT NULL,
141 PRIMARY KEY (`id`),
142 KEY `changesets_changeset_id` (`changeset_id`)
143) ENGINE=InnoDB DEFAULT CHARSET=latin1;
144/*!40101 SET character_set_client = @saved_cs_client */;
145
146--
147-- Dumping data for table `changes`
148--
149
150LOCK TABLES `changes` WRITE;
151/*!40000 ALTER TABLE `changes` DISABLE KEYS */;
152/*!40000 ALTER TABLE `changes` ENABLE KEYS */;
153UNLOCK TABLES;
154
155--
156-- Table structure for table `changeset_parents`
157--
158
159DROP TABLE IF EXISTS `changeset_parents`;
160/*!40101 SET @saved_cs_client = @@character_set_client */;
161/*!40101 SET character_set_client = utf8 */;
162CREATE TABLE `changeset_parents` (
163 `changeset_id` int(11) NOT NULL,
164 `parent_id` int(11) NOT NULL,
165 KEY `changeset_parents_changeset_ids` (`changeset_id`),
166 KEY `changeset_parents_parent_ids` (`parent_id`)
167) ENGINE=InnoDB DEFAULT CHARSET=latin1;
168/*!40101 SET character_set_client = @saved_cs_client */;
169
170--
171-- Dumping data for table `changeset_parents`
172--
173
174LOCK TABLES `changeset_parents` WRITE;
175/*!40000 ALTER TABLE `changeset_parents` DISABLE KEYS */;
176/*!40000 ALTER TABLE `changeset_parents` ENABLE KEYS */;
177UNLOCK TABLES;
178
179--
180-- Table structure for table `changesets`
181--
182
183DROP TABLE IF EXISTS `changesets`;
184/*!40101 SET @saved_cs_client = @@character_set_client */;
185/*!40101 SET character_set_client = utf8 */;
186CREATE TABLE `changesets` (
187 `id` int(11) NOT NULL AUTO_INCREMENT,
188 `repository_id` int(11) NOT NULL,
189 `revision` varchar(255) NOT NULL,
190 `committer` varchar(255) DEFAULT NULL,
191 `committed_on` datetime NOT NULL,
192 `comments` longtext,
193 `commit_date` date DEFAULT NULL,
194 `scmid` varchar(255) DEFAULT NULL,
195 `user_id` int(11) DEFAULT NULL,
196 PRIMARY KEY (`id`),
197 UNIQUE KEY `changesets_repos_rev` (`repository_id`,`revision`),
198 KEY `index_changesets_on_user_id` (`user_id`),
199 KEY `index_changesets_on_repository_id` (`repository_id`),
200 KEY `index_changesets_on_committed_on` (`committed_on`),
201 KEY `changesets_repos_scmid` (`repository_id`,`scmid`)
202) ENGINE=InnoDB DEFAULT CHARSET=latin1;
203/*!40101 SET character_set_client = @saved_cs_client */;
204
205--
206-- Dumping data for table `changesets`
207--
208
209LOCK TABLES `changesets` WRITE;
210/*!40000 ALTER TABLE `changesets` DISABLE KEYS */;
211/*!40000 ALTER TABLE `changesets` ENABLE KEYS */;
212UNLOCK TABLES;
213
214--
215-- Table structure for table `changesets_issues`
216--
217
218DROP TABLE IF EXISTS `changesets_issues`;
219/*!40101 SET @saved_cs_client = @@character_set_client */;
220/*!40101 SET character_set_client = utf8 */;
221CREATE TABLE `changesets_issues` (
222 `changeset_id` int(11) NOT NULL,
223 `issue_id` int(11) NOT NULL,
224 UNIQUE KEY `changesets_issues_ids` (`changeset_id`,`issue_id`)
225) ENGINE=InnoDB DEFAULT CHARSET=latin1;
226/*!40101 SET character_set_client = @saved_cs_client */;
227
228--
229-- Dumping data for table `changesets_issues`
230--
231
232LOCK TABLES `changesets_issues` WRITE;
233/*!40000 ALTER TABLE `changesets_issues` DISABLE KEYS */;
234/*!40000 ALTER TABLE `changesets_issues` ENABLE KEYS */;
235UNLOCK TABLES;
236
237--
238-- Table structure for table `comments`
239--
240
241DROP TABLE IF EXISTS `comments`;
242/*!40101 SET @saved_cs_client = @@character_set_client */;
243/*!40101 SET character_set_client = utf8 */;
244CREATE TABLE `comments` (
245 `id` int(11) NOT NULL AUTO_INCREMENT,
246 `commented_type` varchar(30) NOT NULL DEFAULT '',
247 `commented_id` int(11) NOT NULL DEFAULT '0',
248 `author_id` int(11) NOT NULL DEFAULT '0',
249 `comments` text,
250 `created_on` datetime NOT NULL,
251 `updated_on` datetime NOT NULL,
252 PRIMARY KEY (`id`),
253 KEY `index_comments_on_commented_id_and_commented_type` (`commented_id`,`commented_type`),
254 KEY `index_comments_on_author_id` (`author_id`)
255) ENGINE=InnoDB DEFAULT CHARSET=latin1;
256/*!40101 SET character_set_client = @saved_cs_client */;
257
258--
259-- Dumping data for table `comments`
260--
261
262LOCK TABLES `comments` WRITE;
263/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
264/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
265UNLOCK TABLES;
266
267--
268-- Table structure for table `custom_fields`
269--
270
271DROP TABLE IF EXISTS `custom_fields`;
272/*!40101 SET @saved_cs_client = @@character_set_client */;
273/*!40101 SET character_set_client = utf8 */;
274CREATE TABLE `custom_fields` (
275 `id` int(11) NOT NULL AUTO_INCREMENT,
276 `type` varchar(30) NOT NULL DEFAULT '',
277 `name` varchar(30) NOT NULL DEFAULT '',
278 `field_format` varchar(30) NOT NULL DEFAULT '',
279 `possible_values` text,
280 `regexp` varchar(255) DEFAULT '',
281 `min_length` int(11) DEFAULT NULL,
282 `max_length` int(11) DEFAULT NULL,
283 `is_required` tinyint(1) NOT NULL DEFAULT '0',
284 `is_for_all` tinyint(1) NOT NULL DEFAULT '0',
285 `is_filter` tinyint(1) NOT NULL DEFAULT '0',
286 `position` int(11) DEFAULT '1',
287 `searchable` tinyint(1) DEFAULT '0',
288 `default_value` text,
289 `editable` tinyint(1) DEFAULT '1',
290 `visible` tinyint(1) NOT NULL DEFAULT '1',
291 `multiple` tinyint(1) DEFAULT '0',
292 `format_store` text,
293 `description` text,
294 PRIMARY KEY (`id`),
295 KEY `index_custom_fields_on_id_and_type` (`id`,`type`)
296) ENGINE=InnoDB DEFAULT CHARSET=latin1;
297/*!40101 SET character_set_client = @saved_cs_client */;
298
299--
300-- Dumping data for table `custom_fields`
301--
302
303LOCK TABLES `custom_fields` WRITE;
304/*!40000 ALTER TABLE `custom_fields` DISABLE KEYS */;
305/*!40000 ALTER TABLE `custom_fields` ENABLE KEYS */;
306UNLOCK TABLES;
307
308--
309-- Table structure for table `custom_fields_projects`
310--
311
312DROP TABLE IF EXISTS `custom_fields_projects`;
313/*!40101 SET @saved_cs_client = @@character_set_client */;
314/*!40101 SET character_set_client = utf8 */;
315CREATE TABLE `custom_fields_projects` (
316 `custom_field_id` int(11) NOT NULL DEFAULT '0',
317 `project_id` int(11) NOT NULL DEFAULT '0',
318 UNIQUE KEY `index_custom_fields_projects_on_custom_field_id_and_project_id` (`custom_field_id`,`project_id`)
319) ENGINE=InnoDB DEFAULT CHARSET=latin1;
320/*!40101 SET character_set_client = @saved_cs_client */;
321
322--
323-- Dumping data for table `custom_fields_projects`
324--
325
326LOCK TABLES `custom_fields_projects` WRITE;
327/*!40000 ALTER TABLE `custom_fields_projects` DISABLE KEYS */;
328/*!40000 ALTER TABLE `custom_fields_projects` ENABLE KEYS */;
329UNLOCK TABLES;
330
331--
332-- Table structure for table `custom_fields_roles`
333--
334
335DROP TABLE IF EXISTS `custom_fields_roles`;
336/*!40101 SET @saved_cs_client = @@character_set_client */;
337/*!40101 SET character_set_client = utf8 */;
338CREATE TABLE `custom_fields_roles` (
339 `custom_field_id` int(11) NOT NULL,
340 `role_id` int(11) NOT NULL,
341 UNIQUE KEY `custom_fields_roles_ids` (`custom_field_id`,`role_id`)
342) ENGINE=InnoDB DEFAULT CHARSET=latin1;
343/*!40101 SET character_set_client = @saved_cs_client */;
344
345--
346-- Dumping data for table `custom_fields_roles`
347--
348
349LOCK TABLES `custom_fields_roles` WRITE;
350/*!40000 ALTER TABLE `custom_fields_roles` DISABLE KEYS */;
351/*!40000 ALTER TABLE `custom_fields_roles` ENABLE KEYS */;
352UNLOCK TABLES;
353
354--
355-- Table structure for table `custom_fields_trackers`
356--
357
358DROP TABLE IF EXISTS `custom_fields_trackers`;
359/*!40101 SET @saved_cs_client = @@character_set_client */;
360/*!40101 SET character_set_client = utf8 */;
361CREATE TABLE `custom_fields_trackers` (
362 `custom_field_id` int(11) NOT NULL DEFAULT '0',
363 `tracker_id` int(11) NOT NULL DEFAULT '0',
364 UNIQUE KEY `index_custom_fields_trackers_on_custom_field_id_and_tracker_id` (`custom_field_id`,`tracker_id`)
365) ENGINE=InnoDB DEFAULT CHARSET=latin1;
366/*!40101 SET character_set_client = @saved_cs_client */;
367
368--
369-- Dumping data for table `custom_fields_trackers`
370--
371
372LOCK TABLES `custom_fields_trackers` WRITE;
373/*!40000 ALTER TABLE `custom_fields_trackers` DISABLE KEYS */;
374/*!40000 ALTER TABLE `custom_fields_trackers` ENABLE KEYS */;
375UNLOCK TABLES;
376
377--
378-- Table structure for table `custom_values`
379--
380
381DROP TABLE IF EXISTS `custom_values`;
382/*!40101 SET @saved_cs_client = @@character_set_client */;
383/*!40101 SET character_set_client = utf8 */;
384CREATE TABLE `custom_values` (
385 `id` int(11) NOT NULL AUTO_INCREMENT,
386 `customized_type` varchar(30) NOT NULL DEFAULT '',
387 `customized_id` int(11) NOT NULL DEFAULT '0',
388 `custom_field_id` int(11) NOT NULL DEFAULT '0',
389 `value` text,
390 PRIMARY KEY (`id`),
391 KEY `custom_values_customized` (`customized_type`,`customized_id`),
392 KEY `index_custom_values_on_custom_field_id` (`custom_field_id`)
393) ENGINE=InnoDB DEFAULT CHARSET=latin1;
394/*!40101 SET character_set_client = @saved_cs_client */;
395
396--
397-- Dumping data for table `custom_values`
398--
399
400LOCK TABLES `custom_values` WRITE;
401/*!40000 ALTER TABLE `custom_values` DISABLE KEYS */;
402/*!40000 ALTER TABLE `custom_values` ENABLE KEYS */;
403UNLOCK TABLES;
404
405--
406-- Table structure for table `documents`
407--
408
409DROP TABLE IF EXISTS `documents`;
410/*!40101 SET @saved_cs_client = @@character_set_client */;
411/*!40101 SET character_set_client = utf8 */;
412CREATE TABLE `documents` (
413 `id` int(11) NOT NULL AUTO_INCREMENT,
414 `project_id` int(11) NOT NULL DEFAULT '0',
415 `category_id` int(11) NOT NULL DEFAULT '0',
416 `title` varchar(60) NOT NULL DEFAULT '',
417 `description` text,
418 `created_on` datetime DEFAULT NULL,
419 PRIMARY KEY (`id`),
420 KEY `documents_project_id` (`project_id`),
421 KEY `index_documents_on_category_id` (`category_id`),
422 KEY `index_documents_on_created_on` (`created_on`)
423) ENGINE=InnoDB DEFAULT CHARSET=latin1;
424/*!40101 SET character_set_client = @saved_cs_client */;
425
426--
427-- Dumping data for table `documents`
428--
429
430LOCK TABLES `documents` WRITE;
431/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
432/*!40000 ALTER TABLE `documents` ENABLE KEYS */;
433UNLOCK TABLES;
434
435--
436-- Table structure for table `enabled_modules`
437--
438
439DROP TABLE IF EXISTS `enabled_modules`;
440/*!40101 SET @saved_cs_client = @@character_set_client */;
441/*!40101 SET character_set_client = utf8 */;
442CREATE TABLE `enabled_modules` (
443 `id` int(11) NOT NULL AUTO_INCREMENT,
444 `project_id` int(11) DEFAULT NULL,
445 `name` varchar(255) NOT NULL,
446 PRIMARY KEY (`id`),
447 KEY `enabled_modules_project_id` (`project_id`)
448) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
449/*!40101 SET character_set_client = @saved_cs_client */;
450
451--
452-- Dumping data for table `enabled_modules`
453--
454
455LOCK TABLES `enabled_modules` WRITE;
456/*!40000 ALTER TABLE `enabled_modules` DISABLE KEYS */;
457INSERT INTO `enabled_modules` VALUES (1,1,'issue_tracking'),(2,1,'time_tracking'),(3,1,'news'),(4,1,'documents'),(5,1,'files'),(6,1,'wiki'),(7,1,'repository'),(8,1,'boards'),(9,1,'calendar'),(10,1,'gantt');
458/*!40000 ALTER TABLE `enabled_modules` ENABLE KEYS */;
459UNLOCK TABLES;
460
461--
462-- Table structure for table `enumerations`
463--
464
465DROP TABLE IF EXISTS `enumerations`;
466/*!40101 SET @saved_cs_client = @@character_set_client */;
467/*!40101 SET character_set_client = utf8 */;
468CREATE TABLE `enumerations` (
469 `id` int(11) NOT NULL AUTO_INCREMENT,
470 `name` varchar(30) NOT NULL DEFAULT '',
471 `position` int(11) DEFAULT '1',
472 `is_default` tinyint(1) NOT NULL DEFAULT '0',
473 `type` varchar(255) DEFAULT NULL,
474 `active` tinyint(1) NOT NULL DEFAULT '1',
475 `project_id` int(11) DEFAULT NULL,
476 `parent_id` int(11) DEFAULT NULL,
477 `position_name` varchar(30) DEFAULT NULL,
478 PRIMARY KEY (`id`),
479 KEY `index_enumerations_on_project_id` (`project_id`),
480 KEY `index_enumerations_on_id_and_type` (`id`,`type`)
481) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
482/*!40101 SET character_set_client = @saved_cs_client */;
483
484--
485-- Dumping data for table `enumerations`
486--
487
488LOCK TABLES `enumerations` WRITE;
489/*!40000 ALTER TABLE `enumerations` DISABLE KEYS */;
490INSERT INTO `enumerations` VALUES (1,'Bas',1,0,'IssuePriority',1,NULL,NULL,'lowest'),(2,'Normal',2,1,'IssuePriority',1,NULL,NULL,'default'),(3,'Haut',3,0,'IssuePriority',1,NULL,NULL,'high3'),(4,'Urgent',4,0,'IssuePriority',1,NULL,NULL,'high2'),(5,'Immédiat',5,0,'IssuePriority',1,NULL,NULL,'highest'),(6,'Documentation utilisateur',1,0,'DocumentCategory',1,NULL,NULL,NULL),(7,'Documentation technique',2,0,'DocumentCategory',1,NULL,NULL,NULL),(8,'Conception',1,0,'TimeEntryActivity',1,NULL,NULL,NULL),(9,'Développement',2,0,'TimeEntryActivity',1,NULL,NULL,NULL);
491/*!40000 ALTER TABLE `enumerations` ENABLE KEYS */;
492UNLOCK TABLES;
493
494--
495-- Table structure for table `groups_users`
496--
497
498DROP TABLE IF EXISTS `groups_users`;
499/*!40101 SET @saved_cs_client = @@character_set_client */;
500/*!40101 SET character_set_client = utf8 */;
501CREATE TABLE `groups_users` (
502 `group_id` int(11) NOT NULL,
503 `user_id` int(11) NOT NULL,
504 UNIQUE KEY `groups_users_ids` (`group_id`,`user_id`)
505) ENGINE=InnoDB DEFAULT CHARSET=latin1;
506/*!40101 SET character_set_client = @saved_cs_client */;
507
508--
509-- Dumping data for table `groups_users`
510--
511
512LOCK TABLES `groups_users` WRITE;
513/*!40000 ALTER TABLE `groups_users` DISABLE KEYS */;
514/*!40000 ALTER TABLE `groups_users` ENABLE KEYS */;
515UNLOCK TABLES;
516
517--
518-- Table structure for table `issue_categories`
519--
520
521DROP TABLE IF EXISTS `issue_categories`;
522/*!40101 SET @saved_cs_client = @@character_set_client */;
523/*!40101 SET character_set_client = utf8 */;
524CREATE TABLE `issue_categories` (
525 `id` int(11) NOT NULL AUTO_INCREMENT,
526 `project_id` int(11) NOT NULL DEFAULT '0',
527 `name` varchar(30) NOT NULL DEFAULT '',
528 `assigned_to_id` int(11) DEFAULT NULL,
529 PRIMARY KEY (`id`),
530 KEY `issue_categories_project_id` (`project_id`),
531 KEY `index_issue_categories_on_assigned_to_id` (`assigned_to_id`)
532) ENGINE=InnoDB DEFAULT CHARSET=latin1;
533/*!40101 SET character_set_client = @saved_cs_client */;
534
535--
536-- Dumping data for table `issue_categories`
537--
538
539LOCK TABLES `issue_categories` WRITE;
540/*!40000 ALTER TABLE `issue_categories` DISABLE KEYS */;
541/*!40000 ALTER TABLE `issue_categories` ENABLE KEYS */;
542UNLOCK TABLES;
543
544--
545-- Table structure for table `issue_relations`
546--
547
548DROP TABLE IF EXISTS `issue_relations`;
549/*!40101 SET @saved_cs_client = @@character_set_client */;
550/*!40101 SET character_set_client = utf8 */;
551CREATE TABLE `issue_relations` (
552 `id` int(11) NOT NULL AUTO_INCREMENT,
553 `issue_from_id` int(11) NOT NULL,
554 `issue_to_id` int(11) NOT NULL,
555 `relation_type` varchar(255) NOT NULL DEFAULT '',
556 `delay` int(11) DEFAULT NULL,
557 PRIMARY KEY (`id`),
558 UNIQUE KEY `index_issue_relations_on_issue_from_id_and_issue_to_id` (`issue_from_id`,`issue_to_id`),
559 KEY `index_issue_relations_on_issue_from_id` (`issue_from_id`),
560 KEY `index_issue_relations_on_issue_to_id` (`issue_to_id`)
561) ENGINE=InnoDB DEFAULT CHARSET=latin1;
562/*!40101 SET character_set_client = @saved_cs_client */;
563
564--
565-- Dumping data for table `issue_relations`
566--
567
568LOCK TABLES `issue_relations` WRITE;
569/*!40000 ALTER TABLE `issue_relations` DISABLE KEYS */;
570/*!40000 ALTER TABLE `issue_relations` ENABLE KEYS */;
571UNLOCK TABLES;
572
573--
574-- Table structure for table `issue_statuses`
575--
576
577DROP TABLE IF EXISTS `issue_statuses`;
578/*!40101 SET @saved_cs_client = @@character_set_client */;
579/*!40101 SET character_set_client = utf8 */;
580CREATE TABLE `issue_statuses` (
581 `id` int(11) NOT NULL AUTO_INCREMENT,
582 `name` varchar(30) NOT NULL DEFAULT '',
583 `is_closed` tinyint(1) NOT NULL DEFAULT '0',
584 `is_default` tinyint(1) NOT NULL DEFAULT '0',
585 `position` int(11) DEFAULT '1',
586 `default_done_ratio` int(11) DEFAULT NULL,
587 PRIMARY KEY (`id`),
588 KEY `index_issue_statuses_on_position` (`position`),
589 KEY `index_issue_statuses_on_is_closed` (`is_closed`),
590 KEY `index_issue_statuses_on_is_default` (`is_default`)
591) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
592/*!40101 SET character_set_client = @saved_cs_client */;
593
594--
595-- Dumping data for table `issue_statuses`
596--
597
598LOCK TABLES `issue_statuses` WRITE;
599/*!40000 ALTER TABLE `issue_statuses` DISABLE KEYS */;
600INSERT INTO `issue_statuses` VALUES (1,'Nouveau',0,1,1,NULL),(2,'En cours',0,0,2,NULL),(3,'Résolu',0,0,3,NULL),(4,'Commentaire',0,0,4,NULL),(5,'Fermé',1,0,5,NULL),(6,'Rejeté',1,0,6,NULL);
601/*!40000 ALTER TABLE `issue_statuses` ENABLE KEYS */;
602UNLOCK TABLES;
603
604--
605-- Table structure for table `issues`
606--
607
608DROP TABLE IF EXISTS `issues`;
609/*!40101 SET @saved_cs_client = @@character_set_client */;
610/*!40101 SET character_set_client = utf8 */;
611CREATE TABLE `issues` (
612 `id` int(11) NOT NULL AUTO_INCREMENT,
613 `tracker_id` int(11) NOT NULL,
614 `project_id` int(11) NOT NULL,
615 `subject` varchar(255) NOT NULL DEFAULT '',
616 `description` text,
617 `due_date` date DEFAULT NULL,
618 `category_id` int(11) DEFAULT NULL,
619 `status_id` int(11) NOT NULL,
620 `assigned_to_id` int(11) DEFAULT NULL,
621 `priority_id` int(11) NOT NULL,
622 `fixed_version_id` int(11) DEFAULT NULL,
623 `author_id` int(11) NOT NULL,
624 `lock_version` int(11) NOT NULL DEFAULT '0',
625 `created_on` datetime DEFAULT NULL,
626 `updated_on` datetime DEFAULT NULL,
627 `start_date` date DEFAULT NULL,
628 `done_ratio` int(11) NOT NULL DEFAULT '0',
629 `estimated_hours` float DEFAULT NULL,
630 `parent_id` int(11) DEFAULT NULL,
631 `root_id` int(11) DEFAULT NULL,
632 `lft` int(11) DEFAULT NULL,
633 `rgt` int(11) DEFAULT NULL,
634 `is_private` tinyint(1) NOT NULL DEFAULT '0',
635 `closed_on` datetime DEFAULT NULL,
636 PRIMARY KEY (`id`),
637 KEY `issues_project_id` (`project_id`),
638 KEY `index_issues_on_status_id` (`status_id`),
639 KEY `index_issues_on_category_id` (`category_id`),
640 KEY `index_issues_on_assigned_to_id` (`assigned_to_id`),
641 KEY `index_issues_on_fixed_version_id` (`fixed_version_id`),
642 KEY `index_issues_on_tracker_id` (`tracker_id`),
643 KEY `index_issues_on_priority_id` (`priority_id`),
644 KEY `index_issues_on_author_id` (`author_id`),
645 KEY `index_issues_on_created_on` (`created_on`),
646 KEY `index_issues_on_root_id_and_lft_and_rgt` (`root_id`,`lft`,`rgt`)
647) ENGINE=InnoDB DEFAULT CHARSET=latin1;
648/*!40101 SET character_set_client = @saved_cs_client */;
649
650--
651-- Dumping data for table `issues`
652--
653
654LOCK TABLES `issues` WRITE;
655/*!40000 ALTER TABLE `issues` DISABLE KEYS */;
656/*!40000 ALTER TABLE `issues` ENABLE KEYS */;
657UNLOCK TABLES;
658
659--
660-- Table structure for table `journal_details`
661--
662
663DROP TABLE IF EXISTS `journal_details`;
664/*!40101 SET @saved_cs_client = @@character_set_client */;
665/*!40101 SET character_set_client = utf8 */;
666CREATE TABLE `journal_details` (
667 `id` int(11) NOT NULL AUTO_INCREMENT,
668 `journal_id` int(11) NOT NULL DEFAULT '0',
669 `property` varchar(30) NOT NULL DEFAULT '',
670 `prop_key` varchar(30) NOT NULL DEFAULT '',
671 `old_value` text,
672 `value` text,
673 PRIMARY KEY (`id`),
674 KEY `journal_details_journal_id` (`journal_id`)
675) ENGINE=InnoDB DEFAULT CHARSET=latin1;
676/*!40101 SET character_set_client = @saved_cs_client */;
677
678--
679-- Dumping data for table `journal_details`
680--
681
682LOCK TABLES `journal_details` WRITE;
683/*!40000 ALTER TABLE `journal_details` DISABLE KEYS */;
684/*!40000 ALTER TABLE `journal_details` ENABLE KEYS */;
685UNLOCK TABLES;
686
687--
688-- Table structure for table `journals`
689--
690
691DROP TABLE IF EXISTS `journals`;
692/*!40101 SET @saved_cs_client = @@character_set_client */;
693/*!40101 SET character_set_client = utf8 */;
694CREATE TABLE `journals` (
695 `id` int(11) NOT NULL AUTO_INCREMENT,
696 `journalized_id` int(11) NOT NULL DEFAULT '0',
697 `journalized_type` varchar(30) NOT NULL DEFAULT '',
698 `user_id` int(11) NOT NULL DEFAULT '0',
699 `notes` text,
700 `created_on` datetime NOT NULL,
701 `private_notes` tinyint(1) NOT NULL DEFAULT '0',
702 PRIMARY KEY (`id`),
703 KEY `journals_journalized_id` (`journalized_id`,`journalized_type`),
704 KEY `index_journals_on_user_id` (`user_id`),
705 KEY `index_journals_on_journalized_id` (`journalized_id`),
706 KEY `index_journals_on_created_on` (`created_on`)
707) ENGINE=InnoDB DEFAULT CHARSET=latin1;
708/*!40101 SET character_set_client = @saved_cs_client */;
709
710--
711-- Dumping data for table `journals`
712--
713
714LOCK TABLES `journals` WRITE;
715/*!40000 ALTER TABLE `journals` DISABLE KEYS */;
716/*!40000 ALTER TABLE `journals` ENABLE KEYS */;
717UNLOCK TABLES;
718
719--
720-- Table structure for table `member_roles`
721--
722
723DROP TABLE IF EXISTS `member_roles`;
724/*!40101 SET @saved_cs_client = @@character_set_client */;
725/*!40101 SET character_set_client = utf8 */;
726CREATE TABLE `member_roles` (
727 `id` int(11) NOT NULL AUTO_INCREMENT,
728 `member_id` int(11) NOT NULL,
729 `role_id` int(11) NOT NULL,
730 `inherited_from` int(11) DEFAULT NULL,
731 PRIMARY KEY (`id`),
732 KEY `index_member_roles_on_member_id` (`member_id`),
733 KEY `index_member_roles_on_role_id` (`role_id`)
734) ENGINE=InnoDB DEFAULT CHARSET=latin1;
735/*!40101 SET character_set_client = @saved_cs_client */;
736
737--
738-- Dumping data for table `member_roles`
739--
740
741LOCK TABLES `member_roles` WRITE;
742/*!40000 ALTER TABLE `member_roles` DISABLE KEYS */;
743/*!40000 ALTER TABLE `member_roles` ENABLE KEYS */;
744UNLOCK TABLES;
745
746--
747-- Table structure for table `members`
748--
749
750DROP TABLE IF EXISTS `members`;
751/*!40101 SET @saved_cs_client = @@character_set_client */;
752/*!40101 SET character_set_client = utf8 */;
753CREATE TABLE `members` (
754 `id` int(11) NOT NULL AUTO_INCREMENT,
755 `user_id` int(11) NOT NULL DEFAULT '0',
756 `project_id` int(11) NOT NULL DEFAULT '0',
757 `created_on` datetime DEFAULT NULL,
758 `mail_notification` tinyint(1) NOT NULL DEFAULT '0',
759 PRIMARY KEY (`id`),
760 UNIQUE KEY `index_members_on_user_id_and_project_id` (`user_id`,`project_id`),
761 KEY `index_members_on_user_id` (`user_id`),
762 KEY `index_members_on_project_id` (`project_id`)
763) ENGINE=InnoDB DEFAULT CHARSET=latin1;
764/*!40101 SET character_set_client = @saved_cs_client */;
765
766--
767-- Dumping data for table `members`
768--
769
770LOCK TABLES `members` WRITE;
771/*!40000 ALTER TABLE `members` DISABLE KEYS */;
772/*!40000 ALTER TABLE `members` ENABLE KEYS */;
773UNLOCK TABLES;
774
775--
776-- Table structure for table `messages`
777--
778
779DROP TABLE IF EXISTS `messages`;
780/*!40101 SET @saved_cs_client = @@character_set_client */;
781/*!40101 SET character_set_client = utf8 */;
782CREATE TABLE `messages` (
783 `id` int(11) NOT NULL AUTO_INCREMENT,
784 `board_id` int(11) NOT NULL,
785 `parent_id` int(11) DEFAULT NULL,
786 `subject` varchar(255) NOT NULL DEFAULT '',
787 `content` text,
788 `author_id` int(11) DEFAULT NULL,
789 `replies_count` int(11) NOT NULL DEFAULT '0',
790 `last_reply_id` int(11) DEFAULT NULL,
791 `created_on` datetime NOT NULL,
792 `updated_on` datetime NOT NULL,
793 `locked` tinyint(1) DEFAULT '0',
794 `sticky` int(11) DEFAULT '0',
795 PRIMARY KEY (`id`),
796 KEY `messages_board_id` (`board_id`),
797 KEY `messages_parent_id` (`parent_id`),
798 KEY `index_messages_on_last_reply_id` (`last_reply_id`),
799 KEY `index_messages_on_author_id` (`author_id`),
800 KEY `index_messages_on_created_on` (`created_on`)
801) ENGINE=InnoDB DEFAULT CHARSET=latin1;
802/*!40101 SET character_set_client = @saved_cs_client */;
803
804--
805-- Dumping data for table `messages`
806--
807
808LOCK TABLES `messages` WRITE;
809/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
810/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
811UNLOCK TABLES;
812
813--
814-- Table structure for table `news`
815--
816
817DROP TABLE IF EXISTS `news`;
818/*!40101 SET @saved_cs_client = @@character_set_client */;
819/*!40101 SET character_set_client = utf8 */;
820CREATE TABLE `news` (
821 `id` int(11) NOT NULL AUTO_INCREMENT,
822 `project_id` int(11) DEFAULT NULL,
823 `title` varchar(60) NOT NULL DEFAULT '',
824 `summary` varchar(255) DEFAULT '',
825 `description` text,
826 `author_id` int(11) NOT NULL DEFAULT '0',
827 `created_on` datetime DEFAULT NULL,
828 `comments_count` int(11) NOT NULL DEFAULT '0',
829 PRIMARY KEY (`id`),
830 KEY `news_project_id` (`project_id`),
831 KEY `index_news_on_author_id` (`author_id`),
832 KEY `index_news_on_created_on` (`created_on`)
833) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
834/*!40101 SET character_set_client = @saved_cs_client */;
835
836--
837-- Dumping data for table `news`
838--
839
840LOCK TABLES `news` WRITE;
841/*!40000 ALTER TABLE `news` DISABLE KEYS */;
842INSERT INTO `news` VALUES (1,1,'Félicitation, Redmine installé','','Vous avez bien installé le Redmine',1,'2014-03-03 19:36:47',0);
843/*!40000 ALTER TABLE `news` ENABLE KEYS */;
844UNLOCK TABLES;
845
846--
847-- Table structure for table `open_id_authentication_associations`
848--
849
850DROP TABLE IF EXISTS `open_id_authentication_associations`;
851/*!40101 SET @saved_cs_client = @@character_set_client */;
852/*!40101 SET character_set_client = utf8 */;
853CREATE TABLE `open_id_authentication_associations` (
854 `id` int(11) NOT NULL AUTO_INCREMENT,
855 `issued` int(11) DEFAULT NULL,
856 `lifetime` int(11) DEFAULT NULL,
857 `handle` varchar(255) DEFAULT NULL,
858 `assoc_type` varchar(255) DEFAULT NULL,
859 `server_url` blob,
860 `secret` blob,
861 PRIMARY KEY (`id`)
862) ENGINE=InnoDB DEFAULT CHARSET=latin1;
863/*!40101 SET character_set_client = @saved_cs_client */;
864
865--
866-- Dumping data for table `open_id_authentication_associations`
867--
868
869LOCK TABLES `open_id_authentication_associations` WRITE;
870/*!40000 ALTER TABLE `open_id_authentication_associations` DISABLE KEYS */;
871/*!40000 ALTER TABLE `open_id_authentication_associations` ENABLE KEYS */;
872UNLOCK TABLES;
873
874--
875-- Table structure for table `open_id_authentication_nonces`
876--
877
878DROP TABLE IF EXISTS `open_id_authentication_nonces`;
879/*!40101 SET @saved_cs_client = @@character_set_client */;
880/*!40101 SET character_set_client = utf8 */;
881CREATE TABLE `open_id_authentication_nonces` (
882 `id` int(11) NOT NULL AUTO_INCREMENT,
883 `timestamp` int(11) NOT NULL,
884 `server_url` varchar(255) DEFAULT NULL,
885 `salt` varchar(255) NOT NULL,
886 PRIMARY KEY (`id`)
887) ENGINE=InnoDB DEFAULT CHARSET=latin1;
888/*!40101 SET character_set_client = @saved_cs_client */;
889
890--
891-- Dumping data for table `open_id_authentication_nonces`
892--
893
894LOCK TABLES `open_id_authentication_nonces` WRITE;
895/*!40000 ALTER TABLE `open_id_authentication_nonces` DISABLE KEYS */;
896/*!40000 ALTER TABLE `open_id_authentication_nonces` ENABLE KEYS */;
897UNLOCK TABLES;
898
899--
900-- Table structure for table `projects`
901--
902
903DROP TABLE IF EXISTS `projects`;
904/*!40101 SET @saved_cs_client = @@character_set_client */;
905/*!40101 SET character_set_client = utf8 */;
906CREATE TABLE `projects` (
907 `id` int(11) NOT NULL AUTO_INCREMENT,
908 `name` varchar(255) NOT NULL DEFAULT '',
909 `description` text,
910 `homepage` varchar(255) DEFAULT '',
911 `is_public` tinyint(1) NOT NULL DEFAULT '1',
912 `parent_id` int(11) DEFAULT NULL,
913 `created_on` datetime DEFAULT NULL,
914 `updated_on` datetime DEFAULT NULL,
915 `identifier` varchar(255) DEFAULT NULL,
916 `status` int(11) NOT NULL DEFAULT '1',
917 `lft` int(11) DEFAULT NULL,
918 `rgt` int(11) DEFAULT NULL,
919 `inherit_members` tinyint(1) NOT NULL DEFAULT '0',
920 PRIMARY KEY (`id`),
921 KEY `index_projects_on_lft` (`lft`),
922 KEY `index_projects_on_rgt` (`rgt`)
923) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
924/*!40101 SET character_set_client = @saved_cs_client */;
925
926--
927-- Dumping data for table `projects`
928--
929
930LOCK TABLES `projects` WRITE;
931/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
932INSERT INTO `projects` VALUES (1,'Nouveau Projet','Test de nouveau projet','',1,NULL,'2014-03-03 19:36:05','2014-03-03 19:36:05','nouveau-projet',1,1,2,0);
933/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
934UNLOCK TABLES;
935
936--
937-- Table structure for table `projects_trackers`
938--
939
940DROP TABLE IF EXISTS `projects_trackers`;
941/*!40101 SET @saved_cs_client = @@character_set_client */;
942/*!40101 SET character_set_client = utf8 */;
943CREATE TABLE `projects_trackers` (
944 `project_id` int(11) NOT NULL DEFAULT '0',
945 `tracker_id` int(11) NOT NULL DEFAULT '0',
946 UNIQUE KEY `projects_trackers_unique` (`project_id`,`tracker_id`),
947 KEY `projects_trackers_project_id` (`project_id`)
948) ENGINE=InnoDB DEFAULT CHARSET=latin1;
949/*!40101 SET character_set_client = @saved_cs_client */;
950
951--
952-- Dumping data for table `projects_trackers`
953--
954
955LOCK TABLES `projects_trackers` WRITE;
956/*!40000 ALTER TABLE `projects_trackers` DISABLE KEYS */;
957INSERT INTO `projects_trackers` VALUES (1,1),(1,2),(1,3);
958/*!40000 ALTER TABLE `projects_trackers` ENABLE KEYS */;
959UNLOCK TABLES;
960
961--
962-- Table structure for table `queries`
963--
964
965DROP TABLE IF EXISTS `queries`;
966/*!40101 SET @saved_cs_client = @@character_set_client */;
967/*!40101 SET character_set_client = utf8 */;
968CREATE TABLE `queries` (
969 `id` int(11) NOT NULL AUTO_INCREMENT,
970 `project_id` int(11) DEFAULT NULL,
971 `name` varchar(255) NOT NULL DEFAULT '',
972 `filters` text,
973 `user_id` int(11) NOT NULL DEFAULT '0',
974 `column_names` text,
975 `sort_criteria` text,
976 `group_by` varchar(255) DEFAULT NULL,
977 `type` varchar(255) DEFAULT NULL,
978 `visibility` int(11) DEFAULT '0',
979 `options` text,
980 PRIMARY KEY (`id`),
981 KEY `index_queries_on_project_id` (`project_id`),
982 KEY `index_queries_on_user_id` (`user_id`)
983) ENGINE=InnoDB DEFAULT CHARSET=latin1;
984/*!40101 SET character_set_client = @saved_cs_client */;
985
986--
987-- Dumping data for table `queries`
988--
989
990LOCK TABLES `queries` WRITE;
991/*!40000 ALTER TABLE `queries` DISABLE KEYS */;
992/*!40000 ALTER TABLE `queries` ENABLE KEYS */;
993UNLOCK TABLES;
994
995--
996-- Table structure for table `queries_roles`
997--
998
999DROP TABLE IF EXISTS `queries_roles`;
1000/*!40101 SET @saved_cs_client = @@character_set_client */;
1001/*!40101 SET character_set_client = utf8 */;
1002CREATE TABLE `queries_roles` (
1003 `query_id` int(11) NOT NULL,
1004 `role_id` int(11) NOT NULL,
1005 UNIQUE KEY `queries_roles_ids` (`query_id`,`role_id`)
1006) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1007/*!40101 SET character_set_client = @saved_cs_client */;
1008
1009--
1010-- Dumping data for table `queries_roles`
1011--
1012
1013LOCK TABLES `queries_roles` WRITE;
1014/*!40000 ALTER TABLE `queries_roles` DISABLE KEYS */;
1015/*!40000 ALTER TABLE `queries_roles` ENABLE KEYS */;
1016UNLOCK TABLES;
1017
1018--
1019-- Table structure for table `repositories`
1020--
1021
1022DROP TABLE IF EXISTS `repositories`;
1023/*!40101 SET @saved_cs_client = @@character_set_client */;
1024/*!40101 SET character_set_client = utf8 */;
1025CREATE TABLE `repositories` (
1026 `id` int(11) NOT NULL AUTO_INCREMENT,
1027 `project_id` int(11) NOT NULL DEFAULT '0',
1028 `url` varchar(255) NOT NULL DEFAULT '',
1029 `login` varchar(60) DEFAULT '',
1030 `password` varchar(255) DEFAULT '',
1031 `root_url` varchar(255) DEFAULT '',
1032 `type` varchar(255) DEFAULT NULL,
1033 `path_encoding` varchar(64) DEFAULT NULL,
1034 `log_encoding` varchar(64) DEFAULT NULL,
1035 `extra_info` text,
1036 `identifier` varchar(255) DEFAULT NULL,
1037 `is_default` tinyint(1) DEFAULT '0',
1038 `created_on` datetime DEFAULT NULL,
1039 PRIMARY KEY (`id`),
1040 KEY `index_repositories_on_project_id` (`project_id`)
1041) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1042/*!40101 SET character_set_client = @saved_cs_client */;
1043
1044--
1045-- Dumping data for table `repositories`
1046--
1047
1048LOCK TABLES `repositories` WRITE;
1049/*!40000 ALTER TABLE `repositories` DISABLE KEYS */;
1050/*!40000 ALTER TABLE `repositories` ENABLE KEYS */;
1051UNLOCK TABLES;
1052
1053--
1054-- Table structure for table `roles`
1055--
1056
1057DROP TABLE IF EXISTS `roles`;
1058/*!40101 SET @saved_cs_client = @@character_set_client */;
1059/*!40101 SET character_set_client = utf8 */;
1060CREATE TABLE `roles` (
1061 `id` int(11) NOT NULL AUTO_INCREMENT,
1062 `name` varchar(30) NOT NULL DEFAULT '',
1063 `position` int(11) DEFAULT '1',
1064 `assignable` tinyint(1) DEFAULT '1',
1065 `builtin` int(11) NOT NULL DEFAULT '0',
1066 `permissions` text,
1067 `issues_visibility` varchar(30) NOT NULL DEFAULT 'default',
1068 PRIMARY KEY (`id`)
1069) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
1070/*!40101 SET character_set_client = @saved_cs_client */;
1071
1072--
1073-- Dumping data for table `roles`
1074--
1075
1076LOCK TABLES `roles` WRITE;
1077/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
1078INSERT INTO `roles` VALUES (1,'Non member',1,1,1,'---\n- :view_issues\n- :add_issues\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :add_messages\n- :view_files\n- :browse_repository\n- :view_changesets\n','default'),(2,'Anonymous',2,1,2,'---\n- :view_issues\n- :view_gantt\n- :view_calendar\n- :view_time_entries\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :view_files\n- :browse_repository\n- :view_changesets\n','default'),(3,'Manager',3,1,0,'---\n- :add_project\n- :edit_project\n- :close_project\n- :select_project_modules\n- :manage_members\n- :manage_versions\n- :add_subprojects\n- :manage_categories\n- :view_issues\n- :add_issues\n- :edit_issues\n- :manage_issue_relations\n- :manage_subtasks\n- :set_issues_private\n- :set_own_issues_private\n- :add_issue_notes\n- :edit_issue_notes\n- :edit_own_issue_notes\n- :view_private_notes\n- :set_notes_private\n- :move_issues\n- :delete_issues\n- :manage_public_queries\n- :save_queries\n- :view_issue_watchers\n- :add_issue_watchers\n- :delete_issue_watchers\n- :log_time\n- :view_time_entries\n- :edit_time_entries\n- :edit_own_time_entries\n- :manage_project_activities\n- :manage_news\n- :comment_news\n- :add_documents\n- :edit_documents\n- :delete_documents\n- :view_documents\n- :manage_files\n- :view_files\n- :manage_wiki\n- :rename_wiki_pages\n- :delete_wiki_pages\n- :view_wiki_pages\n- :export_wiki_pages\n- :view_wiki_edits\n- :edit_wiki_pages\n- :delete_wiki_pages_attachments\n- :protect_wiki_pages\n- :manage_repository\n- :browse_repository\n- :view_changesets\n- :commit_access\n- :manage_related_issues\n- :manage_boards\n- :add_messages\n- :edit_messages\n- :edit_own_messages\n- :delete_messages\n- :delete_own_messages\n- :view_calendar\n- :view_gantt\n','all'),(4,'Développeur',4,1,0,'---\n- :manage_versions\n- :manage_categories\n- :view_issues\n- :add_issues\n- :edit_issues\n- :view_private_notes\n- :set_notes_private\n- :manage_issue_relations\n- :manage_subtasks\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :edit_wiki_pages\n- :delete_wiki_pages\n- :add_messages\n- :edit_own_messages\n- :view_files\n- :manage_files\n- :browse_repository\n- :view_changesets\n- :commit_access\n- :manage_related_issues\n','default'),(5,'Rapporteur',5,1,0,'---\n- :view_issues\n- :add_issues\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :add_messages\n- :edit_own_messages\n- :view_files\n- :browse_repository\n- :view_changesets\n','default');
1079/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
1080UNLOCK TABLES;
1081
1082--
1083-- Table structure for table `schema_migrations`
1084--
1085
1086DROP TABLE IF EXISTS `schema_migrations`;
1087/*!40101 SET @saved_cs_client = @@character_set_client */;
1088/*!40101 SET character_set_client = utf8 */;
1089CREATE TABLE `schema_migrations` (
1090 `version` varchar(255) NOT NULL,
1091 UNIQUE KEY `unique_schema_migrations` (`version`)
1092) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1093/*!40101 SET character_set_client = @saved_cs_client */;
1094
1095--
1096-- Dumping data for table `schema_migrations`
1097--
1098
1099LOCK TABLES `schema_migrations` WRITE;
1100/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
1101INSERT INTO `schema_migrations` VALUES ('1'),('10'),('100'),('101'),('102'),('103'),('104'),('105'),('106'),('107'),('108'),('11'),('12'),('13'),('14'),('15'),('16'),('17'),('18'),('19'),('2'),('20'),('20090214190337'),('20090312172426'),('20090312194159'),('20090318181151'),('20090323224724'),('20090401221305'),('20090401231134'),('20090403001910'),('20090406161854'),('20090425161243'),('20090503121501'),('20090503121505'),('20090503121510'),('20090614091200'),('20090704172350'),('20090704172355'),('20090704172358'),('20091010093521'),('20091017212227'),('20091017212457'),('20091017212644'),('20091017212938'),('20091017213027'),('20091017213113'),('20091017213151'),('20091017213228'),('20091017213257'),('20091017213332'),('20091017213444'),('20091017213536'),('20091017213642'),('20091017213716'),('20091017213757'),('20091017213835'),('20091017213910'),('20091017214015'),('20091017214107'),('20091017214136'),('20091017214236'),('20091017214308'),('20091017214336'),('20091017214406'),('20091017214440'),('20091017214519'),('20091017214611'),('20091017214644'),('20091017214720'),('20091017214750'),('20091025163651'),('20091108092559'),('20091114105931'),('20091123212029'),('20091205124427'),('20091220183509'),('20091220183727'),('20091220184736'),('20091225164732'),('20091227112908'),('20100129193402'),('20100129193813'),('20100221100219'),('20100313132032'),('20100313171051'),('20100705164950'),('20100819172912'),('20101104182107'),('20101107130441'),('20101114115114'),('20101114115359'),('20110220160626'),('20110223180944'),('20110223180953'),('20110224000000'),('20110226120112'),('20110226120132'),('20110227125750'),('20110228000000'),('20110228000100'),('20110401192910'),('20110408103312'),('20110412065600'),('20110511000000'),('20110902000000'),('20111201201315'),('20120115143024'),('20120115143100'),('20120115143126'),('20120127174243'),('20120205111326'),('20120223110929'),('20120301153455'),('20120422150750'),('20120705074331'),('20120707064544'),('20120714122000'),('20120714122100'),('20120714122200'),('20120731164049'),('20120930112914'),('20121026002032'),('20121026003537'),('20121209123234'),('20121209123358'),('20121213084931'),('20130110122628'),('20130201184705'),('20130202090625'),('20130207175206'),('20130207181455'),('20130215073721'),('20130215111127'),('20130215111141'),('20130217094251'),('20130602092539'),('20130710182539'),('20130713104233'),('20130713111657'),('20130729070143'),('20130911193200'),('20131004113137'),('20131005100610'),('20131124175346'),('20131210180802'),('20131214094309'),('20131215104612'),('20131218183023'),('20140228130325'),('21'),('22'),('23'),('24'),('25'),('26'),('27'),('28'),('29'),('3'),('30'),('31'),('32'),('33'),('34'),('35'),('36'),('37'),('38'),('39'),('4'),('40'),('41'),('42'),('43'),('44'),('45'),('46'),('47'),('48'),('49'),('5'),('50'),('51'),('52'),('53'),('54'),('55'),('56'),('57'),('58'),('59'),('6'),('60'),('61'),('62'),('63'),('64'),('65'),('66'),('67'),('68'),('69'),('7'),('70'),('71'),('72'),('73'),('74'),('75'),('76'),('77'),('78'),('79'),('8'),('80'),('81'),('82'),('83'),('84'),('85'),('86'),('87'),('88'),('89'),('9'),('90'),('91'),('92'),('93'),('94'),('95'),('96'),('97'),('98'),('99');
1102/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
1103UNLOCK TABLES;
1104
1105--
1106-- Table structure for table `settings`
1107--
1108
1109DROP TABLE IF EXISTS `settings`;
1110/*!40101 SET @saved_cs_client = @@character_set_client */;
1111/*!40101 SET character_set_client = utf8 */;
1112CREATE TABLE `settings` (
1113 `id` int(11) NOT NULL AUTO_INCREMENT,
1114 `name` varchar(255) NOT NULL DEFAULT '',
1115 `value` text,
1116 `updated_on` datetime DEFAULT NULL,
1117 PRIMARY KEY (`id`),
1118 KEY `index_settings_on_name` (`name`)
1119) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1120/*!40101 SET character_set_client = @saved_cs_client */;
1121
1122--
1123-- Dumping data for table `settings`
1124--
1125
1126LOCK TABLES `settings` WRITE;
1127/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1128/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1129UNLOCK TABLES;
1130
1131--
1132-- Table structure for table `time_entries`
1133--
1134
1135DROP TABLE IF EXISTS `time_entries`;
1136/*!40101 SET @saved_cs_client = @@character_set_client */;
1137/*!40101 SET character_set_client = utf8 */;
1138CREATE TABLE `time_entries` (
1139 `id` int(11) NOT NULL AUTO_INCREMENT,
1140 `project_id` int(11) NOT NULL,
1141 `user_id` int(11) NOT NULL,
1142 `issue_id` int(11) DEFAULT NULL,
1143 `hours` float NOT NULL,
1144 `comments` varchar(255) DEFAULT NULL,
1145 `activity_id` int(11) NOT NULL,
1146 `spent_on` date NOT NULL,
1147 `tyear` int(11) NOT NULL,
1148 `tmonth` int(11) NOT NULL,
1149 `tweek` int(11) NOT NULL,
1150 `created_on` datetime NOT NULL,
1151 `updated_on` datetime NOT NULL,
1152 PRIMARY KEY (`id`),
1153 KEY `time_entries_project_id` (`project_id`),
1154 KEY `time_entries_issue_id` (`issue_id`),
1155 KEY `index_time_entries_on_activity_id` (`activity_id`),
1156 KEY `index_time_entries_on_user_id` (`user_id`),
1157 KEY `index_time_entries_on_created_on` (`created_on`)
1158) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1159/*!40101 SET character_set_client = @saved_cs_client */;
1160
1161--
1162-- Dumping data for table `time_entries`
1163--
1164
1165LOCK TABLES `time_entries` WRITE;
1166/*!40000 ALTER TABLE `time_entries` DISABLE KEYS */;
1167/*!40000 ALTER TABLE `time_entries` ENABLE KEYS */;
1168UNLOCK TABLES;
1169
1170--
1171-- Table structure for table `tokens`
1172--
1173
1174DROP TABLE IF EXISTS `tokens`;
1175/*!40101 SET @saved_cs_client = @@character_set_client */;
1176/*!40101 SET character_set_client = utf8 */;
1177CREATE TABLE `tokens` (
1178 `id` int(11) NOT NULL AUTO_INCREMENT,
1179 `user_id` int(11) NOT NULL DEFAULT '0',
1180 `action` varchar(30) NOT NULL DEFAULT '',
1181 `value` varchar(40) NOT NULL DEFAULT '',
1182 `created_on` datetime NOT NULL,
1183 PRIMARY KEY (`id`),
1184 UNIQUE KEY `tokens_value` (`value`),
1185 KEY `index_tokens_on_user_id` (`user_id`)
1186) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1187/*!40101 SET character_set_client = @saved_cs_client */;
1188
1189--
1190-- Dumping data for table `tokens`
1191--
1192
1193LOCK TABLES `tokens` WRITE;
1194/*!40000 ALTER TABLE `tokens` DISABLE KEYS */;
1195INSERT INTO `tokens` VALUES (1,1,'feeds','61e3ce9dc2439c8fa1bf942b8959fc55ec9745c7','2014-03-03 19:35:36');
1196/*!40000 ALTER TABLE `tokens` ENABLE KEYS */;
1197UNLOCK TABLES;
1198
1199--
1200-- Table structure for table `trackers`
1201--
1202
1203DROP TABLE IF EXISTS `trackers`;
1204/*!40101 SET @saved_cs_client = @@character_set_client */;
1205/*!40101 SET character_set_client = utf8 */;
1206CREATE TABLE `trackers` (
1207 `id` int(11) NOT NULL AUTO_INCREMENT,
1208 `name` varchar(30) NOT NULL DEFAULT '',
1209 `is_in_chlog` tinyint(1) NOT NULL DEFAULT '0',
1210 `position` int(11) DEFAULT '1',
1211 `is_in_roadmap` tinyint(1) NOT NULL DEFAULT '1',
1212 `fields_bits` int(11) DEFAULT '0',
1213 PRIMARY KEY (`id`)
1214) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
1215/*!40101 SET character_set_client = @saved_cs_client */;
1216
1217--
1218-- Dumping data for table `trackers`
1219--
1220
1221LOCK TABLES `trackers` WRITE;
1222/*!40000 ALTER TABLE `trackers` DISABLE KEYS */;
1223INSERT INTO `trackers` VALUES (1,'Anomalie',1,1,0,0),(2,'Evolution',1,2,1,0),(3,'Assistance',0,3,0,0);
1224/*!40000 ALTER TABLE `trackers` ENABLE KEYS */;
1225UNLOCK TABLES;
1226
1227--
1228-- Table structure for table `user_preferences`
1229--
1230
1231DROP TABLE IF EXISTS `user_preferences`;
1232/*!40101 SET @saved_cs_client = @@character_set_client */;
1233/*!40101 SET character_set_client = utf8 */;
1234CREATE TABLE `user_preferences` (
1235 `id` int(11) NOT NULL AUTO_INCREMENT,
1236 `user_id` int(11) NOT NULL DEFAULT '0',
1237 `others` text,
1238 `hide_mail` tinyint(1) DEFAULT '0',
1239 `time_zone` varchar(255) DEFAULT NULL,
1240 PRIMARY KEY (`id`),
1241 KEY `index_user_preferences_on_user_id` (`user_id`)
1242) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
1243/*!40101 SET character_set_client = @saved_cs_client */;
1244
1245--
1246-- Dumping data for table `user_preferences`
1247--
1248
1249LOCK TABLES `user_preferences` WRITE;
1250/*!40000 ALTER TABLE `user_preferences` DISABLE KEYS */;
1251INSERT INTO `user_preferences` VALUES (1,1,'--- {}\n',0,NULL),(2,3,'---\n:no_self_notified: \'0\'\n:comments_sorting: asc\n:warn_on_leaving_unsaved: \'1\'\n',0,'');
1252/*!40000 ALTER TABLE `user_preferences` ENABLE KEYS */;
1253UNLOCK TABLES;
1254
1255--
1256-- Table structure for table `users`
1257--
1258
1259DROP TABLE IF EXISTS `users`;
1260/*!40101 SET @saved_cs_client = @@character_set_client */;
1261/*!40101 SET character_set_client = utf8 */;
1262CREATE TABLE `users` (
1263 `id` int(11) NOT NULL AUTO_INCREMENT,
1264 `login` varchar(255) NOT NULL DEFAULT '',
1265 `hashed_password` varchar(40) NOT NULL DEFAULT '',
1266 `firstname` varchar(30) NOT NULL DEFAULT '',
1267 `lastname` varchar(255) NOT NULL DEFAULT '',
1268 `mail` varchar(60) NOT NULL DEFAULT '',
1269 `admin` tinyint(1) NOT NULL DEFAULT '0',
1270 `status` int(11) NOT NULL DEFAULT '1',
1271 `last_login_on` datetime DEFAULT NULL,
1272 `language` varchar(5) DEFAULT '',
1273 `auth_source_id` int(11) DEFAULT NULL,
1274 `created_on` datetime DEFAULT NULL,
1275 `updated_on` datetime DEFAULT NULL,
1276 `type` varchar(255) DEFAULT NULL,
1277 `identity_url` varchar(255) DEFAULT NULL,
1278 `mail_notification` varchar(255) NOT NULL DEFAULT '',
1279 `salt` varchar(64) DEFAULT NULL,
1280 `must_change_passwd` tinyint(1) NOT NULL DEFAULT '0',
1281 PRIMARY KEY (`id`),
1282 KEY `index_users_on_id_and_type` (`id`,`type`),
1283 KEY `index_users_on_auth_source_id` (`auth_source_id`),
1284 KEY `index_users_on_type` (`type`)
1285) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
1286/*!40101 SET character_set_client = @saved_cs_client */;
1287
1288--
1289-- Dumping data for table `users`
1290--
1291
1292LOCK TABLES `users` WRITE;
1293/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1294INSERT INTO `users` VALUES (1,'admin','b8bf5dbe6565ecf03d7e5d315987e5a8784a98c5','Redmine','Admin','admin@example.net',1,1,'2014-03-03 19:35:36','',NULL,'2014-03-03 19:33:28','2014-03-03 19:33:28','User',NULL,'all','ce4bba9b3f195cac55c4d8dd9b0aba1d',0),(2,'','','','Anonymous','',0,0,NULL,'',NULL,'2014-03-03 19:35:26','2014-03-03 19:35:26','AnonymousUser',NULL,'only_my_events',NULL,0),(3,'user1','515bc878bf88fe95f2e2b33db03b4a8b53541619','user','Test','user1@test.com',0,1,NULL,'en',NULL,'2014-03-03 19:38:13','2014-03-03 19:38:13','User',NULL,'only_my_events','d53096a6fcd61e598f4087315725fac1',0);
1295/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1296UNLOCK TABLES;
1297
1298--
1299-- Table structure for table `versions`
1300--
1301
1302DROP TABLE IF EXISTS `versions`;
1303/*!40101 SET @saved_cs_client = @@character_set_client */;
1304/*!40101 SET character_set_client = utf8 */;
1305CREATE TABLE `versions` (
1306 `id` int(11) NOT NULL AUTO_INCREMENT,
1307 `project_id` int(11) NOT NULL DEFAULT '0',
1308 `name` varchar(255) NOT NULL DEFAULT '',
1309 `description` varchar(255) DEFAULT '',
1310 `effective_date` date DEFAULT NULL,
1311 `created_on` datetime DEFAULT NULL,
1312 `updated_on` datetime DEFAULT NULL,
1313 `wiki_page_title` varchar(255) DEFAULT NULL,
1314 `status` varchar(255) DEFAULT 'open',
1315 `sharing` varchar(255) NOT NULL DEFAULT 'none',
1316 PRIMARY KEY (`id`),
1317 KEY `versions_project_id` (`project_id`),
1318 KEY `index_versions_on_sharing` (`sharing`)
1319) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1320/*!40101 SET character_set_client = @saved_cs_client */;
1321
1322--
1323-- Dumping data for table `versions`
1324--
1325
1326LOCK TABLES `versions` WRITE;
1327/*!40000 ALTER TABLE `versions` DISABLE KEYS */;
1328/*!40000 ALTER TABLE `versions` ENABLE KEYS */;
1329UNLOCK TABLES;
1330
1331--
1332-- Table structure for table `watchers`
1333--
1334
1335DROP TABLE IF EXISTS `watchers`;
1336/*!40101 SET @saved_cs_client = @@character_set_client */;
1337/*!40101 SET character_set_client = utf8 */;
1338CREATE TABLE `watchers` (
1339 `id` int(11) NOT NULL AUTO_INCREMENT,
1340 `watchable_type` varchar(255) NOT NULL DEFAULT '',
1341 `watchable_id` int(11) NOT NULL DEFAULT '0',
1342 `user_id` int(11) DEFAULT NULL,
1343 PRIMARY KEY (`id`),
1344 KEY `watchers_user_id_type` (`user_id`,`watchable_type`),
1345 KEY `index_watchers_on_user_id` (`user_id`),
1346 KEY `index_watchers_on_watchable_id_and_watchable_type` (`watchable_id`,`watchable_type`)
1347) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1348/*!40101 SET character_set_client = @saved_cs_client */;
1349
1350--
1351-- Dumping data for table `watchers`
1352--
1353
1354LOCK TABLES `watchers` WRITE;
1355/*!40000 ALTER TABLE `watchers` DISABLE KEYS */;
1356INSERT INTO `watchers` VALUES (1,'News',1,1);
1357/*!40000 ALTER TABLE `watchers` ENABLE KEYS */;
1358UNLOCK TABLES;
1359
1360--
1361-- Table structure for table `wiki_content_versions`
1362--
1363
1364DROP TABLE IF EXISTS `wiki_content_versions`;
1365/*!40101 SET @saved_cs_client = @@character_set_client */;
1366/*!40101 SET character_set_client = utf8 */;
1367CREATE TABLE `wiki_content_versions` (
1368 `id` int(11) NOT NULL AUTO_INCREMENT,
1369 `wiki_content_id` int(11) NOT NULL,
1370 `page_id` int(11) NOT NULL,
1371 `author_id` int(11) DEFAULT NULL,
1372 `data` longblob,
1373 `compression` varchar(6) DEFAULT '',
1374 `comments` varchar(255) DEFAULT '',
1375 `updated_on` datetime NOT NULL,
1376 `version` int(11) NOT NULL,
1377 PRIMARY KEY (`id`),
1378 KEY `wiki_content_versions_wcid` (`wiki_content_id`),
1379 KEY `index_wiki_content_versions_on_updated_on` (`updated_on`)
1380) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1381/*!40101 SET character_set_client = @saved_cs_client */;
1382
1383--
1384-- Dumping data for table `wiki_content_versions`
1385--
1386
1387LOCK TABLES `wiki_content_versions` WRITE;
1388/*!40000 ALTER TABLE `wiki_content_versions` DISABLE KEYS */;
1389/*!40000 ALTER TABLE `wiki_content_versions` ENABLE KEYS */;
1390UNLOCK TABLES;
1391
1392--
1393-- Table structure for table `wiki_contents`
1394--
1395
1396DROP TABLE IF EXISTS `wiki_contents`;
1397/*!40101 SET @saved_cs_client = @@character_set_client */;
1398/*!40101 SET character_set_client = utf8 */;
1399CREATE TABLE `wiki_contents` (
1400 `id` int(11) NOT NULL AUTO_INCREMENT,
1401 `page_id` int(11) NOT NULL,
1402 `author_id` int(11) DEFAULT NULL,
1403 `text` longtext,
1404 `comments` varchar(255) DEFAULT '',
1405 `updated_on` datetime NOT NULL,
1406 `version` int(11) NOT NULL,
1407 PRIMARY KEY (`id`),
1408 KEY `wiki_contents_page_id` (`page_id`),
1409 KEY `index_wiki_contents_on_author_id` (`author_id`)
1410) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1411/*!40101 SET character_set_client = @saved_cs_client */;
1412
1413--
1414-- Dumping data for table `wiki_contents`
1415--
1416
1417LOCK TABLES `wiki_contents` WRITE;
1418/*!40000 ALTER TABLE `wiki_contents` DISABLE KEYS */;
1419/*!40000 ALTER TABLE `wiki_contents` ENABLE KEYS */;
1420UNLOCK TABLES;
1421
1422--
1423-- Table structure for table `wiki_pages`
1424--
1425
1426DROP TABLE IF EXISTS `wiki_pages`;
1427/*!40101 SET @saved_cs_client = @@character_set_client */;
1428/*!40101 SET character_set_client = utf8 */;
1429CREATE TABLE `wiki_pages` (
1430 `id` int(11) NOT NULL AUTO_INCREMENT,
1431 `wiki_id` int(11) NOT NULL,
1432 `title` varchar(255) NOT NULL,
1433 `created_on` datetime NOT NULL,
1434 `protected` tinyint(1) NOT NULL DEFAULT '0',
1435 `parent_id` int(11) DEFAULT NULL,
1436 PRIMARY KEY (`id`),
1437 KEY `wiki_pages_wiki_id_title` (`wiki_id`,`title`),
1438 KEY `index_wiki_pages_on_wiki_id` (`wiki_id`),
1439 KEY `index_wiki_pages_on_parent_id` (`parent_id`)
1440) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1441/*!40101 SET character_set_client = @saved_cs_client */;
1442
1443--
1444-- Dumping data for table `wiki_pages`
1445--
1446
1447LOCK TABLES `wiki_pages` WRITE;
1448/*!40000 ALTER TABLE `wiki_pages` DISABLE KEYS */;
1449/*!40000 ALTER TABLE `wiki_pages` ENABLE KEYS */;
1450UNLOCK TABLES;
1451
1452--
1453-- Table structure for table `wiki_redirects`
1454--
1455
1456DROP TABLE IF EXISTS `wiki_redirects`;
1457/*!40101 SET @saved_cs_client = @@character_set_client */;
1458/*!40101 SET character_set_client = utf8 */;
1459CREATE TABLE `wiki_redirects` (
1460 `id` int(11) NOT NULL AUTO_INCREMENT,
1461 `wiki_id` int(11) NOT NULL,
1462 `title` varchar(255) DEFAULT NULL,
1463 `redirects_to` varchar(255) DEFAULT NULL,
1464 `created_on` datetime NOT NULL,
1465 PRIMARY KEY (`id`),
1466 KEY `wiki_redirects_wiki_id_title` (`wiki_id`,`title`),
1467 KEY `index_wiki_redirects_on_wiki_id` (`wiki_id`)
1468) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1469/*!40101 SET character_set_client = @saved_cs_client */;
1470
1471--
1472-- Dumping data for table `wiki_redirects`
1473--
1474
1475LOCK TABLES `wiki_redirects` WRITE;
1476/*!40000 ALTER TABLE `wiki_redirects` DISABLE KEYS */;
1477/*!40000 ALTER TABLE `wiki_redirects` ENABLE KEYS */;
1478UNLOCK TABLES;
1479
1480--
1481-- Table structure for table `wikis`
1482--
1483
1484DROP TABLE IF EXISTS `wikis`;
1485/*!40101 SET @saved_cs_client = @@character_set_client */;
1486/*!40101 SET character_set_client = utf8 */;
1487CREATE TABLE `wikis` (
1488 `id` int(11) NOT NULL AUTO_INCREMENT,
1489 `project_id` int(11) NOT NULL,
1490 `start_page` varchar(255) NOT NULL,
1491 `status` int(11) NOT NULL DEFAULT '1',
1492 PRIMARY KEY (`id`),
1493 KEY `wikis_project_id` (`project_id`)
1494) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
1495/*!40101 SET character_set_client = @saved_cs_client */;
1496
1497--
1498-- Dumping data for table `wikis`
1499--
1500
1501LOCK TABLES `wikis` WRITE;
1502/*!40000 ALTER TABLE `wikis` DISABLE KEYS */;
1503INSERT INTO `wikis` VALUES (1,1,'Wiki',1);
1504/*!40000 ALTER TABLE `wikis` ENABLE KEYS */;
1505UNLOCK TABLES;
1506
1507--
1508-- Table structure for table `workflows`
1509--
1510
1511DROP TABLE IF EXISTS `workflows`;
1512/*!40101 SET @saved_cs_client = @@character_set_client */;
1513/*!40101 SET character_set_client = utf8 */;
1514CREATE TABLE `workflows` (
1515 `id` int(11) NOT NULL AUTO_INCREMENT,
1516 `tracker_id` int(11) NOT NULL DEFAULT '0',
1517 `old_status_id` int(11) NOT NULL DEFAULT '0',
1518 `new_status_id` int(11) NOT NULL DEFAULT '0',
1519 `role_id` int(11) NOT NULL DEFAULT '0',
1520 `assignee` tinyint(1) NOT NULL DEFAULT '0',
1521 `author` tinyint(1) NOT NULL DEFAULT '0',
1522 `type` varchar(30) DEFAULT NULL,
1523 `field_name` varchar(30) DEFAULT NULL,
1524 `rule` varchar(30) DEFAULT NULL,
1525 PRIMARY KEY (`id`),
1526 KEY `wkfs_role_tracker_old_status` (`role_id`,`tracker_id`,`old_status_id`),
1527 KEY `index_workflows_on_old_status_id` (`old_status_id`),
1528 KEY `index_workflows_on_role_id` (`role_id`),
1529 KEY `index_workflows_on_new_status_id` (`new_status_id`)
1530) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;
1531/*!40101 SET character_set_client = @saved_cs_client */;
1532
1533--
1534-- Dumping data for table `workflows`
1535--
1536
1537LOCK TABLES `workflows` WRITE;
1538/*!40000 ALTER TABLE `workflows` DISABLE KEYS */;
1539INSERT INTO `workflows` VALUES (1,1,1,2,3,0,0,'WorkflowTransition',NULL,NULL),(2,1,1,3,3,0,0,'WorkflowTransition',NULL,NULL),(3,1,1,4,3,0,0,'WorkflowTransition',NULL,NULL),(4,1,1,5,3,0,0,'WorkflowTransition',NULL,NULL),(5,1,1,6,3,0,0,'WorkflowTransition',NULL,NULL),(6,1,2,1,3,0,0,'WorkflowTransition',NULL,NULL),(7,1,2,3,3,0,0,'WorkflowTransition',NULL,NULL),(8,1,2,4,3,0,0,'WorkflowTransition',NULL,NULL),(9,1,2,5,3,0,0,'WorkflowTransition',NULL,NULL),(10,1,2,6,3,0,0,'WorkflowTransition',NULL,NULL),(11,1,3,1,3,0,0,'WorkflowTransition',NULL,NULL),(12,1,3,2,3,0,0,'WorkflowTransition',NULL,NULL),(13,1,3,4,3,0,0,'WorkflowTransition',NULL,NULL),(14,1,3,5,3,0,0,'WorkflowTransition',NULL,NULL),(15,1,3,6,3,0,0,'WorkflowTransition',NULL,NULL),(16,1,4,1,3,0,0,'WorkflowTransition',NULL,NULL),(17,1,4,2,3,0,0,'WorkflowTransition',NULL,NULL),(18,1,4,3,3,0,0,'WorkflowTransition',NULL,NULL),(19,1,4,5,3,0,0,'WorkflowTransition',NULL,NULL),(20,1,4,6,3,0,0,'WorkflowTransition',NULL,NULL),(21,1,5,1,3,0,0,'WorkflowTransition',NULL,NULL),(22,1,5,2,3,0,0,'WorkflowTransition',NULL,NULL),(23,1,5,3,3,0,0,'WorkflowTransition',NULL,NULL),(24,1,5,4,3,0,0,'WorkflowTransition',NULL,NULL),(25,1,5,6,3,0,0,'WorkflowTransition',NULL,NULL),(26,1,6,1,3,0,0,'WorkflowTransition',NULL,NULL),(27,1,6,2,3,0,0,'WorkflowTransition',NULL,NULL),(28,1,6,3,3,0,0,'WorkflowTransition',NULL,NULL),(29,1,6,4,3,0,0,'WorkflowTransition',NULL,NULL),(30,1,6,5,3,0,0,'WorkflowTransition',NULL,NULL),(31,2,1,2,3,0,0,'WorkflowTransition',NULL,NULL),(32,2,1,3,3,0,0,'WorkflowTransition',NULL,NULL),(33,2,1,4,3,0,0,'WorkflowTransition',NULL,NULL),(34,2,1,5,3,0,0,'WorkflowTransition',NULL,NULL),(35,2,1,6,3,0,0,'WorkflowTransition',NULL,NULL),(36,2,2,1,3,0,0,'WorkflowTransition',NULL,NULL),(37,2,2,3,3,0,0,'WorkflowTransition',NULL,NULL),(38,2,2,4,3,0,0,'WorkflowTransition',NULL,NULL),(39,2,2,5,3,0,0,'WorkflowTransition',NULL,NULL),(40,2,2,6,3,0,0,'WorkflowTransition',NULL,NULL),(41,2,3,1,3,0,0,'WorkflowTransition',NULL,NULL),(42,2,3,2,3,0,0,'WorkflowTransition',NULL,NULL),(43,2,3,4,3,0,0,'WorkflowTransition',NULL,NULL),(44,2,3,5,3,0,0,'WorkflowTransition',NULL,NULL),(45,2,3,6,3,0,0,'WorkflowTransition',NULL,NULL),(46,2,4,1,3,0,0,'WorkflowTransition',NULL,NULL),(47,2,4,2,3,0,0,'WorkflowTransition',NULL,NULL),(48,2,4,3,3,0,0,'WorkflowTransition',NULL,NULL),(49,2,4,5,3,0,0,'WorkflowTransition',NULL,NULL),(50,2,4,6,3,0,0,'WorkflowTransition',NULL,NULL),(51,2,5,1,3,0,0,'WorkflowTransition',NULL,NULL),(52,2,5,2,3,0,0,'WorkflowTransition',NULL,NULL),(53,2,5,3,3,0,0,'WorkflowTransition',NULL,NULL),(54,2,5,4,3,0,0,'WorkflowTransition',NULL,NULL),(55,2,5,6,3,0,0,'WorkflowTransition',NULL,NULL),(56,2,6,1,3,0,0,'WorkflowTransition',NULL,NULL),(57,2,6,2,3,0,0,'WorkflowTransition',NULL,NULL),(58,2,6,3,3,0,0,'WorkflowTransition',NULL,NULL),(59,2,6,4,3,0,0,'WorkflowTransition',NULL,NULL),(60,2,6,5,3,0,0,'WorkflowTransition',NULL,NULL),(61,3,1,2,3,0,0,'WorkflowTransition',NULL,NULL),(62,3,1,3,3,0,0,'WorkflowTransition',NULL,NULL),(63,3,1,4,3,0,0,'WorkflowTransition',NULL,NULL),(64,3,1,5,3,0,0,'WorkflowTransition',NULL,NULL),(65,3,1,6,3,0,0,'WorkflowTransition',NULL,NULL),(66,3,2,1,3,0,0,'WorkflowTransition',NULL,NULL),(67,3,2,3,3,0,0,'WorkflowTransition',NULL,NULL),(68,3,2,4,3,0,0,'WorkflowTransition',NULL,NULL),(69,3,2,5,3,0,0,'WorkflowTransition',NULL,NULL),(70,3,2,6,3,0,0,'WorkflowTransition',NULL,NULL),(71,3,3,1,3,0,0,'WorkflowTransition',NULL,NULL),(72,3,3,2,3,0,0,'WorkflowTransition',NULL,NULL),(73,3,3,4,3,0,0,'WorkflowTransition',NULL,NULL),(74,3,3,5,3,0,0,'WorkflowTransition',NULL,NULL),(75,3,3,6,3,0,0,'WorkflowTransition',NULL,NULL),(76,3,4,1,3,0,0,'WorkflowTransition',NULL,NULL),(77,3,4,2,3,0,0,'WorkflowTransition',NULL,NULL),(78,3,4,3,3,0,0,'WorkflowTransition',NULL,NULL),(79,3,4,5,3,0,0,'WorkflowTransition',NULL,NULL),(80,3,4,6,3,0,0,'WorkflowTransition',NULL,NULL),(81,3,5,1,3,0,0,'WorkflowTransition',NULL,NULL),(82,3,5,2,3,0,0,'WorkflowTransition',NULL,NULL),(83,3,5,3,3,0,0,'WorkflowTransition',NULL,NULL),(84,3,5,4,3,0,0,'WorkflowTransition',NULL,NULL),(85,3,5,6,3,0,0,'WorkflowTransition',NULL,NULL),(86,3,6,1,3,0,0,'WorkflowTransition',NULL,NULL),(87,3,6,2,3,0,0,'WorkflowTransition',NULL,NULL),(88,3,6,3,3,0,0,'WorkflowTransition',NULL,NULL),(89,3,6,4,3,0,0,'WorkflowTransition',NULL,NULL),(90,3,6,5,3,0,0,'WorkflowTransition',NULL,NULL),(91,1,1,2,4,0,0,'WorkflowTransition',NULL,NULL),(92,1,1,3,4,0,0,'WorkflowTransition',NULL,NULL),(93,1,1,4,4,0,0,'WorkflowTransition',NULL,NULL),(94,1,1,5,4,0,0,'WorkflowTransition',NULL,NULL),(95,1,2,3,4,0,0,'WorkflowTransition',NULL,NULL),(96,1,2,4,4,0,0,'WorkflowTransition',NULL,NULL),(97,1,2,5,4,0,0,'WorkflowTransition',NULL,NULL),(98,1,3,2,4,0,0,'WorkflowTransition',NULL,NULL),(99,1,3,4,4,0,0,'WorkflowTransition',NULL,NULL),(100,1,3,5,4,0,0,'WorkflowTransition',NULL,NULL),(101,1,4,2,4,0,0,'WorkflowTransition',NULL,NULL),(102,1,4,3,4,0,0,'WorkflowTransition',NULL,NULL),(103,1,4,5,4,0,0,'WorkflowTransition',NULL,NULL),(104,2,1,2,4,0,0,'WorkflowTransition',NULL,NULL),(105,2,1,3,4,0,0,'WorkflowTransition',NULL,NULL),(106,2,1,4,4,0,0,'WorkflowTransition',NULL,NULL),(107,2,1,5,4,0,0,'WorkflowTransition',NULL,NULL),(108,2,2,3,4,0,0,'WorkflowTransition',NULL,NULL),(109,2,2,4,4,0,0,'WorkflowTransition',NULL,NULL),(110,2,2,5,4,0,0,'WorkflowTransition',NULL,NULL),(111,2,3,2,4,0,0,'WorkflowTransition',NULL,NULL),(112,2,3,4,4,0,0,'WorkflowTransition',NULL,NULL),(113,2,3,5,4,0,0,'WorkflowTransition',NULL,NULL),(114,2,4,2,4,0,0,'WorkflowTransition',NULL,NULL),(115,2,4,3,4,0,0,'WorkflowTransition',NULL,NULL),(116,2,4,5,4,0,0,'WorkflowTransition',NULL,NULL),(117,3,1,2,4,0,0,'WorkflowTransition',NULL,NULL),(118,3,1,3,4,0,0,'WorkflowTransition',NULL,NULL),(119,3,1,4,4,0,0,'WorkflowTransition',NULL,NULL),(120,3,1,5,4,0,0,'WorkflowTransition',NULL,NULL),(121,3,2,3,4,0,0,'WorkflowTransition',NULL,NULL),(122,3,2,4,4,0,0,'WorkflowTransition',NULL,NULL),(123,3,2,5,4,0,0,'WorkflowTransition',NULL,NULL),(124,3,3,2,4,0,0,'WorkflowTransition',NULL,NULL),(125,3,3,4,4,0,0,'WorkflowTransition',NULL,NULL),(126,3,3,5,4,0,0,'WorkflowTransition',NULL,NULL),(127,3,4,2,4,0,0,'WorkflowTransition',NULL,NULL),(128,3,4,3,4,0,0,'WorkflowTransition',NULL,NULL),(129,3,4,5,4,0,0,'WorkflowTransition',NULL,NULL),(130,1,1,5,5,0,0,'WorkflowTransition',NULL,NULL),(131,1,2,5,5,0,0,'WorkflowTransition',NULL,NULL),(132,1,3,5,5,0,0,'WorkflowTransition',NULL,NULL),(133,1,4,5,5,0,0,'WorkflowTransition',NULL,NULL),(134,1,3,4,5,0,0,'WorkflowTransition',NULL,NULL),(135,2,1,5,5,0,0,'WorkflowTransition',NULL,NULL),(136,2,2,5,5,0,0,'WorkflowTransition',NULL,NULL),(137,2,3,5,5,0,0,'WorkflowTransition',NULL,NULL),(138,2,4,5,5,0,0,'WorkflowTransition',NULL,NULL),(139,2,3,4,5,0,0,'WorkflowTransition',NULL,NULL),(140,3,1,5,5,0,0,'WorkflowTransition',NULL,NULL),(141,3,2,5,5,0,0,'WorkflowTransition',NULL,NULL),(142,3,3,5,5,0,0,'WorkflowTransition',NULL,NULL),(143,3,4,5,5,0,0,'WorkflowTransition',NULL,NULL),(144,3,3,4,5,0,0,'WorkflowTransition',NULL,NULL);
1540/*!40000 ALTER TABLE `workflows` ENABLE KEYS */;
1541UNLOCK TABLES;
1542/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1543
1544/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1545/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1546/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1547/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1548/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1549/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1550/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1551
1552-- Dump completed on 2014-03-03 19:40:08