schema: Builds: Add 'evaluation' column.

* src/schema.sql (Builds): Add 'evaluation' column.
* src/cuirass/database.scm (db-add-build): Adapt.
* src/cuirass/base.scm (build-packages): Likewise.

1 files changed, 9 insertions, 5 deletions

diff --git a/src/schema.sql b/src/schema.sql
index 248f9d2..725d145 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -34,12 +34,16 @@ CREATE TABLE Derivations (
   FOREIGN KEY (evaluation) REFERENCES Evaluations (id)
 );
 
+-- Builds are not in a one to one relationship with derivations in order to
+-- keep track of non deterministic compilations.
 CREATE TABLE Builds (
-  id              INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-  derivation      TEXT NOT NULL,
-  log             TEXT NOT NULL,
-  output          TEXT,         -- NULL if build failed
-  FOREIGN KEY (derivation) REFERENCES Evaluations (derivation)
+  derivation    TEXT NOT NULL,
+  evaluation    INTEGER NOT NULL,
+  log           TEXT NOT NULL,
+  output        TEXT,		-- NULL if build failed
+  PRIMARY KEY (derivation, evaluation),
+  FOREIGN KEY (derivation) REFERENCES Derivations (derivation),
+  FOREIGN KEY (evaluation) REFERENCES Evaluations (id)
 );
 
 COMMIT;