update to build 135 schema

[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 0c7f146127d89c78ece91dd03b57a8f71ce14b56..2dd804a00e298aa74ee9bfbf92693d88c1dd2daa 100644 (file)
--- a/schema/human_9606_schema/human_9606_index_postgresql.sql
+++ b/schema/human_9606_schema/human_9606_index_postgresql.sql
@@ -1,212 +1,82 @@
 
- CREATE  INDEX ON Batch(tax_id)
-;
- CREATE  INDEX ON Batch(submitted_time)
-;
- CREATE  INDEX ON Batch(handle, loc_batch_id)
-;
- CREATE  INDEX ON Batch(pop_id)
-;
- CREATE  INDEX ON Batch(success_rate_int)
-;
- CREATE  INDEX ON Batch(method_id)
-;
- CREATE  INDEX ON Batch(loc_batch_id_upp)
-;
- CREATE  INDEX ON Batch(last_updated_time)
-;
-
- CREATE  INDEX ON BatchCita(pub_id)
-;
-
-
- CREATE  INDEX ON BatchCultivar(line)
-;
-
-
- CREATE  INDEX ON BatchStrain(line)
-;
-
-
-
-
-
-
-
-
-
-
-
- CREATE  UNIQUE  INDEX ON Pedigree(curator, curator_ped_id)
-;
-
- CREATE  UNIQUE  INDEX ON PedigreeIndividual(ind_id, ped_id)
-;
-
-
- CREATE  UNIQUE    INDEX ON PopMandLine(pop_id, line_num)
-;
-
- CREATE  UNIQUE  INDEX ON Population(handle, loc_pop_id_upp)
-;
- CREATE  UNIQUE  INDEX ON Population(handle, loc_pop_id)
-;
-
-
- CREATE  UNIQUE    INDEX ON SNP(snp_id)
-;
- CREATE  INDEX ON SNP(exemplar_subsnp_id, snp_id)
-;
-
- CREATE  INDEX ON SNP3D(snp_id)
-;
-
-
-
-
-
- CREATE  INDEX ON SNPHistory(history_create_time)
-;
-
-
- CREATE  UNIQUE    INDEX ON SNPSubSNPLink(subsnp_id)
-;
- CREATE  INDEX ON SNPSubSNPLink(snp_id, subsnp_id, substrand_reversed_flag)
-;
-
- CREATE    INDEX ON SNPSubSNPLinkHistory(snp_id)
-;
- CREATE  UNIQUE  INDEX ON SNPSubSNPLinkHistory(subsnp_id, snp_id)
-;
- CREATE  INDEX ON SNPSubSNPLinkHistory(build_id)
-;
- CREATE  INDEX ON SNPSubSNPLinkHistory(build_id_when_history_made)
-;
-
- CREATE  INDEX ON SNPVal(snp_id)
-;
-
- CREATE  UNIQUE    INDEX ON SNP_HGVS(snp_id, hgvs_name)
-;
-
- CREATE  INDEX ON SNP_bitfield(link_prop_b2)
-;
-
- CREATE  INDEX ON SubPop(subsnp_id)
-;
- CREATE  INDEX ON SubPop(pop_id, subsnp_id)
-;
- CREATE  INDEX ON SubPop(subpop_id)
-;
-
- CREATE  UNIQUE    INDEX ON SubPopAllele(batch_id, pop_id, subsnp_id, type, allele, other)
-;
- CREATE  INDEX ON SubPopAllele(freq)
-;
- CREATE  INDEX ON SubPopAllele(freq_max)
-;
- CREATE  INDEX ON SubPopAllele(freq_min)
-;
- CREATE  INDEX ON SubPopAllele(subsnp_id)
-;
- CREATE  INDEX ON SubPopAllele(type)
-;
- CREATE  INDEX ON SubPopAllele(last_updated_time)
-;
- CREATE  INDEX ON SubPopAllele(allele_id)
-;
- CREATE  INDEX ON SubPopAllele(subpop_id)
-;
- CREATE  UNIQUE  INDEX ON SubPopAllele(subpop_id, type, allele, other)
-;
-
- CREATE  INDEX ON SubPopGty(subpop_id)
-;
- 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 SubSNPAcc_ins(acc_part, acc_type_ind, subsnp_id)
-;
-
-
-
-
- CREATE  INDEX ON SubSNPMdFailLn(subsnp_id)
-;
-
-
-
- CREATE  INDEX ON SubSNPPubmed(pubmed_id)
-;
-
-
-
-
-
- CREATE  UNIQUE  INDEX ON SubmittedIndividual(submitted_ind_id)
-;
- CREATE  INDEX ON SubmittedIndividual(ind_id)
-;
-
-
- CREATE  UNIQUE  INDEX ON b132_ContigInfo_37_1(contig_name)
-;
- CREATE  INDEX ON b132_ContigInfo_37_1(contig_label)
-;
- CREATE  INDEX ON b132_ContigInfo_37_1(group_term)
-;
- CREATE  UNIQUE  INDEX ON b132_ContigInfo_37_1(contig_gi)
-;
- CREATE  INDEX ON b132_ContigInfo_37_1(ctg_id)
-;
- CREATE  INDEX ON b132_ContigInfo_37_1(contig_name, contig_acc)
-;
-
- CREATE  INDEX ON b132_GenomeAssemblyInfo_37_1(rep_order, assembly)
-;
-
- CREATE  INDEX ON b132_MapLinkInfo_37_1(gi)
-;
-
- CREATE    INDEX ON b132_MapLink_37_1(snp_id, gi)
-;
- CREATE  INDEX ON b132_MapLink_37_1(gi, "offset", asn_to)
-;
-
-
- CREATE  UNIQUE    INDEX ON b132_SNPChrPosOnRef_37_1(snp_id)
-;
-
- CREATE  UNIQUE    INDEX ON b132_SNPContigLoc_37_1(snp_id, ctg_id, asn_from)
-;
- CREATE  INDEX ON b132_SNPContigLoc_37_1(ctg_id, asn_from)
-;
- CREATE  INDEX ON b132_SNPContigLoc_37_1(snp_type, snp_id)
-;
- CREATE  INDEX ON b132_SNPContigLoc_37_1(ctg_id, snp_id)
-;
-
- CREATE  UNIQUE    INDEX ON b132_SNPContigLocusId_37_1(locus_id, contig_acc, mrna_gi, snp_id, asn_from, allele, mrna_start)
-;
- CREATE  INDEX ON b132_SNPContigLocusId_37_1(snp_id)
-;
-
- CREATE  UNIQUE    INDEX ON b132_SNPMapInfo_37_1(snp_id, assembly)
-;
-
-
- CREATE    INDEX ON dn_IND_batch_pop(pop_id)
-;
-
-
-
-
-
- CREATE    INDEX ON dn_table_rowcount(build_id DESC , reserved_KB_spaceused DESC )
-;
-
+CREATE INDEX ON Batch (tax_id);
+CREATE INDEX ON Batch (submitted_time);
+CREATE INDEX ON Batch (handle,loc_batch_id);
+CREATE INDEX ON Batch (pop_id);
+CREATE INDEX ON Batch (success_rate_int);
+CREATE INDEX ON Batch (method_id);
+CREATE INDEX ON Batch (loc_batch_id_upp);
+CREATE INDEX ON Batch (last_updated_time);
+CREATE INDEX ON BatchCita (pub_id);
+CREATE INDEX ON BatchCultivar (line);
+CREATE INDEX ON BatchStrain (line);
+CREATE INDEX ON FreqSummaryBySsPop (subsnp_id,pop_id);
+CREATE INDEX ON Pedigree (curator,curator_ped_id);
+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 SNPHistory (history_create_time);
+CREATE INDEX ON SNPPubmed (snp_id,subsnp_id,pubmed_id,type);
+CREATE INDEX ON SNPSubSNPLink (subsnp_id);
+CREATE INDEX ON SNPSubSNPLink (snp_id,subsnp_id,substrand_reversed_flag);
+CREATE INDEX ON SNPSubSNPLinkHistory (snp_id);
+CREATE INDEX ON SNPSubSNPLinkHistory (subsnp_id,snp_id);
+CREATE INDEX ON SNPSubSNPLinkHistory (build_id);
+CREATE INDEX ON SNPSubSNPLinkHistory (build_id_when_history_made);
+CREATE INDEX ON SNPVal (snp_id);
+CREATE INDEX ON SNP_HGVS (snp_id,hgvs_name);
+CREATE INDEX ON SNP_bitfield (link_prop_b2,snp_id);
+CREATE INDEX ON SubPop (subsnp_id);
+CREATE INDEX ON SubPop (pop_id,subsnp_id);
+CREATE INDEX ON SubPop (subpop_id);
+CREATE INDEX ON SubPopAllele (batch_id,subsnp_id,pop_id,allele,other,type);
+CREATE INDEX ON SubPopAllele (freq);
+CREATE INDEX ON SubPopAllele (freq_max);
+CREATE INDEX ON SubPopAllele (freq_min);
+CREATE INDEX ON SubPopAllele (subsnp_id);
+CREATE INDEX ON SubPopAllele (type);
+CREATE INDEX ON SubPopAllele (last_updated_time);
+CREATE INDEX ON SubPopAllele (allele_id);
+CREATE INDEX ON SubPopAllele (subpop_id);
+CREATE INDEX ON SubPopAllele (subpop_id,type,allele,other);
+CREATE INDEX ON SubPopGty (subpop_id);
+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 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 dn_IND_batch_pop (pop_id);
+CREATE INDEX ON dn_table_rowcount (build_id DESC,reserved_KB_spaceused DESC);