diff options
Diffstat (limited to 'src/backenddb/drop.sql')
| -rw-r--r-- | src/backenddb/drop.sql | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/src/backenddb/drop.sql b/src/backenddb/drop.sql index fbfd9e6a..9005b6ed 100644 --- a/src/backenddb/drop.sql +++ b/src/backenddb/drop.sql @@ -17,17 +17,15 @@ -- Everything in one big transaction BEGIN; --- This script DROPs all of the tables we create, including the --- versioning schema! --- --- Unlike the other SQL files, it SHOULD be updated to reflect the --- latest requirements for dropping tables. +-- This script DROPs all of the tables we create. --- Unregister patch (0003.sql) -SELECT _v.unregister_patch('merchant-0004'); -SELECT _v.unregister_patch('merchant-0003'); -SELECT _v.unregister_patch('merchant-0002'); -SELECT _v.unregister_patch('merchant-0001'); +WITH xpatches AS ( + SELECT patch_name + FROM _v.patches + WHERE starts_with(patch_name,'merchant-') +) + SELECT _v.unregister_patch(xpatches.patch_name) + FROM xpatches; DROP SCHEMA merchant CASCADE; |