[libeufin] branch master updated: Sandbox DB schema.

[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 87f90438 Sandbox DB schema.
87f90438 is described below

commit 87f904383d044c3d184c6170895ca9c62c576bcc
Author: MS <ms@taler.net>
AuthorDate: Thu Jul 20 14:18:35 2023 +0200

    Sandbox DB schema.
    
    Introducing the new version draft.
---
 database-versioning/sandbox-0001-refactor.sql | 191 ++++++++++++++++++++++++++
 1 file changed, 191 insertions(+)

diff --git a/database-versioning/sandbox-0001-refactor.sql 
b/database-versioning/sandbox-0001-refactor.sql
new file mode 100644
index 00000000..ed846a00
--- /dev/null
+++ b/database-versioning/sandbox-0001-refactor.sql
@@ -0,0 +1,191 @@
+-- Compatible with LibEuFin version: 1fe2687aaf696c8566367fe7ed082f1d78e6b78d
+
+BEGIN;
+
+SELECT _v.register_patch('sandbox-0001', NULL, NULL);
+
+CREATE TABLE IF NOT EXISTS demobankconfigs 
+  (id BIGSERIAL PRIMARY KEY
+  ,hostname TEXT NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS bankaccounts 
+  (id SERIAL PRIMARY KEY
+  ,iban TEXT NOT NULL
+  ,bic TEXT DEFAULT 'SANDBOXX' NOT NULL
+  ,"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
+  ,"lastFiatSubmission" BIGINT NULL REFERENCES bankaccounttransactions(id) ON 
DELETE RESTRICT ON UPDATE RESTRICT
+  ,"lastFiatFetch" TEXT DEFAULT '0' NOT NULL
+  ,"balance" TEXT DEFAULT '0'
+  );
+
+CREATE TABLE IF NOT EXISTS bankaccounttransactions 
+  (id BIGSERIAL PRIMARY KEY
+  ,"creditorIban" TEXT NOT NULL
+  ,"creditorBic" TEXT NULL
+  ,"creditorName" TEXT NOT NULL
+  ,"debtorIban" TEXT NOT NULL
+  ,"debtorBic" TEXT NULL
+  ,"debtorName" TEXT NOT NULL
+  ,subject TEXT NOT NULL
+  ,amount TEXT NOT NULL
+  ,currency TEXT NOT NULL
+  ,"date" BIGINT NOT NULL
+  ,"accountServicerReference" TEXT NOT NULL
+  ,"pmtInfId" TEXT NULL
+  ,"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
+  );
+
+CREATE TABLE IF NOT EXISTS cashoutsubmissions 
+  (id BIGSERIAL PRIMARY KEY
+  ,"localTransaction" BIGINT NOT NULL UNIQUE REFERENCES 
bankaccounttransactions(id) ON DELETE RESTRICT ON UPDATE RESTRICT
+  ,"maybeNexusResponse" TEXT NULL
+  ,"submissionTime" BIGINT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS demobankconfigpairs 
+  (id BIGSERIAL PRIMARY KEY
+  ,"demobankName" TEXT NOT NULL
+  ,"configKey" TEXT NOT NULL
+  ,"configValue" TEXT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS ebicssubscribers 
+  (id SERIAL PRIMARY KEY
+  ,"userID" TEXT NOT NULL
+  ,"partnerID" TEXT NOT NULL
+  ,"systemID" TEXT NULL
+  ,"hostID" TEXT NOT NULL
+  ,"signatureKey" INT NULL REFERENCES ebicssubscriberpublickeys(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT
+  ,"encryptionKey" INT NULL REFERENCES ebicssubscriberpublickeys(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT
+  ,"authorizationKey" INT NULL REFERENCES ebicssubscriberpublickeys(id) ON 
DELETE RESTRICT ON UPDATE RESTRICT
+  ,"nextOrderID" INT NOT NULL
+  ,"state" INT NOT NULL
+  ,"bankAccount" INT NULL REFERENCES bankaccounts(id) ON DELETE CASCADE ON 
UPDATE RESTRICT
+  );
+
+CREATE TABLE IF NOT EXISTS ebicssubscriberpublickeys
+  (id SERIAL PRIMARY KEY
+   ,"rsaPublicKey" bytea NOT NULL
+   ,"state" INT NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS ebicshosts 
+  (id SERIAL PRIMARY KEY
+  ,"hostID" TEXT NOT NULL
+  ,"ebicsVersion" TEXT NOT NULL
+  ,"signaturePrivateKey" bytea NOT NULL
+  ,"encryptionPrivateKey" bytea NOT NULL
+  ,"authenticationPrivateKey" bytea NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS ebicsdownloadtransactions 
+  ("transactionID" TEXT NOT NULL
+  ,"orderType" TEXT NOT NULL
+  ,host INT NOT NULL REFERENCES ebicshosts(id) ON DELETE RESTRICT ON UPDATE 
RESTRICT
+  ,subscriber INT NOT NULL REFERENCES ebicssubscribers(id) ON DELETE RESTRICT 
ON UPDATE RESTRICT
+  ,"encodedResponse" TEXT NOT NULL
+  ,"transactionKeyEnc" bytea NOT NULL
+  ,"numSegments" INT NOT NULL
+  ,"segmentSize" INT NOT NULL
+  ,"receiptReceived" BOOLEAN NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS ebicsuploadtransactions 
+  ("transactionID" TEXT NOT NULL
+  ,"orderType" TEXT NOT NULL
+  ,"orderID" TEXT NOT NULL
+  ,host INT NOT NULL REFERENCES ebicshosts(id) ON DELETE RESTRICT ON UPDATE 
RESTRICT
+  ,subscriber INT NOT NULL REFERENCES ebicssubscribers(id) ON DELETE RESTRICT 
ON UPDATE RESTRICT
+  ,"numSegments" INT NOT NULL
+  ,"lastSeenSegment" INT NOT NULL
+  ,"transactionKeyEnc" bytea NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS ebicsuploadtransactionchunks 
+  ("transactionID" TEXT NOT NULL
+  ,"chunkIndex" INT NOT NULL
+  ,"chunkContent" bytea NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS ebicsordersignatures 
+  (id SERIAL PRIMARY KEY
+  ,"orderID" TEXT NOT NULL
+  ,"orderType" TEXT NOT NULL
+  ,"partnerID" TEXT NOT NULL
+  ,"userID" TEXT NOT NULL
+  ,"signatureAlgorithm" TEXT NOT NULL
+  ,"signatureValue" bytea NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS bankaccountfreshtransactions 
+  (id BIGSERIAL PRIMARY KEY
+  ,"transaction" BIGINT NOT NULL REFERENCES bankaccounttransactions(id) ON 
DELETE CASCADE ON UPDATE RESTRICT
+  );
+
+CREATE TABLE IF NOT EXISTS bankaccountreports 
+  (id SERIAL PRIMARY KEY
+  ,"reportId" TEXT NOT NULL
+  ,"creationTime" BIGINT NOT NULL
+  ,"xmlMessage" TEXT NOT NULL
+  ,"bankAccount" INT NOT NULL REFERENCES bankaccounts(id) ON DELETE RESTRICT 
ON UPDATE RESTRICT
+  );
+
+CREATE TABLE IF NOT EXISTS bankaccountstatements 
+  (id SERIAL PRIMARY KEY
+  ,"statementId" TEXT NOT NULL
+  ,"creationTime" BIGINT NOT NULL
+  ,"xmlMessage" TEXT NOT NULL
+  ,"bankAccount" INT NOT NULL REFERENCES bankaccounts(id) ON DELETE RESTRICT 
ON UPDATE RESTRICT
+  ,"balanceClbd" TEXT NOT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS talerwithdrawals 
+  (id BIGSERIAL PRIMARY KEY
+  ,wopid uuid NOT NULL
+  ,amount TEXT NOT NULL
+  ,"selectionDone" BOOLEAN DEFAULT false NOT NULL
+  ,aborted BOOLEAN DEFAULT false NOT NULL
+  ,"confirmationDone" BOOLEAN DEFAULT false NOT NULL
+  ,"reservePub" TEXT NULL
+  ,"selectedExchangePayto" TEXT NULL
+  ,"walletBankAccount" INT NOT NULL REFERENCES bankaccounts(id) ON DELETE 
RESTRICT ON UPDATE RESTRICT
+  );
+
+CREATE TABLE IF NOT EXISTS demobankcustomers 
+  (id BIGSERIAL PRIMARY KEY
+  ,username TEXT NOT NULL
+  ,"passwordHash" TEXT NOT NULL
+  ,"name" TEXT NULL
+  ,email TEXT NULL
+  ,phone TEXT NULL
+  ,cashout_address TEXT NULL
+  );
+
+CREATE TABLE IF NOT EXISTS cashoutoperations 
+  (id BIGSERIAL PRIMARY KEY
+  ,uuid uuid NOT NULL
+  ,"amountDebit" TEXT NOT NULL
+  ,"amountCredit" TEXT NOT NULL
+  ,"buyAtRatio" TEXT NOT NULL
+  ,"buyInFee" TEXT NOT NULL
+  ,"sellAtRatio" TEXT NOT NULL
+  ,"sellOutFee" TEXT NOT NULL
+  ,subject TEXT NOT NULL
+  ,"creationTime" BIGINT NOT NULL
+  ,"confirmationTime" BIGINT NULL
+  ,"tanChannel" INT NOT NULL
+  ,account TEXT NOT NULL
+  ,"cashoutAddress" TEXT NOT NULL
+  ,tan TEXT NOT NULL
+  ,status INT DEFAULT 1 NOT NULL
+  );
+
+COMMIT;

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