From 4770b0d3e33f27f58ad0ccc1cfb70ab223018b25 Mon Sep 17 00:00:00 2001
From: hewenqiang <1527468660@qq.com>
Date: 星期三, 16 三月 2022 16:53:17 +0800
Subject: [PATCH] fix 修复根据用户ID查询菜单信息SQL报错。`status`字段为char类型，应该传字符类型，此处存在隐式转换问题。（MySQL能自动转换，PostgreSQL转换报错）。
---
script/sql/test.sql | 40 ++++++++++++++++++++--------------------
1 files changed, 20 insertions(+), 20 deletions(-)
diff --git a/script/sql/test.sql b/script/sql/test.sql
index 5d70965..fd547e7 100644
--- a/script/sql/test.sql
+++ b/script/sql/test.sql
@@ -1,35 +1,35 @@
DROP TABLE if EXISTS test_demo;
CREATE TABLE test_demo
(
- id int(0) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
- dept_id int(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
- user_id int(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛id',
- order_num int(0) NULL DEFAULT 0 COMMENT '鎺掑簭鍙�',
+ id int(0) NOT NULL COMMENT '涓婚敭',
+ dept_id int(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
+ user_id int(0) 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 '鍊�',
- version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
- create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
- update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
- del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
+ version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
+ create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
+ update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
+ del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB COMMENT = '娴嬭瘯鍗曡〃';
DROP TABLE if EXISTS test_tree;
CREATE TABLE test_tree
(
- id int(0) NOT NULL AUTO_INCREMENT 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 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',
tree_name varchar(255) NULL DEFAULT NULL COMMENT '鍊�',
- version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
- create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
- create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
- update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
- update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
- del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
+ version int(0) NULL DEFAULT 0 COMMENT '鐗堟湰',
+ create_time datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ create_by varchar(64) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
+ update_time datetime(0) NULL DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+ update_by varchar(64) NULL DEFAULT NULL COMMENT '鏇存柊浜�',
+ del_flag int(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囧織',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB COMMENT = '娴嬭瘯鏍戣〃';
--
Gitblit v1.9.3