Revision 6476
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 4876 | 4876 |
|
| 4877 | 4877 |
|
| 4878 | 4878 |
-- |
| 4879 |
-- Name: analytical_aggregate_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4880 |
-- |
|
| 4881 |
|
|
| 4882 |
CREATE INDEX `analytical_aggregate_by_institutionCode` ON analytical_aggregate (`institutionCode`, `plotName`, `dateCollected`); |
|
| 4883 |
|
|
| 4884 |
|
|
| 4885 |
-- |
|
| 4886 |
-- Name: analytical_stem_by_institutionCode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4887 |
-- |
|
| 4888 |
|
|
| 4889 |
CREATE INDEX `analytical_stem_by_institutionCode` ON analytical_stem (`institutionCode`, `plotName`, `dateCollected`); |
|
| 4890 |
|
|
| 4891 |
|
|
| 4892 |
-- |
|
| 4879 | 4893 |
-- Name: commclass_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4880 | 4894 |
-- |
| 4881 | 4895 |
|
Also available in: Unified diff
schemas/vegbien.sql: analytical_*: Added index on NOT NULL columns, starting with institutionCode