alter table PatchApproval
add DateCreated datetime null
go

update PatchApproval
set DateCreated = convert(datetime,'20150101')
go

alter table PatchApproval
alter column DateCreated datetime not null
go

alter table PatchApproval
add DateDeleted datetime null
go

CREATE TABLE [PatchApprovalUpdate]
(
	[PatchGuid]				[uniqueidentifier]	NOT NULL,
	[RevisionNumber]		[int]				NOT NULL,
	[Action]				[int]				NOT NULL,
	[Deadline]				[datetime]				NULL
) 

GO