Revision 5277
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1978 | 1978 |
|
| 1979 | 1979 |
CREATE TABLE plantusage ( |
| 1980 | 1980 |
plantusage_id int(11) NOT NULL, |
| 1981 |
taxon_id int(11) NOT NULL, |
|
| 1982 |
taxonconcept_id int(11), |
|
| 1981 |
taxonconcept_id int(11) NOT NULL, |
|
| 1983 | 1982 |
taxonstatus text, |
| 1984 | 1983 |
taxon text, |
| 1985 | 1984 |
classsystem text, |
| ... | ... | |
| 4889 | 4888 |
|
| 4890 | 4889 |
|
| 4891 | 4890 |
-- |
| 4892 |
-- Name: plantusage_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4893 |
-- |
|
| 4894 |
|
|
| 4895 |
ALTER TABLE plantusage |
|
| 4896 |
ADD CONSTRAINT plantusage_taxon_id_fkey FOREIGN KEY (taxon_id) REFERENCES taxon(taxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4897 |
|
|
| 4898 |
|
|
| 4899 |
-- |
|
| 4900 | 4891 |
-- Name: plantusage_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4901 | 4892 |
-- |
| 4902 | 4893 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2552 | 2552 |
|
| 2553 | 2553 |
CREATE TABLE plantusage ( |
| 2554 | 2554 |
plantusage_id integer NOT NULL, |
| 2555 |
taxon_id integer NOT NULL, |
|
| 2556 |
taxonconcept_id integer, |
|
| 2555 |
taxonconcept_id integer NOT NULL, |
|
| 2557 | 2556 |
taxonstatus text, |
| 2558 | 2557 |
taxon text, |
| 2559 | 2558 |
classsystem text, |
| ... | ... | |
| 5616 | 5615 |
|
| 5617 | 5616 |
|
| 5618 | 5617 |
-- |
| 5619 |
-- Name: plantusage_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5620 |
-- |
|
| 5621 |
|
|
| 5622 |
ALTER TABLE ONLY plantusage |
|
| 5623 |
ADD CONSTRAINT plantusage_taxon_id_fkey FOREIGN KEY (taxon_id) REFERENCES taxon(taxon_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5624 |
|
|
| 5625 |
|
|
| 5626 |
-- |
|
| 5627 | 5618 |
-- Name: plantusage_taxonconcept_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5628 | 5619 |
-- |
| 5629 | 5620 |
|
Also available in: Unified diff
schemas/vegbien.sql: plantusage: Point just to taxonconcept instead of both to taxonconcept and taxon