From deeebd8e72a13fcbe6d357aefed9130671ee5161 Mon Sep 17 00:00:00 2001
From: Frédéric Guillot <fred@kanboard.net>
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(-)
(limited to 'app')
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