aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <grothoff@gnunet.org>2022-03-22 05:33:08 +0100
committerChristian Grothoff <grothoff@gnunet.org>2022-03-22 05:33:08 +0100
commit734b68d45e6803ef090af076e7102e6234811869 (patch)
treebd31351138c8415eac70a6510524ca6d4891e4c9 /src/exchangedb/exchange-0001.sql
parente200e860321abdff235863bd83e663ae57cf037a (diff)
downloadexchange-734b68d45e6803ef090af076e7102e6234811869.tar.xz
-fix drop SQL issue: drop functions properly
Diffstat (limited to 'src/exchangedb/exchange-0001.sql')
-rw-r--r--src/exchangedb/exchange-0001.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql
index 0e49a9fc4..a12789c5e 100644
--- a/src/exchangedb/exchange-0001.sql
+++ b/src/exchangedb/exchange-0001.sql
@@ -1405,10 +1405,10 @@ COMMENT ON COLUMN partners.master_sig
CREATE TABLE IF NOT EXISTS mergers
(merge_request_serial_id BIGSERIAL UNIQUE
- ,reserve_pub BYTEA NOT NULL REFERENCES reserves (reserve_pub) ON DELETE CASCADE
,partner_serial_id INT8 REFERENCES partners(partner_serial_id) ON DELETE CASCADE
- ,purse_pub BYTEA NOT NULL CHECK (LENGTH(purse_pub)=32)
+ ,reserve_pub BYTEA NOT NULL REFERENCES reserves (reserve_pub) ON DELETE CASCADE
,reserve_sig BYTEA NOT NULL CHECK (LENGTH(reserve_sig)=64)
+ ,purse_pub BYTEA NOT NULL CHECK (LENGTH(purse_pub)=32)
,purse_sig BYTEA NOT NULL CHECK (LENGTH(purse_sig)=64)
,merge_timestamp INT8 NOT NULL
,purse_expiration INT8 NOT NULL