aboutsummaryrefslogtreecommitdiff
path: root/setup/linux
diff options
context:
space:
mode:
Diffstat (limited to 'setup/linux')
-rw-r--r--setup/linux/traccar.xml6
1 files changed, 3 insertions, 3 deletions
diff --git a/setup/linux/traccar.xml b/setup/linux/traccar.xml
index 139b4fec8..3d4e831ca 100644
--- a/setup/linux/traccar.xml
+++ b/setup/linux/traccar.xml
@@ -92,13 +92,13 @@
serverTime TIMESTAMP NOT NULL,
deviceTime TIMESTAMP NOT NULL,
other VARCHAR(4096) NOT NULL,
- FOREIGN KEY (deviceId) REFERENCES device (id));
+ FOREIGN KEY (deviceId) REFERENCES device (id) ON DELETE CASCADE);
ALTER TABLE device ADD
- FOREIGN KEY (positionId) REFERENCES position (id);
+ FOREIGN KEY (positionId) REFERENCES position (id) ON DELETE CASCADE;
ALTER TABLE device ADD
- FOREIGN KEY (dataId) REFERENCES data (id);
+ FOREIGN KEY (dataId) REFERENCES data (id) ON DELETE CASCADE;
CREATE TABLE server (
id INT PRIMARY KEY AUTO_INCREMENT,