From 24e92a5d5b068f24efa6c8cb2f06a50480185b5f Mon Sep 17 00:00:00 2001
From: wuww <252740454@qq.com>
Date: 星期三, 16 四月 2025 16:56:15 +0800
Subject: [PATCH] 添加SimuData类
---
data/init.sql | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/data/init.sql b/data/init.sql
index be5e868..49e71de 100644
--- a/data/init.sql
+++ b/data/init.sql
@@ -12,6 +12,7 @@
service_name varchar(200),
type smallint default 1,
area_type smallint default 0,
+ area_name varchar(200),
data varchar(8000),
status smallint default 0,
result varchar(8000),
@@ -31,6 +32,7 @@
comment on column nsl.simu.service_name is '鏈嶅姟鍚嶇О';
comment on column nsl.simu.type is '绫诲埆锛�1-棰勬祴妯℃嫙锛�2-瀹炴椂妯℃嫙锛�3-鍘嗗彶妯℃嫙';
comment on column nsl.simu.area_type is '鍖哄煙绫诲埆锛�0-鑷畾涔夛紝1-琛屾斂鍖哄垝锛�2-閲嶇偣鍖哄煙锛�3-閲嶇偣娌�';
+comment on column nsl.simu.area_name is '鍖哄煙鍚嶇О';
comment on column nsl.simu.data is '鏁版嵁(JSON)';
comment on column nsl.simu.status is '鐘舵�侊細0-鍒涘缓浠跨湡锛�1-棰勫鐞嗭紝2-鍒嗘瀽涓紝10-瀹屾垚锛�20-鍑洪敊';
comment on column nsl.simu.result is '缁撴灉(JSON)';
@@ -41,7 +43,7 @@
comment on column nsl.simu.bak is '澶囨敞';
comment on column nsl.simu.geom is '绌洪棿浣嶇疆';
--- insert into nsl.simu (name, service_name, type, area_type, status, geom) values ('棰勬祴妯℃嫙-0416', '20250416100000', 1, 1, 0, ST_GeomFromText('MULTIPOLYGON(((116.666748 39.639859,116.659403 39.626287,116.665956 39.654698,116.666748 39.639859)))'));
+-- insert into nsl.simu (name, service_name, type, area_type, area_name, status, geom) values ('棰勬祴妯℃嫙-0416', '20250416100000', 1, 1, '澶у叴鍖�', 0, ST_GeomFromText('MULTIPOLYGON(((116.666748 39.639859,116.659403 39.626287,116.665956 39.654698,116.666748 39.639859)))'));
select *, st_astext(geom) geom from nsl.simu;
---------------------------------------------- 2.鎺ㄦ紨鍖哄煙
--
Gitblit v1.9.3