

ALTER TABLE `attendance`
	CHANGE COLUMN `emp_code` `emp_code` VARCHAR(50);
	
UPDATE proll_employee SET empcode='00036', loginname='00036@unilever.com' WHERE empcode='19600036';
UPDATE proll_employee SET empcode='00037', loginname='00037@unilever.com' WHERE empcode='19600037';
UPDATE proll_employee SET empcode='00038', loginname='00038@unilever.com' WHERE empcode='19600038';
UPDATE proll_employee SET empcode='00039', loginname='00039@unilever.com' WHERE empcode='19600039';
UPDATE proll_employee SET empcode='00040', loginname='00040@unilever.com' WHERE empcode='19600040';
UPDATE proll_employee SET empcode='00041', loginname='00041@unilever.com' WHERE empcode='19600041';
UPDATE proll_employee SET empcode='00042', loginname='00042@unilever.com' WHERE empcode='19600042';
UPDATE proll_employee SET empcode='00043', loginname='00043@unilever.com' WHERE empcode='19600043';
UPDATE proll_employee SET empcode='00044', loginname='00044@unilever.com' WHERE empcode='19600044';
UPDATE proll_employee SET empcode='00045', loginname='00045@unilever.com' WHERE empcode='19600045';
UPDATE proll_employee SET empcode='00046', loginname='00046@unilever.com' WHERE empcode='19600046';
UPDATE proll_employee SET empcode='00047', loginname='00047@unilever.com' WHERE empcode='19600047';
UPDATE proll_employee SET empcode='00048', loginname='00048@unilever.com' WHERE empcode='19600048';
UPDATE proll_employee SET empcode='00049', loginname='00049@unilever.com' WHERE empcode='19600049';
UPDATE proll_employee SET empcode='00050', loginname='00050@unilever.com' WHERE empcode='19600050';
UPDATE proll_employee SET empcode='00051', loginname='00051@unilever.com' WHERE empcode='19600051';


UPDATE proll_department_managers SET empcode='00036', email='00036@unilever.com' WHERE empcode='19600036';
UPDATE proll_department_managers SET empcode='00037', email='00037@unilever.com' WHERE empcode='19600037';
UPDATE proll_department_managers SET empcode='00038', email='00038@unilever.com' WHERE empcode='19600038';
UPDATE proll_department_managers SET empcode='00039', email='00039@unilever.com' WHERE empcode='19600039';
UPDATE proll_department_managers SET empcode='00040', email='00040@unilever.com' WHERE empcode='19600040';
UPDATE proll_department_managers SET empcode='00041', email='00041@unilever.com' WHERE empcode='19600041';
UPDATE proll_department_managers SET empcode='00042', email='00042@unilever.com' WHERE empcode='19600042';
UPDATE proll_department_managers SET empcode='00043', email='00043@unilever.com' WHERE empcode='19600043';
UPDATE proll_department_managers SET empcode='00044', email='00044@unilever.com' WHERE empcode='19600044';
UPDATE proll_department_managers SET empcode='00045', email='00045@unilever.com' WHERE empcode='19600045';
UPDATE proll_department_managers SET empcode='00046', email='00046@unilever.com' WHERE empcode='19600046';
UPDATE proll_department_managers SET empcode='00047', email='00047@unilever.com' WHERE empcode='19600047';
UPDATE proll_department_managers SET empcode='00048', email='00048@unilever.com' WHERE empcode='19600048';
UPDATE proll_department_managers SET empcode='00049', email='00049@unilever.com' WHERE empcode='19600049';
UPDATE proll_department_managers SET empcode='00050', email='00050@unilever.com' WHERE empcode='19600050';
UPDATE proll_department_managers SET empcode='00051', email='00051@unilever.com' WHERE empcode='19600051';



update attendance set emp_code='00036' where emp_code='36';
update attendance set emp_code='00037' where emp_code='37';
update attendance set emp_code='00038' where emp_code='38';
update attendance set emp_code='00039' where emp_code='39';
update attendance set emp_code='00040' where emp_code='40';
update attendance set emp_code='00041' where emp_code='41';
update attendance set emp_code='00042' where emp_code='42';
update attendance set emp_code='00043' where emp_code='43';
update attendance set emp_code='00044' where emp_code='44';
update attendance set emp_code='00045' where emp_code='45';
update attendance set emp_code='00046' where emp_code='46';
update attendance set emp_code='00047' where emp_code='47';
update attendance set emp_code='00048' where emp_code='48';
update attendance set emp_code='00049' where emp_code='49';
update attendance set emp_code='00050' where emp_code='50';
update attendance set emp_code='00051' where emp_code='51';
