lbqms.git - Gitblit

			@@ -374,8 +374,8 @@
			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, '文件管理菜单');
			-- xxl-job-admin控制台
			insert into sys_menu values('120', '任务调度中心', '2', '5', 'XxlJob', 'monitor/xxljob/index', '', 1, 0, 'C', '0', '0', 'monitor:xxljob:list', 'job', 103, 1, sysdate, null, null, 'Xxl-Job控制台菜单');
			-- 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控制台菜单');

			-- 三级菜单
			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, '操作日志菜单');
			@@ -654,9 +654,9 @@
			);

			alter table sys_oper_log add constraint pk_sys_oper_log primary key (oper_id);
			create unique index idx_sys_oper_log_bt on sys_oper_log (business_type);
			create unique index idx_sys_oper_log_s on sys_oper_log (status);
			create unique index idx_sys_oper_log_ot on sys_oper_log (oper_time);
			create index idx_sys_oper_log_bt on sys_oper_log (business_type);
			create index idx_sys_oper_log_s on sys_oper_log (status);
			create index idx_sys_oper_log_ot on sys_oper_log (oper_time);

			comment on table sys_oper_log is '操作日志记录';
			comment on column sys_oper_log.oper_id is '日志主键';
			@@ -827,13 +827,7 @@
			insert into sys_config values(1, '000000', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, sysdate, null, null, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow' );
			insert into sys_config values(2, '000000', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 103, 1, sysdate, null, null, '初始化密码 123456' );
			insert into sys_config values(3, '000000', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, sysdate, null, null, '深色主题theme-dark，浅色主题theme-light' );
			insert into sys_config values(4, '000000', '用户配置-验证码有效期', 'sys.account.captchaExpired', '2', 'Y', 103, 1, sysdate, null, NULL, '验证码有效期（分钟）');
			insert into sys_config values(5, '000000', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 103, 1, sysdate, null, null, '是否开启注册用户功能（true开启，false关闭）');
			insert into sys_config values(6, '000000', '用户配置-密码最大错误次数', 'sys.user.maxRetryCount', '5', 'Y', 103, 1, sysdate, null, null, '密码最大错误次数');
			insert into sys_config values(7, '000000', '用户配置-密码锁定时间', 'sys.user.lockTime', '10', 'Y', 103, 1, sysdate, null, null, '密码锁定时间（分钟）');
			insert into sys_config values(8, '000000', '账号自助-短信开关', 'sys.account.smsEnabled', 'false', 'Y', 103, 1, sysdate, null, null, '是否开启短信功能（true开启，false关闭）');
			insert into sys_config values(9, '000000', '账号自助-验证码模板id', 'sys.account.templateId', '', 'Y', 103, 1, sysdate, null, null, '验证码模板id');
			insert into sys_config values(10, '000000', '账号自助-邮件开关', 'sys.account.emailEnabled', 'false', 'Y', 103, 1, sysdate, null, NULL, '是否开启邮件功能（true开启，false关闭）');
			insert into sys_config values(11, '000000', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, sysdate, null, null, 'true:开启, false:关闭');


			@@ -854,8 +848,8 @@
			);

			alter table sys_logininfor add constraint pk_sys_logininfor primary key (info_id);
			create unique index idx_sys_logininfor_s on sys_logininfor (status);
			create unique index idx_sys_logininfor_lt on sys_logininfor (login_time);
			create index idx_sys_logininfor_s on sys_logininfor (status);
			create index idx_sys_logininfor_lt on sys_logininfor (login_time);

			comment on table sys_logininfor is '系统访问记录';
			comment on column sys_logininfor.info_id is '访问ID';
			@@ -916,6 +910,7 @@
			-- ----------------------------
			create table gen_table (
			table_id number(20) not null,
			data_name varchar2(200) default '',
			table_name varchar2(200) default '',
			table_comment varchar2(500) default '',
			sub_table_name varchar(64) default null,
			@@ -942,6 +937,7 @@

			comment on table gen_table is '代码生成业务表';
			comment on column gen_table.table_id is '编号';
			comment on column gen_table.data_name is '数据源名称';
			comment on column gen_table.table_name is '表名称';
			comment on column gen_table.table_comment is '表描述';
			comment on column gen_table.sub_table_name is '关联子表的表名';