 
 CREATE TABLE file (
   file_id               INT(10) UNSIGNED NOT NULL UNIQUE AUTO_INCREMENT PRIMARY KEY,
+  track_id              INT(10) UNSIGNED NOT NULL,
   path                  TEXT NOT NULL,
   type                  ENUM('fastq', 'bam', 'bai', 'bed', 'bigwig'),
   md5                   CHAR(32),


CREATE TABLE strain (
  strain_id                 INT(10) UNSIGNED NOT NULL UNIQUE AUTO_INCREMENT PRIMARY KEY,
  species_id                INT(10) UNSIGNED,
  production_name           VARCHAR(64) NOT NULL,
  strain                    VARCHAR(32),
  metasum                   CHAR(32) UNIQUE,

  description               TEXT,
  taxon_id                  INT(10) UNSIGNED,
  strain                    TEXT,
  strain_id                 INT(10) UNSIGNED NOT NULL,
  biosample_acc             VARCHAR(15) UNIQUE,
  biosample_group_acc       VARCHAR(15),
  label                     TEXT,
  metasum                   CHAR(32) UNIQUE,
  date                      TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
