summaryrefslogtreecommitdiff
path: root/app_game_log.sql
diff options
context:
space:
mode:
Diffstat (limited to 'app_game_log.sql')
-rw-r--r--app_game_log.sql36
1 files changed, 36 insertions, 0 deletions
diff --git a/app_game_log.sql b/app_game_log.sql
new file mode 100644
index 0000000..35a33a3
--- /dev/null
+++ b/app_game_log.sql
@@ -0,0 +1,36 @@
+INSERT INTO game_log (
+ game_id,
+ plr_X_name,
+ plr_X_color_int,
+ plr_O_name,
+ plr_O_color_int,
+ start_time,
+ start_board,
+ vic_chk,
+ victor_name,
+ victor_color_int,
+ three_in_a_row,
+ draw_accept,
+ resign,
+ end_board,
+ turns,
+ end_time
+)
+VALUES (
+ :game_id,
+ :plr_X_name,
+ :plr_X_color_int,
+ :plr_O_name,
+ :plr_O_color_int,
+ :start_time,
+ :start_board,
+ :vic_chk,
+ :victor_name,
+ :victor_color_int,
+ :three_in_a_row,
+ :draw_accept,
+ :resign,
+ :end_board,
+ :turns,
+ :end_time
+) \ No newline at end of file