From 2b6994291e9b9cde193a9b2fb761beab9db9ff0b Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 19 十一月 2024 10:33:43 +0800
Subject: [PATCH] 1
---
docker-compose/mysql/initdb/se_cloud_20241119.sql | 174 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
se-common/se-common-core/src/main/java/com/se/common/core/web/domain/BaseEntity.java | 2
2 files changed, 176 insertions(+), 0 deletions(-)
diff --git a/docker-compose/mysql/initdb/se_cloud_20241119.sql b/docker-compose/mysql/initdb/se_cloud_20241119.sql
new file mode 100644
index 0000000..255db4b
--- /dev/null
+++ b/docker-compose/mysql/initdb/se_cloud_20241119.sql
@@ -0,0 +1,174 @@
+-- DROP DATABASE IF EXISTS `se-cloud`;
+
+CREATE DATABASE IF NOT EXISTS `se-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
+
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+
+USE `se-cloud`;
+
+-- ----------------------------
+-- 01銆佽蒋浠惰〃
+-- ----------------------------
+drop table if exists sys_soft;
+create table sys_soft (
+ soft_id bigint(20) not null auto_increment comment '杞欢ID',
+ name varchar(200) not null comment '鍚嶇О',
+ type char(1) default '0' comment '绫诲瀷锛�0-搴旂敤杞欢锛�1-鏁版嵁搴擄紝2-涓棿浠讹紝3-鎿嶄綔绯荤粺锛�',
+ lic varchar(500) comment '璁稿彲',
+ descr varchar(500) comment '鎻忚堪',
+ args varchar(8000) comment '鍙傛暟',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (soft_id)
+) engine=innodb auto_increment=1 comment = '杞欢琛�';
+select * from sys_soft order by soft_id;
+
+
+-- ----------------------------
+-- 02銆佺‖浠惰〃
+-- ----------------------------
+drop table if exists sys_hard;
+create table sys_hard (
+ hard_id bigint(20) not null auto_increment comment '纭欢ID',
+ name varchar(200) not null comment '鍚嶇О',
+ cpu varchar(20) comment 'CPU',
+ mem varchar(200) comment '鍐呭瓨',
+ disk varchar(200) comment '纭洏',
+ net varchar(200) comment '缃戠粶',
+ descr varchar(500) comment '鎻忚堪',
+ args varchar(8000) comment '鍙傛暟',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (hard_id)
+) engine=innodb auto_increment=1 comment = '纭欢琛�';
+select * from sys_hard order by hard_id;
+
+
+-- ----------------------------
+-- 03銆侀厤缃〃
+-- ----------------------------
+drop table if exists sys_cfg;
+create table sys_cfg (
+ cfg_id bigint(20) not null auto_increment comment '閰嶇疆ID',
+ name varchar(200) not null comment '鍚嶇О',
+ hard varchar(4000) comment '纭欢',
+ soft varchar(4000) comment '杞欢',
+ args varchar(4000) comment '鍙傛暟',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (cfg_id)
+) engine=innodb auto_increment=1 comment = '閰嶇疆琛�';
+select * from sys_cfg order by cfg_id;
+
+
+-- ----------------------------
+-- 04銆佽祫婧愯〃
+-- ----------------------------
+drop table if exists sys_res;
+create table sys_res (
+ res_id bigint(20) not null auto_increment comment '璧勬簮ID',
+ name varchar(200) not null comment '鍚嶇О',
+ type char(1) default '0' comment '绫诲瀷锛�0-鍏跺畠锛�1-IP锛�2-鏁版嵁搴擄紝3-娑堟伅涓棿浠讹紝4-鍏变韩鏂囦欢锛�5-鍒嗙郴缁熻蒋浠讹紝6-寮曟搸锛�',
+ descr varchar(500) comment '鎻忚堪',
+ args varchar(4000) comment '鍙傛暟',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (res_id)
+) engine=innodb auto_increment=1 comment = '璧勬簮琛�';
+select * from sys_res order by res_id;
+
+
+-- ----------------------------
+-- 05銆佹帴鍙ｈ〃
+-- ----------------------------
+drop table if exists sys_inte;
+create table sys_inte (
+ inte_id bigint(20) not null auto_increment comment '鎺ュ彛ID',
+ name varchar(200) not null comment '鍚嶇О',
+ type char(1) default '0' comment '绫诲瀷',
+ descr varchar(500) comment '鎻忚堪',
+ url varchar(4000) comment 'URL',
+ data varchar(500) comment '鏁版嵁',
+ args varchar(4000) comment '鍙傛暟',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (inte_id)
+) engine=innodb auto_increment=1 comment = '鎺ュ彛琛�';
+select * from sys_inte order by inte_id;
+
+
+-- ----------------------------
+-- 06銆佸憡璀﹁〃
+-- ----------------------------
+drop table if exists sys_warn;
+create table sys_warn (
+ warn_id bigint(20) not null auto_increment comment '鍛婅ID',
+ name varchar(200) not null comment '鍚嶇О',
+ type char(1) default '0' comment '绫诲瀷',
+ descr varchar(500) comment '鎻忚堪',
+ data varchar(500) comment '鏁版嵁',
+ args varchar(4000) comment '鍙傛暟',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (warn_id)
+) engine=innodb auto_increment=1 comment = '鍛婅琛�';
+select * from sys_warn order by warn_id;
+
+
+-- ----------------------------
+-- 07銆佸憡璀﹁〃
+-- ----------------------------
+drop table if exists sys_warn;
+create table sys_warn (
+ warn_id bigint(20) not null auto_increment comment '鍛婅ID',
+ name varchar(200) not null comment '鍚嶇О',
+ type char(1) default '0' comment '绫诲瀷',
+ descr varchar(500) comment '鎻忚堪',
+ data varchar(500) comment '鏁版嵁',
+ args varchar(4000) comment '鍙傛暟',
+ status char(1) default 0 comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
+ create_by varchar(64) default '' comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by varchar(64) default '' comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ remark varchar(500) default '' comment '澶囨敞',
+ primary key (warn_id)
+) engine=innodb auto_increment=1 comment = '鍛婅琛�';
+select * from sys_warn order by warn_id;
+
+
+
+
+
+
+
+
+
+
+
+
diff --git a/se-common/se-common-core/src/main/java/com/se/common/core/web/domain/BaseEntity.java b/se-common/se-common-core/src/main/java/com/se/common/core/web/domain/BaseEntity.java
index 4b7a1a9..4888147 100644
--- a/se-common/se-common-core/src/main/java/com/se/common/core/web/domain/BaseEntity.java
+++ b/se-common/se-common-core/src/main/java/com/se/common/core/web/domain/BaseEntity.java
@@ -13,6 +13,7 @@
*
* @author admin
*/
+@SuppressWarnings("ALL")
public class BaseEntity implements Serializable
{
private static final long serialVersionUID = 1L;
@@ -39,6 +40,7 @@
private String remark;
/** 璇锋眰鍙傛暟 */
+ //@TableField(exist = false)
@JsonInclude(JsonInclude.Include.NON_EMPTY)
private Map<String, Object> params;
--
Gitblit v1.9.3