From 6854cb3f4d8219cf1829e32122eb2502a916eae9 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
Date: Sat, 1 Feb 2020 09:05:48 +0100
Subject: initial checkin

---
 setup/upgrade/0.9.9/upgrade_assignments.php | 31 +++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)
 create mode 100644 setup/upgrade/0.9.9/upgrade_assignments.php

(limited to 'setup/upgrade/0.9.9/upgrade_assignments.php')

diff --git a/setup/upgrade/0.9.9/upgrade_assignments.php b/setup/upgrade/0.9.9/upgrade_assignments.php
new file mode 100644
index 0000000..a9aa53c
--- /dev/null
+++ b/setup/upgrade/0.9.9/upgrade_assignments.php
@@ -0,0 +1,31 @@
+<?php
+   /**********************************************************\
+   | This script moves data from {dbprefix)tasks.assigned_to   |
+   | to {dbprefix}assigned.  This is to implement multiple     |
+   | assignees per task as described in FS#329.  It only needs |
+   | to be run once to do the conversion.                      |
+   \***********************************************************/
+
+$check_sql = $db->query("SELECT task_id, assigned_to
+                           FROM {tasks}
+                          WHERE assigned_to > '0'");
+
+while ($row = $db->fetchRow($check_sql))
+{
+   $check = $db->query('SELECT assigned_id FROM {assigned} WHERE task_id = ? AND user_id = ?',
+                       array($row['task_id'], $row['assigned_to']));
+   if ($db->fetchOne($check)) {
+       continue;
+   }
+
+   $db->query('INSERT INTO {assigned}
+                           (task_id, user_id)
+                    VALUES (?,?)',
+                           array($row['task_id'], $row['assigned_to']));
+
+   $db->query('UPDATE {tasks}
+                  SET assigned_to = 0
+                WHERE task_id = ?',
+                      array($row['task_id']));
+}
+?>
-- 
cgit v1.2.3-70-g09d2