Revision 6433
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2672 | 2672 |
|
| 2673 | 2673 |
|
| 2674 | 2674 |
-- |
| 2675 |
-- Name: cultivated_family_locations; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2676 |
-- |
|
| 2677 |
|
|
| 2678 |
CREATE TABLE cultivated_family_locations ( |
|
| 2679 |
family text NOT NULL, |
|
| 2680 |
country text NOT NULL |
|
| 2681 |
); |
|
| 2682 |
|
|
| 2683 |
|
|
| 2684 |
-- |
|
| 2675 | 2685 |
-- Name: dba_preassignacccode_dba_requestnumber_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2676 | 2686 |
-- |
| 2677 | 2687 |
|
| ... | ... | |
| 4890 | 4900 |
|
| 4891 | 4901 |
|
| 4892 | 4902 |
-- |
| 4903 |
-- Data for Name: cultivated_family_locations; Type: TABLE DATA; Schema: public; Owner: - |
|
| 4904 |
-- |
|
| 4905 |
|
|
| 4906 |
|
|
| 4907 |
|
|
| 4908 |
-- |
|
| 4893 | 4909 |
-- Data for Name: definedvalue; Type: TABLE DATA; Schema: public; Owner: - |
| 4894 | 4910 |
-- |
| 4895 | 4911 |
|
| ... | ... | |
| 5355 | 5371 |
|
| 5356 | 5372 |
|
| 5357 | 5373 |
-- |
| 5374 |
-- Name: cultivated_family_locations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 5375 |
-- |
|
| 5376 |
|
|
| 5377 |
ALTER TABLE ONLY cultivated_family_locations |
|
| 5378 |
ADD CONSTRAINT cultivated_family_locations_pkey PRIMARY KEY (family, country); |
|
| 5379 |
|
|
| 5380 |
|
|
| 5381 |
-- |
|
| 5358 | 5382 |
-- Name: definedvalue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 5359 | 5383 |
-- |
| 5360 | 5384 |
|
| ... | ... | |
| 7717 | 7741 |
|
| 7718 | 7742 |
|
| 7719 | 7743 |
-- |
| 7744 |
-- Name: cultivated_family_locations; Type: ACL; Schema: public; Owner: - |
|
| 7745 |
-- |
|
| 7746 |
|
|
| 7747 |
REVOKE ALL ON TABLE cultivated_family_locations FROM PUBLIC; |
|
| 7748 |
REVOKE ALL ON TABLE cultivated_family_locations FROM bien; |
|
| 7749 |
GRANT ALL ON TABLE cultivated_family_locations TO bien; |
|
| 7750 |
GRANT SELECT ON TABLE cultivated_family_locations TO bien_read; |
|
| 7751 |
|
|
| 7752 |
|
|
| 7753 |
-- |
|
| 7720 | 7754 |
-- Name: definedvalue; Type: ACL; Schema: public; Owner: - |
| 7721 | 7755 |
-- |
| 7722 | 7756 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added cultivated_family_locations to store locations where various taxon families are considered cultivated