tdbmodel.sql - hadarawgs - Hadara adaptation for boardgamearena.com
 (HTM) git clone git://git.z3bra.org/hadarawgs.git
 (DIR) Log
 (DIR) Files
 (DIR) Refs
 (DIR) LICENSE
       ---
       tdbmodel.sql (1397B)
       ---
            1 -- ------
            2 -- BGA framework: © Gregory Isabelli <gisabelli@boardgamearena.com> & Emmanuel Colin <ecolin@boardgamearena.com>
            3 -- hadarawgs implementation : © Willy Goiffon <dev@z3bra.org>
            4 -- 
            5 -- This code has been produced on the BGA studio platform for use on http://boardgamearena.com.
            6 -- See http://en.boardgamearena.com/#!doc/Studio for more information.
            7 -- -----
            8 
            9 -- Note: The database schema is created from this file when the game starts. If you modify this file,
           10 --       you have to restart a game to see your changes in database.
           11 
           12 CREATE TABLE IF NOT EXISTS `playerboard` (
           13         `id` int(10) unsigned NOT NULL,
           14         `coins`    int(10) DEFAULT 0,
           15         `income`   int(10) DEFAULT 0,
           16         `military` int(10) DEFAULT 0,
           17         `culture`  int(10) DEFAULT 0,
           18         `food`     int(10) DEFAULT 0,
           19         PRIMARY KEY (`id`)
           20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
           21 
           22 -- Used for epoch and setup cards
           23 --         type: "setup", "income", "military", …
           24 --         type_arg: epoch number or initiative value
           25 --         card_location: "deck", "hand", "deck_<resource>", "discard_<resource>"
           26 --         card_location_arg: used internally by "Deck"
           27 CREATE TABLE IF NOT EXISTS `card` (
           28         `card_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
           29         `card_type` varchar(32) NOT NULL,
           30         `card_type_arg` int(10) NOT NULL,
           31         `card_location` varchar(32) NOT NULL,
           32         `card_location_arg` int(10) NOT NULL,
           33         PRIMARY KEY (`card_id`)
           34 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;