aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2015-06-29 15:04:03 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2015-06-29 15:04:03 +1200
commite9d300e00f244a56246809a3edace996286f1e19 (patch)
treea3ca032571b9fd528e48c49d5c752ee5bdf89afc
parent474002e0dc2dcc495b963fe8a011b8262788c499 (diff)
downloadtrackermap-server-e9d300e00f244a56246809a3edace996286f1e19.tar.gz
trackermap-server-e9d300e00f244a56246809a3edace996286f1e19.tar.bz2
trackermap-server-e9d300e00f244a56246809a3edace996286f1e19.zip
Reduce sizes of text fieds (fix #1275)
-rw-r--r--debug.xml33
1 files changed, 16 insertions, 17 deletions
diff --git a/debug.xml b/debug.xml
index d69c1746c..bdc92b04c 100644
--- a/debug.xml
+++ b/debug.xml
@@ -42,25 +42,25 @@
<entry key='database.createSchema'>
CREATE TABLE user (
id INT PRIMARY KEY AUTO_INCREMENT,
- name VARCHAR(1024) NOT NULL,
- email VARCHAR(256) NOT NULL UNIQUE,
- hashedPassword VARCHAR(1024) NOT NULL,
- salt VARCHAR(1024) DEFAULT '' NOT NULL,
+ name VARCHAR(128) NOT NULL,
+ email VARCHAR(128) NOT NULL UNIQUE,
+ hashedPassword VARCHAR(128) NOT NULL,
+ salt VARCHAR(128) DEFAULT '' 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,
- distanceUnit VARCHAR(1024) DEFAULT 'km' NOT NULL,
- speedUnit VARCHAR(1024) DEFAULT 'kmh' NOT NULL,
+ map VARCHAR(128) DEFAULT 'osm' NOT NULL,
+ language VARCHAR(128) DEFAULT 'en' NOT NULL,
+ distanceUnit VARCHAR(128) DEFAULT 'km' NOT NULL,
+ speedUnit VARCHAR(128) DEFAULT 'kmh' NOT NULL,
latitude DOUBLE DEFAULT 0 NOT NULL,
longitude DOUBLE DEFAULT 0 NOT NULL,
zoom INT DEFAULT 0 NOT NULL);
CREATE TABLE device (
id INT PRIMARY KEY AUTO_INCREMENT,
- name VARCHAR(1024) NOT NULL,
- uniqueId VARCHAR(256) NOT NULL UNIQUE,
- status VARCHAR(1024),
+ name VARCHAR(128) NOT NULL,
+ uniqueId VARCHAR(128) NOT NULL UNIQUE,
+ status VARCHAR(128),
lastUpdate TIMESTAMP,
positionId INT,
dataId INT);
@@ -75,7 +75,7 @@
CREATE TABLE position (
id INT PRIMARY KEY AUTO_INCREMENT,
- protocol VARCHAR(1024),
+ protocol VARCHAR(128),
deviceId INT NOT NULL,
serverTime TIMESTAMP NOT NULL,
deviceTime TIMESTAMP NOT NULL,
@@ -86,19 +86,19 @@
altitude DOUBLE NOT NULL,
speed DOUBLE NOT NULL,
course DOUBLE NOT NULL,
- address VARCHAR(1024),
- other VARCHAR(8192) NOT NULL,
+ address VARCHAR(512),
+ other VARCHAR(4096) NOT NULL,
FOREIGN KEY (deviceId) REFERENCES device(id) ON DELETE CASCADE);
CREATE INDEX position_deviceId_fixTime ON `position`(deviceId, fixTime);
CREATE TABLE data (
id INT PRIMARY KEY AUTO_INCREMENT,
- protocol VARCHAR(1024),
+ protocol VARCHAR(128),
deviceId INT NOT NULL,
serverTime TIMESTAMP NOT NULL,
deviceTime TIMESTAMP NOT NULL,
- other VARCHAR(8192) NOT NULL,
+ other VARCHAR(4096) NOT NULL,
FOREIGN KEY (deviceId) REFERENCES device(id));
ALTER TABLE device ADD
@@ -255,7 +255,6 @@
<entry key='topflytech.port'>5047</entry>
<entry key='laipac.port'>5048</entry>
<entry key='aplicom.port'>5049</entry>
- <entry key='aplicom.can'>false</entry>
<entry key='gotop.port'>5050</entry>
<entry key='sanav.port'>5051</entry>
<entry key='gator.port'>5052</entry>