Subversion Repositories VORC

Rev

Blame | Last modification | View Log | RSS feed

## Table: score
#
# +-------------+----------------------+------+-----+---------+-------+
# | Field       | Type                 | Null | Key | Default | Extra |
# +-------------+----------------------+------+-----+---------+-------+
# | gid         | int(11) unsigned     | NO   | PRI | NULL    |       |
# | team1_score | smallint(5) unsigned | NO   |     | NULL    |       |
# | team2_score | smallint(5) unsigned | NO   |     | NULL    |       |
# +-------------+----------------------+------+-----+---------+-------+

CREATE TABLE `score` (
  `gid` int(11) unsigned NOT NULL,
  `team1_score` smallint(5) unsigned NOT NULL,
  `team2_score` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`gid`),
  UNIQUE KEY `gid_UNIQUE` (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci