diff options
| author | Abyss777 <abyss@fox5.ru> | 2018-10-11 09:56:12 +0500 |
|---|---|---|
| committer | Abyss777 <abyss@fox5.ru> | 2018-10-11 09:56:12 +0500 |
| commit | bf26c3aa265e3fcdd74b3daaac894f4c001013eb (patch) | |
| tree | 1be84469993ccfee23432e7791700c2487798028 | |
| parent | 81db6816268e7355df8e4a2b9600b3ab1145d84d (diff) | |
| download | traccar-server-bf26c3aa265e3fcdd74b3daaac894f4c001013eb.tar.gz traccar-server-bf26c3aa265e3fcdd74b3daaac894f4c001013eb.tar.bz2 traccar-server-bf26c3aa265e3fcdd74b3daaac894f4c001013eb.zip | |
Fix MSSQL triggers after renaming columns
| -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 |