--Add new column in wrk_pri 
BEGIN
    ALTER TABLE wrk_pri
    ADD wrk_pri_due_type varchar(3) NULL
END

DELETE	cf_label
WHERE	table_name = 'wrk_pri'
AND 	column_name = 'wrk_pri_due_type'
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, 'wrk_pri', 'wrk_pri_due_type', 
		'Due Type:', 
		'Due Type:', 
		'Due Type', 
		'Due Type', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


BEGIN
    ALTER TABLE wrk_pri
    ADD wrk_pri_start_day varchar(10) NULL
END

DELETE	cf_label
WHERE	table_name = 'wrk_pri'
AND 	column_name = 'wrk_pri_start_day'
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, 'wrk_pri', 'wrk_pri_start_day', 
		'Start of the Week:', 
		'Start of the Week:', 
		'Start of the Week', 
		'Start of the Week', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

