Revision 12623
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 8715 | 8715 |
|
| 8716 | 8716 |
|
| 8717 | 8717 |
-- |
| 8718 |
-- Name: locationevent_place_visit_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 8719 |
-- |
|
| 8720 |
|
|
| 8721 |
CREATE INDEX locationevent_place_visit_id ON locationevent (place_visit_id); |
|
| 8722 |
|
|
| 8723 |
|
|
| 8724 |
-- |
|
| 8718 | 8725 |
-- Name: locationevent_previous_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 8719 | 8726 |
-- |
| 8720 | 8727 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 11644 | 11644 |
|
| 11645 | 11645 |
|
| 11646 | 11646 |
-- |
| 11647 |
-- Name: locationevent_place_visit_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 11648 |
-- |
|
| 11649 |
|
|
| 11650 |
CREATE INDEX locationevent_place_visit_id ON locationevent USING btree (place_visit_id); |
|
| 11651 |
|
|
| 11652 |
|
|
| 11653 |
-- |
|
| 11647 | 11654 |
-- Name: locationevent_previous_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 11648 | 11655 |
-- |
| 11649 | 11656 |
|
Also available in: Unified diff
fix: schemas/vegbien.sql: locationevent: added locationevent_place_visit_id index to facilitate joins to place_visit_id in the validations queries