merchant

commit f13c141f1d3f9a167f0fff32d3166db92f1ccbab
parent 6ad92a2d2ccd6a63f48123d835207e13fa32ea81
Author: Christian Blättler <blatc2@bfh.ch>
Date:   Mon, 20 Nov 2023 08:00:13 +0100

db: better naming for validity period

Diffstat:
M
src/backenddb/merchant-0002.sql
 | 
10
+++++-----

1 file changed, 5 insertions(+), 5 deletions(-)
diff --git 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.';