Revision 11093
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbien.sql | ||
|---|---|---|
| 6670 | 6670 |
-- Name: locationevent_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6671 | 6671 |
-- |
| 6672 | 6672 |
|
| 6673 |
CREATE UNIQUE INDEX locationevent_unique_within_creator ON locationevent USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); |
|
| 6673 |
CREATE UNIQUE INDEX locationevent_unique_within_creator ON locationevent USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text)), (COALESCE(stratum_id, 2147483647))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 6674 | 6674 |
|
| 6675 | 6675 |
|
| 6676 | 6676 |
-- |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: locationevent: locationevent_unique_within_creator unique index on sourceaccessioncode: need to add stratum_id, because the addition of stratum_id to this table instead of a separate stratum_event table (which would have required more schema changes) means we need to use the awkward construction of appending stratum_id to every unique constraint, including ones that ordinarily would just pass through the datasource's pkey