Revision 7019
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.sql | ||
|---|---|---|
| 6234 | 6234 |
|
| 6235 | 6235 |
|
| 6236 | 6236 |
-- |
| 6237 |
-- Name: location_unique_within_parent_by_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6238 |
-- |
|
| 6239 |
|
|
| 6240 |
CREATE UNIQUE INDEX location_unique_within_parent_by_sourceaccessioncode ON location USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(sourceaccessioncode, '\N'::text))) WHERE ((parent_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL)); |
|
| 6241 |
|
|
| 6242 |
|
|
| 6243 |
-- |
|
| 6244 | 6237 |
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6245 | 6238 |
-- |
| 6246 | 6239 |
|
Also available in: Unified diff
schemas/vegbien.sql: location: Removed location_unique_within_parent_by_sourceaccessioncode, which duplicates location_unique_within_creator_by_sourceaccessioncode because the sourceaccessioncode is globally unique