From 4414e093d708159d2016ae0fe54087e9fd3cb9d1 Mon Sep 17 00:00:00 2001
From: Abyss777 <abyss@fox5.ru>
Date: Wed, 13 Jul 2016 11:38:53 +0500
Subject: Fix user attributes saving

---
 debug.xml                 | 7 ++++---
 setup/unix/traccar.xml    | 7 ++++---
 setup/windows/traccar.xml | 7 ++++---
 3 files changed, 12 insertions(+), 9 deletions(-)

diff --git a/debug.xml b/debug.xml
index 227ba7b73..02c2ec808 100644
--- a/debug.xml
+++ b/debug.xml
@@ -112,8 +112,8 @@
     </entry>
 
     <entry key='database.insertUser'>
-        INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat)
-        VALUES (:name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat);
+        INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, attributes)
+        VALUES (:name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat, :attributes);
     </entry>
 
     <entry key='database.updateUser'>
@@ -127,7 +127,8 @@
         latitude = :latitude,
         longitude = :longitude,
         zoom = :zoom,
-        twelveHourFormat = :twelveHourFormat
+        twelveHourFormat = :twelveHourFormat,
+        attributes = :attributes
         WHERE id = :id;
     </entry>
 
diff --git a/setup/unix/traccar.xml b/setup/unix/traccar.xml
index 767d53d8b..83abb48fd 100644
--- a/setup/unix/traccar.xml
+++ b/setup/unix/traccar.xml
@@ -70,8 +70,8 @@
     </entry>
 
     <entry key='database.insertUser'>
-        INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat)
-        VALUES (:name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat);
+        INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, attributes)
+        VALUES (:name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat, :attributes);
     </entry>
 
     <entry key='database.updateUser'>
@@ -85,7 +85,8 @@
         latitude = :latitude,
         longitude = :longitude,
         zoom = :zoom,
-        twelveHourFormat = :twelveHourFormat
+        twelveHourFormat = :twelveHourFormat,
+        attributes = :attributes
         WHERE id = :id;
     </entry>
 
diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml
index 8499bda67..72f04d0a0 100644
--- a/setup/windows/traccar.xml
+++ b/setup/windows/traccar.xml
@@ -70,8 +70,8 @@
     </entry>
 
     <entry key='database.insertUser'>
-        INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat)
-        VALUES (:name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat);
+        INSERT INTO users (name, email, hashedPassword, salt, admin, map, distanceUnit, speedUnit, latitude, longitude, zoom, twelveHourFormat, attributes)
+        VALUES (:name, :email, :hashedPassword, :salt, :admin, :map, :distanceUnit, :speedUnit, :latitude, :longitude, :zoom, :twelveHourFormat, :attributes);
     </entry>
 
     <entry key='database.updateUser'>
@@ -85,7 +85,8 @@
         latitude = :latitude,
         longitude = :longitude,
         zoom = :zoom,
-        twelveHourFormat = :twelveHourFormat
+        twelveHourFormat = :twelveHourFormat,
+        attributes = :attributes
         WHERE id = :id;
     </entry>
 
-- 
cgit v1.2.3