Revision 1313
Added by Aaron Marcuse-Kubitza over 12 years ago
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