From 57c63c7af9bcff4d38da1bf247ec0eac21887c48 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 09 一月 2023 16:11:13 +0800
Subject: [PATCH] 5
---
data/db_tab.sql | 117 +++++++++++++++++++++-------------------------------------
1 files changed, 42 insertions(+), 75 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index defbdbe..f342317 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -593,36 +593,56 @@
-- insert into lf.sys_meta(dirid,depid,name,geom,sizes) values (1,1,'Test',ST_PolygonFromText('POLYGON ((100 0,120 0,120 20,100 20,100 0))',4490),0.001);
select * from lf.sys_meta; select id,name,dirid,depid,verid,type,sizes,descr,create_user,create_time,update_user,update_time,st_astext(geom) from lf.sys_meta;
------------------------------------------------------------------------------------------------------ 17.鍏冩暟鎹枃浠惰〃
--- DROP TABLE IF EXISTS lf.sys_meta_file;
-create table lf.sys_meta_file(
+
+----------------------------------------------------------------------------------------------------- 16.鍏冩暟鎹〃-New
+-- DROP TABLE IF EXISTS lf.sys_meta; DROP TABLE IF EXISTS lf.sys_meta_file;
+create table lf.sys_meta_new (
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),
- metaid integer,
- fileid integer default 0,
- guid varchar(40) default new_guid(),
+ type varchar(100),
+ guid varchar(38) default new_guid(),
path varchar(512),
- sizes float default 0,
+ sizes float8 default 0,
+ tab varchar(50),
+ rows 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
+ update_time timestamp(6) without time zone,
+ bak varchar(1024),
+ geom geometry(MultiPolygon, 4490)
);
-comment on table lf.sys_meta_file is '鍏冩暟鎹枃浠惰〃';
-comment on column lf.sys_meta_file.id is '涓婚敭ID';
-comment on column lf.sys_meta_file.name is '鏂囦欢鍚�';
-comment on column lf.sys_meta_file.metaid is '鍏冩暟鎹甀D';
-comment on column lf.sys_meta_file.fileid is '鐖舵枃浠禝D锛�0-娌℃湁';
-comment on column lf.sys_meta_file.guid is '鏂囦欢ID';
-comment on column lf.sys_meta_file.path is '瀛樺偍璺緞';
-comment on column lf.sys_meta_file.sizes is '鏂囦欢澶у皬锛氬崟浣峂B';
-comment on column lf.sys_meta_file.create_user is '鍒涘缓浜篒D';
-comment on column lf.sys_meta_file.create_time is '鍒涘缓鏃堕棿';
-comment on column lf.sys_meta_file.update_user is '鏇存柊浜篒D';
-comment on column lf.sys_meta_file.update_time is '鏇存柊鏃堕棿';
--- insert into lf.sys_meta_file (metaid,name,path) values (1,'a.jpg','c:\a.jpg');
+-- drop index index_sys_meta_geom;
+create index index_sys_meta_geom on lf.sys_meta_new 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.tab is '琛ㄥ悕';
+comment on column lf.sys_meta.rows 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');
+-- alter table lf.sys_meta rename column bstab to tab; alter table lf.sys_meta drop column mdtab;
-select * from lf.sys_meta_file;
+select * from lf.sys_meta; select a.*,st_astext(geom) from lf.sys_meta a;
----------------------------------------------------------------------------------------------------- 18.闄勪欢琛�
-- DROP TABLE IF EXISTS lf.sys_attach;
create table lf.sys_attach(
@@ -1098,59 +1118,6 @@
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_new (
- 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_new 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');
--- 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,
--
Gitblit v1.9.3