23 lines
635 B
Transact-SQL
23 lines
635 B
Transact-SQL
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 |