branch master updated: sql: Add missing table.

[Mathieu Othacehe]

This is an automated email from the git hooks/post-receive script.

mothacehe pushed a commit to branch master
in repository guix-cuirass.

The following commit(s) were added to refs/heads/master by this push:
     new e1382f0  sql: Add missing table.
e1382f0 is described below

commit e1382f0303d282017aa5d68f0e870863070f28c0
Author: Mathieu Othacehe <othacehe@gnu.org>
AuthorDate: Tue May 25 15:14:06 2021 +0200

    sql: Add missing table.
    
    * src/sql/upgrade-11.sql: Add missing table.
---
 src/sql/upgrade-11.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/src/sql/upgrade-11.sql b/src/sql/upgrade-11.sql
index 16fbb2a..84f34c0 100644
--- a/src/sql/upgrade-11.sql
+++ b/src/sql/upgrade-11.sql
@@ -1,5 +1,13 @@
 BEGIN TRANSACTION;
 
+CREATE TABLE BuildDependencies (
+  source        INTEGER NOT NULL,
+  target        INTEGER NOT NULL,
+  PRIMARY KEY (source, target),
+  FOREIGN KEY (source) REFERENCES Builds(id) ON DELETE CASCADE,
+  FOREIGN KEY (target) REFERENCES Builds(id) ON DELETE CASCADE
+);
+
 CREATE FUNCTION build_dependencies(build bigint)
 RETURNS TABLE (dependencies text) AS $$
 SELECT string_agg(cast(BD.target AS text), ',')