Revision 14098
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 11081 | 11081 |
|
| 11082 | 11082 |
|
| 11083 | 11083 |
-- |
| 11084 |
-- Name: threatened_taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 11085 |
-- |
|
| 11086 |
|
|
| 11087 |
CREATE TABLE threatened_taxonlabel ( |
|
| 11088 |
taxonlabel_id integer NOT NULL |
|
| 11089 |
); |
|
| 11090 |
|
|
| 11091 |
|
|
| 11092 |
-- |
|
| 11093 | 11084 |
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: - |
| 11094 | 11085 |
-- |
| 11095 | 11086 |
|
| ... | ... | |
| 14836 | 14827 |
|
| 14837 | 14828 |
|
| 14838 | 14829 |
-- |
| 14839 |
-- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: - |
|
| 14840 |
-- |
|
| 14841 |
|
|
| 14842 |
|
|
| 14843 |
|
|
| 14844 |
-- |
|
| 14845 | 14830 |
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: - |
| 14846 | 14831 |
-- |
| 14847 | 14832 |
|
| ... | ... | |
| 15772 | 15757 |
|
| 15773 | 15758 |
|
| 15774 | 15759 |
-- |
| 15775 |
-- Name: threatened_taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 15776 |
-- |
|
| 15777 |
|
|
| 15778 |
ALTER TABLE ONLY threatened_taxonlabel |
|
| 15779 |
ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_id); |
|
| 15780 |
|
|
| 15781 |
|
|
| 15782 |
-- |
|
| 15783 | 15760 |
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 15784 | 15761 |
-- |
| 15785 | 15762 |
|
| ... | ... | |
| 18148 | 18125 |
|
| 18149 | 18126 |
|
| 18150 | 18127 |
-- |
| 18151 |
-- Name: threatened_taxonlabel_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 18152 |
-- |
|
| 18153 |
|
|
| 18154 |
ALTER TABLE ONLY threatened_taxonlabel |
|
| 18155 |
ADD CONSTRAINT threatened_taxonlabel_taxonlabel_id_fkey FOREIGN KEY (taxonlabel_id) REFERENCES taxonlabel(taxonlabel_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 18156 |
|
|
| 18157 |
|
|
| 18158 |
-- |
|
| 18159 | 18128 |
-- Name: trait_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 18160 | 18129 |
-- |
| 18161 | 18130 |
|
| ... | ... | |
| 19049 | 19018 |
|
| 19050 | 19019 |
|
| 19051 | 19020 |
-- |
| 19052 |
-- Name: threatened_taxonlabel; Type: ACL; Schema: public; Owner: - |
|
| 19053 |
-- |
|
| 19054 |
|
|
| 19055 |
REVOKE ALL ON TABLE threatened_taxonlabel FROM PUBLIC; |
|
| 19056 |
REVOKE ALL ON TABLE threatened_taxonlabel FROM bien; |
|
| 19057 |
GRANT ALL ON TABLE threatened_taxonlabel TO bien; |
|
| 19058 |
GRANT SELECT ON TABLE threatened_taxonlabel TO bien_read; |
|
| 19059 |
|
|
| 19060 |
|
|
| 19061 |
-- |
|
| 19062 | 19021 |
-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: - |
| 19063 | 19022 |
-- |
| 19064 | 19023 |
|
Also available in: Unified diff
schemas/public_.sql: removed no longer used threatened_taxonlabel. use iucn_red_list instead.