-- 系统级键值配置（如访客主管部门 id）
|
CREATE TABLE IF NOT EXISTS sys_biz_setting (
|
id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
setting_key VARCHAR(64) NOT NULL,
|
setting_value VARCHAR(64) NULL,
|
UNIQUE KEY uk_sys_biz_setting_key (setting_key)
|
);
|
|
INSERT IGNORE INTO sys_biz_setting (setting_key, setting_value)
|
VALUES ('VISIT_COMPETENT_DEPT_ID', NULL);
|
