add tournment points visualization added

[brisk.git] / sql / sql.d / 080-games-tourn-pts.sql

diff --git a/sql/sql.d/080-games-tourn-pts.sql b/sql/sql.d/080-games-tourn-pts.sql
new file mode 100644 (file)
index 0000000..0efa468
--- /dev/null
+++ b/sql/sql.d/080-games-tourn-pts.sql
@@ -0,0 +1,4 @@
+-- add tourn_pts to bin5_games table
+ALTER TABLE #PFX#bin5_games DROP COLUMN tourn_pts;
+ALTER TABLE #PFX#bin5_games ADD COLUMN tourn_pts integer DEFAULT -1;  -- points at the beginning of the hand
+