Revision 5297
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 4610 | 4610 |
|
| 4611 | 4611 |
|
| 4612 | 4612 |
-- |
| 4613 |
-- Name: taxonconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4613 |
-- Name: taxonconcept_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4614 | 4614 |
-- |
| 4615 | 4615 |
|
| 4616 |
CREATE UNIQUE INDEX taxonconcept_accessioncode_index ON taxonconcept USING btree (accessioncode);
|
|
| 4616 |
CREATE UNIQUE INDEX taxonconcept_0_unique_identifying_name ON taxonconcept USING btree (creator_id, (COALESCE(identifyingtaxonomicname, '\\N'::text))) WHERE (identifyingtaxonomicname IS NOT NULL);
|
|
| 4617 | 4617 |
|
| 4618 | 4618 |
|
| 4619 | 4619 |
-- |
| 4620 |
-- Name: taxonconcept_unique_within_creator_by_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4620 |
-- Name: taxonconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4621 | 4621 |
-- |
| 4622 | 4622 |
|
| 4623 |
CREATE UNIQUE INDEX taxonconcept_unique_within_creator_by_identifying_name ON taxonconcept USING btree (creator_id, (COALESCE(identifyingtaxonomicname, '\\N'::text))) WHERE (identifyingtaxonomicname IS NOT NULL);
|
|
| 4623 |
CREATE UNIQUE INDEX taxonconcept_accessioncode_index ON taxonconcept USING btree (accessioncode);
|
|
| 4624 | 4624 |
|
| 4625 | 4625 |
|
| 4626 | 4626 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Renamed taxonconcept_unique_within_creator_by_identifying_name to taxonconcept_0_unique_identifying_name to ensure that it is always applied before taxonconcept_unique_within_parent if both collide