X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=sql%2Fsql.d%2F050-bin5.sql;h=2f58a728f913f47812d8e3a244a79237e0414685;hp=938d5d3e71a6945ec27944d00828a437845c01c3;hb=484a365c1e66ba4b878117275423a1594c209960;hpb=31bfc5e122ec3db5c70e2587a23fabd0dae5ee33

diff --git a/sql/sql.d/050-bin5.sql b/sql/sql.d/050-bin5.sql
index 938d5d3..2f58a72 100644
--- 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,