3 lines
303 B
Plaintext
3 lines
303 B
Plaintext
DELETE FROM pp_pages_langs WHERE page_id NOT IN ( SELECT id FROM pp_pages )
|
|
ALTER TABLE pp_pages_langs ADD FOREIGN KEY (page_id) REFERENCES pp_pages(id) ON DELETE CASCADE ON UPDATE CASCADE;
|
|
ALTER TABLE pp_pages_langs ADD FOREIGN KEY (lang_id) REFERENCES pp_langs(id) ON DELETE CASCADE ON UPDATE CASCADE; |