aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2017-02-09 10:29:06 +0500
committerAbyss777 <abyss@fox5.ru>2017-02-09 10:29:06 +0500
commit0d789419b2707be5160a71d2073d48c15f3daf50 (patch)
tree94854daf2afb942dfc3e021f59a8d5535c4a008f /schema
parentc8da62d78ea19dbdaa15697e7f31dbd02474864d (diff)
downloadtraccar-server-0d789419b2707be5160a71d2073d48c15f3daf50.tar.gz
traccar-server-0d789419b2707be5160a71d2073d48c15f3daf50.tar.bz2
traccar-server-0d789419b2707be5160a71d2073d48c15f3daf50.zip
Split trigger to 3.7-mssql changeset
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.10.xml8
1 files changed, 8 insertions, 0 deletions
diff --git a/schema/changelog-3.10.xml b/schema/changelog-3.10.xml
index ad8c34668..4c64373e9 100644
--- a/schema/changelog-3.10.xml
+++ b/schema/changelog-3.10.xml
@@ -99,6 +99,14 @@
DELETE FROM user_user WHERE manageduserid IN (SELECT deleted.id FROM deleted)
END
</sql>
+
+ </changeSet>
+
+ <changeSet author="author" id="changelog-3.7-mssql">
+
+ <preConditions onFail="MARK_RAN">
+ <dbms type="mssql" />
+ </preConditions>
<sql>
CREATE TRIGGER tg_groups_delete
ON groups FOR DELETE