X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F060-tournament.sql;h=7f9e34043ea56541a42fe56994f778d22d7337e3;hb=75e9d0fde7b60527ec0ac44563cc7917ffc36126;hp=b26a1b132f0c1a92818049ae328a687d88718420;hpb=57022841a24fb476ae5410cae9742a30cbe44222;p=brisk.git diff --git a/sql/sql.d/060-tournament.sql b/sql/sql.d/060-tournament.sql index b26a1b1..7f9e340 100644 --- a/sql/sql.d/060-tournament.sql +++ b/sql/sql.d/060-tournament.sql @@ -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