-- Table structure for table `temp2`
--

CREATE TABLE `temp2` (
  `nivel` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `grado` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cur_cor` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cod_cur` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cor_lar` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `grupo` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `jor` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ced` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nom` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `sed` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `temp2`
--

INSERT INTO `temp2` VALUES ('PREESCOLAR','CERO','001','','CERO UNO','1','M','27275957','MARTHA CECILIA GAVIRIA REBOLLEDO','2'),('PREESCOLAR','CERO','002','','CERO DOS','2','M','27275939','ADRIANA DEL PILAR RAMIREZ PEREZ','2'),('PREESCOLAR','CERO','003','','CERO TRES','3','M','40022521','EDELMIRA MUÑOZ ORDOÑEZ','2'),('PREESCOLAR','CERO','004','','CERO CUATRO','4','M','30729137',' MONICA BRAVO MUÑOZ','2'),('PRIMARIA','PRIMERO','101','','PRIMERO UNO','1','M','27275933','VILMA CLARENA  ORDÓÑEZ REALPE','2'),('PRIMARIA','PRIMERO','102','','PRIMERO DOS','2','M','27275837','ANA DEL PILAR MUÑOZ PLACIOS','2'),('PRIMARIA','PRIMERO','103','','PRIMERO TRES','3','M','27275327','BLANCA INES  ORTEGA ','2'),('PRIMARIA','SEGUNDO','201','','SEGUNDO UNO','1','M','27294386','ROSARIO ALICIA GÓMEZ ZAMBRANO','2'),('PRIMARIA','SEGUNDO','202','','SEGUNDO DOS','2','M','27277776','DIANA MARIA ALVEAR GÓMEZ','2'),('PRIMARIA','SEGUNDO','203','','SEGUNDO TRES','3','M','27274898','GLORIA MARLENY BOLAÑOS BELTRAN','2'),('PRIMARIA','TERCERO','301','','TERCERO UNO','1','M','79653207','LEYDER HERNAN  DIAZ LEYTON','2'),('PRIMARIA','TERCERO','302','','TERCERO DOS','2','M','27275540','MARTHA EUGENIA REBOLLEDO BOLAÑOS','2'),('PRIMARIA','TERCERO','303','','TERCERO TRES','3','M','27296191','LUZ LILIANA MUÑOZ RELAPE','2'),('PRIMARIA','CUARTO','401','','CUARTO UNO','1','M','87245064','JESUS ANTONIO  MUÑOZ RELAPE','2'),('PRIMARIA','CUARTO','402','','CUARTO DOS','2','M','27274498','GRACIELA NOHEMY ZAMBRANO ECHEVERRY  ','2'),('PRIMARIA','CUARTO','403','','CUARTO TRES','3','M','27274399','MARIA LUISA REALPE ALVEAR','2'),('PRIMARIA','QUINTO','501','','QUINTO UNO','1','M','30701840','LUCIA DELGADO IBARRA','2'),('PRIMARIA','QUINTO','502','','QUINTO DOS','2','M','5275765','IBO HERLEY BOLAÑOS ORDOÑEZ','2'),('PRIMARIA','QUINTO','503','','QUINTO TRES','3','M','12956596','PEDRO ANTONIO  MUÑOZ  REALPE','2'),('SECUNDARIA','SEXTO','601','','SEXTO UNO','1','M','27277502','ELIANA GOMEZ ORDOÑEZ','1'),('SECUNDARIA','SEXTO','602','','SEXTO DOS','2','M','87247100','ORLANDO REALPE PALACIOS','1'),('SECUNDARIA','SEXTO','603','','SEXTO TRES','3','M','5275708','SEGUNDO EZEQUIEL GUERRERO MARTÍNEZ','1'),('SECUNDARIA','SEXTO','604','','SEXTO CUATRO','4','M','5312302','RAYMON RIGOBERTO NARVAEZ CHECA','1'),('SECUNDARIA','SÉPTIMO','701','','SÉPTIMO UNO','1','M','27275143','LUZ ANGELICA  MUÑOZ ARCOS','1'),('SECUNDARIA','SÉPTIMO','702','','SÉPTIMO DOS','2','M','5379747','EDUARD CARLOS GARCIA','1'),('SECUNDARIA','SÉPTIMO','703','','SÉPTIMO TRES','3','M','5275983','HUGO ISMAEL REALPE NARVAEZ','1'),('SECUNDARIA','OCTAVO','801','','OCTAVO UNO','1','M','10294642','HUBEIMAR ORDÓÑEZ MUÑOZ','1'),('SECUNDARIA','OCTAVO','802','','OCTAVO DOS','2','M','10294642','GLORIA DEL CARMEN MORA HERRERA','1'),('SECUNDARIA','OCTAVO','803','','OCTAVO TRES','3','M','30745840','LUCY OMARY URBANO GÓMEZ','1'),('SECUNDARIA','OCTAVO','804','','OCTAVO CUATRO','4','M','5275370','ALVARO  JESUS ALVEAR PALACIOS','1'),('SECUNDARIA','NOVENO','901','','NOVENO UNO','1','M','87245038','ALVARO MUÑOZ ORTIZ','1'),('SECUNDARIA','NOVENO','902','','NOVENO DOS','2','M','27275715','ANA JULIA RELAPE ROSERO','1'),('SECUNDARIA','NOVENO','903','','NOVENO TRES','3','M','27274908','DOLORES DEL SOCORRO ORDOÑEZ MUTIS','1'),('MEDIA ','DECIMO','1001','','DECIMO UNO','1','M','87246632','JAIRO RAIMUNDO NARVAEZ IBARRA','1'),('MEDIA ','DÉCIMO','1002','','DECIMO DOS','2','M','10296762','WALTER MUÑOZ DIAZ','1'),('MEDIA ','DÉCIMO','1003','','DECIMO TRES','3','M','27275400','GABBY DEL CARMEN ORTEGA BURBANO','1'),('MEDIA ','DÉCIMO','1004','','DECIMO CUATRO','4','M','51739473','TRINIDAD JOSEFINA ORDOÑEZ MUTIS','1'),('MEDIA ','DÉCIMO','1005','','DECIMO CINCO','5','M','27276502','NURY MUÑOZ CERON','1'),('MEDIA ','UNDÉCIMO','1101','','UNDÉCIMO UNO','1','M','87245213','CESAR HUMBERTO REBOLLEDO BOLAÑOS','1'),('MEDIA ','UNDÉCIMO','1102','','UNDÉCIMO DOS','2','M','12983292','OSCAR HERNAN ORTÍZ BOLAÑOS','1'),('MEDIA ','UNDÉCIMO','1103','','UNDÉCIMO TRES','3','M','27275638','DORA ESTELLA BRAVO REALPE','1'),('MEDIA ','UNDÉCIMO','1104','','UNDÉCIMO CUATRO','4','M','31265134','SOLEDAD DEL SOCORRO REALPE','1'),('COMPLEMENTARIA','PRIMER SEMESTRE','1201','','PRIMER SEMESTRE','1','M','5339822','GERARDO ALBINI IMBACHI ORDOÑEZ','1'),('COMPLEMENTARIA','SEGUNDO SEMESTRE','1202','','SEGUNDO SEMESTRE','2','M','5339822','GERARDO ALBINI IMBACHI ORDOÑEZ','1'),('COMPLEMENTARIA','TERCER SEMESTRE','1301','','TERCER SEMESTRE','3','M','87245774','JOSE OLIDEN MUÑOZ BRAVO','1'),('COMPLEMENTARIA','CUARTO SEMESTRE','1302','','CUARTO SEMESTRE','4','M','87245774','JOSE OLIDEN MUÑOZ BRAVO','1');

--
-- Table structure for table `temp3`
--

CREATE TABLE `temp3` (
  `ced` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ape` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nom` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cargo` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `gen` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `dir` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ciu` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `tel1` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `tel2` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `temp3`
--

INSERT INTO `temp3` VALUES ('87245412','ORDOÑEZ BRAVO  ','JAIRO EMILIO','RECTOR','M','CALLE 7 No.8-24','','','7266108','jemilio108@gmail.com'),('87245446','BOLAÑOS GARCES  ','BERNARDO EMIRO','COORDINADOR','M','','','','3146202078','bemboga@hotmail.com'),('27276502','MUÑOZ CERON','NUTY','DOCENTE','F','CALLE 11 No. 6-25','','','3127969826','numuce70@hotmail.com'),('27277502','GOMEZ ORDOÑEZ','ELIANA','DOCENTE','F','CALLE 8 No. 8-75','','','3117627889','eliana2976@hotmail.com'),('5339822','IMBACHI ORDOÑEZ  ','GERARDO ALBINI','DOCENTE','M','CALLE 10 No. 10-15','','','3113094264','geraimbachi@hotmail.com'),('31265134','REALPE MUÑOZ  ','SOLEDAD DEL SOCORRO','DOCENTE','F','CALLE 6 No. 6-83','','','3127572688','socoremu29@yahoo.es'),('27274908','ORDOÑEZ MUTIS  ','DOLORES DEL SOCORRO','DOCENTE','F','CARRERA 10 No. 9-49','','','3122576868','lolaormu908@hotmail.com'),('10296762','MUÑOZ DIAZ  ','WALTER','DOCENTE','M','CARRERA 1ª No 4-20 ','','','3104338908','wmd30@hotmail.com'),('87245213','REBOLLEDO BOLAÑOS ','CESAR HUMBERTO','DOCENTE','M','CARRERA 13 No. 8-48','','','3218017471','cesarhrebolledo@gmail.com'),('87245038','MUÑOZ ORTIZ  ','ALVARO JESUS','DOCENTE','M','CARRERA 10 No. 9-73','','','3113540841','aljemuor@hotmail.com'),('5275354','AHUMADA GOMEZ ','OSCAR ORLANDO','DOCENTE','M','CALLE 5 No.5-42','','','3113542582','o2ahug@gmail.com'),('51739473','ORDOÑEZ MUTIS  ','TRINIDAD JOSEFINA','DOCENTE','F','CARRERA 11 No. 9-42','','','3117711925','nsmlacruz@gmail.com'),('12983292','ORTIZ BOLAÑOS ','OSCAR HERNAN','DOCENTE','M','CALLE 6 No.8-61','','','3207102379','oscarhernanortiz@gmail.com'),('27275143','MUÑOZ ARCOS ','LUZ ANGELICA','DOCENTE','F','CARRERA 6 No. 4-41','','','3117712610','alvaroguerrerogallardo@hotmail.com'),('27277337','PALACIOS ALVEAR','MILENA LENEY','DOCENTE','F','CARRERA 8 No. 5-35','','','3116275140','milepa@yahoo.es'),('87245774','MUÑOZ BRAVO ','JOSE OLIDEN','DOCENTE','M','CALLE 10 No. 10-79','','','3147915814','jolidemu65@gmail.com'),('36754745','BUESAQUILLO ','VIVIAN ELIZABETH','DOCENTE','F','CARRERA 22 A No. 2-41 ','','','3168350475','vivianelizab@gmail.com'),('10294642','ORDOÑEZ MUÑOZ','HUBEIMAR ARMANDO','DOCENTE','M','CALLE 5 No. 7-20','','','3146261330','hubeordo@hotmail.com'),('27275638','BRAVO REALPE  ','DORA ESTELLA','DOCENTE','F','CALLE 8 No.9-11','','','3117711067','doritabravor@hotmail.com'),('5275370','ALVEAR PALACIOS ','ALVARO JESUS','DOCENTE','M','CALLE 3 No.8-48','','','3216199375','al2pal@gmail.com'),('27275715','REALPE ROSERO','ANA JULIA','DOCENTE','F','','','','3127828061','anajuliarealpe@gmail.com'),('1088970409','BOTINA REALPE','NATALI','DOCENTE','F','CARRERA 6 No. 3-70','','','3113784163','natalibotina@gmail.com'),('30745840','URBANO GOMEZ ','LUCY OMARY','DOCENTE','F','','','','3113924202','lucyurbanog@hotmail.com'),('5312302','NARVAEZ CHECA  ','RAYMON RIGOBERTO','DOCENTE','M','CALLE 2 No.9-39','','','3207706010','raymonarvaez@hotmail.com'),('5379747','GARCIA  ','EDUARD CARLOS','DOCENTE','M','CALLE 8 CARRERA 8','','','3104657497','garciaeduardcarlos@gmail.com'),('27275400','ORTEGA BURBANO ','GABBY DEL CARMEN','DOCENTE','F','CALLE 8 No.11-13','','','3113212266','gabby.ortega@hotmail.com'),('27087646','MORA HERRERA ','GLORIA DEL CARMEN','DOCENTE','F','CALLE 1 KRA 4 ','','','3146870651','glocamohe@hotmail.com'),('12976968','VIVEROS DELGADO  ','JORGE BERNARDO','DOCENTE','M','CALLE 8 No.12-76','','','3206838009','bervi61@yahoo.es'),('5275708','GUERRERO MARTINEZ ','SEGUNDO EZEQUIEL','DOCENTE','M','CARRERA 6 No. 3-76','','','3113564414','seguemar@gmail.com'),('87246632','NARVAEZ IBARRA  ','JAIRO RAIMUNDO','DOCENTE','M','CALLE 7 No.8-36','','','3104200421','jaibar.69@hotmail.com'),('87246913','GUERRERO ORTEGA  ','MARINO ALBEIRO','DOCENTE','M','CALLE 5 No.8-56','','','3137654527','nsmlacruz@gmail.com'),('98392578','AMADOR BENAVIDES','MARIO FERNANDO','DOCENTE','M','CALLE 11 No. 39A-52','','','3012514873','tribalverde@gmail.com'),('87248085','CERON MUÑOZ','JAIRO FERNANDO','DOCENTE','M','CALLE 10 No. 9-44','','','3128632895','ferchocm-423@hotmail.es'),('5275983','REALPE NARVAEZ   ','HUGO ISMAEL','DOCENTE','M','CARRERA 7 No. 10-76','','','311360053','nsmlacruz@gmail.com'),('87245499','GARCES DELGADO  ','ALVARO HERNANDO','DOCENTE','M','CALLE 8 No.8-47','','','3122844391','alorgade@hotmail.com'),('87245167','ORTEGA PEREZ ','OSCAR RAUL','DOCENTE','M','CARRERA 8° No. 4-15','','','3128977980','ortegaoscarr@hotmail.com'),('87247100','REALPE PALACIOS','ORLANDO','DOCENTE','M','','','','',''),('27275876','MUÑOZ ORTEGA','MARIA DEL PILAR ','DOCENTE','F','','','','3157344937','eduinclusivalacruz@gmail.com'),('87245335','MUÑOZ BOLAÑOS  ','PABLO EMILIO ','DOCENTE','M','CARRERA 12 No 9-85','','','3136338516','nsmlacruz@gmail.com'),('27275957','GAVIRIA REBOLLEDO ','MARTHA CECILIA','DOCENTE','F','','','','3147262566','marthagaviriar@hotmail.com'),('27275939','RAMIREZ PEREZ ','ADRIANA DEL PILAR','DOCENTE','F','CALLE 6 No 8-85','','','3206815924','nsmlacruz@gmail.com'),('40022521','MUÑOZ ORDOÑEZ  ','EDELMIRA','DOCENTE','F','CALLE 10 No 10-12','','','3122109410','edel5765@gmail.com'),('30729137','BRAVO MUÑOZ ','MONICA','DOCENTE','F','CALLE 8 No 9-15','','','3122521546','monicabram@hotmail.com'),('27275837','MUÑOZ PALACIOS ','ANA DEL PILAR','DOCENTE','F','CALLE7 No 8-29','','','3136152631','anamupal@hotmail.com'),('27275933','ORDOÑEZ REALPE ','VILMA CLARENA','DOCENTE','F','CALLE 8 No 8-31','','','3122582984','vilmaclar@hotmail.com'),('27274898','BOLAÑOS BELTRAN ','GLORIA MARLENY','DOCENTE','F','CARRERA 6 No 5-83','','','3217904379','nsmlacruz@gmail.com'),('27277776','ALVEAR GOMEZ ','DIANA MARIA','DOCENTE','F','CARRERA 8 No7-33','','','3146265275','dmalvearg@gmail.com'),('27294386','GOMEZ ZAMBRANO ','ROSARIO ALICIA','DOCENTE','F','CARRERA 8 No 7-33','','','3217035392','dmalvearg@gmail.com'),('27275540','REBOLLEDO BOLAÑOS ','MARTHA EUGENIA','DOCENTE','F','CALLE 8 No 12-76','','','3136567132','bervi61@yahoo.es'),('27275327','ORTEGA DELGADO ','BLANCA INES','DOCENTE','F','CARRERA 11 No 7-43','','','3146382369','blancaines@hotmail.com'),('87245064','MUÑOZ REALPE ','JESUS ANTONIO','DOCENTE','M','','','','3146462732','marthagaviriar@hotmail.com'),('79653207','DIAZ LEYTON ','LEYDER HERNAND','DOCENTE','M','LA ESTANCIA','','','3146301919','nsmlacruz@gmail.com'),('27274498','ZAMBRANO ERCHEVERRY ','GRACIELA NOHEMY','DOCENTE','M','CARRERA 8 No 5-24','','','3104638376','Grazae225@hotmail.com'),('12956596','MUÑOZ REALPE ','PEDRO ANTONIO','DOCENTE','M','CALLE 8 No 12-57','','','3127535676','profepepe30@gmail.com'),('27274399','REALPE ALVEAR ','MARIA LUISA','DOCENTE','F','CARRERA 8 No 7-25','','','3103912707','nsmlacruz@gmail.com'),('30701840','DELGADO IBARRA ','LUCIA','DOCENTE','F','CARRERA 11 No 7-62','','','31132921575','lucha2851@hotmail.com'),('27274999','MUÑOZ REALPE','MARIA MERCEDES','DOCENTE','F','','','','3117003575',''),('87245148','MOLINA MOLINA','ALVARO ANTONIO','DOCENTE','M','','','','',''),('5275765','BOLAÑOS ORDOOÑEZ','IBO HERLEY','DOCENTE','M','','','','',''),('27296191','MUÑOZ REALPE','LUZ LILIANA','DOCENTE','F','','','','',''),('27274779','MUÑOZ PALACIOS','AMANDA PIEDAD','DOCENTE','F','Calle 5a. No. 8-42','','','7266723',''),('27275759','MUÑOZ ACOSTA','GLORIA LILIANA','DOCENTE','F','','','','3113086829',''),('5275693','ARCOS ALVEAR','ALBERTO LEON','DOCENTE','M','Calle 7a. No. 6-13 ','','','3128630375',''),('27276345','RANGEL BRAVO','MARIA MERCEDES','DOCENTE','F','Carrera 6a. No. 2-36','','','3113793328',''),('27274906','PALACIOS DE MORENO','ROSALBA ','DOCENTE','F','Carrera 9 No. 2-55','','','7266093',''),('25519582','LOPEZ','YENNY DALILA','DOCENTE','F','','','','',''),('94376188','ERAZO BEDOYA','HERNAN ','DOCENTE','M','Carrera 9. Calle 8.','','','3146294420',''),('5275828','ORDOÑEZ REALPE','LUIS EDUARDO','DOCENTE','M','Barrio centro','','','7267005',''),('27277920','DORADO SILVA','LILIANA PATRICIA','DOCENTE','F','Carrera 5 No. 2-28','','','3113088385',''),('27276281','MOLINA ALVEAR','NILSA FERNANDA','DOCENTE','F','','','','3217626912',''),('87246929','BRAVO LEDEZMA','HERNANDO','DOCENTE','M','','','','3127465212',''),('87245055','FRANCO ARCESIO LEITON MENESES','FRANCO ARSECIO','DOCENTE','M','','','','3117107571',''),('27274979','ARCOS DE SUARES ','TRINIDAD ','AUXILIAR SS GENERALES','F','','','','3113423412',''),('27275393','BETANCAURTH  DE MUÑOZ  ','BILMA FERNEYDA','AUXILIAR ADMINISTRATIVO','F','','','','3113392800',''),('27276706','CARLOSAMA BOLAÑOS ','MARIA EUGENIA','AUXILIAR SS GENERALES','F','','','','3113902490',''),('5275868','DAVILA GOMEZ ','EDGAR HENRY','CELADOR','M','','','','3103896287',''),('87245324','GAVIRIA BOLAÑOS ','CESAR HARVEY','AUXILIAR SS GENERALES','M','','','','3206523638',''),('27277352','LEDEZMA ORTEGA','DELMY PATRICIA','SECRETARIA','F','CRA 10 No.  8-35 ','','','3148790015',''),('27275666','NELLY LUCIA  MUÑOZ BRAVO ','NELLY LUCIA','AUXILIAR SS GENERALES','F','','','','3146466725',''),('87248780','MUÑOZ HIDALGO','JAIRO ANCIZAR','AUXILIAR SS GENERALES','M','','','','3113325181',''),('87246365','MUÑOZ MUÑOZ ','HERNANDO','AUXILIAR SS GENERALES','M','','','','3206254706',''),('27275034','NARVAEZ PAZ ','MARIA CECILIA','AUXILIAR SS GENERALES','M','','','','3187451202',''),('27275468','REALPE ALVEAR  ','LUCIA','AUXILIAR ADMINISTRATIVO','F','','','','3105984590',''),('87246659','REALPE GUERRERO','ALVARO','AUXILIAR SS GENERALES','M','','','','3105345721',''),('5275862','REALPE NARVAEZ','DANIEL','CELADOR','M','','','','3113793772',''),('87248240','ZAMBRANO HOYOS ','OSCAR FERNANDO','CONDCUTOR','M','','','','3207254991','');

--
-- Table structure for table `temp4`
--

CREATE TABLE `temp4` (
  `nom_cor` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nom` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `coor` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ced` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `eva` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `temp4`
--

INSERT INTO `temp4` VALUES ('DSOCIOA','DIMENSIÓN SOCIOAFECTIVA','','','S'),('DCORPO','DIMENSIÓN CORPORAL','','','S'),('DCOGNIT','DIMENSÓN GOCNITIVA','','','S'),('DCOMUNI','DIMENSIÓN COMUNICATIVA','','','S'),('DESTET','DIMENSIÓN ESTETICA','','','S'),('NATUR','CIENCIAS NATURALES Y EDUCACIÓN AMBIENTAL','','','S'),('QUIM','CIENCIAS NATURALES Y EDUCACIÓN AMBIENTAL QUIMICA','','','S'),('FISC','CIENCIAS NATURALES Y EDUCACIÓN AMBIENTAL FISICA','','','S'),('MATEM','MATEMÁTICAS ','','','S'),('SOCIA','CIENCIAS SOCIALES ','','','S'),('ETICA','EDUCACIÓN ETICA Y EN VALORES','','','S'),('RELIG','EDUCACIÓN RELIGIOSA Y MORAL','','','S'),('CASTE','LENGUA CASTELLANA','','','S'),('ING','INGLES','','','S'),('INFOR','TECNOLOGÍA E INFORMÁTICA','','','S'),('ARTES','EDUCACIÓN ARTÍSTICA ARTES PLASTICAS','','','S'),('MUSI','EDUCACIÓN ARTÍSTICA MÚSICA','','','S'),('DANZ','EDUCACIÓN ARTÍSTICA DANZAS','','','S'),('E. FISI','EDUCACIÓN FÍSICA RECREACIÓN Y DEPORTE','','','S'),('INVES','PEDAG+OGICAS INVESTIGACIÓN EDUCATIVA','','','S'),('PSICO','PEDAGÓGICAS PSICOLOGÍA EDUCTAIVA','','','S'),('FILOS','FILOSOFIA','','','S'),('GEST','PEDAGÓGICAS GESTIÓN EDUCATIVA','','','S'),('T.PED','TENDECIAS PEDAG+OGICAS','','','S'),('P.P.I.I.','PRACTICA DOCENTE','','','S'),('D.PRE','DIDACTICA PREESCOALR','','','N'),('A. EDU.','AYUDAS EDUCATIVAS','','','S'),('COMP','COMPORTAMIENTO','','','N');

--
-- Table structure for table `temp5`
--

CREATE TABLE `temp5` (
  `area` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nomcor` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nombre` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `temp5`
--

INSERT INTO `temp5` VALUES ('DSOCIOA','D SOC','DIMENSIÓN SOCIOAFECTIVA'),('DCORPO','DCORP','DIMENSIÓN CORPORAL'),('DCOGNIT','DCOGN','DIMENSÓN GOCNITIVA'),('DCOMUNI','DCOM','DIMENSIÓN COMUNICATIVA'),('DESTET','DEST','DIMENSIÓN ESTETICA'),('C.NAT','C NAT','CIENCIAS NATURALES Y ED AMBIENTAL'),('QUIM','QUIM','QUIMICA'),('FISICA','FISC','FISICA'),('MATEM','MATEM','MATEMATICAS'),('SOCIA','SOCIA','CIENCIAS SOCIALES'),('ETICA','ETICA','EDUCACIÓN ETICA Y MORAL'),('RELIG','RELIG','EDUCACIÓN RELIGIOSA Y MORAL'),('CASTE','CASTE','HUMANIDADES LENGUA CASTELLANA'),('ING','ING','IDIOMA EXTRANJERO INGLES'),('INFOR','INFOR','TECNOLOGÍA E INFORMÁTICA'),('ARTES','ARTES','EDUCACION ARTISTICA ARTES PLASTICAS'),('MUSI','MUSI','EDUCACIÓN ARTISTICA MUSICA'),('DANZ','DANZ','EDUCACIÓN ARTÍSTICA -DANZAS'),('E. FISI','E.FISI','EDUCACIÓN FÍSICA RECREACIÓN Y DEPORTE'),('INVES','INVES','INVESTIGACIÓN EDUCATIVA'),('PSICO','PSICO','PSCIOLOGIA'),('FILOS','FILOS','FILOSOFIA'),('GEST','GEST','GESTIÓN EDUCATIVA'),('T.PED','T.PED','TENDECIAS PEDAGÓGICAS'),('P.DOC','P.DOC','PRACTICA DOCENTE'),('D.PRE','D.PRE','DIDACTICA PREESCOALR'),('A. EDU.','A. EDU.','AYUDAS EDUCATIVAS');

--
-- Table structure for table `temp_matgra`
--

CREATE TABLE `temp_matgra` (
  `curso` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `materia` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cedula` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ihs` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `temp_matgra`
--

INSERT INTO `temp_matgra` VALUES ('001','D SOC','27275957','5'),('001','DCORP','27275957','5'),('001','DCOGN','27275957','5'),('001','DCOM','27275957','5'),('001','DEST','27275957','5'),('002','D SOC','27275939','5'),('002','DCORP','27275939','5'),('002','DCOGN','27275939','5'),('002','DCOM','27275939','5'),('002','DEST','27275939','5'),('003','D SOC','40022521','5'),('003','DCORP','40022521','5'),('003','DCOGN','40022521','5'),('003','DCOM','40022521','5'),('003','DEST','40022521','5'),('004','D SOC','30729137','5'),('004','DCORP','30729137','5'),('004','DCOGN','30729137','5'),('004','DCOM','30729137','2'),('004','DEST','30729137','5'),('101','ETICA','27275933','1'),('101','RELIG','27275933','1'),('101','CASTE','27275933','5'),('101','ING','27275933','2'),('101','MATEM','27275933','5'),('101','SOCIA','27275933','4'),('101','C NAT','27275933','4'),('101','ARTES','27275933','1'),('101','MUSI','27275933','1'),('101','E.FIS','27275933','2'),('101','INFOR','27275933','2'),('101','COMP','27275933',''),('102','ETICA','27275837','1'),('102','RELIG','27275837','1'),('102','CASTE','27275837','5'),('102','ING','27275837','2'),('102','MATEM','27275837','5'),('102','SOCIA','27275837','4'),('102','C NAT','27275837','4'),('102','ARTES','27275837','1'),('102','MUSI','27275837','1'),('102','E.FIS','27275837','2'),('102','INFOR','27275837','2'),('102','COMP','27275837',''),('103','ETICA','27275327','1'),('103','RELIG','27275327','1'),('103','CASTE','27275327','5'),('103','ING','27275327','2'),('103','MATEM','27275327','5'),('103','SOCIA','27275327','4'),('103','C NAT','27275327','4'),('103','ARTES','27275327','1'),('103','MUSI','27275327','1'),('103','E.FIS','27275327','2'),('103','INFOR','27275327','2'),('103','COMP','27275327',''),('201','ETICA','27275327','1'),('201','RELIG','27275327','1'),('201','CASTE','27275327','5'),('201','ING','27275327','2'),('201','MATEM','27275327','5'),('201','SOCIA','27275327','4'),('201','C NAT','27275327','4'),('201','ARTES','27275327','1'),('201','MUSI','27275327','1'),('201','E.FIS','27275327','2'),('201','INFOR','27275327','2'),('201','COMP','27275327',''),('202','ETICA','27277776','1'),('202','RELIG','27277776','1'),('202','CASTE','27277776','5'),('202','ING','27277776','2'),('202','MATEM','27277776','5'),('202','SOCIA','27277776','4'),('202','C NAT','27277776','4'),('202','ARTES','27277776','1'),('202','MUSI','27277776','1'),('202','E.FIS','27277776','2'),('202','INFOR','27277776','2'),('202','COMP','27277776',''),('203','ETICA','27274898','1'),('203','RELIG','27274898','1'),('203','CASTE','27274898','5'),('203','ING','27274898','2'),('203','MATEM','27274898','5'),('203','SOCIA','27274898','4'),('203','C NAT','27274898','4'),('203','ARTES','27274898','1'),('203','MUSI','27274898','1'),('203','E.FIS','27274898','2'),('203','INFOR','27274898','2'),('203','COMP','27274898','0'),('301','ETICA','79653207','1'),('301','RELIG','79653207','1'),('301','CASTE','79653207','5'),('301','ING','79653207','2'),('301','MATEM','79653207','5'),('301','SOCIA','79653207','4'),('301','C NAT','79653207','4'),('301','ARTES','79653207','1'),('301','MUSI','79653207','1'),('301','E.FIS','79653207','2'),('301','INFOR','79653207','2'),('301','COMP','79653207','0'),('302','ETICA','27275540','1'),('302','RELIG','27275540','1'),('302','CASTE','27275540','5'),('302','ING','27275540','2'),('302','MATEM','27275540','5'),('302','SOCIA','27275540','4'),('302','C NAT','27275540','4'),('302','ARTES','27275540','1'),('302','MUSI','27275540','1'),('302','E.FIS','27275540','2'),('302','INFOR','27275540','2'),('302','COMP','27275540','0'),('303','ETICA','27296191','1'),('303','RELIG','27296191','1'),('303','CASTE','27296191','5'),('303','ING','27296191','2'),('303','MATEM','27296191','5'),('303','SOCIA','27296191','4'),('303','C NAT','27296191','4'),('303','ARTES','27296191','1'),('303','MUSI','27296191','1'),('303','E.FIS','27296191','2'),('303','INFOR','27296191','2'),('303','COMP','27296191','0'),('401','ETICA','87245064','1'),('401','RELIG','87245064','1'),('401','CASTE','87245064','5'),('401','ING','87245064','2'),('401','MATEM','87245064','5'),('401','SOCIA','87245064','4'),('401','C NAT','87245064','4'),('401','ARTES','87245064','1'),('401','MUSI','87245064','1'),('401','E.FIS','87245064','2'),('401','INFOR','87245064','2'),('401','COMP','87245064',''),('402','ETICA','27274498','1'),('402','RELIG','27274498','1'),('402','CASTE','27274498','5'),('402','ING','27274498','2'),('402','MATEM','27274498','5'),('402','SOCIA','27274498','4'),('402','C NAT','27274498','4'),('402','ARTES','27274498','1'),('402','MUSI','27274498','1'),('402','E.FIS','27274498','2'),('402','INFOR','27274498','2'),('402','COMP','27274498','0'),('403','ETICA','27274399','1'),('403','RELIG','27274399','1'),('403','CASTE','27274399','5'),('403','ING','27274399','2'),('403','MATEM','27274399','5'),('403','SOCIA','27274399','4'),('403','C NAT','27274399','4'),('403','ARTES','27274399','1'),('403','MUSI','27274399','1'),('403','E.FIS','27274399','2'),('403','INFOR','27274399','2'),('403','COMP','27274399',''),('501','ETICA','5275765','1'),('501','RELIG','5275765','1'),('501','CASTE','5275765','5'),('501','ING','5275765','2'),('501','MATEM','5275765','5'),('501','SOCIA','5275765','4'),('501','C NAT','5275765','4'),('501','ARTES','5275765','1'),('501','MUSI','5275765','1'),('501','E.FIS','5275765','2'),('501','INFOR','5275765','2'),('501','COMP','5275765',''),('502','ETICA','30701840','1'),('502','RELIG','30701840','1'),('502','CASTE','30701840','5'),('502','ING','30701840','2'),('502','MATEM','30701840','5'),('502','SOCIA','30701840','4'),('502','C NAT','30701840','4'),('502','ARTES','30701840','1'),('502','MUSI','30701840','1'),('502','E.FIS','30701840','2'),('502','INFOR','30701840','2'),('502','COMP','30701840',''),('503','ETICA','12956596','1'),('503','RELIG','12956596','1'),('503','CASTE','12956596','5'),('503','ING','12956596','2'),('503','MATEM','12956596','5'),('503','SOCIA','12956596','4'),('503','C NAT','12956596','4'),('503','ARTES','12956596','1'),('503','MUSI','12956596','1'),('503','E.FIS','12956596','2'),('503','INFOR','12956596','2'),('503','COMP','12956596',''),('601','C NAT','87247100','4'),('601','MATEM','27275143','4'),('601','SOCIA','12976968','4'),('601','ETICA','87247100','1'),('601','RELIG','5275983','1'),('601','CASTE','1088970409','4'),('601','ING','5312302','3'),('601','INFOR','27277502','2'),('601','ARTES','5275708','2'),('601','MUSI','87248085','1'),('601','E.FIS','87245499','2'),('601','INVES','27277502','2'),('601','COMP','27277502','0'),('602','C NAT','87247100','4'),('602','MATEM','27275143','4'),('602','SOCIA','12976968','4'),('602','ETICA','87247100','1'),('602','RELIG','5275983','1'),('602','CASTE','1088970409','4'),('602','ING','5312302','3'),('602','INFOR','27277502','2'),('602','ARTES','5275708','2'),('602','MUSI','87248085','1'),('602','E.FIS','87245499','2'),('602','INVES','27277502','2'),('602','COMP','87247100','0'),('603','C NAT','87247100','4'),('603','MATEM','27275143','4'),('603','SOCIA','12976968','4'),('603','ETICA','87247100','1'),('603','RELIG','5275983','1'),('603','CASTE','27275715','4'),('603','ING','5312302','3'),('603','INFOR','10294642','2'),('603','ARTES','5275708','2'),('603','MUSI','87248085','1'),('603','E.FIS','87245499','2'),('603','INVES','27277502','2'),('603','COMP','5275708','0'),('604','C NAT','87247100','4'),('604','MATEM','27275143','4'),('604','SOCIA','12976968','4'),('604','ETICA','87247100','1'),('604','RELIG','5275983','1'),('604','CASTE','1088970409','4'),('604','ING','5312302','3'),('604','INFOR','10294642','2'),('604','ARTES','5275708','2'),('604','MUSI','87248085','1'),('604','E.FIS','87245499','2'),('604','INVES','27277502','2'),('604','COMP','5312302','0'),('701','C NAT','5275354','4'),('701','MATEM','27275143','5'),('701','SOCIA','87246632','4'),('701','ETICA','87247100','1'),('701','RELIG','5275983','1'),('701','CASTE','1088970409','4'),('701','ING','5379747','3'),('701','INFOR','10294642','2'),('701','ARTES','98392578','2'),('701','MUSI','87248085','1'),('701','E.FIS','87245167','2'),('701','INVES','27277502','1'),('701','COMP','27275143','0'),('702','C NAT','5275354','4'),('702','MATEM','27274908','5'),('702','SOCIA','87246632','4'),('702','ETICA','87247100','1'),('702','RELIG','5275983','1'),('702','CASTE','1088970409','4'),('702','ING','5379747','3'),('702','INFOR','10294642','2'),('702','ARTES','98392578','2'),('702','MUSI','87248085','1'),('702','E.FIS','87245167','2'),('702','INVES','27277502','1'),('702','COMP','5379747','0'),('703','C NAT','5275354','4'),('703','MATEM','27274908','5'),('703','SOCIA','87246632','4'),('703','ETICA','5275354','1'),('703','RELIG','5275983','1'),('703','CASTE','5275370','4'),('703','ING','5379747','3'),('703','INFOR','10294642','2'),('703','ARTES','98392578','2'),('703','MUSI','87248085','1'),('703','E.FIS','87245167','2'),('703','INVES','','1'),('703','COMP','5275983','0'),('801','C NAT','5275354','4'),('801','MATEM','27277337','5'),('801','SOCIA','27087646','4'),('801','ETICA','27275400','1'),('801','RELIG','5275983','1'),('801','CASTE','5275370','4'),('801','ING','30745840','3'),('801','INFOR','10294642','2'),('801','ARTES','5275708','2'),('801','MUSI','87248085','1'),('801','E.FIS','87245499','2'),('801','INVES','27276502','1'),('801','COMP','10294642','0'),('802','C NAT','87245038','4'),('802','MATEM','','5'),('802','SOCIA','27087646','4'),('802','ETICA','','1'),('802','RELIG','5275983','1'),('802','CASTE','5275370','4'),('802','ING','30745840','3'),('802','INFOR','10294642','2'),('802','ARTES','5275708','2'),('802','MUSI','87248085','1'),('802','E.FIS','87245499','2'),('802','INVES','27276502','1'),('802','COMP','10294642','0'),('803','C NAT','87245038','4'),('803','MATEM','27277337','5'),('803','SOCIA','27087646','4'),('803','ETICA','','1'),('803','RELIG','5275983','1'),('803','CASTE','5275370','4'),('803','ING','30745840','3'),('803','INFOR','10294642','2'),('803','ARTES','5275708','2'),('803','MUSI','87248085','1'),('803','E.FIS','','2'),('803','INVES','27276502','1'),('803','COMP','30745840','0'),('804','C NAT','5275354','4'),('804','MATEM','27277337','2'),('804','SOCIA','27087646','5'),('804','ETICA','27275400','4'),('804','RELIG','5275983','1'),('804','CASTE','5275370','1'),('804','ING','30745840','4'),('804','INFOR','10294642','3'),('804','ARTES','5275708','2'),('804','MUSI','87248085','2'),('804','E.FIS','87245499','1'),('804','INVES','27276502','2'),('804','COMP','5275370','1'),('901','C NAT','87245038','4'),('901','FISC','27274908','2'),('901','MATEM','51739473','4'),('901','SOCIA','27275400','4'),('901','ETICA','31265134','1'),('901','RELIG','5275983','1'),('901','CASTE','27275715','3'),('901','ING','5379747','3'),('901','INFOR','10294642','2'),('901','ARTES','98392578','2'),('901','MUSI','87248085','1'),('901','E.FIS','87245167','2'),('901','INVES','27276502','1'),('901','COMP','87245038','0'),('902','C NAT','87245038','4'),('902','FISC','27274908','2'),('902','MATEM','51739473','4'),('902','SOCIA','27275400','4'),('902','ETICA','31265134','1'),('902','RELIG','5275983','1'),('902','CASTE','27275715','3'),('902','ING','5379747','3'),('902','INFOR','10294642','2'),('902','ARTES','98392578','2'),('902','MUSI','87248085','1'),('902','E.FIS','87245167','2'),('902','INVES','27276502','1'),('902','COMP','27275715','0'),('903','C NAT','87245038','4'),('903','FISC','27274908','2'),('903','MATEM','51739473','4'),('903','SOCIA','27275400','4'),('903','ETICA','31265134','1'),('903','RELIG','5275983','1'),('903','CASTE','27275715','3'),('903','ING','5379747','3'),('903','INFOR','36754745','2'),('903','ARTES','98392578','2'),('903','MUSI','87248085','1'),('903','E.FIS','87245167','2'),('903','INVES','27276502','1'),('903','COMP','27274908','0'),('1001','QUIM','87245213','3'),('1001','FISC','10296762','3'),('1001','MATEM','12983292','3'),('1001','SOCIA','87246632','2'),('1001','ETICA','27275400','1'),('1001','RELIG','5275983','1'),('1001','CASTE','27275638','3'),('1001','ING','5312302','2'),('1001','INFOR','36754745','2'),('1001','ARTES','5275708','1'),('1001','MUSI','87248085','1'),('1001','E.FIS','87245167','2'),('1001','FILOS','87246913','2'),('1001','INVES','27276502','1'),('1001','PSICO','5339822','2'),('1001','GEST','27277502','1'),('1001','COMP','87246632','0'),('1002','QUIM','87245213','3'),('1002','FISC','10296762','3'),('1002','MATEM','51739473','3'),('1002','SOCIA','87246632','2'),('1002','ETICA','27275400','1'),('1002','RELIG','5275983','1'),('1002','CASTE','27275638','3'),('1002','ING','5312302','2'),('1002','INFOR','36754745','2'),('1002','ARTES','5275708','1'),('1002','MUSI','87248085','1'),('1002','E.FIS','87245167','2'),('1002','FILOS','87246913','2'),('1002','INVES','27276502','1'),('1002','PSICO','5339822','2'),('1002','GEST','27277502','1'),('1002','COMP','10296762','0'),('1003','QUIM','31265134','3'),('1003','FISC','10296762','3'),('1003','MATEM','27277337','3'),('1003','SOCIA','87246632','2'),('1003','ETICA','27275400','1'),('1003','RELIG','5275983','1'),('1003','CASTE','27275715','3'),('1003','ING','5312302','2'),('1003','INFOR','36754745','2'),('1003','ARTES','5275708','1'),('1003','MUSI','87248085','1'),('1003','E.FIS','87245167','2'),('1003','FILOS','87246913','2'),('1003','INVES','27276502','1'),('1003','PSICO','5339822','2'),('1003','GEST','27277502','1'),('1003','COMP','27275400','0'),('1004','QUIM','31265134','3'),('1004','FISC','27274908','3'),('1004','MATEM','51739473','3'),('1004','SOCIA','87246632','2'),('1004','ETICA','27276502','1'),('1004','RELIG','','1'),('1004','CASTE','27275715','3'),('1004','ING','5379747','2'),('1004','INFOR','36754745','2'),('1004','ARTES','5275708','1'),('1004','MUSI','87248085','1'),('1004','E.FIS','87245167','2'),('1004','FILOS','87246913','2'),('1004','INVES','27276502','1'),('1004','PSICO','27276502','2'),('1004','GEST','27277502','1'),('1004','COMP','51739473','0'),('1005','QUIM','31265134','3'),('1005','FISC','27274908','3'),('1005','MATEM','51739473','3'),('1005','SOCIA','87246632','2'),('1005','ETICA','27276502','1'),('1005','RELIG','5275983','1'),('1005','CASTE','27275715','3'),('1005','ING','5379747','2'),('1005','INFOR','36754745','2'),('1005','ARTES','5275708','1'),('1005','MUSI','87248085','1'),('1005','E.FIS','87245167','2'),('1005','FILOS','87246913','2'),('1005','INVES','27276502','1'),('1005','PSICO','5339822','2'),('1005','GEST','27277502','1'),('1005','COMP','27276502','0'),('1101','QUIM','87245213','3'),('1101','FISC','10296762','3'),('1101','MATEM','12983292','3'),('1101','SOCIA','27087646','2'),('1101','ETICA','31265134','1'),('1101','RELIG','87246913','1'),('1101','CASTE','27275638','3'),('1101','ING','30745840','2'),('1101','INFOR','36754745','2'),('1101','ARTES','98392578','2'),('1101','MUSI','87248085','1'),('1101','E.FIS','87245499','1'),('1101','FILOS','87246913','2'),('1101','INVES','87245774','2'),('1101','PSICO','5339822','1'),('1101','GEST','87245774','1'),('1101','COMP','87245213','0'),('1102','QUIM','87245213','3'),('1102','FISC','10296762','3'),('1102','MATEM','12983292','3'),('1102','SOCIA','27087646','2'),('1102','ETICA','31265134','1'),('1102','RELIG','5275983','1'),('1102','CASTE','27275638','3'),('1102','ING','30745840','2'),('1102','INFOR','36754745','2'),('1102','ARTES','98392578','2'),('1102','MUSI','87248085','1'),('1102','E.FIS','87245499','1'),('1102','FILOS','87246913','2'),('1102','INVES','87245774','2'),('1102','PSICO','5339822','1'),('1102','GEST','87245774','1'),('1102','COMP','12983292','0'),('1103','QUIM','87245213','3'),('1103','FISC','10296762','3'),('1103','MATEM','12983292','3'),('1103','SOCIA','27087646','2'),('1103','ETICA','31265134','1'),('1103','RELIG','5275983','1'),('1103','CASTE','27275638','3'),('1103','ING','30745840','2'),('1103','INFOR','36754745','2'),('1103','ARTES','98392578','2'),('1103','MUSI','87248085','1'),('1103','E.FIS','87245499','1'),('1103','FILOS','87246913','2'),('1103','INVES','87245774','2'),('1103','PSICO','5339822','1'),('1103','GEST','87245774','1'),('1103','COMP','27275638','0'),('1104','QUIM','87245213','3'),('1104','FISC','10296762','3'),('1104','MATEM','12983292','3'),('1104','SOCIA','27275400','2'),('1104','ETICA','31265134','1'),('1104','RELIG','5275983','1'),('1104','CASTE','27275638','3'),('1104','ING','30745840','2'),('1104','INFOR','36754745','2'),('1104','ARTES','98392578','2'),('1104','MUSI','87248085','1'),('1104','E.FIS','87245499','1'),('1104','FILOS','87246913','2'),('1104','INVES','87245774','2'),('1104','PSICO','5339822','1'),('1104','GEST','87245774','1'),('1104','COMP','31265134','0'),('1201','C NAT','31265134','4'),('1201','MATEM','12983292','4'),('1201','CASTE','27275638','4'),('1201','INVES','87246913','2'),('1201','PSICO','5339822','2'),('1201','A. ED','98392578','2'),('1201','D.PRE','27276502','4'),('1201','P.DOC','5339822','6'),('1201','T.PED','87245774','2'),('1201','COMP','5339822','0'),('1301','MATEM','12983292','4'),('1301','SOCIA','12976968','2'),('1301','ETICA','31265134','2'),('1301','MUSI','','2'),('1301','ING','5312302','4'),('1301','INFOR','36754745','2'),('1301','FILOS','87246913','2'),('1301','INVES','87245774','2'),('1301','PSICO','','2'),('1301','GEST','27277502','2'),('1301','P.DOC','87245774','6'),('1301','COMP','87245774','0');

--
-- Table structure for table `tip_diag`
--

CREATE TABLE `tip_diag` (
  `id_tip_dia` bigint(6) unsigned NOT NULL AUTO_INCREMENT,
  `des_tip_dia` text COLLATE utf8_spanish_ci NOT NULL,
  `fec_ini_tip_dia` date NOT NULL DEFAULT '0000-00-00',
  `fec_fin_tip_dia` date NOT NULL DEFAULT '0000-00-00',
  `est_tip_dia` enum('a','i') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'a' COMMENT 'activo, inactivo',
  `per_tdia` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 's',
  PRIMARY KEY (`id_tip_dia`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tip_diag`
--


--
-- Table structure for table `tip_docu`
--

CREATE TABLE `tip_docu` (
  `id_trp` int(3) NOT NULL AUTO_INCREMENT,
  `nom_trp` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `txt_trp` varchar(250) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cod_trp` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `ver_trp` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `fec_trp` date NOT NULL,
  `hist_esc` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'n',
  `id_pri` int(11) DEFAULT NULL COMMENT 'privilegio al que esta asociado',
  `tipo` enum('g','p') COLLATE utf8_spanish_ci DEFAULT 'g' COMMENT 'generico o particular',
  `fir_trp` text COLLATE utf8_spanish_ci,
  `codigo` text COLLATE utf8_spanish_ci NOT NULL COMMENT 'Código para ejecutar en el reporte',
  PRIMARY KEY (`id_trp`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci ROW_FORMAT=FIXED;

--
-- Dumping data for table `tip_docu`
--

INSERT INTO `tip_docu` VALUES (1,'PLANILLA DE SEGUIMIENTO DEL ESTUDIANTE','','Año Escolar','2014','2012-04-16','n',NULL,'g',NULL,''),(2,'ESTRUCTURAS DE AREA, CONOCIMIENTO Y PROYECTOS','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(3,'REPORTE DE VALORACIONES','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(4,'REPORTE DE ASISTENCIA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(5,'REPORTE DE IMPUNTUALIDAD','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(6,'OBSERVADOR DEL ESTUDIANTE','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(7,'PLANILLA DE ASISTENCIA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(8,'REPORTE DE SALIDAS DE LA INSTITUCION','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(9,'INASISTENCIA EN LA MATERIA DE','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(10,'PLAN DE MEJORAMIENTO DEL ESTUDIANTE','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(11,'REPORTE DE ACTIVIDADES DEL PLAN DE MEJORAMIENTO','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(12,'REPORTE DE RECUPERACIONES','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(13,'LISTA DE ESTUDIANTES CON NECESIDADES ESPECIALES','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(15,'HISTORIA ESCOLAR DEL ESTUDIANTE','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(16,'REPORTE PIA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(17,'PLANEACION CORTA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(18,'ALCALDIA MUNICIPAL DE PASTO - SECRETARIA DE EDUCACIÓN <br> Decreto No. 0259 del 9 de Julio de 2007 <br> Código DANE No. 152001005116 - NIT No. 900000876-1','','Año Escolar','2014','2014-05-28','n',NULL,'g','{\"f1\":{\"id\":\"f1\",\"aplica\":\"s\",\"label\":\"DIRECTOR (A) DE GRUPO\",\"id_per\":\"-1\",\"cc\":\"n\",\"img\":\"n\",\"cargo\":\"s\"},\"f2\":{\"id\":\"f2\",\"aplica\":\"s\",\"label\":\"Firma 2\",\"id_per\":\"1000\",\"cc\":\"n\",\"img\":\"s\",\"cargo\":\"s\"},\"f3\":{\"id\":\"f3\",\"aplica\":\"n\",\"label\":\"Firma 3\",\"id_per\":\"-1\",\"cc\":\"n\",\"img\":\"n\",\"cargo\":\"n\"},\"f4\":{\"id\":\"f4\",\"aplica\":\"n\",\"label\":\"Firma 4\",\"id_per\":\"-1\",\"cc\":\"n\",\"img\":\"n\",\"cargo\":\"n\"}}','function getPar($dat=array()){\r\n	global $con,$cod_niv,$cod_gra,$cod_cur,$id_alu,$id_peri,$filaresCab;\r\n	$fil_niv=\'\';$fil_gra=\'\';$fil_cur=\'\';$fil_alu=\'\';$fil_peri=\'\';\r\n	if($cod_niv!=\'%\')$fil_niv=\"AND g.cod_niv=$cod_niv\";	\r\n	if($cod_gra!=\'%\')$fil_gra=\"AND c.cod_gra=$cod_gra\";\r\n	if($cod_cur!=\'%\')$fil_cur=\"AND imc.cod_cur=$cod_cur\";\r\n	if($id_alu!=\'%\')$fil_alu=\"AND ac.id_alu=$id_alu\";\r\n	if($id_peri!=\'%\')$fil_peri=\"AND imc.id_peri=$id_peri\";\r\n	if(count($dat)==0){\r\n		$query=\"SELECT c.cod_cur,imc.id_peri,ac.id_alu,imc.cod_mat,tn.id_tniv,tn.des_tniv,tc.nota,\r\n		GROUP_CONCAT(t.des_tem,\' \') AS des_tem \r\n		FROM inst_mat_cur imc\r\n		INNER JOIN curso c USING(cod_cur)\r\n		INNER JOIN alumcurso ac USING(cod_cur)\r\n		INNER JOIN grado g USING(cod_gra)\r\n		INNER JOIN instancia_relacion ir USING(cod_ins)\r\n		INNER JOIN tematica t ON t.cod_tem=ir.id_sup\r\n		INNER JOIN tipo_nivel tn USING(id_tniv)\r\n		LEFT JOIN tmp_consolidado tc ON tc.id_tniv=t.id_tniv AND tc.id_alu=ac.id_alu AND tc.cod_mat=imc.cod_mat \r\n		AND tc.cod_cur=imc.cod_cur AND tc.id_peri=imc.id_peri\r\n		WHERE TRUE $fil_niv $fil_gra $fil_cur $fil_alu $fil_peri\r\n		GROUP BY c.cod_cur,imc.id_peri,ac.id_alu,imc.cod_mat,tn.id_tniv,tn.des_tniv,tc.nota\";\r\n		$r=$con->query($query);\r\n		$regs=array();\r\n		while($f=$con->fetch($r)){$regs[$f[\'cod_cur\']][$f[\'id_alu\']][$f[\'cod_mat\']][$f[\'id_tniv\']]=$f;}\r\n		return $regs;\r\n	}else{\r\n	?>\r\n   	<table width=\"100%\" border=\"1\">\r\n    <?php foreach($dat as $id_tniv=>$tn){?>\r\n    	<tr><td><?php echo \"{$tn[\'des_tniv\']}: {$tn[\'des_tem\']}\";?></td> <td width=\"50\"><?php echo $tn[\'nota\']?$tn[\'nota\']:\'\';?></td></tr>\r\n    <?php }?>\r\n    </table>\r\n    <?php			\r\n	}\r\n}\r\n'),(19,'CONSOLIDADO POR ASIGNATURA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(20,'VALORACIÓN POR SECCIÓN Y ASIGNATURA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(21,'PONDERADOS POR ASIGNATURA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(22,'ESTADO DE CUENTA DEL ESTUDIANTE','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(23,'INGRESOS POR FECHA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(24,'PLANILLA GENERAL DE PAGOS DE SERVICIOS','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(25,'RELACION DE PAGOS ANTICIPADOS','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(26,'ESTADO DE INGRESOS POR SERVICIO','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(27,'PAGOS POR MES','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(28,'REPORTE DE CARTERA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(29,'CARTERA POR EDADES','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(30,'TARJETA DE MATRICULA','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(31,'ESTUDIANTES CON DEUDAS DE AÑOS ANTERIORES','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(32,'CONSOLIDADO ESTADÍSTICO FIN DE AÑO','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(33,'LISTADO DE ESTUDIANTES POR PUESTO','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(34,'CUADRO DE HONOR','','Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(35,'CONSOLIDADO NOTAS EN LA SECCION','','Año Escolar','2014','2012-04-23','n',NULL,'g','{\"f1\":{\"id\":\"f1\",\"aplica\":\"s\",\"label\":\"Firma 1\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f2\":{\"id\":\"f2\",\"aplica\":\"s\",\"label\":\"Firma 2\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f3\":{\"id\":\"f3\",\"aplica\":\"n\",\"label\":\"Firma 3\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f4\":{\"id\":\"f4\",\"aplica\":\"n\",\"label\":\"Firma 4\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"}}',''),(36,'FACTURA DE MATRICULA<br/>ESTUDIANTE ANTIGUO','DESPRENDIBLE DE PAGO','Año Escolar','2014','2010-12-11','n',NULL,'g',NULL,''),(38,'SEGUIMIENTO POR ESTUDIANTE',NULL,'Año Escolar','2014','0000-00-00','n',NULL,'g',NULL,''),(39,'REPORTE DE INASISTENCIA E IMPUNTUALIDADES',NULL,'Año Escolar','2014','0000-00-00','n',NULL,'g',NULL,''),(40,'ESTADÍSTICAS DE PERMISOS',NULL,'Año Escolar','2014','2012-04-23','n',NULL,'g',NULL,''),(41,'COMPROBANTE DE REGISTRO',NULL,'Año Escolar','2014','2012-09-11','n',NULL,'g',NULL,''),(42,'LISTADO DE ASPIRANTES',NULL,'Año Escolar','2014','2012-09-29','n',NULL,'g',NULL,''),(43,'INFORMACIÓN DE ESTUDIANTES',NULL,'Año Escolar','2014','2012-11-01','n',NULL,'g',NULL,''),(44,'DOCUMENTO DE MATRÍCULA',NULL,'Año Escolar','2014','2012-11-03','n',NULL,'g',NULL,''),(45,'MATRÍCULA LEGALIZADA',NULL,'Año Escolar','2014','2012-11-06','n',NULL,'g',NULL,''),(46,'MATERIAS PERDIDAS POR NOTA Y/O FALTAS',NULL,'Año Escolar','2014','2012-11-17','n',NULL,'g',NULL,''),(47,'PAZ Y SALVO',NULL,'Año Escolar','2014','2012-11-27','n',NULL,'g',NULL,''),(37,'REGISTRO DE VALORACIONES',NULL,'Año Escolar','2014','2012-11-17','n',NULL,'g',NULL,''),(48,'REGISTRO DE VALORACIONES','','Año Escolar','2014','2012-12-28','n',NULL,'g','{\"f1\":{\"id\":\"f1\",\"aplica\":\"s\",\"label\":\"Firma 1\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f2\":{\"id\":\"f2\",\"aplica\":\"s\",\"label\":\"Firma 2\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f3\":{\"id\":\"f3\",\"aplica\":\"n\",\"label\":\"Firma 3\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f4\":{\"id\":\"f4\",\"aplica\":\"n\",\"label\":\"Firma 4\",\"id_per\":\"1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"}}',''),(49,'BOLETA DE NOTIFICACIÓN',NULL,'Año Escolar','2014','2013-02-19','n',NULL,'g',NULL,''),(52,'LISTADO DE NOTIFICACIÓN',NULL,'Año Escolar','2014','2013-02-19','n',NULL,'g',NULL,''),(51,'ÁLBUM ESTUDIANTIL',NULL,'Año Escolar','2014','2013-02-19','n',NULL,'g',NULL,''),(14,'RESULTADOS DE EVALUACIÓN DOCENTE',NULL,'Año Escolar','2014','2013-04-11','n',NULL,'g',NULL,''),(53,'CERTIFICADOS',NULL,'','','0000-00-00','n',NULL,'g','{\"f1\":{\"id\":\"f1\",\"aplica\":\"s\",\"label\":\"Firma 1\",\"id_per\":\"-1\",\"cc\":\"s\",\"img\":\"n\",\"cargo\":\"s\"},\"f2\":{\"id\":\"f2\",\"aplica\":\"n\",\"label\":\"Firma 2\",\"id_per\":\"-1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f3\":{\"id\":\"f3\",\"aplica\":\"n\",\"label\":\"Firma 3\",\"id_per\":\"-1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"},\"f4\":{\"id\":\"f4\",\"aplica\":\"n\",\"label\":\"Firma 4\",\"id_per\":\"-1\",\"cc\":\"s\",\"img\":\"s\",\"cargo\":\"s\"}}',''),(60,'SATURACIÓN DE EVALUACIONES',NULL,'Año Escolar','2014','2014-08-27','n',NULL,'g',NULL,'');

--
-- Table structure for table `tip_salida`
--

CREATE TABLE `tip_salida` (
  `id_tip_sal` int(10) NOT NULL DEFAULT '0',
  `nom_tip_sal` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id_tip_sal`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tip_salida`
--


--
-- Table structure for table `tipo_inst`
--

CREATE TABLE `tipo_inst` (
  `cod_tip_ins` int(3) NOT NULL AUTO_INCREMENT,
  `des_tip_ins` text COLLATE utf8_spanish_ci NOT NULL,
  `est_tip_ins` enum('a','i') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'a',
  `tip_eva` enum('ev','re','au','co','ep','ap') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'ev',
  `res_tins` enum('i','u') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'u',
  `ord_tins` int(2) NOT NULL DEFAULT '1',
  `color` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`cod_tip_ins`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipo_inst`
--

INSERT INTO `tipo_inst` VALUES (1,'Evaluación escrita','a','ev','u',1,'#d3ebff '),(2,'Taller','a','ev','u',1,'#e2f2ff'),(3,'Evaluación escrita','a','ev','u',1,'#f6fbff'),(4,'Ensayo','a','ev','u',1,NULL),(5,'Laboratorio','a','ev','u',1,NULL);

--
-- Table structure for table `tipo_nivel`
--

CREATE TABLE `tipo_nivel` (
  `id_tniv` int(11) NOT NULL AUTO_INCREMENT,
  `des_tniv` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id_tniv`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipo_nivel`
--

INSERT INTO `tipo_nivel` VALUES (1,'  SABER'),(2,' HACER'),(3,' SER'),(4,'DE SI MISMO (PREES)'),(5,'TECNICO CIENTIFICO (PREES)'),(6,'COMUNICATIVO EN EL MUNDO (PREES)');

--
-- Table structure for table `tipo_pag`
--

CREATE TABLE `tipo_pag` (
  `id_tip` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `des_tipo` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
  `rel_pag` enum('debi','cred') COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id_tip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipo_pag`
--


--
-- Table structure for table `tipo_responsable`
--

CREATE TABLE `tipo_responsable` (
  `cod_tre` bigint(6) NOT NULL AUTO_INCREMENT,
  `des_tre` text COLLATE utf8_spanish_ci,
  PRIMARY KEY (`cod_tre`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipo_responsable`
--


--
-- Table structure for table `tipobsest`
--

CREATE TABLE `tipobsest` (
  `cod_toe` int(3) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `des_toe` varchar(150) COLLATE utf8_spanish_ci NOT NULL,
  `boletin` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'n',
  `faltas` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'n',
  `categoria` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`des_toe`),
  UNIQUE KEY `cod_toe` (`cod_toe`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipobsest`
--

INSERT INTO `tipobsest` VALUES (001,'Observación Academica','n','n','n'),(003,'Observación Convivencia','n','n','n'),(004,'De Boletin','s','n','n'),(005,'Pelea en clase','n','s','n'),(006,'Pelea fuera del plantel','n','s','n'),(007,'Pelea en el plantel','n','s','n'),(008,'Fraude en examen','n','s','n'),(009,'Robo a compañeros','n','s','n'),(010,'Robo a funcionarios','n','s','n'),(011,'Bullying','n','s','n'),(012,' Incidencia academica','n','s','n'),(013,' Incidencia de Comportamiento','n','s','n'),(014,'En Boletin ','s','s','n');

--
-- Table structure for table `tipodocum`
--

CREATE TABLE `tipodocum` (
  `cod_tid` tinyint(1) NOT NULL AUTO_INCREMENT,
  `des_tid` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
  `cod_tid_DANE` char(3) COLLATE utf8_spanish_ci NOT NULL,
  `des_tid_cor` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`cod_tid`),
  KEY `cod_tid` (`cod_tid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipodocum`
--

INSERT INTO `tipodocum` VALUES (1,'CEDULA DE CIUDADANIA','1',NULL),(4,'CEDULA DE EXTRANJERIA','4',NULL),(5,'PASAPORTE','5',NULL),(3,'REGISTRO CIVIL','3',NULL),(2,'TARJETA DE IDENTIDAD','2',NULL),(6,'NUIP','6',NULL),(7,'NES','7',NULL),(8,'NIP','8',NULL);

--
-- Table structure for table `tipususis`
--

CREATE TABLE `tipususis` (
  `tip_usu` int(3) NOT NULL AUTO_INCREMENT,
  `des_usu` varchar(25) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`tip_usu`),
  UNIQUE KEY `des_usu` (`des_usu`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipususis`
--

INSERT INTO `tipususis` VALUES (1,'SUPERUSUARIO'),(2,'DIR. GRUPO'),(3,'PROFESOR'),(4,'COORDINADOR'),(5,'SECRETARIA1'),(6,'ACTUALIZACION'),(10,'DEPORTES'),(7,'ADMINISTRADOR');

--
-- Table structure for table `tipususismen`
--

CREATE TABLE `tipususismen` (
  `id_men` int(3) NOT NULL DEFAULT '0',
  `tip_usu` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_men`,`tip_usu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipususismen`
--

INSERT INTO `tipususismen` VALUES (1,1),(2,1),(2,4),(2,5),(2,7),(4,1),(4,5),(4,7),(5,1),(5,2),(5,3),(5,5),(5,7),(6,1),(6,2),(6,3),(6,4),(6,5),(6,7),(7,1),(7,2),(7,4),(7,5),(7,7),(9,1),(11,1),(11,4),(11,5),(11,7),(12,1),(12,4),(12,7),(13,1),(13,5),(13,7),(14,1),(14,5),(14,7),(15,1),(15,3),(15,4),(15,7),(16,1),(16,5),(16,7),(17,1),(17,7),(18,1),(18,5),(18,7),(19,2),(19,3),(20,1),(20,2),(20,3),(20,4),(20,5),(20,7),(21,1),(21,2),(21,3),(21,4),(21,5),(21,7),(22,1),(22,2),(22,3),(22,4),(22,5),(22,7),(23,1),(23,2),(23,4),(23,5),(24,1),(24,4),(25,1),(25,2),(25,4),(33,4),(38,1),(38,7),(41,1),(41,3),(41,4),(41,5),(41,7),(42,1),(43,1),(43,2),(43,4),(45,1),(45,7),(46,1),(46,4),(48,1),(48,4),(48,5),(48,7),(49,1),(49,4),(49,5),(50,1),(50,2),(50,3),(50,7),(55,1),(55,7),(56,1),(56,4),(56,5),(56,7),(58,1),(58,7),(59,1),(59,5),(60,1),(60,5),(61,1),(63,1),(63,3),(63,4),(64,1),(64,5),(64,7),(65,1),(65,5),(65,7),(66,1),(66,5),(66,7),(67,1),(67,5),(67,7),(68,1),(68,4),(68,5),(69,4),(70,2),(70,4),(71,2),(71,4),(72,1),(72,4),(72,5),(72,7),(73,1),(73,3),(73,4),(73,5),(73,7),(75,1),(75,4),(75,5),(75,7),(78,1),(78,4),(78,5),(78,7),(82,1),(82,4),(82,7),(83,1),(83,5),(84,1),(84,5),(85,1),(85,5),(86,1),(86,5),(89,1),(89,5),(89,7),(90,1),(90,7),(92,1),(92,4),(97,4),(98,3),(99,1),(99,7),(100,1),(101,2),(107,4),(108,1),(108,4),(109,1),(109,4),(110,4),(113,4),(114,2),(114,4),(115,1),(115,4),(115,5),(115,7),(118,1),(118,4),(119,4),(122,1),(122,4),(123,4),(124,1),(124,4),(125,4),(126,4),(127,2),(127,4),(128,4),(129,2),(129,4),(130,1),(130,4),(130,7),(132,1),(132,3),(132,4),(132,5),(132,7),(133,1),(133,5),(133,7),(134,1),(134,5),(135,1),(135,4),(136,1),(136,2),(136,4),(136,5),(136,7),(137,1),(137,2),(137,4),(137,7),(138,1),(138,4),(138,5),(138,7),(140,1),(140,4),(140,5),(140,7),(141,1),(141,4),(141,7),(142,1),(142,4),(142,7),(143,2),(143,4),(144,4),(144,7),(146,1),(146,5),(146,7),(151,1),(151,4),(151,7),(152,4),(152,7),(153,1),(153,4),(153,5),(153,7),(154,4),(154,7),(155,1),(155,4),(155,7),(156,4),(156,7),(157,1),(157,4),(157,5),(157,7),(158,1),(158,2),(158,4),(158,5),(158,7),(159,2),(159,3),(159,4),(159,7),(161,1),(161,2),(161,3),(161,4),(161,5),(161,7),(162,1),(162,4),(162,5),(162,7),(163,3),(163,4),(163,7),(164,1),(164,4),(164,7),(165,1),(165,4),(165,7),(166,4),(166,7),(167,1),(167,4),(167,7),(168,4),(169,1),(169,4),(170,1),(170,4),(171,3),(171,4),(171,7),(172,1),(172,4),(172,5),(172,7),(173,1),(174,1),(174,4),(174,5),(174,7),(175,1),(175,2),(175,4),(175,5),(178,1),(179,1),(179,4),(179,5),(179,7),(180,4),(180,7),(181,1),(181,4),(181,5),(181,7),(182,1),(182,4),(182,7),(183,1),(183,4),(183,5),(183,7),(186,1),(186,4),(186,5),(186,7),(187,1),(187,4),(187,5),(187,7),(188,3),(188,4),(188,7),(189,1),(189,4),(189,5),(189,7),(190,1),(190,4),(190,5),(190,7),(193,4),(193,7),(209,1),(209,7),(217,4),(218,4),(219,4),(220,4),(221,4),(222,4),(223,4),(224,4),(225,4),(226,4),(228,4),(233,1),(233,4),(233,7),(237,4),(239,1),(239,4),(239,5),(239,7),(241,1),(241,7),(242,1),(242,7),(245,1),(245,4),(245,5),(245,7),(246,1),(246,4),(246,7),(247,1),(247,4),(247,7),(248,1),(248,4),(248,7),(249,1),(249,4),(249,7),(250,1),(250,4),(250,5),(250,7),(251,1),(251,4),(251,7),(252,1),(252,4),(252,5),(252,7),(253,1),(253,7),(256,1),(257,4),(257,7),(258,3),(258,4),(258,7),(264,1),(264,4),(264,5),(264,7),(266,1),(266,4),(266,5),(266,7),(268,1),(268,4),(268,5),(268,7),(269,1),(269,4),(270,1),(270,4),(271,1),(272,1),(273,1),(274,1),(275,1),(276,1),(277,1),(277,3),(277,4),(278,2),(279,1),(280,1),(280,7),(281,2),(281,4),(282,1),(282,4),(283,1),(283,2),(283,4),(284,1),(284,4),(285,1),(285,4),(285,7),(286,1),(286,2),(286,4),(286,7),(287,1),(287,5),(287,7),(288,1),(289,1),(290,1),(290,3),(290,4),(291,1),(291,4),(291,5),(291,7),(292,1),(292,4),(292,7),(293,1),(293,5),(293,7),(294,1),(295,1),(295,4),(295,5),(295,7),(299,1),(299,4),(299,5),(299,7),(302,1),(302,4),(302,5),(303,1),(303,4),(303,5),(304,1),(304,4),(304,5),(305,1),(305,4),(305,5),(305,7),(306,1),(306,3),(306,4),(306,5),(306,7),(307,1),(307,4),(307,5),(307,7),(309,1),(309,5),(309,7),(310,2),(310,3),(311,1),(312,1),(319,1),(319,4),(319,5),(319,7),(320,1),(320,5),(321,1),(321,3),(321,4),(321,5),(321,7),(322,1),(322,7),(324,1),(324,3),(324,4),(324,5),(324,7),(325,1),(325,4),(325,5),(325,7),(328,1),(330,1),(332,2),(336,1),(336,4),(337,4),(338,4),(339,4),(340,4),(341,4),(342,4),(343,4),(344,4),(345,4),(346,4),(347,4),(348,4),(349,4),(350,4),(351,4),(352,4),(353,4),(354,4),(355,4),(356,4),(357,4),(358,4),(359,4),(360,4),(361,4),(362,4),(363,4),(364,4),(365,4),(366,4),(367,4),(368,2),(368,3),(370,1),(387,1),(412,4),(413,1),(413,4),(414,4),(415,1),(415,4),(416,4),(417,1),(417,7),(418,1),(418,5),(418,7),(419,1),(419,5),(419,7),(421,1),(421,5),(421,7),(423,1),(423,4),(424,4),(425,1),(425,3),(425,4),(425,5),(425,7),(426,4),(427,2),(427,4),(430,4),(430,7),(432,1),(433,1),(433,2),(433,3),(433,4),(433,5),(433,7),(434,1),(435,1),(436,1),(438,1),(439,1),(443,1),(444,1),(445,1),(446,1),(446,3),(446,7),(447,1),(448,1),(449,1),(450,1),(451,1),(452,1),(453,1),(454,1),(455,1),(456,1),(458,1),(459,1),(461,1),(464,1),(465,1),(466,1),(467,1),(468,1),(468,7),(469,1),(469,7),(470,1),(471,1),(471,7),(472,1),(473,1),(474,1),(475,1),(476,1),(477,1),(478,1),(479,1),(480,1),(481,1),(483,1),(483,7),(484,1),(487,1),(488,1),(488,7),(489,1),(489,7),(490,1),(490,7),(491,1),(491,7),(492,1),(492,5),(492,7),(493,1),(493,7),(495,1),(495,7),(496,7),(497,1),(497,7),(498,1),(498,7),(499,1),(499,7),(500,1),(500,7),(501,1),(501,7),(502,1),(502,7),(503,1),(503,7),(504,1),(504,7),(505,7),(506,5),(506,7),(507,1),(510,1),(511,1),(511,5),(511,7),(512,1),(512,3),(512,5),(512,7),(513,1),(513,7),(514,1),(514,7),(515,1),(515,7),(516,1),(516,5),(516,7),(517,1),(517,7),(518,1),(518,5),(518,7),(519,1),(519,7),(520,7),(521,1),(526,1),(527,1),(530,1),(530,7),(531,1);

--
-- Table structure for table `tipususispri`
--

CREATE TABLE `tipususispri` (
  `tip_usu` int(3) NOT NULL DEFAULT '1',
  `id_pri` int(3) NOT NULL DEFAULT '1',
  `hab_pri` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 's',
  PRIMARY KEY (`tip_usu`,`id_pri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipususispri`
--


--
-- Table structure for table `tipvalora`
--

CREATE TABLE `tipvalora` (
  `id_val` int(3) NOT NULL AUTO_INCREMENT,
  `des_val` varchar(25) COLLATE utf8_spanish_ci NOT NULL,
  `let_val` char(3) COLLATE utf8_spanish_ci NOT NULL,
  `val_apr` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 's',
  `des_val2` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `let_val2` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
  `des_val3` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `let_val3` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
  `des_val_nor` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `let_val_nor` varchar(3) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`des_val`,`let_val`),
  KEY `id_val2` (`id_val`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tipvalora`
--

INSERT INTO `tipvalora` VALUES (1,'SUPERIOR','SP','s','SUPERIOR','SP','SUPERIOR','SP','SUPERIOR','SP'),(2,'ALTO','AL','s','ALTO','AL','ALTO','AL','ALTO','AL'),(3,'BASICO','BS','s','BASICO','BS','BASICO','BS','BASICO','BS'),(4,'BAJO','BJ','n','BAJO','BJ','BAJO','BJ','BAJO','BJ');

--
-- Table structure for table `tmp_consolidado`
--

CREATE TABLE `tmp_consolidado` (
  `id_tniv` bigint(20) NOT NULL,
  `id_alu` bigint(20) NOT NULL,
  `cod_mat` bigint(20) NOT NULL,
  `cod_cur` bigint(20) NOT NULL,
  `id_peri` bigint(20) NOT NULL,
  `id_ano` bigint(20) NOT NULL,
  `nota` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id_tniv`,`id_alu`,`cod_mat`,`cod_cur`,`id_peri`,`id_ano`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tmp_consolidado`
--


--
-- Table structure for table `tmp_pago_factura`
--

CREATE TABLE `tmp_pago_factura` (
  `serial` varchar(20) COLLATE utf8_spanish_ci NOT NULL,
  `fecha_pago` timestamp NULL DEFAULT NULL,
  `valor_pago` decimal(20,0) NOT NULL,
  `id_usu` bigint(20) NOT NULL,
  `id_cue` bigint(10) DEFAULT NULL,
  PRIMARY KEY (`serial`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `tmp_pago_factura`
--


--
-- Table structure for table `ususis`
--

CREATE TABLE `ususis` (
  `id_usu` bigint(6) NOT NULL AUTO_INCREMENT,
  `nom_usu` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `pas_usu` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `tip_usu` int(3) NOT NULL DEFAULT '0',
  `id_per` varchar(20) COLLATE utf8_spanish_ci NOT NULL,
  `id_tfun` tinyint(3) unsigned DEFAULT '1',
  `est_usu` char(1) COLLATE utf8_spanish_ci DEFAULT 'a',
  PRIMARY KEY (`nom_usu`),
  KEY `id_usu` (`id_usu`)
) ENGINE=MyISAM AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `ususis`
--

INSERT INTO `ususis` VALUES (94,'gerardo.imbachi','dfdd5c0ee9761f51336354cd8b9b758a',3,'5',1,'a'),(93,'martha.rebolledo','ad7fbddffef485b9df031f99ce8b252a',3,'49',1,'a'),(92,'rosario.gomez','de1b71ff1e464dc5c0c8e12309a9956c',3,'48',1,'a'),(91,'diana.alvear','03a9bd6c5906c735f66d30aad33dc3c7',3,'47',1,'a'),(90,'gloria.bolanos','ba00819f263287af1ff0100c5a323355',3,'46',1,'a'),(89,'vilma.ordonez','63149e2c46a1aec5eb90dadf204a372c',3,'45',1,'a'),(88,'ana.munoz','a2393886758438b1d2f749da74c060f6',3,'44',1,'a'),(87,'monica.bravo','49528f41b4138b8f7de4353613792e6c',3,'43',1,'a'),(86,'edelmira.munoz','ec616c547691d305fa972a935a4ed0e7',3,'42',1,'a'),(85,'adriana.ramirez','0825db07e82743082d105d8f84bb32ee',3,'41',1,'a'),(84,'martha.gaviria','e2b5d2ded42a938a3a6cdb6a67b89793',3,'40',1,'a'),(83,'eliana.gomez','1fd00535b862f12bc067408803e5d70b',3,'4',1,'a'),(82,'pablo.munoz','401ac69fb657c419e5081caee6539dad',3,'39',1,'a'),(81,'maria.munoz','474cfaac183d47f8a37979e2e2ef56b4',3,'38',1,'a'),(80,'orlando.realpe','193b8e4c3e0cb2f2bd9e6343a22cd92c',3,'37',1,'a'),(79,'oscar.ortega','cc35dbbdbd7e273d83045b89d1b93959',3,'36',1,'a'),(78,'alvaro.garces','f26c2f431a8f57ae8013881556f8e279',3,'35',1,'a'),(77,'hugo.realpe','b53caf1694d1f7e1c9c9671644876796',3,'34',1,'a'),(76,'jairo.ceron','971996ec113a755f790598a36561fd0d',3,'33',1,'a'),(75,'mario.amador','9973009401a05f0f6087f42aedbd4c9e',3,'32',1,'a'),(74,'marino.guerrero','9b748e8eb0c906cf364037e3b149d774',3,'31',1,'a'),(73,'jairo.narvaez','cba4301ce3bac67a06e949b7e30bf542',3,'30',1,'a'),(72,'nury.munoz','dcccfeb0adc3744704bce894dba04399',3,'3',1,'a'),(71,'segundo.guerrero','00429b7cd8bf64469abed6d517cad945',3,'29',1,'a'),(70,'jorge.viveros','4af09080574089cbece43db636e2025f',3,'28',1,'a'),(69,'gloria.mora','8746d3d552962a804fe70ca790fafd6b',3,'27',1,'a'),(68,'gabby.ortega','494b34b72172ffa5322c8df8dd863f96',3,'26',1,'a'),(67,'eduard.garcia','b799d695d4dfd36077009d311e6ee9b2',3,'25',1,'a'),(66,'raymon.narvaez','a9dbda28396d0f6f6d0b07652605fc03',3,'24',1,'a'),(65,'lucy.urbano','a3aeea7ae0aafb10900e92ea9aff2885',3,'23',1,'a'),(64,'natali.botina','79b5e898684bde20f38abe8cc7652e1c',3,'22',1,'a'),(63,'ana.realpe','ae6b546897d9e87b16ee91252578a1c7',3,'21',1,'a'),(62,'alvaro.alvear','6583ce5279b489993edf76f6efa8fc4b',3,'20',1,'a'),(61,'dora.bravo','b5f9e90d9c993835dfe7af33c1bee67c',3,'19',1,'a'),(60,'hubeimar.ordonez','104ead17b175550b263c39101ac17698',3,'18',1,'a'),(59,'vivian.buesaquillo','a973fa85ae29bb7d2dc7bcd716a79ff6',3,'17',1,'a'),(58,'jose.munoz','257c8d46458ff78efddf3138b3155542',3,'16',1,'a'),(57,'milena.palacios','14e5a021920fb4bf5673e66f107c07c5',3,'15',1,'a'),(56,'luz.munoz','1c04a8bd96477a7e975a3acd594e2d0a',3,'14',1,'a'),(55,'oscar.ortiz','005937a69961d4f06b1f5ab4468c74ec',3,'13',1,'a'),(54,'trinidad.ordonez','8cc72af9e8b4e0dd72de2275782ddbbd',3,'12',1,'a'),(53,'oscar.ahumada','15692c3298b1d8e78f0130b979cc7c52',3,'11',1,'a'),(52,'alvaro.munoz','82d2e5ad0bf04cf81961fcf3504a9cdb',3,'10',1,'a'),(95,'blanca.ortega','2de64f504b6a742db8d0bc541ccf1a70',3,'50',1,'a'),(96,'jesus.munoz','1d4ad62b203ee257f92131156625870f',3,'51',1,'a'),(97,'leyder.diaz','8067ff73a549833ba12b08c70a35a36f',3,'52',1,'a'),(98,'graciela.zambrano','882c6312b1c2e3f0a209039dd8b0c5bc',3,'53',1,'a'),(99,'pedro.munoz','49ce582971f2dbc25255569812c76452',3,'54',1,'a'),(100,'maria.realpe','eb61b4b4895505fa4260300a4a1fc155',3,'55',1,'a'),(101,'lucia.delgado','d4fcd995f72fe1f1a6cc6433879cc879',3,'56',1,'a'),(102,'mercedes.munoz','0e9600d32326b67f3a86bbb7a959cbdb',3,'57',1,'a'),(103,'alvaro.molina','b16089782f3f173a14966514ff34669f',3,'58',1,'a'),(104,'ibo.bolanos','5ecd05e7bc5887643f4ac6abcf275c9f',3,'59',1,'a'),(105,'soledad.realpe','f37a98695f8531c71d3437d9059f88f8',3,'6',1,'a'),(106,'liliana.munoz','554de385db819dc297de3ca0180083db',3,'60',1,'a'),(107,'amanda.munoz','f6a95416d2f55762af1b5597eeccb900',3,'61',1,'a'),(108,'gloria.munoz','95a58616eecb5dd50ebcaa08e0a1db93',3,'62',1,'a'),(109,'alberto.arcos','832b6ce95c40db2fae22ade715df34d5',3,'63',1,'a'),(110,'maria.rangel','a33ed47f26e9544e8422d8d0d810fecc',3,'64',1,'a'),(111,'rosalba.palacios','98bb3d0e44a04cb7eae5e5b331bb3279',3,'65',1,'a'),(112,'yenny.lopez','5b59e2a380c3d2d7e9dca23e66a5fa0a',3,'66',1,'a'),(113,'hernan.erazo','5ba06e004ce205f8abf165197f427f8e',3,'67',1,'a'),(114,'luis.ordonez','584eddda5632fec7422f1fcf82f7f753',3,'68',1,'a'),(115,'liliana.dorado','ba6bb7de53be11a91a4539e184ebc885',3,'69',1,'a'),(116,'dolores.ordonez','ab2be112207a58f0c8f8f6701fbe60cb',3,'7',1,'a'),(117,'nilsa.molina','a26588d6f10297f33797896e476d44c8',3,'70',1,'a'),(118,'hernando.bravo','89bbcd0d2010e8826ddf589ab263860b',3,'71',1,'a'),(119,'franco.franco','f317a850c042fc5934d699cb674ab1de',3,'72',1,'a'),(120,'trinidad.arcos','3558616ad2a52876bb92d281e077c402',7,'73',3,'a'),(121,'ferneyda.betancourth','7e30900d5c6d7d08dc1520e68571adb0',7,'74',3,'a'),(122,'maria.carlosama','05ad1ffa13e98917a29f402e518f5872',7,'75',3,'a'),(123,'edgar.davila','3e45547f7fd4462318993753a622a379',3,'76',1,'a'),(124,'cesar.gaviria','b98d2d96098394903c3e95c7d1e8d789',7,'77',1,'a'),(125,'delmy.ledezma','4b745bf16e106b2cd63e4af388a68c4e',7,'78',3,'a'),(126,'nelly.nelly','bc468e71fc1998435e4f73743fe8829b',3,'79',1,'a'),(127,'walter.munoz','662b009e7c50a17a70128dd07c42aa5c',3,'8',1,'a'),(128,'jairo.munoz','6ede27cbdcc86bc9131de662f8a655b0',3,'80',1,'a'),(129,'hernando.munoz','06bcdd5141bfff06839a6e232f3e9dce',7,'81',3,'a'),(130,'maria.narvaez','efbacfb70981a0538b47cd9ad25d3f8d',7,'82',3,'a'),(131,'lucia.realpe','d08934edf1d7e2191f5a1da4a36be48c',7,'83',3,'a'),(132,'alvaro.realpe','9db25c1fd63377196728b71640b04390',7,'84',3,'a'),(133,'daniel.realpe','762058ceff5a644d73f7bbda01064103',7,'85',3,'a'),(134,'oscar.zambrano','079601d37d2a2bbf00b2b27190fdd7fa',7,'86',3,'a'),(135,'jairo.ordonez','10f10ba017d6c411086d4ffffa12dc45',3,'87',1,'a'),(136,'cesar.rebolledo','62547c64059e0096a6e6bcf2bedf6ee7',3,'9',1,'a'),(1,'siti','d34e0915f25bd342ab4a177c64e7a34d',1,'',1,'a');

--
-- Table structure for table `ususismen`
--

CREATE TABLE `ususismen` (
  `id_usu` bigint(20) NOT NULL,
  `id_men` bigint(20) NOT NULL,
  PRIMARY KEY (`id_usu`,`id_men`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `ususismen`
--


--
-- Table structure for table `valor`
--

CREATE TABLE `valor` (
  `id_doc` int(10) unsigned NOT NULL,
  `id_cor` int(10) unsigned NOT NULL,
  `id_ano` int(10) unsigned NOT NULL DEFAULT '1',
  `valor` decimal(10,0) NOT NULL,
  PRIMARY KEY (`id_doc`,`id_cor`,`id_ano`),
  KEY `valor_FKIndex2` (`id_doc`,`id_ano`),
  KEY `valor_FKIndex3` (`id_cor`),
  KEY `valor_FKIndex4` (`id_cor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `valor`
--


--
-- Table structure for table `valor_fac_pre`
--

CREATE TABLE `valor_fac_pre` (
  `hasta` date NOT NULL,
  `id_ano` int(10) unsigned NOT NULL DEFAULT '1',
  `id_doc` int(10) unsigned NOT NULL,
  `interes` decimal(10,0) NOT NULL,
  `valor` decimal(10,0) NOT NULL,
  PRIMARY KEY (`hasta`,`id_ano`,`id_doc`),
  KEY `valor_fac_pre_FKIndex1` (`id_doc`,`id_ano`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `valor_fac_pre`
--


--
-- Table structure for table `valoracion`
--

CREATE TABLE `valoracion` (
  `id_alu` bigint(20) NOT NULL,
  `cod_cur` int(6) NOT NULL DEFAULT '0',
  `cod_mat` bigint(3) NOT NULL DEFAULT '0',
  `id_val` int(3) NOT NULL DEFAULT '0',
  `id_ano` int(10) unsigned NOT NULL DEFAULT '1',
  `per_val` int(3) NOT NULL DEFAULT '1',
  `tip_tab` enum('are','mat') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'mat',
  PRIMARY KEY (`id_alu`,`cod_cur`,`cod_mat`,`id_ano`,`per_val`,`tip_tab`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `valoracion`
--


--
-- Table structure for table `valordane`
--

CREATE TABLE `valordane` (
  `id_dat` bigint(9) unsigned zerofill NOT NULL DEFAULT '000000001',
  `id_dane` bigint(6) unsigned zerofill NOT NULL DEFAULT '000001',
  `dat_pres_sel` varchar(150) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id_dane`,`id_dat`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `valordane`
--


--
-- Table structure for table `valorsqltxt`
--

CREATE TABLE `valorsqltxt` (
  `id_dat` bigint(9) unsigned NOT NULL DEFAULT '1',
  `val_dat` text COLLATE utf8_spanish_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `valorsqltxt`
--


--
-- Table structure for table `var_adi_pla`
--

CREATE TABLE `var_adi_pla` (
  `cod_var` int(10) NOT NULL AUTO_INCREMENT,
  `tit_var` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `det_var` varchar(250) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nom_var` varchar(250) COLLATE utf8_spanish_ci NOT NULL,
  `id_pla` int(10) NOT NULL,
  PRIMARY KEY (`cod_var`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `var_adi_pla`
--

INSERT INTO `var_adi_pla` VALUES (1,'Tit1','Det1','Nom1',0),(2,'Tit2','Det2','Nom2',0),(3,'Tit3','Det3','NOm3',0),(4,'Tit4','det','nom4',14),(5,'Tit5','Det5','NOm5',14),(8,'Etiqueta8','DetEtiqueta8','NomEti8',16),(7,'Etiqueta 7','Detalle7','nombre7',16),(9,'Fecha Inicio Clases','Fecha de Inicio de clases ','f_ini_cl',17),(10,'Etiqueta9','DetEtiqueta9','Etiquet9',16),(11,'Texto reporte inasistencia','Reporte Inasistencia','inasis',18),(12,'Citacion','Citación a padres','citacion',19),(13,'Prioridad','Prioridad de Atencion','priori',19),(14,'dirigido a','destino','DIRIGI',20),(15,'Dirigido a:','destinatario','Dirigido',21);

--
-- Table structure for table `web_actividades`
--

CREATE TABLE `web_actividades` (
  `id_act` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_tact` int(11) DEFAULT NULL,
  `id_alu` bigint(20) NOT NULL,
  `id_res` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  `cod_mat` bigint(20) DEFAULT NULL,
  `id_peri` int(11) DEFAULT NULL,
  `fec_act` date DEFAULT NULL,
  `hor_act` time DEFAULT NULL,
  `des_act` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `arc_act` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `fec_ing` date DEFAULT NULL,
  `hra_ing` time DEFAULT NULL,
  `est_ing` enum('i','a','r') COLLATE utf8_spanish_ci DEFAULT NULL,
  `url_arc` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id_act`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_actividades`
--


--
-- Table structure for table `web_alumnoestadomat`
--

CREATE TABLE `web_alumnoestadomat` (
  `id_alu` bigint(20) NOT NULL,
  `id_ano` int(10) unsigned NOT NULL DEFAULT '1',
  `id_estm` tinyint(3) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=FIXED;

--
-- Dumping data for table `web_alumnoestadomat`
--


--
-- Table structure for table `web_alumreg`
--

CREATE TABLE `web_alumreg` (
  `id_usu` bigint(20) unsigned NOT NULL,
  `id_alu` bigint(20) NOT NULL,
  PRIMARY KEY (`id_alu`,`id_usu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=FIXED;

--
-- Dumping data for table `web_alumreg`
--


--
-- Table structure for table `web_estadomatricula`
--

CREATE TABLE `web_estadomatricula` (
  `id_estm` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `des_estm` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id_estm`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_estadomatricula`
--


--
-- Table structure for table `web_menus`
--

CREATE TABLE `web_menus` (
  `id_men` int(3) NOT NULL AUTO_INCREMENT,
  `tit_men` varchar(250) COLLATE utf8_spanish_ci DEFAULT NULL,
  `url_men` varchar(250) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ven_men` varchar(20) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_men`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_menus`
--

INSERT INTO `web_menus` VALUES (1,'Estado Académico de Estudiante',NULL,''),(2,'Estado de Convivencia',NULL,''),(3,'Estado Financiero del estudiante',NULL,''),(4,'Matricula',NULL,''),(5,'Opciones Generales','n',''),(6,'Actividades',NULL,''),(7,'Mensajes',NULL,''),(8,'Evaluacion Docente',NULL,''),(9,'Elecciones Estudiantiles',NULL,'');

--
-- Table structure for table `web_msg`
--

CREATE TABLE `web_msg` (
  `id_msg` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `id_rem` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `asu_msg` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `txt_msg` text COLLATE utf8_spanish_ci,
  `fec_msg` date DEFAULT NULL,
  `hor_msg` time DEFAULT NULL,
  `ip_msg` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,
  `est_msg` enum('i','l','e') COLLATE utf8_spanish_ci DEFAULT NULL,
  `pri_msg` enum('a','m','n') COLLATE utf8_spanish_ci DEFAULT NULL,
  `tipe_msg` enum('u','m') COLLATE utf8_spanish_ci DEFAULT NULL,
  `res_msg` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id_msg`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_msg`
--

INSERT INTO `web_msg` VALUES (1,'98122314286','Convivencia','Por el medio de este escrito solicito...\r\nTanto los estudiantes ofrecemos el devido respeto a los adminitrativos, tambien debe haber un respeto de los administrativos a los estudiantes ...\r\nYa que por ser coordinadores no quiere decir que nos griten o nos traten de vos si aun no nos conocemos muy bien..\r\n\r\n','2014-03-25','17:05:59','190.66.6.227','i','n','u',''),(2,'98122314286','Convivencia','Por el medio de este escrito solicito...\r\nTanto los estudiantes ofrecemos el devido respeto a los adminitrativos, tambien debe haber un respeto de los administrativos a los estudiantes ...\r\nYa que por ser coordinadores no quiere decir que nos griten o nos traten de vos si aun no nos conocemos muy bien..\r\n\r\n','2014-03-25','17:05:59','190.66.6.227','i','n','u',''),(3,'234','indicadores  que no se requiere','Favor indicar como elimino columna de indicadores que no se require, motivados porque   al tener la capacitacion y  ensayar el programa se metio indicadores solo de ensayo que nada tiene que ver con la asignatura y se han quedado grabados y no se puede eliminar porque tiene notas\n Favor indicar el proceso como se debe eliminar\n\nGracias\n Luis Alberto Benavides','2014-04-03','00:12:13','190.66.6.227','i','n','m',' Padres y Acudientes de ');

--
-- Table structure for table `web_msg_des`
--

CREATE TABLE `web_msg_des` (
  `id_msg` bigint(20) unsigned NOT NULL,
  `id_des` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,
  `id_alu` bigint(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_msg_des`
--


--
-- Table structure for table `web_parametros`
--

CREATE TABLE `web_parametros` (
  `des_par` varchar(50) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `val_par` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`des_par`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_parametros`
--

INSERT INTO `web_parametros` VALUES ('fec_pag_matricula','2008-07-10'),('opcion_matricula','activa');

--
-- Table structure for table `web_privilegios`
--

CREATE TABLE `web_privilegios` (
  `id_pri` int(3) NOT NULL AUTO_INCREMENT,
  `des_pri` varchar(250) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `url_pri` varchar(250) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `ven_pri` varchar(20) COLLATE utf8_spanish_ci NOT NULL DEFAULT '',
  `id_men` bigint(5) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_pri`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_privilegios`
--

INSERT INTO `web_privilegios` VALUES (1,'Boletín Informativo','web/academico/boletin/index.php','central',1),(2,'Instancias Verificadoras','web/academico/instancias/index.php','central',1),(3,'Registro de asistencia','web/normalizacion/asistencia/index.php','central',2),(4,'Reporte Observador Estudiantil','web/normalizacion/observador/index.php','central',2),(5,'Citaciones al Padre o Acudiente','web/normalizacion/citaciones/index.php','central',2),(6,'Datos Médicos','web/normalizacion/datos_med/index.php','central',2),(7,'Generacion de Facturas','web/financiero/servicios/index.php','central',3),(8,'Estado de Cuenta','web/financiero/est_cuenta/index.php','central',3),(9,'Matricula en Linea','web/matricula/matricula/index.php','central',4),(10,'Registro Usuarios*','web/usuarios/registro/registro.php?usu=admin','central',5),(11,'Registro Estudiantes*','web/usuarios/usu_alum/index.php?usu=admin','central',5),(12,'Registro Estudiantes','web/usuarios/usu_alum/index.php','central',5),(13,'Usar Estudiante*','web/usuarios/usu_alum/sel.php?usu=admin','central',5),(14,'Calendario de Actividades','web/calendario/index.php','central',6),(15,'Registro de actividades','web/calendario/registrar/index.php','central',6),(16,'Registro de actividades*','web/calendario/registrar/index.php?usu=admin','central',6),(17,'Servicios Escolares','web/financiero/contratos/index.php','central',3),(18,'Buzon de Mensajes','web/mensajes/principal/index.php','central',7),(19,'Evaluacion Docente','eval_doc/evaluacion/index.php','central',8),(20,'Cambio Pregunta Secreta','pregunta/registro/index.php','central',5),(21,'Cambio de clave','contrasenas/cambio/index.php','central',5),(22,'Elecciones','gobierno_est/votacion/index.php','central',9),(23,'Boletin Informativo','web/academico/boletin/index.php','central',1),(24,'Actualizacion Datos Acudiente','ingreso/ingreso/acu.php?item=3','central',1),(25,'Actualizacion Datos Estudiante','ingreso/ingreso/estum.php','central',1),(26,'Seguimiento por Estudiante','reportes/seg_estu/index.php','central',1),(27,'Boletín Final','reportes/resumenboletin/index.php','central',1);

--
-- Table structure for table `web_tipactividad`
--

CREATE TABLE `web_tipactividad` (
  `id_tact` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `des_tact` varchar(255) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id_tact`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_tipactividad`
--


--
-- Table structure for table `web_tipofun`
--

CREATE TABLE `web_tipofun` (
  `id_tfun` tinyint(4) NOT NULL AUTO_INCREMENT,
  `des_tfun` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id_tfun`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_tipofun`
--

INSERT INTO `web_tipofun` VALUES (1,'ACADEMICO'),(2,'BIENESTAR'),(3,'ADMINISTRATIVO'),(4,'SERVICIOS'),(5,'NINGUNO');

--
-- Table structure for table `web_tipusu`
--

CREATE TABLE `web_tipusu` (
  `id_tusu` int(11) NOT NULL AUTO_INCREMENT,
  `des_tusu` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id_tusu`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_tipusu`
--

INSERT INTO `web_tipusu` VALUES (1,'SUPERUSUARIO'),(2,'DOCENTE'),(3,'FUNCIONARIO'),(4,'ACUDIENTE'),(5,'ESTUDIANTE');

--
-- Table structure for table `web_tipususismen`
--

CREATE TABLE `web_tipususismen` (
  `id_men` int(3) NOT NULL DEFAULT '0',
  `tip_usu` int(3) NOT NULL DEFAULT '0',
  `hab_men` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 's',
  PRIMARY KEY (`id_men`,`tip_usu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=FIXED;

--
-- Dumping data for table `web_tipususismen`
--

INSERT INTO `web_tipususismen` VALUES (1,1,'s'),(1,4,'s'),(1,5,'s'),(2,1,'s'),(2,4,'s'),(2,5,'s'),(3,1,'n'),(3,4,'n'),(3,5,'n'),(4,1,'s'),(4,4,'s'),(4,5,'s'),(5,1,'s'),(5,4,'s'),(5,5,'s'),(6,1,'s'),(6,4,'s'),(6,5,'s'),(7,1,'s'),(7,4,'s'),(7,5,'s'),(8,5,'s'),(8,1,'s'),(9,5,'s');

--
-- Table structure for table `web_tipususispri`
--

CREATE TABLE `web_tipususispri` (
  `tip_usu` int(3) NOT NULL DEFAULT '1',
  `id_pri` int(3) NOT NULL DEFAULT '1',
  `hab_pri` enum('s','n') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'n',
  PRIMARY KEY (`tip_usu`,`id_pri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=FIXED;

--
-- Dumping data for table `web_tipususispri`
--

INSERT INTO `web_tipususispri` VALUES (1,1,'s'),(1,2,'n'),(1,3,'s'),(1,4,'s'),(1,5,'s'),(1,6,'s'),(1,7,'s'),(1,8,'s'),(1,9,'s'),(1,10,'s'),(1,11,'s'),(1,12,'s'),(1,13,'s'),(1,14,'s'),(1,16,'s'),(1,17,'s'),(1,20,'s'),(1,21,'s'),(2,15,'s'),(4,1,'s'),(4,2,'n'),(4,3,'s'),(4,4,'s'),(4,5,'s'),(4,6,'s'),(4,7,'s'),(4,8,'s'),(4,9,'s'),(4,12,'s'),(4,14,'s'),(4,17,'s'),(4,18,'s'),(4,20,'s'),(4,21,'s'),(5,1,'s'),(5,2,'n'),(5,3,'s'),(5,4,'s'),(5,5,'s'),(5,6,'s'),(5,7,'s'),(5,8,'s'),(5,9,'s'),(5,14,'s'),(5,17,'s'),(5,18,'s'),(5,19,'s'),(5,20,'s'),(5,21,'s'),(1,18,'s'),(1,19,'s'),(5,22,'s'),(4,24,'s'),(4,25,'s'),(5,24,'s'),(5,25,'n'),(1,26,'s'),(4,26,'s'),(5,26,'s'),(1,27,'s'),(4,27,'s'),(5,27,'s');

--
-- Table structure for table `web_usu`
--

CREATE TABLE `web_usu` (
  `id_usu` bigint(20) NOT NULL AUTO_INCREMENT,
  `ced_per` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  `nom_per` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ape_per` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `mail_per` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `tel_per` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `tel2_per` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `usu_per` varchar(255) COLLATE utf8_spanish_ci DEFAULT NULL,
  `psw_per` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `est_per` enum('a','i','b') COLLATE utf8_spanish_ci DEFAULT 'a',
  `fec_ing` date DEFAULT NULL,
  `hra_ing` time DEFAULT NULL,
  `ip_ing` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `id_tusu` int(11) DEFAULT NULL,
  `est_usu` enum('a','i') COLLATE utf8_spanish_ci NOT NULL DEFAULT 'a',
  PRIMARY KEY (`id_usu`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci PACK_KEYS=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `web_usu`
--


--
-- Table structure for table `xls_formatos`
--

CREATE TABLE `xls_formatos` (
  `id_for` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `nom_for` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `arch_for` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  `gen_for` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `imp_for` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `pas_for` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id_for`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

--
-- Dumping data for table `xls_formatos`
--

INSERT INTO `xls_formatos` VALUES (1,'Notas por curso','ING_NOTAS.XLS','notas_xls.php','notas_ing.php','siticol');

--
-- Current Database: `8912014301`
--

USE `8912014301`;

--
-- Final view structure for view `filtro_estudiantes_acudientes`
--

/*!50001 DROP TABLE IF EXISTS `filtro_estudiantes_acudientes`*/;
/*!50001 DROP VIEW IF EXISTS `filtro_estudiantes_acudientes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`siti`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `filtro_estudiantes_acudientes` AS select distinct `a`.`id_alu` AS `id_alu`,`a`.`nom_per` AS `nom_per`,`a`.`ape_per` AS `ape_per`,`a`.`id_per` AS `id_per`,`a`.`cod_tip` AS `cod_tip`,`a`.`est_alu` AS `est_alu`,`a`.`ufo_alu` AS `ufo_alu`,`n`.`cod_niv` AS `cod_niv`,`g`.`cod_gra` AS `cod_gra`,`c`.`cod_cur` AS `cod_cur`,`c`.`des_cur` AS `des_cur`,`per`.`id_per` AS `id_acu`,`per`.`nom_per` AS `nom_acu`,`per`.`ape_per` AS `ape_acu`,`c`.`id_sed` AS `id_sed`,`s`.`nom_sed` AS `nom_sed`,`c`.`id_jor` AS `id_jor`,`j`.`des_jor` AS `des_jor` from ((((((((`alumno` `a` left join `alumcurso` `ac` on((`ac`.`id_alu` = `a`.`id_alu`))) left join `curso` `c` on((`c`.`cod_cur` = `ac`.`cod_cur`))) left join `grado` `g` on((`g`.`cod_gra` = `c`.`cod_gra`))) left join `nivel` `n` on((`n`.`cod_niv` = `g`.`cod_niv`))) left join `acudiente` `pd` on(((`pd`.`id_per` like _utf8'%') and (`pd`.`id_per` = `a`.`id_res`)))) left join `persona` `per` on(((`pd`.`id_per` = `per`.`id_per`) and (`per`.`nom_per` like _utf8'%') and (`per`.`ape_per` like _utf8'%')))) left join `jornada` `j` on((`c`.`id_jor` = `j`.`id_jor`))) left join `sede` `s` on((`c`.`id_sed` = `s`.`id_sed`))) order by `a`.`nom_per` */;

--
-- Final view structure for view `filtro_estudiantes_madres`
--

/*!50001 DROP TABLE IF EXISTS `filtro_estudiantes_madres`*/;
/*!50001 DROP VIEW IF EXISTS `filtro_estudiantes_madres`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`siti`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `filtro_estudiantes_madres` AS select distinct `a`.`id_alu` AS `id_alu`,`a`.`nom_per` AS `nom_per`,`a`.`ape_per` AS `ape_per`,`a`.`id_per` AS `id_per`,`a`.`cod_tip` AS `cod_tip`,`a`.`est_alu` AS `est_alu`,`a`.`ufo_alu` AS `ufo_alu`,`n`.`cod_niv` AS `cod_niv`,`g`.`cod_gra` AS `cod_gra`,`c`.`cod_cur` AS `cod_cur`,`c`.`des_cur` AS `des_cur`,`per`.`id_per` AS `id_acu`,`per`.`nom_per` AS `nom_acu`,`per`.`ape_per` AS `ape_acu`,`c`.`id_sed` AS `id_sed`,`s`.`nom_sed` AS `nom_sed`,`c`.`id_jor` AS `id_jor`,`j`.`des_jor` AS `des_jor` from ((((((((`alumno` `a` left join `alumcurso` `ac` on((`ac`.`id_alu` = `a`.`id_alu`))) left join `curso` `c` on((`c`.`cod_cur` = `ac`.`cod_cur`))) left join `grado` `g` on((`g`.`cod_gra` = `c`.`cod_gra`))) left join `nivel` `n` on((`n`.`cod_niv` = `g`.`cod_niv`))) left join `acudiente` `pd` on(((`pd`.`id_per` like _utf8'%') and (`pd`.`id_per` = `a`.`id2_acu`)))) left join `persona` `per` on(((`pd`.`id_per` = `per`.`id_per`) and (`per`.`nom_per` like _utf8'%') and (`per`.`ape_per` like _utf8'%')))) left join `sede` `s` on((`c`.`id_sed` = `s`.`id_sed`))) join `jornada` `j` on((`c`.`id_jor` = `j`.`id_jor`))) where ((`a`.`cod_tip` like _utf8'%') and (`a`.`id_per` like _utf8'%') and (`a`.`id_alu` like _utf8'%%') and (`a`.`nom_per` like _utf8'%') and (`a`.`ape_per` like _utf8'%%')) order by `a`.`nom_per` */;

--
-- Final view structure for view `filtro_estudiantes_padres`
--

/*!50001 DROP TABLE IF EXISTS `filtro_estudiantes_padres`*/;
/*!50001 DROP VIEW IF EXISTS `filtro_estudiantes_padres`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`siti`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `filtro_estudiantes_padres` AS select distinct `a`.`id_alu` AS `id_alu`,`a`.`nom_per` AS `nom_per`,`a`.`ape_per` AS `ape_per`,`a`.`id_per` AS `id_per`,`a`.`cod_tip` AS `cod_tip`,`a`.`est_alu` AS `est_alu`,`a`.`ufo_alu` AS `ufo_alu`,`n`.`cod_niv` AS `cod_niv`,`g`.`cod_gra` AS `cod_gra`,`c`.`cod_cur` AS `cod_cur`,`c`.`des_cur` AS `des_cur`,`per`.`id_per` AS `id_acu`,`per`.`nom_per` AS `nom_acu`,`per`.`ape_per` AS `ape_acu`,`c`.`id_sed` AS `id_sed`,`s`.`nom_sed` AS `nom_sed`,`c`.`id_jor` AS `id_jor`,`j`.`des_jor` AS `des_jor` from ((((((((`alumno` `a` left join `alumcurso` `ac` on((`ac`.`id_alu` = `a`.`id_alu`))) left join `curso` `c` on((`c`.`cod_cur` = `ac`.`cod_cur`))) left join `grado` `g` on((`g`.`cod_gra` = `c`.`cod_gra`))) left join `nivel` `n` on((`n`.`cod_niv` = `g`.`cod_niv`))) left join `acudiente` `pd` on(((`pd`.`id_per` like _utf8'%') and (`pd`.`id_per` = `a`.`id1_acu`)))) left join `persona` `per` on(((`pd`.`id_per` = `per`.`id_per`) and (`per`.`nom_per` like _utf8'%') and (`per`.`ape_per` like _utf8'%')))) left join `sede` `s` on((`c`.`id_sed` = `s`.`id_sed`))) join `jornada` `j` on((`c`.`id_jor` = `j`.`id_jor`))) where ((`a`.`cod_tip` like _utf8'%') and (`a`.`id_per` like _utf8'%') and (`a`.`id_alu` like _utf8'%%') and (`a`.`nom_per` like _utf8'%') and (`a`.`ape_per` like _utf8'%%')) order by `a`.`nom_per` */;

--
-- Final view structure for view `informacion_acudientes`
--

/*!50001 DROP TABLE IF EXISTS `informacion_acudientes`*/;
/*!50001 DROP VIEW IF EXISTS `informacion_acudientes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`siti`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `informacion_acudientes` AS select distinct `a`.`id_alu` AS `CODIGO_ALUMNO`,`ppd`.`ced_per` AS `IDENTIFICACION_ACUDIENTE`,`tdpd`.`des_tid` AS `TIPO_ID_ACUDIENTE`,`ppd`.`nom_per` AS `NOMBRE_ACUDIENTE`,`ppd`.`ape_per` AS `APELLIDO_ACUDIENTE`,`ppd`.`nac_per` AS `FECHA_NACIMIENTO_ACUDIENTE`,`cnpd`.`nom_ciu` AS `CIUDAD_NACIMIENTO_ACUDIENTE`,if((`ppd`.`sex_per` = _utf8'm'),_utf8'MASCULINO',_utf8'FEMENINO') AS `SEXO_ACUDIENTE`,`ppd`.`dir_per` AS `DIRECCION_RESIDENCIA_ACUDIENTE`,`ppd`.`tel_per` AS `TELEFONO_RESIDENCIA_ACUDIENTE`,`ppd`.`tel2_per` AS `TELEFONO_RESIDENCIA_ACUDIENTE_`,`ppd`.`mai_per` AS `CORREO_ELECTRONICO_ACUDIENTE`,`crpd`.`nom_ciu` AS `CIUDAD_RESIDENCIA_ACUDIENTE`,(case `ppd`.`est_per` when _utf8's' then _utf8'SOLTERO' when _utf8'c' then _utf8'CASADO' when _utf8'd' then _utf8'DIVORCIADO' when _utf8'u' then _utf8'UNION LIBRE' when _utf8'r' then _utf8'RELIGIOSO' when _utf8'o' then _utf8'OTRO' end) AS `ESTADO_CIVIL_ACUDIENTE`,`propd`.`des_pro` AS `PROFESION_ACUDIENTE`,`pd`.`dir_tra` AS `DIRECCION_TRABAJO_ACUDIENTE`,`pd`.`tel_tra` AS `TELEFONO_TRABAJO_ACUDIENTE`,`pd`.`tel2_tra` AS `TELEFONO_TRABAJO_ACUDIENTE_`,`ctpd`.`nom_ciu` AS `CIUDAD_TRABAJO_ACUDIENTE`,if((`pd`.`viene` = _utf8's'),_utf8'SI',_utf8'NO') AS `ASISTENCIA_ACUDIENTE`,(case `pd`.`edu_acu` when _utf8'n' then _utf8'NINGUNO' when _utf8'p' then _utf8'PRIMARIA' when _utf8'b' then _utf8'SECUNDARIA' when _utf8't' then _utf8'TECNICO' when _utf8'tl' then _utf8'TECNOLOGICO' when _utf8'u' then _utf8'UNIVERSITARIO' when _utf8'm' then _utf8'MASTERADO' when _utf8'o' then _utf8'OTRO' end) AS `NIVEL_ESTUDIOS_ACUDIENTE`,if((`pd`.`exa_per` = _utf8's'),_utf8'SI',_utf8'NO') AS `ES_EXALUMNO_ACUDIENTE` from (((((((`alumno` `a` left join `acudiente` `pd` on((`pd`.`id_per` = `a`.`id_res`))) left join `profesion` `propd` on((`pd`.`id_pro` = `propd`.`id_pro`))) left join `ciudad` `ctpd` on((`ctpd`.`cod_ciu` = `pd`.`cod_ciu`))) left join `persona` `ppd` on((`pd`.`id_per` = `ppd`.`id_per`))) left join `tipodocum` `tdpd` on((`ppd`.`cod_tid` = `tdpd`.`cod_tid`))) left join `ciudad` `cnpd` on((`cnpd`.`cod_ciu` = `ppd`.`cna_per`))) left join `ciudad` `crpd` on((`crpd`.`cod_ciu` = `ppd`.`cre_per`))) where (`a`.`est_alu` like _utf8'h') order by `a`.`ape_per`,`a`.`nom_per` */;

--
-- Final view structure for view `informacion_estudiantes`
--

/*!50001 DROP TABLE IF EXISTS `informacion_estudiantes`*/;
/*!50001 DROP VIEW IF EXISTS `informacion_estudiantes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`siti`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `informacion_estudiantes` AS select distinct `a`.`id_alu` AS `CODIGO`,`a`.`nom_per` AS `NOMBRE`,`a`.`ape_per` AS `APELLIDO`,`td`.`des_tid` AS `DOCUMENTO_DE_IDENTIDAD`,`a`.`id_per` AS `NUMERO_DE_DOCUMENTO_DE_IDENTIDAD`,if((`a`.`sex_per` = _utf8'm'),_utf8'MASCULINO',_utf8'FEMENINO') AS `GENERO`,`a`.`nac_per` AS `FECHA_DE_NACIMIENTO`,`ciu`.`nom_ciu` AS `CIUDAD_DE_NACIMIENTO`,`iaa`.`rh_alu` AS `R_H`,`salud`.`des_eps` AS `E_P_S`,`iaa`.`dir_cor` AS `DIRECCION_CORRESPONDENCIA`,`br`.`des_bar` AS `BARRIO_CORRESPONDENCIA`,`iaa`.`tel_con` AS `TELEFONO_1`,`iaa`.`tel2_con` AS `TELEFONO_2`,`iaa`.`mail_alu` AS `E_MAIL`,`iaa`.`sisben` AS `SISBEN`,`n`.`des_niv` AS `NIVEL_ESTUDIANTE`,`g`.`cod_gra` AS `cod_gra`,`g`.`des_gra` AS `GRADO_ESTUDIANTE`,`c`.`des_cur` AS `CURSO_ESTUDIANTE`,`c`.`des_cur_cor` AS `SECCION_ESTUDIANTE`,concat(`acocur`.`nom_per`,_utf8' ',`acocur`.`ape_per`) AS `ACOMPANANTE_CURSO`,`a`.`new_est` AS `ES_NUEVO`,`c`.`cod_cur` AS `cod_cur`,`n`.`cod_niv` AS `cod_niv`,`iaa`.`cod_bar` AS `BARRIO`,`ag`.`apro_alu` AS `APROBACION`,`ag`.`id_pas` AS `id_pas`,`ag`.`acepto` AS `ACEPTO`,`ag`.`obs_apro` AS `OBSERVACIONES_APRO`,`ag`.`rep_gra` AS `NUM_REPETICION`,`a`.`est_alu` AS `ESTADO` from (((((((((((`alumno` `a` left join `info_adi_alu` `iaa` on((`iaa`.`id_alu` = `a`.`id_alu`))) left join `eps` `salud` on((`salud`.`id_eps` = `iaa`.`id_eps`))) left join `barrio` `br` on((`br`.`cod_bar` = `iaa`.`cod_bar`))) left join `tipodocum` `td` on((`a`.`cod_tip` = `td`.`cod_tid`))) left join `ciudad` `ciu` on((`a`.`cna_per` = `ciu`.`cod_ciu`))) left join `alumcurso` `ac` on((`ac`.`id_alu` = `a`.`id_alu`))) left join `curso` `c` on((`c`.`cod_cur` = `ac`.`cod_cur`))) left join `persona` `acocur` on((`acocur`.`id_per` = `c`.`id_per`))) left join `alum_grado` `ag` on((`ag`.`id_alu` = `a`.`id_alu`))) left join `grado` `g` on((`g`.`cod_gra` = `c`.`cod_gra`))) left join `nivel` `n` on((`n`.`cod_niv` = `g`.`cod_niv`))) where 1 order by `a`.`ape_per`,`a`.`nom_per` */;

--
-- Final view structure for view `informacion_madres`
--

/*!50001 DROP TABLE IF EXISTS `informacion_madres`*/;
/*!50001 DROP VIEW IF EXISTS `informacion_madres`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`siti`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `informacion_madres` AS select distinct `a`.`id_alu` AS `CODIGO_ALUMNO`,`ppd`.`ced_per` AS `IDENTIFICACION_MADRE`,`tdpd`.`des_tid` AS `TIPO_ID_MADRE`,`ppd`.`nom_per` AS `NOMBRE_MADRE`,`ppd`.`ape_per` AS `APELLIDO_MADRE`,`ppd`.`nac_per` AS `FECHA_NACIMIENTO_MADRE`,`cnpd`.`nom_ciu` AS `CIUDAD_NACIMIENTO_MADRE`,if((`ppd`.`sex_per` = _utf8'm'),_utf8'MASCULINO',_utf8'FEMENINO') AS `SEXO_MADRE`,`ppd`.`dir_per` AS `DIRECCION_RESIDENCIA_MADRE`,`ppd`.`tel_per` AS `TELEFONO_RESIDENCIA_MADRE`,`ppd`.`tel2_per` AS `TELEFONO_RESIDENCIA_MADRE_`,`ppd`.`mai_per` AS `CORREO_ELECTRONICO_MADRE`,`crpd`.`nom_ciu` AS `CIUDAD_RESIDENCIA_MADRE`,(case `ppd`.`est_per` when _utf8's' then _utf8'SOLTERO' when _utf8'c' then _utf8'CASADO' when _utf8'd' then _utf8'DIVORCIADO' when _utf8'u' then _utf8'UNION LIBRE' when _utf8'r' then _utf8'RELIGIOSO' when _utf8'o' then _utf8'OTRO' end) AS `ESTADO_CIVIL_MADRE`,`propd`.`des_pro` AS `PROFESION_MADRE`,`pd`.`dir_tra` AS `DIRECCION_TRABAJO_MADRE`,`pd`.`tel_tra` AS `TELEFONO_TRABAJO_MADRE`,`pd`.`tel2_tra` AS `TELEFONO_TRABAJO_MADRE_`,`ctpd`.`nom_ciu` AS `CIUDAD_TRABAJO_MADRE`,if((`pd`.`viene` = _utf8's'),_utf8'SI',_utf8'NO') AS `ASISTENCIA_MADRE`,(case `pd`.`edu_acu` when _utf8'n' then _utf8'NINGUNO' when _utf8'p' then _utf8'PRIMARIA' when _utf8'b' then _utf8'SECUNDARIA' when _utf8't' then _utf8'TECNICO' when _utf8'tl' then _utf8'TECNOLOGICO' when _utf8'u' then _utf8'UNIVERSITARIO' when _utf8'm' then _utf8'MASTERADO' when _utf8'o' then _utf8'OTRO' end) AS `NIVEL_ESTUDIOS_MADRE`,if((`pd`.`exa_per` = _utf8's'),_utf8'SI',_utf8'NO') AS `ES_EXALUMNO_MADRE` from (((((((`alumno` `a` left join `acudiente` `pd` on((`pd`.`id_per` = `a`.`id2_acu`))) left join `profesion` `propd` on((`pd`.`id_pro` = `propd`.`id_pro`))) left join `ciudad` `ctpd` on((`ctpd`.`cod_ciu` = `pd`.`cod_ciu`))) left join `persona` `ppd` on((`pd`.`id_per` = `ppd`.`id_per`))) left join `tipodocum` `tdpd` on((`ppd`.`cod_tid` = `tdpd`.`cod_tid`))) left join `ciudad` `cnpd` on((`cnpd`.`cod_ciu` = `ppd`.`cna_per`))) left join `ciudad` `crpd` on((`crpd`.`cod_ciu` = `ppd`.`cre_per`))) where (`a`.`est_alu` like _utf8'h') order by `a`.`ape_per`,`a`.`nom_per` */;

--
-- Final view structure for view `informacion_padres`
--

/*!50001 DROP TABLE IF EXISTS `informacion_padres`*/;
/*!50001 DROP VIEW IF EXISTS `informacion_padres`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`siti`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `informacion_padres` AS select distinct `a`.`id_alu` AS `CODIGO_ALUMNO`,`ppd`.`ced_per` AS `IDENTIFICACION_PADRE`,`tdpd`.`des_tid` AS `TIPO_ID_PADRE`,`ppd`.`nom_per` AS `NOMBRE_PADRE`,`ppd`.`ape_per` AS `APELLIDO_PADRE`,`ppd`.`nac_per` AS `FECHA_NACIMIENTO_PADRE`,`cnpd`.`nom_ciu` AS `CIUDAD_NACIMIENTO_PADRE`,if((`ppd`.`sex_per` = _utf8'm'),_utf8'MASCULINO',_utf8'FEMENINO') AS `SEXO_PADRE`,`ppd`.`dir_per` AS `DIRECCION_RESIDENCIA_PADRE`,`ppd`.`tel_per` AS `TELEFONO_RESIDENCIA_PADRE`,`ppd`.`tel2_per` AS `TELEFONO_RESIDENCIA_PADRE_`,`ppd`.`mai_per` AS `CORREO_ELECTRONICO_PADRE`,`crpd`.`nom_ciu` AS `CIUDAD_RESIDENCIA_PADRE`,(case `ppd`.`est_per` when _utf8's' then _utf8'SOLTERO' when _utf8'c' then _utf8'CASADO' when _utf8'd' then _utf8'DIVORCIADO' when _utf8'u' then _utf8'UNION LIBRE' when _utf8'r' then _utf8'RELIGIOSO' when _utf8'o' then _utf8'OTRO' end) AS `ESTADO_CIVIL_PADRE`,`propd`.`des_pro` AS `PROFESION_PADRE`,`pd`.`dir_tra` AS `DIRECCION_TRABAJO_PADRE`,`pd`.`tel_tra` AS `TELEFONO_TRABAJO_PADRE`,`pd`.`tel2_tra` AS `TELEFONO_TRABAJO_PADRE_`,`ctpd`.`nom_ciu` AS `CIUDAD_TRABAJO_PADRE`,if((`pd`.`viene` = _utf8's'),_utf8'SI',_utf8'NO') AS `ASISTENCIA_PADRE`,(case `pd`.`edu_acu` when _utf8'n' then _utf8'NINGUNO' when _utf8'p' then _utf8'PRIMARIA' when _utf8'b' then _utf8'SECUNDARIA' when _utf8't' then _utf8'TECNICO' when _utf8'tl' then _utf8'TECNOLOGICO' when _utf8'u' then _utf8'UNIVERSITARIO' when _utf8'm' then _utf8'MASTERADO' when _utf8'o' then _utf8'OTRO' end) AS `NIVEL_ESTUDIOS_PADRE`,if((`pd`.`exa_per` = _utf8's'),_utf8'SI',_utf8'NO') AS `ES_EXALUMNO_PADRE` from (((((((`alumno` `a` left join `acudiente` `pd` on((`pd`.`id_per` = `a`.`id1_acu`))) left join `profesion` `propd` on((`pd`.`id_pro` = `propd`.`id_pro`))) left join `ciudad` `ctpd` on((`ctpd`.`cod_ciu` = `pd`.`cod_ciu`))) left join `persona` `ppd` on((`pd`.`id_per` = `ppd`.`id_per`))) left join `tipodocum` `tdpd` on((`ppd`.`cod_tid` = `tdpd`.`cod_tid`))) left join `ciudad` `cnpd` on((`cnpd`.`cod_ciu` = `ppd`.`cna_per`))) left join `ciudad` `crpd` on((`crpd`.`cod_ciu` = `ppd`.`cre_per`))) where (`a`.`est_alu` like _utf8'h') order by `a`.`ape_per`,`a`.`nom_per` */;


