Revision 5870
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1012 | 1012 |
continent text, |
| 1013 | 1013 |
country text, |
| 1014 | 1014 |
stateprovince text, |
| 1015 |
county text |
|
| 1015 |
county text, |
|
| 1016 |
description text |
|
| 1016 | 1017 |
); |
| 1017 | 1018 |
|
| 1018 | 1019 |
|
| ... | ... | |
| 2047 | 2048 |
rank text NOT NULL, |
| 2048 | 2049 |
placename text NOT NULL, |
| 2049 | 2050 |
placecode text, |
| 2050 |
placedescription text, |
|
| 2051 | 2051 |
accessioncode text |
| 2052 | 2052 |
); |
| 2053 | 2053 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1544 | 1544 |
country text, |
| 1545 | 1545 |
stateprovince text, |
| 1546 | 1546 |
county text, |
| 1547 |
description text, |
|
| 1547 | 1548 |
CONSTRAINT place_required_key CHECK (((((((placecode IS NOT NULL) OR (coordinates_id IS NOT NULL)) OR (continent IS NOT NULL)) OR (country IS NOT NULL)) OR (stateprovince IS NOT NULL)) OR (county IS NOT NULL))) |
| 1548 | 1549 |
); |
| 1549 | 1550 |
|
| ... | ... | |
| 2737 | 2738 |
rank placerank NOT NULL, |
| 2738 | 2739 |
placename text NOT NULL, |
| 2739 | 2740 |
placecode text, |
| 2740 |
placedescription text, |
|
| 2741 | 2741 |
accessioncode text |
| 2742 | 2742 |
); |
| 2743 | 2743 |
|
Also available in: Unified diff
schemas/vegbien.sql: Moved placedescription from placename to place (and renamed it to description), because it applies to the place itself, not the name for the place