Subversion Repositories VORC

## Table: lead_shift
#
# +-------------+------------------+------+-----+---------+----------------+
# | Field       | Type             | Null | Key | Default | Extra          |
# +-------------+------------------+------+-----+---------+----------------+
# | id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
# | date        | date             | YES  | MUL | NULL    |                |
# | track       | varchar(45)      | YES  |     | NULL    |                |
# | start_time  | time             | YES  |     | NULL    |                |
# | end_time    | time             | YES  |     | NULL    |                |
# | assignee_id | varchar(45)      | YES  |     | NULL    |                |
# +-------------+------------------+------+-----+---------+----------------+

CREATE TABLE `lead_shift` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `track` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `assignee_id` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `shift` (`date`,`track`,`start_time`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci