summaryrefslogtreecommitdiffstats
path: root/create_database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'create_database.sql')
-rw-r--r--create_database.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/create_database.sql b/create_database.sql
index d552be5..4408426 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -206,7 +206,9 @@ CREATE TABLE `Score` (
`id` int(11) NOT NULL auto_increment,
`create_date` timestamp NOT NULL default '0000-00-00 00:00:00',
`game_id` int(11) NOT NULL default '0',
- `hand_id` int(11) NOT NULL default '0',
+ `party` enum('re','contra') default NULL ,
+ `winner_id` int(11) default NULL ,
+ `looser_id` int(11) default NULL ,
`score` enum('120', 'call120','against120','90','call90','against90',
'60','call60','against60','30','call30','against30',
'0','call0','against0',