
--
-- Table structure for table `server`
--

CREATE TABLE `server` (
  `id_server` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `status` int NOT NULL,
  PRIMARY KEY (`id_server`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `server`
--

INSERT INTO `server` VALUES (1,'windows',1),(2,'linux',0);

--
-- Table structure for table `servicios`
--

CREATE TABLE `servicios` (
  `servicio_id` int NOT NULL AUTO_INCREMENT,
  `nombre_servicio` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `costo_servicio` decimal(20,2) NOT NULL DEFAULT '0.00',
  `status` enum('activo','inactivo') CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL DEFAULT 'activo',
  PRIMARY KEY (`servicio_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `servicios`
--

INSERT INTO `servicios` VALUES (1,'Television',50.00,'activo');

--
-- Table structure for table `servicios_adicionales`
--

CREATE TABLE `servicios_adicionales` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cliente_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `servicio_id` int NOT NULL,
  `costo_servicio` decimal(20,2) NOT NULL DEFAULT '0.00',
  `equipo_id` int NOT NULL,
  `serie_equipo` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `equipo_status` int NOT NULL DEFAULT '1',
  `paquete` int DEFAULT NULL,
  `wan` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci DEFAULT NULL,
  `ap` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci DEFAULT NULL,
  `mac` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci DEFAULT NULL,
  `status_servicio` enum('activo','suspendido','pausado','cancelado') CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL DEFAULT 'activo',
  `fecha_creacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fecha_modificacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `cliente_id` (`cliente_id`),
  KEY `servicio_id` (`servicio_id`),
  KEY `equipo_id` (`equipo_id`),
  KEY `status_equipo` (`equipo_status`)
) ENGINE=InnoDB AUTO_INCREMENT=292 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `servicios_adicionales`
--

INSERT INTO `servicios_adicionales` VALUES (1,'BADUAL305',1,50.00,1,'SMARTV',1,1,'192.168.16.77','192.168.1.50','2C:52:AF:21:29:45','activo','2024-05-01 12:01:30','2024-05-01 12:01:30'),(2,'ISISDAHEBA461',1,50.00,1,'1233215465',1,1,'192.168.16.91','192.168.1.50','C0:68:CC:53:31:A9','pausado','2024-05-01 14:26:52','2024-05-01 14:26:52'),(3,'BAEVME255',1,50.00,1,'45455454',1,2,'192.168.16.35','192.168.1.50','34:A2:A2:20:F2:E4','pausado','2024-05-01 14:38:21','2024-07-02 15:59:24'),(4,'ISISEDROCA697',1,50.00,1,'SMARTV',1,1,'192.168.16.108','192.168.1.50','C0:68:CC:4E:39:31','pausado','2024-05-02 09:54:58','2024-05-22 11:44:28'),(5,'ISISMAFAME416',1,50.00,1,'SMARTV',1,1,'192.168.0.155','192.168.1.50','10:55:E4:56:E5:45','pausado','2024-05-03 14:18:06','2024-05-03 14:18:06'),(6,'ISISSAMAME561',1,50.00,1,'SMARTV',1,22,'192.168.0.79','192.168.1.50','C0:68:CC:50:35:39','pausado','2024-05-05 09:31:40','2024-08-28 11:56:46'),(7,'MEMAFA00174',1,50.00,1,'smartv',1,22,'192.168.0.98','192.168.1.50','E4C32AFB2275','pausado','2024-05-07 15:51:48','2025-08-29 23:16:55'),(8,'TEDEGO182',1,0.00,1,'22222',1,7,'192.168.91.244','192.168.1.111','54:37:BB:01:D8:F4','activo','2024-05-10 13:47:04','2024-07-19 11:54:28'),(11,'ISISMAPERI716',1,50.00,1,'12541',1,22,'192.168.16.209','192.168.1.50','D4:01:45:27:00:31','pausado','2024-05-29 12:43:14','2025-06-02 14:14:46'),(12,'ISISJEVAIN712',1,50.00,1,'tv box',1,22,'192.168.16.157','192.168.1.120','C0:68:CC:48:7E:99','activo','2024-05-29 15:05:25','2024-08-27 05:29:42'),(13,'ISISCAMAME578',1,50.00,1,'ESTEREN01',1,1,'192.168.0.33','192.168.1.240','E8:F6:54:A8:A6:B0','activo','2024-05-31 10:53:02','2024-05-31 10:53:02'),(14,'BAEDMA297',1,50.00,1,'ESTEREN02',1,2,'192.168.18.146','192.168.1.120','2C:52:AF:48:BD:68','pausado','2024-05-31 11:00:15','2025-02-11 20:43:22'),(15,'ISISDAHEBA614',1,50.00,1,'ESTEREN03',1,1,'192.168.20.222','192.168.1.120','C0:68:CC:0E:7C:6D','activo','2024-05-31 11:04:25','2024-05-31 11:04:25'),(16,'ISISLIMABA726',1,50.00,1,'lizbethmc',1,1,'192.168.17.8','192.168.1.120','E8:F6:54:E2:0A:00','activo','2024-06-01 09:37:38','2024-06-19 10:39:28'),(17,'ISISLOHEBA727',1,50.00,1,'STEREN',1,22,'192.168.18.63','192.168.1.120','08:5C:1B:39:5D:0D','activo','2024-06-01 14:04:35','2024-12-31 00:10:22'),(18,'ISISLAARBA429',1,50.00,1,'ESTEREN04',1,22,'192.168.18.39','192.168.1.120','C4:EB:FF:36:AD:23','pausado','2024-06-03 10:49:49','2025-05-08 18:25:49'),(19,'ISISJOSAJA736',1,50.00,1,'SMARTV',1,22,'192.168.16.143','192.168.1.50','A8:E8:1E:97:32:A1','activo','2024-06-09 13:25:41','2024-12-26 14:32:27'),(20,'ISISKAVABA731',1,50.00,2,'SMARTV',1,2,'192.168.17.23','192.168.1.120','C8:4C:78:31:AB:12','activo','2024-06-11 17:20:00','2026-01-04 00:42:52'),(22,'ISISFEBAJA745',1,50.00,1,'SMARTV',1,1,'192.168.16.89','192.168.1.50','A8:E8:1E:A9:E7:A1','pausado','2024-06-15 16:42:50','2024-07-10 14:35:40'),(23,'ISISRODEJA702',1,50.00,1,'SMARTV',1,1,'192.168.16.149','192.168.1.50','F4:2D:06:96:EE:3E','pausado','2024-06-18 17:26:33','2024-07-24 08:34:31'),(24,'ISISMEGOCA428',1,50.00,1,'SMARTV',1,22,'192.168.16.116','192.168.1.120','E8:48:BB:16:5D:74','pausado','2024-06-19 08:48:24','2024-09-27 04:53:23'),(25,'ISISMIFLJA703',1,50.00,1,'xxxx',1,22,'192.168.16.132','192.168.1.50','F4:2D:06:96:F3:06','activo','2024-06-19 09:09:05','2025-02-08 02:46:14'),(26,'ISISBESAME451',1,50.00,2,'SMARTV',1,9,'192.168.16.8','192.168.1.50','74:83:C2:50:C1:18','pausado','2024-06-19 12:42:35','2025-01-07 16:24:21'),(27,'ISISLUSAJA749',1,50.00,1,'SMARTV',1,22,'192.168.17.118','192.168.1.50','44:A3:C7:E7:17:E4','activo','2024-06-19 14:12:42','2025-08-20 00:51:50'),(28,'ISISOMPECA750',1,50.00,1,'SMARTV',1,2,'192.168.17.54','192.168.1.50','44:A3:C7:2B:B3:A0','activo','2024-06-20 17:00:09','2024-09-11 11:11:13'),(29,'ISISARCOOB740',1,50.00,1,'aaaa',1,22,'192.168.17.42','192.168.1.120','E8:F6:54:E4:97:03','pausado','2024-06-21 18:52:57','2024-08-12 06:06:20'),(30,'ISISYULACA710',1,50.00,1,'SMARTV',1,1,'192.168.16.16','192.168.1.50','44:A3:C7:2B:B3:76','pausado','2024-06-25 13:39:03','2024-06-25 13:39:03'),(31,'ISISSAPEME764',1,50.00,1,'SMARTV',1,22,'192.168.0.164','192.168.1.240','C0:68:CC:53:1C:31','pausado','2024-07-03 14:38:46','2025-07-17 21:13:54'),(32,'ISISPANUCA770',1,50.00,1,'ROKU',1,1,'192.168.17.57','192.168.1.50','10:55:E4:5D:8C:55','activo','2024-07-07 15:27:50','2024-08-07 13:55:04'),(33,'ISISANL',1,50.00,1,'SMARTV',1,22,'192.168.16.168','192.168.1.120','C0:68:CC:51:13:E1','activo','2024-07-09 09:42:42','2024-11-16 00:25:49'),(34,'ISISROGABA772',1,50.00,1,'ROKU',1,22,'192.168.17.64','192.168.1.120','C0:68:CC:45:57:B9','pausado','2024-07-09 11:56:41','2024-08-27 09:30:48'),(35,'ISISJOTOPO776',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-07-13 16:35:37','2025-01-17 20:14:04'),(36,'ISISCRMOME454',1,50.00,2,'SMARTV',1,22,'192.168.0.182','192.168.1.240','A4:6D:A4:3B:08:EA','pausado','2024-07-17 19:11:38','2025-09-15 16:19:47'),(37,'ISISDECOBA776',1,50.00,2,'SMARTV',1,1,'192.168.16.155','192.168.1.120','44:A3:C7:CF:78:1E','activo','2024-07-18 12:20:35','2024-07-18 12:20:35'),(38,'ISISHITAPO779',1,50.00,1,'SMARTV',1,22,'192.168.16.192','192.168.1.50','44:A3:C7:32:DB:3A','activo','2024-07-19 12:21:59','2025-01-07 21:14:10'),(39,'ISISSHGAPO780',1,50.00,1,'SMARTV',1,22,'192.168.16.214','192.168.1.50','F4:2D:06:83:97:98','pausado','2024-07-19 16:10:22','2024-10-03 11:10:48'),(40,'ISISRAAGPO781',1,50.00,1,'SMARTV',1,22,'192.168.17.27','192.168.1.50','F0:9F:C2:58:2E:40','activo','2024-07-20 15:30:01','2024-09-20 02:46:41'),(41,'ISISKASABA802',1,50.00,2,'SMARTV',1,1,'192.168.17.96','192.168.1.120','44:A3:C7:E6:7C:68','pausado','2024-07-27 16:20:23','2024-07-27 16:20:23'),(42,'ISISSABAME597',1,50.00,1,'ROKU',1,22,'192.168.0.148','192.168.1.240','C0:68:CC:11:2A:4D','pausado','2024-07-29 09:17:12','2025-08-30 20:55:52'),(43,'ISISURLOPO805',1,50.00,2,'ROKU 82:84:27:47:82:90',1,22,'192.168.17.102','192.168.1.50','44:A3:C7:33:1D:5E','pausado','2024-07-30 14:50:18','2025-08-02 17:57:47'),(44,'ISISDEMEPO806',1,50.00,1,'ROKU',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-07-30 15:00:50','2025-08-30 16:49:00'),(45,'ISISSAMAPO808',1,50.00,2,'ROKU',1,1,'192.168.17.105','192.168.1.50','44:A3:C7:E2:43:9C','pausado','2024-07-31 11:11:55','2024-07-31 11:11:55'),(46,'ISISWEESPO810',1,50.00,1,'ROKU',1,22,'192.168.17.108','192.168.1.50','44:A3:C7:CF:7D:46','pausado','2024-07-31 15:19:20','2024-09-11 11:28:17'),(47,'ISISVICOPO813',1,50.00,1,'SMARTV',1,0,'192.168.17.110','192.168.1.50','44:A3:C7:CF:6B:A0','activo','2024-08-02 14:59:52','2025-02-10 17:34:40'),(48,'ISISROMEPO814',1,50.00,2,'SMARTV',1,1,'192.168.17.111','192.168.1.50','44:A3:C7:CF:6E:4C','activo','2024-08-02 15:50:28','2024-08-02 15:50:28'),(49,'ISISFAARPO816',1,100.00,2,'google tv',1,1,'192.168.17.114','192.168.1.50','44:A3:C7:2B:4C:86','activo','2024-08-03 15:18:20','2024-08-03 15:18:20'),(50,'ISISALARPO817',1,50.00,1,'LG',1,1,'192.168.17.113','192.168.1.50','E0:A1:CE:96:AC:18','pausado','2024-08-03 15:29:54','2024-09-03 03:57:17'),(51,'ISISELPEJA821',1,50.00,1,'ROKU',1,22,'192.168.16.169','192.168.1.50','A4:BD:C4:80:C7:36','pausado','2024-08-07 14:04:25','2025-05-22 21:26:27'),(52,'ISISSOGIPO823',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-08-07 14:05:52','2024-12-18 19:24:33'),(53,'ISISMALOBA824',1,50.00,1,'ROKU',1,22,'192.168.17.126','192.168.1.120','C0:68:CC:10:8F:05','pausado','2024-08-07 16:08:14','2025-02-14 23:15:46'),(54,'ISISADBRPO825',1,50.00,2,'0000000',1,22,'192.168.17.125','192.168.1.50','C0:68:CC:10:2B:15','activo','2024-08-08 10:12:19','2024-08-08 10:12:19'),(55,'ISISANGAPO826',1,50.00,1,'0000',1,22,'192.168.17.52','192.168.1.50','44:A3:C7:2B:B3:28','activo','2024-08-08 10:53:07','2024-11-05 07:06:04'),(56,'ISISRURAJA827',1,50.00,2,'0000',1,22,'192.168.17.129','192.168.1.50','44:A3:C7:E7:18:62','activo','2024-08-08 12:54:26','2024-08-08 12:54:26'),(57,'ISISLIDEJA828',1,50.00,1,'00',1,2,'192.168.17.131','192.168.1.50','44:A3:C7:E6:EA:78','activo','2024-08-08 13:36:39','2025-08-23 19:13:33'),(58,'ISISFAVEPO836',1,50.00,1,'ROKU',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-08-10 09:58:30','2025-08-26 20:51:47'),(59,'ISISMAJICA771',1,50.00,1,'SMARTV',1,22,'192.168.17.62','192.168.1.50','10:55:E4:5B:93:AD','activo','2024-08-11 04:05:40','2024-11-06 20:43:17'),(60,'ISISEDLORI838',1,50.00,1,'undefined',1,22,'192.168.16.59','192.168.1.50','44:A3:C7:E7:37:34','pausado','2024-08-13 05:17:58','2025-12-16 21:30:07'),(61,'ISISCODECA829',1,50.00,2,'SMARTV',1,22,'192.168.26.135','192.168.1.50','44:A3:C7:E6:EA:9C','activo','2024-08-16 05:07:47','2025-02-08 16:55:15'),(62,'ISISSOHEBA622',1,50.00,2,'SMARTV',1,5,'192.168.16.203','192.168.1.120','C0:68:CC:11:52:85','pausado','2024-08-17 06:54:22','2024-08-17 06:54:22'),(63,'ISISESHEPO844',1,50.00,1,'SMARTV',1,2,'192.168.17.2','192.168.1.50','44:A3:C7:33:F9:BB','pausado','2024-08-18 03:10:00','2024-11-16 17:53:51'),(64,'ISISGEMARI845',1,50.00,1,'SMARTV',1,22,'192.168.17.67','192.168.1.50','44:A3:C7:E6:EA:60','pausado','2024-08-18 05:11:33','2025-01-23 22:09:33'),(65,'ISISMAESPO847',1,50.00,1,'SMARTV',1,1,'192.168.17.71','192.168.1.50','44:A3:C7:E6:FB:B8','activo','2024-08-18 09:37:22','2025-01-22 19:31:15'),(66,'ISISGAALPO851',1,50.00,1,'SMARTV',1,22,'192.168.17.119','192.168.1.50','44:A3:C7:E7:1C:A0','pausado','2024-08-20 09:32:20','2024-09-20 03:08:02'),(67,'ISISMASUPO857',1,50.00,2,'SN',1,22,'192.168.17.144','192.168.1.50','44:A3:C7:E7:17:5A','pausado','2024-08-23 11:54:58','2024-08-23 12:07:09'),(68,'ISISCIBUPO858',1,50.00,1,'SN',1,22,'192.168.17.145','192.168.1.50','44:A3:C7:E7:38:0C','activo','2024-08-23 12:26:57','2025-09-12 22:57:36'),(69,'ISISLUROPO859',1,50.00,1,'ROKU',1,22,'192.168.17.148','192.168.1.50','44:A3:C7:E7:1A:CC','activo','2024-08-24 06:17:52','2024-09-07 05:27:54'),(70,'ISISELCOPO862',1,50.00,1,'ROKU',1,22,'192.168.17.150','192.168.1.50','44:A3:C7:E7:1C:16','pausado','2024-08-24 08:23:17','2024-09-07 05:41:11'),(71,'ISISLUVEPO860',1,50.00,1,'ROKU',1,22,'192.168.17.146','192.168.1.50','44:A3:C7:E7:1D:A2','pausado','2024-08-25 09:27:04','2024-09-07 05:34:24'),(72,'ISISNEMEOB795',1,100.00,1,'SMARTV',1,22,'192.168.17.92','192.168.1.120','44:A3:C7:CC:AD:6A','pausado','2024-08-27 02:49:39','2024-10-12 05:18:49'),(73,'ISISKAALPO868',1,50.00,2,'SMARTV',1,22,'192.168.17.160','192.168.1.50','44:A3:C7:33:F5:5E','pausado','2024-08-27 06:11:45','2024-08-27 06:11:45'),(74,'ISISDAESPO872',1,50.00,1,'ROKU',1,22,'192.168.17.254','192.168.1.50','44:A3:C7:E6:F5:65','pausado','2024-08-28 03:48:13','2024-12-04 20:58:53'),(75,'ISISHECAPO876',1,50.00,1,'ROKU',1,22,'192.168.17.156','192.168.1.50','44:A3:C7:2F:03:28','pausado','2024-08-28 09:06:07','2024-08-31 06:44:09'),(76,'ISISLERAPO877',1,50.00,2,'ROKU',1,22,'192.168.17.162','192.168.1.50','44:A3:C7:E1:1B:B0','pausado','2024-08-28 10:59:03','2024-08-28 10:59:03'),(77,'ISISMAVEPO883',1,50.00,2,'SMARTV',1,22,'192.168.17.165','192.168.1.50','44:A3:C7:E1:1C:16','pausado','2024-08-30 09:38:33','2025-03-09 15:30:21'),(78,'ISISGRAGPO807',1,50.00,2,'SMARTV',1,22,'192.168.17.103','192.168.1.50','F4:2D:06:85:33:CE','pausado','2024-08-30 10:05:06','2024-08-30 10:05:06'),(79,'ISISIRCOPO884',1,50.00,1,'SMARTV',1,22,'192.168.17.166','192.168.1.50','44:A3:C7:E7:32:00','pausado','2024-08-30 11:34:04','2024-11-02 03:32:47'),(80,'ISISCECRPO886',1,50.00,1,'ROKU',1,2,'192.168.17.79','192.168.1.50','44:A3:C7:CF:6E:AC','activo','2024-08-31 03:00:44','2025-03-18 16:15:19'),(81,'ISISNEMEPO889',1,100.00,1,'SMARTV',1,22,'192.168.17.170','192.168.1.50','44:A3:C7:E7:35:06','pausado','2024-09-01 02:37:06','2025-07-18 14:38:46'),(82,'MECRMA0054',1,100.00,2,'ROKU',1,22,'192.168.0.26','192.168.1.240','68:FF:7B:FC:94:CB','activo','2024-09-01 05:06:46','2024-09-01 05:06:46'),(83,'ISISAIVEPO818',1,50.00,2,'SMARTV',1,22,'192.168.17.115','192.168.1.50','F4:2D:06:9E:27:94','pausado','2024-09-02 05:37:27','2024-09-02 05:37:27'),(84,'ISISGLGUPO897',1,50.00,2,'SMARTV',1,22,'192.168.17.176','192.168.1.50','44:A3:C7:E7:2D:92','activo','2024-09-05 02:55:08','2024-09-05 02:55:08'),(85,'ISISSOFUPO901',1,50.00,2,'SMARTV',1,22,'192.168.17.173','192.168.1.50','44:A3:C7:E1:2B:5E','pausado','2024-09-06 09:34:57','2024-09-06 09:34:57'),(86,'ISISKAZAPO870',1,50.00,1,'lllll',1,22,'192.168.17.157','192.168.1.50','44:A3:C7:E2:AF:5A','pausado','2024-09-07 05:42:43','2024-09-15 07:25:17'),(87,'ISISFITOPO906',1,100.00,1,'SMARTV',1,22,'192.168.17.189','192.168.1.50','44:A3:C7:E6:EF:C4','activo','2024-09-07 10:44:04','2024-09-21 13:55:35'),(88,'ISISVIJIPO914',1,50.00,2,'SMARTV',1,22,'192.168.17.201','192.168.1.50','44:A3:C7:DE:9C:0A','activo','2024-09-11 04:39:24','2024-09-11 04:39:24'),(89,'ISISJACOPO915',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-09-11 09:25:43','2025-03-17 21:54:42'),(90,'ISISMIMABA775',1,50.00,1,'SN',1,22,'192.168.17.73','192.168.1.50','C0:51:5C:E4:FF:B0','activo','2024-09-12 07:05:53','2025-09-12 14:53:25'),(91,'ISISMIBAPO921',1,50.00,1,'SN',1,22,'192.168.16.136','192.168.1.50','C0:68:CC:0C:65:45','pausado','2024-09-13 08:25:47','2025-06-23 15:00:46'),(92,'ISISROCOPO922',1,50.00,1,'SMARTV',1,22,'192.168.17.207','192.168.1.50','40:AE:30:80:21:2A','pausado','2024-09-14 03:00:25','2025-10-21 23:23:58'),(93,'ISISRAESPO923',1,50.00,1,'SMARTV',1,22,'192.168.17.208','192.168.1.50','40:AE:30:7F:8B:9A','activo','2024-09-14 03:06:59','2025-10-16 14:30:00'),(94,'ISISNELACA751',1,50.00,1,'ROKU',1,22,'192.168.17.55','192.168.1.50','44:A3:C7:2B:B3:34','activo','2024-09-14 03:14:09','2025-06-23 14:52:48'),(95,'ISISMAGAPO926',1,50.00,1,'SMARTV',1,22,'192.168.24.14','192.168.1.50','10:55:E4:5A:19:15','pausado','2024-09-16 08:33:57','2025-03-19 21:50:27'),(96,'ISISDOSAEL928',1,50.00,1,'ROKU',1,22,'192.168.18.150','192.168.1.50','44:A3:C7:E1:FA:22','activo','2024-09-18 08:37:34','2025-02-06 23:34:15'),(97,'ISISMARIPO931',1,50.00,1,'SMARTV',1,22,'192.168.17.215','192.168.1.50','40:AE:30:7F:B8:E2','pausado','2024-09-19 06:05:32','2024-11-18 16:37:09'),(98,'ISISELSOPO932',1,50.00,1,'ROKU',1,22,NULL,'192.168.1.50',NULL,'activo','2024-09-19 06:15:37','2025-06-20 16:47:17'),(99,'ISISMARAPO933',1,50.00,1,'Mariana Ramírez Méndez',1,22,'192.168.17.223','192.168.1.50','44:A3:C7:E0:1A:F4','activo','2024-09-21 04:04:54','2025-03-17 19:09:01'),(100,'ISISLUMAJA937',1,50.00,2,'SN',1,22,'192.168.17.229','192.168.1.50','44:A3:C7:DF:34:44','pausado','2024-09-21 13:42:08','2024-09-21 13:42:08'),(101,'ISISGUTIPO934',1,50.00,1,'SMARTV',1,22,'192.168.17.226','192.168.1.50','E0:A1:CE:9B:0C:FE','pausado','2024-09-22 05:45:33','2024-11-27 23:35:58'),(102,'ISISMAGATE938',1,50.00,1,'ROKU',1,22,'192.168.91.228','192.168.1.111','40:AE:30:80:07:92','pausado','2024-09-22 08:54:54','2025-06-13 16:27:07'),(103,'ISISDAHEPO939',1,50.00,2,'iptv pro',1,22,'192.168.23.3','192.168.1.50','44:A3:C7:E7:95:7E','activo','2024-09-22 10:08:28','2024-09-22 10:08:28'),(104,'ISISPEHEPO941',1,50.00,1,'SMARTV',1,22,'192.168.17.13','192.168.1.50','44:A3:C7:E1:F0:B0','pausado','2024-09-24 04:26:08','2024-11-05 20:46:24'),(105,'ISISJODUPO942',1,50.00,1,'SMARTV',1,22,'192.168.17.234','192.168.1.50','F4:2D:06:A0:48:5A','activo','2024-09-24 06:37:58','2025-01-12 22:04:55'),(106,'ISISJOMAPO945',1,50.00,1,'ROKU',1,22,'192.168.17.238','192.168.1.50','F4:2D:06:A0:48:42','activo','2024-09-25 08:31:50','2025-10-06 14:34:23'),(107,'ISIS080902952',1,50.00,1,'6666',1,22,NULL,'192.168.1.50',NULL,'activo','2024-09-28 08:50:03','2025-02-19 16:50:15'),(108,'ISIS080955953',1,50.00,1,'2352345',1,22,'192.168.17.244','192.168.1.50','44:A3:C7:CE:53:98','activo','2024-09-28 08:55:55','2024-10-08 11:43:01'),(109,'ISIS100904954',1,50.00,1,'C7:E2:6F:F6:22:C5',1,22,'192.168.17.250','192.168.1.50','44:A3:C7:E1:F0:EC','pausado','2024-09-28 10:09:04','2024-10-26 20:37:00'),(110,'ISIS030920955',1,50.00,1,'A3:ED:6D:C7:3C:27',1,22,NULL,'192.168.1.50','F4:2D:06:A0:48:72','activo','2024-09-29 03:45:21','2025-02-27 00:09:49'),(111,'ISISERMABA735',1,50.00,1,'SMARTV',1,22,'192.168.17.19','192.168.1.120','E8:F6:54:E2:8A:CD','pausado','2024-09-30 05:03:33','2025-04-22 15:41:05'),(112,'ISIS091018960',1,100.00,1,'555',1,22,NULL,'192.168.1.50',NULL,'activo','2024-10-05 09:52:19','2024-10-18 00:40:14'),(113,'ISIS051024961',1,100.00,1,'23:81:D0:6F:07:35',1,22,'192.168.18.6','192.168.1.120','44:A3:C7:E1:2F:CC','pausado','2024-10-06 05:07:24','2024-12-06 23:27:16'),(114,'ISIS111020967',1,50.00,1,'098134381774',1,22,'192.168.18.2','192.168.1.50','44:A3:C7:CF:5B:DB','pausado','2024-10-09 11:42:21','2024-12-04 22:35:09'),(115,'ISIS091037969',1,50.00,1,'A0:D7:F3:93:78:BE',1,22,NULL,'192.168.1.50',NULL,'activo','2024-10-11 09:14:38','2025-09-11 14:26:20'),(116,'ISIS091017970',1,100.00,1,'95:10:30:29:94:44',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-10-11 09:24:18','2024-10-28 23:23:36'),(117,'ISISEVRUME546',1,50.00,1,'ROKU',1,22,'192.168.0.201','192.168.1.240','C0:68:CC:46:5F:99','activo','2024-10-13 03:37:55','2025-07-14 20:52:28'),(118,'ISIS041029975',1,50.00,1,'XCIPTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-10-13 04:05:30','2025-02-13 23:50:16'),(119,'ISIS061054976',1,50.00,1,'21:87:55:46:65:87',1,22,NULL,'192.168.1.50',NULL,'activo','2024-10-13 06:08:55','2024-10-17 23:59:32'),(120,'ISISEZMOJA674',1,50.00,1,'SMARTV',1,22,'192.168.16.171','192.168.1.50','10:55:E4:59:1A:05','activo','2024-10-16 01:38:22','2025-09-09 16:32:08'),(121,'ISIS101034981',1,50.00,1,'00:12:5F:BE:DF:DE',1,22,'192.168.18.23','192.168.1.120','44:A3:C7:DF:27:8A','pausado','2024-10-17 04:01:35','2024-10-18 01:16:00'),(122,'MEMALO334',1,50.00,2,'SMARTV',1,22,'192.168.0.230','192.168.1.240','F4:2D:06:96:2F:71','pausado','2024-10-17 22:47:54','2024-10-17 22:47:54'),(123,'ISIS111052983',1,50.00,2,'a4:30:7a:d5:78:62',1,22,'192.168.16.161','192.168.1.120','1C:3C:D4:9B:65:C9','activo','2024-10-18 05:53:53','2024-10-18 05:53:53'),(124,'BARAHE223',1,50.00,2,'SMARTV',1,22,'192.168.16.128','192.168.1.120','00:5F:67:6D:7D:1F','activo','2024-10-18 20:22:26','2024-10-18 20:22:26'),(125,'ISISDELORI680',1,50.00,1,'e8:aa:cb:d5:38:4b',1,22,'192.168.17.31','192.168.1.50','F4:2D:06:87:1C:7A','pausado','2024-10-18 20:56:48','2024-11-18 17:26:44'),(126,'ISISJUCABA907',1,50.00,2,'SMARTV',1,2,'192.168.17.192','192.168.1.50','44:A3:C7:E6:FA:8C','pausado','2024-10-20 03:25:51','2024-10-20 03:25:51'),(127,'ISIS011035998',1,50.00,2,'68:84:76:29:75:57',1,22,NULL,'192.168.1.50',NULL,'activo','2024-10-31 07:11:35','2024-10-31 07:11:35'),(128,'ISIS1111311008',1,50.00,2,'405728713358',1,22,'192.168.17.197','192.168.1.120','68:81:E0:DA:60:AC','pausado','2024-11-07 05:47:32','2024-11-07 05:47:32'),(129,'ISIS1011131012',1,50.00,1,'18:82:8C:89:DD:20',1,22,NULL,'192.168.1.50',NULL,'activo','2024-11-09 04:35:14','2025-06-25 18:31:27'),(130,'ISIS0911031015',1,50.00,2,'99:81:15:20:58:06',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-11-14 20:54:27','2024-11-14 20:54:27'),(131,'C4ANSA196',1,100.00,1,'SMARTV',1,22,NULL,'192.168.1.141',NULL,'pausado','2024-11-17 15:47:44','2025-03-20 19:58:25'),(132,'ISIS0211131024',1,50.00,1,'XXXXX',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-11-20 02:04:39','2024-11-20 02:04:39'),(133,'ISIS1011491036',1,50.00,2,'e5:5b:d1:af:fe:e7',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-11-25 22:34:32','2024-11-25 22:34:32'),(134,'ISIS1011121039',1,50.00,1,'D7:A4:72:BD:FB:AA',1,22,'192.168.17.128','192.168.1.120','A8:50:81:95:65:9E','activo','2024-11-27 22:14:12','2025-01-28 18:03:52'),(135,'ISISARVIFI890',1,50.00,1,'ROKU',1,22,NULL,'192.168.90.2',NULL,'activo','2024-11-30 14:17:52','2025-07-10 21:04:09'),(136,'ISISADMOBA491',1,50.00,2,'ROKU',1,22,'192.168.28.169','192.168.1.120','C0:68:CC:51:85:41','pausado','2024-11-30 20:54:01','2025-01-30 14:43:56'),(137,'ISISADJABA767',1,50.00,2,'SMARTV',1,22,'192.168.16.29','192.168.1.120','C0:68:CC:51:96:19','pausado','2024-12-03 20:34:09','2024-12-03 20:34:09'),(138,'ISIS0912221048',1,50.00,2,'64:1C:AE:71:16:A6',1,22,'192.168.17.253','192.168.1.50','C0:51:5C:DD:50:3A','activo','2024-12-04 21:12:12','2024-12-04 21:12:12'),(139,'ISISALMEPO902',1,50.00,1,'ROKU',1,2,'192.168.18.140','192.168.1.50','F4:2D:06:8F:84:C4','pausado','2024-12-05 16:40:17','2025-01-29 20:40:43'),(140,'ISISADPEPO904',1,50.00,1,'xxxxx',1,22,'192.168.18.185','192.168.1.50','44:A3:C7:E6:FB:E2','activo','2024-12-05 20:21:00','2025-02-28 17:32:55'),(141,'ISIS0712121052',1,50.00,1,'iptv pro',1,22,NULL,'192.168.1.50',NULL,'pausado','2024-12-06 19:47:02','2024-12-06 19:47:02'),(142,'ISISGUGATE695',1,350.00,1,'ROKU',1,22,'192.168.91.210','192.168.1.111','C0:F9:B0:0B:5E:3F','activo','2024-12-07 17:27:52','2025-07-06 16:41:46'),(143,'ISISSACUPO912',1,50.00,2,'smartv',1,22,'192.168.17.196','192.168.1.50','44:A3:C7:E1:1C:9A','pausado','2024-12-09 14:27:08','2024-12-10 17:18:04'),(144,'ISIS071000985',1,50.00,1,'19:44:71:74:08:09',1,22,'192.168.18.16','192.168.1.50','1C:3C:D4:9B:B0:29','activo','2024-12-09 20:49:44','2025-05-11 15:48:11'),(145,'ISISLUSAGU734',1,50.00,2,'SMARTV',1,22,'192.168.17.225','192.168.1.50','DC:8D:B7:9F:51:E1','pausado','2024-12-10 21:57:16','2024-12-10 21:57:16'),(146,'ISISGUALC4408',1,100.00,1,'SMARTV',1,8,NULL,'192.168.1.141',NULL,'pausado','2024-12-12 21:57:17','2025-08-09 19:55:18'),(147,'ISISEDGUBA720',1,50.00,2,'SMARTV',1,22,'192.168.16.85','192.168.1.50','C0:68:CC:0D:F7:B5','pausado','2024-12-16 21:39:12','2025-05-31 17:31:55'),(148,'ISISALGABA667',1,50.00,2,'IPTV',1,22,'192.168.16.212','192.168.1.120','C0:51:5C:E8:D7:3B','pausado','2024-12-20 23:31:07','2024-12-20 23:31:07'),(149,'ISIS0312381076',1,50.00,2,'IPTV',1,22,'192.168.18.62','192.168.1.120','6C:D1:E5:0D:28:EE','activo','2024-12-28 15:37:38','2025-01-31 14:46:17'),(150,'ISIS0911301041',1,50.00,1,'ROKU',1,22,'192.168.17.210','192.168.1.120','C0:E1:BE:58:F5:60','pausado','2024-12-29 20:17:51','2025-02-02 17:02:09'),(151,'ISISEDBAPO881',1,100.00,2,'SMARTV',1,22,'192.168.17.84','192.168.1.50','44:A3:C7:0A:0A:B2','pausado','2024-12-30 16:17:19','2024-12-30 16:17:19'),(152,'ISIS0512521077',1,50.00,1,'SMARTV',1,22,'192.168.91.215','192.168.1.111','C0:68:CC:52:B4:C9','activo','2024-12-30 17:48:52','2025-02-08 15:19:20'),(153,'ISIS0612011080',1,50.00,1,'sss333',1,22,'192.168.16.31','192.168.1.50','08:5C:1B:39:AB:04','pausado','2024-12-31 18:06:01','2025-01-27 19:40:38'),(154,'ISIS1201081084',1,50.00,2,'SMARTV',2,22,'192.168.18.68','192.168.1.50','B8:85:7B:84:85:19','pausado','2025-01-04 00:04:09','2025-01-04 00:04:09'),(155,'ISIS111021958',1,50.00,2,'SMARTV',1,22,'192.168.0.224','192.168.1.240','64:2C:AC:D6:01:BF','pausado','2025-01-12 20:17:54','2025-01-12 20:17:54'),(156,'ISIS1112541079',1,50.00,2,'ROKU',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-01-13 20:18:58','2025-01-13 20:18:58'),(157,'ISIS0801231095',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-01-13 20:56:24','2025-04-26 15:23:42'),(158,'ISIS0901031096',1,50.00,1,'SMARTV',2,22,'192.168.16.141','192.168.1.120','C4:EB:FF:42:9F:CA','pausado','2025-01-13 21:14:04','2025-07-22 14:17:26'),(159,'ISIS0201441097',1,100.00,2,'SMARTV',1,2,'192.168.16.151','192.168.1.120','14:8C:4A:59:43:3D','pausado','2025-01-14 14:27:44','2025-01-14 14:27:44'),(160,'ISISOSMAHU411',1,50.00,1,'undefined',1,22,'','192.168.1.240','','activo','2025-01-14 22:28:38','2025-11-21 23:31:47'),(161,'ISIS0801021103',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-01-16 20:16:03','2025-01-16 20:16:03'),(162,'ISIS0501561104',1,50.00,2,'SMARTV',1,22,'192.168.18.97','192.168.1.120','C4:EB:FF:36:AD:E2','activo','2025-01-17 17:08:56','2025-01-17 17:08:56'),(163,'ISIS0612061062',1,50.00,2,'ROKU',1,4,NULL,'192.168.3.200',NULL,'activo','2025-01-17 23:41:38','2025-01-17 23:41:38'),(164,'ISIS0701431112',1,50.00,1,'SMARTV',1,19,NULL,'192.168.1.50',NULL,'activo','2025-01-26 19:31:44','2025-02-26 22:01:30'),(165,'ISIS0801301113',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-01-27 20:25:31','2025-10-18 18:32:46'),(166,'ISIS1001421116',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-01-28 22:54:42','2025-09-06 18:18:02'),(167,'ISIS0501131119',1,50.00,1,'SMARTV',1,22,'192.168.17.243','192.168.1.120','C8:4C:78:26:87:08','pausado','2025-01-30 17:44:14','2025-04-26 16:54:28'),(168,'ISIS0501181120',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-01-31 17:39:19','2025-01-31 17:39:19'),(169,'ISIS0502231122',1,50.00,2,'IPTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-02-01 17:14:23','2025-02-01 17:14:23'),(170,'ISIS0202221128',1,50.00,2,'ROKU',1,22,'192.168.18.149','192.168.1.120','C0:51:5C:DC:C0:39','activo','2025-02-05 14:25:23','2025-02-05 14:25:23'),(171,'ISIS0602481126',1,50.00,1,'IPTV',1,22,NULL,'192.168.1.240',NULL,'activo','2025-02-07 16:00:53','2025-09-15 20:48:50'),(172,'ISIS0802201134',1,50.00,2,'ROKU',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-02-08 20:44:21','2025-02-08 20:44:21'),(173,'ISIS0602261138',1,50.00,1,'Roku',1,22,'192.168.18.153','192.168.1.120','C4:EB:FF:36:AA:70','pausado','2025-02-13 18:11:27','2025-09-26 14:47:41'),(174,'ISIS0802541140',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-02-15 20:13:55','2025-03-30 21:35:17'),(175,'ISIS0802111141',1,50.00,2,'SMARTV',1,22,'192.168.18.156','192.168.1.50','C4:EB:FF:36:65:40','pausado','2025-02-17 20:26:11','2025-02-17 20:26:11'),(176,'MEMIFA365',1,50.00,1,'SMARTV',1,22,'192.168.0.180','192.168.1.240','A4:6D:A4:3A:3B:C9','activo','2025-02-18 16:30:15','2025-07-14 20:47:50'),(177,'ISISCAGABA724',1,50.00,2,'IPTV',1,22,'192.168.16.94','192.168.1.120','10:55:E4:5B:06:7D','pausado','2025-02-18 17:02:28','2025-02-18 17:02:28'),(178,'ISISANMECA604',1,50.00,1,'IPTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-02-18 18:58:22','2025-03-15 21:19:45'),(179,'ISIS0502011150',1,50.00,2,'IPTV',1,22,'192.168.16.160','192.168.1.120','C8:4C:78:32:F7:72','activo','2025-02-28 17:46:02','2025-03-02 17:19:50'),(180,'ISIS0802481151',1,50.00,2,'IPTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-02-28 20:34:48','2025-02-28 20:34:48'),(181,'ISISJOFAME634',1,50.00,1,'ROKU',1,2,'192.168.0.237','192.168.1.240','F4:2D:06:96:2F:35','pausado','2025-03-01 17:15:26','2025-03-13 20:31:08'),(182,'ISIS0803121154',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-03-01 20:41:12','2025-03-03 23:22:34'),(183,'ISIS1003441156',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-03-03 22:20:45','2025-03-03 22:20:45'),(184,'C3AMVE346',1,50.00,2,'56:03:95:37:59:28',1,22,NULL,'192.168.1.33',NULL,'pausado','2025-03-07 18:10:25','2025-03-07 18:10:25'),(185,'ISIS0803281162',1,50.00,1,'ROKU',1,2,NULL,'192.168.1.50',NULL,'activo','2025-03-08 20:53:29','2025-03-29 15:17:50'),(186,'ISISMACOC3744',1,50.00,2,'SMARTV',1,22,'192.168.17.48','192.168.1.33',NULL,'pausado','2025-03-09 15:31:22','2025-03-09 15:31:22'),(187,'C3BERO0094',1,50.00,2,'IPTV',1,8,NULL,'192.168.1.33',NULL,'pausado','2025-03-09 15:32:01','2025-04-01 15:40:53'),(188,'ISISDAALFI867',1,50.00,1,'SMARTV',1,22,NULL,'192.168.90.2',NULL,'pausado','2025-03-11 14:34:43','2025-03-11 16:32:06'),(189,'ISIS0603161166',1,100.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-03-11 18:26:16','2025-03-11 18:26:16'),(190,'ISIS0903181169',1,50.00,2,'SMARTV',1,2,NULL,'192.168.1.50',NULL,'pausado','2025-03-11 21:29:18','2025-03-11 21:29:18'),(191,'ISIS0703221170',1,50.00,1,'64:cb:e9:f9:09:b2',1,22,NULL,'192.168.1.50',NULL,'activo','2025-03-12 19:43:23','2025-03-12 19:43:23'),(192,'ISIS1103551171',1,50.00,1,'xxx',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-03-12 23:44:55','2025-03-12 23:44:55'),(193,'ISIS0703031173',1,50.00,2,'SMARTV',1,22,'192.168.16.243','192.168.1.120','C8:4C:78:31:AB:68','pausado','2025-03-15 19:28:41','2025-03-15 19:28:41'),(194,'ISIS0903511175',1,50.00,1,'ROKU',1,22,NULL,'192.168.1.33',NULL,'activo','2025-03-17 16:55:58','2025-04-14 20:34:13'),(195,'ISIS0701291092',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-03-19 23:49:25','2025-04-07 22:32:33'),(196,'ISIS0403371179',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-03-20 16:59:37','2025-03-20 16:59:37'),(197,'ZALICO00110',1,50.00,2,'IPTV',1,22,'192.168.19.133','192.168.1.33','1C:EF:03:E3:F2:AD','activo','2025-03-21 15:04:04','2025-03-21 15:04:04'),(198,'ISIS0912591055',1,50.00,2,'IPTV',1,22,'192.168.91.223','192.168.1.111','28:6F:B9:9D:4C:74','activo','2025-03-21 17:40:30','2025-03-21 17:40:30'),(199,'ISIS0803341176',1,100.00,1,'ROKU',1,2,NULL,'192.168.1.50',NULL,'activo','2025-03-25 15:38:55','2025-09-15 15:50:29'),(200,'ISIS0403341189',1,50.00,2,'OTTPLAYER',1,22,NULL,'192.168.1.50',NULL,'activo','2025-03-31 16:23:35','2025-03-31 16:23:35'),(201,'ISIS0604231190',1,50.00,1,'IPTV 755082510846',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-04-01 18:18:23','2025-08-21 20:44:06'),(202,'ISIS0604141191',1,50.00,1,'xxxx',1,17,NULL,'192.168.1.50',NULL,'activo','2025-04-02 03:31:15','2025-05-11 20:01:58'),(203,'ISIS1004391205',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-04-17 22:35:39','2025-06-28 15:53:56'),(204,'ISIS0504361204',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-04-17 22:37:51','2025-06-18 22:38:52'),(205,'ISIS1104381206',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-04-17 23:14:39','2025-04-17 23:27:48'),(206,'ISISINGOBA596',1,50.00,1,'SMARTV',1,22,'192.168.16.34','192.168.1.120','C0:68:CC:4D:F1:41','pausado','2025-04-21 17:51:13','2025-05-30 17:58:15'),(207,'ISISJOVACA420',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.33',NULL,'pausado','2025-05-01 16:22:00','2025-05-01 16:22:00'),(208,'ISIS0402291133',1,50.00,2,'SMARTV',1,2,NULL,'192.168.1.50',NULL,'activo','2025-05-05 21:28:49','2025-05-05 21:28:49'),(209,'ISISTOPAME562',1,50.00,1,'ROKU',1,22,NULL,'192.168.1.240',NULL,'pausado','2025-05-11 15:56:18','2025-09-24 20:52:16'),(210,'ISIS0905461226',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-05-12 21:01:57','2025-09-19 18:43:59'),(211,'ISIS0605481228',1,50.00,1,'XXX',1,22,'192.168.17.79','192.168.1.120','44:A3:C7:CF:6E:AC','pausado','2025-05-14 18:14:48','2025-05-15 22:25:32'),(212,'ISIS1111361002',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-05-15 20:48:51','2025-05-15 20:48:51'),(213,'ISIS0501261098',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-05-18 17:12:30','2025-05-18 17:30:05'),(214,'ISIS0405211241',1,100.00,2,'IPTV',1,22,'','192.168.1.50','','activo','2025-05-20 16:57:21','2025-11-17 23:18:05'),(215,'ISIS0205131243',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-05-22 17:51:27','2025-05-22 17:51:27'),(216,'ISIS0605461251',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.141',NULL,'pausado','2025-05-24 21:16:55','2025-07-15 18:09:01'),(217,'ISIS0505291217',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-05-26 15:35:18','2025-06-05 18:26:53'),(218,'ISIS0605511253',1,50.00,2,'OTTPLAYER',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-05-26 18:28:52','2025-05-26 18:28:52'),(219,'ISIS1005591256',1,50.00,1,'SMARTV',1,22,'192.168.0.252','192.168.1.240','C4:EB:FF:36:65:40','pausado','2025-05-27 22:20:00','2025-09-15 14:35:32'),(220,'ISIS0506361259',1,50.00,2,'OTTPLAYER',1,22,'192.168.18.76','192.168.1.120','14:CA:56:94:22:F9','activo','2025-06-02 17:52:36','2025-06-02 17:52:36'),(221,'ISIS0806231260',1,50.00,2,'OTTPLAYER',1,22,NULL,'192.168.1.50',NULL,'activo','2025-06-03 20:26:23','2025-06-03 20:26:23'),(222,'ISISJUNAPO849',1,50.00,1,'OTTPLAYER',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-06-05 15:50:20','2025-10-07 16:28:32'),(223,'ISIS0506121262',1,50.00,1,'OTTPLAYER',1,2,'192.168.18.83','192.168.1.120','F4:E8:4F:4C:D1:88','activo','2025-06-05 17:15:13','2025-10-25 17:42:44'),(224,'ISIS0406241266',1,50.00,1,'75:54:99:16:40:36',1,22,NULL,'192.168.1.50',NULL,'activo','2025-06-11 16:30:25','2025-06-11 16:30:25'),(225,'ISIS0606301269',1,50.00,2,'IPTV PALYER',1,22,NULL,'192.168.1.33',NULL,'pausado','2025-06-13 18:42:31','2025-06-13 18:42:31'),(226,'ISIS0506161268',1,50.00,1,'IPTV PALYER',1,22,NULL,'192.168.1.33',NULL,'pausado','2025-06-13 23:26:26','2025-06-13 23:34:37'),(227,'ISIS0906271271',1,50.00,2,'ROKU',1,22,'192.168.91.196','192.168.1.111','F4:E8:4F:4C:D1:A0','activo','2025-06-17 22:05:35','2025-06-17 22:05:35'),(228,'ISISHIVIPI433',1,50.00,1,'ROKU',1,22,NULL,'192.168.90.2',NULL,'activo','2025-06-20 22:39:19','2025-08-17 21:06:51'),(229,'ISIS0306561277',1,50.00,2,'TIVI PLAYER e0:03:6b:f5:33:6e',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-06-21 15:13:56','2025-08-02 18:00:00'),(230,'ISIS0306011278',1,100.00,1,'OTT PLAYER',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-06-21 15:17:02','2025-08-20 17:29:39'),(231,'ISIS1206501286',1,50.00,2,'IPTV',1,22,'192.168.18.252','192.168.1.50','58:8A:5A:12:2F:58','activo','2025-06-26 00:21:51','2025-06-26 00:21:51'),(232,'ISISROMAME1288',1,50.00,1,'ROKU',1,22,'192.168.0.230','192.168.1.240','54:37:BB:01:90:74','pausado','2025-07-05 16:56:47','2025-08-16 19:45:22'),(233,'ISIS0707371298',1,50.00,2,'OTT PLAYER',1,2,NULL,'192.168.1.50',NULL,'activo','2025-07-07 19:00:38','2025-07-07 19:00:38'),(234,'ISIS0607361306',1,50.00,2,'IPTV',1,22,'192.168.91.193','192.168.1.111','44:A3:C7:E1:EF:EA','pausado','2025-07-14 21:23:11','2025-07-14 21:23:11'),(235,'ISIS0307001308',1,50.00,2,'OTT PLAYER',1,22,'192.168.91.192','192.168.1.111','A0:09:2E:0E:25:C0','activo','2025-07-16 15:46:01','2025-07-16 15:46:01'),(236,'ISIS0907121310',1,50.00,2,'OTT PLAYER',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-07-17 21:05:12','2025-07-17 21:05:12'),(237,'ISISRIRIOB765',1,50.00,1,'OTT PLAYER',1,22,'192.168.18.127','192.168.1.120','F4:E8:4F:4C:D1:C4','pausado','2025-07-18 18:12:16','2025-09-19 22:10:21'),(238,'ISISEUHEPI536',1,50.00,1,'ROKU',1,4,NULL,'192.168.90.2',NULL,'activo','2025-07-19 15:17:50','2025-10-27 20:39:45'),(239,'ISISFAMAPO855',1,50.00,1,'ROKU',1,22,'192.168.17.133','192.168.1.50','E0:A1:CE:A6:60:1E','activo','2025-07-21 15:02:59','2025-07-21 15:02:59'),(240,'ISIS0807061317',1,50.00,2,'OTT PLAYER',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-07-24 20:11:07','2025-07-24 20:11:07'),(241,'ISIS1007191320',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-07-25 22:10:19','2025-07-25 22:10:19'),(242,'ISIS1007461321',1,50.00,1,'IPTV PALYER 04:70:56:b0:89:6e',1,22,'192.168.16.24','192.168.1.120','F4:E4:51:C3:AB:B0','activo','2025-07-25 22:21:46','2025-10-28 18:26:16'),(243,'ISIS0507051327',1,50.00,2,'SMARTV',1,22,'192.168.16.10','192.168.1.50','A0:44:5C:6B:A7:9A','pausado','2025-07-31 17:53:06','2025-07-31 17:53:06'),(244,'ISIS0507511297',1,50.00,2,'ROKU',1,22,'192.168.16.99','192.168.1.120','C4:EB:FF:35:5A:76','pausado','2025-08-09 00:04:40','2025-08-09 00:04:40'),(245,'ISIS0508041342',1,50.00,1,'SMARTV',1,2,NULL,'192.168.1.50',NULL,'activo','2025-08-09 17:52:05','2025-08-11 20:57:00'),(246,'ISIS0708541343',1,50.00,2,'OTT PLAYER',1,22,NULL,'192.168.1.50',NULL,'activo','2025-08-09 19:46:54','2025-08-09 19:46:54'),(247,'ISIS0908131351',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-08-16 21:48:13','2025-08-16 21:48:13'),(248,'ISIS0805011225',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-08-17 19:59:06','2025-08-17 19:59:06'),(249,'ISIS0708311371',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-08-30 19:17:25','2025-08-30 19:17:25'),(250,'ISIS0708481372',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.240',NULL,'activo','2025-08-30 19:44:48','2025-10-14 18:43:49'),(251,'ISISCIPEPO887',1,50.00,2,'ROKU',1,22,'192.168.17.168','192.168.1.50','44:A3:C7:E6:FB:16','pausado','2025-09-01 15:53:06','2025-09-01 15:53:06'),(252,'SAFAAL00113',1,50.00,1,'SMARTV',1,22,NULL,'192.168.0.88',NULL,'activo','2025-09-01 17:02:19','2025-09-15 23:36:27'),(253,'ISISJOGEPO873',1,50.00,1,'RGTSE',1,2,NULL,'192.168.1.50',NULL,'pausado','2025-09-06 18:05:38','2025-10-07 19:53:41'),(254,'ISIS1007041319',1,50.00,1,'ROKU',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-09-12 23:23:45','2025-09-12 23:23:45'),(255,'ISIS0309251396',1,50.00,1,'OTT PLAYER',1,22,NULL,'192.168.1.50',NULL,'activo','2025-09-18 15:40:26','2025-09-18 15:40:26'),(256,'ISIS0709491397',1,50.00,1,'IPTV',1,2,'192.168.17.12','192.168.1.120','14:CA:56:EE:92:DB','activo','2025-09-18 19:08:49','2025-09-25 21:36:41'),(257,'ISIS0406591275',1,50.00,2,'OTT PLAYER',1,22,'192.168.91.194','192.168.1.111','F4:E8:4F:4C:D1:BE','activo','2025-09-20 20:29:46','2025-09-20 20:29:46'),(258,'ISIS0909281406',1,50.00,2,'OTT PLAYER',1,22,NULL,'192.168.0.88',NULL,'activo','2025-09-24 21:48:29','2025-09-24 21:48:29'),(259,'ISIS0609441407',1,50.00,2,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-09-26 18:24:45','2025-09-26 18:24:45'),(260,'ISIS1010481422',1,50.00,1,'SMARTV',1,22,NULL,'192.168.1.50',NULL,'activo','2025-10-08 22:49:49','2025-10-16 23:42:08'),(261,'MESAME321',1,50.00,1,'TV BOX',1,7,'192.168.0.57','192.168.1.240','38:6B:1C:91:21:BD','pausado','2025-10-23 17:09:46','2025-10-23 17:10:27'),(262,'ISISPAGAME1153',1,50.00,2,'ROKU',1,22,'192.168.0.48','192.168.1.240','C8:4C:78:27:13:1E','activo','2025-11-01 23:13:05','2025-11-01 23:13:05'),(263,'OBVICO354',1,50.00,2,'TIVI PLAYER',1,22,'192.168.16.175','192.168.1.120','C0:68:CC:0E:66:F5','pausado','2025-11-02 03:57:00','2025-11-02 03:57:00'),(264,'ISIS0711581452',1,50.00,2,'OTT PLAYER',1,22,NULL,'192.168.1.50',NULL,'pausado','2025-11-03 19:02:58','2025-11-03 19:02:58'),(265,'ISIS0911041454',1,50.00,2,'IPTV PALYER',1,22,NULL,'192.168.1.50',NULL,'activo','2025-11-03 21:33:05','2025-11-03 21:33:05'),(266,'ISISBERUJA669',1,50.00,1,'undefined',1,22,'192.168.16.219','192.168.1.50','C0:51:5C:F6:07:BC','activo','2025-11-12 23:23:50','2025-11-12 23:23:50'),(267,'ISIS0406321267',1,50.00,2,'OTT PLAYER',1,22,'','192.168.1.50','','pausado','2025-11-16 01:51:27','2025-11-16 01:51:27'),(268,'ISISMAALME1476',1,50.00,1,'undefined',1,22,'192.168.0.32','192.168.1.240','C8:4C:78:30:D9:98','pausado','2025-11-18 21:02:07','2025-12-16 04:17:44'),(269,'ISISROCOJA1480',1,50.00,2,'OTT PLAYER',1,22,'',NULL,'','activo','2025-11-22 19:49:36','2025-11-22 19:49:36'),(270,'ISISRAGOFI917',1,50.00,2,'SMARTV',1,4,'','192.168.90.2','','activo','2025-11-26 20:44:48','2025-11-26 20:44:48'),(271,'MEDASA00168',1,50.00,2,'SMARTV',1,22,'192.168.0.96','192.168.1.240','00:5F:67:9D:76:BD','pausado','2025-11-30 03:22:55','2025-11-30 03:22:55'),(272,'ISISBERIPO1491',1,50.00,2,'OTT PLAYER',1,22,'',NULL,'','activo','2025-12-05 19:59:49','2025-12-05 19:59:49'),(273,'ISIS0408571341',1,50.00,2,'OTT PLAYER',1,22,'','192.168.1.50','','pausado','2025-12-08 22:38:54','2025-12-08 22:38:54'),(274,'ISISPESUBA841',1,50.00,2,'dc:e7:bc:9c:65:1c',1,22,'192.168.16.118','192.168.1.120','44:A3:C7:E6:EA:DE','activo','2025-12-09 00:07:56','2025-12-16 06:29:27'),(275,'OBCAVI277',1,50.00,2,'SMARTV',1,22,'192.168.16.73','192.168.1.120','30:FB:B8:DA:43:89','activo','2025-12-11 00:11:10','2025-12-11 00:11:10'),(276,'ISISZUNAPO1499',1,50.00,2,'OTT PLAYER',1,22,'',NULL,'','activo','2025-12-10 21:03:37','2025-12-10 21:03:37'),(277,'ISIS0701021088',1,50.00,2,'SMARTV',1,22,'','192.168.1.50','','activo','2025-12-11 22:27:14','2025-12-11 22:27:14'),(278,'ISISLIHEOB1470',1,50.00,2,'SMARTV',1,22,'','192.168.1.33','','activo','2025-12-12 00:03:22','2025-12-12 00:03:22'),(279,'ISISERCRC-1492',1,50.00,2,'IPTV PALYER',1,22,'','192.168.1.141','','pausado','2025-12-12 04:26:32','2025-12-12 04:26:32'),(280,'ISISCELOME444',1,50.00,2,'IPTV PALYER',1,22,'','192.168.1.240','','pausado','2025-12-12 23:12:42','2025-12-12 23:12:42'),(281,'ISISAGCRIN1500',1,50.00,2,'LIVE TV',1,22,'192.168.16.245',NULL,'68:D1:BA:BE:36:C9','activo','2025-12-12 20:25:11','2025-12-12 20:25:11'),(282,'ISISJALOOB1513',1,50.00,2,'OTT PLAYER',1,22,'',NULL,'','activo','2025-12-23 22:33:22','2025-12-23 22:33:22'),(283,'ISISJOROJA1515',1,50.00,2,'IPTV PALYER',1,22,'',NULL,'','pausado','2025-12-24 18:27:21','2025-12-24 18:27:21'),(284,'ISISRIHERI1475',1,50.00,2,'IPTV',1,22,'','192.168.1.50','','activo','2025-12-25 02:14:34','2025-12-25 02:14:34'),(285,'ISISLUCABA1526',1,100.00,2,'58:72:C3:80:25:15',1,22,'192.168.17.124',NULL,'68:D1:BA:19:02:91','pausado','2026-01-07 17:02:05','2026-01-07 17:02:05'),(286,'ISIS1209191379',1,50.00,1,'undefined',1,22,'','192.168.1.240','','activo','2026-01-10 07:17:25','2026-01-10 07:17:25'),(287,'ISISVIGAME1535',1,50.00,2,'IPTV',1,22,'',NULL,'','pausado','2026-01-16 22:28:44','2026-01-16 22:28:44'),(288,'ISISJUSAME1537',1,50.00,2,'SMARTV',1,22,'',NULL,'','pausado','2026-01-18 17:55:58','2026-01-18 17:55:58'),(289,'OBARGO221',1,50.00,2,'SMARTV',1,22,'192.168.17.29','192.168.1.120','44:A3:C7:E6:75:7E','activo','2026-01-22 03:37:53','2026-01-22 03:38:06'),(290,'ISISCADOPO1544',1,50.00,2,'LIVE TV',1,22,'','192.168.1.50','','activo','2026-01-29 05:46:23','2026-01-29 05:46:23'),(291,'ISISROARPO1541',1,50.00,2,'SMARTV',1,22,'','192.168.1.50','','activo','2026-01-29 05:47:11','2026-01-29 05:47:11');

--
-- Table structure for table `status_equipo`
--

CREATE TABLE `status_equipo` (
  `status_id` int NOT NULL AUTO_INCREMENT,
  `nombre_status_equipo` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  PRIMARY KEY (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `status_equipo`
--

INSERT INTO `status_equipo` VALUES (1,'Comprado'),(2,'Rentado');

--
-- Table structure for table `status_instalaciones`
--

CREATE TABLE `status_instalaciones` (
  `status_id` int NOT NULL AUTO_INCREMENT,
  `nombre_status` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `descripcion` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  PRIMARY KEY (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `status_instalaciones`
--

INSERT INTO `status_instalaciones` VALUES (1,'agendado','La instalación fue guardada en la base de datos pero no ha sido agendada'),(2,'instalando','Se ha establecido una fecha para realizar la instalación'),(3,'conectando','La instalación esta siendo realizada por el técnico asignado'),(4,'finalizado','La instalacion fue eliminada por motivos extras'),(5,'cancelado','El servicio del cliente esta conectandose');

--
-- Table structure for table `status_negociaciones`
--

CREATE TABLE `status_negociaciones` (
  `status_negociacion` int NOT NULL AUTO_INCREMENT,
  `nombre` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`status_negociacion`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `status_negociaciones`
--

INSERT INTO `status_negociaciones` VALUES (1,'corriendo'),(2,'vencida'),(3,'pagada');

--
-- Table structure for table `status_reportes`
--

CREATE TABLE `status_reportes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `status_reporte` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `status_reportes`
--

INSERT INTO `status_reportes` VALUES (1,'espera','El reporte ha sido capturado por soporte tecnico'),(2,'revision','El reporte esta siendo revisado por los tecnicos'),(3,'finalizado','El reporte ha sido solucionado correctamente');

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `template` varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `type` enum('whatsapp','sms','email') CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci DEFAULT 'whatsapp',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `templates`
--

INSERT INTO `templates` VALUES (1,'welcome','Mensaje de bienvenida','Estimado {cliente} le damos las gracias por su preferencia, y ponemos a su disposición los números de teléfono para soporte técnico y aclaraciones:\n            \n*Finanzas:* +52 1 937 228 6860\n*Soporte:* +52 1 937 165 9727\n\nDe igual manera le recordamos puede realizar sus pagos mediante transferencias electrónicas con los siguientes datos:\n            \n*Nombre:* Jesús Manuel Gerónimo Mayge\n*Banco:* BBVA Bancomer\n*Numero de cuenta:* 2661614746\n*Numero de tarjeta:* 4152 3141 8291 0698\n*Concepto:* {concepto_transferencia}\n*Monto:* {monto_mensual}  \n     \nO bien puede realizar sus pagos en efectivo en nuestras precio_instalaciones ubicadas en:\n            \n1.- Av. Lázaro Cárdenas s/n entre Jacinto López y Ernesto Aguirre Colorado, frente a bodega Aurrera local No 1, Cárdenas Tabasco.\n            \n2.- Poblado Mecatepec Huimanguillo, frente a la cancha de basquetbol local No 2\n            \n*Detalles del servicio*\n*Mensualidad:* {mensualidad}\n*Costo de costo_renta:* {costo_renta}\n*Instalación:* {precio_instalacion}\n*Facturación:* Días {dia_facturacion} de cada mes\n*Monto mensual:* {monto_mensual}\n\nES MUY IMPORTANTE ENVIAR EL COMPROBANTE','whatsapp'),(2,'recordatorio','Recordatorio de pago','Estimado {cliente} \n\nSu fecha de facturación esta cerca.\n\nPuede realizar su pago mediante transferencias electrónicas con los siguientes datos:\n\n*Nombre:* Jesus Manuel Geronimo Mayge\n*Banco:* BBVA Bancomer\n*Numero de cuenta:* 2661614746\n*Numero de tarjeta:* 4152 3141 8291 0698\n*Concepto:* {concepto_transferencia}\n\n*ES MUY IMPORTANTE ENVIAR EL COMPROBANTE* \n\nTambién puede realizar sus pagos en efectivo en nuestras instalaciones ubicadas en:\n\n1.- Av. Lazaro Cardenas s/n entre Jasinto López y Ernesto Aguirre Colorado, frente a bodega aurrera local N 1, Cárdenas Tabasco.\n\n2.- Poblado Mecatepec Huimanguillo, frente a la cancha de basquetbol local N 2.\n\n*Gracias por ser parte de nosotros*','whatsapp'),(3,'suspension','Mensaje de suspención','Estimado {cliente}\n\nLe informamos que su servicio ha sido suspendido por que no se reporto pago para el periodo actual el cual debió pagarse el día {corte}. \n\nPuede solicitar una negociación llamando al telefono: +52 1 937 228 6860 y su servicio será conectado mientras, realiza el pago correspondiente\n\n!Gracias por su comprensión!\n','whatsapp'),(4,'negociacion','Mensaje de negociación','Estimado {cliente}\n\nHemos agregado una negociación para que se extienda servicio la fecha {fecha_fin} de no realizarse el pago el servicio volverá a suspenderse.\n\n*Gracias por ser parte de nosotros!*\n','whatsapp'),(5,'facturacion','Mensaje de facturación','\nEstimad@ {cliente} le recordamos que hoy es el día en que debe pagar la mensualidad de su servicio, si el pago no es reportado el servicio será suspendido en los proximos días.\n\nRecuerde que su pago nos ayuda a brindarle un mejor servicio.\n\n*Gracias por su comprensión*','whatsapp'),(6,'pago','Mensaje de pago','Estimado {cliente}. Hemos capturado su pago correctamente le mostramos a continuación todos los detalles:\n\n*Periodos:* {periodos_pagados}\n*Monto del pago:* {monto_pago}\n*Fecha de captura:* {fecha_captura}\nTipo de pago: {tipo_pago}\nFolio: {folio_pago}\nPagos extras: {ingresos_extras}\n\nLe recordamos que el pago será revisado y puede ser rechazado en caso de errores los cuales se le harán saber en su momento.\n\nEL pago se refleja desde {fecha_inicio} hasta el {fecha_expiracion}, si tiene alguna duda o necesita una aclaración comuniquese al numero +52 1 937 228 6860.\n\nHaga click en el link para solicitar su recibo: {link_pdf}\n\nGracias por ser parte de nosotros','whatsapp'),(7,'negociacion','Mensaje de negociacion','Estimado {cliente}\n\nEste mensaje es para informarle que la negociacion establecida  para la fecha {fecha_fin} ha finalizado, lamentablemente no hemos encontrado registro de pago, por lo que el sistema procederá a suspender su servicio.\n\nSi ya realizo su pago y esta recibiendo este mensaje puede pedir informes en nuestras oficinas ubicadas en:\n\n1.- Avenida Lázaro Cárdenas, Colonia Centro, Cardenas Tabasco, Frente a Bodega Aurrera planta alta, Local N° 1\n\n2.- Poblado Mecatepec, Huimanguillo Tabasco, frente al domo, local N° 2\n\nO bien puede comunicarse al teléfono: +52 1 937 385 3062\n\n*Gracias por su comprensión*','whatsapp'),(8,'falla','Falla reportada','Estimado {cliente}\n\nHemos recibido un reporte de falla el cual será atendido por nuestros técnicos de la forma más ágil posible, le pedimos que sea paciente en lo que atendemos las fallas previas a la reportada por usted.\nPersonal de oficina le mantendrá informado de cualquier situación.\n\nGracias por su comprención','whatsapp'),(9,'falla','Atención de reporte','Estimado {tecnico}\r\n\r\nSe ha asignado un reporte para su cuadrilla con los siguientes detalles:\r\n\r\n*Falla:* {reporte_descripcion}\r\n*Cliente:* {cliente}\r\n*Telefono:* {cliente_telefono}\r\n*Direccion:* {cliente_direccion}\r\n*Ubicacion:* {cliente_ubicacion}\r\n*Zona:* {zona_nombre}\r\n*Marca de cable*: {mark_wire}\r\n\r\nNo olvide realizar el siguiente proceso antes de atender el reporte:\r\n\r\n*1.-* Revisar la ubicacion del cliente y la coincidencia con la zona\r\n\r\n*2.-* Comunicarse con el cliente antes de dirijirse al domicilio\r\n\r\n*3.-* Cuestionar al cliente si la falla aun persiste\r\n\r\nRecuerde ser amable con el cliente y presentarse antes de comenzar, recuerde que la atención es lo más importante.','whatsapp'),(10,'instalacion','Instalación programada','Estimado {cliente}\n\nHemos agendado su instalación de manera satisfactoria con los siguientes datos:\n\n*Cliente:* {cliente}\n*Costo:* {costo_instalacion}\n*Telefono:* {cliente_telefono}\n*Fecha:* {fecha_programada}\n\nMantengase en contacto con su promotor o envienos un mensage de whatsapp al telefono +52 1 937 228 6860.','whatsapp'),(11,'instalacion','Instalacion iniciada','Estimado {tecnico} \n\nSe ha asignado una instalación para su cuadrilla, a continuación los detalles:\n\n*Cliente:* {cliente}\n*Telefono de contacto:* {cliente_telefono}\n*Direccion:* {direccion}\n*Ubicacion:* {ubicacion}\n*Colonia:* {colonia}\n\nNo olvide realizar el siguiente proceso antes de atender el reporte:\n\n1.- Revisar la ubicación del cliente y la coincidencia con la colonia\n\n2.- Comunicarse con el cliente antes de dirigirse al domicilio\n\nRecuerde ser amable y presentarse antes de comenzar, recuerde que la atención es lo más importante.','whatsapp'),(12,'instalacion','Instalación iniciada','Estimado {promotor} \n\nSe ha dado inicio a la instalación a nombre de {cliente}, mantengase en contacto con el cliente para confirmar la visita.\n\nSi es necesario envienos un mensaje de whatsapp al telefono +52 1 937 228 6860 para cualquier situación. Gracias por su colaboración.','whatsapp'),(13,'instalacion','Instalación iniciada','Estimado {cliente} \n\nSe ha dado inicio a su instalación a nombre de {cliente}, en unos momentos nuestros técnicos llegarán a su domicilio.\n\nSi es necesario envienos un mensaje de whatsapp al telefono +52 1 937 228 6860 para cualquier situación. Gracias por su colaboración.','whatsapp'),(14,'instalacion','Instalación programada','Estimado {promotor} \n\nHemos agendado la instalación a nombre de {cliente} para el dia {fecha_programada} con un costo de {costo_instalacion}.\n\nMantengase en comunicación con cliente y personal de oficina para confirmar la información o aclarar dudas. Gracias por su colaboración.','whatsapp'),(15,'falla','Atencion inicializada','Estimado {cliente}.\r\n\r\nSe ha dado inicio a la atencion de su reporte: {reporte_descripcion}. \r\n                                     \r\nEn unos momentos nuestros técnicos llegarán a su domicilio.\r\n                                       \r\nSi es necesario envienos un mensaje de whatsapp al telefono +52 1 937 228 6860 para cualquier situación. \r\n                                       \r\nGracias por su apoyo.','whatsapp');

--
-- Table structure for table `tipo_servicios`
--

CREATE TABLE `tipo_servicios` (
  `servicio_id` int NOT NULL AUTO_INCREMENT,
  `nombre_servicio` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  PRIMARY KEY (`servicio_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `tipo_servicios`
--

INSERT INTO `tipo_servicios` VALUES (1,'Inalambrico'),(2,'Fibra Optica');

--
-- Table structure for table `tipos_clientes`
--

CREATE TABLE `tipos_clientes` (
  `tipo_cliente_id` int NOT NULL AUTO_INCREMENT,
  `tipo_nombre` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `tipo_descripcion` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `tipo_privilegios` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `tipo_descuento` int NOT NULL,
  PRIMARY KEY (`tipo_cliente_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `tipos_clientes`
--

INSERT INTO `tipos_clientes` VALUES (1,'Residencial','Cliente con internet para su hogar','',0),(2,'Empresarial','Cliente con más de un servicio, tv e internet','',0),(3,'Negocios','Cliente con mas de dos servicios','',0);

--
-- Table structure for table `tipos_movimientos`
--

CREATE TABLE `tipos_movimientos` (
  `tipo_movimiento_id` int NOT NULL AUTO_INCREMENT,
  `nombre_movimiento` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `descripcion` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  PRIMARY KEY (`tipo_movimiento_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `tipos_movimientos`
--

INSERT INTO `tipos_movimientos` VALUES (1,'Entrada','Ingreso a caja'),(2,'Salida','Salida de caja');

--
-- Table structure for table `usuarios_status`
--

CREATE TABLE `usuarios_status` (
  `status_id` int NOT NULL AUTO_INCREMENT,
  `status_nombre` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `descripcion` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  PRIMARY KEY (`status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `usuarios_status`
--

INSERT INTO `usuarios_status` VALUES (1,'Activo','El usuario puede acceder al sistema y a us funciones'),(2,'Suspendido','El cliente no puede realizar ninguna operacion en el sistema'),(3,'Baja','El  cliente fue dado de baja hasta que el usuario root lo reactive de nuevo'),(4,'conectado','Usuario con mas de una session');

--
-- Table structure for table `usuarios_tipos`
--

CREATE TABLE `usuarios_tipos` (
  `tipo_id` int NOT NULL AUTO_INCREMENT,
  `tipo_nombre` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `destroy` int NOT NULL,
  `view` int NOT NULL,
  `edit` int NOT NULL,
  `creation` int NOT NULL,
  `negociation` int NOT NULL DEFAULT '1',
  `installations` int NOT NULL,
  `payment` int NOT NULL,
  `reports` int NOT NULL,
  `suspend` int NOT NULL,
  `unsubscribe` int NOT NULL,
  `enable` int NOT NULL,
  PRIMARY KEY (`tipo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `usuarios_tipos`
--

INSERT INTO `usuarios_tipos` VALUES (1,'root',1,1,1,1,1,1,1,1,1,1,1),(2,'admin',1,1,1,1,1,1,1,1,1,1,1),(3,'gerente',0,1,1,0,1,0,0,0,0,0,0),(4,'cobranza',0,1,1,1,1,1,1,1,1,1,1),(5,'tecnico',0,1,0,0,0,0,0,0,0,0,0),(6,'promotor',0,0,0,0,0,1,0,0,0,0,0),(7,'sistemas',0,0,0,0,0,0,0,0,0,0,0),(8,'finanzas',0,0,0,0,0,0,0,0,0,0,0),(9,'soporte',0,0,0,0,0,0,0,0,0,0,0);

--
-- Table structure for table `zonas`
--

CREATE TABLE `zonas` (
  `zona_id` int NOT NULL AUTO_INCREMENT,
  `zona_nombre` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci NOT NULL,
  `zona_ubicacion` varchar(2083) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci DEFAULT NULL,
  `zona_mikrotik` int DEFAULT NULL,
  `zona_status` int DEFAULT '1',
  `address_ip` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci DEFAULT NULL,
  `broadcast` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish2_ci DEFAULT NULL,
  PRIMARY KEY (`zona_id`),
  KEY `mikrotik_control` (`zona_mikrotik`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish2_ci;

--
-- Dumping data for table `zonas`
--

INSERT INTO `zonas` VALUES (1,'Tecominoacan',NULL,1,0,NULL,NULL),(2,'C17',NULL,1,1,NULL,NULL),(4,'Meca',NULL,2,0,NULL,NULL),(5,'C34',NULL,1,1,NULL,NULL),(6,'Bajio',NULL,1,1,NULL,NULL),(7,'Obrera',NULL,1,1,NULL,NULL),(8,'San Fernando',NULL,1,1,NULL,NULL),(9,'Pino Suarez',NULL,1,0,NULL,NULL),(10,'Cardenas',NULL,1,1,NULL,NULL),(11,'Progreso',NULL,1,0,NULL,NULL),(12,'Ocuapan',NULL,1,1,NULL,NULL),(13,'C33',NULL,1,0,NULL,NULL),(14,'Zamora',NULL,1,1,NULL,NULL),(15,'SANTANA',NULL,1,1,NULL,NULL),(18,'Paso la Mina',NULL,1,1,NULL,NULL),(19,'Los Naranjos',NULL,1,0,NULL,NULL),(21,'Huimanguillo',NULL,2,0,NULL,NULL),(22,'C41',NULL,1,0,NULL,NULL),(32,'Mecatepec',NULL,2,1,NULL,NULL),(33,'Invitab',NULL,1,1,NULL,NULL),(34,'GUADALUPE VICTORIA',NULL,1,1,NULL,NULL),(35,'PINO ZUAREZ',NULL,3,1,NULL,NULL),(36,'Jacinto Lopez  Cardenas ',NULL,1,1,NULL,NULL),(37,'Rio seco ',NULL,1,1,NULL,NULL),(38,'Tecominoacan Fibra',NULL,4,1,NULL,NULL),(39,'Petrolera',NULL,1,1,NULL,NULL),(40,'Petrolera',NULL,1,1,NULL,NULL),(41,'Pomoca',NULL,1,1,NULL,NULL),(42,'El Toloque',NULL,1,1,NULL,NULL),(43,'Nuevo Progreso',NULL,5,1,NULL,NULL),(44,'C33 FIBRA',NULL,6,1,NULL,NULL),(45,'C-41',NULL,7,1,NULL,NULL),(46,'San Fernando Fibra',NULL,9,1,NULL,NULL),(47,'Tascoob',NULL,1,1,NULL,NULL),(48,'C-34 Fibra',NULL,11,1,NULL,NULL);

--
-- Dumping events for database 'isisinte_isisinternet'
--

--
-- Dumping routines for database 'isisinte_isisinternet'
--


