anchor.diff:    `public_ip` varchar(15) DEFAULT NULL,
     `agent_password` varchar(25) DEFAULT NULL,
     `registered` tinyint(1) DEFAULT '0',
  -  PRIMARY KEY (`hostid`)
  +  PRIMARY KEY (`id`),
  +  KEY (`hostid`),
  +  KEY (`hostname_`)  
  +) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
  +
  +
  +CREATE TABLE `alerts` (
  +  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  +  `current_value` varchar(32) DEFAULT NULL,
  +  `failure_max` varchar(32) DEFAULT NULL,
  +  `failure_min` varchar(32) DEFAULT NULL,
  +  `warning_max` varchar(32) DEFAULT NULL,
  +  `warning_min` varchar(32) DEFAULT NULL,
  +  `agent_time` bigint(20) DEFAULT NULL,
  +  `alert_time` datetime DEFAULT NULL,
  +  `data_source` varchar(128) DEFAULT NULL,
  +  `host_id` int(11) DEFAULT NULL,
  +  `message` varchar(1024) NOT NULL,
  +  `plugin` varchar(128) DEFAULT NULL,
  +  `plugin_instance` varchar(128) DEFAULT NULL,
  +  `provider` varchar(255) DEFAULT NULL,
  +  `severity` varchar(255) DEFAULT NULL,
  +  `type` varchar(128) DEFAULT NULL,
  +  `type_instance` varchar(128) DEFAULT NULL,
  +  PRIMARY KEY (`id`),
  +  FOREIGN KEY (`host_id`) REFERENCES `hosts` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
   ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
   
   
  
positive.code: 
  CREATE TABLE `tf_resources` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `host_id` VARCHAR(128) 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` (`hostid`) ON DELETE CASCADE ON UPDATE NO ACTION,
    PRIMARY KEY (`id`)
  ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
  
  
negative.code: -- kmon
  -- ------------------------
  
  CREATE TABLE `hosts` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `hostid` varchar(128) NOT NULL,
    `cores` int(11) DEFAULT NULL,
    `disk_capacity` bigint(20) DEFAULT NULL,
  