-- 系统级键值配置（如访客主管部门 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);