add human 9606 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
new file mode 100644 (file)
index 0000000..0c7f146
--- /dev/null
+++ b/schema/human_9606_schema/human_9606_index_postgresql.sql
@@ -0,0 +1,212 @@
+
+ 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 )
+;
+