diff options
| author | Abyss777 <abyss@fox5.ru> | 2016-07-26 15:22:03 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2016-07-26 15:22:03 +0500 |
| commit | 8ce7ef517c2913483eee7a09fd19e98cfd37b6e8 (patch) | |
| tree | c6c879b5889a18e0cd0086cd748c44281cede3fb | |
| parent | 60c442ac19776f0e07fafd1db8a0b75f971fd40e (diff) | |
| download | trackermap-server-8ce7ef517c2913483eee7a09fd19e98cfd37b6e8.tar.gz trackermap-server-8ce7ef517c2913483eee7a09fd19e98cfd37b6e8.tar.bz2 trackermap-server-8ce7ef517c2913483eee7a09fd19e98cfd37b6e8.zip | |
Do not store device status in database
| -rw-r--r-- | debug.xml | 2 | ||||
| -rw-r--r-- | schema/changelog-3.7.xml | 2 | ||||
| -rw-r--r-- | setup/unix/traccar.xml | 2 | ||||
| -rw-r--r-- | setup/windows/traccar.xml | 2 |
4 files changed, 5 insertions, 3 deletions
@@ -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'>
|