aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2015-02-10 16:54:18 +1300
committerAnton Tananaev <anton.tananaev@gmail.com>2015-02-10 16:54:18 +1300
commite4981d8e06f730a145ceaa4aa874533591ed0695 (patch)
tree00ac5ebdc7d1516cee0f817587e31e730cb07368
parentc37b9de4b1a5d678c191f209b2b8f2447492a5c3 (diff)
downloadtrackermap-server-e4981d8e06f730a145ceaa4aa874533591ed0695.tar.gz
trackermap-server-e4981d8e06f730a145ceaa4aa874533591ed0695.tar.bz2
trackermap-server-e4981d8e06f730a145ceaa4aa874533591ed0695.zip
More database init code
-rw-r--r--src/org/traccar/database/DataManager.java32
1 files changed, 30 insertions, 2 deletions
diff --git a/src/org/traccar/database/DataManager.java b/src/org/traccar/database/DataManager.java
index 336ac3e34..602345df9 100644
--- a/src/org/traccar/database/DataManager.java
+++ b/src/org/traccar/database/DataManager.java
@@ -225,11 +225,39 @@ public class DataManager {
try {
statement.execute(
- "CREATE TABLE users_new (" +
+ "CREATE TABLE IF NOT EXISTS users (" +
"id INT PRIMARY KEY AUTO_INCREMENT," +
"name VARCHAR(1024) NOT NULL UNIQUE," +
"password VARCHAR(1024) NOT NULL," +
- "admin BOOLEAN NOT NULL)");
+ "admin BOOLEAN NOT NULL);");
+
+ statement.execute(
+ "CREATE TABLE IF NOT EXISTS devices (" +
+ "id INT PRIMARY KEY AUTO_INCREMENT," +
+ "name VARCHAR(1024) NOT NULL," +
+ "uniqueId VARCHAR(1024) NOT NULL UNIQUE);");
+
+ statement.execute(
+ "CREATE TABLE IF NOT EXISTS users_devices (" +
+ "userId INT NOT NULL," +
+ "deviceId INT NOT NULL," +
+ "FOREIGN KEY (userId) REFERENCES users(id)," +
+ "FOREIGN KEY (deviceId) REFERENCES devices(id));");
+
+ statement.execute(
+ "CREATE TABLE IF NOT EXISTS positions (" +
+ "id INT PRIMARY KEY AUTO_INCREMENT," +
+ "deviceId INT NOT NULL," +
+ "time TIMESTAMP NOT NULL," +
+ "valid BOOLEAN NOT NULL," +
+ "latitude DOUBLE NOT NULL," +
+ "longitude DOUBLE NOT NULL," +
+ "altitude DOUBLE NOT NULL," +
+ "speed DOUBLE NOT NULL," +
+ "course DOUBLE NOT NULL," +
+ "address VARCHAR(1024) NOT NULL," +
+ "other VARCHAR(8192) NOT NULL," +
+ "FOREIGN KEY (deviceId) REFERENCES devices(id));");
} finally {
statement.close();