From 3372ad6e59c7da5abf28e65447c7b428e5793326 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 07 一月 2023 09:54:30 +0800
Subject: [PATCH] 1.7
---
data/db_tab.sql | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 08f23f2..eedc3ce 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1100,7 +1100,7 @@
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 (
+create table lf.sys_meta_new (
id serial primary key,
eventid varchar(38) default new_guid(),
metaid integer default 0,
@@ -1124,7 +1124,7 @@
geom geometry(MultiPolygon, 4490)
);
-- drop index index_sys_meta_geom;
-create index index_sys_meta_geom on lf.sys_meta using GIST (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';
@@ -1149,7 +1149,7 @@
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 * from lf.sys_meta; select a.*,st_astext(geom) from lf.sys_meta a;
+select * from lf.sys_meta_new; 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