aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2016-07-26 15:22:03 +0500
committerAbyss777 <abyss@fox5.ru>2016-07-26 15:22:03 +0500
commit8ce7ef517c2913483eee7a09fd19e98cfd37b6e8 (patch)
treec6c879b5889a18e0cd0086cd748c44281cede3fb
parent60c442ac19776f0e07fafd1db8a0b75f971fd40e (diff)
downloadtrackermap-server-8ce7ef517c2913483eee7a09fd19e98cfd37b6e8.tar.gz
trackermap-server-8ce7ef517c2913483eee7a09fd19e98cfd37b6e8.tar.bz2
trackermap-server-8ce7ef517c2913483eee7a09fd19e98cfd37b6e8.zip
Do not store device status in database
-rw-r--r--debug.xml2
-rw-r--r--schema/changelog-3.7.xml2
-rw-r--r--setup/unix/traccar.xml2
-rw-r--r--setup/windows/traccar.xml2
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'>