diff options
| -rw-r--r-- | src/org/traccar/database/DataManager.java | 32 |
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(); |