aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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