X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fshared_schema%2FdbSNP_main_index_postgresql.sql;h=4162f20f9452a72ba458f0e1081e0f516b10c811;hb=77ec8a32a887e1eb6364f327f55049cae8e69f95;hp=0bca28e74faed1e13abb5a730a38eb5039a23d66;hpb=6e51d2d339036d36e6294b1bbed27e5c18a6a2f5;p=dbsnp.git

diff --git a/schema/shared_schema/dbSNP_main_index_postgresql.sql b/schema/shared_schema/dbSNP_main_index_postgresql.sql
index 0bca28e..4162f20 100644
--- a/schema/shared_schema/dbSNP_main_index_postgresql.sql
+++ b/schema/shared_schema/dbSNP_main_index_postgresql.sql
@@ -1,126 +1,36 @@
- 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)
-;
-
-
+CREATE INDEX ON Allele (allele);
+CREATE INDEX ON Allele (rev_allele_id);
+CREATE INDEX ON AlleleMotif (motif_id);
+CREATE INDEX ON AllocIds (name);
+CREATE INDEX ON Author (author);
+CREATE 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 INDEX ON Method (handle ASC,loc_method_id);
+CREATE INDEX ON Motif (motif);
+CREATE INDEX ON ObsGenotype (obs);
+CREATE INDEX ON ObsGenotype (obs_upp_fix);
+CREATE INDEX ON ObsGenotype (gty_id);
+CREATE INDEX ON ObsVariation (pattern);
+CREATE INDEX ON ObsVariation (univar_id);
+CREATE INDEX ON OrganismTax (organism);
+CREATE INDEX ON OrganismTax (tax_id);
+CREATE INDEX ON OrganismTax (species_tax_id);
+CREATE INDEX ON OrganismTax (database_name);
+CREATE INDEX ON Publication (handle ASC,title);
+CREATE INDEX ON SNP_tax_id (tax_id ASC,snp_id);
+CREATE INDEX ON SnpValidationCode (code);
+CREATE INDEX ON StrandCode (abbrev ASC,rs_to_ss_orien ASC,code);
+CREATE INDEX ON SubSNPDelComm (comment_id);
+CREATE INDEX ON Submitter (handle);
+CREATE INDEX ON Submitter (name);
+CREATE INDEX ON UniGty (gty_str);
+CREATE INDEX ON UniGty (allele_id_1 ASC,allele_id_2);
+CREATE INDEX ON UniGty (allele_id_2);
+CREATE INDEX ON UniVariAllele (allele_id);
+CREATE INDEX ON UniVariation (var_str);
+CREATE INDEX ON UniVariation (univar_id ASC,subsnp_class);
+CREATE INDEX ON VariAllele (allele_id);
+CREATE INDEX ON dn_gty2unigty_trueSNP (gty_id ASC,rev_flag);