| | |
|---|
| | | union_id varchar(255) default null::varchar, |
|---|
| | | scope varchar(255) default null::varchar, |
|---|
| | | token_type varchar(255) default null::varchar, |
|---|
| | | id_token varchar(255) default null::varchar, |
|---|
| | | id_token varchar(2000) default null::varchar, |
|---|
| | | mac_algorithm varchar(255) default null::varchar, |
|---|
| | | mac_key varchar(255) default null::varchar, |
|---|
| | | code varchar(255) default null::varchar, |
|---|
| | |
|---|
| | | ancestors varchar(500)default ''::varchar, |
|---|
| | | dept_name varchar(30) default ''::varchar, |
|---|
| | | order_num int4 default 0, |
|---|
| | | leader varchar(20) default null::varchar, |
|---|
| | | leader int8 default null, |
|---|
| | | phone varchar(11) default null::varchar, |
|---|
| | | email varchar(50) default null::varchar, |
|---|
| | | status char default '0'::bpchar, |
|---|
| | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- 初始化-部门表数据 |
|---|
| | | -- ---------------------------- |
|---|
| | | insert into sys_dept values(100, '000000', 0, '0', 'XXX科技', 0, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(101, '000000', 100, '0,100', '深圳总公司', 1, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(102, '000000', 100, '0,100', '长沙分公司', 2, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(103, '000000', 101, '0,100,101', '研发部门', 1, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(104, '000000', 101, '0,100,101', '市场部门', 2, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(105, '000000', 101, '0,100,101', '测试部门', 3, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(106, '000000', 101, '0,100,101', '财务部门', 4, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(107, '000000', 101, '0,100,101', '运维部门', 5, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(108, '000000', 102, '0,100,102', '市场部门', 1, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(109, '000000', 102, '0,100,102', '财务部门', 2, '疯狂的狮子Li', '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(100, '000000', 0, '0', 'XXX科技', 0, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(101, '000000', 100, '0,100', '深圳总公司', 1, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(102, '000000', 100, '0,100', '长沙分公司', 2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(103, '000000', 101, '0,100,101', '研发部门', 1, 1, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(104, '000000', 101, '0,100,101', '市场部门', 2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(105, '000000', 101, '0,100,101', '测试部门', 3, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(106, '000000', 101, '0,100,101', '财务部门', 4, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(107, '000000', 101, '0,100,101', '运维部门', 5, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(108, '000000', 102, '0,100,102', '市场部门', 1, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | insert into sys_dept values(109, '000000', 102, '0,100,102', '财务部门', 2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, now(), null, null); |
|---|
| | | |
|---|
| | | -- ---------------------------- |
|---|
| | | -- 2、用户信息表 |
|---|
| | |
|---|
| | | insert into sys_menu values('1601', '文件上传', '118', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:upload', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1602', '文件下载', '118', '3', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:download', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1603', '文件删除', '118', '4', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:remove', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1604', '配置添加', '118', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:add', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1605', '配置编辑', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:oss:edit', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1620', '配置列表', '118', '5', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:list', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1621', '配置添加', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:add', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1622', '配置编辑', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:edit', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1623', '配置删除', '118', '6', '#', '', '', '1', '0', 'F', '0', '0', 'system:ossConfig:remove', '#', 103, 1, now(), null, null, ''); |
|---|
| | | -- 租户管理相关按钮 |
|---|
| | | insert into sys_menu values('1606', '租户查询', '121', '1', '#', '', '', '1', '0', 'F', '0', '0', 'system:tenant:query', '#', 103, 1, now(), null, null, ''); |
|---|
| | | insert into sys_menu values('1607', '租户新增', '121', '2', '#', '', '', '1', '0', 'F', '0', '0', 'system:tenant:add', '#', 103, 1, now(), null, null, ''); |
|---|
| | |
|---|
| | | info_id int8, |
|---|
| | | tenant_id varchar(20) default '000000'::varchar, |
|---|
| | | user_name varchar(50) default ''::varchar, |
|---|
| | | client_key varchar(32) default ''::varchar, |
|---|
| | | device_type varchar(32) default ''::varchar, |
|---|
| | | ipaddr varchar(128) default ''::varchar, |
|---|
| | | login_location varchar(255) default ''::varchar, |
|---|
| | | browser varchar(50) default ''::varchar, |
|---|
| | |
|---|
| | | comment on column sys_logininfor.info_id is '访问ID'; |
|---|
| | | comment on column sys_logininfor.tenant_id is '租户编号'; |
|---|
| | | comment on column sys_logininfor.user_name is '用户账号'; |
|---|
| | | comment on column sys_logininfor.client_key is '客户端'; |
|---|
| | | comment on column sys_logininfor.device_type is '设备类型'; |
|---|
| | | comment on column sys_logininfor.ipaddr is '登录IP地址'; |
|---|
| | | comment on column sys_logininfor.login_location is '登录地点'; |
|---|
| | | comment on column sys_logininfor.browser is '浏览器类型'; |
|---|
