more robust sql scripts adding IF EXISTS to DROP TABLE statementes

[brisk.git] / sql / sql.d / 060-tournament.sql

diff --git a/sql/sql.d/060-tournament.sql b/sql/sql.d/060-tournament.sql
index 7f9e340..90b54a2 100644 (file)
--- a/sql/sql.d/060-tournament.sql
+++ b/sql/sql.d/060-tournament.sql
@@ -1,4 +1,4 @@
-DROP TABLE #PFX#bin5_tournaments;
+DROP TABLE IF EXISTS #PFX#bin5_tournaments;
 CREATE TABLE #PFX#bin5_tournaments (
        code   SERIAL PRIMARY KEY,
        active integer,