UPDATE `user` SET `username_usr`='ANCHARRO' WHERE `serial_usr`='1061';
UPDATE `user` SET `username_usr`='archarro' WHERE `serial_usr`='1529';

UPDATE `employee` SET `serial_usr`='730' WHERE `serial_emp`='200114';
DELETE FROM `user` WHERE `serial_usr`='1802';
UPDATE `user` SET `serial_emp`='200114' WHERE `serial_usr`='730';
DELETE FROM `user_profile` WHERE `serial_usr`='1802' and`serial_prf`='4';
INSERT INTO `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES ('730', '4', 'ACTIVE');

UPDATE `employee` SET `serial_usr`='1606' WHERE `serial_emp`='203586';
UPDATE `user_profile` SET `serial_usr`='1606' WHERE `serial_usr`='1872' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203586' WHERE `serial_usr`='1606';
DELETE FROM `user` WHERE `serial_usr`='1872';

UPDATE `user` SET `username_usr`='allombeida' WHERE `serial_usr`='1171';
UPDATE `user` SET `username_usr`='anlombeida' WHERE `serial_usr`='1748';

SET foreign_key_checks = 0;
DELETE FROM `user` WHERE `serial_usr`='488';
DELETE FROM `guardian` WHERE `serial_grd`='3072';
DELETE FROM `user_profile` WHERE `serial_usr`='488' and`serial_prf`='2';
SET foreign_key_checks = 1;

UPDATE `employee` SET `serial_usr`='487' WHERE `serial_emp`='203149';
UPDATE `user_profile` SET `serial_usr`='487' WHERE `serial_usr`='1811' and`serial_prf`='4';
DELETE FROM `user` WHERE `serial_usr`='1811';
UPDATE `user` SET `serial_emp`='203149' WHERE `serial_usr`='487';

UPDATE `user` SET `username_usr`='alrzonzew' WHERE `serial_usr`='1219';
UPDATE `user` SET `username_usr`='anrzonzew' WHERE `serial_usr`='1449'

UPDATE `user` SET `username_usr`='alsalazar' WHERE `serial_usr`='1350';
UPDATE `user` SET `username_usr`='ansalazar' WHERE `serial_usr`='1527';

UPDATE `employee` SET `serial_usr`='405' WHERE `serial_emp`='203280';
UPDATE `user_profile` SET `serial_usr`='405' WHERE `serial_usr`='1822' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203280' WHERE `serial_usr`='405';
DELETE FROM `user` WHERE `serial_usr`='1822';

UPDATE `employee` SET `serial_usr`='206' WHERE `serial_emp`='303041';
UPDATE `user_profile` SET `serial_usr`='206' WHERE `serial_usr`='1927' and`serial_prf`='5';
UPDATE `user` SET `serial_emp`='303041' WHERE `serial_usr`='206';
DELETE FROM `user` WHERE `serial_usr`='1927';


UPDATE `employee` SET `serial_usr`='792', `serial_grd`='3783' WHERE `serial_emp`='203542';
UPDATE `user_profile` SET `serial_usr`='792' WHERE `serial_usr`='1854' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203542' WHERE `serial_usr`='792';
DELETE FROM `user` WHERE `serial_usr`='1854';
UPDATE `guardian` SET `serial_emp`='203542' WHERE `serial_grd`='3070';

UPDATE `employee` SET `serial_usr`='437', `serial_grd`='2926' WHERE `serial_emp`='203255';
UPDATE `user_profile` SET `serial_usr`='437' WHERE `serial_usr`='1821' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203255' WHERE `serial_usr`='437';
DELETE FROM `user` WHERE `serial_usr`='1821';
UPDATE `guardian` SET `serial_emp`='203255' WHERE `serial_grd`='2926';

UPDATE `employee` SET `serial_usr`='265', `serial_grd`='2204' WHERE `serial_emp`='200122';
UPDATE `user_profile` SET `serial_usr`='265' WHERE `serial_usr`='1804' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='200122' WHERE `serial_usr`='265';
DELETE FROM `user` WHERE `serial_usr`='1804';
UPDATE `guardian` SET `serial_emp`='200122' WHERE `serial_grd`='2204';

UPDATE `employee` SET `serial_usr`='732', `serial_grd`='3682' WHERE `serial_emp`='303071';
UPDATE `user_profile` SET `serial_usr`='732' WHERE `serial_usr`='1934' and`serial_prf`='5';
UPDATE `user` SET `serial_emp`='303071' WHERE `serial_usr`='732';
DELETE FROM `user` WHERE `serial_usr`='1934';
UPDATE `guardian` SET `serial_emp`='303071' WHERE `serial_grd`='3682';

UPDATE `user` SET `username_usr`='frguerrero' WHERE `serial_usr`='1488';
UPDATE `user` SET `username_usr`='faguerrero' WHERE `serial_usr`='1787';

UPDATE `employee` SET `serial_grd`='2701' WHERE `serial_emp`='200121';
UPDATE `consolidado`.`employee` SET `serial_usr`='173' WHERE `serial_emp`='200121';
UPDATE `user_profile` SET `serial_usr`='368' WHERE `serial_usr`='1803' and`serial_prf`='4';
DELETE FROM `user` WHERE `serial_usr`='1803';
UPDATE `user` SET `serial_emp`='200121' WHERE `serial_usr`='368';
UPDATE `guardian` SET `serial_emp`='200121' WHERE `serial_grd`='2701';

UPDATE `employee` SET `serial_usr`='419', `serial_grd`='2820' WHERE `serial_emp`='201009';
UPDATE `user_profile` SET `serial_usr`='419' WHERE `serial_usr`='1806' and`serial_prf`='5';
UPDATE `user` SET `serial_emp`='201009' WHERE `serial_usr`='419';
DELETE FROM `user` WHERE `serial_usr`='1806';
UPDATE `guardian` SET `serial_emp`='201009' WHERE `serial_grd`='2820';

UPDATE `employee` SET `serial_usr`='239', `serial_grd`='2089' WHERE `serial_emp`='303046';
UPDATE `user_profile` SET `serial_usr`='239' WHERE `serial_usr`='1929' and`serial_prf`='5';
UPDATE `user` SET `serial_emp`='303046' WHERE `serial_usr`='239';
DELETE FROM `user` WHERE `serial_usr`='1929';
UPDATE `guardian` SET `serial_emp`='303046' WHERE `serial_grd`='2089';

UPDATE `user` SET `username_usr`='ssaud' WHERE `serial_usr`='1708';


UPDATE `employee` SET `serial_usr`='24', `serial_grd`='399' WHERE `serial_emp`='203172';
UPDATE `user_profile` SET `serial_usr`='24' WHERE `serial_usr`='1814' and`serial_prf`='4';
DELETE FROM `user` WHERE `serial_usr`='1814';
UPDATE `user` SET `serial_emp`='203172' WHERE `serial_usr`='24';
UPDATE `guardian` SET `serial_emp`='203172' WHERE `serial_grd`='399';

UPDATE `employee` SET `serial_usr`='466', `serial_grd`='2993' WHERE `serial_emp`='203216';
UPDATE `user_profile` SET `serial_usr`='466' WHERE `serial_usr`='1816' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203216' WHERE `serial_usr`='466';
DELETE FROM `user` WHERE `serial_usr`='1816';
UPDATE `guardian` SET `serial_emp`='203216' WHERE `serial_grd`='2993';

UPDATE `employee` SET `serial_usr`='692', `serial_grd`='3605' WHERE `serial_emp`='203458';
UPDATE `user_profile` SET `serial_usr`='692' WHERE `serial_usr`='1840' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203458' WHERE `serial_usr`='692';
DELETE FROM `user` WHERE `serial_usr`='1840';
UPDATE `guardian` SET `serial_emp`='203458' WHERE `serial_grd`='3605';


UPDATE `employee` SET `serial_usr`='733', `serial_grd`='3683' WHERE `serial_emp`='203510';
UPDATE `user_profile` SET `serial_usr`='733' WHERE `serial_usr`='1848' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203510', `photo_usr`='_MG_7360.jpg' WHERE `serial_usr`='733';
DELETE FROM `user` WHERE `serial_usr`='1848';
UPDATE `guardian` SET `serial_emp`='203510' WHERE `serial_grd`='3683';

UPDATE `employee` SET `serial_usr`='610', `serial_grd`='3411' WHERE `serial_emp`='303076';
UPDATE `user_profile` SET `serial_usr`='610' WHERE `serial_usr`='1937' and`serial_prf`='5';
UPDATE `user` SET `serial_emp`='303076' WHERE `serial_usr`='610';
DELETE FROM `user` WHERE `serial_usr`='1937';
UPDATE `guardian` SET `serial_emp`='303076' WHERE `serial_grd`='3411';

UPDATE `employee` SET `serial_usr`='268', `serial_grd`='2209' WHERE `serial_emp`='200112';
UPDATE `user_profile` SET `serial_usr`='268' WHERE `serial_usr`='1801' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='200112', `photo_usr`='_MG_5623.JPG' WHERE `serial_usr`='268';
DELETE FROM `user` WHERE `serial_usr`='1801';
UPDATE `guardian` SET `serial_emp`='200112' WHERE `serial_grd`='2209';

UPDATE `user` SET `username_usr`='mtmolina' WHERE `serial_usr`='1523';
UPDATE `user` SET `username_usr`='mrmolina' WHERE `serial_usr`='1666';

UPDATE `employee` SET `serial_usr`='226', `serial_grd`='2054' WHERE `serial_emp`='303042';
UPDATE `user_profile` SET `serial_usr`='226' WHERE `serial_usr`='1928' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='303042' WHERE `serial_usr`='226';
DELETE FROM `user` WHERE `serial_usr`='1928';
UPDATE `guardian` SET `serial_emp`='303042' WHERE `serial_grd`='2054';


UPDATE `user` SET `username_usr`='p.jfjaramillo' WHERE `serial_usr`='715';
UPDATE `user` SET `username_usr`='p.jfjaramillo' WHERE `serial_usr`='534';

UPDATE `user` SET `username_usr`='p.pfavila' WHERE `serial_usr`='154';
UPDATE `user` SET `username_usr`='p.paavila' WHERE `serial_usr`='902';

UPDATE `employee` SET `serial_usr`='793', `serial_grd`='3784' WHERE `serial_emp`='203393';
UPDATE `user_profile` SET `serial_usr`='793' WHERE `serial_usr`='1830' and`serial_prf`='4';
DELETE FROM `user` WHERE `serial_usr`='1830';
UPDATE `user` SET `serial_emp`='203393' WHERE `serial_usr`='793';
UPDATE `guardian` SET `serial_emp`='203393' WHERE `serial_grd`='3784';

UPDATE `user` SET `username_usr`='p.islguerini' WHERE `serial_usr`='366';
UPDATE `user` SET `username_usr`='p.isguerini' WHERE `serial_usr`='441';

UPDATE `user` SET `username_usr`='p.jjjaramillo' WHERE `serial_usr`='534';

UPDATE `employee` SET `serial_usr`='32', `serial_grd`='435' WHERE `serial_emp`='303063';
UPDATE `user_profile` SET `serial_usr`='32' WHERE `serial_usr`='1932' and`serial_prf`='5';
UPDATE `user` SET `serial_emp`='303063' WHERE `serial_usr`='32';
DELETE FROM `user` WHERE `serial_usr`='1932';
UPDATE `guardian` SET `serial_emp`='303063' WHERE `serial_grd`='435';

UPDATE `employee` SET `serial_usr`='20', `serial_grd`='318' WHERE `serial_emp`='203154';
UPDATE `user_profile` SET `serial_usr`='20' WHERE `serial_usr`='1812' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203154', `photo_usr`='SANDDY CALDERON.JPG' WHERE `serial_usr`='20';
DELETE FROM `user` WHERE `serial_usr`='1812';
UPDATE `guardian` SET `serial_emp`='203154' WHERE `serial_grd`='318';


UPDATE `employee` SET `serial_usr`='436', `serial_grd`='2921' WHERE `serial_emp`='203511';
UPDATE `user_profile` SET `serial_usr`='436' WHERE `serial_usr`='1849' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203511' WHERE `serial_usr`='436';
DELETE FROM `user` WHERE `serial_usr`='1849';
UPDATE `guardian` SET `serial_emp`='203511' WHERE `serial_grd`='2921';

UPDATE `user` SET `username_usr`='sasaud' WHERE `serial_usr`='1232';
UPDATE `user` SET `username_usr`='spsaud' WHERE `serial_usr`='1708';

UPDATE `employee` SET `serial_usr`='19', `serial_grd`='314' WHERE `serial_emp`='203042';
UPDATE `user_profile` SET `serial_usr`='19' WHERE `serial_usr`='1808' and`serial_prf`='4';
UPDATE `user` SET `serial_emp`='203042' WHERE `serial_usr`='19';
DELETE FROM `user` WHERE `serial_usr`='1808';
UPDATE `guardian` SET `serial_emp`='203042' WHERE `serial_grd`='314';

UPDATE `user` SET `username_usr`='tvigodaec' WHERE `serial_usr`='57';
UPDATE `user` SET `username_usr`='tvigodae' WHERE `serial_usr`='1792';








