lbqms.git - Gitblit

			@@ -5,7 +5,7 @@
			create table sys_dept (
			dept_id bigint(20) not null comment '部门id',
			parent_id bigint(20) default 0 comment '父部门id',
			ancestors varchar(50) default '' comment '祖级列表',
			ancestors varchar(500) default '' comment '祖级列表',
			dept_name varchar(30) default '' comment '部门名称',
			order_num int(4) default 0 comment '显示顺序',
			leader varchar(20) default null comment '负责人',
			@@ -173,6 +173,7 @@
			insert into sys_menu values('108', '日志管理', '1', '9', 'log', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, '日志管理菜单');
			insert into sys_menu values('109', '在线用户', '2', '1', 'online', 'monitor/online/index', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, '在线用户菜单');
			insert into sys_menu values('111', '数据监控', '2', '3', 'druid', 'monitor/druid/index', '', 1, 0, 'C', '0', '0', 'monitor:druid:list', 'druid', 'admin', sysdate(), '', null, '数据监控菜单');
			insert into sys_menu values('112', '缓存列表', '2', '6', 'cacheList', 'monitor/cache/list', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis-list', 'admin', sysdate(), '', null, '缓存列表菜单');
			insert into sys_menu values('113', '缓存监控', '2', '5', 'cache', 'monitor/cache/index', '', 1, 0, 'C', '0', '0', 'monitor:cache:list', 'redis', 'admin', sysdate(), '', null, '缓存监控菜单');
			insert into sys_menu values('114', '表单构建', '3', '1', 'build', 'tool/build/index', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, '表单构建菜单');
			insert into sys_menu values('115', '代码生成', '3', '2', 'gen', 'tool/gen/index', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, '代码生成菜单');
			@@ -515,7 +516,7 @@
			-- ----------------------------
			drop table if exists sys_config;
			create table sys_config (
			config_id int(5) not null comment '参数主键',
			config_id bigint(20) not null comment '参数主键',
			config_name varchar(100) default '' comment '参数名称',
			config_key varchar(100) default '' comment '参数键名',
			config_value varchar(500) default '' comment '参数键值',
			@@ -559,7 +560,7 @@
			-- ----------------------------
			drop table if exists sys_notice;
			create table sys_notice (
			notice_id int(4) not null comment '公告ID',
			notice_id bigint(20) not null comment '公告ID',
			notice_title varchar(50) not null comment '公告标题',
			notice_type char(1) not null comment '公告类型（1通知 2公告）',
			notice_content longblob default null comment '公告内容',
			@@ -614,7 +615,7 @@
			drop table if exists gen_table_column;
			create table gen_table_column (
			column_id bigint(20) not null comment '编号',
			table_id varchar(64) comment '归属表编号',
			table_id bigint(20) comment '归属表编号',
			column_name varchar(200) comment '列名称',
			column_comment varchar(500) comment '列描述',
			column_type varchar(100) comment '列类型',
			@@ -668,6 +669,7 @@
			bucket_name varchar(255) default '' comment '桶名称',
			prefix varchar(255) default '' comment '前缀',
			endpoint varchar(255) default '' comment '访问站点',
			domain varchar(255) default '' comment '自定义域名',
			is_https char(1) default 'N' comment '是否https（Y=是,N=否）',
			region varchar(255) default '' comment '域',
			status char(1) default '1' comment '状态（0=正常,1=停用）',
			@@ -680,7 +682,9 @@
			primary key (oss_config_id)
			) engine=innodb comment='对象存储配置表';

			insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', 'http://localhost:9000', 'N', '', '0', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '0', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);
			insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL);