add b137 schema changes for the human tables

[dbsnp.git] / schema / human_9606_schema / human_9606_index_postgresql.sql

diff --git a/schema/human_9606_schema/human_9606_index_postgresql.sql b/schema/human_9606_schema/human_9606_index_postgresql.sql
index 2dd804a00e298aa74ee9bfbf92693d88c1dd2daa..7d63ac411ae20f0e8c2ed9bda14a756a7ba29faf 100644 (file)
--- a/schema/human_9606_schema/human_9606_index_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_index_postgresql.sql
@@ -16,11 +16,11 @@ CREATE INDEX ON PedigreeIndividual (ind_id,ped_id);
 CREATE INDEX ON PopMandLine (pop_id,line_num);
 CREATE INDEX ON Population (handle,loc_pop_id_upp);
 CREATE INDEX ON Population (handle,loc_pop_id);
-CREATE INDEX ON RsMergeArch (rsLow);
 CREATE INDEX ON RsMergeArch (rsHigh);
 CREATE INDEX ON SNP (snp_id);
 CREATE INDEX ON SNP (exemplar_subsnp_id,snp_id);
 CREATE INDEX ON SNP3D (snp_id);
+CREATE INDEX ON SNPClinSig (hgvs_g,snp_id);
 CREATE INDEX ON SNPHistory (history_create_time);
 CREATE INDEX ON SNPPubmed (snp_id,subsnp_id,pubmed_id,type);
 CREATE INDEX ON SNPSubSNPLink (subsnp_id);
@@ -50,33 +50,20 @@ CREATE INDEX ON SubPopGty (gty_id);
 CREATE INDEX ON SubSNP (loc_snp_id_upp,subsnp_id);
 CREATE INDEX ON SubSNP (batch_id,subsnp_id);
 CREATE INDEX ON SubSNP (variation_id,subsnp_id);
+CREATE INDEX ON SubSNP (subsnp_id,batch_id,loc_snp_id);
 CREATE INDEX ON SubSNPAcc_ins (acc_part,acc_type_ind,subsnp_id);
 CREATE INDEX ON SubSNPMdFailLn (subsnp_id);
 CREATE INDEX ON SubSNPPubmed (pubmed_id);
 CREATE INDEX ON SubmittedIndividual (submitted_ind_id);
 CREATE INDEX ON SubmittedIndividual (ind_id);
-CREATE INDEX ON b135_ContigInfo_37_3 (asm_acc,asm_version,contig_start,contig_end,chr_gi);
-CREATE INDEX ON b135_ContigInfo_37_3 (asm_acc,asm_version,chr_gi,contig_start,contig_end);
-CREATE INDEX ON b135_ContigInfo_37_3 (contig_label);
-CREATE INDEX ON b135_ContigInfo_37_3 (placement_status,ctg_id);
-CREATE INDEX ON b135_MapLinkInfo_37_3 (gi);
-CREATE INDEX ON b135_MapLink_37_3 (snp_id,gi,offset);
-CREATE INDEX ON b135_MapLink_37_3 (source,snp_type,snp_id,gi,offset,asn_to);
-CREATE INDEX ON b135_ProteinInfo_37_3 (gi);
-CREATE INDEX ON b135_Remapped_37_3 (snp_id,src_gi,src_from,tgt_gi);
-CREATE INDEX ON b135_Remapped_37_3 (tgt_gi,snp_type,snp_id);
-CREATE INDEX ON b135_SNPChrPosOnRef_37_3 (snp_id);
-CREATE INDEX ON b135_SNPContigLoc_37_3 (snp_id,ctg_id,asn_from);
-CREATE INDEX ON b135_SNPContigLoc_37_3 (ctg_id);
-CREATE INDEX ON b135_SNPContigLoc_37_3 (snp_type,snp_id);
-CREATE INDEX ON b135_SNPContigLoc_37_3 (asn_from);
-CREATE INDEX ON b135_SNPContigLocusId_37_3 (snp_id,contig_acc,asn_from,locus_id,allele,mrna_start,mrna_gi);
-CREATE INDEX ON b135_SNPContigLocusId_37_3 (snp_id);
-CREATE INDEX ON b135_SNPContigProtein_37_3 (snp_id,contig_gi,contig_start);
-CREATE INDEX ON b135_SNPMapInfo_37_3 (snp_id,asm_acc);
-CREATE INDEX ON b135_SNPMapInfo_37_3 (asm_acc,asm_version);
-CREATE INDEX ON b135_SNPMapInfo_37_3 (asm_acc,weight,snp_id);
-CREATE INDEX ON b135_SNPMapLinkProtein_37_3 (snp_id,mrna_gi,mrna_start,mrna_stop);
-CREATE INDEX ON b135_SNPMapLinkProtein_37_3 (ctg_gi,mrna_gi,snp_id);
+CREATE INDEX ON b137_ContigInfo (asm_acc,asm_version,chr_gi,contig_start,contig_end);
+CREATE INDEX ON b137_MapLink (snp_id,gi,offset);
+CREATE INDEX ON b137_MapLinkInfo (gi);
+CREATE INDEX ON b137_ProteinInfo (gi);
+CREATE INDEX ON b137_SNPChrPosOnRef (snp_id);
+CREATE INDEX ON b137_SNPContigLoc (ctg_id,asn_from,snp_id);
+CREATE INDEX ON b137_SNPContigLocusId (snp_id,contig_acc,asn_from,locus_id,allele,mrna_start,mrna_gi);
+CREATE INDEX ON b137_SNPContigLocusId (snp_id);
+CREATE INDEX ON b137_SNPMapInfo (snp_id,asm_acc);
 CREATE INDEX ON dn_IND_batch_pop (pop_id);
 CREATE INDEX ON dn_table_rowcount (build_id DESC,reserved_KB_spaceused DESC);