From 5a29cccc959dfd0be5fdc279ac1170d2db0b3040 Mon Sep 17 00:00:00 2001 From: Frederic Guillot Date: Fri, 3 Apr 2015 18:32:51 -0400 Subject: Various fixes for PHPAnalyzer --- app/Schema/Mysql.php | 1 + app/Schema/Postgres.php | 1 + app/Schema/Sqlite.php | 1 + 3 files changed, 3 insertions(+) (limited to 'app/Schema') diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index 2dcfd3b7..e5269d93 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -162,6 +162,7 @@ function version_49($pdo) $pdo->exec('ALTER TABLE subtasks ADD COLUMN position INTEGER DEFAULT 1'); $task_id = 0; + $position = 1; $urq = $pdo->prepare('UPDATE subtasks SET position=? WHERE id=?'); $rq = $pdo->prepare('SELECT * FROM subtasks ORDER BY task_id, id ASC'); diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php index 6c6ea001..2c5e0f28 100644 --- a/app/Schema/Postgres.php +++ b/app/Schema/Postgres.php @@ -155,6 +155,7 @@ function version_30($pdo) $pdo->exec('ALTER TABLE subtasks ADD COLUMN position INTEGER DEFAULT 1'); $task_id = 0; + $position = 1; $urq = $pdo->prepare('UPDATE subtasks SET position=? WHERE id=?'); $rq = $pdo->prepare('SELECT * FROM subtasks ORDER BY task_id, id ASC'); diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php index ef6523e4..b9c264bc 100644 --- a/app/Schema/Sqlite.php +++ b/app/Schema/Sqlite.php @@ -157,6 +157,7 @@ function version_48($pdo) // Migrate all subtasks position $task_id = 0; + $position = 1; $urq = $pdo->prepare('UPDATE subtasks SET position=? WHERE id=?'); $rq = $pdo->prepare('SELECT * FROM subtasks ORDER BY task_id, id ASC'); -- cgit v1.2.3