From ff912b5a2abd0016cc8afca66cb64d0a0190364d Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 09 一月 2023 09:51:39 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index eedc3ce..defbdbe 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1148,8 +1148,29 @@
comment on column lf.sys_meta.bak 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');
+-- create table lf.sys_meta as select * from lf.sys_meta_new;
select * from lf.sys_meta_new; select a.*,st_astext(geom) from lf.sys_meta a;
+----------------------------------------------------------------------------------------------------- 32.FME鏃ュ織琛�
+create table lf.sys_fme_log (
+ id serial primary key,
+ parentid varchar(38),
+ dirpath varchar(1024),
+ pg_ns varchar(10),
+ tcmc varchar(150),
+ tcdm varchar(50),
+ count integer default 0
+);
+comment on table lf.sys_fme_log is 'FME鏃ュ織琛�';
+comment on column lf.sys_fme_log.id is '涓婚敭ID';
+comment on column lf.sys_fme_log.parentid is '鐖惰〃GUID';
+comment on column lf.sys_fme_log.dirpath is '鏂囦欢璺緞';
+comment on column lf.sys_fme_log.pg_ns is '琛ㄦ灦鏋�';
+comment on column lf.sys_fme_log.tcmc is '鍥惧眰鍚嶇О';
+comment on column lf.sys_fme_log.tcdm is '琛ㄥ悕';
+comment on column lf.sys_fme_log.count is '琛屾暟';
+
+select * from lf.sys_fme_log;
----------------------------------------------------------------------------------------------------- 鍏冩暟鎹祴璇曡〃 *
-- drop table if exists md.md_zxcg;
create table md.md_zxcg(
--
Gitblit v1.9.3