diff options
| -rw-r--r-- | src/backenddb/merchant-0002.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/backenddb/merchant-0002.sql b/src/backenddb/merchant-0002.sql index 2b6af4eb..c2fffb43 100644 --- a/src/backenddb/merchant-0002.sql +++ b/src/backenddb/merchant-0002.sql @@ -72,22 +72,22 @@ COMMENT ON COLUMN merchant_token_families.redeemed CREATE TABLE IF NOT EXISTS merchant_token_keys (token_keys_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY ,token_family_serial BIGINT REFERENCES merchant_token_families(token_family_serial) ON DELETE CASCADE - ,start_date BIGINT NOT NULL - ,expiration_date BIGINT NOT NULL + ,valid_after BIGINT NOT NULL + ,valid_before BIGINT NOT NULL ,pub BYTEA NOT NULL ,h_pub BYTEA NOT NULL UNIQUE CHECK (LENGTH(h_pub)=32) ,priv BYTEA ,cipher TEXT NOT NULL CHECK (cipher IN ('rsa', 'cs')) - ,UNIQUE (token_family_serial, start_date) + ,UNIQUE (token_family_serial, valid_after) ); COMMENT ON TABLE merchant_token_keys IS 'Keys for token families.'; COMMENT ON COLUMN merchant_token_keys.token_family_serial IS 'Token family to which the key belongs.'; -COMMENT ON COLUMN merchant_token_keys.start_date +COMMENT ON COLUMN merchant_token_keys.valid_after IS 'Start date/time for the validity of the token key.'; -COMMENT ON COLUMN merchant_token_keys.expiration_date +COMMENT ON COLUMN merchant_token_keys.valid_before IS 'Expiration date/time for the validity of the token key.'; COMMENT ON COLUMN merchant_token_keys.pub IS 'Public key of the token family.'; |