Revision 6476
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 5927 | 5927 |
|
| 5928 | 5928 |
|
| 5929 | 5929 |
-- |
| 5930 |
-- Name: analytical_aggregate_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5931 |
-- |
|
| 5932 |
|
|
| 5933 |
CREATE INDEX "analytical_aggregate_by_institutionCode" ON analytical_aggregate USING btree ("institutionCode", "plotName", "dateCollected");
|
|
| 5934 |
|
|
| 5935 |
|
|
| 5936 |
-- |
|
| 5937 |
-- Name: analytical_stem_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5938 |
-- |
|
| 5939 |
|
|
| 5940 |
CREATE INDEX "analytical_stem_by_institutionCode" ON analytical_stem USING btree ("institutionCode", "plotName", "dateCollected");
|
|
| 5941 |
|
|
| 5942 |
|
|
| 5943 |
-- |
|
| 5930 | 5944 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5931 | 5945 |
-- |
| 5932 | 5946 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Added index on NOT NULL columns, starting with institutionCode