/*
 Navicat Premium Data Transfer

 Source Server         : Local
 Source Server Type    : MySQL
 Source Server Version : 50724
 Source Host           : localhost:3306
 Source Schema         : sice

 Target Server Type    : MySQL
 Target Server Version : 50724
 File Encoding         : 65001

 Date: 13/10/2020 00:22:28
*/


-- ----------------------------
-- Table structure for alumnos
-- ----------------------------
CREATE TABLE `alumnos`  (
  `idalumno` int(11) NOT NULL AUTO_INCREMENT,
  `matricula` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `curp` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `nombre` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `apellidos` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `nacionalidad` varchar(150) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fechaNacimiento` date NULL DEFAULT NULL,
  `idgenero` int(11) NULL DEFAULT NULL,
  `idestadocivil` int(11) NULL DEFAULT NULL,
  `idniveleducativo` int(11) NULL DEFAULT NULL,
  `idcarrera` int(11) NULL DEFAULT NULL,
  `idsede` int(11) NULL DEFAULT NULL,
  `generacion` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ultimogrado` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `codigopostal` decimal(10, 0) NULL DEFAULT NULL,
  `direccion` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `colonia` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `municipio` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `estado` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ciudad` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `pais` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `telcelular` decimal(10, 0) NULL DEFAULT NULL,
  `telcasa` decimal(10, 0) NULL DEFAULT NULL,
  `email` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `discapacidad` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `idestadonacimiento` int(11) NULL DEFAULT NULL,
  `foto` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentoacta` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fileacta` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentocertificadobachillerato` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filecertificadobachillerato` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentocertificadosecundaria` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filecertificadosecundaria` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentocurp` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filecurp` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentocartacompromiso` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filedocumentocartacompromiso` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentofichainscripcion` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filefichainscripcion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fotografias` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentoine` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filedocumentoine` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentocomprobantedomicilio` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filecomprobantedomicilio` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `documentocertificadomedico` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `filecertificadomedico` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `idusuariocreacion` int(11) NULL DEFAULT NULL,
  `idusuariomodificacion` int(11) NULL DEFAULT NULL,
  `idusuarioeliminacion` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `status` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `cuatrimestre` char(2) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `colegiatura` decimal(10, 0) NULL DEFAULT NULL,
  `inscripcion` decimal(10, 0) NULL DEFAULT NULL,
  `reinscripcion` decimal(10, 0) NULL DEFAULT NULL,
  PRIMARY KEY (`idalumno`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for carreras
-- ----------------------------
CREATE TABLE `carreras`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idNivel` int(11) NULL DEFAULT NULL,
  `nombre` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `modalidad` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `duracionciclo` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `planestudios` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of carreras
-- ----------------------------
INSERT INTO `carreras` VALUES (1, 2, 'Licenciatura en Administración de Empresas', NULL, NULL, NULL, '2019-12-24 00:16:44', '2019-12-24 00:16:46');
INSERT INTO `carreras` VALUES (2, 2, 'Licenciatura en Administración Turística', NULL, NULL, NULL, '2019-12-24 00:16:44', '2019-12-24 00:16:46');
INSERT INTO `carreras` VALUES (3, 2, 'Licenciatura en Ciencias de la Comunicación', NULL, NULL, NULL, '2019-12-24 00:16:44', '2019-12-24 00:16:46');
INSERT INTO `carreras` VALUES (4, 2, 'Licenciatura en Mercadotecnia', NULL, NULL, NULL, '2020-03-11 14:54:57', '2020-03-11 14:55:02');
INSERT INTO `carreras` VALUES (5, 2, 'Licenciatura en Negocios Internacionales', NULL, NULL, NULL, '2020-03-11 14:55:35', '2020-03-11 14:55:39');
INSERT INTO `carreras` VALUES (6, 2, 'Licenciatura en Educación', NULL, NULL, NULL, '2020-03-11 15:07:25', '2020-03-11 15:07:29');
INSERT INTO `carreras` VALUES (7, 2, 'Licenciatura en Derecho', NULL, NULL, NULL, '2020-03-11 15:07:49', '2020-03-11 15:07:52');
INSERT INTO `carreras` VALUES (8, 2, 'Licenciatura en Lengua Inglesa', NULL, NULL, NULL, '2020-03-11 15:08:47', '2020-03-11 15:08:50');
INSERT INTO `carreras` VALUES (9, 2, 'Licenciatura en Contaduria', NULL, NULL, NULL, '2020-03-11 15:09:22', '2020-03-11 15:09:25');
INSERT INTO `carreras` VALUES (10, 2, 'Licenciatura en Psicología', NULL, NULL, NULL, '2020-03-11 15:10:11', '2020-03-11 15:10:14');
INSERT INTO `carreras` VALUES (11, 2, 'Licenciatura en Pedagogía', NULL, NULL, NULL, '2020-03-11 15:10:50', '2020-03-11 15:10:54');
INSERT INTO `carreras` VALUES (12, 2, 'Licenciatura en Sistemas Computacionales', NULL, NULL, NULL, '2020-03-11 15:11:19', '2020-03-11 15:11:23');
INSERT INTO `carreras` VALUES (13, 3, 'Maestría en Auditoria', NULL, NULL, NULL, '2020-03-11 15:12:22', '2020-03-11 15:12:25');
INSERT INTO `carreras` VALUES (14, 3, 'Maestría en Ciencias de la Educacion', NULL, NULL, NULL, '2020-03-11 15:12:54', '2020-03-11 15:12:57');
INSERT INTO `carreras` VALUES (15, 3, 'Maestría en Finanzas', NULL, NULL, NULL, '2020-03-11 15:13:47', '2020-03-11 15:13:50');
INSERT INTO `carreras` VALUES (16, 3, 'Maestría en Negocios Internacionales', NULL, NULL, NULL, '2020-03-11 15:16:00', '2020-03-11 15:16:03');
INSERT INTO `carreras` VALUES (17, 3, 'Maestría en Fiscal Contable', NULL, NULL, NULL, '2020-03-11 15:19:34', '2020-03-11 15:19:38');

-- ----------------------------
-- Table structure for catalogoentidades
-- ----------------------------
CREATE TABLE `catalogoentidades`  (
  `idEntidad` int(11) NOT NULL AUTO_INCREMENT,
  `entidad` varchar(250) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `entidadAbreviacion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `status` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`idEntidad`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of catalogoentidades
-- ----------------------------
INSERT INTO `catalogoentidades` VALUES (1, 'AGUASCALIENTES', 'AGS ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (2, 'BAJA CALIFORNIA', 'BC   ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (3, 'BAJA CALIFORNIA SUR', 'BCS  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (4, 'CAMPECHE', 'CAMP ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (5, 'COAHUILA DE ZARAGOZA', 'COAH ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (6, 'COLIMA', 'COL  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (7, 'CHIAPAS', 'CHIS ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (8, 'CHIHUAHUA', 'CHIH ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (9, 'CIUDAD DE MÉXICO', 'CDMX ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (10, 'DURANGO', 'DGO  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (11, 'GUANAJUATO', 'GTO  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (12, 'GUERRERO', 'GRO  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (13, 'HIDALGO', 'HGO  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (14, 'JALISCO', 'JAL  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (15, 'MÉXICO', 'MEX  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (16, 'MICHOÁCAN DE OCAMPO', 'MICH ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (17, 'MORELOS', 'MOR  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (18, 'NAYARIT', 'NAY  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (19, 'NUEVO LEÓN', 'NL   ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (20, 'OAXACA', 'OAX  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (21, 'PUEBLA', 'PUE  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (22, 'QUERÉTARO', 'QRO  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (23, 'QUINTANA ROO', 'QROO ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (24, 'SAN LUIS POTOSÍ', 'SLP  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (25, 'SINALOA', 'SIN  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (26, 'SONORA', 'SON  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (27, 'TABASCO', 'TAB  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (28, 'TAMAULIPAS', 'TAMPS', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (29, 'TLAXCALA', 'TLAX ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (30, 'VERACRUZ DE IGNACIO DE LA LLAVE', 'VER  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (31, 'YUCATÁN', 'YUC  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (32, 'ZACATECAS', 'ZAC  ', '1', NULL, NULL);
INSERT INTO `catalogoentidades` VALUES (33, 'EXTRANJERO', 'EXT', '1', NULL, NULL);

-- ----------------------------
-- Table structure for conceptos
-- ----------------------------
CREATE TABLE `conceptos`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `concepto` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of conceptos
-- ----------------------------
INSERT INTO `conceptos` VALUES (2, 'Inscripción', '2019-12-24 02:17:40', '2019-12-24 02:17:40');
INSERT INTO `conceptos` VALUES (3, 'Re-Inscripción', '2019-12-24 02:17:40', '2019-12-24 02:17:40');
INSERT INTO `conceptos` VALUES (4, 'Colegiatura', '2019-12-24 02:17:40', '2019-12-24 02:17:40');
INSERT INTO `conceptos` VALUES (5, 'Titulación', '2019-12-24 02:17:40', '2019-12-24 02:17:40');

-- ----------------------------
-- Table structure for estadocivil
-- ----------------------------
CREATE TABLE `estadocivil`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `estadoCivil` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of estadocivil
-- ----------------------------
INSERT INTO `estadocivil` VALUES (1, 'Soltero', '2020-07-07 18:38:43', '2020-07-07 18:38:50');
INSERT INTO `estadocivil` VALUES (2, 'Casado', '2020-07-07 18:39:31', '2020-07-07 18:39:35');
INSERT INTO `estadocivil` VALUES (3, 'Divorsiado', '2020-07-07 18:39:57', '2020-07-07 18:40:00');
INSERT INTO `estadocivil` VALUES (4, 'Viudo', '2020-07-07 18:40:18', '2020-07-07 18:40:22');
INSERT INTO `estadocivil` VALUES (5, 'Concubinato', '2020-07-07 18:40:40', '2020-07-07 18:40:46');

-- ----------------------------
-- Table structure for examenunico
-- ----------------------------
CREATE TABLE `examenunico`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fechaRegistro` date NULL DEFAULT NULL,
  `nivelAcademico` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `municipio` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fechaPresentacion` date NULL DEFAULT NULL,
  `aPaterno` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `aMaterno` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `nombre` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `edad` int(10) NULL DEFAULT NULL,
  `curp` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `sexo` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fechaNacimiento` date NULL DEFAULT NULL,
  `lugarNacimiento` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `escuelAnterior` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ubicacion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `entidad` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `municipioProcedencia` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `localidad` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `estudiosIncompletos` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `nombreInstitucion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `ubicacionInstitucion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `entidadInstitucion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `municipioInstitucion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `localidadInstitucion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `nacionalidad` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `estadOrigen` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `idEstadoCivil` int(11) NULL DEFAULT NULL,
  `ocupacion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `direccionGeneral` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `coloniaGeneral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `cPostal` decimal(10, 0) NULL DEFAULT NULL,
  `estadoGeneral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `municipioGeneral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `localidadGeneral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `telCasa` decimal(10, 0) NULL DEFAULT NULL,
  `telCelular` decimal(10, 0) NULL DEFAULT NULL,
  `email` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `empresa` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `actividad` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `domicilioLaboral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `estadoLaboral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `municipioLaboral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `localidadLaboral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `telefonoLaboral` varchar(13) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `emailLaboral` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `activo` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of examenunico
-- ----------------------------
INSERT INTO `examenunico` VALUES (1, '2020-07-12', 'Universidad', 'Neza', '2020-07-17', 'Albor', 'Aguilar', 'Adrian Aron', 22, 'AOAA971217HMCLGD01', '1', '1997-12-17', 'Nezahualcoyotl', 'UTN', 'Neza', 'Federativa', 'Nezahualcoyotl', 'Estado de Mexico', 'no', 'ninguna', 'ninguna', 'ninguna', 'ninguna', 'ninguna', 'Mexicana', 'México', 3, 'Trabajo', 'Fernando Montes de Oca', 'San Lorenzo', 57139, 'Mexico', 'Chimalhuacan', 'Estado de Mexico', 5543127899, 5581287917, 'albor@gmail.com', 'EvolutionClub', 'Ingeniero Programador Doctor', 'Alvaro Obregon', 'CDMX', 'Venustiano Carranza', 'Estado de Mexico', '5563241865', 'albor@evol.com', '1', '2020-07-12 03:22:18', '2020-07-21 14:49:18');
INSERT INTO `examenunico` VALUES (2, NULL, 'Universidad', 'Neza', '2020-07-12', 'Albor', 'Aguilar', 'Adrian Aron', 22, 'AOAA971217HMCLGD01', '1', '2020-07-12', 'Nezahualcoyotl', 'UTN', 'Neza', NULL, NULL, 'Estado de Mexico', 'no', 'ninguna', 'ninguna', 'ninguna', 'ninguna', 'ninguna', 'Mexicana', 'México', 1, 'Trabajo', 'Fernando Montes de Oca', NULL, NULL, NULL, 'Chimalhuacan', 'Estado de Mexico', 5543127899, 5581287917, 'albor@gmail.com', 'EvolutionClub', 'Ingeniero Programador Doctor', 'Alvaro Obregon', 'CDMX', 'Venustiano Carranza', 'Estado de Mexico', '5563241865', 'albor@evol.com', '0', '2020-07-12 03:25:29', '2020-07-12 03:25:29');
INSERT INTO `examenunico` VALUES (3, NULL, 'Bachillerato', 'ibubuo', '2020-07-12', 'Rodriguez', 'Bert', 'Alan', 22, 'bbbbouf63', '1', '2020-07-12', 'khbihvyo', 'nkbkbib', 'n kbjbi', NULL, NULL, 'jjbkuo', 'kbuvjvvkuk', 'jbkbkb', 'bjjbojb', 'kjbkvv', 'nkniouououuo', 'jjbojjbobob', 'ukvv', 'bhkvvjh', 2, 'hyig', 'iygyigiy', NULL, NULL, NULL, 'iyviyvi', 'ohoubou', 55623419, 51524767, 'rdroguez@njkbjjiinh.com', 'bivo', 'iyvhvvgu', 'uvuyfu', 'igiiyvyv', 'jouhoi', 'biiyg', '55643227', 'rdriguez@gmail.com', '0', '2020-07-12 13:37:20', '2020-07-15 15:43:04');
INSERT INTO `examenunico` VALUES (4, NULL, 'sdg', 'gregrh', '2020-07-12', 'gsg', 'sdgdfhdsgg', 'sdgsgsdg', 22, 'dsgsg', '1', '2020-07-12', 'dgdg', 'trjtykju', 'dghhfggfj', NULL, NULL, '7823', 'fegfh', 'rrehtrtjr', 'rrherh', 'rrhrh', 'rereg', 'rereh', 'dsgs', 'dsgsg', 3, 'sdgsdgs', 'dgg', NULL, NULL, NULL, 'dgdxg', 'tjnnhg', 55627839, 44528936, 'al@gmail.com', 'dsgsdgs', 'dgsg', 'sgsdg', 'dgg', 'jghj', 'yukyuk', '5543212', 'al@gmail.com', '0', '2020-07-12 15:07:02', '2020-07-21 14:13:03');
INSERT INTO `examenunico` VALUES (5, NULL, 'njjoouj', 'sgsg', '2020-07-12', 'jbbib', 'nnouou', 'oouu', 50, 'fdhdhj', '2', '2020-07-12', 'kuykmj', 'ryjyj', 'jyj', 'thtrj', NULL, 'kmk', 'fhh', 'rehrtj', 'ytjyukioñioñtrjtr', 'hrh', 'trrjtyk', 'vcmvmv', 'sjkjs', 'ggfjj', 4, 'ghh', 'tyt', 'sg', 32145, 'ytkuk', 'rfww', 'sg', 667788994, 4455638292, 's@gmail.com', 'gdfgz', 'dfhfh', 'dfhdfh', 'uyil', 'asfas', 'thj', '5543167', 's@gmail.com', '0', '2020-07-12 15:38:25', '2020-07-21 14:13:12');
INSERT INTO `examenunico` VALUES (6, NULL, 'gerhy', 'municipio procedencia', '2020-07-12', 'ryreykk', 'ghjhg', 'oiloi', 20, 'ifjshuig', '2', '2020-07-12', 'dkngjjdgj', 'nlkn', 'mkdo', 'dnds', NULL, 'josdoigh', 'oqfwpo', 'sjfsjj', 'ddsj', 'dsgosdjg', 'sjoivdjs', 'nnvdsvn', 'snlknnnlk', 'pjpijpvi', 4, 'mdmsdlg', 'ksdbkjsb', 'snnaahu', 66748, 'lksois', 'djdsdol', 'jdjg', 7788995544, 378648732, 's@gmail.com', 'vl', 'kd', 'vdmmdmv', 'psdds', 'sdgonsdjg', 'jdoid', '554667733', 's@gmail.com', '0', '2020-07-12 15:44:01', '2020-07-12 15:44:01');
INSERT INTO `examenunico` VALUES (7, '2020-07-12', 'secu', 'chapultepec', '2020-07-12', 'chapul', 'aguilar', 'daniel antonio', 40, 'jiubouou', '1', '2020-07-12', 'ljbul', 'oiuig9', 'guvuvuy', 'jiubigiy', 'hhiuiohiuiu', 'iuggiuuoguo', 'kbkhivik', 'olbobougo', 'lbobo', 'ugiygpiguhu', 'kjbouou', 'uoguoiu', 'mexicano chapulin', 'uhiubib', 3, 'nibbivi', 'hiyviy', 'bigigy', 667544, 'lyilyuvi', 'nubk', 'ouhigiy', 554667733, 7858786, 's@gmail.com', 'chapulines sa cv', 'ohouou', 'mbuhjvvuv', 'kbibiu', 'giyguyf8i', 'ohgiy', '55666777', 's@gmail.com', '0', '2020-07-12 16:10:01', '2020-07-21 14:13:19');
INSERT INTO `examenunico` VALUES (8, '2020-07-21', 'Bachillerato', 'Veracruz', '2020-07-31', 'Suarez', 'Medina', 'Alma Delia', 47, 'SUMA730202MVZRDL01', '2', '1973-02-02', 'Veracruz', 'Instituto nacional para la educacion de los alumnos', 'NO', 'NO', 'NO', 'NO', 'Ninguno', 'Ninguno', 'Ninguno', 'Ninguno', 'Ninguno', 'Ninguno', 'Mexicana', 'Veracruz', 1, 'Ama de casa', 'Amparo de la Torre 826', 'Fraccionamiento villa rica', 91810, 'Veracruz', 'Veracruz', 'Veracruz', 0, 2299000465, 'delyrusua040217@gmail.com', 'Ama de Casa', 'Ninguno', 'Ninguno', 'Ninguno', 'NO', 'NO', '0', 'NO@gmail.com', '1', '2020-07-21 12:36:37', '2020-07-21 15:08:45');
INSERT INTO `examenunico` VALUES (9, '2020-07-21', 'ioo', 'jhoh', '2020-07-21', 'oo', 'jjhivoo', 'ohui', 66, 'WDKIEDKE', '1', '2020-07-21', 'jvv', 'vv', 'tythfvh', 'gutfty', 'gytfvyt', 'vuu', 'jgg', 'gjv', 'vhgv', 'jvfgfv', 'fvgh', 'gfvgh', 'nono', 'WNQDOQN', 1, 'bkhb', 'bkbh', 'hvjvjhh', 656567, 'ghvfhg', 'guygyu', 'guyfv', 76786876, 656656, 'vh@gmai.com', 'jpOJEPW', 'njnf', 'j kb', 'kjb k', 'bjhvhj', 'hvjjv', '76786', 'a@gmail.com', '0', '2020-07-21 14:11:15', '2020-07-21 14:12:39');

-- ----------------------------
-- Table structure for failed_jobs
-- ----------------------------
CREATE TABLE `failed_jobs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for gastos
-- ----------------------------
CREATE TABLE `gastos`  (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `tipoGasto` varchar(220) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fechaGasto` date NULL DEFAULT NULL,
  `costo` float NULL DEFAULT NULL,
  `observacion` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `created_at` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  `updated_at` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of gastos
-- ----------------------------
INSERT INTO `gastos` VALUES (1, 'gastosss', '2020-03-05', 5, NULL, '2020-03-05 15:08:05', '2020-03-05 15:08:05');
INSERT INTO `gastos` VALUES (2, 'papeleria', '2020-03-05', 10, 'gastos', '2020-03-05 15:12:47', '2020-03-05 15:12:47');
INSERT INTO `gastos` VALUES (3, 'documentos', '2020-03-05', 15, 'papeles', '2020-03-05 15:14:51', '2020-03-05 15:14:51');
INSERT INTO `gastos` VALUES (4, 'documentos', '2020-03-05', 15, 'papeles', '2020-03-05 15:16:40', '2020-03-05 15:16:40');

-- ----------------------------
-- Table structure for generos
-- ----------------------------
CREATE TABLE `generos`  (
  `idgenero` int(11) NOT NULL AUTO_INCREMENT,
  `genero` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`idgenero`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of generos
-- ----------------------------
INSERT INTO `generos` VALUES (1, 'Masculino', NULL, NULL);
INSERT INTO `generos` VALUES (2, 'Femenino', NULL, NULL);

-- ----------------------------
-- Table structure for logacciones
-- ----------------------------
CREATE TABLE `logacciones`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idUsuario` int(11) NULL DEFAULT NULL,
  `accion` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 179 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of logacciones
-- ----------------------------
INSERT INTO `logacciones` VALUES (1, 1, 'Agregó al usuario Marlen Espinoza', '2019-12-21 04:13:28', '2019-12-21 04:13:28');
INSERT INTO `logacciones` VALUES (2, 1, 'Agrego al alumno: Marlen Espinoza Ortega', '2019-12-24 01:12:45', '2019-12-24 01:12:45');
INSERT INTO `logacciones` VALUES (3, 1, 'Eliminó al alumno: Marlen Espinoza Ortega', '2019-12-24 01:15:15', '2019-12-24 01:15:15');
INSERT INTO `logacciones` VALUES (4, 1, 'Actualizó la información del alumno: Carlos Alexis 1 Campos Mariscal 1', '2019-12-24 01:55:52', '2019-12-24 01:55:52');
INSERT INTO `logacciones` VALUES (5, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2019-12-24 01:56:02', '2019-12-24 01:56:02');
INSERT INTO `logacciones` VALUES (6, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2019-12-24 01:56:31', '2019-12-24 01:56:31');
INSERT INTO `logacciones` VALUES (7, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2019-12-24 01:56:41', '2019-12-24 01:56:41');
INSERT INTO `logacciones` VALUES (8, 1, 'Modificó los permisos de acceso del usuario: Carlos Alexis', '2019-12-24 02:12:29', '2019-12-24 02:12:29');
INSERT INTO `logacciones` VALUES (9, 1, 'Modificó los permisos de acceso del usuario: Carlos Alexis', '2019-12-24 02:13:06', '2019-12-24 02:13:06');
INSERT INTO `logacciones` VALUES (10, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:40:15', '2019-12-24 03:40:15');
INSERT INTO `logacciones` VALUES (11, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:41:02', '2019-12-24 03:41:02');
INSERT INTO `logacciones` VALUES (12, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:42:35', '2019-12-24 03:42:35');
INSERT INTO `logacciones` VALUES (13, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:46:04', '2019-12-24 03:46:04');
INSERT INTO `logacciones` VALUES (14, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:49:00', '2019-12-24 03:49:00');
INSERT INTO `logacciones` VALUES (15, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:50:04', '2019-12-24 03:50:04');
INSERT INTO `logacciones` VALUES (16, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:50:27', '2019-12-24 03:50:27');
INSERT INTO `logacciones` VALUES (17, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:51:21', '2019-12-24 03:51:21');
INSERT INTO `logacciones` VALUES (18, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:52:12', '2019-12-24 03:52:12');
INSERT INTO `logacciones` VALUES (19, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:58:02', '2019-12-24 03:58:02');
INSERT INTO `logacciones` VALUES (20, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 03:59:18', '2019-12-24 03:59:18');
INSERT INTO `logacciones` VALUES (21, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 04:00:19', '2019-12-24 04:00:19');
INSERT INTO `logacciones` VALUES (22, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 04:00:45', '2019-12-24 04:00:45');
INSERT INTO `logacciones` VALUES (23, 1, 'Agregó un pago al usuario: Carlos Alexis Campos Mariscal', '2019-12-24 04:03:37', '2019-12-24 04:03:37');
INSERT INTO `logacciones` VALUES (24, 1, 'Agrego al alumno: aron albor', '2020-02-17 14:55:30', '2020-02-17 14:55:30');
INSERT INTO `logacciones` VALUES (25, 1, 'Actualizó la información del alumno: aron 5581287918', '2020-02-18 15:36:06', '2020-02-18 15:36:06');
INSERT INTO `logacciones` VALUES (26, 1, 'Actualizó la información del alumno: aron 5581287917', '2020-02-18 15:39:33', '2020-02-18 15:39:33');
INSERT INTO `logacciones` VALUES (27, 1, 'Agrego al alumno: gustavo perez aguilar', '2020-02-18 15:42:46', '2020-02-18 15:42:46');
INSERT INTO `logacciones` VALUES (28, 1, 'Actualizó la información del alumno: gustavo 5566971471', '2020-02-18 15:43:40', '2020-02-18 15:43:40');
INSERT INTO `logacciones` VALUES (29, 1, 'Actualizó la información del alumno: aron 5581287917', '2020-02-18 15:51:11', '2020-02-18 15:51:11');
INSERT INTO `logacciones` VALUES (30, 1, 'Actualizó la información del alumno: aron 5581287917', '2020-02-18 15:51:16', '2020-02-18 15:51:16');
INSERT INTO `logacciones` VALUES (31, 1, 'Actualizó la información del alumno: aron 5581287917', '2020-02-18 15:51:52', '2020-02-18 15:51:52');
INSERT INTO `logacciones` VALUES (32, 1, 'Actualizó la información del alumno: aron 5581287917', '2020-02-18 16:08:22', '2020-02-18 16:08:22');
INSERT INTO `logacciones` VALUES (33, 1, 'Actualizó la información del alumno: aron 5581287917', '2020-02-18 16:10:56', '2020-02-18 16:10:56');
INSERT INTO `logacciones` VALUES (34, 1, 'Actualizó la información del alumno: aron 5581287917', '2020-02-18 16:11:47', '2020-02-18 16:11:47');
INSERT INTO `logacciones` VALUES (35, 1, 'Actualizó la información del alumno: gustavo 5566971471', '2020-02-18 16:16:10', '2020-02-18 16:16:10');
INSERT INTO `logacciones` VALUES (36, 1, 'Actualizó la información del alumno: gustavo 5566971471', '2020-02-18 16:16:43', '2020-02-18 16:16:43');
INSERT INTO `logacciones` VALUES (37, 1, 'Eliminó al alumno: gustavo 5566971471', '2020-02-18 16:25:41', '2020-02-18 16:25:41');
INSERT INTO `logacciones` VALUES (38, 1, 'Actualizó la información del alumno: aron albor aguilar', '2020-02-18 16:29:03', '2020-02-18 16:29:03');
INSERT INTO `logacciones` VALUES (39, 1, 'Actualizó la información del alumno: aron albor aguilar', '2020-02-18 16:29:26', '2020-02-18 16:29:26');
INSERT INTO `logacciones` VALUES (40, 1, 'Actualizó la información del alumno: aron albor aguilar', '2020-02-18 16:32:29', '2020-02-18 16:32:29');
INSERT INTO `logacciones` VALUES (41, 1, 'Actualizó la información del alumno: aron albor aguilar', '2020-02-18 16:38:03', '2020-02-18 16:38:03');
INSERT INTO `logacciones` VALUES (42, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 16:38:41', '2020-02-18 16:38:41');
INSERT INTO `logacciones` VALUES (43, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 16:42:50', '2020-02-18 16:42:50');
INSERT INTO `logacciones` VALUES (44, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 16:44:33', '2020-02-18 16:44:33');
INSERT INTO `logacciones` VALUES (45, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 16:45:05', '2020-02-18 16:45:05');
INSERT INTO `logacciones` VALUES (46, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 16:45:29', '2020-02-18 16:45:29');
INSERT INTO `logacciones` VALUES (47, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 17:14:26', '2020-02-18 17:14:26');
INSERT INTO `logacciones` VALUES (48, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-02-18 17:15:35', '2020-02-18 17:15:35');
INSERT INTO `logacciones` VALUES (49, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-02-18 17:16:12', '2020-02-18 17:16:12');
INSERT INTO `logacciones` VALUES (50, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 17:17:02', '2020-02-18 17:17:02');
INSERT INTO `logacciones` VALUES (51, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 17:17:52', '2020-02-18 17:17:52');
INSERT INTO `logacciones` VALUES (52, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 17:18:21', '2020-02-18 17:18:21');
INSERT INTO `logacciones` VALUES (53, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-02-18 17:20:49', '2020-02-18 17:20:49');
INSERT INTO `logacciones` VALUES (54, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-02-18 17:24:28', '2020-02-18 17:24:28');
INSERT INTO `logacciones` VALUES (55, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-02-18 17:25:56', '2020-02-18 17:25:56');
INSERT INTO `logacciones` VALUES (56, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-02-18 17:46:35', '2020-02-18 17:46:35');
INSERT INTO `logacciones` VALUES (57, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-02-18 17:48:06', '2020-02-18 17:48:06');
INSERT INTO `logacciones` VALUES (58, 1, 'Modificó los permisos de acceso del usuario: Carlos Alexis', '2020-03-03 16:40:06', '2020-03-03 16:40:06');
INSERT INTO `logacciones` VALUES (59, 1, 'Agrego al alumno: Elizabeth Jimenez', '2020-03-05 18:18:12', '2020-03-05 18:18:12');
INSERT INTO `logacciones` VALUES (60, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-03-05 18:27:30', '2020-03-05 18:27:30');
INSERT INTO `logacciones` VALUES (61, 1, 'Actualizó la información del alumno: aron albor sanchez', '2020-03-05 18:28:16', '2020-03-05 18:28:16');
INSERT INTO `logacciones` VALUES (62, 1, 'Actualizó la información del alumno: Aron albor sanchez', '2020-03-05 18:28:47', '2020-03-05 18:28:47');
INSERT INTO `logacciones` VALUES (63, 1, 'Actualizó la información del alumno: Marlen Espinoza Ortega', '2020-03-05 18:32:04', '2020-03-05 18:32:04');
INSERT INTO `logacciones` VALUES (64, 1, 'Actualizó la información del alumno: Carlos Alexis 18172003', '2020-03-06 12:50:30', '2020-03-06 12:50:30');
INSERT INTO `logacciones` VALUES (65, 1, 'Agrego al alumno: angel flores', '2020-03-06 15:33:43', '2020-03-06 15:33:43');
INSERT INTO `logacciones` VALUES (66, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-03-06 15:34:31', '2020-03-06 15:34:31');
INSERT INTO `logacciones` VALUES (67, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-03-06 15:35:19', '2020-03-06 15:35:19');
INSERT INTO `logacciones` VALUES (68, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-03-06 15:37:41', '2020-03-06 15:37:41');
INSERT INTO `logacciones` VALUES (69, 1, 'Actualizó la información del alumno: Marlen Espinoza Ortega', '2020-03-06 15:38:07', '2020-03-06 15:38:07');
INSERT INTO `logacciones` VALUES (70, 1, 'Actualizó la información del alumno: Aron albor sanchez', '2020-03-06 15:38:34', '2020-03-06 15:38:34');
INSERT INTO `logacciones` VALUES (71, 1, 'Actualizó la información del alumno: Elizabeth Jimenez', '2020-03-06 15:38:59', '2020-03-06 15:38:59');
INSERT INTO `logacciones` VALUES (72, 1, 'Actualizó la información del alumno: AOAA971217HMCLGD01 albor sanchez', '2020-03-13 11:12:53', '2020-03-13 11:12:53');
INSERT INTO `logacciones` VALUES (73, 1, 'Actualizó la información del alumno: aron albor albor sanchez', '2020-03-13 11:15:03', '2020-03-13 11:15:03');
INSERT INTO `logacciones` VALUES (74, 1, 'Agrego al alumno: evolution club', '2020-03-13 13:50:38', '2020-03-13 13:50:38');
INSERT INTO `logacciones` VALUES (75, 1, 'Actualizó la información del alumno: evolution club', '2020-03-13 13:51:12', '2020-03-13 13:51:12');
INSERT INTO `logacciones` VALUES (76, 1, 'Actualizó la información del alumno: evolution club', '2020-03-13 13:57:33', '2020-03-13 13:57:33');
INSERT INTO `logacciones` VALUES (77, 1, 'Actualizó la información del alumno: angel flores', '2020-03-13 13:58:27', '2020-03-13 13:58:27');
INSERT INTO `logacciones` VALUES (78, 1, 'Actualizó la información del alumno: angel flores', '2020-03-13 14:09:39', '2020-03-13 14:09:39');
INSERT INTO `logacciones` VALUES (79, 1, 'Actualizó la información del alumno: Elizabeth Jimenez', '2020-03-19 19:11:33', '2020-03-19 19:11:33');
INSERT INTO `logacciones` VALUES (80, 1, 'Agrego al alumno: brandon david luna avila', '2020-03-23 23:33:43', '2020-03-23 23:33:43');
INSERT INTO `logacciones` VALUES (81, 1, 'Agrego al alumno: kevin luna avila', '2020-03-23 23:50:33', '2020-03-23 23:50:33');
INSERT INTO `logacciones` VALUES (82, 1, 'Agrego al alumno: miguel luna avila', '2020-03-24 00:21:22', '2020-03-24 00:21:22');
INSERT INTO `logacciones` VALUES (83, 1, 'Agrego al alumno: luis angel albor', '2020-03-24 00:23:52', '2020-03-24 00:23:52');
INSERT INTO `logacciones` VALUES (84, 1, 'Eliminó al alumno: luis angel albor', '2020-03-24 12:41:32', '2020-03-24 12:41:32');
INSERT INTO `logacciones` VALUES (85, 1, 'Eliminó al alumno: miguel luna avila', '2020-03-24 12:41:43', '2020-03-24 12:41:43');
INSERT INTO `logacciones` VALUES (86, 1, 'Eliminó al alumno: kevin luna avila', '2020-03-24 12:41:52', '2020-03-24 12:41:52');
INSERT INTO `logacciones` VALUES (87, 1, 'Eliminó al alumno: brandon david luna avila', '2020-03-24 12:42:03', '2020-03-24 12:42:03');
INSERT INTO `logacciones` VALUES (88, 1, 'Eliminó al alumno: evolution club', '2020-03-24 12:42:13', '2020-03-24 12:42:13');
INSERT INTO `logacciones` VALUES (89, 1, 'Agrego al alumno: Brandon Luna Avila', '2020-03-24 12:53:14', '2020-03-24 12:53:14');
INSERT INTO `logacciones` VALUES (90, 1, 'Agrego al alumno: prueba para ine', '2020-03-25 19:08:08', '2020-03-25 19:08:08');
INSERT INTO `logacciones` VALUES (91, 1, 'Agrego al alumno: ine ines', '2020-03-25 23:18:20', '2020-03-25 23:18:20');
INSERT INTO `logacciones` VALUES (92, 1, 'Agrego al alumno: ine2 ine ine', '2020-03-25 23:30:46', '2020-03-25 23:30:46');
INSERT INTO `logacciones` VALUES (93, 1, 'Agrego al alumno: archivo ine archivo', '2020-03-25 23:33:33', '2020-03-25 23:33:33');
INSERT INTO `logacciones` VALUES (94, 1, 'Agrego al alumno: acta nacimiento', '2020-03-25 23:46:34', '2020-03-25 23:46:34');
INSERT INTO `logacciones` VALUES (95, 1, 'Agrego al alumno: acta ac ine', '2020-03-25 23:49:25', '2020-03-25 23:49:25');
INSERT INTO `logacciones` VALUES (96, 1, 'Agrego al alumno: prueba para todos', '2020-03-26 00:01:03', '2020-03-26 00:01:03');
INSERT INTO `logacciones` VALUES (97, 1, 'Eliminó al alumno: Brandon Luna Avila', '2020-03-26 00:05:47', '2020-03-26 00:05:47');
INSERT INTO `logacciones` VALUES (98, 1, 'Eliminó al alumno: prueba para ine', '2020-03-26 00:05:58', '2020-03-26 00:05:58');
INSERT INTO `logacciones` VALUES (99, 1, 'Eliminó al alumno: ine ines', '2020-03-26 00:06:08', '2020-03-26 00:06:08');
INSERT INTO `logacciones` VALUES (100, 1, 'Eliminó al alumno: ine2 ine ine', '2020-03-26 00:06:18', '2020-03-26 00:06:18');
INSERT INTO `logacciones` VALUES (101, 1, 'Eliminó al alumno: archivo ine archivo', '2020-03-26 00:06:30', '2020-03-26 00:06:30');
INSERT INTO `logacciones` VALUES (102, 1, 'Eliminó al alumno: acta nacimiento', '2020-03-26 00:06:42', '2020-03-26 00:06:42');
INSERT INTO `logacciones` VALUES (103, 1, 'Eliminó al alumno: acta ac ine', '2020-03-26 00:06:52', '2020-03-26 00:06:52');
INSERT INTO `logacciones` VALUES (104, 1, 'Agrego al alumno: prueba 2 para volver a cargar', '2020-03-26 00:13:25', '2020-03-26 00:13:25');
INSERT INTO `logacciones` VALUES (105, 1, 'Agrego al alumno: Pedro Martinez', '2020-03-26 12:41:59', '2020-03-26 12:41:59');
INSERT INTO `logacciones` VALUES (106, 1, 'Agrego al alumno: Juan Zubieta Aguilar', '2020-03-26 14:54:49', '2020-03-26 14:54:49');
INSERT INTO `logacciones` VALUES (107, 1, 'Agrego al alumno: Rey Zubieta Aguilar', '2020-03-26 14:57:45', '2020-03-26 14:57:45');
INSERT INTO `logacciones` VALUES (108, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-03-26 15:01:17', '2020-03-26 15:01:17');
INSERT INTO `logacciones` VALUES (109, 1, 'Eliminó al alumno: angel flores', '2020-03-26 15:02:04', '2020-03-26 15:02:04');
INSERT INTO `logacciones` VALUES (110, 1, 'Eliminó al alumno: prueba para todos', '2020-03-26 15:02:13', '2020-03-26 15:02:13');
INSERT INTO `logacciones` VALUES (111, 1, 'Eliminó al alumno: prueba 2 para volver a cargar', '2020-03-26 15:02:25', '2020-03-26 15:02:25');
INSERT INTO `logacciones` VALUES (112, 1, 'Eliminó al alumno: Juan Zubieta Aguilar', '2020-03-26 15:02:35', '2020-03-26 15:02:35');
INSERT INTO `logacciones` VALUES (113, 1, 'Actualizó la información del alumno: Elizabeth Jimenez', '2020-03-26 15:08:45', '2020-03-26 15:08:45');
INSERT INTO `logacciones` VALUES (114, 1, 'Actualizó la información del alumno: Marlen Espinoza Ortega', '2020-03-26 15:10:15', '2020-03-26 15:10:15');
INSERT INTO `logacciones` VALUES (115, 1, 'Actualizó la información del alumno: aron albor albor sanchez', '2020-03-26 15:11:23', '2020-03-26 15:11:23');
INSERT INTO `logacciones` VALUES (116, 1, 'Actualizó la información del alumno: Adrian Aron Albor Aguilar', '2020-03-26 15:12:08', '2020-03-26 15:12:08');
INSERT INTO `logacciones` VALUES (117, 1, 'Agrego al alumno: Alfredo Del Mazo', '2020-03-26 22:08:20', '2020-03-26 22:08:20');
INSERT INTO `logacciones` VALUES (118, 1, 'Actualizó la información del alumno: Alfredo Del Mazo', '2020-03-26 23:42:44', '2020-03-26 23:42:44');
INSERT INTO `logacciones` VALUES (119, 1, 'Actualizó la información del alumno: Alfredo Del Mazo', '2020-03-26 23:43:38', '2020-03-26 23:43:38');
INSERT INTO `logacciones` VALUES (120, 1, 'Actualizó la información del alumno: Alfredo Del Mazo', '2020-03-26 23:52:36', '2020-03-26 23:52:36');
INSERT INTO `logacciones` VALUES (121, 1, 'Actualizó la información del alumno: Alfredo Del Mazo', '2020-03-26 23:56:15', '2020-03-26 23:56:15');
INSERT INTO `logacciones` VALUES (122, 1, 'Actualizó la información del alumno: Alfredo Del Mazo', '2020-03-27 00:00:21', '2020-03-27 00:00:21');
INSERT INTO `logacciones` VALUES (123, 1, 'Actualizó la información del alumno: Alfredo Del Mazo', '2020-03-27 00:01:22', '2020-03-27 00:01:22');
INSERT INTO `logacciones` VALUES (124, 1, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-03-27 00:02:28', '2020-03-27 00:02:28');
INSERT INTO `logacciones` VALUES (125, 1, 'Agrego al alumno: SIAPI SIAPI', '2020-03-30 21:55:44', '2020-03-30 21:55:44');
INSERT INTO `logacciones` VALUES (126, 1, 'Agregó un pago al usuario: Adrian Aron Albor Aguilar', '2020-03-30 22:21:30', '2020-03-30 22:21:30');
INSERT INTO `logacciones` VALUES (127, 1, 'Actualizó la información del alumno: SIAPI SIAPI', '2020-03-31 16:34:21', '2020-03-31 16:34:21');
INSERT INTO `logacciones` VALUES (128, 1, 'Actualizó la información del alumno: Alfredo Del Mazo', '2020-03-31 16:49:49', '2020-03-31 16:49:49');
INSERT INTO `logacciones` VALUES (129, 1, 'Agregó un pago al usuario: Adrian Aron Albor Aguilar', '2020-04-09 15:45:33', '2020-04-09 15:45:33');
INSERT INTO `logacciones` VALUES (130, 1, 'Actualizó la información del alumno: Adrian Aron Albor Aguilar', '2020-04-09 15:46:39', '2020-04-09 15:46:39');
INSERT INTO `logacciones` VALUES (131, 1, 'Agregó un pago al usuario: Adrian Aron Albor Aguilar', '2020-04-09 15:47:10', '2020-04-09 15:47:10');
INSERT INTO `logacciones` VALUES (132, 1, 'Eliminó al alumno: Rey Zubieta Aguilar', '2020-04-09 19:12:41', '2020-04-09 19:12:41');
INSERT INTO `logacciones` VALUES (133, 1, 'Eliminó al alumno: Pedro Martinez', '2020-04-09 19:14:05', '2020-04-09 19:14:05');
INSERT INTO `logacciones` VALUES (134, 1, 'Eliminó al alumno: Alfredo Del Mazo', '2020-04-09 19:14:16', '2020-04-09 19:14:16');
INSERT INTO `logacciones` VALUES (135, 1, 'Eliminó al alumno: Elizabeth Jimenez', '2020-04-09 19:14:53', '2020-04-09 19:14:53');
INSERT INTO `logacciones` VALUES (136, 1, 'Agregó al usuario Aron Albor', '2020-04-16 19:42:06', '2020-04-16 19:42:06');
INSERT INTO `logacciones` VALUES (137, 1, 'Modificó los permisos de acceso del usuario: Aron Albor', '2020-04-16 19:44:10', '2020-04-16 19:44:10');
INSERT INTO `logacciones` VALUES (138, 1, 'Modificó los permisos de acceso del usuario: Aron Albor', '2020-04-16 19:46:47', '2020-04-16 19:46:47');
INSERT INTO `logacciones` VALUES (139, 1, 'Agregó un pago al usuario: Adrian Aron Albor Aguilar', '2020-06-29 17:28:51', '2020-06-29 17:28:51');
INSERT INTO `logacciones` VALUES (140, 5, 'Modificó los permisos de acceso del usuario: Aron Albor', '2020-07-10 18:16:40', '2020-07-10 18:16:40');
INSERT INTO `logacciones` VALUES (141, 5, 'Modificó los permisos de acceso del usuario: Aron Albor', '2020-07-11 18:29:24', '2020-07-11 18:29:24');
INSERT INTO `logacciones` VALUES (142, 5, 'Eliminó al alumno: Adrian Aron Albor', '2020-07-12 05:13:05', '2020-07-12 05:13:05');
INSERT INTO `logacciones` VALUES (143, 5, 'Eliminó al alumno: Adrian Aron Albor', '2020-07-12 05:16:37', '2020-07-12 05:16:37');
INSERT INTO `logacciones` VALUES (144, 5, 'Eliminó al alumno: Adrian Aron Albor', '2020-07-12 05:17:09', '2020-07-12 05:17:09');
INSERT INTO `logacciones` VALUES (145, 5, 'Eliminó al alumno: Adrian Aron Albor', '2020-07-12 05:18:08', '2020-07-12 05:18:08');
INSERT INTO `logacciones` VALUES (146, 5, 'Eliminó al alumno: Adrian Aron Albor', '2020-07-12 13:31:56', '2020-07-12 13:31:56');
INSERT INTO `logacciones` VALUES (147, 5, 'Eliminó al alumno: daniel antonio chapul', '2020-07-12 16:11:17', '2020-07-12 16:11:17');
INSERT INTO `logacciones` VALUES (148, 5, 'Eliminó al alumno: Alan Rodriguez', '2020-07-15 15:43:05', '2020-07-15 15:43:05');
INSERT INTO `logacciones` VALUES (149, 5, 'Eliminó al alumno: ohui oo', '2020-07-21 14:12:40', '2020-07-21 14:12:40');
INSERT INTO `logacciones` VALUES (150, 5, 'Eliminó al alumno: sdgsgsdg gsg', '2020-07-21 14:13:03', '2020-07-21 14:13:03');
INSERT INTO `logacciones` VALUES (151, 5, 'Eliminó al alumno: oouu jbbib', '2020-07-21 14:13:12', '2020-07-21 14:13:12');
INSERT INTO `logacciones` VALUES (152, 5, 'Eliminó al alumno: daniel antonio chapul', '2020-07-21 14:13:19', '2020-07-21 14:13:19');
INSERT INTO `logacciones` VALUES (153, 5, 'Actualizó la información del alumno: Carlos Alexis Campos Mariscal', '2020-07-21 14:28:45', '2020-07-21 14:28:45');
INSERT INTO `logacciones` VALUES (154, 5, 'Modificó los permisos de acceso del usuario: Aron Albor', '2020-07-22 19:26:57', '2020-07-22 19:26:57');
INSERT INTO `logacciones` VALUES (155, 5, 'Modificó los permisos de acceso del usuario: Carlos Alexis', '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `logacciones` VALUES (156, 5, 'Modificó los permisos de acceso del usuario: Aron Albor', '2020-07-22 19:56:23', '2020-07-22 19:56:23');
INSERT INTO `logacciones` VALUES (157, 5, 'Modificó los permisos de acceso del usuario: Maria Elizabeth', '2020-07-22 19:57:00', '2020-07-22 19:57:00');
INSERT INTO `logacciones` VALUES (158, 5, 'Modificó los permisos de acceso del usuario: Maria Elizabeth', '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `logacciones` VALUES (159, 5, 'Modificó los datos del usuario: Maria Elizabeth', '2020-07-22 20:13:00', '2020-07-22 20:13:00');
INSERT INTO `logacciones` VALUES (160, 6, 'Agregó al usuario Juan', '2020-07-22 20:14:38', '2020-07-22 20:14:38');
INSERT INTO `logacciones` VALUES (161, 6, 'Modificó los datos del usuario: Juan', '2020-07-22 20:15:23', '2020-07-22 20:15:23');
INSERT INTO `logacciones` VALUES (162, 5, 'Modificó los permisos de acceso del usuario: Juan', '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `logacciones` VALUES (163, 6, 'Modificó los datos del usuario: Juan', '2020-07-22 20:17:39', '2020-07-22 20:17:39');
INSERT INTO `logacciones` VALUES (164, 6, 'Modificó los datos del usuario: Juan', '2020-07-22 20:18:11', '2020-07-22 20:18:11');
INSERT INTO `logacciones` VALUES (165, 1, 'Agrego al alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 01:42:58', '2020-10-03 01:42:58');
INSERT INTO `logacciones` VALUES (166, 1, 'Agrego al alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 02:03:47', '2020-10-03 02:03:47');
INSERT INTO `logacciones` VALUES (167, 1, 'Actualizó la información del alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 04:05:58', '2020-10-03 04:05:58');
INSERT INTO `logacciones` VALUES (168, 1, 'Actualizó la información del alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 04:06:16', '2020-10-03 04:06:16');
INSERT INTO `logacciones` VALUES (169, 1, 'Actualizó la información del alumno: CARLOS ALEXIS UNO CAMPOS MARISCAL', '2020-10-03 04:06:28', '2020-10-03 04:06:28');
INSERT INTO `logacciones` VALUES (170, 1, 'Actualizó la información del alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 04:06:51', '2020-10-03 04:06:51');
INSERT INTO `logacciones` VALUES (171, 1, 'Actualizó la información del alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 04:07:06', '2020-10-03 04:07:06');
INSERT INTO `logacciones` VALUES (172, 1, 'Actualizó la información del alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 04:07:14', '2020-10-03 04:07:14');
INSERT INTO `logacciones` VALUES (173, 1, 'Actualizó la información del alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 04:07:27', '2020-10-03 04:07:27');
INSERT INTO `logacciones` VALUES (174, 1, 'Actualizó la información del alumno: CARLOS ALEXIS CAMPOS MARISCAL', '2020-10-03 04:07:37', '2020-10-03 04:07:37');
INSERT INTO `logacciones` VALUES (175, 1, 'Eliminó al usuario: Aron Albor', '2020-10-03 04:15:51', '2020-10-03 04:15:51');
INSERT INTO `logacciones` VALUES (176, 1, 'Eliminó al usuario: Juan', '2020-10-03 04:15:56', '2020-10-03 04:15:56');
INSERT INTO `logacciones` VALUES (177, 1, 'Eliminó al usuario: Maria Elizabeth', '2020-10-03 04:16:00', '2020-10-03 04:16:00');
INSERT INTO `logacciones` VALUES (178, 1, 'Eliminó al usuario: Marlen Espinoza', '2020-10-03 04:16:03', '2020-10-03 04:16:03');

-- ----------------------------
-- Table structure for materiascarrera
-- ----------------------------
CREATE TABLE `materiascarrera`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cuatrimestre` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `nombre` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `clave` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `creditos` float NULL DEFAULT NULL,
  `idCarrera` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
CREATE TABLE `menu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES (1, 'Alumnos', '2019-12-12 17:40:04', '2019-12-12 17:40:08');
INSERT INTO `menu` VALUES (2, 'Gastos', '2019-12-12 18:49:51', '2019-12-12 18:49:54');
INSERT INTO `menu` VALUES (3, 'Ventas', '2019-12-12 23:39:43', '2019-12-12 23:39:46');
INSERT INTO `menu` VALUES (4, 'Usuarios', '2019-12-12 23:40:54', '2019-12-12 23:40:57');
INSERT INTO `menu` VALUES (5, 'Pagos', '2019-12-24 02:05:02', '2019-12-24 02:05:05');

-- ----------------------------
-- Table structure for menuuser
-- ----------------------------
CREATE TABLE `menuuser`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idMenu` int(11) NULL DEFAULT NULL,
  `idUsuario` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 119 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of menuuser
-- ----------------------------
INSERT INTO `menuuser` VALUES (78, 1, 1, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `menuuser` VALUES (79, 2, 1, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `menuuser` VALUES (80, 5, 1, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `menuuser` VALUES (81, 4, 1, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `menuuser` VALUES (82, 3, 1, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `menuuser` VALUES (94, 1, 5, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `menuuser` VALUES (95, 2, 5, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `menuuser` VALUES (96, 5, 5, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `menuuser` VALUES (97, 4, 5, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `menuuser` VALUES (102, 1, 6, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `menuuser` VALUES (103, 2, 6, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `menuuser` VALUES (104, 5, 6, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `menuuser` VALUES (105, 4, 6, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `menuuser` VALUES (115, 1, 7, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `menuuser` VALUES (116, 2, 7, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `menuuser` VALUES (117, 5, 7, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `menuuser` VALUES (118, 4, 7, '2020-07-22 20:16:46', '2020-07-22 20:16:46');

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (3, '2019_08_19_000000_create_failed_jobs_table', 1);

-- ----------------------------
-- Table structure for niveleducativo
-- ----------------------------
CREATE TABLE `niveleducativo`  (
  `idnivel` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`idnivel`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of niveleducativo
-- ----------------------------
INSERT INTO `niveleducativo` VALUES (1, 'Preparatoria', NULL, NULL);
INSERT INTO `niveleducativo` VALUES (2, 'Licenciatura', NULL, NULL);
INSERT INTO `niveleducativo` VALUES (3, 'Maestría', NULL, NULL);
INSERT INTO `niveleducativo` VALUES (4, 'Especialidad', NULL, NULL);

-- ----------------------------
-- Table structure for pagos
-- ----------------------------
CREATE TABLE `pagos`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idAlumno` int(11) NULL DEFAULT NULL,
  `pago` decimal(10, 2) NULL DEFAULT NULL,
  `concepto` int(11) NULL DEFAULT NULL,
  `tipoPago` int(11) NULL DEFAULT NULL,
  `mes` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `year` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  `folioInterno` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `fechaRecepcion` date NULL DEFAULT NULL,
  `idUsuarioCreacion` int(11) NULL DEFAULT NULL,
  `idUsuarioModificacion` int(11) NULL DEFAULT NULL,
  `idUsuarioEliminacion` int(11) NULL DEFAULT NULL,
  `fechaEliminacion` datetime(0) NULL DEFAULT NULL,
  `status` char(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pagos
-- ----------------------------
INSERT INTO `pagos` VALUES (1, 4, 2.00, 4, 1, 'Marzo', '2020', '2020-03-30 22:21:30', '2020-03-30 22:21:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pagos` VALUES (2, 27, 2.00, 4, 1, 'Enero', '2020', '2020-03-30 22:21:30', '2020-03-30 22:21:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pagos` VALUES (3, 27, 2.00, 4, 1, 'Febrero', '2020', '2020-03-30 22:21:30', '2020-03-30 22:21:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pagos` VALUES (4, 4, 2.00, 3, 1, 'Enero-Abril', '2021', '2020-04-09 15:45:32', '2020-04-09 15:45:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pagos` VALUES (5, 4, 2.00, 3, 1, 'Enero-Abril', '2021', '2020-04-09 15:47:10', '2020-04-09 15:47:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pagos` VALUES (6, 4, 22.00, 4, 1, 'Junio', '2020', '2020-06-29 17:28:51', '2020-06-29 17:28:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for sedes
-- ----------------------------
CREATE TABLE `sedes`  (
  `idsede` int(11) NOT NULL AUTO_INCREMENT,
  `sede` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`idsede`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sedes
-- ----------------------------
INSERT INTO `sedes` VALUES (1, 'Ecatepec - Americas', '2020-09-30 22:39:19', '2020-09-30 22:39:22');
INSERT INTO `sedes` VALUES (2, 'SUTEYM', '2020-09-30 22:39:19', '2020-09-30 22:39:19');

-- ----------------------------
-- Table structure for submenu
-- ----------------------------
CREATE TABLE `submenu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idMenu` int(11) NULL DEFAULT NULL,
  `subMenu` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `direccion` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of submenu
-- ----------------------------
INSERT INTO `submenu` VALUES (1, 4, 'Gestión de Usuarios', 'usuarios.index', '2019-12-12 23:51:35', '2019-12-12 23:51:37');
INSERT INTO `submenu` VALUES (2, 1, 'Agregar Nuevo', 'alumnos.create', '2019-12-23 20:19:10', '2019-12-23 20:19:13');
INSERT INTO `submenu` VALUES (3, 1, 'Listado ', 'alumnos.index', '2019-12-24 00:01:16', '2019-12-24 00:01:19');
INSERT INTO `submenu` VALUES (4, 5, 'Registrar Pago', 'pagos.index', '2019-12-24 02:05:30', '2019-12-24 02:05:33');
INSERT INTO `submenu` VALUES (5, 2, 'Gastos Administrativos', 'gastos.index', '2020-03-03 16:39:02', '2020-03-03 16:39:07');
INSERT INTO `submenu` VALUES (6, 1, 'Examen único', 'only', '2020-07-10 18:15:51', '2020-07-10 18:15:58');
INSERT INTO `submenu` VALUES (7, 1, 'Listado Examen único', 'listadoexamen', '2020-07-11 17:44:26', '2020-07-11 17:44:34');

-- ----------------------------
-- Table structure for submenuusuarios
-- ----------------------------
CREATE TABLE `submenuusuarios`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idMenu` int(11) NULL DEFAULT NULL,
  `idUsuario` int(11) NULL DEFAULT NULL,
  `idSubMenu` int(11) NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 85 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of submenuusuarios
-- ----------------------------
INSERT INTO `submenuusuarios` VALUES (53, 1, 1, 2, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `submenuusuarios` VALUES (54, 1, 1, 3, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `submenuusuarios` VALUES (55, 1, 1, 6, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `submenuusuarios` VALUES (56, 1, 1, 7, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `submenuusuarios` VALUES (57, 2, 1, 5, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `submenuusuarios` VALUES (58, 5, 1, 4, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `submenuusuarios` VALUES (59, 4, 1, 1, '2020-07-22 19:27:25', '2020-07-22 19:27:25');
INSERT INTO `submenuusuarios` VALUES (60, 1, 5, 2, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `submenuusuarios` VALUES (61, 1, 5, 3, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `submenuusuarios` VALUES (62, 1, 5, 6, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `submenuusuarios` VALUES (63, 1, 5, 7, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `submenuusuarios` VALUES (64, 2, 5, 5, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `submenuusuarios` VALUES (65, 5, 5, 4, '2020-07-22 19:56:22', '2020-07-22 19:56:22');
INSERT INTO `submenuusuarios` VALUES (66, 4, 5, 1, '2020-07-22 19:56:23', '2020-07-22 19:56:23');
INSERT INTO `submenuusuarios` VALUES (71, 1, 6, 2, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `submenuusuarios` VALUES (72, 1, 6, 3, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `submenuusuarios` VALUES (73, 1, 6, 6, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `submenuusuarios` VALUES (74, 1, 6, 7, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `submenuusuarios` VALUES (75, 2, 6, 5, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `submenuusuarios` VALUES (76, 5, 6, 4, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `submenuusuarios` VALUES (77, 4, 6, 1, '2020-07-22 20:10:00', '2020-07-22 20:10:00');
INSERT INTO `submenuusuarios` VALUES (78, 1, 7, 2, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `submenuusuarios` VALUES (79, 1, 7, 3, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `submenuusuarios` VALUES (80, 1, 7, 6, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `submenuusuarios` VALUES (81, 1, 7, 7, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `submenuusuarios` VALUES (82, 2, 7, 5, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `submenuusuarios` VALUES (83, 5, 7, 4, '2020-07-22 20:16:46', '2020-07-22 20:16:46');
INSERT INTO `submenuusuarios` VALUES (84, 4, 7, 1, '2020-07-22 20:16:46', '2020-07-22 20:16:46');

-- ----------------------------
-- Table structure for tipopagos
-- ----------------------------
CREATE TABLE `tipopagos`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `created_at` datetime(0) NULL DEFAULT NULL,
  `updated_at` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tipopagos
-- ----------------------------
INSERT INTO `tipopagos` VALUES (1, 'Efectivo', '2019-12-24 02:16:08', '2019-12-24 02:16:10');
INSERT INTO `tipopagos` VALUES (2, 'Transferencia', '2019-12-24 02:16:39', '2019-12-24 02:16:42');
INSERT INTO `tipopagos` VALUES (3, 'Terminal', '2019-12-24 02:16:44', '2019-12-24 02:16:46');

