Revision 3342
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3808 | 3808 |
|
| 3809 | 3809 |
|
| 3810 | 3810 |
-- |
| 3811 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3812 |
-- |
|
| 3813 |
|
|
| 3814 |
|
|
| 3815 |
|
|
| 3816 |
|
|
| 3817 |
-- |
|
| 3811 | 3818 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3812 | 3819 |
-- |
| 3813 | 3820 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4344 | 4344 |
|
| 4345 | 4345 |
|
| 4346 | 4346 |
-- |
| 4347 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4348 |
-- |
|
| 4349 |
|
|
| 4350 |
CREATE UNIQUE INDEX specimenreplicate_unique_plantobservation ON specimenreplicate USING btree ((COALESCE(plantobservation_id, 2147483647))) WHERE (plantobservation_id IS NOT NULL); |
|
| 4351 |
|
|
| 4352 |
|
|
| 4353 |
-- |
|
| 4347 | 4354 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4348 | 4355 |
-- |
| 4349 | 4356 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Added UNIQUE INDEX on plantobservation_id for direct vouchers in plots data