 DELETE	cf_table
WHERE	table_name = 'cf_user'
GO

INSERT	cf_table (	table_name,           
					table_desc,
					custom_report,
					audit_user,
					audit_date )
VALUES (			'cf_user',
					'Login ID Record',
					'0',
					'admin',
					GETDATE())
GO

select * from cf_label WHERE	table_name = 'cf_user' 


DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_prv_tmpl'
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, 'cf_user', 'cf_user_prv_tmpl', 
		'Privilege Template:', 
		'Privilege Template:', 
		'Privilege Template', 
		'Privilege Template', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

---2

DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_default_lang'
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, 'cf_user', 'cf_user_default_lang', 
		'Default Language:', 
		'Default Language:', 
		'Default Language', 
		'Default Language', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

---3

DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_default_site'
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, 'cf_user', 'cf_user_default_site', 
		'Default Site Code:', 
		'Default Site Code:', 
		'Default Site Code', 
		'Default Site Code', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

---4
DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_usr_ID'
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, 'cf_user', 'cf_user_usr_ID', 
		'User ID:', 
		'User ID:', 
		'User ID', 
		'User ID', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

----5

DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_pass'
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, 'cf_user', 'cf_user_pass', 
		'Password:', 
		'Password:', 
		'Password', 
		'Password', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

---6


DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_pass'
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, 'cf_user', 'cf_user_pass', 
		'Password:', 
		'Password:', 
		'Password', 
		'Password', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

select * from cf_label where table_name = 'cf_user' 

---7
DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_name'
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, 'cf_user', 'cf_user_name', 
		'Name:', 
		'Name:', 
		'Name', 
		'Name', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

---8
DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_exp_date'
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, 'cf_user', 'cf_user_exp_date', 
		'Expired Date:', 
		'Expired Date:', 
		'Expired Date', 
		'Expired Date', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

---9
DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_sys_admin'
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, 'cf_user', 'cf_user_sys_admin', 
		'System Administrator:', 
		'System Administrator:', 
		'System Administrator', 
		'System Administrator', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


---10
DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_last_pwd_changed'
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, 'cf_user', 'cf_user_last_pwd_changed', 
		'Last Password Changed:', 
		'Last Password Changed:', 
		'Last Password Changed', 
		'Last Password Changed', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO

---11
DELETE	cf_label
WHERE	table_name = 'cf_user'
AND 	column_name = 'cf_user_last_login'
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, 'cf_user', 'cf_user_last_login', 
		'Last Login:', 
		'Last Login:', 
		'Last Login', 
		'Last Login', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


