USE [EnVisage]
GO

IF NOT EXISTS(SELECT * FROM sys.columns 
            WHERE Name = N'CaptureHistory' AND Object_ID = Object_ID(N'Scenario'))
BEGIN
ALTER table [dbo].[Scenario] Add [CaptureHistory] [int] NULL
end
go

IF NOT EXISTS(SELECT * FROM sys.columns 
            WHERE Name = N'CaptureHistory' AND Object_ID = Object_ID(N'ScenarioDetail'))
BEGIN
ALTER table [dbo].[ScenarioDetail] Add [CaptureHistory] [int] NULL
end
go

IF NOT EXISTS(SELECT * FROM sys.columns 
            WHERE Name = N'LastLoginDate' AND Object_ID = Object_ID(N'AspNetUsers'))
BEGIN
ALTER table [dbo].[AspNetUsers] Add [LastLoginDate] [datetime] NULL
end
go