anchor.diff:  /*!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 `Alerts`
  ---
  -
  -DROP TABLE IF EXISTS `Alerts`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `Alerts` (
  -  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  -  `CURRENTVALUE` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `FAILUREMAX` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `FAILUREMIN` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `WARNINGMAX` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `WARNINGMIN` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `AGENTTIME` bigint(20) DEFAULT NULL,
  -  `ALERTTIME` datetime DEFAULT NULL,
  -  `DATASOURCE` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `HOSTID` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `MESSAGE` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
  -  `PLUGIN` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PLUGININSTANCE` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PROVIDER` int(11) DEFAULT NULL,
  -  `SEVERITY` int(11) DEFAULT NULL,
  -  `TYPE` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `TYPEINSTANCE` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `Alerts`
  ---
  -
  -LOCK TABLES `Alerts` WRITE;
  -/*!40000 ALTER TABLE `Alerts` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Alerts` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `ClusterEntities`
  ---
  -
  -DROP TABLE IF EXISTS `ClusterEntities`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `ClusterEntities` (
  -  `ID` bigint(20) NOT NULL,
  -  `CLUSTERNAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `CLUSTERTYPE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `YAMLCONTENT` text COLLATE utf8_unicode_ci,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `ClusterEntities`
  ---
  -
  -LOCK TABLES `ClusterEntities` WRITE;
  -/*!40000 ALTER TABLE `ClusterEntities` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `ClusterEntities` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `Commands`
  ---
  -
  -DROP TABLE IF EXISTS `Commands`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `Commands` (
  -  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  -  `CLUSTER` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  -  `COMMAND` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  -  `END_TIME` datetime DEFAULT NULL,
  -  `HOSTID` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  -  `ROLE_` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  -  `SERVICE` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  -  `START_TIME` datetime DEFAULT NULL,
  -  `STATUS` int(11) DEFAULT NULL,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `Commands`
  ---
  -
  -LOCK TABLES `Commands` WRITE;
  -/*!40000 ALTER TABLE `Commands` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Commands` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `Graphs`
  ---
  -
  -DROP TABLE IF EXISTS `Graphs`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `Graphs` (
  -  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  -  `CHARTS` longblob,
  -  `GRAPHID` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  -  `GROUP_` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  -  `GROUPRANK` int(11) DEFAULT NULL,
  -  `PLUGIN` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PLUGININSTANCE` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `RANK` int(11) DEFAULT NULL,
  -  `SELECTED` tinyint(1) DEFAULT '0',
  -  `TARGET` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  -  `TITLE` varchar(48) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `VAR` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `VERTICALLABEL` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `Graphs`
  ---
  -
  -LOCK TABLES `Graphs` WRITE;
  -/*!40000 ALTER TABLE `Graphs` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Graphs` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `Hosts`
  ---
  -
  -DROP TABLE IF EXISTS `Hosts`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `Hosts` (
  -  `HOSTID` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  -  `CORES` int(11) DEFAULT NULL,
  -  `DISKCAPACITY` bigint(20) DEFAULT NULL,
  -  `DISKUSED` bigint(20) DEFAULT NULL,
  -  `HOSTNAME_` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  -  `LASTHEARTBEAT` bigint(20) DEFAULT NULL,
  -  `LOAD1` double DEFAULT NULL,
  -  `LOAD15` double DEFAULT NULL,
  -  `LOAD5` double DEFAULT NULL,
  -  `MEMORYCAPACITY` bigint(20) DEFAULT NULL,
  -  `MEMORYUSED` bigint(20) DEFAULT NULL,
  -  `PRIVATEIP` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PUBLICIP` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `REGISTERED` tinyint(1) DEFAULT '0',
  -  PRIMARY KEY (`HOSTID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `Hosts`
  ---
  -
  -LOCK TABLES `Hosts` WRITE;
  -/*!40000 ALTER TABLE `Hosts` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Hosts` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `Jobs`
  ---
  -
  -DROP TABLE IF EXISTS `Jobs`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `Jobs` (
  -  `ID` bigint(20) NOT NULL,
  -  `COMPLETED` tinyint(1) DEFAULT '0',
  -  `COMPLETIONTIME` bigint(20) DEFAULT NULL,
  -  `DATERUN` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `EXECUTEDBY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `GRAPHDOT` text COLLATE utf8_unicode_ci,
  -  `NAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `TABLEJOB` text COLLATE utf8_unicode_ci,
  -  `UNIQUEID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `Jobs`
  ---
  -
  -LOCK TABLES `Jobs` WRITE;
  -/*!40000 ALTER TABLE `Jobs` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Jobs` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `NodeProgress`
  ---
  -
  -DROP TABLE IF EXISTS `NodeProgress`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `NodeProgress` (
  -  `ID` bigint(20) NOT NULL,
  -  `CLUSTER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `IP` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `LOGINUSER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `NODEID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `NODEROLE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PHASE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PREVIOUSPHASE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PRIVATEKEY` text COLLATE utf8_unicode_ci,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `NodeProgress`
  ---
  -
  -LOCK TABLES `NodeProgress` WRITE;
  -/*!40000 ALTER TABLE `NodeProgress` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `NodeProgress` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `PaasCredentials`
  ---
  -
  -DROP TABLE IF EXISTS `PaasCredentials`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `PaasCredentials` (
  -  `ID` bigint(20) NOT NULL,
  -  `ACCESSKEY` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `ACCOUNTID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `DASHBOARDIP` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `EMAIL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `KEYSTONEURL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PROVIDER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `PUBLICKEY` text COLLATE utf8_unicode_ci,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `PaasCredentials`
  ---
  -
  -LOCK TABLES `PaasCredentials` WRITE;
  -/*!40000 ALTER TABLE `PaasCredentials` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `PaasCredentials` 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` bigint(20) NOT NULL AUTO_INCREMENT,
  -  `CLUSTER` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  -  `COMMAND` varchar(31) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `CONFIGFILE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `HOSTID` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  -  `PID` int(11) DEFAULT NULL,
  -  `ROLE_` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  -  `SERVICE` varchar(48) COLLATE utf8_unicode_ci NOT NULL,
  -  `STATUS` int(11) NOT NULL,
  -  `SUPPORTSINIT` tinyint(1) DEFAULT '0',
  -  `UPTIME` bigint(20) DEFAULT NULL,
  -  `WEBPORT` int(11) DEFAULT NULL,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `Roles`
  ---
  -
  -LOCK TABLES `Roles` WRITE;
  -/*!40000 ALTER TABLE `Roles` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Roles` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `SEQUENCE`
  ---
  -
  -DROP TABLE IF EXISTS `SEQUENCE`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `SEQUENCE` (
  -  `SEQ_NAME` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  -  `SEQ_COUNT` decimal(38,0) DEFAULT NULL,
  -  PRIMARY KEY (`SEQ_NAME`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `SEQUENCE`
  ---
  -
  -LOCK TABLES `SEQUENCE` WRITE;
  -/*!40000 ALTER TABLE `SEQUENCE` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `SEQUENCE` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `Samples`
  ---
  -
  -DROP TABLE IF EXISTS `Samples`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `Samples` (
  -  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  -  `DATAADMINSTRATOR` longblob,
  -  `DESCRIPTION` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `DIAGNOSIS` longblob,
  -  `ENGLISHNAME` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `LASTUPDATED` datetime DEFAULT NULL,
  -  `ORGANIZATION` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `OTHERINFORMATION` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `RESPONSIBLE` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `SAMPLECOLLECTION` longblob,
  -  `SAMPLEDONORS` longblob,
  -  `SAMPLES` longblob,
  -  `STUDY` longblob,
  -  `SWEDISHNAME` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `Samples`
  ---
  -
  -LOCK TABLES `Samples` WRITE;
  -/*!40000 ALTER TABLE `Samples` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Samples` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `ServiceRoles`
  ---
  -
  -DROP TABLE IF EXISTS `ServiceRoles`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `ServiceRoles` (
  -  `role_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  `service` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  `role_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  PRIMARY KEY (`service`,`role_type`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `ServiceRoles`
  ---
  -
  -LOCK TABLES `ServiceRoles` WRITE;
  -/*!40000 ALTER TABLE `ServiceRoles` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `ServiceRoles` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `USERS`
  ---
  -
  -DROP TABLE IF EXISTS `USERS`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `USERS` (
  -  `EMAIL` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  `MOBILENUM` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  `NAME` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  `PASSWORD` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  -  `REGISTEREDON` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  -  `SALT` longblob NOT NULL,
  -  `USERNAME` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  PRIMARY KEY (`EMAIL`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `USERS`
  ---
  -
  -LOCK TABLES `USERS` WRITE;
  -/*!40000 ALTER TABLE `USERS` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `USERS` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  ---
  --- Table structure for table `USERS_GROUPS`
  ---
  -
  -DROP TABLE IF EXISTS `USERS_GROUPS`;
  -/*!40101 SET @saved_cs_client     = @@character_set_client */;
  -/*!40101 SET character_set_client = utf8 */;
  -CREATE TABLE `USERS_GROUPS` (
  -  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  -  `groupname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  -  UNIQUE KEY `UNQ_USERS_GROUPS_0` (`email`,`groupname`),
  - CONSTRAINT `FK_USERS_GROUPS_email` FOREIGN KEY(`email`) REFERENCES `USERS` (`EMAIL`) ON DELETE NO ACTION ON UPDATE NO ACTION
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  ---
  --- Dumping data for table `USERS_GROUPS`
  ---
  -
  -LOCK TABLES `USERS_GROUPS` WRITE;
  -/*!40000 ALTER TABLE `USERS_GROUPS` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `USERS_GROUPS` 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` bigint(20) NOT NULL,
  -  `OWNER` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `WORKFLOWDATE` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `WORKFLOWMETADATA` text COLLATE utf8_unicode_ci,
  -  `WORKFLOWNAME` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  `WORKFLOWTAGS` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  -  PRIMARY KEY (`ID`)
  -) ENGINE=ndbcluster DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  -/*!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 2014-08-10 21:08:42
  -
  -
  -LOCK TABLES `USERS` WRITE;
  -/*!40000 ALTER TABLE `USERS` DISABLE KEYS */;
  -INSERT INTO `USERS` VALUES ('admin','33','Administrator','61646D696E','2013-09-26 12:51:52','xx','admin'),('kthfsagent@sics.se','0','KTHFS Agent','6B746866736167656E74','2013-02-08 15:49:01','xx','kthfsagent');
  -/*!40000 ALTER TABLE `USERS` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
  -
  -LOCK TABLES `USERS_GROUPS` WRITE;
  -/*!40000 ALTER TABLE `USERS_GROUPS` DISABLE KEYS */;
  -INSERT INTO `USERS_GROUPS` VALUES ('admin','ADMIN'),('kthfsagent@sics.se','AGENT');
  -/*!40000 ALTER TABLE `USERS_GROUPS` 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 */;
  -
  -
  -
  -LOCK TABLES `PaasCredentials` WRITE;
  -/*!40000 ALTER TABLE `PaasCredentials` DISABLE KEYS */;
  -# INSERT INTO `PaasCredentials`(EMAIL,ACCESSKEY,ACCOUNTID,DASHBOARDIP,KEYSTONEURL,PROVIDER,PUBLICKEY) VALUES ("<%= node[:provider][:email] %>", "<%= node[:provider][:access_key] %>", "<%= node[:provider][:account_id] %>", "<%= @private_ip %>", "<%= node[:provider][:keystone_url] %>", "<%= node[:provider][:name] %>", "<%= node[:hopshub][:public_key] %>");
  -/*!40000 ALTER TABLE `PaasCredentials` ENABLE KEYS */;
  -UNLOCK TABLES;
  -
   
   --
   -- Table structure for table `Address`
  
