-- phpMyAdmin SQL Dump

-- version 4.8.4
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 27-08-2021 a las 04:15:08
-- Versión del servidor: 10.1.37-MariaDB
-- Versión de PHP: 7.3.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: `kardex`
--

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

--
-- Estructura de tabla para la tabla `docentes`
--

CREATE TABLE `docentes` (

`carnet` int(11) NOT NULL,
`nombres` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

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

INSERT INTO `docentes` (`carnet`, `nombres`) VALUES

(2254152, 'ING. LUJAN\r'),
(2541541, 'ING.PEREIRA\r'),
(2542541, 'ING. ROMERO\r'),
(3254124, 'LIC. CUAQUIRA\r'),
(3353362, 'LIC. ZEBALLOS\r'),
(3452147, 'LIC. CARVAJAL\r'),
(4254178, 'ING. GOMEZ\r'),
(5412485, 'LIC. TAPIA\r');

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

--
-- Estructura de tabla para la tabla `estudiantes`
--

CREATE TABLE `estudiantes` (

 `carnet` int(11) NOT NULL,
`paterno` varchar(20) COLLATE utf8_spanish2_ci DEFAULT NULL,
`materno` varchar(20) COLLATE utf8_spanish2_ci DEFAULT NULL,
`nombres` varchar(30) COLLATE utf8_spanish2_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

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

INSERT INTO `estudiantes` (`carnet`, `paterno`, `materno`, `nombres`)

VALUES
(3094450, 'QUISPIA', 'RIVERA', 'ALDO JAVIER'),
(3452262, 'ARTIEDA', 'MARQUEZ', 'HEBER NATANIEL\r'),
(3534508, 'PACHECO', 'ALVAREZ', 'CRISTHIAM MARCELO\r'),
(4201314, 'LAGUNA', 'QUIROGA', 'ROLANDO PATRICIO\r'),
(4299188, 'BUEZO', 'NISTAHUZ', 'FERNANDO FELIX\r'),
(4317589, 'AGUILAR', 'APAZA', 'EDWIN MARCELO\r'),
(4329948, 'QUISPE', 'BLANCO', 'DAVID JORGE\r'),
(4339547, 'QUISPE', 'ROJAS', 'FLOR REBECA\r'),
(4369274, 'GUTIERREZ', 'GUTIERREZ', 'ANGEL\r'),
(4771404, 'SALAZAR', 'RODRIGUEZ', 'YERSON IVAN\r'),
(4784615, 'TICONA', 'MAMANI', 'LIMBER\r'),
(4827291, 'LUNA', 'MAIDANA', 'NELSON JULIO\r'),
(4833757, 'HERNANDEZ', 'JURADO', 'SINFOROSO JOSE\r'),
(4844828, 'TARQUI', 'MENDEZ', 'JOSE EDUARDO\r'),
(4845628, 'RIOS', 'ALIAGA', 'LEONARDO JULIO\r'),
(4849844, 'TICONA', 'MAMANI', 'WILSON\r'),
(4883329, 'LAIME', 'FLORES', 'JOSE MANUEL\r'),
(4913514, 'CANAVIRI', 'LOPEZ', 'VICTOR HUGO\r'),
(4919045, 'MORENO', 'TORREZ', 'MARCELO\r'),
(4921802, 'BLANCO', 'CHURATA', 'RICHARD SANTOS\r'),
(4923886, 'GUANCA', 'SALAZAR', 'CLAUDIA CATIA\r'),
(4980011, 'CASTRO', 'ROCABADO', 'JHONATAN ISMAEL\r'),
(4982601, 'POMA', 'ALVARADO', 'MIGUEL ANGEL\r'),
(4987909, 'CARRIZO', 'CONDORI', 'HENRY\r'),
(4997781, 'MAMANI', 'LIMACHI', 'EDWIN GONZALO\r'),
(5476007, 'CALLE', 'BORDA', 'JAIME\r'),
(5515122, 'TARCAYA', 'GALLARDO', 'SERGIO\r'),
(5774320, 'UGARTE', 'TEJERINA', 'SIDNEY EYLEEN\r'),
(5799459, 'MAMANI', 'ALVAREZ', 'NOEMI\r'),
(5956925, 'PEREZ', 'MAMANI', 'LIDIA MAYOLI\r'),
(5970844, 'GUTIERREZ', 'YUJRA', 'PABEL LEONEL\r'),
(5974586, 'APAZA', 'RAMIREZ', 'PRISCILA GERALDINE\r'),
(5977087, 'FERNANDEZ', 'EGUIVAR', 'PAOLA ALEJANDRA\r'),
(6009256, 'USNAYO', 'FELIPEZ', 'JAIME\r'),
(6028285, 'ADUVIRI', 'PERALTA', 'AMERICO\r'),
(6031754, 'CRUZ', 'NINA', 'JULIA\r'),
(6035450, 'APAZA', 'MAMANI', 'BELISARIO\r'),
(6036159, 'GALLO', 'QUISPE', 'FRANKLIN\r'),
(6043300, 'TAPIA', 'POCOATA', 'JHEP OMAR\r'),
(6049466, 'APAZA', 'HUANCA', 'GABRIEL\r'),
(6050328, 'SARZURI', 'MAMANI', 'CLARA NAIVE\r'),
(6059989, 'TARQUI', 'TORREZ', 'JUAN CARLOS\r'),
(6065458, 'CONDE', 'MEDINA', 'RONALD GUSTAVO\r'),
(6072526, 'COLMENA', 'QUESO', 'JHONNY ELIAS\r'),
(6076486, 'PATZI', 'MAMANI', 'MIGUEL ANGEL\r'),
(6077333, 'QUISPE', 'LUQUE', 'DELIA\r'),
(6090930, 'MARTINEZ', 'SARZURI', 'JANETH HAEL\r'),
(6095226, 'MAMANI', 'MAMANI', 'EDDY DAVID\r'),
(6095399, 'CHUQUIMIA', 'MAMANI', 'NEYDA NERIDA\r'),
(6102324, 'JALLASI', 'YUJRA', 'DELIA\r'),
(6104283, 'LAURA', 'GARCIA', 'ERWIN SANTOS\r'),
(6118490, 'PAREDES', 'CHIPANA', 'MARCO ANTONIO\r'),
(6121213, 'CALLISAYA', 'APAZA', 'WILMER DAVID\r'),
(6121235, 'CALLISAYA', 'APAZA', 'GROVER OCTAVIO\r'),
(6121828, 'LARA', 'TICONA', 'JORGE ABIMAEL\r'),
(6134063, 'PEREZ', 'PEREIRA', 'DIEGO HERNAN\r'),
(6144520, 'PACHECO', 'CABEZAS', 'NELSON MIGUEL\r'),
(6177816, 'MAQUERA', 'ALIAGA', 'NELSON\r'),
(6192821, 'QUISPE', 'RODRIGUEZ', 'ROMMY HEBER\r'),
(6193953, 'TIÑINI', 'MAMANI', 'JUANA\r'),
(6593984, 'CHOQUE', 'HUAYTA', 'OSCAR RAMIRO\r'),
(6723295, 'ARCANI', 'GARCIA', 'MARCOS MAURICIO\r'),
(6728517, 'CONDORI', 'HUANCA', 'FREDDY\r'),
(6740649, 'POMAR', 'AVALOS', 'OMAR RODRIGO\r'),
(6740666, 'MIRANDA', 'FLORES', 'ANGELA JAZMIN\r'),
(6756865, 'AGUILAR', 'HEREDIA', 'ANTONIO ROBERTO\r'),
(6774625, 'GARCIA', 'MAMANI', 'VIRGILIO\r'),
(6777238, 'CHARCAS', 'CUENTAS', 'PATRICIA GABRIELA\r'),
(6780753, 'VIVEROS', 'MARCA', 'PABLO AUGUSTO\r'),
(6791799, 'LAURA', 'QUETEGUARI', 'YURI VLADIMIR\r'),
(6795129, 'CHOQUE', 'MAMANI', 'FABIO DANIEL\r'),
(6800356, 'ZELADA', 'YUJRA', 'JAVIER ANDRES\r'),
(6805843, 'MONTECINOS', 'MARQUEZ', 'JAIME ANTONIO\r'),
(6806428, 'MANTILLA', 'CONDORI', 'LUIS MIGUEL\r'),
(6814635, 'VARGAS', 'SANDALIO', 'JOSE MIGUEL\r'),
(6815172, 'CRUZ', 'COARETI', 'WENDY PAOLA\r'),
(6815511, 'CANAVIRI', 'BLANCO', 'PAOLA PATRICIA\r'),
(6822668, 'MUÑOZ', 'MENDOZA', 'ARNALDO\r'),
(6822713, 'GOMEZ', 'JIMENEZ', 'TELASSIM GINNOLA\r'),
(6825876, 'CHOQUE', 'MAMANI', 'WILSON OVIDIO\r'),
(6828070, 'ALFARO', 'QUISPE', 'CARLOS\r'),
(6848090, 'CRISPIN', 'MACHICADO', 'OMAR GONZALO\r'),
(6849347, 'MAYTA', 'FUENTES', 'MARIBEL\r'),
(6861908, 'TERAN', 'MURILLO', 'DIEGO FABIAN\r'),
(6869952, 'CORONEL', 'BERRIOS', 'DANIEL ALEJANDRO\r'),
(6870915, 'FERNANDEZ', 'CABRERA', 'LUZ ALEJANDRA\r'),
(6893912, 'AGUILAR', 'LOZANO', 'ERICK\r'),
(6901694, 'GARCIA', 'SAENZ', 'RODRIGO MAURICIO\r'),
(6906907, 'LOZA', 'LUCANA', 'DANIEL\r'),
(6933814, 'TICONA', 'HUANCA', 'COCO VIDAL\r'),
(6944713, 'SANCHEZ', 'MENDEZ', 'GUSTAVO\r'),
(6944974, 'QUINO', 'JIMENEZ', 'VICTOR DANIEL\r'),
(6945019, 'TORREZ', 'VALDIVIA', 'OSCAR INTI\r'),
(6949018, 'LECOÑA', 'RIVAS', 'ALEJANDRA\r'),
(6949345, 'MAZUELOS', 'RABAZA', 'GABRIEL ADRIAN\r'),
(6949509, 'CAJCHAYA', 'MAMANI', 'YOSELYN CAROLINA\r'),
(6952065, 'APANQUI', 'OTOYA', 'RENE ALEX\r'),
(6952136, 'VILLARPANDO', 'CHAVARRIA', 'BRAIAN SERGIO\r'),
(6953072, 'ACOSTA', 'ARCHONDO', 'MARCELO MAX\r'),
(6957806, 'BAUTISTA', 'ARCANI', 'MAYRA\r'),
(6964266, 'VALENCIA', 'BLANCO', 'LEIDI STEFANI\r'),
(6966551, 'GERONIMO', 'PATZI', 'JORGE LUIS\r'),
(6966635, 'LAURA', 'CHOQUE', 'PRIMO\r'),
(6967776, 'QUIÑAJO', 'QUIÑAJO', 'EDSON FELIX\r'),
(6977723, 'CHUQUIMIA', 'CORDOVA', 'ROSMERY PAOLA\r'),
(6984167, 'ARUQUIPA', 'CHIPANA', 'VEYMAR DAVID\r'),
(6986015, 'TICONA', 'ALCON', 'JOSE LUIS\r'),
(6989127, 'CHOQUE', 'HUANCA', 'HERNY FRANKLIN\r'),
(6989279, 'MAMANI', 'MAMANI', 'VIVIANA\r'),
(6989918, 'PARI', 'CAHUNA', 'RICARDO ESTEBAN\r'),
(6990604, 'TORREZ', 'MACHICADO', 'VANIA HELEN\r'),
(6995817, 'MAMANI', 'ARUQUIPA', 'JOSE ARMANDO\r'),
(6997876, 'HUAYCHO', 'CHAVEZ', 'ARTURO MISAEL\r'),
(7005717, 'PACHAJAYA', 'LARICO', 'WILSON EFRAIN\r'),
(7023913, 'TORREZ', 'ARUQUIPA', 'RUBEN DARIO\r'),
(7031954, 'ALVAREZ', 'COLQUE', 'FERNANDO\r'),
(7032430, 'HUANCA', 'MAMANI', 'REYNALDO\r'),
(7039950, 'LLUSCO', 'CATACORA', 'JUAN ROSENDO\r'),
(7041686, 'TORRICO', 'FERNANDEZ', 'CARLOS JOSE\r'),
(7046747, 'PALLY', 'CAMPOS', 'WENDDY AMAGALY\r'),
(7047036, 'PAUCARA', 'TORREZ', 'EFRAIN\r'),
(7048181, 'GONZALES', 'TOLEDO', 'DAVID EFRAIN\r'),
(7051670, 'QUISPE', 'CASTAÑETA', 'VILMA PATRICIA\r'),
(7058903, 'TICONA', 'RAMOS', 'DIEGO FERNANDO\r'),
(7059562, 'LEMUS', 'ARUQUIPA', 'LIZ FABIOLA\r'),
(7061467, 'LIMACHI', 'YUJRA', 'MARIA KARINA\r'),
(7063050, 'RODAS', 'CORIA', 'ABIGAIL\r'),
(7065040, 'HUAYHUA', 'QUISPE', 'SUSANA JULIA\r'),
(7066887, 'ORUÑO', 'MAMANI', 'DANAE\r'),
(7071807, 'SILVA', 'ARANDO', 'DIANA VANESSA\r'),
(7072041, 'PAREDES', 'TOLA', 'ERLAND PACIFICO\r'),
(7073610, 'HUMEREZ', 'DAVALOS', 'LINDSAY SHIRLEY\r'),
(7284636, 'TORREZ', 'LIRA', 'RODOLFO\r'),
(8105954, 'GONZALES', 'APAZA', 'PAMELA\r'),
(8264146, 'FERNANDEZ', 'RAMOS', 'LUIS VLADIMIR\r'),
(8264427, 'MAYTA', 'CHOQUECALLO', 'CANDIDO\r'),
(8287377, 'MAMANI', 'VALLEJOS', 'MERY GABRIELA\r'),
(8300134, 'VARGAS', 'SUCAPUCA', 'JUAN REYNALDO\r'),
(8302495, 'CHAVEZ', 'HUANCA', 'JOSE LUIS\r'),
(8302680, 'QUENTA', 'LOPEZ', 'ADALID ALEX\r'),
(8303797, 'CORTEZ', 'GUACHALLA', 'MARIANA ZENAIDA\r'),
(8303892, 'PLATA', 'ZEGARRA', 'WALDO\r'),
(8304469, 'POMA', 'CANAVIRI', 'INDIRA NOEMI\r'),
(8306113, 'TICONA', 'CHOQUE', 'JUAN ANDRES\r'),
(8310947, 'ARPAZI', 'VITO', 'GROVER CHRISTIAN\r'),
(8313157, 'CHALCO', 'LAREDO', 'JOEL FRANKLIN\r'),
(8314445, 'QUISPE', 'CHAMIZO', 'CAROL ANAHI\r'),
(8315048, 'MOLLEAPAZA', 'CALAMANI', 'MARINA\r'),
(8317846, 'QUISPE', 'JIMENEZ', 'LOURDES MARIANA\r'),
(8321008, 'MORGA', 'LIUCA', 'SERGIO GARY\r'),
(8322827, 'MOYA', 'VERA', 'JUAN PABLO\r'),
(8323573, 'PEREZ', 'ZEBALLOS', 'PABLO TUPACK\r'),
(8323779, 'GALARZA', 'SAAVEDRA', 'IVAN DANIEL\r'),
(8324817, 'TITO', 'TAMBO', 'LUIS ANGEL\r'),
(8326617, 'MAMANI', 'CARI', 'VIRGINIA\r'),
(8330408, 'YAMPASI', 'BURGOS', 'LIMBER FABIAN\r'),
(8331867, 'QUISPE', 'CALLE', 'JULIETA\r'),
(8334408, 'CALLEJAS', 'JIMENEZ', 'NANCY\r'),
(8334857, 'CERRO ', 'MORALES', 'MELVI TAHERE\r'),
(8337674, 'FLORES', 'CHINO', 'RAPHAEL\r'),
(8340433, 'MURILLO', 'MAMANI', 'ANDRES JULIO\r'),
(8341010, 'CHURA', 'CONDORI', 'NESTOR\r'),
(8343146, 'SANTIESTEBAN', 'ZEBALLOS', 'JORGE TEODORO\r'),
(8344694, 'FLORES', 'ESPINOZA', 'CHRISTIAN CALIXTO\r'),
(8345147, 'MERLO', 'SAAVEDRA', 'DAYNOR GEOVANNY\r'),
(8346057, 'VASQUEZ', 'JALIRI', 'ISMAEL MILTON\r'),
(8346420, 'TARIFA', 'CALLE', 'CRISTIAN\r'),
(8347690, 'MAMANI', 'CHAVEZ', 'NOEMI STEFANY\r'),
(8349252, 'MAMANI', 'QUISPE', 'PATRICIA\r'),
(8350017, 'LOSANTOS', 'RAMOS', 'ADOLFO ALBERTO\r'),
(8351469, 'ALAPA', 'CONDORI', 'GEOVANA CARLA\r'),
(8353931, 'ALARCON', 'ARROYO', 'OLIVER\r'),
(8360501, 'LLANQUI', 'CASTRO', 'OSMAR FABIO\r'),
(8362926, 'MEJIA', 'MICHEL', 'HELIO\r'),
(8363750, 'ILLANES', 'FERNANDEZ', 'GUDNAR RODRIGO\r'),
(8364758, 'QUISPE', 'QUISPE', 'WILMER ALEX\r'),
(8369536, 'CARRASCO', 'ASTORGA', 'ANGELA MARIA DANIELA\r'),
(8383914, 'ALEJO', 'PEREZ', 'IVAN OSCAR\r'),
(8387204, 'LIMACHI', 'MACHACA', 'KARLA BELEN\r'),
(8392126, 'ESQUIVEL', 'QUISBERT', 'ALVARO RODRIGO\r'),
(8398945, 'CHUQUIMIA', 'MENDOZA', 'JUAN PABLO\r'),
(8402328, 'CALDERON', 'MACUCHAPI', 'FABIOLA DENNIS\r'),
(8402645, 'ALIAGA', 'BARRIONUEVO', 'ALEJANDRA LUCIA\r'),
(8410497, 'CHURATA', 'HUAYHUA', 'LENY\r'),
(8420758, 'YLLATARCO', 'CASTILLO', 'FRANCO HAROLD\r'),
(8421503, 'YAÑEZ', 'YAÑEZ', 'MARCELO AMMAR\r'),
(8433144, 'VARGAS', 'MANTILLA', 'KEVIN\r'),
(8442805, 'ARTEAGA', 'GUTIERREZ', 'NICOLAS BRYAN\r'),
(8444602, 'QUISPE', 'CHALLCO', 'RONALD NICOLAS\r'),
(8445604, 'HILAYA', 'TICONA', 'HENRRY MIGUEL\r'),
(8464476, 'CAMACHO', 'LUGONES', 'MADDIZON MASHIEL\r'),
(8468662, 'SALAZAR', 'QUISPE', 'BRIAN RODRIGO\r'),
(8469272, 'FERNANDEZ', 'MONDACCA', 'CARLOS ADRIAN\r'),
(9087901, 'NIGAÑEZ', 'ALIAGA', 'JUAN FELIPE\r'),
(9099740, 'PACAJE', 'MAMANI', 'FATIMA LIDIA\r'),
(9100539, 'CANQUELLA', 'VARGAS', 'IVAN MARCOS\r'),
(9103168, 'GONZALES', 'VELASQUEZ', 'BRAYAN HUBER\r'),
(9103275, 'VICENTE', 'QUISPE', 'MILENKA SHIRLEY\r'),
(9110020, 'VILLCA', 'ALARCON', 'ABRAHAM\r'),
(9113846, 'UGARTE', 'PABON', 'MIJAEL\r'),
(9129050, 'COLQUE', 'QUISPE', 'AYDE LINA\r'),
(9169954, 'QUISPE', 'CALA', 'VANESA DAYSI\r'),
(9170991, 'MOLLINEDO', 'PACUANCA', 'FAVIO JAVIER\r'),
(9179201, 'ESPINOZA', 'ARGOLLO', 'BRANIMIR FERNANDO\r'),
(9189645, 'MENDOZA', 'ESCOBAR', 'FERNANDO\r'),
(9201368, 'ALTAMIRANO', 'CHOQUE', 'MARCO ANTONIO\r'),
(9209906, 'MENDOZA', 'MAMANI', 'LIZETH\r'),
(9214751, 'BALTAZAR', 'ORTIZ', 'SANDRA\r'),
(9228002, 'CALLISAYA', 'CONDORI', 'EDWIN LUIS\r'),
(9241291, 'MARQUEZ', 'GUARAVIA', 'ROCIO DEL CARMEN\r'),
(9243300, 'TORREZ', 'ARUNI', 'JUAN GABRIEL\r'),
(9259568, 'VILLCA', 'LAIME', 'GUSTAVO ELVIS\r'),
(9870223, 'LIMACHI', 'CONDORI', 'ESTHER ALEJANDRA\r'),
(9877346, 'RONQUILLA', 'CHIPANA', 'GABRIELA ELIZABETH\r'),
(9881338, 'HELGUERO', 'VARGAS', 'PABLO VICENTE\r'),
(9895530, 'CARVAJAL', 'YUCRA', 'OSCAR GAUSS\r'),
(9933451, 'DURAN', 'QUISPE', 'CLISMAN\r'),
(10031207, 'SALINAS', 'FLORES', 'BLANCA ESTEFANY\r'),
(10039164, 'MAMANI', 'HUANCA', 'MIRIAM\r'),
(10069779, 'ANCARI', 'VILLCARANI', 'NOEMI ROSARIO\r'),
(10911896, 'CRUZ', 'MENDOZA', 'SEBASTIAN\r'),
(10913746, 'CORDERO', 'MAYDANA', 'XIMENA STEFANIA\r'),
(10914862, 'CHURA', 'CHOQUE', 'ARIEL SOCRATES\r'),
(10955552, 'MAMANI', 'CHOQUE', 'OLIVER CASIO\r'),
(11103108, 'ALVAREZ', 'QUISPE', 'WILMER FRANCO\r'),
(12514450, 'VARGAS', 'HILARI', 'MARILUZ\r');

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

--
-- Estructura de tabla para la tabla `historico`
--

CREATE TABLE `historico` (

`idhistorico` int(11) NOT NULL,
`cestudiante` int(11) DEFAULT NULL,
`periodo` varchar(7) COLLATE utf8_spanish2_ci DEFAULT NULL,
`sigla` varchar(7) COLLATE utf8_spanish2_ci DEFAULT NULL,
`n1p` int(11) DEFAULT NULL,
`n2p` int(11) DEFAULT NULL,
`nef` int(11) DEFAULT NULL,
`cdocente` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

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

INSERT INTO `historico` (`idhistorico`, `cestudiante`, `periodo`,

`sigla`, `n1p`, `n2p`, `nef`, `cdocente`) VALUES
(1, 3094450, 'I-2018', 'LAB-111', 8, 24, 11, 3452147),
(2, 3452262, 'I-2016', 'INF-111', 5, 5, 24, 5412485),
(3, 3534508, 'I-2016', 'INF-152', 2, 15, 42, 2541541),
(4, 4201314, 'I-2017', 'INF-153', 14, 9, 19, 3254124),
(5, 4299188, 'I-2019', 'LAB-111', 12, 20, 35, 3452147),
(6, 4317589, 'II-2017', 'LAB-131', 20, 6, 24, 3452147),
(7, 4329948, 'I-2019', 'LAB-111', 23, 18, 0, 3452147),
(8, 4339547, 'II-2016', 'LAB-131', 19, 2, 39, 3452147),
(9, 4369274, 'I-2016', 'INF-163', 1, 22, 29, 2254152),
(10, 4771404, 'I-2017', 'LAB-111', 13, 23, 5, 3452147),
(11, 4784615, 'II-2017', 'LAB-111', 25, 25, 46, 3452147),
(12, 4827291, 'I-2019', 'LAB-131', 8, 14, 40, 3452147),
(13, 4833757, 'I-2017', 'INF-272', 11, 4, 11, 3353362),
(14, 4844828, 'I-2016', 'INF-152', 23, 25, 30, 2541541),
(15, 4845628, 'I-2016', 'INF-152', 7, 2, 10, 2541541),
(16, 4849844, 'II-2019', 'INF-325', 4, 3, 49, 3353362),
(17, 4883329, 'I-2017', 'INF-163', 20, 8, 36, 2254152),
(18, 4913514, 'I-2017', 'INF-272', 8, 1, 39, 3353362),
(19, 4919045, 'II-2017', 'LAB-131', 5, 20, 41, 3452147),
(20, 4921802, 'II-2017', 'LAB-131', 11, 2, 31, 3452147),
(21, 4923886, 'II-2017', 'INF-273', 14, 10, 45, 4254178),
(22, 4980011, 'II-2017', 'LAB-131', 6, 16, 30, 3452147),
(23, 4982601, 'II-2016', 'INF-272', 5, 10, 24, 3353362),
(24, 4987909, 'I-2018', 'MAT-124', 4, 6, 5, 2542541),
(25, 4997781, 'II-2019', 'INF-163', 22, 21, 18, 2254152),
(26, 5476007, 'I-2018', 'INF-153', 10, 25, 37, 3254124),
(27, 5515122, 'I-2017', 'MAT-124', 16, 11, 46, 2542541),
(28, 5774320, 'I-2019', 'INF-163', 4, 13, 11, 2254152),
(29, 5799459, 'I-2017', 'INF-273', 10, 19, 36, 4254178),
(30, 5956925, 'II-2017', 'LAB-111', 4, 2, 10, 3452147),
(31, 5970844, 'I-2018', 'INF-152', 5, 22, 25, 2541541),
(32, 5974586, 'I-2016', 'LAB-111', 7, 11, 21, 3452147),
(33, 5977087, 'I-2018', 'INF-273', 4, 12, 0, 4254178),
(34, 6009256, 'I-2017', 'INF-111', 12, 12, 40, 5412485),
(35, 6028285, 'II-2019', 'INF-325', 22, 11, 30, 3353362),
(36, 6031754, 'II-2017', 'INF-273', 8, 17, 7, 4254178),
(37, 6035450, 'I-2018', 'INF-152', 13, 1, 47, 2541541),
(38, 6036159, 'II-2016', 'INF-163', 18, 12, 27, 2254152),
(39, 6043300, 'I-2017', 'INF-325', 20, 12, 0, 3353362),
(40, 6049466, 'I-2016', 'MAT-124', 0, 20, 31, 2542541),
(41, 6050328, 'I-2018', 'INF-272', 18, 4, 50, 3353362),
(42, 6059989, 'I-2018', 'INF-272', 3, 7, 38, 3353362),
(43, 6065458, 'I-2017', 'INF-152', 22, 7, 39, 2541541),
(44, 6072526, 'I-2017', 'INF-325', 19, 9, 29, 3353362),
(45, 6076486, 'I-2017', 'INF-111', 23, 17, 50, 5412485),
(46, 6077333, 'I-2018', 'INF-152', 25, 8, 10, 2541541),
(47, 6090930, 'II-2016', 'INF-272', 19, 25, 27, 3353362),
(48, 6095226, 'I-2018', 'INF-272', 7, 23, 2, 3353362),
(49, 6095399, 'I-2018', 'INF-325', 19, 2, 29, 3353362),
(50, 6102324, 'I-2019', 'LAB-131', 11, 23, 32, 3452147),
(51, 6104283, 'I-2017', 'LAB-111', 5, 22, 38, 3452147),
(52, 6118490, 'I-2019', 'MAT-124', 18, 17, 8, 2542541),
(53, 6121213, 'I-2018', 'INF-325', 22, 9, 32, 3353362),
(54, 6121235, 'II-2016', 'MAT-124', 17, 12, 49, 2542541),
(55, 6121828, 'I-2018', 'INF-272', 14, 25, 28, 3353362),
(56, 6134063, 'I-2016', 'INF-111', 16, 16, 46, 5412485),
(57, 6144520, 'II-2017', 'INF-152', 14, 13, 44, 2541541),
(58, 6177816, 'I-2016', 'LAB-111', 15, 5, 14, 3452147),
(59, 6192821, 'I-2016', 'INF-163', 16, 19, 35, 2254152),
(60, 6193953, 'I-2018', 'INF-163', 22, 2, 14, 2254152),
(61, 6593984, 'II-2016', 'INF-163', 4, 24, 49, 2254152),
(62, 6723295, 'I-2016', 'INF-325', 22, 10, 27, 3353362),
(63, 6728517, 'II-2017', 'INF-325', 8, 7, 22, 3353362),
(64, 6740649, 'II-2019', 'INF-152', 22, 9, 24, 2541541),
(65, 6740666, 'II-2017', 'INF-153', 25, 21, 18, 3254124),
(66, 6756865, 'I-2017', 'INF-272', 6, 20, 16, 3353362),
(67, 6774625, 'I-2017', 'INF-152', 12, 23, 45, 2541541),
(68, 6777238, 'I-2018', 'INF-273', 8, 19, 36, 4254178),
(69, 6780753, 'I-2017', 'LAB-131', 22, 6, 12, 3452147),
(70, 6791799, 'II-2019', 'INF-272', 14, 9, 31, 3353362),
(71, 6795129, 'I-2018', 'LAB-131', 0, 15, 20, 3452147),
(72, 6800356, 'I-2016', 'LAB-131', 11, 20, 3, 3452147),
(73, 6805843, 'II-2016', 'INF-153', 0, 11, 11, 3254124),
(74, 6806428, 'I-2019', 'INF-111', 4, 15, 11, 5412485),
(75, 6814635, 'I-2016', 'INF-325', 11, 14, 40, 3353362),
(76, 6815172, 'I-2016', 'INF-273', 10, 16, 42, 4254178),
(77, 6815511, 'I-2017', 'INF-152', 23, 18, 30, 2541541),
(78, 6822668, 'I-2018', 'INF-152', 17, 10, 31, 2541541),
(79, 6822713, 'II-2017', 'INF-273', 3, 3, 42, 4254178),
(80, 6825876, 'I-2017', 'INF-273', 21, 19, 15, 4254178),
(81, 6828070, 'I-2018', 'INF-163', 15, 4, 48, 2254152),
(82, 6848090, 'II-2016', 'INF-153', 6, 1, 15, 3254124),
(83, 6849347, 'I-2016', 'INF-163', 6, 11, 13, 2254152),
(84, 6861908, 'I-2019', 'INF-272', 23, 13, 35, 3353362),
(85, 6869952, 'I-2016', 'INF-325', 21, 9, 36, 3353362),
(86, 6870915, 'I-2018', 'INF-273', 10, 4, 20, 4254178),
(87, 6893912, 'I-2017', 'INF-163', 13, 23, 47, 2254152),
(88, 6901694, 'I-2016', 'INF-163', 3, 15, 40, 2254152),
(89, 6906907, 'I-2018', 'INF-273', 17, 2, 48, 4254178),
(90, 6933814, 'I-2016', 'INF-272', 9, 11, 20, 3353362),
(91, 6944713, 'II-2019', 'INF-153', 3, 2, 41, 3254124),
(92, 6944974, 'II-2016', 'LAB-111', 5, 1, 24, 3452147),
(93, 6945019, 'I-2018', 'LAB-111', 25, 10, 42, 3452147),
(94, 6949018, 'I-2018', 'INF-325', 11, 5, 5, 3353362),
(95, 6949345, 'I-2018', 'LAB-111', 25, 8, 16, 3452147),
(96, 6949509, 'I-2017', 'INF-163', 20, 14, 29, 2254152),
(97, 6952065, 'I-2018', 'INF-111', 12, 22, 16, 5412485),
(98, 6952136, 'II-2019', 'INF-152', 14, 11, 9, 2541541),
(99, 6953072, 'I-2018', 'INF-152', 12, 4, 33, 2541541),
(100, 6957806, 'I-2019', 'LAB-111', 2, 9, 11, 3452147),
(101, 6964266, 'II-2019', 'INF-153', 7, 23, 37, 3254124),
(102, 6966551, 'I-2019', 'INF-325', 8, 21, 46, 3353362),
(103, 6966635, 'I-2017', 'MAT-124', 22, 12, 44, 2542541),
(104, 6967776, 'I-2017', 'LAB-131', 8, 9, 25, 3452147),
(105, 6977723, 'I-2016', 'MAT-124', 3, 20, 13, 2542541),
(106, 6984167, 'II-2016', 'MAT-124', 2, 16, 26, 2542541),
(107, 6986015, 'II-2016', 'INF-163', 20, 2, 35, 2254152),
(108, 6989127, 'I-2018', 'INF-152', 21, 19, 49, 2541541),
(109, 6989279, 'I-2016', 'LAB-131', 14, 17, 6, 3452147),
(110, 6989918, 'II-2019', 'MAT-124', 14, 4, 12, 2542541),
(111, 6990604, 'II-2017', 'MAT-124', 3, 11, 47, 2542541),
(112, 6995817, 'II-2016', 'LAB-111', 23, 7, 50, 3452147),
(113, 6997876, 'I-2016', 'INF-272', 22, 13, 50, 3353362),
(114, 7005717, 'I-2016', 'INF-325', 25, 3, 15, 3353362),
(115, 7023913, 'II-2019', 'LAB-131', 19, 1, 31, 3452147),
(116, 7031954, 'I-2016', 'INF-273', 21, 12, 48, 4254178),
(117, 7032430, 'I-2018', 'MAT-124', 9, 15, 24, 2542541),
(118, 7039950, 'II-2017', 'INF-325', 5, 18, 25, 3353362),
(119, 7041686, 'I-2016', 'LAB-131', 6, 22, 30, 3452147),
(120, 7046747, 'I-2017', 'LAB-111', 13, 2, 25, 3452147),
(121, 7047036, 'I-2016', 'INF-325', 10, 0, 35, 3353362),
(122, 7048181, 'I-2019', 'LAB-131', 19, 14, 39, 3452147),
(123, 7051670, 'I-2018', 'INF-153', 11, 2, 49, 3254124),
(124, 7058903, 'I-2019', 'INF-111', 0, 8, 21, 5412485),
(125, 7059562, 'I-2018', 'INF-111', 13, 6, 15, 5412485),
(126, 7061467, 'II-2017', 'INF-272', 17, 19, 44, 3353362),
(127, 7063050, 'I-2016', 'INF-153', 11, 11, 6, 3254124),
(128, 7065040, 'I-2016', 'INF-153', 5, 8, 21, 3254124),
(129, 7066887, 'I-2018', 'MAT-124', 23, 14, 27, 2542541),
(130, 7071807, 'II-2016', 'INF-273', 4, 13, 25, 4254178),
(131, 7072041, 'II-2019', 'INF-273', 17, 11, 46, 4254178),
(132, 7073610, 'I-2016', 'INF-111', 19, 10, 1, 5412485),
(133, 7284636, 'II-2019', 'INF-153', 3, 5, 44, 3254124),
(134, 8105954, 'I-2017', 'INF-152', 19, 19, 50, 2541541),
(135, 8264146, 'I-2017', 'LAB-111', 5, 12, 27, 3452147),
(136, 8264427, 'I-2019', 'INF-273', 15, 17, 26, 4254178),
(137, 8287377, 'I-2016', 'INF-272', 0, 20, 47, 3353362),
(138, 8300134, 'II-2017', 'INF-152', 0, 4, 47, 2541541),
(139, 8302495, 'II-2019', 'MAT-124', 17, 23, 49, 2542541),
(140, 8302680, 'I-2017', 'INF-111', 1, 18, 24, 5412485),
(141, 8303797, 'II-2017', 'INF-325', 20, 17, 8, 3353362),
(142, 8303892, 'I-2017', 'LAB-131', 18, 24, 9, 3452147),
(143, 8304469, 'I-2018', 'INF-163', 2, 4, 42, 2254152),
(144, 8306113, 'II-2019', 'INF-111', 14, 6, 31, 5412485),
(145, 8310947, 'I-2017', 'INF-325', 7, 23, 26, 3353362),
(146, 8313157, 'II-2019', 'INF-153', 21, 22, 32, 3254124),
(147, 8314445, 'II-2016', 'INF-272', 24, 3, 6, 3353362),
(148, 8315048, 'II-2017', 'INF-152', 25, 12, 32, 2541541),
(149, 8317846, 'I-2016', 'LAB-111', 24, 0, 19, 3452147),
(150, 8321008, 'I-2017', 'LAB-131', 12, 15, 37, 3452147),
(151, 8322827, 'II-2016', 'INF-272', 7, 6, 19, 3353362),
(152, 8323573, 'I-2017', 'MAT-124', 10, 18, 42, 2542541),
(153, 8323779, 'I-2016', 'INF-272', 23, 18, 16, 3353362),
(154, 8324817, 'I-2018', 'INF-163', 4, 12, 17, 2254152),
(155, 8326617, 'I-2016', 'INF-163', 6, 14, 6, 2254152),
(156, 8330408, 'I-2018', 'LAB-111', 16, 3, 4, 3452147),
(157, 8331867, 'II-2019', 'LAB-131', 9, 1, 9, 3452147),
(158, 8334408, 'I-2017', 'INF-273', 1, 24, 37, 4254178),
(159, 8334857, 'I-2019', 'INF-163', 5, 21, 43, 2254152),
(160, 8337674, 'II-2019', 'MAT-124', 21, 18, 48, 2542541),
(161, 8340433, 'I-2017', 'INF-152', 25, 1, 36, 2541541),
(162, 8341010, 'I-2017', 'INF-163', 10, 2, 6, 2254152),
(163, 8343146, 'I-2016', 'INF-325', 9, 15, 45, 3353362),
(164, 8344694, 'I-2019', 'INF-153', 9, 11, 37, 3254124),
(165, 8345147, 'I-2018', 'INF-152', 6, 9, 7, 2541541),
(166, 8346057, 'I-2017', 'INF-152', 1, 9, 29, 2541541),
(167, 8346420, 'I-2018', 'INF-273', 22, 14, 47, 4254178),
(168, 8347690, 'II-2016', 'LAB-131', 3, 3, 2, 3452147),
(169, 8349252, 'II-2017', 'LAB-111', 11, 4, 42, 3452147),
(170, 8350017, 'I-2016', 'INF-325', 11, 1, 21, 3353362),
(171, 8351469, 'II-2016', 'INF-152', 23, 1, 29, 2541541),
(172, 8353931, 'II-2019', 'INF-152', 6, 13, 25, 2541541),
(173, 8360501, 'I-2016', 'LAB-131', 12, 16, 41, 3452147),
(174, 8362926, 'I-2018', 'INF-153', 22, 18, 3, 3254124),
(175, 8363750, 'I-2016', 'MAT-124', 18, 12, 22, 2542541),
(176, 8364758, 'I-2019', 'LAB-111', 10, 5, 39, 3452147),
(177, 8369536, 'I-2017', 'INF-273', 19, 25, 3, 4254178),
(178, 8383914, 'I-2019', 'INF-153', 13, 3, 31, 3254124),
(179, 8387204, 'I-2017', 'INF-153', 25, 13, 15, 3254124),
(180, 8392126, 'I-2017', 'INF-152', 7, 11, 40, 2541541),
(181, 8398945, 'II-2016', 'INF-153', 16, 18, 27, 3254124),
(182, 8402328, 'I-2018', 'INF-152', 21, 5, 9, 2541541),
(183, 8402645, 'II-2019', 'INF-273', 21, 2, 24, 4254178),
(184, 8410497, 'I-2019', 'INF-152', 24, 19, 29, 2541541),
(185, 8420758, 'I-2017', 'INF-163', 20, 7, 5, 2254152),
(186, 8421503, 'I-2018', 'LAB-111', 20, 11, 26, 3452147),
(187, 8433144, 'II-2016', 'INF-325', 15, 22, 35, 3353362),
(188, 8442805, 'I-2018', 'INF-111', 20, 13, 26, 5412485),
(189, 8444602, 'I-2019', 'INF-111', 3, 20, 1, 5412485),
(190, 8445604, 'I-2016', 'INF-272', 13, 25, 3, 3353362),
(191, 8464476, 'I-2017', 'LAB-131', 18, 5, 39, 3452147),
(192, 8468662, 'I-2019', 'INF-153', 22, 13, 31, 3254124),
(193, 8469272, 'I-2016', 'MAT-124', 2, 24, 29, 2542541),
(194, 9087901, 'I-2018', 'INF-152', 24, 7, 9, 2541541),
(195, 9099740, 'II-2019', 'INF-153', 17, 4, 25, 3254124),
(196, 9100539, 'II-2016', 'INF-153', 5, 22, 5, 3254124),
(197, 9103168, 'II-2017', 'INF-163', 2, 11, 39, 2254152),
(198, 9103275, 'I-2016', 'INF-153', 0, 2, 10, 3254124),
(199, 9110020, 'I-2016', 'INF-152', 10, 13, 30, 2541541),
(200, 9113846, 'I-2016', 'LAB-111', 13, 7, 9, 3452147),
(201, 9129050, 'I-2018', 'LAB-111', 19, 3, 47, 3452147),
(202, 9169954, 'II-2016', 'INF-273', 8, 12, 1, 4254178),
(203, 9170991, 'I-2019', 'INF-272', 25, 10, 17, 3353362),
(204, 9179201, 'I-2017', 'MAT-124', 1, 2, 44, 2542541),
(205, 9189645, 'I-2016', 'INF-272', 16, 4, 39, 3353362),
(206, 9201368, 'I-2019', 'INF-163', 20, 14, 36, 2254152),
(207, 9209906, 'I-2018', 'LAB-131', 17, 6, 0, 3452147),
(208, 9214751, 'I-2016', 'INF-163', 17, 5, 14, 2254152),
(209, 9228002, 'I-2017', 'INF-273', 13, 2, 25, 4254178),
(210, 9241291, 'II-2019', 'INF-163', 23, 12, 0, 2254152),
(211, 9243300, 'I-2019', 'INF-111', 4, 18, 38, 5412485),
(212, 9259568, 'I-2016', 'LAB-131', 5, 24, 45, 3452147),
(213, 9870223, 'II-2019', 'INF-273', 24, 14, 10, 4254178),
(214, 9877346, 'I-2017', 'INF-152', 12, 19, 16, 2541541),
(215, 9881338, 'II-2016', 'INF-273', 9, 22, 8, 4254178),
(216, 9895530, 'I-2017', 'INF-111', 15, 22, 4, 5412485),
(217, 9933451, 'II-2016', 'INF-325', 24, 22, 34, 3353362),
(218, 10031207, 'II-2019', 'MAT-124', 13, 15, 2, 2542541),
(219, 10039164, 'I-2017', 'INF-272', 6, 1, 14, 3353362),
(220, 10069779, 'I-2016', 'LAB-131', 12, 24, 46, 3452147),
(221, 10911896, 'I-2016', 'INF-273', 4, 25, 28, 4254178),
(222, 10913746, 'II-2017', 'INF-152', 23, 11, 10, 2541541),
(223, 10914862, 'II-2017', 'INF-273', 11, 1, 22, 4254178),
(224, 10955552, 'I-2018', 'MAT-124', 4, 15, 48, 2542541),
(225, 11103108, 'I-2017', 'MAT-124', 10, 5, 0, 2542541),
(226, 12514450, 'I-2018', 'INF-152', 18, 12, 20, 2541541);

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

--
-- Estructura de tabla para la tabla `inscritos`
--

CREATE TABLE `inscritos` (

`ci` int(11) NOT NULL,
`ex` varchar(2) COLLATE utf8_spanish2_ci DEFAULT NULL,
`nombres` varchar(30) COLLATE utf8_spanish2_ci DEFAULT NULL,
`paterno` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL,
`materno` varchar(25) COLLATE utf8_spanish2_ci DEFAULT NULL,
`sexo` varchar(10) COLLATE utf8_spanish2_ci DEFAULT NULL,
`nacimiento` date DEFAULT NULL,
`email` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL,
`foto` varchar(30) COLLATE utf8_spanish2_ci DEFAULT NULL,
`documentos` varchar(30) COLLATE utf8_spanish2_ci DEFAULT NULL,
`nacionalidad` varchar(15) COLLATE utf8_spanish2_ci DEFAULT NULL,
`telefonoCelular` varchar(20) COLLATE utf8_spanish2_ci DEFAULT NULL,
`zona` varchar(30) COLLATE utf8_spanish2_ci DEFAULT NULL,
`calleAvenida` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL,
`noDomicilio` varchar(20) COLLATE utf8_spanish2_ci DEFAULT NULL,
`bachiller` varchar(2) COLLATE utf8_spanish2_ci DEFAULT NULL,
`colegio` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL,
 `tipocolegio` varchar(20) COLLATE utf8_spanish2_ci DEFAULT NULL,
`gestion` varchar(4) COLLATE utf8_spanish2_ci DEFAULT NULL,
`clave` varchar(15) COLLATE utf8_spanish2_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

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

INSERT INTO `inscritos` (`ci`, `ex`, `nombres`, `paterno`, `materno`,

`sexo`, `nacimiento`, `email`, `foto`, `documentos`, `nacionalidad`,
`telefonoCelular`, `zona`, `calleAvenida`, `noDomicilio`, `bachiller`,
`colegio`, `tipocolegio`, `gestion`, `clave`) VALUES
(666, 'LP', 'Joaquin', 'Santana', 'Lopez', 'MASCULINO', '1990-09-09',
'jsantana@gmail.com', 'fotomayte.jpg', 'FISICA.png', 'BOLIVIANA',
'71536276', 'San Pedro', 'Los Angeles', '325', 'NO', 'Amerinst',
'PARTICULAR', '2020', 'Registrado');

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

--
-- Estructura de tabla para la tabla `materias`
--

CREATE TABLE `materias` (

`sigla` varchar(7) COLLATE utf8_spanish2_ci NOT NULL,
`descripcion` varchar(50) COLLATE utf8_spanish2_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

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

INSERT INTO `materias` (`sigla`, `descripcion`) VALUES

('INF-111', 'INTRODUCCIÓN INFORMÁTICA'),
('INF-152', 'SISTEMAS DE INFORMACIÓN\r'),
('INF-153', 'ASSEMBLER\r'),
('INF-163', 'INGENIERÍA DE SOFTWARE\r'),
('INF-272', 'TALLER DE BASE DE DATOS\r'),
('INF-273', 'TELEMÁTICA\r'),
('INF-325', 'PROGRAMACIÓN VIRTUAL\r'),
('LAB-111', 'LABORATORIO DE INF-111\r'),
('LAB-131', 'LABORATORIO DE INF-131\r'),
('MAT-124', 'ALGEBRA LINEAL\r');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `docentes`
--
ALTER TABLE `docentes`
ADD PRIMARY KEY (`carnet`);

--
-- Indices de la tabla `estudiantes`
--
ALTER TABLE `estudiantes`
ADD PRIMARY KEY (`carnet`);

--
-- Indices de la tabla `historico`
--
ALTER TABLE `historico`
ADD PRIMARY KEY (`idhistorico`),
ADD KEY `cestudiante` (`cestudiante`),
ADD KEY `sigla` (`sigla`),
ADD KEY `cdocente` (`cdocente`);

--
-- Indices de la tabla `inscritos`
--
ALTER TABLE `inscritos`
ADD PRIMARY KEY (`ci`);

--
-- Indices de la tabla `materias`
--
ALTER TABLE `materias`
ADD PRIMARY KEY (`sigla`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `historico`
--
ALTER TABLE `historico`
MODIFY `idhistorico` int(11) NOT NULL AUTO_INCREMENT,
AUTO_INCREMENT=227;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `historico`
--
ALTER TABLE `historico`
ADD CONSTRAINT `historico_ibfk_1` FOREIGN KEY (`cestudiante`)
REFERENCES `estudiantes` (`carnet`),
ADD CONSTRAINT `historico_ibfk_2` FOREIGN KEY (`sigla`) REFERENCES
`materias` (`sigla`),
ADD CONSTRAINT `historico_ibfk_3` FOREIGN KEY (`cdocente`)
REFERENCES `docentes` (`carnet`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;