From 22b26d0b4d68f0492275ec93eb4df1a975a8fc80 Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Sat, 20 Jun 2015 17:53:49 -0400 Subject: Change comments table structure (drop foreign key on user_id) --- app/Model/User.php | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'app/Model/User.php') diff --git a/app/Model/User.php b/app/Model/User.php index 83cf065b..726978e5 100644 --- a/app/Model/User.php +++ b/app/Model/User.php @@ -302,11 +302,21 @@ class User extends Base { return $this->db->transaction(function ($db) use ($user_id) { - // All assigned tasks are now unassigned + // All assigned tasks are now unassigned (no foreign key) if (! $db->table(Task::TABLE)->eq('owner_id', $user_id)->update(array('owner_id' => 0))) { return false; } + // All assigned subtasks are now unassigned (no foreign key) + if (! $db->table(Subtask::TABLE)->eq('user_id', $user_id)->update(array('user_id' => 0))) { + return false; + } + + // All comments are not assigned anymore (no foreign key) + if (! $db->table(Comment::TABLE)->eq('user_id', $user_id)->update(array('user_id' => 0))) { + return false; + } + // All private projects are removed $project_ids = $db->table(Project::TABLE) ->eq('is_private', 1) -- cgit v1.2.3