From de5c10c0c692dc3cad552821ca78f7ddb4074491 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期二, 28 二月 2023 16:41:56 +0800 Subject: [PATCH] 1 --- data/db_tab.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) diff --git a/data/db_tab.sql b/data/db_tab.sql index 42972da..d20b3ce 100644 --- a/data/db_tab.sql +++ b/data/db_tab.sql @@ -679,7 +679,7 @@ tabletype varchar(20), unit varchar(50), domain_na varchar(100), - showtype smallint, + showtype smallint default 0, editable smallint, status smallint default 0, bak varchar(1024) @@ -706,6 +706,7 @@ comment on column lf.sys_dict.editable is '鏄惁鍙紪杈�'; comment on column lf.sys_dict.status is '鐘舵�侊細0-姝e父锛�1-鍒犻櫎锛�-1-搴熷純'; comment on column lf.sys_dict.bak is '澶囨敞'; +-- alter table lf.sys_dict alter column showtype set default 0; -- alter sequence lf.sys_dict_id_seq restart with 300; select count(*) from lf.sys_dict where status=0 and tab='sys_user'; -- Gitblit v1.9.3