aboutsummaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAbyss777 <abyss@fox5.ru>2017-02-09 09:39:54 +0500
committerAbyss777 <abyss@fox5.ru>2017-02-09 09:39:54 +0500
commitc8da62d78ea19dbdaa15697e7f31dbd02474864d (patch)
tree8a91969e23b808e1c048a541a6e709b652df3c4c /schema
parent1e12757c6dbbb7a48923705437426fe24f86e10a (diff)
downloadtrackermap-server-c8da62d78ea19dbdaa15697e7f31dbd02474864d.tar.gz
trackermap-server-c8da62d78ea19dbdaa15697e7f31dbd02474864d.tar.bz2
trackermap-server-c8da62d78ea19dbdaa15697e7f31dbd02474864d.zip
Add trigger on group deleting
Diffstat (limited to 'schema')
-rw-r--r--schema/changelog-3.10.xml14
1 files changed, 11 insertions, 3 deletions
diff --git a/schema/changelog-3.10.xml b/schema/changelog-3.10.xml
index 33f02880d..ad8c34668 100644
--- a/schema/changelog-3.10.xml
+++ b/schema/changelog-3.10.xml
@@ -34,11 +34,11 @@
<addForeignKeyConstraint baseTableName="user_calendar" baseColumnNames="userid" constraintName="fk_user_calendar_userid" referencedTableName="users" referencedColumnNames="id" onDelete="CASCADE" />
<addForeignKeyConstraint baseTableName="user_calendar" baseColumnNames="calendarid" constraintName="fk_user_calendar_geofenceid" referencedTableName="calendars" referencedColumnNames="id" onDelete="CASCADE" />
-
+
<addColumn tableName="geofences">
<column name="calendarid" type="INT" />
</addColumn>
-
+
<addForeignKeyConstraint baseColumnNames="calendarid" baseTableName="geofences" constraintName="fk_geofence_calendar_calendarid" onDelete="SET NULL" onUpdate="RESTRICT" referencedColumnNames="id" referencedTableName="calendars"/>
<addColumn tableName="positions">
@@ -75,6 +75,7 @@
</addColumn>
</changeSet>
+
<changeSet author="author" id="changelog-3.10-notmssql">
<preConditions onFail="MARK_RAN">
@@ -95,7 +96,14 @@
CREATE TRIGGER tg_users_delete
ON users FOR DELETE
AS BEGIN
- DELETE FROM user_user WHERE managedUserId IN (SELECT deleted.id FROM deleted)
+ DELETE FROM user_user WHERE manageduserid IN (SELECT deleted.id FROM deleted)
+ END
+ </sql>
+ <sql>
+ CREATE TRIGGER tg_groups_delete
+ ON groups FOR DELETE
+ AS BEGIN
+ UPDATE groups SET groupid = NULL WHERE groupid IN (SELECT deleted.id FROM deleted)
END
</sql>