exchange

commit 50ee0286c18a7491e6a0c18b706f7598748316d0
parent 736fafe3f5195eeb8184e7a7289e30e2a2d6583f
Author: Christian Grothoff <christian@grothoff.org>
Date:   Wed,  7 May 2025 21:24:19 +0200

drop very bad primary key constraint

Diffstat:
M
src/exchangedb/0002-kyc_attributes.sql
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/src/exchangedb/0002-kyc_attributes.sql b/src/exchangedb/0002-kyc_attributes.sql
@@ -26,7 +26,7 @@ BEGIN
   PERFORM create_partitioned_table(
     'CREATE TABLE IF NOT EXISTS %I'
       '(kyc_attributes_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY'
-      ',h_payto BYTEA PRIMARY KEY CHECK (LENGTH(h_payto)=32)'
+      ',h_payto BYTEA CHECK (LENGTH(h_payto)=32)'
       ',collection_time INT8 NOT NULL'
       ',expiration_time INT8 NOT NULL'
       ',encrypted_attributes BYTEA NOT NULL'