more robust sql scripts adding IF EXISTS to DROP TABLE statementes

[brisk.git] / sql / sql.d / 051-bin5-places.sql

diff --git a/sql/sql.d/051-bin5-places.sql b/sql/sql.d/051-bin5-places.sql
index ebf3add..6f8d7ad 100644 (file)
--- a/sql/sql.d/051-bin5-places.sql
+++ b/sql/sql.d/051-bin5-places.sql
@@ -6,14 +6,14 @@
 -- wee = 4
 --
 
-DROP   TABLE #PFX#bin5_places_mtime;
+DROP TABLE IF EXISTS #PFX#bin5_places_mtime;
 CREATE TABLE #PFX#bin5_places_mtime (
        code   int,
        mtime  timestamp
 );
 INSERT INTO #PFX#bin5_places_mtime (code, mtime) VALUES (0, now());
 
-DROP   TABLE #PFX#bin5_places;
+DROP TABLE IF EXISTS #PFX#bin5_places;
 CREATE TABLE #PFX#bin5_places (
        type   integer,
        rank   integer,