create table sys_client
(
    id             bigint              not null comment 'id'
        primary key,
    client_id      varchar(64)         null comment '客户端id',
    client_key     varchar(32)         null comment '客户端key',
    client_secret  varchar(255)        null comment '客户端秘钥',
    grant_type     varchar(255)        null comment '授权类型',
    device_type    varchar(32)         null comment '设备类型',
    active_timeout int  default 1800   null comment 'token活跃超时时间',
    timeout        int  default 604800 null comment 'token固定超时',
    status         char default '0'    null comment '状态（0正常 1停用）',
    del_flag       char default '0'    null comment '删除标志（0代表存在 1代表删除）',
    create_dept    bigint              null comment '创建部门',
    create_by      bigint              null comment '创建者',
    create_time    datetime            null comment '创建时间',
    update_by      bigint              null comment '更新者',
    update_time    datetime            null comment '更新时间'
)
    comment '系统授权表';

INSERT INTO ruoyi.sys_client (id, client_id, client_key, client_secret, grant_type, device_type, active_timeout, timeout, status, del_flag, create_dept, create_by, create_time, update_by, update_time) VALUES (1, 'e5cd7e4891bf95d1d19206ce24a7b32e', 'pc', 'pc123', 'password,social', 'pc', 648000, 604800, '0', '0', 103, 1, '2025-08-23 21:51:27', 1, '2025-08-23 21:51:27');
INSERT INTO ruoyi.sys_client (id, client_id, client_key, client_secret, grant_type, device_type, active_timeout, timeout, status, del_flag, create_dept, create_by, create_time, update_by, update_time) VALUES (2, '428a8310cd442757ae699df5d894f051', 'app', 'app123', 'password,sms,social', 'android', 648000, 604800, '0', '0', 103, 1, '2025-08-23 21:51:27', 1, '2025-08-23 21:51:27');
