aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/procedures.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-11-27 22:00:24 +0100
committerChristian Grothoff <christian@grothoff.org>2022-11-27 22:00:24 +0100
commit1cdd999c960a9625e6c71e09c68f86c37f2996e5 (patch)
treef6795ff2d65739ecf35c0fc59c039715dd73896d /src/exchangedb/procedures.sql
parent68abe6d9fa82009893218f3f71c4ae675d8ea1d0 (diff)
downloadexchange-1cdd999c960a9625e6c71e09c68f86c37f2996e5.tar.xz
-fix foreign key constraint issue
Diffstat (limited to 'src/exchangedb/procedures.sql')
-rw-r--r--src/exchangedb/procedures.sql5
1 files changed, 2 insertions, 3 deletions
diff --git a/src/exchangedb/procedures.sql b/src/exchangedb/procedures.sql
index 4bd24dde1..f0df64440 100644
--- a/src/exchangedb/procedures.sql
+++ b/src/exchangedb/procedures.sql
@@ -1654,7 +1654,7 @@ BEGIN
IF in_partner_url IS NULL
THEN
- my_partner_serial_id=0;
+ my_partner_serial_id=NULL;
ELSE
SELECT
partner_serial_id
@@ -1817,7 +1817,6 @@ ELSE
END IF;
-
RETURN;
END $$;
@@ -1851,7 +1850,7 @@ INSERT INTO exchange.purse_merges
,merge_sig
,merge_timestamp)
VALUES
- (0
+ (NULL
,in_reserve_pub
,in_purse_pub
,in_merge_sig