exchange

commit 5cd47837025ee5aac39accb5fc36882f4b7fc7b9
parent 1bfe6bbd2838311b0399f679c86cc87b4a571e70
Author: Christian Grothoff <grothoff@gnunet.org>
Date:   Wed,  7 May 2025 17:43:19 +0200

merge 4-refunds

Diffstat:
M
src/exchangedb/0002-refunds.sql
 | 
2
+-
D
src/exchangedb/0004-refunds.sql
 | 
35
-----------------------------------
M
src/exchangedb/exchange-0004.sql.in
 | 
2
--

3 files changed, 1 insertion(+), 38 deletions(-)
diff --git a/src/exchangedb/0002-refunds.sql b/src/exchangedb/0002-refunds.sql
@@ -76,7 +76,7 @@ BEGIN
     'ALTER TABLE ' || table_name ||
     ' ADD CONSTRAINT ' || table_name || '_refund_serial_id_key'
     ' UNIQUE (refund_serial_id) '
-    ',ADD PRIMARY KEY (batch_deposit_serial_id, rtransaction_id) '
+    ',ADD PRIMARY KEY (batch_deposit_serial_id, coin_pub, rtransaction_id) '
   );
 END
 $$;
diff --git a/src/exchangedb/0004-refunds.sql b/src/exchangedb/0004-refunds.sql
@@ -1,35 +0,0 @@
-
-CREATE FUNCTION constrain_table_refunds4 (
-  IN partition_suffix TEXT DEFAULT NULL
-)
-RETURNS void
-LANGUAGE plpgsql
-AS $$
-DECLARE
-  table_name TEXT DEFAULT 'refunds';
-BEGIN
-  table_name = concat_ws('_', table_name, partition_suffix);
-
-  EXECUTE FORMAT (
-    'ALTER TABLE ' || table_name ||
-    ' DROP CONSTRAINT ' || table_name || '_pkey'
-  );
-  EXECUTE FORMAT (
-    'ALTER TABLE ' || table_name ||
-    ' ADD PRIMARY KEY (batch_deposit_serial_id, coin_pub, rtransaction_id) '
-  );
-END
-$$;
-
-INSERT INTO exchange_tables
-    (name
-    ,version
-    ,action
-    ,partitioned
-    ,by_range)
-  VALUES
-    ('refunds4'
-    ,'exchange-0004'
-    ,'constrain'
-    ,TRUE
-    ,FALSE);
diff --git a/src/exchangedb/exchange-0004.sql.in b/src/exchangedb/exchange-0004.sql.in
@@ -19,6 +19,4 @@ BEGIN;
 SELECT _v.register_patch('exchange-0004', NULL, NULL);
 SET search_path TO exchange;
 
-#include "0004-refunds.sql"
-
 COMMIT;