X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F080-games-tourn-pts.sql;fp=sql%2Fsql.d%2F080-games-tourn-pts.sql;h=0efa468f601018d25cd687025379c10fd140d3eb;hb=db12d769481823f4c744ce0e3a50404cc6b01cd1;hp=0000000000000000000000000000000000000000;hpb=9c96c38b48ab376e202045407786dbcf553febb2;p=brisk.git

diff --git a/sql/sql.d/080-games-tourn-pts.sql b/sql/sql.d/080-games-tourn-pts.sql
new file mode 100644
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
+