-- 小程序用户；执行 V3 后：员工含 dept_id、dept_leader_flag，且不再与 sys_user 绑定
CREATE TABLE IF NOT EXISTS mp_user (
    id BIGINT AUTO_INCREMENT PRIMARY KEY,
    uuid VARCHAR(64) NOT NULL,
    version BIGINT NOT NULL DEFAULT 1,
    create_id BIGINT NULL,
    create_time DATETIME NULL,
    update_id BIGINT NULL,
    update_time DATETIME NULL,
    del_flag INT NOT NULL DEFAULT 0,
    open_id VARCHAR(64) NOT NULL,
    union_id VARCHAR(64) NULL,
    user_type VARCHAR(32) NOT NULL COMMENT 'VISITOR / EMPLOYEE',
    sys_user_id BIGINT NULL COMMENT '历史字段，V3 迁移后删除',
    nick_name VARCHAR(128) NULL,
    avatar_url VARCHAR(512) NULL,
    mobile VARCHAR(32) NULL,
    UNIQUE KEY uk_mp_user_uuid (uuid),
    UNIQUE KEY uk_mp_user_open_id (open_id),
    KEY idx_mp_user_sys (sys_user_id)
);