anchor.diff:  ) ENGINE=ndbcluster;
   
   CREATE TABLE `userlogins` (
  -  `login_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  -  `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,
  -  `uid` INT(10) NOT NULL,
  -  `login_date` TIMESTAMP NULL DEFAULT NULL,
  -  PRIMARY KEY (`login_id`),
  -  KEY (`login_date`),
  -  FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE NO ACTION
  -) ENGINE=ndbcluster;
  +    `login_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  +    `ip` VARCHAR(45) DEFAULT NULL,
  +    `os` VARCHAR(30) DEFAULT NULL,
  +    `browser` VARCHAR(40) DEFAULT NULL,
  +    `action` VARCHAR(80) DEFAULT NULL,
  +    `outcome` VARCHAR(20) DEFAULT NULL,
  +    `mac` VARCHAR(45) DEFAULT NULL,
  +    `uid` INT(11) NOT NULL,
  +    `email` VARCHAR(150)  DEFAULT NULL,
  +    `login_date` TIMESTAMP NULL DEFAULT NULL,
  +    PRIMARY KEY (`login_id`),
  +    KEY (`login_date`),
  +    FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE NO ACTION
  +) ENGINE=ndbcluster;
  +
   
   CREATE TABLE `jobs` (
     `id` INT(11) NOT NULL AUTO_INCREMENT,
     `name` VARCHAR(128) DEFAULT NULL,
     `creation_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
     `project_id` INT(11) NOT NULL,
  -  `creator` VARCHAR(45) NOT NULL,
  +  `creator` VARCHAR(150) NOT NULL,
     `type` VARCHAR(128) NOT NULL,
     `json_config` TEXT NOT NULL,
     PRIMARY KEY (`id`),
  
positive.code:   FOREIGN KEY (`execution_id`) REFERENCES `executions` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  ) ENGINE=ndbcluster;
  
  CREATE TABLE `consent` (
    `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `date` DATE DEFAULT NULL,
    `project_id` INT(11) NOT NULL,
    `status` VARCHAR(30) DEFAULT NULL,
    `name` VARCHAR(80) DEFAULT NULL,
    `type` VARCHAR(30) DEFAULT NULL,
    `consent_form` longblob DEFAULT NULL,
     PRIMARY KEY (`id`),
    FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
  ) ENGINE=ndbcluster;
  
  CREATE TABLE `organization` (
      `id` INT(11) NOT NULL AUTO_INCREMENT,
      `uid` INT(11) DEFAULT NULL,
      `org_name` VARCHAR(100) DEFAULT NULL,
      `website` VARCHAR(200) DEFAULT NULL,
      `contact_person` VARCHAR(100) DEFAULT NULL,
      `contact_email` VARCHAR(100) DEFAULT NULL,
      `department` VARCHAR(100) DEFAULT NULL,
      `phone` VARCHAR(20) DEFAULT NULL,
      `fax` VARCHAR(20) DEFAULT NULL,
      PRIMARY KEY (`id`),
      FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE
  ) ENGINE=ndbcluster;
  
negative.code:   PRIMARY KEY (`id`),
    UNIQUE KEY(`projectname`),
    UNIQUE KEY(`inode_pid`, `inode_name`),
  #  FOREIGN KEY (`username`) REFERENCES `users` (`email`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY (`inode_pid`,`inode_name`) REFERENCES `hops`.`hdfs_inodes`(`parent_id`,`name`) ON DELETE CASCADE ON UPDATE NO ACTION
  ) ENGINE=ndbcluster CHARSET=latin1;
  
  