summaryrefslogtreecommitdiff
path: root/src/exchangedb/drop.sql
diff options
context:
space:
mode:
authorChristian Grothoff <grothoff@gnunet.org>2024-03-08 11:12:50 +0100
committerChristian Grothoff <grothoff@gnunet.org>2024-03-08 11:12:50 +0100
commita50e69908e7205021167415fac42162be96f98d0 (patch)
tree3de2eb42d6c5243e860dc02fe8846fadb3d1dd5a /src/exchangedb/drop.sql
parentfb02619f98eca93de71aaee9c7c8d83ac77025bc (diff)
downloadexchange-a50e69908e7205021167415fac42162be96f98d0.tar.gz
exchange-a50e69908e7205021167415fac42162be96f98d0.tar.bz2
exchange-a50e69908e7205021167415fac42162be96f98d0.zip
add taler-exchange-dbinit -a option
Diffstat (limited to 'src/exchangedb/drop.sql')
-rw-r--r--src/exchangedb/drop.sql10
1 files changed, 9 insertions, 1 deletions
diff --git a/src/exchangedb/drop.sql b/src/exchangedb/drop.sql
index ff383d743..fa7609bfd 100644
--- a/src/exchangedb/drop.sql
+++ b/src/exchangedb/drop.sql
@@ -17,10 +17,18 @@
-- Everything in one big transaction
BEGIN;
-
+-- TODO: consider use exchange-* in the future!
SELECT _v.unregister_patch('exchange-0001');
SELECT _v.unregister_patch('exchange-0002');
+WITH xpatches AS (
+ SELECT patch_name
+ FROM _v.patches
+ WHERE patch_name='auditor-triggers-0001' -- TODO: use auditor-triggers-* in the future!
+)
+ SELECT _v.unregister_patch(xpatches.patch_name)
+ FROM xpatches;
+
DROP SCHEMA exchange CASCADE;
COMMIT;