| | |
|---|
| | | comment on column sys_social.id is '主键'; |
|---|
| | | comment on column sys_social.user_id is '用户ID'; |
|---|
| | | comment on column sys_social.tenant_id is '租户id'; |
|---|
| | | comment on column sys_social.auth_id is '授权+授权openid'; |
|---|
| | | comment on column sys_social.auth_id is '平台+平台唯一id'; |
|---|
| | | comment on column sys_social.source is '用户来源'; |
|---|
| | | comment on column sys_social.open_id is '原生openid'; |
|---|
| | | comment on column sys_social.open_id is '平台编号唯一id'; |
|---|
| | | comment on column sys_social.user_name is '登录账号'; |
|---|
| | | comment on column sys_social.nick_name is '用户昵称'; |
|---|
| | | comment on column sys_social.email is '用户邮箱'; |
|---|
| | |
|---|
| | | comment on column sys_social.update_by is '更新者'; |
|---|
| | | comment on column sys_social.update_time is '更新时间'; |
|---|
| | | comment on column sys_social.del_flag is '删除标志（0代表存在 2代表删除）'; |
|---|
| | | |
|---|
| | | insert into sys_social values (1, 1, '000000', 'GITEE1766278', 'GITEE', NULL, 'JavaLionLi', '', '', 'https://foruda.gitee.com/avatar/1676987709652631782/1766278_javalionli_1585201115.png', '2a25b8a8b6803939070d931cdb1f9540', 86400, '448155d0a9c35e6a036a346f7a090f9b3aa7fd41fd2e9563e71e38a7faffbe1c', NULL, NULL, 'user_info projects', 'bearer', NULL, NULL, NULL, NULL, NULL, NULL, 103, 1, '2023-07-13 17:12:01', 1, '2023-07-13 17:12:01', '0'); |
|---|
| | | |
|---|
| | | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- 系统授权表 |
|---|
| | |
|---|
| | | insert into sys_dict_data values(36, '000000', 0, 'APP端', 'app', 'sys_device_type', '', 'default', 'N', '0', 103, 1, sysdate, null, null, 'APP端'); |
|---|
| | | |
|---|
| | | -- 二级菜单 |
|---|
| | | insert into sys_menu values('123', '客户端管理', '1', '1', 'client', 'system/client/index', '', 1, 0, 'C', '0', '0', 'system:client:list', 'international', 103, 1, sysdate, null, null, '客户端管理菜单'); |
|---|
| | | insert into sys_menu values('123', '客户端管理', '1', '11', 'client', 'system/client/index', '', 1, 0, 'C', '0', '0', 'system:client:list', 'international', 103, 1, sysdate, null, null, '客户端管理菜单'); |
|---|
| | | -- 客户端管理按钮 |
|---|
| | | insert into sys_menu values('1061', '客户端管理查询', '123', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:client:query', '#', 103, 1, sysdate, null, null, ''); |
|---|
| | | insert into sys_menu values('1062', '客户端管理新增', '123', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:client:add', '#', 103, 1, sysdate, null, null, ''); |
|---|
