From 96d2a27d41784215799f22ff66743e6d8f1d2e38 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期二, 20 六月 2023 14:25:01 +0800
Subject: [PATCH] 添加sql字段
---
sql/2.6.8升级2.6.9.sql | 4 ++++
sql/初始化.sql | 1 +
2 files changed, 5 insertions(+), 0 deletions(-)
diff --git "a/sql/2.6.8\345\215\207\347\272\2472.6.9.sql" "b/sql/2.6.8\345\215\207\347\272\2472.6.9.sql"
index 3734bcd..e633d63 100644
--- "a/sql/2.6.8\345\215\207\347\272\2472.6.9.sql"
+++ "b/sql/2.6.8\345\215\207\347\272\2472.6.9.sql"
@@ -58,6 +58,10 @@
alter table device
change online on_line varchar(50) null;
+alter table device
+ add COLUMN switch_primary_sub_stream bool default false comment '寮�鍚富瀛愮爜娴佸垏鎹㈢殑寮�鍏筹紙0-涓嶅紑鍚紝1-寮�鍚級鐜板湪宸茬煡鏀寔璁惧涓� 澶у崕銆乀P鈥斺�擫INK鍏ㄧ郴璁惧'
+
+
alter table device_alarm
change deviceId device_id varchar(50) not null;
diff --git "a/sql/\345\210\235\345\247\213\345\214\226.sql" "b/sql/\345\210\235\345\247\213\345\214\226.sql"
index d61c47c..3eed0dd 100644
--- "a/sql/\345\210\235\345\247\213\345\214\226.sql"
+++ "b/sql/\345\210\235\345\247\213\345\214\226.sql"
@@ -31,6 +31,7 @@
password character varying(255),
as_message_channel bool default false,
keepalive_interval_time integer,
+ switch_primary_sub_stream bool default false,
constraint uk_device_device unique (device_id)
);
--
Gitblit v1.8.0