From b690505b0e1e255e5081adcf49c724186bb831c2 Mon Sep 17 00:00:00 2001
From: Malf Furious <m@lfurio.us>
Date: Sat, 20 Oct 2018 21:49:32 -0400
Subject: issue:  Add assigned timestamp

---
 app/class/issue.class.php | 2 ++
 srvs/mysql.sql            | 1 +
 2 files changed, 3 insertions(+)

diff --git a/app/class/issue.class.php b/app/class/issue.class.php
index 5d1daec..57fc588 100644
--- a/app/class/issue.class.php
+++ b/app/class/issue.class.php
@@ -37,6 +37,7 @@ class issue extends obj
             "seen",
             "description",
             "opened",
+            "assigned",
             "authored",
             "closed",
             "due",
@@ -89,6 +90,7 @@ class issue extends obj
     {
         $this->seen = 0;
         $this->assignee = $assignee->guid;
+        $this->assigned = self::getCurrentTimestamp();
         $this->saveObj();
     }
 
diff --git a/srvs/mysql.sql b/srvs/mysql.sql
index 9f3193b..9bad437 100644
--- a/srvs/mysql.sql
+++ b/srvs/mysql.sql
@@ -185,6 +185,7 @@ CREATE TABLE issues (
     seen        int(1)              NOT NULL    DEFAULT 0,      /* has the assignee seen this yet? */
     description text                NOT NULL,
     opened      varchar(64)         NOT NULL    DEFAULT '',
+    assigned    varchar(64)         NOT NULL    DEFAULT '',
     authored    varchar(64)         NOT NULL    DEFAULT '',
     closed      varchar(64)         NOT NULL    DEFAULT '',
     due         varchar(64)         NOT NULL    DEFAULT '',
-- 
cgit v1.2.3