Revision 7338
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 7340 | 7340 |
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7341 | 7341 |
-- |
| 7342 | 7342 |
|
| 7343 |
CREATE UNIQUE INDEX taxonverbatim_unique ON taxonverbatim USING btree ((COALESCE(taxonlabel_id, 2147483647)), (COALESCE(morphospecies, '\N'::text))); |
|
| 7343 |
CREATE UNIQUE INDEX taxonverbatim_unique ON taxonverbatim USING btree ((COALESCE(taxonlabel_id, 2147483647)), (COALESCE(morphospecies, '\N'::text)), (COALESCE(morphoname, '\N'::text)));
|
|
| 7344 | 7344 |
|
| 7345 | 7345 |
|
| 7346 | 7346 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonverbatim: taxonverbatim_unique: Added morphoname for cases when there is just a morphoname, and to distinguish taxonverbatims with the same taxonlabel but different morphonames