anchor.diff:  /*!40101 SET character_set_client = @saved_cs_client */;
   
   --
  --- Dumping data for table `Address`
  ---
  -
  -LOCK TABLES `Address` WRITE;
  -/*!40000 ALTER TABLE `Address` DISABLE KEYS */;
  -/*!40000 ALTER TABLE `Address` ENABLE KEYS */;
  -UNLOCK TABLES;
  +-- 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`
  
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: /*!50001 SET collation_connection      = utf8_general_ci */;
  /*!50001 CREATE ALGORITHM=UNDEFINED */
  /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
  /*!50001 VIEW `StudyDetails` AS select `study`.`name` AS `studyName`,`study`.`username` AS `email`,`USERS`.`NAME` AS `creator` from (`study` join `USERS` on((`study`.`username` = `USERS`.`EMAIL`))) where `study`.`name` in (select `StudyTeam`.`name` from `StudyTeam`) */;
  /*!50001 SET character_set_client      = @saved_cs_client */;
  /*!50001 SET character_set_results     = @saved_cs_results */;
  /*!50001 SET collation_connection      = @saved_col_connection */;
  
  --
  -- Final view structure for view `activitydetails`
  --
  
  /*!50001 DROP VIEW IF EXISTS `activitydetails`*/;
  /*!50001 SET @saved_cs_client          = @@character_set_client */;
  /*!50001 SET @saved_cs_results         = @@character_set_results */;
  /*!50001 SET @saved_col_connection     = @@collation_connection */;
  /*!50001 SET character_set_client      = utf8 */;
  /*!50001 SET character_set_results     = utf8 */;
  /*!50001 SET collation_connection      = utf8_general_ci */;
  /*!50001 CREATE ALGORITHM=UNDEFINED */
  /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
  /*!50001 VIEW `activitydetails` AS select `activity`.`id` AS `id`,`activity`.`performed_By` AS `performed_by_email`,`USERS`.`NAME` AS `performed_by_name`,`activity`.`activity` AS `description`,`activity`.`activity_on` AS `studyname`,`activity`.`timestamp` AS `timestamp` from (`activity` join `USERS` on((`activity`.`performed_By` = `USERS`.`EMAIL`))) */;
  /*!50001 SET character_set_client      = @saved_cs_client */;
  /*!50001 SET character_set_results     = @saved_cs_results */;
  /*!50001 SET collation_connection      = @saved_col_connection */;
  
  
  -- Dump completed on 2015-01-07 14:15:59
  