Alter Table [Users] ADD LastAppLoginTime datetime
GO

Alter Table [CourseType] ADD LockState int CONSTRAINT [DF_CourseType_LockState]  DEFAULT (1)
GO

Update CourseType set LockState = 1
GO

Alter Table [Potential] ADD IsPublic int CONSTRAINT [DF_Potential_IsPublic]  DEFAULT (0)
GO

Update Potential set IsPublic = 0
GO

Alter Table [Potential] ADD PrivateDate datetime
GO

Update [Potential] set PrivateDate = getdate()
GO

Update DBInfo set DateAndTime='2014-08-08'
GO












