 CREATE  UNIQUE  INDEX ON Allele(allele)
;
 CREATE  INDEX ON Allele(rev_allele_id)
;


 CREATE  INDEX ON AlleleMotif(motif_id)
;

 CREATE  UNIQUE    INDEX ON AllocIds(name)
;

 CREATE  INDEX ON Author(author)
;

 CREATE  UNIQUE    INDEX ON Batch_tax_id(batch_id)
;






 CREATE  INDEX ON GtyAllele(unigty_id)
;
 CREATE  INDEX ON GtyAllele(gty_id)
;
 CREATE  INDEX ON GtyAllele(gty_id)
;


 CREATE  INDEX ON LoadHistory(loaddate)
;



 CREATE  UNIQUE  INDEX ON Method(handle, loc_method_id)
;




 CREATE  UNIQUE  INDEX ON Motif(motif)
;

 CREATE  INDEX ON ObsGenotype(obs)
;
 CREATE  INDEX ON ObsGenotype(obs_upp_fix)
;
 CREATE  INDEX ON ObsGenotype(gty_id)
;

 CREATE  UNIQUE  INDEX ON ObsVariation(pattern)
;
 CREATE  INDEX ON ObsVariation(univar_id)
;


 CREATE  UNIQUE    INDEX ON OrganismTax(organism)
;
 CREATE  INDEX ON OrganismTax(tax_id)
;
 CREATE  INDEX ON OrganismTax(species_tax_id)
;
 CREATE  INDEX ON OrganismTax(database_name)
;



 CREATE  UNIQUE    INDEX ON Publication(handle, title)
;


 CREATE  INDEX ON SNP_tax_id(tax_id, snp_id)
;




 CREATE  UNIQUE    INDEX ON SnpValidationCode(code)
;

 CREATE  INDEX ON StrandCode(abbrev, rs_to_ss_orien, code)
;

 CREATE  UNIQUE    INDEX ON SubSNPDelComm(comment_id)
;


 CREATE  UNIQUE    INDEX ON Submitter(handle)
;
 CREATE  INDEX ON Submitter(name)
;


 CREATE  UNIQUE  INDEX ON UniGty(gty_str)
;
 CREATE  UNIQUE  INDEX ON UniGty(allele_id_1, allele_id_2)
;
 CREATE  INDEX ON UniGty(allele_id_2)
;

 CREATE  INDEX ON UniVariAllele(allele_id)
;

 CREATE  UNIQUE  INDEX ON UniVariation(var_str)
;
 CREATE  INDEX ON UniVariation(univar_id, subsnp_class)
;


 CREATE  INDEX ON VariAllele(allele_id)
;









 CREATE  UNIQUE    INDEX ON dn_gty2unigty_trueSNP(gty_id, rev_flag)
;


