Revision 1313
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 25 | 25 |
|
| 26 | 26 |
|
| 27 | 27 |
-- |
| 28 |
-- Name: placerank; Type: TYPE; Schema: public; Owner: - |
|
| 29 |
-- |
|
| 30 |
|
|
| 31 |
|
|
| 32 |
|
|
| 33 |
|
|
| 34 |
-- |
|
| 35 |
-- Name: TYPE placerank; Type: COMMENT; Schema: public; Owner: - |
|
| 36 |
-- |
|
| 37 |
|
|
| 38 |
|
|
| 39 |
|
|
| 40 |
|
|
| 41 |
-- |
|
| 28 | 42 |
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: - |
| 29 | 43 |
-- |
| 30 | 44 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 32 | 32 |
|
| 33 | 33 |
|
| 34 | 34 |
-- |
| 35 |
-- Name: placerank; Type: TYPE; Schema: public; Owner: - |
|
| 36 |
-- |
|
| 37 |
|
|
| 38 |
CREATE TYPE placerank AS ENUM ( |
|
| 39 |
'continent', |
|
| 40 |
'country', |
|
| 41 |
'territory', |
|
| 42 |
'region', |
|
| 43 |
'state', |
|
| 44 |
'county', |
|
| 45 |
'municipality', |
|
| 46 |
'site' |
|
| 47 |
); |
|
| 48 |
|
|
| 49 |
|
|
| 50 |
-- |
|
| 51 |
-- Name: TYPE placerank; Type: COMMENT; Schema: public; Owner: - |
|
| 52 |
-- |
|
| 53 |
|
|
| 54 |
COMMENT ON TYPE placerank IS 'state = province |
|
| 55 |
county = parish, canton |
|
| 56 |
municipality = city |
|
| 57 |
'; |
|
| 58 |
|
|
| 59 |
|
|
| 60 |
-- |
|
| 35 | 61 |
-- Name: taxonclass; Type: TYPE; Schema: public; Owner: - |
| 36 | 62 |
-- |
| 37 | 63 |
|
Also available in: Unified diff
vegbien.sql: Added placerank enum