From a9fc9ce2035e0db07baa6e732200265a90f66332 Mon Sep 17 00:00:00 2001
From: Jeffrey Armstrong <jeff@approximatrix.com>
Date: Mon, 27 Jun 2022 16:52:40 -0400
Subject: Added player report of task type, which the captain will show in the
 job summary.

---
 captain/sql/create.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'captain/sql/create.sql')

diff --git a/captain/sql/create.sql b/captain/sql/create.sql
index 40cbc0c..323efd0 100644
--- a/captain/sql/create.sql
+++ b/captain/sql/create.sql
@@ -3,7 +3,7 @@ CREATE TABLE players(id INTEGER PRIMARY KEY, name TEXT NOT NULL, token TEXT NOT
 
 CREATE TABLE jobs(id INTEGER PRIMARY KEY, player INTEGER, instruction INTEGER, status INTEGER, time TEXT DEFAULT NULL, FOREIGN KEY(player) REFERENCES players(id), FOREIGN KEY(instruction) REFERENCES instructions(id));
 
-CREATE TABLE tasks(job INTEGER, task INTEGER, status INTEGER, FOREIGN KEY(job) REFERENCES jobs(id));
+CREATE TABLE tasks(job INTEGER, task INTEGER, status INTEGER, type TEXT DEFAULT NULL, attribute TEXT DEFAULT NULL, FOREIGN KEY(job) REFERENCES jobs(id));
 
 CREATE TABLE instructions(id INTEGER PRIMARY KEY, name TEXT UNIQUE NOT NULL);
 
-- 
cgit v1.2.3

