From 8e18c39db9dbb0d91e28006b972dbe331e6500b4 Mon Sep 17 00:00:00 2001
From: Lev Lazinskiy <lev@levlaz.org>
Date: Sun, 22 Jan 2017 09:39:30 -0800
Subject: Add date_modification to comments (PR #2950)

---
 app/Schema/Postgres.php | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

(limited to 'app/Schema/Postgres.php')

diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index 32a7a744..9c72141a 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -6,7 +6,15 @@ use PDO;
 use Kanboard\Core\Security\Token;
 use Kanboard\Core\Security\Role;
 
-const VERSION = 97;
+const VERSION = 98;
+
+function version_98(PDO $pdo)
+{
+    $pdo->exec('ALTER TABLE "comments" ADD COLUMN date_modification BIGINT');
+    $pdo->exec('UPDATE "comments"
+        SET date_modificaiton = date_creation
+        WHERE date_modification IS NULL');
+}
 
 function version_97(PDO $pdo)
 {
-- 
cgit v1.2.3