From 591f1a4e3f1dbf6c2c209032239bec7fcf63fc91 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期二, 20 二月 2024 09:17:30 +0800 Subject: [PATCH] bug修复+引入系统监控 --- sql/ry_20231130.sql | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 59 insertions(+), 0 deletions(-) diff --git a/sql/ry_20231130.sql b/sql/ry_20231130.sql index 457bb09..705e32d 100644 --- a/sql/ry_20231130.sql +++ b/sql/ry_20231130.sql @@ -910,3 +910,62 @@ insert into sys_config values (6, '鐢ㄦ埛鐧诲綍-榛戝悕鍗曞垪琛�', 'sys.login.blackIPList', '', 'Y', 'admin', sysdate(), '', null, '璁剧疆鐧诲綍IP榛戝悕鍗曢檺鍒讹紝澶氫釜鍖归厤椤逛互;鍒嗛殧锛屾敮鎸佸尮閰嶏紙*閫氶厤銆佺綉娈碉級'); + + +-- ---------------------------- +-- 18銆佷唬鐮佺敓鎴愪笟鍔¤〃 +-- ---------------------------- +drop table if exists gen_table; +create table gen_table ( + table_id bigint(20) not null auto_increment comment '缂栧彿', + table_name varchar(200) default '' comment '琛ㄥ悕绉�', + table_comment varchar(500) default '' comment '琛ㄦ弿杩�', + sub_table_name varchar(64) default null comment '鍏宠仈瀛愯〃鐨勮〃鍚�', + sub_table_fk_name varchar(64) default null comment '瀛愯〃鍏宠仈鐨勫閿悕', + class_name varchar(100) default '' comment '瀹炰綋绫诲悕绉�', + tpl_category varchar(200) default 'crud' comment '浣跨敤鐨勬ā鏉匡紙crud鍗曡〃鎿嶄綔 tree鏍戣〃鎿嶄綔锛�', + package_name varchar(100) comment '鐢熸垚鍖呰矾寰�', + module_name varchar(30) comment '鐢熸垚妯″潡鍚�', + business_name varchar(30) comment '鐢熸垚涓氬姟鍚�', + function_name varchar(50) comment '鐢熸垚鍔熻兘鍚�', + function_author varchar(50) comment '鐢熸垚鍔熻兘浣滆��', + gen_type char(1) default '0' comment '鐢熸垚浠g爜鏂瑰紡锛�0zip鍘嬬缉鍖� 1鑷畾涔夎矾寰勶級', + gen_path varchar(200) default '/' comment '鐢熸垚璺緞锛堜笉濉粯璁ら」鐩矾寰勶級', + options varchar(1000) comment '鍏跺畠鐢熸垚閫夐」', + create_by varchar(64) default '' comment '鍒涘缓鑰�', + create_time datetime comment '鍒涘缓鏃堕棿', + update_by varchar(64) default '' comment '鏇存柊鑰�', + update_time datetime comment '鏇存柊鏃堕棿', + remark varchar(500) default null comment '澶囨敞', + primary key (table_id) +) engine=innodb auto_increment=1 comment = '浠g爜鐢熸垚涓氬姟琛�'; + +-- ---------------------------- +-- 19銆佷唬鐮佺敓鎴愪笟鍔¤〃瀛楁 +-- ---------------------------- +drop table if exists gen_table_column; +create table gen_table_column ( + column_id bigint(20) not null auto_increment comment '缂栧彿', + table_id varchar(64) comment '褰掑睘琛ㄧ紪鍙�', + column_name varchar(200) comment '鍒楀悕绉�', + column_comment varchar(500) comment '鍒楁弿杩�', + column_type varchar(100) comment '鍒楃被鍨�', + java_type varchar(500) comment 'JAVA绫诲瀷', + java_field varchar(200) comment 'JAVA瀛楁鍚�', + is_pk char(1) comment '鏄惁涓婚敭锛�1鏄級', + is_increment char(1) comment '鏄惁鑷锛�1鏄級', + is_required char(1) comment '鏄惁蹇呭~锛�1鏄級', + is_insert char(1) comment '鏄惁涓烘彃鍏ュ瓧娈碉紙1鏄級', + is_edit char(1) comment '鏄惁缂栬緫瀛楁锛�1鏄級', + is_list char(1) comment '鏄惁鍒楄〃瀛楁锛�1鏄級', + is_query char(1) comment '鏄惁鏌ヨ瀛楁锛�1鏄級', + query_type varchar(200) default 'EQ' comment '鏌ヨ鏂瑰紡锛堢瓑浜庛�佷笉绛変簬銆佸ぇ浜庛�佸皬浜庛�佽寖鍥达級', + html_type varchar(200) comment '鏄剧ず绫诲瀷锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佹棩鏈熸帶浠讹級', + dict_type varchar(200) default '' comment '瀛楀吀绫诲瀷', + sort int comment '鎺掑簭', + create_by varchar(64) default '' comment '鍒涘缓鑰�', + create_time datetime comment '鍒涘缓鏃堕棿', + update_by varchar(64) default '' comment '鏇存柊鑰�', + update_time datetime comment '鏇存柊鏃堕棿', + primary key (column_id) +) engine=innodb auto_increment=1 comment = '浠g爜鐢熸垚涓氬姟琛ㄥ瓧娈�'; \ No newline at end of file -- Gitblit v1.8.0