Revision 6036
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 243 | 243 |
|
| 244 | 244 |
|
| 245 | 245 |
-- |
| 246 |
-- Name: make_family_higher_plant_group(); Type: FUNCTION; Schema: public; Owner: - |
|
| 247 |
-- |
|
| 248 |
|
|
| 249 |
|
|
| 250 |
|
|
| 251 |
|
|
| 252 |
-- |
|
| 246 | 253 |
-- Name: party_reference_id_self_ref(); Type: FUNCTION; Schema: public; Owner: - |
| 247 | 254 |
-- |
| 248 | 255 |
|
| ... | ... | |
| 1908 | 1915 |
|
| 1909 | 1916 |
|
| 1910 | 1917 |
-- |
| 1918 |
-- Name: family_higher_plant_group; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1919 |
-- |
|
| 1920 |
|
|
| 1921 |
CREATE TABLE family_higher_plant_group ( |
|
| 1922 |
family text NOT NULL, |
|
| 1923 |
higher_plant_group text |
|
| 1924 |
); |
|
| 1925 |
|
|
| 1926 |
|
|
| 1927 |
-- |
|
| 1911 | 1928 |
-- Name: geoscrub_input; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1912 | 1929 |
-- |
| 1913 | 1930 |
|
| ... | ... | |
| 3883 | 3900 |
|
| 3884 | 3901 |
|
| 3885 | 3902 |
-- |
| 3903 |
-- Data for Name: family_higher_plant_group; Type: TABLE DATA; Schema: public; Owner: - |
|
| 3904 |
-- |
|
| 3905 |
|
|
| 3906 |
|
|
| 3907 |
|
|
| 3908 |
|
|
| 3909 |
-- |
|
| 3886 | 3910 |
-- Data for Name: geoscrub_input; Type: TABLE DATA; Schema: public; Owner: - |
| 3887 | 3911 |
-- |
| 3888 | 3912 |
|
| ... | ... | |
| 4379 | 4403 |
|
| 4380 | 4404 |
|
| 4381 | 4405 |
-- |
| 4406 |
-- Name: family_higher_plant_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4407 |
-- |
|
| 4408 |
|
|
| 4409 |
ALTER TABLE family_higher_plant_group |
|
| 4410 |
ADD CONSTRAINT family_higher_plant_group_pkey PRIMARY KEY (family); |
|
| 4411 |
|
|
| 4412 |
|
|
| 4413 |
-- |
|
| 4382 | 4414 |
-- Name: graphic_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4383 | 4415 |
-- |
| 4384 | 4416 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added family_higher_plant_group lookup table, generated with make_family_higher_plant_group() using the contents of higher_plant_group_nodes