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 0bca28e74faed1e13abb5a730a38eb5039a23d66..4162f20f9452a72ba458f0e1081e0f516b10c811 100644 (file)
--- 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)\r
-;\r
- CREATE  INDEX ON Allele(rev_allele_id)\r
-;\r
-\r
-\r
- CREATE  INDEX ON AlleleMotif(motif_id)\r
-;\r
-\r
- CREATE  UNIQUE    INDEX ON AllocIds(name)\r
-;\r
-\r
- CREATE  INDEX ON Author(author)\r
-;\r
-\r
- CREATE  UNIQUE    INDEX ON Batch_tax_id(batch_id)\r
-;\r
-\r
-\r
-\r
-\r
-\r
-\r
- CREATE  INDEX ON GtyAllele(unigty_id)\r
-;\r
- CREATE  INDEX ON GtyAllele(gty_id)\r
-;\r
- CREATE  INDEX ON GtyAllele(gty_id)\r
-;\r
-\r
-\r
- CREATE  INDEX ON LoadHistory(loaddate)\r
-;\r
-\r
-\r
-\r
- CREATE  UNIQUE  INDEX ON Method(handle, loc_method_id)\r
-;\r
-\r
-\r
-\r
-\r
- CREATE  UNIQUE  INDEX ON Motif(motif)\r
-;\r
-\r
- CREATE  INDEX ON ObsGenotype(obs)\r
-;\r
- CREATE  INDEX ON ObsGenotype(obs_upp_fix)\r
-;\r
- CREATE  INDEX ON ObsGenotype(gty_id)\r
-;\r
-\r
- CREATE  UNIQUE  INDEX ON ObsVariation(pattern)\r
-;\r
- CREATE  INDEX ON ObsVariation(univar_id)\r
-;\r
-\r
-\r
- CREATE  UNIQUE    INDEX ON OrganismTax(organism)\r
-;\r
- CREATE  INDEX ON OrganismTax(tax_id)\r
-;\r
- CREATE  INDEX ON OrganismTax(species_tax_id)\r
-;\r
- CREATE  INDEX ON OrganismTax(database_name)\r
-;\r
-\r
-\r
-\r
- CREATE  UNIQUE    INDEX ON Publication(handle, title)\r
-;\r
-\r
-\r
- CREATE  INDEX ON SNP_tax_id(tax_id, snp_id)\r
-;\r
-\r
-\r
-\r
-\r
- CREATE  UNIQUE    INDEX ON SnpValidationCode(code)\r
-;\r
-\r
- CREATE  INDEX ON StrandCode(abbrev, rs_to_ss_orien, code)\r
-;\r
-\r
- CREATE  UNIQUE    INDEX ON SubSNPDelComm(comment_id)\r
-;\r
-\r
-\r
- CREATE  UNIQUE    INDEX ON Submitter(handle)\r
-;\r
- CREATE  INDEX ON Submitter(name)\r
-;\r
-\r
-\r
- CREATE  UNIQUE  INDEX ON UniGty(gty_str)\r
-;\r
- CREATE  UNIQUE  INDEX ON UniGty(allele_id_1, allele_id_2)\r
-;\r
- CREATE  INDEX ON UniGty(allele_id_2)\r
-;\r
-\r
- CREATE  INDEX ON UniVariAllele(allele_id)\r
-;\r
-\r
- CREATE  UNIQUE  INDEX ON UniVariation(var_str)\r
-;\r
- CREATE  INDEX ON UniVariation(univar_id, subsnp_class)\r
-;\r
-\r
-\r
- CREATE  INDEX ON VariAllele(allele_id)\r
-;\r
-\r
-\r
-\r
-\r
-\r
-\r
-\r
-\r
-\r
- CREATE  UNIQUE    INDEX ON dn_gty2unigty_trueSNP(gty_id, rev_flag)\r
-;\r
-\r
-\r
+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);