From ade1aadab51ad5d46292267ff4e59809526908cc Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 20 十一月 2022 16:04:53 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 20 ++++++++++----------
1 files changed, 10 insertions(+), 10 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 5393048..cd31a10 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -967,18 +967,18 @@
x float8,
y float8,
z float8,
- create_user integer,
- create_time timestamp(6) without time zone default now(),
- update_user integer,
- update_time timestamp(6) without time zone,
+ createuser integer,
+ createtime timestamp(6) without time zone default now(),
+ updateuser integer,
+ updatetime timestamp(6) without time zone,
geom geometry(Point, 4490)
);
create index if not exists md_zxcg_geom_idx on md.md_zxcg using gist (geom);
-drop index if exists md_zxcg_geom_idx cascade;
+/*drop index if exists md_zxcg_geom_idx cascade;
comment on table md.md_zxcg is '涓嚎鎴愭灉琛�';
vacuum analyze md.md_zxcg;
insert into md.md_zxcg (zh, geom) values ('A01', ST_GeomFromText('POINT(95.80461853400004 34.13862467200005)'));
-insert into md.md_zxcg (zh, geom) values ('A02', ST_GeomFromText('POINT(119.873000 39.392000)'));
+insert into md.md_zxcg (zh, geom) values ('A02', ST_GeomFromText('POINT(119.873000 39.392000)'));*/
select gid,zh,ST_ASText(geom) from md.md_zxcg;
select * from md.md_zxcg;
@@ -1004,10 +1004,10 @@
gkpl varchar(100),
dldy varchar(100),
bz varchar(100),
- create_user integer,
- create_time timestamp(6) without time zone default now(),
- update_user integer,
- update_time timestamp(6) without time zone
+ createuser integer,
+ createtime timestamp(6) without time zone default now(),
+ updateuser integer,
+ updatetime timestamp(6) without time zone
);
comment on table md.md_gdcg is '绠￠亾鎴愭灉琛�';
--
Gitblit v1.9.3