From eb1af5f77f2c16e580173553e548ff4e41653e4e Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 02 十一月 2022 17:02:13 +0800
Subject: [PATCH] 1

---
 data/db_tab.sql |   11 +++++++++++
 1 files changed, 11 insertions(+), 0 deletions(-)

diff --git a/data/db_tab.sql b/data/db_tab.sql
index 8a0f2b1..dab4081 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -686,6 +686,11 @@
   create_time timestamp(6) without time zone default now(),
   update_user integer,
   update_time timestamp(6) without time zone,
+  tabletype varchar(20),
+  unit varchar(50),
+  domain_na varchar(100),
+  showtype smallint,
+  editable smallint,	
   bak varchar(1024) 
 );
 comment on table lf.sys_dict is '闄勪欢琛�';
@@ -703,6 +708,11 @@
 comment on column lf.sys_dict.create_time is '鍒涘缓鏃堕棿';
 comment on column lf.sys_dict.update_user is '鏇存柊浜篒D';
 comment on column lf.sys_dict.update_time is '鏇存柊鏃堕棿';
+comment on column lf.sys_dict.tabletype is '琛ㄧ被鍨�';
+comment on column lf.sys_dict.unit is '鍗曚綅';
+comment on column lf.sys_dict.domain_na is '鍊煎煙鍚嶇О';
+comment on column lf.sys_dict.showtype is '鏄剧ず绫诲瀷';
+comment on column lf.sys_dict.editable is '鏄惁鍙紪杈�';
 comment on column lf.sys_dict.bak is '澶囨敞';
 /* alter sequence lf.sys_dict_id_seq restart with 300;
 update lf.sys_dict set create_user=1,create_time=now() where 1=1;
@@ -710,6 +720,7 @@
 
 select count(*) from lf.sys_dict where tab='sys_user';
 select * from lf.sys_dict order by ns,tab,order_num limit 10 offset 0;
+select distinct ns,fn_get_entity(tab) tab,tab_desc,tabletype from lf.sys_dict order by tab;
 ----------------------------------------------------------------------------------------------------- 21.鏍峰紡琛�
 -- DROP TABLE IF EXISTS lf.sys_style;
 create table lf.sys_style(

--
Gitblit v1.9.3