libeufin

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

Bring 'make check' to pass again.

The breakage was due to the (obsolete) Nexus SQL.

Diffstat:
M
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
@@ -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
   );