diff options
author | Christian Grothoff <christian@grothoff.org> | 2020-02-04 00:21:34 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2020-02-04 00:21:34 +0100 |
commit | 0bff58489f64ceec7c02fa72c270186b315ffc8a (patch) | |
tree | 978a902f3ccf89ad9a339d9df5bc51b43965ceaf | |
parent | 93f169dcffad89aab134b9cfe541ec795c4f0fe7 (diff) | |
download | merchant-0bff58489f64ceec7c02fa72c270186b315ffc8a.tar.gz merchant-0bff58489f64ceec7c02fa72c270186b315ffc8a.tar.bz2 merchant-0bff58489f64ceec7c02fa72c270186b315ffc8a.zip |
fix drop script
-rw-r--r-- | src/backenddb/drop0000.sql | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/src/backenddb/drop0000.sql b/src/backenddb/drop0000.sql index 3d11bf75..4a1b3ecc 100644 --- a/src/backenddb/drop0000.sql +++ b/src/backenddb/drop0000.sql @@ -1,3 +1,30 @@ +-- +-- This file is part of TALER +-- Copyright (C) 2014--2020 Taler Systems SA +-- +-- TALER is free software; you can redistribute it and/or modify it under the +-- terms of the GNU General Public License as published by the Free Software +-- Foundation; either version 3, or (at your option) any later version. +-- +-- TALER is distributed in the hope that it will be useful, but WITHOUT ANY +-- WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR +-- A PARTICULAR PURPOSE. See the GNU General Public License for more details. +-- +-- You should have received a copy of the GNU General Public License along with +-- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> +-- + +-- 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. + +-- Drops for 0001.sql + DROP TABLE IF EXISTS merchant_transfers CASCADE; DROP TABLE IF EXISTS merchant_deposits CASCADE; DROP TABLE IF EXISTS merchant_transactions CASCADE; @@ -11,3 +38,9 @@ DROP TABLE IF EXISTS merchant_tip_reserve_credits CASCADE; DROP TABLE IF EXISTS merchant_tip_reserves CASCADE; DROP TABLE IF EXISTS merchant_orders CASCADE; DROP TABLE IF EXISTS merchant_session_info CASCADE; + +-- Drop versioning (0000.sql) +DROP SCHEMA IF EXISTS _v CASCADE; + +-- And we're out of here... +COMMIT; |