anchor.diff:  /*!40101 SET character_set_client = @saved_cs_client */;
   
   
  +
  +--
  +-- Table structure for table `AUDIT`
  +--
  +
  +DROP TABLE IF EXISTS `AUDIT`;
  +/*!40101 SET @saved_cs_client     = @@character_set_client */;
  +/*!40101 SET character_set_client = utf8 */;
  +CREATE TABLE `AUDIT` (
  +  `uid` varchar(8) DEFAULT NULL,
  +  `username` varchar(80) DEFAULT NULL,
  +  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  +  `role` varchar(20) DEFAULT NULL,
  +  `action` varchar(20) DEFAULT NULL,
  +  `resource` varchar(100) DEFAULT NULL,
  +  `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
  +  PRIMARY KEY (`log_id`),
  +  KEY `AUDIT_uid_idx` (`uid`),
  +  KEY `AUDIT_username_idx` (`username`)
  +) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
  +/*!40101 SET character_set_client = @saved_cs_client */;
  +
  +--
  +-- Table structure for table `Address`
  +--
  +
  +DROP TABLE IF EXISTS `Address`;
  +/*!40101 SET @saved_cs_client     = @@character_set_client */;
  +/*!40101 SET character_set_client = utf8 */;
  +CREATE TABLE `Address` (
  +  `address1` varchar(120) DEFAULT NULL,
  +  `address2` varchar(120) DEFAULT NULL,
  +  `address3` varchar(120) DEFAULT NULL,
  +  `city` varchar(100) DEFAULT NULL,
  +  `state` varchar(100) DEFAULT NULL,
  +  `country` varchar(100) DEFAULT NULL,
  +  `postalcode` varchar(16) DEFAULT NULL,
  +  `address_id` bigint(20) NOT NULL AUTO_INCREMENT,
  +  `uid` int(11) NOT NULL,
  +  PRIMARY KEY (`address_id`)
  +) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
  +/*!40101 SET character_set_client = @saved_cs_client */;
  +
  +--
  +-- Table structure for table `BBCGroup`
  +--
  +
  +DROP TABLE IF EXISTS `BBCGroup`;
  +/*!40101 SET @saved_cs_client     = @@character_set_client */;
  +/*!40101 SET character_set_client = utf8 */;
  +CREATE TABLE `BBCGroup` (
  +  `gid` int(10) NOT NULL,
  +  `group_name` varchar(20) NOT NULL,
  +  `group_desc` varchar(200) DEFAULT NULL,
  +  PRIMARY KEY (`gid`)
  +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  +/*!40101 SET character_set_client = @saved_cs_client */;
  +
  +--
  +-- Table structure for table `CONSENT`
  +--
  +
  +DROP TABLE IF EXISTS `CONSENT`;
  +/*!40101 SET @saved_cs_client     = @@character_set_client */;
  +/*!40101 SET character_set_client = utf8 */;
  +CREATE TABLE `CONSENT` (
  +  `id` int(11) NOT NULL,
  +  `date` date DEFAULT NULL,
  +  `study_name` varchar(128) DEFAULT NULL,
  +  `retention_period` date DEFAULT NULL,
  +  `consent_form` blob,
  +  `status` varchar(30) DEFAULT NULL,
  +  `name` varchar(80) DEFAULT NULL,
  +  PRIMARY KEY (`id`)
  +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  +/*!40101 SET character_set_client = @saved_cs_client */;
  +
  +--
  +-- 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` (
  +  `login_id` bigint(20) NOT NULL,
  +  `uid` varchar(8) DEFAULT NULL,
  +  `username` varchar(80) DEFAULT NULL,
  +  `role` varchar(20) DEFAULT NULL,
  +  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  +  `ip` varchar(16) DEFAULT NULL,
  +  `os` varchar(30) DEFAULT NULL,
  +  `browser` varchar(40) DEFAULT NULL,
  +  `action` varchar(80) DEFAULT NULL,
  +  `outcome` varchar(20) DEFAULT NULL,
  +  PRIMARY KEY (`login_id`),
  +  KEY `LOGIN_uid_idx` (`uid`),
  +  KEY `LOGIN_username_idx` (`username`)
  +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  +/*!40101 SET character_set_client = @saved_cs_client */;
  +
   --
   -- Table structure for table `People_Group`
   --
  
positive.code: /*!50001 SET character_set_results     = utf8 */;
  /*!50001 SET collation_connection      = utf8_general_ci */;
  /*!50001 CREATE ALGORITHM=UNDEFINED */
  /*!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 */;
  
negative.code: /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2015-03-10 17:23:48
  