libeufin

commit 2ff15fb7d16ca90d0df4f79b987e5e12b7a36d8d
parent e3cda62aac3375ba0867ff2b454f4f3e2b9b8529
Author: MS <ms@taler.net>
Date:   Fri, 21 Jul 2023 15:08:02 +0200

Remove BIGINT before REFERENCES.

Diffstat:
M
database-versioning/new/sandbox-0001-refactor.sql
 | 
12
++++++------

1 file changed, 6 insertions(+), 6 deletions(-)
diff --git a/database-versioning/new/sandbox-0001-refactor.sql b/database-versioning/new/sandbox-0001-refactor.sql
@@ -21,9 +21,9 @@ CREATE TABLE IF NOT EXISTS bankaccounts
   ,"label" TEXT NOT NULL UNIQUE
   ,"owner" TEXT NOT NULL
   ,"isPublic" BOOLEAN DEFAULT false NOT NULL
-  ,"demoBank" BIGINT REFERENCES demobankconfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT
-  ,"lastTransaction" BIGINT NULL REFERENCES bankaccounttransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT -- FIXME: under discussion on MM, might be removed.
-  ,"lastFiatSubmission" BIGINT NULL REFERENCES bankaccounttransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,"demoBank" REFERENCES demobankconfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,"lastTransaction" NULL REFERENCES bankaccounttransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT -- FIXME: under discussion on MM, might be removed.
+  ,"lastFiatSubmission" NULL REFERENCES bankaccounttransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
   ,"lastFiatFetch" TEXT DEFAULT '0' NOT NULL
   ,"balance" TEXT DEFAULT '0'
   );
@@ -45,12 +45,12 @@ CREATE TABLE IF NOT EXISTS bankaccounttransactions
   ,"EndToEndId" TEXT NULL
   ,direction TEXT NOT NULL
   ,account INT NOT NULL REFERENCES bankaccounts(id) ON DELETE CASCADE ON UPDATE RESTRICT
-  ,demobank BIGINT NOT NULL REFERENCES demobankconfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,demobank NOT NULL REFERENCES demobankconfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT
   );
 
 CREATE TABLE IF NOT EXISTS cashoutsubmissions 
   (id BIGSERIAL PRIMARY KEY
-  ,"localTransaction" BIGINT NOT NULL UNIQUE REFERENCES bankaccounttransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,"localTransaction" NOT NULL UNIQUE REFERENCES bankaccounttransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
   ,"maybeNexusResponse" TEXT NULL
   ,"submissionTime" BIGINT NULL
   );
@@ -132,7 +132,7 @@ CREATE TABLE IF NOT EXISTS ebicsordersignatures
 
 CREATE TABLE IF NOT EXISTS bankaccountfreshtransactions 
   (id BIGSERIAL PRIMARY KEY
-  ,"transaction" BIGINT NOT NULL REFERENCES bankaccounttransactions(id) ON DELETE CASCADE ON UPDATE RESTRICT
+  ,"transaction" NOT NULL REFERENCES bankaccounttransactions(id) ON DELETE CASCADE ON UPDATE RESTRICT
   );
 
 CREATE TABLE IF NOT EXISTS bankaccountreports