diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2015-11-07 10:55:00 +1300 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2015-11-07 10:55:00 +1300 |
| commit | c55ecff2f0d6b83973953b3ae4f86e14a923b6c7 (patch) | |
| tree | 9e0df9b3a7914c5bf4b3a617aa3c098bae54d8a9 | |
| parent | 315c359711b37b1afd90117564332f0770033057 (diff) | |
| download | trackermap-server-c55ecff2f0d6b83973953b3ae4f86e14a923b6c7.tar.gz trackermap-server-c55ecff2f0d6b83973953b3ae4f86e14a923b6c7.tar.bz2 trackermap-server-c55ecff2f0d6b83973953b3ae4f86e14a923b6c7.zip | |
Change coordinates to double precision
| -rw-r--r-- | debug.xml | 12 |
1 files changed, 6 insertions, 6 deletions
@@ -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 ( |