anchor.diff:    KEY `pid_2` (`pid`,`isDir`),
     KEY `name` (`name`),
     CONSTRAINT `Inodes_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `Inodes` (`id`) ON DELETE CASCADE
  -) ENGINE=InnoDB AUTO_INCREMENT=419 DEFAULT CHARSET=latin1;
  -/*!40101 SET character_set_client = @saved_cs_client */;
  -
  +) ENGINE=InnoDB AUTO_INCREMENT=440 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` (
  +  `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_uid` FOREIGN KEY (`People_uid`) REFERENCES `People` (`uid`),
  +  CONSTRAINT `fk_login_people` 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 */;
  +
  +--
  +-- 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 */;
  +
  +--
  +-- 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_People_Group_uid` FOREIGN KEY (`uid`) REFERENCES `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
  +) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   /*!40101 SET character_set_client = @saved_cs_client */;
   
   --
  
positive.code: /*!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 `Address`
  
negative.code: /*!50001 SET character_set_results     = @saved_cs_results */;
  /*!50001 SET collation_connection      = @saved_col_connection */;
  
  --
  -- Final view structure for view `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 */;
  /*!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 `v_People_Group` 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 `People` `u` on((`u`.`uid` = `ug`.`uid`))) join `Group` `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 */;
  /*!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 2015-01-09 19:36:24
  