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 b26a1b1..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,
@@ -17,4 +17,4 @@ ALTER TABLE #PFX#bin5_matches DROP CONSTRAINT #PFX#bin5_matches_tcode_fkey;
 ALTER TABLE #PFX#bin5_matches ADD FOREIGN KEY (tcode) REFERENCES #PFX#bin5_tournaments(code) ON UPDATE cascade ON DELETE cascade;
 
 ALTER TABLE #PFX#bin5_games DROP COLUMN act;
-ALTER TABLE #PFX#bin5_games ADD COLUMN act    integer;  -- end reason of the game
+ALTER TABLE #PFX#bin5_games ADD COLUMN act integer DEFAULT -1;  -- end reason of the game