 
 CREATE TABLE run (
   run_id                 INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
+  experiment_id          INT(10),
   run_sra_acc            CHAR(9) NOT NULL,
   title                  TEXT,
   submitter              TEXT,

  
  KEY analysis_param_id_idx            (analysis_param_id),
  KEY analysis_param_analysis_id_idx   (analysis_id),
  UNIQUE KEY                           (analysis_param_id)
) ENGINE=MyISAM;




CREATE TABLE experiment (
  experiment_id          INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  study_id               INT(10),
  experiment_sra_acc     CHAR(9) NOT NULL,
  title                  TEXT,
  metasum                CHAR(32),
  date                   DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  status                 BOOLEAN DEFAULT True,
  
  KEY experiment_id_idx            (experiment_id),
  KEY experiment_study_id_idx      (study_id),
  KEY experiment_sra_acc_idx       (experiment_sra_acc),
  UNIQUE KEY                       (experiment_id, study_id, experiment_sra_acc)
) ENGINE=MyISAM;

/**
