[taler-grid5k] 38/189: test

[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 c31c8d16dcbd6126bd0c8d7c2dfac028aea56e98
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Sun Feb 27 17:25:18 2022 +0100

    test
---
 sql/exchange-0001.sql | 9 +++++----
 1 file changed, 5 insertions(+), 4 deletions(-)

diff --git a/sql/exchange-0001.sql b/sql/exchange-0001.sql
index 184d62a..b65422f 100644
--- a/sql/exchange-0001.sql
+++ b/sql/exchange-0001.sql
@@ -67,13 +67,13 @@ COMMENT ON TABLE denomination_revocations
 
 
 CREATE TABLE IF NOT EXISTS wire_targets
-  (wire_target_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY -- UNIQUE
-  ,h_payto BYTEA PRIMARY KEY CHECK (LENGTH(h_payto)=64)
+  (wire_target_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY UNIQUE
+  ,h_payto BYTEA CHECK (LENGTH(h_payto)=64)
   ,payto_uri VARCHAR NOT NULL
   ,kyc_ok BOOLEAN NOT NULL DEFAULT (FALSE)
   ,external_id VARCHAR
   )
-  PARTITION BY HASH (h_payto);
+  PARTITION BY HASH (wire_target_serial_id);
 COMMENT ON TABLE wire_targets
   IS 'All senders and recipients of money via the exchange';
 COMMENT ON COLUMN wire_targets.payto_uri
@@ -91,9 +91,10 @@ CREATE TABLE IF NOT EXISTS wire_targets_default
 -- FIXME partition by serial_id rather than h_payto, 
 -- it is used more in join conditions - crucial for sharding to select this.
 -- Author: (Boss Marco)
-CREATE INDEX IF NOT EXISTS wire_targets_serial_id_index
+CREATE INDEX IF NOT EXISTS wire_targets_serial_payto_index
   ON wire_targets
   (wire_target_serial_id
+   ,h_payto
   );
 
 CREATE TABLE IF NOT EXISTS reserves

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