| | |
| | | -- ---------------------------- |
| | | -- 第三方平台授权表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_social; |
| | | create table sys_social |
| | | ( |
| | | id bigint not null comment '主键', |
| | | user_id bigint not null comment '用户ID', |
| | | tenant_id varchar(20) default null comment '租户id', |
| | | tenant_id varchar(20) default '000000' comment '租户id', |
| | | auth_id varchar(255) not null comment '平台+平台唯一id', |
| | | source varchar(255) not null comment '用户来源', |
| | | open_id varchar(255) default null comment '平台编号唯一id', |
| | |
| | | create_time datetime comment '创建时间', |
| | | update_by bigint(20) comment '更新者', |
| | | update_time datetime comment '更新时间', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 2代表删除)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 1代表删除)', |
| | | PRIMARY KEY (id) |
| | | ) engine=innodb comment = '社会化关系表'; |
| | | |
| | |
| | | -- ---------------------------- |
| | | -- 租户表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_tenant; |
| | | create table sys_tenant |
| | | ( |
| | | id bigint(20) not null comment 'id', |
| | |
| | | expire_time datetime comment '过期时间', |
| | | account_count int default -1 comment '用户数量(-1不限制)', |
| | | status char(1) default '0' comment '租户状态(0正常 1停用)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 2代表删除)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 1代表删除)', |
| | | create_dept bigint(20) comment '创建部门', |
| | | create_by bigint(20) comment '创建者', |
| | | create_time datetime comment '创建时间', |
| | |
| | | -- ---------------------------- |
| | | -- 租户套餐表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_tenant_package; |
| | | create table sys_tenant_package ( |
| | | package_id bigint(20) not null comment '租户套餐id', |
| | | package_name varchar(20) comment '套餐名称', |
| | |
| | | remark varchar(200) comment '备注', |
| | | menu_check_strictly tinyint(1) default 1 comment '菜单树选择项是否关联显示', |
| | | status char(1) default '0' comment '状态(0正常 1停用)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 2代表删除)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 1代表删除)', |
| | | create_dept bigint(20) comment '创建部门', |
| | | create_by bigint(20) comment '创建者', |
| | | create_time datetime comment '创建时间', |
| | |
| | | -- ---------------------------- |
| | | -- 1、部门表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_dept; |
| | | create table sys_dept ( |
| | | dept_id bigint(20) not null comment '部门id', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | | parent_id bigint(20) default 0 comment '父部门id', |
| | | ancestors varchar(500) default '' comment '祖级列表', |
| | | dept_name varchar(30) default '' comment '部门名称', |
| | | dept_category varchar(100) default null comment '部门类别编码', |
| | | order_num int(4) default 0 comment '显示顺序', |
| | | leader bigint(20) default null comment '负责人', |
| | | phone varchar(11) default null comment '联系电话', |
| | | email varchar(50) default null comment '邮箱', |
| | | status char(1) default '0' comment '部门状态(0正常 1停用)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 2代表删除)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 1代表删除)', |
| | | create_dept bigint(20) default null comment '创建部门', |
| | | create_by bigint(20) default null comment '创建者', |
| | | create_time datetime comment '创建时间', |
| | |
| | | -- ---------------------------- |
| | | |
| | | |
| | | insert into sys_dept values(100, '000000', 0, '0', 'XXX科技', 0, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(101, '000000', 100, '0,100', '深圳总公司', 1, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(102, '000000', 100, '0,100', '长沙分公司', 2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(103, '000000', 101, '0,100,101', '研发部门', 1, 1, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(104, '000000', 101, '0,100,101', '市场部门', 2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(105, '000000', 101, '0,100,101', '测试部门', 3, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(106, '000000', 101, '0,100,101', '财务部门', 4, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(107, '000000', 101, '0,100,101', '运维部门', 5, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(108, '000000', 102, '0,100,102', '市场部门', 1, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(109, '000000', 102, '0,100,102', '财务部门', 2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(100, '000000', 0, '0', 'XXX科技', null,0, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(101, '000000', 100, '0,100', '深圳总公司', null,1, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(102, '000000', 100, '0,100', '长沙分公司', null,2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(103, '000000', 101, '0,100,101', '研发部门', null,1, 1, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(104, '000000', 101, '0,100,101', '市场部门', null,2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(105, '000000', 101, '0,100,101', '测试部门', null,3, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(106, '000000', 101, '0,100,101', '财务部门', null,4, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(107, '000000', 101, '0,100,101', '运维部门', null,5, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(108, '000000', 102, '0,100,102', '市场部门', null,1, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | insert into sys_dept values(109, '000000', 102, '0,100,102', '财务部门', null,2, null, '15888888888', 'xxx@qq.com', '0', '0', 103, 1, sysdate(), null, null); |
| | | |
| | | |
| | | -- ---------------------------- |
| | | -- 2、用户信息表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_user; |
| | | create table sys_user ( |
| | | user_id bigint(20) not null comment '用户ID', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | |
| | | avatar bigint(20) comment '头像地址', |
| | | password varchar(100) default '' comment '密码', |
| | | status char(1) default '0' comment '帐号状态(0正常 1停用)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 2代表删除)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 1代表删除)', |
| | | login_ip varchar(128) default '' comment '最后登录IP', |
| | | login_date datetime comment '最后登录时间', |
| | | create_dept bigint(20) default null comment '创建部门', |
| | |
| | | -- ---------------------------- |
| | | -- 3、岗位信息表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_post; |
| | | create table sys_post |
| | | ( |
| | | post_id bigint(20) not null comment '岗位ID', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | | dept_id bigint(20) not null comment '部门id', |
| | | post_code varchar(64) not null comment '岗位编码', |
| | | post_category varchar(100) default null comment '岗位类别编码', |
| | | post_name varchar(50) not null comment '岗位名称', |
| | | post_sort int(4) not null comment '显示顺序', |
| | | status char(1) not null comment '状态(0正常 1停用)', |
| | |
| | | -- ---------------------------- |
| | | -- 初始化-岗位信息表数据 |
| | | -- ---------------------------- |
| | | insert into sys_post values(1, '000000', 'ceo', '董事长', 1, '0', 103, 1, sysdate(), null, null, ''); |
| | | insert into sys_post values(2, '000000', 'se', '项目经理', 2, '0', 103, 1, sysdate(), null, null, ''); |
| | | insert into sys_post values(3, '000000', 'hr', '人力资源', 3, '0', 103, 1, sysdate(), null, null, ''); |
| | | insert into sys_post values(4, '000000', 'user', '普通员工', 4, '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, ''); |
| | | |
| | | |
| | | -- ---------------------------- |
| | | -- 4、角色信息表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_role; |
| | | create table sys_role ( |
| | | role_id bigint(20) not null comment '角色ID', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | |
| | | menu_check_strictly tinyint(1) default 1 comment '菜单树选择项是否关联显示', |
| | | dept_check_strictly tinyint(1) default 1 comment '部门树选择项是否关联显示', |
| | | status char(1) not null comment '角色状态(0正常 1停用)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 2代表删除)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 1代表删除)', |
| | | create_dept bigint(20) default null comment '创建部门', |
| | | create_by bigint(20) default null comment '创建者', |
| | | create_time datetime comment '创建时间', |
| | |
| | | -- ---------------------------- |
| | | -- 5、菜单权限表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_menu; |
| | | create table sys_menu ( |
| | | menu_id bigint(20) not null comment '菜单ID', |
| | | menu_name varchar(50) not null comment '菜单名称', |
| | |
| | | insert into sys_menu values('108', '日志管理', '1', '9', 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 103, 1, sysdate(), null, null, '日志管理菜单'); |
| | | insert into sys_menu values('109', '在线用户', '2', '1', 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 103, 1, sysdate(), null, null, '在线用户菜单'); |
| | | insert into sys_menu values('113', '缓存监控', '2', '5', 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 103, 1, sysdate(), null, null, '缓存监控菜单'); |
| | | insert into sys_menu values('114', '表单构建', '3', '1', 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 103, 1, sysdate(), null, null, '表单构建菜单'); |
| | | insert into sys_menu values('115', '代码生成', '3', '2', 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 103, 1, sysdate(), null, null, '代码生成菜单'); |
| | | insert into sys_menu values('121', '租户管理', '6', '1', 'tenant', 'system/tenant/index', '', 1, 0, 'C', '0', '0', 'system:tenant:list', 'list', 103, 1, sysdate(), null, null, '租户管理菜单'); |
| | | insert into sys_menu values('122', '租户套餐管理', '6', '2', 'tenantPackage', 'system/tenantPackage/index', '', 1, 0, 'C', '0', '0', 'system:tenantPackage:list', 'form', 103, 1, sysdate(), null, null, '租户套餐管理菜单'); |
| | |
| | | insert into sys_menu values('117', 'Admin监控', '2', '5', 'Admin', 'monitor/admin/index', '', 1, 0, 'C', '0', '0', 'monitor:admin:list', 'dashboard', 103, 1, sysdate(), null, null, 'Admin监控菜单'); |
| | | -- oss菜单 |
| | | insert into sys_menu values('118', '文件管理', '1', '10', 'oss', 'system/oss/index', '', 1, 0, 'C', '0', '0', 'system:oss:list', 'upload', 103, 1, sysdate(), null, null, '文件管理菜单'); |
| | | -- powerjob server控制台 |
| | | insert into sys_menu values('120', '任务调度中心', '2', '5', 'powerjob', 'monitor/powerjob/index', '', 1, 0, 'C', '0', '0', 'monitor:powerjob:list', 'job', 103, 1, sysdate(), null, null, 'PowerJob控制台菜单'); |
| | | -- retry server控制台 |
| | | insert into sys_menu values('130', 'EasyRetry控制台', '2', '6', 'easyretry', 'monitor/easyretry/index', '', 1, 0, 'C', '0', '0', 'monitor:easyretry:list', 'job', 103, 1, sysdate(), null, null, 'EasyRetry控制台菜单'); |
| | | -- snail-job server控制台 |
| | | insert into sys_menu values('120', '任务调度中心', '2', '6', 'snailjob', 'monitor/snailjob/index', '', 1, 0, 'C', '0', '0', 'monitor:snailjob:list', 'job', 103, 1, sysdate(), null, null, 'SnailJob控制台菜单'); |
| | | |
| | | -- 三级菜单 |
| | | insert into sys_menu values('500', '操作日志', '108', '1', 'operlog', 'monitor/operlog/index', '', 1, 0, 'C', '0', '0', 'monitor:operlog:list', 'form', 103, 1, sysdate(), null, null, '操作日志菜单'); |
| | |
| | | -- ---------------------------- |
| | | -- 6、用户和角色关联表 用户N-1角色 |
| | | -- ---------------------------- |
| | | drop table if exists sys_user_role; |
| | | create table sys_user_role ( |
| | | user_id bigint(20) not null comment '用户ID', |
| | | role_id bigint(20) not null comment '角色ID', |
| | |
| | | -- ---------------------------- |
| | | -- 7、角色和菜单关联表 角色1-N菜单 |
| | | -- ---------------------------- |
| | | drop table if exists sys_role_menu; |
| | | create table sys_role_menu ( |
| | | role_id bigint(20) not null comment '角色ID', |
| | | menu_id bigint(20) not null comment '菜单ID', |
| | |
| | | insert into sys_role_menu values ('3', '106'); |
| | | insert into sys_role_menu values ('3', '107'); |
| | | insert into sys_role_menu values ('3', '108'); |
| | | insert into sys_role_menu values ('3', '118'); |
| | | insert into sys_role_menu values ('3', '123'); |
| | | insert into sys_role_menu values ('3', '500'); |
| | | insert into sys_role_menu values ('3', '501'); |
| | | insert into sys_role_menu values ('3', '1001'); |
| | |
| | | insert into sys_role_menu values ('3', '1043'); |
| | | insert into sys_role_menu values ('3', '1044'); |
| | | insert into sys_role_menu values ('3', '1045'); |
| | | insert into sys_role_menu values ('3', '1050'); |
| | | insert into sys_role_menu values ('3', '1061'); |
| | | insert into sys_role_menu values ('3', '1062'); |
| | | insert into sys_role_menu values ('3', '1063'); |
| | | insert into sys_role_menu values ('3', '1064'); |
| | | insert into sys_role_menu values ('3', '1065'); |
| | | insert into sys_role_menu values ('3', '1500'); |
| | | insert into sys_role_menu values ('3', '1501'); |
| | | insert into sys_role_menu values ('3', '1502'); |
| | |
| | | insert into sys_role_menu values ('3', '1509'); |
| | | insert into sys_role_menu values ('3', '1510'); |
| | | insert into sys_role_menu values ('3', '1511'); |
| | | insert into sys_role_menu values ('3', '1600'); |
| | | insert into sys_role_menu values ('3', '1601'); |
| | | insert into sys_role_menu values ('3', '1602'); |
| | | insert into sys_role_menu values ('3', '1603'); |
| | | insert into sys_role_menu values ('3', '1620'); |
| | | insert into sys_role_menu values ('3', '1621'); |
| | | insert into sys_role_menu values ('3', '1622'); |
| | | insert into sys_role_menu values ('3', '1623'); |
| | | insert into sys_role_menu values ('3', '11618'); |
| | | insert into sys_role_menu values ('3', '11619'); |
| | | insert into sys_role_menu values ('3', '11629'); |
| | | insert into sys_role_menu values ('3', '11632'); |
| | | insert into sys_role_menu values ('3', '11633'); |
| | | insert into sys_role_menu values ('3', '11638'); |
| | | insert into sys_role_menu values ('3', '11639'); |
| | | insert into sys_role_menu values ('3', '11640'); |
| | | insert into sys_role_menu values ('3', '11641'); |
| | | insert into sys_role_menu values ('3', '11642'); |
| | | insert into sys_role_menu values ('3', '11643'); |
| | | insert into sys_role_menu values ('4', '5'); |
| | | insert into sys_role_menu values ('4', '1500'); |
| | | insert into sys_role_menu values ('4', '1501'); |
| | |
| | | -- ---------------------------- |
| | | -- 8、角色和部门关联表 角色1-N部门 |
| | | -- ---------------------------- |
| | | drop table if exists sys_role_dept; |
| | | create table sys_role_dept ( |
| | | role_id bigint(20) not null comment '角色ID', |
| | | dept_id bigint(20) not null comment '部门ID', |
| | |
| | | -- ---------------------------- |
| | | -- 9、用户与岗位关联表 用户1-N岗位 |
| | | -- ---------------------------- |
| | | drop table if exists sys_user_post; |
| | | create table sys_user_post |
| | | ( |
| | | user_id bigint(20) not null comment '用户ID', |
| | |
| | | -- ---------------------------- |
| | | -- 10、操作日志记录 |
| | | -- ---------------------------- |
| | | drop table if exists sys_oper_log; |
| | | create table sys_oper_log ( |
| | | oper_id bigint(20) not null comment '日志主键', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | |
| | | oper_url varchar(255) default '' comment '请求URL', |
| | | oper_ip varchar(128) default '' comment '主机地址', |
| | | oper_location varchar(255) default '' comment '操作地点', |
| | | oper_param varchar(2000) default '' comment '请求参数', |
| | | json_result varchar(2000) default '' comment '返回参数', |
| | | oper_param varchar(4000) default '' comment '请求参数', |
| | | json_result varchar(4000) default '' comment '返回参数', |
| | | status int(1) default 0 comment '操作状态(0正常 1异常)', |
| | | error_msg varchar(2000) default '' comment '错误消息', |
| | | error_msg varchar(4000) default '' comment '错误消息', |
| | | oper_time datetime comment '操作时间', |
| | | cost_time bigint(20) default 0 comment '消耗时间', |
| | | primary key (oper_id), |
| | |
| | | -- ---------------------------- |
| | | -- 11、字典类型表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_dict_type; |
| | | create table sys_dict_type |
| | | ( |
| | | dict_id bigint(20) not null comment '字典主键', |
| | |
| | | -- ---------------------------- |
| | | -- 12、字典数据表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_dict_data; |
| | | create table sys_dict_data |
| | | ( |
| | | dict_code bigint(20) not null comment '字典编码', |
| | |
| | | -- ---------------------------- |
| | | -- 13、参数配置表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_config; |
| | | create table sys_config ( |
| | | config_id bigint(20) not null comment '参数主键', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | |
| | | -- ---------------------------- |
| | | -- 14、系统访问记录 |
| | | -- ---------------------------- |
| | | drop table if exists sys_logininfor; |
| | | create table sys_logininfor ( |
| | | info_id bigint(20) not null comment '访问ID', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | |
| | | -- ---------------------------- |
| | | -- 17、通知公告表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_notice; |
| | | create table sys_notice ( |
| | | notice_id bigint(20) not null comment '公告ID', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | |
| | | -- ---------------------------- |
| | | -- 18、代码生成业务表 |
| | | -- ---------------------------- |
| | | drop table if exists gen_table; |
| | | create table gen_table ( |
| | | table_id bigint(20) not null comment '编号', |
| | | data_name varchar(200) default '' comment '数据源名称', |
| | |
| | | -- ---------------------------- |
| | | -- 19、代码生成业务表字段 |
| | | -- ---------------------------- |
| | | drop table if exists gen_table_column; |
| | | create table gen_table_column ( |
| | | column_id bigint(20) not null comment '编号', |
| | | table_id bigint(20) comment '归属表编号', |
| | |
| | | -- ---------------------------- |
| | | -- OSS对象存储表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_oss; |
| | | create table sys_oss ( |
| | | oss_id bigint(20) not null comment '对象存储主键', |
| | | tenant_id varchar(20) default '000000' comment '租户编号', |
| | |
| | | -- ---------------------------- |
| | | -- OSS对象存储动态配置表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_oss_config; |
| | | 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', |
| | |
| | | insert into sys_oss_config values (1, '000000', 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '1' ,'0', '', 103, 1, sysdate(), 1, sysdate(), null); |
| | | insert into sys_oss_config values (2, '000000', 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null); |
| | | insert into sys_oss_config values (3, '000000', 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null); |
| | | insert into sys_oss_config values (4, '000000', 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null); |
| | | insert into sys_oss_config values (4, '000000', 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1240000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null); |
| | | insert into sys_oss_config values (5, '000000', 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1' ,'1', '', 103, 1, sysdate(), 1, sysdate(), null); |
| | | |
| | | -- ---------------------------- |
| | | -- 系统授权表 |
| | | -- ---------------------------- |
| | | drop table if exists sys_client; |
| | | create table sys_client ( |
| | | id bigint(20) not null comment 'id', |
| | | client_id varchar(64) default null comment '客户端id', |
| | |
| | | active_timeout int(11) default 1800 comment 'token活跃超时时间', |
| | | timeout int(11) default 604800 comment 'token固定超时', |
| | | status char(1) default '0' comment '状态(0正常 1停用)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 2代表删除)', |
| | | del_flag char(1) default '0' comment '删除标志(0代表存在 1代表删除)', |
| | | create_dept bigint(20) default null comment '创建部门', |
| | | create_by bigint(20) default null comment '创建者', |
| | | create_time datetime default null comment '创建时间', |
| | |
| | | insert into sys_client values (2, '428a8310cd442757ae699df5d894f051', 'app', 'app123', 'password,sms,social', 'android', 1800, 604800, 0, 0, 103, 1, sysdate(), 1, sysdate()); |
| | | |
| | | |
| | | DROP TABLE if EXISTS test_demo; |
| | | CREATE TABLE test_demo |
| | | ( |
| | | id bigint(0) NOT NULL COMMENT '主键', |
| | |
| | | PRIMARY KEY (id) USING BTREE |
| | | ) ENGINE = InnoDB COMMENT = '测试单表'; |
| | | |
| | | DROP TABLE if EXISTS test_tree; |
| | | CREATE TABLE test_tree |
| | | ( |
| | | id bigint(0) NOT NULL COMMENT '主键', |