Revision 4711
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1677 | 1677 |
rank text NOT NULL, |
| 1678 | 1678 |
verbatimrank text, |
| 1679 | 1679 |
plantname text NOT NULL, |
| 1680 |
authority text, |
|
| 1680 | 1681 |
description text, |
| 1681 | 1682 |
accessioncode text |
| 1682 | 1683 |
); |
| schemas/vegbien.sql | ||
|---|---|---|
| 2087 | 2087 |
rank taxonrank NOT NULL, |
| 2088 | 2088 |
verbatimrank text, |
| 2089 | 2089 |
plantname text NOT NULL, |
| 2090 |
authority text, |
|
| 2090 | 2091 |
description text, |
| 2091 | 2092 |
accessioncode text |
| 2092 | 2093 |
); |
| ... | ... | |
| 4338 | 4339 |
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4339 | 4340 |
-- |
| 4340 | 4341 |
|
| 4341 |
CREATE UNIQUE INDEX plantname_unique ON plantname USING btree ((COALESCE(parent_id, 2147483647)), plantname, rank, (COALESCE(scope_id, 2147483647))); |
|
| 4342 |
CREATE UNIQUE INDEX plantname_unique ON plantname USING btree ((COALESCE(parent_id, 2147483647)), plantname, rank, (COALESCE(scope_id, 2147483647)), (COALESCE(authority, '\\N'::text)));
|
|
| 4342 | 4343 |
|
| 4343 | 4344 |
|
| 4344 | 4345 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: plantname: Added authority so each taxonomic level can have its own authority (author). Include it in the plantname_unique unique index because plantname is a globally scoped table.