Revision 14098
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 7796 | 7796 |
|
| 7797 | 7797 |
|
| 7798 | 7798 |
-- |
| 7799 |
-- Name: threatened_taxonlabel; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 7800 |
-- |
|
| 7801 |
|
|
| 7802 |
CREATE TABLE threatened_taxonlabel ( |
|
| 7803 |
taxonlabel_id int(11) NOT NULL |
|
| 7804 |
); |
|
| 7805 |
|
|
| 7806 |
|
|
| 7807 |
-- |
|
| 7808 | 7799 |
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: - |
| 7809 | 7800 |
-- |
| 7810 | 7801 |
|
| ... | ... | |
| 11089 | 11080 |
|
| 11090 | 11081 |
|
| 11091 | 11082 |
-- |
| 11092 |
-- Data for Name: threatened_taxonlabel; Type: TABLE DATA; Schema: public; Owner: - |
|
| 11093 |
-- |
|
| 11094 |
|
|
| 11095 |
|
|
| 11096 |
|
|
| 11097 |
-- |
|
| 11098 | 11083 |
-- Data for Name: trait; Type: TABLE DATA; Schema: public; Owner: - |
| 11099 | 11084 |
-- |
| 11100 | 11085 |
|
| ... | ... | |
| 12025 | 12010 |
|
| 12026 | 12011 |
|
| 12027 | 12012 |
-- |
| 12028 |
-- Name: threatened_taxonlabel_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 12029 |
-- |
|
| 12030 |
|
|
| 12031 |
ALTER TABLE threatened_taxonlabel |
|
| 12032 |
ADD CONSTRAINT threatened_taxonlabel_pkey PRIMARY KEY (taxonlabel_id); |
|
| 12033 |
|
|
| 12034 |
|
|
| 12035 |
-- |
|
| 12036 | 12013 |
-- Name: trait_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 12037 | 12014 |
-- |
| 12038 | 12015 |
|
| ... | ... | |
| 14351 | 14328 |
|
| 14352 | 14329 |
|
| 14353 | 14330 |
-- |
| 14354 |
-- Name: threatened_taxonlabel_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 14355 |
-- |
|
| 14356 |
|
|
| 14357 |
|
|
| 14358 |
|
|
| 14359 |
|
|
| 14360 |
-- |
|
| 14361 | 14331 |
-- Name: trait_taxonoccurrence_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 14362 | 14332 |
-- |
| 14363 | 14333 |
|
| ... | ... | |
| 15251 | 15221 |
|
| 15252 | 15222 |
|
| 15253 | 15223 |
-- |
| 15254 |
-- Name: threatened_taxonlabel; Type: ACL; Schema: public; Owner: - |
|
| 15255 |
-- |
|
| 15256 |
|
|
| 15257 |
|
|
| 15258 |
|
|
| 15259 |
|
|
| 15260 |
|
|
| 15261 |
|
|
| 15262 |
|
|
| 15263 |
-- |
|
| 15264 | 15224 |
-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: - |
| 15265 | 15225 |
-- |
| 15266 | 15226 |
|
| trunk/schemas/public_.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 |
|
| trunk/schemas/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.