libeufin

commit e8f5586203391569159401156b7694314bef675b
parent 69453219c1bd2090dfed4b29a7583f693d8f675c
Author: MS <ms@taler.net>
Date:   Fri, 21 Jul 2023 21:16:43 +0200

placing FIXMEs in the SQL

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
@@ -43,9 +43,9 @@ CREATE TABLE IF NOT EXISTS BankAccounts
   ,"label" TEXT NOT NULL UNIQUE
   ,"owner" TEXT NOT NULL
   ,"isPublic" BOOLEAN DEFAULT false NOT NULL
-  ,"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
+  ,"demoBank" FIXME_TYPE REFERENCES DemobankConfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,"lastTransaction" FIXME_TYPE NULL REFERENCES BankAccountTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT -- FIXME: under discussion on MM, might be removed.
+  ,"lastFiatSubmission" FIXME_TYPE NULL REFERENCES BankAccountTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
   ,"lastFiatFetch" TEXT DEFAULT '0' NOT NULL
   ,"balance" TEXT DEFAULT '0'
   );
@@ -71,7 +71,7 @@ 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 NOT NULL REFERENCES DemobankConfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,demobank FIXME_TYPE NOT NULL REFERENCES DemobankConfigs(id) ON DELETE RESTRICT ON UPDATE RESTRICT
   );
 
 -- end of: money transactions
@@ -80,7 +80,7 @@ CREATE TABLE IF NOT EXISTS BankAccountTransactions
 
 CREATE TABLE IF NOT EXISTS CashoutSubmissions 
   (id BIGSERIAL PRIMARY KEY
-  ,"localTransaction" NOT NULL UNIQUE REFERENCES BankAccountTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,"localTransaction" FIXME_TYPE NOT NULL UNIQUE REFERENCES BankAccountTransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
   ,"maybeNexusResponse" TEXT NULL
   ,"submissionTime" BIGINT NULL
   );
@@ -182,7 +182,7 @@ CREATE TABLE IF NOT EXISTS EbicsOrderSignatures
 
 CREATE TABLE IF NOT EXISTS BankAccountFreshTransactions 
   (id BIGSERIAL PRIMARY KEY
-  ,"transaction" NOT NULL REFERENCES BankAccountTransactions(id) ON DELETE CASCADE ON UPDATE RESTRICT
+  ,"transaction" FIXME_TYPE NOT NULL REFERENCES BankAccountTransactions(id) ON DELETE CASCADE ON UPDATE RESTRICT
   );
 
 CREATE TABLE IF NOT EXISTS BankAccountReports