From 2d1b4aad57da93d171170b2c63d9b6380bf59e44 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton@traccar.org>
Date: Sat, 13 Jul 2024 08:55:33 -0700
Subject: Drop foreign keys

---
 schema/changelog-6.3.xml    | 31 +++++++++++++++++++++++++++++++
 schema/changelog-master.xml |  1 +
 2 files changed, 32 insertions(+)
 create mode 100644 schema/changelog-6.3.xml

diff --git a/schema/changelog-6.3.xml b/schema/changelog-6.3.xml
new file mode 100644
index 000000000..c987a7315
--- /dev/null
+++ b/schema/changelog-6.3.xml
@@ -0,0 +1,31 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<databaseChangeLog
+  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
+                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd"
+  logicalFilePath="changelog-6.3">
+
+  <changeSet author="author" id="changelog-6.3-old">
+
+    <preConditions onFail="MARK_RAN">
+      <foreignKeyConstraintExists foreignKeyTableName="tc_events" foreignKeyName="fk_event_deviceid" />
+    </preConditions>
+
+    <dropForeignKeyConstraint baseTableName="tc_events" constraintName="fk_event_deviceid" />
+    <dropForeignKeyConstraint baseTableName="tc_positions" constraintName="fk_position_deviceid" />
+
+  </changeSet>
+
+  <changeSet author="author" id="changelog-6.3-new">
+
+    <preConditions onFail="MARK_RAN">
+      <foreignKeyConstraintExists foreignKeyTableName="tc_events" foreignKeyName="fk_events_deviceid" />
+    </preConditions>
+
+    <dropForeignKeyConstraint baseTableName="tc_events" constraintName="fk_events_deviceid" />
+    <dropForeignKeyConstraint baseTableName="tc_positions" constraintName="fk_positions_deviceid" />
+
+  </changeSet>
+
+</databaseChangeLog>
diff --git a/schema/changelog-master.xml b/schema/changelog-master.xml
index e9ae52569..3ce4b43e6 100644
--- a/schema/changelog-master.xml
+++ b/schema/changelog-master.xml
@@ -44,5 +44,6 @@
   <include file="changelog-5.11.xml" relativeToChangelogFile="true" />
 
   <include file="changelog-6.2.xml" relativeToChangelogFile="true" />
+  <include file="changelog-6.3.xml" relativeToChangelogFile="true" />
 
 </databaseChangeLog>
-- 
cgit v1.2.3