Save pending/closing time stamps for misc support issues

[bpt/portal.git] / tables.sql

diff --git a/tables.sql b/tables.sql
index e28196a..682f44d 100644 (file)
--- a/tables.sql
+++ b/tables.sql
@@ -181,6 +181,8 @@ CREATE TABLE SupIssue(
        priv BOOLEAN NOT NULL,
        status INTEGER NOT NULL,
        stamp TIMESTAMP NOT NULL,
+       pstamp TIMESTAMP,
+       cstamp TIMESTAMP,
        FOREIGN KEY (usr) REFERENCES WebUser(id) ON DELETE CASCADE,
        FOREIGN KEY (cat) REFERENCES SupCategory(id) ON DELETE CASCADE);