Revision 852
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 4325 | 4325 |
|
| 4326 | 4326 |
|
| 4327 | 4327 |
-- |
| 4328 |
-- Name: party_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4329 |
-- |
|
| 4330 |
|
|
| 4331 |
ALTER TABLE ONLY party |
|
| 4332 |
ADD CONSTRAINT party_keys UNIQUE (givenname, middlename, surname, organizationname); |
|
| 4333 |
|
|
| 4334 |
|
|
| 4335 |
-- |
|
| 4336 | 4328 |
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4337 | 4329 |
-- |
| 4338 | 4330 |
|
| ... | ... | |
| 5442 | 5434 |
|
| 5443 | 5435 |
|
| 5444 | 5436 |
-- |
| 5437 |
-- Name: party_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5438 |
-- |
|
| 5439 |
|
|
| 5440 |
CREATE UNIQUE INDEX party_keys ON party USING btree ((COALESCE(givenname, ''::text)), (COALESCE(middlename, ''::text)), (COALESCE(surname, ''::text)), (COALESCE(organizationname, ''::text))); |
|
| 5441 |
|
|
| 5442 |
|
|
| 5443 |
-- |
|
| 5445 | 5444 |
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5446 | 5445 |
-- |
| 5447 | 5446 |
|
Also available in: Unified diff
vegbien.sql: Fixed duplicate elimination for party to use a UNIQUE index with COALESCE for nullable fields