 @see associcated_group
 @see xref
 */
-
+DROP TABLE IF EXISTS `associated_xref`;
 CREATE TABLE `associated_xref` (
   `associated_xref_id`  int(10)       unsigned NOT NULL AUTO_INCREMENT,
   `object_xref_id`      int(10)       unsigned NOT NULL DEFAULT '0',

   `description`            VARCHAR(255)          DEFAULT NULL,
   `name`                   VARCHAR(100)          DEFAULT NULL,
   `primary_design_type`    VARCHAR(30)           DEFAULT NULL,
   PRIMARY KEY  (`experiment_id`),
   UNIQUE KEY `name_idx` (`name`),
   KEY `design_idx` (`primary_design_type`),

  KEY `feature_type_idx` (`feature_type_id`),
  KEY `feature_set_idx` (`feature_set_id`),
  KEY `seq_region_idx` (`seq_region_id`,`seq_region_start`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


/**
