Revision 1075
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3017 | 3017 |
-- |
| 3018 | 3018 |
|
| 3019 | 3019 |
ALTER TABLE locationevent |
| 3020 |
ADD CONSTRAINT locationevent_keys_datasource_authorcode UNIQUE (datasource_id, project_id, authoreventcode);
|
|
| 3020 |
ADD CONSTRAINT locationevent_keys_datasource_authorcode UNIQUE (project_id, authoreventcode, obsstartdate);
|
|
| 3021 | 3021 |
|
| 3022 | 3022 |
|
| 3023 | 3023 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 3378 | 3378 |
-- |
| 3379 | 3379 |
|
| 3380 | 3380 |
ALTER TABLE ONLY locationevent |
| 3381 |
ADD CONSTRAINT locationevent_keys_datasource_authorcode UNIQUE (datasource_id, project_id, authoreventcode);
|
|
| 3381 |
ADD CONSTRAINT locationevent_keys_datasource_authorcode UNIQUE (project_id, authoreventcode, obsstartdate);
|
|
| 3382 | 3382 |
|
| 3383 | 3383 |
|
| 3384 | 3384 |
-- |
Also available in: Unified diff
vegbien.sql: locationevent: Redid unique constraints to handle datasources that treat the authoreventcode as an authorlocationcode. Eventually, authoreventcode will be renamed to authorlocationcode.