aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2015-11-07 10:55:00 +1300
committerAnton Tananaev <anton.tananaev@gmail.com>2015-11-07 10:55:00 +1300
commitc55ecff2f0d6b83973953b3ae4f86e14a923b6c7 (patch)
tree9e0df9b3a7914c5bf4b3a617aa3c098bae54d8a9
parent315c359711b37b1afd90117564332f0770033057 (diff)
downloadtrackermap-server-c55ecff2f0d6b83973953b3ae4f86e14a923b6c7.tar.gz
trackermap-server-c55ecff2f0d6b83973953b3ae4f86e14a923b6c7.tar.bz2
trackermap-server-c55ecff2f0d6b83973953b3ae4f86e14a923b6c7.zip
Change coordinates to double precision
-rw-r--r--debug.xml12
1 files changed, 6 insertions, 6 deletions
diff --git a/debug.xml b/debug.xml
index 34d638927..c8fbe53d8 100644
--- a/debug.xml
+++ b/debug.xml
@@ -63,8 +63,8 @@
language VARCHAR(128),
distanceUnit VARCHAR(128),
speedUnit VARCHAR(128),
- latitude FLOAT DEFAULT 0 NOT NULL,
- longitude FLOAT DEFAULT 0 NOT NULL,
+ latitude DOUBLE PRECISION DEFAULT 0 NOT NULL,
+ longitude DOUBLE PRECISION DEFAULT 0 NOT NULL,
zoom INT DEFAULT 0 NOT NULL);
CREATE TABLE device (
@@ -93,8 +93,8 @@
deviceTime TIMESTAMP NOT NULL,
fixTime TIMESTAMP NOT NULL,
valid BIT NOT NULL,
- latitude FLOAT NOT NULL,
- longitude FLOAT NOT NULL,
+ latitude DOUBLE PRECISION NOT NULL,
+ longitude DOUBLE PRECISION NOT NULL,
altitude FLOAT NOT NULL,
speed FLOAT NOT NULL,
course FLOAT NOT NULL,
@@ -113,8 +113,8 @@
language VARCHAR(128),
distanceUnit VARCHAR(128),
speedUnit VARCHAR(128),
- latitude FLOAT DEFAULT 0 NOT NULL,
- longitude FLOAT DEFAULT 0 NOT NULL,
+ latitude DOUBLE PRECISION DEFAULT 0 NOT NULL,
+ longitude DOUBLE PRECISION DEFAULT 0 NOT NULL,
zoom INT DEFAULT 0 NOT NULL);
CREATE TABLE traccar (