From deeebd8e72a13fcbe6d357aefed9130671ee5161 Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Sat, 11 Oct 2014 21:14:16 -0400 Subject: Sqlite: change column type to numeric --- app/Schema/Sqlite.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php index 45a6fb22..f290c824 100644 --- a/app/Schema/Sqlite.php +++ b/app/Schema/Sqlite.php @@ -10,8 +10,8 @@ const VERSION = 32; function version_32($pdo) { $pdo->exec("ALTER TABLE tasks ADD COLUMN date_started INTEGER"); - $pdo->exec("ALTER TABLE tasks ADD COLUMN time_spent FLOAT DEFAULT 0"); - $pdo->exec("ALTER TABLE tasks ADD COLUMN time_estimated FLOAT DEFAULT 0"); + $pdo->exec("ALTER TABLE tasks ADD COLUMN time_spent NUMERIC DEFAULT 0"); + $pdo->exec("ALTER TABLE tasks ADD COLUMN time_estimated NUMERIC DEFAULT 0"); } function version_31($pdo) -- cgit v1.2.3