From cf547f4d9c56cf2d86ae60132aa7496bee93bf9c Mon Sep 17 00:00:00 2001 From: xing <xingjs@qq.com> Date: 星期二, 21 二月 2023 17:12:12 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- data/db_tab.sql | 4 +++- 1 files changed, 3 insertions(+), 1 deletions(-) diff --git a/data/db_tab.sql b/data/db_tab.sql index 17d9282..a447cc4 100644 --- a/data/db_tab.sql +++ b/data/db_tab.sql @@ -552,6 +552,7 @@ id serial primary key, eventid varchar(38) default new_guid(), metaid integer default 0, + ismeta smallint default 0, dirid integer default 0, depid integer default 0, depcode varchar(24) default '00', @@ -578,6 +579,7 @@ comment on column lf.sys_meta.id is '涓婚敭ID'; comment on column lf.sys_meta.eventid is 'GUID'; comment on column lf.sys_meta.metaid is '鐖舵簮鏁版嵁ID锛�0-娌℃湁'; +comment on column lf.sys_meta.ismeta is '鏄惁涓哄厓鏁版嵁'; comment on column lf.sys_meta.dirid is '鐩綍ID'; comment on column lf.sys_meta.depid is '鍗曚綅ID'; comment on column lf.sys_meta.depcode is '鐩綍缂栫爜'; @@ -596,7 +598,7 @@ comment on column lf.sys_meta.update_user is '鏇存柊浜篒D'; comment on column lf.sys_meta.update_time is '鏇存柊鏃堕棿'; comment on column lf.sys_meta.bak is '澶囨敞'; -comment on column lf.sys_meta.geom is '绌洪棿浣嶇疆'; +comment on column lf.sys_meta.geom is '绌洪棿浣嶇疆 -- insert into lf.sys_meta(dirid,depid,geom,sizes,name,path) values (1,1,ST_PolygonFromText('MultiPolygon (((100 0,120 0,120 20,100 20,100 0)))', 4490),0.001,'a.jpg','c:\a.jpg'); select a.*,st_astext(geom) from lf.sys_meta a; select id,name,dirid,depid,verid,type,sizes,create_user,create_time,update_user,update_time,st_astext(geom) from lf.sys_meta; -- Gitblit v1.9.3