diff options
Diffstat (limited to 'setup')
| -rw-r--r-- | setup/linux/traccar.xml | 6 | ||||
| -rw-r--r-- | setup/macosx/traccar.xml | 6 | ||||
| -rw-r--r-- | setup/windows/traccar.xml | 6 |
3 files changed, 9 insertions, 9 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, diff --git a/setup/macosx/traccar.xml b/setup/macosx/traccar.xml index 139b4fec8..3d4e831ca 100644 --- a/setup/macosx/traccar.xml +++ b/setup/macosx/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, diff --git a/setup/windows/traccar.xml b/setup/windows/traccar.xml index 0b68fe5ea..d796d8040 100644 --- a/setup/windows/traccar.xml +++ b/setup/windows/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,
|