diff options
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
-rw-r--r-- | src/backenddb/merchant-0001.sql | 25 |
1 files changed, 25 insertions, 0 deletions
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), |