lbqms.git - Gitblit

			@@ -4,7 +4,7 @@
			create table sys_dept (
			dept_id number(20) not null,
			parent_id number(20) default 0,
			ancestors varchar2(50) default '',
			ancestors varchar2(500) default '',
			dept_name varchar2(30) default '',
			order_num number(4) default 0,
			leader varchar2(20) default null,
			@@ -258,6 +258,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, '代码生成菜单');
			@@ -522,10 +523,10 @@
			oper_url varchar2(255) default '',
			oper_ip varchar2(128) default '',
			oper_location varchar2(255) default '',
			oper_param varchar2(2000) default '',
			json_result varchar2(2000) default '',
			oper_param varchar2(2100) default '',
			json_result varchar2(2100) default '',
			status number(1) default 0,
			error_msg varchar2(2000) default '' ,
			error_msg varchar2(2100) default '' ,
			oper_time date
			);

			@@ -812,7 +813,7 @@
			-- ----------------------------
			create table gen_table_column (
			column_id number(20) not null,
			table_id varchar2(64),
			table_id number(20),
			column_name varchar2(200),
			column_comment varchar2(500),
			column_type varchar2(100),
			@@ -904,6 +905,7 @@
			bucket_name varchar(255) default '',
			prefix varchar(255) default '',
			endpoint varchar(255) default '',
			domain varchar(255) default '',
			is_https char(1) default 'N',
			region varchar(255) default '',
			status char(1) default '1',
			@@ -925,6 +927,7 @@
			comment on column sys_oss_config.bucket_name is '桶名称';
			comment on column sys_oss_config.prefix is '前缀';
			comment on column sys_oss_config.endpoint is '访问站点';
			comment on column sys_oss_config.domain is '自定义域名';
			comment on column sys_oss_config.is_https is '是否https（Y=是,N=否）';
			comment on column sys_oss_config.region is '域';
			comment on column sys_oss_config.status is '状态（0=正常,1=停用）';
			@@ -935,10 +938,12 @@
			comment on column sys_oss_config.update_by is '更新者';
			comment on column sys_oss_config.update_time is '更新时间';

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


			-- ----------------------------
			-- 钩子，用于session连接之后自动设置默认的date类型格式化简化时间查询