Revision 4970
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 634 | 634 |
placepath_id int(11) NOT NULL, |
| 635 | 635 |
datasource_id int(11) NOT NULL, |
| 636 | 636 |
placecode text, |
| 637 |
canon_placepath_id int(11), |
|
| 637 | 638 |
place_id int(11), |
| 638 | 639 |
continent text, |
| 639 | 640 |
country text, |
| ... | ... | |
| 653 | 654 |
|
| 654 | 655 |
|
| 655 | 656 |
-- |
| 657 |
-- Name: COLUMN placepath.canon_placepath_id; Type: COMMENT; Schema: public; Owner: - |
|
| 658 |
-- |
|
| 659 |
|
|
| 660 |
|
|
| 661 |
|
|
| 662 |
|
|
| 663 |
-- |
|
| 656 | 664 |
-- Name: COLUMN placepath.otherranks; Type: COMMENT; Schema: public; Owner: - |
| 657 | 665 |
-- |
| 658 | 666 |
|
| ... | ... | |
| 4669 | 4677 |
|
| 4670 | 4678 |
|
| 4671 | 4679 |
-- |
| 4680 |
-- Name: placepath_canon_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4681 |
-- |
|
| 4682 |
|
|
| 4683 |
ALTER TABLE placepath |
|
| 4684 |
ADD CONSTRAINT placepath_canon_placepath_id_fkey FOREIGN KEY (canon_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 4685 |
|
|
| 4686 |
|
|
| 4687 |
-- |
|
| 4672 | 4688 |
-- Name: placepath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4673 | 4689 |
-- |
| 4674 | 4690 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 920 | 920 |
placepath_id integer NOT NULL, |
| 921 | 921 |
datasource_id integer NOT NULL, |
| 922 | 922 |
placecode text, |
| 923 |
canon_placepath_id integer, |
|
| 923 | 924 |
place_id integer, |
| 924 | 925 |
continent text, |
| 925 | 926 |
country text, |
| ... | ... | |
| 941 | 942 |
|
| 942 | 943 |
|
| 943 | 944 |
-- |
| 945 |
-- Name: COLUMN placepath.canon_placepath_id; Type: COMMENT; Schema: public; Owner: - |
|
| 946 |
-- |
|
| 947 |
|
|
| 948 |
COMMENT ON COLUMN placepath.canon_placepath_id IS 'The placepath containing the scrubbed name of this verbatim place path. placepaths should be linked only one level deep, with verbatim place paths pointing to scrubbed names.'; |
|
| 949 |
|
|
| 950 |
|
|
| 951 |
-- |
|
| 944 | 952 |
-- Name: COLUMN placepath.otherranks; Type: COMMENT; Schema: public; Owner: - |
| 945 | 953 |
-- |
| 946 | 954 |
|
| ... | ... | |
| 5295 | 5303 |
|
| 5296 | 5304 |
|
| 5297 | 5305 |
-- |
| 5306 |
-- Name: placepath_canon_placepath_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5307 |
-- |
|
| 5308 |
|
|
| 5309 |
ALTER TABLE ONLY placepath |
|
| 5310 |
ADD CONSTRAINT placepath_canon_placepath_id_fkey FOREIGN KEY (canon_placepath_id) REFERENCES placepath(placepath_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5311 |
|
|
| 5312 |
|
|
| 5313 |
-- |
|
| 5298 | 5314 |
-- Name: placepath_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5299 | 5315 |
-- |
| 5300 | 5316 |
|
Also available in: Unified diff
schemas/vegbien.sql: placepath: Added canon_placepath_id, analogous to taxonpath.canon_taxonpath_id