summaryrefslogtreecommitdiff
path: root/src/exchangedb/0002-refresh_commitments.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-11-27 21:21:04 +0100
committerChristian Grothoff <christian@grothoff.org>2022-11-27 21:21:04 +0100
commitcf2e37cd876651e799893e8fe5babb51a9e12dd7 (patch)
tree437047cc646fb1a3a86f4226fd5460bbe2b0c530 /src/exchangedb/0002-refresh_commitments.sql
parentf2ba02aab2b9bbd976107ecc4ac7e7d657a9d73a (diff)
downloadexchange-cf2e37cd876651e799893e8fe5babb51a9e12dd7.tar.gz
exchange-cf2e37cd876651e799893e8fe5babb51a9e12dd7.tar.bz2
exchange-cf2e37cd876651e799893e8fe5babb51a9e12dd7.zip
more work on SQL refactoring
Diffstat (limited to 'src/exchangedb/0002-refresh_commitments.sql')
-rw-r--r--src/exchangedb/0002-refresh_commitments.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/exchangedb/0002-refresh_commitments.sql b/src/exchangedb/0002-refresh_commitments.sql
index c3d5cfdef..c63995c74 100644
--- a/src/exchangedb/0002-refresh_commitments.sql
+++ b/src/exchangedb/0002-refresh_commitments.sql
@@ -100,6 +100,7 @@ BEGIN
EXECUTE FORMAT (
'ALTER TABLE ' || table_name ||
' ADD CONSTRAINT ' || table_name || '_foreign_coin_pub'
+ ' FOREIGN KEY (old_coin_pub) '
' REFERENCES known_coins (coin_pub) ON DELETE CASCADE'
);
END