Subversion Repositories VORC

## Table: game
#
# +--------------+--------------+------+-----+---------+----------------+
# | Field        | Type         | Null | Key | Default | Extra          |
# +--------------+--------------+------+-----+---------+----------------+
# | id           | int(11)      | NO   | PRI | NULL    | auto_increment |
# | title        | varchar(128) | YES  |     | NULL    |                |
# | team1        | varchar(64)  | NO   |     | NULL    |                |
# | team2        | varchar(64)  | NO   |     | NULL    |                |
# | date         | date         | NO   | MUL | NULL    |                |
# | time         | time         | NO   |     | NULL    |                |
# | end_time     | time         | NO   |     | NULL    |                |
# | track        | varchar(45)  | NO   |     | NULL    |                |
# | level        | varchar(45)  | NO   |     | NULL    |                |
# | restrictions | varchar(45)  | YES  |     | NULL    |                |
# | type         | varchar(45)  | NO   |     | NULL    |                |
# | notes        | mediumtext   | YES  |     | NULL    |                |
# +--------------+--------------+------+-----+---------+----------------+

CREATE TABLE `game` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `team1` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `team2` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `end_time` time NOT NULL,
  `track` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `restrictions` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` mediumtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`date`,`time`,`track`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci