tAdd comments about database model - hadarawgs - Hadara adaptation for boardgamearena.com
 (HTM) git clone git://git.z3bra.org/hadarawgs.git
 (DIR) Log
 (DIR) Files
 (DIR) Refs
 (DIR) LICENSE
       ---
 (DIR) commit 2f3e4f104493b3098264029129e6914c4e292f2d
 (DIR) parent d3d3a7725fe32bd40c60f7a95301ebaa70ed59fb
 (HTM) Author: Willy Goiffon <dev@z3bra.org>
       Date:   Fri,  6 Mar 2020 10:56:21 +0100
       
       Add comments about database model
       
       Diffstat:
         M dbmodel.sql                         |      17 +++++++++++------
       
       1 file changed, 11 insertions(+), 6 deletions(-)
       ---
 (DIR) diff --git a/dbmodel.sql b/dbmodel.sql
       t@@ -20,11 +20,16 @@ CREATE TABLE IF NOT EXISTS `playerboard` (
                PRIMARY KEY (`id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
        
       +-- Used for epoch and setup cards
       +--         type: "setup", "income", "military", …
       +--         type_arg: epoch number or initiative value
       +--         card_location: "deck", "hand", "deck_<resource>", "discard_<resource>"
       +--         card_location_arg: used internally by "Deck"
        CREATE TABLE IF NOT EXISTS `card` (
       -  `card_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
       -  `card_type` varchar(32) NOT NULL,
       -  `card_type_arg` int(10) NOT NULL,
       -  `card_location` varchar(32) NOT NULL,
       -  `card_location_arg` int(10) NOT NULL,
       -  PRIMARY KEY (`card_id`)
       +        `card_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
       +        `card_type` varchar(32) NOT NULL,
       +        `card_type_arg` int(10) NOT NULL,
       +        `card_location` varchar(32) NOT NULL,
       +        `card_location_arg` int(10) NOT NULL,
       +        PRIMARY KEY (`card_id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;