Revision 4792
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4001 | 4001 |
|
| 4002 | 4002 |
|
| 4003 | 4003 |
-- |
| 4004 |
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4005 |
-- |
|
| 4006 |
|
|
| 4007 |
CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate (plantobservation_id); |
|
| 4008 |
|
|
| 4009 |
|
|
| 4010 |
-- |
|
| 4004 | 4011 |
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4005 | 4012 |
-- |
| 4006 | 4013 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4589 | 4589 |
|
| 4590 | 4590 |
|
| 4591 | 4591 |
-- |
| 4592 |
-- Name: specimenreplicate_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4593 |
-- |
|
| 4594 |
|
|
| 4595 |
CREATE INDEX specimenreplicate_plantobservation ON specimenreplicate USING btree (plantobservation_id); |
|
| 4596 |
|
|
| 4597 |
|
|
| 4598 |
-- |
|
| 4592 | 4599 |
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4593 | 4600 |
-- |
| 4594 | 4601 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added indexes for additional analytical_db_view joins, as described at <https://projects.nceas.ucsb.edu/nceas/issues/494>