Subversion Repositories VORC

## Table: staff_template
#
# +------------+------------------------------------+------+-----+---------+----------------+
# | Field      | Type                               | Null | Key | Default | Extra          |
# +------------+------------------------------------+------+-----+---------+----------------+
# | id         | int(11)                            | NO   | PRI | NULL    | auto_increment |
# | type       | varchar(45)                        | NO   | PRI | NULL    |                |
# | department | varchar(5)                         | NO   |     | NULL    |                |
# | role       | varchar(64)                        | NO   |     | NULL    |                |
# | assignment | enum('open','selected','reserved') | NO   |     | NULL    |                |
# +------------+------------------------------------+------+-----+---------+----------------+

CREATE TABLE `staff_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assignment` enum('open','selected','reserved') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`,`type`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci