| 208 |
- |
1 |
## Table: setting
|
|
|
2 |
#
|
|
|
3 |
# +-------+--------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +-------+--------------+------+-----+---------+-------+
|
|
|
6 |
# | key | varchar(64) | NO | PRI | NULL | |
|
|
|
7 |
# | value | varchar(255) | NO | | NULL | |
|
|
|
8 |
# | note | varchar(256) | YES | | NULL | |
|
|
|
9 |
# +-------+--------------+------+-----+---------+-------+
|
|
|
10 |
|
|
|
11 |
CREATE TABLE `setting` (
|
|
|
12 |
`key` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
13 |
`value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
|
14 |
`note` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
|
15 |
PRIMARY KEY (`key`),
|
|
|
16 |
UNIQUE KEY `key_UNIQUE` (`key`)
|
|
|
17 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|