X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fshared_schema%2FdbSNP_main_index_postgresql.sql;fp=schema%2Fshared_schema%2FdbSNP_main_index_postgresql.sql;h=311c7fd2230868617e8487050b006c26539f552c;hb=2463fb6da871eef907dccadc3423931b9180a9a1;hp=4162f20f9452a72ba458f0e1081e0f516b10c811;hpb=ce0a637afd7f53101cc1c53c6d853814cf477bac;p=dbsnp.git

diff --git a/schema/shared_schema/dbSNP_main_index_postgresql.sql b/schema/shared_schema/dbSNP_main_index_postgresql.sql
index 4162f20..311c7fd 100644
--- a/schema/shared_schema/dbSNP_main_index_postgresql.sql
+++ b/schema/shared_schema/dbSNP_main_index_postgresql.sql
@@ -8,7 +8,7 @@ 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 Method (handle,loc_method_id);
 CREATE INDEX ON Motif (motif);
 CREATE INDEX ON ObsGenotype (obs);
 CREATE INDEX ON ObsGenotype (obs_upp_fix);
@@ -19,18 +19,18 @@ 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 Publication (handle,title);
+CREATE INDEX ON SNP_tax_id (tax_id,snp_id);
 CREATE INDEX ON SnpValidationCode (code);
-CREATE INDEX ON StrandCode (abbrev ASC,rs_to_ss_orien ASC,code);
+CREATE INDEX ON StrandCode (abbrev,rs_to_ss_orien,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_1,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 UniVariation (univar_id,subsnp_class);
 CREATE INDEX ON VariAllele (allele_id);
-CREATE INDEX ON dn_gty2unigty_trueSNP (gty_id ASC,rev_flag);
+CREATE INDEX ON dn_gty2unigty_trueSNP (gty_id,rev_flag);