LastUpdateTax

USE lin2world
GO

--SetLastTaxUpdate fix

DROP TABLE dbo.castle_tax
GO

CREATE TABLE castle_tax
    (
    income_update_t INT NOT NULL DEFAULT 0,
    tax_change_t INT NOT NULL DEFAULT 0,
    manor_reset_t INT NOT NULL DEFAULT 0
    )
GO

CREATE PROCEDURE lin_SetLastTaxUpdateEx
(
 @incomeUpdate INT,
 @taxChange INT,
 @manorReset INT
)
AS
    SET NOCOUNT ON;
BEGIN
  UPDATE castle_tax SET income_update_t = @incomeUpdate, tax_change_t = @taxChange, manor_reset_t = @manorReset

  IF @@ROWCOUNT=0
  BEGIN
    INSERT INTO castle_tax (income_update_t, tax_change_t, manor_reset_t) VALUES(@incomeUpdate, @taxChange, @manorReset)
  END
END

GO