branch master updated: Fix db-get-specifications.

[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 3e65617  Fix db-get-specifications.
3e65617 is described below

commit 3e6561740958ea06bf50f8086a4066b555beacc5
Author: Mathieu Othacehe <othacehe@gnu.org>
AuthorDate: Mon Feb 22 11:12:00 2021 +0100

    Fix db-get-specifications.
    
    * src/schema.sql: Reorder fields.
    * src/cuirass/database.scm (db-get-specifications): Ditto.
---
 src/cuirass/database.scm | 2 +-
 src/schema.sql           | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/cuirass/database.scm b/src/cuirass/database.scm
index 2332cbf..815636f 100644
--- a/src/cuirass/database.scm
+++ b/src/cuirass/database.scm
@@ -473,7 +473,7 @@ SELECT * FROM Specifications ORDER BY name ASC;")))
       (match rows
         (() (reverse specs))
         (((name load-path-inputs package-path-inputs proc-input proc-file proc
-                proc-args build-outputs notifications priority)
+                proc-args build-outputs priority notifications)
           . rest)
          (loop rest
                (cons `((#:name . ,name)
diff --git a/src/schema.sql b/src/schema.sql
index 66194a9..d4929e2 100644
--- a/src/schema.sql
+++ b/src/schema.sql
@@ -13,8 +13,8 @@ CREATE TABLE Specifications (
   proc          TEXT NOT NULL, -- defined in proc_file
   proc_args     TEXT NOT NULL, -- passed to proc
   build_outputs TEXT NOT NULL, --specify what build outputs should be made 
available for download
-  notifications TEXT,
-  priority      INTEGER NOT NULL DEFAULT 0
+  priority      INTEGER NOT NULL DEFAULT 0,
+  notifications TEXT
 );
 
 CREATE TABLE Inputs (