| 1234567891011121314151617181920212223 |
- 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');
|
