Subversion Repositories VORC

## Table: assignment
#
# +---------------+------------------+------+-----+---------+----------------+
# | Field         | Type             | Null | Key | Default | Extra          |
# +---------------+------------------+------+-----+---------+----------------+
# | Aid           | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
# | Gid           | int(11) unsigned | NO   | MUL | NULL    |                |
# | role          | char(8)          | NO   |     | NULL    |                |
# | RCid          | int(11) unsigned | NO   |     | NULL    |                |
# | wb_ticket_act | varchar(12)      | YES  | UNI | NULL    |                |
# +---------------+------------------+------+-----+---------+----------------+

CREATE TABLE `assignment` (
  `Aid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Gid` int(11) unsigned NOT NULL,
  `role` char(8) COLLATE utf8mb4_unicode_ci NOT NULL,
  `RCid` int(11) unsigned NOT NULL,
  `wb_ticket_act` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`Aid`),
  UNIQUE KEY `Aid_UNIQUE` (`Aid`),
  UNIQUE KEY `idx_assignment_Gid_role` (`Gid`,`role`),
  UNIQUE KEY `idx_assignment_Gid_RCid` (`Gid`,`RCid`,`role`),
  UNIQUE KEY `wb_ticket_act_UNIQUE` (`wb_ticket_act`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci