Subversion Repositories VORC

## Table: shift
#
# +-------------+------------------+------+-----+---------+----------------+
# | Field       | Type             | Null | Key | Default | Extra          |
# +-------------+------------------+------+-----+---------+----------------+
# | id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
# | dept        | varchar(45)      | YES  |     | NULL    |                |
# | role        | varchar(45)      | YES  |     | NULL    |                |
# | type        | varchar(45)      | YES  |     | NULL    |                |
# | date        | date             | YES  |     | NULL    |                |
# | location    | varchar(45)      | YES  |     | NULL    |                |
# | start_time  | time             | YES  |     | NULL    |                |
# | end_time    | time             | YES  |     | NULL    |                |
# | mod_time    | decimal(4,2)     | YES  |     | NULL    |                |
# | doubletime  | tinyint(1)       | NO   |     | 0       |                |
# | note        | mediumtext       | YES  |     | NULL    |                |
# | assignee_id | varchar(45)      | YES  |     | NULL    |                |
# +-------------+------------------+------+-----+---------+----------------+

CREATE TABLE `shift` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dept` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `location` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `mod_time` decimal(4,2) DEFAULT NULL,
  `doubletime` tinyint(1) NOT NULL DEFAULT '0',
  `note` mediumtext COLLATE utf8mb4_unicode_ci,
  `assignee_id` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci