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