Skip to content

Commit c53bbf3

Browse files
SimonGoringSimonGoring
committed
Moved indexes out of the root folder and into a folder in function.
This generates a set of indexes, based in part on the table in issue #7.
1 parent 3311272 commit c53bbf3

File tree

2 files changed

+20
-4
lines changed

2 files changed

+20
-4
lines changed

‎function/indexes/addingIndices.sql‎

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
CREATE INDEX taxonames_idx ON taxa USING GIN(taxonname gin_trgm_ops);
2+
CREATE INDEX sitenames_idx ON sites USING GIN(sitename gin_trgm_ops);
3+
CREATE INDEX familynames_idx ON contacts USING GIN(familyname gin_trgm_ops);
4+
5+
CREATE INDEX sitegeog_gix ON sites USING GIST (geog);
6+
7+
CREATE INDEX youngage_idx ON chronologies USING btree(ageboundyounger);
8+
9+
CREATE INDEX oldage_idx ON chronologies USING btree(ageboundolder);
10+
CREATE INDEX youngage_idx ON chronologies USING btree(ageboundyounger);
11+
12+
CREATE INDEX oldage_idx ON chroncontrols USING btree(agelimitolder);
13+
CREATE INDEX youngage_idx ON chroncontrols USING btree(agelimityounger);
14+
15+
CREATE INDEX smpage_idx ON sampleages USING btree(age);
16+
CREATE INDEX smpageold_idx ON sampleages USING btree(ageolder);
17+
CREATE INDEX smpageyoung_idx ON sampleages USING btree(ageyounger);
18+
19+
CREATE INDEX chronage_idx ON chroncontrols USING btree(age);
20+
CREATE INDEX geoage_idx ON geochronology USING btree(age);

‎indices.sql‎

Lines changed: 0 additions & 4 deletions
This file was deleted.

0 commit comments

Comments
 (0)