From cd33cd66aea3cfbded96151ab78ccc58a4072171 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期五, 18 三月 2022 20:53:26 +0800
Subject: [PATCH] !158 修复demo模块字段类型错误问题 Merge pull request !158 from KonBAI/demo_field_type
---
script/sql/test.sql | 14 +++++++-------
1 files changed, 7 insertions(+), 7 deletions(-)
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