[taler-merchant] branch master updated: define table for login tokens

[gnunet]

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

grothoff pushed a commit to branch master
in repository merchant.

The following commit(s) were added to refs/heads/master by this push:
     new 631ba9db define table for login tokens
631ba9db is described below

commit 631ba9db07f0613fd3ec673932dae1f68e86ae80
Author: Christian Grothoff <grothoff@gnunet.org>
AuthorDate: Tue Sep 5 23:39:47 2023 +0200

    define table for login tokens
---
 src/backenddb/merchant-0001.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)

diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql
index 4d286db6..03474831 100644
--- a/src/backenddb/merchant-0001.sql
+++ b/src/backenddb/merchant-0001.sql
@@ -118,6 +118,31 @@ COMMENT ON COLUMN merchant_instances.user_type
   IS 'what type of user is this (individual or business)';
 
 
+CREATE TABLE IF NOT EXISTS merchant_login_tokens
+  (token BYTEA NOT NULL UNIQUE CHECK (LENGTH(token)=32),
+   creation_time INT8 NOT NULL,
+   expiration_time INT8 NOT NULL,
+   validity_scope INT4 NOT NULL,
+   merchant_serial BIGINT
+     REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE
+  );
+COMMENT ON TABLE merchant_login_tokens
+  IS 'login tokens that have been created for the given instance';
+COMMENT ON COLUMN merchant_login_tokens.token
+  IS 'binary value of the login token';
+COMMENT ON COLUMN merchant_login_tokens.creation_time
+  IS 'time when the token was created';
+COMMENT ON COLUMN merchant_login_tokens.expiration_time
+  IS 'determines when the token expires';
+COMMENT ON COLUMN merchant_login_tokens.merchant_scope
+  IS 'identifies the opeations for which the token is valid';
+COMMENT ON COLUMN merchant_login_tokens.merchant_serial
+  IS 'identifies the instance for which the token is valid';
+
+CREATE INDEX IF NOT EXISTS merchant_login_tokens_by_expiration
+  ON merchant_login_tokens
+    (expiration_time);
+
 
 CREATE TABLE IF NOT EXISTS merchant_keys
   (merchant_priv BYTEA NOT NULL UNIQUE CHECK (LENGTH(merchant_priv)=32),

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