more robust sql scripts adding IF EXISTS to DROP TABLE statementes

[brisk.git] / sql / sql.d / 050-bin5.sql

diff --git a/sql/sql.d/050-bin5.sql b/sql/sql.d/050-bin5.sql
index 938d5d3..2f58a72 100644 (file)
--- a/sql/sql.d/050-bin5.sql
+++ b/sql/sql.d/050-bin5.sql
@@ -2,21 +2,21 @@
 -- briskin5 (bin5) related tables
 --
 
-DROP TABLE #PFX#bin5_matches;
+DROP TABLE IF EXISTS #PFX#bin5_matches;
 CREATE TABLE #PFX#bin5_matches (
        code   SERIAL PRIMARY KEY,
        ttok   text UNIQUE,              -- token associated to the match
        tidx   integer                   -- table index
        );
 
-DROP TABLE #PFX#bin5_games;
+DROP TABLE IF EXISTS #PFX#bin5_games;
 CREATE TABLE #PFX#bin5_games (
        code   SERIAL PRIMARY KEY,
        mcode  integer REFERENCES #PFX#bin5_matches (code) ON DELETE cascade ON UPDATE cascade,
        tstamp timestamp                 -- end game time
        );
        
-DROP TABLE #PFX#bin5_points;
+DROP TABLE IF EXISTS #PFX#bin5_points;
 CREATE TABLE #PFX#bin5_points (
        gcode  integer REFERENCES #PFX#bin5_games (code) ON DELETE cascade ON UPDATE cascade,
        ucode  integer REFERENCES #PFX#users (code) ON DELETE cascade ON UPDATE cascade,