From 13f8f7e0e5b2361a5d3aa3f3a21519b03cd4c9c2 Mon Sep 17 00:00:00 2001
From: Jeffrey Armstrong <jeff@approximatrix.com>
Date: Fri, 26 Mar 2021 11:19:59 -0400
Subject: Started work on a template engine complete with variables.  Added a
 few database routines and some hopeful, untested changes to the sql creation
 script.

---
 captain/sql/create.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

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

diff --git a/captain/sql/create.sql b/captain/sql/create.sql
index d78c90c..9fd00d0 100644
--- a/captain/sql/create.sql
+++ b/captain/sql/create.sql
@@ -7,4 +7,6 @@ CREATE TABLE tasks(job INTEGER, task INTEGER, status INTEGER, FOREIGN KEY(job) R
 
 CREATE TABLE instructions(id INTEGER PRIMARY KEY, name TEXT NOT NULL, file TEXT NOT NULL);
 
-CREATE_TABLE available(instructions INTEGER, player INTEGER, FOREIGN KEY(instructions) REFERENCES instructions(id), FOREIGN KEY(player) REFERENCES players(id));
+CREATE_TABLE available(instruction INTEGER, player INTEGER, \
+    FOREIGN KEY(instruction) REFERENCES instructions(id), \
+    FOREIGN KEY(player) REFERENCES players(id));
-- 
cgit v1.2.3

