Revision 1085
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3012 | 3012 |
|
| 3013 | 3013 |
|
| 3014 | 3014 |
-- |
| 3015 |
-- Name: locationevent_keys_parent_location; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3016 |
-- |
|
| 3017 |
|
|
| 3018 |
ALTER TABLE locationevent |
|
| 3019 |
ADD CONSTRAINT locationevent_keys_parent_location UNIQUE (parent_id, location_id); |
|
| 3020 |
|
|
| 3021 |
|
|
| 3022 |
-- |
|
| 3015 | 3023 |
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3016 | 3024 |
-- |
| 3017 | 3025 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3373 | 3373 |
|
| 3374 | 3374 |
|
| 3375 | 3375 |
-- |
| 3376 |
-- Name: locationevent_keys_parent_location; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3377 |
-- |
|
| 3378 |
|
|
| 3379 |
ALTER TABLE ONLY locationevent |
|
| 3380 |
ADD CONSTRAINT locationevent_keys_parent_location UNIQUE (parent_id, location_id); |
|
| 3381 |
|
|
| 3382 |
|
|
| 3383 |
-- |
|
| 3376 | 3384 |
-- Name: locationevent_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3377 | 3385 |
-- |
| 3378 | 3386 |
|
Also available in: Unified diff
vegbien.sql: locationevent: Added unique constraint for subplots based on subplot location