more robust sql scripts adding IF EXISTS to DROP TABLE statementes

[brisk.git] / sql / sql.d / 070-add-mailmgmt.sql

diff --git a/sql/sql.d/070-add-mailmgmt.sql b/sql/sql.d/070-add-mailmgmt.sql
index cef0248..bfd0a24 100644 (file)
--- a/sql/sql.d/070-add-mailmgmt.sql
+++ b/sql/sql.d/070-add-mailmgmt.sql
@@ -1,7 +1,7 @@
 --
 --  Table to manage mails sent to users
 --
-DROP TABLE #PFX#mails;
+DROP TABLE IF EXISTS #PFX#mails;
 CREATE TABLE #PFX#mails (
        code       SERIAL PRIMARY KEY,
        ucode      integer REFERENCES #PFX#users (code) ON DELETE cascade ON UPDATE cascade,