-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 12-03-2026 a las 15:37:36
-- Versión del servidor: 10.4.32-MariaDB
-- Versión de PHP: 8.2.12

START TRANSACTION;



--
-- Base de datos: `adminolt`
--

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

--
-- Estructura de tabla para la tabla `activity_logs`
--

CREATE TABLE `activity_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `olt_device_id` bigint(20) UNSIGNED DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `target` varchar(255) DEFAULT NULL,
  `commands` text DEFAULT NULL,
  `output` text DEFAULT NULL,
  `success` tinyint(1) NOT NULL DEFAULT 1,
  `ip_address` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `activity_logs` (`id`, `user_id`, `olt_device_id`, `action`, `target`, `commands`, `output`, `success`, `ip_address`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'authorize_onu', 'gpon-onu_1/13/16:1', 'interface gpon-olt_1/13/16\n  onu 1 type ZTE-F680 sn ZTEGD4F664ED\n!\ninterface gpon-onu_1/13/16:1\n  description nodo netd\n  name nextfibger\n  sn-bind enable sn\n  tcont 1 profile UP1000M\n  gemport 1 tcont 1\n  switchport mode hybrid vport 1\n  service-port 13 vport 1 user-vlan 510 vlan 510\n!\npon-onu-mng gpon-onu_1/13/16:1\n  service INTERNET gemport 1 vlan 510', 'interface gpon-olt_1/13/16\r\n                  ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  onu 1 type ZTE-F680 sn ZTEGD4F664ED\r\n                    ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#!\r\nNextFiber-C300-Ss#interface gpon-onu_1/13/16:1\r\n                  ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  description nodo netd\r\n                      ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  name nextfibger\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  sn-bind enable sn\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  tcont 1 profile UP1000M\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  gemport 1 tcont 1\r\n                    ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  switchport mode hybrid vport 1\r\n                      ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  service-port 13 vport 1 user-vlan 510 vlan 510\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#!\r\nNextFiber-C300-Ss#pon-onu-mng gpon-onu_1/13/16:1\r\n                   ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  service INTERNET gemport 1 vlan 510\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#', 1, '192.168.110.200', '2026-03-12 02:46:15', '2026-03-12 02:46:15'),
(2, 1, 1, 'authorize_onu', 'gpon-onu_1/13/16:15', 'interface gpon-olt_1/13/16\n  onu 15 type ZTE-F680 sn ZTEGD4F664ED\n!\ninterface gpon-onu_1/13/16:15\n  description Prueba\n  name Prueba\n  sn-bind enable sn\n  tcont 1 profile UP1000M\n  gemport 1 tcont 1\n  switchport mode hybrid vport 1\n  service-port 16 vport 1 user-vlan 510 vlan 510\n!\npon-onu-mng gpon-onu_1/13/16:15\n  service INTERNET gemport 1 vlan 510', 'interface gpon-olt_1/13/16\r\n                  ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  onu 15 type ZTE-F680 sn ZTEGD4F664ED\r\n                    ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#!\r\nNextFiber-C300-Ss#interface gpon-onu_1/13/16:15\r\n                  ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  description Prueba\r\n                      ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  name Prueba\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  sn-bind enable sn\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  tcont 1 profile UP1000M\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  gemport 1 tcont 1\r\n                    ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  switchport mode hybrid vport 1\r\n                      ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  service-port 16 vport 1 user-vlan 510 vlan 510\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#!\r\nNextFiber-C300-Ss#pon-onu-mng gpon-onu_1/13/16:15\r\n                   ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#  service INTERNET gemport 1 vlan 510\r\n                     ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextFiber-C300-Ss#', 1, '192.168.110.200', '2026-03-12 02:49:06', '2026-03-12 02:49:06'),
(3, 1, 1, 'authorize_onu', 'gpon-onu_1/13/16:17', 'configure terminal\ninterface gpon-olt_1/13/16\nonu 17 type ZTE-F680 sn ZTEGD4F664ED\nexit\ninterface gpon-onu_1/13/16:17\ndescription Prueba\nname Prueba\nsn-bind enable sn\ntcont 1 profile UP1000M\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 16 vport 1 user-vlan 510 vlan 510\nexit\npon-onu-mng gpon-onu_1/13/16:17\nservice INTERNET gemport 1 vlan 510\nexit\nexit', 'configure terminal\r\n%Info 20272: Enter configuration commands, one per line. End with CTRL/Z.\r\nNextFiber-C300-Ss(config)#interface gpon-olt_1/13/16\r\nNextFiber-C300-Ss(config-if)#onu 17 type ZTE-F680 sn ZTEGD4F664ED\r\n.[Successful]\r\nNextFiber-C300-Ss(config-if)#exit\r\nNextFiber-C300-Ss(config)#interface gpon-onu_1/13/16:17\r\nNextFiber-C300-Ss(config-if)#description Prueba\r\nNextFiber-C300-Ss(config-if)#name Prueba\r\nNextFiber-C300-Ss(config-if)#sn-bind enable sn\r\nNextFiber-C300-Ss(config-if)#tcont 1 profile UP1000M\r\nNextFiber-C300-Ss(config-if)#gemport 1 tcont 1\r\nNextFiber-C300-Ss(config-if)#switchport mode hybrid vport 1\r\nNextFiber-C300-Ss(config-if)#service-port 16 vport 1 user-vlan 510 vlan 510\r\nNextFiber-C300-Ss(config-if)#exit\r\nNextFiber-C300-Ss(config)#pon-onu-mng gpon-onu_1/13/16:17\r\nNextFiber-C300-Ss(gpon-onu-mng 1/13/16:17)#service INTERNET gemport 1 vlan 510$ERNET gemport 1 vlan 510           \r\nNextFiber-C300-Ss(gpon-onu-mng 1/13/16:17)#exit\r\nNextFiber-C300-Ss(config)#exit\r\nNextFiber-C300-Ss#', 1, '192.168.110.200', '2026-03-12 03:11:18', '2026-03-12 03:11:18'),
(4, 1, 1, 'authorize_onu', 'gpon-onu_1/13/16:1', 'configure terminal\ninterface gpon-olt_1/13/16\nonu 1 type ZTE-F680 sn ZTEGD38D800E\nexit\ninterface gpon-onu_1/13/16:1\ndescription PRUEBA 3\nname PRUEBA 3\nsn-bind enable sn\ntcont 1 profile UP1000M\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 16 vport 1 user-vlan 510 vlan 510\nexit\npon-onu-mng gpon-onu_1/13/16:1\nservice INTERNET gemport 1 vlan 510\nexit\nexit', 'configure terminal\r\n%Info 20272: Enter configuration commands, one per line. End with CTRL/Z.\r\nNextFiber-C300-Ss(config)#interface gpon-olt_1/13/16\r\nNextFiber-C300-Ss(config-if)#onu 1 type ZTE-F680 sn ZTEGD38D800E\r\n.[Successful]\r\nNextFiber-C300-Ss(config-if)#exit\r\nNextFiber-C300-Ss(config)#interface gpon-onu_1/13/16:1\r\nNextFiber-C300-Ss(config-if)#description PRUEBA 3\r\nNextFiber-C300-Ss(config-if)#name PRUEBA 3\r\nNextFiber-C300-Ss(config-if)#sn-bind enable sn\r\nNextFiber-C300-Ss(config-if)#tcont 1 profile UP1000M\r\nNextFiber-C300-Ss(config-if)#gemport 1 tcont 1\r\nNextFiber-C300-Ss(config-if)#switchport mode hybrid vport 1\r\nNextFiber-C300-Ss(config-if)#service-port 16 vport 1 user-vlan 510 vlan 510\r\nNextFiber-C300-Ss(config-if)#exit\r\nNextFiber-C300-Ss(config)#pon-onu-mng gpon-onu_1/13/16:1\r\nNextFiber-C300-Ss(gpon-onu-mng 1/13/16:1)#service INTERNET gemport 1 vlan 510\r\nNextFiber-C300-Ss(gpon-onu-mng 1/13/16:1)#exit\r\nNextFiber-C300-Ss(config)#exit\r\nNextFiber-C300-Ss#', 1, '192.168.110.200', '2026-03-12 03:53:54', '2026-03-12 03:53:54'),
(5, 1, 3, 'authorize_onu', 'ZTEGDA197EAF', 'configure terminal\ninterface gpon-olt_1/7/5\nonu 4 type ZTE-F680 sn ZTEGDA197EAF\nexit\ninterface gpon-onu_1/7/5:4\ndescription NF_YURI YUCRA TUNKI\nname YURI YUCRA TUNKI\nsn-bind enable sn\ntcont 1 profile UP1G\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 5 vport 1 user-vlan 2500 vlan 2500\nexit\npon-onu-mng gpon-onu_1/7/5:4\nservice INTERNET gemport 1 vlan 2500\nexit\nexit', 'configure terminal\r\n%Info 20272: Enter configuration commands, one per line. End with CTRL/Z.\r\nNextfiber-Puerto-M(config)#interface gpon-olt_1/7/5\r\nNextfiber-Puerto-M(config-if)#onu 4 type ZTE-F680 sn ZTEGDA197EAF\r\n%Code 63904-GPONRM : Not support this ONU.\r\nNextfiber-Puerto-M(config-if)#exit\r\nNextfiber-Puerto-M(config)#interface gpon-onu_1/7/5:4\r\n                                     ^\r\n%Error 20202: Invalid input detected at \'^\' marker.Invalid parameter\r\nNextfiber-Puerto-M(config)#description NF_YURI YUCRA TUNKI\r\n                             ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M(config)#name YURI YUCRA TUNKI\r\n                            ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M(config)#sn-bind enable sn\r\n                             ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M(config)#tcont 1 profile UP1G\r\n                            ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M(config)#gemport 1 tcont 1\r\n                            ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M(config)#switchport mode hybrid vport 1\r\n                                 ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M(config)#service-port 5 vport 1 user-vlan 2500 vlan 2500\r\n                                  ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M(config)#exit\r\nNextfiber-Puerto-M#pon-onu-mng gpon-onu_1/7/5:4\r\n                    ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M#service INTERNET gemport 1 vlan 2500\r\n                    ^\r\n%Error 20200: Invalid input detected at \'^\' marker.Invalid command\r\nNextfiber-Puerto-M#exit\r\nThe configuration is changed,confirm to logout without saving? [yes/no]:exit\r\n\r\n%Error 20205: Invalid input detected at \'^\' marker in mutual command\r\nNextfiber-Puerto-M#', 0, '192.168.110.200', '2026-03-12 04:05:36', '2026-03-12 04:05:36'),
(6, 2, 1, 'authorize_onu', 'gpon-onu_1/13/16:2', 'configure terminal\ninterface gpon-olt_1/13/16\nonu 2 type ZTE-F680 sn ZTEGD422A58C\nexit\ninterface gpon-onu_1/13/16:2\ndescription NEXTFIBER\nname NEXTFIBER\nsn-bind enable sn\ntcont 1 profile UP1000M\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 16 vport 1 user-vlan 510 vlan 510\nexit\npon-onu-mng gpon-onu_1/13/16:2\nservice INTERNET gemport 1 vlan 510\nexit\nexit', 'configure terminal\r\n%Info 20272: Enter configuration commands, one per line. End with CTRL/Z.\r\nNextFiber-C300-Ss(config)#interface gpon-olt_1/13/16\r\nNextFiber-C300-Ss(config-if)#onu 2 type ZTE-F680 sn ZTEGD422A58C\r\n.[Successful]\r\nNextFiber-C300-Ss(config-if)#exit\r\nNextFiber-C300-Ss(config)#interface gpon-onu_1/13/16:2\r\nNextFiber-C300-Ss(config-if)#description NEXTFIBER\r\nNextFiber-C300-Ss(config-if)#name NEXTFIBER\r\nNextFiber-C300-Ss(config-if)#sn-bind enable sn\r\nNextFiber-C300-Ss(config-if)#tcont 1 profile UP1000M\r\nNextFiber-C300-Ss(config-if)#gemport 1 tcont 1\r\nNextFiber-C300-Ss(config-if)#switchport mode hybrid vport 1\r\nNextFiber-C300-Ss(config-if)#service-port 16 vport 1 user-vlan 510 vlan 510\r\nNextFiber-C300-Ss(config-if)#exit\r\nNextFiber-C300-Ss(config)#pon-onu-mng gpon-onu_1/13/16:2\r\nNextFiber-C300-Ss(gpon-onu-mng 1/13/16:2)#service INTERNET gemport 1 vlan 510\r\nNextFiber-C300-Ss(gpon-onu-mng 1/13/16:2)#exit\r\nNextFiber-C300-Ss(config)#exit\r\nNextFiber-C300-Ss#', 1, '192.168.110.200', '2026-03-12 19:21:42', '2026-03-12 19:21:42');

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

--
-- Estructura de tabla para la tabla `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_03_11_200011_create_olt_devices_table', 1),
(5, '2026_03_11_200012_create_olt_ports_table', 1),
(6, '2026_03_11_200013_create_activity_logs_table', 1),
(7, '2026_03_11_200014_create_olt_onus_table', 1),
(8, '2026_03_11_230135_add_defaults_to_olt_devices_table', 2),
(9, '2026_03_12_134016_add_role_to_users_table', 3);

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

