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