Revision 3989
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3627 | 3627 |
|
| 3628 | 3628 |
|
| 3629 | 3629 |
-- |
| 3630 |
-- Name: location_unique_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3631 |
-- |
|
| 3632 |
|
|
| 3633 |
|
|
| 3634 |
|
|
| 3635 |
|
|
| 3636 |
-- |
|
| 3630 | 3637 |
-- Name: location_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3631 | 3638 |
-- |
| 3632 | 3639 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4158 | 4158 |
|
| 4159 | 4159 |
|
| 4160 | 4160 |
-- |
| 4161 |
-- Name: location_unique_authorlocationcode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4162 |
-- |
|
| 4163 |
|
|
| 4164 |
CREATE UNIQUE INDEX location_unique_authorlocationcode ON location USING btree (datasource_id, (COALESCE(authorlocationcode, '\\N'::text))) WHERE ((authorlocationcode IS NOT NULL) AND (sourceaccessioncode IS NULL)); |
|
| 4165 |
|
|
| 4166 |
|
|
| 4167 |
-- |
|
| 4161 | 4168 |
-- Name: location_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4162 | 4169 |
-- |
| 4163 | 4170 |
|
Also available in: Unified diff
schemas/vegbien.sql: location: Support uniquely specifying a location by its authorlocationcode