-- MySQL dump 10.13  Distrib 5.5.47, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: ggrcdev
-- ------------------------------------------------------
-- Server version	5.5.47-0ubuntu0.14.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `access_groups`
--

DROP TABLE IF EXISTS `access_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `access_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `os_state` varchar(250) NOT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `notes` text,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_access_groups` (`slug`),
  UNIQUE KEY `uq_t_access_groups` (`title`),
  KEY `fk_access_groups_contact` (`contact_id`),
  KEY `fk_access_groups_contexts` (`context_id`),
  KEY `fk_access_groups_secondary_contact` (`secondary_contact_id`),
  KEY `ix_access_groups_updated_at` (`updated_at`),
  CONSTRAINT `access_groups_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `access_groups_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `access_groups_ibfk_3` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `access_groups`
--

LOCK TABLES `access_groups` WRITE;
/*!40000 ALTER TABLE `access_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `access_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `assessment_templates`
--

DROP TABLE IF EXISTS `assessment_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assessment_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `template_object_type` varchar(250) DEFAULT NULL,
  `test_plan_procedure` tinyint(1) NOT NULL,
  `procedure_description` text,
  `default_people` text NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `context_id` (`context_id`),
  CONSTRAINT `assessment_templates_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assessment_templates`
--

LOCK TABLES `assessment_templates` WRITE;
/*!40000 ALTER TABLE `assessment_templates` DISABLE KEYS */;
INSERT 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');
/*!40000 ALTER TABLE `assessment_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `assessments`
--

DROP TABLE IF EXISTS `assessments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `assessments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `design` varchar(250) DEFAULT NULL,
  `operationally` varchar(250) DEFAULT NULL,
  `os_state` varchar(250) NOT NULL,
  `test_plan` text,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `status` enum('Open','In Progress','Finished','Verified','Final') NOT NULL DEFAULT 'Open',
  `notes` text,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `control_id` int(11) DEFAULT NULL,
  `finished_date` datetime DEFAULT NULL,
  `verified_date` datetime DEFAULT NULL,
  `recipients` varchar(250) DEFAULT NULL,
  `send_by_default` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_control_assessments` (`slug`),
  KEY `contact_id` (`contact_id`),
  KEY `context_id` (`context_id`),
  KEY `secondary_contact_id` (`secondary_contact_id`),
  KEY `fk_control_control_assessment` (`control_id`),
  CONSTRAINT `assessments_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `assessments_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `assessments_ibfk_3` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `fk_control_control_assessment` FOREIGN KEY (`control_id`) REFERENCES `controls` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assessments`
--

LOCK TABLES `assessments` WRITE;
/*!40000 ALTER TABLE `assessments` DISABLE KEYS */;
/*!40000 ALTER TABLE `assessments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `audit_objects`
--

DROP TABLE IF EXISTS `audit_objects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audit_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) NOT NULL,
  `audit_id` int(11) NOT NULL,
  `auditable_id` int(11) NOT NULL,
  `auditable_type` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `audit_id` (`audit_id`,`auditable_id`,`auditable_type`),
  KEY `context_id` (`context_id`),
  CONSTRAINT `audit_objects_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `audit_objects_ibfk_2` FOREIGN KEY (`audit_id`) REFERENCES `audits` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `audit_objects`
--

LOCK TABLES `audit_objects` WRITE;
/*!40000 ALTER TABLE `audit_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `audit_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `audits`
--

DROP TABLE IF EXISTS `audits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `audits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `report_start_date` date DEFAULT NULL,
  `report_end_date` date DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `status` enum('Planned','In Progress','Manager Review','Ready for External Review','Completed') NOT NULL,
  `gdrive_evidence_folder` varchar(250) DEFAULT NULL,
  `program_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `notes` text,
  `audit_firm_id` int(11) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `object_type` varchar(250) NOT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_t_audits` (`title`),
  KEY `program_id` (`program_id`),
  KEY `fk_audits_contact` (`contact_id`),
  KEY `fk_audits_contexts` (`context_id`),
  KEY `ix_audits_updated_at` (`updated_at`),
  KEY `fk_audits_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `audits_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `audits_ibfk_3` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `audits`
--

LOCK TABLES `audits` WRITE;
/*!40000 ALTER TABLE `audits` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `audits` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `background_tasks`
--

DROP TABLE IF EXISTS `background_tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `background_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `parameters` mediumblob,
  `result` mediumblob,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_background_tasks_contexts` (`context_id`),
  KEY `ix_background_tasks_updated_at` (`updated_at`),
  CONSTRAINT `background_tasks_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `background_tasks`
--

LOCK TABLES `background_tasks` WRITE;
/*!40000 ALTER TABLE `background_tasks` DISABLE KEYS */;
/*!40000 ALTER TABLE `background_tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `name` varchar(250) DEFAULT NULL,
  `lft` int(11) DEFAULT NULL,
  `rgt` int(11) DEFAULT NULL,
  `scope_id` int(11) DEFAULT NULL,
  `depth` int(11) DEFAULT NULL,
  `required` tinyint(1) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `type` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `fk_categories_contexts` (`context_id`),
  KEY `ix_categories_updated_at` (`updated_at`),
  CONSTRAINT `fk_categories_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT 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');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categorizations`
--

DROP TABLE IF EXISTS `categorizations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categorizations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `categorizable_id` int(11) DEFAULT NULL,
  `categorizable_type` varchar(250) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `category_type` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_id` (`category_id`),
  KEY `fk_categorizations_contexts` (`context_id`),
  KEY `ix_categorizations_updated_at` (`updated_at`),
  CONSTRAINT `categorizations_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `fk_categorizations_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categorizations`
--

LOCK TABLES `categorizations` WRITE;
/*!40000 ALTER TABLE `categorizations` DISABLE KEYS */;
/*!40000 ALTER TABLE `categorizations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clauses`
--

DROP TABLE IF EXISTS `clauses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clauses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `na` tinyint(1) NOT NULL,
  `notes` text,
  `os_state` varchar(250) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_clauses` (`slug`),
  UNIQUE KEY `uq_t_clauses` (`title`),
  KEY `contact_id` (`contact_id`),
  KEY `context_id` (`context_id`),
  KEY `parent_id` (`parent_id`),
  KEY `secondary_contact_id` (`secondary_contact_id`),
  CONSTRAINT `clauses_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `clauses_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `clauses_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `clauses` (`id`),
  CONSTRAINT `clauses_ibfk_4` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clauses`
--

LOCK TABLES `clauses` WRITE;
/*!40000 ALTER TABLE `clauses` DISABLE KEYS */;
/*!40000 ALTER TABLE `clauses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comments`
--

DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `assignee_type` text,
  PRIMARY KEY (`id`),
  KEY `context_id` (`context_id`),
  CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comments`
--

LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `context_implications`
--

DROP TABLE IF EXISTS `context_implications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `context_implications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `context_id` int(11) DEFAULT NULL,
  `source_context_id` int(11) DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_scope` varchar(128) DEFAULT NULL,
  `source_context_scope` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_context_implications_contexts` (`context_id`),
  KEY `ix_context_implications_updated_at` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `context_implications`
--

LOCK TABLES `context_implications` WRITE;
/*!40000 ALTER TABLE `context_implications` DISABLE KEYS */;
INSERT 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');
/*!40000 ALTER TABLE `context_implications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contexts`
--

DROP TABLE IF EXISTS `contexts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contexts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `description` text,
  `related_object_id` int(11) DEFAULT NULL,
  `related_object_type` varchar(128) DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_contexts_contexts` (`context_id`),
  KEY `ix_context_related_object` (`related_object_type`,`related_object_id`),
  KEY `ix_contexts_updated_at` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contexts`
--

LOCK TABLES `contexts` WRITE;
/*!40000 ALTER TABLE `contexts` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `contexts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `controls`
--

DROP TABLE IF EXISTS `controls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `controls` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `directive_id` int(11) DEFAULT NULL,
  `kind_id` int(11) DEFAULT NULL,
  `means_id` int(11) DEFAULT NULL,
  `version` varchar(250) DEFAULT NULL,
  `documentation_description` text,
  `verify_frequency_id` int(11) DEFAULT NULL,
  `fraud_related` tinyint(1) DEFAULT NULL,
  `key_control` tinyint(1) DEFAULT NULL,
  `active` tinyint(1) DEFAULT NULL,
  `notes` text,
  `parent_id` int(11) DEFAULT NULL,
  `company_control` tinyint(1) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `principal_assessor_id` int(11) DEFAULT NULL,
  `secondary_assessor_id` int(11) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  `test_plan` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_controls` (`slug`),
  UNIQUE KEY `uq_t_controls` (`title`),
  KEY `directive_id` (`directive_id`),
  KEY `parent_id` (`parent_id`),
  KEY `fk_controls_contexts` (`context_id`),
  KEY `fk_controls_contact` (`contact_id`),
  KEY `ix_controls_principal_assessor` (`principal_assessor_id`),
  KEY `ix_controls_secondary_assessor` (`secondary_assessor_id`),
  KEY `ix_controls_updated_at` (`updated_at`),
  KEY `fk_controls_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `controls_ibfk_1` FOREIGN KEY (`directive_id`) REFERENCES `directives` (`id`),
  CONSTRAINT `controls_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `controls` (`id`),
  CONSTRAINT `fk_controls_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `controls`
--

LOCK TABLES `controls` WRITE;
/*!40000 ALTER TABLE `controls` DISABLE KEYS */;
INSERT 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');
/*!40000 ALTER TABLE `controls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custom_attribute_definitions`
--

DROP TABLE IF EXISTS `custom_attribute_definitions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_attribute_definitions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `helptext` varchar(250) DEFAULT NULL,
  `placeholder` varchar(250) DEFAULT NULL,
  `definition_type` varchar(250) NOT NULL,
  `attribute_type` varchar(250) NOT NULL,
  `multi_choice_options` text,
  `mandatory` tinyint(1) DEFAULT NULL,
  `definition_id` int(11) DEFAULT NULL,
  `multi_choice_mandatory` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_custom_attribute` (`definition_type`,`definition_id`,`title`),
  KEY `ix_custom_attributes_title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_attribute_definitions`
--

LOCK TABLES `custom_attribute_definitions` WRITE;
/*!40000 ALTER TABLE `custom_attribute_definitions` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `custom_attribute_definitions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custom_attribute_values`
--

DROP TABLE IF EXISTS `custom_attribute_values`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `custom_attribute_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `custom_attribute_id` int(11) NOT NULL,
  `attributable_id` int(11) DEFAULT NULL,
  `attributable_type` varchar(250) DEFAULT NULL,
  `attribute_value` text,
  `attribute_object_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_custom_attributes_attributable` (`attributable_id`,`attributable_type`),
  KEY `custom_attribute_values_ibfk_1` (`custom_attribute_id`),
  CONSTRAINT `custom_attribute_values_ibfk_1` FOREIGN KEY (`custom_attribute_id`) REFERENCES `custom_attribute_definitions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_attribute_values`
--

LOCK TABLES `custom_attribute_values` WRITE;
/*!40000 ALTER TABLE `custom_attribute_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `custom_attribute_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cycle_task_entries`
--

DROP TABLE IF EXISTS `cycle_task_entries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cycle_task_entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cycle_task_group_object_task_id` int(11) NOT NULL,
  `description` text,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `cycle_id` int(11) NOT NULL,
  `_is_declining_review` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cycle_task_group_object_task_id` (`cycle_task_group_object_task_id`),
  KEY `fk_cycle_task_entries_contexts` (`context_id`),
  KEY `cycle_task_entries_cycle` (`cycle_id`),
  KEY `ix_cycle_task_entries_updated_at` (`updated_at`),
  CONSTRAINT `cycle_task_entries_cycle` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`),
  CONSTRAINT `cycle_task_entries_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `cycle_task_entries_ibfk_2` FOREIGN KEY (`cycle_task_group_object_task_id`) REFERENCES `cycle_task_group_object_tasks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cycle_task_entries`
--

LOCK TABLES `cycle_task_entries` WRITE;
/*!40000 ALTER TABLE `cycle_task_entries` DISABLE KEYS */;
/*!40000 ALTER TABLE `cycle_task_entries` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cycle_task_group_object_tasks`
--

DROP TABLE IF EXISTS `cycle_task_group_object_tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cycle_task_group_object_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cycle_task_group_object_id` int(11) DEFAULT NULL,
  `task_group_task_id` int(11) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `description` text,
  `title` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `sort_index` varchar(250) NOT NULL,
  `cycle_id` int(11) NOT NULL,
  `response_options` text NOT NULL,
  `selected_response_options` text NOT NULL,
  `task_type` varchar(250) NOT NULL,
  `cycle_task_group_id` int(11) NOT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `finished_date` datetime DEFAULT NULL,
  `verified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_slug` (`slug`),
  KEY `cycle_task_group_object_id` (`cycle_task_group_object_id`),
  KEY `task_group_task_id` (`task_group_task_id`),
  KEY `fk_cycle_task_group_object_tasks_contact` (`contact_id`),
  KEY `fk_cycle_task_group_object_tasks_contexts` (`context_id`),
  KEY `cycle_task_group_object_tasks_cycle` (`cycle_id`),
  KEY `ix_cycle_task_group_object_tasks_updated_at` (`updated_at`),
  KEY `cycle_task_group_id` (`cycle_task_group_id`),
  KEY `fk_cycle_task_group_object_tasks_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `cycle_task_group_id` FOREIGN KEY (`cycle_task_group_id`) REFERENCES `cycle_task_groups` (`id`),
  CONSTRAINT `cycle_task_group_object_tasks_cycle` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`),
  CONSTRAINT `cycle_task_group_object_tasks_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `cycle_task_group_object_tasks_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `cycle_task_group_object_tasks_ibfk_3` FOREIGN KEY (`cycle_task_group_object_id`) REFERENCES `cycle_task_group_objects` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cycle_task_group_object_tasks`
--

LOCK TABLES `cycle_task_group_object_tasks` WRITE;
/*!40000 ALTER TABLE `cycle_task_group_object_tasks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cycle_task_group_object_tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cycle_task_group_objects`
--

DROP TABLE IF EXISTS `cycle_task_group_objects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cycle_task_group_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cycle_task_group_id` int(11) NOT NULL,
  `task_group_object_id` int(11) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `description` text,
  `title` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `cycle_id` int(11) NOT NULL,
  `object_id` int(11) NOT NULL,
  `object_type` varchar(250) NOT NULL,
  `next_due_date` date DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cycle_task_group_id` (`cycle_task_group_id`),
  KEY `task_group_object_id` (`task_group_object_id`),
  KEY `fk_cycle_task_group_objects_contact` (`contact_id`),
  KEY `fk_cycle_task_group_objects_contexts` (`context_id`),
  KEY `cycle_task_group_objects_cycle` (`cycle_id`),
  KEY `ix_cycle_task_group_objects_updated_at` (`updated_at`),
  KEY `fk_cycle_task_group_objects_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `cycle_task_group_objects_cycle` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`),
  CONSTRAINT `cycle_task_group_objects_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `cycle_task_group_objects_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `cycle_task_group_objects_ibfk_3` FOREIGN KEY (`cycle_task_group_id`) REFERENCES `cycle_task_groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cycle_task_group_objects`
--

LOCK TABLES `cycle_task_group_objects` WRITE;
/*!40000 ALTER TABLE `cycle_task_group_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `cycle_task_group_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cycle_task_groups`
--

DROP TABLE IF EXISTS `cycle_task_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cycle_task_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cycle_id` int(11) NOT NULL,
  `task_group_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `description` text,
  `title` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `sort_index` varchar(250) NOT NULL,
  `next_due_date` date DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_slug` (`slug`),
  KEY `cycle_id` (`cycle_id`),
  KEY `task_group_id` (`task_group_id`),
  KEY `fk_cycle_task_groups_contact` (`contact_id`),
  KEY `fk_cycle_task_groups_contexts` (`context_id`),
  KEY `ix_cycle_task_groups_updated_at` (`updated_at`),
  KEY `fk_cycle_task_groups_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `cycle_task_groups_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `cycle_task_groups_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `cycle_task_groups_ibfk_3` FOREIGN KEY (`cycle_id`) REFERENCES `cycles` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cycle_task_groups`
--

LOCK TABLES `cycle_task_groups` WRITE;
/*!40000 ALTER TABLE `cycle_task_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `cycle_task_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cycles`
--

DROP TABLE IF EXISTS `cycles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cycles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `description` text,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `is_current` tinyint(1) NOT NULL,
  `next_due_date` date DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_cycles` (`slug`),
  KEY `workflow_id` (`workflow_id`),
  KEY `fk_cycles_contact` (`contact_id`),
  KEY `fk_cycles_contexts` (`context_id`),
  KEY `ix_cycles_updated_at` (`updated_at`),
  KEY `fk_cycles_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `cycles_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `cycles_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `cycles_ibfk_3` FOREIGN KEY (`workflow_id`) REFERENCES `workflows` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cycles`
--

LOCK TABLES `cycles` WRITE;
/*!40000 ALTER TABLE `cycles` DISABLE KEYS */;
/*!40000 ALTER TABLE `cycles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `data_assets`
--

DROP TABLE IF EXISTS `data_assets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_assets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_data_assets` (`slug`),
  UNIQUE KEY `uq_t_data_assets` (`title`),
  KEY `fk_data_assets_contexts` (`context_id`),
  KEY `fk_data_assets_contact` (`contact_id`),
  KEY `ix_data_assets_updated_at` (`updated_at`),
  KEY `fk_data_assets_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_data_assets_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `data_assets`
--

LOCK TABLES `data_assets` WRITE;
/*!40000 ALTER TABLE `data_assets` DISABLE KEYS */;
/*!40000 ALTER TABLE `data_assets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `directives`
--

DROP TABLE IF EXISTS `directives`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `directives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `version` varchar(250) DEFAULT NULL,
  `organization` varchar(250) DEFAULT NULL,
  `scope` text,
  `kind_id` int(11) DEFAULT NULL,
  `audit_start_date` datetime DEFAULT NULL,
  `audit_frequency_id` int(11) DEFAULT NULL,
  `audit_duration_id` int(11) DEFAULT NULL,
  `kind` varchar(250) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `meta_kind` varchar(250) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_directives` (`slug`),
  UNIQUE KEY `uq_t_directives` (`title`),
  KEY `fk_directives_contexts` (`context_id`),
  KEY `fk_directives_contact` (`contact_id`),
  KEY `ix_directives_meta_kind` (`meta_kind`),
  KEY `ix_directives_updated_at` (`updated_at`),
  KEY `fk_directives_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_directives_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `directives`
--

LOCK TABLES `directives` WRITE;
/*!40000 ALTER TABLE `directives` DISABLE KEYS */;
/*!40000 ALTER TABLE `directives` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `documents`
--

DROP TABLE IF EXISTS `documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `link` varchar(250) DEFAULT NULL,
  `description` text,
  `kind_id` int(11) DEFAULT NULL,
  `year_id` int(11) DEFAULT NULL,
  `language_id` int(11) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_documents_contexts` (`context_id`),
  KEY `ix_documents_updated_at` (`updated_at`),
  CONSTRAINT `fk_documents_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `documents`
--

LOCK TABLES `documents` WRITE;
/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
/*!40000 ALTER TABLE `documents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `action` enum('POST','PUT','DELETE','IMPORT','GET') NOT NULL,
  `resource_id` int(11) DEFAULT NULL,
  `resource_type` varchar(250) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `events_modified_by` (`modified_by_id`),
  KEY `fk_events_contexts` (`context_id`),
  KEY `ix_events_updated_at` (`updated_at`),
  CONSTRAINT `events_modified_by` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`),
  CONSTRAINT `fk_events_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
INSERT 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');
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facilities`
--

DROP TABLE IF EXISTS `facilities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facilities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_facilities` (`slug`),
  UNIQUE KEY `uq_t_facilities` (`title`),
  KEY `fk_facilities_contexts` (`context_id`),
  KEY `fk_facilities_contact` (`contact_id`),
  KEY `ix_facilities_updated_at` (`updated_at`),
  KEY `fk_facilities_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_facilities_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facilities`
--

LOCK TABLES `facilities` WRITE;
/*!40000 ALTER TABLE `facilities` DISABLE KEYS */;
/*!40000 ALTER TABLE `facilities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fulltext_record_properties`
--

DROP TABLE IF EXISTS `fulltext_record_properties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fulltext_record_properties` (
  `key` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(64) NOT NULL,
  `tags` varchar(250) DEFAULT NULL,
  `property` varchar(64) NOT NULL,
  `content` text,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`key`,`type`,`property`),
  KEY `ix_fulltext_record_properties_context_id` (`context_id`),
  KEY `ix_fulltext_record_properties_key` (`key`),
  KEY `ix_fulltext_record_properties_tags` (`tags`),
  KEY `ix_fulltext_record_properties_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fulltext_record_properties`
--

LOCK TABLES `fulltext_record_properties` WRITE;
/*!40000 ALTER TABLE `fulltext_record_properties` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `fulltext_record_properties` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ggrc_alembic_version`
--

DROP TABLE IF EXISTS `ggrc_alembic_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ggrc_alembic_version` (
  `version_num` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ggrc_alembic_version`
--

LOCK TABLES `ggrc_alembic_version` WRITE;
/*!40000 ALTER TABLE `ggrc_alembic_version` DISABLE KEYS */;
INSERT INTO `ggrc_alembic_version` VALUES ('b96b24667e0');
/*!40000 ALTER TABLE `ggrc_alembic_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ggrc_basic_permissions_alembic_version`
--

DROP TABLE IF EXISTS `ggrc_basic_permissions_alembic_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ggrc_basic_permissions_alembic_version` (
  `version_num` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ggrc_basic_permissions_alembic_version`
--

LOCK TABLES `ggrc_basic_permissions_alembic_version` WRITE;
/*!40000 ALTER TABLE `ggrc_basic_permissions_alembic_version` DISABLE KEYS */;
INSERT INTO `ggrc_basic_permissions_alembic_version` VALUES ('3bf028a83e79');
/*!40000 ALTER TABLE `ggrc_basic_permissions_alembic_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ggrc_gdrive_integration_alembic_version`
--

DROP TABLE IF EXISTS `ggrc_gdrive_integration_alembic_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ggrc_gdrive_integration_alembic_version` (
  `version_num` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ggrc_gdrive_integration_alembic_version`
--

LOCK TABLES `ggrc_gdrive_integration_alembic_version` WRITE;
/*!40000 ALTER TABLE `ggrc_gdrive_integration_alembic_version` DISABLE KEYS */;
INSERT INTO `ggrc_gdrive_integration_alembic_version` VALUES ('50b3f0b2a002');
/*!40000 ALTER TABLE `ggrc_gdrive_integration_alembic_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ggrc_risk_assessments_alembic_version`
--

DROP TABLE IF EXISTS `ggrc_risk_assessments_alembic_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ggrc_risk_assessments_alembic_version` (
  `version_num` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ggrc_risk_assessments_alembic_version`
--

LOCK TABLES `ggrc_risk_assessments_alembic_version` WRITE;
/*!40000 ALTER TABLE `ggrc_risk_assessments_alembic_version` DISABLE KEYS */;
INSERT INTO `ggrc_risk_assessments_alembic_version` VALUES ('5b29b4becf8');
/*!40000 ALTER TABLE `ggrc_risk_assessments_alembic_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ggrc_risks_alembic_version`
--

DROP TABLE IF EXISTS `ggrc_risks_alembic_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ggrc_risks_alembic_version` (
  `version_num` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ggrc_risks_alembic_version`
--

LOCK TABLES `ggrc_risks_alembic_version` WRITE;
/*!40000 ALTER TABLE `ggrc_risks_alembic_version` DISABLE KEYS */;
INSERT INTO `ggrc_risks_alembic_version` VALUES ('17ae137bda7a');
/*!40000 ALTER TABLE `ggrc_risks_alembic_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ggrc_workflows_alembic_version`
--

DROP TABLE IF EXISTS `ggrc_workflows_alembic_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ggrc_workflows_alembic_version` (
  `version_num` varchar(32) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ggrc_workflows_alembic_version`
--

LOCK TABLES `ggrc_workflows_alembic_version` WRITE;
/*!40000 ALTER TABLE `ggrc_workflows_alembic_version` DISABLE KEYS */;
INSERT INTO `ggrc_workflows_alembic_version` VALUES ('1263c1ab4642');
/*!40000 ALTER TABLE `ggrc_workflows_alembic_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `helps`
--

DROP TABLE IF EXISTS `helps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `helps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `content` text,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_helps` (`slug`),
  KEY `fk_helps_contexts` (`context_id`),
  KEY `ix_helps_updated_at` (`updated_at`),
  CONSTRAINT `fk_helps_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `helps`
--

LOCK TABLES `helps` WRITE;
/*!40000 ALTER TABLE `helps` DISABLE KEYS */;
/*!40000 ALTER TABLE `helps` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `issues`
--

DROP TABLE IF EXISTS `issues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `issues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `os_state` varchar(250) NOT NULL,
  `test_plan` text,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `notes` text,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_issues` (`slug`),
  UNIQUE KEY `uq_t_issues` (`title`),
  KEY `contact_id` (`contact_id`),
  KEY `context_id` (`context_id`),
  KEY `secondary_contact_id` (`secondary_contact_id`),
  CONSTRAINT `issues_ibfk_1` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `issues_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `issues_ibfk_3` FOREIGN KEY (`secondary_contact_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `issues`
--

LOCK TABLES `issues` WRITE;
/*!40000 ALTER TABLE `issues` DISABLE KEYS */;
/*!40000 ALTER TABLE `issues` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `markets`
--

DROP TABLE IF EXISTS `markets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `markets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_markets` (`slug`),
  UNIQUE KEY `uq_t_markets` (`title`),
  KEY `fk_markets_contexts` (`context_id`),
  KEY `fk_markets_contact` (`contact_id`),
  KEY `ix_markets_updated_at` (`updated_at`),
  KEY `fk_markets_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_markets_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `markets`
--

LOCK TABLES `markets` WRITE;
/*!40000 ALTER TABLE `markets` DISABLE KEYS */;
/*!40000 ALTER TABLE `markets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meetings`
--

DROP TABLE IF EXISTS `meetings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meetings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `response_id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `description` text,
  `start_at` datetime NOT NULL,
  `end_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `response_id` (`response_id`),
  KEY `fk_meetings_contexts` (`context_id`),
  KEY `ix_meetings_updated_at` (`updated_at`),
  CONSTRAINT `meetings_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `meetings_ibfk_3` FOREIGN KEY (`response_id`) REFERENCES `responses` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `meetings`
--

LOCK TABLES `meetings` WRITE;
/*!40000 ALTER TABLE `meetings` DISABLE KEYS */;
/*!40000 ALTER TABLE `meetings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_configs`
--

DROP TABLE IF EXISTS `notification_configs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_configs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `enable_flag` tinyint(1) DEFAULT NULL,
  `notif_type` varchar(250) DEFAULT NULL,
  `person_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_notif_configs_person_id_notif_type` (`person_id`,`notif_type`),
  KEY `fk_notification_configs_contexts` (`context_id`),
  KEY `ix_notification_configs_updated_at` (`updated_at`),
  CONSTRAINT `notification_configs_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `notification_configs_ibfk_2` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_configs`
--

LOCK TABLES `notification_configs` WRITE;
/*!40000 ALTER TABLE `notification_configs` DISABLE KEYS */;
/*!40000 ALTER TABLE `notification_configs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_types`
--

DROP TABLE IF EXISTS `notification_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `description` varchar(250) DEFAULT NULL,
  `advance_notice` int(11) DEFAULT NULL,
  `template` varchar(250) NOT NULL,
  `instant` tinyint(1) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `modified_by_id` (`modified_by_id`),
  CONSTRAINT `notification_types_ibfk_1` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_types`
--

LOCK TABLES `notification_types` WRITE;
/*!40000 ALTER TABLE `notification_types` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `notification_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `object_id` int(11) NOT NULL,
  `object_type` varchar(250) NOT NULL,
  `notification_type_id` int(11) NOT NULL,
  `send_on` datetime NOT NULL,
  `sent_at` datetime DEFAULT NULL,
  `custom_message` text,
  `force_notifications` tinyint(1) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `modified_by_id` (`modified_by_id`),
  KEY `fk_notification_type_id` (`notification_type_id`),
  CONSTRAINT `notifications_ibfk_2` FOREIGN KEY (`notification_type_id`) REFERENCES `notification_types` (`id`),
  CONSTRAINT `notifications_ibfk_3` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notifications`
--

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `object_documents`
--

DROP TABLE IF EXISTS `object_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `object_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `role` varchar(250) DEFAULT NULL,
  `notes` text,
  `document_id` int(11) NOT NULL,
  `documentable_id` int(11) NOT NULL,
  `documentable_type` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_object_documents` (`document_id`,`documentable_id`,`documentable_type`),
  KEY `fk_object_documents_contexts` (`context_id`),
  KEY `ix_document_id` (`document_id`),
  KEY `ix_object_documents_updated_at` (`updated_at`),
  CONSTRAINT `fk_object_documents_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `object_documents_ibfk_1` FOREIGN KEY (`document_id`) REFERENCES `documents` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `object_documents`
--

LOCK TABLES `object_documents` WRITE;
/*!40000 ALTER TABLE `object_documents` DISABLE KEYS */;
/*!40000 ALTER TABLE `object_documents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `object_events`
--

DROP TABLE IF EXISTS `object_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `object_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `calendar_id` varchar(250) DEFAULT NULL,
  `event_id` varchar(250) NOT NULL,
  `eventable_id` int(11) NOT NULL,
  `eventable_type` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_object_events_contexts` (`context_id`),
  KEY `ix_object_events_updated_at` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `object_events`
--

LOCK TABLES `object_events` WRITE;
/*!40000 ALTER TABLE `object_events` DISABLE KEYS */;
/*!40000 ALTER TABLE `object_events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `object_files`
--

DROP TABLE IF EXISTS `object_files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `object_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `parent_folder_id` varchar(250) DEFAULT NULL,
  `file_id` varchar(250) NOT NULL,
  `fileable_id` int(11) NOT NULL,
  `fileable_type` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_object_files_contexts` (`context_id`),
  KEY `ix_object_files_updated_at` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `object_files`
--

LOCK TABLES `object_files` WRITE;
/*!40000 ALTER TABLE `object_files` DISABLE KEYS */;
/*!40000 ALTER TABLE `object_files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `object_folders`
--

DROP TABLE IF EXISTS `object_folders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `object_folders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `parent_folder_id` varchar(250) DEFAULT NULL,
  `folder_id` varchar(250) NOT NULL,
  `folderable_id` int(11) NOT NULL,
  `folderable_type` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_object_folders_contexts` (`context_id`),
  KEY `ix_folderable_id_type` (`folderable_type`,`folderable_id`),
  KEY `ix_object_folders_updated_at` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `object_folders`
--

LOCK TABLES `object_folders` WRITE;
/*!40000 ALTER TABLE `object_folders` DISABLE KEYS */;
/*!40000 ALTER TABLE `object_folders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `object_owners`
--

DROP TABLE IF EXISTS `object_owners`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `object_owners` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` int(11) NOT NULL,
  `ownable_id` int(11) NOT NULL,
  `ownable_type` varchar(250) NOT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_id_owners` (`person_id`,`ownable_id`,`ownable_type`),
  KEY `fk_object_owners_contexts` (`context_id`),
  KEY `ix_object_owners_ownable` (`ownable_type`,`ownable_id`),
  KEY `ix_object_owners_updated_at` (`updated_at`),
  CONSTRAINT `object_owners_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`),
  CONSTRAINT `object_owners_ibfk_2` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `object_owners`
--

LOCK TABLES `object_owners` WRITE;
/*!40000 ALTER TABLE `object_owners` DISABLE KEYS */;
INSERT 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');
/*!40000 ALTER TABLE `object_owners` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `object_people`
--

DROP TABLE IF EXISTS `object_people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `object_people` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `role` varchar(250) DEFAULT NULL,
  `notes` text,
  `person_id` int(11) NOT NULL,
  `personable_id` int(11) NOT NULL,
  `personable_type` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_object_people` (`person_id`,`personable_id`,`personable_type`),
  KEY `fk_object_people_contexts` (`context_id`),
  KEY `ix_person_id` (`person_id`),
  KEY `ix_object_people_updated_at` (`updated_at`),
  CONSTRAINT `fk_object_people_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `object_people_ibfk_1` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `object_people`
--

LOCK TABLES `object_people` WRITE;
/*!40000 ALTER TABLE `object_people` DISABLE KEYS */;
/*!40000 ALTER TABLE `object_people` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `objectives`
--

DROP TABLE IF EXISTS `objectives`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `objectives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `notes` text,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_objectives` (`slug`),
  UNIQUE KEY `uq_t_objectives` (`title`),
  KEY `fk_objectives_contact` (`contact_id`),
  KEY `fk_objectives_contexts` (`context_id`),
  KEY `ix_objectives_updated_at` (`updated_at`),
  KEY `fk_objectives_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `objectives_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `objectives`
--

LOCK TABLES `objectives` WRITE;
/*!40000 ALTER TABLE `objectives` DISABLE KEYS */;
/*!40000 ALTER TABLE `objectives` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `options`
--

DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `role` varchar(250) DEFAULT NULL,
  `title` varchar(250) DEFAULT NULL,
  `required` tinyint(1) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_options_contexts` (`context_id`),
  KEY `ix_options_role` (`role`),
  KEY `ix_options_updated_at` (`updated_at`),
  CONSTRAINT `fk_options_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `options`
--

LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `org_groups`
--

DROP TABLE IF EXISTS `org_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `org_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_org_groups` (`slug`),
  UNIQUE KEY `uq_t_org_groups` (`title`),
  KEY `fk_org_groups_contexts` (`context_id`),
  KEY `fk_org_groups_contact` (`contact_id`),
  KEY `ix_org_groups_updated_at` (`updated_at`),
  KEY `fk_org_groups_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_org_groups_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `org_groups`
--

LOCK TABLES `org_groups` WRITE;
/*!40000 ALTER TABLE `org_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `org_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `people`
--

DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `people` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `email` varchar(250) NOT NULL,
  `name` varchar(250) DEFAULT NULL,
  `language_id` int(11) DEFAULT NULL,
  `company` varchar(250) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_people_email` (`email`),
  KEY `fk_people_contexts` (`context_id`),
  KEY `ix_people_name_email` (`name`,`email`),
  KEY `ix_people_updated_at` (`updated_at`),
  CONSTRAINT `fk_people_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `people`
--

LOCK TABLES `people` WRITE;
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `kind_id` int(11) DEFAULT NULL,
  `version` varchar(250) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_products` (`slug`),
  UNIQUE KEY `uq_t_products` (`title`),
  KEY `fk_products_contexts` (`context_id`),
  KEY `fk_products_contact` (`contact_id`),
  KEY `ix_products_updated_at` (`updated_at`),
  KEY `fk_products_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_products_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `programs`
--

DROP TABLE IF EXISTS `programs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `programs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `kind` varchar(250) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `private` tinyint(1) NOT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_programs` (`slug`),
  UNIQUE KEY `uq_t_programs` (`title`),
  KEY `fk_programs_contexts` (`context_id`),
  KEY `fk_programs_contact` (`contact_id`),
  KEY `ix_programs_updated_at` (`updated_at`),
  KEY `fk_programs_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_programs_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `programs`
--

LOCK TABLES `programs` WRITE;
/*!40000 ALTER TABLE `programs` DISABLE KEYS */;
INSERT 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');
/*!40000 ALTER TABLE `programs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projects`
--

DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_projects` (`slug`),
  UNIQUE KEY `uq_t_projects` (`title`),
  KEY `fk_projects_contexts` (`context_id`),
  KEY `fk_projects_contact` (`contact_id`),
  KEY `ix_projects_updated_at` (`updated_at`),
  KEY `fk_projects_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_projects_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projects`
--

LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `relationship_attrs`
--

DROP TABLE IF EXISTS `relationship_attrs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `relationship_attrs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `relationship_id` int(11) NOT NULL,
  `attr_name` varchar(250) NOT NULL,
  `attr_value` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `relationship_id` (`relationship_id`),
  CONSTRAINT `relationship_attrs_ibfk_1` FOREIGN KEY (`relationship_id`) REFERENCES `relationships` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `relationship_attrs`
--

LOCK TABLES `relationship_attrs` WRITE;
/*!40000 ALTER TABLE `relationship_attrs` DISABLE KEYS */;
/*!40000 ALTER TABLE `relationship_attrs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `relationships`
--

DROP TABLE IF EXISTS `relationships`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `relationships` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `source_id` int(11) NOT NULL,
  `source_type` varchar(250) NOT NULL,
  `destination_id` int(11) NOT NULL,
  `destination_type` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `automapping_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_relationships` (`source_id`,`source_type`,`destination_id`,`destination_type`),
  KEY `fk_relationships_contexts` (`context_id`),
  KEY `ix_relationships_destination` (`destination_type`,`destination_id`),
  KEY `ix_relationships_source` (`source_type`,`source_id`),
  KEY `ix_relationships_updated_at` (`updated_at`),
  KEY `relationships_automapping_parent` (`automapping_id`),
  CONSTRAINT `fk_relationships_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `relationships_automapping_parent` FOREIGN KEY (`automapping_id`) REFERENCES `relationships` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `relationships`
--

LOCK TABLES `relationships` WRITE;
/*!40000 ALTER TABLE `relationships` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `relationships` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `requests`
--

DROP TABLE IF EXISTS `requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `requests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `request_type` enum('documentation','interview','population sample') NOT NULL,
  `status` enum('Open','In Progress','Finished','Verified','Final') NOT NULL,
  `requested_on` date NOT NULL,
  `due_on` date NOT NULL,
  `audit_id` int(11) DEFAULT NULL,
  `gdrive_upload_path` varchar(250) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `test` text,
  `notes` text,
  `description` text,
  `requestor_id` int(11) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `audit_object_id` int(11) DEFAULT NULL,
  `finished_date` datetime DEFAULT NULL,
  `verified_date` datetime DEFAULT NULL,
  `recipients` varchar(250) DEFAULT NULL,
  `send_by_default` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_requests` (`slug`),
  KEY `audit_id` (`audit_id`),
  KEY `fk_requests_contexts` (`context_id`),
  KEY `ix_requests_updated_at` (`updated_at`),
  KEY `requests_audit_objects_ibfk` (`audit_object_id`),
  CONSTRAINT `requests_audit_objects_ibfk` FOREIGN KEY (`audit_object_id`) REFERENCES `audit_objects` (`id`),
  CONSTRAINT `requests_ibfk_2` FOREIGN KEY (`audit_id`) REFERENCES `audits` (`id`),
  CONSTRAINT `requests_ibfk_3` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `requests`
--

LOCK TABLES `requests` WRITE;
/*!40000 ALTER TABLE `requests` DISABLE KEYS */;
/*!40000 ALTER TABLE `requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `responses`
--

DROP TABLE IF EXISTS `responses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `responses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `request_id` int(11) NOT NULL,
  `response_type` enum('documentation','interview','population sample') NOT NULL,
  `status` varchar(250) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `population_count` int(11) DEFAULT NULL,
  `sample_count` int(11) DEFAULT NULL,
  `population_worksheet_id` int(11) DEFAULT NULL,
  `sample_worksheet_id` int(11) DEFAULT NULL,
  `sample_evidence_id` int(11) DEFAULT NULL,
  `notes` text,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `request_id` (`request_id`),
  KEY `population_worksheet_document` (`population_worksheet_id`),
  KEY `sample_worksheet_document` (`sample_worksheet_id`),
  KEY `sample_evidence_document` (`sample_evidence_id`),
  KEY `fk_responses_contact` (`contact_id`),
  KEY `fk_responses_contexts` (`context_id`),
  KEY `ix_responses_updated_at` (`updated_at`),
  KEY `fk_responses_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `population_worksheet_document` FOREIGN KEY (`population_worksheet_id`) REFERENCES `documents` (`id`),
  CONSTRAINT `responses_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `responses_ibfk_3` FOREIGN KEY (`request_id`) REFERENCES `requests` (`id`),
  CONSTRAINT `sample_evidence_document` FOREIGN KEY (`sample_evidence_id`) REFERENCES `documents` (`id`),
  CONSTRAINT `sample_worksheet_document` FOREIGN KEY (`sample_worksheet_id`) REFERENCES `documents` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `responses`
--

LOCK TABLES `responses` WRITE;
/*!40000 ALTER TABLE `responses` DISABLE KEYS */;
/*!40000 ALTER TABLE `responses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `revisions`
--

DROP TABLE IF EXISTS `revisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `revisions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resource_id` int(11) NOT NULL,
  `resource_type` varchar(250) NOT NULL,
  `event_id` int(11) NOT NULL,
  `action` enum('created','modified','deleted') NOT NULL,
  `content` text NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `source_type` varchar(250) DEFAULT NULL,
  `source_id` int(11) DEFAULT NULL,
  `destination_type` varchar(250) DEFAULT NULL,
  `destination_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `event_id` (`event_id`),
  KEY `revisions_modified_by` (`modified_by_id`),
  KEY `fk_revisions_contexts` (`context_id`),
  KEY `ix_revisions_updated_at` (`updated_at`),
  KEY `fk_revisions_resource` (`resource_type`,`resource_id`),
  KEY `fk_revisions_source` (`source_type`,`source_id`),
  KEY `fk_revisions_destination` (`destination_type`,`destination_id`),
  CONSTRAINT `fk_revisions_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `revisions_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`),
  CONSTRAINT `revisions_modified_by` FOREIGN KEY (`modified_by_id`) REFERENCES `people` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `revisions`
--

LOCK TABLES `revisions` WRITE;
/*!40000 ALTER TABLE `revisions` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `revisions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `risk_assessments`
--

DROP TABLE IF EXISTS `risk_assessments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `risk_assessments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `description` text,
  `notes` text,
  `ra_manager_id` int(11) DEFAULT NULL,
  `ra_counsel_id` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `program_id` int(11) NOT NULL,
  `slug` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_slug` (`slug`),
  KEY `fk_risk_assessments_manager_person_id` (`ra_manager_id`),
  KEY `fk_risk_assessments_counsel_person_id` (`ra_counsel_id`),
  KEY `fk_risk_assessments_contexts` (`context_id`),
  KEY `ix_risk_assessments_updated_at` (`updated_at`),
  CONSTRAINT `fk_risk_assessments_counsel_person_id` FOREIGN KEY (`ra_counsel_id`) REFERENCES `people` (`id`),
  CONSTRAINT `fk_risk_assessments_manager_person_id` FOREIGN KEY (`ra_manager_id`) REFERENCES `people` (`id`),
  CONSTRAINT `risk_assessments_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `risk_assessments`
--

LOCK TABLES `risk_assessments` WRITE;
/*!40000 ALTER TABLE `risk_assessments` DISABLE KEYS */;
/*!40000 ALTER TABLE `risk_assessments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `risk_objects`
--

DROP TABLE IF EXISTS `risk_objects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `risk_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `risk_id` int(11) NOT NULL,
  `object_id` int(11) NOT NULL,
  `object_type` varchar(250) NOT NULL,
  `status` varchar(250) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `risk_id` (`risk_id`,`object_id`,`object_type`),
  KEY `fk_risk_objects_contexts` (`context_id`),
  KEY `ix_risk_id` (`risk_id`),
  KEY `fk_risk_objects_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `risk_objects_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `risk_objects_ibfk_2` FOREIGN KEY (`risk_id`) REFERENCES `risks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `risk_objects`
--

LOCK TABLES `risk_objects` WRITE;
/*!40000 ALTER TABLE `risk_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `risk_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `risks`
--

DROP TABLE IF EXISTS `risks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `risks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `title` varchar(250) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `description` text NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(250) NOT NULL,
  `notes` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_risks` (`slug`),
  UNIQUE KEY `uq_t_risks` (`title`),
  KEY `fk_risks_contexts` (`context_id`),
  KEY `fk_risks_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `risks_ibfk_1` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `risks`
--

LOCK TABLES `risks` WRITE;
/*!40000 ALTER TABLE `risks` DISABLE KEYS */;
/*!40000 ALTER TABLE `risks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `permissions_json` text NOT NULL,
  `description` text,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `scope` varchar(64) DEFAULT NULL,
  `role_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_roles_contexts` (`context_id`),
  KEY `ix_roles_updated_at` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sections`
--

DROP TABLE IF EXISTS `sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `na` tinyint(1) NOT NULL,
  `notes` text,
  `parent_id` int(11) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  `status` varchar(250) DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_sections` (`slug`),
  UNIQUE KEY `uq_t_sections` (`title`),
  KEY `parent_id` (`parent_id`),
  KEY `fk_sections_contexts` (`context_id`),
  KEY `fk_sections_contact` (`contact_id`),
  KEY `ix_sections_updated_at` (`updated_at`),
  KEY `fk_sections_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_sections_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `sections_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `sections` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sections`
--

LOCK TABLES `sections` WRITE;
/*!40000 ALTER TABLE `sections` DISABLE KEYS */;
/*!40000 ALTER TABLE `sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `systems`
--

DROP TABLE IF EXISTS `systems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `systems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `infrastructure` tinyint(1) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `is_biz_process` tinyint(1) DEFAULT NULL,
  `version` varchar(250) DEFAULT NULL,
  `notes` text,
  `network_zone_id` int(11) DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_systems` (`slug`),
  UNIQUE KEY `uq_t_systems` (`title`),
  KEY `fk_systems_contexts` (`context_id`),
  KEY `fk_systems_contact` (`contact_id`),
  KEY `ix_systems_is_biz_process` (`is_biz_process`),
  KEY `ix_systems_updated_at` (`updated_at`),
  KEY `fk_systems_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_systems_contexts` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `systems`
--

LOCK TABLES `systems` WRITE;
/*!40000 ALTER TABLE `systems` DISABLE KEYS */;
/*!40000 ALTER TABLE `systems` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `task_group_objects`
--

DROP TABLE IF EXISTS `task_group_objects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `task_group_objects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_group_id` int(11) NOT NULL,
  `object_id` int(11) NOT NULL,
  `object_type` varchar(250) NOT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_group_id` (`task_group_id`,`object_id`,`object_type`),
  KEY `fk_task_group_objects_contexts` (`context_id`),
  KEY `ix_task_group_id` (`task_group_id`),
  KEY `ix_task_group_objects_updated_at` (`updated_at`),
  CONSTRAINT `fk_task_group_objects_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `fk_task_group_objects_task_group_id` FOREIGN KEY (`task_group_id`) REFERENCES `task_groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `task_group_objects`
--

LOCK TABLES `task_group_objects` WRITE;
/*!40000 ALTER TABLE `task_group_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `task_group_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `task_group_tasks`
--

DROP TABLE IF EXISTS `task_group_tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `task_group_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `task_group_id` int(11) NOT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `sort_index` varchar(250) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `description` text,
  `title` varchar(250) NOT NULL,
  `relative_end_day` int(11) DEFAULT NULL,
  `relative_end_month` int(11) DEFAULT NULL,
  `relative_start_day` int(11) DEFAULT NULL,
  `relative_start_month` int(11) DEFAULT NULL,
  `object_approval` tinyint(1) NOT NULL,
  `response_options` text NOT NULL,
  `task_type` varchar(250) NOT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_slug` (`slug`),
  KEY `fk_task_group_tasks_contexts` (`context_id`),
  KEY `fk_task_group_tasks_task_group_id` (`task_group_id`),
  KEY `fk_task_group_tasks_contact` (`contact_id`),
  KEY `ix_task_group_tasks_updated_at` (`updated_at`),
  KEY `fk_task_group_tasks_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_task_group_tasks_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `fk_task_group_tasks_task_group_id` FOREIGN KEY (`task_group_id`) REFERENCES `task_groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `task_group_tasks`
--

LOCK TABLES `task_group_tasks` WRITE;
/*!40000 ALTER TABLE `task_group_tasks` DISABLE KEYS */;
/*!40000 ALTER TABLE `task_group_tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `task_groups`
--

DROP TABLE IF EXISTS `task_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `task_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `description` text,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `lock_task_order` tinyint(1) DEFAULT NULL,
  `sort_index` varchar(250) NOT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_task_groups` (`slug`),
  KEY `fk_task_groups_workflow_id` (`workflow_id`),
  KEY `fk_task_groups_contact` (`contact_id`),
  KEY `fk_task_groups_contexts` (`context_id`),
  KEY `ix_task_groups_updated_at` (`updated_at`),
  KEY `fk_task_groups_secondary_contact` (`secondary_contact_id`),
  CONSTRAINT `fk_task_groups_contact_id` FOREIGN KEY (`contact_id`) REFERENCES `people` (`id`),
  CONSTRAINT `fk_task_groups_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `fk_task_groups_workflow_id` FOREIGN KEY (`workflow_id`) REFERENCES `workflows` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `task_groups`
--

LOCK TABLES `task_groups` WRITE;
/*!40000 ALTER TABLE `task_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `task_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `threats`
--

DROP TABLE IF EXISTS `threats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `threats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) DEFAULT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(250) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_t_actors` (`title`),
  UNIQUE KEY `uq_threats` (`slug`),
  KEY `fk_threat_actors_secondary_contact` (`secondary_contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `threats`
--

LOCK TABLES `threats` WRITE;
/*!40000 ALTER TABLE `threats` DISABLE KEYS */;
/*!40000 ALTER TABLE `threats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_roles`
--

DROP TABLE IF EXISTS `user_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `person_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_role_context_person` (`role_id`,`context_id`,`person_id`),
  KEY `fk_user_roles_contexts` (`context_id`),
  KEY `ix_user_roles_person` (`person_id`),
  KEY `ix_user_roles_updated_at` (`updated_at`),
  CONSTRAINT `user_roles_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_roles`
--

LOCK TABLES `user_roles` WRITE;
/*!40000 ALTER TABLE `user_roles` DISABLE KEYS */;
INSERT 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);
/*!40000 ALTER TABLE `user_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendors`
--

DROP TABLE IF EXISTS `vendors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vendors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `modified_by_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `description` text,
  `url` varchar(250) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `slug` varchar(250) NOT NULL,
  `title` varchar(250) NOT NULL,
  `context_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `notes` text,
  `status` varchar(250) NOT NULL,
  `reference_url` varchar(250) DEFAULT NULL,
  `secondary_contact_id` int(11) DEFAULT NULL,
  `os_state` varchar(16) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_vendors_title` (`title`),
  UNIQUE KEY `uq_slug_vendors` (`slug`),
  KEY `fk_vendors_context` (`context_id`),
  KEY `fk_vendors_contact` (`contact_id`),
  KEY `fk_vendors_modified_by` (`modified_by_id`),
  KEY `fk_vendors_status` (`status`),
  KEY `ix_vendors_updated_at` (`updated_at`),
  KEY `fk_vendors_secondary_contact` (`secondary_contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendors`
--

LOCK TABLES `vendors` WRITE;
/*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
/*!40000 ALTER TABLE `vendors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `workflow_people`
--

DROP TABLE IF EXISTS `workflow_people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workflow_people` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workflow_id` int(11) NOT NULL,
  `person_id` int(11) NOT NULL,
  `status` varchar(250) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `workflow_id` (`workflow_id`,`person_id`),
  KEY `fk_workflow_people_contexts` (`context_id`),
  KEY `ix_person_id` (`person_id`),
  KEY `ix_workflow_id` (`workflow_id`),
  KEY `ix_workflow_people_updated_at` (`updated_at`),
  CONSTRAINT `fk_workflow_people_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`),
  CONSTRAINT `fk_workflow_people_person_id` FOREIGN KEY (`person_id`) REFERENCES `people` (`id`),
  CONSTRAINT `fk_workflow_people_workflow_id` FOREIGN KEY (`workflow_id`) REFERENCES `workflows` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `workflow_people`
--

LOCK TABLES `workflow_people` WRITE;
/*!40000 ALTER TABLE `workflow_people` DISABLE KEYS */;
/*!40000 ALTER TABLE `workflow_people` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `workflows`
--

DROP TABLE IF EXISTS `workflows`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workflows` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `end_date` date DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `description` text,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `modified_by_id` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `context_id` int(11) DEFAULT NULL,
  `frequency` varchar(250) DEFAULT NULL,
  `notify_custom_message` text,
  `notify_on_change` tinyint(1) NOT NULL,
  `object_approval` tinyint(1) NOT NULL,
  `next_cycle_start_date` date DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `recurrences` tinyint(1) NOT NULL,
  `non_adjusted_next_cycle_start_date` date DEFAULT NULL,
  `is_old_workflow` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_workflows` (`slug`),
  KEY `fk_workflows_contexts` (`context_id`),
  KEY `ix_workflows_updated_at` (`updated_at`),
  CONSTRAINT `fk_workflows_context_id` FOREIGN KEY (`context_id`) REFERENCES `contexts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `workflows`
--

LOCK TABLES `workflows` WRITE;
/*!40000 ALTER TABLE `workflows` DISABLE KEYS */;
/*!40000 ALTER TABLE `workflows` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-04-21 14:55:01