diff options
Diffstat (limited to 'app/Schema/Postgres.php')
| -rw-r--r-- | app/Schema/Postgres.php | 13 |
1 files changed, 6 insertions, 7 deletions
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php index 517ded85..0cc31616 100644 --- a/app/Schema/Postgres.php +++ b/app/Schema/Postgres.php @@ -399,7 +399,6 @@ function version_30($pdo) $rq->execute(); foreach ($rq->fetchAll(PDO::FETCH_ASSOC) as $subtask) { - if ($task_id != $subtask['task_id']) { $position = 1; $task_id = $subtask['task_id']; @@ -459,13 +458,13 @@ function version_27($pdo) function version_26($pdo) { - $pdo->exec('ALTER TABLE tasks ADD COLUMN date_moved INT DEFAULT 0'); + $pdo->exec('ALTER TABLE tasks ADD COLUMN date_moved INT DEFAULT 0'); - /* Update tasks.date_moved from project_activities table if tasks.date_moved = null or 0. - * We take max project_activities.date_creation where event_name in task.create','task.move.column - * since creation date is always less than task moves - */ - $pdo->exec("UPDATE tasks + /* Update tasks.date_moved from project_activities table if tasks.date_moved = null or 0. + * We take max project_activities.date_creation where event_name in task.create','task.move.column + * since creation date is always less than task moves + */ + $pdo->exec("UPDATE tasks SET date_moved = ( SELECT md FROM ( |