Foreign key relations in MySql – Avoiding accidental deletion of posts
The normal case when using foreign key relationships in database tables might be “ON DELETE CASCADE ON UPDATE CASCADE”. If you have a table connecting a user_id to an activity_id, this means that deleting the activity post also deletes the connection post. Fine! The activity is gone, and so the table post defining the connection… [Read more…]
July 7, 2009
1