anchor.diff:    `name` varchar(255) NOT NULL,
     `path` varchar(255) NOT NULL,
     PRIMARY KEY (`job_id`,`name`),
  +  CONSTRAINT `FK_job_output_files_job_id` FOREIGN KEY (`job_id`) REFERENCES `jobhistory` (`id`),
     CONSTRAINT `job_output_files_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `jobhistory` (`id`)
   ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
   /*!40101 SET character_set_client = @saved_cs_client */;
  
positive.code:   `sampled_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `anatomical_site` int(16) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `samplecollection_id` (`samplecollection_id`),
    KEY `parent_id` (`parent_id`),
    KEY `anatomical_site` (`anatomical_site`),
    CONSTRAINT `SAMPLES_ibfk_1` FOREIGN KEY (`samplecollection_id`) REFERENCES `SAMPLECOLLECTIONS` (`id`),
    CONSTRAINT `SAMPLES_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `SAMPLES` (`id`),
    CONSTRAINT `SAMPLES_ibfk_3` FOREIGN KEY (`anatomical_site`) REFERENCES `ANATOMICAL_PARTS` (`id`)
  
negative.code:   `description` varchar(2000) DEFAULT NULL,
    PRIMARY KEY (`studyname`),
    UNIQUE KEY `id` (`id`),
    CONSTRAINT `FK_STUDY_META_studyname` FOREIGN KEY (`studyname`) REFERENCES `study` (`name`),
    CONSTRAINT `STUDY_META_ibfk_1` FOREIGN KEY (`studyname`) REFERENCES `study` (`name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Table structure for table `Samples`
  --
  
  DROP TABLE IF EXISTS `Samples`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `Samples` (
    `ID` bigint(20) NOT NULL AUTO_INCREMENT,
    `DATAADMINSTRATOR` longblob,
    `DESCRIPTION` varchar(1024) DEFAULT NULL,
    `DIAGNOSIS` longblob,
    `ENGLISHNAME` varchar(512) DEFAULT NULL,
    `LASTUPDATED` datetime DEFAULT NULL,
    `ORGANIZATION` varchar(512) DEFAULT NULL,
    `OTHERINFORMATION` varchar(1024) DEFAULT NULL,
    `RESPONSIBLE` varchar(512) DEFAULT NULL,
    `SAMPLECOLLECTION` longblob,
    `SAMPLEDONORS` longblob,
    `SAMPLES` longblob,
    `STUDY` longblob,
    `SWEDISHNAME` varchar(512) DEFAULT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  