From 8ce7ef517c2913483eee7a09fd19e98cfd37b6e8 Mon Sep 17 00:00:00 2001
From: Abyss777 <abyss@fox5.ru>
Date: Tue, 26 Jul 2016 15:22:03 +0500
Subject: Do not store device status in database

---
 debug.xml                 | 2 +-
 schema/changelog-3.7.xml  | 2 ++
 setup/unix/traccar.xml    | 2 +-
 setup/windows/traccar.xml | 2 +-
 4 files changed, 5 insertions(+), 3 deletions(-)

diff --git a/debug.xml b/debug.xml
index bd55b7ee1..c08d46531 100644
--- a/debug.xml
+++ b/debug.xml
@@ -171,7 +171,7 @@
     </entry>
 
     <entry key='database.updateDeviceStatus'>
-        UPDATE devices SET status = :status, lastUpdate = :lastUpdate WHERE id = :id;
+        UPDATE devices SET lastUpdate = :lastUpdate WHERE id = :id;
     </entry>
 
     <entry key='database.deleteDevice'>
diff --git a/schema/changelog-3.7.xml b/schema/changelog-3.7.xml
index ae85f69f3..d82dbe91b 100644
--- a/schema/changelog-3.7.xml
+++ b/schema/changelog-3.7.xml
@@ -26,6 +26,8 @@
 
     <dropColumn tableName="devices" columnName="motion" />
 
+    <dropColumn tableName="devices" columnName="status" />
+
     <addColumn tableName="groups">
       <column name="attributes" type="VARCHAR(4096)" />
     </addColumn>
diff --git a/setup/unix/traccar.xml b/setup/unix/traccar.xml
index 186e981cb..da09d74d6 100644
--- a/setup/unix/traccar.xml
+++ b/setup/unix/traccar.xml
@@ -120,7 +120,7 @@
     </entry>
 
     <entry key='database.updateDeviceStatus'>
-        UPDATE devices SET status = :status, lastUpdate = :lastUpdate WHERE id = :id;
+        UPDATE devices SET lastUpdate = :lastUpdate WHERE id = :id;
     </entry>
 
     <entry key='database.deleteDevice'>
diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml
index aa3809763..a3971e4f8 100644
--- a/setup/windows/traccar.xml
+++ b/setup/windows/traccar.xml
@@ -120,7 +120,7 @@
     </entry>
 
     <entry key='database.updateDeviceStatus'>
-        UPDATE devices SET status = :status, lastUpdate = :lastUpdate WHERE id = :id;
+        UPDATE devices SET lastUpdate = :lastUpdate WHERE id = :id;
     </entry>
 
     <entry key='database.deleteDevice'>
-- 
cgit v1.2.3