aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2017-07-08 19:14:14 +1200
committerAnton Tananaev <anton.tananaev@gmail.com>2017-07-08 19:14:14 +1200
commiteb8d0d220d4aa1b68331342c839adfd02c574f35 (patch)
treed8f76e39b40082631f8264dd2f012ed1b2866936 /schema
parentb524bbdd7727e672c890cea05800e34f5444eb65 (diff)
downloadtraccar-server-eb8d0d220d4aa1b68331342c839adfd02c574f35.tar.gz
traccar-server-eb8d0d220d4aa1b68331342c839adfd02c574f35.tar.bz2
traccar-server-eb8d0d220d4aa1b68331342c839adfd02c574f35.zip
Do not rename position and event keys
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.12.xml4
1 files changed, 2 insertions, 2 deletions
diff --git a/schema/changelog-3.12.xml b/schema/changelog-3.12.xml
index efd978532..19c67cb36 100644
--- a/schema/changelog-3.12.xml
+++ b/schema/changelog-3.12.xml
@@ -77,11 +77,11 @@
<addForeignKeyConstraint baseTableName="device_attribute" baseColumnNames="deviceid" constraintName="fk_device_attribute_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
<addForeignKeyConstraint baseTableName="device_attribute" baseColumnNames="attributeid" constraintName="fk_device_attribute_attributeid" referencedTableName="attributes" referencedColumnNames="id" onDelete="CASCADE" />
- <dropForeignKeyConstraint baseTableName="positions" constraintName="fk_position_deviceid" />
+ <!--<dropForeignKeyConstraint baseTableName="positions" constraintName="fk_position_deviceid" />
<addForeignKeyConstraint baseTableName="positions" baseColumnNames="deviceid" constraintName="fk_positions_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
<dropForeignKeyConstraint baseTableName="events" constraintName="fk_event_deviceid" />
- <addForeignKeyConstraint baseTableName="events" baseColumnNames="deviceid" constraintName="fk_events_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />
+ <addForeignKeyConstraint baseTableName="events" baseColumnNames="deviceid" constraintName="fk_events_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />-->
<dropForeignKeyConstraint baseTableName="device_geofence" constraintName="fk_user_device_geofence_deviceid" />
<addForeignKeyConstraint baseTableName="device_geofence" baseColumnNames="deviceid" constraintName="fk_device_geofence_deviceid" referencedTableName="devices" referencedColumnNames="id" onDelete="CASCADE" />