more robust sql scripts adding IF EXISTS to DROP TABLE statementes

[brisk.git] / sql / sql.d / 071-apprentice.sql

diff --git a/sql/sql.d/071-apprentice.sql b/sql/sql.d/071-apprentice.sql
index c3a0193..376427b 100644 (file)
--- a/sql/sql.d/071-apprentice.sql
+++ b/sql/sql.d/071-apprentice.sql
@@ -1,7 +1,7 @@
 --
 --  Table to manage mails sent to users
 --
-DROP TABLE #PFX#selfreg_chk;
+DROP TABLE IF EXISTS #PFX#selfreg_chk;
 CREATE TABLE #PFX#selfreg_chk (
        ip         integer,                           -- ip v4 address
        atime      timestamp DEFAULT to_timestamp(0)  -- access time