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