Revision 3202
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.sql | ||
|---|---|---|
| 4757 | 4757 |
|
| 4758 | 4758 |
|
| 4759 | 4759 |
-- |
| 4760 |
-- Name: locationevent_unique_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4761 |
-- |
|
| 4762 |
|
|
| 4763 |
CREATE UNIQUE INDEX locationevent_unique_location ON locationevent USING btree (location_id) WHERE (parent_id IS NULL); |
|
| 4764 |
|
|
| 4765 |
|
|
| 4766 |
-- |
|
| 4760 | 4767 |
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4761 | 4768 |
-- |
| 4762 | 4769 |
|
Also available in: Unified diff
schemas/vegbien.sql: locationevent: Allow to be uniquely specified by location_id. This is useful for specimens data where there is one location for every locationevent.