From ddc43b3057ba8f2d20f5b1e627c5e03f871371b5 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期一, 07 八月 2023 17:23:13 +0800 Subject: [PATCH] update 优化 删除字典无用状态字段(基本用不上 禁用后还会导致回显问题) --- script/sql/test.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/script/sql/test.sql b/script/sql/test.sql index 59257f0..d4cea05 100644 --- a/script/sql/test.sql +++ b/script/sql/test.sql @@ -2,7 +2,7 @@ CREATE TABLE test_demo ( id bigint(0) NOT NULL COMMENT '涓婚敭', - tenant_id varchar(20) NOT NULL COMMENT '绉熸埛缂栧彿', + tenant_id varchar(20) NULL DEFAULT '000000' COMMENT '绉熸埛缂栧彿', dept_id bigint(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id', user_id bigint(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛id', order_num int(0) NULL DEFAULT 0 COMMENT '鎺掑簭鍙�', @@ -22,7 +22,7 @@ CREATE TABLE test_tree ( id bigint(0) NOT NULL COMMENT '涓婚敭', - tenant_id varchar(20) NOT NULL COMMENT '绉熸埛缂栧彿', + tenant_id varchar(20) NULL DEFAULT '000000' COMMENT '绉熸埛缂栧彿', parent_id bigint(0) NULL DEFAULT 0 COMMENT '鐖秈d', dept_id bigint(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id', user_id bigint(0) NULL DEFAULT NULL COMMENT '鐢ㄦ埛id', -- Gitblit v1.9.3