Subversion Repositories VORC

## Table: RCid_ticket_link
#
# +-------+------------------+------+-----+---------+-------+
# | Field | Type             | Null | Key | Default | Extra |
# +-------+------------------+------+-----+---------+-------+
# | RCid  | int(11) unsigned | NO   | PRI | NULL    |       |
# | MVPid | varchar(24)      | NO   | UNI | NULL    |       |
# | year  | int(4) unsigned  | NO   | PRI | NULL    |       |
# +-------+------------------+------+-----+---------+-------+

CREATE TABLE `RCid_ticket_link` (
  `RCid` int(11) unsigned NOT NULL,
  `MVPid` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
  `year` int(4) unsigned NOT NULL,
  PRIMARY KEY (`RCid`,`year`),
  UNIQUE KEY `MVPid_UNIQUE` (`MVPid`),
  UNIQUE KEY `RCid_UNIQUE` (`RCid`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci