USE lin2world
GO

--Manor fix
ALTER TABLE dbo.manor_info ADD
    last_changed_t INT NOT NULL DEFAULT 0
GO

ALTER TABLE dbo.manor_info
    DROP COLUMN last_changed
GO

ALTER  PROCEDURE [dbo].[lin_SaveManorInfo]
(
 @manor_id INT,
 @residence_id INT,
 @AdenaSeedSell INT,
 @AdenaCropBuy INT,
 @change_state TINYINT,
 @last_changed INT
)
AS

SET NOCOUNT ON

IF EXISTS(SELECT * FROM manor_info WHERE manor_id = @manor_id)
BEGIN
    UPDATE
        manor_info
    SET
        residence_id = @residence_id,
        adena_vault = @AdenaSeedSell,
        crop_buy_vault = @AdenaCropBuy,
        change_state = @change_state,
        last_changed_t = @last_changed
    WHERE
        manor_id = @manor_id
END
ELSE
BEGIN
    INSERT INTO manor_info (manor_id, residence_id, adena_vault, crop_buy_vault, change_state, last_changed_t)
    VALUES (@manor_id, @residence_id,@AdenaSeedSell,@AdenaCropBuy, @change_state, @last_changed)
END

GO

ALTER  PROCEDURE [dbo].[lin_LoadManorInfo]
(
 @manor_id INT
)
AS

SET NOCOUNT ON

IF EXISTS(SELECT * FROM manor_info WHERE manor_id = @manor_id)
BEGIN
    SELECT
        residence_id, adena_vault, crop_buy_vault, change_state, last_changed_t
    FROM
        manor_info
    WHERE
        manor_id = @manor_id
END
ELSE
BEGIN
    SELECT 0, 0, 0, 0, 0

END

GO