From a458c7056dabb98f8d594cb27d30a3b4d122e85d Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 14 三月 2024 17:28:10 +0800
Subject: [PATCH] update 优化 !pr493 代码结构与问题修复

---
 script/sql/postgres/postgres_test.sql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/script/sql/postgres/postgres_test.sql b/script/sql/postgres/postgres_test.sql
index 0a7d3ff..179096b 100644
--- a/script/sql/postgres/postgres_test.sql
+++ b/script/sql/postgres/postgres_test.sql
@@ -2,7 +2,7 @@
 create table if not exists test_demo
 (
     id          int8,
-    tenant_id   varchar(20)     not null,
+    tenant_id   varchar(20)     default '000000',
     dept_id     int8,
     user_id     int8,
     order_num   int4            default 0,
@@ -37,7 +37,7 @@
 create table if not exists test_tree
 (
     id          int8,
-    tenant_id   varchar(20)     not null,
+    tenant_id   varchar(20)     default '000000',
     parent_id   int8            default 0,
     dept_id     int8,
     user_id     int8,

--
Gitblit v1.9.3