From 7c0f41c785ef1ae7b121cf7c6127e7566da866a5 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期五, 11 三月 2022 13:00:09 +0800
Subject: [PATCH] update 确保更好的适配 多数据库 主键策略统一改为 雪花ID
---
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