X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F060-tournament.sql;h=7f9e34043ea56541a42fe56994f778d22d7337e3;hb=14cd1fc05b5d9148de3c427e43bf60cfdf098e9d;hp=b26a1b132f0c1a92818049ae328a687d88718420;hpb=8e4b8df113c19f41ddab9e31f9fd4fc24db2d91f;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