INSERT INTO `user`(`serial_usr`, `serial_emp`, `serial_grd`, `serial_std`, `username_usr`, `password_usr`, `photo_usr`, `change_pass_usr`, `status_usr`) VALUES (2060,null,null,0003043,'abarnes','81dc9bdb52d04dc20036dbd8313ed055','','NO','ACTIVE');
INSERT INTO `user`(`serial_usr`, `serial_emp`, `serial_grd`, `serial_std`, `username_usr`, `password_usr`, `photo_usr`, `change_pass_usr`, `status_usr`) VALUES (2061,null,null,0003011,'dpazos','81dc9bdb52d04dc20036dbd8313ed055','','NO','ACTIVE');
INSERT INTO `user`(`serial_usr`, `serial_emp`, `serial_grd`, `serial_std`, `username_usr`, `password_usr`, `photo_usr`, `change_pass_usr`, `status_usr`) VALUES (2062,null,null,0003012,'mpazos','81dc9bdb52d04dc20036dbd8313ed055','','NO','ACTIVE');
																																																


INSERT INTO `student`(`serial_std`, `serial_fml`, `serial_ste`, `serial_usr`, `serial_nnt`, `serial_nnt2`, `id_std`, `code_std`, `first_name_std`, `last_name_std`, `birthdate_std`, `birthcity_std`, `gender_std`, `marital_status_std`, `phone_std`, `mobile_std`, `orphan_std`, `type_std`, `email_std`, `observation_std`, `status_std`, `lives_with_std`, `first_name_mother_std`, `last_name_mother_std`, `phone_mother_std`, `mobile_mother_std`, `office_phone_mother_std`, `first_name_father_std`, `last_name_father_std`, `phone_father_std`, `mobile_father_std`, `office_phone_father_std`, `previous_school_std`, `school_entrydate_std`, `exit_type`, `left_alone`, `last_time`, `check_trans`, `garantor_if_repr_isnt_pha_mat`) VALUES(0003043,0001451, null,2060,14,null,'5403693340','0003043','ALEXANDER PATRICK','BARNES','2007-07-17','SALT LAKE CITY','MALE','SINGLE','022477901','','NONE','NEW','abarnes@einstein.k12.ec',' ','ACTIVE','PARENTS','PATRICIA EROR','BARNES','022477901','','','PATRICK MICHAEL','BARNES','022477901','','023949640','',NULL,'BUS','NO','NO','YES','NO');
INSERT INTO `student`(`serial_std`, `serial_fml`, `serial_ste`, `serial_usr`, `serial_nnt`, `serial_nnt2`, `id_std`, `code_std`, `first_name_std`, `last_name_std`, `birthdate_std`, `birthcity_std`, `gender_std`, `marital_status_std`, `phone_std`, `mobile_std`, `orphan_std`, `type_std`, `email_std`, `observation_std`, `status_std`, `lives_with_std`, `first_name_mother_std`, `last_name_mother_std`, `phone_mother_std`, `mobile_mother_std`, `office_phone_mother_std`, `first_name_father_std`, `last_name_father_std`, `phone_father_std`, `mobile_father_std`, `office_phone_father_std`, `previous_school_std`, `school_entrydate_std`, `exit_type`, `left_alone`, `last_time`, `check_trans`, `garantor_if_repr_isnt_pha_mat`) VALUES(0003011,0001428, null,2061,1,null,'1727846766','0003011','DAVID JOAQUÍN','PAZOS MORENO','2012-05-11','QUITO','MALE','SINGLE','023332288','','NONE','NEW','',' ','ACTIVE','PARENTS','MARÍA BELÉN','MORENO NOBOA','023332288','0997001480','023942400','SANTIAGO MAXIMILIANO','PAZOS CARRILLO','023332288','0982969631','022991700','',NULL,'BUS','NO','NO','YES','NO');
INSERT INTO `student`(`serial_std`, `serial_fml`, `serial_ste`, `serial_usr`, `serial_nnt`, `serial_nnt2`, `id_std`, `code_std`, `first_name_std`, `last_name_std`, `birthdate_std`, `birthcity_std`, `gender_std`, `marital_status_std`, `phone_std`, `mobile_std`, `orphan_std`, `type_std`, `email_std`, `observation_std`, `status_std`, `lives_with_std`, `first_name_mother_std`, `last_name_mother_std`, `phone_mother_std`, `mobile_mother_std`, `office_phone_mother_std`, `first_name_father_std`, `last_name_father_std`, `phone_father_std`, `mobile_father_std`, `office_phone_father_std`, `previous_school_std`, `school_entrydate_std`, `exit_type`, `left_alone`, `last_time`, `check_trans`, `garantor_if_repr_isnt_pha_mat`) VALUES(0003012,0001428, null,2062,1,null,'1727846733','0003012','MARTÍN IGNACIO','PAZOS MORENO','2012-05-11','QUITO','MALE','SINGLE','023332288','','NONE','NEW','',' ','ACTIVE','PARENTS','MARÍA BELÉN','MORENO NOBOA','023332288','0997001480','023942400','SANTIAGO MAXIMILIANO','PAZOS CARRILLO','023332288','0982969631','022991700','',NULL,'BUS','NO','NO','YES','NO');


