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


CREATE TABLE experiment (
  experiment_id          INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  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_sra_acc_idx  (experiment_sra_acc),
  UNIQUE KEY                  (experiment_id, experiment_sra_acc)
) ENGINE=MyISAM;

/**

  date                   DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  status                 BOOLEAN DEFAULT True,
  
  KEY run_id_idx              (run_id),
  KEY run_experiment_id_idx   (experiment_id),
  KEY run_sra_acc_idx         (run_sra_acc),
  UNIQUE KEY                  (run_id, experiment_id, run_sra_acc)
) ENGINE=MyISAM;


