Database: g1 +------------------+ | Tables | +------------------+ | category | | election | | election0voting | | entity | | event | | judgment | | judgment0history | | judgment0judge | | mail | | motion | | motion0history | | motion0voting | | name | | office | | officer | | player | | proposal | | proposal0history | | proposal0voting | | rule | | rule0category | | rule0history | | score | +------------------+ Database: g1 Table: category Rows: 20 +----------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | PRI | 0 | | select,insert,update,references | | category | tinytext | | | | | select,insert,update,references | +----------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: election Rows: 8 +-----------+---------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-----------+---------+------+-----+---------+-------+---------------------------------+ | nweek | int(11) | | | 0 | | select,insert,update,references | | id | int(11) | | | 0 | | select,insert,update,references | | nominator | int(11) | | | 0 | | select,insert,update,references | | office | int(11) | | | 0 | | select,insert,update,references | | vitality | char(1) | | | l | | select,insert,update,references | | decline | char(1) | | | n | | select,insert,update,references | +-----------+---------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: election0voting Rows: 48 +--------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +--------+----------+------+-----+---------+-------+---------------------------------+ | nweek | int(11) | | | 0 | | select,insert,update,references | | id | int(11) | | | 0 | | select,insert,update,references | | vote | tinytext | | | | | select,insert,update,references | | office | int(11) | | | 0 | | select,insert,update,references | | date | datetime | YES | | | | select,insert,update,references | +--------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: entity Rows: 22 +----------+----------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+----------------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | PRI | 0 | | select,insert,update,references | | type | enum('player') | YES | | | | select,insert,update,references | | activity | int(11) | | | 0 | | select,insert,update,references | | vitality | int(11) | | | 0 | | select,insert,update,references | | score | int(11) | | | 0 | | select,insert,update,references | +----------+----------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: event Rows: 1156 +-------+----------+------+-----+---------+----------------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-------+----------+------+-----+---------+----------------+---------------------------------+ | id | int(11) | | PRI | | auto_increment | select,insert,update,references | | date | datetime | YES | | | | select,insert,update,references | | event | tinytext | YES | | | | select,insert,update,references | +-------+----------+------+-----+---------+----------------+---------------------------------+ Database: g1 Table: judgment Rows: 30 +------------+------------------------------------------------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +------------+------------------------------------------------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | PRI | 0 | | select,insert,update,references | | revision | tinyint(4) | | PRI | 0 | | select,insert,update,references | | plaintiff | tinyint(4) | | | 0 | | select,insert,update,references | | statement | text | | | | | select,insert,update,references | | p_analysis | text | YES | | | | select,insert,update,references | | ruling | enum('true','false','undecided','refused','pending') | YES | | pending | | select,insert,update,references | | j_analysis | text | YES | | | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +------------+------------------------------------------------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: judgment0history Rows: 149 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | | 0 | | select,insert,update,references | | revision | tinyint(4) | | | 0 | | select,insert,update,references | | id | int(11) | | | 0 | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: judgment0judge Rows: 44 +----------+---------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+---------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | | 0 | | select,insert,update,references | | revision | tinyint(4) | | | 0 | | select,insert,update,references | | id | int(11) | | | 0 | | select,insert,update,references | | recused | enum('y','n') | YES | | n | | select,insert,update,references | +----------+---------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: mail Rows: 24 +---------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +---------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | | 0 | | select,insert,update,references | | address | tinytext | | | | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +---------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: motion Rows: 23 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | PRI | 0 | | select,insert,update,references | | revision | tinyint(4) | | PRI | 0 | | select,insert,update,references | | activity | int(11) | | | 0 | | select,insert,update,references | | owner | int(11) | | | 0 | | select,insert,update,references | | title | tinytext | YES | | | | select,insert,update,references | | text | text | YES | | | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: motion0history Rows: 77 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | YES | | | | select,insert,update,references | | revision | tinyint(4) | YES | | | | select,insert,update,references | | id | int(11) | YES | | | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: motion0voting Rows: 18 +----------+-----------------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+-----------------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | PRI | 0 | | select,insert,update,references | | revision | tinyint(4) | | PRI | 0 | | select,insert,update,references | | id | int(11) | | PRI | 0 | | select,insert,update,references | | vote | enum('y','n','a','-') | YES | | | | select,insert,update,references | | date | datetime | YES | | | | select,insert,update,references | +----------+-----------------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: name Rows: 24 +-------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | | 0 | | select,insert,update,references | | name | tinytext | | | | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +-------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: office Rows: 5 +---------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +---------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | PRI | 0 | | select,insert,update,references | | office | tinytext | | PRI | | | select,insert,update,references | | elected | int(1) | | PRI | 0 | | select,insert,update,references | +---------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: officer Rows: 9 +--------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +--------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | | 0 | | select,insert,update,references | | office | int(11) | | | 0 | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | | vacant | int(1) | YES | | | | select,insert,update,references | +--------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: player Rows: 21 +-------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | | 0 | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +-------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: proposal Rows: 157 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | PRI | 0 | | select,insert,update,references | | revision | tinyint(4) | | PRI | 0 | | select,insert,update,references | | activity | int(11) | | | 0 | | select,insert,update,references | | owner | int(11) | | | 0 | | select,insert,update,references | | title | tinytext | YES | | | | select,insert,update,references | | text | text | YES | | | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: proposal0history Rows: 509 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | | 0 | | select,insert,update,references | | revision | tinyint(4) | | | 0 | | select,insert,update,references | | id | int(11) | | | 0 | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: proposal0voting Rows: 2003 +----------+-----------------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+-----------------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | MUL | 0 | | select,insert,update,references | | revision | tinyint(4) | | | 0 | | select,insert,update,references | | id | int(11) | | | 0 | | select,insert,update,references | | vote | enum('y','n','a','-') | YES | | | | select,insert,update,references | | date | datetime | YES | | | | select,insert,update,references | +----------+-----------------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: rule Rows: 176 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | PRI | 0 | | select,insert,update,references | | revision | tinyint(4) | | PRI | 0 | | select,insert,update,references | | title | tinytext | YES | | | | select,insert,update,references | | text | text | YES | | | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: rule0category Rows: 142 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | | 0 | | select,insert,update,references | | revision | tinyint(4) | | | 0 | | select,insert,update,references | | category | tinyint(4) | | | 0 | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: rule0history Rows: 184 +----------+------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+------------+------+-----+---------+-------+---------------------------------+ | number | int(11) | | | 0 | | select,insert,update,references | | revision | tinyint(4) | | | 0 | | select,insert,update,references | | id | int(11) | | | 0 | | select,insert,update,references | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: score Rows: 0 +-------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +-------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | | 0 | | select,insert,update,references | | date | datetime | YES | | | | select,insert,update,references | | score | int(11) | | | 0 | | select,insert,update,references | +-------+----------+------+-----+---------+-------+---------------------------------+