INSERT INTO  `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES (2060,3,'ACTIVE');
INSERT INTO  `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES (2061,3,'ACTIVE');
INSERT INTO  `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES (2062,3,'ACTIVE');


INSERT INTO `student_by_course`(`serial_std`, `serial_crs`, `status_stc`) VALUES(0003043,8,'ACTIVE');
INSERT INTO `student_by_course`(`serial_std`, `serial_crs`, `status_stc`) VALUES(0003011,12,'ACTIVE');
INSERT INTO `student_by_course`(`serial_std`, `serial_crs`, `status_stc`) VALUES(0003012,14,'ACTIVE');

INSERT INTO `student_guardian`(`serial_std`, `serial_grd`, `relationship_stg`, `legal_guardian_stg`, `economic_guardian_stg`, `status_stg`) VALUES(0003043,0004349,'MOTHER','NO','NO','ACTIVE');
INSERT INTO `student_guardian`(`serial_std`, `serial_grd`, `relationship_stg`, `legal_guardian_stg`, `economic_guardian_stg`, `status_stg`) VALUES(0003011,0004303,'MOTHER','YES','YES','ACTIVE');
INSERT INTO `student_guardian`(`serial_std`, `serial_grd`, `relationship_stg`, `legal_guardian_stg`, `economic_guardian_stg`, `status_stg`) VALUES(0003012,0004303,'MOTHER','YES','YES','ACTIVE');

INSERT INTO `student_guardian`(`serial_std`, `serial_grd`, `relationship_stg`, `legal_guardian_stg`, `economic_guardian_stg`, `status_stg`) VALUES(0003043,0004348,'FATHER','YES','YES','ACTIVE');
INSERT INTO `student_guardian`(`serial_std`, `serial_grd`, `relationship_stg`, `legal_guardian_stg`, `economic_guardian_stg`, `status_stg`) VALUES(0003011,0004302,'FATHER','NO','NO','ACTIVE');
INSERT INTO `student_guardian`(`serial_std`, `serial_grd`, `relationship_stg`, `legal_guardian_stg`, `economic_guardian_stg`, `status_stg`) VALUES(0003012,0004302,'FATHER','NO','NO','ACTIVE');

INSERT INTO `student_address`(`serial_std`, `serial_ste`, `serial_cnt`, `serial_par`, `serial_zne`, `main_street_sta`, `number_sta`, `secondary_street_sta`, `address_type_sta`, `phone1_sta`, `phone2_sta`, `main_address_sta`, `reference`, `status_sta`, `sector`) VALUES (0003043,19,187,1006,16,'AV. GONZÁLEZ SUÁREZ','E14-LT8','ANTONIO FLORES JIJÓN','HOME','022477901',' ','YES','EDIF. SILJA DEL 1101 FRENTE AL COL. LA INMACULADA','ACTIVE','GONZÁLEZ SUÁREZ');
INSERT INTO `student_address`(`serial_std`, `serial_ste`, `serial_cnt`, `serial_par`, `serial_zne`, `main_street_sta`, `number_sta`, `secondary_street_sta`, `address_type_sta`, `phone1_sta`, `phone2_sta`, `main_address_sta`, `reference`, `status_sta`, `sector`) VALUES (0003011,19,187,1006,16,'MANUEL SOTOMAYOR','E10-36','ANTONIO FLORES JIJÓN','HOME','023332288',' ','YES','EDF. WELCH PB DEPARTAMENTO 002, CERCA DEL CANAL 8','ACTIVE','BELLAVISTA');
INSERT INTO `student_address`(`serial_std`, `serial_ste`, `serial_cnt`, `serial_par`, `serial_zne`, `main_street_sta`, `number_sta`, `secondary_street_sta`, `address_type_sta`, `phone1_sta`, `phone2_sta`, `main_address_sta`, `reference`, `status_sta`, `sector`) VALUES (0003012,19,187,1006,16,'MANUEL SOTOMAYOR','E10-36','','HOME','023332288',' ','YES','EDF. WELCH PB DEPARTAMENTO 002, CERCA DEL CANAL 8','ACTIVE','BELLAVISTA');


INSERT INTO `student_year`(`folio_number_sty`, `matricule_number_sty`, `is_listener_sty`, `comment_sty`, `serial_std`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`, `serial_pag`, `status_sty`, `registration_type_sty`, `debts_checked_sty`, `matricule_date_sty`, `authorize_takes_pictures`, `authorize_departure_pedagogy`) VALUES(492,492,'NO','',0003043,10,4,10,3,NULL,'REGISTERED','ORDINARY','NO','2016-01-04','NO',NULL);
INSERT INTO `student_year`(`folio_number_sty`, `matricule_number_sty`, `is_listener_sty`, `comment_sty`, `serial_std`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`, `serial_pag`, `status_sty`, `registration_type_sty`, `debts_checked_sty`, `matricule_date_sty`, `authorize_takes_pictures`, `authorize_departure_pedagogy`) VALUES(107,107,'NO','',0003011,11,11,11,1,NULL,'REGISTERED','ORDINARY','NO','2015-12-10','NO',NULL);
INSERT INTO `student_year`(`folio_number_sty`, `matricule_number_sty`, `is_listener_sty`, `comment_sty`, `serial_std`, `serial_spt`, `serial_lvl`, `serial_scy`, `serial_set`, `serial_pag`, `status_sty`, `registration_type_sty`, `debts_checked_sty`, `matricule_date_sty`, `authorize_takes_pictures`, `authorize_departure_pedagogy`) VALUES(108,108,'NO','',0003012,12,11,12,1,NULL,'REGISTERED','ORDINARY','NO','2015-12-10','NO',NULL);


INSERT INTO `user` (`serial_usr`, `serial_emp`, `serial_grd`, `serial_std`, `username_usr`, `password_usr`, `photo_usr`, `change_pass_usr`, `status_usr`) VALUES(2063,NULL,0004303,NULL,'p.mmoreno','81dc9bdb52d04dc20036dbd8313ed055',NULL,'NO','ACTIVE');
INSERT INTO `user` (`serial_usr`, `serial_emp`, `serial_grd`, `serial_std`, `username_usr`, `password_usr`, `photo_usr`, `change_pass_usr`, `status_usr`) VALUES(2064,NULL,0004302,NULL,'p.spazos','81dc9bdb52d04dc20036dbd8313ed055',NULL,'NO','ACTIVE');
INSERT INTO `user` (`serial_usr`, `serial_emp`, `serial_grd`, `serial_std`, `username_usr`, `password_usr`, `photo_usr`, `change_pass_usr`, `status_usr`) VALUES(2065,NULL,0004348,NULL,'p.pbarnes','81dc9bdb52d04dc20036dbd8313ed055',NULL,'NO','ACTIVE');
INSERT INTO `user` (`serial_usr`, `serial_emp`, `serial_grd`, `serial_std`, `username_usr`, `password_usr`, `photo_usr`, `change_pass_usr`, `status_usr`) VALUES(2066,NULL,0004349,NULL,'p.pebarnes','81dc9bdb52d04dc20036dbd8313ed055',NULL,'NO','ACTIVE');

select * from guardian;
select * from user;
INSERT INTO `guardian` (`serial_grd`, `serial_usr`, `serial_emp`, `serial_nnt`, `serial_nnt2`, `serial_elg`, `serial_ocg`, `serial_dgr`, `id_grd`, `first_name_grd`, `last_name_grd`, `birthdate_grd`, `gender_grd`, `marital_status_grd`, `alumnus_grd`, `phone_grd`, `mobile_grd`, `company_name_grd`, `company_activity_grd`, `role_in_company_grd`, `time_in_job_grd`, `company_phone_grd`, `email_grd`, `email2_grd`, `email3_grd`, `lives_with_student_grd`, `allow_to_pick_student_grd`, `observation_grd`, `status_grd`, `serial_sch`, `third_level_degree_grd`, `university_third_level_grd`, `fourth_level_degree_grd`, `university_fourt_level_grd`) VALUES (0004303,2063,null,NULL,NULL,2,null,null,'','MARÍA BELÉN','MORENO NOBOA',null,'FEMALE','MARRIED','NO','023332288','0997001480','WEATHERFORD','','LIGAL CONSUL ECUADOR Y PE','','023942400','maria.moreno@la.weatherford.com','mbelenmn@yahoo.com','','YES','YES','','ACTIVE','','','','','');
INSERT INTO `guardian` (`serial_grd`, `serial_usr`, `serial_emp`, `serial_nnt`, `serial_nnt2`, `serial_elg`, `serial_ocg`, `serial_dgr`, `id_grd`, `first_name_grd`, `last_name_grd`, `birthdate_grd`, `gender_grd`, `marital_status_grd`, `alumnus_grd`, `phone_grd`, `mobile_grd`, `company_name_grd`, `company_activity_grd`, `role_in_company_grd`, `time_in_job_grd`, `company_phone_grd`, `email_grd`, `email2_grd`, `email3_grd`, `lives_with_student_grd`, `allow_to_pick_student_grd`, `observation_grd`, `status_grd`, `serial_sch`, `third_level_degree_grd`, `university_third_level_grd`, `fourth_level_degree_grd`, `university_fourt_level_grd`) VALUES (0004302,2064,null,NULL,NULL,2,null,null,'','SANTIAGO MAXIMILIANO','PAZOS CARRILLO',null,'MALE','MARRIED','NO','023332288','0982969631','PUCE','','DOCENTE INVESTIGADOR','','022991700','santiagopazoscarrillo@yahoo.com','','','YES','YES','','ACTIVE','','','','','');
INSERT INTO `guardian` (`serial_grd`, `serial_usr`, `serial_emp`, `serial_nnt`, `serial_nnt2`, `serial_elg`, `serial_ocg`, `serial_dgr`, `id_grd`, `first_name_grd`, `last_name_grd`, `birthdate_grd`, `gender_grd`, `marital_status_grd`, `alumnus_grd`, `phone_grd`, `mobile_grd`, `company_name_grd`, `company_activity_grd`, `role_in_company_grd`, `time_in_job_grd`, `company_phone_grd`, `email_grd`, `email2_grd`, `email3_grd`, `lives_with_student_grd`, `allow_to_pick_student_grd`, `observation_grd`, `status_grd`, `serial_sch`, `third_level_degree_grd`, `university_third_level_grd`, `fourth_level_degree_grd`, `university_fourt_level_grd`) VALUES (0004348,2065,null,NULL,NULL,2,null,null,'506375872','PATRICK MICHAEL','BARNES',null,'MALE','MARRIED','NO','022477901','','MINISTERIO MINERÍA','','CONSULTOR','','023949640','patrick.barnes@woodmac.com','','','YES','YES','','ACTIVE','','','','','');
INSERT INTO `guardian` (`serial_grd`, `serial_usr`, `serial_emp`, `serial_nnt`, `serial_nnt2`, `serial_elg`, `serial_ocg`, `serial_dgr`, `id_grd`, `first_name_grd`, `last_name_grd`, `birthdate_grd`, `gender_grd`, `marital_status_grd`, `alumnus_grd`, `phone_grd`, `mobile_grd`, `company_name_grd`, `company_activity_grd`, `role_in_company_grd`, `time_in_job_grd`, `company_phone_grd`, `email_grd`, `email2_grd`, `email3_grd`, `lives_with_student_grd`, `allow_to_pick_student_grd`, `observation_grd`, `status_grd`, `serial_sch`, `third_level_degree_grd`, `university_third_level_grd`, `fourth_level_degree_grd`, `university_fourt_level_grd`) VALUES (0004349,2066,null,NULL,NULL,2,null,null,'','PATRICIA EROR','BARNES',null,'FEMALE','MARRIED','NO','022477901','','','','','','','patricia.jean.barnes@gmail.com','','','YES','YES','','ACTIVE','','','','','');

INSERT INTO `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES (2063,2,'ACTIVE');
INSERT INTO `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES (2064,2,'ACTIVE');
INSERT INTO `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES (2065,2,'ACTIVE');
INSERT INTO `user_profile` (`serial_usr`, `serial_prf`, `status_upr`) VALUES (2066,2,'ACTIVE');


INSERT INTO `guardian_address` ( `serial_grd`, `serial_ste`, `serial_cnt`, `serial_par`, `serial_zne`, `main_street_gda`, `number_gda`, `secondary_street_gda`, `sector`, `address_type_gda`, `phone1_gda`, `phone2_gda`, `main_address_gda`, `coordinate_w`, `coordinate_s`, `status_gda`,`reference`) VALUES(0004303,19,187,NULL ,52,'MANUEL SOTOMAYOR','E10-36','ANTONIO FLORES JIJÓN','BELLAVISTA','HOME','023942400',' ','YES',NULL,NULL,'ACTIVE','EDF. WELCH PB DEPARTAMENTO 002, CERCA DEL CANAL 8');
INSERT INTO `guardian_address` ( `serial_grd`, `serial_ste`, `serial_cnt`, `serial_par`, `serial_zne`, `main_street_gda`, `number_gda`, `secondary_street_gda`, `sector`, `address_type_gda`, `phone1_gda`, `phone2_gda`, `main_address_gda`, `coordinate_w`, `coordinate_s`, `status_gda`,`reference`) VALUES(0004302,19,187,NULL,53,'MANUEL SOTOMAYOR','E10-36','ANTONIO FLORES JIJÓN','BELLAVISTA','HOME','022991700',' ','YES',NULL,NULL,'ACTIVE','EDF. WELCH PB DEPARTAMENTO 002, CERCA DEL CANAL 8');
INSERT INTO `guardian_address` ( `serial_grd`, `serial_ste`, `serial_cnt`, `serial_par`, `serial_zne`, `main_street_gda`, `number_gda`, `secondary_street_gda`, `sector`, `address_type_gda`, `phone1_gda`, `phone2_gda`, `main_address_gda`, `coordinate_w`, `coordinate_s`, `status_gda`,`reference`) VALUES(0004348,19,187,NULL,54,'AV. GONZÁLEZ SUÁREZ','E14-LT8','ERNESTO NOBOA CAAMAÑO','GONZÁLEZ SUÁREZ','HOME','023949640',' ','YES',NULL,NULL,'ACTIVE','EDIF. SILJA DEL 1101 FRENTE AL COL. LA INMACULADA');
INSERT INTO `guardian_address` ( `serial_grd`, `serial_ste`, `serial_cnt`, `serial_par`, `serial_zne`, `main_street_gda`, `number_gda`, `secondary_street_gda`, `sector`, `address_type_gda`, `phone1_gda`, `phone2_gda`, `main_address_gda`, `coordinate_w`, `coordinate_s`, `status_gda`,`reference`) VALUES(0004349,19,187,NULL,55,'AV. GONZÁLEZ SUÁREZ','E14-LT8','ERNESTO NOBOA CAAMAÑO','GONZÁLEZ SUÁREZ','HOME','',' ','YES',NULL,NULL,'ACTIVE','EDIF. SILJA DEL 1101 FRENTE AL COL. LA INMACULADA');

INSERT INTO `family`(`serial_fml`, `first_surname_fml`, `last_surname_fml`, `cod_group_family_exchange`, `main_street`, `secundary_street`, `number_street`, `reference`, `serial_ste`, `serial_cnt`, `serial_par`, `phone2_fml`, `phone_fml`, `status_fml`, `coordinate_w`, `coordinate_s`, `admition_register`) VALUES(1428,'PAZOS MORENO',' ','PAZOS_MORENO','MANUEL SOTOMAYOR','ANTONIO FLORES JIJÓN','E10-36','EDF. WELCH PB DEPARTAMENTO 002, CERCA DEL CANAL 8',19,188,null,' ','023332288','ACTIVE','','','0');
INSERT INTO `family`(`serial_fml`, `first_surname_fml`, `last_surname_fml`, `cod_group_family_exchange`, `main_street`, `secundary_street`, `number_street`, `reference`, `serial_ste`, `serial_cnt`, `serial_par`, `phone2_fml`, `phone_fml`, `status_fml`, `coordinate_w`, `coordinate_s`, `admition_register`) VALUES(1451,'Barnes',' ','BARNES_BARNES','AV. GONZÁLEZ SUÁREZ','ERNESTO NOBOA CAAMAÑO','E14-LT8','EDIF. SILJA DEL 1101 FRENTE AL COL. LA INMACULADA',19,188,null,' ','022477901','ACTIVE','','','0');



UPDATE `rutademicae`.`user` SET `username_usr`='p.mmoreno' WHERE `serial_usr`='2063';
UPDATE `rutademicae`.`user` SET `username_usr`='p.spazos' WHERE `serial_usr`='2064';
UPDATE `rutademicae`.`user` SET `username_usr`='p.pbarnes' WHERE `serial_usr`='2065';
UPDATE `rutademicae`.`user` SET `username_usr`='p.pebarnes' WHERE `serial_usr`='2066';