| Server IP : 74.208.127.88 / Your IP : 3.144.88.107 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/apirestE/nppBackup/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Servidor: 127.0.0.1 -- Tiempo de generación: 28-02-2025 a las 19:37:26 -- Versión del servidor: 10.4.21-MariaDB -- Versión de PHP: 7.3.31 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: `victoria` -- -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `employee` -- CREATE TABLE `employee` ( `id_cust` int(11) NOT NULL, `name` varchar(40) NOT NULL, `contract` int(11) NOT NULL, `Sueldo` decimal(14,2) DEFAULT NULL, `direccion` varchar(250) DEFAULT NULL, `come_in` varchar(200) DEFAULT NULL, `id_ruta` int(11) DEFAULT 2, `route_id` int(11) DEFAULT NULL, `poblacion` varchar(40) DEFAULT NULL, `phone` char(35) DEFAULT NULL, `id_puesto` int(11) NOT NULL DEFAULT 1, `status` int(11) DEFAULT 1, `dateUp` date DEFAULT NULL, `dateBaja` date DEFAULT NULL, `dateReUp` date DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `date_emp` date DEFAULT '2022-07-01' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Volcado de datos para la tabla `employee` -- INSERT INTO `employee` (`id_cust`, `name`, `contract`, `Sueldo`, `direccion`, `come_in`, `id_ruta`, `route_id`, `poblacion`, `phone`, `id_puesto`, `status`, `dateUp`, `dateBaja`, `dateReUp`, `created_at`, `date_emp`) VALUES (53, 'PEDRO PLACIDO DE HOYOS GUERRA', 1, NULL, NULL, NULL, 6, 11, 'javier mina', '8621090747', 1, 1, '2011-05-09', NULL, NULL, '2024-03-22 04:40:08', '2024-03-16'), (54, 'OLGA LETICIA CARDONA RAMIREZ', 2, NULL, NULL, NULL, 1, NULL, 'JAVIER MINA', '8621272786', 1, 1, '2011-05-09', NULL, NULL, '2024-03-16 06:05:01', '2024-03-04'), (55, 'FRANCISCO J. DE HOYOS GUERRA ', 3, NULL, NULL, NULL, 6, NULL, 'ALLENDE COAH ', '8661325345', 1, 1, '2012-08-09', NULL, NULL, '2024-03-16 06:43:02', '2024-03-14'), (57, 'MARIA DE LA LUZ MARTINEZ SALAZAR ', 5, NULL, NULL, NULL, 1, NULL, 'ALLENDE COAH ', '8626294228', 1, 1, '2014-09-04', NULL, NULL, '2024-03-16 06:25:57', '2023-10-11'), (58, 'JUAN PABLO FUENTES ENRIQUEZ', 6, NULL, NULL, NULL, 2, NULL, 'ALLENDE COAH ', '8621207841', 2, 1, '2016-10-01', NULL, NULL, '2024-03-16 06:43:10', '2024-03-13'), (59, 'LEONEL S. HERNANDEZ SANCHEZ', 7, NULL, NULL, NULL, 4, 20, 'ALLENDE COAH ', '8621245936', 3, 1, '2019-08-26', NULL, NULL, '2025-02-27 19:10:40', '2024-03-14'), (61, 'RICARDO A. ARENAS DE HOYOS', 9, NULL, NULL, NULL, 2, NULL, 'ALLENDE COAH ', '8781398278', 2, 1, '2023-01-21', NULL, NULL, '2025-02-27 18:26:48', '2024-03-14'), (62, 'JOSE JAVIER ROSAS HUERTA', 10, NULL, NULL, NULL, 2, 4, 'NAVA COAH', '8132334000', 2, 1, '2023-07-01', NULL, NULL, '2025-02-27 19:33:53', '2025-02-27'), (63, 'JOSE AGUSTIN CRUZ BARRIENTOS', 11, NULL, NULL, NULL, 2, 5, 'ZARAGOZA ', '8782108758', 2, 1, '2023-05-23', NULL, NULL, '2024-03-18 19:17:24', '2023-10-28'), (64, 'ALONDRA M. MARTINEZ HERNANDEZ', 12, NULL, NULL, NULL, 3, NULL, 'ALLENDE COAH ', '8621113185', 3, 1, '2023-09-20', NULL, NULL, '2024-03-15 03:04:32', '2024-03-14'), (67, 'MARIELA G. MEDINA JUAREZ', 15, NULL, NULL, NULL, NULL, NULL, 'ALLENDE COAH ', '8626282293', 2, 0, '2023-11-17', '2024-03-21', NULL, '2024-04-11 01:08:12', '2024-04-10'), (71, 'JORGE ARMANDO RIOJAS MENDOZA', 17, NULL, NULL, NULL, 2, 2, 'ZARAGOZA 63', '8781369579', 2, 1, '2024-01-17', NULL, NULL, '2024-03-18 19:12:31', '2024-02-19'), (73, 'ALFONSO NICANOR MORENO ORTIZ', 21, NULL, NULL, NULL, 2, 12, 'ALLENDE COAH ', '8626294583', 2, 1, '2024-02-07', NULL, NULL, '2024-04-16 15:48:26', '2024-03-22'), (74, 'PEDRO P.DE HOYOS CARDONA', 4, NULL, NULL, NULL, 5, 6, 'MINA 1102 PONT.', '8621099114', 1, 1, '2013-05-09', NULL, NULL, '2024-05-08 01:14:50', '2024-03-14'), (83, 'FRANCISCO SANCHEZ PEREZ ', 22, NULL, NULL, NULL, NULL, NULL, 'OCAMPO 112', '8621107185', 2, 0, '2023-11-15', '2024-03-23', NULL, '2024-04-11 01:02:27', '2024-04-10'), (86, 'ZARAGOZA GALAVIZ TORREZ', 23, NULL, NULL, NULL, 2, 1, 'NAVA 48 ', '8626288051', 2, 1, '2024-03-02', NULL, NULL, '2025-02-27 18:26:48', '2024-04-15'), (87, 'JOSE ALFREDO LARA DOMINGUEZ', 24, NULL, NULL, NULL, NULL, NULL, 'DORA E, GARCIA ', '8781350193', 2, 0, '2024-04-10', '2024-04-21', NULL, '2024-05-08 01:11:20', '2024-05-07'); -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `employee` -- ALTER TABLE `employee` ADD PRIMARY KEY (`id_cust`), ADD UNIQUE KEY `contract` (`contract`), ADD UNIQUE KEY `name` (`name`), ADD UNIQUE KEY `route_id_2` (`route_id`), ADD KEY `id_ruta` (`id_ruta`), ADD KEY `route_id` (`route_id`); -- -- AUTO_INCREMENT de las tablas volcadas -- -- -- AUTO_INCREMENT de la tabla `employee` -- ALTER TABLE `employee` MODIFY `id_cust` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88; 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 */;