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=840 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 */;
  -
  ---
  --- Table structure for table `Roles`
  ---
  +) ENGINE=InnoDB AUTO_INCREMENT=1592 DEFAULT CHARSET=latin1;
  +/*!40101 SET character_set_client = @saved_cs_client */;
  +
  +
   
   DROP TABLE IF EXISTS `Roles`;
   /*!40101 SET @saved_cs_client     = @@character_set_client */;
  
positive.code: -- MySQL dump 10.13  Distrib 5.6.22, for Linux (x86_64)
  --
  -- Host: localhost    Database: kthfs
  -- ------------------------------------------------------
  -- Server version	5.6.22
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  
negative.code: /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Temporary view structure for view `StudyDetails`
  --
  
  