   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),
-  strain_id                 INT(10) UNSIGNED NOT NULL,
   label                     TEXT,
   metasum                   CHAR(32) UNIQUE,
   date                      TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,


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,

@desc Where all metadata about the files are stored.

@column file_id                File id (primary key, internal identifier).
@column track_id               Track primary id (foreign key).
@column path                   Path of the file.
@column type                   File type (fastq, bam...).
@column md5                    md5 checksum of the file.
