Revision 5236
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3904 | 3904 |
|
| 3905 | 3905 |
|
| 3906 | 3906 |
-- |
| 3907 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3907 |
-- Name: party_unique_root; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3908 | 3908 |
-- |
| 3909 | 3909 |
|
| 3910 | 3910 |
|
| 3911 | 3911 |
|
| 3912 | 3912 |
|
| 3913 | 3913 |
-- |
| 3914 |
-- Name: party_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3915 |
-- |
|
| 3916 |
|
|
| 3917 |
|
|
| 3918 |
|
|
| 3919 |
|
|
| 3920 |
-- |
|
| 3914 | 3921 |
-- Name: place_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3915 | 3922 |
-- |
| 3916 | 3923 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4553 | 4553 |
|
| 4554 | 4554 |
|
| 4555 | 4555 |
-- |
| 4556 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4556 |
-- Name: party_unique_root; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4557 | 4557 |
-- |
| 4558 | 4558 |
|
| 4559 |
CREATE UNIQUE INDEX party_unique ON party USING btree (datasource_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text)));
|
|
| 4559 |
CREATE UNIQUE INDEX party_unique_root ON party USING btree ((COALESCE(organizationname, '\\N'::text))) WHERE (datasource_id = party_id);
|
|
| 4560 | 4560 |
|
| 4561 | 4561 |
|
| 4562 | 4562 |
-- |
| 4563 |
-- Name: party_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4564 |
-- |
|
| 4565 |
|
|
| 4566 |
CREATE UNIQUE INDEX party_unique_within_datasource ON party USING btree (datasource_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text))); |
|
| 4567 |
|
|
| 4568 |
|
|
| 4569 |
-- |
|
| 4563 | 4570 |
-- Name: place_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4564 | 4571 |
-- |
| 4565 | 4572 |
|
Also available in: Unified diff
schemas/vegbien.sql: party: Fixed bug where needed separate unique index for roots (datasources), whose organizationnames must be globally unique rather than unique within a datasource