Subversion Repositories VORC

## Table: setting
#
# +-------+--------------+------+-----+---------+-------+
# | Field | Type         | Null | Key | Default | Extra |
# +-------+--------------+------+-----+---------+-------+
# | key   | varchar(64)  | NO   | PRI | NULL    |       |
# | value | varchar(255) | NO   |     | NULL    |       |
# | note  | varchar(256) | YES  |     | NULL    |       |
# +-------+--------------+------+-----+---------+-------+

CREATE TABLE `setting` (
  `key` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`key`),
  UNIQUE KEY `key_UNIQUE` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci