| | |
| | | -- ---------------------------- |
| | | -- 初始化-岗位信息表数据 |
| | | -- ---------------------------- |
| | | insert into sys_post values(1, '000000', 100, 'ceo', null, '董事长', 1, '0', 103, 1, sysdate(), null, null, ''); |
| | | insert into sys_post values(1, '000000', 103, 'ceo', null, '董事长', 1, '0', 103, 1, sysdate(), null, null, ''); |
| | | insert into sys_post values(2, '000000', 100, 'se', null, '项目经理', 2, '0', 103, 1, sysdate(), null, null, ''); |
| | | insert into sys_post values(3, '000000', 100, 'hr', null, '人力资源', 3, '0', 103, 1, sysdate(), null, null, ''); |
| | | insert into sys_post values(4, '000000', 100, 'user', null, '普通员工', 4, '0', 103, 1, sysdate(), null, null, ''); |
| | |
| | | -- OSS对象存储动态配置表 |
| | | -- ---------------------------- |
| | | create table sys_oss_config ( |
| | | oss_config_id bigint(20) not null comment '主建', |
| | | oss_config_id bigint(20) not null comment '主键', |
| | | tenant_id varchar(20) default '000000'comment '租户编号', |
| | | config_key varchar(20) not null default '' comment '配置key', |
| | | access_key varchar(255) default '' comment 'accessKey', |