--
-- Estructura de tabla para la tabla `olt_onus`
--

CREATE TABLE `olt_onus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `olt_port_id` bigint(20) UNSIGNED NOT NULL,
  `onu_number` int(11) NOT NULL,
  `serial_number` varchar(255) NOT NULL,
  `onu_type` varchar(255) NOT NULL DEFAULT 'ZTE-F680',
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_description` varchar(255) DEFAULT NULL,
  `vlan` int(11) NOT NULL DEFAULT 510,
  `tcont_profile` varchar(255) NOT NULL DEFAULT 'UP1000M',
  `service_port` int(11) NOT NULL DEFAULT 2,
  `service_name` varchar(255) NOT NULL DEFAULT 'INTERNET',
  `status` enum('authorized','pending','disabled') NOT NULL DEFAULT 'authorized',
  `raw_config` text DEFAULT NULL,
  `authorized_at` timestamp NULL DEFAULT NULL,
  `authorized_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `olt_onus` (`id`, `olt_port_id`, `onu_number`, `serial_number`, `onu_type`, `customer_name`, `customer_description`, `vlan`, `tcont_profile`, `service_port`, `service_name`, `status`, `raw_config`, `authorized_at`, `authorized_by`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'ZTEGD4F664ED', 'ZTE-F680', 'nextfibger', 'nodo netd', 510, 'UP1000M', 13, 'INTERNET', 'authorized', 'interface gpon-olt_1/13/16\n  onu 1 type ZTE-F680 sn ZTEGD4F664ED\n!\ninterface gpon-onu_1/13/16:1\n  description nodo netd\n  name nextfibger\n  sn-bind enable sn\n  tcont 1 profile UP1000M\n  gemport 1 tcont 1\n  switchport mode hybrid vport 1\n  service-port 13 vport 1 user-vlan 510 vlan 510\n!\npon-onu-mng gpon-onu_1/13/16:1\n  service INTERNET gemport 1 vlan 510', '2026-03-12 02:46:15', 1, '2026-03-12 02:46:15', '2026-03-12 02:46:15'),
(2, 1, 15, 'ZTEGD4F664ED', 'ZTE-F680', 'Prueba', 'Prueba', 510, 'UP1000M', 16, 'INTERNET', 'authorized', 'interface gpon-olt_1/13/16\n  onu 15 type ZTE-F680 sn ZTEGD4F664ED\n!\ninterface gpon-onu_1/13/16:15\n  description Prueba\n  name Prueba\n  sn-bind enable sn\n  tcont 1 profile UP1000M\n  gemport 1 tcont 1\n  switchport mode hybrid vport 1\n  service-port 16 vport 1 user-vlan 510 vlan 510\n!\npon-onu-mng gpon-onu_1/13/16:15\n  service INTERNET gemport 1 vlan 510', '2026-03-12 02:49:06', 1, '2026-03-12 02:49:06', '2026-03-12 02:49:06'),
(3, 1, 17, 'ZTEGD4F664ED', 'ZTE-F680', 'Prueba', 'Prueba', 510, 'UP1000M', 16, 'INTERNET', 'authorized', 'configure terminal\ninterface gpon-olt_1/13/16\nonu 17 type ZTE-F680 sn ZTEGD4F664ED\nexit\ninterface gpon-onu_1/13/16:17\ndescription Prueba\nname Prueba\nsn-bind enable sn\ntcont 1 profile UP1000M\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 16 vport 1 user-vlan 510 vlan 510\nexit\npon-onu-mng gpon-onu_1/13/16:17\nservice INTERNET gemport 1 vlan 510\nexit\nexit', '2026-03-12 03:11:18', 1, '2026-03-12 03:11:18', '2026-03-12 03:11:18'),
(4, 1, 1, 'ZTEGD38D800E', 'ZTE-F680', 'PRUEBA 3', 'PRUEBA 3', 510, 'UP1000M', 16, 'INTERNET', 'authorized', 'configure terminal\ninterface gpon-olt_1/13/16\nonu 1 type ZTE-F680 sn ZTEGD38D800E\nexit\ninterface gpon-onu_1/13/16:1\ndescription PRUEBA 3\nname PRUEBA 3\nsn-bind enable sn\ntcont 1 profile UP1000M\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 16 vport 1 user-vlan 510 vlan 510\nexit\npon-onu-mng gpon-onu_1/13/16:1\nservice INTERNET gemport 1 vlan 510\nexit\nexit', '2026-03-12 03:53:54', 1, '2026-03-12 03:53:54', '2026-03-12 03:53:54'),
(5, 2, 4, 'ZTEGDA197EAF', 'ZTE-F680', 'YURI YUCRA TUNKI', 'NF_YURI YUCRA TUNKI', 2500, 'UP1G', 5, 'INTERNET', 'pending', 'configure terminal\ninterface gpon-olt_1/7/5\nonu 4 type ZTE-F680 sn ZTEGDA197EAF\nexit\ninterface gpon-onu_1/7/5:4\ndescription NF_YURI YUCRA TUNKI\nname YURI YUCRA TUNKI\nsn-bind enable sn\ntcont 1 profile UP1G\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 5 vport 1 user-vlan 2500 vlan 2500\nexit\npon-onu-mng gpon-onu_1/7/5:4\nservice INTERNET gemport 1 vlan 2500\nexit\nexit', NULL, NULL, '2026-03-12 04:05:36', '2026-03-12 04:05:36'),
(6, 1, 2, 'ZTEGD422A58C', 'ZTE-F680', 'NEXTFIBER', 'NEXTFIBER', 510, 'UP1000M', 16, 'INTERNET', 'authorized', 'configure terminal\ninterface gpon-olt_1/13/16\nonu 2 type ZTE-F680 sn ZTEGD422A58C\nexit\ninterface gpon-onu_1/13/16:2\ndescription NEXTFIBER\nname NEXTFIBER\nsn-bind enable sn\ntcont 1 profile UP1000M\ngemport 1 tcont 1\nswitchport mode hybrid vport 1\nservice-port 16 vport 1 user-vlan 510 vlan 510\nexit\npon-onu-mng gpon-onu_1/13/16:2\nservice INTERNET gemport 1 vlan 510\nexit\nexit', '2026-03-12 19:21:42', 2, '2026-03-12 19:21:42', '2026-03-12 19:21:42');

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

--
-- Estructura de tabla para la tabla `olt_ports`
--

CREATE TABLE `olt_ports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `olt_device_id` bigint(20) UNSIGNED NOT NULL,
  `frame` int(11) NOT NULL DEFAULT 1,
  `slot` int(11) NOT NULL,
  `port` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `olt_ports` (`id`, `olt_device_id`, `frame`, `slot`, `port`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 13, 16, NULL, '2026-03-12 02:46:00', '2026-03-12 02:46:00'),
