Revision 852
Added by Aaron Marcuse-Kubitza almost 13 years ago
| inputs/NYBG/test/import.out.ref | ||
|---|---|---|
| 1 |
Inserted 84 new rows into database |
|
| 1 |
Inserted 83 new rows into database |
|
| schemas/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 |
|
| schemas/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