Subversion Repositories VORC

## Table: department
#
# +-------------+---------------------+------+-----+---------+-------+
# | Field       | Type                | Null | Key | Default | Extra |
# +-------------+---------------------+------+-----+---------+-------+
# | TLA         | char(5)             | NO   | PRI | NULL    |       |
# | name        | varchar(45)         | NO   |     | NULL    |       |
# | autoapprove | tinyint(3) unsigned | NO   |     | NULL    |       |
# | description | varchar(512)        | YES  |     | NULL    |       |
# | link        | varchar(45)         | YES  |     | NULL    |       |
# +-------------+---------------------+------+-----+---------+-------+

CREATE TABLE `department` (
  `TLA` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `autoapprove` tinyint(3) unsigned NOT NULL,
  `description` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`TLA`),
  UNIQUE KEY `TLA_UNIQUE` (`TLA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci