aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2015-04-26 17:36:48 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2015-04-26 17:36:48 +1200
commit05666c6d2e309313583ac698a1792833d84d0e41 (patch)
treeb7b9db93ce1bd886625f1f1bc1f62dc2401e0169
parent71dad7d3240bb178701e5dd1e86ae31a6eaa8263 (diff)
downloadtrackermap-server-05666c6d2e309313583ac698a1792833d84d0e41.tar.gz
trackermap-server-05666c6d2e309313583ac698a1792833d84d0e41.tar.bz2
trackermap-server-05666c6d2e309313583ac698a1792833d84d0e41.zip
Add more fields to DB tables
-rw-r--r--src/org/traccar/database/DataManager.java3
1 files changed, 3 insertions, 0 deletions
diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java
index faded815b..c7c4d2b7f 100644
--- a/src/org/traccar/database/DataManager.java
+++ b/src/org/traccar/database/DataManager.java
@@ -244,6 +244,7 @@ public class DataManager {
"salt VARCHAR(1024) NOT NULL," +
"readonly BOOLEAN DEFAULT false NOT NULL," +
"admin BOOLEAN DEFAULT false NOT NULL," +
+ "map VARCHAR(1024) DEFAULT 'osm' NOT NULL," +
"language VARCHAR(1024) DEFAULT 'en' NOT NULL," +
"distance_unit VARCHAR(1024) DEFAULT 'km' NOT NULL," +
"speed_unit VARCHAR(1024) DEFAULT 'kmh' NOT NULL," +
@@ -255,6 +256,8 @@ public class DataManager {
"id INT PRIMARY KEY AUTO_INCREMENT," +
"name VARCHAR(1024) NOT NULL," +
"unique_id VARCHAR(1024) NOT NULL UNIQUE," +
+ "status VARCHAR(1024)," +
+ "last_update TIMESTAMP," +
"position_id INT," +
"data_id INT);" +