From f2a2c2d4074541b35251c0bc5397717e26c28968 Mon Sep 17 00:00:00 2001
From: konbai <1527468660@qq.com>
Date: 星期五, 18 三月 2022 20:38:17 +0800
Subject: [PATCH] fix 修复demo模块字段类型错误问题。

---
 ruoyi-demo/src/main/java/com/ruoyi/demo/domain/TestDemo.java                |    2 +-
 ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestBatchController.java |    4 ++--
 script/sql/test.sql                                                         |   14 +++++++-------
 3 files changed, 10 insertions(+), 10 deletions(-)

diff --git a/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestBatchController.java b/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestBatchController.java
index 1bb9d9f..aa1f064 100644
--- a/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestBatchController.java
+++ b/ruoyi-demo/src/main/java/com/ruoyi/demo/controller/TestBatchController.java
@@ -45,7 +45,7 @@
         List<TestDemo> list = new ArrayList<>();
         for (int i = 0; i < 1000; i++) {
             TestDemo testDemo = new TestDemo();
-            testDemo.setOrderNum(-1L);
+            testDemo.setOrderNum(-1);
             testDemo.setTestKey("鎵归噺鏂板");
             testDemo.setValue("娴嬭瘯鏂板");
             list.add(testDemo);
@@ -65,7 +65,7 @@
         List<TestDemo> list = new ArrayList<>();
         for (int i = 0; i < 1000; i++) {
             TestDemo testDemo = new TestDemo();
-            testDemo.setOrderNum(-1L);
+            testDemo.setOrderNum(-1);
             testDemo.setTestKey("鎵归噺鏂板");
             testDemo.setValue("娴嬭瘯鏂板");
             list.add(testDemo);        }
diff --git a/ruoyi-demo/src/main/java/com/ruoyi/demo/domain/TestDemo.java b/ruoyi-demo/src/main/java/com/ruoyi/demo/domain/TestDemo.java
index c079d12..dc19ce2 100644
--- a/ruoyi-demo/src/main/java/com/ruoyi/demo/domain/TestDemo.java
+++ b/ruoyi-demo/src/main/java/com/ruoyi/demo/domain/TestDemo.java
@@ -39,7 +39,7 @@
      * 鎺掑簭鍙�
      */
     @OrderBy(asc = false, sort = 1)
-    private Long orderNum;
+    private Integer orderNum;
 
     /**
      * key閿�
diff --git a/script/sql/test.sql b/script/sql/test.sql
index fd547e7..cfe3add 100644
--- a/script/sql/test.sql
+++ b/script/sql/test.sql
@@ -1,9 +1,9 @@
 DROP TABLE if EXISTS test_demo;
 CREATE TABLE test_demo
 (
-    id          int(0)       NOT NULL COMMENT '涓婚敭',
-    dept_id     int(0)       NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
-    user_id     int(0)       NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
+    id          bigint(20)   NOT NULL COMMENT '涓婚敭',
+    dept_id     bigint(20)   NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
+    user_id     bigint(20)   NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
     order_num   int(0)       NULL DEFAULT 0 COMMENT '鎺掑簭鍙�',
     test_key    varchar(255) NULL DEFAULT NULL COMMENT 'key閿�',
     value       varchar(255) NULL DEFAULT NULL COMMENT '鍊�',
@@ -19,10 +19,10 @@
 DROP TABLE if EXISTS test_tree;
 CREATE TABLE test_tree
 (
-    id          int(0)       NOT NULL COMMENT '涓婚敭',
-    parent_id   int(0)       NULL DEFAULT 0 COMMENT '鐖秈d',
-    dept_id     int(0)       NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
-    user_id     int(0)       NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
+    id          bigint(20)   NOT NULL COMMENT '涓婚敭',
+    parent_id   bigint(20)   NULL DEFAULT 0 COMMENT '鐖秈d',
+    dept_id     bigint(20)   NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
+    user_id     bigint(20)   NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
     tree_name   varchar(255) NULL DEFAULT NULL COMMENT '鍊�',
     version     int(0)       NULL DEFAULT 0 COMMENT '鐗堟湰',
     create_time datetime(0)  NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',

--
Gitblit v1.9.3