Revision 3988
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3634 | 3634 |
|
| 3635 | 3635 |
|
| 3636 | 3636 |
-- |
| 3637 |
-- Name: location_unique_within_parent_by_coords; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3637 |
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3638 | 3638 |
-- |
| 3639 | 3639 |
|
| 3640 | 3640 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4165 | 4165 |
|
| 4166 | 4166 |
|
| 4167 | 4167 |
-- |
| 4168 |
-- Name: location_unique_within_parent_by_coords; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4168 |
-- Name: location_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4169 | 4169 |
-- |
| 4170 | 4170 |
|
| 4171 |
CREATE UNIQUE INDEX location_unique_within_parent_by_coords ON location USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(sublocationxposition, 'NaN'::double precision)), (COALESCE(sublocationyposition, 'NaN'::double precision))) WHERE ((parent_id IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
|
| 4171 |
CREATE UNIQUE INDEX location_unique_within_parent ON location USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(authorlocationcode, '\\N'::text)), (COALESCE(sublocationxposition, 'NaN'::double precision)), (COALESCE(sublocationyposition, 'NaN'::double precision))) WHERE ((parent_id IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
|
| 4172 | 4172 |
|
| 4173 | 4173 |
|
| 4174 | 4174 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: location: Added authorlocationcode to unique indexes