diff options
author | Christian Grothoff <grothoff@gnunet.org> | 2024-03-08 11:12:50 +0100 |
---|---|---|
committer | Christian Grothoff <grothoff@gnunet.org> | 2024-03-08 11:12:50 +0100 |
commit | a50e69908e7205021167415fac42162be96f98d0 (patch) | |
tree | 3de2eb42d6c5243e860dc02fe8846fadb3d1dd5a /src/exchangedb/drop.sql | |
parent | fb02619f98eca93de71aaee9c7c8d83ac77025bc (diff) | |
download | exchange-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.sql | 10 |
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; |