Files
cmsPRO/updates/1.60/ver_1.632_sql.txt
2026-02-22 21:59:33 +01:00

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;