USE [AccountServer]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[UPD_ACCOUNT_LOGIN]
   ON [AccountServer].[dbo].[account_login]
   AFTER UPDATE
AS
BEGIN
	IF @@ROWCOUNT = 0 RETURN
	DECLARE @IP VARCHAR(55)
	DECLARE @MAC VARCHAR(55)
	SELECT @IP = SUBSTRING(last_login_mac,25,15) FROM INSERTED
	SELECT @MAC = SUBSTRING(last_login_mac,0,24) FROM INSERTED
	UPDATE account_login
		SET
			last_login_ip = CASE WHEN @IP='' THEN last_login_ip ELSE @IP END,
			last_login_mac = CASE WHEN @MAC='' THEN last_login_mac ELSE @MAC END
		WHERE id=(SELECT id FROM INSERTED)
END
GO

USE [AccountServer]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[INS_USER_LOG]
   ON [AccountServer].[dbo].[user_log]
   AFTER INSERT
AS
BEGIN
	IF @@ROWCOUNT = 0 RETURN
	DECLARE @IP VARCHAR(55)
	SELECT @IP = last_login_ip FROM account_login WHERE id=(SELECT user_id FROM INSERTED)
	UPDATE user_log
		SET
			login_ip = CASE WHEN @IP='' THEN login_ip ELSE @IP END
		WHERE log_id=(SELECT log_id FROM INSERTED)
END
GO