From e5f61db766b3eaa28506835e3581cbd2fdc8533d Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 05 一月 2023 17:49:31 +0800
Subject: [PATCH] 1.5
---
data/db_tab.sql | 52 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 52 insertions(+), 0 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index eb37816..d492166 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1098,6 +1098,58 @@
comment on column lf.sys_flow.update_time is '鏇存柊鏃堕棿';
select * from lf.sys_flow;
+----------------------------------------------------------------------------------------------------- 16.鍏冩暟鎹〃-New
+-- DROP TABLE IF EXISTS lf.sys_meta; DROP TABLE IF EXISTS lf.sys_meta_file;
+create table lf.sys_meta (
+ id serial primary key,
+ eventid varchar(38) default new_guid(),
+ metaid integer default 0,
+ dirid integer default 0,
+ depid integer default 0,
+ verid integer default 0,
+ name varchar(256),
+ type varchar(100),
+ guid varchar(38) default new_guid(),
+ path varchar(512),
+ sizes float8 default 0,
+ bstab varchar(50),
+ bsrows integer default 0,
+ mdtab varchar(50),
+ mdrows integer default 0,
+ create_user integer default 1,
+ create_time timestamp(6) without time zone default now(),
+ update_user integer,
+ update_time timestamp(6) without time zone,
+ bak varchar(1024),
+ geom geometry(MultiPolygon, 4490)
+);
+-- drop index index_sys_meta_geom;
+create index index_sys_meta_geom on lf.sys_meta using GIST (geom);
+comment on table lf.sys_meta is '鍏冩暟鎹〃';
+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.dirid is '鐩綍ID';
+comment on column lf.sys_meta.depid is '鍗曚綅ID';
+comment on column lf.sys_meta.verid is '鐗堟湰ID';
+comment on column lf.sys_meta.name is '鍚嶇О';
+comment on column lf.sys_meta.type is '绫诲瀷:file-鏂囦欢锛宻hp-ShapeFile锛実db-GDB锛寊ip-鍘嬬缉鍖�';
+comment on column lf.sys_meta.guid is '鏂囦欢GUID';
+comment on column lf.sys_meta.path is '瀛樺偍璺緞';
+comment on column lf.sys_meta.sizes is '澶у皬锛氬崟浣峂B';
+comment on column lf.sys_meta.bstab is '涓氬姟琛ㄥ悕';
+comment on column lf.sys_meta.bsrows is '涓氬姟琛ㄨ鏁�';
+comment on column lf.sys_meta.mdtab is '鍏冩暟鎹〃鍚�';
+comment on column lf.sys_meta.mdrows is '鍏冩暟鎹鏁�';
+comment on column lf.sys_meta.create_user is '鍒涘缓浜篒D';
+comment on column lf.sys_meta.create_time is '鍒涘缓鏃堕棿';
+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 '绌洪棿浣嶇疆';
+-- 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;
----------------------------------------------------------------------------------------------------- 鍏冩暟鎹祴璇曡〃 *
-- drop table if exists md.md_zxcg;
create table md.md_zxcg(
--
Gitblit v1.9.3