ALTER TABLE VS4TAssetFixReq
	DROP COLUMN TFRqTextSort,TFRqTime,TFRqGLStatus
GO
EXECUTE sp_rename N'VS4TAssetFixReq.TFRqFixDate', N'TFRqErrorDate', 'COLUMN'
GO
ALTER TABLE VS4TAssetFixReq ADD
	TFRqTAFBTAFPNo nvarchar(30) NULL,
	TFRqTAFBLn int NULL,
	TFRqTASPYear int NULL,
	TFRqTASPLn int NULL,
	TFRqTCCLLn int NULL,
	TFRqErrorTime datetime NULL
GO
UPDATE VS4TAssetFixReq SET TFRqErrorTime=TFRqErrorDate WHERE TFRqErrorTime is null
GO
