[libeufin] branch master updated: Bring 'make check' to pass again.

[gnunet]

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

ms pushed a commit to branch master
in repository libeufin.

The following commit(s) were added to refs/heads/master by this push:
     new ccc380d6 Bring 'make check' to pass again.
ccc380d6 is described below

commit ccc380d636834af2cb2ff45639dc7871a532a58b
Author: MS <ms@taler.net>
AuthorDate: Mon Aug 28 12:18:40 2023 +0200

    Bring 'make check' to pass again.
    
    The breakage was due to the (obsolete) Nexus SQL.
---
 database-versioning/nexus-0001.sql | 19 +++++++------------
 1 file changed, 7 insertions(+), 12 deletions(-)

diff --git a/database-versioning/nexus-0001.sql 
b/database-versioning/nexus-0001.sql
index 8c9e076f..00197265 100644
--- a/database-versioning/nexus-0001.sql
+++ b/database-versioning/nexus-0001.sql
@@ -5,23 +5,18 @@ BEGIN;
 SELECT _v.register_patch('nexus-0001', NULL, NULL);
 
 CREATE TABLE IF NOT EXISTS nexususers 
-  (id BIGINT GENERATED BY DEFAULT AS IDENTITY
-  ,username TEXT NOT NULL PRIMARY KEY
-  ,password TEXT NOT NULL
-  ,superuser BOOLEAN NOT NULL DEFAULT (false)
+  (id BIGSERIAL PRIMARY KEY
+  ,username TEXT NOT NULL
+  ,"password" TEXT NOT NULL
+  ,superuser BOOLEAN NOT NULL
   );
 
-COMMENT ON TABLE nexususers
-  IS 'xxx';
-COMMENT ON COLUMN nexususers.password
-  IS 'hashed password - FIXME: which hash, how encoded, salted?';
-
 CREATE TABLE IF NOT EXISTS nexusbankconnections 
   (id BIGSERIAL PRIMARY KEY
   ,"connectionId" TEXT NOT NULL
-  ,type TEXT NOT NULL
-  ,dialect TEXT NULL
-  ,user BIGINT NOT NULL 
+  ,"type" TEXT NOT NULL
+  ,dialect TEXT
+  ,"user" BIGINT NOT NULL 
   ,CONSTRAINT fk_nexusbankconnections_user_id FOREIGN KEY ("user") REFERENCES 
nexususers(id) ON DELETE RESTRICT ON UPDATE RESTRICT
   );
 

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.