alter table ast_dwntime
add ast_dwntime_asset_no varchar(30)

alter table ast_dwntime
add ast_dwntime_status_original varchar(3)

alter table ast_dwntime
add ast_dwntime_status_down varchar(3)

alter table ast_dwntime
add ast_dwntime_status_up varchar(3)

alter table ast_dwntime
add ast_dwntime_repair_from datetime

alter table ast_dwntime
add ast_dwntime_repair_to datetime

alter table ast_dwntime
add ast_dwntime_remark varchar(255)


DELETE	cf_label
WHERE	table_name = 'ast_dwntime'
AND 	column_name = 'ast_dwntime_asset_no'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_dwntime', 'ast_dwntime_asset_no', 
		'Asset No:', 
		'Asset No', 
		'Asset No:', 
		'Asset No', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


DELETE	cf_label
WHERE	table_name = 'ast_dwntime'
AND 	column_name = 'ast_dwntime_status_original'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_dwntime', 'ast_dwntime_status_original', 
		'Status Original:', 
		'Status Original', 
		'Status Original:', 
		'Status Original', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

DELETE	cf_label
WHERE	table_name = 'ast_dwntime'
AND 	column_name = 'ast_dwntime_status_down'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_dwntime', 'ast_dwntime_status_down', 
		'Status Down:', 
		'Status Down', 
		'Status Down:', 
		'Status Down', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


DELETE	cf_label
WHERE	table_name = 'ast_dwntime'
AND 	column_name = 'ast_dwntime_status_up'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_dwntime', 'ast_dwntime_status_up', 
		'Status Up:', 
		'Status Up', 
		'Status Up:', 
		'Status Up', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


DELETE	cf_label
WHERE	table_name = 'ast_dwntime'
AND 	column_name = 'ast_dwntime_repair_down'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_dwntime', 'ast_dwntime_repair_down', 
		'Repair From:', 
		'Repair From', 
		'Repair From:', 
		'Repair From', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


DELETE	cf_label
WHERE	table_name = 'ast_dwntime'
AND 	column_name = 'ast_dwntime_remark'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_dwntime', 'ast_dwntime_remark', 
		'Remark:', 
		'Remark', 
		'Remark:', 
		'Remark', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO



DELETE	cf_label
WHERE	table_name = 'ast_dwntime'
AND 	column_name = 'ast_dwntime_sched_flag'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'ast_dwntime', 'ast_dwntime_sched_flag', 
		'Planned Shutdown?:', 
		'Planned Shutdown?', 
		'Planned Shutdown?:', 
		'Planned Shutdown?', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO