diff options
| author | Anton Tananaev <anton.tananaev@gmail.com> | 2015-06-29 15:04:03 +1200 |
|---|---|---|
| committer | Anton Tananaev <anton.tananaev@gmail.com> | 2015-06-29 15:04:03 +1200 |
| commit | e9d300e00f244a56246809a3edace996286f1e19 (patch) | |
| tree | a3ca032571b9fd528e48c49d5c752ee5bdf89afc | |
| parent | 474002e0dc2dcc495b963fe8a011b8262788c499 (diff) | |
| download | trackermap-server-e9d300e00f244a56246809a3edace996286f1e19.tar.gz trackermap-server-e9d300e00f244a56246809a3edace996286f1e19.tar.bz2 trackermap-server-e9d300e00f244a56246809a3edace996286f1e19.zip | |
Reduce sizes of text fieds (fix #1275)
| -rw-r--r-- | debug.xml | 33 |
1 files changed, 16 insertions, 17 deletions
@@ -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> |