From ec4a6960e2a8347b4860aeab4fbf641c8640c633 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 23 三月 2023 11:20:15 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index e18d3ba..7ba6609 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -1250,6 +1250,7 @@
-- drop table if exists lf.sys_publish;
create table lf.sys_publish(
id serial primary key,
+ regid varchar(40),
name varchar(50),
url varchar(512),
path varchar(200),
@@ -1271,6 +1272,7 @@
create index idx_sys_publish_geom on lf.sys_publish using gist (geom);
comment on table lf.sys_publish is '鏁版嵁鍙戝竷琛�';
comment on column lf.sys_publish.id is '涓婚敭ID';
+comment on column lf.sys_publish.regid is '娉ㄥ唽ID';
comment on column lf.sys_publish.name is '鍚嶇О';
comment on column lf.sys_publish.url is '鍦板潃';
comment on column lf.sys_publish.path is '璺緞';
@@ -1286,6 +1288,7 @@
comment on column lf.sys_publish.update_user is '鏇存柊浜篒D';
comment on column lf.sys_publish.update_time is '鏇存柊鏃堕棿';
comment on column lf.sys_publish.bak is '澶囨敞';
+-- alter table lf.sys_publish add column regid varchar(40);
-- insert into lf.sys_publish (name,geom) values ('Test',ST_GeomFromText('POINT Z (101.9281 36.58675 2199.5)'));
select st_astext(geom) "wkt",a.* from lf.sys_publish a;
--
Gitblit v1.9.3