--
-- Host: localhost    Database: inv2
-- ------------------------------------------------------


--
-- Table structure for table `inv_asignaciones`
--

CREATE TABLE `inv_asignaciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ciclo_item_id` int(11) NOT NULL,
  `empleado_id` int(11) NOT NULL,
  `monitor_id` int(11) NOT NULL,
  `asignado_por` int(11) NOT NULL,
  `asignado_en` datetime NOT NULL,
  `entregado_en` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ciclo_item_id` (`ciclo_item_id`),
  KEY `empleado_id` (`empleado_id`),
  KEY `monitor_id` (`monitor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=333 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inv_asignaciones`
--

INSERT INTO `inv_asignaciones` VALUES (63,179,3,2,2,'2026-02-05 12:27:44',NULL),(64,180,3,2,2,'2026-02-05 12:27:44',NULL),(65,181,3,2,2,'2026-02-05 12:27:44',NULL),(66,182,3,2,2,'2026-02-05 12:27:44',NULL),(67,174,3,2,2,'2026-02-05 12:27:44',NULL),(68,175,3,2,2,'2026-02-05 12:27:44',NULL),(69,176,3,2,2,'2026-02-05 12:27:44',NULL),(70,177,3,2,2,'2026-02-05 12:27:45',NULL),(71,178,3,2,2,'2026-02-05 12:27:45',NULL),(72,169,3,2,2,'2026-02-05 12:27:45',NULL),(73,170,3,2,2,'2026-02-05 12:27:45',NULL),(74,171,3,2,2,'2026-02-05 12:27:45',NULL),(75,172,3,2,2,'2026-02-05 12:27:45',NULL),(76,173,3,2,2,'2026-02-05 12:27:45',NULL),(77,71,9,2,2,'2026-02-05 12:28:09',NULL),(78,72,9,2,2,'2026-02-05 12:28:09',NULL),(79,73,9,2,2,'2026-02-05 12:28:09',NULL),(80,74,9,2,2,'2026-02-05 12:28:10',NULL),(81,225,8,2,2,'2026-02-05 13:04:55',NULL),(82,226,8,2,2,'2026-02-05 13:04:55',NULL),(83,227,8,2,2,'2026-02-05 13:04:55',NULL),(84,228,8,2,2,'2026-02-05 13:04:55',NULL),(85,221,8,2,2,'2026-02-05 13:04:55',NULL),(86,222,8,2,2,'2026-02-05 13:04:55',NULL),(87,223,8,2,2,'2026-02-05 13:04:55',NULL),(88,224,8,2,2,'2026-02-05 13:04:56',NULL),(89,209,10,2,2,'2026-02-05 13:04:56',NULL),(90,210,10,2,2,'2026-02-05 13:04:56',NULL),(91,211,10,2,2,'2026-02-05 13:04:56',NULL),(92,212,10,2,2,'2026-02-05 13:04:56',NULL),(93,213,10,2,2,'2026-02-05 13:04:56',NULL),(94,214,10,2,2,'2026-02-05 13:04:56',NULL),(95,215,10,2,2,'2026-02-05 13:04:56',NULL),(96,216,10,2,2,'2026-02-05 13:04:56',NULL),(97,217,10,2,2,'2026-02-05 13:04:57',NULL),(98,218,10,2,2,'2026-02-05 13:04:57',NULL),(99,219,10,2,2,'2026-02-05 13:04:57',NULL),(100,220,10,2,2,'2026-02-05 13:04:57',NULL),(101,197,10,2,2,'2026-02-05 13:04:57',NULL),(102,198,10,2,2,'2026-02-05 13:04:57',NULL),(103,199,10,2,2,'2026-02-05 13:04:57',NULL),(104,200,10,2,2,'2026-02-05 13:04:57',NULL),(105,201,10,2,2,'2026-02-05 13:04:57',NULL),(106,202,10,2,2,'2026-02-05 13:04:57',NULL),(107,203,10,2,2,'2026-02-05 13:04:58',NULL),(108,204,10,2,2,'2026-02-05 13:04:58',NULL),(109,205,10,2,2,'2026-02-05 13:04:58',NULL),(110,206,10,2,2,'2026-02-05 13:04:58',NULL),(111,207,10,2,2,'2026-02-05 13:04:58',NULL),(112,208,10,2,2,'2026-02-05 13:04:58',NULL),(113,191,7,2,2,'2026-02-05 13:04:58',NULL),(114,192,7,2,2,'2026-02-05 13:04:58',NULL),(115,193,7,2,2,'2026-02-05 13:04:58',NULL),(116,194,7,2,2,'2026-02-05 13:04:59',NULL),(117,195,7,2,2,'2026-02-05 13:04:59',NULL),(118,196,7,2,2,'2026-02-05 13:04:59',NULL),(119,187,6,2,2,'2026-02-05 13:04:59',NULL),(120,188,6,2,2,'2026-02-05 13:04:59',NULL),(121,189,6,2,2,'2026-02-05 13:05:00',NULL),(122,190,6,2,2,'2026-02-05 13:05:00',NULL),(123,183,6,2,2,'2026-02-05 13:05:00',NULL),(124,184,6,2,2,'2026-02-05 13:05:00',NULL),(125,185,6,2,2,'2026-02-05 13:05:00',NULL),(126,186,6,2,2,'2026-02-05 13:05:00',NULL),(127,229,7,2,2,'2026-02-05 13:56:30',NULL),(128,230,7,2,2,'2026-02-05 13:56:30',NULL),(129,231,7,2,2,'2026-02-05 13:56:30',NULL),(130,232,7,2,2,'2026-02-05 13:56:30',NULL),(131,233,7,2,2,'2026-02-05 13:56:30',NULL),(132,234,7,2,2,'2026-02-05 13:56:30',NULL),(133,235,7,2,2,'2026-02-05 13:56:30',NULL),(134,271,9,2,2,'2026-02-05 15:24:32',NULL),(135,272,9,2,2,'2026-02-05 15:24:32',NULL),(136,267,9,2,2,'2026-02-05 15:24:32',NULL),(137,268,9,2,2,'2026-02-05 15:24:32',NULL),(138,269,9,2,2,'2026-02-05 15:24:32',NULL),(139,270,9,2,2,'2026-02-05 15:24:32',NULL),(140,263,9,2,2,'2026-02-05 15:24:33',NULL),(141,264,9,2,2,'2026-02-05 15:24:33',NULL),(142,265,9,2,2,'2026-02-05 15:24:33',NULL),(143,266,9,2,2,'2026-02-05 15:24:33',NULL),(144,260,7,2,2,'2026-02-05 15:24:33',NULL),(145,262,6,2,2,'2026-02-05 15:25:11',NULL),(146,261,6,2,2,'2026-02-05 15:25:11',NULL),(147,280,14,2,2,'2026-02-05 16:35:19',NULL),(148,281,14,2,2,'2026-02-05 16:35:19',NULL),(149,282,14,2,2,'2026-02-05 16:35:20',NULL),(150,283,14,2,2,'2026-02-05 16:35:20',NULL),(151,284,14,2,2,'2026-02-05 16:35:20',NULL),(152,273,14,2,2,'2026-02-05 16:35:20',NULL),(153,274,14,2,2,'2026-02-05 16:35:20',NULL),(154,275,14,2,2,'2026-02-05 16:35:20',NULL),(155,276,14,2,2,'2026-02-05 16:35:20',NULL),(156,277,14,2,2,'2026-02-05 16:35:20',NULL),(157,278,14,2,2,'2026-02-05 16:35:20',NULL),(158,279,14,2,2,'2026-02-05 16:35:20',NULL),(159,343,10,2,2,'2026-02-05 16:35:57',NULL),(160,344,10,2,2,'2026-02-05 16:35:58',NULL),(161,345,10,2,2,'2026-02-05 16:35:58',NULL),(162,346,10,2,2,'2026-02-05 16:35:58',NULL),(163,347,10,2,2,'2026-02-05 16:35:58',NULL),(164,348,10,2,2,'2026-02-05 16:35:58',NULL),(165,349,10,2,2,'2026-02-05 16:35:58',NULL),(166,350,10,2,2,'2026-02-05 16:35:58',NULL),(167,351,10,2,2,'2026-02-05 16:35:58',NULL),(168,352,10,2,2,'2026-02-05 16:35:58',NULL),(169,353,10,2,2,'2026-02-05 16:35:59',NULL),(170,354,10,2,2,'2026-02-05 16:35:59',NULL),(171,331,10,2,2,'2026-02-05 16:35:59',NULL),(172,332,10,2,2,'2026-02-05 16:35:59',NULL),(173,333,10,2,2,'2026-02-05 16:35:59',NULL),(174,334,10,2,2,'2026-02-05 16:35:59',NULL),(175,335,10,2,2,'2026-02-05 16:35:59',NULL),(176,336,10,2,2,'2026-02-05 16:36:00',NULL),(177,337,10,2,2,'2026-02-05 16:36:00',NULL),(178,338,10,2,2,'2026-02-05 16:36:00',NULL),(179,339,10,2,2,'2026-02-05 16:36:00',NULL),(180,340,10,2,2,'2026-02-05 16:36:00',NULL),(181,341,10,2,2,'2026-02-05 16:36:00',NULL),(182,342,10,2,2,'2026-02-05 16:36:00',NULL),(183,395,6,2,2,'2026-02-05 17:00:34',NULL),(184,396,6,2,2,'2026-02-05 17:00:34',NULL),(185,397,6,2,2,'2026-02-05 17:00:34',NULL),(186,398,6,2,2,'2026-02-05 17:00:35',NULL),(187,391,6,2,2,'2026-02-05 17:00:35',NULL),(188,392,6,2,2,'2026-02-05 17:00:35',NULL),(189,393,6,2,2,'2026-02-05 17:00:35',NULL),(190,394,6,2,2,'2026-02-05 17:00:36',NULL),(191,387,6,2,2,'2026-02-05 17:00:36',NULL),(192,388,6,2,2,'2026-02-05 17:00:36',NULL),(193,389,6,2,2,'2026-02-05 17:00:36',NULL),(194,390,6,2,2,'2026-02-05 17:00:36',NULL),(195,383,6,2,2,'2026-02-05 17:00:36',NULL),(196,384,6,2,2,'2026-02-05 17:00:36',NULL),(197,385,6,2,2,'2026-02-05 17:00:37',NULL),(198,386,6,2,2,'2026-02-05 17:00:37',NULL),(199,379,6,2,2,'2026-02-05 17:00:37',NULL),(200,380,6,2,2,'2026-02-05 17:00:37',NULL),(201,381,6,2,2,'2026-02-05 17:00:37',NULL),(202,382,6,2,2,'2026-02-05 17:00:37',NULL),(203,375,6,2,2,'2026-02-05 17:00:37',NULL),(204,376,6,2,2,'2026-02-05 17:00:37',NULL),(205,377,6,2,2,'2026-02-05 17:00:37',NULL),(206,378,6,2,2,'2026-02-05 17:00:38',NULL),(207,371,6,2,2,'2026-02-05 17:00:38',NULL),(208,372,6,2,2,'2026-02-05 17:00:38',NULL),(209,373,6,2,2,'2026-02-05 17:00:38',NULL),(210,374,6,2,2,'2026-02-05 17:00:38',NULL),(211,367,6,2,2,'2026-02-05 17:00:38',NULL),(212,368,6,2,2,'2026-02-05 17:00:38',NULL),(213,369,6,2,2,'2026-02-05 17:00:38',NULL),(214,370,6,2,2,'2026-02-05 17:00:38',NULL),(215,363,6,2,2,'2026-02-05 17:00:38',NULL),(216,364,6,2,2,'2026-02-05 17:00:39',NULL),(217,365,6,2,2,'2026-02-05 17:00:39',NULL),(218,366,6,2,2,'2026-02-05 17:00:39',NULL),(219,359,8,2,2,'2026-02-05 17:00:39',NULL),(220,360,8,2,2,'2026-02-05 17:00:39',NULL),(221,361,8,2,2,'2026-02-05 17:00:39',NULL),(222,362,8,2,2,'2026-02-05 17:00:39',NULL),(223,355,8,2,2,'2026-02-05 17:00:39',NULL),(224,356,8,2,2,'2026-02-05 17:00:39',NULL),(225,357,8,2,2,'2026-02-05 17:00:39',NULL),(226,358,8,2,2,'2026-02-05 17:00:40',NULL),(227,321,3,2,2,'2026-02-05 17:00:40',NULL),(228,322,3,2,2,'2026-02-05 17:00:40',NULL),(229,323,3,2,2,'2026-02-05 17:00:40',NULL),(230,324,3,2,2,'2026-02-05 17:00:40',NULL),(231,325,3,2,2,'2026-02-05 17:00:41',NULL),(232,326,3,2,2,'2026-02-05 17:00:41',NULL),(233,327,3,2,2,'2026-02-05 17:00:41',NULL),(234,328,3,2,2,'2026-02-05 17:00:41',NULL),(235,329,3,2,2,'2026-02-05 17:00:41',NULL),(236,330,3,2,2,'2026-02-05 17:00:41',NULL),(237,316,3,2,2,'2026-02-05 17:00:41',NULL),(238,317,3,2,2,'2026-02-05 17:00:41',NULL),(239,318,3,2,2,'2026-02-05 17:00:41',NULL),(240,319,3,2,2,'2026-02-05 17:00:42',NULL),(241,320,3,2,2,'2026-02-05 17:00:42',NULL),(242,306,3,2,2,'2026-02-05 17:00:42',NULL),(243,307,3,2,2,'2026-02-05 17:00:42',NULL),(244,308,3,2,2,'2026-02-05 17:00:42',NULL),(245,309,3,2,2,'2026-02-05 17:00:42',NULL),(246,310,3,2,2,'2026-02-05 17:00:42',NULL),(247,311,3,2,2,'2026-02-05 17:00:42',NULL),(248,312,3,2,2,'2026-02-05 17:00:43',NULL),(249,313,3,2,2,'2026-02-05 17:00:43',NULL),(250,314,3,2,2,'2026-02-05 17:00:43',NULL),(251,315,3,2,2,'2026-02-05 17:00:43',NULL),(252,296,3,2,2,'2026-02-05 17:00:43',NULL),(253,297,3,2,2,'2026-02-05 17:00:43',NULL),(254,298,3,2,2,'2026-02-05 17:00:43',NULL),(255,299,3,2,2,'2026-02-05 17:00:43',NULL),(256,300,3,2,2,'2026-02-05 17:00:43',NULL),(257,301,3,2,2,'2026-02-05 17:00:44',NULL),(258,302,3,2,2,'2026-02-05 17:00:44',NULL),(259,303,3,2,2,'2026-02-05 17:00:44',NULL),(260,304,3,2,2,'2026-02-05 17:00:44',NULL),(261,305,3,2,2,'2026-02-05 17:00:44',NULL),(262,285,3,2,2,'2026-02-05 17:00:44',NULL),(263,286,3,2,2,'2026-02-05 17:00:44',NULL),(264,287,3,2,2,'2026-02-05 17:00:44',NULL),(265,288,3,2,2,'2026-02-05 17:00:44',NULL),(266,289,3,2,2,'2026-02-05 17:00:44',NULL),(267,290,3,2,2,'2026-02-05 17:00:45',NULL),(268,291,3,2,2,'2026-02-05 17:00:45',NULL),(269,292,3,2,2,'2026-02-05 17:00:45',NULL),(270,293,3,2,2,'2026-02-05 17:00:45',NULL),(271,294,3,2,2,'2026-02-05 17:00:45',NULL),(272,295,3,2,2,'2026-02-05 17:00:45',NULL),(273,433,7,2,2,'2026-02-06 09:45:05',NULL),(274,434,7,2,2,'2026-02-06 09:45:05',NULL),(275,435,7,2,2,'2026-02-06 09:45:05',NULL),(276,436,7,2,2,'2026-02-06 09:45:05',NULL),(277,437,7,2,2,'2026-02-06 09:45:05',NULL),(278,438,7,2,2,'2026-02-06 09:45:05',NULL),(279,439,7,2,2,'2026-02-06 09:45:05',NULL),(280,440,7,2,2,'2026-02-06 09:45:06',NULL),(281,441,7,2,2,'2026-02-06 09:45:06',NULL),(282,442,7,2,2,'2026-02-06 09:45:06',NULL),(283,443,7,2,2,'2026-02-06 09:45:06',NULL),(284,444,7,2,2,'2026-02-06 09:45:06',NULL),(285,408,7,2,2,'2026-02-06 09:45:06',NULL),(286,409,7,2,2,'2026-02-06 09:45:06',NULL),(287,410,7,2,2,'2026-02-06 09:45:06',NULL),(288,411,7,2,2,'2026-02-06 09:45:06',NULL),(289,412,7,2,2,'2026-02-06 09:45:07',NULL),(290,404,7,2,2,'2026-02-06 09:45:07',NULL),(291,405,7,2,2,'2026-02-06 09:45:07',NULL),(292,406,7,2,2,'2026-02-06 09:45:07',NULL),(293,407,7,2,2,'2026-02-06 09:45:07',NULL),(294,403,14,2,2,'2026-02-06 09:45:07',NULL),(295,400,8,2,2,'2026-02-06 09:45:07',NULL),(296,401,8,2,2,'2026-02-06 09:45:07',NULL),(297,402,8,2,2,'2026-02-06 09:45:08',NULL),(298,399,7,2,2,'2026-02-06 09:45:08',NULL),(299,567,7,2,2,'2026-02-07 13:29:59',NULL),(300,568,7,2,2,'2026-02-07 13:29:59',NULL),(301,569,7,2,2,'2026-02-07 13:29:59',NULL),(302,570,7,2,2,'2026-02-07 13:29:59',NULL),(303,571,6,2,2,'2026-02-07 14:27:22',NULL),(304,572,6,2,2,'2026-02-07 14:27:22',NULL),(305,573,6,2,2,'2026-02-07 14:27:22',NULL),(306,574,14,2,2,'2026-02-07 13:31:16',NULL),(307,575,14,2,2,'2026-02-07 13:31:17',NULL),(308,576,14,2,2,'2026-02-07 13:31:17',NULL),(309,577,14,2,2,'2026-02-07 13:31:17',NULL),(310,578,14,2,2,'2026-02-07 13:31:17',NULL),(311,579,14,2,2,'2026-02-07 13:31:17',NULL),(312,597,3,2,2,'2026-02-07 14:27:19',NULL),(313,598,3,2,2,'2026-02-07 14:27:19',NULL),(314,599,3,2,2,'2026-02-07 14:27:19',NULL),(315,600,3,2,2,'2026-02-07 14:27:19',NULL),(316,588,3,2,2,'2026-02-07 14:27:20',NULL),(317,589,3,2,2,'2026-02-07 14:27:20',NULL),(318,590,3,2,2,'2026-02-07 14:27:20',NULL),(319,591,3,2,2,'2026-02-07 14:27:20',NULL),(320,592,3,2,2,'2026-02-07 14:27:20',NULL),(321,593,3,2,2,'2026-02-07 14:27:20',NULL),(322,594,3,2,2,'2026-02-07 14:27:20',NULL),(323,595,3,2,2,'2026-02-07 14:27:20',NULL),(324,596,3,2,2,'2026-02-07 14:27:20',NULL),(325,580,3,2,2,'2026-02-07 14:27:21',NULL),(326,581,3,2,2,'2026-02-07 14:27:21',NULL),(327,582,3,2,2,'2026-02-07 14:27:21',NULL),(328,583,3,2,2,'2026-02-07 14:27:21',NULL),(329,584,3,2,2,'2026-02-07 14:27:21',NULL),(330,585,3,2,2,'2026-02-07 14:27:21',NULL),(331,586,3,2,2,'2026-02-07 14:27:21',NULL),(332,587,3,2,2,'2026-02-07 14:27:21',NULL);

--
-- Table structure for table `inv_assignments`
--

CREATE TABLE `inv_assignments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `assigned_by_user_id` int(11) DEFAULT NULL,
  `assigned_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` enum('assigned','returned','reviewed','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'assigned',
  PRIMARY KEY (`id`),
  KEY `idx_item_status` (`item_id`,`status`),
  KEY `idx_employee` (`employee_id`),
  KEY `idx_assigned_at` (`assigned_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inv_assignments`
--


--
-- Table structure for table `inv_ciclo_items`
--

CREATE TABLE `inv_ciclo_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ciclo_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `item_variation_id` int(11) DEFAULT NULL,
  `estado` enum('nuevo','asignado','en_proceso','listo','archivado') NOT NULL DEFAULT 'nuevo',
  `creado_en` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_cycle_item` (`ciclo_id`,`item_id`,`item_variation_id`),
  KEY `ciclo_id` (`ciclo_id`),
  KEY `estado` (`estado`)
) ENGINE=InnoDB AUTO_INCREMENT=601 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inv_ciclo_items`
--

INSERT INTO `inv_ciclo_items` VALUES (70,1,2837,NULL,'archivado','2026-02-04 23:19:30'),(71,1,3858,22200,'listo','2026-02-04 23:21:45'),(72,1,3858,22201,'listo','2026-02-04 23:21:45'),(73,1,3858,22202,'listo','2026-02-04 23:21:45'),(74,1,3858,22203,'listo','2026-02-04 23:21:45'),(75,1,4572,NULL,'archivado','2026-02-04 23:23:28'),(76,1,7847,21736,'archivado','2026-02-05 00:01:45'),(77,1,7847,21737,'archivado','2026-02-05 00:01:45'),(78,1,7847,21738,'archivado','2026-02-05 00:01:45'),(79,1,7847,21739,'archivado','2026-02-05 00:01:45'),(80,1,7847,22125,'archivado','2026-02-05 00:01:45'),(81,1,7847,27506,'archivado','2026-02-05 00:01:45'),(82,1,10727,32002,'archivado','2026-02-05 00:02:14'),(83,1,4469,2145,'archivado','2026-02-05 00:06:43'),(84,1,4469,2146,'archivado','2026-02-05 00:06:43'),(85,1,4469,2147,'archivado','2026-02-05 00:06:43'),(86,1,4469,2149,'archivado','2026-02-05 00:06:43'),(87,1,5987,15601,'archivado','2026-02-05 00:06:57'),(88,1,5987,15602,'archivado','2026-02-05 00:06:57'),(89,1,5987,15603,'archivado','2026-02-05 00:06:57'),(90,1,5987,15604,'archivado','2026-02-05 00:06:57'),(91,1,5988,15605,'archivado','2026-02-05 00:07:04'),(92,1,5988,15606,'archivado','2026-02-05 00:07:04'),(93,1,5988,15607,'archivado','2026-02-05 00:07:04'),(94,1,5988,15608,'archivado','2026-02-05 00:07:04'),(95,1,5989,15609,'archivado','2026-02-05 00:07:10'),(96,1,5989,15610,'archivado','2026-02-05 00:07:10'),(97,1,5989,15611,'archivado','2026-02-05 00:07:10'),(98,1,5989,15612,'archivado','2026-02-05 00:07:10'),(99,1,10680,31838,'archivado','2026-02-05 00:07:19'),(100,1,10680,31839,'archivado','2026-02-05 00:07:19'),(101,1,10680,31840,'archivado','2026-02-05 00:07:19'),(102,1,10680,31841,'archivado','2026-02-05 00:07:19'),(103,1,10680,31842,'archivado','2026-02-05 00:07:19'),(104,1,10680,31843,'archivado','2026-02-05 00:07:19'),(105,1,10680,31844,'archivado','2026-02-05 00:07:19'),(106,1,11841,36055,'archivado','2026-02-05 00:07:31'),(107,1,11841,36056,'archivado','2026-02-05 00:07:31'),(108,1,11841,36057,'archivado','2026-02-05 00:07:31'),(109,1,11841,36058,'archivado','2026-02-05 00:07:31'),(110,1,10682,31852,'archivado','2026-02-05 00:07:41'),(111,1,10682,31853,'archivado','2026-02-05 00:07:42'),(112,1,10682,31854,'archivado','2026-02-05 00:07:42'),(113,1,10682,31855,'archivado','2026-02-05 00:07:42'),(114,1,10682,31856,'archivado','2026-02-05 00:07:42'),(115,1,10682,31857,'archivado','2026-02-05 00:07:42'),(116,1,10682,31858,'archivado','2026-02-05 00:07:42'),(117,1,13158,40950,'archivado','2026-02-05 00:07:52'),(118,1,13158,40951,'archivado','2026-02-05 00:07:52'),(119,1,13158,40952,'archivado','2026-02-05 00:07:52'),(120,1,13158,40953,'archivado','2026-02-05 00:07:52'),(121,1,13156,40942,'archivado','2026-02-05 00:08:02'),(122,1,13156,40943,'archivado','2026-02-05 00:08:02'),(123,1,13156,40944,'archivado','2026-02-05 00:08:02'),(124,1,13156,40945,'archivado','2026-02-05 00:08:02'),(125,1,13155,40938,'archivado','2026-02-05 00:08:10'),(126,1,13155,40939,'archivado','2026-02-05 00:08:10'),(127,1,13155,40940,'archivado','2026-02-05 00:08:10'),(128,1,13155,40941,'archivado','2026-02-05 00:08:10'),(129,1,13154,40933,'archivado','2026-02-05 00:08:18'),(130,1,13154,40934,'archivado','2026-02-05 00:08:18'),(131,1,13154,40935,'archivado','2026-02-05 00:08:19'),(132,1,13154,40936,'archivado','2026-02-05 00:08:19'),(133,1,13154,40937,'archivado','2026-02-05 00:08:19'),(134,1,12331,37859,'archivado','2026-02-05 00:08:29'),(135,1,12331,37860,'archivado','2026-02-05 00:08:29'),(136,1,12331,37861,'archivado','2026-02-05 00:08:29'),(137,1,12331,37862,'archivado','2026-02-05 00:08:30'),(138,1,12331,37863,'archivado','2026-02-05 00:08:30'),(139,1,12331,37864,'archivado','2026-02-05 00:08:30'),(140,1,12330,37854,'archivado','2026-02-05 00:08:57'),(141,1,12330,37855,'archivado','2026-02-05 00:08:57'),(142,1,12330,37856,'archivado','2026-02-05 00:08:57'),(143,1,12330,37857,'archivado','2026-02-05 00:08:57'),(144,1,12330,37858,'archivado','2026-02-05 00:08:57'),(145,1,12329,37849,'archivado','2026-02-05 00:09:09'),(146,1,12329,37850,'archivado','2026-02-05 00:09:09'),(147,1,12329,37851,'archivado','2026-02-05 00:09:09'),(148,1,12329,37852,'archivado','2026-02-05 00:09:09'),(149,1,12329,37853,'archivado','2026-02-05 00:09:09'),(150,1,11844,36067,'archivado','2026-02-05 00:09:19'),(151,1,11844,36068,'archivado','2026-02-05 00:09:19'),(152,1,11844,36069,'archivado','2026-02-05 00:09:19'),(153,1,11844,36070,'archivado','2026-02-05 00:09:19'),(154,1,11843,36063,'archivado','2026-02-05 00:09:25'),(155,1,11843,36064,'archivado','2026-02-05 00:09:26'),(156,1,11843,36065,'archivado','2026-02-05 00:09:26'),(157,1,11843,36066,'archivado','2026-02-05 00:09:26'),(158,1,11842,36059,'archivado','2026-02-05 00:09:30'),(159,1,11842,36060,'archivado','2026-02-05 00:09:30'),(160,1,11842,36061,'archivado','2026-02-05 00:09:30'),(161,1,11842,36062,'archivado','2026-02-05 00:09:30'),(162,1,10681,31845,'archivado','2026-02-05 00:09:37'),(163,1,10681,31846,'archivado','2026-02-05 00:09:37'),(164,1,10681,31847,'archivado','2026-02-05 00:09:37'),(165,1,10681,31848,'archivado','2026-02-05 00:09:37'),(166,1,10681,31849,'archivado','2026-02-05 00:09:37'),(167,1,10681,31850,'archivado','2026-02-05 00:09:37'),(168,1,10681,31851,'archivado','2026-02-05 00:09:37'),(169,1,13152,40923,'listo','2026-02-05 00:11:10'),(170,1,13152,40924,'listo','2026-02-05 00:11:10'),(171,1,13152,40925,'listo','2026-02-05 00:11:11'),(172,1,13152,40926,'listo','2026-02-05 00:11:11'),(173,1,13152,40927,'listo','2026-02-05 00:11:11'),(174,1,13153,40928,'listo','2026-02-05 00:11:30'),(175,1,13153,40929,'listo','2026-02-05 00:11:30'),(176,1,13153,40930,'listo','2026-02-05 00:11:30'),(177,1,13153,40931,'listo','2026-02-05 00:11:30'),(178,1,13153,40932,'listo','2026-02-05 00:11:30'),(179,1,13157,40946,'listo','2026-02-05 00:11:35'),(180,1,13157,40947,'listo','2026-02-05 00:11:35'),(181,1,13157,40948,'listo','2026-02-05 00:11:35'),(182,1,13157,40949,'listo','2026-02-05 00:11:35'),(183,1,10707,31953,'listo','2026-02-05 12:48:30'),(184,1,10707,31954,'listo','2026-02-05 12:48:30'),(185,1,10707,31955,'listo','2026-02-05 12:48:30'),(186,1,10707,31956,'listo','2026-02-05 12:48:30'),(187,1,10710,31965,'listo','2026-02-05 12:48:42'),(188,1,10710,31966,'listo','2026-02-05 12:48:42'),(189,1,10710,31967,'listo','2026-02-05 12:48:42'),(190,1,10710,31968,'listo','2026-02-05 12:48:42'),(191,1,11142,32857,'listo','2026-02-05 12:48:56'),(192,1,11142,32858,'listo','2026-02-05 12:48:56'),(193,1,11142,32859,'listo','2026-02-05 12:48:56'),(194,1,11142,32860,'listo','2026-02-05 12:48:57'),(195,1,11142,32861,'listo','2026-02-05 12:48:57'),(196,1,11142,32862,'listo','2026-02-05 12:48:57'),(197,1,11178,32986,'listo','2026-02-05 12:49:26'),(198,1,11178,32987,'listo','2026-02-05 12:49:26'),(199,1,11178,32988,'listo','2026-02-05 12:49:26'),(200,1,11178,32989,'listo','2026-02-05 12:49:26'),(201,1,11178,32990,'listo','2026-02-05 12:49:26'),(202,1,11178,32991,'listo','2026-02-05 12:49:26'),(203,1,11178,32992,'listo','2026-02-05 12:49:26'),(204,1,11178,32993,'listo','2026-02-05 12:49:26'),(205,1,11178,32994,'listo','2026-02-05 12:49:26'),(206,1,11178,32995,'listo','2026-02-05 12:49:26'),(207,1,11178,32996,'listo','2026-02-05 12:49:26'),(208,1,11178,32997,'listo','2026-02-05 12:49:26'),(209,1,11179,32998,'listo','2026-02-05 12:49:32'),(210,1,11179,32999,'listo','2026-02-05 12:49:32'),(211,1,11179,33000,'listo','2026-02-05 12:49:32'),(212,1,11179,33001,'listo','2026-02-05 12:49:32'),(213,1,11179,33002,'listo','2026-02-05 12:49:32'),(214,1,11179,33003,'listo','2026-02-05 12:49:32'),(215,1,11179,33004,'listo','2026-02-05 12:49:32'),(216,1,11179,33005,'listo','2026-02-05 12:49:33'),(217,1,11179,33006,'listo','2026-02-05 12:49:33'),(218,1,11179,33007,'listo','2026-02-05 12:49:33'),(219,1,11179,33008,'listo','2026-02-05 12:49:33'),(220,1,11179,33009,'listo','2026-02-05 12:49:33'),(221,1,11834,36026,'listo','2026-02-05 12:55:27'),(222,1,11834,36027,'listo','2026-02-05 12:55:28'),(223,1,11834,36028,'listo','2026-02-05 12:55:28'),(224,1,11834,36029,'listo','2026-02-05 12:55:28'),(225,1,13166,40984,'listo','2026-02-05 12:56:59'),(226,1,13166,40985,'listo','2026-02-05 12:56:59'),(227,1,13166,40986,'listo','2026-02-05 12:56:59'),(228,1,13166,40987,'listo','2026-02-05 12:56:59'),(229,1,5186,8898,'listo','2026-02-05 13:16:08'),(230,1,5186,8899,'listo','2026-02-05 13:16:08'),(231,1,5186,8900,'listo','2026-02-05 13:16:08'),(232,1,5186,8901,'listo','2026-02-05 13:16:08'),(233,1,5186,8902,'listo','2026-02-05 13:16:09'),(234,1,5186,8903,'listo','2026-02-05 13:16:09'),(235,1,5186,8904,'listo','2026-02-05 13:16:09'),(236,1,4595,2310,'archivado','2026-02-05 14:32:14'),(237,1,4595,2311,'archivado','2026-02-05 14:32:14'),(238,1,4595,2312,'archivado','2026-02-05 14:32:14'),(239,1,4595,2313,'archivado','2026-02-05 14:32:14'),(240,1,4595,2314,'archivado','2026-02-05 14:32:14'),(241,1,4595,2315,'archivado','2026-02-05 14:32:14'),(242,1,4595,2316,'archivado','2026-02-05 14:32:14'),(243,1,4595,2317,'archivado','2026-02-05 14:32:14'),(244,1,4595,2318,'archivado','2026-02-05 14:32:14'),(245,1,4595,2319,'archivado','2026-02-05 14:32:14'),(246,1,4595,2320,'archivado','2026-02-05 14:32:14'),(247,1,4595,2321,'archivado','2026-02-05 14:32:14'),(248,1,4595,2322,'archivado','2026-02-05 14:32:14'),(249,1,4595,2390,'archivado','2026-02-05 14:32:14'),(250,1,4595,2391,'archivado','2026-02-05 14:32:14'),(251,1,4595,2392,'archivado','2026-02-05 14:32:14'),(252,1,4595,2393,'archivado','2026-02-05 14:32:15'),(253,1,4595,2394,'archivado','2026-02-05 14:32:15'),(254,1,4595,2395,'archivado','2026-02-05 14:32:15'),(255,1,4595,2396,'archivado','2026-02-05 14:32:15'),(256,1,4595,2397,'archivado','2026-02-05 14:32:15'),(257,1,4595,2398,'archivado','2026-02-05 14:32:15'),(258,1,4595,2399,'archivado','2026-02-05 14:32:15'),(259,1,4595,2400,'archivado','2026-02-05 14:32:15'),(260,1,13067,40639,'listo','2026-02-05 15:11:41'),(261,1,13090,40662,'listo','2026-02-05 15:12:49'),(262,1,13091,40663,'listo','2026-02-05 15:13:56'),(263,1,13104,40696,'listo','2026-02-05 15:14:57'),(264,1,13104,40697,'listo','2026-02-05 15:14:57'),(265,1,13104,40698,'listo','2026-02-05 15:14:58'),(266,1,13104,40699,'listo','2026-02-05 15:14:58'),(267,1,13105,40700,'listo','2026-02-05 15:15:14'),(268,1,13105,40701,'listo','2026-02-05 15:15:14'),(269,1,13105,40702,'listo','2026-02-05 15:15:14'),(270,1,13105,40703,'listo','2026-02-05 15:15:14'),(271,1,13106,40704,'listo','2026-02-05 15:15:32'),(272,1,13106,40705,'listo','2026-02-05 15:15:32'),(273,1,13118,40749,'listo','2026-02-05 16:25:15'),(274,1,13118,40750,'listo','2026-02-05 16:25:15'),(275,1,13118,40751,'listo','2026-02-05 16:25:15'),(276,1,13118,40752,'listo','2026-02-05 16:25:15'),(277,1,13118,40753,'listo','2026-02-05 16:25:15'),(278,1,13118,40754,'listo','2026-02-05 16:25:15'),(279,1,13118,40755,'listo','2026-02-05 16:25:15'),(280,1,13119,40756,'listo','2026-02-05 16:25:36'),(281,1,13119,40757,'listo','2026-02-05 16:25:36'),(282,1,13119,40758,'listo','2026-02-05 16:25:36'),(283,1,13119,40759,'listo','2026-02-05 16:25:36'),(284,1,13119,40760,'listo','2026-02-05 16:25:36'),(285,1,13122,40773,'listo','2026-02-05 16:26:16'),(286,1,13122,40774,'listo','2026-02-05 16:26:16'),(287,1,13122,40775,'listo','2026-02-05 16:26:16'),(288,1,13122,40776,'listo','2026-02-05 16:26:16'),(289,1,13122,40777,'listo','2026-02-05 16:26:16'),(290,1,13122,40778,'listo','2026-02-05 16:26:16'),(291,1,13122,40779,'listo','2026-02-05 16:26:16'),(292,1,13122,40780,'listo','2026-02-05 16:26:16'),(293,1,13122,40781,'listo','2026-02-05 16:26:16'),(294,1,13122,40782,'listo','2026-02-05 16:26:16'),(295,1,13122,40783,'listo','2026-02-05 16:26:16'),(296,1,13123,40784,'listo','2026-02-05 16:26:32'),(297,1,13123,40785,'listo','2026-02-05 16:26:32'),(298,1,13123,40786,'listo','2026-02-05 16:26:32'),(299,1,13123,40787,'listo','2026-02-05 16:26:32'),(300,1,13123,40788,'listo','2026-02-05 16:26:32'),(301,1,13123,40789,'listo','2026-02-05 16:26:32'),(302,1,13123,40790,'listo','2026-02-05 16:26:33'),(303,1,13123,40791,'listo','2026-02-05 16:26:33'),(304,1,13123,40792,'listo','2026-02-05 16:26:33'),(305,1,13123,40793,'listo','2026-02-05 16:26:33'),(306,1,13124,40794,'listo','2026-02-05 16:29:10'),(307,1,13124,40795,'listo','2026-02-05 16:29:10'),(308,1,13124,40796,'listo','2026-02-05 16:29:10'),(309,1,13124,40797,'listo','2026-02-05 16:29:10'),(310,1,13124,40798,'listo','2026-02-05 16:29:10'),(311,1,13124,40799,'listo','2026-02-05 16:29:10'),(312,1,13124,40800,'listo','2026-02-05 16:29:10'),(313,1,13124,40801,'listo','2026-02-05 16:29:10'),(314,1,13124,40802,'listo','2026-02-05 16:29:10'),(315,1,13124,40803,'listo','2026-02-05 16:29:10'),(316,1,13125,40804,'listo','2026-02-05 16:29:25'),(317,1,13125,40805,'listo','2026-02-05 16:29:25'),(318,1,13125,40806,'listo','2026-02-05 16:29:25'),(319,1,13125,40807,'listo','2026-02-05 16:29:25'),(320,1,13125,40808,'listo','2026-02-05 16:29:26'),(321,1,13126,40809,'listo','2026-02-05 16:29:40'),(322,1,13126,40810,'listo','2026-02-05 16:29:40'),(323,1,13126,40811,'listo','2026-02-05 16:29:40'),(324,1,13126,40812,'listo','2026-02-05 16:29:40'),(325,1,13126,40813,'listo','2026-02-05 16:29:40'),(326,1,13126,40814,'listo','2026-02-05 16:29:40'),(327,1,13126,40815,'listo','2026-02-05 16:29:40'),(328,1,13126,40816,'listo','2026-02-05 16:29:40'),(329,1,13126,40817,'listo','2026-02-05 16:29:40'),(330,1,13126,40818,'listo','2026-02-05 16:29:40'),(331,1,13127,40819,'listo','2026-02-05 16:30:00'),(332,1,13127,40820,'listo','2026-02-05 16:30:00'),(333,1,13127,40821,'listo','2026-02-05 16:30:00'),(334,1,13127,40822,'listo','2026-02-05 16:30:01'),(335,1,13127,40823,'listo','2026-02-05 16:30:01'),(336,1,13127,40824,'listo','2026-02-05 16:30:01'),(337,1,13127,40825,'listo','2026-02-05 16:30:01'),(338,1,13127,40826,'listo','2026-02-05 16:30:01'),(339,1,13127,40827,'listo','2026-02-05 16:30:01'),(340,1,13127,40828,'listo','2026-02-05 16:30:01'),(341,1,13127,40829,'listo','2026-02-05 16:30:01'),(342,1,13127,40830,'listo','2026-02-05 16:30:01'),(343,1,13128,40831,'listo','2026-02-05 16:30:18'),(344,1,13128,40832,'listo','2026-02-05 16:30:18'),(345,1,13128,40833,'listo','2026-02-05 16:30:18'),(346,1,13128,40834,'listo','2026-02-05 16:30:18'),(347,1,13128,40835,'listo','2026-02-05 16:30:18'),(348,1,13128,40836,'listo','2026-02-05 16:30:18'),(349,1,13128,40837,'listo','2026-02-05 16:30:18'),(350,1,13128,40838,'listo','2026-02-05 16:30:18'),(351,1,13128,40839,'listo','2026-02-05 16:30:18'),(352,1,13128,40840,'listo','2026-02-05 16:30:19'),(353,1,13128,40841,'listo','2026-02-05 16:30:19'),(354,1,13128,40842,'listo','2026-02-05 16:30:19'),(355,1,13134,40867,'listo','2026-02-05 16:30:54'),(356,1,13134,40868,'listo','2026-02-05 16:30:54'),(357,1,13134,40869,'listo','2026-02-05 16:30:54'),(358,1,13134,40870,'listo','2026-02-05 16:30:55'),(359,1,13135,40871,'listo','2026-02-05 16:31:10'),(360,1,13135,40872,'listo','2026-02-05 16:31:11'),(361,1,13135,40873,'listo','2026-02-05 16:31:11'),(362,1,13135,40874,'listo','2026-02-05 16:31:11'),(363,1,13180,41046,'listo','2026-02-05 16:35:24'),(364,1,13180,41047,'listo','2026-02-05 16:35:25'),(365,1,13180,41048,'listo','2026-02-05 16:35:25'),(366,1,13180,41049,'listo','2026-02-05 16:35:25'),(367,1,13184,41062,'listo','2026-02-05 16:35:56'),(368,1,13184,41063,'listo','2026-02-05 16:35:56'),(369,1,13184,41064,'listo','2026-02-05 16:35:56'),(370,1,13184,41065,'listo','2026-02-05 16:35:56'),(371,1,13183,41058,'listo','2026-02-05 16:36:11'),(372,1,13183,41059,'listo','2026-02-05 16:36:11'),(373,1,13183,41060,'listo','2026-02-05 16:36:11'),(374,1,13183,41061,'listo','2026-02-05 16:36:11'),(375,1,13182,41054,'listo','2026-02-05 16:36:27'),(376,1,13182,41055,'listo','2026-02-05 16:36:27'),(377,1,13182,41056,'listo','2026-02-05 16:36:27'),(378,1,13182,41057,'listo','2026-02-05 16:36:28'),(379,1,13181,41050,'listo','2026-02-05 16:36:47'),(380,1,13181,41051,'listo','2026-02-05 16:36:47'),(381,1,13181,41052,'listo','2026-02-05 16:36:47'),(382,1,13181,41053,'listo','2026-02-05 16:36:47'),(383,1,13176,41030,'listo','2026-02-05 16:37:13'),(384,1,13176,41031,'listo','2026-02-05 16:37:13'),(385,1,13176,41032,'listo','2026-02-05 16:37:13'),(386,1,13176,41033,'listo','2026-02-05 16:37:13'),(387,1,13177,41034,'listo','2026-02-05 16:37:35'),(388,1,13177,41035,'listo','2026-02-05 16:37:35'),(389,1,13177,41036,'listo','2026-02-05 16:37:35'),(390,1,13177,41037,'listo','2026-02-05 16:37:35'),(391,1,13178,41038,'listo','2026-02-05 16:37:46'),(392,1,13178,41039,'listo','2026-02-05 16:37:46'),(393,1,13178,41040,'listo','2026-02-05 16:37:46'),(394,1,13178,41041,'listo','2026-02-05 16:37:46'),(395,1,13179,41042,'listo','2026-02-05 16:37:46'),(396,1,13179,41043,'listo','2026-02-05 16:37:46'),(397,1,13179,41044,'listo','2026-02-05 16:37:46'),(398,1,13179,41045,'listo','2026-02-05 16:37:46'),(399,1,13037,40564,'listo','2026-02-05 17:54:55'),(400,1,12692,39336,'listo','2026-02-05 17:56:11'),(401,1,12692,39337,'listo','2026-02-05 17:56:11'),(402,1,12692,39338,'listo','2026-02-05 17:56:11'),(403,1,12704,39380,'listo','2026-02-05 17:57:40'),(404,1,12251,37495,'listo','2026-02-05 17:59:23'),(405,1,12251,37496,'listo','2026-02-05 17:59:23'),(406,1,12251,37497,'listo','2026-02-05 17:59:23'),(407,1,12251,37498,'listo','2026-02-05 17:59:23'),(408,1,12265,37552,'listo','2026-02-05 18:00:06'),(409,1,12265,37553,'listo','2026-02-05 18:00:07'),(410,1,12265,37554,'listo','2026-02-05 18:00:07'),(411,1,12265,37555,'listo','2026-02-05 18:00:07'),(412,1,12265,37556,'listo','2026-02-05 18:00:07'),(413,1,12767,39876,'archivado','2026-02-05 22:30:59'),(414,1,12767,39877,'archivado','2026-02-05 22:30:59'),(415,1,12767,39878,'archivado','2026-02-05 22:30:59'),(416,1,12767,39879,'archivado','2026-02-05 22:31:00'),(417,1,12767,39880,'archivado','2026-02-05 22:31:00'),(418,1,12767,39881,'archivado','2026-02-05 22:31:00'),(419,1,12767,39882,'archivado','2026-02-05 22:31:00'),(420,1,12767,39883,'archivado','2026-02-05 22:31:00'),(421,1,12767,39884,'archivado','2026-02-05 22:31:00'),(422,1,12767,39885,'archivado','2026-02-05 22:31:00'),(423,1,12767,39886,'archivado','2026-02-05 22:31:00'),(424,1,12767,39887,'archivado','2026-02-05 22:31:00'),(425,1,12767,39888,'archivado','2026-02-05 22:31:00'),(426,1,12767,39889,'archivado','2026-02-05 22:31:00'),(427,1,12767,39890,'archivado','2026-02-05 22:31:00'),(428,1,12803,40071,'archivado','2026-02-05 22:31:07'),(429,1,12803,40072,'archivado','2026-02-05 22:31:07'),(430,1,12803,40073,'archivado','2026-02-05 22:31:07'),(431,1,12803,40074,'archivado','2026-02-05 22:31:07'),(432,1,12803,40075,'archivado','2026-02-05 22:31:07'),(433,1,10219,30006,'listo','2026-02-05 22:31:37'),(434,1,10219,30007,'listo','2026-02-05 22:31:37'),(435,1,10219,30008,'listo','2026-02-05 22:31:37'),(436,1,10219,30009,'listo','2026-02-05 22:31:37'),(437,1,10219,30010,'listo','2026-02-05 22:31:37'),(438,1,10219,30011,'listo','2026-02-05 22:31:37'),(439,1,10219,30012,'listo','2026-02-05 22:31:37'),(440,1,10219,30013,'listo','2026-02-05 22:31:37'),(441,1,10219,30014,'listo','2026-02-05 22:31:37'),(442,1,10219,30015,'listo','2026-02-05 22:31:37'),(443,1,10219,30016,'listo','2026-02-05 22:31:38'),(444,1,10219,30017,'listo','2026-02-05 22:31:38'),(445,1,12800,40056,'archivado','2026-02-05 22:31:48'),(446,1,12800,40057,'archivado','2026-02-05 22:31:48'),(447,1,12800,40058,'archivado','2026-02-05 22:31:48'),(448,1,12800,40059,'archivado','2026-02-05 22:31:48'),(449,1,12800,40060,'archivado','2026-02-05 22:31:48'),(450,1,10202,29913,'archivado','2026-02-05 22:34:41'),(451,1,10202,29914,'archivado','2026-02-05 22:34:41'),(452,1,10202,29915,'archivado','2026-02-05 22:34:41'),(453,1,10202,29916,'archivado','2026-02-05 22:34:41'),(454,1,10202,29917,'archivado','2026-02-05 22:34:42'),(455,1,10201,29905,'archivado','2026-02-05 22:34:50'),(456,1,10201,29906,'archivado','2026-02-05 22:34:50'),(457,1,10201,29907,'archivado','2026-02-05 22:34:51'),(458,1,10201,29908,'archivado','2026-02-05 22:34:51'),(459,1,10201,29909,'archivado','2026-02-05 22:34:51'),(460,1,10201,29910,'archivado','2026-02-05 22:34:51'),(461,1,10201,29911,'archivado','2026-02-05 22:34:51'),(462,1,10201,29912,'archivado','2026-02-05 22:34:51'),(463,1,12802,40066,'archivado','2026-02-05 22:35:06'),(464,1,12802,40067,'archivado','2026-02-05 22:35:06'),(465,1,12802,40068,'archivado','2026-02-05 22:35:06'),(466,1,12802,40069,'archivado','2026-02-05 22:35:06'),(467,1,12802,40070,'archivado','2026-02-05 22:35:06'),(468,1,12804,40076,'archivado','2026-02-05 22:35:32'),(469,1,12804,40077,'archivado','2026-02-05 22:35:32'),(470,1,12804,40078,'archivado','2026-02-05 22:35:32'),(471,1,12804,40079,'archivado','2026-02-05 22:35:32'),(472,1,12804,40080,'archivado','2026-02-05 22:35:32'),(473,1,12801,40061,'archivado','2026-02-05 22:35:45'),(474,1,12801,40062,'archivado','2026-02-05 22:35:45'),(475,1,12801,40063,'archivado','2026-02-05 22:35:45'),(476,1,12801,40064,'archivado','2026-02-05 22:35:45'),(477,1,12801,40065,'archivado','2026-02-05 22:35:45'),(478,1,10213,29955,'archivado','2026-02-05 22:35:52'),(479,1,10213,29956,'archivado','2026-02-05 22:35:53'),(480,1,10213,29957,'archivado','2026-02-05 22:35:53'),(481,1,10213,29958,'archivado','2026-02-05 22:35:53'),(482,1,10213,29959,'archivado','2026-02-05 22:35:53'),(483,1,10213,29960,'archivado','2026-02-05 22:35:53'),(484,1,10213,29961,'archivado','2026-02-05 22:35:53'),(485,1,10213,29962,'archivado','2026-02-05 22:35:53'),(486,1,10213,29963,'archivado','2026-02-05 22:35:53'),(487,1,10213,29964,'archivado','2026-02-05 22:35:53'),(488,1,10213,29965,'archivado','2026-02-05 22:35:53'),(489,1,10213,29966,'archivado','2026-02-05 22:35:53'),(490,1,10211,29946,'archivado','2026-02-05 22:36:03'),(491,1,10211,29947,'archivado','2026-02-05 22:36:03'),(492,1,10211,29948,'archivado','2026-02-05 22:36:03'),(493,1,10211,29949,'archivado','2026-02-05 22:36:03'),(494,1,10211,29950,'archivado','2026-02-05 22:36:03'),(495,1,10211,29951,'archivado','2026-02-05 22:36:03'),(496,1,10206,29933,'archivado','2026-02-05 22:36:41'),(497,1,10206,29934,'archivado','2026-02-05 22:36:41'),(498,1,10206,29935,'archivado','2026-02-05 22:36:41'),(499,1,10206,29936,'archivado','2026-02-05 22:36:41'),(500,1,10206,29937,'archivado','2026-02-05 22:36:41'),(501,1,10205,29928,'archivado','2026-02-05 22:36:46'),(502,1,10205,29929,'archivado','2026-02-05 22:36:46'),(503,1,10205,29930,'archivado','2026-02-05 22:36:46'),(504,1,10205,29931,'archivado','2026-02-05 22:36:46'),(505,1,10205,29932,'archivado','2026-02-05 22:36:46'),(506,1,10203,29918,'archivado','2026-02-05 22:37:06'),(507,1,10203,29919,'archivado','2026-02-05 22:37:06'),(508,1,10203,29920,'archivado','2026-02-05 22:37:06'),(509,1,10203,29921,'archivado','2026-02-05 22:37:06'),(510,1,10203,29922,'archivado','2026-02-05 22:37:06'),(511,1,1163,NULL,'archivado','2026-02-05 22:38:38'),(512,1,10204,29923,'archivado','2026-02-05 22:39:43'),(513,1,10204,29924,'archivado','2026-02-05 22:39:43'),(514,1,10204,29925,'archivado','2026-02-05 22:39:43'),(515,1,10204,29926,'archivado','2026-02-05 22:39:43'),(516,1,10204,29927,'archivado','2026-02-05 22:39:44'),(517,1,10207,29938,'archivado','2026-02-05 22:39:48'),(518,1,10207,29939,'archivado','2026-02-05 22:39:48'),(519,1,10207,29940,'archivado','2026-02-05 22:39:48'),(520,1,10207,29941,'archivado','2026-02-05 22:39:48'),(521,1,10207,29942,'archivado','2026-02-05 22:39:48'),(522,1,10212,29952,'archivado','2026-02-05 22:39:52'),(523,1,10212,29953,'archivado','2026-02-05 22:39:52'),(524,1,10212,29954,'archivado','2026-02-05 22:39:52'),(525,1,12806,40086,'archivado','2026-02-05 22:39:58'),(526,1,12806,40087,'archivado','2026-02-05 22:39:58'),(527,1,12806,40088,'archivado','2026-02-05 22:39:58'),(528,1,12806,40089,'archivado','2026-02-05 22:39:58'),(529,1,12806,40090,'archivado','2026-02-05 22:39:58'),(530,1,5291,10301,'archivado','2026-02-05 22:45:14'),(531,1,5291,10302,'archivado','2026-02-05 22:45:14'),(532,1,5291,10303,'archivado','2026-02-05 22:45:14'),(533,1,5291,10304,'archivado','2026-02-05 22:45:14'),(534,1,12705,39381,'archivado','2026-02-05 22:45:41'),(535,1,12705,39382,'archivado','2026-02-05 22:45:41'),(536,1,12706,39383,'archivado','2026-02-05 22:45:50'),(537,1,12706,39384,'archivado','2026-02-05 22:45:50'),(538,1,12706,39385,'archivado','2026-02-05 22:45:50'),(539,1,12707,39386,'archivado','2026-02-05 22:45:58'),(540,1,12707,39387,'archivado','2026-02-05 22:45:58'),(541,1,12707,39388,'archivado','2026-02-05 22:45:58'),(542,1,11986,36309,'archivado','2026-02-05 22:46:13'),(543,1,11883,36273,'archivado','2026-02-05 22:46:28'),(544,1,7870,21819,'archivado','2026-02-05 22:46:38'),(545,1,7869,21818,'archivado','2026-02-05 22:46:48'),(546,1,7866,21815,'archivado','2026-02-05 22:47:00'),(547,1,10732,32007,'archivado','2026-02-05 22:48:49'),(548,1,10732,32008,'archivado','2026-02-05 22:48:49'),(549,1,10732,32009,'archivado','2026-02-05 22:48:49'),(550,1,10732,32010,'archivado','2026-02-05 22:48:49'),(551,1,10732,32011,'archivado','2026-02-05 22:48:50'),(552,1,10732,32012,'archivado','2026-02-05 22:48:50'),(553,1,7868,21817,'archivado','2026-02-05 22:49:25'),(554,1,7864,21810,'archivado','2026-02-05 22:49:33'),(555,1,7864,21811,'archivado','2026-02-05 22:49:33'),(556,1,7867,21816,'archivado','2026-02-05 22:49:46'),(557,1,7865,21812,'archivado','2026-02-05 22:49:58'),(558,1,7865,21813,'archivado','2026-02-05 22:49:58'),(559,1,7865,21814,'archivado','2026-02-05 22:49:58'),(560,1,11172,32960,'archivado','2026-02-05 22:55:58'),(561,1,11170,32958,'archivado','2026-02-05 22:56:06'),(562,1,9571,26550,'archivado','2026-02-05 22:56:28'),(563,1,9566,26545,'archivado','2026-02-05 22:56:34'),(564,1,6336,16999,'archivado','2026-02-05 23:01:39'),(565,1,6336,17005,'archivado','2026-02-05 23:01:39'),(566,1,6338,17002,'archivado','2026-02-05 23:01:49'),(567,1,11835,36030,'listo','2026-02-07 13:27:34'),(568,1,11835,36031,'listo','2026-02-07 13:27:34'),(569,1,11835,36032,'listo','2026-02-07 13:27:34'),(570,1,11835,36033,'listo','2026-02-07 13:27:34'),(571,1,11764,35637,'listo','2026-02-07 13:29:08'),(572,1,11764,35638,'listo','2026-02-07 13:29:08'),(573,1,11764,35639,'listo','2026-02-07 13:29:08'),(574,1,7403,19424,'listo','2026-02-07 13:30:24'),(575,1,7403,19425,'listo','2026-02-07 13:30:24'),(576,1,7403,19426,'listo','2026-02-07 13:30:24'),(577,1,7403,19427,'listo','2026-02-07 13:30:24'),(578,1,7403,19428,'listo','2026-02-07 13:30:24'),(579,1,7403,19429,'listo','2026-02-07 13:30:24'),(580,1,10112,29088,'listo','2026-02-07 13:33:08'),(581,1,10112,29089,'listo','2026-02-07 13:33:08'),(582,1,10112,29090,'listo','2026-02-07 13:33:08'),(583,1,10112,29091,'listo','2026-02-07 13:33:08'),(584,1,10112,29092,'listo','2026-02-07 13:33:08'),(585,1,10112,29093,'listo','2026-02-07 13:33:08'),(586,1,10112,29094,'listo','2026-02-07 13:33:08'),(587,1,10112,29095,'listo','2026-02-07 13:33:08'),(588,1,10113,29096,'listo','2026-02-07 13:33:25'),(589,1,10113,29097,'listo','2026-02-07 13:33:25'),(590,1,10113,29098,'listo','2026-02-07 13:33:25'),(591,1,10113,29099,'listo','2026-02-07 13:33:25'),(592,1,10113,29100,'listo','2026-02-07 13:33:25'),(593,1,10113,29101,'listo','2026-02-07 13:33:25'),(594,1,10113,29102,'listo','2026-02-07 13:33:25'),(595,1,10113,29103,'listo','2026-02-07 13:33:25'),(596,1,10113,29104,'listo','2026-02-07 13:33:25'),(597,1,10114,29105,'listo','2026-02-07 13:33:43'),(598,1,10114,29106,'listo','2026-02-07 13:33:43'),(599,1,10114,29107,'listo','2026-02-07 13:33:43'),(600,1,10114,29108,'listo','2026-02-07 13:33:43');

--
-- Table structure for table `inv_ciclos`
--

CREATE TABLE `inv_ciclos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) NOT NULL,
  `estado` enum('abierto','en_revision','archivado') NOT NULL DEFAULT 'abierto',
  `creado_por` int(11) NOT NULL,
  `creado_en` datetime NOT NULL,
  `notas` text,
  PRIMARY KEY (`id`),
  KEY `estado` (`estado`),
  KEY `creado_en` (`creado_en`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inv_ciclos`
--

INSERT INTO `inv_ciclos` VALUES (1,'test','abierto',1,'2026-02-04 19:03:20','testtes'),(2,'Invemntario Arreglo','archivado',1,'2026-02-04 22:38:25','');

--
-- Table structure for table `inv_item_notes`
--

CREATE TABLE `inv_item_notes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `note_text` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by_user_id` int(11) DEFAULT NULL,
  `created_by_employee_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_item_created_at` (`item_id`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inv_item_notes`
--


--
-- Table structure for table `inv_movimientos`
--

CREATE TABLE `inv_movimientos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` enum('ASIGNAR','CAPTURAR','ENVIAR_REVISION','ARCHIVAR','RECONTAR') NOT NULL,
  `referencia_id` int(11) DEFAULT NULL,
  `usuario_id` int(11) NOT NULL,
  `fecha` datetime NOT NULL,
  `detalle` text,
  PRIMARY KEY (`id`),
  KEY `tipo` (`tipo`),
  KEY `fecha` (`fecha`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inv_movimientos`
--


--
-- Table structure for table `inv_reconteos`
--

CREATE TABLE `inv_reconteos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ciclo_item_id` int(11) NOT NULL,
  `vitrina_id` int(11) NOT NULL,
  `cantidad` int(11) NOT NULL DEFAULT '0',
  `capturado_por` int(11) NOT NULL,
  `capturado_en` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_reconteo` (`ciclo_item_id`,`vitrina_id`),
  KEY `ciclo_item_id` (`ciclo_item_id`),
  KEY `vitrina_id` (`vitrina_id`)
) ENGINE=InnoDB AUTO_INCREMENT=737 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inv_reconteos`
--

INSERT INTO `inv_reconteos` VALUES (440,74,0,0,2,'2026-02-05 15:23:49'),(441,73,0,0,2,'2026-02-05 15:23:49'),(442,72,0,0,2,'2026-02-05 15:23:50'),(443,71,0,9,2,'2026-02-05 15:23:50'),(444,224,0,1,2,'2026-02-05 15:52:47'),(445,223,0,4,2,'2026-02-05 15:52:47'),(446,222,0,3,2,'2026-02-05 15:52:47'),(447,221,0,2,2,'2026-02-05 15:52:48'),(448,182,0,2,2,'2026-02-05 16:12:51'),(449,181,0,4,2,'2026-02-05 16:12:51'),(450,180,0,4,2,'2026-02-05 16:12:51'),(451,179,0,2,2,'2026-02-05 16:12:52'),(452,178,0,2,2,'2026-02-05 16:20:57'),(453,177,0,3,2,'2026-02-05 16:20:57'),(454,176,0,3,2,'2026-02-05 16:20:57'),(455,175,0,3,2,'2026-02-05 16:20:57'),(456,174,0,1,2,'2026-02-05 16:20:57'),(457,235,0,0,2,'2026-02-05 16:23:16'),(458,234,0,0,2,'2026-02-05 16:23:17'),(459,233,0,0,2,'2026-02-05 16:23:17'),(460,232,0,0,2,'2026-02-05 16:23:17'),(461,231,0,0,2,'2026-02-05 16:23:17'),(462,230,0,0,2,'2026-02-05 16:23:17'),(463,229,0,0,2,'2026-02-05 16:23:17'),(464,186,0,0,5,'2026-02-05 16:29:43'),(465,185,0,2,5,'2026-02-05 16:29:43'),(466,184,0,2,5,'2026-02-05 16:29:43'),(467,183,0,1,5,'2026-02-05 16:29:43'),(468,190,0,0,5,'2026-02-05 16:32:15'),(469,189,0,2,5,'2026-02-05 16:32:15'),(470,188,0,2,5,'2026-02-05 16:32:15'),(471,187,0,1,5,'2026-02-05 16:32:15'),(472,173,0,2,2,'2026-02-05 16:40:45'),(473,172,0,3,2,'2026-02-05 16:40:45'),(474,171,0,3,2,'2026-02-05 16:40:45'),(475,170,0,3,2,'2026-02-05 16:40:45'),(476,169,0,1,2,'2026-02-05 16:40:45'),(477,228,0,1,2,'2026-02-05 16:53:31'),(478,227,0,2,2,'2026-02-05 16:53:31'),(479,226,0,2,2,'2026-02-05 16:53:31'),(480,225,0,1,2,'2026-02-05 16:53:31'),(485,220,0,0,2,'2026-02-05 17:21:05'),(486,219,0,0,2,'2026-02-05 17:21:05'),(487,218,0,1,2,'2026-02-05 17:21:05'),(488,217,0,0,2,'2026-02-05 17:21:05'),(489,216,0,0,2,'2026-02-05 17:21:05'),(490,215,0,0,2,'2026-02-05 17:21:06'),(491,214,0,1,2,'2026-02-05 17:21:06'),(492,213,0,0,2,'2026-02-05 17:21:06'),(493,212,0,1,2,'2026-02-05 17:21:06'),(494,211,0,0,2,'2026-02-05 17:21:06'),(495,210,0,0,2,'2026-02-05 17:21:06'),(496,209,0,0,2,'2026-02-05 17:21:06'),(497,208,0,0,2,'2026-02-05 17:22:24'),(498,207,0,0,2,'2026-02-05 17:22:24'),(499,206,0,0,2,'2026-02-05 17:22:24'),(500,205,0,1,2,'2026-02-05 17:22:24'),(501,204,0,1,2,'2026-02-05 17:22:24'),(502,203,0,0,2,'2026-02-05 17:22:24'),(503,202,0,0,2,'2026-02-05 17:22:24'),(504,201,0,0,2,'2026-02-05 17:22:24'),(505,200,0,0,2,'2026-02-05 17:22:24'),(506,199,0,0,2,'2026-02-05 17:22:25'),(507,198,0,0,2,'2026-02-05 17:22:25'),(508,197,0,0,2,'2026-02-05 17:22:25'),(509,196,0,3,2,'2026-02-05 17:44:23'),(510,195,0,2,2,'2026-02-05 17:44:23'),(511,194,0,4,2,'2026-02-05 17:44:23'),(512,193,0,2,2,'2026-02-05 17:44:23'),(513,192,0,1,2,'2026-02-05 17:44:23'),(514,191,0,4,2,'2026-02-05 17:44:24'),(519,315,0,0,2,'2026-02-06 09:31:09'),(520,314,0,1,2,'2026-02-06 09:31:09'),(521,313,0,2,2,'2026-02-06 09:31:10'),(522,312,0,1,2,'2026-02-06 09:31:10'),(523,311,0,0,2,'2026-02-06 09:31:10'),(524,310,0,1,2,'2026-02-06 09:31:10'),(525,309,0,1,2,'2026-02-06 09:31:10'),(526,308,0,2,2,'2026-02-06 09:31:10'),(527,307,0,0,2,'2026-02-06 09:31:10'),(528,306,0,0,2,'2026-02-06 09:31:10'),(530,304,0,0,2,'2026-02-06 09:38:48'),(531,303,0,1,2,'2026-02-06 09:38:48'),(533,301,0,1,2,'2026-02-06 09:38:49'),(534,300,0,1,2,'2026-02-06 09:38:49'),(535,299,0,1,2,'2026-02-06 09:38:49'),(536,298,0,1,2,'2026-02-06 09:38:49'),(537,297,0,1,2,'2026-02-06 09:38:49'),(538,296,0,2,2,'2026-02-06 09:38:49'),(539,320,0,2,2,'2026-02-06 10:52:45'),(540,319,0,3,2,'2026-02-06 10:52:45'),(541,318,0,0,2,'2026-02-06 10:52:45'),(542,317,0,0,2,'2026-02-06 10:52:45'),(543,316,0,2,2,'2026-02-06 10:52:45'),(544,295,0,0,2,'2026-02-06 11:12:08'),(545,294,0,0,2,'2026-02-06 11:12:08'),(546,293,0,0,2,'2026-02-06 11:12:08'),(547,292,0,1,2,'2026-02-06 11:12:08'),(548,291,0,2,2,'2026-02-06 11:12:09'),(549,290,0,0,2,'2026-02-06 11:12:09'),(550,289,0,1,2,'2026-02-06 11:12:09'),(551,288,0,1,2,'2026-02-06 11:12:09'),(552,287,0,0,2,'2026-02-06 11:12:09'),(553,286,0,1,2,'2026-02-06 11:12:09'),(554,285,0,0,2,'2026-02-06 11:12:09'),(568,272,0,10,5,'2026-02-06 11:46:15'),(569,271,0,7,5,'2026-02-06 11:46:15'),(570,330,0,1,2,'2026-02-06 11:49:41'),(571,329,0,0,2,'2026-02-06 11:49:41'),(572,328,0,0,2,'2026-02-06 11:49:41'),(573,327,0,1,2,'2026-02-06 11:49:41'),(574,326,0,0,2,'2026-02-06 11:49:41'),(575,325,0,0,2,'2026-02-06 11:49:41'),(576,324,0,2,2,'2026-02-06 11:49:41'),(577,323,0,1,2,'2026-02-06 11:49:41'),(578,322,0,1,2,'2026-02-06 11:49:42'),(579,321,0,0,2,'2026-02-06 11:49:42'),(580,270,0,2,5,'2026-02-06 12:30:40'),(581,269,0,6,5,'2026-02-06 12:30:41'),(582,268,0,5,5,'2026-02-06 12:30:41'),(583,267,0,2,5,'2026-02-06 12:30:41'),(584,266,0,22,5,'2026-02-06 12:53:14'),(585,265,0,17,5,'2026-02-06 12:53:14'),(586,264,0,21,5,'2026-02-06 12:53:15'),(587,263,0,21,5,'2026-02-06 12:53:15'),(588,354,0,1,2,'2026-02-06 13:40:13'),(589,353,0,1,2,'2026-02-06 13:40:13'),(590,352,0,1,2,'2026-02-06 13:40:13'),(591,351,0,0,2,'2026-02-06 13:40:13'),(592,350,0,1,2,'2026-02-06 13:40:13'),(593,349,0,0,2,'2026-02-06 13:40:13'),(594,348,0,1,2,'2026-02-06 13:40:13'),(595,347,0,1,2,'2026-02-06 13:40:13'),(596,346,0,1,2,'2026-02-06 13:40:13'),(597,345,0,1,2,'2026-02-06 13:40:14'),(598,344,0,0,2,'2026-02-06 13:40:14'),(599,343,0,1,2,'2026-02-06 13:40:14'),(604,370,0,1,5,'2026-02-06 15:15:41'),(605,369,0,2,5,'2026-02-06 15:15:41'),(606,368,0,2,5,'2026-02-06 15:15:41'),(607,367,0,1,5,'2026-02-06 15:15:42'),(608,390,0,1,5,'2026-02-06 15:22:13'),(609,389,0,2,5,'2026-02-06 15:22:14'),(610,388,0,2,5,'2026-02-06 15:22:14'),(611,387,0,1,5,'2026-02-06 15:22:14'),(612,398,0,1,5,'2026-02-06 15:30:43'),(613,397,0,2,5,'2026-02-06 15:30:43'),(614,396,0,2,5,'2026-02-06 15:30:43'),(615,395,0,1,5,'2026-02-06 15:30:43'),(616,378,0,0,5,'2026-02-06 15:46:18'),(617,377,0,2,5,'2026-02-06 15:46:19'),(618,376,0,2,5,'2026-02-06 15:46:19'),(619,375,0,0,5,'2026-02-06 15:46:19'),(620,374,0,1,5,'2026-02-06 15:51:26'),(621,373,0,2,5,'2026-02-06 15:51:26'),(622,372,0,2,5,'2026-02-06 15:51:26'),(623,371,0,0,5,'2026-02-06 15:51:26'),(624,394,0,0,5,'2026-02-06 15:54:25'),(625,393,0,2,5,'2026-02-06 15:54:25'),(626,392,0,2,5,'2026-02-06 15:54:25'),(627,391,0,0,5,'2026-02-06 15:54:25'),(628,366,0,2,5,'2026-02-06 16:28:51'),(629,365,0,3,5,'2026-02-06 16:28:51'),(630,364,0,4,5,'2026-02-06 16:28:51'),(631,363,0,1,5,'2026-02-06 16:28:51'),(632,386,0,1,5,'2026-02-06 16:32:51'),(633,385,0,0,5,'2026-02-06 16:32:51'),(634,384,0,1,5,'2026-02-06 16:32:51'),(635,383,0,0,5,'2026-02-06 16:32:51'),(636,382,0,0,5,'2026-02-06 16:35:10'),(637,381,0,2,5,'2026-02-06 16:35:10'),(638,380,0,2,5,'2026-02-06 16:35:10'),(639,379,0,1,5,'2026-02-06 16:35:10'),(640,358,0,1,2,'2026-02-06 16:38:10'),(641,357,0,4,2,'2026-02-06 16:38:10'),(642,356,0,1,2,'2026-02-06 16:38:10'),(643,355,0,1,2,'2026-02-06 16:38:10'),(644,342,0,1,2,'2026-02-06 16:41:43'),(645,341,0,1,2,'2026-02-06 16:41:43'),(646,340,0,1,2,'2026-02-06 16:41:43'),(647,339,0,1,2,'2026-02-06 16:41:43'),(648,338,0,1,2,'2026-02-06 16:41:43'),(649,337,0,1,2,'2026-02-06 16:41:44'),(650,336,0,1,2,'2026-02-06 16:41:44'),(651,335,0,0,2,'2026-02-06 16:41:44'),(652,334,0,0,2,'2026-02-06 16:41:44'),(653,333,0,0,2,'2026-02-06 16:41:44'),(654,332,0,1,2,'2026-02-06 16:41:44'),(655,331,0,0,2,'2026-02-06 16:41:44'),(656,444,0,0,5,'2026-02-06 16:53:02'),(657,443,0,1,5,'2026-02-06 16:53:02'),(658,442,0,0,5,'2026-02-06 16:53:02'),(659,441,0,0,5,'2026-02-06 16:53:03'),(660,440,0,0,5,'2026-02-06 16:53:03'),(661,439,0,0,5,'2026-02-06 16:53:03'),(662,438,0,2,5,'2026-02-06 16:53:03'),(663,437,0,1,5,'2026-02-06 16:53:03'),(664,436,0,0,5,'2026-02-06 16:53:03'),(665,435,0,0,5,'2026-02-06 16:53:03'),(666,434,0,0,5,'2026-02-06 16:53:03'),(667,433,0,1,5,'2026-02-06 16:53:03'),(668,284,0,3,2,'2026-02-06 17:17:21'),(669,283,0,3,2,'2026-02-06 17:17:22'),(670,282,0,1,2,'2026-02-06 17:17:22'),(671,281,0,3,2,'2026-02-06 17:17:22'),(672,280,0,1,2,'2026-02-06 17:17:22'),(673,412,0,0,5,'2026-02-06 17:40:51'),(674,411,0,0,5,'2026-02-06 17:40:51'),(675,410,0,0,5,'2026-02-06 17:40:51'),(676,409,0,0,5,'2026-02-06 17:40:51'),(677,408,0,0,5,'2026-02-06 17:40:51'),(678,305,0,0,2,'2026-02-06 17:40:51'),(679,302,0,1,2,'2026-02-06 17:40:52'),(680,279,0,2,2,'2026-02-07 11:33:21'),(681,278,0,1,2,'2026-02-07 11:33:21'),(682,277,0,2,2,'2026-02-07 11:33:21'),(683,276,0,3,2,'2026-02-07 11:33:21'),(684,275,0,3,2,'2026-02-07 11:33:21'),(685,274,0,2,2,'2026-02-07 11:33:21'),(686,273,0,1,2,'2026-02-07 11:33:21'),(687,407,0,0,5,'2026-02-07 12:09:27'),(688,406,0,0,5,'2026-02-07 12:09:27'),(689,405,0,0,5,'2026-02-07 12:09:27'),(690,404,0,1,5,'2026-02-07 12:09:27'),(691,399,0,0,2,'2026-02-07 12:25:25'),(692,402,0,0,2,'2026-02-07 13:23:15'),(693,401,0,0,2,'2026-02-07 13:23:15'),(694,400,0,0,2,'2026-02-07 13:23:15'),(695,570,0,1,5,'2026-02-07 14:15:53'),(696,569,0,1,5,'2026-02-07 14:15:53'),(697,568,0,1,5,'2026-02-07 14:15:53'),(698,567,0,1,5,'2026-02-07 14:15:53'),(699,403,0,2,5,'2026-02-07 14:22:38'),(700,261,0,0,5,'2026-02-07 14:23:29'),(701,262,0,0,5,'2026-02-07 14:23:38'),(702,260,0,0,5,'2026-02-07 14:23:50'),(703,362,0,4,2,'2026-02-07 14:41:36'),(704,361,0,8,2,'2026-02-07 14:41:36'),(705,360,0,3,2,'2026-02-07 14:41:36'),(706,359,0,1,2,'2026-02-07 14:41:36'),(708,586,0,1,2,'2026-02-07 15:12:40'),(709,585,0,0,2,'2026-02-07 15:12:40'),(710,584,0,1,2,'2026-02-07 15:12:40'),(711,583,0,2,2,'2026-02-07 15:12:40'),(712,582,0,1,2,'2026-02-07 15:12:40'),(713,581,0,1,2,'2026-02-07 15:12:40'),(714,580,0,1,2,'2026-02-07 15:12:41'),(715,600,0,1,2,'2026-02-07 15:13:23'),(716,599,0,1,2,'2026-02-07 15:13:23'),(717,598,0,0,2,'2026-02-07 15:13:23'),(718,597,0,0,2,'2026-02-07 15:13:23'),(719,596,0,0,2,'2026-02-07 15:37:52'),(720,595,0,1,2,'2026-02-07 15:37:53'),(721,594,0,1,2,'2026-02-07 15:37:53'),(722,593,0,0,2,'2026-02-07 15:37:53'),(723,592,0,0,2,'2026-02-07 15:37:53'),(724,591,0,2,2,'2026-02-07 15:37:53'),(725,590,0,1,2,'2026-02-07 15:37:53'),(726,589,0,1,2,'2026-02-07 15:37:53'),(727,588,0,0,2,'2026-02-07 15:37:53'),(728,579,0,0,2,'2026-02-07 15:40:50'),(729,578,0,0,2,'2026-02-07 15:40:50'),(730,577,0,0,2,'2026-02-07 15:40:50'),(731,576,0,0,2,'2026-02-07 15:40:50'),(732,575,0,0,2,'2026-02-07 15:40:50'),(733,574,0,0,2,'2026-02-07 15:40:51'),(734,573,0,3,5,'2026-02-07 16:20:55'),(735,572,0,5,5,'2026-02-07 16:20:56'),(736,571,0,2,5,'2026-02-07 16:20:56');

--
-- Table structure for table `inv_unlock_requests`
--

CREATE TABLE `inv_unlock_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `ciclo_id` int(11) NOT NULL DEFAULT '1',
  `requested_by_user_id` int(11) DEFAULT NULL,
  `requested_by_employee_id` int(11) DEFAULT NULL,
  `status` enum('pending','approved','rejected','cancelled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `resolved_at` timestamp NULL DEFAULT NULL,
  `resolved_by_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_pending_request` (`item_id`,`status`,`requested_by_user_id`,`requested_by_employee_id`),
  KEY `idx_item_status` (`item_id`,`status`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_ciclo_status` (`ciclo_id`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inv_unlock_requests`
--


--
-- Table structure for table `inv_users`
--

CREATE TABLE `inv_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` varchar(100) NOT NULL,
  `clave_hash` varchar(255) NOT NULL,
  `rol` enum('admin','monitor','empleado') NOT NULL DEFAULT 'empleado',
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `creado_en` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `usuario` (`usuario`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inv_users`
--

INSERT INTO `inv_users` VALUES (1,'admin','$2y$10$KoBVR9okTF7WsxBYih5/D..r3AeLi2V9zcDQsFxO/79L6JHG2ieJ.','admin',1,'2026-02-04 17:50:24'),(2,'ilde','$2y$10$8cO2VJ6oL.Hg4rVdQ.1gquhC6OR9XDklfX0ihhOQhl3Qd9i7d2vSy','monitor',1,'2026-02-04 19:06:03'),(3,'mery','$2y$10$pvfcLdRF7KKMOhpFuFW5eu3pMw0lVZ3y9JB6OM0bIMLN/dKJbzr26','empleado',1,'2026-02-04 19:06:10'),(4,'juan','$2y$10$wNWpC8QMbDB3nF5oAq2RRuXsBMvjLxxwDtE8oRwyUAtKnuKqGQTB2','empleado',0,'2026-02-04 19:06:26'),(5,'yuly','$2y$10$LTRuQ2pHhi3LgakChQZhsuIIeN7D0yrp4/rb0pvBrJTFI9GmmGzGy','monitor',1,'2026-02-04 23:06:27'),(6,'gley','$2y$10$JAe3uUk8zM6t/ImVNAVNteQM9gZIMg4KfXD8X00WEEMtC6lzlyyVy','empleado',1,'2026-02-04 23:06:40'),(7,'sarah','$2y$10$F9zvIOR/rIVzBKQB6Amdz.sGk.j2uHDMFeV/kVuwUpuJAqZuONpRK','empleado',1,'2026-02-04 23:06:52'),(8,'keiber','$2y$10$9fRr4Gh1IvXSJ70qvsfeHeGV5YKMQLPOVh.ropTUHxtOA6BkXzLki','empleado',1,'2026-02-04 23:07:01'),(9,'angeles','$2y$10$PBDwf2Gg.IkDOCoCWtuVCO1nx6Mh1RXCJp7rV28W8xuts3Rmwb7qW','empleado',1,'2026-02-04 23:07:29'),(10,'frank','$2y$10$N.sUdf0NiQXRj4ERSgAp/OlodYizFby5PXqiQjeqwIGTuWl2z5eVq','empleado',1,'2026-02-04 23:07:46'),(11,'buceina','$2y$10$SrtI.9b0PMogcFd89c77M.6eL2lGLQ8TnLEbtfD.7Qm3ZsCMidvVe','empleado',0,'2026-02-04 23:07:56'),(13,'buc','$2y$10$xjO3lav3ljx6i8BZTFAaW.HpvxStdN9BHOvFWEAzImyXv2cn2bxV6','admin',1,'2026-02-04 23:08:21'),(14,'osmer','$2y$10$ZS7J/oodd6bxVrho1K2V.ucKT/0k8BejWwkJq0HtM.JT/HYAELbo.','empleado',1,'2026-02-05 16:10:28');

--
-- Dumping events for database 'inv2'
--

--
-- Dumping routines for database 'inv2'
--