positive.code: /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Group`
  --
  
  LOCK TABLES `Group` WRITE;
  /*!40000 ALTER TABLE `Group` DISABLE KEYS */;
  INSERT INTO `Group` VALUES (1001,'BBC_ADMIN',NULL),(1002,'BBC_RESEARCHER',NULL),(1003,'BBC_GUEST',NULL),(1004,'AUDITOR',NULL),(1005,'ETHICS_BOARD',NULL);
  /*!40000 ALTER TABLE `Group` 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` (
    `uid` int(10) NOT NULL DEFAULT '1000',
    `username` varchar(10) NOT NULL,
    `password` varchar(128) NOT NULL,
    `email` varchar(45) DEFAULT NULL,
    `fname` varchar(30) DEFAULT NULL,
    `lname` varchar(30) DEFAULT NULL,
    `activated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `home_org` varchar(100) DEFAULT NULL,
    `title` varchar(10) DEFAULT NULL,
    `mobile` varchar(20) DEFAULT NULL,
    `orcid` varchar(20) DEFAULT NULL,
    `false_login` int(11) NOT NULL DEFAULT '0',
    `active` int(11) NOT NULL DEFAULT '-1',
    `isonline` int(11) NOT NULL DEFAULT '-1',
    `secret` varchar(20) DEFAULT NULL,
    `security_question` varchar(20) DEFAULT NULL,
    `security_answer` varchar(128) DEFAULT NULL,
    PRIMARY KEY (`uid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `People`
  --
  
  LOCK TABLES `People` WRITE;
  /*!40000 ALTER TABLE `People` DISABLE KEYS */;
  /*!40000 ALTER TABLE `People` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  
  --
  -- Table structure for table `Login`
  --
  
  DROP TABLE IF EXISTS `Login`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Login` (
    `loginid` bigint(20) NOT NULL AUTO_INCREMENT,
    `People_uid` int(10) DEFAULT NULL,
    `last_login` timestamp NULL DEFAULT NULL,
    `last_ip` varchar(45) DEFAULT NULL,
    `os_platform` int(11) DEFAULT NULL,
    `logout` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`loginid`),
    KEY `fk_login_people` (`People_uid`),
    CONSTRAINT `fk_login_people` FOREIGN KEY (`People_uid`) REFERENCES `People` (`uid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `FK_Login_People_uid` FOREIGN KEY (`People_uid`) REFERENCES `People` (`uid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Login`
  --
  
  LOCK TABLES `Login` WRITE;
  /*!40000 ALTER TABLE `Login` DISABLE KEYS */;
  /*!40000 ALTER TABLE `Login` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `People_Group`
  --
  
  DROP TABLE IF EXISTS `People_Group`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `People_Group` (
    `uid` int(10) NOT NULL,
    `gid` int(10) NOT NULL,
    PRIMARY KEY (`uid`,`gid`),
    KEY `fk_people_has_group_group1` (`gid`),
    KEY `fk_people_has_groups_people` (`uid`),
    CONSTRAINT `fk_group` FOREIGN KEY (`gid`) REFERENCES `Group` (`gid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `fk_people` FOREIGN KEY (`uid`) REFERENCES `People` (`uid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    CONSTRAINT `FK_People_Group_uid` FOREIGN KEY (`uid`) REFERENCES `People` (`uid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `People_Group`
  --
  
  LOCK TABLES `People_Group` WRITE;
  /*!40000 ALTER TABLE `People_Group` DISABLE KEYS */;
  /*!40000 ALTER TABLE `People_Group` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `Yubikey`
  --
  
  DROP TABLE IF EXISTS `Yubikey`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Yubikey` (
    `yubidnum` varchar(45) NOT NULL,
    `serial` varchar(10) DEFAULT NULL,
    `version` varchar(15) DEFAULT NULL,
    `active` tinyint(1) DEFAULT NULL,
    `notes` varchar(100) DEFAULT NULL,
    `counter` int(11) DEFAULT NULL,
    `low` int(11) DEFAULT NULL,
    `high` int(11) DEFAULT NULL,
    `session_use` int(11) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `aes_secret` varchar(100) DEFAULT NULL,
    `public_id` varchar(40) DEFAULT NULL,
    `People_uid` int(10) DEFAULT NULL,
    PRIMARY KEY (`yubidnum`),
    KEY `fk_Yubikey_People_idx` (`People_uid`),
    CONSTRAINT `fk_Yubikey_People1` FOREIGN KEY (`People_uid`) REFERENCES `People` (`uid`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `Yubikey`
  --
  
  LOCK TABLES `Yubikey` WRITE;
  /*!40000 ALTER TABLE `Yubikey` DISABLE KEYS */;
  /*!40000 ALTER TABLE `Yubikey` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Temporary table structure for view `v_People_Group`
  --
  
  DROP TABLE IF EXISTS `v_People_Group`;
  /*!50001 DROP VIEW IF EXISTS `v_People_Group`*/;
  SET @saved_cs_client     = @@character_set_client;
  SET character_set_client = utf8;
  /*!50001 CREATE TABLE `v_People_Group` (
    `username` tinyint NOT NULL,
    `password` tinyint NOT NULL,
    `secret` tinyint NOT NULL,
    `email` tinyint NOT NULL,
    `group_name` tinyint NOT NULL
  ) ENGINE=MyISAM */;
  SET character_set_client = @saved_cs_client;
  
  --
  -- Final view structure for view `v_People_Group`
  --
  
  /*!50001 DROP TABLE IF EXISTS `v_People_Group`*/;
  /*!50001 DROP VIEW IF EXISTS `v_People_Group`*/;
  /*!50001 SET @saved_cs_client          = @@character_set_client */;
  /*!50001 SET @saved_cs_results         = @@character_set_results */;
  /*!50001 SET @saved_col_connection     = @@collation_connection */;
  
negative.code: /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `COLLECTION_TYPES`
  --
  
  DROP TABLE IF EXISTS `COLLECTION_TYPES`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `COLLECTION_TYPES` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) NOT NULL,
    `definition` varchar(2000) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `name` (`name`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `Env_vars`
  --
  
  DROP TABLE IF EXISTS `Env_vars`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Env_vars` (
    `name` varchar(128) NOT NULL,
    `value` varchar(1024) DEFAULT NULL,
    PRIMARY KEY (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `Group`
  