1 CREATE UNIQUE INDEX ON "Allele"("allele")
3 CREATE INDEX ON "Allele"("rev_allele_id")
7 CREATE INDEX ON "AlleleMotif"("motif_id")
10 CREATE UNIQUE INDEX ON "AllocIds"("name")
13 CREATE INDEX ON "Author"("author")
16 CREATE UNIQUE INDEX ON "Batch_tax_id"("batch_id")
24 CREATE INDEX ON "GtyAllele"("unigty_id")
26 CREATE INDEX ON "GtyAllele"("gty_id")
28 CREATE INDEX ON "GtyAllele"("gty_id")
32 CREATE INDEX ON "LoadHistory"("loaddate")
37 CREATE UNIQUE INDEX ON "Method"("handle", "loc_method_id")
43 CREATE UNIQUE INDEX ON "Motif"("motif")
46 CREATE INDEX ON "ObsGenotype"("obs")
48 CREATE INDEX ON "ObsGenotype"("obs_upp_fix")
50 CREATE INDEX ON "ObsGenotype"("gty_id")
53 CREATE UNIQUE INDEX ON "ObsVariation"("pattern")
55 CREATE INDEX ON "ObsVariation"("univar_id")
59 CREATE UNIQUE INDEX ON "OrganismTax"("organism")
61 CREATE INDEX ON "OrganismTax"("tax_id")
63 CREATE INDEX ON "OrganismTax"("species_tax_id")
65 CREATE INDEX ON "OrganismTax"("database_name")
70 CREATE UNIQUE INDEX ON "Publication"("handle", "title")
74 CREATE INDEX ON "SNP_tax_id"("tax_id", "snp_id")
80 CREATE UNIQUE INDEX ON "SnpValidationCode"("code")
83 CREATE INDEX ON "StrandCode"("abbrev", "rs_to_ss_orien", "code")
86 CREATE UNIQUE INDEX ON "SubSNPDelComm"("comment_id")
90 CREATE UNIQUE INDEX ON "Submitter"("handle")
92 CREATE INDEX ON "Submitter"("name")
96 CREATE UNIQUE INDEX ON "UniGty"("gty_str")
98 CREATE UNIQUE INDEX ON "UniGty"("allele_id_1", "allele_id_2")
100 CREATE INDEX ON "UniGty"("allele_id_2")
103 CREATE INDEX ON "UniVariAllele"("allele_id")
106 CREATE UNIQUE INDEX ON "UniVariation"("var_str")
108 CREATE INDEX ON "UniVariation"("univar_id", "subsnp_class")
112 CREATE INDEX ON "VariAllele"("allele_id")
115 CREATE UNIQUE INDEX ON "db_DataDictionaryNew"("tab", "col_order")
126 CREATE UNIQUE INDEX ON "dn_gty2unigty_trueSNP"("gty_id", "rev_flag")