10a965c854809846a2afc9de5bd9db3eb80cc8a0
1 ALTER TABLE contacts
DROP FOREIGN KEY contacts_ibfk_2
;
3 WHERE NOT EXISTS (SELECT profiles.
*
5 WHERE profiles.pid
= contacts.contact
);
6 ALTER TABLE contacts
ADD FOREIGN KEY (contact
) REFERENCES profiles (pid
) ON DELETE CASCADE ON UPDATE CASCADE;
8 -- vim:set syntax=mysql: