From c2d53052e846fa2f8bbedcae9eb37ed607bb13ee Mon Sep 17 00:00:00 2001 From: emkael Date: Thu, 3 Sep 2015 12:58:13 +0200 Subject: * options for collecting play and bidding data --- Aktywator/Bws.cs | 26 ++++++++++++++++++++++++++ 1 file changed, 26 insertions(+) (limited to 'Aktywator/Bws.cs') diff --git a/Aktywator/Bws.cs b/Aktywator/Bws.cs index 0be06df..20278e0 100644 --- a/Aktywator/Bws.cs +++ b/Aktywator/Bws.cs @@ -54,6 +54,8 @@ namespace Aktywator settings.Add(new Setting("BM2AutoBoardNumber", main.xAutoBoardNumber, this)); settings.Add(new Setting("BM2ResetFunctionKey", main.xResetFunctionKey, this)); settings.Add(new Setting("BM2ViewHandrecord", main.xViewHandrecord, this)); + settings.Add(new Setting("BM2RecordBidding", main.xCollectBidding, this)); + settings.Add(new Setting("BM2RecordPlay", main.xCollectPlay, this)); } public string sectionsForHandRecords() @@ -131,6 +133,8 @@ namespace Aktywator settings.Add(new Setting("BM2NameSource", "integer", "2")); settings.Add(new Setting("BM2ViewHandrecord", "bit", "false")); settings.Add(new Setting("BM2EnterHandrecord", "bit", "false")); + settings.Add(new Setting("BM2RecordBidding", "bit", "false")); + settings.Add(new Setting("BM2RecordPlay", "bit", "false")); settings.Add(new Setting("Name", "text(18)", "''", "PlayerNumbers")); settings.Add(new Setting("Updated", "bit", "false", "PlayerNumbers")); @@ -167,6 +171,28 @@ namespace Aktywator catch (OleDbException) { } + try + { + sql.query("CREATE TABLE PlayData (" + + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`Counter` integer, `Direction` text(2), `Card` text(10), `DateLog` datetime," + + "`TimeLog` datetime, `Erased` bit" + + ");"); + } + catch (OleDbException) + { + } + try + { + sql.query("CREATE TABLE BiddingData (" + + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`Counter` integer, `Direction` text(2), `Bid` text(10), `DateLog` datetime," + + "`TimeLog` datetime, `Erased` bit" + + ");"); + } + catch (OleDbException) + { + } } public void updateSettings() -- cgit v1.2.3 From 6f5d3a1d030fe7d66d56c71bdacb2534a9c98561 Mon Sep 17 00:00:00 2001 From: emkael Date: Sat, 14 Nov 2015 10:55:05 +0100 Subject: * autonumber IDs in bidding/play tables --- Aktywator/Bws.cs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'Aktywator/Bws.cs') diff --git a/Aktywator/Bws.cs b/Aktywator/Bws.cs index 20278e0..8884868 100644 --- a/Aktywator/Bws.cs +++ b/Aktywator/Bws.cs @@ -174,7 +174,7 @@ namespace Aktywator try { sql.query("CREATE TABLE PlayData (" - + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`ID` autoincrement, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + "`Counter` integer, `Direction` text(2), `Card` text(10), `DateLog` datetime," + "`TimeLog` datetime, `Erased` bit" + ");"); @@ -185,7 +185,7 @@ namespace Aktywator try { sql.query("CREATE TABLE BiddingData (" - + "`ID` integer, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + + "`ID` autoincrement, `Section` integer, `Table` integer, `Round` integer, `Board` integer," + "`Counter` integer, `Direction` text(2), `Bid` text(10), `DateLog` datetime," + "`TimeLog` datetime, `Erased` bit" + ");"); -- cgit v1.2.3