Revision 5297
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3962 | 3962 |
|
| 3963 | 3963 |
|
| 3964 | 3964 |
-- |
| 3965 |
-- Name: taxonconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3965 |
-- Name: taxonconcept_0_unique_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3966 | 3966 |
-- |
| 3967 | 3967 |
|
| 3968 |
CREATE UNIQUE INDEX taxonconcept_accessioncode_index ON taxonconcept (accessioncode); |
|
| 3969 | 3968 |
|
| 3970 | 3969 |
|
| 3970 |
|
|
| 3971 | 3971 |
-- |
| 3972 |
-- Name: taxonconcept_unique_within_creator_by_identifying_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3972 |
-- Name: taxonconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3973 | 3973 |
-- |
| 3974 | 3974 |
|
| 3975 |
CREATE UNIQUE INDEX taxonconcept_accessioncode_index ON taxonconcept (accessioncode); |
|
| 3975 | 3976 |
|
| 3976 | 3977 |
|
| 3977 |
|
|
| 3978 | 3978 |
-- |
| 3979 | 3979 |
-- Name: taxonconcept_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3980 | 3980 |
-- |
| schemas/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