[taler-anastasis] branch master updated: -migrate to Postgress 11: use BIGINT GENERATED BY DEFAULT AS IDENTITY instead of BIGSERIAL

[gnunet]

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

grothoff pushed a commit to branch master
in repository anastasis.

The following commit(s) were added to refs/heads/master by this push:
     new aab703a  -migrate to Postgress 11: use BIGINT GENERATED BY DEFAULT AS 
IDENTITY instead of BIGSERIAL
aab703a is described below

commit aab703a7e3047c61cfd0f84290251c982c5ba97b
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Thu Feb 17 23:09:12 2022 +0100

    -migrate to Postgress 11: use BIGINT GENERATED BY DEFAULT AS IDENTITY 
instead of BIGSERIAL
---
 src/stasis/stasis-0001.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/stasis/stasis-0001.sql b/src/stasis/stasis-0001.sql
index d512473..38e60fc 100644
--- a/src/stasis/stasis-0001.sql
+++ b/src/stasis/stasis-0001.sql
@@ -73,7 +73,7 @@ COMMENT ON COLUMN anastasis_user.expiration_date
 
 
 CREATE TABLE IF NOT EXISTS anastasis_recdoc_payment
-  (payment_id BIGSERIAL PRIMARY KEY,
+  (payment_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    user_id BYTEA NOT NULL REFERENCES anastasis_user(user_id),
    post_counter INT4 NOT NULL DEFAULT 0 CHECK(post_counter >= 0),
    amount_val INT8 NOT NULL,
@@ -102,7 +102,7 @@ COMMENT ON COLUMN anastasis_recdoc_payment.paid
 
 
 CREATE TABLE IF NOT EXISTS anastasis_challenge_payment
-  (payment_id BIGSERIAL PRIMARY KEY,
+  (payment_id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    truth_uuid BYTEA CHECK(LENGTH(truth_uuid)=32) NOT NULL,
    amount_val INT8 NOT NULL,
    amount_frac INT4 NOT NULL,
@@ -200,7 +200,7 @@ COMMENT ON INDEX anastasis_challengecode_expiration_index
 
 
 CREATE TABLE IF NOT EXISTS anastasis_auth_iban_in
-  (auth_in_serial_id BIGSERIAL UNIQUE
+  (auth_in_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
   ,wire_reference INT8 NOT NULL PRIMARY KEY
   ,wire_subject TEXT NOT NULL
   ,credit_val INT8 NOT NULL

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