diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2015-04-26 17:36:48 +1200 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2015-04-26 17:36:48 +1200 |
| commit | 05666c6d2e309313583ac698a1792833d84d0e41 (patch) | |
| tree | b7b9db93ce1bd886625f1f1bc1f62dc2401e0169 /src/org/traccar/database | |
| parent | 71dad7d3240bb178701e5dd1e86ae31a6eaa8263 (diff) | |
| download | trackermap-server-05666c6d2e309313583ac698a1792833d84d0e41.tar.gz trackermap-server-05666c6d2e309313583ac698a1792833d84d0e41.tar.bz2 trackermap-server-05666c6d2e309313583ac698a1792833d84d0e41.zip | |
Add more fields to DB tables
Diffstat (limited to 'src/org/traccar/database')
| -rw-r--r-- | src/org/traccar/database/DataManager.java | 3 |
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);" + |