aboutsummaryrefslogtreecommitdiff
path: root/src/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/schema.sql')
-rw-r--r--src/schema.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/src/schema.sql b/src/schema.sql
index 5ea1ff7..d1b38ae 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -31,6 +31,7 @@ CREATE TABLE Checkouts (
evaluation INTEGER NOT NULL,
input TEXT NOT NULL,
directory TEXT NOT NULL,
+ timestamp INTEGER NOT NULL,
PRIMARY KEY (specification, revision),
FOREIGN KEY (evaluation) REFERENCES Evaluations (id),
FOREIGN KEY (specification) REFERENCES Specifications (name),
@@ -41,6 +42,9 @@ CREATE TABLE Evaluations (
id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
specification TEXT NOT NULL,
in_progress INTEGER NOT NULL,
+ timestamp INTEGER NOT NULL,
+ checkouttime INTEGER NOT NULL,
+ evaltime INTEGER NOT NULL,
FOREIGN KEY (specification) REFERENCES Specifications (name)
);