create trigger PasswordMaintenance
	on Vevo
	for insert, update
as
	begin

	declare @date datetime
	declare @expireDate datetime = dateadd(year,1,getdate())

	declare @newPassword nvarchar(50)
	declare @oldPassword nvarchar(50)

	select @date = JelszoLejarat from inserted i

	if @date is null
		begin

		update vevo
		set JelszoLejarat = @expireDate
		from Vevo v join inserted i on v.ID = i.ID

		end
	else
	  begin

		select @newPassword = Jelszo from inserted
		select @oldPassword = Jelszo from deleted

		if @newPassword != @oldPassword
			begin

			update vevo
			set JelszoLejarat = @expireDate
			from Vevo v join inserted i on v.ID = i.ID

			end
	  end
	end