[taler-grid5k] 19/189: update shard sql

[gnunet]

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

marco-boss pushed a commit to branch master
in repository grid5k.

commit 8109d4658cfe3e077b6d2cf09b3a4c568bb6770d
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Tue Feb 22 10:01:07 2022 +0100

    update shard sql
---
 sql/exchange-shard-0000.sql | 44 ++++++++++++++++++++++----------------------
 1 file changed, 22 insertions(+), 22 deletions(-)

diff --git a/sql/exchange-shard-0000.sql b/sql/exchange-shard-0000.sql
index 836baca..dfbca38 100644
--- a/sql/exchange-shard-0000.sql
+++ b/sql/exchange-shard-0000.sql
@@ -6,7 +6,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I ' 
-      '(wire_target_serial_id BIGSERIAL UNIQUE '
+      '(wire_target_serial_id BIGINT UNIQUE '
       ',h_payto BYTEA PRIMARY KEY CHECK (LENGTH(h_payto)=64) '
       ',payto_uri VARCHAR NOT NULL '
       ',kyc_ok BOOLEAN NOT NULL DEFAULT (FALSE) '
@@ -17,7 +17,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(reserve_uuid BIGSERIAL '
+      '(reserve_uuid BIGINT '
       ',reserve_pub BYTEA PRIMARY KEY CHECK(LENGTH(reserve_pub)=32) '
       ',current_balance_val INT8 NOT NULL '
       ',current_balance_frac INT4 NOT NULL '
@@ -29,7 +29,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(reserve_in_serial_id BIGSERIAL '
+      '(reserve_in_serial_id BIGINT UNIQUE '
       ',reserve_pub BYTEA PRIMARY KEY '
       ',wire_reference INT8 NOT NULL '
       ',credit_val INT8 NOT NULL '
@@ -43,7 +43,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(close_uuid BIGSERIAL PRIMARY KEY '
+      '(close_uuid BIGINT PRIMARY KEY '
       ',reserve_pub BYTEA NOT NULL '
       ',execution_date INT8 NOT NULL '
       ',wtid BYTEA NOT NULL CHECK (LENGTH(wtid)=32) '
@@ -58,8 +58,8 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(reserve_out_serial_id BIGSERIAL UNIQUE '
-      ',h_blind_ev BYTEA PRIMARY KEY CHECK (LENGTH(h_blind_ev)=64) '
+      '(reserve_out_serial_id BIGINT UNIQUE '
+      ',h_blind_ev BYTEA CHECK (LENGTH(h_blind_ev)=64) UNIQUE'
       ',denominations_serial INT8 NOT NULL '
       ',denom_sig BYTEA NOT NULL '
       ',reserve_uuid INT8 NOT NULL '
@@ -73,7 +73,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(known_coin_id BIGSERIAL UNIQUE '
+      '(known_coin_id BIGINT UNIQUE '
       ',denominations_serial INT8 NOT NULL '
       ',coin_pub BYTEA NOT NULL PRIMARY KEY CHECK (LENGTH(coin_pub)=32) '
       ',age_hash BYTEA CHECK (LENGTH(age_hash)=32) '
@@ -86,7 +86,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(melt_serial_id BIGSERIAL UNIQUE '
+      '(melt_serial_id BIGINT UNIQUE '
       ',rc BYTEA PRIMARY KEY CHECK (LENGTH(rc)=64) '
       ',old_coin_pub BYTEA NOT NULL '
       ',old_coin_sig BYTEA NOT NULL CHECK(LENGTH(old_coin_sig)=64) '
@@ -99,14 +99,14 @@ BEGIN
   
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(rrc_serial BIGSERIAL UNIQUE '
+      '(rrc_serial BIGINT UNIQUE '
       ',melt_serial_id INT8 NOT NULL '
       ',freshcoin_index INT4 NOT NULL '
       ',link_sig BYTEA NOT NULL CHECK(LENGTH(link_sig)=64) '
       ',denominations_serial INT8 NOT NULL '
-      ',coin_ev BYTEA NOT NULL '
-      ',h_coin_ev BYTEA NOT NULL CHECK(LENGTH(h_coin_ev)=64) '
-      ',ev_sig BYTEA NOT NULL UNIQUE '
+      ',coin_ev BYTEA NOT NULL UNIQUE'
+      ',h_coin_ev BYTEA NOT NULL CHECK(LENGTH(h_coin_ev)=64) UNIQUE'
+      ',ev_sig BYTEA NOT NULL '
       ',ewv BYTEA NOT NULL '
       ',PRIMARY KEY (melt_serial_id, freshcoin_index) '
     ')',
@@ -114,8 +114,8 @@ BEGIN
   );
   
   EXECUTE FORMAT(
-    'CREATE TABLE IF NOT EXISTS refresh_transfer_keys '
-      '(rtc_serial BIGSERIAL UNIQUE '
+    'CREATE TABLE IF NOT EXISTS %I '
+      '(rtc_serial BIGINT UNIQUE '
       ',melt_serial_id INT8 PRIMARY KEY '
       ',transfer_pub BYTEA NOT NULL CHECK(LENGTH(transfer_pub)=32) '
       ',transfer_privs BYTEA NOT NULL '
@@ -125,7 +125,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(deposit_serial_id BIGSERIAL PRIMARY KEY '
+      '(deposit_serial_id BIGINT PRIMARY KEY '
       ',shard INT8 NOT NULL '
       ',known_coin_id INT8 NOT NULL '
       ',amount_with_fee_val INT8 NOT NULL '
@@ -150,7 +150,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(refund_serial_id BIGSERIAL UNIQUE'
+      '(refund_serial_id BIGINT UNIQUE'
       ',deposit_serial_id INT8 NOT NULL '
       ',merchant_sig BYTEA NOT NULL CHECK(LENGTH(merchant_sig)=64) '
       ',rtransaction_id INT8 NOT NULL '
@@ -163,7 +163,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(wireout_uuid BIGSERIAL PRIMARY KEY'
+      '(wireout_uuid BIGINT PRIMARY KEY'
       ',execution_date INT8 NOT NULL '
       ',wtid_raw BYTEA UNIQUE NOT NULL CHECK (LENGTH(wtid_raw)=32) '
       ',wire_target_serial_id INT8 NOT NULL '
@@ -176,7 +176,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(aggregation_serial_id BIGSERIAL '
+      '(aggregation_serial_id BIGINT UNIQUE '
       ',deposit_serial_id INT8 PRIMARY KEY '
       ',wtid_raw BYTEA ' 
     ')',
@@ -185,7 +185,7 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(recoup_uuid BIGSERIAL '
+      '(recoup_uuid BIGINT UNIQUE '
       ',known_coin_id INT8 NOT NULL '
       ',coin_sig BYTEA NOT NULL CHECK(LENGTH(coin_sig)=64) '
       ',coin_blind BYTEA NOT NULL CHECK(LENGTH(coin_blind)=32) '
@@ -199,21 +199,21 @@ BEGIN
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(recoup_refresh_uuid BIGSERIAL '
+      '(recoup_refresh_uuid BIGINT UNIQUE '
       ',known_coin_id INT8 NOT NULL '
       ',coin_sig BYTEA NOT NULL CHECK(LENGTH(coin_sig)=64) '
       ',coin_blind BYTEA NOT NULL CHECK(LENGTH(coin_blind)=32) '
       ',amount_val INT8 NOT NULL '
       ',amount_frac INT4 NOT NULL '
       ',recoup_timestamp INT8 NOT NULL '
-      ',rrc_serial INT8 NOT NULL '
+      ',rrc_serial INT8 NOT NULL UNIQUE'
     ')',
     'recoup_refresh_' || suffix
   );
 
   EXECUTE FORMAT(
     'CREATE TABLE IF NOT EXISTS %I '
-      '(prewire_uuid BIGSERIAL PRIMARY KEY '
+      '(prewire_uuid BIGINT PRIMARY KEY '
       ',wire_method TEXT NOT NULL '
       ',finished BOOLEAN NOT NULL DEFAULT false '
       ',failed BOOLEAN NOT NULL DEFAULT false '

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