--Add column for online access
alter table cf_site
add require_offline varchar(1) NULL

Update cf_site set require_offline = '1'


--Add column for employee privileges
alter table emp_det
add emp_det_mobile varchar(1) NULL

alter table emp_det
add emp_det_core varchar(1) NULL

alter table emp_det
add emp_det_webwork varchar(1) NULL

Update emp_det set emp_det_mobile = '1', emp_det_core = '1', emp_det_webwork = '1'


DELETE	cf_label
WHERE	table_name = 'emp_det'
AND 	column_name = 'emp_det_mobile'
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, 'emp_det', 'emp_det_mobile', 
		'Mobile Access:', 
		'Mobile Access:', 
		'Mobile Access:', 
		'Mobile Access:', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

DELETE	cf_label
WHERE	table_name = 'emp_det'
AND 	column_name = 'emp_det_core'
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, 'emp_det', 'emp_det_core', 
		'Core Access:', 
		'Core Access:', 
		'Core Access:', 
		'Core Access:', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

DELETE	cf_label
WHERE	table_name = 'emp_det'
AND 	column_name = 'emp_det_web'
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, 'emp_det', 'emp_det_web', 
		'Webwork Access:', 
		'Webwork Access:', 
		'Webwork Access:', 
		'Webwork Access:', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO