Subversion Repositories VORC

## Table: role
#
# +-------+-----------------------------------------+------+-----+---------+-------+
# | Field | Type                                    | Null | Key | Default | Extra |
# +-------+-----------------------------------------+------+-----+---------+-------+
# | TLA   | char(8)                                 | NO   | PRI | NULL    |       |
# | name  | varchar(45)                             | NO   |     | NULL    |       |
# | type  | enum('referee','nso','obs','announcer') | NO   |     | NULL    |       |
# +-------+-----------------------------------------+------+-----+---------+-------+

CREATE TABLE `role` (
  `TLA` char(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('referee','nso','obs','announcer') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`TLA`),
  UNIQUE KEY `TLA_UNIQUE` (`TLA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci