anchor.diff:  ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (project_id) */;
   
   
  +CREATE TABLE `pythondep_host_status` (
  +  `project_id` INT(11) NOT NULL,
  +  `dep_id` INT(10) NOT NULL,
  +  `repo_id` INT(11) NOT NULL,
  +  `host_id` INT(11) NOT NULL,
  +  `status` VARCHAR(128) NOT NULL,  
  +  PRIMARY KEY (`project_id`, `dep_id`, `repo_id`, `host_id`),
  +  KEY (`status`),  
  +  FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  +  FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  +  FOREIGN KEY (`repo_id`) REFERENCES `anaconda_repo` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,    
  +  FOREIGN KEY (`dep_id`) REFERENCES `python_dep` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  +) ENGINE=ndbcluster DEFAULT CHARSET=latin1 /*!50100 PARTITION BY KEY (project_id) */;
  +
  +
  +
   --
   -- Kagent Asynchronous Commands
   --
  
positive.code: CREATE TABLE `kagent_commands` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `json_command` VARCHAR(1024) NOT NULL,
    `host_id` varchar(128) NOT NULL,
    `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `project_id` INT(11),
    PRIMARY KEY (`id`),
    FOREIGN KEY (`project_id`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
    FOREIGN KEY (`host_id`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE ON UPDATE NO ACTION
  ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
  
  
negative.code: 
  CREATE TABLE `tf_resources` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `host_id` INT NOT NULL,
    `device_id` INT NOT NULL,
    `device_path` VARCHAR(255) NOT NULL,
    `resource` VARCHAR(20) NOT NULL,
    `free` tinyint(1) NOT NULL DEFAULT '1',
    KEY `resource_idx` (`resource`),
    FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
    PRIMARY KEY (`id`)
  ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
  
  