Revision 852
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3879 | 3879 |
|
| 3880 | 3880 |
|
| 3881 | 3881 |
-- |
| 3882 |
-- Name: party_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3883 |
-- |
|
| 3884 |
|
|
| 3885 |
ALTER TABLE party |
|
| 3886 |
ADD CONSTRAINT party_keys UNIQUE (givenname, middlename, surname, organizationname); |
|
| 3887 |
|
|
| 3888 |
|
|
| 3889 |
-- |
|
| 3890 | 3882 |
-- Name: party_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3891 | 3883 |
-- |
| 3892 | 3884 |
|
| ... | ... | |
| 4996 | 4988 |
|
| 4997 | 4989 |
|
| 4998 | 4990 |
-- |
| 4991 |
-- Name: party_keys; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4992 |
-- |
|
| 4993 |
|
|
| 4994 |
|
|
| 4995 |
|
|
| 4996 |
|
|
| 4997 |
-- |
|
| 4999 | 4998 |
-- Name: partymember_childparty_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5000 | 4999 |
-- |
| 5001 | 5000 |
|
Also available in: Unified diff
vegbien.sql: Fixed duplicate elimination for party to use a UNIQUE index with COALESCE for nullable fields