create table sj_system_user
(
    id        bigint unsigned auto_increment comment '主键'
        primary key,
    username  varchar(64)                        not null comment '账号',
    password  varchar(128)                       not null comment '密码',
    role      tinyint  default 0                 not null comment '角色：1-普通用户、2-管理员',
    create_dt datetime default CURRENT_TIMESTAMP not null comment '创建时间',
    update_dt datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间',
    constraint uk_username
        unique (username)
)
    comment '系统用户表';

INSERT INTO ruoyi.sj_system_user (id, username, password, role, create_dt, update_dt) VALUES (1, 'admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2, '2025-08-23 21:50:38', '2025-08-23 21:50:38');
