diff options
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.'; |