
ALTER TABLE	wko_ls7
ADD			wko_ls7_date1 DATETIME,
			wko_ls7_date2 DATETIME,
			wko_ls7_date3 DATETIME,
			wko_ls7_date4 DATETIME,
			wko_ls7_date5 DATETIME
GO

DELETE	cf_label
WHERE	table_name = 'wko_ls7'
AND 	column_name = 'wko_ls7_date1'
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, 'wko_ls7', 'wko_ls7_date1', 
		'UDF Date 1:', 
		'UDF Date 1:', 
		'UDF Date 1', 
		'UDF Date 1', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

DELETE	cf_label
WHERE	table_name = 'wko_ls7'
AND 	column_name = 'wko_ls7_date2'
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, 'wko_ls7', 'wko_ls7_date2', 
		'UDF Date 2:', 
		'UDF Date 2:', 
		'UDF Date 2', 
		'UDF Date 2', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

DELETE	cf_label
WHERE	table_name = 'wko_ls7'
AND 	column_name = 'wko_ls7_date3'
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, 'wko_ls7', 'wko_ls7_date3', 
		'UDF Date 3:', 
		'UDF Date 3:', 
		'UDF Date 3', 
		'UDF Date 3', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

DELETE	cf_label
WHERE	table_name = 'wko_ls7'
AND 	column_name = 'wko_ls7_date4'
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, 'wko_ls7', 'wko_ls7_date4', 
		'UDF Date 4:', 
		'UDF Date 4:', 
		'UDF Date 4', 
		'UDF Date 4', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

DELETE	cf_label
WHERE	table_name = 'wko_ls7'
AND 	column_name = 'wko_ls7_date5'
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, 'wko_ls7', 'wko_ls7_date5', 
		'UDF Date 5:', 
		'UDF Date 5:', 
		'UDF Date 5', 
		'UDF Date 5', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO