From 31bfaa54f63b023ac6c4c26d0718c7bdf4276b8f Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 19 十月 2022 10:38:48 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 30 +++++++++++++++---------------
1 files changed, 15 insertions(+), 15 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 3bfa8e3..392227e 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -548,13 +548,13 @@
create_time timestamp(6) without time zone default now(),
update_user integer,
update_time timestamp(6) without time zone,
- geo geometry default null,
- CONSTRAINT enforce_dims_geom CHECK (st_ndims(geo) = 2),
- CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geo) = 'POLYGON'::text OR geo IS NULL),
- CONSTRAINT enforce_srid_geom CHECK (st_srid(geo) = 4490)
+ geom geometry default null,
+ CONSTRAINT enforce_dims_geom CHECK (st_ndims(geom) = 2),
+ CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POLYGON'::text OR geom IS NULL),
+ CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 4490)
);
--- drop index index_sys_meta_geo;
-create index index_sys_meta_geo on lf.sys_meta using GIST (geo);
+-- 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.name is '鍚嶇О';
@@ -572,10 +572,10 @@
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.geo is '绌洪棿浣嶇疆';
--- insert into lf.sys_meta(dirid,depid,name,geo,sizes) values (1,1,'Test',ST_PolygonFromText('POLYGON ((100 0,120 0,120 20,100 20,100 0))',4490),0.001);
+comment on column lf.sys_meta.geom is '绌洪棿浣嶇疆';
+-- 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(geo) from lf.sys_meta;
+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(
@@ -761,13 +761,13 @@
create_time timestamp(6) without time zone default now(),
download_user integer,
download_time timestamp(6) without time zone,
- geo geometry default null,
+ geom geometry default null,
bak varchar(1024)
- CONSTRAINT enforce_dims_geom CHECK (st_ndims(geo) = 2),
- CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geo) = 'POLYGON'::text OR geo IS NULL),
- CONSTRAINT enforce_srid_geom CHECK (st_srid(geo) = 4490)
+ CONSTRAINT enforce_dims_geom CHECK (st_ndims(geom) = 2),
+ CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) = 'POLYGON'::text OR geom IS NULL),
+ CONSTRAINT enforce_srid_geom CHECK (st_srid(geom) = 4490)
);
-create index index_sys_download_geo on lf.sys_download using gist (geo);
+create index index_sys_download_geom on lf.sys_download using gist (geom);
comment on table lf.sys_download is '涓嬭浇璁板綍琛�';
comment on column lf.sys_download.id is '涓婚敭ID';
comment on column lf.sys_download.name is '鍚嶇О';
@@ -783,7 +783,7 @@
comment on column lf.sys_download.download_user is '涓嬭浇浜篒D';
comment on column lf.sys_download.download_time is '涓嬭浇鏃堕棿';
comment on column lf.sys_download.bak is '澶囨敞';
-comment on column lf.sys_download.geo is '绌洪棿浣嶇疆';
+comment on column lf.sys_download.geom is '绌洪棿浣嶇疆';
-- insert into lf.sys_download (name,pwd,url,descr) values ('2022-09-27','123456','','娴嬭瘯涓嬭浇');
select * from lf.sys_download;
--
Gitblit v1.9.3