_datos_db.sql

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 19-01-2023 a las 19:24:54
-- Versión del servidor: 10.4.27-MariaDB
-- Versión de PHP: 8.0.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `eg`
--

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

INSERT INTO `periodos` (`inicio`, `fin`) VALUES
('2023-01-01',	'2023-12-31');

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

INSERT INTO `comision` (`id`, `numero`) VALUES
(21, '1K01'),
(22, '1K02'),
(23, '1K03'),
(24, '1K04'),
(25, '1K05'),
(26, '1K06'),
(27, '1K07'),
(28, '1K08'),
(29, '1K09'),
(30, '1K10'),
(31, '1K11'),
(32, '1K12'),
(33, '1K13'),
(34, '2K01'),
(35, '2K02'),
(36, '2K03'),
(37, '2K04'),
(38, '2K05'),
(39, '2K06'),
(40, '2K07'),
(41, '2K08'),
(42, '3K01'),
(43, '3K02'),
(44, '3K03'),
(45, '3K04'),
(46, '3K05'),
(48, '401'),
(49, '402'),
(50, '403'),
(51, '404'),
(52, '501'),
(53, '502'),
(54, '503');

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

INSERT INTO `materia` (`id`, `nombre`) VALUES
(3, 'Gestión de Datos'),
(5, 'Proyecto Final'),
(6, 'Administracion Gerencial'),
(7, 'Sistemas de Gestion'),
(8, 'Teoria de Control'),
(9, 'Administracion de Recursos'),
(10, 'Investigacion Operativa'),
(11, 'Comunicaciones'),
(12, 'Legislacion'),
(13, 'Redes de Informacion'),
(14, 'Ingenieria de Software'),
(15, 'Analisis Numerico'),
(16, 'Economia'),
(17, 'Probabilidad y Estadistica'),
(18, 'Analisis de Sistemas de Informacion'),
(19, 'Analisis Matematico II'),
(20, 'Analisis Matematico I'),
(21, 'Fisica I'),
(22, 'Fisica II'),
(23, 'Sintaxis y Semantica de los Lenguajes'),
(24, 'Ingenieria y Sociedad'),
(25, 'Paradigmas de Programacion'),
(26, 'Sistemas Operativos'),
(27, 'Ingles I'),
(28, 'Arquitectura de Computadoras'),
(29, 'Algoritmos y Estructuras de Datos'),
(30, 'Logica y Estructuras Discretas'),
(31, 'Sistemas y Procesos de Negocio'),
(32, 'Algebra y Geometria Analitica'),
(33, 'Disenio de Sistemas de Informacion'),
(34, 'Simulacion'),
(35, 'Inteligencia Artificial');

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

