Revision 1253
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3443 | 3443 |
|
| 3444 | 3444 |
|
| 3445 | 3445 |
-- |
| 3446 |
-- Name: specimenreplicate_unique_catalognumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3447 |
-- |
|
| 3448 |
|
|
| 3449 |
ALTER TABLE specimenreplicate |
|
| 3450 |
ADD CONSTRAINT specimenreplicate_unique_catalognumber UNIQUE (datasource_id, collectioncode_dwc, catalognumber_dwc); |
|
| 3451 |
|
|
| 3452 |
|
|
| 3453 |
-- |
|
| 3454 |
-- Name: specimenreplicate_unique_collectionnumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3455 |
-- |
|
| 3456 |
|
|
| 3457 |
ALTER TABLE specimenreplicate |
|
| 3458 |
ADD CONSTRAINT specimenreplicate_unique_collectionnumber UNIQUE (datasource_id, verbatimcollectorname, collectionnumber); |
|
| 3459 |
|
|
| 3460 |
|
|
| 3461 |
-- |
|
| 3462 | 3446 |
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3463 | 3447 |
-- |
| 3464 | 3448 |
|
| ... | ... | |
| 4588 | 4572 |
|
| 4589 | 4573 |
|
| 4590 | 4574 |
-- |
| 4575 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4576 |
-- |
|
| 4577 |
|
|
| 4578 |
|
|
| 4579 |
|
|
| 4580 |
|
|
| 4581 |
-- |
|
| 4591 | 4582 |
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4592 | 4583 |
-- |
| 4593 | 4584 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3840 | 3840 |
|
| 3841 | 3841 |
|
| 3842 | 3842 |
-- |
| 3843 |
-- Name: specimenreplicate_unique_catalognumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3844 |
-- |
|
| 3845 |
|
|
| 3846 |
ALTER TABLE ONLY specimenreplicate |
|
| 3847 |
ADD CONSTRAINT specimenreplicate_unique_catalognumber UNIQUE (datasource_id, collectioncode_dwc, catalognumber_dwc); |
|
| 3848 |
|
|
| 3849 |
|
|
| 3850 |
-- |
|
| 3851 |
-- Name: specimenreplicate_unique_collectionnumber; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3852 |
-- |
|
| 3853 |
|
|
| 3854 |
ALTER TABLE ONLY specimenreplicate |
|
| 3855 |
ADD CONSTRAINT specimenreplicate_unique_collectionnumber UNIQUE (datasource_id, verbatimcollectorname, collectionnumber); |
|
| 3856 |
|
|
| 3857 |
|
|
| 3858 |
-- |
|
| 3859 | 3843 |
-- Name: stemobservation_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3860 | 3844 |
-- |
| 3861 | 3845 |
|
| ... | ... | |
| 4985 | 4969 |
|
| 4986 | 4970 |
|
| 4987 | 4971 |
-- |
| 4972 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4973 |
-- |
|
| 4974 |
|
|
| 4975 |
CREATE UNIQUE INDEX specimenreplicate_unique_catalognumber ON specimenreplicate USING btree (datasource_id, catalognumber_dwc) WHERE (sourceaccessioncode IS NULL); |
|
| 4976 |
|
|
| 4977 |
|
|
| 4978 |
-- |
|
| 4988 | 4979 |
-- Name: stemobservation_plantobservation_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4989 | 4980 |
-- |
| 4990 | 4981 |
|
Also available in: Unified diff
vegbien.sql: specimenreplicate: Removed specimenreplicate_unique_collectionnumber index because the collectionnumber (NYBG FieldNumber) is not always unique within a collector, even though it should be. Changed specimenreplicate_unique_catalognumber to only operate on rows with no sourceaccessioncode (of which there are 8 in NYBG).