drop table t_uc_user;
CREATE TABLE
    t_uc_user
    (
        user_id varchar(32) PRIMARY KEY,
        user_name varchar(50),
        employee_code varchar(32),
        organize_id varchar(32),
        organize_name varchar(50),
        create_time TIMESTAMP(6),
        create_by varchar(32),
        last_modify_time TIMESTAMP(6),
        last_modify_by varchar(32),
        login_name varchar(50),
        password varchar(50),
        gender varchar(20),
        account_status varchar(10),
        id_card varchar(20),
        mobile varchar(20),
        email varchar(50),
        photo varchar(100)
    );
-- 给字段添加注释
alter table t_uc_user comment '人员表';
alter table t_uc_user modify user_id varchar(32)  comment '主键';
alter table t_uc_user modify user_name varchar(50) comment '姓名';
alter table t_uc_user modify employee_code varchar(32) comment '工号';
alter table t_uc_user modify organize_id varchar(32) comment '直属部门id';
alter table t_uc_user modify organize_name varchar(50) comment '部门名称';
alter table t_uc_user modify login_name varchar(50) comment '用户名';
alter table t_uc_user modify account_status varchar(10) comment '用户状态 ENABLE 激活、FORBIDDEN 冻结、UNAPPROVED 待审批';
alter table t_uc_user modify id_card varchar(20) comment '身份证号码';
alter table t_uc_user modify mobile varchar(20) comment '手机号码';
alter table t_uc_user modify email varchar(50) comment '邮箱';

INSERT INTO t_uc_user (user_id, user_name, employee_code, organize_id, organize_name, create_time, create_by, last_modify_time, last_modify_by, login_name, password, account_status,
id_card, mobile,gender, email,photo) VALUES ('880eda246b3c4802be7d7d697c1fe7c7', '系统管理员', '100000', '282095e70c5547caa51a7e5664febd03', '徽辰智电', '2024-12-17 14:35:35', '880eda246b3c4802be7d7d697c1fe7c7', '2024-12-17 14:35:35', '880eda246b3c4802be7d7d697c1fe7c7', 'admin', '21232f297a57a5a743894a0e4a801fc3', 'ENABLE', '34122545784578', '13349163615','女', '','');