anchor.diff:  -- ------------------------
   CREATE TABLE `message` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
  -  `user_from` varchar(45) DEFAULT NULL,
  -  `user_to` varchar(45)  NOT NULL,
  +  `user_from` varchar(150) DEFAULT NULL,
  +  `user_to` varchar(150)  NOT NULL,
     `date_sent` datetime NOT NULL,
     `subject` varchar(128)  DEFAULT NULL,
     `preview` varchar(128) DEFAULT NULL,
  
positive.code: 
  CREATE TABLE `bbc_group` (
    `group_name` VARCHAR(20) NOT NULL,
    `group_desc` VARCHAR(200) DEFAULT NULL,
    `gid` INT(11) NOT NULL,
    PRIMARY KEY (`gid`)
  ) ENGINE=ndbcluster;
  
  CREATE TABLE `users` (
    `uid` INT(16) NOT NULL DEFAULT '1000',
    `username` VARCHAR(16) 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,
    `title` VARCHAR(10)  DEFAULT NULL,
    `orcid` VARCHAR(20)  DEFAULT NULL,
    `false_login` INT(11) NOT NULL DEFAULT '-1',
    `isonline` TINYINT(1) NOT NULL DEFAULT '0',
    `secret` VARCHAR(20)  DEFAULT NULL,
    `validation_key` VARCHAR(128)  DEFAULT NULL,
    `security_question` VARCHAR(20)  DEFAULT NULL,
    `security_answer` VARCHAR(128)  DEFAULT NULL,
    `yubikey_user` INT(11) NOT NULL DEFAULT '0',
    `password_changed` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
    `notes` VARCHAR(500)  DEFAULT NULL,
    `mobile` VARCHAR(20)  DEFAULT NULL,
    `status` INT(11) NOT NULL DEFAULT '-1',
    PRIMARY KEY (`uid`),
    UNIQUE (`username`),
    UNIQUE (`email`)
  ) ENGINE=ndbcluster AUTO_INCREMENT=10000;
  
  CREATE TABLE `yubikey` (
    `serial` VARCHAR(10)  DEFAULT NULL,
    `version` VARCHAR(15)  DEFAULT NULL,
    `notes` VARCHAR(100)  DEFAULT NULL,
    `counter` INT(11) DEFAULT NULL,
    `low` INT(11) DEFAULT NULL,
    `high` INT(11) DEFAULT NULL,
    `session_use` INT(11) DEFAULT NULL,
    `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `aes_secret` VARCHAR(100)  DEFAULT NULL,
    `public_id` VARCHAR(40)  DEFAULT NULL,
    `accessed` TIMESTAMP NULL DEFAULT NULL,
    `status` INT(11) DEFAULT '-1',
    `yubidnum` INT(11) NOT NULL AUTO_INCREMENT,
    `uid` INT(11) NOT NULL,
    PRIMARY KEY (`yubidnum`),
    UNIQUE (`uid`),
    UNIQUE (`serial`),
    UNIQUE (`public_id`),
    FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE NO ACTION
  ) ENGINE=ndbcluster;
  
  CREATE TABLE `address` (
    `address1` VARCHAR(50) DEFAULT NULL,
    `address2` VARCHAR(50) DEFAULT NULL,
    `address3` VARCHAR(50) DEFAULT NULL,
    `city` VARCHAR(30) DEFAULT NULL,
    `state` VARCHAR(100) DEFAULT NULL,
    `country` VARCHAR(40) DEFAULT NULL,
    `postalcode` VARCHAR(10) DEFAULT NULL,
    `address_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `uid` INT(10) NOT NULL,
    PRIMARY KEY (`address_id`),
    FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE NO ACTION
  ) ENGINE=ndbcluster;
  
  CREATE TABLE `people_group` (
    `uid` INT(10) NOT NULL,
    `gid` INT(11) NOT NULL,
    PRIMARY KEY (`uid`,`gid`),
    FOREIGN KEY (`gid`) REFERENCES `bbc_group` (`gid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
    FOREIGN KEY (`uid`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE NO ACTION
  ) ENGINE=ndbcluster;
  
  CREATE TABLE `project` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `inode_pid` INT(11) NOT NULL,
    `inode_name` VARCHAR(255) NOT NULL,
    `projectname` VARCHAR(128) NOT NULL,
    `username` VARCHAR(45) NOT NULL,
    `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `retention_period` DATE DEFAULT NULL,
    `ethical_status` VARCHAR(30) DEFAULT NULL,
  
negative.code: ) ENGINE=ndbcluster;
  
  CREATE TABLE `userlogins` (
      `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(150) NOT NULL,
    `type` VARCHAR(128) NOT NULL,
    `json_config` TEXT NOT NULL,
    PRIMARY KEY (`id`),
  