ZmFtHksp

1-- MySQL dump 10.13  Distrib 5.5.47, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost    Database: ggrcdev
4-- ------------------------------------------------------
5-- Server version	5.5.47-0ubuntu0.14.04.1
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 `access_groups`
20--
21
22DROP TABLE IF EXISTS `access_groups`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `access_groups` (
26  `id` int(11) NOT NULL AUTO_INCREMENT,
27  `os_state` varchar(250) NOT NULL,
28  `end_date` date DEFAULT NULL,
29  `start_date` date DEFAULT NULL,
30  `status` varchar(250) DEFAULT NULL,
31  `notes` text,
32  `description` text,
33  `url` varchar(250) DEFAULT NULL,
34  `reference_url` varchar(250) DEFAULT NULL,
35  `secondary_contact_id` int(11) DEFAULT NULL,
36  `contact_id` int(11) DEFAULT NULL,
37  `title` varchar(250) NOT NULL,
38  `slug` varchar(250) NOT NULL,
39  `created_at` datetime DEFAULT NULL,
40  `modified_by_id` int(11) DEFAULT NULL,
41  `updated_at` datetime DEFAULT NULL,
42  `context_id` int(11) DEFAULT NULL,
43  PRIMARY KEY (`id`),
44  UNIQUE KEY `uq_access_groups` (`slug`),
45  UNIQUE KEY `uq_t_access_groups` (`title`),
46  KEY `fk_access_groups_contact` (`contact_id`),
47  KEY `fk_access_groups_contexts` (`context_id`),
48  KEY `fk_access_groups_secondary_contact` (`secondary_contact_id`),
49  KEY `ix_access_groups_updated_at` (`updated_at`),
50  CONSTRAINT `access_groups_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
51  CONSTRAINT `access_groups_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
52  CONSTRAINT `access_groups_ibfk_3` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54/*!40101 SET character_set_client = @saved_cs_client */;
55
56--
57-- Dumping data for table `access_groups`
58--
59
60LOCK TABLES `access_groups` WRITE;
61/*!40000 ALTER TABLE `access_groups` DISABLE KEYS */;
62/*!40000 ALTER TABLE `access_groups` ENABLE KEYS */;
63UNLOCK TABLES;
64
65--
66-- Table structure for table `assessment_templates`
67--
68
69DROP TABLE IF EXISTS `assessment_templates`;
70/*!40101 SET @saved_cs_client     = @@character_set_client */;
71/*!40101 SET character_set_client = utf8 */;
72CREATE TABLE `assessment_templates` (
73  `id` int(11) NOT NULL AUTO_INCREMENT,
74  `template_object_type` varchar(250) DEFAULT NULL,
75  `test_plan_procedure` tinyint(1) NOT NULL,
76  `procedure_description` text,
77  `default_people` text NOT NULL,
78  `created_at` datetime DEFAULT NULL,
79  `modified_by_id` int(11) DEFAULT NULL,
80  `updated_at` datetime DEFAULT NULL,
81  `context_id` int(11) DEFAULT NULL,
82  `title` varchar(250) NOT NULL,
83  `slug` varchar(250) NOT NULL,
84  PRIMARY KEY (`id`),
85  KEY `context_id` (`context_id`),
86  CONSTRAINT `assessment_templates_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
87) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
88/*!40101 SET character_set_client = @saved_cs_client */;
89
90--
91-- Dumping data for table `assessment_templates`
92--
93
94LOCK TABLES `assessment_templates` WRITE;
95/*!40000 ALTER TABLE `assessment_templates` DISABLE KEYS */;
96INSERT INTO `assessment_templates` VALUES (1,'Control',1,NULL,'{\"assessors\":\"Object Owners\",\"verifiers\":\"Object Owners\"}','2016-04-14 22:20:26',1,'2016-04-14 22:20:26',5,'Simple Assessment Template','TEMPLATE-1'),(2,'Control',0,NULL,'{\"assessors\":\"Object Owners\",\"verifiers\":\"Object Owners\"}','2016-04-14 22:22:41',1,'2016-04-14 22:22:41',5,'Full Assessment Template','TEMPLATE-2'),(3,'Control',0,NULL,'{\"assessors\":\"Object Owners\",\"verifiers\":\"Object Owners\"}','2016-04-14 22:25:43',1,'2016-04-14 22:25:43',5,'Different Assessment Template','TEMPLATE-3');
97/*!40000 ALTER TABLE `assessment_templates` ENABLE KEYS */;
98UNLOCK TABLES;
99
100--
101-- Table structure for table `assessments`
102--
103
104DROP TABLE IF EXISTS `assessments`;
105/*!40101 SET @saved_cs_client     = @@character_set_client */;
106/*!40101 SET character_set_client = utf8 */;
107CREATE TABLE `assessments` (
108  `id` int(11) NOT NULL AUTO_INCREMENT,
109  `design` varchar(250) DEFAULT NULL,
110  `operationally` varchar(250) DEFAULT NULL,
111  `os_state` varchar(250) NOT NULL,
112  `test_plan` text,
113  `end_date` date DEFAULT NULL,
114  `start_date` date DEFAULT NULL,
115  `status` enum('Open','In Progress','Finished','Verified','Final') NOT NULL DEFAULT 'Open',
116  `notes` text,
117  `description` text,
118  `url` varchar(250) DEFAULT NULL,
119  `reference_url` varchar(250) DEFAULT NULL,
120  `secondary_contact_id` int(11) DEFAULT NULL,
121  `contact_id` int(11) DEFAULT NULL,
122  `title` varchar(250) NOT NULL,
123  `slug` varchar(250) NOT NULL,
124  `created_at` datetime DEFAULT NULL,
125  `modified_by_id` int(11) DEFAULT NULL,
126  `updated_at` datetime DEFAULT NULL,
127  `context_id` int(11) DEFAULT NULL,
128  `control_id` int(11) DEFAULT NULL,
129  `finished_date` datetime DEFAULT NULL,
130  `verified_date` datetime DEFAULT NULL,
131  `recipients` varchar(250) DEFAULT NULL,
132  `send_by_default` tinyint(1) DEFAULT NULL,
133  PRIMARY KEY (`id`),
134  UNIQUE KEY `uq_control_assessments` (`slug`),
135  KEY `contact_id` (`contact_id`),
136  KEY `context_id` (`context_id`),
137  KEY `secondary_contact_id` (`secondary_contact_id`),
138  KEY `fk_control_control_assessment` (`control_id`),
139  CONSTRAINT `assessments_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
140  CONSTRAINT `assessments_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
141  CONSTRAINT `assessments_ibfk_3` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`),
142  CONSTRAINT `fk_control_control_assessment` FOREIGN KEY (`control_id`) REFERENCES `controls` (`id`)
143) ENGINE=InnoDB DEFAULT CHARSET=utf8;
144/*!40101 SET character_set_client = @saved_cs_client */;
145
146--
147-- Dumping data for table `assessments`
148--
149
150LOCK TABLES `assessments` WRITE;
151/*!40000 ALTER TABLE `assessments` DISABLE KEYS */;
152/*!40000 ALTER TABLE `assessments` ENABLE KEYS */;
153UNLOCK TABLES;
154
155--
156-- Table structure for table `audit_objects`
157--
158
159DROP TABLE IF EXISTS `audit_objects`;
160/*!40101 SET @saved_cs_client     = @@character_set_client */;
161/*!40101 SET character_set_client = utf8 */;
162CREATE TABLE `audit_objects` (
163  `id` int(11) NOT NULL AUTO_INCREMENT,
164  `modified_by_id` int(11) DEFAULT NULL,
165  `created_at` datetime DEFAULT NULL,
166  `updated_at` datetime DEFAULT NULL,
167  `context_id` int(11) NOT NULL,
168  `audit_id` int(11) NOT NULL,
169  `auditable_id` int(11) NOT NULL,
170  `auditable_type` varchar(250) NOT NULL,
171  PRIMARY KEY (`id`),
172  UNIQUE KEY `audit_id` (`audit_id`,`auditable_id`,`auditable_type`),
173  KEY `context_id` (`context_id`),
174  CONSTRAINT `audit_objects_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
175  CONSTRAINT `audit_objects_ibfk_2` FOREIGN KEY (`audit_id`) REFERENCES `audits` (`id`)
176) ENGINE=InnoDB DEFAULT CHARSET=utf8;
177/*!40101 SET character_set_client = @saved_cs_client */;
178
179--
180-- Dumping data for table `audit_objects`
181--
182
183LOCK TABLES `audit_objects` WRITE;
184/*!40000 ALTER TABLE `audit_objects` DISABLE KEYS */;
185/*!40000 ALTER TABLE `audit_objects` ENABLE KEYS */;
186UNLOCK TABLES;
187
188--
189-- Table structure for table `audits`
190--
191
192DROP TABLE IF EXISTS `audits`;
193/*!40101 SET @saved_cs_client     = @@character_set_client */;
194/*!40101 SET character_set_client = utf8 */;
195CREATE TABLE `audits` (
196  `id` int(11) NOT NULL AUTO_INCREMENT,
197  `title` varchar(250) NOT NULL,
198  `slug` varchar(250) NOT NULL,
199  `description` text,
200  `url` varchar(250) DEFAULT NULL,
201  `start_date` date DEFAULT NULL,
202  `end_date` date DEFAULT NULL,
203  `report_start_date` date DEFAULT NULL,
204  `report_end_date` date DEFAULT NULL,
205  `contact_id` int(11) DEFAULT NULL,
206  `status` enum('Planned','In Progress','Manager Review','Ready for External Review','Completed') NOT NULL,
207  `gdrive_evidence_folder` varchar(250) DEFAULT NULL,
208  `program_id` int(11) NOT NULL,
209  `created_at` datetime DEFAULT NULL,
210  `modified_by_id` int(11) DEFAULT NULL,
211  `updated_at` datetime DEFAULT NULL,
212  `context_id` int(11) DEFAULT NULL,
213  `notes` text,
214  `audit_firm_id` int(11) DEFAULT NULL,
215  `reference_url` varchar(250) DEFAULT NULL,
216  `object_type` varchar(250) NOT NULL,
217  `secondary_contact_id` int(11) DEFAULT NULL,
218  PRIMARY KEY (`id`),
219  UNIQUE KEY `uq_t_audits` (`title`),
220  KEY `program_id` (`program_id`),
221  KEY `fk_audits_contact` (`contact_id`),
222  KEY `fk_audits_contexts` (`context_id`),
223  KEY `ix_audits_updated_at` (`updated_at`),
224  KEY `fk_audits_secondary_contact` (`secondary_contact_id`),
225  CONSTRAINT `audits_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
226  CONSTRAINT `audits_ibfk_3` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`)
227) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
228/*!40101 SET character_set_client = @saved_cs_client */;
229
230--
231-- Dumping data for table `audits`
232--
233
234LOCK TABLES `audits` WRITE;
235/*!40000 ALTER TABLE `audits` DISABLE KEYS */;
236INSERT INTO `audits` VALUES (1,'2016: Program 1 - Audit 1','AUDIT-1','',NULL,'2016-04-25','2016-05-25',NULL,NULL,1,'Planned',NULL,1,'2016-04-14 22:16:52',1,'2016-04-14 22:16:52',5,NULL,NULL,NULL,'Assessment',NULL);
237/*!40000 ALTER TABLE `audits` ENABLE KEYS */;
238UNLOCK TABLES;
239
240--
241-- Table structure for table `background_tasks`
242--
243
244DROP TABLE IF EXISTS `background_tasks`;
245/*!40101 SET @saved_cs_client     = @@character_set_client */;
246/*!40101 SET character_set_client = utf8 */;
247CREATE TABLE `background_tasks` (
248  `id` int(11) NOT NULL AUTO_INCREMENT,
249  `name` varchar(250) DEFAULT NULL,
250  `parameters` mediumblob,
251  `result` mediumblob,
252  `created_at` datetime DEFAULT NULL,
253  `modified_by_id` int(11) DEFAULT NULL,
254  `updated_at` datetime DEFAULT NULL,
255  `context_id` int(11) DEFAULT NULL,
256  `status` varchar(250) DEFAULT NULL,
257  PRIMARY KEY (`id`),
258  KEY `fk_background_tasks_contexts` (`context_id`),
259  KEY `ix_background_tasks_updated_at` (`updated_at`),
260  CONSTRAINT `background_tasks_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
261) ENGINE=InnoDB DEFAULT CHARSET=utf8;
262/*!40101 SET character_set_client = @saved_cs_client */;
263
264--
265-- Dumping data for table `background_tasks`
266--
267
268LOCK TABLES `background_tasks` WRITE;
269/*!40000 ALTER TABLE `background_tasks` DISABLE KEYS */;
270/*!40000 ALTER TABLE `background_tasks` ENABLE KEYS */;
271UNLOCK TABLES;
272
273--
274-- Table structure for table `categories`
275--
276
277DROP TABLE IF EXISTS `categories`;
278/*!40101 SET @saved_cs_client     = @@character_set_client */;
279/*!40101 SET character_set_client = utf8 */;
280CREATE TABLE `categories` (
281  `id` int(11) NOT NULL AUTO_INCREMENT,
282  `modified_by_id` int(11) DEFAULT NULL,
283  `created_at` datetime DEFAULT NULL,
284  `updated_at` datetime DEFAULT NULL,
285  `name` varchar(250) DEFAULT NULL,
286  `lft` int(11) DEFAULT NULL,
287  `rgt` int(11) DEFAULT NULL,
288  `scope_id` int(11) DEFAULT NULL,
289  `depth` int(11) DEFAULT NULL,
290  `required` tinyint(1) DEFAULT NULL,
291  `parent_id` int(11) DEFAULT NULL,
292  `context_id` int(11) DEFAULT NULL,
293  `type` varchar(250) DEFAULT NULL,
294  PRIMARY KEY (`id`),
295  KEY `parent_id` (`parent_id`),
296  KEY `fk_categories_contexts` (`context_id`),
297  KEY `ix_categories_updated_at` (`updated_at`),
298  CONSTRAINT `fk_categories_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
299) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
300/*!40101 SET character_set_client = @saved_cs_client */;
301
302--
303-- Dumping data for table `categories`
304--
305
306LOCK TABLES `categories` WRITE;
307/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
308INSERT INTO `categories` VALUES (37,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Confidentiality',NULL,NULL,102,NULL,NULL,NULL,NULL,'ControlAssertion'),(38,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Integrity',NULL,NULL,102,NULL,NULL,NULL,NULL,'ControlAssertion'),(39,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Availability',NULL,NULL,102,NULL,NULL,NULL,NULL,'ControlAssertion'),(40,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Security',NULL,NULL,102,NULL,NULL,NULL,NULL,'ControlAssertion'),(41,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Privacy',NULL,NULL,102,NULL,NULL,NULL,NULL,'ControlAssertion'),(42,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Org and Admin/Governance',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(43,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Training',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(44,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Policies & Procedures',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(45,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','HR',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(46,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Logical Access/ Access Control',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(47,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Access Management',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(48,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Authorization',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(49,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Authentication',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(50,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Change Management',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(51,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Segregation of Duties',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(52,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Configuration Management',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(53,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Package Verification and Code release',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(54,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Incident Management',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(55,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Monitoring ',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(56,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Process',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(57,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Business Continuity',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(58,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Disaster Recovery',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(59,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Restoration Tests',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(60,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Backup Logs ',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(61,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Replication',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(62,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Data Protection and Retention',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(63,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Physical Security',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(64,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Data Centers',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory'),(65,NULL,'2016-04-14 22:13:45','2016-04-14 22:13:45','Sites',NULL,NULL,100,NULL,NULL,NULL,NULL,'ControlCategory');
309/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
310UNLOCK TABLES;
311
312--
313-- Table structure for table `categorizations`
314--
315
316DROP TABLE IF EXISTS `categorizations`;
317/*!40101 SET @saved_cs_client     = @@character_set_client */;
318/*!40101 SET character_set_client = utf8 */;
319CREATE TABLE `categorizations` (
320  `id` int(11) NOT NULL AUTO_INCREMENT,
321  `modified_by_id` int(11) DEFAULT NULL,
322  `created_at` datetime DEFAULT NULL,
323  `updated_at` datetime DEFAULT NULL,
324  `category_id` int(11) NOT NULL,
325  `categorizable_id` int(11) DEFAULT NULL,
326  `categorizable_type` varchar(250) DEFAULT NULL,
327  `context_id` int(11) DEFAULT NULL,
328  `category_type` varchar(250) DEFAULT NULL,
329  PRIMARY KEY (`id`),
330  KEY `category_id` (`category_id`),
331  KEY `fk_categorizations_contexts` (`context_id`),
332  KEY `ix_categorizations_updated_at` (`updated_at`),
333  CONSTRAINT `categorizations_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
334  CONSTRAINT `fk_categorizations_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
335) ENGINE=InnoDB DEFAULT CHARSET=utf8;
336/*!40101 SET character_set_client = @saved_cs_client */;
337
338--
339-- Dumping data for table `categorizations`
340--
341
342LOCK TABLES `categorizations` WRITE;
343/*!40000 ALTER TABLE `categorizations` DISABLE KEYS */;
344/*!40000 ALTER TABLE `categorizations` ENABLE KEYS */;
345UNLOCK TABLES;
346
347--
348-- Table structure for table `clauses`
349--
350
351DROP TABLE IF EXISTS `clauses`;
352/*!40101 SET @saved_cs_client     = @@character_set_client */;
353/*!40101 SET character_set_client = utf8 */;
354CREATE TABLE `clauses` (
355  `id` int(11) NOT NULL AUTO_INCREMENT,
356  `na` tinyint(1) NOT NULL,
357  `notes` text,
358  `os_state` varchar(250) NOT NULL,
359  `parent_id` int(11) DEFAULT NULL,
360  `description` text,
361  `url` varchar(250) DEFAULT NULL,
362  `reference_url` varchar(250) DEFAULT NULL,
363  `secondary_contact_id` int(11) DEFAULT NULL,
364  `contact_id` int(11) DEFAULT NULL,
365  `title` varchar(250) NOT NULL,
366  `slug` varchar(250) NOT NULL,
367  `created_at` datetime DEFAULT NULL,
368  `modified_by_id` int(11) DEFAULT NULL,
369  `updated_at` datetime DEFAULT NULL,
370  `context_id` int(11) DEFAULT NULL,
371  `status` varchar(250) DEFAULT NULL,
372  `end_date` date DEFAULT NULL,
373  `start_date` date DEFAULT NULL,
374  PRIMARY KEY (`id`),
375  UNIQUE KEY `uq_clauses` (`slug`),
376  UNIQUE KEY `uq_t_clauses` (`title`),
377  KEY `contact_id` (`contact_id`),
378  KEY `context_id` (`context_id`),
379  KEY `parent_id` (`parent_id`),
380  KEY `secondary_contact_id` (`secondary_contact_id`),
381  CONSTRAINT `clauses_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
382  CONSTRAINT `clauses_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
383  CONSTRAINT `clauses_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `clauses` (`id`),
384  CONSTRAINT `clauses_ibfk_4` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`)
385) ENGINE=InnoDB DEFAULT CHARSET=utf8;
386/*!40101 SET character_set_client = @saved_cs_client */;
387
388--
389-- Dumping data for table `clauses`
390--
391
392LOCK TABLES `clauses` WRITE;
393/*!40000 ALTER TABLE `clauses` DISABLE KEYS */;
394/*!40000 ALTER TABLE `clauses` ENABLE KEYS */;
395UNLOCK TABLES;
396
397--
398-- Table structure for table `comments`
399--
400
401DROP TABLE IF EXISTS `comments`;
402/*!40101 SET @saved_cs_client     = @@character_set_client */;
403/*!40101 SET character_set_client = utf8 */;
404CREATE TABLE `comments` (
405  `id` int(11) NOT NULL AUTO_INCREMENT,
406  `description` text,
407  `created_at` datetime DEFAULT NULL,
408  `modified_by_id` int(11) DEFAULT NULL,
409  `updated_at` datetime DEFAULT NULL,
410  `context_id` int(11) DEFAULT NULL,
411  `assignee_type` text,
412  PRIMARY KEY (`id`),
413  KEY `context_id` (`context_id`),
414  CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
415) ENGINE=InnoDB DEFAULT CHARSET=utf8;
416/*!40101 SET character_set_client = @saved_cs_client */;
417
418--
419-- Dumping data for table `comments`
420--
421
422LOCK TABLES `comments` WRITE;
423/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
424/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
425UNLOCK TABLES;
426
427--
428-- Table structure for table `context_implications`
429--
430
431DROP TABLE IF EXISTS `context_implications`;
432/*!40101 SET @saved_cs_client     = @@character_set_client */;
433/*!40101 SET character_set_client = utf8 */;
434CREATE TABLE `context_implications` (
435  `id` int(11) NOT NULL AUTO_INCREMENT,
436  `context_id` int(11) DEFAULT NULL,
437  `source_context_id` int(11) DEFAULT NULL,
438  `modified_by_id` int(11) DEFAULT NULL,
439  `created_at` datetime DEFAULT NULL,
440  `updated_at` datetime DEFAULT NULL,
441  `context_scope` varchar(128) DEFAULT NULL,
442  `source_context_scope` varchar(128) DEFAULT NULL,
443  PRIMARY KEY (`id`),
444  KEY `fk_context_implications_contexts` (`context_id`),
445  KEY `ix_context_implications_updated_at` (`updated_at`)
446) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
447/*!40101 SET character_set_client = @saved_cs_client */;
448
449--
450-- Dumping data for table `context_implications`
451--
452
453LOCK TABLES `context_implications` WRITE;
454/*!40000 ALTER TABLE `context_implications` DISABLE KEYS */;
455INSERT INTO `context_implications` VALUES (1,NULL,NULL,NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,NULL),(2,NULL,4,1,'2016-04-14 22:15:01','2016-04-14 22:15:01',NULL,'Program'),(3,4,NULL,1,'2016-04-14 22:15:01','2016-04-14 22:15:01','Program',NULL),(4,5,4,1,'2016-04-14 22:16:52','2016-04-14 22:16:52','Audit','Program'),(5,4,5,1,'2016-04-14 22:16:52','2016-04-14 22:16:52','Program','Audit'),(6,NULL,5,1,'2016-04-14 22:16:52','2016-04-14 22:16:52',NULL,'Audit');
456/*!40000 ALTER TABLE `context_implications` ENABLE KEYS */;
457UNLOCK TABLES;
458
459--
460-- Table structure for table `contexts`
461--
462
463DROP TABLE IF EXISTS `contexts`;
464/*!40101 SET @saved_cs_client     = @@character_set_client */;
465/*!40101 SET character_set_client = utf8 */;
466CREATE TABLE `contexts` (
467  `id` int(11) NOT NULL AUTO_INCREMENT,
468  `name` varchar(128) DEFAULT NULL,
469  `description` text,
470  `related_object_id` int(11) DEFAULT NULL,
471  `related_object_type` varchar(128) DEFAULT NULL,
472  `modified_by_id` int(11) DEFAULT NULL,
473  `created_at` datetime DEFAULT NULL,
474  `updated_at` datetime DEFAULT NULL,
475  `context_id` int(11) DEFAULT NULL,
476  PRIMARY KEY (`id`),
477  KEY `fk_contexts_contexts` (`context_id`),
478  KEY `ix_context_related_object` (`related_object_type`,`related_object_id`),
479  KEY `ix_contexts_updated_at` (`updated_at`)
480) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
481/*!40101 SET character_set_client = @saved_cs_client */;
482
483--
484-- Dumping data for table `contexts`
485--
486
487LOCK TABLES `contexts` WRITE;
488/*!40000 ALTER TABLE `contexts` DISABLE KEYS */;
489INSERT INTO `contexts` VALUES (0,'System Administration','Context for super-user permissions.',NULL,NULL,NULL,NULL,NULL,NULL),(1,'Administration','Context for Administrative resources.',NULL,NULL,0,NULL,NULL,1),(3,'Personal Context for user@example.com','',1,'Person',1,'2016-04-14 22:14:02','2016-04-14 22:15:01',4),(4,'Program Context 2016-04-14 22:15:01.893380','',1,'Program',1,'2016-04-14 22:15:01','2016-04-14 22:16:52',5),(5,'Audit Context 2016-04-14 22:16:52.345295','',1,'Audit',1,'2016-04-14 22:16:52','2016-04-14 22:16:52',NULL);
490/*!40000 ALTER TABLE `contexts` ENABLE KEYS */;
491UNLOCK TABLES;
492
493--
494-- Table structure for table `controls`
495--
496
497DROP TABLE IF EXISTS `controls`;
498/*!40101 SET @saved_cs_client     = @@character_set_client */;
499/*!40101 SET character_set_client = utf8 */;
500CREATE TABLE `controls` (
501  `id` int(11) NOT NULL AUTO_INCREMENT,
502  `modified_by_id` int(11) DEFAULT NULL,
503  `created_at` datetime DEFAULT NULL,
504  `updated_at` datetime DEFAULT NULL,
505  `description` text,
506  `url` varchar(250) DEFAULT NULL,
507  `start_date` date DEFAULT NULL,
508  `end_date` date DEFAULT NULL,
509  `slug` varchar(250) NOT NULL,
510  `title` varchar(250) NOT NULL,
511  `directive_id` int(11) DEFAULT NULL,
512  `kind_id` int(11) DEFAULT NULL,
513  `means_id` int(11) DEFAULT NULL,
514  `version` varchar(250) DEFAULT NULL,
515  `documentation_description` text,
516  `verify_frequency_id` int(11) DEFAULT NULL,
517  `fraud_related` tinyint(1) DEFAULT NULL,
518  `key_control` tinyint(1) DEFAULT NULL,
519  `active` tinyint(1) DEFAULT NULL,
520  `notes` text,
521  `parent_id` int(11) DEFAULT NULL,
522  `company_control` tinyint(1) DEFAULT NULL,
523  `context_id` int(11) DEFAULT NULL,
524  `contact_id` int(11) DEFAULT NULL,
525  `status` varchar(250) DEFAULT NULL,
526  `principal_assessor_id` int(11) DEFAULT NULL,
527  `secondary_assessor_id` int(11) DEFAULT NULL,
528  `reference_url` varchar(250) DEFAULT NULL,
529  `secondary_contact_id` int(11) DEFAULT NULL,
530  `os_state` varchar(16) NOT NULL,
531  `test_plan` text,
532  PRIMARY KEY (`id`),
533  UNIQUE KEY `uq_controls` (`slug`),
534  UNIQUE KEY `uq_t_controls` (`title`),
535  KEY `directive_id` (`directive_id`),
536  KEY `parent_id` (`parent_id`),
537  KEY `fk_controls_contexts` (`context_id`),
538  KEY `fk_controls_contact` (`contact_id`),
539  KEY `ix_controls_principal_assessor` (`principal_assessor_id`),
540  KEY `ix_controls_secondary_assessor` (`secondary_assessor_id`),
541  KEY `ix_controls_updated_at` (`updated_at`),
542  KEY `fk_controls_secondary_contact` (`secondary_contact_id`),
543  CONSTRAINT `controls_ibfk_1` FOREIGN KEY (`directive_id`) REFERENCES `directives` (`id`),
544  CONSTRAINT `controls_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `controls` (`id`),
545  CONSTRAINT `fk_controls_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
546) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
547/*!40101 SET character_set_client = @saved_cs_client */;
548
549--
550-- Dumping data for table `controls`
551--
552
553LOCK TABLES `controls` WRITE;
554/*!40000 ALTER TABLE `controls` DISABLE KEYS */;
555INSERT INTO `controls` VALUES (1,1,'2016-04-18 03:48:20','2016-04-18 03:48:20','Description for Control 1','',NULL,NULL,'CONTROL-1','Control 1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Some notes for Control 1',NULL,NULL,NULL,1,'Draft',NULL,NULL,'',NULL,'Modified','Test Plan for Control 1'),(2,1,'2016-04-18 03:48:49','2016-04-18 03:48:49','Description for Control 2','',NULL,NULL,'CONTROL-2','Control 2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,1,'Draft',NULL,NULL,'',NULL,'Modified','Test Plan for Control 2');
556/*!40000 ALTER TABLE `controls` ENABLE KEYS */;
557UNLOCK TABLES;
558
559--
560-- Table structure for table `custom_attribute_definitions`
561--
562
563DROP TABLE IF EXISTS `custom_attribute_definitions`;
564/*!40101 SET @saved_cs_client     = @@character_set_client */;
565/*!40101 SET character_set_client = utf8 */;
566CREATE TABLE `custom_attribute_definitions` (
567  `id` int(11) NOT NULL AUTO_INCREMENT,
568  `modified_by_id` int(11) DEFAULT NULL,
569  `context_id` int(11) DEFAULT NULL,
570  `created_at` datetime DEFAULT NULL,
571  `updated_at` datetime DEFAULT NULL,
572  `title` varchar(250) NOT NULL,
573  `helptext` varchar(250) DEFAULT NULL,
574  `placeholder` varchar(250) DEFAULT NULL,
575  `definition_type` varchar(250) NOT NULL,
576  `attribute_type` varchar(250) NOT NULL,
577  `multi_choice_options` text,
578  `mandatory` tinyint(1) DEFAULT NULL,
579  `definition_id` int(11) DEFAULT NULL,
580  `multi_choice_mandatory` text,
581  PRIMARY KEY (`id`),
582  UNIQUE KEY `uq_custom_attribute` (`definition_type`,`definition_id`,`title`),
583  KEY `ix_custom_attributes_title` (`title`)
584) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
585/*!40101 SET character_set_client = @saved_cs_client */;
586
587--
588-- Dumping data for table `custom_attribute_definitions`
589--
590
591LOCK TABLES `custom_attribute_definitions` WRITE;
592/*!40000 ALTER TABLE `custom_attribute_definitions` DISABLE KEYS */;
593INSERT INTO `custom_attribute_definitions` VALUES (1,1,5,'2016-04-14 22:20:27','2016-04-14 22:20:27','OCA Text',NULL,NULL,'assessment_template','Text','',NULL,1,NULL),(2,1,5,'2016-04-14 22:22:41','2016-04-14 22:22:41','OCA Rich Text',NULL,NULL,'assessment_template','Rich Text','',NULL,2,NULL),(3,1,5,'2016-04-14 22:22:41','2016-04-14 22:22:41','OCA Date',NULL,NULL,'assessment_template','Date','',NULL,2,NULL),(4,1,5,'2016-04-14 22:22:41','2016-04-14 22:22:41','OCA Chexbox',NULL,NULL,'assessment_template','Checkbox','box 1,box 2,box 3',NULL,2,NULL),(5,1,5,'2016-04-14 22:22:41','2016-04-14 22:22:41','OCA Dropdown',NULL,NULL,'assessment_template','Dropdown','value 1,value 2,value 3',NULL,2,NULL),(6,1,5,'2016-04-14 22:22:41','2016-04-14 22:22:41','OCA Person',NULL,NULL,'assessment_template','Map:Person','',NULL,2,NULL),(7,1,5,'2016-04-14 22:25:43','2016-04-14 22:25:43','OCA Text',NULL,NULL,'assessment_template','Text','',NULL,3,NULL),(8,1,NULL,'2016-04-21 14:52:56','2016-04-21 14:52:56','CA checkbox','',NULL,'assessment','Checkbox',NULL,0,NULL,NULL);
594/*!40000 ALTER TABLE `custom_attribute_definitions` ENABLE KEYS */;
595UNLOCK TABLES;
596
597--
598-- Table structure for table `custom_attribute_values`
599--
600
601DROP TABLE IF EXISTS `custom_attribute_values`;
602/*!40101 SET @saved_cs_client     = @@character_set_client */;
603/*!40101 SET character_set_client = utf8 */;
604CREATE TABLE `custom_attribute_values` (
605  `id` int(11) NOT NULL AUTO_INCREMENT,
606  `modified_by_id` int(11) DEFAULT NULL,
607  `context_id` int(11) DEFAULT NULL,
608  `created_at` datetime DEFAULT NULL,
609  `updated_at` datetime DEFAULT NULL,
610  `custom_attribute_id` int(11) NOT NULL,
611  `attributable_id` int(11) DEFAULT NULL,
612  `attributable_type` varchar(250) DEFAULT NULL,
613  `attribute_value` text,
614  `attribute_object_id` int(11) DEFAULT NULL,
615  PRIMARY KEY (`id`),
616  KEY `ix_custom_attributes_attributable` (`attributable_id`,`attributable_type`),
617  KEY `custom_attribute_values_ibfk_1` (`custom_attribute_id`),
618  CONSTRAINT `custom_attribute_values_ibfk_1` FOREIGN KEY (`custom_attribute_id`) REFERENCES `custom_attribute_definitions` (`id`) ON DELETE CASCADE
619) ENGINE=InnoDB DEFAULT CHARSET=utf8;
620/*!40101 SET character_set_client = @saved_cs_client */;
621
622--
623-- Dumping data for table `custom_attribute_values`
624--
625
626LOCK TABLES `custom_attribute_values` WRITE;
627/*!40000 ALTER TABLE `custom_attribute_values` DISABLE KEYS */;
628/*!40000 ALTER TABLE `custom_attribute_values` ENABLE KEYS */;
629UNLOCK TABLES;
630
631--
632-- Table structure for table `cycle_task_entries`
633--
634
635DROP TABLE IF EXISTS `cycle_task_entries`;
636/*!40101 SET @saved_cs_client     = @@character_set_client */;
637/*!40101 SET character_set_client = utf8 */;
638CREATE TABLE `cycle_task_entries` (
639  `id` int(11) NOT NULL AUTO_INCREMENT,
640  `cycle_task_group_object_task_id` int(11) NOT NULL,
641  `description` text,
642  `created_at` datetime DEFAULT NULL,
643  `modified_by_id` int(11) DEFAULT NULL,
644  `updated_at` datetime DEFAULT NULL,
645  `context_id` int(11) DEFAULT NULL,
646  `cycle_id` int(11) NOT NULL,
647  `_is_declining_review` tinyint(1) DEFAULT NULL,
648  PRIMARY KEY (`id`),
649  KEY `cycle_task_group_object_task_id` (`cycle_task_group_object_task_id`),
650  KEY `fk_cycle_task_entries_contexts` (`context_id`),
651  KEY `cycle_task_entries_cycle` (`cycle_id`),
652  KEY `ix_cycle_task_entries_updated_at` (`updated_at`),
653  CONSTRAINT `cycle_task_entries_cycle` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`),
654  CONSTRAINT `cycle_task_entries_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
655  CONSTRAINT `cycle_task_entries_ibfk_2` FOREIGN KEY (`cycle_task_group_object_task_id`) REFERENCES `cycle_task_group_object_tasks` (`id`)
656) ENGINE=InnoDB DEFAULT CHARSET=utf8;
657/*!40101 SET character_set_client = @saved_cs_client */;
658
659--
660-- Dumping data for table `cycle_task_entries`
661--
662
663LOCK TABLES `cycle_task_entries` WRITE;
664/*!40000 ALTER TABLE `cycle_task_entries` DISABLE KEYS */;
665/*!40000 ALTER TABLE `cycle_task_entries` ENABLE KEYS */;
666UNLOCK TABLES;
667
668--
669-- Table structure for table `cycle_task_group_object_tasks`
670--
671
672DROP TABLE IF EXISTS `cycle_task_group_object_tasks`;
673/*!40101 SET @saved_cs_client     = @@character_set_client */;
674/*!40101 SET character_set_client = utf8 */;
675CREATE TABLE `cycle_task_group_object_tasks` (
676  `id` int(11) NOT NULL AUTO_INCREMENT,
677  `cycle_task_group_object_id` int(11) DEFAULT NULL,
678  `task_group_task_id` int(11) NOT NULL,
679  `contact_id` int(11) DEFAULT NULL,
680  `status` varchar(250) DEFAULT NULL,
681  `end_date` date DEFAULT NULL,
682  `start_date` date DEFAULT NULL,
683  `description` text,
684  `title` varchar(250) NOT NULL,
685  `created_at` datetime DEFAULT NULL,
686  `modified_by_id` int(11) DEFAULT NULL,
687  `updated_at` datetime DEFAULT NULL,
688  `context_id` int(11) DEFAULT NULL,
689  `sort_index` varchar(250) NOT NULL,
690  `cycle_id` int(11) NOT NULL,
691  `response_options` text NOT NULL,
692  `selected_response_options` text NOT NULL,
693  `task_type` varchar(250) NOT NULL,
694  `cycle_task_group_id` int(11) NOT NULL,
695  `secondary_contact_id` int(11) DEFAULT NULL,
696  `slug` varchar(250) NOT NULL,
697  `finished_date` datetime DEFAULT NULL,
698  `verified_date` datetime DEFAULT NULL,
699  PRIMARY KEY (`id`),
700  UNIQUE KEY `unique_slug` (`slug`),
701  KEY `cycle_task_group_object_id` (`cycle_task_group_object_id`),
702  KEY `task_group_task_id` (`task_group_task_id`),
703  KEY `fk_cycle_task_group_object_tasks_contact` (`contact_id`),
704  KEY `fk_cycle_task_group_object_tasks_contexts` (`context_id`),
705  KEY `cycle_task_group_object_tasks_cycle` (`cycle_id`),
706  KEY `ix_cycle_task_group_object_tasks_updated_at` (`updated_at`),
707  KEY `cycle_task_group_id` (`cycle_task_group_id`),
708  KEY `fk_cycle_task_group_object_tasks_secondary_contact` (`secondary_contact_id`),
709  CONSTRAINT `cycle_task_group_id` FOREIGN KEY (`cycle_task_group_id`) REFERENCES `cycle_task_groups` (`id`),
710  CONSTRAINT `cycle_task_group_object_tasks_cycle` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`),
711  CONSTRAINT `cycle_task_group_object_tasks_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
712  CONSTRAINT `cycle_task_group_object_tasks_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
713  CONSTRAINT `cycle_task_group_object_tasks_ibfk_3` FOREIGN KEY (`cycle_task_group_object_id`) REFERENCES `cycle_task_group_objects` (`id`)
714) ENGINE=InnoDB DEFAULT CHARSET=utf8;
715/*!40101 SET character_set_client = @saved_cs_client */;
716
717--
718-- Dumping data for table `cycle_task_group_object_tasks`
719--
720
721LOCK TABLES `cycle_task_group_object_tasks` WRITE;
722/*!40000 ALTER TABLE `cycle_task_group_object_tasks` DISABLE KEYS */;
723/*!40000 ALTER TABLE `cycle_task_group_object_tasks` ENABLE KEYS */;
724UNLOCK TABLES;
725
726--
727-- Table structure for table `cycle_task_group_objects`
728--
729
730DROP TABLE IF EXISTS `cycle_task_group_objects`;
731/*!40101 SET @saved_cs_client     = @@character_set_client */;
732/*!40101 SET character_set_client = utf8 */;
733CREATE TABLE `cycle_task_group_objects` (
734  `id` int(11) NOT NULL AUTO_INCREMENT,
735  `cycle_task_group_id` int(11) NOT NULL,
736  `task_group_object_id` int(11) NOT NULL,
737  `contact_id` int(11) DEFAULT NULL,
738  `status` varchar(250) DEFAULT NULL,
739  `end_date` date DEFAULT NULL,
740  `start_date` date DEFAULT NULL,
741  `description` text,
742  `title` varchar(250) NOT NULL,
743  `created_at` datetime DEFAULT NULL,
744  `modified_by_id` int(11) DEFAULT NULL,
745  `updated_at` datetime DEFAULT NULL,
746  `context_id` int(11) DEFAULT NULL,
747  `cycle_id` int(11) NOT NULL,
748  `object_id` int(11) NOT NULL,
749  `object_type` varchar(250) NOT NULL,
750  `next_due_date` date DEFAULT NULL,
751  `secondary_contact_id` int(11) DEFAULT NULL,
752  PRIMARY KEY (`id`),
753  KEY `cycle_task_group_id` (`cycle_task_group_id`),
754  KEY `task_group_object_id` (`task_group_object_id`),
755  KEY `fk_cycle_task_group_objects_contact` (`contact_id`),
756  KEY `fk_cycle_task_group_objects_contexts` (`context_id`),
757  KEY `cycle_task_group_objects_cycle` (`cycle_id`),
758  KEY `ix_cycle_task_group_objects_updated_at` (`updated_at`),
759  KEY `fk_cycle_task_group_objects_secondary_contact` (`secondary_contact_id`),
760  CONSTRAINT `cycle_task_group_objects_cycle` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`),
761  CONSTRAINT `cycle_task_group_objects_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
762  CONSTRAINT `cycle_task_group_objects_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
763  CONSTRAINT `cycle_task_group_objects_ibfk_3` FOREIGN KEY (`cycle_task_group_id`) REFERENCES `cycle_task_groups` (`id`)
764) ENGINE=InnoDB DEFAULT CHARSET=utf8;
765/*!40101 SET character_set_client = @saved_cs_client */;
766
767--
768-- Dumping data for table `cycle_task_group_objects`
769--
770
771LOCK TABLES `cycle_task_group_objects` WRITE;
772/*!40000 ALTER TABLE `cycle_task_group_objects` DISABLE KEYS */;
773/*!40000 ALTER TABLE `cycle_task_group_objects` ENABLE KEYS */;
774UNLOCK TABLES;
775
776--
777-- Table structure for table `cycle_task_groups`
778--
779
780DROP TABLE IF EXISTS `cycle_task_groups`;
781/*!40101 SET @saved_cs_client     = @@character_set_client */;
782/*!40101 SET character_set_client = utf8 */;
783CREATE TABLE `cycle_task_groups` (
784  `id` int(11) NOT NULL AUTO_INCREMENT,
785  `cycle_id` int(11) NOT NULL,
786  `task_group_id` int(11) DEFAULT NULL,
787  `contact_id` int(11) DEFAULT NULL,
788  `status` varchar(250) DEFAULT NULL,
789  `end_date` date DEFAULT NULL,
790  `start_date` date DEFAULT NULL,
791  `description` text,
792  `title` varchar(250) NOT NULL,
793  `created_at` datetime DEFAULT NULL,
794  `modified_by_id` int(11) DEFAULT NULL,
795  `updated_at` datetime DEFAULT NULL,
796  `context_id` int(11) DEFAULT NULL,
797  `sort_index` varchar(250) NOT NULL,
798  `next_due_date` date DEFAULT NULL,
799  `secondary_contact_id` int(11) DEFAULT NULL,
800  `slug` varchar(250) NOT NULL,
801  PRIMARY KEY (`id`),
802  UNIQUE KEY `unique_slug` (`slug`),
803  KEY `cycle_id` (`cycle_id`),
804  KEY `task_group_id` (`task_group_id`),
805  KEY `fk_cycle_task_groups_contact` (`contact_id`),
806  KEY `fk_cycle_task_groups_contexts` (`context_id`),
807  KEY `ix_cycle_task_groups_updated_at` (`updated_at`),
808  KEY `fk_cycle_task_groups_secondary_contact` (`secondary_contact_id`),
809  CONSTRAINT `cycle_task_groups_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
810  CONSTRAINT `cycle_task_groups_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
811  CONSTRAINT `cycle_task_groups_ibfk_3` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`)
812) ENGINE=InnoDB DEFAULT CHARSET=utf8;
813/*!40101 SET character_set_client = @saved_cs_client */;
814
815--
816-- Dumping data for table `cycle_task_groups`
817--
818
819LOCK TABLES `cycle_task_groups` WRITE;
820/*!40000 ALTER TABLE `cycle_task_groups` DISABLE KEYS */;
821/*!40000 ALTER TABLE `cycle_task_groups` ENABLE KEYS */;
822UNLOCK TABLES;
823
824--
825-- Table structure for table `cycles`
826--
827
828DROP TABLE IF EXISTS `cycles`;
829/*!40101 SET @saved_cs_client     = @@character_set_client */;
830/*!40101 SET character_set_client = utf8 */;
831CREATE TABLE `cycles` (
832  `id` int(11) NOT NULL AUTO_INCREMENT,
833  `workflow_id` int(11) NOT NULL,
834  `contact_id` int(11) DEFAULT NULL,
835  `status` varchar(250) DEFAULT NULL,
836  `end_date` date DEFAULT NULL,
837  `start_date` date DEFAULT NULL,
838  `description` text,
839  `title` varchar(250) NOT NULL,
840  `slug` varchar(250) NOT NULL,
841  `created_at` datetime DEFAULT NULL,
842  `modified_by_id` int(11) DEFAULT NULL,
843  `updated_at` datetime DEFAULT NULL,
844  `context_id` int(11) DEFAULT NULL,
845  `is_current` tinyint(1) NOT NULL,
846  `next_due_date` date DEFAULT NULL,
847  `secondary_contact_id` int(11) DEFAULT NULL,
848  PRIMARY KEY (`id`),
849  UNIQUE KEY `uq_cycles` (`slug`),
850  KEY `workflow_id` (`workflow_id`),
851  KEY `fk_cycles_contact` (`contact_id`),
852  KEY `fk_cycles_contexts` (`context_id`),
853  KEY `ix_cycles_updated_at` (`updated_at`),
854  KEY `fk_cycles_secondary_contact` (`secondary_contact_id`),
855  CONSTRAINT `cycles_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
856  CONSTRAINT `cycles_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
857  CONSTRAINT `cycles_ibfk_3` FOREIGN KEY (`workflow_id`) REFERENCES `workflows` (`id`)
858) ENGINE=InnoDB DEFAULT CHARSET=utf8;
859/*!40101 SET character_set_client = @saved_cs_client */;
860
861--
862-- Dumping data for table `cycles`
863--
864
865LOCK TABLES `cycles` WRITE;
866/*!40000 ALTER TABLE `cycles` DISABLE KEYS */;
867/*!40000 ALTER TABLE `cycles` ENABLE KEYS */;
868UNLOCK TABLES;
869
870--
871-- Table structure for table `data_assets`
872--
873
874DROP TABLE IF EXISTS `data_assets`;
875/*!40101 SET @saved_cs_client     = @@character_set_client */;
876/*!40101 SET character_set_client = utf8 */;
877CREATE TABLE `data_assets` (
878  `id` int(11) NOT NULL AUTO_INCREMENT,
879  `modified_by_id` int(11) DEFAULT NULL,
880  `created_at` datetime DEFAULT NULL,
881  `updated_at` datetime DEFAULT NULL,
882  `description` text,
883  `url` varchar(250) DEFAULT NULL,
884  `start_date` date DEFAULT NULL,
885  `end_date` date DEFAULT NULL,
886  `slug` varchar(250) NOT NULL,
887  `title` varchar(250) NOT NULL,
888  `context_id` int(11) DEFAULT NULL,
889  `contact_id` int(11) DEFAULT NULL,
890  `notes` text,
891  `status` varchar(250) DEFAULT NULL,
892  `reference_url` varchar(250) DEFAULT NULL,
893  `secondary_contact_id` int(11) DEFAULT NULL,
894  `os_state` varchar(16) NOT NULL,
895  PRIMARY KEY (`id`),
896  UNIQUE KEY `uq_data_assets` (`slug`),
897  UNIQUE KEY `uq_t_data_assets` (`title`),
898  KEY `fk_data_assets_contexts` (`context_id`),
899  KEY `fk_data_assets_contact` (`contact_id`),
900  KEY `ix_data_assets_updated_at` (`updated_at`),
901  KEY `fk_data_assets_secondary_contact` (`secondary_contact_id`),
902  CONSTRAINT `fk_data_assets_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
903) ENGINE=InnoDB DEFAULT CHARSET=utf8;
904/*!40101 SET character_set_client = @saved_cs_client */;
905
906--
907-- Dumping data for table `data_assets`
908--
909
910LOCK TABLES `data_assets` WRITE;
911/*!40000 ALTER TABLE `data_assets` DISABLE KEYS */;
912/*!40000 ALTER TABLE `data_assets` ENABLE KEYS */;
913UNLOCK TABLES;
914
915--
916-- Table structure for table `directives`
917--
918
919DROP TABLE IF EXISTS `directives`;
920/*!40101 SET @saved_cs_client     = @@character_set_client */;
921/*!40101 SET character_set_client = utf8 */;
922CREATE TABLE `directives` (
923  `id` int(11) NOT NULL AUTO_INCREMENT,
924  `modified_by_id` int(11) DEFAULT NULL,
925  `created_at` datetime DEFAULT NULL,
926  `updated_at` datetime DEFAULT NULL,
927  `description` text,
928  `url` varchar(250) DEFAULT NULL,
929  `start_date` date DEFAULT NULL,
930  `end_date` date DEFAULT NULL,
931  `slug` varchar(250) NOT NULL,
932  `title` varchar(250) NOT NULL,
933  `version` varchar(250) DEFAULT NULL,
934  `organization` varchar(250) DEFAULT NULL,
935  `scope` text,
936  `kind_id` int(11) DEFAULT NULL,
937  `audit_start_date` datetime DEFAULT NULL,
938  `audit_frequency_id` int(11) DEFAULT NULL,
939  `audit_duration_id` int(11) DEFAULT NULL,
940  `kind` varchar(250) DEFAULT NULL,
941  `context_id` int(11) DEFAULT NULL,
942  `meta_kind` varchar(250) DEFAULT NULL,
943  `contact_id` int(11) DEFAULT NULL,
944  `notes` text,
945  `status` varchar(250) DEFAULT NULL,
946  `reference_url` varchar(250) DEFAULT NULL,
947  `secondary_contact_id` int(11) DEFAULT NULL,
948  `os_state` varchar(16) NOT NULL,
949  PRIMARY KEY (`id`),
950  UNIQUE KEY `uq_directives` (`slug`),
951  UNIQUE KEY `uq_t_directives` (`title`),
952  KEY `fk_directives_contexts` (`context_id`),
953  KEY `fk_directives_contact` (`contact_id`),
954  KEY `ix_directives_meta_kind` (`meta_kind`),
955  KEY `ix_directives_updated_at` (`updated_at`),
956  KEY `fk_directives_secondary_contact` (`secondary_contact_id`),
957  CONSTRAINT `fk_directives_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
958) ENGINE=InnoDB DEFAULT CHARSET=utf8;
959/*!40101 SET character_set_client = @saved_cs_client */;
960
961--
962-- Dumping data for table `directives`
963--
964
965LOCK TABLES `directives` WRITE;
966/*!40000 ALTER TABLE `directives` DISABLE KEYS */;
967/*!40000 ALTER TABLE `directives` ENABLE KEYS */;
968UNLOCK TABLES;
969
970--
971-- Table structure for table `documents`
972--
973
974DROP TABLE IF EXISTS `documents`;
975/*!40101 SET @saved_cs_client     = @@character_set_client */;
976/*!40101 SET character_set_client = utf8 */;
977CREATE TABLE `documents` (
978  `id` int(11) NOT NULL AUTO_INCREMENT,
979  `modified_by_id` int(11) DEFAULT NULL,
980  `created_at` datetime DEFAULT NULL,
981  `updated_at` datetime DEFAULT NULL,
982  `title` varchar(250) DEFAULT NULL,
983  `link` varchar(250) DEFAULT NULL,
984  `description` text,
985  `kind_id` int(11) DEFAULT NULL,
986  `year_id` int(11) DEFAULT NULL,
987  `language_id` int(11) DEFAULT NULL,
988  `context_id` int(11) DEFAULT NULL,
989  PRIMARY KEY (`id`),
990  KEY `fk_documents_contexts` (`context_id`),
991  KEY `ix_documents_updated_at` (`updated_at`),
992  CONSTRAINT `fk_documents_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
993) ENGINE=InnoDB DEFAULT CHARSET=utf8;
994/*!40101 SET character_set_client = @saved_cs_client */;
995
996--
997-- Dumping data for table `documents`
998--
999
1000LOCK TABLES `documents` WRITE;
1001/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
1002/*!40000 ALTER TABLE `documents` ENABLE KEYS */;
1003UNLOCK TABLES;
1004
1005--
1006-- Table structure for table `events`
1007--
1008
1009DROP TABLE IF EXISTS `events`;
1010/*!40101 SET @saved_cs_client     = @@character_set_client */;
1011/*!40101 SET character_set_client = utf8 */;
1012CREATE TABLE `events` (
1013  `id` int(11) NOT NULL AUTO_INCREMENT,
1014  `modified_by_id` int(11) DEFAULT NULL,
1015  `created_at` datetime DEFAULT NULL,
1016  `action` enum('POST','PUT','DELETE','IMPORT','GET') NOT NULL,
1017  `resource_id` int(11) DEFAULT NULL,
1018  `resource_type` varchar(250) DEFAULT NULL,
1019  `context_id` int(11) DEFAULT NULL,
1020  `updated_at` datetime DEFAULT NULL,
1021  PRIMARY KEY (`id`),
1022  KEY `events_modified_by` (`modified_by_id`),
1023  KEY `fk_events_contexts` (`context_id`),
1024  KEY `ix_events_updated_at` (`updated_at`),
1025  CONSTRAINT `events_modified_by` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`),
1026  CONSTRAINT `fk_events_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1027) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
1028/*!40101 SET character_set_client = @saved_cs_client */;
1029
1030--
1031-- Dumping data for table `events`
1032--
1033
1034LOCK TABLES `events` WRITE;
1035/*!40000 ALTER TABLE `events` DISABLE KEYS */;
1036INSERT INTO `events` VALUES (1,1,'2016-04-14 22:14:02','GET',1,'Person',NULL,'2016-04-14 22:14:02'),(2,1,'2016-04-14 22:15:01','POST',1,'Program',4,'2016-04-14 22:15:01'),(3,1,'2016-04-14 22:15:59','POST',2,'Person',NULL,'2016-04-14 22:15:59'),(4,1,'2016-04-14 22:16:52','POST',1,'Audit',5,'2016-04-14 22:16:52'),(5,1,'2016-04-14 22:16:53','POST',2,'UserRole',5,'2016-04-14 22:16:53'),(6,1,'2016-04-14 22:16:54','POST',3,'UserRole',4,'2016-04-14 22:16:54'),(7,1,'2016-04-14 22:17:32','POST',4,'UserRole',NULL,'2016-04-14 22:17:32'),(8,1,'2016-04-14 22:20:26','POST',1,'AssessmentTemplate',5,'2016-04-14 22:20:26'),(9,1,'2016-04-14 22:20:27','POST',1,'Relationship',5,'2016-04-14 22:20:27'),(10,1,'2016-04-14 22:20:27','POST',1,'CustomAttributeDefinition',5,'2016-04-14 22:20:27'),(11,1,'2016-04-14 22:22:41','POST',2,'AssessmentTemplate',5,'2016-04-14 22:22:41'),(12,1,'2016-04-14 22:22:41','POST',2,'Relationship',5,'2016-04-14 22:22:41'),(13,1,'2016-04-14 22:22:41','POST',2,'CustomAttributeDefinition',5,'2016-04-14 22:22:41'),(14,1,'2016-04-14 22:22:41','POST',3,'CustomAttributeDefinition',5,'2016-04-14 22:22:41'),(15,1,'2016-04-14 22:22:41','POST',4,'CustomAttributeDefinition',5,'2016-04-14 22:22:41'),(16,1,'2016-04-14 22:22:41','POST',5,'CustomAttributeDefinition',5,'2016-04-14 22:22:41'),(17,1,'2016-04-14 22:22:41','POST',6,'CustomAttributeDefinition',5,'2016-04-14 22:22:41'),(18,1,'2016-04-14 22:25:43','POST',3,'AssessmentTemplate',5,'2016-04-14 22:25:43'),(19,1,'2016-04-14 22:25:43','POST',3,'Relationship',5,'2016-04-14 22:25:43'),(20,1,'2016-04-14 22:25:43','POST',7,'CustomAttributeDefinition',5,'2016-04-14 22:25:43'),(21,1,'2016-04-18 03:48:20','POST',1,'Control',NULL,'2016-04-18 03:48:20'),(22,1,'2016-04-18 03:48:20','POST',1,'ObjectOwner',NULL,'2016-04-18 03:48:20'),(23,1,'2016-04-18 03:48:49','POST',2,'Control',NULL,'2016-04-18 03:48:49'),(24,1,'2016-04-18 03:48:49','POST',2,'ObjectOwner',NULL,'2016-04-18 03:48:49'),(25,1,'2016-04-18 03:50:17','POST',5,'Relationship',4,'2016-04-18 03:50:17'),(26,1,'2016-04-18 03:50:17','POST',7,'Relationship',4,'2016-04-18 03:50:17'),(27,1,'2016-04-21 14:52:56','POST',8,'CustomAttributeDefinition',NULL,'2016-04-21 14:52:56');
1037/*!40000 ALTER TABLE `events` ENABLE KEYS */;
1038UNLOCK TABLES;
1039
1040--
1041-- Table structure for table `facilities`
1042--
1043
1044DROP TABLE IF EXISTS `facilities`;
1045/*!40101 SET @saved_cs_client     = @@character_set_client */;
1046/*!40101 SET character_set_client = utf8 */;
1047CREATE TABLE `facilities` (
1048  `id` int(11) NOT NULL AUTO_INCREMENT,
1049  `modified_by_id` int(11) DEFAULT NULL,
1050  `created_at` datetime DEFAULT NULL,
1051  `updated_at` datetime DEFAULT NULL,
1052  `description` text,
1053  `url` varchar(250) DEFAULT NULL,
1054  `start_date` date DEFAULT NULL,
1055  `end_date` date DEFAULT NULL,
1056  `slug` varchar(250) NOT NULL,
1057  `title` varchar(250) NOT NULL,
1058  `context_id` int(11) DEFAULT NULL,
1059  `contact_id` int(11) DEFAULT NULL,
1060  `notes` text,
1061  `status` varchar(250) DEFAULT NULL,
1062  `reference_url` varchar(250) DEFAULT NULL,
1063  `secondary_contact_id` int(11) DEFAULT NULL,
1064  `os_state` varchar(16) NOT NULL,
1065  PRIMARY KEY (`id`),
1066  UNIQUE KEY `uq_facilities` (`slug`),
1067  UNIQUE KEY `uq_t_facilities` (`title`),
1068  KEY `fk_facilities_contexts` (`context_id`),
1069  KEY `fk_facilities_contact` (`contact_id`),
1070  KEY `ix_facilities_updated_at` (`updated_at`),
1071  KEY `fk_facilities_secondary_contact` (`secondary_contact_id`),
1072  CONSTRAINT `fk_facilities_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1073) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1074/*!40101 SET character_set_client = @saved_cs_client */;
1075
1076--
1077-- Dumping data for table `facilities`
1078--
1079
1080LOCK TABLES `facilities` WRITE;
1081/*!40000 ALTER TABLE `facilities` DISABLE KEYS */;
1082/*!40000 ALTER TABLE `facilities` ENABLE KEYS */;
1083UNLOCK TABLES;
1084
1085--
1086-- Table structure for table `fulltext_record_properties`
1087--
1088
1089DROP TABLE IF EXISTS `fulltext_record_properties`;
1090/*!40101 SET @saved_cs_client     = @@character_set_client */;
1091/*!40101 SET character_set_client = utf8 */;
1092CREATE TABLE `fulltext_record_properties` (
1093  `key` int(11) NOT NULL AUTO_INCREMENT,
1094  `type` varchar(64) NOT NULL,
1095  `tags` varchar(250) DEFAULT NULL,
1096  `property` varchar(64) NOT NULL,
1097  `content` text,
1098  `context_id` int(11) DEFAULT NULL,
1099  PRIMARY KEY (`key`,`type`,`property`),
1100  KEY `ix_fulltext_record_properties_context_id` (`context_id`),
1101  KEY `ix_fulltext_record_properties_key` (`key`),
1102  KEY `ix_fulltext_record_properties_tags` (`tags`),
1103  KEY `ix_fulltext_record_properties_type` (`type`)
1104) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
1105/*!40101 SET character_set_client = @saved_cs_client */;
1106
1107--
1108-- Dumping data for table `fulltext_record_properties`
1109--
1110
1111LOCK TABLES `fulltext_record_properties` WRITE;
1112/*!40000 ALTER TABLE `fulltext_record_properties` DISABLE KEYS */;
1113INSERT INTO `fulltext_record_properties` VALUES (1,'AssessmentTemplate','','title','Simple Assessment Template',5),(1,'Audit','','description','',5),(1,'Audit','','notes',NULL,5),(1,'Audit','','slug','AUDIT-1',5),(1,'Audit','','title','2016: Program 1 - Audit 1',5),(1,'Control','','description','Description for Control 1',NULL),(1,'Control','','notes','Some notes for Control 1',NULL),(1,'Control','','slug','CONTROL-1',NULL),(1,'Control','','test_plan','Test Plan for Control 1',NULL),(1,'Control','','title','Control 1',NULL),(1,'CustomAttributeDefinition','','title','OCA Text',5),(1,'Person','','company',NULL,NULL),(1,'Person','','email','user@example.com',NULL),(1,'Person','','name','Example User',NULL),(1,'Program','','description','Description for Program 1',4),(1,'Program','','notes','Notes for Program 1<br>',4),(1,'Program','','slug','PROGRAM-1',4),(1,'Program','','title','Program 1',4),(2,'AssessmentTemplate','','title','Full Assessment Template',5),(2,'Control','','description','Description for Control 2',NULL),(2,'Control','','notes','',NULL),(2,'Control','','slug','CONTROL-2',NULL),(2,'Control','','test_plan','Test Plan for Control 2',NULL),(2,'Control','','title','Control 2',NULL),(2,'CustomAttributeDefinition','','title','OCA Rich Text',5),(2,'Person','','company','',NULL),(2,'Person','','email','email@company.com',NULL),(2,'Person','','name','John Doe',NULL),(3,'AssessmentTemplate','','title','Different Assessment Template',5),(3,'CustomAttributeDefinition','','title','OCA Date',5),(4,'CustomAttributeDefinition','','title','OCA Chexbox',5),(5,'CustomAttributeDefinition','','title','OCA Dropdown',5),(6,'CustomAttributeDefinition','','title','OCA Person',5),(7,'CustomAttributeDefinition','','title','OCA Text',5),(8,'CustomAttributeDefinition','','title','CA checkbox',NULL);
1114/*!40000 ALTER TABLE `fulltext_record_properties` ENABLE KEYS */;
1115UNLOCK TABLES;
1116
1117--
1118-- Table structure for table `ggrc_alembic_version`
1119--
1120
1121DROP TABLE IF EXISTS `ggrc_alembic_version`;
1122/*!40101 SET @saved_cs_client     = @@character_set_client */;
1123/*!40101 SET character_set_client = utf8 */;
1124CREATE TABLE `ggrc_alembic_version` (
1125  `version_num` varchar(32) NOT NULL
1126) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1127/*!40101 SET character_set_client = @saved_cs_client */;
1128
1129--
1130-- Dumping data for table `ggrc_alembic_version`
1131--
1132
1133LOCK TABLES `ggrc_alembic_version` WRITE;
1134/*!40000 ALTER TABLE `ggrc_alembic_version` DISABLE KEYS */;
1135INSERT INTO `ggrc_alembic_version` VALUES ('b96b24667e0');
1136/*!40000 ALTER TABLE `ggrc_alembic_version` ENABLE KEYS */;
1137UNLOCK TABLES;
1138
1139--
1140-- Table structure for table `ggrc_basic_permissions_alembic_version`
1141--
1142
1143DROP TABLE IF EXISTS `ggrc_basic_permissions_alembic_version`;
1144/*!40101 SET @saved_cs_client     = @@character_set_client */;
1145/*!40101 SET character_set_client = utf8 */;
1146CREATE TABLE `ggrc_basic_permissions_alembic_version` (
1147  `version_num` varchar(32) NOT NULL
1148) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1149/*!40101 SET character_set_client = @saved_cs_client */;
1150
1151--
1152-- Dumping data for table `ggrc_basic_permissions_alembic_version`
1153--
1154
1155LOCK TABLES `ggrc_basic_permissions_alembic_version` WRITE;
1156/*!40000 ALTER TABLE `ggrc_basic_permissions_alembic_version` DISABLE KEYS */;
1157INSERT INTO `ggrc_basic_permissions_alembic_version` VALUES ('3bf028a83e79');
1158/*!40000 ALTER TABLE `ggrc_basic_permissions_alembic_version` ENABLE KEYS */;
1159UNLOCK TABLES;
1160
1161--
1162-- Table structure for table `ggrc_gdrive_integration_alembic_version`
1163--
1164
1165DROP TABLE IF EXISTS `ggrc_gdrive_integration_alembic_version`;
1166/*!40101 SET @saved_cs_client     = @@character_set_client */;
1167/*!40101 SET character_set_client = utf8 */;
1168CREATE TABLE `ggrc_gdrive_integration_alembic_version` (
1169  `version_num` varchar(32) NOT NULL
1170) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1171/*!40101 SET character_set_client = @saved_cs_client */;
1172
1173--
1174-- Dumping data for table `ggrc_gdrive_integration_alembic_version`
1175--
1176
1177LOCK TABLES `ggrc_gdrive_integration_alembic_version` WRITE;
1178/*!40000 ALTER TABLE `ggrc_gdrive_integration_alembic_version` DISABLE KEYS */;
1179INSERT INTO `ggrc_gdrive_integration_alembic_version` VALUES ('50b3f0b2a002');
1180/*!40000 ALTER TABLE `ggrc_gdrive_integration_alembic_version` ENABLE KEYS */;
1181UNLOCK TABLES;
1182
1183--
1184-- Table structure for table `ggrc_risk_assessments_alembic_version`
1185--
1186
1187DROP TABLE IF EXISTS `ggrc_risk_assessments_alembic_version`;
1188/*!40101 SET @saved_cs_client     = @@character_set_client */;
1189/*!40101 SET character_set_client = utf8 */;
1190CREATE TABLE `ggrc_risk_assessments_alembic_version` (
1191  `version_num` varchar(32) NOT NULL
1192) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1193/*!40101 SET character_set_client = @saved_cs_client */;
1194
1195--
1196-- Dumping data for table `ggrc_risk_assessments_alembic_version`
1197--
1198
1199LOCK TABLES `ggrc_risk_assessments_alembic_version` WRITE;
1200/*!40000 ALTER TABLE `ggrc_risk_assessments_alembic_version` DISABLE KEYS */;
1201INSERT INTO `ggrc_risk_assessments_alembic_version` VALUES ('5b29b4becf8');
1202/*!40000 ALTER TABLE `ggrc_risk_assessments_alembic_version` ENABLE KEYS */;
1203UNLOCK TABLES;
1204
1205--
1206-- Table structure for table `ggrc_risks_alembic_version`
1207--
1208
1209DROP TABLE IF EXISTS `ggrc_risks_alembic_version`;
1210/*!40101 SET @saved_cs_client     = @@character_set_client */;
1211/*!40101 SET character_set_client = utf8 */;
1212CREATE TABLE `ggrc_risks_alembic_version` (
1213  `version_num` varchar(32) NOT NULL
1214) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1215/*!40101 SET character_set_client = @saved_cs_client */;
1216
1217--
1218-- Dumping data for table `ggrc_risks_alembic_version`
1219--
1220
1221LOCK TABLES `ggrc_risks_alembic_version` WRITE;
1222/*!40000 ALTER TABLE `ggrc_risks_alembic_version` DISABLE KEYS */;
1223INSERT INTO `ggrc_risks_alembic_version` VALUES ('17ae137bda7a');
1224/*!40000 ALTER TABLE `ggrc_risks_alembic_version` ENABLE KEYS */;
1225UNLOCK TABLES;
1226
1227--
1228-- Table structure for table `ggrc_workflows_alembic_version`
1229--
1230
1231DROP TABLE IF EXISTS `ggrc_workflows_alembic_version`;
1232/*!40101 SET @saved_cs_client     = @@character_set_client */;
1233/*!40101 SET character_set_client = utf8 */;
1234CREATE TABLE `ggrc_workflows_alembic_version` (
1235  `version_num` varchar(32) NOT NULL
1236) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1237/*!40101 SET character_set_client = @saved_cs_client */;
1238
1239--
1240-- Dumping data for table `ggrc_workflows_alembic_version`
1241--
1242
1243LOCK TABLES `ggrc_workflows_alembic_version` WRITE;
1244/*!40000 ALTER TABLE `ggrc_workflows_alembic_version` DISABLE KEYS */;
1245INSERT INTO `ggrc_workflows_alembic_version` VALUES ('1263c1ab4642');
1246/*!40000 ALTER TABLE `ggrc_workflows_alembic_version` ENABLE KEYS */;
1247UNLOCK TABLES;
1248
1249--
1250-- Table structure for table `helps`
1251--
1252
1253DROP TABLE IF EXISTS `helps`;
1254/*!40101 SET @saved_cs_client     = @@character_set_client */;
1255/*!40101 SET character_set_client = utf8 */;
1256CREATE TABLE `helps` (
1257  `id` int(11) NOT NULL AUTO_INCREMENT,
1258  `modified_by_id` int(11) DEFAULT NULL,
1259  `created_at` datetime DEFAULT NULL,
1260  `updated_at` datetime DEFAULT NULL,
1261  `slug` varchar(250) NOT NULL,
1262  `title` varchar(250) NOT NULL,
1263  `content` text,
1264  `context_id` int(11) DEFAULT NULL,
1265  PRIMARY KEY (`id`),
1266  UNIQUE KEY `uq_helps` (`slug`),
1267  KEY `fk_helps_contexts` (`context_id`),
1268  KEY `ix_helps_updated_at` (`updated_at`),
1269  CONSTRAINT `fk_helps_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1270) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1271/*!40101 SET character_set_client = @saved_cs_client */;
1272
1273--
1274-- Dumping data for table `helps`
1275--
1276
1277LOCK TABLES `helps` WRITE;
1278/*!40000 ALTER TABLE `helps` DISABLE KEYS */;
1279/*!40000 ALTER TABLE `helps` ENABLE KEYS */;
1280UNLOCK TABLES;
1281
1282--
1283-- Table structure for table `issues`
1284--
1285
1286DROP TABLE IF EXISTS `issues`;
1287/*!40101 SET @saved_cs_client     = @@character_set_client */;
1288/*!40101 SET character_set_client = utf8 */;
1289CREATE TABLE `issues` (
1290  `id` int(11) NOT NULL AUTO_INCREMENT,
1291  `os_state` varchar(250) NOT NULL,
1292  `test_plan` text,
1293  `end_date` date DEFAULT NULL,
1294  `start_date` date DEFAULT NULL,
1295  `status` varchar(250) DEFAULT NULL,
1296  `notes` text,
1297  `description` text,
1298  `url` varchar(250) DEFAULT NULL,
1299  `reference_url` varchar(250) DEFAULT NULL,
1300  `secondary_contact_id` int(11) DEFAULT NULL,
1301  `contact_id` int(11) DEFAULT NULL,
1302  `title` varchar(250) NOT NULL,
1303  `slug` varchar(250) NOT NULL,
1304  `created_at` datetime DEFAULT NULL,
1305  `modified_by_id` int(11) DEFAULT NULL,
1306  `updated_at` datetime DEFAULT NULL,
1307  `context_id` int(11) DEFAULT NULL,
1308  PRIMARY KEY (`id`),
1309  UNIQUE KEY `uq_issues` (`slug`),
1310  UNIQUE KEY `uq_t_issues` (`title`),
1311  KEY `contact_id` (`contact_id`),
1312  KEY `context_id` (`context_id`),
1313  KEY `secondary_contact_id` (`secondary_contact_id`),
1314  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
1315  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
1316  CONSTRAINT `issues_ibfk_3` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`)
1317) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1318/*!40101 SET character_set_client = @saved_cs_client */;
1319
1320--
1321-- Dumping data for table `issues`
1322--
1323
1324LOCK TABLES `issues` WRITE;
1325/*!40000 ALTER TABLE `issues` DISABLE KEYS */;
1326/*!40000 ALTER TABLE `issues` ENABLE KEYS */;
1327UNLOCK TABLES;
1328
1329--
1330-- Table structure for table `markets`
1331--
1332
1333DROP TABLE IF EXISTS `markets`;
1334/*!40101 SET @saved_cs_client     = @@character_set_client */;
1335/*!40101 SET character_set_client = utf8 */;
1336CREATE TABLE `markets` (
1337  `id` int(11) NOT NULL AUTO_INCREMENT,
1338  `modified_by_id` int(11) DEFAULT NULL,
1339  `created_at` datetime DEFAULT NULL,
1340  `updated_at` datetime DEFAULT NULL,
1341  `description` text,
1342  `url` varchar(250) DEFAULT NULL,
1343  `start_date` date DEFAULT NULL,
1344  `end_date` date DEFAULT NULL,
1345  `slug` varchar(250) NOT NULL,
1346  `title` varchar(250) NOT NULL,
1347  `context_id` int(11) DEFAULT NULL,
1348  `contact_id` int(11) DEFAULT NULL,
1349  `notes` text,
1350  `status` varchar(250) DEFAULT NULL,
1351  `reference_url` varchar(250) DEFAULT NULL,
1352  `secondary_contact_id` int(11) DEFAULT NULL,
1353  `os_state` varchar(16) NOT NULL,
1354  PRIMARY KEY (`id`),
1355  UNIQUE KEY `uq_markets` (`slug`),
1356  UNIQUE KEY `uq_t_markets` (`title`),
1357  KEY `fk_markets_contexts` (`context_id`),
1358  KEY `fk_markets_contact` (`contact_id`),
1359  KEY `ix_markets_updated_at` (`updated_at`),
1360  KEY `fk_markets_secondary_contact` (`secondary_contact_id`),
1361  CONSTRAINT `fk_markets_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1362) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1363/*!40101 SET character_set_client = @saved_cs_client */;
1364
1365--
1366-- Dumping data for table `markets`
1367--
1368
1369LOCK TABLES `markets` WRITE;
1370/*!40000 ALTER TABLE `markets` DISABLE KEYS */;
1371/*!40000 ALTER TABLE `markets` ENABLE KEYS */;
1372UNLOCK TABLES;
1373
1374--
1375-- Table structure for table `meetings`
1376--
1377
1378DROP TABLE IF EXISTS `meetings`;
1379/*!40101 SET @saved_cs_client     = @@character_set_client */;
1380/*!40101 SET character_set_client = utf8 */;
1381CREATE TABLE `meetings` (
1382  `id` int(11) NOT NULL AUTO_INCREMENT,
1383  `response_id` int(11) NOT NULL,
1384  `title` varchar(250) NOT NULL,
1385  `created_at` datetime DEFAULT NULL,
1386  `modified_by_id` int(11) DEFAULT NULL,
1387  `updated_at` datetime DEFAULT NULL,
1388  `context_id` int(11) DEFAULT NULL,
1389  `description` text,
1390  `start_at` datetime NOT NULL,
1391  `end_at` datetime NOT NULL,
1392  PRIMARY KEY (`id`),
1393  KEY `response_id` (`response_id`),
1394  KEY `fk_meetings_contexts` (`context_id`),
1395  KEY `ix_meetings_updated_at` (`updated_at`),
1396  CONSTRAINT `meetings_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
1397  CONSTRAINT `meetings_ibfk_3` FOREIGN KEY (`response_id`) REFERENCES `responses` (`id`)
1398) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1399/*!40101 SET character_set_client = @saved_cs_client */;
1400
1401--
1402-- Dumping data for table `meetings`
1403--
1404
1405LOCK TABLES `meetings` WRITE;
1406/*!40000 ALTER TABLE `meetings` DISABLE KEYS */;
1407/*!40000 ALTER TABLE `meetings` ENABLE KEYS */;
1408UNLOCK TABLES;
1409
1410--
1411-- Table structure for table `notification_configs`
1412--
1413
1414DROP TABLE IF EXISTS `notification_configs`;
1415/*!40101 SET @saved_cs_client     = @@character_set_client */;
1416/*!40101 SET character_set_client = utf8 */;
1417CREATE TABLE `notification_configs` (
1418  `id` int(11) NOT NULL AUTO_INCREMENT,
1419  `name` varchar(250) DEFAULT NULL,
1420  `created_at` datetime DEFAULT NULL,
1421  `modified_by_id` int(11) DEFAULT NULL,
1422  `updated_at` datetime DEFAULT NULL,
1423  `context_id` int(11) DEFAULT NULL,
1424  `enable_flag` tinyint(1) DEFAULT NULL,
1425  `notif_type` varchar(250) DEFAULT NULL,
1426  `person_id` int(11) NOT NULL,
1427  PRIMARY KEY (`id`),
1428  UNIQUE KEY `uq_notif_configs_person_id_notif_type` (`person_id`,`notif_type`),
1429  KEY `fk_notification_configs_contexts` (`context_id`),
1430  KEY `ix_notification_configs_updated_at` (`updated_at`),
1431  CONSTRAINT `notification_configs_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
1432  CONSTRAINT `notification_configs_ibfk_2` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`)
1433) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1434/*!40101 SET character_set_client = @saved_cs_client */;
1435
1436--
1437-- Dumping data for table `notification_configs`
1438--
1439
1440LOCK TABLES `notification_configs` WRITE;
1441/*!40000 ALTER TABLE `notification_configs` DISABLE KEYS */;
1442/*!40000 ALTER TABLE `notification_configs` ENABLE KEYS */;
1443UNLOCK TABLES;
1444
1445--
1446-- Table structure for table `notification_types`
1447--
1448
1449DROP TABLE IF EXISTS `notification_types`;
1450/*!40101 SET @saved_cs_client     = @@character_set_client */;
1451/*!40101 SET character_set_client = utf8 */;
1452CREATE TABLE `notification_types` (
1453  `id` int(11) NOT NULL AUTO_INCREMENT,
1454  `name` varchar(250) NOT NULL,
1455  `description` varchar(250) DEFAULT NULL,
1456  `advance_notice` int(11) DEFAULT NULL,
1457  `template` varchar(250) NOT NULL,
1458  `instant` tinyint(1) NOT NULL,
1459  `created_at` datetime DEFAULT NULL,
1460  `modified_by_id` int(11) DEFAULT NULL,
1461  `updated_at` datetime DEFAULT NULL,
1462  `context_id` int(11) DEFAULT NULL,
1463  PRIMARY KEY (`id`),
1464  KEY `modified_by_id` (`modified_by_id`),
1465  CONSTRAINT `notification_types_ibfk_1` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`)
1466) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
1467/*!40101 SET character_set_client = @saved_cs_client */;
1468
1469--
1470-- Dumping data for table `notification_types`
1471--
1472
1473LOCK TABLES `notification_types` WRITE;
1474/*!40000 ALTER TABLE `notification_types` DISABLE KEYS */;
1475INSERT INTO `notification_types` VALUES (1,'cycle_created','Notify workflow members that a one time workflow has been started and send them their assigned tasks.',0,'cycle_created',0,NULL,NULL,NULL,NULL),(2,'manual_cycle_created','Notify workflow members that a one time workflow has been started and send them their assigned tasks.',0,'manual_cycle_created',1,NULL,NULL,NULL,NULL),(3,'cycle_task_due_in','Notify task assignee his task is due in X days',1,'cycle_task_due_in',0,NULL,NULL,NULL,NULL),(4,'one_time_cycle_task_due_in','Notify task assignee his task is due in X days',1,'cycle_task_due_in',0,NULL,NULL,NULL,NULL),(5,'weekly_cycle_task_due_in','Notify task assignee his task is due in X days',1,'cycle_task_due_in',0,NULL,NULL,NULL,NULL),(6,'monthly_cycle_task_due_in','Notify task assignee his task is due in X days',1,'cycle_task_due_in',0,NULL,NULL,NULL,NULL),(7,'quarterly_cycle_task_due_in','Notify task assignee his task is due in X days',1,'cycle_task_due_in',0,NULL,NULL,NULL,NULL),(8,'annually_cycle_task_due_in','Notify task assignee his task is due in X days',1,'cycle_task_due_in',0,NULL,NULL,NULL,NULL),(9,'cycle_task_due_today','Notify task assignee his task is due today',0,'cycle_task_due_today',0,NULL,NULL,NULL,NULL),(10,'cycle_task_reassigned','Notify task assignee his task is due today',0,'cycle_task_due_today',1,NULL,NULL,NULL,NULL),(11,'task_group_assignee_change','Email owners on task group assignee change.',0,'task_group_assignee_change',1,NULL,NULL,NULL,NULL),(12,'cycle_task_declined','Notify task assignee his task is due today',0,'cycle_task_due_today',1,NULL,NULL,NULL,NULL),(13,'all_cycle_tasks_completed','Notify workflow owner when all cycle tasks in one cycle have been completed and verified',1,'weekly_workflow_starts_in',1,NULL,NULL,NULL,NULL),(14,'weekly_workflow_starts_in','Advanced notification for a reccuring workflow.',1,'weekly_workflow_starts_in',0,NULL,NULL,NULL,NULL),(15,'monthly_workflow_starts_in','Advanced notification for a reccuring workflow.',3,'monthly_workflow_starts_in',0,NULL,NULL,NULL,NULL),(16,'quarterly_workflow_starts_in','Advanced notification for a reccuring workflow.',7,'quaterly_workflow_starts_in',0,NULL,NULL,NULL,NULL),(17,'annually_workflow_starts_in','Advanced notification for a reccuring workflow.',15,'annual_workflow_starts_in',0,NULL,NULL,NULL,NULL),(18,'cycle_start_failed','Notify workflow owners that a cycle has failed tostart for a recurring workflow',0,'cycle_start_failed',0,NULL,NULL,NULL,NULL),(19,'request_open','Notify all assignees Requesters Assignees and Verifiers that a new request has been created.',0,'request_open',0,NULL,NULL,NULL,NULL),(20,'request_declined','Notify Requester that a request has been declined.',0,'request_declined',0,NULL,NULL,NULL,NULL),(21,'request_manual','Send a manual notification to the Requester.',0,'request_manual',0,NULL,NULL,NULL,NULL),(22,'assessment_open','Send an open assessment notification to Assessors, Assignees and Verifiers.',0,'assessment_open',0,NULL,NULL,NULL,NULL),(23,'assessment_declined','Notify Assessor that an assessment was declined.',0,'assessment_declined',0,NULL,NULL,NULL,NULL),(24,'assessment_manual','Send a manual notification to the Requester.',0,'assessment_manual',0,NULL,NULL,NULL,NULL),(25,'comment_created','Notify selected users that a comment has been created',0,'comment_created',0,NULL,NULL,NULL,NULL);
1476/*!40000 ALTER TABLE `notification_types` ENABLE KEYS */;
1477UNLOCK TABLES;
1478
1479--
1480-- Table structure for table `notifications`
1481--
1482
1483DROP TABLE IF EXISTS `notifications`;
1484/*!40101 SET @saved_cs_client     = @@character_set_client */;
1485/*!40101 SET character_set_client = utf8 */;
1486CREATE TABLE `notifications` (
1487  `id` int(11) NOT NULL AUTO_INCREMENT,
1488  `object_id` int(11) NOT NULL,
1489  `object_type` varchar(250) NOT NULL,
1490  `notification_type_id` int(11) NOT NULL,
1491  `send_on` datetime NOT NULL,
1492  `sent_at` datetime DEFAULT NULL,
1493  `custom_message` text,
1494  `force_notifications` tinyint(1) NOT NULL,
1495  `created_at` datetime DEFAULT NULL,
1496  `modified_by_id` int(11) DEFAULT NULL,
1497  `updated_at` datetime DEFAULT NULL,
1498  `context_id` int(11) DEFAULT NULL,
1499  PRIMARY KEY (`id`),
1500  KEY `modified_by_id` (`modified_by_id`),
1501  KEY `fk_notification_type_id` (`notification_type_id`),
1502  CONSTRAINT `notifications_ibfk_2` FOREIGN KEY (`notification_type_id`) REFERENCES `notification_types` (`id`),
1503  CONSTRAINT `notifications_ibfk_3` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`)
1504) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1505/*!40101 SET character_set_client = @saved_cs_client */;
1506
1507--
1508-- Dumping data for table `notifications`
1509--
1510
1511LOCK TABLES `notifications` WRITE;
1512/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
1513/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
1514UNLOCK TABLES;
1515
1516--
1517-- Table structure for table `object_documents`
1518--
1519
1520DROP TABLE IF EXISTS `object_documents`;
1521/*!40101 SET @saved_cs_client     = @@character_set_client */;
1522/*!40101 SET character_set_client = utf8 */;
1523CREATE TABLE `object_documents` (
1524  `id` int(11) NOT NULL AUTO_INCREMENT,
1525  `modified_by_id` int(11) DEFAULT NULL,
1526  `created_at` datetime DEFAULT NULL,
1527  `updated_at` datetime DEFAULT NULL,
1528  `start_date` date DEFAULT NULL,
1529  `end_date` date DEFAULT NULL,
1530  `role` varchar(250) DEFAULT NULL,
1531  `notes` text,
1532  `document_id` int(11) NOT NULL,
1533  `documentable_id` int(11) NOT NULL,
1534  `documentable_type` varchar(250) NOT NULL,
1535  `context_id` int(11) DEFAULT NULL,
1536  `status` varchar(250) DEFAULT NULL,
1537  PRIMARY KEY (`id`),
1538  UNIQUE KEY `uq_object_documents` (`document_id`,`documentable_id`,`documentable_type`),
1539  KEY `fk_object_documents_contexts` (`context_id`),
1540  KEY `ix_document_id` (`document_id`),
1541  KEY `ix_object_documents_updated_at` (`updated_at`),
1542  CONSTRAINT `fk_object_documents_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
1543  CONSTRAINT `object_documents_ibfk_1` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`)
1544) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1545/*!40101 SET character_set_client = @saved_cs_client */;
1546
1547--
1548-- Dumping data for table `object_documents`
1549--
1550
1551LOCK TABLES `object_documents` WRITE;
1552/*!40000 ALTER TABLE `object_documents` DISABLE KEYS */;
1553/*!40000 ALTER TABLE `object_documents` ENABLE KEYS */;
1554UNLOCK TABLES;
1555
1556--
1557-- Table structure for table `object_events`
1558--
1559
1560DROP TABLE IF EXISTS `object_events`;
1561/*!40101 SET @saved_cs_client     = @@character_set_client */;
1562/*!40101 SET character_set_client = utf8 */;
1563CREATE TABLE `object_events` (
1564  `id` int(11) NOT NULL AUTO_INCREMENT,
1565  `modified_by_id` int(11) DEFAULT NULL,
1566  `created_at` datetime DEFAULT NULL,
1567  `updated_at` datetime DEFAULT NULL,
1568  `context_id` int(11) DEFAULT NULL,
1569  `calendar_id` varchar(250) DEFAULT NULL,
1570  `event_id` varchar(250) NOT NULL,
1571  `eventable_id` int(11) NOT NULL,
1572  `eventable_type` varchar(250) NOT NULL,
1573  PRIMARY KEY (`id`),
1574  KEY `fk_object_events_contexts` (`context_id`),
1575  KEY `ix_object_events_updated_at` (`updated_at`)
1576) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1577/*!40101 SET character_set_client = @saved_cs_client */;
1578
1579--
1580-- Dumping data for table `object_events`
1581--
1582
1583LOCK TABLES `object_events` WRITE;
1584/*!40000 ALTER TABLE `object_events` DISABLE KEYS */;
1585/*!40000 ALTER TABLE `object_events` ENABLE KEYS */;
1586UNLOCK TABLES;
1587
1588--
1589-- Table structure for table `object_files`
1590--
1591
1592DROP TABLE IF EXISTS `object_files`;
1593/*!40101 SET @saved_cs_client     = @@character_set_client */;
1594/*!40101 SET character_set_client = utf8 */;
1595CREATE TABLE `object_files` (
1596  `id` int(11) NOT NULL AUTO_INCREMENT,
1597  `modified_by_id` int(11) DEFAULT NULL,
1598  `created_at` datetime DEFAULT NULL,
1599  `updated_at` datetime DEFAULT NULL,
1600  `context_id` int(11) DEFAULT NULL,
1601  `parent_folder_id` varchar(250) DEFAULT NULL,
1602  `file_id` varchar(250) NOT NULL,
1603  `fileable_id` int(11) NOT NULL,
1604  `fileable_type` varchar(250) NOT NULL,
1605  PRIMARY KEY (`id`),
1606  KEY `fk_object_files_contexts` (`context_id`),
1607  KEY `ix_object_files_updated_at` (`updated_at`)
1608) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1609/*!40101 SET character_set_client = @saved_cs_client */;
1610
1611--
1612-- Dumping data for table `object_files`
1613--
1614
1615LOCK TABLES `object_files` WRITE;
1616/*!40000 ALTER TABLE `object_files` DISABLE KEYS */;
1617/*!40000 ALTER TABLE `object_files` ENABLE KEYS */;
1618UNLOCK TABLES;
1619
1620--
1621-- Table structure for table `object_folders`
1622--
1623
1624DROP TABLE IF EXISTS `object_folders`;
1625/*!40101 SET @saved_cs_client     = @@character_set_client */;
1626/*!40101 SET character_set_client = utf8 */;
1627CREATE TABLE `object_folders` (
1628  `id` int(11) NOT NULL AUTO_INCREMENT,
1629  `modified_by_id` int(11) DEFAULT NULL,
1630  `created_at` datetime DEFAULT NULL,
1631  `updated_at` datetime DEFAULT NULL,
1632  `context_id` int(11) DEFAULT NULL,
1633  `parent_folder_id` varchar(250) DEFAULT NULL,
1634  `folder_id` varchar(250) NOT NULL,
1635  `folderable_id` int(11) NOT NULL,
1636  `folderable_type` varchar(250) NOT NULL,
1637  PRIMARY KEY (`id`),
1638  KEY `fk_object_folders_contexts` (`context_id`),
1639  KEY `ix_folderable_id_type` (`folderable_type`,`folderable_id`),
1640  KEY `ix_object_folders_updated_at` (`updated_at`)
1641) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1642/*!40101 SET character_set_client = @saved_cs_client */;
1643
1644--
1645-- Dumping data for table `object_folders`
1646--
1647
1648LOCK TABLES `object_folders` WRITE;
1649/*!40000 ALTER TABLE `object_folders` DISABLE KEYS */;
1650/*!40000 ALTER TABLE `object_folders` ENABLE KEYS */;
1651UNLOCK TABLES;
1652
1653--
1654-- Table structure for table `object_owners`
1655--
1656
1657DROP TABLE IF EXISTS `object_owners`;
1658/*!40101 SET @saved_cs_client     = @@character_set_client */;
1659/*!40101 SET character_set_client = utf8 */;
1660CREATE TABLE `object_owners` (
1661  `id` int(11) NOT NULL AUTO_INCREMENT,
1662  `person_id` int(11) NOT NULL,
1663  `ownable_id` int(11) NOT NULL,
1664  `ownable_type` varchar(250) NOT NULL,
1665  `modified_by_id` int(11) DEFAULT NULL,
1666  `created_at` datetime DEFAULT NULL,
1667  `updated_at` datetime DEFAULT NULL,
1668  `context_id` int(11) DEFAULT NULL,
1669  `status` varchar(250) DEFAULT NULL,
1670  PRIMARY KEY (`id`),
1671  UNIQUE KEY `uq_id_owners` (`person_id`,`ownable_id`,`ownable_type`),
1672  KEY `fk_object_owners_contexts` (`context_id`),
1673  KEY `ix_object_owners_ownable` (`ownable_type`,`ownable_id`),
1674  KEY `ix_object_owners_updated_at` (`updated_at`),
1675  CONSTRAINT `object_owners_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`),
1676  CONSTRAINT `object_owners_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1677) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1678/*!40101 SET character_set_client = @saved_cs_client */;
1679
1680--
1681-- Dumping data for table `object_owners`
1682--
1683
1684LOCK TABLES `object_owners` WRITE;
1685/*!40000 ALTER TABLE `object_owners` DISABLE KEYS */;
1686INSERT INTO `object_owners` VALUES (1,1,1,'Control',1,'2016-04-18 03:48:20','2016-04-18 03:48:20',NULL,'Draft'),(2,1,2,'Control',1,'2016-04-18 03:48:49','2016-04-18 03:48:49',NULL,'Draft');
1687/*!40000 ALTER TABLE `object_owners` ENABLE KEYS */;
1688UNLOCK TABLES;
1689
1690--
1691-- Table structure for table `object_people`
1692--
1693
1694DROP TABLE IF EXISTS `object_people`;
1695/*!40101 SET @saved_cs_client     = @@character_set_client */;
1696/*!40101 SET character_set_client = utf8 */;
1697CREATE TABLE `object_people` (
1698  `id` int(11) NOT NULL AUTO_INCREMENT,
1699  `modified_by_id` int(11) DEFAULT NULL,
1700  `created_at` datetime DEFAULT NULL,
1701  `updated_at` datetime DEFAULT NULL,
1702  `start_date` date DEFAULT NULL,
1703  `end_date` date DEFAULT NULL,
1704  `role` varchar(250) DEFAULT NULL,
1705  `notes` text,
1706  `person_id` int(11) NOT NULL,
1707  `personable_id` int(11) NOT NULL,
1708  `personable_type` varchar(250) NOT NULL,
1709  `context_id` int(11) DEFAULT NULL,
1710  `status` varchar(250) DEFAULT NULL,
1711  PRIMARY KEY (`id`),
1712  UNIQUE KEY `uq_object_people` (`person_id`,`personable_id`,`personable_type`),
1713  KEY `fk_object_people_contexts` (`context_id`),
1714  KEY `ix_person_id` (`person_id`),
1715  KEY `ix_object_people_updated_at` (`updated_at`),
1716  CONSTRAINT `fk_object_people_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
1717  CONSTRAINT `object_people_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`)
1718) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1719/*!40101 SET character_set_client = @saved_cs_client */;
1720
1721--
1722-- Dumping data for table `object_people`
1723--
1724
1725LOCK TABLES `object_people` WRITE;
1726/*!40000 ALTER TABLE `object_people` DISABLE KEYS */;
1727/*!40000 ALTER TABLE `object_people` ENABLE KEYS */;
1728UNLOCK TABLES;
1729
1730--
1731-- Table structure for table `objectives`
1732--
1733
1734DROP TABLE IF EXISTS `objectives`;
1735/*!40101 SET @saved_cs_client     = @@character_set_client */;
1736/*!40101 SET character_set_client = utf8 */;
1737CREATE TABLE `objectives` (
1738  `id` int(11) NOT NULL AUTO_INCREMENT,
1739  `modified_by_id` int(11) DEFAULT NULL,
1740  `created_at` datetime DEFAULT NULL,
1741  `updated_at` datetime DEFAULT NULL,
1742  `description` text,
1743  `url` varchar(250) DEFAULT NULL,
1744  `slug` varchar(250) NOT NULL,
1745  `title` varchar(250) NOT NULL,
1746  `notes` text,
1747  `context_id` int(11) DEFAULT NULL,
1748  `contact_id` int(11) DEFAULT NULL,
1749  `status` varchar(250) DEFAULT NULL,
1750  `reference_url` varchar(250) DEFAULT NULL,
1751  `secondary_contact_id` int(11) DEFAULT NULL,
1752  `os_state` varchar(16) NOT NULL,
1753  PRIMARY KEY (`id`),
1754  UNIQUE KEY `uq_objectives` (`slug`),
1755  UNIQUE KEY `uq_t_objectives` (`title`),
1756  KEY `fk_objectives_contact` (`contact_id`),
1757  KEY `fk_objectives_contexts` (`context_id`),
1758  KEY `ix_objectives_updated_at` (`updated_at`),
1759  KEY `fk_objectives_secondary_contact` (`secondary_contact_id`),
1760  CONSTRAINT `objectives_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1761) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1762/*!40101 SET character_set_client = @saved_cs_client */;
1763
1764--
1765-- Dumping data for table `objectives`
1766--
1767
1768LOCK TABLES `objectives` WRITE;
1769/*!40000 ALTER TABLE `objectives` DISABLE KEYS */;
1770/*!40000 ALTER TABLE `objectives` ENABLE KEYS */;
1771UNLOCK TABLES;
1772
1773--
1774-- Table structure for table `options`
1775--
1776
1777DROP TABLE IF EXISTS `options`;
1778/*!40101 SET @saved_cs_client     = @@character_set_client */;
1779/*!40101 SET character_set_client = utf8 */;
1780CREATE TABLE `options` (
1781  `id` int(11) NOT NULL AUTO_INCREMENT,
1782  `modified_by_id` int(11) DEFAULT NULL,
1783  `created_at` datetime DEFAULT NULL,
1784  `updated_at` datetime DEFAULT NULL,
1785  `description` text,
1786  `role` varchar(250) DEFAULT NULL,
1787  `title` varchar(250) DEFAULT NULL,
1788  `required` tinyint(1) DEFAULT NULL,
1789  `context_id` int(11) DEFAULT NULL,
1790  PRIMARY KEY (`id`),
1791  KEY `fk_options_contexts` (`context_id`),
1792  KEY `ix_options_role` (`role`),
1793  KEY `ix_options_updated_at` (`updated_at`),
1794  CONSTRAINT `fk_options_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1795) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
1796/*!40101 SET character_set_client = @saved_cs_client */;
1797
1798--
1799-- Dumping data for table `options`
1800--
1801
1802LOCK TABLES `options` WRITE;
1803/*!40000 ALTER TABLE `options` DISABLE KEYS */;
1804INSERT INTO `options` VALUES (1,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'asset_type','Client List',NULL,NULL),(2,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'asset_type','Employee List',NULL,NULL),(3,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'asset_type','Ledger Accounts',NULL,NULL),(4,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'asset_type','Patents',NULL,NULL),(5,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'asset_type','Personal Identifiable Info',NULL,NULL),(6,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'asset_type','Source Code',NULL,NULL),(7,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'asset_type','User Data',NULL,NULL),(8,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','1 Month',NULL,NULL),(9,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','1 Week',NULL,NULL),(10,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','1 Year',NULL,NULL),(11,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','2 Months',NULL,NULL),(12,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','2 Weeks',NULL,NULL),(13,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','3 Months',NULL,NULL),(14,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','4 Months',NULL,NULL),(15,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_duration','6 Months',NULL,NULL),(16,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Ad-Hoc',NULL,NULL),(17,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Annual',NULL,NULL),(18,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Bi-Annual',NULL,NULL),(19,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Continuous',NULL,NULL),(20,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Daily',NULL,NULL),(21,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Hourly',NULL,NULL),(22,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Monthly',NULL,NULL),(23,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Quarterly',NULL,NULL),(24,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Semi-Annual',NULL,NULL),(25,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'audit_frequency','Weekly',NULL,NULL),(27,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'control_kind','Detective',NULL,NULL),(28,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'control_kind','Preventative',NULL,NULL),(38,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'directive_kind','Company Policy',NULL,NULL),(39,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'directive_kind','Data Asset Policy',NULL,NULL),(40,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'directive_kind','Operational Group Policy',NULL,NULL),(41,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'directive_kind','Regulation',NULL,NULL),(42,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_status','active',NULL,NULL),(43,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_status','deprecated',NULL,NULL),(44,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_type','Excel',NULL,NULL),(45,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_type','PDF',NULL,NULL),(46,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_type','Text',NULL,NULL),(47,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_type','URL',NULL,NULL),(48,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_type','Word',NULL,NULL),(49,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1980',NULL,NULL),(50,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1981',NULL,NULL),(51,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1982',NULL,NULL),(52,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1983',NULL,NULL),(53,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1984',NULL,NULL),(54,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1985',NULL,NULL),(55,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1986',NULL,NULL),(56,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1987',NULL,NULL),(57,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1988',NULL,NULL),(58,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1989',NULL,NULL),(59,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1990',NULL,NULL),(60,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1991',NULL,NULL),(61,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1992',NULL,NULL),(62,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1993',NULL,NULL),(63,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1994',NULL,NULL),(64,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1995',NULL,NULL),(65,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1996',NULL,NULL),(66,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1997',NULL,NULL),(67,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1998',NULL,NULL),(68,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','1999',NULL,NULL),(69,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2000',NULL,NULL),(70,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2001',NULL,NULL),(71,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2002',NULL,NULL),(72,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2003',NULL,NULL),(73,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2004',NULL,NULL),(74,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2005',NULL,NULL),(75,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2006',NULL,NULL),(76,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2007',NULL,NULL),(77,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2008',NULL,NULL),(78,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2009',NULL,NULL),(79,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2010',NULL,NULL),(80,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2011',NULL,NULL),(81,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2012',NULL,NULL),(82,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'document_year','2013',0,NULL),(83,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'entity_kind','Not Applicable',NULL,NULL),(84,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'entity_type','Business Unit',NULL,NULL),(85,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'entity_type','Division',NULL,NULL),(86,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'entity_type','Functional Group',NULL,NULL),(87,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'entity_type','Legal Entity',NULL,NULL),(88,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'language','English',NULL,NULL),(89,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Building',NULL,NULL),(90,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','HazMat Storage',NULL,NULL),(91,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Kitchen',NULL,NULL),(92,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Lab',NULL,NULL),(93,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Machine Room',NULL,NULL),(94,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Maintenance Facility',NULL,NULL),(95,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Office',NULL,NULL),(96,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Parking Garage',NULL,NULL),(97,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_kind','Workshop',NULL,NULL),(98,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Colo Data Center',NULL,NULL),(99,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Contract Manufacturer',NULL,NULL),(100,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Data Center',NULL,NULL),(101,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Distribution Center',NULL,NULL),(102,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Headquarters',NULL,NULL),(103,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Regional Office',NULL,NULL),(104,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Sales Office',NULL,NULL),(105,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'location_type','Vendor Worksite',NULL,NULL),(106,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'network_zone','Corp',0,NULL),(107,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'network_zone','Prod',0,NULL),(108,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'person_language','English',NULL,NULL),(109,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'product_kind','Not Applicable',NULL,NULL),(110,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'product_type','Appliance',NULL,NULL),(111,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'product_type','Desktop Software',NULL,NULL),(112,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'product_type','SaaS',NULL,NULL),(113,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'reference_type','Database',NULL,NULL),(114,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'reference_type','Document',NULL,NULL),(115,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'reference_type','Numeric Data',NULL,NULL),(116,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'reference_type','Screenshot',NULL,NULL),(117,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'reference_type','Simple Text',NULL,NULL),(118,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'reference_type','Website',NULL,NULL),(119,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'system_kind','Infrastructure',NULL,NULL),(120,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'system_type','Infrastructure',NULL,NULL),(121,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'threat_type','Insider Threat',NULL,NULL),(122,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'threat_type','Outsider Threat',NULL,NULL),(123,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Bi-Weekly',NULL,NULL),(124,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Yearly',NULL,NULL),(125,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Bi-Monthly',NULL,NULL),(126,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Continuous',NULL,NULL),(127,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Daily',NULL,NULL),(128,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Hourly',NULL,NULL),(129,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Indeterminate',0,NULL),(130,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Monthly',NULL,NULL),(131,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Quarterly',NULL,NULL),(132,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Semi-Annually',NULL,NULL),(133,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Transactional',0,NULL),(134,NULL,'2016-04-14 22:13:44','2016-04-14 22:13:44',NULL,'verify_frequency','Weekly',NULL,NULL),(135,NULL,NULL,NULL,NULL,'network_zone','3rd Party',NULL,NULL),(136,NULL,NULL,NULL,NULL,'network_zone','Core',NULL,NULL),(137,NULL,NULL,NULL,NULL,'network_zone','Service',NULL,NULL),(138,NULL,NULL,NULL,NULL,'control_kind','Corrective',NULL,NULL),(139,NULL,NULL,NULL,NULL,'control_means','Technical',NULL,NULL),(140,NULL,NULL,NULL,NULL,'control_means','Administrative',NULL,NULL),(141,NULL,NULL,NULL,NULL,'control_means','Physical',NULL,NULL);
1805/*!40000 ALTER TABLE `options` ENABLE KEYS */;
1806UNLOCK TABLES;
1807
1808--
1809-- Table structure for table `org_groups`
1810--
1811
1812DROP TABLE IF EXISTS `org_groups`;
1813/*!40101 SET @saved_cs_client     = @@character_set_client */;
1814/*!40101 SET character_set_client = utf8 */;
1815CREATE TABLE `org_groups` (
1816  `id` int(11) NOT NULL AUTO_INCREMENT,
1817  `modified_by_id` int(11) DEFAULT NULL,
1818  `created_at` datetime DEFAULT NULL,
1819  `updated_at` datetime DEFAULT NULL,
1820  `description` text,
1821  `url` varchar(250) DEFAULT NULL,
1822  `start_date` date DEFAULT NULL,
1823  `end_date` date DEFAULT NULL,
1824  `slug` varchar(250) NOT NULL,
1825  `title` varchar(250) NOT NULL,
1826  `context_id` int(11) DEFAULT NULL,
1827  `contact_id` int(11) DEFAULT NULL,
1828  `notes` text,
1829  `status` varchar(250) DEFAULT NULL,
1830  `reference_url` varchar(250) DEFAULT NULL,
1831  `secondary_contact_id` int(11) DEFAULT NULL,
1832  `os_state` varchar(16) NOT NULL,
1833  PRIMARY KEY (`id`),
1834  UNIQUE KEY `uq_org_groups` (`slug`),
1835  UNIQUE KEY `uq_t_org_groups` (`title`),
1836  KEY `fk_org_groups_contexts` (`context_id`),
1837  KEY `fk_org_groups_contact` (`contact_id`),
1838  KEY `ix_org_groups_updated_at` (`updated_at`),
1839  KEY `fk_org_groups_secondary_contact` (`secondary_contact_id`),
1840  CONSTRAINT `fk_org_groups_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1841) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1842/*!40101 SET character_set_client = @saved_cs_client */;
1843
1844--
1845-- Dumping data for table `org_groups`
1846--
1847
1848LOCK TABLES `org_groups` WRITE;
1849/*!40000 ALTER TABLE `org_groups` DISABLE KEYS */;
1850/*!40000 ALTER TABLE `org_groups` ENABLE KEYS */;
1851UNLOCK TABLES;
1852
1853--
1854-- Table structure for table `people`
1855--
1856
1857DROP TABLE IF EXISTS `people`;
1858/*!40101 SET @saved_cs_client     = @@character_set_client */;
1859/*!40101 SET character_set_client = utf8 */;
1860CREATE TABLE `people` (
1861  `id` int(11) NOT NULL AUTO_INCREMENT,
1862  `modified_by_id` int(11) DEFAULT NULL,
1863  `created_at` datetime DEFAULT NULL,
1864  `updated_at` datetime DEFAULT NULL,
1865  `email` varchar(250) NOT NULL,
1866  `name` varchar(250) DEFAULT NULL,
1867  `language_id` int(11) DEFAULT NULL,
1868  `company` varchar(250) DEFAULT NULL,
1869  `context_id` int(11) DEFAULT NULL,
1870  PRIMARY KEY (`id`),
1871  UNIQUE KEY `uq_people_email` (`email`),
1872  KEY `fk_people_contexts` (`context_id`),
1873  KEY `ix_people_name_email` (`name`,`email`),
1874  KEY `ix_people_updated_at` (`updated_at`),
1875  CONSTRAINT `fk_people_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1876) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1877/*!40101 SET character_set_client = @saved_cs_client */;
1878
1879--
1880-- Dumping data for table `people`
1881--
1882
1883LOCK TABLES `people` WRITE;
1884/*!40000 ALTER TABLE `people` DISABLE KEYS */;
1885INSERT INTO `people` VALUES (1,NULL,'2016-04-14 22:14:01','2016-04-14 22:14:01','user@example.com','Example User',NULL,NULL,NULL),(2,1,'2016-04-14 22:15:59','2016-04-14 22:15:59','email@company.com','John Doe',NULL,'',NULL);
1886/*!40000 ALTER TABLE `people` ENABLE KEYS */;
1887UNLOCK TABLES;
1888
1889--
1890-- Table structure for table `products`
1891--
1892
1893DROP TABLE IF EXISTS `products`;
1894/*!40101 SET @saved_cs_client     = @@character_set_client */;
1895/*!40101 SET character_set_client = utf8 */;
1896CREATE TABLE `products` (
1897  `id` int(11) NOT NULL AUTO_INCREMENT,
1898  `modified_by_id` int(11) DEFAULT NULL,
1899  `created_at` datetime DEFAULT NULL,
1900  `updated_at` datetime DEFAULT NULL,
1901  `description` text,
1902  `url` varchar(250) DEFAULT NULL,
1903  `start_date` date DEFAULT NULL,
1904  `end_date` date DEFAULT NULL,
1905  `slug` varchar(250) NOT NULL,
1906  `title` varchar(250) NOT NULL,
1907  `kind_id` int(11) DEFAULT NULL,
1908  `version` varchar(250) DEFAULT NULL,
1909  `context_id` int(11) DEFAULT NULL,
1910  `contact_id` int(11) DEFAULT NULL,
1911  `notes` text,
1912  `status` varchar(250) DEFAULT NULL,
1913  `reference_url` varchar(250) DEFAULT NULL,
1914  `secondary_contact_id` int(11) DEFAULT NULL,
1915  `os_state` varchar(16) NOT NULL,
1916  PRIMARY KEY (`id`),
1917  UNIQUE KEY `uq_products` (`slug`),
1918  UNIQUE KEY `uq_t_products` (`title`),
1919  KEY `fk_products_contexts` (`context_id`),
1920  KEY `fk_products_contact` (`contact_id`),
1921  KEY `ix_products_updated_at` (`updated_at`),
1922  KEY `fk_products_secondary_contact` (`secondary_contact_id`),
1923  CONSTRAINT `fk_products_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1924) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1925/*!40101 SET character_set_client = @saved_cs_client */;
1926
1927--
1928-- Dumping data for table `products`
1929--
1930
1931LOCK TABLES `products` WRITE;
1932/*!40000 ALTER TABLE `products` DISABLE KEYS */;
1933/*!40000 ALTER TABLE `products` ENABLE KEYS */;
1934UNLOCK TABLES;
1935
1936--
1937-- Table structure for table `programs`
1938--
1939
1940DROP TABLE IF EXISTS `programs`;
1941/*!40101 SET @saved_cs_client     = @@character_set_client */;
1942/*!40101 SET character_set_client = utf8 */;
1943CREATE TABLE `programs` (
1944  `id` int(11) NOT NULL AUTO_INCREMENT,
1945  `modified_by_id` int(11) DEFAULT NULL,
1946  `created_at` datetime DEFAULT NULL,
1947  `updated_at` datetime DEFAULT NULL,
1948  `description` text,
1949  `url` varchar(250) DEFAULT NULL,
1950  `start_date` date DEFAULT NULL,
1951  `end_date` date DEFAULT NULL,
1952  `slug` varchar(250) NOT NULL,
1953  `title` varchar(250) NOT NULL,
1954  `kind` varchar(250) DEFAULT NULL,
1955  `context_id` int(11) DEFAULT NULL,
1956  `contact_id` int(11) DEFAULT NULL,
1957  `notes` text,
1958  `status` varchar(250) DEFAULT NULL,
1959  `reference_url` varchar(250) DEFAULT NULL,
1960  `private` tinyint(1) NOT NULL,
1961  `secondary_contact_id` int(11) DEFAULT NULL,
1962  `os_state` varchar(16) NOT NULL,
1963  PRIMARY KEY (`id`),
1964  UNIQUE KEY `uq_programs` (`slug`),
1965  UNIQUE KEY `uq_t_programs` (`title`),
1966  KEY `fk_programs_contexts` (`context_id`),
1967  KEY `fk_programs_contact` (`contact_id`),
1968  KEY `ix_programs_updated_at` (`updated_at`),
1969  KEY `fk_programs_secondary_contact` (`secondary_contact_id`),
1970  CONSTRAINT `fk_programs_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
1971) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1972/*!40101 SET character_set_client = @saved_cs_client */;
1973
1974--
1975-- Dumping data for table `programs`
1976--
1977
1978LOCK TABLES `programs` WRITE;
1979/*!40000 ALTER TABLE `programs` DISABLE KEYS */;
1980INSERT INTO `programs` VALUES (1,1,'2016-04-14 22:15:01','2016-04-14 22:15:01','Description for Program 1','',NULL,NULL,'PROGRAM-1','Program 1','Directive',4,1,'Notes for Program 1<br>','Draft','',0,NULL,'Modified');
1981/*!40000 ALTER TABLE `programs` ENABLE KEYS */;
1982UNLOCK TABLES;
1983
1984--
1985-- Table structure for table `projects`
1986--
1987
1988DROP TABLE IF EXISTS `projects`;
1989/*!40101 SET @saved_cs_client     = @@character_set_client */;
1990/*!40101 SET character_set_client = utf8 */;
1991CREATE TABLE `projects` (
1992  `id` int(11) NOT NULL AUTO_INCREMENT,
1993  `modified_by_id` int(11) DEFAULT NULL,
1994  `created_at` datetime DEFAULT NULL,
1995  `updated_at` datetime DEFAULT NULL,
1996  `description` text,
1997  `url` varchar(250) DEFAULT NULL,
1998  `start_date` date DEFAULT NULL,
1999  `end_date` date DEFAULT NULL,
2000  `slug` varchar(250) NOT NULL,
2001  `title` varchar(250) NOT NULL,
2002  `context_id` int(11) DEFAULT NULL,
2003  `contact_id` int(11) DEFAULT NULL,
2004  `notes` text,
2005  `status` varchar(250) DEFAULT NULL,
2006  `reference_url` varchar(250) DEFAULT NULL,
2007  `secondary_contact_id` int(11) DEFAULT NULL,
2008  `os_state` varchar(16) NOT NULL,
2009  PRIMARY KEY (`id`),
2010  UNIQUE KEY `uq_projects` (`slug`),
2011  UNIQUE KEY `uq_t_projects` (`title`),
2012  KEY `fk_projects_contexts` (`context_id`),
2013  KEY `fk_projects_contact` (`contact_id`),
2014  KEY `ix_projects_updated_at` (`updated_at`),
2015  KEY `fk_projects_secondary_contact` (`secondary_contact_id`),
2016  CONSTRAINT `fk_projects_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
2017) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2018/*!40101 SET character_set_client = @saved_cs_client */;
2019
2020--
2021-- Dumping data for table `projects`
2022--
2023
2024LOCK TABLES `projects` WRITE;
2025/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
2026/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
2027UNLOCK TABLES;
2028
2029--
2030-- Table structure for table `relationship_attrs`
2031--
2032
2033DROP TABLE IF EXISTS `relationship_attrs`;
2034/*!40101 SET @saved_cs_client     = @@character_set_client */;
2035/*!40101 SET character_set_client = utf8 */;
2036CREATE TABLE `relationship_attrs` (
2037  `id` int(11) NOT NULL AUTO_INCREMENT,
2038  `relationship_id` int(11) NOT NULL,
2039  `attr_name` varchar(250) NOT NULL,
2040  `attr_value` varchar(250) NOT NULL,
2041  PRIMARY KEY (`id`),
2042  KEY `relationship_id` (`relationship_id`),
2043  CONSTRAINT `relationship_attrs_ibfk_1` FOREIGN KEY (`relationship_id`) REFERENCES `relationships` (`id`)
2044) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2045/*!40101 SET character_set_client = @saved_cs_client */;
2046
2047--
2048-- Dumping data for table `relationship_attrs`
2049--
2050
2051LOCK TABLES `relationship_attrs` WRITE;
2052/*!40000 ALTER TABLE `relationship_attrs` DISABLE KEYS */;
2053/*!40000 ALTER TABLE `relationship_attrs` ENABLE KEYS */;
2054UNLOCK TABLES;
2055
2056--
2057-- Table structure for table `relationships`
2058--
2059
2060DROP TABLE IF EXISTS `relationships`;
2061/*!40101 SET @saved_cs_client     = @@character_set_client */;
2062/*!40101 SET character_set_client = utf8 */;
2063CREATE TABLE `relationships` (
2064  `id` int(11) NOT NULL AUTO_INCREMENT,
2065  `modified_by_id` int(11) DEFAULT NULL,
2066  `created_at` datetime DEFAULT NULL,
2067  `updated_at` datetime DEFAULT NULL,
2068  `source_id` int(11) NOT NULL,
2069  `source_type` varchar(250) NOT NULL,
2070  `destination_id` int(11) NOT NULL,
2071  `destination_type` varchar(250) NOT NULL,
2072  `context_id` int(11) DEFAULT NULL,
2073  `status` varchar(250) DEFAULT NULL,
2074  `automapping_id` int(11) DEFAULT NULL,
2075  PRIMARY KEY (`id`),
2076  UNIQUE KEY `uq_relationships` (`source_id`,`source_type`,`destination_id`,`destination_type`),
2077  KEY `fk_relationships_contexts` (`context_id`),
2078  KEY `ix_relationships_destination` (`destination_type`,`destination_id`),
2079  KEY `ix_relationships_source` (`source_type`,`source_id`),
2080  KEY `ix_relationships_updated_at` (`updated_at`),
2081  KEY `relationships_automapping_parent` (`automapping_id`),
2082  CONSTRAINT `fk_relationships_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2083  CONSTRAINT `relationships_automapping_parent` FOREIGN KEY (`automapping_id`) REFERENCES `relationships` (`id`) ON DELETE SET NULL
2084) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
2085/*!40101 SET character_set_client = @saved_cs_client */;
2086
2087--
2088-- Dumping data for table `relationships`
2089--
2090
2091LOCK TABLES `relationships` WRITE;
2092/*!40000 ALTER TABLE `relationships` DISABLE KEYS */;
2093INSERT INTO `relationships` VALUES (1,1,'2016-04-14 22:20:27','2016-04-14 22:20:27',1,'AssessmentTemplate',1,'Audit',5,'Draft',NULL),(2,1,'2016-04-14 22:22:41','2016-04-14 22:22:41',2,'AssessmentTemplate',1,'Audit',5,'Draft',NULL),(3,1,'2016-04-14 22:25:43','2016-04-14 22:25:43',3,'AssessmentTemplate',1,'Audit',5,'Draft',NULL),(4,1,'2016-04-18 03:50:17','2016-04-18 03:50:17',1,'Audit',1,'Control',NULL,NULL,NULL),(5,1,'2016-04-18 03:50:17','2016-04-18 03:50:17',1,'Program',1,'Control',4,'Draft',NULL),(6,1,'2016-04-18 03:50:17','2016-04-18 03:50:17',1,'Audit',2,'Control',NULL,NULL,NULL),(7,1,'2016-04-18 03:50:17','2016-04-18 03:50:17',1,'Program',2,'Control',4,'Draft',NULL);
2094/*!40000 ALTER TABLE `relationships` ENABLE KEYS */;
2095UNLOCK TABLES;
2096
2097--
2098-- Table structure for table `requests`
2099--
2100
2101DROP TABLE IF EXISTS `requests`;
2102/*!40101 SET @saved_cs_client     = @@character_set_client */;
2103/*!40101 SET character_set_client = utf8 */;
2104CREATE TABLE `requests` (
2105  `id` int(11) NOT NULL AUTO_INCREMENT,
2106  `request_type` enum('documentation','interview','population sample') NOT NULL,
2107  `status` enum('Open','In Progress','Finished','Verified','Final') NOT NULL,
2108  `requested_on` date NOT NULL,
2109  `due_on` date NOT NULL,
2110  `audit_id` int(11) DEFAULT NULL,
2111  `gdrive_upload_path` varchar(250) DEFAULT NULL,
2112  `created_at` datetime DEFAULT NULL,
2113  `modified_by_id` int(11) DEFAULT NULL,
2114  `updated_at` datetime DEFAULT NULL,
2115  `context_id` int(11) DEFAULT NULL,
2116  `test` text,
2117  `notes` text,
2118  `description` text,
2119  `requestor_id` int(11) DEFAULT NULL,
2120  `slug` varchar(250) NOT NULL,
2121  `title` varchar(250) NOT NULL,
2122  `audit_object_id` int(11) DEFAULT NULL,
2123  `finished_date` datetime DEFAULT NULL,
2124  `verified_date` datetime DEFAULT NULL,
2125  `recipients` varchar(250) DEFAULT NULL,
2126  `send_by_default` tinyint(1) DEFAULT NULL,
2127  PRIMARY KEY (`id`),
2128  UNIQUE KEY `uq_requests` (`slug`),
2129  KEY `audit_id` (`audit_id`),
2130  KEY `fk_requests_contexts` (`context_id`),
2131  KEY `ix_requests_updated_at` (`updated_at`),
2132  KEY `requests_audit_objects_ibfk` (`audit_object_id`),
2133  CONSTRAINT `requests_audit_objects_ibfk` FOREIGN KEY (`audit_object_id`) REFERENCES `audit_objects` (`id`),
2134  CONSTRAINT `requests_ibfk_2` FOREIGN KEY (`audit_id`) REFERENCES `audits` (`id`),
2135  CONSTRAINT `requests_ibfk_3` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
2136) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2137/*!40101 SET character_set_client = @saved_cs_client */;
2138
2139--
2140-- Dumping data for table `requests`
2141--
2142
2143LOCK TABLES `requests` WRITE;
2144/*!40000 ALTER TABLE `requests` DISABLE KEYS */;
2145/*!40000 ALTER TABLE `requests` ENABLE KEYS */;
2146UNLOCK TABLES;
2147
2148--
2149-- Table structure for table `responses`
2150--
2151
2152DROP TABLE IF EXISTS `responses`;
2153/*!40101 SET @saved_cs_client     = @@character_set_client */;
2154/*!40101 SET character_set_client = utf8 */;
2155CREATE TABLE `responses` (
2156  `id` int(11) NOT NULL AUTO_INCREMENT,
2157  `request_id` int(11) NOT NULL,
2158  `response_type` enum('documentation','interview','population sample') NOT NULL,
2159  `status` varchar(250) NOT NULL,
2160  `contact_id` int(11) DEFAULT NULL,
2161  `title` varchar(250) NOT NULL,
2162  `slug` varchar(250) NOT NULL,
2163  `created_at` datetime DEFAULT NULL,
2164  `modified_by_id` int(11) DEFAULT NULL,
2165  `updated_at` datetime DEFAULT NULL,
2166  `context_id` int(11) DEFAULT NULL,
2167  `description` text,
2168  `url` varchar(250) DEFAULT NULL,
2169  `population_count` int(11) DEFAULT NULL,
2170  `sample_count` int(11) DEFAULT NULL,
2171  `population_worksheet_id` int(11) DEFAULT NULL,
2172  `sample_worksheet_id` int(11) DEFAULT NULL,
2173  `sample_evidence_id` int(11) DEFAULT NULL,
2174  `notes` text,
2175  `reference_url` varchar(250) DEFAULT NULL,
2176  `secondary_contact_id` int(11) DEFAULT NULL,
2177  PRIMARY KEY (`id`),
2178  KEY `request_id` (`request_id`),
2179  KEY `population_worksheet_document` (`population_worksheet_id`),
2180  KEY `sample_worksheet_document` (`sample_worksheet_id`),
2181  KEY `sample_evidence_document` (`sample_evidence_id`),
2182  KEY `fk_responses_contact` (`contact_id`),
2183  KEY `fk_responses_contexts` (`context_id`),
2184  KEY `ix_responses_updated_at` (`updated_at`),
2185  KEY `fk_responses_secondary_contact` (`secondary_contact_id`),
2186  CONSTRAINT `population_worksheet_document` FOREIGN KEY (`population_worksheet_id`) REFERENCES `documents` (`id`),
2187  CONSTRAINT `responses_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2188  CONSTRAINT `responses_ibfk_3` FOREIGN KEY (`request_id`) REFERENCES `requests` (`id`),
2189  CONSTRAINT `sample_evidence_document` FOREIGN KEY (`sample_evidence_id`) REFERENCES `documents` (`id`),
2190  CONSTRAINT `sample_worksheet_document` FOREIGN KEY (`sample_worksheet_id`) REFERENCES `documents` (`id`)
2191) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2192/*!40101 SET character_set_client = @saved_cs_client */;
2193
2194--
2195-- Dumping data for table `responses`
2196--
2197
2198LOCK TABLES `responses` WRITE;
2199/*!40000 ALTER TABLE `responses` DISABLE KEYS */;
2200/*!40000 ALTER TABLE `responses` ENABLE KEYS */;
2201UNLOCK TABLES;
2202
2203--
2204-- Table structure for table `revisions`
2205--
2206
2207DROP TABLE IF EXISTS `revisions`;
2208/*!40101 SET @saved_cs_client     = @@character_set_client */;
2209/*!40101 SET character_set_client = utf8 */;
2210CREATE TABLE `revisions` (
2211  `id` int(11) NOT NULL AUTO_INCREMENT,
2212  `resource_id` int(11) NOT NULL,
2213  `resource_type` varchar(250) NOT NULL,
2214  `event_id` int(11) NOT NULL,
2215  `action` enum('created','modified','deleted') NOT NULL,
2216  `content` text NOT NULL,
2217  `context_id` int(11) DEFAULT NULL,
2218  `created_at` datetime DEFAULT NULL,
2219  `updated_at` datetime DEFAULT NULL,
2220  `modified_by_id` int(11) DEFAULT NULL,
2221  `source_type` varchar(250) DEFAULT NULL,
2222  `source_id` int(11) DEFAULT NULL,
2223  `destination_type` varchar(250) DEFAULT NULL,
2224  `destination_id` int(11) DEFAULT NULL,
2225  PRIMARY KEY (`id`),
2226  KEY `event_id` (`event_id`),
2227  KEY `revisions_modified_by` (`modified_by_id`),
2228  KEY `fk_revisions_contexts` (`context_id`),
2229  KEY `ix_revisions_updated_at` (`updated_at`),
2230  KEY `fk_revisions_resource` (`resource_type`,`resource_id`),
2231  KEY `fk_revisions_source` (`source_type`,`source_id`),
2232  KEY `fk_revisions_destination` (`destination_type`,`destination_id`),
2233  CONSTRAINT `fk_revisions_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2234  CONSTRAINT `revisions_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`),
2235  CONSTRAINT `revisions_modified_by` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`)
2236) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
2237/*!40101 SET character_set_client = @saved_cs_client */;
2238
2239--
2240-- Dumping data for table `revisions`
2241--
2242
2243LOCK TABLES `revisions` WRITE;
2244/*!40000 ALTER TABLE `revisions` DISABLE KEYS */;
2245INSERT INTO `revisions` VALUES (1,1,'Person',1,'created','{\"display_name\": \"user@example.com\", \"name\": \"Example User\", \"updated_at\": \"2016-04-14T22:14:01\", \"context_id\": null, \"created_at\": \"2016-04-14T22:14:01\", \"language_id\": null, \"id\": 1, \"email\": \"user@example.com\", \"modified_by_id\": null, \"company\": null}',NULL,'2016-04-14 22:14:02','2016-04-14 22:14:02',1,NULL,NULL,NULL,NULL),(2,3,'Context',2,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:15:01','2016-04-14 22:15:01',1,NULL,NULL,NULL,NULL),(3,4,'Context',2,'created','{\"display_name\": \"Program Context 2016-04-14 22:15:01.893380\", \"name\": \"Program Context 2016-04-14 22:15:01.893380\", \"context_id\": null, \"created_at\": \"2016-04-14T22:15:01\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Program\", \"modified_by_id\": 1, \"id\": 4, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:15:01','2016-04-14 22:15:01',1,NULL,NULL,NULL,NULL),(4,3,'ContextImplication',2,'created','{\"source_context_id\": null, \"source_context_scope\": null, \"context_id\": 4, \"created_at\": \"2016-04-14T22:15:01\", \"updated_at\": \"2016-04-14T22:15:01\", \"context_scope\": \"Program\", \"modified_by_id\": 1, \"display_name\": \"Default Context -> Program Context 2016-04-14 22:15:01.893380\", \"id\": 3}',NULL,'2016-04-14 22:15:01','2016-04-14 22:15:01',1,NULL,NULL,NULL,NULL),(5,2,'ContextImplication',2,'created','{\"source_context_id\": 4, \"source_context_scope\": \"Program\", \"context_id\": null, \"created_at\": \"2016-04-14T22:15:01\", \"updated_at\": \"2016-04-14T22:15:01\", \"context_scope\": null, \"modified_by_id\": 1, \"display_name\": \"Program Context 2016-04-14 22:15:01.893380 -> Default Context\", \"id\": 2}',NULL,'2016-04-14 22:15:01','2016-04-14 22:15:01',1,NULL,NULL,NULL,NULL),(6,1,'UserRole',2,'created','{\"display_name\": \"user@example.com <-> ProgramOwner in Program 1\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:15:01\", \"updated_at\": \"2016-04-14T22:15:01\", \"role_id\": 1, \"modified_by_id\": 1, \"person_id\": 1, \"id\": 1}',NULL,'2016-04-14 22:15:01','2016-04-14 22:15:01',1,NULL,NULL,NULL,NULL),(7,1,'Program',2,'created','{\"status\": \"Draft\", \"created_at\": \"2016-04-14T22:15:01\", \"kind\": \"Directive\", \"display_name\": \"Program 1\", \"description\": \"Description for Program 1\", \"end_date\": null, \"title\": \"Program 1\", \"os_state\": \"Modified\", \"secondary_contact_id\": null, \"notes\": \"Notes for Program 1<br>\", \"updated_at\": \"2016-04-14T22:15:01\", \"private\": false, \"start_date\": null, \"reference_url\": \"\", \"url\": \"\", \"contact_id\": 1, \"modified_by_id\": 1, \"context_id\": 4, \"slug\": \"PROGRAM-1\", \"id\": 1}',NULL,'2016-04-14 22:15:01','2016-04-14 22:15:01',1,NULL,NULL,NULL,NULL),(8,3,'Context',3,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:15:59','2016-04-14 22:15:59',1,NULL,NULL,NULL,NULL),(9,2,'Person',3,'created','{\"display_name\": \"email@company.com\", \"name\": \"John Doe\", \"updated_at\": \"2016-04-14T22:15:59\", \"context_id\": null, \"created_at\": \"2016-04-14T22:15:59\", \"language_id\": null, \"id\": 2, \"email\": \"email@company.com\", \"modified_by_id\": 1, \"company\": \"\"}',NULL,'2016-04-14 22:15:59','2016-04-14 22:15:59',1,NULL,NULL,NULL,NULL),(10,3,'Context',4,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:16:52','2016-04-14 22:16:52',1,NULL,NULL,NULL,NULL),(11,4,'ContextImplication',4,'created','{\"source_context_id\": 4, \"source_context_scope\": \"Program\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:16:52\", \"updated_at\": \"2016-04-14T22:16:52\", \"context_scope\": \"Audit\", \"modified_by_id\": 1, \"display_name\": \"Program Context 2016-04-14 22:15:01.893380 -> Audit Context 2016-04-14 22:16:52.345295\", \"id\": 4}',NULL,'2016-04-14 22:16:52','2016-04-14 22:16:52',1,NULL,NULL,NULL,NULL),(12,5,'ContextImplication',4,'created','{\"source_context_id\": 5, \"source_context_scope\": \"Audit\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:16:52\", \"updated_at\": \"2016-04-14T22:16:52\", \"context_scope\": \"Program\", \"modified_by_id\": 1, \"display_name\": \"Audit Context 2016-04-14 22:16:52.345295 -> Program Context 2016-04-14 22:15:01.893380\", \"id\": 5}',NULL,'2016-04-14 22:16:52','2016-04-14 22:16:52',1,NULL,NULL,NULL,NULL),(13,6,'ContextImplication',4,'created','{\"source_context_id\": 5, \"source_context_scope\": \"Audit\", \"context_id\": null, \"created_at\": \"2016-04-14T22:16:52\", \"updated_at\": \"2016-04-14T22:16:52\", \"context_scope\": null, \"modified_by_id\": 1, \"display_name\": \"Audit Context 2016-04-14 22:16:52.345295 -> Default Context\", \"id\": 6}',NULL,'2016-04-14 22:16:52','2016-04-14 22:16:52',1,NULL,NULL,NULL,NULL),(14,1,'Audit',4,'created','{\"context_id\": 5, \"object_type\": \"Assessment\", \"updated_at\": \"2016-04-14T22:16:52\", \"contact_id\": 1, \"id\": 1, \"display_name\": \"2016: Program 1 - Audit 1\", \"title\": \"2016: Program 1 - Audit 1\", \"modified_by_id\": 1, \"start_date\": \"2016-04-25T00:00:00\", \"status\": \"Planned\", \"gdrive_evidence_folder\": null, \"description\": \"\", \"end_date\": \"2016-05-25T00:00:00\", \"secondary_contact_id\": null, \"program_id\": 1, \"report_end_date\": null, \"slug\": \"AUDIT-1\", \"url\": null, \"audit_firm_id\": null, \"created_at\": \"2016-04-14T22:16:52\", \"reference_url\": null, \"notes\": null, \"report_start_date\": null}',NULL,'2016-04-14 22:16:52','2016-04-14 22:16:52',1,NULL,NULL,NULL,NULL),(15,5,'Context',4,'created','{\"display_name\": \"Audit Context 2016-04-14 22:16:52.345295\", \"name\": \"Audit Context 2016-04-14 22:16:52.345295\", \"context_id\": null, \"created_at\": \"2016-04-14T22:16:52\", \"updated_at\": \"2016-04-14T22:16:52\", \"related_object_type\": \"Audit\", \"modified_by_id\": 1, \"id\": 5, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:16:52','2016-04-14 22:16:52',1,NULL,NULL,NULL,NULL),(16,3,'Context',5,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:16:53','2016-04-14 22:16:53',1,NULL,NULL,NULL,NULL),(17,2,'UserRole',5,'created','{\"display_name\": \"email@company.com <-> Auditor in 2016: Program 1 - Audit 1\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:16:53\", \"updated_at\": \"2016-04-14T22:16:53\", \"role_id\": 14, \"modified_by_id\": 1, \"person_id\": 2, \"id\": 2}',NULL,'2016-04-14 22:16:53','2016-04-14 22:16:53',1,NULL,NULL,NULL,NULL),(18,3,'Context',6,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:16:54','2016-04-14 22:16:54',1,NULL,NULL,NULL,NULL),(19,3,'UserRole',6,'created','{\"display_name\": \"email@company.com <-> ProgramReader in Program 1\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:16:54\", \"updated_at\": \"2016-04-14T22:16:54\", \"role_id\": 3, \"modified_by_id\": 1, \"person_id\": 2, \"id\": 3}',NULL,'2016-04-14 22:16:54','2016-04-14 22:16:54',1,NULL,NULL,NULL,NULL),(20,3,'Context',7,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:17:32','2016-04-14 22:17:32',1,NULL,NULL,NULL,NULL),(21,4,'UserRole',7,'created','{\"display_name\": \"email@company.com <-> Editor\", \"context_id\": null, \"created_at\": \"2016-04-14T22:17:32\", \"updated_at\": \"2016-04-14T22:17:32\", \"role_id\": 6, \"modified_by_id\": 1, \"person_id\": 2, \"id\": 4}',NULL,'2016-04-14 22:17:32','2016-04-14 22:17:32',1,NULL,NULL,NULL,NULL),(22,3,'Context',8,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:20:26','2016-04-14 22:20:26',1,NULL,NULL,NULL,NULL),(23,1,'AssessmentTemplate',8,'created','{\"display_name\": \"Simple Assessment Template\", \"procedure_description\": null, \"title\": \"Simple Assessment Template\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:20:26\", \"updated_at\": \"2016-04-14T22:20:26\", \"modified_by_id\": 1, \"default_people\": \"{\\\"assessors\\\":\\\"Object Owners\\\",\\\"verifiers\\\":\\\"Object Owners\\\"}\", \"test_plan_procedure\": true, \"id\": 1, \"template_object_type\": \"Control\"}',NULL,'2016-04-14 22:20:26','2016-04-14 22:20:26',1,NULL,NULL,NULL,NULL),(24,3,'Context',9,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:20:27','2016-04-14 22:20:27',1,NULL,NULL,NULL,NULL),(25,1,'Relationship',9,'created','{\"status\": \"Draft\", \"display_name\": \"AssessmentTemplate:1 <-> Audit:1\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:20:27\", \"modified_by_id\": 1, \"updated_at\": \"2016-04-14T22:20:27\", \"source_type\": \"AssessmentTemplate\", \"automapping_id\": null, \"destination_id\": 1, \"destination_type\": \"Audit\", \"source_id\": 1, \"id\": 1, \"attrs\": {}}',NULL,'2016-04-14 22:20:27','2016-04-14 22:20:27',1,'AssessmentTemplate',1,'Audit',1),(26,3,'Context',10,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:20:27','2016-04-14 22:20:27',1,NULL,NULL,NULL,NULL),(27,1,'CustomAttributeDefinition',10,'created','{\"mandatory\": null, \"title\": \"OCA Text\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-14T22:20:27\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-14T22:20:27\", \"definition_id\": 1, \"definition_type\": \"assessment_template\", \"helptext\": null, \"attribute_type\": \"Text\", \"context_id\": 5, \"display_name\": \"OCA Text\", \"multi_choice_options\": \"\", \"id\": 1}',NULL,'2016-04-14 22:20:27','2016-04-14 22:20:27',1,NULL,NULL,NULL,NULL),(28,3,'Context',11,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(29,2,'AssessmentTemplate',11,'created','{\"display_name\": \"Full Assessment Template\", \"procedure_description\": null, \"title\": \"Full Assessment Template\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:22:41\", \"updated_at\": \"2016-04-14T22:22:41\", \"modified_by_id\": 1, \"default_people\": \"{\\\"assessors\\\":\\\"Object Owners\\\",\\\"verifiers\\\":\\\"Object Owners\\\"}\", \"test_plan_procedure\": false, \"id\": 2, \"template_object_type\": \"Control\"}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(30,3,'Context',12,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(31,2,'Relationship',12,'created','{\"status\": \"Draft\", \"display_name\": \"AssessmentTemplate:2 <-> Audit:1\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:22:41\", \"modified_by_id\": 1, \"updated_at\": \"2016-04-14T22:22:41\", \"source_type\": \"AssessmentTemplate\", \"automapping_id\": null, \"destination_id\": 1, \"destination_type\": \"Audit\", \"source_id\": 2, \"id\": 2, \"attrs\": {}}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,'AssessmentTemplate',2,'Audit',1),(32,3,'Context',13,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(33,2,'CustomAttributeDefinition',13,'created','{\"mandatory\": null, \"title\": \"OCA Rich Text\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-14T22:22:41\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-14T22:22:41\", \"definition_id\": 2, \"definition_type\": \"assessment_template\", \"helptext\": null, \"attribute_type\": \"Rich Text\", \"context_id\": 5, \"display_name\": \"OCA Rich Text\", \"multi_choice_options\": \"\", \"id\": 2}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(34,3,'CustomAttributeDefinition',14,'created','{\"mandatory\": null, \"title\": \"OCA Date\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-14T22:22:41\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-14T22:22:41\", \"definition_id\": 2, \"definition_type\": \"assessment_template\", \"helptext\": null, \"attribute_type\": \"Date\", \"context_id\": 5, \"display_name\": \"OCA Date\", \"multi_choice_options\": \"\", \"id\": 3}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(35,4,'CustomAttributeDefinition',15,'created','{\"mandatory\": null, \"title\": \"OCA Chexbox\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-14T22:22:41\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-14T22:22:41\", \"definition_id\": 2, \"definition_type\": \"assessment_template\", \"helptext\": null, \"attribute_type\": \"Checkbox\", \"context_id\": 5, \"display_name\": \"OCA Chexbox\", \"multi_choice_options\": \"box 1,box 2,box 3\", \"id\": 4}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(36,5,'CustomAttributeDefinition',16,'created','{\"mandatory\": null, \"title\": \"OCA Dropdown\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-14T22:22:41\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-14T22:22:41\", \"definition_id\": 2, \"definition_type\": \"assessment_template\", \"helptext\": null, \"attribute_type\": \"Dropdown\", \"context_id\": 5, \"display_name\": \"OCA Dropdown\", \"multi_choice_options\": \"value 1,value 2,value 3\", \"id\": 5}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(37,6,'CustomAttributeDefinition',17,'created','{\"mandatory\": null, \"title\": \"OCA Person\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-14T22:22:41\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-14T22:22:41\", \"definition_id\": 2, \"definition_type\": \"assessment_template\", \"helptext\": null, \"attribute_type\": \"Map:Person\", \"context_id\": 5, \"display_name\": \"OCA Person\", \"multi_choice_options\": \"\", \"id\": 6}',NULL,'2016-04-14 22:22:41','2016-04-14 22:22:41',1,NULL,NULL,NULL,NULL),(38,3,'Context',18,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:25:43','2016-04-14 22:25:43',1,NULL,NULL,NULL,NULL),(39,3,'AssessmentTemplate',18,'created','{\"display_name\": \"Different Assessment Template\", \"procedure_description\": null, \"title\": \"Different Assessment Template\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:25:43\", \"updated_at\": \"2016-04-14T22:25:43\", \"modified_by_id\": 1, \"default_people\": \"{\\\"assessors\\\":\\\"Object Owners\\\",\\\"verifiers\\\":\\\"Object Owners\\\"}\", \"test_plan_procedure\": false, \"id\": 3, \"template_object_type\": \"Control\"}',NULL,'2016-04-14 22:25:43','2016-04-14 22:25:43',1,NULL,NULL,NULL,NULL),(40,3,'Context',19,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:25:43','2016-04-14 22:25:43',1,NULL,NULL,NULL,NULL),(41,3,'Relationship',19,'created','{\"status\": \"Draft\", \"display_name\": \"AssessmentTemplate:3 <-> Audit:1\", \"context_id\": 5, \"created_at\": \"2016-04-14T22:25:43\", \"modified_by_id\": 1, \"updated_at\": \"2016-04-14T22:25:43\", \"source_type\": \"AssessmentTemplate\", \"automapping_id\": null, \"destination_id\": 1, \"destination_type\": \"Audit\", \"source_id\": 3, \"id\": 3, \"attrs\": {}}',NULL,'2016-04-14 22:25:43','2016-04-14 22:25:43',1,'AssessmentTemplate',3,'Audit',1),(42,3,'Context',20,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-14 22:25:43','2016-04-14 22:25:43',1,NULL,NULL,NULL,NULL),(43,7,'CustomAttributeDefinition',20,'created','{\"mandatory\": null, \"title\": \"OCA Text\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-14T22:25:43\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-14T22:25:43\", \"definition_id\": 3, \"definition_type\": \"assessment_template\", \"helptext\": null, \"attribute_type\": \"Text\", \"context_id\": 5, \"display_name\": \"OCA Text\", \"multi_choice_options\": \"\", \"id\": 7}',NULL,'2016-04-14 22:25:43','2016-04-14 22:25:43',1,NULL,NULL,NULL,NULL),(44,3,'Context',21,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-18 03:48:20','2016-04-18 03:48:20',1,NULL,NULL,NULL,NULL),(45,1,'Control',21,'created','{\"company_control\": null, \"principal_assessor_id\": null, \"updated_at\": \"2016-04-18T03:48:20\", \"contact_id\": 1, \"fraud_related\": null, \"id\": 1, \"display_name\": \"Control 1\", \"title\": \"Control 1\", \"kind_id\": null, \"documentation_description\": null, \"parent_id\": null, \"version\": null, \"directive_id\": null, \"secondary_contact_id\": null, \"context_id\": null, \"start_date\": null, \"status\": \"Draft\", \"description\": \"Description for Control 1\", \"end_date\": null, \"os_state\": \"Modified\", \"secondary_assessor_id\": null, \"means_id\": null, \"modified_by_id\": 1, \"verify_frequency_id\": null, \"active\": null, \"slug\": \"CONTROL-1\", \"url\": \"\", \"notes\": \"Some notes for Control 1\", \"key_control\": null, \"reference_url\": \"\", \"test_plan\": \"Test Plan for Control 1\", \"created_at\": \"2016-04-18T03:48:20\"}',NULL,'2016-04-18 03:48:20','2016-04-18 03:48:20',1,NULL,NULL,NULL,NULL),(46,3,'Context',22,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-18 03:48:20','2016-04-18 03:48:20',1,NULL,NULL,NULL,NULL),(47,1,'Person',22,'modified','{\"display_name\": \"user@example.com\", \"name\": \"Example User\", \"updated_at\": \"2016-04-14T22:14:01\", \"context_id\": null, \"created_at\": \"2016-04-14T22:14:01\", \"language_id\": null, \"id\": 1, \"email\": \"user@example.com\", \"modified_by_id\": null, \"company\": null}',NULL,'2016-04-18 03:48:20','2016-04-18 03:48:20',1,NULL,NULL,NULL,NULL),(48,1,'ObjectOwner',22,'created','{\"status\": \"Draft\", \"display_name\": \"Control 1<->user@example.com\", \"context_id\": null, \"created_at\": \"2016-04-18T03:48:20\", \"updated_at\": \"2016-04-18T03:48:20\", \"ownable_type\": \"Control\", \"modified_by_id\": 1, \"person_id\": 1, \"ownable_id\": 1, \"id\": 1}',NULL,'2016-04-18 03:48:20','2016-04-18 03:48:20',1,NULL,NULL,NULL,NULL),(49,3,'Context',23,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-18 03:48:49','2016-04-18 03:48:49',1,NULL,NULL,NULL,NULL),(50,2,'Control',23,'created','{\"company_control\": null, \"principal_assessor_id\": null, \"updated_at\": \"2016-04-18T03:48:49\", \"contact_id\": 1, \"fraud_related\": null, \"id\": 2, \"display_name\": \"Control 2\", \"title\": \"Control 2\", \"kind_id\": null, \"documentation_description\": null, \"parent_id\": null, \"version\": null, \"directive_id\": null, \"secondary_contact_id\": null, \"context_id\": null, \"start_date\": null, \"status\": \"Draft\", \"description\": \"Description for Control 2\", \"end_date\": null, \"os_state\": \"Modified\", \"secondary_assessor_id\": null, \"means_id\": null, \"modified_by_id\": 1, \"verify_frequency_id\": null, \"active\": null, \"slug\": \"CONTROL-2\", \"url\": \"\", \"notes\": \"\", \"key_control\": null, \"reference_url\": \"\", \"test_plan\": \"Test Plan for Control 2\", \"created_at\": \"2016-04-18T03:48:49\"}',NULL,'2016-04-18 03:48:49','2016-04-18 03:48:49',1,NULL,NULL,NULL,NULL),(51,3,'Context',24,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-18 03:48:49','2016-04-18 03:48:49',1,NULL,NULL,NULL,NULL),(52,1,'Person',24,'modified','{\"display_name\": \"user@example.com\", \"name\": \"Example User\", \"updated_at\": \"2016-04-14T22:14:01\", \"context_id\": null, \"created_at\": \"2016-04-14T22:14:01\", \"language_id\": null, \"id\": 1, \"email\": \"user@example.com\", \"modified_by_id\": null, \"company\": null}',NULL,'2016-04-18 03:48:49','2016-04-18 03:48:49',1,NULL,NULL,NULL,NULL),(53,2,'ObjectOwner',24,'created','{\"status\": \"Draft\", \"display_name\": \"Control 2<->user@example.com\", \"context_id\": null, \"created_at\": \"2016-04-18T03:48:49\", \"updated_at\": \"2016-04-18T03:48:49\", \"ownable_type\": \"Control\", \"modified_by_id\": 1, \"person_id\": 1, \"ownable_id\": 2, \"id\": 2}',NULL,'2016-04-18 03:48:49','2016-04-18 03:48:49',1,NULL,NULL,NULL,NULL),(54,3,'Context',25,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-18 03:50:17','2016-04-18 03:50:17',1,NULL,NULL,NULL,NULL),(55,5,'Relationship',25,'created','{\"status\": \"Draft\", \"display_name\": \"Program:1 <-> Control:1\", \"context_id\": 4, \"created_at\": \"2016-04-18T03:50:17\", \"modified_by_id\": 1, \"updated_at\": \"2016-04-18T03:50:17\", \"source_type\": \"Program\", \"automapping_id\": null, \"destination_id\": 1, \"destination_type\": \"Control\", \"source_id\": 1, \"id\": 5, \"attrs\": {}}',NULL,'2016-04-18 03:50:17','2016-04-18 03:50:17',1,'Program',1,'Control',1),(56,7,'Relationship',26,'created','{\"status\": \"Draft\", \"display_name\": \"Program:1 <-> Control:2\", \"context_id\": 4, \"created_at\": \"2016-04-18T03:50:17\", \"modified_by_id\": 1, \"updated_at\": \"2016-04-18T03:50:17\", \"source_type\": \"Program\", \"automapping_id\": null, \"destination_id\": 2, \"destination_type\": \"Control\", \"source_id\": 1, \"id\": 7, \"attrs\": {}}',NULL,'2016-04-18 03:50:17','2016-04-18 03:50:17',1,'Program',1,'Control',2),(57,3,'Context',27,'modified','{\"display_name\": \"Personal Context for user@example.com\", \"name\": \"Personal Context for user@example.com\", \"context_id\": 4, \"created_at\": \"2016-04-14T22:14:02\", \"updated_at\": \"2016-04-14T22:15:01\", \"related_object_type\": \"Person\", \"modified_by_id\": 1, \"id\": 3, \"related_object_id\": 1, \"description\": \"\"}',NULL,'2016-04-21 14:52:56','2016-04-21 14:52:56',1,NULL,NULL,NULL,NULL),(58,8,'CustomAttributeDefinition',27,'created','{\"mandatory\": false, \"title\": \"CA checkbox\", \"multi_choice_mandatory\": null, \"created_at\": \"2016-04-21T14:52:56\", \"modified_by_id\": 1, \"placeholder\": null, \"updated_at\": \"2016-04-21T14:52:56\", \"definition_id\": null, \"definition_type\": \"assessment\", \"helptext\": \"\", \"attribute_type\": \"Checkbox\", \"context_id\": null, \"display_name\": \"CA checkbox\", \"multi_choice_options\": null, \"id\": 8}',NULL,'2016-04-21 14:52:56','2016-04-21 14:52:56',1,NULL,NULL,NULL,NULL);
2246/*!40000 ALTER TABLE `revisions` ENABLE KEYS */;
2247UNLOCK TABLES;
2248
2249--
2250-- Table structure for table `risk_assessments`
2251--
2252
2253DROP TABLE IF EXISTS `risk_assessments`;
2254/*!40101 SET @saved_cs_client     = @@character_set_client */;
2255/*!40101 SET character_set_client = utf8 */;
2256CREATE TABLE `risk_assessments` (
2257  `id` int(11) NOT NULL AUTO_INCREMENT,
2258  `title` varchar(250) NOT NULL,
2259  `description` text,
2260  `notes` text,
2261  `ra_manager_id` int(11) DEFAULT NULL,
2262  `ra_counsel_id` int(11) DEFAULT NULL,
2263  `start_date` date DEFAULT NULL,
2264  `end_date` date DEFAULT NULL,
2265  `created_at` datetime DEFAULT NULL,
2266  `modified_by_id` int(11) DEFAULT NULL,
2267  `updated_at` datetime DEFAULT NULL,
2268  `context_id` int(11) DEFAULT NULL,
2269  `program_id` int(11) NOT NULL,
2270  `slug` varchar(250) NOT NULL,
2271  PRIMARY KEY (`id`),
2272  UNIQUE KEY `unique_slug` (`slug`),
2273  KEY `fk_risk_assessments_manager_person_id` (`ra_manager_id`),
2274  KEY `fk_risk_assessments_counsel_person_id` (`ra_counsel_id`),
2275  KEY `fk_risk_assessments_contexts` (`context_id`),
2276  KEY `ix_risk_assessments_updated_at` (`updated_at`),
2277  CONSTRAINT `fk_risk_assessments_counsel_person_id` FOREIGN KEY (`ra_counsel_id`) REFERENCES `people` (`id`),
2278  CONSTRAINT `fk_risk_assessments_manager_person_id` FOREIGN KEY (`ra_manager_id`) REFERENCES `people` (`id`),
2279  CONSTRAINT `risk_assessments_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
2280) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2281/*!40101 SET character_set_client = @saved_cs_client */;
2282
2283--
2284-- Dumping data for table `risk_assessments`
2285--
2286
2287LOCK TABLES `risk_assessments` WRITE;
2288/*!40000 ALTER TABLE `risk_assessments` DISABLE KEYS */;
2289/*!40000 ALTER TABLE `risk_assessments` ENABLE KEYS */;
2290UNLOCK TABLES;
2291
2292--
2293-- Table structure for table `risk_objects`
2294--
2295
2296DROP TABLE IF EXISTS `risk_objects`;
2297/*!40101 SET @saved_cs_client     = @@character_set_client */;
2298/*!40101 SET character_set_client = utf8 */;
2299CREATE TABLE `risk_objects` (
2300  `id` int(11) NOT NULL AUTO_INCREMENT,
2301  `risk_id` int(11) NOT NULL,
2302  `object_id` int(11) NOT NULL,
2303  `object_type` varchar(250) NOT NULL,
2304  `status` varchar(250) DEFAULT NULL,
2305  `created_at` datetime DEFAULT NULL,
2306  `modified_by_id` int(11) DEFAULT NULL,
2307  `updated_at` datetime DEFAULT NULL,
2308  `context_id` int(11) DEFAULT NULL,
2309  `secondary_contact_id` int(11) DEFAULT NULL,
2310  PRIMARY KEY (`id`),
2311  UNIQUE KEY `risk_id` (`risk_id`,`object_id`,`object_type`),
2312  KEY `fk_risk_objects_contexts` (`context_id`),
2313  KEY `ix_risk_id` (`risk_id`),
2314  KEY `fk_risk_objects_secondary_contact` (`secondary_contact_id`),
2315  CONSTRAINT `risk_objects_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2316  CONSTRAINT `risk_objects_ibfk_2` FOREIGN KEY (`risk_id`) REFERENCES `risks` (`id`)
2317) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2318/*!40101 SET character_set_client = @saved_cs_client */;
2319
2320--
2321-- Dumping data for table `risk_objects`
2322--
2323
2324LOCK TABLES `risk_objects` WRITE;
2325/*!40000 ALTER TABLE `risk_objects` DISABLE KEYS */;
2326/*!40000 ALTER TABLE `risk_objects` ENABLE KEYS */;
2327UNLOCK TABLES;
2328
2329--
2330-- Table structure for table `risks`
2331--
2332
2333DROP TABLE IF EXISTS `risks`;
2334/*!40101 SET @saved_cs_client     = @@character_set_client */;
2335/*!40101 SET character_set_client = utf8 */;
2336CREATE TABLE `risks` (
2337  `id` int(11) NOT NULL AUTO_INCREMENT,
2338  `slug` varchar(250) NOT NULL,
2339  `created_at` datetime DEFAULT NULL,
2340  `modified_by_id` int(11) DEFAULT NULL,
2341  `updated_at` datetime DEFAULT NULL,
2342  `context_id` int(11) DEFAULT NULL,
2343  `title` varchar(250) NOT NULL,
2344  `contact_id` int(11) DEFAULT NULL,
2345  `description` text NOT NULL,
2346  `start_date` date DEFAULT NULL,
2347  `end_date` date DEFAULT NULL,
2348  `status` varchar(250) DEFAULT NULL,
2349  `secondary_contact_id` int(11) DEFAULT NULL,
2350  `os_state` varchar(250) NOT NULL,
2351  `notes` text,
2352  PRIMARY KEY (`id`),
2353  UNIQUE KEY `uq_risks` (`slug`),
2354  UNIQUE KEY `uq_t_risks` (`title`),
2355  KEY `fk_risks_contexts` (`context_id`),
2356  KEY `fk_risks_secondary_contact` (`secondary_contact_id`),
2357  CONSTRAINT `risks_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
2358) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2359/*!40101 SET character_set_client = @saved_cs_client */;
2360
2361--
2362-- Dumping data for table `risks`
2363--
2364
2365LOCK TABLES `risks` WRITE;
2366/*!40000 ALTER TABLE `risks` DISABLE KEYS */;
2367/*!40000 ALTER TABLE `risks` ENABLE KEYS */;
2368UNLOCK TABLES;
2369
2370--
2371-- Table structure for table `roles`
2372--
2373
2374DROP TABLE IF EXISTS `roles`;
2375/*!40101 SET @saved_cs_client     = @@character_set_client */;
2376/*!40101 SET character_set_client = utf8 */;
2377CREATE TABLE `roles` (
2378  `id` int(11) NOT NULL AUTO_INCREMENT,
2379  `name` varchar(128) NOT NULL,
2380  `permissions_json` text NOT NULL,
2381  `description` text,
2382  `modified_by_id` int(11) DEFAULT NULL,
2383  `created_at` datetime DEFAULT NULL,
2384  `updated_at` datetime DEFAULT NULL,
2385  `context_id` int(11) DEFAULT NULL,
2386  `scope` varchar(64) DEFAULT NULL,
2387  `role_order` int(11) DEFAULT NULL,
2388  PRIMARY KEY (`id`),
2389  KEY `fk_roles_contexts` (`context_id`),
2390  KEY `ix_roles_updated_at` (`updated_at`)
2391) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
2392/*!40101 SET character_set_client = @saved_cs_client */;
2393
2394--
2395-- Dumping data for table `roles`
2396--
2397
2398LOCK TABLES `roles` WRITE;
2399/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
2400INSERT INTO `roles` VALUES (1,'ProgramOwner','CODE DECLARED ROLE','User with authorization to peform administrative tasks such as associating users to roles within the scope of of a program.<br/><br/>When a person creates a program they are automatically given the ProgramOwner role. This allows them to Edit, Delete, or Map objects to the Program. It also allows them to add people and assign them roles when their programs are private. ProgramOwner is the most powerful role.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Private Program',1),(2,'ProgramEditor','CODE DECLARED ROLE','A user with authorization to edit mapping objects related to an access controlled program.<br/><br/>When a person has this role they can map and unmap objects to the Program and edit the Program info, but they are unable to delete the Program or assign other people roles for that program.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Private Program',2),(3,'ProgramReader','CODE DECLARED ROLE','A user with authorization to read mapping objects related to an access controlled Program.<br/><br/>This is essentially a view only role. A person with this role can access and view an otherwise private program, but they cannot map to or edit that program in any way.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Private Program',3),(5,'Reader','CODE DECLARED ROLE','This role grants a user basic, read-only, access permission to a gGRC instance.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'System',5),(6,'Editor','CODE DECLARED ROLE','Global Editor',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'System',6),(8,'gGRC Admin','{\"__GGRC_ADMIN__\": [\"__GGRC_ALL__\"]}','gGRC System Administrator with super-user privileges',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Admin',8),(9,'AuditorReader','CODE DECLARED ROLE','A user with Auditor role for a program audit will also have this role in the default object context so that the auditor will have access to the objects required to perform the audit.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'System Implied',9),(10,'AuditorProgramReader','CODE DECLARED ROLE','A user with Auditor role for a program audit will also have this role in the program context so that the auditor will have access to the private program information and mappings required to perform the audit.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Private Program Implied',10),(11,'ProgramAuditOwner','CODE DECLARED ROLE','A user with the ProgramOwner role for a private program will also have this role in the audit context for any audit created for that program.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Audit Implied',11),(12,'ProgramAuditEditor','CODE DECLARED ROLE','A user with the ProgramEditor role for a private program will also have this role in the audit context for any audit created for that program.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Audit Implied',12),(13,'ProgramAuditReader','CODE DECLARED ROLE','A user with the ProgramReader role for a private program will also have this role in the audit context for any audit created for that program.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Audit Implied',13),(14,'Auditor','CODE DECLARED ROLE','The permissions required by an auditor to access relevant resources for the program being audited.',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Audit',14),(15,'ProgramBasicReader','CODE DECLARED ROLE','Allow any user assigned a role in a program the ability to read Role resources.',1,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Program Implied',15),(16,'ProgramMappingEditor','CODE DECLARED ROLE','\n              This role grants a user permission to edit program mappings.\n              ',1,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'Private Program Implied',16),(17,'Creator','CODE DECLARED ROLE','Global creator',NULL,'2016-04-14 22:13:48','2016-04-14 22:13:48',NULL,'System',4),(18,'WorkflowOwner','CODE DECLARED ROLE','This role grants a user permission to edit workflow mappings and details',1,'2016-04-14 22:13:49','2016-04-14 22:13:49',NULL,'Workflow',NULL),(19,'WorkflowMember','CODE DECLARED ROLE','This role grants a user permission to edit workflow mappings',1,'2016-04-14 22:13:49','2016-04-14 22:13:49',NULL,'Workflow',NULL),(20,'BasicWorkflowReader','CODE DECLARED ROLE',' ',1,'2016-04-14 22:13:49','2016-04-14 22:13:49',NULL,'Workflow Implied',NULL),(21,'WorkflowBasicReader','CODE DECLARED ROLE',' ',1,'2016-04-14 22:13:49','2016-04-14 22:13:49',NULL,'Workflow Implied',NULL);
2401/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
2402UNLOCK TABLES;
2403
2404--
2405-- Table structure for table `sections`
2406--
2407
2408DROP TABLE IF EXISTS `sections`;
2409/*!40101 SET @saved_cs_client     = @@character_set_client */;
2410/*!40101 SET character_set_client = utf8 */;
2411CREATE TABLE `sections` (
2412  `id` int(11) NOT NULL AUTO_INCREMENT,
2413  `modified_by_id` int(11) DEFAULT NULL,
2414  `created_at` datetime DEFAULT NULL,
2415  `updated_at` datetime DEFAULT NULL,
2416  `description` text,
2417  `url` varchar(250) DEFAULT NULL,
2418  `slug` varchar(250) NOT NULL,
2419  `title` varchar(250) NOT NULL,
2420  `na` tinyint(1) NOT NULL,
2421  `notes` text,
2422  `parent_id` int(11) DEFAULT NULL,
2423  `context_id` int(11) DEFAULT NULL,
2424  `contact_id` int(11) DEFAULT NULL,
2425  `reference_url` varchar(250) DEFAULT NULL,
2426  `secondary_contact_id` int(11) DEFAULT NULL,
2427  `os_state` varchar(16) NOT NULL,
2428  `status` varchar(250) DEFAULT NULL,
2429  `end_date` date DEFAULT NULL,
2430  `start_date` date DEFAULT NULL,
2431  PRIMARY KEY (`id`),
2432  UNIQUE KEY `uq_sections` (`slug`),
2433  UNIQUE KEY `uq_t_sections` (`title`),
2434  KEY `parent_id` (`parent_id`),
2435  KEY `fk_sections_contexts` (`context_id`),
2436  KEY `fk_sections_contact` (`contact_id`),
2437  KEY `ix_sections_updated_at` (`updated_at`),
2438  KEY `fk_sections_secondary_contact` (`secondary_contact_id`),
2439  CONSTRAINT `fk_sections_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2440  CONSTRAINT `sections_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `sections` (`id`)
2441) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2442/*!40101 SET character_set_client = @saved_cs_client */;
2443
2444--
2445-- Dumping data for table `sections`
2446--
2447
2448LOCK TABLES `sections` WRITE;
2449/*!40000 ALTER TABLE `sections` DISABLE KEYS */;
2450/*!40000 ALTER TABLE `sections` ENABLE KEYS */;
2451UNLOCK TABLES;
2452
2453--
2454-- Table structure for table `systems`
2455--
2456
2457DROP TABLE IF EXISTS `systems`;
2458/*!40101 SET @saved_cs_client     = @@character_set_client */;
2459/*!40101 SET character_set_client = utf8 */;
2460CREATE TABLE `systems` (
2461  `id` int(11) NOT NULL AUTO_INCREMENT,
2462  `modified_by_id` int(11) DEFAULT NULL,
2463  `created_at` datetime DEFAULT NULL,
2464  `updated_at` datetime DEFAULT NULL,
2465  `description` text,
2466  `url` varchar(250) DEFAULT NULL,
2467  `start_date` date DEFAULT NULL,
2468  `end_date` date DEFAULT NULL,
2469  `slug` varchar(250) NOT NULL,
2470  `title` varchar(250) NOT NULL,
2471  `infrastructure` tinyint(1) DEFAULT NULL,
2472  `contact_id` int(11) DEFAULT NULL,
2473  `is_biz_process` tinyint(1) DEFAULT NULL,
2474  `version` varchar(250) DEFAULT NULL,
2475  `notes` text,
2476  `network_zone_id` int(11) DEFAULT NULL,
2477  `context_id` int(11) DEFAULT NULL,
2478  `status` varchar(250) DEFAULT NULL,
2479  `reference_url` varchar(250) DEFAULT NULL,
2480  `secondary_contact_id` int(11) DEFAULT NULL,
2481  `os_state` varchar(16) NOT NULL,
2482  PRIMARY KEY (`id`),
2483  UNIQUE KEY `uq_systems` (`slug`),
2484  UNIQUE KEY `uq_t_systems` (`title`),
2485  KEY `fk_systems_contexts` (`context_id`),
2486  KEY `fk_systems_contact` (`contact_id`),
2487  KEY `ix_systems_is_biz_process` (`is_biz_process`),
2488  KEY `ix_systems_updated_at` (`updated_at`),
2489  KEY `fk_systems_secondary_contact` (`secondary_contact_id`),
2490  CONSTRAINT `fk_systems_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
2491) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2492/*!40101 SET character_set_client = @saved_cs_client */;
2493
2494--
2495-- Dumping data for table `systems`
2496--
2497
2498LOCK TABLES `systems` WRITE;
2499/*!40000 ALTER TABLE `systems` DISABLE KEYS */;
2500/*!40000 ALTER TABLE `systems` ENABLE KEYS */;
2501UNLOCK TABLES;
2502
2503--
2504-- Table structure for table `task_group_objects`
2505--
2506
2507DROP TABLE IF EXISTS `task_group_objects`;
2508/*!40101 SET @saved_cs_client     = @@character_set_client */;
2509/*!40101 SET character_set_client = utf8 */;
2510CREATE TABLE `task_group_objects` (
2511  `id` int(11) NOT NULL AUTO_INCREMENT,
2512  `task_group_id` int(11) NOT NULL,
2513  `object_id` int(11) NOT NULL,
2514  `object_type` varchar(250) NOT NULL,
2515  `end_date` date DEFAULT NULL,
2516  `start_date` date DEFAULT NULL,
2517  `status` varchar(250) DEFAULT NULL,
2518  `created_at` datetime DEFAULT NULL,
2519  `modified_by_id` int(11) DEFAULT NULL,
2520  `updated_at` datetime DEFAULT NULL,
2521  `context_id` int(11) DEFAULT NULL,
2522  PRIMARY KEY (`id`),
2523  UNIQUE KEY `task_group_id` (`task_group_id`,`object_id`,`object_type`),
2524  KEY `fk_task_group_objects_contexts` (`context_id`),
2525  KEY `ix_task_group_id` (`task_group_id`),
2526  KEY `ix_task_group_objects_updated_at` (`updated_at`),
2527  CONSTRAINT `fk_task_group_objects_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2528  CONSTRAINT `fk_task_group_objects_task_group_id` FOREIGN KEY (`task_group_id`) REFERENCES `task_groups` (`id`)
2529) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2530/*!40101 SET character_set_client = @saved_cs_client */;
2531
2532--
2533-- Dumping data for table `task_group_objects`
2534--
2535
2536LOCK TABLES `task_group_objects` WRITE;
2537/*!40000 ALTER TABLE `task_group_objects` DISABLE KEYS */;
2538/*!40000 ALTER TABLE `task_group_objects` ENABLE KEYS */;
2539UNLOCK TABLES;
2540
2541--
2542-- Table structure for table `task_group_tasks`
2543--
2544
2545DROP TABLE IF EXISTS `task_group_tasks`;
2546/*!40101 SET @saved_cs_client     = @@character_set_client */;
2547/*!40101 SET character_set_client = utf8 */;
2548CREATE TABLE `task_group_tasks` (
2549  `id` int(11) NOT NULL AUTO_INCREMENT,
2550  `task_group_id` int(11) NOT NULL,
2551  `end_date` date DEFAULT NULL,
2552  `start_date` date DEFAULT NULL,
2553  `created_at` datetime DEFAULT NULL,
2554  `modified_by_id` int(11) DEFAULT NULL,
2555  `updated_at` datetime DEFAULT NULL,
2556  `context_id` int(11) DEFAULT NULL,
2557  `sort_index` varchar(250) NOT NULL,
2558  `contact_id` int(11) DEFAULT NULL,
2559  `description` text,
2560  `title` varchar(250) NOT NULL,
2561  `relative_end_day` int(11) DEFAULT NULL,
2562  `relative_end_month` int(11) DEFAULT NULL,
2563  `relative_start_day` int(11) DEFAULT NULL,
2564  `relative_start_month` int(11) DEFAULT NULL,
2565  `object_approval` tinyint(1) NOT NULL,
2566  `response_options` text NOT NULL,
2567  `task_type` varchar(250) NOT NULL,
2568  `secondary_contact_id` int(11) DEFAULT NULL,
2569  `slug` varchar(250) NOT NULL,
2570  PRIMARY KEY (`id`),
2571  UNIQUE KEY `unique_slug` (`slug`),
2572  KEY `fk_task_group_tasks_contexts` (`context_id`),
2573  KEY `fk_task_group_tasks_task_group_id` (`task_group_id`),
2574  KEY `fk_task_group_tasks_contact` (`contact_id`),
2575  KEY `ix_task_group_tasks_updated_at` (`updated_at`),
2576  KEY `fk_task_group_tasks_secondary_contact` (`secondary_contact_id`),
2577  CONSTRAINT `fk_task_group_tasks_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2578  CONSTRAINT `fk_task_group_tasks_task_group_id` FOREIGN KEY (`task_group_id`) REFERENCES `task_groups` (`id`)
2579) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2580/*!40101 SET character_set_client = @saved_cs_client */;
2581
2582--
2583-- Dumping data for table `task_group_tasks`
2584--
2585
2586LOCK TABLES `task_group_tasks` WRITE;
2587/*!40000 ALTER TABLE `task_group_tasks` DISABLE KEYS */;
2588/*!40000 ALTER TABLE `task_group_tasks` ENABLE KEYS */;
2589UNLOCK TABLES;
2590
2591--
2592-- Table structure for table `task_groups`
2593--
2594
2595DROP TABLE IF EXISTS `task_groups`;
2596/*!40101 SET @saved_cs_client     = @@character_set_client */;
2597/*!40101 SET character_set_client = utf8 */;
2598CREATE TABLE `task_groups` (
2599  `id` int(11) NOT NULL AUTO_INCREMENT,
2600  `workflow_id` int(11) NOT NULL,
2601  `contact_id` int(11) DEFAULT NULL,
2602  `end_date` date DEFAULT NULL,
2603  `start_date` date DEFAULT NULL,
2604  `description` text,
2605  `title` varchar(250) NOT NULL,
2606  `slug` varchar(250) NOT NULL,
2607  `created_at` datetime DEFAULT NULL,
2608  `modified_by_id` int(11) DEFAULT NULL,
2609  `updated_at` datetime DEFAULT NULL,
2610  `context_id` int(11) DEFAULT NULL,
2611  `lock_task_order` tinyint(1) DEFAULT NULL,
2612  `sort_index` varchar(250) NOT NULL,
2613  `secondary_contact_id` int(11) DEFAULT NULL,
2614  PRIMARY KEY (`id`),
2615  UNIQUE KEY `uq_task_groups` (`slug`),
2616  KEY `fk_task_groups_workflow_id` (`workflow_id`),
2617  KEY `fk_task_groups_contact` (`contact_id`),
2618  KEY `fk_task_groups_contexts` (`context_id`),
2619  KEY `ix_task_groups_updated_at` (`updated_at`),
2620  KEY `fk_task_groups_secondary_contact` (`secondary_contact_id`),
2621  CONSTRAINT `fk_task_groups_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
2622  CONSTRAINT `fk_task_groups_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2623  CONSTRAINT `fk_task_groups_workflow_id` FOREIGN KEY (`workflow_id`) REFERENCES `workflows` (`id`)
2624) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2625/*!40101 SET character_set_client = @saved_cs_client */;
2626
2627--
2628-- Dumping data for table `task_groups`
2629--
2630
2631LOCK TABLES `task_groups` WRITE;
2632/*!40000 ALTER TABLE `task_groups` DISABLE KEYS */;
2633/*!40000 ALTER TABLE `task_groups` ENABLE KEYS */;
2634UNLOCK TABLES;
2635
2636--
2637-- Table structure for table `threats`
2638--
2639
2640DROP TABLE IF EXISTS `threats`;
2641/*!40101 SET @saved_cs_client     = @@character_set_client */;
2642/*!40101 SET character_set_client = utf8 */;
2643CREATE TABLE `threats` (
2644  `id` int(11) NOT NULL AUTO_INCREMENT,
2645  `modified_by_id` int(11) DEFAULT NULL,
2646  `created_at` datetime DEFAULT NULL,
2647  `updated_at` datetime DEFAULT NULL,
2648  `description` text,
2649  `url` varchar(250) DEFAULT NULL,
2650  `start_date` date DEFAULT NULL,
2651  `end_date` date DEFAULT NULL,
2652  `slug` varchar(250) NOT NULL,
2653  `title` varchar(250) NOT NULL,
2654  `context_id` int(11) DEFAULT NULL,
2655  `contact_id` int(11) DEFAULT NULL,
2656  `notes` text,
2657  `status` varchar(250) DEFAULT NULL,
2658  `reference_url` varchar(250) DEFAULT NULL,
2659  `secondary_contact_id` int(11) DEFAULT NULL,
2660  `os_state` varchar(250) NOT NULL,
2661  PRIMARY KEY (`id`),
2662  UNIQUE KEY `uq_t_actors` (`title`),
2663  UNIQUE KEY `uq_threats` (`slug`),
2664  KEY `fk_threat_actors_secondary_contact` (`secondary_contact_id`)
2665) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2666/*!40101 SET character_set_client = @saved_cs_client */;
2667
2668--
2669-- Dumping data for table `threats`
2670--
2671
2672LOCK TABLES `threats` WRITE;
2673/*!40000 ALTER TABLE `threats` DISABLE KEYS */;
2674/*!40000 ALTER TABLE `threats` ENABLE KEYS */;
2675UNLOCK TABLES;
2676
2677--
2678-- Table structure for table `user_roles`
2679--
2680
2681DROP TABLE IF EXISTS `user_roles`;
2682/*!40101 SET @saved_cs_client     = @@character_set_client */;
2683/*!40101 SET character_set_client = utf8 */;
2684CREATE TABLE `user_roles` (
2685  `id` int(11) NOT NULL AUTO_INCREMENT,
2686  `role_id` int(11) NOT NULL,
2687  `modified_by_id` int(11) DEFAULT NULL,
2688  `created_at` datetime DEFAULT NULL,
2689  `updated_at` datetime DEFAULT NULL,
2690  `context_id` int(11) DEFAULT NULL,
2691  `person_id` int(11) NOT NULL,
2692  PRIMARY KEY (`id`),
2693  UNIQUE KEY `unique_role_context_person` (`role_id`,`context_id`,`person_id`),
2694  KEY `fk_user_roles_contexts` (`context_id`),
2695  KEY `ix_user_roles_person` (`person_id`),
2696  KEY `ix_user_roles_updated_at` (`updated_at`),
2697  CONSTRAINT `user_roles_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
2698) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
2699/*!40101 SET character_set_client = @saved_cs_client */;
2700
2701--
2702-- Dumping data for table `user_roles`
2703--
2704
2705LOCK TABLES `user_roles` WRITE;
2706/*!40000 ALTER TABLE `user_roles` DISABLE KEYS */;
2707INSERT INTO `user_roles` VALUES (1,1,1,'2016-04-14 22:15:01','2016-04-14 22:15:01',4,1),(2,14,1,'2016-04-14 22:16:53','2016-04-14 22:16:53',5,2),(3,3,1,'2016-04-14 22:16:54','2016-04-14 22:16:54',4,2),(4,6,1,'2016-04-14 22:17:32','2016-04-14 22:17:32',NULL,2);
2708/*!40000 ALTER TABLE `user_roles` ENABLE KEYS */;
2709UNLOCK TABLES;
2710
2711--
2712-- Table structure for table `vendors`
2713--
2714
2715DROP TABLE IF EXISTS `vendors`;
2716/*!40101 SET @saved_cs_client     = @@character_set_client */;
2717/*!40101 SET character_set_client = utf8 */;
2718CREATE TABLE `vendors` (
2719  `id` int(11) NOT NULL AUTO_INCREMENT,
2720  `modified_by_id` int(11) DEFAULT NULL,
2721  `created_at` datetime DEFAULT NULL,
2722  `updated_at` datetime DEFAULT NULL,
2723  `description` text,
2724  `url` varchar(250) DEFAULT NULL,
2725  `start_date` datetime DEFAULT NULL,
2726  `end_date` datetime DEFAULT NULL,
2727  `slug` varchar(250) NOT NULL,
2728  `title` varchar(250) NOT NULL,
2729  `context_id` int(11) DEFAULT NULL,
2730  `contact_id` int(11) DEFAULT NULL,
2731  `notes` text,
2732  `status` varchar(250) NOT NULL,
2733  `reference_url` varchar(250) DEFAULT NULL,
2734  `secondary_contact_id` int(11) DEFAULT NULL,
2735  `os_state` varchar(16) NOT NULL,
2736  PRIMARY KEY (`id`),
2737  UNIQUE KEY `uq_vendors_title` (`title`),
2738  UNIQUE KEY `uq_slug_vendors` (`slug`),
2739  KEY `fk_vendors_context` (`context_id`),
2740  KEY `fk_vendors_contact` (`contact_id`),
2741  KEY `fk_vendors_modified_by` (`modified_by_id`),
2742  KEY `fk_vendors_status` (`status`),
2743  KEY `ix_vendors_updated_at` (`updated_at`),
2744  KEY `fk_vendors_secondary_contact` (`secondary_contact_id`)
2745) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2746/*!40101 SET character_set_client = @saved_cs_client */;
2747
2748--
2749-- Dumping data for table `vendors`
2750--
2751
2752LOCK TABLES `vendors` WRITE;
2753/*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
2754/*!40000 ALTER TABLE `vendors` ENABLE KEYS */;
2755UNLOCK TABLES;
2756
2757--
2758-- Table structure for table `workflow_people`
2759--
2760
2761DROP TABLE IF EXISTS `workflow_people`;
2762/*!40101 SET @saved_cs_client     = @@character_set_client */;
2763/*!40101 SET character_set_client = utf8 */;
2764CREATE TABLE `workflow_people` (
2765  `id` int(11) NOT NULL AUTO_INCREMENT,
2766  `workflow_id` int(11) NOT NULL,
2767  `person_id` int(11) NOT NULL,
2768  `status` varchar(250) DEFAULT NULL,
2769  `created_at` datetime DEFAULT NULL,
2770  `modified_by_id` int(11) DEFAULT NULL,
2771  `updated_at` datetime DEFAULT NULL,
2772  `context_id` int(11) DEFAULT NULL,
2773  PRIMARY KEY (`id`),
2774  UNIQUE KEY `workflow_id` (`workflow_id`,`person_id`),
2775  KEY `fk_workflow_people_contexts` (`context_id`),
2776  KEY `ix_person_id` (`person_id`),
2777  KEY `ix_workflow_id` (`workflow_id`),
2778  KEY `ix_workflow_people_updated_at` (`updated_at`),
2779  CONSTRAINT `fk_workflow_people_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
2780  CONSTRAINT `fk_workflow_people_person_id` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`),
2781  CONSTRAINT `fk_workflow_people_workflow_id` FOREIGN KEY (`workflow_id`) REFERENCES `workflows` (`id`)
2782) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2783/*!40101 SET character_set_client = @saved_cs_client */;
2784
2785--
2786-- Dumping data for table `workflow_people`
2787--
2788
2789LOCK TABLES `workflow_people` WRITE;
2790/*!40000 ALTER TABLE `workflow_people` DISABLE KEYS */;
2791/*!40000 ALTER TABLE `workflow_people` ENABLE KEYS */;
2792UNLOCK TABLES;
2793
2794--
2795-- Table structure for table `workflows`
2796--
2797
2798DROP TABLE IF EXISTS `workflows`;
2799/*!40101 SET @saved_cs_client     = @@character_set_client */;
2800/*!40101 SET character_set_client = utf8 */;
2801CREATE TABLE `workflows` (
2802  `id` int(11) NOT NULL AUTO_INCREMENT,
2803  `end_date` date DEFAULT NULL,
2804  `start_date` date DEFAULT NULL,
2805  `description` text,
2806  `title` varchar(250) NOT NULL,
2807  `slug` varchar(250) NOT NULL,
2808  `created_at` datetime DEFAULT NULL,
2809  `modified_by_id` int(11) DEFAULT NULL,
2810  `updated_at` datetime DEFAULT NULL,
2811  `context_id` int(11) DEFAULT NULL,
2812  `frequency` varchar(250) DEFAULT NULL,
2813  `notify_custom_message` text,
2814  `notify_on_change` tinyint(1) NOT NULL,
2815  `object_approval` tinyint(1) NOT NULL,
2816  `next_cycle_start_date` date DEFAULT NULL,
2817  `status` varchar(250) DEFAULT NULL,
2818  `recurrences` tinyint(1) NOT NULL,
2819  `non_adjusted_next_cycle_start_date` date DEFAULT NULL,
2820  `is_old_workflow` tinyint(1) DEFAULT NULL,
2821  PRIMARY KEY (`id`),
2822  UNIQUE KEY `uq_workflows` (`slug`),
2823  KEY `fk_workflows_contexts` (`context_id`),
2824  KEY `ix_workflows_updated_at` (`updated_at`),
2825  CONSTRAINT `fk_workflows_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
2826) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2827/*!40101 SET character_set_client = @saved_cs_client */;
2828
2829--
2830-- Dumping data for table `workflows`
2831--
2832
2833LOCK TABLES `workflows` WRITE;
2834/*!40000 ALTER TABLE `workflows` DISABLE KEYS */;
2835/*!40000 ALTER TABLE `workflows` ENABLE KEYS */;
2836UNLOCK TABLES;
2837/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2838
2839/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2840/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2841/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2842/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2843/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2844/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2845/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2846
2847-- Dump completed on 2016-04-21 14:55:01