From bf26c3aa265e3fcdd74b3daaac894f4c001013eb Mon Sep 17 00:00:00 2001
From: Abyss777 <abyss@fox5.ru>
Date: Thu, 11 Oct 2018 09:56:12 +0500
Subject: Fix MSSQL triggers after renaming columns

---
 schema/changelog-4.0-clean.xml | 17 ++++++++++++++---
 1 file changed, 14 insertions(+), 3 deletions(-)

(limited to 'schema')

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,12 +652,16 @@
   <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
@@ -666,6 +670,13 @@
       END
     </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
-- 
cgit v1.2.3