From a5525cba9bfea2bc95f542fdd7519b8f94344555 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 27 十月 2022 18:34:01 +0800
Subject: [PATCH] 1
---
data/db_tab.sql | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/data/db_tab.sql b/data/db_tab.sql
index 1dea35d..8a0f2b1 100644
--- a/data/db_tab.sql
+++ b/data/db_tab.sql
@@ -885,4 +885,25 @@
insert into lf.sys_blacklist (ip,type) values ('127.0.0.1',2); */
select * from lf.sys_blacklist;
+----------------------------------------------------------------------------------------------------- 26.鏍囩粯琛�
+-- DROP TABLE IF EXISTS lf.sys_mark;
+create table lf.sys_mark(
+ id serial primary key,
+ name varchar(50),
+ wkt text,
+ create_user integer default 1,
+ create_time timestamp(6) without time zone default now(),
+ update_user integer,
+ update_time timestamp(6) without time zone
+);
+comment on table lf.sys_mark is '鏍囩粯琛�';
+comment on column lf.sys_mark.id is '涓婚敭ID';
+comment on column lf.sys_mark.name is '鍚嶇О';
+comment on column lf.sys_mark.wkt is 'WKT';
+comment on column lf.sys_mark.create_user is '鍒涘缓浜篒D';
+comment on column lf.sys_mark.create_time is '鍒涘缓鏃堕棿';
+comment on column lf.sys_mark.update_user is '鏇存柊浜篒D';
+comment on column lf.sys_mark.update_time is '鏇存柊鏃堕棿';
+
+select * from lf.sys_mark;
-----------------------------------------------------------------------------------------------------
--
Gitblit v1.9.3