[Bio] / Babel / bin / create_pg_indexes.sql Repository:
ViewVC logotype

View of /Babel/bin/create_pg_indexes.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.15 - (download) (annotate)
Fri Mar 25 18:50:31 2011 UTC (9 years, 3 months ago) by tharriso
Branch: MAIN
CVS Tags: mgrast_dev_08112011, mgrast_dev_08022011, mobedac_release_05302012, mgrast_dev_05262011, mgrast_dev_04082011, mgrast_version_3_2, mgrast_dev_12152011, mgrast_dev_06072011, mgrast_dev_10262011, mgrast_dev_03252011, mgrast_release_3_0_4, mgrast_release_3_0_3, mgrast_dev_03312011, mgrast_release_3_1_2, mgrast_release_3_1_1, mgrast_release_3_1_0, mgrast_dev_04132011, mgrast_dev_04012011, mgrast_dev_04052011, HEAD
Changes since 1.14: +1 -0 lines
update for ranked rna taxonomy

CREATE INDEX md5_protein_id ON md5_protein (id);
CREATE INDEX md5_protein_md5 ON md5_protein (md5);
CREATE INDEX md5_protein_function ON md5_protein (function);
CREATE INDEX md5_protein_organism ON md5_protein (organism);
CREATE INDEX md5_protein_source ON md5_protein (source);

CREATE INDEX md5_ontology_id ON md5_ontology (id);
CREATE INDEX md5_ontology_md5 ON md5_ontology (md5);
CREATE INDEX md5_ontology_function ON md5_ontology (function);
CREATE INDEX md5_ontology_source ON md5_ontology (source);

CREATE INDEX md5_rna_id ON md5_rna (id);
CREATE INDEX md5_rna_md5 ON md5_rna (md5);
CREATE INDEX md5_rna_function ON md5_rna (function);
CREATE INDEX md5_rna_organism ON md5_rna (organism);
CREATE INDEX md5_rna_tax_rank ON md5_rna (tax_rank);
CREATE INDEX md5_rna_source ON md5_rna (source);

CREATE INDEX aliases_protein_id on aliases_protein (id);

CREATE INDEX functions_name ON functions (name);

CREATE INDEX contigs_id ON contigs (name);
CREATE INDEX contigs_organism ON contigs (organism);
CREATE INDEX contigs_length ON contigs (length);

CREATE INDEX id2contig_id ON id2contig (id);
CREATE INDEX id2contig_contig ON id2contig (contig);

CREATE INDEX organisms_ncbi_name ON organisms_ncbi (name);
CREATE INDEX organisms_ncbi_tax_id ON organisms_ncbi (ncbi_tax_id);

CREATE INDEX ontology_seed_id ON ontology_seed (id);

CREATE INDEX ontology_kegg_id ON ontology_kegg (id);

CREATE INDEX ontology_eggnog_id ON ontology_eggnog (id);
CREATE INDEX ontology_eggnog_type ON ontology_eggnog (type);

CREATE INDEX sources_name ON sources (name);
CREATE INDEX sources_type ON sources (type);

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3