INSERT INTO `datoparticipante` (`id_dato`, `nombre`, `apellido`, `genero`, `rfc`, `telefono`, `email`, `fecha_alta`, `tipo`, `status`) VALUES
(2322, 'Julia Rubi ', 'Sarao Corzo', 'Femenino', 'SACJ991019', '9933987918', 'julia99_princess@hotmail.com', '2018-06-08 22:48:51', 'alumno_lic', 1),
(2323, 'Patricia Yareli', 'Diaz De La Cruz', 'Femenino', 'DICP960619', '9935917453', 'pattydiaz52@gmail.com', '2018-06-08 23:01:00', 'alumno_lic', 1),
(2324, 'Jonathan ', 'Ruiz Cortez ', 'Masculino', 'RUCJ9108057t2', '9933212995', 'jonhy_cortez@hotmail.com', '2018-06-08 23:13:48', 'alumno_mtr', 1),
(2325, 'Leidy del Carmen', 'Pérez de la Cruz', 'Femenino', 'Pecl8703078a1', '9371005916', 'leidy_pc87@hotmail.com', '2018-06-08 23:55:45', 'alumno_mtr', 1),
(2326, 'Viviana', 'Carrillo Carrillo', 'Femenino', 'CACV790729N89', '9931258736', 'viv_carrillo@hotmail.com', '2018-06-09 06:14:11', 'alumno_mtr', 1),
(2327, 'Atenogenes ', 'Zapata flofes', 'Masculino', 'Zafa800506rl4', '9371261220', 'madero_118@hltmail.com', '2018-06-09 07:08:02', 'alumno_mtr', 1),
(2328, 'Cindy del Carmen ', 'González ocaña', 'Femenino', 'Gooc921127p8a', '9141234015', 'glezocz_cindy@hotmail.com', '2018-06-09 07:08:58', 'alumno_mtr', 1),
(2329, 'Atenogenes ', 'Zapata flofes', 'Masculino', 'Zafa800605rl4', '9371261220', 'madero_118@hltmail.com', '2018-06-09 07:14:52', 'alumno_mtr', 1),
(2330, 'glendys', 'ramirez', 'Femenino', 'rahg800616f50', '9371674317', 'rosarodriguez29oct2014@gmail.com', '2018-06-09 07:23:16', 'alumno_mtr', 1),
(2331, 'Jonatan ', 'Saldaña de la Cruz ', 'Masculino', 'Sacj920129ph9', '9931196225', 'jonatan_sdc@hotmail.com', '2018-06-09 07:24:41', 'alumno_mtr', 1),
(2332, 'SEBASTIANA r', 'RODRIGUEZ GONZALEZ', 'Femenino', 'ROGS700120HU9', '9371555814', 'shebita70@hotmail.com', '2018-06-09 07:30:58', 'alumno_mtr', 1),
(2333, 'MARIA DE LOS ANGELES', 'YSIDRO ISIDRO', 'Femenino', 'YIIA920102L95', '9141096725', 'gelita1992@gmail.com', '2018-06-09 07:36:33', 'alumno_mtr', 1),
(2334, 'MARIA DE LOS ANGELES', 'YSIDRO ISIDRO', 'Femenino', 'YIIA920102L95', '9141096725', 'gelita1992@gmail.com', '2018-06-09 07:36:34', 'alumno_mtr', 1),
(2335, 'Atenogenes', 'Zapata Flores ', 'Masculino', 'Zafa800605rl4', '9371261220', 'madero_118@hotmail.com', '2018-06-09 08:03:41', 'alumno_mtr', 1),
(2336, 'Angélica María ', 'Morales Domínguez', 'Femenino', 'Moda9212308r5', '9331458511', 'angelicamorales1230@hotmail.com', '2018-06-09 08:06:29', 'alumno_mtr', 1),
(2337, 'alondra de jesus ', 'betanzos hernandez', 'Femenino', 'BEHA910829', '9931373680', 'alexismarinvillamil@gmail.com', '2018-06-09 08:19:31', 'alumno_lic', 1),
(2338, 'MARIA DEL CARMEN', 'ALAMILLA DE LA ROSA', 'Femenino', 'AARC7005237L2', '9932899883', 'cande_356@hotmail.com', '2018-06-09 09:34:51', 'alumno_mtr', 1),
(2339, 'Víctor Manuel', 'Mendoza Salazar', 'Masculino', 'MESV800328KV4', '9935904956', 'vicman_0328@hotmail.com', '2018-06-09 10:57:25', 'alumno_mtr', 1),
(2340, 'FLOR ALELI', 'CHABLE REYES', 'Femenino', 'CARF880123AA9', '9361032475', 'ALHHELI8823@HOTMAIL.COM', '2018-06-09 11:08:38', 'alumno_mtr', 1),
(2341, 'MARIA DEL CARMEN', 'ALAMILLA DE LA ROSA', 'Femenino', 'AARC7005237L2', '9932899883', 'cande_356@hotmail.com', '2018-06-09 11:25:14', 'alumno_mtr', 1),
(2342, 'Jehosafat', 'Torres Burelo', 'Masculino', 'TOBJ9909115HTCRRH06', '9931880728', 'jtorres_burelo@hotmail.com', '2018-06-09 11:45:39', 'alumno_lic', 1),
(2343, 'Mayra Guadalupe', 'Jimenez Cabrera', 'Femenino', 'JICM960524', '9932350320', 'lupitahjimenes@hotmail.com', '2018-06-09 11:52:18', 'alumno_lic', 1),
(2344, 'Nancy Marina', 'Flores Cruz', 'Femenino', 'FOCN960822', '9934339712', 'nancy08010@hotmail.com', '2018-06-09 11:54:13', 'alumno_lic', 1),
(2345, 'Ana Lucia', 'Hernandez Hernandez', 'Femenino', 'HEHA911214', '9932810592', 'Ana200812_v@hotmail.com', '2018-06-09 11:55:29', 'alumno_lic', 1),
(2346, 'Yamilet Guadalupe', 'del Angel Pulido', 'Femenino', 'AEPY981209', '9932629311', 'yami-98@hotmail.com', '2018-06-09 12:36:53', 'alumno_lic', 1),
(2347, 'ROSA MARIA', 'JIMENEZ DE LOS SANTOS ', 'Femenino', 'JISR910207RE6', '9931928917', 'misteriosa_ros@hotmail.com', '2018-06-09 12:47:14', 'alumno_mtr', 1),
(2348, 'ROSA MARIA', 'JIMENEZ DE LOS SANTOS ', 'Femenino', 'JISR910207RE6', '9931928917', 'misteriosa_ros@hotmail.com', '2018-06-09 12:47:14', 'alumno_mtr', 1),
(2349, 'Itzel ', 'Reyes Ramos ', 'Femenino', 'RERI991028', '9134037736', 'itzel_reyes99@outlook.com', '2018-06-09 13:00:46', 'alumno_lic', 1),
(2350, 'Genesis Fabiola ', 'Montejo Sanchez ', 'Femenino', 'MOSG960626', '9933344179', 'julian_echavarria@hotmail.com', '2018-06-09 13:21:30', 'alumno_lic', 1),
(2351, 'Maria Victoria', 'Angulo Castro', 'Femenino', 'AUCV990509I48', '9933023801', 'victoria99angulo@gmail.com', '2018-06-09 19:21:02', '', 1),
(2352, 'PAOLA KRISTEL ', 'MENDEZ BROCA ', 'Femenino', 'MEBP980730L19', '9371408803', 'pao_mendez098@hotmail.com', '2018-06-09 23:28:14', 'alumno_lic', 1),
(2353, 'PAULA JOCABED ', 'SANCHEZ GONZALEZ ', 'Femenino', 'SAGP990605GP1', '9331222421', 'jocabed.sanz@gmail.com', '2018-06-09 23:36:11', 'alumno_lic', 1),
(2354, 'PATRICIA ', 'RODRIGUEZ DE LOS SANTOS ', 'Femenino', 'ROSP980817KD7', '9334256363', 'Paty301112@gmail.com', '2018-06-10 09:18:53', 'alumno_lic', 1),
(2355, 'LEYDY FERNANDA', 'CASTELLANOS MAY', 'Femenino', 'CAML990624', '9932317667', 'Leydy_24may@hotmail.com', '2018-06-10 11:14:57', 'alumno_lic', 1),
(2356, 'Isabel cristina', 'Lopez correa', 'Femenino', 'LOCI921014576', '9933603865', 'isabel_lopez312@hotmail.es', '2018-06-10 13:40:51', 'alumno_mtr', 1),
(2357, 'Elena Guadalupe ', 'Sánchez Chan', 'Femenino', 'SACE830603L11', '9932332207', 'cleopatra_8319@hotmail.com', '2018-06-10 16:17:19', 'alumno_lic', 1),
(2358, '', '', '', '', '', '', '2018-06-10 16:39:20', '', 1),
(2359, 'Maria Del Rosario', 'Magaña Pascual', 'Femenino', 'MAPR841022654', '9932133973', 'charito_9586@hotmail.com', '2018-06-10 20:04:40', 'alumno_mtr', 1),
(2360, 'Karina', 'Centeno Santiago', 'Femenino', 'CESK990701', '9932358024', 'centeno-baster@hotmail.com', '2018-06-10 21:29:02', 'alumno_lic', 1),
(2361, 'SARAI DEL CARMEN ', 'RODRIGUEZ VELAZQUEZ', 'Femenino', 'ROVS860724MTCDLR00', '9331369434', 'PARTY_86@HOTMAIL.COM', '2018-06-10 21:35:13', 'alumno_lic', 1),
(2362, 'Cielo Verania ', 'Díaz Vázquez ', 'Femenino', 'DIVC990802', '9931354802', 'dark.cielo1999@gmail.com', '2018-06-10 21:43:54', 'alumno_lic', 1),
(2363, 'STEYCI SCARLETT', 'RUIZ CORDOVA', 'Femenino', 'RUCS990830', '9931942988', 'STEYCI3008@GMAIL.COM', '2018-06-10 22:09:27', 'alumno_lic', 1),
(2364, 'ABIGAIL', 'JIMENEZ DAMIAN', 'Femenino', 'JIDA98919', '9934253796', 'ABIGAIL.JIMENEZ.VALLOLET@GMAIL.COM', '2018-06-10 22:15:05', 'alumno_lic', 1),
(2365, 'FATIMA KRISTHELL ', 'SOSA OLAN', 'Femenino', 'SOOF970511MTCSLT00', '9371030844', 'KRISSOSA@HOTMAIL.COM', '2018-06-10 22:23:38', 'alumno_lic', 1),
(2366, 'GISSELA AMANDA', 'WILSON MARQUEZ', 'Femenino', 'WIMG980721MTCLRS00', '9331379859', 'AMANDAWILSON-96@HOTMAIL.COM', '2018-06-10 22:36:10', 'alumno_lic', 1),
(2367, 'Danna Rebeca ', 'Velázquez Lanestoza', 'Femenino', 'MTCLNN00', '9932232520', 'dannita_990729@outlook.com', '2018-06-10 23:27:10', 'alumno_lic', 1),
(2368, 'Marlene Eudith', 'Sanchez Pozo', 'Femenino', 'SAPM930828', '9931827332', 'solesito1309@hotmail.com', '2018-06-11 07:19:52', 'ext_col_ent', 1),
(2369, 'marijose', 'gonzalez aguirre', 'Femenino', 'goam981201', '9932632132', 'madijose_99@hotmail.com', '2018-06-11 07:33:08', 'alumno_lic', 1),
(2370, 'Diana Laura', 'Garcia Vidal', 'Femenino', 'GAVD980317', '9932124595', 'dianyyvg@gmail.com', '2018-06-11 07:53:30', 'alumno_lic', 1),
(2371, 'Marlene Eudith', 'Sanchez Pozo', 'Femenino', 'SAPM930828', '9931827332', 'solesito1309@hotmail.com', '2018-06-11 07:56:54', 'alumno_lic', 1),
(2372, 'Juana Lorena', 'Mendaño Diaz ', 'Femenino', 'MEDJ98015', '9934565080', 'juanita.mendano24@gmail.com', '2018-06-11 08:23:17', 'alumno_lic', 1),
(2373, 'Diego Martin', 'Ramos Marin', 'Masculino', 'RAMD9508117G2 ', '9932208348', 'diegobondz27@outlook.com', '2018-06-11 08:28:38', 'alumno_lic', 1),
(2374, 'Daniel', 'Rodriguez Rodriguez', 'Masculino', 'RORD991029', '9131035552', 'danielrodriguez2910@hotmail.com', '2018-06-11 08:31:57', 'alumno_lic', 1),
(2375, 'Jacqueline', 'Rodriguez Garcia', 'Femenino', 'ROGJ981109', '9931296612', 'jaqui-290816@hotmail.com', '2018-06-11 08:34:06', 'alumno_lic', 1),
(2376, 'YURIANA DEL CARMEN ', 'ORTIZ CHAN', 'Femenino', 'OICY900727', '9934150836', 'kateri_nena@hotmail.com', '2018-06-11 08:34:19', 'ext_col_ent', 1),
(2377, 'Brenda', 'Vázquez Martínez', 'Femenino', 'VAMB990902', '9932410499', 'brenda2vaz@gmail.com', '2018-06-11 09:49:30', 'alumno_lic', 1),
(2378, 'Juan ', 'Hernández Landero', 'Masculino', 'HELJ980213', '9131089915', 'juan_landero98@hotmail.com', '2018-06-11 09:51:20', 'alumno_lic', 1),
(2379, 'JUAN JESUS', 'DE LA CRUZ AGUIRRE', 'Masculino', 'CUAJ981224', '9931922837', 'JUANB_2412@OUTLOOK.ES', '2018-06-11 09:54:54', 'alumno_lic', 1),
(2380, 'BRENDA ', 'CORREA RAMIREZ', 'Masculino', 'CORB980609', '9373776219', 'JUANB_2412@OUTLOOK.ES', '2018-06-11 09:58:50', 'alumno_lic', 1),
(2381, 'Sandy', 'Goméz Montejo ', 'Femenino', 'GOMS990614', '9932413146', 'sandy_01_00@houtlook.com', '2018-06-11 10:01:45', 'alumno_lic', 1),
(2382, 'Susna del Carmen ', 'Zenteno Dominguez ', 'Femenino', 'ZEDS980919', '9931101084', 'susizenteno19@gmail.com', '2018-06-11 10:30:49', 'alumno_lic', 1),
(2383, 'Susna del Carmen ', 'Zenteno Dominguez ', 'Femenino', 'ZEDS980919', '9931101084', 'susizenteno19@gmail.com', '2018-06-11 10:31:25', 'alumno_lic', 1),
(2384, 'Beatriz ', 'Martinez Jimenez', 'Femenino', 'MAJB900503', '9141302237', 'fredd.leon12@hotmail.com', '2018-06-11 11:55:08', 'alumno_lic', 1),
(2385, 'Eva Vanessa', 'Ramón  Sánchez', 'Femenino', 'RASE990919', '9933080051', 'eva_evita@hotmail.com', '2018-06-11 12:05:47', 'alumno_lic', 1),
(2386, 'Cindy Lizbeth', 'Morales Veresaluse', 'Femenino', 'MOVC99006MTCRRN06', '9931348898', 'cindyveresaluse@gmail.com', '2018-06-11 12:10:35', 'alumno_lic', 1),
(2387, 'Jonathan Guadalupe', 'Vidal Estrada', 'Masculino', 'VIEJ961112657', '9932397692', 'jonathan_oni@hotmail.com', '2018-06-11 14:49:04', 'alumno_lic', 1),
(2388, 'SANDRA ', 'VASQUEZ LUIS ', 'Femenino', 'VALS8710169T1', '9371189018', 'SANDRAVALU_16879@HOTMAIL.COM', '2018-06-11 16:12:40', 'alumno_mtr', 1),
(2389, 'Janice Iliana ', 'Perez Hernandez  ', 'Femenino', 'PEHJ981105', '9141331830', 'jani_princes98@hotmail.com', '2018-06-11 16:39:06', 'alumno_lic', 1),
(2390, 'chabelli gitzell', 'vazquez chable', 'Femenino', 'VACC981203', '9931030397', 'gitzell-14@outlook.com', '2018-06-11 19:16:32', 'alumno_lic', 1),
(2391, 'Ingrid Janet', 'Carrera López ', 'Femenino', 'CALI981224', '9933978843', 'ingriidlopez1@hotmail.com', '2018-06-11 19:35:47', 'alumno_lic', 1),
(2392, 'Deysi', 'Lara Miranda ', 'Femenino', 'LAMD990918', '9933780097', 'deymiralara@gmail.com', '2018-06-11 19:44:48', 'alumno_lic', 1),
(2393, 'karen janeth', 'margalli gonzalez', 'Femenino', 'magk990803mcsrnr00', '9171172392', 'margallikaren3@gmail.com', '2018-06-11 21:42:59', 'alumno_lic', 1),
(2394, 'Susana Fabiola', 'Cabrera Vázquez ', 'Femenino', 'CAVS820811', '9931007056', 'susan_1182@hotmail.com', '2018-06-11 22:49:07', 'alumno_lic', 1),
(2395, 'FRANCISCO JAVIER ', 'FLORES SANCHEZ', 'Masculino', 'FOSF990628', '9931357704', 'JAVIER-.F28@HOTMAIL.COM', '2018-06-12 07:59:09', 'alumno_lic', 1),
(2396, 'Liliana Cristal ', 'Hernández  Alamilla ', 'Femenino', 'HEAL980916 ', '9361214220', 'mairene1704@hotmail.com', '2018-06-12 08:05:53', 'alumno_lic', 1),
(2397, 'FIDELIO FIDELIO', 'CASTILLO ROMERO', 'Masculino', 'CARF6810104D0', '1', 'fromero@gmail.com', '2018-06-12 08:35:27', 'docente', 1),
(2398, 'FIDELIO FIDELIO', 'CASTILLO ROMERO', 'Masculino', 'CARF6810104D0', '1', 'fromero@gmail.com', '2018-06-12 08:48:48', 'alumno_lic', 1),
(2399, 'Marly Guadalupe', 'Pavón Zurita', 'Femenino', 'PAZM991006', '9932340041', 'marla__marly@hotmail.com', '2018-06-12 09:31:44', 'alumno_lic', 1),
(2400, 'Vanessa Alejandra', 'Morales Arredondo', 'Femenino', 'MOAV990811332', '9934036928', 'vanne.m29@hotmail.com', '2018-06-12 09:34:21', 'alumno_lic', 1),
(2401, 'María de los Ángeles', 'Rodríguez de la O', 'Femenino', 'ROOA970901', '9933423517', 'marla__marly@hotmail.com', '2018-06-12 09:37:50', 'alumno_lic', 1),
(2402, 'Karina Berenice', 'Camara Montiel', 'Femenino', 'CAMK971119', '9932012117', 'kari19971119@gmail.com', '2018-06-12 09:40:47', 'alumno_lic', 1),
(2403, 'maria de ls angeles ', 'rodriguez d la o ', 'Femenino', 'ROOA970901', '99212726', 'angeles555884898@hotmail.com', '2018-06-12 09:53:12', 'alumno_lic', 1),
(2404, 'Maria de los Angeles ', 'Rodriguez de la O', 'Masculino', 'ROOA970901', '9932182726', 'angeles555884898@hotmail.com', '2018-06-12 09:56:24', 'alumno_lic', 1),
(2405, 'MARIA DEL CARMEN', 'PALACIO DE LOS SANTOS', 'Femenino', 'PASC960425QV7', '9932400223', 'CARMENPALACIO_96@HOTMAIL.COM', '2018-06-12 16:26:05', 'alumno_lic', 1),
(2406, 'ROLANDO ', 'VERDEJO VIDAL', 'Masculino', 'VEVR951103', '9931014629', 'VERDEJOUZZUMAKY@OUTLOOK.COM', '2018-06-12 16:31:53', 'alumno_lic', 1),
(2407, 'Judith Elizabeth', 'Ramírez Acosta', 'Femenino', 'Raaj870927c13', '9171252564', 'jera_27@hotmail.com', '2018-06-12 16:44:57', 'alumno_mtr', 1),
(2408, 'ABEL', 'MARTÍNEZ ÁLVAREZ', 'Masculino', 'MAAA810515L19', '9365932161', 'docente_prim@hotmail.com', '2018-06-13 10:41:00', 'docente', 1),
(2409, 'imelda', 'hernandez may', 'Femenino', 'hemi860904mtcrym05', '9141114265', 'adlemi_bebe@hotmail.com', '2018-06-13 11:31:41', 'alumno_lic', 1),
(2410, 'Eduardo', 'García García', 'Masculino', 'GAGE98030501F', '9932872468', 'edu_35111@hotmail.com', '2018-06-13 12:43:14', 'alumno_lic', 1),
(2411, 'ISABEL', 'GARCÍA GARCÍA', 'Femenino', 'GAGI990907', '9931296203', 'chavelita071@gmail.com', '2018-06-13 13:36:35', 'alumno_lic', 1),
(2412, 'FANNY ESTRELLA', 'INCLÁN PÉREZ', 'Femenino', 'IAPF79116IE7', '9932019565', 'fann.inclan@hotmail.com', '2018-06-14 05:41:46', 'alumno_lic', 1),
(2413, 'FRANCISCA', 'POTENCIANO LIZCANO', 'Femenino', 'POLF581009', '9931961574', 'fpotencianoll@hotmail.com', '2018-06-14 12:57:09', 'docente', 1),
(2414, 'Delia ', 'Cornelio Arias', 'Femenino', 'coad770326762', '9321052890', 'deliacorne78@hotmai.com', '2018-06-14 19:49:06', 'docente', 1),
(2415, 'José Julián', 'JAUREGUI MOlina', 'Masculino', 'JAMJ780406TJ9', '9932082511', 'jojujamo@gmail.com', '2018-06-14 21:42:51', 'ext_col_ent', 1),
(2416, 'José Julián', 'Jáuregui Molina', 'Masculino', 'JAMJ780406TJ9', '9932082511', 'jojujamo@gmail.com', '2018-06-14 21:52:44', 'ext_taller', 1),
(2417, 'Mariela', 'Jiménez Lázaro ', 'Femenino', 'JILM881209NYA', '9331255819', 'Mariela_jl09@hotmail.com', '2018-06-15 07:55:10', 'alumno_mtr', 1),
(2418, 'Nelson Thomas', 'Guzman Alcudia', 'Masculino', 'GUAN900228', '9932423916', 'n.thomaz999@gmail.com', '2018-06-15 08:58:11', 'alumno_lic', 1),
(2419, 'Nelson Thomas', 'Guzman Alcudia', 'Masculino', 'GUAN900228', '9932423916', 'n.thomaz999@gmail.com', '2018-06-15 08:58:11', 'alumno_lic', 1),
(2420, 'Nelson Thomas', 'Guzman Alcudia', 'Masculino', 'GUAN900228', '9932423916', 'n.thomaz999@gmail.com', '2018-06-15 08:58:11', 'alumno_lic', 1),
(2421, 'Nelson Thomas', 'Guzman Alcudia', 'Masculino', 'GUAN900228', '9932423916', 'n.thomaz999@gmail.com', '2018-06-15 08:58:11', 'alumno_lic', 1),
(2422, 'Nelson Thomas', 'Guzman Alcudia', 'Masculino', 'GUAN900228', '9932423916', 'n.thomaz999@gmail.com', '2018-06-15 08:58:12', 'alumno_lic', 1),
(2423, 'Nelson Thomas', 'Guzman Alcudia', 'Masculino', 'GUAN900228', '9932423916', 'n.thomaz999@gmail.com', '2018-06-15 08:58:15', 'alumno_lic', 1),
(2424, 'Nelson Thomas', 'Guzman Alcudia', 'Masculino', 'GUAN900228', '9932423916', 'n.thomaz999@gmail.com', '2018-06-15 08:58:20', 'alumno_lic', 1),
(2425, 'laudis', 'vasconcelos hernandez', 'Femenino', 'VAHLl890830i48', '9931334169', 'laudis_vh@hotmail.com', '2018-06-15 21:40:46', 'alumno_mtr', 1),
(2426, 'GLORIA SILVIA', 'LOPEZ PEREZ', 'Femenino', 'LOPG990724', '9381303982', 'sl9555642@gmail.com', '2018-06-16 23:37:54', 'alumno_lic', 1),
(2427, 'k', 'k', 'Masculino', '512510151015', '9933608195', 'jose_roman_machin@outlook.com', '2018-06-19 16:26:12', 'alumno_mtr', 1),
(2428, 'Alma Yedid', 'Reyes Hernández ', 'Femenino', 'REHA960711', '9141398164', 'almireyes9530@gmail.com', '2018-09-17 17:52:41', 'alumno_lic', 1),
(2429, 'guadalupe', 'dominguez hernandez', 'Femenino', 'dohg731212', '9333297703', 'mariposamonarca@hotmail.com.mx', '2018-09-18 09:35:06', 'docente', 1),
(2430, 'f1', 'ca', 'Masculino', 'CARF6810104D0', '1', 'fromero@gmail.com', '2018-10-06 13:36:36', 'alumno_lic', 1),
(2431, 'FIDELIO FIDELIO', 'CASTILLO ROMERO', 'Masculino', 'CARF6810104D0', '1', 'fromero105@gmail.com', '2018-11-29 00:10:57', 'alumno_lic', 1),
(2432, 'FIDELIO FIDELIO', 'CASTILLO ROMERO', 'Masculino', 'CARF6810104D0', '1', 'a@1', '2019-04-06 09:03:44', 'alumno_mtr', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `evento`
--

CREATE TABLE `evento` (
  `id_evento` int(11) NOT NULL,
  `nombre_evento` varchar(500) NOT NULL COMMENT 'Nombre del evento',
  `tipo` varchar(45) NOT NULL COMMENT 'Alterna en Taller, Foros, Conferencia',
  `lugar` varchar(200) NOT NULL,
  `hora` varchar(20) NOT NULL,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date NOT NULL,
  `cupo` int(11) NOT NULL,
  `conteo` int(11) NOT NULL DEFAULT '0',
  `expositor` varchar(300) NOT NULL COMMENT 'Nombre de los expositores',
  `empresa` varchar(500) NOT NULL COMMENT 'Origen del expositor',
  `solo` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indica si el evento no pertence a un coloquio',
  `id_coloquio` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `costo` double NOT NULL DEFAULT '0',
  `cartel` varchar(1000) NOT NULL DEFAULT 'ninguno'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `evento_has_acceso`
--

CREATE TABLE `evento_has_acceso` (
  `id_evento` int(11) NOT NULL,
  `id_acceso` int(11) NOT NULL,
  `id_puntoAcceso` varchar(45) NOT NULL COMMENT 'concatenacion de id_evento-id_acceso'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ficha`
--

CREATE TABLE `ficha` (
  `id_ficha` int(11) NOT NULL,
  `folio` int(11) NOT NULL,
  `clave_acceso` int(11) NOT NULL,
  `cuota` double NOT NULL COMMENT 'Cuota de admicion',
  `fecha` date NOT NULL COMMENT 'Fecha de registro',
  `id_participante` int(11) NOT NULL,
  `pagado` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indica se la ficha esta pagada',
  `libro` tinyint(1) NOT NULL DEFAULT '0',
  `tipo_participante` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `ficha`
--

INSERT INTO `ficha` (`id_ficha`, `folio`, `clave_acceso`, `cuota`, `fecha`, `id_participante`, `pagado`, `libro`, `tipo_participante`) VALUES
(2531, 1, 10012, 0, '2016-06-19', 1292, 1, 0, 'alumno_lic'),
(2533, 2, 20012, 0, '2016-06-19', 1293, 1, 0, 'alumno_lic'),
(2535, 3, 30012, 0, '2016-06-19', 1294, 0, 0, 'alumno_lic'),
(2537, 4, 40012, 0, '2016-06-19', 1295, 0, 0, 'alumno_lic'),
(2539, 5, 50012, 0, '2016-06-19', 1296, 0, 0, 'alumno_lic'),
(2541, 6, 60012, 0, '2016-06-19', 1297, 0, 0, 'alumno_lic'),
(2543, 7, 70012, 0, '2016-06-19', 1298, 0, 0, 'alumno_lic'),
(2545, 8, 80012, 600, '2016-06-20', 1299, 0, 0, 'alumno_mtr'),
(2547, 9, 90012, 100, '2016-06-20', 1300, 0, 0, 'docente'),
(2549, 10, 100012, 100, '2016-06-20', 1301, 0, 0, 'docente'),
(2551, 11, 110012, 600, '2016-06-20', 1302, 0, 0, 'alumno_mtr'),
(2553, 12, 120012, 200, '2016-06-20', 1303, 0, 0, 'ext_alumno'),
(2555, 13, 130012, 200, '2016-06-20', 1304, 0, 0, 'ext_alum_otras'),
(2557, 14, 140012, 200, '2016-06-20', 1305, 0, 0, 'ext_alumno'),
(2559, 15, 150012, 800, '2016-06-21', 1306, 0, 0, 'ext_alumno'),
(2561, 16, 160012, 800, '2016-06-21', 1307, 0, 0, 'ext_alum_otras'),
(2563, 17, 170012, 800, '2016-06-21', 1308, 0, 0, 'ext_maestronormales'),
(2565, 18, 180012, 0, '2016-06-21', 1309, 0, 0, 'otro'),
(2567, 19, 190012, 0, '2016-06-21', 1310, 0, 0, 'otro'),
(2569, 20, 200012, 800, '2016-06-21', 1311, 0, 0, 'otro'),
(2571, 21, 210012, 0, '2016-06-21', 1312, 0, 0, 'alumno_lic'),
(2573, 22, 220012, 600, '2016-06-22', 1313, 1, 0, 'alumno_mtr'),
(2575, 23, 230012, 600, '2016-06-22', 1314, 1, 0, 'alumno_mtr'),
(2577, 24, 240012, 600, '2016-06-22', 1315, 1, 0, 'alumno_mtr'),
(2579, 25, 250012, 600, '2016-06-22', 1316, 1, 0, 'alumno_mtr'),
(2581, 26, 260012, 600, '2016-06-22', 1317, 0, 0, 'alumno_mtr'),
(2583, 27, 270012, 600, '2016-06-22', 1318, 1, 0, 'alumno_mtr'),
(2585, 28, 280012, 600, '2016-06-22', 1319, 1, 0, 'alumno_mtr'),
(2587, 29, 290012, 600, '2016-06-22', 1320, 1, 0, 'alumno_mtr'),
(2589, 30, 300012, 800, '2016-06-22', 1321, 0, 0, 'ext_alum_otras'),
(2591, 31, 310012, 600, '2016-06-22', 1322, 1, 0, 'alumno_mtr'),
(2593, 32, 320012, 600, '2016-06-22', 1323, 1, 0, 'alumno_mtr'),
(2595, 33, 330012, 100, '2016-06-22', 1324, 1, 0, 'docente'),
(2597, 34, 340012, 0, '2016-06-22', 1325, 0, 0, 'alumno_lic'),
(2599, 35, 350012, 0, '2016-06-22', 1326, 1, 0, 'alumno_lic'),
(2601, 36, 360012, 0, '2016-06-22', 1327, 1, 0, 'alumno_lic'),
(2603, 37, 370012, 600, '2016-06-23', 1328, 1, 0, 'alumno_mtr'),
(2605, 38, 380012, 600, '2016-06-23', 1329, 1, 0, 'alumno_mtr'),
(2607, 39, 390012, 600, '2016-06-23', 1330, 1, 0, 'alumno_mtr'),
(2609, 40, 400012, 600, '2016-06-23', 1331, 1, 0, 'alumno_mtr'),
(2611, 41, 410012, 600, '2016-06-23', 1332, 1, 0, 'alumno_mtr'),
(2613, 42, 420012, 600, '2016-06-23', 1333, 1, 0, 'alumno_mtr'),
(2615, 43, 430012, 600, '2016-06-23', 1334, 0, 0, 'alumno_mtr'),
(2617, 44, 440012, 600, '2016-06-23', 1335, 1, 0, 'alumno_mtr'),
(2619, 45, 450012, 600, '2016-06-23', 1336, 1, 0, 'alumno_mtr'),
(2621, 46, 460012, 800, '2016-06-23', 1337, 1, 0, 'ext_maestronormales'),
(2623, 47, 470012, 600, '2016-06-23', 1338, 1, 0, 'alumno_mtr'),
(2625, 48, 480012, 600, '2016-06-23', 1339, 1, 0, 'alumno_mtr'),
(2627, 49, 490012, 0, '2016-06-23', 1340, 0, 0, 'alumno_lic'),
(2629, 50, 500012, 0, '2016-06-23', 1341, 0, 0, 'alumno_lic'),
(2631, 51, 510012, 0, '2016-06-23', 1342, 0, 0, 'alumno_lic'),
(2633, 52, 520012, 600, '2016-06-23', 1343, 1, 0, 'alumno_mtr'),
(2635, 53, 530012, 600, '2016-06-23', 1344, 1, 0, 'alumno_mtr'),
(2637, 54, 540012, 800, '2016-06-23', 1345, 0, 0, 'ext_maestronormales'),
(2639, 55, 550012, 600, '2016-06-24', 1346, 1, 0, 'alumno_mtr'),
(2641, 56, 560012, 0, '2016-06-24', 1347, 0, 0, 'alumno_lic'),
(2643, 57, 570012, 600, '2016-06-24', 1348, 0, 0, 'alumno_mtr'),
(2645, 58, 580012, 600, '2016-06-24', 1349, 0, 0, 'alumno_mtr'),
(2647, 59, 590012, 0, '2016-06-24', 1350, 0, 0, 'alumno_lic'),
(2649, 60, 600012, 0, '2016-06-24', 1351, 1, 0, 'alumno_lic'),
(2651, 61, 610012, 600, '2016-06-24', 1352, 1, 0, 'alumno_mtr'),
(2653, 62, 620012, 600, '2016-06-24', 1353, 1, 0, 'alumno_mtr'),
(2655, 63, 630012, 0, '2016-06-24', 1354, 1, 0, 'alumno_lic'),
(2657, 64, 640012, 600, '2016-06-24', 1355, 1, 0, 'alumno_mtr'),
(2659, 65, 650012, 600, '2016-06-24', 1356, 1, 0, 'alumno_mtr'),
(2661, 66, 660012, 800, '2016-06-24', 1357, 0, 0, 'otro'),
(2663, 67, 670012, 600, '2016-06-24', 1358, 1, 0, 'alumno_mtr'),
(2665, 68, 680012, 600, '2016-06-24', 1359, 1, 0, 'alumno_mtr'),
(2667, 69, 690012, 0, '2016-06-24', 1360, 1, 0, 'alumno_lic'),
(2669, 70, 700012, 0, '2016-06-24', 1361, 1, 0, 'alumno_lic'),
(2671, 71, 710012, 0, '2016-06-24', 1362, 1, 0, 'alumno_lic'),
(2673, 72, 720012, 0, '2016-06-24', 1363, 1, 0, 'alumno_lic'),
(2675, 73, 730012, 600, '2016-06-24', 1364, 1, 0, 'alumno_mtr'),
(2677, 74, 740012, 0, '2016-06-24', 1365, 1, 0, 'alumno_lic'),
(2679, 75, 750012, 600, '2016-06-24', 1366, 1, 0, 'alumno_mtr'),
(2681, 76, 760012, 600, '2016-06-24', 1367, 1, 0, 'alumno_mtr'),
(2683, 77, 770012, 600, '2016-06-24', 1368, 1, 0, 'alumno_mtr'),
(2685, 78, 780012, 600, '2016-06-24', 1369, 1, 0, 'alumno_mtr'),
(2687, 79, 790012, 0, '2016-06-24', 1370, 1, 0, 'alumno_lic'),
(2689, 80, 800012, 0, '2016-06-24', 1371, 1, 0, 'alumno_lic'),
(2691, 81, 810012, 0, '2016-06-24', 1372, 1, 0, 'alumno_lic'),
(2693, 82, 820012, 0, '2016-06-24', 1373, 1, 0, 'alumno_lic'),
(2695, 83, 830012, 0, '2016-06-24', 1374, 1, 0, ''),
(2697, 84, 840012, 0, '2016-06-24', 1375, 0, 0, 'alumno_lic'),
(2699, 85, 850012, 0, '2016-06-24', 1376, 0, 0, 'alumno_lic'),
(2701, 86, 860012, 0, '2016-06-24', 1377, 1, 0, 'alumno_lic'),
(2703, 87, 870012, 0, '2016-06-24', 1378, 1, 0, 'alumno_lic'),
(2705, 88, 880012, 0, '2016-06-24', 1379, 0, 0, 'alumno_lic'),
(2707, 89, 890012, 0, '2016-06-24', 1380, 1, 0, 'alumno_lic'),
(2709, 90, 900012, 0, '2016-06-24', 1381, 1, 0, 'alumno_lic'),
(2711, 91, 910012, 0, '2016-06-24', 1382, 1, 0, 'alumno_lic'),
(2713, 92, 920012, 600, '2016-06-24', 1383, 1, 0, 'alumno_mtr'),
(2715, 93, 930012, 0, '2016-06-24', 1384, 1, 0, 'alumno_lic'),
(2717, 94, 940012, 0, '2016-06-24', 1385, 1, 0, 'alumno_lic'),
(2719, 95, 950012, 0, '2016-06-24', 1386, 1, 0, 'alumno_lic'),
(2721, 96, 960012, 0, '2016-06-24', 1387, 0, 0, 'alumno_lic'),
(2723, 97, 970012, 0, '2016-06-24', 1388, 0, 0, 'alumno_lic'),
(2725, 98, 980012, 0, '2016-06-24', 1389, 0, 0, 'alumno_lic'),
(2727, 99, 990012, 0, '2016-06-24', 1390, 1, 0, 'alumno_lic'),
(2729, 100, 1000012, 600, '2016-06-24', 1391, 1, 0, 'alumno_mtr'),
(2731, 101, 1010012, 0, '2016-06-24', 1392, 1, 0, 'alumno_lic'),
(2733, 102, 1020012, 0, '2016-06-24', 1393, 1, 0, 'alumno_lic'),
(2735, 103, 1030012, 0, '2016-06-24', 1394, 1, 0, 'alumno_lic'),
(2737, 104, 1040012, 600, '2016-06-25', 1395, 1, 0, 'alumno_mtr'),
(2739, 105, 1050012, 600, '2016-06-25', 1396, 1, 0, 'alumno_mtr'),
(2741, 106, 1060012, 600, '2016-06-25', 1397, 1, 0, 'alumno_mtr'),
(2743, 107, 1070012, 0, '2016-06-25', 1398, 1, 0, 'alumno_lic'),
(2745, 108, 1080012, 600, '2016-06-25', 1399, 1, 0, 'alumno_mtr'),
(2747, 109, 1090012, 800, '2016-06-25', 1400, 0, 0, 'otro'),
(2749, 110, 1100012, 600, '2016-06-25', 1401, 1, 0, 'alumno_mtr'),
(2751, 111, 1110012, 0, '2016-06-25', 1402, 1, 0, 'alumno_lic'),
(2753, 112, 1120012, 600, '2016-06-25', 1403, 1, 0, 'alumno_mtr'),
(2755, 113, 1130012, 0, '2016-06-25', 1404, 1, 0, 'alumno_lic'),
(2757, 114, 1140012, 600, '2016-06-25', 1405, 1, 0, 'alumno_mtr'),
(2759, 115, 1150012, 600, '2016-06-25', 1406, 1, 0, 'alumno_mtr'),
(2761, 116, 1160012, 600, '2016-06-25', 1407, 0, 0, 'alumno_mtr'),
(2763, 117, 1170012, 600, '2016-06-25', 1408, 1, 0, 'alumno_mtr'),
(2765, 118, 1180012, 600, '2016-06-25', 1409, 1, 0, 'alumno_mtr'),
(2767, 119, 1190012, 600, '2016-06-25', 1410, 1, 0, 'alumno_mtr'),
(2769, 120, 1200012, 600, '2016-06-25', 1411, 1, 0, 'alumno_mtr'),
(2771, 121, 1210012, 600, '2016-06-25', 1412, 0, 0, 'alumno_mtr'),
(2773, 122, 1220012, 600, '2016-06-25', 1413, 0, 0, 'alumno_mtr'),
(2775, 123, 1230012, 600, '2016-06-25', 1414, 0, 0, 'alumno_mtr'),
(2777, 124, 1240012, 600, '2016-06-25', 1415, 1, 0, 'alumno_mtr'),
(2779, 125, 1250012, 600, '2016-06-25', 1416, 1, 0, 'alumno_mtr'),
(2781, 126, 1260012, 600, '2016-06-25', 1417, 0, 0, 'alumno_mtr'),
(2783, 127, 1270012, 600, '2016-06-25', 1418, 0, 0, 'alumno_mtr'),
(2785, 128, 1280012, 600, '2016-06-25', 1419, 1, 0, 'alumno_mtr'),
(2787, 129, 1290012, 600, '2016-06-25', 1420, 1, 0, 'alumno_mtr'),
(2789, 130, 1300012, 600, '2016-06-25', 1421, 1, 0, 'alumno_mtr'),
(2791, 131, 1310012, 600, '2016-06-25', 1422, 1, 0, 'alumno_mtr'),
(2793, 132, 1320012, 0, '2016-06-25', 1423, 1, 0, 'alumno_lic'),
(2795, 133, 1330012, 0, '2016-06-25', 1424, 1, 0, 'alumno_lic'),
(2797, 134, 1340012, 0, '2016-06-25', 1425, 1, 0, 'alumno_lic'),
(2799, 135, 1350012, 0, '2016-06-25', 1426, 1, 0, 'alumno_lic'),
(2801, 136, 1360012, 600, '2016-06-25', 1427, 1, 0, 'alumno_mtr'),
(2803, 137, 1370012, 600, '2016-06-25', 1428, 0, 0, 'alumno_mtr'),
(2805, 138, 1380012, 600, '2016-06-25', 1429, 0, 0, 'alumno_mtr'),
(2807, 139, 1390012, 600, '2016-06-25', 1430, 1, 0, 'alumno_mtr'),
(2809, 140, 1400012, 600, '2016-06-25', 1431, 1, 0, 'alumno_mtr'),
(2811, 141, 1410012, 0, '2016-06-25', 1432, 1, 0, 'alumno_lic'),
(2813, 142, 1420012, 800, '2016-06-25', 1433, 0, 0, 'ext_maestronormales'),
(2815, 143, 1430012, 0, '2016-06-25', 1434, 1, 0, 'alumno_lic'),
(2817, 144, 1440012, 600, '2016-06-25', 1435, 1, 0, 'alumno_mtr'),
(2819, 145, 1450012, 600, '2016-06-25', 1436, 1, 0, 'alumno_mtr'),
(2821, 146, 1460012, 0, '2016-06-25', 1437, 1, 0, 'alumno_lic'),
(2823, 147, 1470012, 0, '2016-06-25', 1438, 1, 0, 'alumno_lic'),
(2825, 148, 1480012, 0, '2016-06-26', 1439, 1, 0, 'alumno_lic'),
(2827, 149, 1490012, 0, '2016-06-26', 1440, 1, 0, 'alumno_lic'),
(2829, 150, 1500012, 0, '2016-06-26', 1441, 0, 0, 'alumno_lic'),
(2831, 151, 1510012, 0, '2016-06-26', 1442, 1, 0, 'alumno_lic'),
(2833, 152, 1520012, 0, '2016-06-26', 1443, 1, 0, 'alumno_lic'),
(2835, 153, 1530012, 0, '2016-06-26', 1444, 1, 0, 'alumno_lic'),
(2837, 154, 1540012, 0, '2016-06-26', 1445, 1, 0, 'alumno_lic'),
(2839, 155, 1550012, 0, '2016-06-26', 1446, 0, 0, 'alumno_lic'),
(2841, 156, 1560012, 0, '2016-06-26', 1447, 1, 0, 'alumno_lic'),
(2843, 157, 1570012, 600, '2016-06-27', 1448, 1, 0, 'alumno_mtr'),
(2845, 158, 1580012, 0, '2016-06-27', 1449, 1, 0, 'alumno_lic'),
(2847, 159, 1590012, 0, '2016-06-27', 1450, 0, 0, 'alumno_lic'),
(2849, 160, 1600012, 0, '2016-06-27', 1451, 0, 0, 'alumno_lic'),
(2851, 161, 1610012, 600, '2016-06-27', 1452, 1, 0, 'alumno_mtr'),
(2853, 162, 1620012, 600, '2016-06-27', 1453, 1, 0, 'alumno_mtr'),
(2855, 163, 1630012, 0, '2016-06-27', 1454, 1, 0, 'alumno_lic'),
(2857, 164, 1640012, 800, '2016-06-27', 1455, 1, 0, 'ext_maestronormales'),
(2859, 165, 1650012, 600, '2016-06-27', 1456, 1, 0, 'alumno_mtr'),
(2861, 166, 1660012, 800, '2016-06-27', 1457, 1, 0, 'ext_maestronormales'),
(2863, 167, 1670012, 800, '2016-06-27', 1458, 1, 0, 'ext_maestronormales'),
(2865, 168, 1680012, 800, '2016-06-27', 1459, 0, 0, 'ext_maestronormales'),
(2867, 169, 1690012, 0, '2016-06-27', 1460, 1, 0, 'alumno_lic'),
(2869, 170, 1700012, 0, '2016-06-27', 1461, 1, 0, 'alumno_lic'),
(2871, 171, 1710012, 0, '2016-06-27', 1462, 0, 0, 'alumno_lic'),
(2873, 172, 1720012, 0, '2016-06-27', 1463, 1, 0, 'alumno_lic'),
(2875, 173, 1730012, 0, '2016-06-27', 1464, 1, 0, 'alumno_lic'),
(2877, 174, 1740012, 0, '2016-06-27', 1465, 1, 0, 'alumno_lic'),
(2879, 175, 1750012, 0, '2016-06-27', 1466, 1, 0, 'alumno_lic'),
(2881, 176, 1760012, 0, '2016-06-27', 1467, 0, 0, 'alumno_lic'),
(2883, 177, 1770012, 0, '2016-06-27', 1468, 1, 0, 'alumno_lic'),
(2885, 178, 1780012, 0, '2016-06-27', 1469, 0, 0, 'alumno_lic'),
(2887, 179, 1790012, 800, '2016-06-27', 1470, 0, 0, 'ext_alumno'),
(2889, 180, 1800012, 0, '2016-06-27', 1471, 1, 0, 'alumno_lic'),
(2891, 181, 1810012, 0, '2016-06-27', 1472, 1, 0, 'alumno_lic'),
(2893, 182, 1820012, 0, '2016-06-27', 1473, 0, 0, 'alumno_lic'),
(2895, 183, 1830012, 0, '2016-06-27', 1474, 1, 0, 'alumno_lic'),
(2897, 184, 1840012, 0, '2016-06-27', 1475, 1, 0, 'alumno_lic'),
(2899, 185, 1850012, 0, '2016-06-27', 1476, 0, 0, 'alumno_lic'),
(2901, 186, 1860012, 0, '2016-06-27', 1477, 1, 0, 'alumno_lic'),
(2903, 187, 1870012, 0, '2016-06-27', 1478, 1, 0, 'alumno_lic'),
(2905, 188, 1880012, 0, '2016-06-27', 1479, 0, 0, 'alumno_lic'),
(2907, 189, 1890012, 0, '2016-06-27', 1480, 1, 0, 'alumno_lic'),
(2909, 190, 1900012, 0, '2016-06-27', 1481, 0, 0, 'alumno_lic'),
(2911, 191, 1910012, 0, '2016-06-27', 1482, 1, 0, 'alumno_lic'),
(2913, 192, 1920012, 0, '2016-06-27', 1483, 0, 0, 'alumno_lic'),
(2915, 193, 1930012, 0, '2016-06-27', 1484, 0, 0, 'alumno_lic'),
(2917, 194, 1940012, 0, '2016-06-27', 1485, 1, 0, 'alumno_lic'),
(2919, 195, 1950012, 600, '2016-06-27', 1486, 1, 0, 'alumno_mtr'),
(2921, 196, 1960012, 0, '2016-06-27', 1487, 1, 0, 'alumno_lic'),
(2923, 197, 1970012, 0, '2016-06-27', 1488, 1, 0, 'alumno_lic'),
(2925, 198, 1980012, 600, '2016-06-27', 1489, 1, 0, 'alumno_mtr'),
(2927, 199, 1990012, 800, '2016-06-28', 1490, 0, 0, 'ext_maestronormales'),
(2929, 200, 2000012, 600, '2016-06-28', 1491, 1, 0, 'alumno_mtr'),
(2931, 201, 2010012, 0, '2016-06-28', 1492, 1, 0, 'alumno_lic'),
(2933, 202, 2020012, 0, '2016-06-28', 1493, 1, 0, 'alumno_lic'),
(2935, 203, 2030012, 0, '2016-06-28', 1494, 1, 0, 'alumno_lic'),
(2937, 204, 2040012, 600, '2016-06-28', 1495, 1, 0, 'alumno_mtr'),
(2939, 205, 2050012, 0, '2016-06-28', 1496, 0, 0, 'alumno_lic'),
(2941, 206, 2060012, 0, '2016-06-28', 1497, 0, 0, 'alumno_lic'),
(2943, 207, 2070012, 0, '2016-06-28', 1498, 0, 0, 'alumno_lic'),
(2945, 208, 2080012, 0, '2016-06-28', 1499, 1, 0, 'alumno_lic'),
(2947, 209, 2090012, 0, '2016-06-28', 1500, 0, 0, 'alumno_lic'),
(2949, 210, 2100012, 0, '2016-06-28', 1501, 1, 0, 'alumno_lic'),
(2951, 211, 2110012, 0, '2016-06-28', 1502, 0, 0, 'alumno_lic'),
(2953, 212, 2120012, 0, '2016-06-28', 1503, 1, 0, 'alumno_lic'),
(2955, 213, 2130012, 0, '2016-06-28', 1504, 1, 0, 'alumno_lic'),
(2957, 214, 2140012, 600, '2016-06-28', 1505, 1, 0, 'alumno_mtr'),
(2959, 215, 2150012, 0, '2016-06-28', 1506, 1, 0, 'alumno_lic'),
(2961, 216, 2160012, 0, '2016-06-28', 1507, 1, 0, 'alumno_lic'),
(2963, 217, 2170012, 100, '2016-06-28', 1508, 1, 0, 'docente'),
(2965, 218, 2180012, 0, '2016-06-28', 1509, 1, 0, 'alumno_lic'),
(2967, 219, 2190012, 0, '2016-06-28', 1510, 0, 0, 'alumno_lic'),
(2969, 220, 2200012, 0, '2016-06-28', 1511, 1, 0, 'alumno_lic'),
(2971, 221, 2210012, 0, '2016-06-28', 1512, 1, 0, 'alumno_lic'),
(2973, 222, 2220012, 0, '2016-06-28', 1513, 1, 0, 'alumno_lic'),
(2975, 223, 2230012, 0, '2016-06-28', 1514, 1, 0, 'alumno_lic'),
(2977, 224, 2240012, 600, '2016-06-28', 1515, 1, 0, 'alumno_mtr'),
(2979, 225, 2250012, 0, '2016-06-28', 1516, 1, 0, 'alumno_lic'),
(2981, 226, 2260012, 0, '2016-06-28', 1517, 0, 0, 'alumno_lic'),
(2983, 227, 2270012, 600, '2016-06-28', 1518, 0, 0, 'alumno_mtr'),
(2985, 228, 2280012, 0, '2016-06-28', 1519, 1, 0, 'alumno_lic'),
(2987, 229, 2290012, 0, '2016-06-28', 1520, 1, 0, 'alumno_lic'),
(2989, 230, 2300012, 0, '2016-06-28', 1521, 1, 0, 'alumno_lic'),
(2991, 231, 2310012, 600, '2016-06-28', 1522, 1, 0, 'alumno_mtr'),
(2993, 232, 2320012, 0, '2016-06-28', 1523, 0, 0, 'alumno_lic'),
(2995, 233, 2330012, 0, '2016-06-28', 1524, 1, 0, 'alumno_lic'),
(2997, 234, 2340012, 600, '2016-06-28', 1525, 1, 0, 'alumno_mtr'),
(2999, 235, 2350012, 600, '2016-06-28', 1526, 1, 0, 'alumno_mtr'),
(3001, 236, 2360012, 0, '2016-06-28', 1527, 0, 0, 'alumno_lic'),
(3003, 237, 2370012, 600, '2016-06-28', 1528, 1, 0, 'alumno_mtr'),
(3005, 238, 2380012, 100, '2016-06-28', 1529, 0, 0, 'docente'),
(3007, 239, 2390012, 0, '2016-06-28', 1530, 1, 0, 'alumno_lic'),
(3009, 240, 2400012, 800, '2016-06-28', 1531, 1, 0, 'otro'),
(3011, 241, 2410012, 0, '2016-06-28', 1532, 1, 0, 'alumno_lic'),
(3013, 242, 2420012, 0, '2016-06-28', 1533, 1, 0, 'alumno_lic'),
(3015, 243, 2430012, 600, '2016-06-29', 1534, 1, 0, 'alumno_mtr'),
(3017, 244, 2440012, 800, '2016-06-29', 1535, 0, 0, 'otro'),
(3019, 245, 2450012, 600, '2016-06-29', 1536, 1, 0, 'alumno_mtr'),
(3021, 246, 2460012, 600, '2016-06-29', 1537, 0, 0, 'alumno_mtr'),
(3023, 247, 2470012, 600, '2016-06-29', 1538, 1, 0, 'alumno_mtr'),
(3025, 248, 2480012, 600, '2016-06-29', 1539, 1, 0, 'alumno_mtr'),
(3027, 249, 2490012, 600, '2016-06-29', 1540, 0, 0, 'alumno_mtr'),
(3029, 250, 2500012, 0, '2016-06-29', 1541, 1, 0, 'alumno_lic'),
(3031, 251, 2510012, 800, '2016-06-29', 1542, 0, 0, 'ext_alumno'),
(3033, 252, 2520012, 0, '2016-06-29', 1543, 1, 0, 'alumno_lic'),
(3035, 253, 2530012, 0, '2016-06-29', 1544, 0, 0, 'alumno_lic'),
(3037, 254, 2540012, 0, '2016-06-29', 1545, 1, 0, 'alumno_lic'),
(3039, 255, 2550012, 800, '2016-06-29', 1546, 0, 0, 'ext_alum_otras'),
(3041, 256, 2560012, 600, '2016-06-29', 1547, 1, 0, 'alumno_mtr'),
(3043, 257, 2570012, 600, '2016-06-29', 1548, 1, 0, 'alumno_mtr'),
(3045, 258, 2580012, 600, '2016-06-29', 1549, 1, 0, 'alumno_mtr'),
(3047, 259, 2590012, 0, '2016-06-29', 1550, 0, 0, 'alumno_lic'),
(3049, 260, 2600012, 100, '2016-06-29', 1551, 1, 0, 'docente'),
(3051, 261, 2610012, 600, '2016-06-29', 1552, 1, 0, 'alumno_mtr'),
(3053, 262, 2620012, 0, '2016-06-29', 1553, 1, 0, 'alumno_lic'),
(3055, 263, 2630012, 600, '2016-06-29', 1554, 1, 0, 'alumno_mtr'),
(3057, 264, 2640012, 0, '2016-06-29', 1555, 0, 0, 'alumno_lic'),
(3059, 265, 2650012, 0, '2016-06-29', 1556, 1, 0, 'alumno_lic'),
(3061, 266, 2660012, 0, '2016-06-29', 1557, 1, 0, 'alumno_lic'),
(3063, 267, 2670012, 0, '2016-06-29', 1558, 1, 0, 'alumno_lic'),
(3065, 268, 2680012, 0, '2016-06-29', 1559, 1, 0, 'alumno_lic'),
(3067, 269, 2690012, 0, '2016-06-29', 1560, 0, 0, 'alumno_lic'),
(3069, 270, 2700012, 0, '2016-06-29', 1561, 1, 0, 'alumno_lic'),
(3071, 271, 2710012, 0, '2016-06-29', 1562, 0, 0, 'alumno_lic'),
(3073, 272, 2720012, 0, '2016-06-29', 1563, 1, 0, 'alumno_lic'),
(3075, 273, 2730012, 0, '2016-06-29', 1564, 1, 0, 'alumno_lic'),
(3077, 274, 2740012, 0, '2016-06-29', 1565, 1, 0, 'alumno_lic'),
(3079, 275, 2750012, 0, '2016-06-29', 1566, 1, 0, 'alumno_lic'),
(3081, 276, 2760012, 0, '2016-06-29', 1567, 1, 0, 'alumno_lic'),
(3083, 277, 2770012, 0, '2016-06-29', 1568, 1, 0, 'alumno_lic'),
(3085, 278, 2780012, 0, '2016-06-29', 1569, 1, 0, 'alumno_lic'),
(3087, 279, 2790012, 0, '2016-06-29', 1570, 1, 0, 'alumno_lic'),
(3089, 280, 2800012, 0, '2016-06-29', 1571, 1, 0, 'alumno_lic'),
(3091, 281, 2810012, 0, '2016-06-29', 1572, 1, 0, 'alumno_lic'),
(3093, 282, 2820012, 0, '2016-06-29', 1573, 1, 0, 'alumno_lic'),
(3095, 283, 2830012, 0, '2016-06-29', 1574, 1, 0, 'alumno_lic'),
(3097, 284, 2840012, 0, '2016-06-29', 1575, 1, 0, 'alumno_lic'),
(3099, 285, 2850012, 0, '2016-06-29', 1576, 0, 0, 'alumno_lic'),
(3101, 286, 2860012, 0, '2016-06-29', 1577, 0, 0, 'alumno_lic'),
(3103, 287, 2870012, 0, '2016-06-29', 1578, 1, 0, 'alumno_lic'),
(3105, 288, 2880012, 0, '2016-06-29', 1579, 1, 0, 'alumno_lic'),
(3107, 289, 2890012, 600, '2016-06-29', 1580, 1, 0, 'alumno_mtr'),
(3109, 290, 2900012, 600, '2016-06-29', 1581, 0, 0, 'alumno_mtr'),
(3111, 291, 2910012, 600, '2016-06-29', 1582, 0, 0, 'alumno_mtr'),
(3113, 292, 2920012, 0, '2016-06-29', 1583, 1, 0, 'alumno_lic'),
(3115, 293, 2930012, 600, '2016-06-29', 1584, 0, 0, 'alumno_mtr'),
(3117, 294, 2940012, 600, '2016-06-29', 1585, 0, 0, 'alumno_mtr'),
(3119, 295, 2950012, 600, '2016-06-29', 1586, 1, 0, 'alumno_mtr'),
(3121, 296, 2960012, 0, '2016-06-29', 1587, 0, 0, 'alumno_lic'),
(3123, 297, 2970012, 0, '2016-06-29', 1588, 1, 0, 'alumno_lic'),
(3125, 298, 2980012, 600, '2016-06-29', 1589, 1, 0, 'alumno_mtr'),
(3127, 299, 2990012, 600, '2016-06-29', 1590, 1, 0, 'alumno_mtr'),
(3129, 300, 3000012, 600, '2016-06-30', 1591, 1, 0, 'alumno_mtr'),
(3131, 301, 3010012, 0, '2016-06-30', 1592, 0, 0, 'alumno_lic'),
(3133, 302, 3020012, 0, '2016-06-30', 1593, 1, 0, 'alumno_lic'),
(3135, 303, 3030012, 600, '2016-06-30', 1594, 1, 0, 'alumno_mtr'),
(3137, 304, 3040012, 600, '2016-06-30', 1595, 1, 0, 'alumno_mtr'),
(3139, 305, 3050012, 800, '2016-06-30', 1596, 0, 0, 'ext_alumno'),
(3141, 306, 3060012, 0, '2016-06-30', 1597, 0, 0, 'alumno_lic'),
(3143, 307, 3070012, 600, '2016-06-30', 1598, 1, 0, 'alumno_mtr'),
(3145, 308, 3080012, 0, '2016-06-30', 1599, 0, 0, 'alumno_lic'),
(3147, 309, 3090012, 0, '2016-06-30', 1600, 1, 0, 'alumno_lic'),
(3149, 310, 3100012, 0, '2016-06-30', 1601, 1, 0, 'alumno_lic'),
(3151, 311, 3110012, 600, '2016-06-30', 1602, 1, 0, 'alumno_mtr'),
(3153, 312, 3120012, 0, '2016-06-30', 1603, 1, 0, 'alumno_lic'),
(3155, 313, 3130012, 600, '2016-06-30', 1604, 1, 0, 'alumno_mtr'),
(3157, 314, 3140012, 0, '2016-06-30', 1605, 0, 0, 'alumno_lic'),
(3159, 315, 3150012, 600, '2016-06-30', 1606, 1, 0, 'alumno_mtr'),
(3161, 316, 3160012, 600, '2016-06-30', 1607, 1, 0, 'alumno_mtr'),
(3163, 317, 3170012, 0, '2016-06-30', 1608, 1, 0, 'alumno_lic'),
(3165, 318, 3180012, 0, '2016-06-30', 1609, 1, 0, 'alumno_lic'),
(3167, 319, 3190012, 0, '2016-06-30', 1610, 1, 0, 'alumno_lic'),
(3169, 320, 3200012, 600, '2016-06-30', 1611, 0, 0, 'alumno_mtr'),
(3171, 321, 3210012, 600, '2016-06-30', 1612, 1, 0, 'alumno_mtr'),
(3173, 322, 3220012, 0, '2016-06-30', 1613, 0, 0, 'alumno_lic'),
(3175, 323, 3230012, 0, '2016-06-30', 1614, 1, 0, 'alumno_lic'),
(3177, 324, 3240012, 600, '2016-06-30', 1615, 0, 0, 'alumno_mtr'),
(3179, 325, 3250012, 600, '2016-06-30', 1616, 0, 0, 'alumno_mtr'),
(3181, 326, 3260012, 600, '2016-06-30', 1617, 1, 0, 'alumno_mtr'),
(3183, 327, 3270012, 600, '2016-06-30', 1618, 1, 0, 'alumno_mtr'),
(3185, 328, 3280012, 600, '2016-06-30', 1619, 0, 0, 'alumno_mtr'),
(3187, 329, 3290012, 600, '2016-06-30', 1620, 0, 0, 'alumno_mtr'),
(3189, 330, 3300012, 600, '2016-06-30', 1621, 1, 0, 'alumno_mtr'),
(3191, 331, 3310012, 600, '2016-06-30', 1622, 1, 0, 'alumno_mtr'),
(3193, 332, 3320012, 0, '2016-06-30', 1623, 1, 0, 'alumno_lic'),
(3195, 333, 3330012, 0, '2016-06-30', 1624, 1, 0, 'alumno_lic'),
(3197, 334, 3340012, 0, '2016-06-30', 1625, 1, 0, 'alumno_lic'),
(3199, 335, 3350012, 0, '2016-06-30', 1626, 1, 0, 'alumno_lic'),
(3201, 336, 3360012, 0, '2016-06-30', 1627, 0, 0, 'alumno_lic'),
(3203, 337, 3370012, 600, '2016-06-30', 1628, 1, 0, 'alumno_mtr'),
(3205, 338, 3380012, 600, '2016-06-30', 1629, 1, 0, 'alumno_mtr'),
(3207, 339, 3390012, 0, '2016-06-30', 1630, 1, 0, 'alumno_lic'),
(3209, 340, 3400012, 0, '2016-06-30', 1631, 1, 0, 'alumno_lic'),
(3211, 341, 3410012, 600, '2016-06-30', 1632, 1, 0, 'alumno_mtr'),
(3213, 342, 3420012, 0, '2016-06-30', 1633, 0, 0, 'alumno_lic'),
(3215, 343, 3430012, 0, '2016-06-30', 1634, 0, 0, 'alumno_lic'),
(3217, 344, 3440012, 0, '2016-06-30', 1635, 0, 0, 'alumno_lic'),
(3219, 345, 3450012, 0, '2016-06-30', 1636, 0, 0, 'alumno_lic'),
(3221, 346, 3460012, 0, '2016-06-30', 1637, 0, 0, 'alumno_lic'),
(3223, 347, 3470012, 0, '2016-06-30', 1638, 1, 0, 'alumno_lic'),
(3225, 348, 3480012, 600, '2016-06-30', 1639, 1, 0, 'alumno_mtr'),
(3227, 349, 3490012, 800, '2016-06-30', 1640, 0, 0, 'ext_alumno'),
(3229, 350, 3500012, 800, '2016-06-30', 1641, 0, 0, 'ext_alum_otras'),
(3231, 351, 3510012, 800, '2016-06-30', 1642, 0, 0, 'ext_maestronormales'),
(3233, 352, 3520012, 800, '2016-06-30', 1643, 0, 0, 'otro'),
(3235, 353, 3530012, 0, '2016-06-30', 1644, 1, 0, 'alumno_lic'),
(3237, 354, 3540012, 800, '2016-06-30', 1645, 0, 0, 'otro'),
(3239, 355, 3550012, 0, '2016-06-30', 1646, 0, 0, 'alumno_lic'),
(3241, 356, 3560012, 600, '2016-06-30', 1647, 0, 0, 'alumno_mtr'),
(3243, 357, 3570012, 100, '2016-06-30', 1648, 0, 0, 'docente'),
(3245, 358, 3580012, 0, '2016-06-30', 1649, 1, 0, 'alumno_lic'),
(3247, 359, 3590012, 0, '2016-06-30', 1650, 0, 0, 'alumno_lic'),
(3249, 360, 3600012, 0, '2016-06-30', 1651, 1, 0, 'alumno_lic'),
(3251, 361, 3610012, 0, '2016-06-30', 1652, 1, 0, 'alumno_lic'),
(3253, 362, 3620012, 0, '2016-06-30', 1653, 1, 0, 'alumno_lic'),
(3255, 363, 3630012, 600, '2016-06-30', 1654, 0, 0, 'alumno_mtr'),
(3257, 364, 3640012, 600, '2016-06-30', 1655, 1, 0, 'alumno_mtr'),
(3259, 365, 3650012, 0, '2016-06-30', 1656, 0, 0, 'alumno_lic'),
(3261, 366, 3660012, 800, '2016-06-30', 1657, 0, 0, 'ext_alumno'),
(3263, 367, 3670012, 0, '2016-06-30', 1658, 0, 0, 'alumno_lic'),
(3265, 368, 3680012, 0, '2016-06-30', 1659, 1, 0, 'alumno_lic'),
(3267, 369, 3690012, 0, '2016-06-30', 1660, 1, 0, 'alumno_lic'),
(3269, 370, 3700012, 0, '2016-06-30', 1661, 1, 0, 'alumno_lic'),
(3271, 371, 3710012, 0, '2016-06-30', 1662, 1, 0, 'alumno_lic'),
(3273, 372, 3720012, 0, '2016-06-30', 1663, 1, 0, 'alumno_lic'),
(3275, 373, 3730012, 600, '2016-06-30', 1664, 1, 0, 'alumno_mtr'),
(3277, 374, 3740012, 0, '2016-06-30', 1665, 0, 0, 'alumno_lic'),
(3279, 375, 3750012, 600, '2016-06-30', 1666, 1, 0, 'alumno_mtr'),
(3281, 376, 3760012, 0, '2016-06-30', 1667, 1, 0, 'alumno_lic'),
(3283, 377, 3770012, 0, '2016-06-30', 1668, 1, 0, 'alumno_lic'),
(3285, 378, 3780012, 0, '2016-06-30', 1669, 1, 0, 'alumno_lic'),
(3287, 379, 3790012, 800, '2016-06-30', 1670, 0, 0, 'ext_alum_otras'),
(3289, 380, 3800012, 0, '2016-06-30', 1671, 1, 0, 'alumno_lic'),
(3291, 381, 3810012, 800, '2016-06-30', 1672, 0, 0, 'ext_alum_otras'),
(3293, 382, 3820012, 0, '2016-06-30', 1673, 1, 0, 'alumno_lic'),
(3295, 383, 3830012, 800, '2016-06-30', 1674, 0, 0, 'ext_maestronormales'),
(3297, 384, 3840012, 800, '2016-06-30', 1675, 1, 0, 'ext_maestronormales'),
(3299, 385, 3850012, 600, '2016-06-30', 1676, 1, 0, 'alumno_mtr'),
(3301, 386, 3860012, 800, '2016-06-30', 1677, 1, 0, 'ext_alumno'),
(3303, 387, 3870012, 0, '2016-06-30', 1678, 1, 0, 'alumno_lic'),
(3305, 388, 3880012, 600, '2016-06-30', 1679, 1, 0, 'alumno_mtr'),
(3307, 389, 3890012, 600, '2016-06-30', 1680, 1, 0, 'alumno_mtr'),
(3309, 390, 3900012, 600, '2016-06-30', 1681, 1, 0, 'alumno_mtr'),
(3311, 391, 3910012, 0, '2016-06-30', 1682, 0, 0, 'alumno_lic'),
(3313, 392, 3920012, 600, '2016-06-30', 1683, 1, 0, 'alumno_mtr'),
(3315, 393, 3930012, 0, '2016-06-30', 1684, 1, 0, 'alumno_lic'),
(3317, 394, 3940012, 800, '2016-06-30', 1685, 0, 0, 'ext_alum_otras'),
(3319, 395, 3950012, 0, '2016-06-30', 1686, 1, 0, 'alumno_lic'),
(3321, 396, 3960012, 0, '2016-06-30', 1687, 1, 0, 'alumno_lic'),
(3323, 397, 3970012, 600, '2016-06-30', 1688, 0, 0, 'alumno_mtr'),
(3325, 398, 3980012, 600, '2016-06-30', 1689, 0, 0, 'alumno_mtr'),
(3327, 399, 3990012, 600, '2016-06-30', 1690, 1, 0, 'alumno_mtr'),
(3329, 400, 4000012, 600, '2016-06-30', 1691, 1, 0, 'alumno_mtr'),
(3331, 401, 4010012, 600, '2016-06-30', 1692, 1, 0, 'alumno_mtr'),
(3333, 402, 4020012, 0, '2016-06-30', 1693, 0, 0, 'alumno_lic'),
(3335, 403, 4030012, 0, '2016-06-30', 1694, 1, 0, 'alumno_lic'),
(3337, 404, 4040012, 0, '2016-06-30', 1695, 1, 0, 'alumno_lic'),
(3339, 405, 4050012, 600, '2016-06-30', 1696, 0, 0, 'alumno_mtr'),
(3341, 406, 4060012, 600, '2016-06-30', 1697, 1, 0, 'alumno_mtr'),
(3343, 407, 4070012, 0, '2016-06-30', 1698, 1, 0, 'alumno_lic'),
(3345, 408, 4080012, 600, '2016-06-30', 1699, 1, 0, 'alumno_mtr'),
(3347, 409, 4090012, 0, '2016-06-30', 1700, 0, 0, ''),
(3349, 410, 4100012, 0, '2016-06-30', 1701, 0, 0, 'alumno_lic'),
(3351, 411, 4110012, 0, '2016-06-30', 1702, 0, 0, 'alumno_lic'),
(3353, 412, 4120012, 0, '2016-06-30', 1703, 1, 0, 'alumno_lic'),
(3355, 413, 4130012, 0, '2016-06-30', 1704, 1, 0, 'alumno_lic'),
(3357, 414, 4140012, 0, '2016-06-30', 1705, 1, 0, 'alumno_lic'),
(3359, 415, 4150012, 600, '2016-06-30', 1706, 1, 0, 'alumno_mtr'),
(3361, 416, 4160012, 0, '2016-06-30', 1707, 1, 0, 'alumno_lic'),
(3363, 417, 4170012, 800, '2016-06-30', 1708, 0, 0, 'ext_alumno'),
(3365, 418, 4180012, 800, '2016-07-01', 1709, 0, 0, 'ext_alumno'),
(3367, 419, 4190012, 0, '2016-07-01', 1710, 1, 0, 'alumno_lic'),
(3369, 420, 4200012, 600, '2016-07-01', 1711, 1, 0, 'alumno_mtr'),
(3371, 421, 4210012, 0, '2016-07-01', 1712, 1, 0, 'alumno_lic'),
(3373, 422, 4220012, 0, '2016-07-01', 1713, 1, 0, 'alumno_lic'),
(3375, 423, 4230012, 0, '2016-07-01', 1714, 0, 0, 'alumno_lic'),
(3377, 424, 4240012, 0, '2016-07-01', 1715, 0, 0, 'alumno_lic'),
(3379, 425, 4250012, 0, '2016-07-01', 1716, 1, 0, 'alumno_lic'),
(3381, 426, 4260012, 0, '2016-07-01', 1717, 1, 0, 'alumno_lic'),
(3383, 427, 4270012, 800, '2016-07-01', 1718, 1, 0, 'ext_alumno'),
(3385, 428, 4280012, 600, '2016-07-01', 1719, 1, 0, 'alumno_mtr'),
(3387, 429, 4290012, 0, '2016-07-01', 1720, 0, 0, 'alumno_lic'),
(3389, 430, 4300012, 0, '2016-07-01', 1721, 0, 0, 'alumno_lic'),
(3391, 431, 4310012, 0, '2016-07-01', 1722, 1, 0, 'alumno_lic'),
(3393, 432, 4320012, 0, '2016-07-01', 1723, 1, 0, 'alumno_lic'),
(3395, 433, 4330012, 0, '2016-07-01', 1724, 1, 0, 'alumno_lic'),
(3397, 434, 4340012, 0, '2016-07-01', 1725, 0, 0, 'alumno_lic'),
(3399, 435, 4350012, 0, '2016-07-01', 1726, 1, 0, 'alumno_lic'),
(3401, 436, 4360012, 600, '2016-07-01', 1727, 1, 0, 'alumno_mtr'),
(3403, 437, 4370012, 600, '2016-07-01', 1728, 0, 0, 'alumno_mtr'),
(3405, 438, 4380012, 600, '2016-07-01', 1729, 1, 0, 'alumno_mtr'),
(3407, 439, 4390012, 0, '2016-07-01', 1730, 1, 0, 'alumno_lic'),
(3409, 440, 4400012, 0, '2016-07-01', 1731, 1, 0, 'alumno_lic'),
(3411, 441, 4410012, 600, '2016-07-01', 1732, 1, 0, 'alumno_mtr'),
(3413, 442, 4420012, 0, '2016-07-01', 1733, 0, 0, 'alumno_lic'),
(3415, 443, 4430012, 600, '2016-07-01', 1734, 0, 0, 'alumno_mtr'),
(3417, 444, 4440012, 0, '2016-07-01', 1735, 1, 0, 'alumno_lic'),
(3419, 445, 4450012, 600, '2016-07-01', 1736, 1, 0, 'alumno_mtr'),
(3421, 446, 4460012, 800, '2016-07-01', 1737, 1, 0, 'ext_maestronormales'),
(3423, 447, 4470012, 600, '2016-07-01', 1738, 1, 0, 'alumno_mtr'),
(3425, 448, 4480012, 600, '2016-07-01', 1739, 1, 0, 'alumno_mtr'),
(3427, 449, 4490012, 600, '2016-07-01', 1740, 1, 0, 'alumno_mtr'),
(3429, 450, 4500012, 600, '2016-07-01', 1741, 1, 0, 'alumno_mtr'),
(3431, 451, 4510012, 0, '2016-07-01', 1742, 0, 0, 'alumno_lic'),
(3433, 452, 4520012, 0, '2016-07-01', 1743, 0, 0, 'alumno_lic'),
(3435, 453, 4530012, 0, '2016-07-01', 1744, 0, 0, 'alumno_lic'),
(3437, 454, 4540012, 100, '2016-07-01', 1745, 1, 0, 'docente'),
(3439, 455, 4550012, 0, '2016-07-01', 1746, 0, 0, 'alumno_lic'),
(3441, 456, 4560012, 0, '2016-07-01', 1747, 0, 0, 'alumno_lic'),
(3443, 457, 4570012, 0, '2016-07-01', 1748, 0, 0, 'alumno_lic'),
(3445, 458, 4580012, 0, '2016-07-01', 1749, 0, 0, 'alumno_lic'),
(3447, 459, 4590012, 0, '2016-07-01', 1750, 1, 0, 'alumno_lic'),
(3449, 460, 4600012, 0, '2016-07-01', 1751, 1, 0, 'alumno_lic'),
(3451, 461, 4610012, 0, '2016-07-01', 1752, 1, 0, 'alumno_lic'),
(3453, 462, 4620012, 0, '2016-07-01', 1753, 0, 0, 'alumno_lic'),
(3455, 463, 4630012, 0, '2016-07-01', 1754, 0, 0, 'alumno_lic'),
(3457, 464, 4640012, 100, '2016-07-01', 1755, 1, 0, 'docente'),
(3459, 465, 4650012, 0, '2016-07-01', 1756, 1, 0, 'alumno_lic'),
(3461, 466, 4660012, 600, '2016-07-01', 1757, 0, 0, 'alumno_mtr'),
(3463, 467, 4670012, 600, '2016-07-01', 1758, 1, 0, 'alumno_mtr'),
(3465, 468, 4680012, 0, '2016-07-01', 1759, 1, 0, 'alumno_lic'),
(3467, 469, 4690012, 0, '2016-07-01', 1760, 1, 0, 'alumno_lic'),
(3469, 470, 4700012, 0, '2016-07-01', 1761, 0, 0, 'alumno_lic'),
(3471, 471, 4710012, 0, '2016-07-01', 1762, 0, 0, 'alumno_lic'),
(3473, 472, 4720012, 0, '2016-07-01', 1763, 1, 0, 'alumno_lic'),
(3475, 473, 4730012, 0, '2016-07-01', 1764, 1, 0, 'alumno_lic'),
(3477, 474, 4740012, 600, '2016-07-01', 1765, 1, 0, 'alumno_mtr'),
(3479, 475, 4750012, 0, '2016-07-01', 1766, 1, 0, 'alumno_lic'),
(3481, 476, 4760012, 0, '2016-07-01', 1767, 0, 0, 'alumno_lic'),
(3483, 477, 4770012, 600, '2016-07-01', 1768, 1, 0, 'alumno_mtr'),
(3485, 478, 4780012, 0, '2016-07-01', 1769, 1, 0, 'alumno_lic'),
(3487, 479, 4790012, 0, '2016-07-02', 1770, 1, 0, 'alumno_lic'),
(3489, 480, 4800012, 600, '2016-07-02', 1771, 1, 0, 'alumno_mtr'),
(3491, 481, 4810012, 600, '2016-07-02', 1772, 1, 0, 'alumno_mtr'),
(3493, 0, 0, 0, '2016-07-02', 1773, 0, 0, ''),
(3495, 482, 4820012, 600, '2016-07-02', 1774, 1, 0, 'alumno_mtr'),
(3497, 483, 4830012, 600, '2016-07-02', 1775, 1, 0, 'alumno_mtr'),
(3499, 484, 4840012, 100, '2016-07-02', 1776, 0, 0, 'docente'),
(3501, 485, 4850012, 100, '2016-07-02', 1777, 0, 0, 'docente'),
(3503, 486, 4860012, 600, '2016-07-02', 1778, 0, 0, 'alumno_mtr'),
(3505, 487, 4870012, 600, '2016-07-02', 1779, 1, 0, 'alumno_mtr'),
(3507, 488, 4880012, 600, '2016-07-02', 1780, 1, 0, 'alumno_mtr'),
(3509, 489, 4890012, 600, '2016-07-02', 1781, 1, 0, 'alumno_mtr'),
(3511, 490, 4900012, 600, '2016-07-02', 1782, 1, 0, 'alumno_mtr'),
(3513, 491, 4910012, 600, '2016-07-02', 1783, 1, 0, 'alumno_mtr'),
(3515, 492, 4920012, 0, '2016-07-02', 1784, 0, 0, 'alumno_lic'),
(3517, 493, 4930012, 0, '2016-07-02', 1785, 0, 0, 'alumno_lic'),
(3519, 494, 4940012, 0, '2016-07-02', 1786, 1, 0, 'alumno_lic'),
(3521, 495, 4950012, 800, '2016-07-03', 1787, 0, 0, 'otro'),
(3523, 496, 4960012, 800, '2016-07-03', 1788, 1, 0, 'otro'),
(3525, 497, 4970012, 0, '2016-07-03', 1789, 0, 0, 'alumno_lic'),
(3527, 498, 4980012, 0, '2016-07-03', 1790, 0, 0, 'alumno_lic'),
(3529, 499, 4990012, 0, '2016-07-03', 1791, 1, 0, 'alumno_lic'),
(3531, 500, 5000012, 0, '2016-07-04', 1792, 0, 0, 'alumno_lic'),
(3533, 501, 5010012, 0, '2016-07-04', 1793, 0, 0, ''),
(3535, 502, 5020012, 800, '2016-07-05', 1794, 0, 0, 'otro'),
(3537, 503, 5030012, 0, '2016-07-05', 1795, 0, 0, 'alumno_lic'),
(3539, 504, 5040012, 0, '2016-07-05', 1796, 0, 0, 'alumno_lic'),
(3541, 505, 5050012, 0, '2016-07-05', 1797, 0, 0, 'alumno_lic'),
(3543, 506, 5060012, 0, '2016-07-05', 1798, 1, 0, 'alumno_lic'),
(3545, 507, 5070012, 0, '2016-07-05', 1799, 0, 0, 'alumno_lic'),
(3547, 508, 5080012, 0, '2016-07-05', 1800, 0, 0, 'alumno_lic'),
(3549, 509, 5090012, 0, '2016-07-05', 1801, 0, 0, 'alumno_lic'),
(3551, 510, 5100012, 0, '2016-07-05', 1802, 1, 0, 'alumno_lic'),
(3553, 511, 5110012, 100, '2016-07-05', 1803, 1, 0, 'docente'),
(3555, 512, 5120012, 800, '2016-07-05', 1804, 0, 0, 'ext_alumno'),
(3557, 513, 5130012, 600, '2016-07-06', 1805, 1, 0, 'alumno_mtr'),
(3559, 514, 5140012, 0, '2016-07-06', 1806, 1, 0, 'alumno_lic'),
(3561, 515, 5150012, 0, '2016-07-06', 1807, 0, 0, 'alumno_lic'),
(3563, 516, 5160012, 0, '2016-07-06', 1808, 0, 0, 'alumno_lic'),
(3565, 517, 5170012, 0, '2016-07-07', 1809, 1, 0, 'alumno_lic'),
(3567, 518, 5180012, 100, '2016-07-07', 1810, 1, 0, 'docente'),
(3569, 519, 5190012, 0, '2016-07-07', 1811, 0, 0, 'alumno_lic'),
(3571, 520, 5200012, 800, '2016-07-07', 1812, 0, 0, 'otro'),
(3573, 521, 5210012, 0, '2016-07-09', 1813, 1, 0, 'alumno_lic'),
(3575, 0, 0, 0, '2016-08-02', 1814, 0, 0, ''),
(3577, 0, 0, 0, '2016-09-02', 1815, 0, 0, ''),
(3579, 0, 0, 0, '2016-10-04', 1816, 0, 0, ''),
(3581, 522, 5220012, 0, '2017-04-21', 1817, 0, 0, 'alumno_lic'),
(3583, 523, 5230012, 0, '2017-04-21', 1818, 0, 0, 'alumno_lic'),
(3585, 524, 5240012, 0, '2017-04-21', 1819, 0, 0, 'alumno_lic'),
(3587, 525, 5250012, 600, '2017-04-21', 1820, 0, 0, 'alumno_mtr'),
(3589, 526, 5260012, 600, '2017-04-21', 1821, 0, 0, 'alumno_mtr'),
(3591, 527, 5270012, 800, '2017-04-21', 1822, 0, 0, 'ext_alumno'),
(3593, 528, 5280012, 100, '2017-04-21', 1823, 0, 0, 'docente'),
(3595, 529, 5290012, 800, '2017-04-26', 1824, 0, 0, 'otro'),
(3597, 530, 5300012, 0, '2017-04-27', 1825, 0, 0, 'alumno_lic'),
(3599, 531, 5310012, 0, '2017-04-27', 1826, 0, 0, 'alumno_lic'),
(3601, 532, 5320012, 0, '2017-04-27', 1827, 0, 0, 'alumno_lic'),
(3603, 533, 5330012, 0, '2017-04-27', 1828, 0, 0, 'alumno_lic'),
(3605, 534, 5340012, 0, '2017-04-27', 1829, 0, 0, 'alumno_lic'),
(3607, 535, 5350012, 0, '2017-04-27', 1830, 0, 0, 'alumno_lic'),
(3609, 536, 5360012, 0, '2017-04-27', 1831, 0, 0, 'alumno_lic'),
(3611, 537, 5370012, 0, '2017-04-27', 1832, 0, 0, 'alumno_lic'),
(3613, 538, 5380012, 0, '2017-04-27', 1833, 0, 0, 'alumno_lic'),
(3615, 539, 5390012, 0, '2017-04-27', 1834, 0, 0, 'alumno_lic'),
(3617, 540, 5400012, 0, '2017-04-27', 1835, 0, 0, 'alumno_lic'),
(3619, 541, 5410012, 0, '2017-04-27', 1836, 0, 0, 'alumno_lic'),
(3621, 542, 5420012, 0, '2017-04-27', 1837, 0, 0, 'alumno_lic'),
(3623, 543, 5430012, 0, '2017-04-27', 1838, 0, 0, 'alumno_lic'),
(3625, 544, 5440012, 0, '2017-04-27', 1839, 0, 0, 'alumno_lic'),
(3627, 545, 5450012, 0, '2017-04-27', 1840, 0, 0, 'alumno_lic'),
(3629, 546, 5460012, 0, '2017-04-27', 1841, 0, 0, 'alumno_lic'),
(3631, 547, 5470012, 0, '2017-04-27', 1842, 0, 0, 'alumno_lic'),
(3633, 548, 5480012, 0, '2017-04-27', 1843, 0, 0, 'alumno_lic'),
(3635, 549, 5490012, 0, '2017-04-27', 1844, 0, 0, 'alumno_lic'),
(3637, 550, 5500012, 0, '2017-04-27', 1845, 0, 0, 'alumno_lic'),
(3639, 551, 5510012, 0, '2017-05-02', 1846, 0, 0, 'alumno_lic'),
(3641, 552, 5520012, 0, '2017-05-02', 1847, 0, 0, 'alumno_lic'),
(3643, 553, 5530012, 0, '2017-05-02', 1848, 0, 0, 'alumno_lic'),
(3645, 0, 0, 0, '2017-05-02', 1849, 0, 0, 'alumno_lic'),
(3647, 0, 0, 0, '2017-05-02', 1850, 0, 0, 'alumno_lic'),
(3649, 554, 5540012, 0, '2017-05-02', 1851, 0, 0, 'alumno_lic'),
(3651, 555, 5550012, 0, '2017-05-02', 1852, 0, 0, 'alumno_lic'),
(3653, 556, 5560012, 0, '2017-05-02', 1853, 0, 0, 'alumno_lic'),
(3655, 557, 5570012, 0, '2017-05-02', 1854, 0, 0, 'alumno_lic'),
(3657, 558, 5580012, 0, '2017-05-02', 1855, 0, 0, 'alumno_lic'),
(3659, 559, 5590012, 0, '2017-05-02', 1856, 0, 0, 'alumno_lic'),
(3661, 560, 5600012, 0, '2017-05-02', 1857, 0, 0, 'alumno_lic'),
(3663, 561, 5610012, 0, '2017-05-02', 1858, 0, 0, 'alumno_lic'),
(3665, 562, 5620012, 0, '2017-05-02', 1859, 0, 0, 'alumno_lic'),
(3667, 563, 5630012, 0, '2017-05-02', 1860, 0, 0, 'alumno_lic'),
(3669, 564, 5640012, 0, '2017-05-02', 1861, 0, 0, 'alumno_lic'),
(3671, 565, 5650012, 0, '2017-05-02', 1862, 0, 0, 'alumno_lic'),
(3673, 566, 5660012, 0, '2017-05-02', 1863, 0, 0, 'alumno_lic'),
(3675, 567, 5670012, 0, '2017-05-02', 1864, 0, 0, 'alumno_lic'),
(3677, 568, 5680012, 0, '2017-05-02', 1865, 0, 0, 'alumno_lic'),
(3679, 569, 5690012, 0, '2017-05-02', 1866, 0, 0, 'alumno_lic'),
(3681, 570, 5700012, 0, '2017-05-02', 1867, 0, 0, 'alumno_mtr'),
(3683, 571, 5710012, 100, '2017-05-02', 1868, 0, 0, 'docente'),
(3685, 572, 5720012, 100, '2017-05-02', 1869, 0, 0, 'docente'),
(3687, 573, 5730012, 100, '2017-05-02', 1870, 0, 0, 'docente'),
(3689, 574, 5740012, 100, '2017-05-02', 1871, 0, 0, 'docente'),
(3691, 575, 5750012, 100, '2017-05-02', 1872, 0, 0, 'docente'),
(3693, 576, 5760012, 100, '2017-05-02', 1873, 0, 0, 'docente'),
(3695, 577, 5770012, 800, '2017-05-02', 1874, 0, 0, 'ext_alumno'),
(3697, 578, 5780012, 0, '2017-05-03', 1875, 0, 0, 'alumno_lic'),
(3699, 579, 5790012, 0, '2017-05-03', 1876, 0, 0, 'alumno_lic'),
(3701, 580, 5800012, 0, '2017-05-03', 1877, 0, 0, 'alumno_lic'),
(3703, 581, 5810012, 0, '2017-05-03', 1878, 0, 0, 'alumno_lic'),
(3705, 582, 5820012, 0, '2017-05-03', 1879, 0, 0, 'alumno_lic'),
(3707, 583, 5830012, 0, '2017-05-03', 1880, 0, 0, 'alumno_lic'),
(3709, 584, 5840012, 0, '2017-05-04', 1881, 0, 0, 'alumno_lic'),
(3711, 585, 5850012, 0, '2017-05-04', 1882, 0, 0, 'alumno_lic'),
(3713, 586, 5860012, 0, '2017-05-04', 1883, 0, 0, 'alumno_lic'),
(3715, 587, 5870012, 0, '2017-05-04', 1884, 0, 0, 'alumno_lic'),
(3717, 588, 5880012, 0, '2017-05-04', 1885, 0, 0, 'alumno_lic'),
(3719, 589, 5890012, 0, '2017-05-04', 1886, 0, 0, 'alumno_lic'),
(3721, 590, 5900012, 0, '2017-05-04', 1887, 0, 0, 'alumno_lic'),
(3723, 591, 5910012, 0, '2017-05-04', 1888, 0, 0, 'alumno_lic'),
(3725, 592, 5920012, 0, '2017-05-04', 1889, 0, 0, 'alumno_lic'),
(3727, 593, 5930012, 0, '2017-05-04', 1890, 0, 0, 'alumno_lic'),
(3729, 594, 5940012, 0, '2017-05-04', 1891, 0, 0, 'alumno_lic'),
(3731, 595, 5950012, 0, '2017-05-04', 1892, 0, 0, 'alumno_lic'),
(3733, 596, 5960012, 0, '2017-05-04', 1893, 0, 0, 'alumno_lic'),
(3735, 597, 5970012, 0, '2017-05-04', 1894, 0, 0, 'alumno_lic'),
(3737, 598, 5980012, 0, '2017-05-04', 1895, 0, 0, 'alumno_lic'),
(3739, 599, 5990012, 0, '2017-05-04', 1896, 0, 0, 'alumno_lic'),
(3741, 600, 6000012, 0, '2017-05-04', 1897, 0, 0, 'alumno_lic'),
(3743, 601, 6010012, 0, '2017-05-04', 1898, 0, 0, 'alumno_lic'),
(3745, 602, 6020012, 0, '2017-05-04', 1899, 0, 0, 'alumno_lic'),
(3747, 603, 6030012, 0, '2017-05-04', 1900, 0, 0, 'alumno_lic'),
(3749, 604, 6040012, 0, '2017-05-04', 1901, 0, 0, 'alumno_lic'),
(3751, 605, 6050012, 0, '2017-05-04', 1902, 0, 0, 'alumno_lic'),
(3753, 606, 6060012, 0, '2017-05-04', 1903, 0, 0, 'alumno_lic'),
(3755, 607, 6070012, 0, '2017-05-04', 1904, 0, 0, 'alumno_lic'),
(3757, 608, 6080012, 0, '2017-05-04', 1905, 0, 0, 'alumno_lic'),
(3759, 609, 6090012, 0, '2017-05-04', 1906, 0, 0, 'alumno_lic'),
(3761, 610, 6100012, 0, '2017-05-04', 1907, 0, 0, 'alumno_lic'),
(3763, 611, 6110012, 0, '2017-05-04', 1908, 0, 0, 'alumno_lic'),
(3765, 612, 6120012, 0, '2017-05-04', 1909, 0, 0, 'alumno_lic'),
(3767, 613, 6130012, 0, '2017-05-04', 1910, 0, 0, 'alumno_lic'),
(3769, 614, 6140012, 0, '2017-05-04', 1911, 0, 0, 'alumno_lic'),
(3771, 615, 6150012, 0, '2017-05-04', 1912, 0, 0, 'alumno_lic'),
(3773, 616, 6160012, 0, '2017-05-04', 1913, 0, 0, 'alumno_lic'),
(3775, 617, 6170012, 0, '2017-05-04', 1914, 0, 0, 'alumno_lic'),
(3777, 618, 6180012, 0, '2017-05-04', 1915, 0, 0, 'alumno_lic'),
(3779, 619, 6190012, 0, '2017-05-04', 1916, 0, 0, 'alumno_lic'),
(3781, 620, 6200012, 0, '2017-05-04', 1917, 0, 0, 'alumno_lic'),
(3783, 621, 6210012, 0, '2017-05-04', 1918, 0, 0, 'alumno_lic'),
(3785, 622, 6220012, 0, '2017-05-04', 1919, 0, 0, 'alumno_lic'),
(3787, 623, 6230012, 0, '2017-05-04', 1920, 0, 0, 'alumno_lic'),
(3789, 624, 6240012, 0, '2017-05-04', 1921, 0, 0, 'alumno_lic'),
(3791, 625, 6250012, 0, '2017-05-04', 1922, 0, 0, 'alumno_lic'),
(3793, 626, 6260012, 0, '2017-05-04', 1923, 0, 0, 'alumno_lic'),
(3795, 627, 6270012, 0, '2017-05-04', 1924, 0, 0, 'alumno_lic'),
(3797, 628, 6280012, 0, '2017-05-04', 1925, 0, 0, 'alumno_lic'),
(3799, 629, 6290012, 0, '2017-05-04', 1926, 0, 0, 'alumno_lic'),
(3801, 630, 6300012, 0, '2017-05-04', 1927, 0, 0, 'alumno_lic'),
(3803, 631, 6310012, 0, '2017-05-04', 1928, 0, 0, 'alumno_lic'),
(3805, 632, 6320012, 0, '2017-05-04', 1929, 0, 0, 'alumno_lic'),
(3807, 633, 6330012, 0, '2017-05-04', 1930, 0, 0, 'alumno_lic'),
(3809, 634, 6340012, 0, '2017-05-04', 1931, 0, 0, 'alumno_lic'),
(3811, 635, 6350012, 0, '2017-05-04', 1932, 0, 0, 'alumno_lic'),
(3813, 636, 6360012, 0, '2017-05-04', 1933, 0, 0, 'alumno_lic'),
(3815, 637, 6370012, 0, '2017-05-04', 1934, 0, 0, 'alumno_lic'),
(3817, 638, 6380012, 0, '2017-05-04', 1935, 0, 0, 'alumno_lic'),
(3819, 639, 6390012, 0, '2017-05-04', 1936, 0, 0, 'alumno_lic'),
(3821, 640, 6400012, 0, '2017-05-04', 1937, 0, 0, 'alumno_lic'),
(3823, 641, 6410012, 0, '2017-05-04', 1938, 0, 0, 'alumno_lic'),
(3825, 642, 6420012, 0, '2017-05-04', 1939, 0, 0, 'alumno_lic'),
(3827, 643, 6430012, 0, '2017-05-04', 1940, 0, 0, 'alumno_lic'),
(3829, 644, 6440012, 0, '2017-05-04', 1941, 0, 0, 'alumno_lic'),
(3831, 645, 6450012, 0, '2017-05-04', 1942, 0, 0, 'alumno_lic'),
(3833, 646, 6460012, 0, '2017-05-04', 1943, 0, 0, 'alumno_lic'),
(3835, 647, 6470012, 0, '2017-05-04', 1944, 0, 0, 'alumno_lic'),
(3837, 648, 6480012, 0, '2017-05-04', 1945, 0, 0, 'alumno_lic'),
(3839, 649, 6490012, 0, '2017-05-04', 1946, 0, 0, 'ext_alumno'),
(3841, 650, 6500012, 0, '2017-05-04', 1947, 0, 0, 'ext_alumno'),
(3843, 651, 6510012, 0, '2017-05-04', 1948, 0, 0, 'ext_alumno'),
(3845, 652, 6520012, 0, '2017-05-04', 1949, 0, 0, 'ext_alumno'),
(3847, 653, 6530012, 0, '2017-05-04', 1950, 0, 0, 'ext_alumno'),
(3849, 654, 6540012, 0, '2017-05-04', 1951, 0, 0, 'ext_alumno'),
(3851, 655, 6550012, 0, '2017-05-04', 1952, 0, 0, 'ext_alumno'),
(3853, 656, 6560012, 0, '2017-05-04', 1953, 0, 0, 'ext_alumno'),
(3855, 657, 6570012, 0, '2017-05-04', 1954, 0, 0, 'ext_alumno'),
(3857, 658, 6580012, 0, '2017-05-04', 1955, 0, 0, 'alumno_lic'),
(3859, 659, 6590012, 0, '2017-05-04', 1956, 0, 0, 'alumno_lic'),
(3861, 660, 6600012, 0, '2017-05-04', 1957, 0, 0, 'alumno_lic'),
(3863, 661, 6610012, 0, '2017-05-04', 1958, 0, 0, 'alumno_lic'),
(3865, 662, 6620012, 0, '2017-05-07', 1959, 0, 0, 'alumno_lic'),
(3867, 663, 6630012, 0, '2017-05-07', 1960, 0, 0, 'alumno_lic'),
(3869, 664, 6640012, 0, '2017-05-07', 1961, 0, 0, 'alumno_lic'),
(3871, 665, 6650012, 0, '2017-05-07', 1962, 0, 0, 'alumno_lic'),
(3873, 666, 6660012, 0, '2017-05-07', 1963, 0, 0, 'alumno_lic'),
(3875, 667, 6670012, 0, '2017-05-07', 1964, 0, 0, 'alumno_lic'),
(3877, 668, 6680012, 0, '2017-05-07', 1965, 0, 0, 'alumno_lic'),
(3879, 669, 6690012, 0, '2017-05-07', 1966, 0, 0, 'alumno_lic'),
(3881, 670, 6700012, 0, '2017-05-07', 1967, 0, 0, 'alumno_mtr'),
(3883, 671, 6710012, 0, '2017-05-07', 1968, 0, 0, 'alumno_lic'),
(3885, 672, 6720012, 0, '2017-05-07', 1969, 0, 0, 'alumno_lic'),
(3887, 673, 6730012, 100, '2017-05-07', 1970, 0, 0, 'docente'),
(3889, 674, 6740012, 100, '2017-05-07', 1971, 0, 0, 'docente'),
(3891, 675, 6750012, 800, '2017-05-07', 1972, 0, 0, 'ext_alumno'),
(3893, 676, 6760012, 800, '2017-05-07', 1973, 0, 0, 'ext_alum_otras'),
(3895, 677, 6770012, 800, '2017-05-07', 1974, 0, 0, 'ext_maestronormales'),
(3897, 678, 6780012, 800, '2017-05-07', 1975, 0, 0, 'otro'),
(3899, 679, 6790012, 800, '2017-05-07', 1976, 0, 0, 'otro'),
(3901, 680, 6800012, 800, '2017-05-07', 1977, 0, 0, 'otro'),
(3903, 681, 6810012, 800, '2017-05-07', 1978, 0, 0, 'otro'),
(3905, 682, 6820012, 800, '2017-05-07', 1979, 0, 0, 'ext_alumno'),
(3907, 683, 6830012, 800, '2017-05-08', 1980, 0, 0, 'ext_maestronormales'),
(3909, 684, 6840012, 0, '2017-05-08', 1981, 0, 0, 'alumno_mtr'),
(3911, 685, 6850012, 1, '2017-05-08', 1982, 0, 127, 'alumno_lic'),
(3913, 686, 6860012, 250, '2017-05-08', 1983, 0, 1, 'alumno_lic'),
(3915, 687, 6870012, 250, '2017-05-08', 1984, 0, 1, 'alumno_lic'),
(3917, 688, 6880012, 100, '2017-05-08', 1985, 0, 2, 'alumno_lic'),
(3919, 689, 6890012, 720, '2017-05-08', 1986, 0, 1, 'alumno_mtr'),
(3921, 690, 6900012, 0, '2017-05-08', 1987, 0, 2, 'docente'),
(3923, 691, 6910012, 250, '2017-05-08', 1988, 0, 1, 'docente'),
(3925, 692, 6920012, 0, '2017-05-10', 1989, 0, 0, 'ext_col_ent'),
(3927, 693, 6930012, 0, '2017-05-10', 1990, 0, 1, 'ext_col_ent'),
(3929, 694, 6940012, 1000, '2017-05-10', 1991, 0, 1, 'ext_col_ent'),
(3931, 695, 6950012, 1000, '2017-05-10', 1992, 0, 1, 'ext_col_ent'),
(3933, 696, 6960012, 1000, '2017-05-10', 1993, 0, 1, 'ext_col_ent'),
(3935, 697, 6970012, 300, '2017-05-10', 1994, 0, 1, 'ext_conferencias'),
(3937, 698, 6980012, 300, '2017-05-11', 1995, 0, 1, 'ext_conferencias'),
(3939, 699, 6990012, 300, '2017-05-11', 1996, 0, 1, 'ext_conferencias'),
(3941, 700, 7000012, 300, '2017-05-11', 1997, 0, 1, 'ext_conferencias'),
(3943, 701, 7010012, 300, '2017-05-11', 1998, 0, 1, 'ext_conferencias'),
(3945, 702, 7020012, 1000, '2017-05-11', 1999, 0, 1, 'ext_col_ent'),
(3947, 703, 7030012, 1000, '2017-05-11', 2000, 0, 1, 'ext_col_ent'),
(3949, 704, 7040012, 750, '2017-05-11', 2001, 0, 2, 'ext_col_ent'),
(3951, 705, 7050012, 300, '2017-05-11', 2002, 0, 1, 'ext_conferencias'),
(3953, 706, 7060012, 550, '2017-05-11', 2003, 0, 2, 'ext_conferencias'),
(3955, 707, 7070012, 650, '2017-05-11', 2004, 0, 1, 'ext_taller'),
(3957, 708, 7080012, 400, '2017-05-11', 2005, 0, 2, 'ext_taller'),
(3959, 709, 7090012, 800, '2017-05-11', 2006, 0, 1, 'ext_confetaller'),
(3961, 710, 7100012, 800, '2017-05-11', 2007, 0, 1, 'ext_confetaller'),
(3963, 711, 7110012, 800, '2017-05-11', 2008, 0, 1, 'ext_confetaller'),
(3965, 712, 7120012, 600, '2017-05-11', 2009, 0, 2, 'ext_confetaller'),
(3967, 713, 7130012, 0, '2017-05-11', 2010, 0, 0, 'alumno_lic'),
(3969, 714, 7140012, 0, '2017-05-11', 2011, 0, 0, 'alumno_lic'),
(3971, 715, 7150012, 600, '0000-00-00', 2012, 0, 2, 'ext_confetaller'),
(3973, 716, 7160012, 600, '0000-00-00', 2013, 0, 2, 'ext_confetaller'),
(3975, 717, 7170012, 250, '2017-05-10', 2014, 0, 1, 'alumno_lic'),
(3977, 718, 7180012, 100, '2017-05-10', 2015, 0, 2, 'alumno_lic'),
(3979, 719, 7190012, 720, '2017-05-10', 2016, 0, 1, 'alumno_mtr'),
(3981, 720, 7200012, 250, '2017-05-10', 2017, 0, 1, 'docente'),
(3983, 721, 7210012, 0, '2017-05-10', 2018, 0, 2, 'docente'),
(3985, 722, 7220012, 250, '2017-05-10', 2019, 0, 1, 'alumno_lic'),
(3987, 723, 7230012, 250, '2017-05-10', 2020, 0, 1, 'alumno_lic'),
(3989, 724, 7240012, 1000, '2017-05-10', 2021, 0, 1, 'ext_col_ent'),
(3991, 725, 7250012, 250, '2018-06-01', 2022, 0, 1, 'alumno_lic'),
(3993, 726, 7260012, 100, '2018-06-01', 2023, 0, 2, 'alumno_lic'),
(3995, 727, 7270012, 250, '2018-06-01', 2024, 0, 1, 'alumno_lic'),
(3997, 728, 7280012, 100, '2018-06-01', 2025, 0, 2, 'alumno_lic'),
(3999, 729, 7290012, 0, '2018-06-01', 2026, 0, 2, 'alumno_mtr'),
(4001, 730, 7300012, 0, '2018-06-01', 2027, 0, 2, 'alumno_mtr'),
(4003, 731, 7310012, 500, '2018-06-01', 2028, 0, 2, 'alumno_mtr'),
(4005, 732, 7320012, 0, '2018-06-01', 2029, 0, 2, 'docente'),
(4007, 733, 7330012, 750, '2018-06-01', 2030, 0, 2, 'ext_col_ent'),
(4009, 734, 7340012, 300, '2018-06-01', 2031, 0, 2, 'ext_conferencias'),
(4011, 735, 7350012, 400, '2018-06-01', 2032, 0, 2, 'ext_taller'),
(4013, 736, 7360012, 600, '2018-06-01', 2033, 0, 2, 'ext_confetaller'),
(4015, 737, 7370012, 100, '2018-06-01', 2034, 0, 2, 'alumno_lic'),
(4017, 738, 7380012, 500, '2018-06-01', 2035, 0, 2, 'alumno_mtr'),
(4019, 739, 7390012, 0, '2018-06-01', 2036, 0, 2, 'docente'),
(4021, 740, 7400012, 750, '2018-06-01', 2037, 0, 2, 'ext_col_ent'),
(4023, 741, 7410012, 300, '2018-06-01', 2038, 0, 2, 'ext_conferencias'),
(4025, 742, 7420012, 400, '2018-06-01', 2039, 0, 2, 'ext_taller'),
(4027, 743, 7430012, 600, '2018-06-01', 2040, 0, 2, 'ext_confetaller'),
(4029, 744, 7440012, 100, '2018-06-02', 2041, 0, 2, 'alumno_lic'),
(4031, 745, 7450012, 100, '2018-06-02', 2042, 0, 2, 'alumno_lic'),
(4033, 746, 7460012, 100, '2018-06-02', 2043, 0, 2, 'alumno_lic'),
(4035, 747, 7470012, 100, '2018-06-02', 2044, 0, 2, 'alumno_lic'),
(4037, 748, 7480012, 100, '2018-06-02', 2045, 0, 2, 'alumno_lic'),
(4039, 749, 7490012, 100, '2018-06-02', 2046, 0, 2, 'alumno_lic'),
(4041, 750, 7500012, 100, '2018-06-02', 2047, 0, 2, 'alumno_lic'),
(4043, 751, 7510012, 500, '2018-06-03', 2048, 0, 2, 'alumno_mtr'),
(4045, 752, 7520012, 100, '2018-06-03', 2049, 0, 2, 'alumno_lic'),
(4047, 753, 7530012, 100, '2018-06-03', 2050, 0, 2, 'alumno_lic'),
(4049, 754, 7540012, 100, '2018-06-03', 2051, 0, 2, 'alumno_lic'),
(4051, 755, 7550012, 100, '2018-06-03', 2052, 0, 2, 'alumno_lic'),
(4053, 756, 7560012, 500, '2018-06-03', 2053, 0, 2, 'alumno_mtr'),
(4055, 757, 7570012, 0, '2018-06-03', 2054, 0, 2, 'docente'),
(4057, 758, 7580012, 0, '2018-06-03', 2055, 0, 2, 'docente'),
(4059, 759, 7590012, 100, '2018-06-04', 2056, 0, 2, 'alumno_lic'),
(4061, 760, 7600012, 100, '2018-06-04', 2057, 0, 2, 'alumno_lic'),
(4063, 761, 7610012, 100, '2018-06-04', 2058, 0, 2, 'alumno_lic'),
(4065, 762, 7620012, 100, '2018-06-04', 2059, 0, 2, 'alumno_lic'),
(4067, 763, 7630012, 500, '2018-06-04', 2060, 0, 2, 'alumno_mtr'),
(4069, 764, 7640012, 0, '2018-06-04', 2061, 0, 2, 'docente'),
(4071, 765, 7650012, 0, '2018-06-04', 2062, 0, 2, 'docente'),
(4073, 766, 7660012, 0, '2018-06-04', 2063, 0, 2, 'ext_col_ent'),
(4075, 767, 7670012, 750, '2018-06-04', 2064, 0, 2, 'ext_col_ent'),
(4077, 768, 7680012, 0, '2018-06-04', 2065, 0, 2, 'ext_conferencias'),
(4079, 769, 7690012, 300, '2018-06-04', 2066, 0, 2, 'ext_conferencias'),
(4081, 770, 7700012, 0, '2018-06-04', 2067, 0, 2, 'ext_taller'),
(4083, 771, 7710012, 400, '2018-06-04', 2068, 0, 2, 'ext_taller'),
(4085, 772, 7720012, 0, '2018-06-04', 2069, 0, 2, 'ext_confetaller'),
(4087, 773, 7730012, 600, '2018-06-04', 2070, 0, 2, 'ext_confetaller'),
(4089, 774, 7740012, 100, '2018-06-04', 2071, 0, 2, 'alumno_lic'),
(4091, 775, 7750012, 500, '2018-06-04', 2072, 0, 2, 'alumno_mtr'),
(4093, 776, 7760012, 500, '2018-06-04', 2073, 0, 2, 'alumno_mtr'),
(4095, 777, 7770012, 500, '2018-06-04', 2074, 1, 2, 'alumno_mtr'),
(4097, 778, 7780012, 100, '2018-06-04', 2075, 0, 2, 'alumno_lic');
INSERT INTO `ficha` (`id_ficha`, `folio`, `clave_acceso`, `cuota`, `fecha`, `id_participante`, `pagado`, `libro`, `tipo_participante`) VALUES
(4099, 779, 7790012, 500, '2018-06-04', 2076, 0, 2, 'alumno_mtr'),
(4101, 780, 7800012, 500, '2018-06-04', 2077, 0, 2, 'alumno_mtr'),
(4103, 781, 7810012, 500, '2018-06-04', 2078, 0, 2, 'alumno_mtr'),
(4105, 782, 7820012, 500, '2018-06-04', 2079, 0, 2, 'alumno_mtr'),
(4107, 783, 7830012, 500, '2018-06-04', 2080, 0, 2, 'alumno_mtr'),
(4109, 784, 7840012, 500, '2018-06-04', 2081, 0, 2, 'alumno_mtr'),
(4111, 785, 7850012, 100, '2018-06-04', 2082, 0, 2, 'alumno_lic'),
(4113, 786, 7860012, 500, '2018-06-04', 2083, 1, 2, 'alumno_mtr'),
(4115, 787, 7870012, 500, '2018-06-04', 2084, 1, 2, 'alumno_mtr'),
(4117, 788, 7880012, 500, '2018-06-04', 2085, 1, 2, 'alumno_mtr'),
(4119, 789, 7890012, 500, '2018-06-04', 2086, 1, 2, 'alumno_mtr'),
(4121, 790, 7900012, 500, '2018-06-04', 2087, 1, 2, 'alumno_mtr'),
(4123, 791, 7910012, 500, '2018-06-04', 2088, 1, 2, 'alumno_mtr'),
(4125, 792, 7920012, 500, '2018-06-04', 2089, 1, 2, 'alumno_mtr'),
(4127, 793, 7930012, 500, '2018-06-04', 2090, 1, 2, 'alumno_mtr'),
(4129, 794, 7940012, 500, '2018-06-04', 2091, 1, 2, 'alumno_mtr'),
(4131, 795, 7950012, 750, '2018-06-04', 2092, 0, 2, 'ext_col_ent'),
(4133, 796, 7960012, 100, '2018-06-04', 2093, 0, 2, 'alumno_lic'),
(4135, 797, 7970012, 100, '2018-06-04', 2094, 0, 2, 'alumno_lic'),
(4137, 798, 7980012, 750, '2018-06-04', 2095, 0, 2, 'ext_col_ent'),
(4139, 799, 7990012, 500, '2018-06-04', 2096, 1, 2, 'alumno_mtr'),
(4141, 800, 8000012, 100, '2018-06-04', 2097, 0, 2, 'alumno_lic'),
(4143, 801, 8010012, 100, '2018-06-04', 2098, 0, 2, 'alumno_lic'),
(4145, 802, 8020012, 100, '2018-06-04', 2099, 0, 2, 'alumno_lic'),
(4147, 803, 8030012, 100, '2018-06-04', 2100, 0, 2, 'alumno_lic'),
(4149, 804, 8040012, 500, '2018-06-04', 2101, 1, 2, 'alumno_mtr'),
(4151, 805, 8050012, 100, '2018-06-04', 2102, 0, 2, 'alumno_lic'),
(4153, 806, 8060012, 100, '2018-06-04', 2103, 0, 2, 'alumno_lic'),
(4155, 807, 8070012, 100, '2018-06-04', 2104, 0, 2, 'alumno_lic'),
(4157, 808, 8080012, 500, '2018-06-04', 2105, 0, 2, 'alumno_mtr'),
(4159, 809, 8090012, 500, '2018-06-04', 2106, 0, 2, 'alumno_mtr'),
(4161, 810, 8100012, 500, '2018-06-04', 2107, 1, 2, 'alumno_mtr'),
(4163, 811, 8110012, 500, '2018-06-04', 2108, 1, 2, 'alumno_mtr'),
(4165, 812, 8120012, 500, '2018-06-04', 2109, 1, 2, 'alumno_mtr'),
(4167, 813, 8130012, 500, '2018-06-04', 2110, 1, 2, 'alumno_mtr'),
(4169, 814, 8140012, 0, '2018-06-04', 2111, 0, 2, 'docente'),
(4171, 815, 8150012, 500, '2018-06-04', 2112, 1, 2, 'alumno_mtr'),
(4173, 816, 8160012, 0, '2018-06-04', 2113, 1, 2, ''),
(4175, 817, 8170012, 0, '2018-06-04', 2114, 1, 2, ''),
(4177, 818, 8180012, 500, '2018-06-05', 2115, 1, 2, 'alumno_mtr'),
(4179, 819, 8190012, 100, '2018-06-05', 2116, 0, 2, 'alumno_lic'),
(4181, 820, 8200012, 100, '2018-06-05', 2117, 0, 2, 'alumno_lic'),
(4183, 821, 8210012, 100, '2018-06-05', 2118, 0, 2, 'alumno_lic'),
(4185, 822, 8220012, 100, '2018-06-05', 2119, 0, 2, 'alumno_lic'),
(4187, 823, 8230012, 100, '2018-06-05', 2120, 0, 2, 'alumno_lic'),
(4189, 824, 8240012, 100, '2018-06-05', 2121, 0, 2, 'alumno_lic'),
(4191, 825, 8250012, 100, '2018-06-05', 2122, 0, 2, 'alumno_lic'),
(4193, 826, 8260012, 100, '2018-06-05', 2123, 0, 2, 'alumno_lic'),
(4195, 827, 8270012, 100, '2018-06-05', 2124, 0, 2, 'alumno_lic'),
(4197, 828, 8280012, 100, '2018-06-05', 2125, 0, 2, 'alumno_lic'),
(4199, 829, 8290012, 500, '2018-06-05', 2126, 0, 2, 'alumno_mtr'),
(4201, 830, 8300012, 500, '2018-06-05', 2127, 1, 2, 'alumno_mtr'),
(4203, 831, 8310012, 500, '2018-06-05', 2128, 1, 2, 'alumno_mtr'),
(4205, 832, 8320012, 500, '2018-06-05', 2129, 1, 2, 'alumno_mtr'),
(4207, 833, 8330012, 500, '2018-06-05', 2130, 1, 2, 'alumno_mtr'),
(4209, 834, 8340012, 750, '2018-06-05', 2131, 0, 2, 'ext_col_ent'),
(4211, 835, 8350012, 500, '2018-06-05', 2132, 1, 2, 'alumno_mtr'),
(4213, 836, 8360012, 500, '2018-06-05', 2133, 1, 2, 'alumno_mtr'),
(4215, 837, 8370012, 0, '2018-06-05', 2134, 1, 2, ''),
(4217, 838, 8380012, 500, '2018-06-05', 2135, 1, 2, 'alumno_mtr'),
(4219, 839, 8390012, 500, '2018-06-05', 2136, 1, 2, 'alumno_mtr'),
(4221, 840, 8400012, 500, '2018-06-05', 2137, 1, 2, 'alumno_mtr'),
(4223, 841, 8410012, 500, '2018-06-05', 2138, 1, 2, 'alumno_mtr'),
(4225, 842, 8420012, 500, '2018-06-05', 2139, 1, 2, 'alumno_mtr'),
(4227, 843, 8430012, 0, '2018-06-05', 2140, 0, 2, ''),
(4229, 844, 8440012, 0, '2018-06-05', 2141, 1, 2, ''),
(4231, 845, 8450012, 0, '2018-06-05', 2142, 0, 2, ''),
(4233, 846, 8460012, 500, '2018-06-05', 2143, 1, 2, 'alumno_mtr'),
(4235, 847, 8470012, 500, '2018-06-05', 2144, 1, 2, 'alumno_mtr'),
(4237, 848, 8480012, 500, '2018-06-05', 2145, 1, 2, 'alumno_mtr'),
(4239, 849, 8490012, 500, '2018-06-05', 2146, 1, 2, 'alumno_mtr'),
(4241, 850, 8500012, 0, '2018-06-05', 2147, 0, 2, ''),
(4243, 851, 8510012, 0, '2018-06-05', 2148, 0, 2, ''),
(4245, 852, 8520012, 0, '2018-06-05', 2149, 1, 2, ''),
(4247, 853, 8530012, 750, '2018-06-05', 2150, 0, 2, 'ext_col_ent'),
(4249, 854, 8540012, 750, '2018-06-05', 2151, 0, 2, 'ext_col_ent'),
(4251, 855, 8550012, 500, '2018-06-05', 2152, 1, 2, 'alumno_mtr'),
(4253, 856, 8560012, 500, '2018-06-05', 2153, 1, 2, 'alumno_mtr'),
(4255, 857, 8570012, 500, '2018-06-05', 2154, 1, 2, 'alumno_mtr'),
(4257, 858, 8580012, 500, '2018-06-05', 2155, 1, 2, 'alumno_mtr'),
(4259, 859, 8590012, 500, '2018-06-05', 2156, 0, 2, 'alumno_mtr'),
(4261, 860, 8600012, 500, '2018-06-05', 2157, 1, 2, 'alumno_mtr'),
(4263, 861, 8610012, 500, '2018-06-05', 2158, 1, 2, 'alumno_mtr'),
(4265, 862, 8620012, 500, '2018-06-05', 2159, 0, 2, 'alumno_mtr'),
(4267, 863, 8630012, 0, '2018-06-05', 2160, 1, 2, ''),
(4269, 864, 8640012, 500, '2018-06-05', 2161, 1, 2, 'alumno_mtr'),
(4271, 865, 8650012, 750, '2018-06-05', 2162, 0, 2, 'ext_col_ent'),
(4273, 866, 8660012, 750, '2018-06-05', 2163, 0, 2, 'ext_col_ent'),
(4275, 867, 8670012, 500, '2018-06-05', 2164, 1, 2, 'alumno_mtr'),
(4277, 868, 8680012, 500, '2018-06-05', 2165, 1, 2, 'alumno_mtr'),
(4279, 869, 8690012, 500, '2018-06-05', 2166, 1, 2, 'alumno_mtr'),
(4281, 870, 8700012, 500, '2018-06-05', 2167, 1, 2, 'alumno_mtr'),
(4283, 871, 8710012, 500, '2018-06-05', 2168, 1, 2, 'alumno_mtr'),
(4285, 872, 8720012, 500, '2018-06-05', 2169, 1, 2, 'alumno_mtr'),
(4287, 873, 8730012, 100, '2018-06-05', 2170, 1, 2, 'alumno_lic'),
(4289, 874, 8740012, 500, '2018-06-05', 2171, 1, 2, 'alumno_mtr'),
(4291, 875, 8750012, 500, '2018-06-05', 2172, 1, 2, 'alumno_mtr'),
(4293, 876, 8760012, 500, '2018-06-06', 2173, 0, 2, 'alumno_mtr'),
(4295, 877, 8770012, 500, '2018-06-06', 2174, 1, 2, 'alumno_mtr'),
(4297, 878, 8780012, 500, '2018-06-06', 2175, 1, 2, 'alumno_mtr'),
(4299, 879, 8790012, 500, '2018-06-06', 2176, 0, 2, 'alumno_mtr'),
(4301, 880, 8800012, 400, '2018-06-06', 2177, 0, 2, 'ext_taller'),
(4303, 881, 8810012, 0, '2018-06-06', 2178, 0, 2, 'docente'),
(4305, 882, 8820012, 0, '2018-06-06', 2179, 0, 2, 'docente'),
(4307, 883, 8830012, 500, '2018-06-06', 2180, 1, 2, 'alumno_mtr'),
(4309, 884, 8840012, 400, '2018-06-06', 2181, 0, 2, 'ext_taller'),
(4311, 885, 8850012, 400, '2018-06-06', 2182, 0, 2, 'ext_taller'),
(4313, 886, 8860012, 500, '2018-06-06', 2183, 1, 2, 'alumno_mtr'),
(4315, 887, 8870012, 400, '2018-06-06', 2184, 0, 2, 'ext_taller'),
(4317, 888, 8880012, 500, '2018-06-06', 2185, 1, 2, 'alumno_mtr'),
(4319, 889, 8890012, 400, '2018-06-06', 2186, 0, 2, 'ext_taller'),
(4321, 890, 8900012, 400, '2018-06-06', 2187, 0, 2, 'ext_taller'),
(4323, 891, 8910012, 400, '2018-06-06', 2188, 0, 2, 'ext_taller'),
(4325, 892, 8920012, 500, '2018-06-06', 2189, 1, 2, 'alumno_mtr'),
(4327, 893, 8930012, 500, '2018-06-06', 2190, 1, 2, 'alumno_mtr'),
(4329, 894, 8940012, 500, '2018-06-06', 2191, 0, 2, 'alumno_mtr'),
(4331, 895, 8950012, 500, '2018-06-06', 2192, 0, 2, 'alumno_mtr'),
(4333, 896, 8960012, 500, '2018-06-06', 2193, 1, 2, 'alumno_mtr'),
(4335, 897, 8970012, 400, '2018-06-06', 2194, 0, 2, 'ext_taller'),
(4337, 898, 8980012, 400, '2018-06-06', 2195, 0, 2, 'ext_taller'),
(4339, 899, 8990012, 500, '2018-06-06', 2196, 1, 2, 'alumno_mtr'),
(4341, 900, 9000012, 500, '2018-06-06', 2197, 0, 2, 'alumno_mtr'),
(4343, 901, 9010012, 500, '2018-06-06', 2198, 1, 2, 'alumno_mtr'),
(4345, 902, 9020012, 500, '2018-06-06', 2199, 1, 2, 'alumno_mtr'),
(4347, 903, 9030012, 500, '2018-06-06', 2200, 0, 2, 'alumno_mtr'),
(4349, 904, 9040012, 500, '2018-06-06', 2201, 1, 2, 'alumno_mtr'),
(4351, 905, 9050012, 500, '2018-06-06', 2202, 1, 2, 'alumno_mtr'),
(4353, 906, 9060012, 500, '2018-06-06', 2203, 1, 2, 'alumno_mtr'),
(4355, 907, 9070012, 500, '2018-06-06', 2204, 1, 2, 'alumno_mtr'),
(4357, 908, 9080012, 500, '2018-06-06', 2205, 1, 2, 'alumno_mtr'),
(4359, 909, 9090012, 500, '2018-06-06', 2206, 1, 2, 'alumno_mtr'),
(4361, 910, 9100012, 500, '2018-06-06', 2207, 1, 2, 'alumno_mtr'),
(4363, 911, 9110012, 500, '2018-06-06', 2208, 1, 2, 'alumno_mtr'),
(4365, 912, 9120012, 500, '2018-06-06', 2209, 1, 2, 'alumno_mtr'),
(4367, 913, 9130012, 500, '2018-06-06', 2210, 1, 2, 'alumno_mtr'),
(4369, 914, 9140012, 500, '2018-06-06', 2211, 1, 2, 'alumno_mtr'),
(4371, 915, 9150012, 100, '2018-06-06', 2212, 0, 2, 'alumno_lic'),
(4373, 916, 9160012, 500, '2018-06-06', 2213, 1, 2, 'alumno_mtr'),
(4375, 917, 9170012, 100, '2018-06-06', 2214, 1, 2, 'alumno_lic'),
(4377, 918, 9180012, 100, '2018-06-06', 2215, 1, 2, 'alumno_lic'),
(4379, 919, 9190012, 100, '2018-06-06', 2216, 0, 2, 'alumno_lic'),
(4381, 920, 9200012, 100, '2018-06-06', 2217, 0, 2, 'alumno_lic'),
(4383, 921, 9210012, 100, '2018-06-06', 2218, 1, 2, 'alumno_lic'),
(4385, 922, 9220012, 500, '2018-06-06', 2219, 1, 2, 'alumno_mtr'),
(4387, 923, 9230012, 600, '2018-06-06', 2220, 1, 2, 'ext_confetaller'),
(4389, 924, 9240012, 500, '2018-06-06', 2221, 1, 2, 'alumno_mtr'),
(4391, 925, 9250012, 500, '2018-06-07', 2222, 1, 2, 'alumno_mtr'),
(4393, 926, 9260012, 500, '2018-06-07', 2223, 1, 2, 'alumno_mtr'),
(4395, 927, 9270012, 500, '2018-06-07', 2224, 1, 2, 'alumno_mtr'),
(4397, 928, 9280012, 500, '2018-06-07', 2225, 1, 2, 'alumno_mtr'),
(4399, 929, 9290012, 0, '2018-06-07', 2226, 1, 2, 'docente'),
(4401, 930, 9300012, 100, '2018-06-07', 2227, 1, 2, 'alumno_lic'),
(4403, 931, 9310012, 500, '2018-06-07', 2228, 0, 2, 'alumno_mtr'),
(4405, 932, 9320012, 500, '2018-06-07', 2229, 1, 2, 'alumno_mtr'),
(4407, 933, 9330012, 500, '2018-06-07', 2230, 1, 2, 'alumno_mtr'),
(4409, 934, 9340012, 500, '2018-06-07', 2231, 1, 2, 'alumno_mtr'),
(4411, 935, 9350012, 500, '2018-06-07', 2232, 0, 2, 'alumno_mtr'),
(4413, 936, 9360012, 500, '2018-06-07', 2233, 1, 2, 'alumno_mtr'),
(4415, 937, 9370012, 750, '2018-06-07', 2234, 1, 2, 'ext_col_ent'),
(4417, 938, 9380012, 500, '2018-06-07', 2235, 1, 2, 'alumno_mtr'),
(4419, 939, 9390012, 500, '2018-06-07', 2236, 1, 2, 'alumno_mtr'),
(4421, 940, 9400012, 500, '2018-06-07', 2237, 1, 2, 'alumno_mtr'),
(4423, 941, 9410012, 500, '2018-06-07', 2238, 1, 2, 'alumno_mtr'),
(4425, 942, 9420012, 500, '2018-06-07', 2239, 1, 2, 'alumno_mtr'),
(4427, 943, 9430012, 100, '2018-06-07', 2240, 1, 2, 'alumno_lic'),
(4429, 944, 9440012, 500, '2018-06-07', 2241, 1, 2, 'alumno_mtr'),
(4431, 945, 9450012, 500, '2018-06-07', 2242, 1, 2, 'alumno_mtr'),
(4433, 946, 9460012, 500, '2018-06-07', 2243, 1, 2, 'alumno_mtr'),
(4435, 947, 9470012, 500, '2018-06-07', 2244, 1, 2, 'alumno_mtr'),
(4437, 948, 9480012, 500, '2018-06-07', 2245, 1, 2, 'alumno_mtr'),
(4439, 949, 9490012, 500, '2018-06-07', 2246, 1, 2, 'alumno_mtr'),
(4441, 950, 9500012, 500, '2018-06-07', 2247, 1, 2, 'alumno_mtr'),
(4443, 951, 9510012, 500, '2018-06-07', 2248, 1, 2, 'alumno_mtr'),
(4445, 952, 9520012, 100, '2018-06-07', 2249, 0, 2, 'alumno_lic'),
(4447, 953, 9530012, 500, '2018-06-07', 2250, 0, 2, 'alumno_mtr'),
(4449, 954, 9540012, 100, '2018-06-07', 2251, 1, 2, 'alumno_lic'),
(4451, 955, 9550012, 500, '2018-06-07', 2252, 1, 2, 'alumno_mtr'),
(4453, 956, 9560012, 750, '2018-06-07', 2253, 0, 2, 'ext_col_ent'),
(4455, 957, 9570012, 100, '2018-06-07', 2254, 1, 2, 'alumno_lic'),
(4457, 958, 9580012, 500, '2018-06-07', 2255, 1, 2, 'alumno_mtr'),
(4459, 959, 9590012, 100, '2018-06-07', 2256, 0, 2, 'alumno_lic'),
(4461, 960, 9600012, 100, '2018-06-07', 2257, 1, 2, 'alumno_lic'),
(4463, 961, 9610012, 100, '2018-06-07', 2258, 0, 2, 'alumno_lic'),
(4465, 962, 9620012, 100, '2018-06-07', 2259, 1, 2, 'alumno_lic'),
(4467, 963, 9630012, 100, '2018-06-07', 2260, 0, 2, 'alumno_lic'),
(4469, 964, 9640012, 500, '2018-06-07', 2261, 0, 2, 'alumno_mtr'),
(4471, 965, 9650012, 500, '2018-06-07', 2262, 1, 2, 'alumno_mtr'),
(4473, 966, 9660012, 500, '2018-06-07', 2263, 1, 2, 'alumno_mtr'),
(4475, 967, 9670012, 100, '2018-06-08', 2264, 1, 2, 'alumno_lic'),
(4477, 968, 9680012, 100, '2018-06-08', 2265, 1, 2, 'alumno_lic'),
(4479, 969, 9690012, 100, '2018-06-08', 2266, 0, 2, 'alumno_lic'),
(4481, 970, 9700012, 100, '2018-06-08', 2267, 1, 2, 'alumno_lic'),
(4483, 971, 9710012, 500, '2018-06-08', 2268, 1, 2, 'alumno_mtr'),
(4485, 972, 9720012, 500, '2018-06-08', 2269, 1, 2, 'alumno_mtr'),
(4487, 973, 9730012, 500, '2018-06-08', 2270, 0, 2, 'alumno_mtr'),
(4489, 974, 9740012, 100, '2018-06-08', 2271, 1, 2, 'alumno_lic'),
(4491, 975, 9750012, 500, '2018-06-08', 2272, 0, 2, 'alumno_mtr'),
(4493, 976, 9760012, 100, '2018-06-08', 2273, 1, 2, 'alumno_lic'),
(4495, 977, 9770012, 100, '2018-06-08', 2274, 1, 2, 'alumno_lic'),
(4497, 978, 9780012, 100, '2018-06-08', 2275, 1, 2, 'alumno_lic'),
(4499, 979, 9790012, 100, '2018-06-08', 2276, 1, 2, 'alumno_lic'),
(4501, 980, 9800012, 100, '2018-06-08', 2277, 1, 2, 'alumno_lic'),
(4503, 981, 9810012, 100, '2018-06-08', 2278, 1, 2, 'alumno_lic'),
(4505, 982, 9820012, 100, '2018-06-08', 2279, 1, 2, 'alumno_lic'),
(4507, 983, 9830012, 100, '2018-06-08', 2280, 1, 2, 'alumno_lic'),
(4509, 984, 9840012, 100, '2018-06-08', 2281, 1, 2, 'alumno_lic'),
(4511, 985, 9850012, 100, '2018-06-08', 2282, 1, 2, 'alumno_lic'),
(4513, 986, 9860012, 100, '2018-06-08', 2283, 1, 2, 'alumno_lic'),
(4515, 987, 9870012, 100, '2018-06-08', 2284, 1, 2, 'alumno_lic'),
(4517, 988, 9880012, 500, '2018-06-08', 2285, 1, 2, 'alumno_mtr'),
(4519, 989, 9890012, 100, '2018-06-08', 2286, 0, 2, 'alumno_lic'),
(4521, 990, 9900012, 100, '2018-06-08', 2287, 1, 2, 'alumno_lic'),
(4523, 991, 9910012, 100, '2018-06-08', 2288, 1, 2, 'alumno_lic'),
(4525, 992, 9920012, 100, '2018-06-08', 2289, 0, 2, 'alumno_lic'),
(4527, 993, 9930012, 100, '2018-06-08', 2290, 1, 2, 'alumno_lic'),
(4529, 994, 9940012, 100, '2018-06-08', 2291, 1, 2, 'alumno_lic'),
(4531, 995, 9950012, 500, '2018-06-08', 2292, 1, 2, 'alumno_mtr'),
(4533, 996, 9960012, 500, '2018-06-08', 2293, 1, 2, 'alumno_mtr'),
(4535, 997, 9970012, 500, '2018-06-08', 2294, 1, 2, 'alumno_mtr'),
(4537, 998, 9980012, 100, '2018-06-08', 2295, 1, 2, 'alumno_lic'),
(4539, 999, 9990012, 100, '2018-06-08', 2296, 0, 2, 'alumno_lic'),
(4541, 1000, 10000012, 100, '2018-06-08', 2297, 1, 2, 'alumno_lic'),
(4543, 1001, 10010012, 100, '2018-06-08', 2298, 0, 2, 'alumno_lic'),
(4545, 1002, 10020012, 100, '2018-06-08', 2299, 0, 2, 'alumno_lic'),
(4547, 1003, 10030012, 750, '2018-06-08', 2300, 1, 2, 'ext_col_ent'),
(4549, 1004, 10040012, 100, '2018-06-08', 2301, 1, 2, 'alumno_lic'),
(4551, 1005, 10050012, 500, '2018-06-08', 2302, 1, 2, 'alumno_mtr'),
(4553, 1006, 10060012, 500, '2018-06-08', 2303, 1, 2, 'alumno_mtr'),
(4555, 1007, 10070012, 500, '2018-06-08', 2304, 1, 2, 'alumno_mtr'),
(4557, 1008, 10080012, 100, '2018-06-08', 2305, 1, 2, 'alumno_lic'),
(4559, 1009, 10090012, 500, '2018-06-08', 2306, 1, 2, 'alumno_mtr'),
(4561, 1010, 10100012, 100, '2018-06-08', 2307, 1, 2, 'alumno_lic'),
(4563, 1011, 10110012, 500, '2018-06-08', 2308, 1, 2, 'alumno_mtr'),
(4565, 1012, 10120012, 500, '2018-06-08', 2309, 1, 2, 'alumno_mtr'),
(4567, 1013, 10130012, 100, '2018-06-08', 2310, 1, 2, 'alumno_lic'),
(4569, 1014, 10140012, 500, '2018-06-08', 2311, 0, 2, 'alumno_mtr'),
(4571, 1015, 10150012, 500, '2018-06-08', 2312, 0, 2, 'alumno_mtr'),
(4573, 1016, 10160012, 500, '2018-06-08', 2313, 1, 2, 'alumno_mtr'),
(4575, 1017, 10170012, 500, '2018-06-08', 2314, 1, 2, 'alumno_mtr'),
(4577, 1018, 10180012, 500, '2018-06-08', 2315, 0, 2, 'alumno_mtr'),
(4579, 1019, 10190012, 500, '2018-06-08', 2316, 1, 2, 'alumno_mtr'),
(4581, 1020, 10200012, 500, '2018-06-08', 2317, 1, 2, 'alumno_mtr'),
(4583, 1021, 10210012, 100, '2018-06-08', 2318, 0, 2, 'alumno_lic'),
(4585, 1022, 10220012, 100, '2018-06-08', 2319, 0, 2, 'alumno_lic'),
(4587, 1023, 10230012, 100, '2018-06-08', 2320, 1, 2, 'alumno_lic'),
(4589, 1024, 10240012, 500, '2018-06-08', 2321, 1, 2, 'alumno_mtr'),
(4591, 1025, 10250012, 100, '2018-06-08', 2322, 1, 2, 'alumno_lic'),
(4593, 1026, 10260012, 100, '2018-06-08', 2323, 1, 2, 'alumno_lic'),
(4595, 1027, 10270012, 500, '2018-06-08', 2324, 1, 2, 'alumno_mtr'),
(4597, 1028, 10280012, 500, '2018-06-08', 2325, 1, 2, 'alumno_mtr'),
(4599, 1029, 10290012, 500, '2018-06-09', 2326, 1, 2, 'alumno_mtr'),
(4601, 1030, 10300012, 500, '2018-06-09', 2327, 0, 2, 'alumno_mtr'),
(4603, 1031, 10310012, 500, '2018-06-09', 2328, 1, 2, 'alumno_mtr'),
(4605, 1032, 10320012, 500, '2018-06-09', 2329, 0, 2, 'alumno_mtr'),
(4607, 1033, 10330012, 500, '2018-06-09', 2330, 1, 2, 'alumno_mtr'),
(4609, 1034, 10340012, 500, '2018-06-09', 2331, 1, 2, 'alumno_mtr'),
(4611, 1035, 10350012, 500, '2018-06-09', 2332, 1, 2, 'alumno_mtr'),
(4613, 1036, 10360012, 500, '2018-06-09', 2333, 0, 2, 'alumno_mtr'),
(4615, 1037, 10370012, 500, '2018-06-09', 2334, 1, 2, 'alumno_mtr'),
(4617, 1038, 10380012, 500, '2018-06-09', 2335, 1, 2, 'alumno_mtr'),
(4619, 1039, 10390012, 500, '2018-06-09', 2336, 1, 2, 'alumno_mtr'),
(4621, 1040, 10400012, 100, '2018-06-09', 2337, 1, 2, 'alumno_lic'),
(4623, 1041, 10410012, 500, '2018-06-09', 2338, 0, 2, 'alumno_mtr'),
(4625, 1042, 10420012, 500, '2018-06-09', 2339, 1, 2, 'alumno_mtr'),
(4627, 1043, 10430012, 500, '2018-06-09', 2340, 1, 2, 'alumno_mtr'),
(4629, 1044, 10440012, 500, '2018-06-09', 2341, 1, 2, 'alumno_mtr'),
(4631, 1045, 10450012, 100, '2018-06-09', 2342, 1, 2, 'alumno_lic'),
(4633, 1046, 10460012, 100, '2018-06-09', 2343, 1, 2, 'alumno_lic'),
(4635, 1047, 10470012, 100, '2018-06-09', 2344, 1, 2, 'alumno_lic'),
(4637, 1048, 10480012, 100, '2018-06-09', 2345, 1, 2, 'alumno_lic'),
(4639, 1049, 10490012, 100, '2018-06-09', 2346, 1, 2, 'alumno_lic'),
(4641, 1050, 10500012, 500, '2018-06-09', 2347, 0, 2, 'alumno_mtr'),
(4643, 1051, 10510012, 500, '2018-06-09', 2348, 1, 2, 'alumno_mtr'),
(4645, 1052, 10520012, 100, '2018-06-09', 2349, 1, 2, 'alumno_lic'),
(4647, 1053, 10530012, 100, '2018-06-09', 2350, 1, 2, 'alumno_lic'),
(4649, 1054, 10540012, 0, '2018-06-09', 2351, 1, 2, ''),
(4651, 1055, 10550012, 100, '2018-06-09', 2352, 1, 2, 'alumno_lic'),
(4653, 1056, 10560012, 100, '2018-06-09', 2353, 1, 2, 'alumno_lic'),
(4655, 1057, 10570012, 100, '2018-06-10', 2354, 1, 2, 'alumno_lic'),
(4657, 1058, 10580012, 100, '2018-06-10', 2355, 1, 2, 'alumno_lic'),
(4659, 1059, 10590012, 500, '2018-06-10', 2356, 0, 2, 'alumno_mtr'),
(4661, 1060, 10600012, 100, '2018-06-10', 2357, 0, 2, 'alumno_lic'),
(4663, 0, 0, 0, '2018-06-10', 2358, 0, 2, ''),
(4665, 1061, 10610012, 500, '2018-06-10', 2359, 0, 2, 'alumno_mtr'),
(4667, 1062, 10620012, 100, '2018-06-10', 2360, 1, 2, 'alumno_lic'),
(4669, 1063, 10630012, 100, '2018-06-10', 2361, 1, 2, 'alumno_lic'),
(4671, 1064, 10640012, 100, '2018-06-10', 2362, 1, 2, 'alumno_lic'),
(4673, 1065, 10650012, 100, '2018-06-10', 2363, 1, 2, 'alumno_lic'),
(4675, 1066, 10660012, 100, '2018-06-10', 2364, 1, 2, 'alumno_lic'),
(4677, 1067, 10670012, 100, '2018-06-10', 2365, 1, 2, 'alumno_lic'),
(4679, 1068, 10680012, 100, '2018-06-10', 2366, 1, 2, 'alumno_lic'),
(4681, 1069, 10690012, 100, '2018-06-10', 2367, 1, 2, 'alumno_lic'),
(4683, 1070, 10700012, 750, '2018-06-11', 2368, 0, 2, 'ext_col_ent'),
(4685, 1071, 10710012, 100, '2018-06-11', 2369, 1, 2, 'alumno_lic'),
(4687, 1072, 10720012, 100, '2018-06-11', 2370, 1, 2, 'alumno_lic'),
(4689, 1073, 10730012, 100, '2018-06-11', 2371, 1, 2, 'alumno_lic'),
(4691, 1074, 10740012, 100, '2018-06-11', 2372, 1, 2, 'alumno_lic'),
(4693, 1075, 10750012, 100, '2018-06-11', 2373, 1, 2, 'alumno_lic'),
(4695, 1076, 10760012, 100, '2018-06-11', 2374, 1, 2, 'alumno_lic'),
(4697, 1077, 10770012, 100, '2018-06-11', 2375, 1, 2, 'alumno_lic'),
(4699, 1078, 10780012, 750, '2018-06-11', 2376, 1, 2, 'ext_col_ent'),
(4701, 1079, 10790012, 100, '2018-06-11', 2377, 1, 2, 'alumno_lic'),
(4703, 1080, 10800012, 100, '2018-06-11', 2378, 1, 2, 'alumno_lic'),
(4705, 1081, 10810012, 100, '2018-06-11', 2379, 1, 2, 'alumno_lic'),
(4707, 1082, 10820012, 100, '2018-06-11', 2380, 1, 2, 'alumno_lic'),
(4709, 1083, 10830012, 100, '2018-06-11', 2381, 1, 2, 'alumno_lic'),
(4711, 1084, 10840012, 100, '2018-06-11', 2382, 0, 2, 'alumno_lic'),
(4713, 1085, 10850012, 100, '2018-06-11', 2383, 1, 2, 'alumno_lic'),
(4715, 1086, 10860012, 100, '2018-06-11', 2384, 1, 2, 'alumno_lic'),
(4717, 1087, 10870012, 100, '2018-06-11', 2385, 1, 2, 'alumno_lic'),
(4719, 1088, 10880012, 100, '2018-06-11', 2386, 1, 2, 'alumno_lic'),
(4721, 1089, 10890012, 100, '2018-06-11', 2387, 1, 2, 'alumno_lic'),
(4723, 1090, 10900012, 500, '2018-06-11', 2388, 1, 2, 'alumno_mtr'),
(4725, 1091, 10910012, 100, '2018-06-11', 2389, 1, 2, 'alumno_lic'),
(4727, 1092, 10920012, 100, '2018-06-11', 2390, 1, 2, 'alumno_lic'),
(4729, 1093, 10930012, 100, '2018-06-11', 2391, 1, 2, 'alumno_lic'),
(4731, 1094, 10940012, 100, '2018-06-11', 2392, 1, 2, 'alumno_lic'),
(4733, 1095, 10950012, 100, '2018-06-11', 2393, 1, 2, 'alumno_lic'),
(4735, 1096, 10960012, 100, '2018-06-11', 2394, 1, 2, 'alumno_lic'),
(4737, 1097, 10970012, 100, '2018-06-12', 2395, 1, 2, 'alumno_lic'),
(4739, 1098, 10980012, 100, '2018-06-12', 2396, 1, 2, 'alumno_lic'),
(4741, 1099, 10990012, 0, '2018-06-12', 2397, 0, 2, 'docente'),
(4743, 1100, 11000012, 100, '2018-06-12', 2398, 0, 2, 'alumno_lic'),
(4745, 1101, 11010012, 100, '2018-06-12', 2399, 1, 2, 'alumno_lic'),
(4747, 1102, 11020012, 100, '2018-06-12', 2400, 1, 2, 'alumno_lic'),
(4749, 1103, 11030012, 100, '2018-06-12', 2401, 0, 2, 'alumno_lic'),
(4751, 1104, 11040012, 100, '2018-06-12', 2402, 1, 2, 'alumno_lic'),
(4753, 1105, 11050012, 100, '2018-06-12', 2403, 0, 2, 'alumno_lic'),
(4755, 1106, 11060012, 100, '2018-06-12', 2404, 1, 2, 'alumno_lic'),
(4757, 1107, 11070012, 100, '2018-06-12', 2405, 1, 2, 'alumno_lic'),
(4759, 1108, 11080012, 100, '2018-06-12', 2406, 1, 2, 'alumno_lic'),
(4761, 1109, 11090012, 500, '2018-06-12', 2407, 1, 2, 'alumno_mtr'),
(4763, 1110, 11100012, 0, '2018-06-13', 2408, 0, 2, 'docente'),
(4765, 1111, 11110012, 100, '2018-06-13', 2409, 0, 2, 'alumno_lic'),
(4767, 1112, 11120012, 100, '2018-06-13', 2410, 0, 2, 'alumno_lic'),
(4769, 1113, 11130012, 100, '2018-06-13', 2411, 0, 2, 'alumno_lic'),
(4771, 1114, 11140012, 100, '2018-06-14', 2412, 1, 2, 'alumno_lic'),
(4773, 1115, 11150012, 0, '2018-06-14', 2413, 0, 2, 'docente'),
(4775, 1116, 11160012, 0, '2018-06-14', 2414, 1, 2, 'docente'),
(4777, 1117, 11170012, 750, '2018-06-14', 2415, 0, 2, 'ext_col_ent'),
(4779, 1118, 11180012, 400, '2018-06-14', 2416, 0, 2, 'ext_taller'),
(4781, 1119, 11190012, 500, '2018-06-15', 2417, 0, 2, 'alumno_mtr'),
(4783, 1120, 11200012, 100, '2018-06-15', 2418, 0, 2, 'alumno_lic'),
(4785, 1121, 11210012, 100, '2018-06-15', 2420, 0, 2, 'alumno_lic'),
(4787, 1122, 11220012, 100, '2018-06-15', 2419, 0, 2, 'alumno_lic'),
(4789, 1123, 11230012, 100, '2018-06-15', 2421, 0, 2, 'alumno_lic'),
(4791, 1124, 11240012, 100, '2018-06-15', 2422, 0, 2, 'alumno_lic'),
(4793, 1125, 11250012, 100, '2018-06-15', 2423, 0, 2, 'alumno_lic'),
(4795, 1126, 11260012, 100, '2018-06-15', 2424, 0, 2, 'alumno_lic'),
(4797, 1127, 11270012, 500, '2018-06-15', 2425, 0, 2, 'alumno_mtr'),
(4799, 1128, 11280012, 100, '2018-06-16', 2426, 0, 2, 'alumno_lic'),
(4801, 1129, 11290012, 500, '2018-06-19', 2427, 0, 2, 'alumno_mtr'),
(4803, 1130, 11300012, 100, '2018-09-17', 2428, 0, 2, 'alumno_lic'),
(4805, 1131, 11310012, 0, '2018-09-18', 2429, 0, 2, 'docente'),
(4807, 1132, 11320012, 100, '2018-10-06', 2430, 0, 2, 'alumno_lic'),
(4809, 1133, 11330012, 100, '2018-11-29', 2431, 0, 2, 'alumno_lic'),
(4811, 1134, 11340012, 500, '2019-04-06', 2432, 1, 2, 'alumno_mtr');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `lista_participante`
--

CREATE TABLE `lista_participante` (
  `id_coloquio` int(11) DEFAULT NULL,
  `id_ficha` int(11) DEFAULT NULL,
  `folio` int(11) DEFAULT NULL,
  `clave_acceso` int(11) DEFAULT NULL,
  `cuota` int(11) DEFAULT NULL,
  `pagado` int(11) DEFAULT NULL,
  `libro` int(11) DEFAULT NULL,
  `id_dato` int(11) DEFAULT NULL,
  `nombre` int(11) DEFAULT NULL,
  `apellido` int(11) DEFAULT NULL,
  `genero` int(11) DEFAULT NULL,
  `rfc` int(11) DEFAULT NULL,
  `telefono` int(11) DEFAULT NULL,
  `email` int(11) DEFAULT NULL,
  `fecha_alta` int(11) DEFAULT NULL,
  `tipo` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `plan_carrera`
--

CREATE TABLE `plan_carrera` (
  `id_maestria` int(11) NOT NULL,
  `tipo_carrera` varchar(100) NOT NULL COMMENT 'Tipo del plan de estudios Maestria, Licenciatura',
  `comentario` varchar(100) NOT NULL,
  `carrera` varchar(500) NOT NULL COMMENT 'Nombre de la carrera'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `plan_carrera`
--

INSERT INTO `plan_carrera` (`id_maestria`, `tipo_carrera`, `comentario`, `carrera`) VALUES
(1, 'MAESTRIA', '', 'EN EDUCACION'),
(2, 'MAESTRIA', '', 'EN GESTION EDUCATIVA'),
(3, 'MAESTRIA', '', 'EN INTEGRACION EDUCATIVA'),
(4, 'MAESTRIA', '', 'EN EDUCACION MEDIA SUPERIOR'),
(5, 'LICENCIATURA', '', 'LE-94'),
(6, 'LICENCIATURA', '', 'LEPEPMI-90'),
(7, 'LICENCIATURA', '', 'LIE'),
(8, 'ESPECIALIZACIÓN', '', 'ESP. DIDACT. DE LAS MATEMATICAS P. EDUC. PRIM.'),
(9, 'LICENCIATURA', '', 'PEDAGOGIA');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `prog_coloquio`
--

CREATE TABLE `prog_coloquio` (
  `idprog_coloquio` int(11) NOT NULL,
  `ficha_id_ficha` int(11) NOT NULL,
  `coloquio_id_coloquio` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `prog_coloquio`
--

INSERT INTO `prog_coloquio` (`idprog_coloquio`, `ficha_id_ficha`, `coloquio_id_coloquio`) VALUES
(1307, 2531, 12),
(1308, 2533, 12),
(1309, 2535, 12),
(1310, 2537, 12),
(1311, 2539, 12),
(1312, 2541, 12),
(1313, 2543, 12),
(1314, 2545, 12),
(1315, 2547, 12),
(1316, 2549, 12),
(1317, 2551, 12),
(1318, 2553, 12),
(1319, 2555, 12),
(1320, 2557, 12),
(1321, 2559, 12),
(1322, 2561, 12),
(1323, 2563, 12),
(1324, 2565, 12),
(1325, 2567, 12),
(1326, 2569, 12),
(1327, 2571, 12),
(1328, 2573, 12),
(1329, 2575, 12),
(1330, 2577, 12),
(1331, 2579, 12),
(1332, 2581, 12),
(1333, 2583, 12),
(1334, 2585, 12),
(1335, 2587, 12),
(1336, 2589, 12),
(1337, 2591, 12),
(1338, 2593, 12),
(1339, 2595, 12),
(1340, 2597, 12),
(1341, 2599, 12),
(1342, 2601, 12),
(1343, 2603, 12),
(1344, 2605, 12),
(1345, 2607, 12),
(1346, 2609, 12),
(1347, 2611, 12),
(1348, 2613, 12),
(1349, 2615, 12),
(1350, 2617, 12),
(1351, 2619, 12),
(1352, 2621, 12),
(1353, 2623, 12),
(1354, 2625, 12),
(1355, 2627, 12),
(1356, 2629, 12),
(1357, 2631, 12),
(1358, 2633, 12),
(1359, 2635, 12),
(1360, 2637, 12),
(1361, 2639, 12),
(1362, 2641, 12),
(1363, 2643, 12),
(1364, 2645, 12),
(1365, 2647, 12),
(1366, 2649, 12),
(1367, 2651, 12),
(1368, 2653, 12),
(1369, 2655, 12),
(1370, 2657, 12),
(1371, 2659, 12),
(1372, 2661, 12),
(1373, 2663, 12),
(1374, 2665, 12),
(1375, 2667, 12),
(1376, 2669, 12),
(1377, 2671, 12),
(1378, 2673, 12),
(1379, 2675, 12),
(1380, 2677, 12),
(1381, 2679, 12),
(1382, 2681, 12),
(1383, 2683, 12),
(1384, 2685, 12),
(1385, 2687, 12),
(1386, 2689, 12),
(1387, 2691, 12),
(1388, 2693, 12),
(1389, 2695, 12),
(1390, 2697, 12),
(1391, 2699, 12),
(1392, 2701, 12),
(1393, 2703, 12),
(1394, 2705, 12),
(1395, 2707, 12),
(1396, 2709, 12),
(1397, 2711, 12),
(1398, 2713, 12),
(1399, 2715, 12),
(1400, 2717, 12),
(1401, 2719, 12),
(1402, 2721, 12),
(1403, 2723, 12),
(1404, 2725, 12),
(1405, 2727, 12),
(1406, 2729, 12),
(1407, 2731, 12),
(1408, 2733, 12),
(1409, 2735, 12),
(1410, 2737, 12),
(1411, 2739, 12),
(1412, 2741, 12),
(1413, 2743, 12),
(1414, 2745, 12),
(1415, 2747, 12),
(1416, 2749, 12),
(1417, 2751, 12),
(1418, 2753, 12),
(1419, 2755, 12),
(1420, 2757, 12),
(1421, 2759, 12),
(1422, 2761, 12),
(1423, 2763, 12),
(1424, 2765, 12),
(1425, 2767, 12),
(1426, 2769, 12),
(1427, 2771, 12),
(1428, 2773, 12),
(1429, 2775, 12),
(1430, 2777, 12),
(1431, 2779, 12),
(1432, 2781, 12),
(1433, 2783, 12),
(1434, 2785, 12),
(1435, 2787, 12),
(1436, 2789, 12),
(1437, 2791, 12),
(1438, 2793, 12),
(1439, 2795, 12),
(1440, 2797, 12),
(1441, 2799, 12),
(1442, 2801, 12),
(1443, 2803, 12),
(1444, 2805, 12),
(1445, 2807, 12),
(1446, 2809, 12),
(1447, 2811, 12),
(1448, 2813, 12),
(1449, 2815, 12),
(1450, 2817, 12),
(1451, 2819, 12),
(1452, 2821, 12),
(1453, 2823, 12),
(1454, 2825, 12),
(1455, 2827, 12),
(1456, 2829, 12),
(1457, 2831, 12),
(1458, 2833, 12),
(1459, 2835, 12),
(1460, 2837, 12),
(1461, 2839, 12),
(1462, 2841, 12),
(1463, 2843, 12),
(1464, 2845, 12),
(1465, 2847, 12),
(1466, 2849, 12),
(1467, 2851, 12),
(1468, 2853, 12),
(1469, 2855, 12),
(1470, 2857, 12),
(1471, 2859, 12),
(1472, 2861, 12),
(1473, 2863, 12),
(1474, 2865, 12),
(1475, 2867, 12),
(1476, 2869, 12),
(1477, 2871, 12),
(1478, 2873, 12),
(1479, 2875, 12),
(1480, 2877, 12),
(1481, 2879, 12),
(1482, 2881, 12),
(1483, 2883, 12),
(1484, 2885, 12),
(1485, 2887, 12),
(1486, 2889, 12),
(1487, 2891, 12),
(1488, 2893, 12),
(1489, 2895, 12),
(1490, 2897, 12),
(1491, 2899, 12),
(1492, 2901, 12),
(1493, 2903, 12),
(1494, 2905, 12),
(1495, 2907, 12),
(1496, 2909, 12),
(1497, 2911, 12),
(1498, 2913, 12),
(1499, 2915, 12),
(1500, 2917, 12),
(1501, 2919, 12),
(1502, 2921, 12),
(1503, 2923, 12),
(1504, 2925, 12),
(1505, 2927, 12),
(1506, 2929, 12),
(1507, 2931, 12),
(1508, 2933, 12),
(1509, 2935, 12),
(1510, 2937, 12),
(1511, 2939, 12),
(1512, 2941, 12),
(1513, 2943, 12),
(1514, 2945, 12),
(1515, 2947, 12),
(1516, 2949, 12),
(1517, 2951, 12),
(1518, 2953, 12),
(1519, 2955, 12),
(1520, 2957, 12),
(1521, 2959, 12),
(1522, 2961, 12),
(1523, 2963, 12),
(1524, 2965, 12),
(1525, 2967, 12),
(1526, 2969, 12),
(1527, 2971, 12),
(1528, 2973, 12),
(1529, 2975, 12),
(1530, 2977, 12),
(1531, 2979, 12),
(1532, 2981, 12),
(1533, 2983, 12),
(1534, 2985, 12),
(1535, 2987, 12),
(1536, 2989, 12),
(1537, 2991, 12),
(1538, 2993, 12),
(1539, 2995, 12),
(1540, 2997, 12),
(1541, 2999, 12),
(1542, 3001, 12),
(1543, 3003, 12),
(1544, 3005, 12),
(1545, 3007, 12),
(1546, 3009, 12),
(1547, 3011, 12),
(1548, 3013, 12),
(1549, 3015, 12),
(1550, 3017, 12),
(1551, 3019, 12),
(1552, 3021, 12),
(1553, 3023, 12),
(1554, 3025, 12),
(1555, 3027, 12),
(1556, 3029, 12),
(1557, 3031, 12),
(1558, 3033, 12),
(1559, 3035, 12),
(1560, 3037, 12),
(1561, 3039, 12),
(1562, 3041, 12),
(1563, 3043, 12),
(1564, 3045, 12),
(1565, 3047, 12),
(1566, 3049, 12),
(1567, 3051, 12),
(1568, 3053, 12),
(1569, 3055, 12),
(1570, 3057, 12),
(1571, 3059, 12),
(1572, 3061, 12),
(1573, 3063, 12),
(1574, 3065, 12),
(1575, 3067, 12),
(1576, 3069, 12),
(1577, 3071, 12),
(1578, 3073, 12),
(1579, 3075, 12),
(1580, 3077, 12),
(1581, 3079, 12),
(1582, 3081, 12),
(1583, 3083, 12),
(1584, 3085, 12),
(1585, 3087, 12),
(1586, 3089, 12),
(1587, 3091, 12),
(1588, 3093, 12),
(1589, 3095, 12),
(1590, 3097, 12),
(1591, 3099, 12),
(1592, 3101, 12),
(1593, 3103, 12),
(1594, 3105, 12),
(1595, 3107, 12),
(1596, 3109, 12),
(1597, 3111, 12),
(1598, 3113, 12),
(1599, 3115, 12),
(1600, 3117, 12),
(1601, 3119, 12),
(1602, 3121, 12),
(1603, 3123, 12),
(1604, 3125, 12),
(1605, 3127, 12),
(1606, 3129, 12),
(1607, 3131, 12),
(1608, 3133, 12),
(1609, 3135, 12),
(1610, 3137, 12),
(1611, 3139, 12),
(1612, 3141, 12),
(1613, 3143, 12),
(1614, 3145, 12),
(1615, 3147, 12),
(1616, 3149, 12),
(1617, 3151, 12),
(1618, 3153, 12),
(1619, 3155, 12),
(1620, 3157, 12),
(1621, 3159, 12),
(1622, 3161, 12),
(1623, 3163, 12),
(1624, 3165, 12),
(1625, 3167, 12),
(1626, 3169, 12),
(1627, 3171, 12),
(1628, 3173, 12),
(1629, 3175, 12),
(1630, 3177, 12),
(1631, 3179, 12),
(1632, 3181, 12),
(1633, 3183, 12),
(1634, 3185, 12),
(1635, 3187, 12),
(1636, 3189, 12),
(1637, 3191, 12),
(1638, 3193, 12),
(1639, 3195, 12),
(1640, 3197, 12),
(1641, 3199, 12),
(1642, 3201, 12),
(1643, 3203, 12),
(1644, 3205, 12),
(1645, 3207, 12),
(1646, 3209, 12),
(1647, 3211, 12),
(1648, 3213, 12),
(1649, 3215, 12),
(1650, 3217, 12),
(1651, 3219, 12),
(1652, 3221, 12),
(1653, 3223, 12),
(1654, 3225, 12),
(1655, 3227, 12),
(1656, 3229, 12),
(1657, 3231, 12),
(1658, 3233, 12),
(1659, 3235, 12),
(1660, 3237, 12),
(1661, 3239, 12),
(1662, 3241, 12),
(1663, 3243, 12),
(1664, 3245, 12),
(1665, 3247, 12),
(1666, 3249, 12),
(1667, 3251, 12),
(1668, 3253, 12),
(1669, 3255, 12),
(1670, 3257, 12),
(1671, 3259, 12),
(1672, 3261, 12),
(1673, 3263, 12),
(1674, 3265, 12),
(1675, 3267, 12),
(1676, 3269, 12),
(1677, 3271, 12),
(1678, 3273, 12),
(1679, 3275, 12),
(1680, 3277, 12),
(1681, 3279, 12),
(1682, 3281, 12),
(1683, 3283, 12),
(1684, 3285, 12),
(1685, 3287, 12),
(1686, 3289, 12),
(1687, 3291, 12),
(1688, 3293, 12),
(1689, 3295, 12),
(1690, 3297, 12),
(1691, 3299, 12),
(1692, 3301, 12),
(1693, 3303, 12),
(1694, 3305, 12),
(1695, 3307, 12),
(1696, 3309, 12),
(1697, 3311, 12),
(1698, 3313, 12),
(1699, 3315, 12),
(1700, 3317, 12),
(1701, 3319, 12),
(1702, 3321, 12),
(1703, 3323, 12),
(1704, 3325, 12),
(1705, 3327, 12),
(1706, 3329, 12),
(1707, 3331, 12),
(1708, 3333, 12),
(1709, 3335, 12),
(1710, 3337, 12),
(1711, 3339, 12),
(1712, 3341, 12),
(1713, 3343, 12),
(1714, 3345, 12),
(1715, 3347, 12),
(1716, 3349, 12),
(1717, 3351, 12),
(1718, 3353, 12),
(1719, 3355, 12),
(1720, 3357, 12),
(1721, 3359, 12),
(1722, 3361, 12),
(1723, 3363, 12),
(1724, 3365, 12),
(1725, 3367, 12),
(1726, 3369, 12),
(1727, 3371, 12),
(1728, 3373, 12),
(1729, 3375, 12),
(1730, 3377, 12),
(1731, 3379, 12),
(1732, 3381, 12),
(1733, 3383, 12),
(1734, 3385, 12),
(1735, 3387, 12),
(1736, 3389, 12),
(1737, 3391, 12),
(1738, 3393, 12),
(1739, 3395, 12),
(1740, 3397, 12),
(1741, 3399, 12),
(1742, 3401, 12),
(1743, 3403, 12),
(1744, 3405, 12),
(1745, 3407, 12),
(1746, 3409, 12),
(1747, 3411, 12),
(1748, 3413, 12),
(1749, 3415, 12),
(1750, 3417, 12),
(1751, 3419, 12),
(1752, 3421, 12),
(1753, 3423, 12),
(1754, 3425, 12),
(1755, 3427, 12),
(1756, 3429, 12),
(1757, 3431, 12),
(1758, 3433, 12),
(1759, 3435, 12),
(1760, 3437, 12),
(1761, 3439, 12),
(1762, 3441, 12),
(1763, 3443, 12),
(1764, 3445, 12),
(1765, 3447, 12),
(1766, 3449, 12),
(1767, 3451, 12),
(1768, 3453, 12),
(1769, 3455, 12),
(1770, 3457, 12),
(1771, 3459, 12),
(1772, 3461, 12),
(1773, 3463, 12),
(1774, 3465, 12),
(1775, 3467, 12),
(1776, 3469, 12),
(1777, 3471, 12),
(1778, 3473, 12),
(1779, 3475, 12),
(1780, 3477, 12),
(1781, 3479, 12),
(1782, 3481, 12),
(1783, 3483, 12),
(1784, 3485, 12),
(1785, 3487, 12),
(1786, 3489, 12),
(1787, 3491, 12),
(1789, 3495, 12),
(1790, 3497, 12),
(1791, 3499, 12),
(1792, 3501, 12),
(1793, 3503, 12),
(1794, 3505, 12),
(1795, 3507, 12),
(1796, 3509, 12),
(1797, 3511, 12),
(1798, 3513, 12),
(1799, 3515, 12),
(1800, 3517, 12),
(1801, 3519, 12),
(1802, 3521, 12),
(1803, 3523, 12),
(1804, 3525, 12),
(1805, 3527, 12),
(1806, 3529, 12),
(1807, 3531, 12),
(1808, 3533, 12),
(1809, 3535, 12),
(1810, 3537, 12),
(1811, 3539, 12),
(1812, 3541, 12),
(1813, 3543, 12),
(1814, 3545, 12),
(1815, 3547, 12),
(1816, 3549, 12),
(1817, 3551, 12),
(1818, 3553, 12),
(1819, 3555, 12),
(1820, 3557, 12),
(1821, 3559, 12),
(1822, 3561, 12),
(1823, 3563, 12),
(1824, 3565, 12),
(1825, 3567, 12),
(1826, 3569, 12),
(1827, 3571, 12),
(1828, 3573, 12),
(1829, 3581, 12),
(1830, 3583, 12),
(1831, 3585, 12),
(1832, 3587, 12),
(1833, 3589, 12),
(1834, 3591, 12),
(1835, 3593, 12),
(1836, 3595, 12),
(1837, 3597, 12),
(1838, 3599, 12),
(1839, 3601, 12),
(1840, 3603, 12),
(1841, 3605, 12),
(1842, 3607, 12),
(1843, 3609, 12),
(1844, 3611, 12),
(1845, 3613, 12),
(1846, 3615, 12),
(1847, 3617, 12),
(1848, 3619, 12),
(1849, 3621, 12),
(1850, 3623, 12),
(1851, 3625, 12),
(1852, 3627, 12),
(1853, 3629, 12),
(1854, 3631, 12),
(1855, 3633, 12),
(1856, 3635, 12),
(1857, 3637, 12),
(1858, 3639, 12),
(1859, 3641, 12),
(1860, 3643, 12),
(1863, 3649, 12),
(1864, 3651, 12),
(1865, 3653, 12),
(1866, 3655, 12),
(1867, 3657, 12),
(1868, 3659, 12),
(1869, 3661, 12),
(1870, 3663, 12),
(1871, 3665, 12),
(1872, 3667, 12),
(1873, 3669, 12),
(1874, 3671, 12),
(1875, 3673, 12),
(1876, 3675, 12),
(1877, 3677, 12),
(1878, 3679, 12),
(1879, 3681, 12),
(1880, 3683, 12),
(1881, 3685, 12),
(1882, 3687, 12),
(1883, 3689, 12),
(1884, 3691, 12),
(1885, 3693, 12),
(1886, 3695, 12),
(1887, 3697, 12),
(1888, 3699, 12),
(1889, 3701, 12),
(1890, 3703, 12),
(1891, 3705, 12),
(1892, 3707, 12),
(1893, 3709, 12),
(1894, 3711, 12),
(1895, 3713, 12),
(1896, 3715, 12),
(1897, 3717, 12),
(1898, 3719, 12),
(1899, 3721, 12),
(1900, 3723, 12),
(1901, 3725, 12),
(1902, 3727, 12),
(1903, 3729, 12),
(1904, 3731, 12),
(1905, 3733, 12),
(1906, 3735, 12),
(1907, 3737, 12),
(1908, 3739, 12),
(1909, 3741, 12),
(1910, 3743, 12),
(1911, 3745, 12),
(1912, 3747, 12),
(1913, 3749, 12),
(1914, 3751, 12),
(1915, 3753, 12),
(1916, 3755, 12),
(1917, 3757, 12),
(1918, 3759, 12),
(1919, 3761, 12),
(1920, 3763, 12),
(1921, 3765, 12),
(1922, 3767, 12),
(1923, 3769, 12),
(1924, 3771, 12),
(1925, 3773, 12),
(1926, 3775, 12),
(1927, 3777, 12),
(1928, 3779, 12),
(1929, 3781, 12),
(1930, 3783, 12),
(1931, 3785, 12),
(1932, 3787, 12),
(1933, 3789, 12),
(1934, 3791, 12),
(1935, 3793, 12),
(1936, 3795, 12),
(1937, 3797, 12),
(1938, 3799, 12),
(1939, 3801, 12),
(1940, 3803, 12),
(1941, 3805, 12),
(1942, 3807, 12),
(1943, 3809, 12),
(1944, 3811, 12),
(1945, 3813, 12),
(1946, 3815, 12),
(1947, 3817, 12),
(1948, 3819, 12),
(1949, 3821, 12),
(1950, 3823, 12),
(1951, 3825, 12),
(1952, 3827, 12),
(1953, 3829, 12),
(1954, 3831, 12),
(1955, 3833, 12),
(1956, 3835, 12),
(1957, 3837, 12),
(1958, 3839, 12),
(1959, 3841, 12),
(1960, 3843, 12),
(1961, 3845, 12),
(1962, 3847, 12),
(1963, 3849, 12),
(1964, 3851, 12),
(1965, 3853, 12),
(1966, 3855, 12),
(1967, 3857, 12),
(1968, 3859, 12),
(1969, 3861, 12),
(1970, 3863, 12),
(1971, 3865, 12),
(1972, 3867, 12),
(1973, 3869, 12),
(1974, 3871, 12),
(1975, 3873, 12),
(1976, 3875, 12),
(1977, 3877, 12),
(1978, 3879, 12),
(1979, 3881, 12),
(1980, 3883, 12),
(1981, 3885, 12),
(1982, 3887, 12),
(1983, 3889, 12),
(1984, 3891, 12),
(1985, 3893, 12),
(1986, 3895, 12),
(1987, 3897, 12),
(1988, 3899, 12),
(1989, 3901, 12),
(1990, 3903, 12),
(1991, 3905, 12),
(1992, 3907, 12),
(1993, 3909, 12),
(1994, 3911, 12),
(1995, 3915, 12),
(1996, 3917, 12),
(1997, 3919, 12),
(1998, 3921, 12),
(1999, 3923, 12),
(2000, 3925, 12),
(2001, 3927, 12),
(2002, 3929, 12),
(2003, 3931, 12),
(2004, 3933, 12),
(2005, 3935, 12),
(2006, 3937, 12),
(2007, 3939, 12),
(2008, 3941, 12),
(2009, 3943, 12),
(2010, 3945, 12),
(2011, 3947, 12),
(2012, 3949, 12),
(2013, 3951, 12),
(2014, 3953, 12),
(2015, 3955, 12),
(2016, 3957, 12),
(2017, 3959, 12),
(2018, 3961, 12),
(2019, 3963, 12),
(2020, 3965, 12),
(2021, 3967, 12),
(2022, 3969, 12),
(2023, 3971, 12),
(2024, 3973, 12),
(2025, 3975, 12),
(2026, 3977, 12),
(2027, 3979, 12),
(2028, 3981, 12),
(2029, 3983, 12),
(2030, 3985, 12),
(2031, 3987, 12),
(2032, 3989, 12),
(2033, 3991, 12),
(2034, 3993, 12),
(2035, 3995, 12),
(2036, 3997, 12),
(2037, 3999, 12),
(2038, 4001, 12),
(2039, 4003, 12),
(2040, 4005, 12),
(2041, 4007, 12),
(2042, 4009, 12),
(2043, 4011, 12),
(2044, 4013, 12),
(2045, 4015, 12),
(2046, 4017, 12),
(2047, 4019, 12),
(2048, 4021, 12),
(2049, 4023, 12),
(2050, 4025, 12),
(2051, 4027, 12),
(2052, 4029, 12),
(2053, 4031, 12),
(2054, 4033, 12),
(2055, 4035, 12),
(2056, 4037, 12),
(2057, 4039, 12),
(2058, 4041, 12),
(2059, 4043, 12),
(2060, 4045, 12),
(2061, 4047, 12),
(2062, 4049, 12),
(2063, 4051, 12),
(2064, 4053, 12),
(2065, 4055, 12),
(2066, 4057, 12),
(2067, 4059, 12),
(2068, 4061, 12),
(2069, 4063, 12),
(2070, 4065, 12),
(2071, 4067, 12),
(2072, 4069, 12),
(2073, 4071, 12),
(2074, 4073, 12),
(2075, 4075, 12),
(2076, 4077, 12),
(2077, 4079, 12),
(2078, 4081, 12),
(2079, 4083, 12),
(2080, 4085, 12),
(2081, 4087, 12),
(2082, 4089, 12),
(2083, 4091, 12),
(2084, 4093, 12),
(2085, 4095, 12),
(2086, 4097, 12),
(2087, 4099, 12),
(2088, 4101, 12),
(2089, 4103, 12),
(2090, 4105, 12),
(2091, 4107, 12),
(2092, 4109, 12),
(2093, 4111, 12),
(2094, 4113, 12),
(2095, 4115, 12),
(2096, 4117, 12),
(2097, 4119, 12),
(2098, 4121, 12),
(2099, 4123, 12),
(2100, 4125, 12),
(2101, 4127, 12),
(2102, 4129, 12),
(2103, 4131, 12),
(2104, 4133, 12),
(2105, 4135, 12),
(2106, 4137, 12),
(2107, 4139, 12),
(2108, 4141, 12),
(2109, 4143, 12),
(2110, 4145, 12),
(2111, 4147, 12),
(2112, 4149, 12),
(2113, 4151, 12),
(2114, 4153, 12),
(2115, 4155, 12),
(2116, 4157, 12),
(2117, 4159, 12),
(2118, 4161, 12),
(2119, 4163, 12),
(2120, 4165, 12),
(2121, 4167, 12),
(2122, 4169, 12),
(2123, 4171, 12),
(2124, 4173, 12),
(2125, 4175, 12),
(2126, 4177, 12),
(2127, 4179, 12),
(2128, 4181, 12),
(2129, 4183, 12),
(2130, 4185, 12),
(2131, 4187, 12),
(2132, 4189, 12),
(2133, 4191, 12),
(2134, 4193, 12),
(2135, 4195, 12),
(2136, 4197, 12),
(2137, 4199, 12),
(2138, 4201, 12),
(2139, 4203, 12),
(2140, 4205, 12),
(2141, 4207, 12),
(2142, 4209, 12),
(2143, 4211, 12),
(2144, 4213, 12),
(2145, 4215, 12),
(2146, 4217, 12),
(2147, 4219, 12),
(2148, 4221, 12),
(2149, 4223, 12),
(2150, 4225, 12),
(2151, 4227, 12),
(2152, 4229, 12),
(2153, 4231, 12),
(2154, 4233, 12),
(2155, 4235, 12),
(2156, 4237, 12),
(2157, 4239, 12),
(2158, 4241, 12),
(2159, 4243, 12),
(2160, 4245, 12),
(2161, 4247, 12),
(2162, 4249, 12),
(2163, 4251, 12),
(2164, 4253, 12),
(2165, 4255, 12),
(2166, 4257, 12),
(2167, 4259, 12),
(2168, 4261, 12),
(2169, 4263, 12),
(2170, 4265, 12),
(2171, 4267, 12),
(2172, 4269, 12),
(2173, 4271, 12),
(2174, 4273, 12),
(2175, 4275, 12),
(2176, 4277, 12),
(2177, 4279, 12),
(2178, 4281, 12),
(2179, 4283, 12),
(2180, 4285, 12),
(2181, 4287, 12),
(2182, 4289, 12),
(2183, 4291, 12),
(2184, 4293, 12),
(2185, 4295, 12),
(2186, 4297, 12),
(2187, 4299, 12),
(2188, 4301, 12),
(2189, 4303, 12),
(2190, 4305, 12),
(2191, 4307, 12),
(2192, 4309, 12),
(2193, 4311, 12),
(2194, 4313, 12),
(2195, 4315, 12),
(2196, 4317, 12),
(2197, 4319, 12),
(2198, 4321, 12),
(2199, 4323, 12),
(2200, 4325, 12),
(2201, 4327, 12),
(2202, 4329, 12),
(2203, 4331, 12),
(2204, 4333, 12),
(2205, 4335, 12),
(2206, 4337, 12),
(2207, 4339, 12),
(2208, 4341, 12),
(2209, 4343, 12),
(2210, 4345, 12),
(2211, 4347, 12),
(2212, 4349, 12),
(2213, 4351, 12),
(2214, 4353, 12),
(2215, 4355, 12),
(2216, 4357, 12),
(2217, 4359, 12),
(2218, 4361, 12),
(2219, 4363, 12),
(2220, 4365, 12),
(2221, 4367, 12),
(2222, 4369, 12),
(2223, 4371, 12),
(2224, 4373, 12),
(2225, 4375, 12),
(2226, 4377, 12),
(2227, 4379, 12),
(2228, 4381, 12),
(2229, 4383, 12),
(2230, 4385, 12),
(2231, 4387, 12),
(2232, 4389, 12),
(2233, 4391, 12),
(2234, 4393, 12),
(2235, 4395, 12),
(2236, 4397, 12),
(2237, 4399, 12),
(2238, 4401, 12),
(2239, 4403, 12),
(2240, 4405, 12),
(2241, 4407, 12),
(2242, 4409, 12),
(2243, 4411, 12),
(2244, 4413, 12),
(2245, 4415, 12),
(2246, 4417, 12),
(2247, 4419, 12),
(2248, 4421, 12),
(2249, 4423, 12),
(2250, 4425, 12),
(2251, 4427, 12),
(2252, 4429, 12),
(2253, 4431, 12),
(2254, 4433, 12),
(2255, 4435, 12),
(2256, 4437, 12),
(2257, 4439, 12),
(2258, 4441, 12),
(2259, 4443, 12),
(2260, 4445, 12),
(2261, 4447, 12),
(2262, 4449, 12),
(2263, 4451, 12),
(2264, 4453, 12),
(2265, 4455, 12),
(2266, 4457, 12),
(2267, 4459, 12),
(2268, 4461, 12),
(2269, 4463, 12),
(2270, 4465, 12),
(2271, 4467, 12),
(2272, 4469, 12),
(2273, 4471, 12),
(2274, 4473, 12),
(2275, 4475, 12),
(2276, 4477, 12),
(2277, 4479, 12),
(2278, 4481, 12),
(2279, 4483, 12),
(2280, 4485, 12),
(2281, 4487, 12),
(2282, 4489, 12),
(2283, 4491, 12),
(2284, 4493, 12),
(2285, 4495, 12),
(2286, 4497, 12),
(2287, 4499, 12),
(2288, 4501, 12),
(2289, 4503, 12),
(2290, 4505, 12),
(2291, 4507, 12),
(2292, 4509, 12),
(2293, 4511, 12),
(2294, 4513, 12),
(2295, 4515, 12),
(2296, 4517, 12),
(2297, 4519, 12),
(2298, 4521, 12),
(2299, 4523, 12),
(2300, 4525, 12),
(2301, 4527, 12),
(2302, 4529, 12),
(2303, 4531, 12),
(2304, 4533, 12),
(2305, 4535, 12),
(2306, 4537, 12),
(2307, 4539, 12),
(2308, 4541, 12),
(2309, 4543, 12),
(2310, 4545, 12),
(2311, 4547, 12),
(2312, 4549, 12),
(2313, 4551, 12),
(2314, 4553, 12),
(2315, 4555, 12),
(2316, 4557, 12),
(2317, 4559, 12),
(2318, 4561, 12),
(2319, 4563, 12),
(2320, 4565, 12),
(2321, 4567, 12),
(2322, 4569, 12),
(2323, 4571, 12),
(2324, 4573, 12),
(2325, 4575, 12),
(2326, 4577, 12),
(2327, 4579, 12),
(2328, 4581, 12),
(2329, 4583, 12),
(2330, 4585, 12),
(2331, 4587, 12),
(2332, 4589, 12),
(2333, 4591, 12),
(2334, 4593, 12),
(2335, 4595, 12),
(2336, 4597, 12),
(2337, 4599, 12),
(2338, 4601, 12),
(2339, 4603, 12),
(2340, 4605, 12),
(2341, 4607, 12),
(2342, 4609, 12),
(2343, 4611, 12),
(2344, 4613, 12),
(2345, 4615, 12),
(2346, 4617, 12),
(2347, 4619, 12),
(2348, 4621, 12),
(2349, 4623, 12),
(2350, 4625, 12),
(2351, 4627, 12),
(2352, 4629, 12),
(2353, 4631, 12),
(2354, 4633, 12),
(2355, 4635, 12),
(2356, 4637, 12),
(2357, 4639, 12),
(2358, 4641, 12),
(2359, 4643, 12),
(2360, 4645, 12),
(2361, 4647, 12),
(2362, 4649, 12),
(2363, 4651, 12),
(2364, 4653, 12),
(2365, 4655, 12),
(2366, 4657, 12),
(2367, 4659, 12),
(2368, 4661, 12),
(2370, 4665, 12),
(2371, 4667, 12),
(2372, 4669, 12),
(2373, 4671, 12),
(2374, 4673, 12),
(2375, 4675, 12),
(2376, 4677, 12),
(2377, 4679, 12),
(2378, 4681, 12),
(2379, 4683, 12),
(2380, 4685, 12),
(2381, 4687, 12),
(2382, 4689, 12),
(2383, 4691, 12),
(2384, 4693, 12),
(2385, 4695, 12),
(2386, 4697, 12),
(2387, 4699, 12),
(2388, 4701, 12),
(2389, 4703, 12),
(2390, 4705, 12),
(2391, 4707, 12),
(2392, 4709, 12),
(2393, 4711, 12),
(2394, 4713, 12),
(2395, 4715, 12),
(2396, 4717, 12),
(2397, 4719, 12),
(2398, 4721, 12),
(2399, 4723, 12),
(2400, 4725, 12),
(2401, 4727, 12),
(2402, 4729, 12),
(2403, 4731, 12),
(2404, 4733, 12),
(2405, 4735, 12),
(2406, 4737, 12),
(2407, 4739, 12),
(2408, 4741, 12),
(2409, 4743, 12),
(2410, 4745, 12),
(2411, 4747, 12),
(2412, 4749, 12),
(2413, 4751, 12),
(2414, 4753, 12),
(2415, 4755, 12),
(2416, 4757, 12),
(2417, 4759, 12),
(2418, 4761, 12),
(2419, 4763, 12),
(2420, 4765, 12),
(2421, 4767, 12),
(2422, 4769, 12),
(2423, 4771, 12),
(2424, 4773, 12),
(2425, 4775, 12),
(2426, 4777, 12),
(2427, 4779, 12),
(2428, 4781, 12),
(2429, 4783, 12),
(2430, 4785, 12),
(2431, 4787, 12),
(2432, 4789, 12),
(2433, 4791, 12),
(2434, 4793, 12),
(2435, 4795, 12),
(2436, 4797, 12),
(2437, 4799, 12),
(2438, 4801, 12),
(2439, 4803, 12),
(2440, 4805, 12),
(2441, 4807, 12),
(2442, 4809, 12),
(2443, 4811, 12);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `prog_participante`
--

CREATE TABLE `prog_participante` (
  `idprog_participante` int(11) NOT NULL,
  `evento_id` int(11) NOT NULL,
  `ficha_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `p_alumnolicenciatura`
--

CREATE TABLE `p_alumnolicenciatura` (
  `id_al` int(11) NOT NULL,
  `licentura` varchar(100) NOT NULL,
  `id_participante` int(11) NOT NULL,
  `sede_id_sede` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `p_alumnomaestria`
--

CREATE TABLE `p_alumnomaestria` (
  `id_am` int(11) NOT NULL,
  `semestre` varchar(100) NOT NULL,
  `maestria_id` int(11) NOT NULL,
  `sede_id` int(11) NOT NULL,
  `id_participante` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `p_alumnomaestria`
--

INSERT INTO `p_alumnomaestria` (`id_am`, `semestre`, `maestria_id`, `sede_id`, `id_participante`) VALUES
(544, '2', 1, 1, 1299),
(545, '2', 1, 1, 1302),
(546, 'SEGUNDO', 4, 2, 1313),
(547, '2', 2, 2, 1314),
(548, 'Segundo', 2, 2, 1315),
(549, 'Tercero', 2, 2, 1316),
(550, '3%C2%B0 ', 1, 2, 1317),
(551, 'Primero', 2, 2, 1318),
(552, 'Segundo', 4, 2, 1319),
(553, 'Segundo', 4, 2, 1320),
(554, 'Tercero', 2, 5, 1322),
(555, 'Tercero', 2, 5, 1323),
(556, 'TERCER SEMESTRE', 2, 5, 1328),
(557, 'SEGUNDO', 4, 2, 1329),
(558, 'SEGUNDO', 4, 2, 1330),
(559, 'TERCERO', 2, 2, 1331),
(560, '2do.', 4, 2, 1332),
(561, 'SEGUNDO', 4, 2, 1333),
(562, '2', 4, 2, 1334),
(563, '3', 1, 2, 1335),
(564, 'PRIMER', 1, 2, 1336),
(565, 'TERCER', 1, 2, 1338),
(566, '3er. SEMESTRE', 1, 2, 1339),
(567, '3', 2, 2, 1343),
(568, 'PRIMER SEMESTRE', 2, 1, 1344),
(569, 'tercero', 1, 2, 1346),
(570, 'Primero', 2, 2, 1348),
(571, 'Primero', 2, 2, 1349),
(572, 'Primero', 2, 2, 1352),
(573, 'segundo', 2, 2, 1353),
(574, '3', 2, 2, 1355),
(575, '1', 2, 2, 1356),
(576, '1 ', 2, 2, 1358),
(577, 'PRIMERO', 2, 2, 1359),
(578, 'TERCERO', 1, 2, 1364),
(579, '1', 2, 2, 1366),
(580, '3', 2, 2, 1367),
(581, 'Tercero', 2, 2, 1368),
(582, '3', 1, 2, 1369),
(583, 'TERCERO', 2, 5, 1383),
(584, 'TERCERO', 2, 2, 1391),
(585, 'TERCERO', 2, 2, 1395),
(586, 'SEGUNDO', 2, 2, 1396),
(587, 'TERCERO', 1, 2, 1397),
(588, 'TERCERO', 1, 2, 1399),
(589, '3', 2, 2, 1401),
(590, 'TERCERO ', 1, 2, 1403),
(591, 'TERCERO ', 1, 2, 1405),
(592, 'PRIMERO', 2, 2, 1406),
(593, 'PRIMERO', 2, 2, 1407),
(594, '3ro', 1, 2, 1408),
(595, '3ro', 1, 2, 1409),
(596, '3ero A', 1, 2, 1410),
(597, '2DO.SEMESTRE', 2, 2, 1411),
(598, 'TERCER SEMESTRE', 1, 2, 1412),
(599, '2DO.SEMESTRE', 2, 2, 1413),
(600, 'TERSERO ', 2, 5, 1414),
(601, 'III', 2, 5, 1415),
(602, 'tercero', 1, 1, 1416),
(603, 'PRIMERO', 2, 2, 1417),
(604, 'PRIMERO', 2, 2, 1418),
(605, 'PRIMERO', 2, 2, 1419),
(606, '3ro', 2, 5, 1420),
(607, '3ro', 2, 5, 1421),
(608, 'TERCERO', 2, 2, 1422),
(609, 'tercero', 2, 5, 1427),
(610, 'tercero', 2, 5, 1428),
(611, 'tercero', 2, 5, 1429),
(612, 'III semestre', 2, 2, 1430),
(613, '3er semestre', 2, 2, 1431),
(614, '     III   Semestre', 2, 5, 1435),
(615, '3', 1, 2, 1436),
(616, 'Primero', 4, 2, 1448),
(617, '1%C2%B0', 1, 2, 1452),
(618, 'SEGUNDO', 4, 2, 1453),
(619, '3', 1, 2, 1456),
(620, 'SEGUNDO', 2, 2, 1486),
(621, 'PRIMER SEMESTRE', 2, 2, 1489),
(622, '2do', 4, 2, 1491),
(623, 'primero', 1, 2, 1495),
(624, '1', 2, 2, 1505),
(625, 'SEGUNDO', 2, 2, 1515),
(626, '1er. SEMESTRE', 2, 2, 1518),
(627, '2', 4, 2, 1522),
(628, 'PRIMERO', 1, 1, 1525),
(629, 'PRIMERO', 2, 2, 1526),
(630, 'PRIMERO', 2, 2, 1528),
(631, 'TERCERO', 1, 2, 1534),
(632, 'PRIMERO', 4, 2, 1536),
(633, '3', 1, 2, 1537),
(634, '1RO', 2, 2, 1538),
(635, '1RO', 2, 2, 1539),
(636, 'SEGUNDO', 4, 2, 1540),
(637, 'PRIMERO', 4, 2, 1547),
(638, 'primer  semestre ', 2, 2, 1548),
(639, 'PRIMERO', 2, 2, 1549),
(640, '3%C2%B0', 1, 2, 1552),
(641, '1ro', 2, 2, 1554),
(642, '3', 1, 2, 1580),
(643, '3', 1, 2, 1581),
(644, '3', 1, 2, 1582),
(645, 'TERCERO', 1, 2, 1584),
(646, 'TERCERO', 1, 2, 1585),
(647, 'TERCERO', 1, 2, 1586),
(648, '3RO', 2, 2, 1589),
(649, '1', 1, 2, 1590),
(650, 'TERCERO', 1, 2, 1591),
(651, '2%C2%B0', 2, 2, 1594),
(652, '2%C2%B0', 2, 2, 1595),
(653, '3', 1, 2, 1598),
(654, 'II', 4, 2, 1602),
(655, 'TERCERO', 2, 2, 1604),
(656, '1ro', 1, 2, 1606),
(657, 'III', 2, 5, 1607),
(658, 'SEGUNDO', 4, 2, 1611),
(659, '2', 2, 2, 1612),
(660, '1er.', 1, 2, 1615),
(661, 'SEGUNDO', 4, 2, 1616),
(662, '1er.', 1, 2, 1617),
(663, 'PRIMERO', 1, 2, 1618),
(664, 'SEGUNDO', 4, 2, 1619),
(665, 'SEGUNDO', 4, 2, 1620),
(666, 'SEGUNDO', 4, 2, 1621),
(667, '1A', 2, 2, 1622),
(668, '2', 4, 2, 1628),
(669, 'primero', 4, 2, 1629),
(670, 'SEGUNDO', 2, 2, 1632),
(671, 'PRIMERO ', 2, 2, 1639),
(672, '1', 1, 1, 1647),
(673, 'Primer', 4, 2, 1654),
(674, 'Primer', 4, 2, 1655),
(675, '1er semestre', 1, 2, 1664),
(676, 'Primero ', 4, 2, 1666),
(677, '2', 2, 2, 1676),
(678, '1', 1, 2, 1679),
(679, 'primero', 4, 2, 1680),
(680, 'PRIMERO', 4, 2, 1681),
(681, 'PRIMERO', 4, 2, 1683),
(682, 'SEGUNDO', 2, 1, 1688),
(683, 'SEGUNDO', 2, 2, 1689),
(684, 'PRIMERO', 1, 2, 1690),
(685, '2do. SEMESTRE', 2, 2, 1691),
(686, '3ro.', 1, 2, 1692),
(687, 'PRIMERO', 1, 2, 1696),
(688, 'PRIMERO', 1, 2, 1697),
(689, 'SEGUNDO', 2, 2, 1699),
(690, 'PRIMERO', 4, 2, 1706),
(691, 'primero', 4, 2, 1711),
(692, 'TERCER SEMESTRE', 2, 5, 1719),
(693, 'PRIMERO', 1, 2, 1727),
(694, 'TERCERO ', 1, 2, 1728),
(695, 'PRIMERO', 1, 2, 1729),
(696, 'segundo', 4, 2, 1732),
(697, 'segundo', 4, 2, 1734),
(698, '3ro', 2, 2, 1736),
(699, '3 B', 1, 2, 1738),
(700, '1', 2, 2, 1739),
(701, 'TERCER SEMESTRE', 1, 2, 1740),
(702, 'SEGUNDO', 2, 2, 1741),
(703, '3ro', 2, 2, 1757),
(704, '3ro', 2, 2, 1758),
(705, '3%C2%BA B', 1, 1, 1765),
(706, '1er semestre', 2, 2, 1768),
(707, 'SEGUNDO', 2, 2, 1771),
(708, '3er', 1, 2, 1772),
(709, 'SEGUNDO', 4, 2, 1774),
(710, '2do', 2, 2, 1775),
(711, '1 semestre', 1, 1, 1778),
(712, 'PRIMER SEMESTRE', 1, 1, 1779),
(713, '3ro.', 2, 2, 1780),
(714, 'III', 1, 2, 1781),
(715, 'TERCERO', 1, 2, 1782),
(716, 'TERCERO ', 1, 2, 1783),
(717, '3', 1, 2, 1805),
(718, '2', 3, 2, 1820),
(719, '2', 3, 2, 1821),
(720, '3', 3, 2, 1867),
(721, '5', 1, 1, 1967),
(722, '2', 1, 1, 1981),
(723, '8', 1, 1, 1986),
(724, '9', 1, 1, 2016),
(725, '4', 2, 2, 2026),
(726, '4', 2, 2, 2027),
(727, '9', 1, 2, 2028),
(728, '7', 1, 1, 2035),
(729, '1', 1, 1, 2048),
(730, '3', 1, 2, 2053),
(731, '8', 1, 1, 2060),
(732, '6', 1, 1, 2072),
(733, '1', 1, 2, 2073),
(734, '3', 2, 2, 2074),
(735, '2', 2, 3, 2076),
(736, '2', 2, 3, 2077),
(737, '2', 2, 3, 2078),
(738, '2', 2, 3, 2079),
(739, '2', 2, 3, 2080),
(740, '1', 4, 5, 2081),
(741, 'Cuarto ', 1, 2, 2083),
(742, 'TERCERO', 1, 2, 2084),
(743, '3ro', 1, 2, 2085),
(744, '3', 1, 2, 2086),
(745, '4', 1, 2, 2087),
(746, 'tercero', 1, 3, 2088),
(747, '4', 2, 2, 2089),
(748, 'tercero', 1, 3, 2090),
(749, 'tercero', 2, 2, 2091),
(750, '3', 1, 2, 2096),
(751, 'SEGUNDO', 2, 2, 2101),
(752, '4Â° A', 1, 2, 2105),
(753, '4Â° A', 1, 2, 2106),
(754, 'CUARTO', 1, 2, 2107),
(755, 'Segundo', 1, 2, 2108),
(756, '4Â°', 1, 2, 2109),
(757, ' 2Â° Semestre', 1, 2, 2110),
(758, 'Tercero', 1, 3, 2112),
(759, '4to', 1, 2, 2115),
(760, '1', 1, 4, 2126),
(761, 'TERCERO', 1, 3, 2127),
(762, 'CUARTO', 1, 2, 2128),
(763, 'TERCERO', 1, 2, 2129),
(764, 'TERCERO', 1, 2, 2130),
(765, 'TERCER', 1, 2, 2132),
(766, '3', 1, 3, 2133),
(767, 'Segundo', 2, 2, 2135),
(768, '3', 1, 2, 2136),
(769, 'TERCERO', 1, 3, 2137),
(770, 'PRIMERO', 1, 2, 2138),
(771, 'TERCER SEMESTRE', 2, 2, 2139),
(772, 'I', 1, 2, 2143),
(773, 'Primero', 1, 2, 2144),
(774, '4', 1, 2, 2145),
(775, 'PRIMERO', 1, 2, 2146),
(776, '3', 1, 2, 2152),
(777, '1', 1, 2, 2153),
(778, 'Segundo', 1, 2, 2154),
(779, '2 \"A\"', 1, 1, 2155),
(780, 'Segundo', 1, 2, 2156),
(781, '1', 1, 2, 2157),
(782, 'Primero', 1, 2, 2158),
(783, '3', 1, 2, 2159),
(784, 'TERCERO', 1, 2, 2161),
(785, 'TERCERO', 1, 3, 2164),
(786, 'TERCERO', 1, 3, 2165),
(787, 'Cuarto semestre', 2, 2, 2166),
(788, '3', 1, 1, 2167),
(789, '3', 1, 2, 2168),
(790, 'Cuarto semestre', 2, 2, 2169),
(791, 'CUARTO', 1, 2, 2171),
(792, 'TERCER', 1, 2, 2172),
(793, '3', 1, 3, 2173),
(794, '3', 1, 3, 2174),
(795, 'TERCERO', 2, 2, 2175),
(796, 'TERCERO', 2, 2, 2176),
(797, 'SEGUNDO', 1, 2, 2180),
(798, 'SEGUNDO ', 1, 2, 2183),
(799, 'SEGUNDO ', 1, 2, 2185),
(800, 'PRIMERO', 1, 2, 2189),
(801, 'TERCER SEMESTRE', 1, 3, 2190),
(802, 'TERCER SEMESTRE', 1, 3, 2191),
(803, 'TERCER SEMESTRE', 1, 3, 2192),
(804, '3ro', 2, 2, 2193),
(805, 'segundo', 1, 2, 2196),
(806, '9', 1, 1, 2197),
(807, '3', 2, 2, 2198),
(808, '3', 2, 2, 2199),
(809, '3 ero', 2, 2, 2200),
(810, 'Tercero ', 2, 2, 2201),
(811, 'TERCERO', 1, 2, 2202),
(812, '3 ERO.', 2, 2, 2203),
(813, 'Tercero', 1, 3, 2204),
(814, '3', 1, 3, 2205),
(815, '3RO.', 2, 2, 2206),
(816, '2do', 1, 2, 2207),
(817, '3ro', 1, 2, 2208),
(818, '3', 2, 2, 2209),
(819, '1', 1, 2, 2210),
(820, '3ER SEMESTRE', 2, 2, 2211),
(821, '3', 2, 1, 2213),
(822, '3er', 1, 2, 2219),
(823, '4', 1, 2, 2221),
(824, '3', 2, 2, 2222),
(825, '3ro ', 1, 3, 2223),
(826, '4', 2, 2, 2224),
(827, 'CUARTO', 2, 2, 2225),
(828, '4to', 1, 2, 2228),
(829, '4to', 1, 2, 2229),
(830, 'CUARTO', 1, 2, 2230),
(831, 'SEGUNDO ', 1, 2, 2231),
(832, 'segundo ', 1, 2, 2232),
(833, 'segundo ', 1, 1, 2233),
(834, '4to', 2, 2, 2235),
(835, '3o. ', 2, 2, 2236),
(836, '3', 2, 2, 2237),
(837, 'Cuarto', 1, 2, 2238),
(838, '4', 2, 2, 2239),
(839, '2', 1, 2, 2241),
(840, 'segundo ', 1, 2, 2242),
(841, '2', 2, 2, 2243),
(842, '2Â°', 1, 2, 2244),
(843, '3er semestre', 1, 2, 2245),
(844, '4to', 2, 2, 2246),
(845, 'TERCERO', 1, 1, 2247),
(846, '2', 2, 2, 2248),
(847, '3Â°', 2, 2, 2250),
(848, '2Â°', 1, 2, 2252),
(849, ' 1', 1, 2, 2255),
(850, 'Primer semestre', 1, 1, 2261),
(851, 'Primer semestre', 1, 2, 2262),
(852, 'SEGUNDO', 1, 2, 2263),
(853, 'TERCERO', 1, 2, 2268),
(854, 'TERCERO', 1, 1, 2269),
(855, '2', 1, 2, 2270),
(856, '3', 1, 2, 2272),
(857, 'TERCERO', 1, 3, 2285),
(858, '3ER', 1, 2, 2292),
(859, 'TERCER SEMESTRE', 1, 2, 2293),
(860, 'TERCERO', 1, 2, 2294),
(861, 'II', 2, 2, 2302),
(862, '2 do', 1, 2, 2303),
(863, '2', 1, 2, 2304),
(864, '3', 2, 2, 2306),
(865, '2Â° A', 1, 2, 2308),
(866, '2a', 1, 2, 2309),
(867, '3Â°', 2, 2, 2311),
(868, '3Â°', 2, 2, 2312),
(869, '3', 2, 2, 2313),
(870, '2', 1, 2, 2314),
(871, '3ro', 2, 2, 2315),
(872, 'TERCERO', 2, 2, 2316),
(873, '2DO', 2, 2, 2317),
(874, '1Â°', 1, 2, 2321),
(875, '1', 1, 2, 2324),
(876, '2', 1, 1, 2325),
(877, '2DO', 2, 2, 2326),
(878, 'Primer', 1, 2, 2327),
(879, '1', 1, 2, 2328),
(880, 'Primer', 1, 2, 2329),
(881, '3', 1, 2, 2330),
(882, '1', 1, 2, 2331),
(883, '3', 1, 2, 2332),
(884, '3', 1, 2, 2333),
(885, '3', 1, 2, 2334),
(886, '1', 1, 2, 2335),
(887, '1', 1, 2, 2336),
(888, '2', 1, 2, 2338),
(889, 'Segundo', 2, 2, 2339),
(890, '3', 1, 2, 2340),
(891, '2', 1, 2, 2341),
(892, '3', 1, 2, 2347),
(893, '3', 1, 2, 2348),
(894, '3ro', 2, 2, 2356),
(895, '3ro', 1, 2, 2359),
(896, '2 \"A\"', 1, 2, 2388),
(897, '4', 1, 2, 2407),
(898, 'Cuarto', 1, 2, 2417),
(899, '3', 1, 2, 2425),
(900, '1', 1, 5, 2427),
(901, '1', 1, 1, 2432);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `p_docenteupn`
--

CREATE TABLE `p_docenteupn` (
  `id_dupn` int(11) NOT NULL,
  `nivel_estudio` varchar(100) NOT NULL,
  `sede_id` int(11) NOT NULL,
  `id_participante` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `p_docenteupn`
--

INSERT INTO `p_docenteupn` (`id_dupn`, `nivel_estudio`, `sede_id`, `id_participante`) VALUES
(1, 'Licenciatuta', 3, 2061),
(2, 'Licenciatuta', 3, 2062),
(3, 'Licenciatuta', 2, 2111),
(4, 'MaestrÃ­a', 3, 2178),
(5, 'MaestrÃ­a', 2, 2179),
(6, 'Licenciatuta', 2, 2226),
(7, 'MaestrÃ­a', 2, 2397),
(8, 'MaestrÃ­a', 2, 2408),
(9, 'Doctorado', 2, 2413),
(10, 'Doctorado', 2, 2414),
(11, 'Licenciatuta', 3, 2429);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `p_externo`
--

CREATE TABLE `p_externo` (
  `id_extrerno` int(11) NOT NULL,
  `instituto` varchar(500) NOT NULL COMMENT 'Institucion de procedencia',
  `grado` varchar(100) NOT NULL COMMENT 'Licenciatura, Maestria o Doctorado',
  `datoPersonal_id` int(11) NOT NULL,
  `tipo` varchar(50) NOT NULL COMMENT 'Estudiante o Maestro'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `p_externo`
--

INSERT INTO `p_externo` (`id_extrerno`, `instituto`, `grado`, `datoPersonal_id`, `tipo`) VALUES
(167, 'UNIVERSIDAD JUAREZ AUTONOMA DE TABASCO', 'COORDINADOR', 1309, 'otro'),
(168, 'UNIVERSIDAD JUAREZ AUTONOMA DE TABASCO', 'COORDINADOR', 1310, 'otro'),
(169, 'UNIVERSIDAD JUAREZ AUTONOMA DE TABASCO', 'COORDINADOR', 1311, 'otro'),
(170, ' UNIVERSIDAD TECNOLÓGICA DE TABASCO', 'DOCENTE', 1357, 'otro'),
(171, 'SECRETARIA DE EDUCACION DE TABASCO', 'MAESTRO', 1400, 'otro'),
(172, 'docente en SE', 'docente', 1531, 'otro'),
(173, 'docente en SE', 'docente', 1535, 'otro'),
(174, 'ujat', 'coordinador', 1643, 'otro'),
(175, 'ujat', 'coordinador', 1645, 'otro'),
(176, 'DOCENTE DE EDUCACIÓN PRIMARIA DE TABASCO', 'DOCENTE', 1787, 'otro'),
(177, 'DOCENTE DE EDUCACIÓN PRIMARIA DE TABASCO', 'DOCENTE', 1788, 'otro'),
(178, 'ALUMNO DE ESCUELA NORMAL', 'ALUMNO', 1794, 'otro'),
(179, 'SEP', 'Docente', 1812, 'otro'),
(180, 'Laranet', 'Programador', 1824, 'otro'),
(181, 'Laranet', 'Programador', 1975, 'otro'),
(182, 'Laranet', 'Programador', 1976, 'otro'),
(183, 'Laranet', 'Programador', 1977, 'otro'),
(184, 'Laranet', 'Programador', 1978, 'otro');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ref_costo`
--

CREATE TABLE `ref_costo` (
  `id_costo` int(11) NOT NULL,
  `alumno_lic` varchar(20) NOT NULL DEFAULT '0-0' COMMENT 'Esta tabla solo toma como referenci los costo de cada eventooero no es utili para operaciones de calculo ya que los costos tienen un fomatro string',
  `alumno_mtr` varchar(20) NOT NULL DEFAULT '0-0',
  `maestro_upn` varchar(20) NOT NULL DEFAULT '0-0',
  `externo` varchar(20) NOT NULL DEFAULT '0-0',
  `id_coloquio` int(11) NOT NULL,
  `coloquio_entero` varchar(20) NOT NULL,
  `conferencia_exclusivamente` varchar(20) NOT NULL,
  `taller_exclusivamente` varchar(20) NOT NULL,
  `conferencia_taller` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `ref_costo`
--

INSERT INTO `ref_costo` (`id_costo`, `alumno_lic`, `alumno_mtr`, `maestro_upn`, `externo`, `id_coloquio`, `coloquio_entero`, `conferencia_exclusivamente`, `taller_exclusivamente`, `conferencia_taller`) VALUES
(12, '0-0', '0-600', '0-100', '0-800', 12, '800', '800', '800', '800');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sede`
--

CREATE TABLE `sede` (
  `id_sede` int(11) NOT NULL,
  `sede` varchar(100) NOT NULL,
  `comentario` varchar(100) NOT NULL,
  `direcc` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Volcado de datos para la tabla `sede`
--

INSERT INTO `sede` (`id_sede`, `sede`, `comentario`, `direcc`) VALUES
(1, 'CARDENAS', '', ''),
(2, 'CENTRO', '', ''),
(3, 'COMALCALCO', '', ''),
(4, 'EMILIANO ZAPATA', '', ''),
(5, 'NACAJUCA', '', '');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `vista_eventoacceso`
--

CREATE TABLE `vista_eventoacceso` (
  `id_acceso` int(11) DEFAULT NULL,
  `clave` int(11) DEFAULT NULL,
  `lugar` int(11) DEFAULT NULL,
  `tipoacceso` int(11) DEFAULT NULL,
  `id_evento` int(11) DEFAULT NULL,
  `id_puntoAcceso` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `acceso`
--
ALTER TABLE `acceso`
  ADD PRIMARY KEY (`id_acceso`);

--
-- Indices de la tabla `asistencia`
--
ALTER TABLE `asistencia`
  ADD PRIMARY KEY (`idasistencia`),
  ADD KEY `fk_asistencia_datoParticipante1_idx` (`id_participante`),
  ADD KEY `fk_asistencia_acceso1_idx` (`id_acceso`);

--
-- Indices de la tabla `coloquio`
--
ALTER TABLE `coloquio`
  ADD PRIMARY KEY (`id_coloquio`);

--
-- Indices de la tabla `datoparticipante`
--
ALTER TABLE `datoparticipante`
  ADD PRIMARY KEY (`id_dato`);

--
-- Indices de la tabla `evento`
--
ALTER TABLE `evento`
  ADD PRIMARY KEY (`id_evento`),
  ADD KEY `fk_evento_coloquio1_idx` (`id_coloquio`);

--
-- Indices de la tabla `evento_has_acceso`
--
ALTER TABLE `evento_has_acceso`
  ADD PRIMARY KEY (`id_evento`,`id_acceso`,`id_puntoAcceso`),
  ADD KEY `fk_evento_has_acceso_acceso1_idx` (`id_acceso`),
  ADD KEY `fk_evento_has_acceso_evento1_idx` (`id_evento`);

--
-- Indices de la tabla `ficha`
--
ALTER TABLE `ficha`
  ADD PRIMARY KEY (`id_ficha`),
  ADD KEY `fk_ficha_datoParticipante1_idx` (`id_participante`);

--
-- Indices de la tabla `plan_carrera`
--
ALTER TABLE `plan_carrera`
  ADD PRIMARY KEY (`id_maestria`);

--
-- Indices de la tabla `prog_coloquio`
--
ALTER TABLE `prog_coloquio`
  ADD PRIMARY KEY (`idprog_coloquio`),
  ADD KEY `fk_prog_coloquio_coloquio1_idx` (`coloquio_id_coloquio`),
  ADD KEY `fk_prog_coloquio_ficha1_idx` (`ficha_id_ficha`);

--
-- Indices de la tabla `prog_participante`
--
ALTER TABLE `prog_participante`
  ADD PRIMARY KEY (`idprog_participante`),
  ADD KEY `fk_prog_participante_evento1_idx` (`evento_id`),
  ADD KEY `fk_prog_participante_ficha1_idx` (`ficha_id`);

--
-- Indices de la tabla `p_alumnolicenciatura`
--
ALTER TABLE `p_alumnolicenciatura`
  ADD PRIMARY KEY (`id_al`),
  ADD KEY `fk_p_alumnoLicenciatura_datoPersonal1_idx` (`id_participante`),
  ADD KEY `fk_p_alumnoLicenciatura_sede1_idx` (`sede_id_sede`);

--
-- Indices de la tabla `p_alumnomaestria`
--
ALTER TABLE `p_alumnomaestria`
  ADD PRIMARY KEY (`id_am`),
  ADD KEY `fk_p_alumnoMaestria_sede_idx` (`sede_id`),
  ADD KEY `fk_p_alumnoMaestria_maestria1_idx` (`maestria_id`),
  ADD KEY `fk_p_alumnoMaestria_datoPersonal1_idx` (`id_participante`);

--
-- Indices de la tabla `p_docenteupn`
--
ALTER TABLE `p_docenteupn`
  ADD PRIMARY KEY (`id_dupn`),
  ADD KEY `fk_p_docenteupn_sede1_idx` (`sede_id`),
  ADD KEY `fk_p_docenteupn_datoPersonal1_idx` (`id_participante`);

--
-- Indices de la tabla `p_externo`
--
ALTER TABLE `p_externo`
  ADD PRIMARY KEY (`id_extrerno`),
  ADD KEY `fk_extrerno_datoParticipante1_idx` (`datoPersonal_id`);

--
-- Indices de la tabla `ref_costo`
--
ALTER TABLE `ref_costo`
  ADD PRIMARY KEY (`id_costo`),
  ADD KEY `fk_ref_costo_coloquio1_idx` (`id_coloquio`);

--
-- Indices de la tabla `sede`
--
ALTER TABLE `sede`
  ADD PRIMARY KEY (`id_sede`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `acceso`
--
ALTER TABLE `acceso`
  MODIFY `id_acceso` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `asistencia`
--
ALTER TABLE `asistencia`
  MODIFY `idasistencia` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3502;

--
-- AUTO_INCREMENT de la tabla `coloquio`
--
ALTER TABLE `coloquio`
  MODIFY `id_coloquio` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT de la tabla `datoparticipante`
--
ALTER TABLE `datoparticipante`
  MODIFY `id_dato` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2433;

--
-- AUTO_INCREMENT de la tabla `evento`
--
ALTER TABLE `evento`
  MODIFY `id_evento` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `evento_has_acceso`
--
ALTER TABLE `evento_has_acceso`
  MODIFY `id_evento` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `ficha`
--
ALTER TABLE `ficha`
  MODIFY `id_ficha` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4812;

--
-- AUTO_INCREMENT de la tabla `plan_carrera`
--
ALTER TABLE `plan_carrera`
  MODIFY `id_maestria` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de la tabla `prog_coloquio`
--
ALTER TABLE `prog_coloquio`
  MODIFY `idprog_coloquio` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2444;

--
-- AUTO_INCREMENT de la tabla `prog_participante`
--
ALTER TABLE `prog_participante`
  MODIFY `idprog_participante` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `p_alumnolicenciatura`
--
ALTER TABLE `p_alumnolicenciatura`
  MODIFY `id_al` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `p_alumnomaestria`
--
ALTER TABLE `p_alumnomaestria`
  MODIFY `id_am` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=902;

--
-- AUTO_INCREMENT de la tabla `p_docenteupn`
--
ALTER TABLE `p_docenteupn`
  MODIFY `id_dupn` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de la tabla `p_externo`
--
ALTER TABLE `p_externo`
  MODIFY `id_extrerno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=185;

--
-- AUTO_INCREMENT de la tabla `ref_costo`
--
ALTER TABLE `ref_costo`
  MODIFY `id_costo` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT de la tabla `sede`
--
ALTER TABLE `sede`
  MODIFY `id_sede` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `asistencia`
--
ALTER TABLE `asistencia`
  ADD CONSTRAINT `fk_asistencia_acceso1` FOREIGN KEY (`id_acceso`) REFERENCES `acceso` (`id_acceso`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_asistencia_datoParticipante1` FOREIGN KEY (`id_participante`) REFERENCES `datoparticipante` (`id_dato`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `evento`
--
ALTER TABLE `evento`
  ADD CONSTRAINT `fk_evento_coloquio1` FOREIGN KEY (`id_coloquio`) REFERENCES `coloquio` (`id_coloquio`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `evento_has_acceso`
--
ALTER TABLE `evento_has_acceso`
  ADD CONSTRAINT `fk_evento_has_acceso_acceso1` FOREIGN KEY (`id_acceso`) REFERENCES `acceso` (`id_acceso`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_evento_has_acceso_evento1` FOREIGN KEY (`id_evento`) REFERENCES `evento` (`id_evento`) ON DELETE NO ACTION ON UPDATE CASCADE;

--
-- Filtros para la tabla `ficha`
--
ALTER TABLE `ficha`
  ADD CONSTRAINT `fk_ficha_datoParticipante1` FOREIGN KEY (`id_participante`) REFERENCES `datoparticipante` (`id_dato`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `prog_coloquio`
--
ALTER TABLE `prog_coloquio`
  ADD CONSTRAINT `fk_prog_coloquio_coloquio1` FOREIGN KEY (`coloquio_id_coloquio`) REFERENCES `coloquio` (`id_coloquio`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_prog_coloquio_ficha1` FOREIGN KEY (`ficha_id_ficha`) REFERENCES `ficha` (`id_ficha`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Filtros para la tabla `prog_participante`
--
ALTER TABLE `prog_participante`
  ADD CONSTRAINT `fk_prog_participante_evento1` FOREIGN KEY (`evento_id`) REFERENCES `evento` (`id_evento`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_prog_participante_ficha1` FOREIGN KEY (`ficha_id`) REFERENCES `ficha` (`id_ficha`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Filtros para la tabla `p_alumnolicenciatura`
--
ALTER TABLE `p_alumnolicenciatura`
  ADD CONSTRAINT `fk_p_alumnoLicenciatura_datoPersonal1` FOREIGN KEY (`id_participante`) REFERENCES `datoparticipante` (`id_dato`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_p_alumnoLicenciatura_sede1` FOREIGN KEY (`sede_id_sede`) REFERENCES `sede` (`id_sede`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `p_alumnomaestria`
--
ALTER TABLE `p_alumnomaestria`
  ADD CONSTRAINT `fk_p_alumnoMaestria_datoPersonal1` FOREIGN KEY (`id_participante`) REFERENCES `datoparticipante` (`id_dato`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_p_alumnoMaestria_maestria1` FOREIGN KEY (`maestria_id`) REFERENCES `plan_carrera` (`id_maestria`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_p_alumnoMaestria_sede` FOREIGN KEY (`sede_id`) REFERENCES `sede` (`id_sede`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `p_docenteupn`
--
ALTER TABLE `p_docenteupn`
  ADD CONSTRAINT `fk_p_docenteupn_datoPersonal1` FOREIGN KEY (`id_participante`) REFERENCES `datoparticipante` (`id_dato`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_p_docenteupn_sede1` FOREIGN KEY (`sede_id`) REFERENCES `sede` (`id_sede`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `p_externo`
--
ALTER TABLE `p_externo`
  ADD CONSTRAINT `fk_extrerno_datoParticipante1` FOREIGN KEY (`datoPersonal_id`) REFERENCES `datoparticipante` (`id_dato`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

