Database: g1 +------------------+ | Tables | +------------------+ | election | | election0voting | | entity | | event | | judgment | | judgment0history | | judgment0judge | | mail | | motion | | motion0history | | motion0voting | | name | | officer | | player | | proposal | | proposal0history | | proposal0voting | | rule | | rule0history | | score | +------------------+ 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 | tinytext | | | | | 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: 0 +--------+----------+------+-----+---------+-------+---------------------------------+ | 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 | tinytext | | | | | select,insert,update,references | | date | datetime | YES | | | | select,insert,update,references | +--------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: entity Rows: 14 +----------+----------------+------+-----+---------+-------+---------------------------------+ | 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 | char(1) | | | a | | select,insert,update,references | | vitality | char(1) | | | l | | select,insert,update,references | | score | int(11) | | | 0 | | select,insert,update,references | +----------+----------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: event Rows: 746 +-------+----------+------+-----+---------+----------------+---------------------------------+ | 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 | | type | char(1) | YES | | | | select,insert,update,references | +-------+----------+------+-----+---------+----------------+---------------------------------+ Database: g1 Table: judgment Rows: 27 +------------+------------------------------------------------------+------+-----+---------+-------+---------------------------------+ | 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 | | vitality | char(1) | | | l | | 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 | +------------+------------------------------------------------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: judgment0history Rows: 134 +----------+------------+------+-----+---------+-------+---------------------------------+ | 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: 39 +----------+---------------+------+-----+---------+-------+---------------------------------+ | 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: 15 +---------+----------+------+-----+---------+-------+---------------------------------+ | 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: 10 +----------+------------+------+-----+---------+-------+---------------------------------+ | 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 | | vitality | char(1) | YES | | l | | select,insert,update,references | | activity | char(1) | YES | | a | | 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 | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: motion0history Rows: 33 +----------+------------+------+-----+---------+-------+---------------------------------+ | 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: 0 +----------+-----------------------+------+-----+---------+-------+---------------------------------+ | 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: 14 +-------+----------+------+-----+---------+-------+---------------------------------+ | 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: officer Rows: 1 +--------+----------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +--------+----------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | | 0 | | select,insert,update,references | | office | tinytext | | | | | select,insert,update,references | | start | datetime | YES | | | | select,insert,update,references | | end | datetime | YES | | | | select,insert,update,references | +--------+----------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: player Rows: 12 +----------+---------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------+---------+------+-----+---------+-------+---------------------------------+ | id | int(11) | | | 0 | | select,insert,update,references | | activity | char(1) | | | a | | select,insert,update,references | +----------+---------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: proposal Rows: 98 +----------+------------+------+-----+---------+-------+---------------------------------+ | 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 | | vitality | char(1) | | | l | | select,insert,update,references | | activity | char(1) | | | a | | 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 | +----------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: proposal0history Rows: 302 +----------+------------+------+-----+---------+-------+---------------------------------+ | 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: 1114 +----------+-----------------------+------+-----+---------+-------+---------------------------------+ | 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: 134 +------------+------------+------+-----+---------+-------+---------------------------------+ | 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 | | vitality | char(1) | | | l | | select,insert,update,references | | categories | tinytext | YES | | | | select,insert,update,references | | title | tinytext | YES | | | | select,insert,update,references | | text | text | YES | | | | select,insert,update,references | +------------+------------+------+-----+---------+-------+---------------------------------+ Database: g1 Table: rule0history Rows: 140 +----------+------------+------+-----+---------+-------+---------------------------------+ | 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 | +-------+----------+------+-----+---------+-------+---------------------------------+