nucleo/Acceso_QR
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
Acceso_QR/acceso.sql
Antonio Espiritu f5dcfba2b6 carga 
carga
2025-04-17 00:18:43 -06:00

1033 lines
51 KiB
SQL
Raw Permalink Blame History

-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 25-07-2022 a las 03:15:55
-- Versión del servidor: 8.0.17
-- Versión de PHP: 7.3.10
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: `acceso`
--
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `autenticacion_perfil`
--
CREATE TABLE `autenticacion_perfil` (
`id` bigint(20) NOT NULL,
`matricula` varchar(50) COLLATE utf8_spanish_ci NOT NULL,
`cuatrimestre` varchar(2) COLLATE utf8_spanish_ci NOT NULL,
`grupo` varchar(1) COLLATE utf8_spanish_ci NOT NULL,
`direccion` varchar(250) COLLATE utf8_spanish_ci DEFAULT NULL,
`telefono` varchar(15) COLLATE utf8_spanish_ci DEFAULT NULL,
`genero` varchar(1) COLLATE utf8_spanish_ci NOT NULL,
`foto` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`qr` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`fecha_alta` date NOT NULL,
`fecha_actualizacion` date NOT NULL,
`id_carrera_id` bigint(20) NOT NULL,
`usuario_id` int(11) DEFAULT NULL,
`tipo` varchar(20) COLLATE utf8_spanish_ci NOT NULL,
`key` varchar(250) COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `autenticacion_perfil`
--
INSERT INTO `autenticacion_perfil` (`id`, `matricula`, `cuatrimestre`, `grupo`, `direccion`, `telefono`, `genero`, `foto`, `qr`, `fecha_alta`, `fecha_actualizacion`, `id_carrera_id`, `usuario_id`, `tipo`, `key`) VALUES
(1, '193474', '9', 'A', 'tapachula', '9622398378', 'M', 'foto/cat.jpg', 'qr/193474qr_BT0CvO3.png', '2022-07-19', '2022-07-21', 1, 1, 'Estudiante', 'pbkdf2sha25632000087G8TKpJcLIN3vMzpvA5yiPIgQwkAPCKLYIbVEOsB3PFmaaO7ZhWlVsQcpEXU1'),
(8, '193391', '9', 'A', 'La Antorcha', '9621127773', 'F', 'foto/CV.png', 'qr/193391qr.png', '2022-07-19', '2022-07-19', 1, 3, 'Estudiante', NULL),
(9, '193308', '9', 'A', 'Primera Sur', '8278434734', 'M', 'foto/icon-5359553_960_720.webp', 'qr/193308qr.png', '2022-07-20', '2022-07-24', 1, 4, 'Estudiante', 'pbkdf2sha256320000dSejTXFvE1jlQgJmpTzAAov8ht1YzXd5dJxBXlCUaF7y8HxgEdy0Rlz9mXk4gnJiw4'),
(13, '1934744', '9', 'A', 'tap', '962', 'M', 'foto/icon-transparent_4ujvLJf.png', 'qr/1934744qr.png', '2022-07-20', '2022-07-21', 1, 2, 'Estudiante', 'pbkdf2_sha256$320000$2QexdsPpwVf45uOwiWig6z$p6Vjo56JmK8udDtTh656Pyc2wBoys/2yXNyMBw++BE4='),
(15, '321654', '9', 'A', 'tap', '962', 'M', 'foto/FB_IMG_1503895826749.jpg', 'qr/321654qr_p6T3pjR.png', '2022-07-21', '2022-07-22', 1, 5, 'Estudiante', 'pbkdf2sha256320000R9deayRQ0uuQfOVRBIiX6f1x6PdnV1aAkVc0AvWjEwwEHKIefZOil0LzsgMu0KE5');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `auth_group`
--
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL,
`name` varchar(150) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `auth_group_permissions`
--
CREATE TABLE `auth_group_permissions` (
`id` bigint(20) NOT NULL,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `auth_permission`
--
CREATE TABLE `auth_permission` (
`id` int(11) NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `auth_permission`
--
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES
(1, 'Can add log entry', 1, 'add_logentry'),
(2, 'Can change log entry', 1, 'change_logentry'),
(3, 'Can delete log entry', 1, 'delete_logentry'),
(4, 'Can view log entry', 1, 'view_logentry'),
(5, 'Can add permission', 2, 'add_permission'),
(6, 'Can change permission', 2, 'change_permission'),
(7, 'Can delete permission', 2, 'delete_permission'),
(8, 'Can view permission', 2, 'view_permission'),
(9, 'Can add group', 3, 'add_group'),
(10, 'Can change group', 3, 'change_group'),
(11, 'Can delete group', 3, 'delete_group'),
(12, 'Can view group', 3, 'view_group'),
(13, 'Can add user', 4, 'add_user'),
(14, 'Can change user', 4, 'change_user'),
(15, 'Can delete user', 4, 'delete_user'),
(16, 'Can view user', 4, 'view_user'),
(17, 'Can add content type', 5, 'add_contenttype'),
(18, 'Can change content type', 5, 'change_contenttype'),
(19, 'Can delete content type', 5, 'delete_contenttype'),
(20, 'Can view content type', 5, 'view_contenttype'),
(21, 'Can add session', 6, 'add_session'),
(22, 'Can change session', 6, 'change_session'),
(23, 'Can delete session', 6, 'delete_session'),
(24, 'Can view session', 6, 'view_session'),
(25, 'Can add perfil', 7, 'add_perfil'),
(26, 'Can change perfil', 7, 'change_perfil'),
(27, 'Can delete perfil', 7, 'delete_perfil'),
(28, 'Can view perfil', 7, 'view_perfil'),
(29, 'Can add asignatura', 8, 'add_asignatura'),
(30, 'Can change asignatura', 8, 'change_asignatura'),
(31, 'Can delete asignatura', 8, 'delete_asignatura'),
(32, 'Can view asignatura', 8, 'view_asignatura'),
(33, 'Can add laboratorio', 9, 'add_laboratorio'),
(34, 'Can change laboratorio', 9, 'change_laboratorio'),
(35, 'Can delete laboratorio', 9, 'delete_laboratorio'),
(36, 'Can view laboratorio', 9, 'view_laboratorio'),
(37, 'Can add area', 10, 'add_area'),
(38, 'Can change area', 10, 'change_area'),
(39, 'Can delete area', 10, 'delete_area'),
(40, 'Can view area', 10, 'view_area'),
(41, 'Can add material', 11, 'add_material'),
(42, 'Can change material', 11, 'change_material'),
(43, 'Can delete material', 11, 'delete_material'),
(44, 'Can view material', 11, 'view_material'),
(45, 'Can add carrera', 12, 'add_carrera'),
(46, 'Can change carrera', 12, 'change_carrera'),
(47, 'Can delete carrera', 12, 'delete_carrera'),
(48, 'Can view carrera', 12, 'view_carrera'),
(49, 'Can add laboratorio', 13, 'add_lab'),
(50, 'Can change laboratorio', 13, 'change_lab'),
(51, 'Can delete laboratorio', 13, 'delete_lab'),
(52, 'Can view laboratorio', 13, 'view_lab'),
(53, 'Can add Laboratorio de cómputo y redes', 14, 'add_labcomputo'),
(54, 'Can change Laboratorio de cómputo y redes', 14, 'change_labcomputo'),
(55, 'Can delete Laboratorio de cómputo y redes', 14, 'delete_labcomputo'),
(56, 'Can view Laboratorio de cómputo y redes', 14, 'view_labcomputo');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `auth_user`
--
CREATE TABLE `auth_user` (
`id` int(11) NOT NULL,
`password` varchar(128) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`last_login` datetime(6) DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`first_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`last_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`email` varchar(254) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `auth_user`
--
INSERT INTO `auth_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `email`, `is_staff`, `is_active`, `date_joined`) VALUES
(1, 'pbkdf2_sha256$320000$87G8TKpJcLIN3vMzpvA5yi$PI/gQwkAPCKLY+IbVEOsB3PFmaa+O7ZhWlVsQcp+EXU=', '2022-07-24 21:40:22.837246', 1, 'nucleo', 'Ramon', 'Espiritu', 's.i.g.nucleo@gmail.com', 1, 1, '2022-06-22 18:37:09.920348'),
(2, 'pbkdf2_sha256$320000$2QexdsPpwVf45uOwiWig6z$p6Vjo56JmK8udDtTh656Pyc2wBoys/2yXNyMBw++BE4=', '2022-07-21 04:53:20.413577', 0, 'espiritu', 'antonio', 'espiritu', 'antonio.spiritu@gmail.com', 0, 1, '2022-07-19 01:10:04.367383'),
(3, 'pbkdf2_sha256$320000$cjHxk2wxIyAerjFsXsHa4P$NRce/5RphSGfzjKxD1uSzEqtbk6OoL+j5NTG5EkCKw4=', '2022-07-24 22:04:53.254198', 1, '193391', 'Kristell Damaris', 'Mendoza López', 'dama.mendoza456@gmail.com', 1, 1, '2022-07-19 19:55:21.347205'),
(4, 'pbkdf2_sha256$320000$dSejTXFvE1jlQgJmpTzAAo$v8ht1YzXd5dJxBXlCUaF7y8HxgEdy0Rlz9mXk4gnJiw=', '2022-07-24 17:06:42.127355', 1, '@Usuario', 'UsuarioNombre', 'UsarioApellidos', 'sotere4637@leupus.com', 1, 1, '2022-07-20 21:46:29.369336'),
(5, 'pbkdf2_sha256$320000$R9deayRQ0uuQfOVRBIiX6f$1x6PdnV1aAkVc0A+vWjEwwEHKI/efZOil0LzsgMu0KE=', '2022-07-22 07:24:19.405684', 0, 'prueba', 'prueba', 'prueba', 'central_tap@hotmail.com', 0, 1, '2022-07-21 05:21:54.507547');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `auth_user_groups`
--
CREATE TABLE `auth_user_groups` (
`id` bigint(20) NOT NULL,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `auth_user_user_permissions`
--
CREATE TABLE `auth_user_user_permissions` (
`id` bigint(20) NOT NULL,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `django_admin_log`
--
CREATE TABLE `django_admin_log` (
`id` int(11) NOT NULL,
`action_time` datetime(6) NOT NULL,
`object_id` longtext CHARACTER SET utf8 COLLATE utf8_spanish_ci,
`object_repr` varchar(200) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`action_flag` smallint(5) UNSIGNED NOT NULL,
`change_message` longtext CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`content_type_id` int(11) DEFAULT NULL,
`user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `django_admin_log`
--
INSERT INTO `django_admin_log` (`id`, `action_time`, `object_id`, `object_repr`, `action_flag`, `change_message`, `content_type_id`, `user_id`) VALUES
(1, '2022-07-19 05:43:05.190163', '1', 'Software', 1, '[{\"added\": {}}]', 12, 1),
(2, '2022-07-19 20:48:55.752760', '1', 'Ingeniería de Software', 2, '[{\"changed\": {\"fields\": [\"Nombre\"]}}]', 12, 1),
(3, '2022-07-19 20:49:14.821967', '2', 'Ingeniería Agroindustrial', 1, '[{\"added\": {}}]', 12, 1),
(4, '2022-07-19 20:49:24.670308', '3', 'Ingeniería en Animación y Efectos Visuales', 1, '[{\"added\": {}}]', 12, 1),
(5, '2022-07-19 20:49:37.721132', '4', 'Ingeniería en Energía', 1, '[{\"added\": {}}]', 12, 1),
(6, '2022-07-19 20:49:45.863495', '5', 'Ingeniería en Logística y Transporte', 1, '[{\"added\": {}}]', 12, 1),
(7, '2022-07-19 20:49:59.683734', '6', 'Ingeniería en Nanotecnología', 1, '[{\"added\": {}}]', 12, 1),
(8, '2022-07-19 20:50:08.597226', '7', 'Ingeniería en Sistemas Automotrices', 1, '[{\"added\": {}}]', 12, 1),
(9, '2022-07-19 20:50:16.027959', '8', 'Ingeniería en Tecnología Ambiental', 1, '[{\"added\": {}}]', 12, 1),
(10, '2022-07-19 20:50:23.486661', '9', 'Ingeniería Financiera', 1, '[{\"added\": {}}]', 12, 1),
(11, '2022-07-19 20:50:32.566936', '10', 'Ingeniería Mecatrónica', 1, '[{\"added\": {}}]', 12, 1),
(12, '2022-07-19 21:39:30.773149', '1', 'Laboratorio de automatización', 1, '[{\"added\": {}}]', 9, 3),
(13, '2022-07-19 21:40:40.248615', '2', 'Laboratorio de cómputo y redes', 1, '[{\"added\": {}}]', 9, 3),
(14, '2022-07-19 21:41:03.380617', '3', 'Cabina de audio', 1, '[{\"added\": {}}]', 9, 3),
(15, '2022-07-19 21:41:26.785161', '4', 'Laboratorio internet de las cosas', 1, '[{\"added\": {}}]', 9, 3),
(16, '2022-07-19 21:41:49.637338', '5', 'Laboratorio de frutas y hortalizas', 1, '[{\"added\": {}}]', 9, 3),
(17, '2022-07-19 21:50:23.961721', '1', 'Diseño 3D', 1, '[{\"added\": {}}]', 10, 3),
(18, '2022-07-19 21:50:55.489600', '2', 'Sala de ciencias 3D', 1, '[{\"added\": {}}]', 10, 3),
(19, '2022-07-19 21:51:32.055727', '3', 'Brazos robóticos', 1, '[{\"added\": {}}]', 10, 3),
(20, '2022-07-21 04:04:18.735001', '13', 'eaer831126', 2, '[{\"changed\": {\"fields\": [\"Foto\"]}}]', 7, 1),
(21, '2022-07-23 07:53:02.491226', '1', 'SEGURIDAD DE LA INFORMACIÓN', 1, '[{\"added\": {}}]', 8, 1),
(22, '2022-07-23 07:53:28.305124', '2', 'ADMINISTRACIÓN DE PROYECTOS DE SOFTWARE', 1, '[{\"added\": {}}]', 8, 1),
(23, '2022-07-23 07:53:52.071446', '3', 'EXPRESIÓN ORAL Y ESCRITA II', 1, '[{\"added\": {}}]', 8, 1),
(24, '2022-07-23 07:54:10.168289', '4', 'MINERÍA DE DATOS', 1, '[{\"added\": {}}]', 8, 1),
(25, '2022-07-23 07:54:29.686063', '5', 'ARQUITECTURA ORIENTADA A SERVICIOS', 1, '[{\"added\": {}}]', 8, 1),
(26, '2022-07-23 07:54:49.222230', '6', 'PROGRAMACIÓN PARA MÓVILES II', 1, '[{\"added\": {}}]', 8, 1),
(27, '2022-07-23 07:55:09.037699', '7', 'INGLÉS IX', 1, '[{\"added\": {}}]', 8, 1),
(28, '2022-07-24 00:22:57.103680', '2', 'Ncuatrimestre object (2)', 1, '[{\"added\": {}}]', 15, 1),
(29, '2022-07-24 00:23:09.842734', '2', 'Ncuatrimestre object (2)', 2, '[]', 15, 1),
(30, '2022-07-24 00:23:14.922914', '3', 'Ncuatrimestre object (3)', 1, '[{\"added\": {}}]', 15, 1),
(31, '2022-07-24 00:23:19.056585', '4', 'Ncuatrimestre object (4)', 1, '[{\"added\": {}}]', 15, 1),
(32, '2022-07-24 00:23:22.249769', '5', 'Ncuatrimestre object (5)', 1, '[{\"added\": {}}]', 15, 1),
(33, '2022-07-24 00:23:26.097401', '6', 'Ncuatrimestre object (6)', 1, '[{\"added\": {}}]', 15, 1),
(34, '2022-07-24 00:23:29.864215', '7', 'Ncuatrimestre object (7)', 1, '[{\"added\": {}}]', 15, 1),
(35, '2022-07-24 00:23:33.288330', '8', 'Ncuatrimestre object (8)', 1, '[{\"added\": {}}]', 15, 1),
(36, '2022-07-24 00:23:36.327256', '9', 'Ncuatrimestre object (9)', 1, '[{\"added\": {}}]', 15, 1),
(37, '2022-07-24 00:23:39.193607', '10', 'Ncuatrimestre object (10)', 1, '[{\"added\": {}}]', 15, 1),
(38, '2022-07-24 00:23:43.967802', '11', 'Ncuatrimestre object (11)', 1, '[{\"added\": {}}]', 15, 1),
(39, '2022-07-24 00:23:50.249066', '12', 'Ncuatrimestre object (12)', 1, '[{\"added\": {}}]', 15, 1),
(40, '2022-07-24 22:00:38.994106', '8', 'ALGEBRA LINEAL', 1, '[{\"added\": {}}]', 8, 1),
(41, '2022-07-24 22:01:02.808432', '9', 'ALGORITMOS', 1, '[{\"added\": {}}]', 8, 1),
(42, '2022-07-24 22:01:28.584344', '10', 'EXPRESION ORAL Y ESCRITA', 1, '[{\"added\": {}}]', 8, 1),
(43, '2022-07-24 22:02:48.038720', '11', 'FUNDAMENTOS DE LA COMPUTACION', 1, '[{\"added\": {}}]', 8, 1),
(44, '2022-07-24 22:03:27.765920', '12', 'INGLES I', 1, '[{\"added\": {}}]', 8, 1),
(45, '2022-07-24 22:03:51.334359', '13', 'MATEMATICAS DISCRETAS', 1, '[{\"added\": {}}]', 8, 1),
(46, '2022-07-24 22:05:03.677275', '14', 'QUIMICA', 1, '[{\"added\": {}}]', 8, 1),
(47, '2022-07-24 22:05:35.444118', '15', 'CALCULO DIFERENCIAL', 1, '[{\"added\": {}}]', 8, 1),
(48, '2022-07-24 22:06:34.849771', '16', 'DESARROLLO HUMANO Y DE VALORES', 1, '[{\"added\": {}}]', 8, 1),
(49, '2022-07-24 22:07:06.479689', '2', 'Laboratorio de cómputo y redes', 2, '[{\"changed\": {\"fields\": [\"Descripcion\"]}}]', 9, 3),
(50, '2022-07-24 22:08:59.827910', '1', 'Laboratorio de automatización', 2, '[{\"changed\": {\"fields\": [\"Descripcion\"]}}]', 9, 3),
(51, '2022-07-24 22:17:56.825016', '17', 'ESTRUCTURA DE DATOS', 1, '[{\"added\": {}}]', 8, 1),
(52, '2022-07-24 22:19:19.563145', '18', 'INGENIERIA DE SOFTWARE ASISTIDA POR COMPUTADORA', 1, '[{\"added\": {}}]', 8, 1),
(53, '2022-07-24 22:19:51.800481', '19', 'INGLES II', 1, '[{\"added\": {}}]', 8, 1),
(54, '2022-07-24 22:20:20.490137', '20', 'PROCESOS DE DESARROLLO DE SOFTWARE', 1, '[{\"added\": {}}]', 8, 1),
(55, '2022-07-24 22:22:00.602392', '21', 'CALCULO INTEGRAL', 1, '[{\"added\": {}}]', 8, 1),
(56, '2022-07-24 22:23:30.003848', '22', 'ESTRUCTURA DE DATOS AVANZADA', 1, '[{\"added\": {}}]', 8, 1),
(57, '2022-07-24 22:24:26.557264', '23', 'FUNDAMENTOS DE BASE SDE DATOS', 1, '[{\"added\": {}}]', 8, 1),
(58, '2022-07-24 22:26:49.870681', '24', 'INGENIERIA DE REQUERIMIENTO DE SOFTWARE', 1, '[{\"added\": {}}]', 8, 1),
(59, '2022-07-24 22:27:53.467372', '25', 'INGLES III', 1, '[{\"added\": {}}]', 8, 1),
(60, '2022-07-24 22:28:39.705172', '26', 'INTELIGENCIA EMOCIONAL Y MANEJO DE CONFLICTOS', 1, '[{\"added\": {}}]', 8, 1),
(61, '2022-07-24 22:34:57.020398', '1', 'Laboratorio de automatización', 2, '[{\"changed\": {\"fields\": [\"Descripcion\"]}}]', 9, 3),
(62, '2022-07-24 22:35:09.045887', '1', 'Laboratorio de automatización', 2, '[{\"changed\": {\"fields\": [\"Descripcion\"]}}]', 9, 3),
(63, '2022-07-24 22:35:37.852572', '2', 'Laboratorio de cómputo y redes', 2, '[{\"changed\": {\"fields\": [\"Descripcion\"]}}]', 9, 3),
(64, '2022-07-24 22:58:11.126734', '27', 'PROGRAMACION VISUAL', 1, '[{\"added\": {}}]', 8, 1),
(65, '2022-07-24 22:58:55.872693', '28', 'BASE DE DATOS', 1, '[{\"added\": {}}]', 8, 1),
(66, '2022-07-24 22:59:20.573164', '29', 'DISEÑO DE INTERFACES', 1, '[{\"added\": {}}]', 8, 1),
(67, '2022-07-24 22:59:51.001935', '30', 'ELECTRICIDAD Y MAGNETISMO', 1, '[{\"added\": {}}]', 8, 1),
(68, '2022-07-24 23:00:42.812854', '31', 'HABILIDADES COGNITIVAS Y CREATIVIDAD', 1, '[{\"added\": {}}]', 8, 1),
(69, '2022-07-24 23:01:01.271667', '32', 'INGLES IV', 1, '[{\"added\": {}}]', 8, 1),
(70, '2022-07-24 23:01:23.560563', '33', 'MATEMATICAS PARA INGENIERIA', 1, '[{\"added\": {}}]', 8, 1),
(71, '2022-07-24 23:02:09.701788', '34', 'PROGRAMACION WEB', 1, '[{\"added\": {}}]', 8, 1),
(72, '2022-07-24 23:02:41.529809', '35', 'ARQUITECTURA DE SOFTWARE', 1, '[{\"added\": {}}]', 8, 1),
(73, '2022-07-24 23:03:11.239733', '36', 'ETICA PROFESIONAL', 1, '[{\"added\": {}}]', 8, 1),
(74, '2022-07-24 23:03:34.470208', '37', 'FUNDAMENTO DE REDES', 1, '[{\"added\": {}}]', 8, 1),
(75, '2022-07-24 23:03:50.760300', '38', 'INGLES V', 1, '[{\"added\": {}}]', 8, 1),
(76, '2022-07-24 23:04:17.557221', '39', 'MATEMATICAS PARA INGENIERIA 2', 1, '[{\"added\": {}}]', 8, 1),
(77, '2022-07-24 23:04:51.857214', '40', 'PROGRAMACION CLIENTE SERVIDOR', 1, '[{\"added\": {}}]', 8, 1),
(78, '2022-07-24 23:05:12.499241', '41', 'SISTEMAS DIGITALES', 1, '[{\"added\": {}}]', 8, 1),
(79, '2022-07-24 23:05:45.598623', '42', 'ARQUITECTURA DE COMPUTADORAS', 1, '[{\"added\": {}}]', 8, 1),
(80, '2022-07-24 23:07:01.113666', '43', 'CALIDAD DEL SOFTWARE', 1, '[{\"added\": {}}]', 8, 1),
(81, '2022-07-24 23:11:36.502088', '44', 'HABILIDADES GERENCIALES', 1, '[{\"added\": {}}]', 8, 1),
(82, '2022-07-24 23:12:03.369139', '45', 'INGLES VI', 1, '[{\"added\": {}}]', 8, 1),
(83, '2022-07-24 23:16:22.445539', '46', 'PROBABILIDAD Y ESTADISTICA', 1, '[{\"added\": {}}]', 8, 1),
(84, '2022-07-24 23:16:35.263455', '47', 'REDES', 1, '[{\"added\": {}}]', 8, 1),
(85, '2022-07-24 23:16:53.395555', '48', 'INGLES VII', 1, '[{\"added\": {}}]', 8, 1),
(86, '2022-07-24 23:17:26.902840', '49', 'LENGUAJES Y AUTOMATAS', 1, '[{\"added\": {}}]', 8, 1),
(87, '2022-07-24 23:31:37.565136', '1', 'PC 01', 1, '[{\"added\": {}}]', 11, 3),
(88, '2022-07-24 23:31:54.444875', '2', 'PC 02', 1, '[{\"added\": {}}]', 11, 3),
(89, '2022-07-24 23:32:10.139546', '3', 'PC 03', 1, '[{\"added\": {}}]', 11, 3),
(90, '2022-07-24 23:32:17.061670', '4', 'PC 04', 1, '[{\"added\": {}}]', 11, 3),
(91, '2022-07-24 23:32:25.179703', '5', 'PC 05', 1, '[{\"added\": {}}]', 11, 3),
(92, '2022-07-24 23:32:32.586620', '6', 'PC 06', 1, '[{\"added\": {}}]', 11, 3),
(93, '2022-07-24 23:32:39.492398', '7', 'PC 07', 1, '[{\"added\": {}}]', 11, 3),
(94, '2022-07-24 23:32:45.579658', '8', 'PC 08', 1, '[{\"added\": {}}]', 11, 3),
(95, '2022-07-24 23:32:52.930948', '9', 'PC 09', 1, '[{\"added\": {}}]', 11, 3),
(96, '2022-07-24 23:33:01.726792', '10', 'PC 10', 1, '[{\"added\": {}}]', 11, 3),
(97, '2022-07-24 23:33:07.121927', '11', 'PC 11', 1, '[{\"added\": {}}]', 11, 3),
(98, '2022-07-24 23:33:13.075367', '12', 'PC 12', 1, '[{\"added\": {}}]', 11, 3),
(99, '2022-07-24 23:33:18.986855', '13', 'PC 13', 1, '[{\"added\": {}}]', 11, 3),
(100, '2022-07-24 23:33:36.530373', '14', 'PC 14', 1, '[{\"added\": {}}]', 11, 3),
(101, '2022-07-24 23:33:45.377379', '15', 'PC 15', 1, '[{\"added\": {}}]', 11, 3),
(102, '2022-07-24 23:33:51.161479', '16', 'PC 16', 1, '[{\"added\": {}}]', 11, 3),
(103, '2022-07-24 23:33:59.009558', '17', 'PC 17', 1, '[{\"added\": {}}]', 11, 3),
(104, '2022-07-24 23:34:04.641273', '18', 'PC 18', 1, '[{\"added\": {}}]', 11, 3),
(105, '2022-07-24 23:34:09.913284', '19', 'PC 19', 1, '[{\"added\": {}}]', 11, 3),
(106, '2022-07-24 23:34:15.333186', '20', 'PC 20', 1, '[{\"added\": {}}]', 11, 3),
(107, '2022-07-24 23:34:22.975899', '21', 'PC 21', 1, '[{\"added\": {}}]', 11, 3),
(108, '2022-07-24 23:34:27.825995', '22', 'PC 22', 1, '[{\"added\": {}}]', 11, 3),
(109, '2022-07-24 23:34:37.105576', '23', 'PC 23', 1, '[{\"added\": {}}]', 11, 3),
(110, '2022-07-24 23:34:59.371825', '24', 'PC 24', 1, '[{\"added\": {}}]', 11, 3),
(111, '2022-07-24 23:35:05.815424', '25', 'PC 25', 1, '[{\"added\": {}}]', 11, 3),
(112, '2022-07-24 23:35:14.384455', '26', 'PC 26', 1, '[{\"added\": {}}]', 11, 3);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `django_content_type`
--
CREATE TABLE `django_content_type` (
`id` int(11) NOT NULL,
`app_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`model` varchar(100) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `django_content_type`
--
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES
(1, 'admin', 'logentry'),
(7, 'autenticacion', 'perfil'),
(3, 'auth', 'group'),
(2, 'auth', 'permission'),
(4, 'auth', 'user'),
(5, 'contenttypes', 'contenttype'),
(13, 'laboratorios', 'lab'),
(14, 'laboratorios', 'labcomputo'),
(6, 'sessions', 'session'),
(10, 'universidad', 'area'),
(8, 'universidad', 'asignatura'),
(12, 'universidad', 'carrera'),
(9, 'universidad', 'laboratorio'),
(11, 'universidad', 'material'),
(15, 'universidad', 'ncuatrimestre');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `django_migrations`
--
CREATE TABLE `django_migrations` (
`id` bigint(20) NOT NULL,
`app` varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`applied` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `django_migrations`
--
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES
(1, 'contenttypes', '0001_initial', '2022-06-22 18:34:34.975163'),
(2, 'auth', '0001_initial', '2022-06-22 18:34:35.354439'),
(3, 'admin', '0001_initial', '2022-06-22 18:34:35.477851'),
(4, 'admin', '0002_logentry_remove_auto_add', '2022-06-22 18:34:35.484852'),
(5, 'admin', '0003_logentry_add_action_flag_choices', '2022-06-22 18:34:35.492854'),
(6, 'contenttypes', '0002_remove_content_type_name', '2022-06-22 18:34:35.580850'),
(7, 'auth', '0002_alter_permission_name_max_length', '2022-06-22 18:34:35.628853'),
(8, 'auth', '0003_alter_user_email_max_length', '2022-06-22 18:34:35.697852'),
(9, 'auth', '0004_alter_user_username_opts', '2022-06-22 18:34:35.704852'),
(10, 'auth', '0005_alter_user_last_login_null', '2022-06-22 18:34:35.760777'),
(11, 'auth', '0006_require_contenttypes_0002', '2022-06-22 18:34:35.764778'),
(12, 'auth', '0007_alter_validators_add_error_messages', '2022-06-22 18:34:35.772777'),
(13, 'auth', '0008_alter_user_username_max_length', '2022-06-22 18:34:35.827778'),
(14, 'auth', '0009_alter_user_last_name_max_length', '2022-06-22 18:34:35.876781'),
(15, 'auth', '0010_alter_group_name_max_length', '2022-06-22 18:34:35.932778'),
(16, 'auth', '0011_update_proxy_permissions', '2022-06-22 18:34:35.940779'),
(17, 'auth', '0012_alter_user_first_name_max_length', '2022-06-22 18:34:35.994778'),
(18, 'sessions', '0001_initial', '2022-06-22 18:34:36.042275'),
(19, 'universidad', '0001_initial', '2022-06-27 13:26:48.864722'),
(20, 'autenticacion', '0001_initial', '2022-06-27 13:26:49.008013'),
(21, 'laboratorios', '0001_initial', '2022-06-27 13:26:49.310254'),
(22, 'autenticacion', '0002_perfil_tipo_alter_perfil_genero', '2022-07-19 04:25:37.677139'),
(23, 'autenticacion', '0003_perfil_key_alter_perfil_tipo', '2022-07-19 06:49:04.123167'),
(24, 'laboratorios', '0002_alter_lab_options_alter_lab_id_area_and_more', '2022-07-22 12:25:34.867878'),
(25, 'laboratorios', '0003_alter_labcomputo_entrada_and_more', '2022-07-23 08:21:02.022497'),
(26, 'autenticacion', '0004_alter_perfil_cuatrimestre', '2022-07-23 23:52:37.019246'),
(27, 'laboratorios', '0004_alter_lab_options_alter_labcomputo_options', '2022-07-23 23:52:37.052257'),
(28, 'universidad', '0002_ncuatrimestre', '2022-07-24 00:20:07.052415'),
(29, 'autenticacion', '0005_alter_perfil_cuatrimestre', '2022-07-24 00:54:45.725603'),
(30, 'autenticacion', '0006_alter_perfil_cuatrimestre', '2022-07-24 00:54:45.913489'),
(31, 'universidad', '0003_delete_ncuatrimestre_asignatura_cuatri', '2022-07-24 00:54:45.979449'),
(32, 'laboratorios', '0005_alter_labcomputo_options', '2022-07-24 22:10:28.374943'),
(33, 'universidad', '0004_alter_laboratorio_descripcion', '2022-07-24 22:10:28.683871'),
(34, 'universidad', '0005_alter_area_descripcion', '2022-07-24 22:11:48.381856'),
(35, 'universidad', '0006_alter_material_descripcion', '2022-07-24 22:46:11.019956');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `django_session`
--
CREATE TABLE `django_session` (
`session_key` varchar(40) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`session_data` longtext CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
`expire_date` datetime(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `django_session`
--
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES
('0chc5lqlhi6r2lw4sd5wac1j6ewc5095', '.eJxVjEEOwiAQRe_C2hCmFAZduu8ZCMMMUjVtUtqV8e7apAvd_vfef6mYtrXGrckSR1YXBer0u1HKD5l2wPc03Wad52ldRtK7og_a9DCzPK-H-3dQU6vfupQOIAAZccjYM0iwJrMA-mKIzjY4QiPcJ_JoXba9RUnIULxk6zr1_gDl-Tf8:1oDfww:0AqW4xDmejDwfpgf6ahZ7uNEhepcoeFZQo-41GVA3CA', '2022-08-02 05:39:14.197652'),
('4e7i8s6swv1410vaq38nm1qdhx65ljwz', '.eJxVjEEOwiAQRe_C2hCmFAZduu8ZCMMMUjVtUtqV8e7apAvd_vfef6mYtrXGrckSR1YXBer0u1HKD5l2wPc03Wad52ldRtK7og_a9DCzPK-H-3dQU6vfupQOIAAZccjYM0iwJrMA-mKIzjY4QiPcJ_JoXba9RUnIULxk6zr1_gDl-Tf8:1oF9tu:NbjzgWOT9rRIuAJ0RU9g2JFlFY31ojaL4caOnLccJ1k', '2022-08-06 07:50:14.785169'),
('8zwbzvltobss4h4h73cuvddady6cbwte', '.eJxVjEEOwiAQRe_C2hAHCGVcuvcMZBimUjWQlHbVeHdt0oVu_3vvbyrSupS4dpnjlNVFWXX63RLxU-oO8oPqvWludZmnpHdFH7TrW8vyuh7u30GhXr41A2IA6yyywxxQjIfksmGAwYTMdiT0RIjeoEOEIOfkOYGAH60fnHp_AMEFNwM:1oDtKU:ENeJaxo-TP1vfRH1NIks0CPcSV6tW3LXkXmbPKJm9DM', '2022-08-02 19:56:26.064422'),
('eyanzvji4mow6bxdc46ype2wb4j0fjb3', '.eJxVjEEOwiAQRe_C2hCmFAZduu8ZCMMMUjVtUtqV8e7apAvd_vfef6mYtrXGrckSR1YXBer0u1HKD5l2wPc03Wad52ldRtK7og_a9DCzPK-H-3dQU6vfupQOIAAZccjYM0iwJrMA-mKIzjY4QiPcJ_JoXba9RUnIULxk6zr1_gDl-Tf8:1oFjKo:tUbz-23Z7-QrWIPH-WGX9f5-rr2FytXkALaQe-EK8cA', '2022-08-07 21:40:22.842243'),
('hxvn8w256omhzghg7h99jzw9jjmlyuya', '.eJxVjEEOwiAQRe_C2hCmFAZduu8ZCMMMUjVtUtqV8e7apAvd_vfef6mYtrXGrckSR1YXBer0u1HKD5l2wPc03Wad52ldRtK7og_a9DCzPK-H-3dQU6vfupQOIAAZccjYM0iwJrMA-mKIzjY4QiPcJ_JoXba9RUnIULxk6zr1_gDl-Tf8:1oDtOe:JoXgoNxLFev4gp4WSmkQSrq9e9Jcaq7TBYx9Hp1zVcs', '2022-08-02 20:00:44.611785'),
('ixn5rb9ny8vkeusubg1riohe9lbc8f01', '.eJxVjEEOwiAQRe_C2hCmFAZduu8ZCMMMUjVtUtqV8e7apAvd_vfef6mYtrXGrckSR1YXBer0u1HKD5l2wPc03Wad52ldRtK7og_a9DCzPK-H-3dQU6vfupQOIAAZccjYM0iwJrMA-mKIzjY4QiPcJ_JoXba9RUnIULxk6zr1_gDl-Tf8:1oF9vY:mxtU7uNGG7IjJnCgRCCAQTTVC0Gg9UvIXzyhDSeA98U', '2022-08-06 07:51:56.367944'),
('iyglni5jzsv2fin6qrcabxb584yfe1vw', 'eyJfcGFzc3dvcmRfcmVzZXRfdG9rZW4iOiJiOHhvaDQtNzgyMGZlN2E0ZjQ2MzNmNDAyYTEwMDEyNGUwOGIwNmEifQ:1oEja6:Nor0VNiVMnYP2wzC73fn0YQ0_4kr8V8LCQTVydt0OIc', '2022-08-05 03:44:02.883592'),
('ootl6xj694vuf0x43fd3scwo2mm9nxfs', '.eJxVjDsOwyAQRO9CHSGDl1_K9D4DWmAJTiIsGbuKcvdgyUXSjd68mTfzuG_F741WPyd2ZcAuvyxgfFI9ivTAel94XOq2zoEfCj_bxqcl0et2un8HBVvp6yCVFtFpOSiRB5NEBDBGEaLrBLK1QuLYk7QjUqLsglMETgQwFrVgny-51jbm:1oFf3y:4dIW22XDBVOrnogcooD4j-tSSA3bkROM9ZNV8-cTZrI', '2022-08-07 17:06:42.130354'),
('q4cn9rn24kitsg9hliu0ue0wll7xy5mb', '.eJxVjMsOwiAQAP-FsyErLEg9eu83kF0eUjWQlPZk_HdD0oNeZybzFp72rfi9p9UvUVyFEadfxhSeqQ4RH1TvTYZWt3VhORJ52C7nFtPrdrR_g0K9jK3jrBl50qTBaQsKAoO6qLPDDIDW6gA2gSNUlBmMi2xizoAZMU1BfL7ALzdb:1oEOdV:xKYy5W-TOWmbKQ-buF7-LxYie_z_xaqYo_JvWyNvNtE', '2022-08-04 05:22:09.632268'),
('r8j8bll5qdx19lfhjuhpnmsn3us89zdo', '.eJxVjEEOwiAQRe_C2hCmFAZduu8ZCMMMUjVtUtqV8e7apAvd_vfef6mYtrXGrckSR1YXBer0u1HKD5l2wPc03Wad52ldRtK7og_a9DCzPK-H-3dQU6vfupQOIAAZccjYM0iwJrMA-mKIzjY4QiPcJ_JoXba9RUnIULxk6zr1_gDl-Tf8:1o45EU:zJQGbDvXO47JTD8M2jWu0TxD3R9WR78vumGncr-StnA', '2022-07-06 18:37:42.282320'),
('tf363qdadc0fnaidwyy4othiwg0kw5xk', '.eJxVjEEOwiAQRe_C2hCmFAZduu8ZCMMMUjVtUtqV8e7apAvd_vfef6mYtrXGrckSR1YXBer0u1HKD5l2wPc03Wad52ldRtK7og_a9DCzPK-H-3dQU6vfupQOIAAZccjYM0iwJrMA-mKIzjY4QiPcJ_JoXba9RUnIULxk6zr1_gDl-Tf8:1oFLwG:inviyc5VVfnlKK6YcGf28phsjUVzULGDf2ZfY1GefCc', '2022-08-06 20:41:28.498683');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `laboratorios_lab`
--
CREATE TABLE `laboratorios_lab` (
`id` bigint(20) NOT NULL,
`uso` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
`foto` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`entrada` date NOT NULL,
`salida` date NOT NULL,
`fecha_alta` date NOT NULL,
`fecha_actualizacion` date NOT NULL,
`id_area_id` bigint(20) DEFAULT NULL,
`id_asig_id` bigint(20) DEFAULT NULL,
`id_lab_id` bigint(20) DEFAULT NULL,
`id_mat_id` bigint(20) DEFAULT NULL,
`usuario_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `laboratorios_labcomputo`
--
CREATE TABLE `laboratorios_labcomputo` (
`id` bigint(20) NOT NULL,
`uso` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
`foto` varchar(100) COLLATE utf8_spanish_ci NOT NULL,
`entrada` datetime(6) NOT NULL,
`salida` datetime(6) NOT NULL,
`fecha_alta` datetime(6) NOT NULL,
`fecha_actualizacion` datetime(6) NOT NULL,
`id_area_id` bigint(20) DEFAULT NULL,
`id_asig_id` bigint(20) DEFAULT NULL,
`id_lab_id` bigint(20) DEFAULT NULL,
`id_mat_id` bigint(20) DEFAULT NULL,
`usuario_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `laboratorios_labcomputo`
--
INSERT INTO `laboratorios_labcomputo` (`id`, `uso`, `foto`, `entrada`, `salida`, `fecha_alta`, `fecha_actualizacion`, `id_area_id`, `id_asig_id`, `id_lab_id`, `id_mat_id`, `usuario_id`) VALUES
(1, 'Clase', '', '2022-07-23 00:00:00.000000', '2022-07-23 00:00:00.000000', '2022-07-23 00:00:00.000000', '2022-07-23 00:00:00.000000', NULL, 4, 1, NULL, 2),
(2, 'Practica', '', '2022-07-23 00:00:00.000000', '2022-07-24 10:06:30.113918', '2022-07-23 00:00:00.000000', '2022-07-23 00:00:00.000000', 1, 6, 1, NULL, 1),
(3, 'Clase', '', '2022-07-23 00:00:00.000000', '2022-07-24 09:27:20.150178', '2022-07-23 00:00:00.000000', '2022-07-23 00:00:00.000000', 2, 3, 1, NULL, 1),
(4, 'Libre', '', '2022-07-23 08:21:42.507961', '2022-07-24 09:27:50.262176', '2022-07-23 08:21:42.507961', '2022-07-23 08:21:42.507961', 2, 1, 2, NULL, 1),
(5, 'Clase', '', '2022-07-23 10:51:34.011440', '2022-07-23 10:51:34.011440', '2022-07-23 10:51:34.011440', '2022-07-23 10:51:34.011440', 2, 6, 2, NULL, 1),
(6, 'Clase', '', '2022-07-23 20:37:03.127080', '2022-07-23 20:37:03.127080', '2022-07-23 20:37:03.127080', '2022-07-23 20:37:03.127080', 3, 3, 2, NULL, 2),
(7, 'Clase', '', '2022-07-23 23:39:07.290337', '2022-07-24 09:26:10.416449', '2022-07-23 23:39:07.290337', '2022-07-23 23:39:07.290337', 2, 3, 1, NULL, 1),
(8, 'Clase', '', '2022-07-23 23:41:15.157076', '2022-07-23 23:41:15.157076', '2022-07-23 23:41:15.157076', '2022-07-23 23:41:15.157076', NULL, 3, 2, NULL, 5),
(9, 'Clase', '', '2022-07-24 02:03:57.358856', '2022-07-24 09:27:28.389883', '2022-07-24 02:03:57.358856', '2022-07-24 02:03:57.358856', NULL, 6, 2, NULL, 1),
(11, 'Clase', '', '2022-07-24 05:01:19.352401', '2022-07-24 09:22:18.368516', '2022-07-24 05:01:19.352401', '2022-07-24 05:01:19.352401', NULL, 5, 1, NULL, 1),
(12, 'Clase', '', '2022-07-24 10:05:48.459526', '2022-07-24 10:06:02.361466', '2022-07-24 10:05:48.459526', '2022-07-24 10:05:48.459526', NULL, 3, 1, NULL, 1),
(13, 'Clase', '', '2022-07-24 10:14:10.917484', '2022-07-24 10:14:34.254147', '2022-07-24 10:14:10.917484', '2022-07-24 10:14:10.917484', 3, 6, 4, NULL, 5);
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `universidad_area`
--
CREATE TABLE `universidad_area` (
`id` bigint(20) NOT NULL,
`nombre` varchar(200) COLLATE utf8_spanish_ci NOT NULL,
`descripcion` longtext COLLATE utf8_spanish_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `universidad_area`
--
INSERT INTO `universidad_area` (`id`, `nombre`, `descripcion`) VALUES
(1, 'Diseño 3D', 'D'),
(2, 'Sala de ciencias 3D', 'Z'),
(3, 'Brazos robóticos', 'V');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `universidad_asignatura`
--
CREATE TABLE `universidad_asignatura` (
`id` bigint(20) NOT NULL,
`nombre` varchar(200) COLLATE utf8_spanish_ci NOT NULL,
`creditos` int(11) NOT NULL,
`id_carrera_id` bigint(20) NOT NULL,
`cuatri` varchar(2) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `universidad_asignatura`
--
INSERT INTO `universidad_asignatura` (`id`, `nombre`, `creditos`, `id_carrera_id`, `cuatri`) VALUES
(1, 'SEGURIDAD DE LA INFORMACIÓN', 10, 1, '9'),
(2, 'ADMINISTRACIÓN DE PROYECTOS DE SOFTWARE', 10, 1, '9'),
(3, 'EXPRESIÓN ORAL Y ESCRITA II', 10, 1, '9'),
(4, 'MINERÍA DE DATOS', 10, 1, '9'),
(5, 'ARQUITECTURA ORIENTADA A SERVICIOS', 10, 1, '9'),
(6, 'PROGRAMACIÓN PARA MÓVILES II', 10, 1, '9'),
(7, 'INGLÉS IX', 10, 1, '9'),
(8, 'ALGEBRA LINEAL', 10, 1, '1'),
(9, 'ALGORITMOS', 10, 1, '1'),
(10, 'EXPRESION ORAL Y ESCRITA', 10, 1, '1'),
(11, 'FUNDAMENTOS DE LA COMPUTACION', 10, 1, '1'),
(12, 'INGLES I', 10, 1, '1'),
(13, 'MATEMATICAS DISCRETAS', 10, 1, '1'),
(14, 'QUIMICA', 10, 1, '1'),
(15, 'CALCULO DIFERENCIAL', 10, 1, '2'),
(16, 'DESARROLLO HUMANO Y DE VALORES', 10, 1, '2'),
(17, 'ESTRUCTURA DE DATOS', 10, 1, '2'),
(18, 'INGENIERIA DE SOFTWARE ASISTIDA POR COMPUTADORA', 10, 1, '2'),
(19, 'INGLES II', 10, 1, '2'),
(20, 'PROCESOS DE DESARROLLO DE SOFTWARE', 10, 1, '2'),
(21, 'CALCULO INTEGRAL', 10, 1, '3'),
(22, 'ESTRUCTURA DE DATOS AVANZADA', 10, 1, '3'),
(23, 'FUNDAMENTOS DE BASE SDE DATOS', 10, 1, '3'),
(24, 'INGENIERIA DE REQUERIMIENTO DE SOFTWARE', 10, 1, '3'),
(25, 'INGLES III', 10, 1, '3'),
(26, 'INTELIGENCIA EMOCIONAL Y MANEJO DE CONFLICTOS', 10, 1, '3'),
(27, 'PROGRAMACION VISUAL', 10, 1, '3'),
(28, 'BASE DE DATOS', 10, 1, '4'),
(29, 'DISEÑO DE INTERFACES', 10, 1, '4'),
(30, 'ELECTRICIDAD Y MAGNETISMO', 10, 1, '4'),
(31, 'HABILIDADES COGNITIVAS Y CREATIVIDAD', 10, 1, '4'),
(32, 'INGLES IV', 10, 1, '4'),
(33, 'MATEMATICAS PARA INGENIERIA', 10, 1, '4'),
(34, 'PROGRAMACION WEB', 10, 1, '4'),
(35, 'ARQUITECTURA DE SOFTWARE', 10, 1, '5'),
(36, 'ETICA PROFESIONAL', 10, 1, '5'),
(37, 'FUNDAMENTO DE REDES', 10, 1, '5'),
(38, 'INGLES V', 10, 1, '5'),
(39, 'MATEMATICAS PARA INGENIERIA 2', 10, 1, '5'),
(40, 'PROGRAMACION CLIENTE SERVIDOR', 10, 1, '5'),
(41, 'SISTEMAS DIGITALES', 10, 1, '5'),
(42, 'ARQUITECTURA DE COMPUTADORAS', 10, 1, '6'),
(43, 'CALIDAD DEL SOFTWARE', 10, 1, '6'),
(44, 'HABILIDADES GERENCIALES', 10, 1, '6'),
(45, 'INGLES VI', 10, 1, '6'),
(46, 'PROBABILIDAD Y ESTADISTICA', 10, 1, '6'),
(47, 'REDES', 10, 1, '6'),
(48, 'INGLES VII', 10, 1, '6'),
(49, 'LENGUAJES Y AUTOMATAS', 10, 1, '6');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `universidad_carrera`
--
CREATE TABLE `universidad_carrera` (
`id` bigint(20) NOT NULL,
`nombre` varchar(200) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `universidad_carrera`
--
INSERT INTO `universidad_carrera` (`id`, `nombre`) VALUES
(2, 'Ingeniería Agroindustrial'),
(1, 'Ingeniería de Software'),
(3, 'Ingeniería en Animación y Efectos Visuales'),
(4, 'Ingeniería en Energía'),
(5, 'Ingeniería en Logística y Transporte'),
(6, 'Ingeniería en Nanotecnología'),
(7, 'Ingeniería en Sistemas Automotrices'),
(8, 'Ingeniería en Tecnología Ambiental'),
(9, 'Ingeniería Financiera'),
(10, 'Ingeniería Mecatrónica');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `universidad_laboratorio`
--
CREATE TABLE `universidad_laboratorio` (
`id` bigint(20) NOT NULL,
`nombre` varchar(200) COLLATE utf8_spanish_ci NOT NULL,
`descripcion` longtext COLLATE utf8_spanish_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `universidad_laboratorio`
--
INSERT INTO `universidad_laboratorio` (`id`, `nombre`, `descripcion`) VALUES
(1, 'Laboratorio de automatización', 'Se desarrollan actividades practicas del programa educativo Ingeniería en Sistema Automotriz Ingeniería en Mecatrónica e Ingeniería en Energía y algunas otras ingenierías que requieran hacer uso de las herramientas que existen dentro del laboratorio la cual son herramientas que se utilizan para manufactura, en el caso de un torno, prensas, etc.\r\nEsto con el fin de desarrollar actividades para que el alumno pueda aplicarlo en el ambiente laboral y cumplir con un buen trabajo.'),
(2, 'Laboratorio de cómputo y redes', 'Cuenta con estaciones de trabajo de última generación equipadas con procesadores de alto rendimiento, así como la integración de doble tarjeta de video, generando con estos componentes un mejor desempeño y desarrollo en actividades académicas que requieran de funcionalidades con requisitos más exigentes. \r\n\r\nLo anterior con el objeto de mejorar el proceso de la enseñanza en la práctica y generar características que propicien una forma de innovar en las habilidades de aprendizaje.'),
(3, 'Cabina de audio', 'S'),
(4, 'Laboratorio internet de las cosas', 'Q'),
(5, 'Laboratorio de frutas y hortalizas', 'W');
-- --------------------------------------------------------
--
-- Estructura de tabla para la tabla `universidad_material`
--
CREATE TABLE `universidad_material` (
`id` bigint(20) NOT NULL,
`nombre` varchar(200) COLLATE utf8_spanish_ci NOT NULL,
`descripcion` longtext COLLATE utf8_spanish_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
--
-- Volcado de datos para la tabla `universidad_material`
--
INSERT INTO `universidad_material` (`id`, `nombre`, `descripcion`) VALUES
(1, 'PC 01', 'CPU, Monitor, Mouse y Teclado.'),
(2, 'PC 02', 'CPU, Monitor, Mouse y Teclado.'),
(3, 'PC 03', 'CPU, Monitor, Mouse y Teclado.'),
(4, 'PC 04', 'CPU, Monitor, Mouse y Teclado.'),
(5, 'PC 05', 'CPU, Monitor, Mouse y Teclado.'),
(6, 'PC 06', 'CPU, Monitor, Mouse y Teclado.'),
(7, 'PC 07', 'CPU, Monitor, Mouse y Teclado.'),
(8, 'PC 08', 'CPU, Monitor, Mouse y Teclado.'),
(9, 'PC 09', 'CPU, Monitor, Mouse y Teclado.'),
(10, 'PC 10', 'CPU, Monitor, Mouse y Teclado.'),
(11, 'PC 11', 'CPU, Monitor, Mouse y Teclado.'),
(12, 'PC 12', 'CPU, Monitor, Mouse y Teclado.'),
(13, 'PC 13', 'CPU, Monitor, Mouse y Teclado.'),
(14, 'PC 14', 'CPU, Monitor, Mouse y Teclado.'),
(15, 'PC 15', 'CPU, Monitor, Mouse y Teclado.'),
(16, 'PC 16', 'CPU, Monitor, Mouse y Teclado.'),
(17, 'PC 17', 'CPU, Monitor, Mouse y Teclado.'),
(18, 'PC 18', 'CPU, Monitor, Mouse y Teclado.'),
(19, 'PC 19', 'CPU, Monitor, Mouse y Teclado.'),
(20, 'PC 20', 'CPU, Monitor, Mouse y Teclado.'),
(21, 'PC 21', 'CPU, Monitor, Mouse y Teclado.'),
(22, 'PC 22', 'CPU, Monitor, Mouse y Teclado.'),
(23, 'PC 23', 'CPU, Monitor, Mouse y Teclado.'),
(24, 'PC 24', 'CPU, Monitor y Teclado.'),
(25, 'PC 25', 'CPU, Monitor y Teclado.'),
(26, 'PC 26', 'CPU, Monitor y Teclado.');
--
-- Índices para tablas volcadas
--
--
-- Indices de la tabla `autenticacion_perfil`
--
ALTER TABLE `autenticacion_perfil`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `matricula` (`matricula`),
ADD KEY `autenticacion_perfil_id_carrera_id_b6b0c9b7_fk_universid` (`id_carrera_id`),
ADD KEY `autenticacion_perfil_usuario_id_6a46def6_fk_auth_user_id` (`usuario_id`);
--
-- Indices de la tabla `auth_group`
--
ALTER TABLE `auth_group`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`);
--
-- Indices de la tabla `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
ADD KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`);
--
-- Indices de la tabla `auth_permission`
--
ALTER TABLE `auth_permission`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`);
--
-- Indices de la tabla `auth_user`
--
ALTER TABLE `auth_user`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `username` (`username`);
--
-- Indices de la tabla `auth_user_groups`
--
ALTER TABLE `auth_user_groups`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
ADD KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`);
--
-- Indices de la tabla `auth_user_user_permissions`
--
ALTER TABLE `auth_user_user_permissions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
ADD KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`);
--
-- Indices de la tabla `django_admin_log`
--
ALTER TABLE `django_admin_log`
ADD PRIMARY KEY (`id`),
ADD KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
ADD KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`);
--
-- Indices de la tabla `django_content_type`
--
ALTER TABLE `django_content_type`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`);
--
-- Indices de la tabla `django_migrations`
--
ALTER TABLE `django_migrations`
ADD PRIMARY KEY (`id`);
--
-- Indices de la tabla `django_session`
--
ALTER TABLE `django_session`
ADD PRIMARY KEY (`session_key`),
ADD KEY `django_session_expire_date_a5c62663` (`expire_date`);
--
-- Indices de la tabla `laboratorios_lab`
--
ALTER TABLE `laboratorios_lab`
ADD PRIMARY KEY (`id`),
ADD KEY `laboratorios_lab_usuario_id_10c9a742_fk_auth_user_id` (`usuario_id`),
ADD KEY `laboratorios_lab_id_area_id_6cab2a52_fk_universidad_area_id` (`id_area_id`),
ADD KEY `laboratorios_lab_id_asig_id_78006e02_fk_universid` (`id_asig_id`),
ADD KEY `laboratorios_lab_id_lab_id_ea18f4c1_fk_universid` (`id_lab_id`),
ADD KEY `laboratorios_lab_id_mat_id_1ae59baf_fk_universidad_material_id` (`id_mat_id`);
--
-- Indices de la tabla `laboratorios_labcomputo`
--
ALTER TABLE `laboratorios_labcomputo`
ADD PRIMARY KEY (`id`),
ADD KEY `laboratorios_labcomp_id_area_id_c05f985a_fk_universid` (`id_area_id`),
ADD KEY `laboratorios_labcomp_id_asig_id_719a8349_fk_universid` (`id_asig_id`),
ADD KEY `laboratorios_labcomp_id_lab_id_c06eab3c_fk_universid` (`id_lab_id`),
ADD KEY `laboratorios_labcomp_id_mat_id_d9db573b_fk_universid` (`id_mat_id`),
ADD KEY `laboratorios_labcomputo_usuario_id_6869c1d4_fk_auth_user_id` (`usuario_id`);
--
-- Indices de la tabla `universidad_area`
--
ALTER TABLE `universidad_area`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `nombre` (`nombre`);
--
-- Indices de la tabla `universidad_asignatura`
--
ALTER TABLE `universidad_asignatura`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `nombre` (`nombre`),
ADD KEY `universidad_asignatu_id_carrera_id_87eca5c4_fk_universid` (`id_carrera_id`);
--
-- Indices de la tabla `universidad_carrera`
--
ALTER TABLE `universidad_carrera`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `nombre` (`nombre`);
--
-- Indices de la tabla `universidad_laboratorio`
--
ALTER TABLE `universidad_laboratorio`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `nombre` (`nombre`);
--
-- Indices de la tabla `universidad_material`
--
ALTER TABLE `universidad_material`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `nombre` (`nombre`);
--
-- AUTO_INCREMENT de las tablas volcadas
--
--
-- AUTO_INCREMENT de la tabla `autenticacion_perfil`
--
ALTER TABLE `autenticacion_perfil`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT de la tabla `auth_group`
--
ALTER TABLE `auth_group`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `auth_permission`
--
ALTER TABLE `auth_permission`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
--
-- AUTO_INCREMENT de la tabla `auth_user`
--
ALTER TABLE `auth_user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT de la tabla `auth_user_groups`
--
ALTER TABLE `auth_user_groups`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `auth_user_user_permissions`
--
ALTER TABLE `auth_user_user_permissions`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `django_admin_log`
--
ALTER TABLE `django_admin_log`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;
--
-- AUTO_INCREMENT de la tabla `django_content_type`
--
ALTER TABLE `django_content_type`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT de la tabla `django_migrations`
--
ALTER TABLE `django_migrations`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT de la tabla `laboratorios_lab`
--
ALTER TABLE `laboratorios_lab`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT de la tabla `laboratorios_labcomputo`
--
ALTER TABLE `laboratorios_labcomputo`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT de la tabla `universidad_area`
--
ALTER TABLE `universidad_area`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT de la tabla `universidad_asignatura`
--
ALTER TABLE `universidad_asignatura`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;
--
-- AUTO_INCREMENT de la tabla `universidad_carrera`
--
ALTER TABLE `universidad_carrera`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT de la tabla `universidad_laboratorio`
--
ALTER TABLE `universidad_laboratorio`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT de la tabla `universidad_material`
--
ALTER TABLE `universidad_material`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
--
-- Restricciones para tablas volcadas
--
--
-- Filtros para la tabla `autenticacion_perfil`
--
ALTER TABLE `autenticacion_perfil`
ADD CONSTRAINT `autenticacion_perfil_id_carrera_id_b6b0c9b7_fk_universid` FOREIGN KEY (`id_carrera_id`) REFERENCES `universidad_carrera` (`id`),
ADD CONSTRAINT `autenticacion_perfil_usuario_id_6a46def6_fk_auth_user_id` FOREIGN KEY (`usuario_id`) REFERENCES `auth_user` (`id`);
--
-- Filtros para la tabla `auth_group_permissions`
--
ALTER TABLE `auth_group_permissions`
ADD CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
ADD CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);
--
-- Filtros para la tabla `auth_permission`
--
ALTER TABLE `auth_permission`
ADD CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);
--
-- Filtros para la tabla `auth_user_groups`
--
ALTER TABLE `auth_user_groups`
ADD CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
ADD CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
--
-- Filtros para la tabla `auth_user_user_permissions`
--
ALTER TABLE `auth_user_user_permissions`
ADD CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
ADD CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
--
-- Filtros para la tabla `django_admin_log`
--
ALTER TABLE `django_admin_log`
ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
--
-- Filtros para la tabla `laboratorios_lab`
--
ALTER TABLE `laboratorios_lab`
ADD CONSTRAINT `laboratorios_lab_id_area_id_6cab2a52_fk_universidad_area_id` FOREIGN KEY (`id_area_id`) REFERENCES `universidad_area` (`id`),
ADD CONSTRAINT `laboratorios_lab_id_asig_id_78006e02_fk_universid` FOREIGN KEY (`id_asig_id`) REFERENCES `universidad_asignatura` (`id`),
ADD CONSTRAINT `laboratorios_lab_id_lab_id_ea18f4c1_fk_universid` FOREIGN KEY (`id_lab_id`) REFERENCES `universidad_laboratorio` (`id`),
ADD CONSTRAINT `laboratorios_lab_id_mat_id_1ae59baf_fk_universidad_material_id` FOREIGN KEY (`id_mat_id`) REFERENCES `universidad_material` (`id`),
ADD CONSTRAINT `laboratorios_lab_usuario_id_10c9a742_fk_auth_user_id` FOREIGN KEY (`usuario_id`) REFERENCES `auth_user` (`id`);
--
-- Filtros para la tabla `laboratorios_labcomputo`
--
ALTER TABLE `laboratorios_labcomputo`
ADD CONSTRAINT `laboratorios_labcomp_id_area_id_c05f985a_fk_universid` FOREIGN KEY (`id_area_id`) REFERENCES `universidad_area` (`id`),
ADD CONSTRAINT `laboratorios_labcomp_id_asig_id_719a8349_fk_universid` FOREIGN KEY (`id_asig_id`) REFERENCES `universidad_asignatura` (`id`),
ADD CONSTRAINT `laboratorios_labcomp_id_lab_id_c06eab3c_fk_universid` FOREIGN KEY (`id_lab_id`) REFERENCES `universidad_laboratorio` (`id`),
ADD CONSTRAINT `laboratorios_labcomp_id_mat_id_d9db573b_fk_universid` FOREIGN KEY (`id_mat_id`) REFERENCES `universidad_material` (`id`),
ADD CONSTRAINT `laboratorios_labcomputo_usuario_id_6869c1d4_fk_auth_user_id` FOREIGN KEY (`usuario_id`) REFERENCES `auth_user` (`id`);
--
-- Filtros para la tabla `universidad_asignatura`
--
ALTER TABLE `universidad_asignatura`
ADD CONSTRAINT `universidad_asignatu_id_carrera_id_87eca5c4_fk_universid` FOREIGN KEY (`id_carrera_id`) REFERENCES `universidad_carrera` (`id`);
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 */;
Reference in New Issue View Git Blame Copy Permalink