aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2015-06-27 17:35:29 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2015-06-27 17:35:29 +1200
commit51169169b4f34fe23cbcd0c26d46815ba9292e60 (patch)
tree4f107b2f72914f8aad0542b56e638b21d96010f5
parentd15ed63e4d276737a88e849c27af2876bf56a82e (diff)
downloadtrackermap-server-51169169b4f34fe23cbcd0c26d46815ba9292e60.tar.gz
trackermap-server-51169169b4f34fe23cbcd0c26d46815ba9292e60.tar.bz2
trackermap-server-51169169b4f34fe23cbcd0c26d46815ba9292e60.zip
Add position SQL index
-rw-r--r--debug.xml4
1 files changed, 2 insertions, 2 deletions
diff --git a/debug.xml b/debug.xml
index c29b30937..8643681f9 100644
--- a/debug.xml
+++ b/debug.xml
@@ -73,8 +73,6 @@
FOREIGN KEY (userId) REFERENCES user(id) ON DELETE CASCADE,
FOREIGN KEY (deviceId) REFERENCES device(id) ON DELETE CASCADE);
- CREATE INDEX user_device_user_id ON user_device(userId);
-
CREATE TABLE position (
id INT PRIMARY KEY AUTO_INCREMENT,
protocol VARCHAR(1024),
@@ -91,6 +89,8 @@
address VARCHAR(1024),
other VARCHAR(8192) 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,