设备信息字段 device_info 长度调整为 4000

thinkgem · Nov 11, 2024 · 3333ad2 · 3333ad2
1 parent 83752a7
commit 3333ad2
Show file tree

Hide file tree

Showing 14 changed files with 18 additions and 20 deletions.
diff --git a/modules/app/db/app.erm b/modules/app/db/app.erm
@@ -329,7 +329,7 @@
 		</word>
 		<word>
 			<id>a63e3fda50530388ba263296184d8a6919a75791</id>
-			<length>1000</length>
+			<length>4000</length>
 			<decimal>null</decimal>
 			<array>false</array>
 			<array_dimension>null</array_dimension>

diff --git a/modules/app/db/db2/app.sql b/modules/app/db/db2/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE js_app_comment
 	update_date timestamp NOT NULL,
 	remarks vargraphic(500),
 	create_by_name varchar(200),
-	device_info varchar(1000),
+	device_info varchar(4000),
 	reply_date date,
 	reply_content vargraphic(500),
 	reply_user_code varchar(64),

diff --git a/modules/app/db/h2/app.sql b/modules/app/db/h2/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE js_app_comment
 	update_date datetime NOT NULL,
 	remarks varchar(500),
 	create_by_name varchar(200),
-	device_info varchar(1000),
+	device_info varchar(4000),
 	reply_date date,
 	reply_content varchar(500),
 	reply_user_code varchar(64),

diff --git a/modules/app/db/mssql/app.sql b/modules/app/db/mssql/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE [js_app_comment]
 	[update_date] datetime NOT NULL,
 	[remarks] nvarchar(500),
 	[create_by_name] varchar(200),
-	[device_info] varchar(1000),
+	[device_info] varchar(4000),
 	[reply_date] date,
 	[reply_content] nvarchar(500),
 	[reply_user_code] varchar(64),

diff --git a/modules/app/db/mysql/app.sql b/modules/app/db/mysql/app.sql
@@ -17,7 +17,7 @@ CREATE TABLE js_app_comment
 	update_date datetime NOT NULL COMMENT '更新时间',
 	remarks varchar(500) COMMENT '备注信息',
 	create_by_name varchar(200) COMMENT '提问人员姓名',
-	device_info varchar(1000) COMMENT '设备信息',
+	device_info varchar(4000) COMMENT '设备信息',
 	reply_date date COMMENT '回复时间',
 	reply_content varchar(500) COMMENT '回复意见',
 	reply_user_code varchar(64) COMMENT '回复人员',

diff --git a/modules/app/db/oracle/app.sql b/modules/app/db/oracle/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE js_app_comment
 	update_date timestamp NOT NULL,
 	remarks nvarchar2(500),
 	create_by_name varchar2(200),
-	device_info varchar2(1000),
+	device_info varchar2(4000),
 	reply_date date,
 	reply_content nvarchar2(500),
 	reply_user_code varchar2(64),

diff --git a/modules/app/db/postgresql/app.sql b/modules/app/db/postgresql/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE js_app_comment
 	update_date timestamp NOT NULL,
 	remarks varchar(500),
 	create_by_name varchar(200),
-	device_info varchar(1000),
+	device_info varchar(4000),
 	reply_date date,
 	reply_content varchar(500),
 	reply_user_code varchar(64),

diff --git a/modules/app/src/main/java/com/jeesite/modules/app/entity/AppComment.java b/modules/app/src/main/java/com/jeesite/modules/app/entity/AppComment.java
@@ -4,17 +4,15 @@
  */
 package com.jeesite.modules.app.entity;
 
-import java.util.Date;
-
-import jakarta.validation.constraints.NotBlank;
-
-import jakarta.validation.constraints.Size;
-
 import com.fasterxml.jackson.annotation.JsonFormat;
 import com.jeesite.common.entity.DataEntity;
 import com.jeesite.common.mybatis.annotation.Column;
 import com.jeesite.common.mybatis.annotation.Table;
 import com.jeesite.common.mybatis.mapper.query.QueryType;
+import jakarta.validation.constraints.NotBlank;
+import jakarta.validation.constraints.Size;
+
+import java.util.Date;
 
 /**
  * APP意见反馈Entity
@@ -84,7 +82,7 @@ public void setContact(String contact) {
 		this.contact = contact;
 	}
 
-	@Size(min=0, max=1000, message="设备信息长度不能超过 1000 个字符")
+	@Size(min=0, max=4000, message="设备信息长度不能超过 4000 个字符")
 	public String getDeviceInfo() {
 		return deviceInfo;
 	}

diff --git a/modules/app/src/main/resources/db/create/db2/app.sql b/modules/app/src/main/resources/db/create/db2/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE ${_prefix}app_comment
 	update_date timestamp NOT NULL,
 	remarks vargraphic(500),
 	create_by_name varchar(200),
-	device_info varchar(1000),
+	device_info varchar(4000),
 	reply_date date,
 	reply_content vargraphic(500),
 	reply_user_code varchar(64),

diff --git a/modules/app/src/main/resources/db/create/h2/app.sql b/modules/app/src/main/resources/db/create/h2/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE ${_prefix}app_comment
 	update_date datetime NOT NULL,
 	remarks varchar(500),
 	create_by_name varchar(200),
-	device_info varchar(1000),
+	device_info varchar(4000),
 	reply_date date,
 	reply_content varchar(500),
 	reply_user_code varchar(64),

diff --git a/modules/app/src/main/resources/db/create/mssql/app.sql b/modules/app/src/main/resources/db/create/mssql/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE [${_prefix}app_comment]
 	[update_date] datetime NOT NULL,
 	[remarks] nvarchar(500),
 	[create_by_name] varchar(200),
-	[device_info] varchar(1000),
+	[device_info] varchar(4000),
 	[reply_date] date,
 	[reply_content] nvarchar(500),
 	[reply_user_code] varchar(64),

diff --git a/modules/app/src/main/resources/db/create/mysql/app.sql b/modules/app/src/main/resources/db/create/mysql/app.sql
@@ -17,7 +17,7 @@ CREATE TABLE ${_prefix}app_comment
 	update_date datetime NOT NULL COMMENT '更新时间',
 	remarks varchar(500) COMMENT '备注信息',
 	create_by_name varchar(200) COMMENT '提问人员姓名',
-	device_info varchar(1000) COMMENT '设备信息',
+	device_info varchar(4000) COMMENT '设备信息',
 	reply_date date COMMENT '回复时间',
 	reply_content varchar(500) COMMENT '回复意见',
 	reply_user_code varchar(64) COMMENT '回复人员',

diff --git a/modules/app/src/main/resources/db/create/oracle/app.sql b/modules/app/src/main/resources/db/create/oracle/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE ${_prefix}app_comment
 	update_date timestamp NOT NULL,
 	remarks nvarchar2(500),
 	create_by_name varchar2(200),
-	device_info varchar2(1000),
+	device_info varchar2(4000),
 	reply_date date,
 	reply_content nvarchar2(500),
 	reply_user_code varchar2(64),

diff --git a/modules/app/src/main/resources/db/create/postgresql/app.sql b/modules/app/src/main/resources/db/create/postgresql/app.sql
@@ -16,7 +16,7 @@ CREATE TABLE ${_prefix}app_comment
 	update_date timestamp NOT NULL,
 	remarks varchar(500),
 	create_by_name varchar(200),
-	device_info varchar(1000),
+	device_info varchar(4000),
 	reply_date date,
 	reply_content varchar(500),
 	reply_user_code varchar(64),