From: Don Armstrong <don@donarmstrong.com>
Date: Wed, 1 Jul 2020 20:06:26 +0000 (-0700)
Subject: only drop tables, views, and types if they exist
X-Git-Url: https://git.donarmstrong.com/?p=debbugs.git;a=commitdiff_plain;h=87fbca05798a10efa96f6ea0f2297b8c7531174e

only drop tables, views, and types if they exist
---

diff --git a/sql/debbugs_schema.sql b/sql/debbugs_schema.sql
index 3a75bac..0e6f4e5 100644
--- a/sql/debbugs_schema.sql
+++ b/sql/debbugs_schema.sql
@@ -1,40 +1,40 @@
 -- -*- mode: sql; sql-product: postgres; -*-
-DROP TABLE bug_status_cache CASCADE;
-DROP VIEW bug_package CASCADE;
-DROP VIEW binary_versions CASCADE;
-DROP VIEW bug_status CASCADE;
-DROP TABLE bug_tag CASCADE;
-DROP TABLE tag CASCADE;
-DROP TABLE bug_user_tag CASCADE;
-DROP TABLE user_tag CASCADE;
-DROP TABLE severity CASCADE;
-DROP TABLE bug CASCADE;
-DROP TABLE src_pkg CASCADE;
-DROP TABLE bug_ver CASCADE;
-DROP TABLE src_ver CASCADE;
-DROP TABLE arch CASCADE;
-DROP TABLE bin_ver CASCADE;
-DROP TABLE bin_pkg CASCADE;
-DROP TABLE bug_blocks CASCADE;
-DROP TABLE bug_merged CASCADE;
-DROP TABLE bug_srcpackage CASCADE;
-DROP TABLE bug_binpackage CASCADE;
-DROP TABLE bug_affects_binpackage CASCADE;
-DROP TABLE bug_affects_srcpackage CASCADE;
-DROP TABLE suite CASCADE;
-DROP TABLE bin_associations CASCADE;
-DROP TABLE src_associations CASCADE;
-DROP TABLE maintainer CASCADE;
-DROP TABLE bug_message CASCADE;
-DROP TABLE message_correspondent CASCADE;
-DROP TABLE correspondent_full_name CASCADE;
-DROP TABLE correspondent CASCADE;
-DROP TABLE message_refs CASCADE;
-DROP TABLE message CASCADE;
-DROP TYPE message_correspondent_type CASCADE;
-DROP TABLE table_comments CASCADE;
-DROP TABLE column_comments CASCADE;
-DROP TYPE bug_status_type CASCADE;
+DROP TABLE IF EXISTS bug_status_cache CASCADE;
+DROP VIEW IF EXISTS bug_package CASCADE;
+DROP VIEW IF EXISTS binary_versions CASCADE;
+DROP VIEW IF EXISTS bug_status CASCADE;
+DROP TABLE IF EXISTS bug_tag CASCADE;
+DROP TABLE IF EXISTS tag CASCADE;
+DROP TABLE IF EXISTS bug_user_tag CASCADE;
+DROP TABLE IF EXISTS user_tag CASCADE;
+DROP TABLE IF EXISTS severity CASCADE;
+DROP TABLE IF EXISTS bug CASCADE;
+DROP TABLE IF EXISTS src_pkg CASCADE;
+DROP TABLE IF EXISTS bug_ver CASCADE;
+DROP TABLE IF EXISTS src_ver CASCADE;
+DROP TABLE IF EXISTS arch CASCADE;
+DROP TABLE IF EXISTS bin_ver CASCADE;
+DROP TABLE IF EXISTS bin_pkg CASCADE;
+DROP TABLE IF EXISTS bug_blocks CASCADE;
+DROP TABLE IF EXISTS bug_merged CASCADE;
+DROP TABLE IF EXISTS bug_srcpackage CASCADE;
+DROP TABLE IF EXISTS bug_binpackage CASCADE;
+DROP TABLE IF EXISTS bug_affects_binpackage CASCADE;
+DROP TABLE IF EXISTS bug_affects_srcpackage CASCADE;
+DROP TABLE IF EXISTS suite CASCADE;
+DROP TABLE IF EXISTS bin_associations CASCADE;
+DROP TABLE IF EXISTS src_associations CASCADE;
+DROP TABLE IF EXISTS maintainer CASCADE;
+DROP TABLE IF EXISTS bug_message CASCADE;
+DROP TABLE IF EXISTS message_correspondent CASCADE;
+DROP TABLE IF EXISTS correspondent_full_name CASCADE;
+DROP TABLE IF EXISTS correspondent CASCADE;
+DROP TABLE IF EXISTS message_refs CASCADE;
+DROP TABLE IF EXISTS message CASCADE;
+DROP TYPE IF EXISTS message_correspondent_type CASCADE;
+DROP TABLE IF EXISTS table_comments CASCADE;
+DROP TABLE IF EXISTS column_comments CASCADE;
+DROP TYPE IF EXISTS bug_status_type CASCADE;
 
 -- the following two tables are used to provide documentation about
 -- the tables and columns for DBIx::Class::Schema::Loader