Fix error when creating triggers
@@ -1370,20 +1370,14 @@ CREATE INDEX IDX_CORS_SP_APP_ID ON IDN_CORS_ASSOCIATION (SP_APP_ID);
-- IDN_CORS_ASSOCIATION --
CREATE INDEX IDX_CORS_ORIGIN_ID ON IDN_CORS_ASSOCIATION (IDN_CORS_ORIGIN_ID);
+GO
+
-- Trigger IDN_CLAIM delete by dialect on IDN_CLAIM_DIALECT deletion --
-CREATE TRIGGER IDN_CLAIM_DIALECT_DELETE_TRIGGER
-ON IDN_CLAIM_DIALECT
-INSTEAD OF DELETE
-AS BEGIN
- DELETE FROM IDN_CLAIM WHERE DIALECT_ID IN (SELECT ID FROM deleted)
- DELETE FROM IDN_CLAIM_DIALECT WHERE ID IN (SELECT ID FROM deleted)
-END;
+CREATE TRIGGER IDN_CLAIM_DIALECT_DELETE_TRIGGER ON IDN_CLAIM_DIALECT INSTEAD OF DELETE AS BEGIN DELETE FROM IDN_CLAIM WHERE DIALECT_ID IN (SELECT ID FROM deleted)DELETE FROM IDN_CLAIM_DIALECT WHERE ID IN (SELECT ID FROM deleted)END;
+
+GO
-- Trigger IDN_CLAIM_MAPPING delete by claim id on IDN_CLAIM deletion by claim id --
-CREATE TRIGGER IDN_CLAIM_MAPPING_DELETE_TRIGGER
-ON IDN_CLAIM
-INSTEAD OF DELETE
-AS BEGIN
- DELETE FROM IDN_CLAIM_MAPPING WHERE EXT_CLAIM_ID IN (SELECT ID FROM deleted) OR MAPPED_LOCAL_CLAIM_ID IN (SELECT ID FROM deleted)
- DELETE FROM IDN_CLAIM WHERE ID IN (SELECT ID FROM deleted)
-END;
+CREATE TRIGGER IDN_CLAIM_MAPPING_DELETE_TRIGGER ON IDN_CLAIM INSTEAD OF DELETE AS BEGIN DELETE FROM IDN_CLAIM_MAPPING WHERE EXT_CLAIM_ID IN (SELECT ID FROM deleted) OR MAPPED_LOCAL_CLAIM_ID IN (SELECT ID FROM deleted)DELETE FROM IDN_CLAIM WHERE ID IN (SELECT ID FROM deleted)END;
+
+GO
