update to build 135 schema

[dbsnp.git] / schema / shared_schema / dbSNP_main_index_postgresql.sql

diff --git a/schema/shared_schema/dbSNP_main_index_postgresql.sql b/schema/shared_schema/dbSNP_main_index_postgresql.sql
index e503a6a76175037719140db36941edd83aa27265..4162f20f9452a72ba458f0e1081e0f516b10c811 100644 (file)
--- a/schema/shared_schema/dbSNP_main_index_postgresql.sql
+++ b/schema/shared_schema/dbSNP_main_index_postgresql.sql
@@ -1,129 +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 "db_DataDictionaryNew"("tab", "col_order")
-;
-
-
-
-
-
-
-
-
-
- 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);