aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAnton Tananaev <anton.tananaev@gmail.com>2018-10-11 19:05:57 +1300
committerGitHub <noreply@github.com>2018-10-11 19:05:57 +1300
commit21d3d6aaa42557e0d6279165f89e6fabe53235c6 (patch)
tree1be84469993ccfee23432e7791700c2487798028
parent81db6816268e7355df8e4a2b9600b3ab1145d84d (diff)
parentbf26c3aa265e3fcdd74b3daaac894f4c001013eb (diff)
downloadtrackermap-server-21d3d6aaa42557e0d6279165f89e6fabe53235c6.tar.gz
trackermap-server-21d3d6aaa42557e0d6279165f89e6fabe53235c6.tar.bz2
trackermap-server-21d3d6aaa42557e0d6279165f89e6fabe53235c6.zip
Merge pull request #4100 from Abyss777/fix_triggers
Fix MSSQL triggers after renaming columns
-rw-r--r--schema/changelog-4.0-clean.xml17
1 files changed, 14 insertions, 3 deletions
diff --git a/schema/changelog-4.0-clean.xml b/schema/changelog-4.0-clean.xml
index 0f3f694ba..27a845dc8 100644
--- a/schema/changelog-4.0-clean.xml
+++ b/schema/changelog-4.0-clean.xml
@@ -652,13 +652,17 @@
<changeSet author="author" id="changelog-4.0-clean-mssql">
<preConditions onFail="MARK_RAN">
- <not>
- <changeSetExecuted changeLogFile="changelog-3.3" id="changelog-3.3" author="author" />
- </not>
<dbms type="mssql" />
</preConditions>
<sql>
+ IF EXISTS (SELECT * FROM sysobjects WHERE type = 'TR' AND name = 'tg_groups_delete')
+ BEGIN
+ DROP TRIGGER tg_groups_delete
+ END;
+ </sql>
+
+ <sql>
CREATE TRIGGER tg_groups_delete
ON tc_groups FOR DELETE
AS BEGIN
@@ -667,6 +671,13 @@
</sql>
<sql>
+ IF EXISTS (SELECT * FROM sysobjects WHERE type = 'TR' AND name = 'tg_users_delete')
+ BEGIN
+ DROP TRIGGER tg_users_delete
+ END;
+ </sql>
+
+ <sql>
CREATE TRIGGER tg_users_delete
ON tc_users FOR DELETE
AS BEGIN