Revision 6433
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1869 | 1869 |
|
| 1870 | 1870 |
|
| 1871 | 1871 |
-- |
| 1872 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1873 |
-- |
|
| 1874 |
|
|
| 1875 |
CREATE TABLE cultivated_family_locations ( |
|
| 1876 |
family varchar(255) NOT NULL, |
|
| 1877 |
country varchar(255) NOT NULL |
|
| 1878 |
); |
|
| 1879 |
|
|
| 1880 |
|
|
| 1881 |
-- |
|
| 1872 | 1882 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1873 | 1883 |
-- |
| 1874 | 1884 |
|
| ... | ... | |
| 3852 | 3862 |
|
| 3853 | 3863 |
|
| 3854 | 3864 |
-- |
| 3865 |
-- Data for Name: cultivated_family_locations; Type: TABLE DATA; Schema: public; Owner: - |
|
| 3866 |
-- |
|
| 3867 |
|
|
| 3868 |
|
|
| 3869 |
|
|
| 3870 |
-- |
|
| 3855 | 3871 |
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: - |
| 3856 | 3872 |
-- |
| 3857 | 3873 |
|
| ... | ... | |
| 4317 | 4333 |
|
| 4318 | 4334 |
|
| 4319 | 4335 |
-- |
| 4336 |
-- Name: cultivated_family_locations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4337 |
-- |
|
| 4338 |
|
|
| 4339 |
ALTER TABLE cultivated_family_locations |
|
| 4340 |
ADD CONSTRAINT cultivated_family_locations_pkey PRIMARY KEY (family, country); |
|
| 4341 |
|
|
| 4342 |
|
|
| 4343 |
-- |
|
| 4320 | 4344 |
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4321 | 4345 |
-- |
| 4322 | 4346 |
|
| ... | ... | |
| 6633 | 6657 |
|
| 6634 | 6658 |
|
| 6635 | 6659 |
-- |
| 6660 |
-- Name: cultivated_family_locations; Type: ACL; Schema: public; Owner: - |
|
| 6661 |
-- |
|
| 6662 |
|
|
| 6663 |
|
|
| 6664 |
|
|
| 6665 |
|
|
| 6666 |
|
|
| 6667 |
|
|
| 6668 |
|
|
| 6669 |
-- |
|
| 6636 | 6670 |
-- Name: definedvalue; Type: ACL; Schema: public; Owner: - |
| 6637 | 6671 |
-- |
| 6638 | 6672 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added cultivated_family_locations to store locations where various taxon families are considered cultivated