From afabff8dba6a31923696fe9f7af87755b30830f2 Mon Sep 17 00:00:00 2001
From: VVT789 <sdxt_0802@163.com>
Date: 星期二, 18 三月 2025 10:50:52 +0800
Subject: [PATCH] update sql
---
sql/postgre.sql | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/sql/postgre.sql b/sql/postgre.sql
index 81bc1c8..30cb760 100644
--- a/sql/postgre.sql
+++ b/sql/postgre.sql
@@ -581,6 +581,7 @@
"id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
"code" varchar(20) COLLATE "pg_catalog"."default",
"name" varchar(20) COLLATE "pg_catalog"."default",
+ "gateway_key" varchar(255) COLLATE "pg_catalog"."default",
"device_type" varchar(10) COLLATE "pg_catalog"."default",
"unit" varchar(10) COLLATE "pg_catalog"."default",
"create_by" varchar(64) COLLATE "pg_catalog"."default",
@@ -594,6 +595,7 @@
COMMENT ON COLUMN "daq_template"."id" IS '涓婚敭';
COMMENT ON COLUMN "daq_template"."code" IS '鍙傛暟缂栫爜';
COMMENT ON COLUMN "daq_template"."name" IS '鍙傛暟鍚嶇О';
+COMMENT ON COLUMN "daq_template"."gateway_key" IS '閲囬泦缂栫爜';
COMMENT ON COLUMN "daq_template"."device_type" IS '鍙傛暟鎵�灞炵被鍨�';
COMMENT ON COLUMN "daq_template"."unit" IS '鍗曚綅';
COMMENT ON COLUMN "daq_template"."create_by" IS '鍒涘缓鑰�';
@@ -2232,6 +2234,7 @@
"update_time" timestamp(6)
)
;
+INSERT INTO "public"."sys_dept" ("dept_id", "parent_id", "ancestors", "dept_name", "order_num", "leader", "phone", "email", "status", "del_flag", "create_by", "create_time", "update_by", "update_time") VALUES (1, 0, NULL, '鏅虹⒊鏈潵绉戞妧鏈夐檺鍏徃', 1, NULL, NULL, NULL, '0', 0, 'admin', '2025-03-17 13:09:00', NULL, NULL);
ALTER TABLE "sys_dept" OWNER TO "postgres";
COMMENT ON COLUMN "sys_dept"."dept_id" IS '閮ㄩ棬id';
COMMENT ON COLUMN "sys_dept"."parent_id" IS '鐖堕儴闂╥d';
--
Gitblit v1.9.3