(2, 3, 1, 7, 5, NULL, '2026-03-12 04:05:09', '2026-03-12 04:05:09');

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

--
-- Estructura de tabla para la tabla `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('a9a44CKb7Ewzw9wfGLDNLrf0qbN1cL2uoU094slY', 2, '192.168.110.200', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTHF0MGNJbFIwVmlNaURKd1Rxc2xTekNPZE91d1p1VEtBa2NmM05UcyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHA6Ly8xOTIuMTY4LjExMC4yMDAvYWRtaW5vbHQvcHVibGljL29udXMiO3M6NToicm91dGUiO3M6MTA6Im9udXMuaW5kZXgiO31zOjM6InVybCI7YTowOnt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjt9', 1773325379);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_logs_user_id_foreign` (`user_id`),
  ADD KEY `activity_logs_olt_device_id_foreign` (`olt_device_id`);

--
-- Indices de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indices de la tabla `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_reserved_at_available_at_index` (`queue`,`reserved_at`,`available_at`);

--
-- Indices de la tabla `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `olt_onus`
--
ALTER TABLE `olt_onus`
  ADD PRIMARY KEY (`id`),
  ADD KEY `olt_onus_olt_port_id_foreign` (`olt_port_id`),
  ADD KEY `olt_onus_authorized_by_foreign` (`authorized_by`);

--
-- Indices de la tabla `olt_ports`
--
ALTER TABLE `olt_ports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `olt_ports_olt_device_id_foreign` (`olt_device_id`);

--
-- Indices de la tabla `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `activity_logs`
--
ALTER TABLE `activity_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de la tabla `olt_onus`
--
ALTER TABLE `olt_onus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `olt_ports`
--
ALTER TABLE `olt_ports`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `activity_logs`
--
ALTER TABLE `activity_logs`
  ADD CONSTRAINT `activity_logs_olt_device_id_foreign` FOREIGN KEY (`olt_device_id`) REFERENCES `olt_devices` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `activity_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `olt_onus`
--
ALTER TABLE `olt_onus`
  ADD CONSTRAINT `olt_onus_authorized_by_foreign` FOREIGN KEY (`authorized_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `olt_onus_olt_port_id_foreign` FOREIGN KEY (`olt_port_id`) REFERENCES `olt_ports` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `olt_ports`
--
ALTER TABLE `olt_ports`
  ADD CONSTRAINT `olt_ports_olt_device_id_foreign` FOREIGN KEY (`olt_device_id`) REFERENCES `olt_devices` (`id`) ON DELETE CASCADE;
COMMIT;

