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

Annotation of /Babel/bin/create_pg_indexes.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.15 - (view) (download)

1 : tharriso 1.1
2 : tharriso 1.7 CREATE INDEX md5_protein_id ON md5_protein (id);
3 :     CREATE INDEX md5_protein_md5 ON md5_protein (md5);
4 :     CREATE INDEX md5_protein_function ON md5_protein (function);
5 :     CREATE INDEX md5_protein_organism ON md5_protein (organism);
6 : tharriso 1.11 CREATE INDEX md5_protein_source ON md5_protein (source);
7 : tharriso 1.7
8 : tharriso 1.8 CREATE INDEX md5_ontology_id ON md5_ontology (id);
9 :     CREATE INDEX md5_ontology_md5 ON md5_ontology (md5);
10 :     CREATE INDEX md5_ontology_function ON md5_ontology (function);
11 :     CREATE INDEX md5_ontology_source ON md5_ontology (source);
12 :    
13 : tharriso 1.13 CREATE INDEX md5_rna_id ON md5_rna (id);
14 :     CREATE INDEX md5_rna_md5 ON md5_rna (md5);
15 :     CREATE INDEX md5_rna_function ON md5_rna (function);
16 :     CREATE INDEX md5_rna_organism ON md5_rna (organism);
17 : tharriso 1.15 CREATE INDEX md5_rna_tax_rank ON md5_rna (tax_rank);
18 : tharriso 1.13 CREATE INDEX md5_rna_source ON md5_rna (source);
19 :    
20 : tharriso 1.7 CREATE INDEX aliases_protein_id on aliases_protein (id);
21 :    
22 :     CREATE INDEX functions_name ON functions (name);
23 :    
24 :     CREATE INDEX contigs_id ON contigs (name);
25 :     CREATE INDEX contigs_organism ON contigs (organism);
26 :     CREATE INDEX contigs_length ON contigs (length);
27 :    
28 :     CREATE INDEX id2contig_id ON id2contig (id);
29 :     CREATE INDEX id2contig_contig ON id2contig (contig);
30 :    
31 :     CREATE INDEX organisms_ncbi_name ON organisms_ncbi (name);
32 :     CREATE INDEX organisms_ncbi_tax_id ON organisms_ncbi (ncbi_tax_id);
33 : tharriso 1.1
34 : tharriso 1.9 CREATE INDEX ontology_seed_id ON ontology_seed (id);
35 :    
36 :     CREATE INDEX ontology_kegg_id ON ontology_kegg (id);
37 :    
38 :     CREATE INDEX ontology_eggnog_id ON ontology_eggnog (id);
39 : tharriso 1.10 CREATE INDEX ontology_eggnog_type ON ontology_eggnog (type);
40 : tharriso 1.9
41 : tharriso 1.7 CREATE INDEX sources_name ON sources (name);
42 : tharriso 1.12 CREATE INDEX sources_type ON sources (type);

MCS Webmaster
ViewVC Help
Powered by ViewVC 1.0.3