lbqms.git - Gitblit

			@@ -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 '日志主键';
			@@ -848,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';
			@@ -910,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,
			@@ -936,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 '关联子表的表名';