ushahidi/Lamu — pull request #37 by rjmackay (2013-04-01 22:27:04+00:00)
Title: Add missing foreign keys and missing relations in models

* Also remove ip_address fields - we have no business collecting that
* Add comments to a posts user_id/type
* Tasks to posts/users/parent
* ON DELETE SET NULL for assignee/assignor - just unassign
* ON DELETE CASCADE for post or parent
* post_* to form_attributes
* ON DELETE SET NULL - to avoid mass deleting data if attribute removed
* post_comments to users / parent
* ON DELETE SET NULL since a comment can just be treated as anonymous
once a user is delete. Top level if parent deleted
* posts to form / users / parent
* All using ON DELETE SET NULL to avoid mass deleting data when a form
is remove
* Relations
* Add form_attribute relation for post_*
* Add form relation to post
* Add posts relation to form

Things to resolve before merge - should we always be using ON DELETE CASCADE? are the 'SET NULL' instances ok?