Revision 3202
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4226 | 4226 |
|
| 4227 | 4227 |
|
| 4228 | 4228 |
-- |
| 4229 |
-- Name: locationevent_unique_location; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4230 |
-- |
|
| 4231 |
|
|
| 4232 |
|
|
| 4233 |
|
|
| 4234 |
|
|
| 4235 |
-- |
|
| 4229 | 4236 |
-- Name: locationevent_unique_project_authorcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4230 | 4237 |
-- |
| 4231 | 4238 |
|
| schemas/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.