| | |
|---|
| | | 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 '用户邮箱'; |
|---|
| | |
|---|
| | | -- 二级菜单 |
|---|
| | | insert into sys_menu values('123', '客户端管理', '1', '1', 'client', 'system/client/index', '', '1', '0', 'C', '0', '0', 'system:client:list', 'international', 103, 1, now(), null, null, '客户端管理菜单'); |
|---|
| | | -- 客户端管理按钮 |
|---|
| | | insert into sys_menu values('1061', '客户端管理查询', '123', '1', '#', '', '1', '0', 'F', '0', '0', 'system:client:query', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1062', '客户端管理新增', '123', '2', '#', '', '1', '0', 'F', '0', '0', 'system:client:add', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1063', '客户端管理修改', '123', '3', '#', '', '1', '0', 'F', '0', '0', 'system:client:edit', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1064', '客户端管理删除', '123', '4', '#', '', '1', '0', 'F', '0', '0', 'system:client:remove', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1065', '客户端管理导出', '123', '5', '#', '', '1', '0', 'F', '0', '0', 'system:client:export', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1061', '客户端管理查询', '123', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:query', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1062', '客户端管理新增', '123', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:add', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1063', '客户端管理修改', '123', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:edit', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1064', '客户端管理删除', '123', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:remove', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1065', '客户端管理导出', '123', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:client:export', '#', 103, 1, now(), null, null, ''); |
|---|
| | | |
|---|
| | | -- 角色菜单权限 |
|---|
| | | insert into sys_role_menu values ('2', '1061'); |
|---|
