anchor.diff:  /*!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`) */;
  +/*!50013 DEFINER=`kthfs`@`localhost` SQL SECURITY DEFINER */
  +/*!50001 VIEW `StudyDetails` AS select `study`.`name` AS `studyName`,`study`.`username` AS `email`,concat(`USERS`.`fname`,' ',`USERS`.`lname`) 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 `USERS_GROUPS`
  +--
  +
  +/*!50001 DROP TABLE IF EXISTS `USERS_GROUPS`*/;
  +/*!50001 DROP VIEW IF EXISTS `USERS_GROUPS`*/;
  +/*!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=`kthfs`@`localhost` SQL SECURITY DEFINER */
  +/*!50001 VIEW `USERS_GROUPS` AS select `u`.`username` AS `username`,`u`.`password` AS `password`,`u`.`secret` AS `secret`,`u`.`email` AS `email`,`g`.`group_name` AS `group_name` from ((`People_Group` `ug` join `USERS` `u` on((`u`.`uid` = `ug`.`uid`))) join `BBCGroup` `g` on((`g`.`gid` = `ug`.`gid`))) */;
  +/*!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 TABLE IF EXISTS `activitydetails`*/;
   /*!50001 DROP VIEW IF EXISTS `activitydetails`*/;
   /*!50001 SET @saved_cs_client          = @@character_set_client */;
   /*!50001 SET @saved_cs_results         = @@character_set_results */;
  
positive.code:   `Pgid` int(11) NOT NULL AUTO_INCREMENT,
    `gid` int(11) DEFAULT NULL,
    PRIMARY KEY (`Pgid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `USERS`
  
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
  