MariaDB [(none)]> source C:\xampp ( antiguo )\Final(actualizado).sql Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 1 row affected (0.001 sec) Database changed Query OK, 0 rows affected (0.005 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.025 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.024 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.020 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 4 rows affected (0.003 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.005 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.017 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.016 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 4 rows affected (0.003 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.017 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.027 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.004 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.023 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.000 sec) MariaDB [practicantesFacultadInenieriaUR]> show tables; +-------------------------------------------+ | Tables_in_practicantesfacultadinenieriaur | +-------------------------------------------+ | actividades | | actividadespracticantes | | areaconocimiento | | entrevista | | horarios | | instituciontec | | practicantes | | practicantesentrevista | +-------------------------------------------+ 8 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from actividades; +-----------+------------------------------------------+ | CodigoAct | Detalles | +-----------+------------------------------------------+ | 1 | Organizaci n de papeler a | | 2 | Atenci n a estudiantes y profesores | | 3 | Gesti n de agendas | | 4 | Manejo de correspondencia | | 5 | Preparaci n de informes | | 6 | Apoyo a eventos en la facultad | | 7 | Fotocopiado y escaneo de documentos | | 8 | Coordinaci n y asignaci n de aulas | | 9 | Asistencias en tareas administrativas | | 10 | Suministro e inventario de materiales en | +-----------+------------------------------------------+ 10 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from areaConocimiento; +------------+------------------------+------------+ | CodigoArea | detalles | CodigoHor1 | +------------+------------------------+------------+ | 1 | ingenier a de sistemas | 1 | | 2 | ingenier a civil | 2 | | 3 | ingenier a ambiental | 3 | | 4 | ingenier a industrial | 4 | +------------+------------------------+------------+ 4 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from entrevista; +-----------+---------------------+------------------------------------+ | CodigoEnt | nomEntrevistador | detalles | +-----------+---------------------+------------------------------------+ | 1 | Maria clara bonilla | Profesor de ingenier a de sistemas | | 2 | Jorge berm dez | Profesor de ingenier a de sistemas | | 3 | Daniel monsalve | Profesor de ingenier a industrial | | 4 | Manuel oliveira | Profesor de ingenier a ambiental | | 5 | Elizabteh lvarez | Profesor de ingener a industrial | | 6 | Diana pineda | Profesor de ingener a civil | | 7 | Oscar cort s | Profesor de ingener a civil | | 8 | Oscar tavarez | Profesor de ingener a civil | | 9 | David aguilar | Decano de ingener a | | 10 | Maria moncada | jefe de programa de ingener a | +-----------+---------------------+------------------------------------+ 10 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from horarios; +-----------+----------------------+ | CodigoHor | detalles | +-----------+----------------------+ | 1 | 06:30 am - 15:30 pm | | 2 | 06:50 am - 15:50 pm | | 3 | 07:00 am - 16:00 pm | | 4 | 07:30 am - 16:30 pm | +-----------+----------------------+ 4 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from institucionTec; +------------+--------------------------------+ | CodigoInst | nombre | +------------+--------------------------------+ | 1 | Cesde | | 2 | Sena | | 3 | polit cnico ciandco | | 4 | polit cnico de sur mericana | | 5 | Polit cnico de colombia | | 6 | Centro de formaci n de antioqu | | 7 | Instituto t cnico de eduaci n | | 8 | Instituto t cnico antioque o | | 9 | Corporaci n eduactiva ITAE | | 10 | Instituto t cnico laboral de a | +------------+--------------------------------+ 10 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from practicantes; +-------------+------------------------+-----------+------------+-------------+-------------+ | CodigoPract | Nombre | Direccion | telefono | CodigoInst1 | CodigoArea1 | +-------------+------------------------+-----------+------------+-------------+-------------+ | 1 | Ana Mar a L pez | Cra 70-20 | 3102516231 | 1 | 1 | | 2 | Juan carlos P rez | Cra 32-56 | 3104521365 | 4 | 3 | | 3 | Mar a Fernanda G mez | Cra 48-21 | 3145236415 | 6 | 4 | | 4 | Luis alberto rodr guez | Cra 54-19 | 3013248974 | 4 | 2 | | 5 | Catalina Ram rez | Cra 28-04 | 3022013452 | 2 | 1 | | 6 | Jorge Andr s Mart nez | Cra 24-31 | 3022083751 | 8 | 1 | | 7 | Laura isabel S nchez | Cra 64-31 | 3107846531 | 3 | 2 | | 8 | Carlos Eduardo Ram rez | Cra 52-28 | 3105642137 | 5 | 4 | | 9 | Sofia Patricia Torres | Cra 55-21 | 3145879465 | 4 | 3 | | 10 | Miguel ngel Castillo | Cra 37-31 | 3102541324 | 8 | 2 | +-------------+------------------------+-----------+------------+-------------+-------------+ 10 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> create table historial_entrevistas ( -> idHistorial int auto_increment primary key, -> CodigoEnt int, -> nomEntrevistador varchar(30), -> detalles varchar(40), -> fecha_eliminacion datetime, -> foreign key (CodigoEnt) references entrevista(CodigoEnt) on delete cascade -> ); Query OK, 0 rows affected (0.095 sec) MariaDB [practicantesFacultadInenieriaUR]> Delimiter // MariaDB [practicantesFacultadInenieriaUR]> create trigger after_delete_entrevista after delete on entrevista -> for each row -> begin -> insert into historial_entrevistas (CodigoEnt, nomEntrevistador, detalles, fecha_eliminacion) values (null, old.nomEntrevistador, old.detalles, now()); -> end -> // Query OK, 0 rows affected (0.069 sec) MariaDB [practicantesFacultadInenieriaUR]> delimiter ; MariaDB [practicantesFacultadInenieriaUR]> delete from entrevista where codigoEnt = 1; Query OK, 1 row affected (0.040 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from entrevista; +-----------+-------------------+------------------------------------+ | CodigoEnt | nomEntrevistador | detalles | +-----------+-------------------+------------------------------------+ | 2 | Jorge berm dez | Profesor de ingenier a de sistemas | | 3 | Daniel monsalve | Profesor de ingenier a industrial | | 4 | Manuel oliveira | Profesor de ingenier a ambiental | | 5 | Elizabteh lvarez | Profesor de ingener a industrial | | 6 | Diana pineda | Profesor de ingener a civil | | 7 | Oscar cort s | Profesor de ingener a civil | | 8 | Oscar tavarez | Profesor de ingener a civil | | 9 | David aguilar | Decano de ingener a | | 10 | Maria moncada | jefe de programa de ingener a | +-----------+-------------------+------------------------------------+ 9 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from historial_entrevistas; +-------------+-----------+---------------------+------------------------------------+---------------------+ | idHistorial | CodigoEnt | nomEntrevistador | detalles | fecha_eliminacion | +-------------+-----------+---------------------+------------------------------------+---------------------+ | 2 | NULL | Maria clara bonilla | Profesor de ingenier a de sistemas | 2025-03-15 12:08:39 | +-------------+-----------+---------------------+------------------------------------+---------------------+ 1 row in set (0.000 sec) MariaDB [practicantesFacultadInenieriaUR]> delete from entrevista where codigoEnt = 10; Query OK, 1 row affected (0.065 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from entrevista; +-----------+-------------------+------------------------------------+ | CodigoEnt | nomEntrevistador | detalles | +-----------+-------------------+------------------------------------+ | 2 | Jorge berm dez | Profesor de ingenier a de sistemas | | 3 | Daniel monsalve | Profesor de ingenier a industrial | | 4 | Manuel oliveira | Profesor de ingenier a ambiental | | 5 | Elizabteh lvarez | Profesor de ingener a industrial | | 6 | Diana pineda | Profesor de ingener a civil | | 7 | Oscar cort s | Profesor de ingener a civil | | 8 | Oscar tavarez | Profesor de ingener a civil | | 9 | David aguilar | Decano de ingener a | +-----------+-------------------+------------------------------------+ 8 rows in set (0.000 sec) MariaDB [practicantesFacultadInenieriaUR]> select * from historial_entrevistas; +-------------+-----------+---------------------+------------------------------------+---------------------+ | idHistorial | CodigoEnt | nomEntrevistador | detalles | fecha_eliminacion | +-------------+-----------+---------------------+------------------------------------+---------------------+ | 2 | NULL | Maria clara bonilla | Profesor de ingenier a de sistemas | 2025-03-15 12:08:39 | | 3 | NULL | Maria moncada | jefe de programa de ingener a | 2025-03-15 12:09:15 | +-------------+-----------+---------------------+------------------------------------+---------------------+ 2 rows in set (0.001 sec) MariaDB [practicantesFacultadInenieriaUR]> exit