-- Fix for smartkiosk server causing itself to deadlock by accessing the same table within the trigger
BEGIN TRANSACTION

USE [smartkiosk_uptime]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[tr_KioskUptimeUpdatedAt]
ON [dbo].[KioskUptime]
AFTER UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    -- Update the KioskUptime column with the current timestamp
    UPDATE KioskUptime
    SET updated_at = SYSDATETIME()
    WHERE KioskUptime.id IN (SELECT DISTINCT id FROM inserted);
END;

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[tr_KioskStartupHistoryUpdatedAt]
ON [dbo].[KioskStartupHistory]
AFTER UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    -- Update the updated_at column with the current timestamp
    UPDATE KioskStartupHistory
    SET updated_at = SYSDATETIME()
    WHERE KioskStartupHistory.id IN (SELECT DISTINCT id FROM inserted);
END;

COMMIT;