diff options
Diffstat (limited to 'src/schema.sql')
-rw-r--r-- | src/schema.sql | 4 |
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) ); |