Revision 7130
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 6047 | 6047 |
|
| 6048 | 6048 |
|
| 6049 | 6049 |
-- |
| 6050 |
-- Name: taxonverbatim_unique; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 6051 |
-- |
|
| 6052 |
|
|
| 6053 |
ALTER TABLE ONLY taxonverbatim |
|
| 6054 |
ADD CONSTRAINT taxonverbatim_unique UNIQUE (taxonlabel_id); |
|
| 6055 |
|
|
| 6056 |
|
|
| 6057 |
-- |
|
| 6058 | 6050 |
-- Name: telephone_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 6059 | 6051 |
-- |
| 6060 | 6052 |
|
| ... | ... | |
| 7273 | 7265 |
|
| 7274 | 7266 |
|
| 7275 | 7267 |
-- |
| 7268 |
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7269 |
-- |
|
| 7270 |
|
|
| 7271 |
CREATE UNIQUE INDEX taxonverbatim_unique ON taxonverbatim USING btree (taxonlabel_id, (COALESCE(morphospecies, '\N'::text))); |
|
| 7272 |
|
|
| 7273 |
|
|
| 7274 |
-- |
|
| 7276 | 7275 |
-- Name: telephone_party_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7277 | 7276 |
-- |
| 7278 | 7277 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonverbatim: taxonverbatim_unique: Added morphospecies so that there can be multiple taxonverbatims for the same taxonlabel, each with different morphospecies suffixes