Revision 12630
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 9943 | 9943 |
|
| 9944 | 9944 |
|
| 9945 | 9945 |
-- |
| 9946 |
-- Name: locationevent_place_visit_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 9947 |
-- |
|
| 9948 |
|
|
| 9949 |
ALTER TABLE locationevent |
|
| 9950 |
ADD CONSTRAINT locationevent_place_visit_id_fkey FOREIGN KEY (place_visit_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 9951 |
|
|
| 9952 |
|
|
| 9953 |
-- |
|
| 9946 | 9954 |
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 9947 | 9955 |
-- |
| 9948 | 9956 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 12891 | 12891 |
|
| 12892 | 12892 |
|
| 12893 | 12893 |
-- |
| 12894 |
-- Name: locationevent_place_visit_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 12895 |
-- |
|
| 12896 |
|
|
| 12897 |
ALTER TABLE ONLY locationevent |
|
| 12898 |
ADD CONSTRAINT locationevent_place_visit_id_fkey FOREIGN KEY (place_visit_id) REFERENCES locationevent(locationevent_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 12899 |
|
|
| 12900 |
|
|
| 12901 |
-- |
|
| 12894 | 12902 |
-- Name: locationevent_previous_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 12895 | 12903 |
-- |
| 12896 | 12904 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: locationevent: added missing fkey on place_visit_id