Revision 6128
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 6009 | 6009 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6010 | 6010 |
-- |
| 6011 | 6011 |
|
| 6012 |
CREATE UNIQUE INDEX party_unique ON party USING btree (reference_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(fullname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text))); |
|
| 6012 |
CREATE UNIQUE INDEX party_unique ON party USING btree (reference_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(fullname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text)), (COALESCE(suffix, '\\N'::text)));
|
|
| 6013 | 6013 |
|
| 6014 | 6014 |
|
| 6015 | 6015 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: party: Added new suffix field to party_unique unique index