| 208 |
- |
1 |
## Table: RCid_ticket_link
|
|
|
2 |
#
|
|
|
3 |
# +-------+------------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +-------+------------------+------+-----+---------+-------+
|
|
|
6 |
# | RCid | int(11) unsigned | NO | PRI | NULL | |
|
|
|
7 |
# | MVPid | varchar(24) | NO | UNI | NULL | |
|
|
|
8 |
# | year | int(4) unsigned | NO | PRI | NULL | |
|
|
|
9 |
# +-------+------------------+------+-----+---------+-------+
|
|
|
10 |
|
|
|
11 |
CREATE TABLE `RCid_ticket_link` (
|
|
|
12 |
`RCid` int(11) unsigned NOT NULL,
|
|
|
13 |
`MVPid` varchar(24) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
14 |
`year` int(4) unsigned NOT NULL,
|
|
|
15 |
PRIMARY KEY (`RCid`,`year`),
|
|
|
16 |
UNIQUE KEY `MVPid_UNIQUE` (`MVPid`),
|
|
|
17 |
UNIQUE KEY `RCid_UNIQUE` (`RCid`,`year`)
|
|
|
18 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|