diff options
| -rw-r--r-- | schema/changelog-4.0-clean.xml | 17 |
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 |