INSERT INTO `materia_x_comision` (`id`, `materia_id`, `comision_id`) VALUES
(8, 27, 28),
(9, 28, 28),
(10, 29, 28),
(12, 31, 28),
(14, 28, 21),
(15, 28, 22),
(16, 28, 23),
(17, 28, 24),
(18, 28, 25),
(19, 28, 26),
(20, 28, 27),
(21, 28, 28),
(22, 28, 29),
(23, 28, 30),
(24, 28, 31),
(25, 28, 32),
(26, 28, 33),
(27, 27, 21),
(28, 27, 22),
(29, 27, 23),
(30, 27, 24),
(31, 27, 25),
(32, 27, 26),
(33, 27, 27),
(34, 27, 28),
(35, 27, 29),
(36, 27, 30),
(37, 27, 31),
(38, 27, 32),
(39, 27, 33),
(40, 20, 21),
(41, 20, 22),
(42, 20, 23),
(43, 20, 24),
(44, 20, 25),
(45, 20, 26),
(46, 20, 27),
(47, 20, 28),
(48, 20, 29),
(49, 20, 30),
(50, 20, 31),
(51, 20, 32),
(52, 20, 33),
(53, 31, 21),
(54, 31, 22),
(55, 31, 23),
(56, 31, 24),
(57, 31, 25),
(58, 31, 26),
(59, 31, 27),
(60, 31, 28),
(61, 31, 29),
(62, 31, 30),
(63, 31, 31),
(64, 31, 32),
(65, 31, 33),
(66, 29, 21),
(67, 29, 22),
(68, 29, 23),
(69, 29, 24),
(70, 29, 25),
(71, 29, 26),
(72, 29, 27),
(73, 29, 28),
(74, 29, 29),
(75, 29, 30),
(76, 29, 31),
(77, 29, 32),
(78, 29, 33),
(79, 21, 21),
(80, 21, 22),
(81, 21, 23),
(82, 21, 24),
(83, 21, 25),
(84, 21, 26),
(85, 21, 27),
(86, 21, 28),
(87, 21, 29),
(88, 21, 30),
(89, 21, 31),
(90, 21, 32),
(91, 21, 33),
(92, 32, 21),
(93, 32, 22),
(94, 32, 23),
(95, 32, 24),
(96, 32, 25),
(97, 32, 26),
(98, 32, 27),
(99, 32, 28),
(100, 32, 29),
(101, 32, 30),
(102, 32, 31),
(103, 32, 32),
(104, 32, 33),
(105, 30, 21),
(106, 30, 22),
(107, 30, 23),
(108, 30, 24),
(109, 30, 25),
(110, 30, 26),
(111, 30, 27),
(112, 30, 28),
(113, 30, 29),
(114, 30, 30),
(115, 30, 31),
(116, 30, 32),
(117, 30, 33),
(118, 18, 34),
(119, 18, 35),
(120, 18, 36),
(121, 18, 37),
(122, 18, 38),
(123, 18, 39),
(124, 18, 40),
(125, 18, 41),
(126, 24, 34),
(127, 24, 35),
(128, 24, 36),
(129, 24, 37),
(130, 24, 38),
(131, 24, 39),
(132, 24, 40),
(133, 24, 41),
(134, 19, 34),
(135, 19, 35),
(136, 19, 36),
(137, 19, 37),
(138, 19, 38),
(139, 19, 39),
(140, 19, 40),
(141, 19, 41),
(142, 23, 34),
(143, 23, 35),
(144, 23, 36),
(145, 23, 37),
(146, 23, 38),
(147, 23, 39),
(148, 23, 40),
(149, 23, 41),
(150, 22, 34),
(151, 22, 35),
(152, 22, 36),
(153, 22, 37),
(154, 22, 38),
(155, 22, 39),
(156, 22, 40),
(157, 22, 41),
(158, 26, 34),
(159, 26, 35),
(160, 26, 36),
(161, 26, 37),
(162, 26, 38),
(163, 26, 39),
(164, 26, 40),
(165, 26, 41),
(166, 25, 34),
(167, 25, 35),
(168, 25, 36),
(169, 25, 37),
(170, 25, 38),
(171, 25, 39),
(172, 25, 40),
(173, 25, 41),
(174, 11, 42),
(175, 11, 43),
(176, 11, 44),
(177, 11, 45),
(178, 11, 46),
(179, 15, 42),
(180, 15, 43),
(181, 15, 44),
(182, 15, 45),
(183, 15, 46),
(184, 33, 42),
(185, 33, 43),
(186, 33, 44),
(187, 33, 45),
(188, 33, 46),
(189, 3, 42),
(190, 3, 43),
(191, 3, 44),
(192, 3, 45),
(193, 3, 46),
(194, 16, 42),
(195, 16, 43),
(196, 16, 44),
(197, 16, 45),
(198, 16, 46),
(199, 10, 48),
(200, 10, 49),
(201, 10, 50),
(202, 10, 51),
(203, 9, 48),
(204, 9, 49),
(205, 9, 50),
(206, 9, 51),
(207, 34, 48),
(208, 34, 49),
(209, 34, 50),
(210, 34, 51),
(211, 12, 48),
(212, 12, 49),
(213, 12, 50),
(214, 12, 51),
(215, 13, 48),
(216, 13, 49),
(217, 13, 50),
(218, 13, 51),
(219, 8, 48),
(220, 8, 49),
(221, 8, 50),
(222, 8, 51),
(223, 14, 48),
(224, 14, 49),
(225, 14, 50),
(226, 14, 51),
(227, 5, 52),
(228, 5, 53),
(229, 5, 54),
(230, 6, 52),
(231, 6, 53),
(232, 6, 54),
(233, 7, 52),
(234, 7, 53),
(235, 7, 54),
(236, 35, 52),
(237, 35, 53),
(238, 35, 54);