diff options
author | priscilla <priscilla.huang@efrei.net> | 2023-02-21 12:39:40 -0500 |
---|---|---|
committer | priscilla <priscilla.huang@efrei.net> | 2023-02-21 12:39:48 -0500 |
commit | 9ac6fc8c84748f3de070b44822ec47c4f854bd15 (patch) | |
tree | 2f2ebb96c9b5c0b64791c16dfc7412e800e5a8d8 /src/backenddb/merchant-0004.sql | |
parent | 7aace51b40c2b63a64aa5d0e7f66b9819b0a07f6 (diff) | |
download | merchant-9ac6fc8c84748f3de070b44822ec47c4f854bd15.tar.gz merchant-9ac6fc8c84748f3de070b44822ec47c4f854bd15.tar.bz2 merchant-9ac6fc8c84748f3de070b44822ec47c4f854bd15.zip |
update changes
Diffstat (limited to 'src/backenddb/merchant-0004.sql')
-rw-r--r-- | src/backenddb/merchant-0004.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/backenddb/merchant-0004.sql b/src/backenddb/merchant-0004.sql index 7c86a636..e74ff1f9 100644 --- a/src/backenddb/merchant-0004.sql +++ b/src/backenddb/merchant-0004.sql @@ -32,7 +32,8 @@ CREATE TABLE IF NOT EXISTS merchant_template REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE ,template_id VARCHAR NOT NULL ,template_description VARCHAR NOT NULL - ,pos_key VARCHAR + ,pos_key VARCHAR DEFAULT NULL, + ,pos_algorithm INT NOT NULL DEFAULT (0); ,template_contract VARCHAR NOT NULL -- in JSON format ,UNIQUE (merchant_serial, template_id) ); @@ -42,6 +43,8 @@ COMMENT ON COLUMN merchant_template.template_description IS 'Human-readable template description'; COMMENT ON COLUMN merchant_template.pos_key IS 'A base64-encoded key of the point-of-sale. It will be use by the TOTP'; +COMMENT ON COLUMN merchant_template.pos_algorithm + IS 'algorithm to used to generate the confirmation code. It is link with the pos_key'; COMMENT ON COLUMN merchant_template.template_contract IS 'The template contract will contains some additional information.'; |