ALTER TABLE tblshopping_list_items
ADD CONSTRAINT fk_shopping_list_id FOREIGN KEY (shopping_list_id)
REFERENCES tblshopping_list(id) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE tbldismissed_announcements
ADD CONSTRAINT fk_announcement_id FOREIGN KEY (announcementid)
REFERENCES tblannouncements(announcementid) ON DELETE CASCADE ON UPDATE CASCADE;