From 05666c6d2e309313583ac698a1792833d84d0e41 Mon Sep 17 00:00:00 2001 From: Anton Tananaev Date: Sun, 26 Apr 2015 17:36:48 +1200 Subject: Add more fields to DB tables --- src/org/traccar/database/DataManager.java | 3 +++ 1 file changed, 3 insertions(+) (limited to 'src/org/traccar') 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);" + -- cgit v1.2.3