[taler-merchant] 07/19: db: better naming for validity period

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository merchant.

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

    db: better naming for validity period
---
 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
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.';

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.