add b137 schema changes for the human tables

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

diff --git a/schema/human_9606_schema/human_9606_index.sql b/schema/human_9606_schema/human_9606_index.sql
index c935c662f03365e1eb3d2b27dc7709b16260e462..27bf6fc8d335900d287c2093352683ef1a6cfe61 100644 (file)
--- a/schema/human_9606_schema/human_9606_index.sql
+++ b/schema/human_9606_schema/human_9606_index.sql
@@ -55,9 +55,7 @@ GO
 CREATE NONCLUSTERED INDEX [i_handle_loc_pop_id] ON [Population] ([handle] ASC,[loc_pop_id] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_rsL] ON [RsMergeArch] ([rsLow] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_rsH] ON [RsMergeArch] ([rsHigh] ASC)\r
+CREATE NONCLUSTERED INDEX [ndx_RsMergeArch_HI] ON [RsMergeArch] ([rsHigh] ASC)\r
 GO
 
 CREATE CLUSTERED INDEX [i_rs] ON [SNP] ([snp_id] ASC)\r
@@ -71,6 +69,8 @@ GO
 
 
 
+CREATE CLUSTERED INDEX [i_rs_hgvs] ON [SNPClinSig] ([hgvs_g] ASC,[snp_id] ASC)\r
+GO
 
 
 
@@ -143,6 +143,8 @@ CREATE NONCLUSTERED INDEX [i_bid_ss] ON [SubSNP] ([batch_id] ASC,[subsnp_id] ASC
 GO
 CREATE NONCLUSTERED INDEX [i_var] ON [SubSNP] ([variation_id] ASC,[subsnp_id] ASC)\r
 GO
+CREATE NONCLUSTERED INDEX [i_ss_bid_loc] ON [SubSNP] ([subsnp_id] ASC,[batch_id] ASC,[loc_snp_id] ASC)\r
+GO
 
 CREATE NONCLUSTERED INDEX [i_acc_part_ind] ON [SubSNPAcc_ins] ([acc_part] ASC,[acc_type_ind] ASC,[subsnp_id] ASC)\r
 GO
@@ -168,65 +170,38 @@ CREATE NONCLUSTERED INDEX [i_ind] ON [SubmittedIndividual] ([ind_id] ASC)
 GO
 
 
-CREATE NONCLUSTERED INDEX [i_asm] ON [b135_ContigInfo_37_3] ([asm_acc] ASC,[asm_version] ASC,[contig_start] ASC,[contig_end] ASC,[chr_gi] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_asm_chr_ctg] ON [b135_ContigInfo_37_3] ([asm_acc] ASC,[asm_version] ASC,[chr_gi] ASC,[contig_start] ASC,[contig_end] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [idxContigLabel] ON [b135_ContigInfo_37_3] ([contig_label] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [ndx_ContigInfo_pc_37_3] ON [b135_ContigInfo_37_3] ([placement_status] ASC,[ctg_id] ASC)\r
-GO
-
 
-CREATE CLUSTERED INDEX [i_gi] ON [b135_MapLinkInfo_37_3] ([gi] ASC)\r
+CREATE NONCLUSTERED INDEX [i_asm_chr_ctg] ON [b137_ContigInfo] ([asm_acc] ASC,[asm_version] ASC,[chr_gi] ASC,[contig_start] ASC,[contig_end] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_rs_gi_pos] ON [b135_MapLink_37_3] ([snp_id] ASC,[gi] ASC,[offset] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_src] ON [b135_MapLink_37_3] ([source] ASC,[snp_type] ASC,[snp_id] ASC,[gi] ASC,[offset] ASC,[asn_to] ASC)\r
+CREATE CLUSTERED INDEX [i_rs_gi_pos] ON [b137_MapLink] ([snp_id] ASC,[gi] ASC,[offset] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_gi] ON [b135_ProteinInfo_37_3] ([gi] ASC)\r
-GO
 
-CREATE CLUSTERED INDEX [i_rs_pos] ON [b135_Remapped_37_3] ([snp_id] ASC,[src_gi] ASC,[src_from] ASC,[tgt_gi] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_tgt_gi] ON [b135_Remapped_37_3] ([tgt_gi] ASC,[snp_type] ASC,[snp_id] ASC)\r
+CREATE CLUSTERED INDEX [i_gi] ON [b137_MapLinkInfo] ([gi] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_rs] ON [b135_SNPChrPosOnRef_37_3] ([snp_id] ASC)\r
+CREATE CLUSTERED INDEX [i_gi] ON [b137_ProteinInfo] ([gi] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_rs] ON [b135_SNPContigLoc_37_3] ([snp_id] ASC,[ctg_id] ASC,[asn_from] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_ctg] ON [b135_SNPContigLoc_37_3] ([ctg_id] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_snp] ON [b135_SNPContigLoc_37_3] ([snp_type] ASC,[snp_id] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [idxAsnFrom] ON [b135_SNPContigLoc_37_3] ([asn_from] ASC)\r
-GO
 
-CREATE CLUSTERED INDEX [i_rsCtgMrna] ON [b135_SNPContigLocusId_37_3] ([snp_id] ASC,[contig_acc] ASC,[asn_from] ASC,[locus_id] ASC,[allele] ASC,[mrna_start] ASC,[mrna_gi] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_rs] ON [b135_SNPContigLocusId_37_3] ([snp_id] ASC)\r
+CREATE CLUSTERED INDEX [i_rs] ON [b137_SNPChrPosOnRef] ([snp_id] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_rs_gi] ON [b135_SNPContigProtein_37_3] ([snp_id] ASC,[contig_gi] ASC,[contig_start] ASC)\r
+CREATE NONCLUSTERED INDEX [i_pos] ON [b137_SNPContigLoc] ([ctg_id] ASC,[asn_from] ASC,[snp_id] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_rs_asm] ON [b135_SNPMapInfo_37_3] ([snp_id] ASC,[asm_acc] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_asm] ON [b135_SNPMapInfo_37_3] ([asm_acc] ASC,[asm_version] ASC)\r
+CREATE CLUSTERED INDEX [i_rsCtgMrna] ON [b137_SNPContigLocusId] ([snp_id] ASC,[contig_acc] ASC,[asn_from] ASC,[locus_id] ASC,[allele] ASC,[mrna_start] ASC,[mrna_gi] ASC)\r
 GO
-CREATE NONCLUSTERED INDEX [iuc_rs_assembly_37_3] ON [b135_SNPMapInfo_37_3] ([asm_acc] ASC,[weight] ASC,[snp_id] ASC)\r
+CREATE NONCLUSTERED INDEX [i_rs] ON [b137_SNPContigLocusId] ([snp_id] ASC)\r
 GO
 
-CREATE CLUSTERED INDEX [i_rs_pos] ON [b135_SNPMapLinkProtein_37_3] ([snp_id] ASC,[mrna_gi] ASC,[mrna_start] ASC,[mrna_stop] ASC)\r
-GO
-CREATE NONCLUSTERED INDEX [i_ctg] ON [b135_SNPMapLinkProtein_37_3] ([ctg_gi] ASC,[mrna_gi] ASC,[snp_id] ASC)\r
+
+CREATE CLUSTERED INDEX [i_rs_asm] ON [b137_SNPMapInfo] ([snp_id] ASC,[asm_acc] ASC)\r
 GO
 
 
+
 CREATE CLUSTERED INDEX [i_pid] ON [dn_IND_batch_pop] ([pop_id] ASC)\r
 GO