    `description`            VARCHAR(255)          DEFAULT NULL,
    `name`                   VARCHAR(100)          DEFAULT NULL,
    `primary_design_type`    VARCHAR(30)           DEFAULT NULL,
+   `archive_id`             varchar(60)           DEFAULT NULL,
+   `display_url`            varchar(255)          DEFAULT NULL,
    PRIMARY KEY  (`experiment_id`),
    UNIQUE KEY `name_idx` (`name`),
    KEY `design_idx` (`primary_design_type`),


-- Update and remove these for each release to avoid erroneous patching
INSERT INTO meta (species_id, meta_key, meta_value) VALUES (NULL, 'schema_version', '76');
INSERT INTO meta (species_id, meta_key, meta_value) VALUES (NULL, 'patch_75_76_a.sql|schema_version')
INSERT INTO meta (species_id, meta_key, meta_value) VALUES (NULL, 'patch_75_76_b.sql|result/feature_set.experiment_id & experiment/input_subset.display_url/archive_id')
INSERT INTO meta (species_id, meta_key, meta_value) VALUES (NULL, 'patch_75_76_c.sql|cell_type.display_label')
INSERT INTO meta (species_id, meta_key, meta_value) VALUES (NULL, 'patch_75_76_d.sql|feature_set.type mirna; object_xref.ensembl_object_type add MirnaTargetFeature')
INSERT INTO meta (species_id, meta_key, meta_value) VALUES (NULL, 'patch_75_76_e.sql|add has_evidence, cell_type_count to regulatory_feature, adjust UNIQUE constraint')
INSERT INTO meta (species_id, meta_key, meta_value) VALUES (NULL, 'patch_75_76_f.sql|add feature_type.class Transcription Start Site')



/**


DROP TABLE IF EXISTS `result_set`;
CREATE TABLE `result_set` (
   `result_set_id`    int(10) unsigned NOT NULL auto_increment,
   `analysis_id`      smallint(5) unsigned NOT NULL,
   `name`             varchar(100) default NULL,
   `cell_type_id`     int(10) unsigned default NULL,
   `feature_type_id`  int(10) unsigned default NULL,
   `feature_class`    enum('result', 'dna_methylation') DEFAULT NULL,
   `replicate`        tinyint(3) unsigned NOT NULL,
   `experiment_id`    int(10) unsigned default NULL,
   PRIMARY KEY  (`result_set_id`),
   UNIQUE KEY `name_idx` (`name`),
   KEY cell_type_idx (cell_type_id),
   KEY feature_type_idx (feature_type_id),
   KEY analysis_idx (analysis_id),
   KEY feature_class_idx (feature_class),
   KEY experiment_idx (experiment_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


