-- MySQL dump 10.13 Distrib 8.0.46, for Linux (x86_64)
--
-- Host: localhost Database: acai_stock
-- ------------------------------------------------------
-- Server version 8.0.46-0ubuntu0.22.04.3
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `admin_users`
--
DROP TABLE IF EXISTS `admin_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_users` (
`id` int NOT NULL AUTO_INCREMENT,
`usuario` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`password_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`nombre` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`rol` enum('admin','socio') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin',
`activo` tinyint(1) DEFAULT '1',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`last_login` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `usuario` (`usuario`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `admin_users`
--
LOCK TABLES `admin_users` WRITE;
/*!40000 ALTER TABLE `admin_users` DISABLE KEYS */;
INSERT INTO `admin_users` VALUES (1,'admin','$2y$10$TUN3Grczk6BYFRFxJXjlbuiHpONIkN/pkMQzAo1RfiKKEULfY8HGC','Alejandro','admin',1,'2026-04-30 14:28:44','2026-07-14 18:12:30'),(2,'SOCIO','$2y$10$Xyy4JLTBugahA9QzY2Nm1eDa/7NQfG2uyQJrmDGf9RgS4R5/ya7jO','Socio','socio',1,'2026-04-30 15:14:15','2026-05-01 12:52:22');
/*!40000 ALTER TABLE `admin_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `categorias`
--
DROP TABLE IF EXISTS `categorias`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `categorias` (
`id` int NOT NULL AUTO_INCREMENT,
`nombre` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`emoji` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 0xF09F93A6,
`orden` int DEFAULT '0',
`activo` tinyint(1) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `categorias`
--
LOCK TABLES `categorias` WRITE;
/*!40000 ALTER TABLE `categorias` DISABLE KEYS */;
INSERT INTO `categorias` VALUES (1,'AÇAÍ y CREMAS','🥣',1,1),(2,'INSUMOS','📦',2,1);
/*!40000 ALTER TABLE `categorias` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `items`
--
DROP TABLE IF EXISTS `items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `items` (
`id` int NOT NULL AUTO_INCREMENT,
`categoria_id` int NOT NULL,
`nombre` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`emoji` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT '',
`unidad_medida` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unidad',
`umbral_amarillo` int NOT NULL DEFAULT '5',
`umbral_rojo` int NOT NULL DEFAULT '2',
`incluir_reporte` tinyint(1) NOT NULL DEFAULT '1',
`orden` int DEFAULT '0',
`activo` tinyint(1) DEFAULT '1',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `categoria_id` (`categoria_id`),
CONSTRAINT `items_ibfk_1` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `items`
--
LOCK TABLES `items` WRITE;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
INSERT INTO `items` VALUES (1,1,'Açaí','🍇','Pote',40,20,1,1,1,'2026-04-30 14:28:44'),(2,1,'Açaí Zero','🍇','Pote',3,2,1,2,1,'2026-04-30 14:28:44'),(3,1,'Coco','🥥','Balde',5,3,1,3,1,'2026-04-30 14:28:44'),(4,1,'Agua de coco','🥥','Balde',5,3,1,4,1,'2026-04-30 14:28:44'),(5,1,'Maracuyá','🍋','Pote',10,5,1,5,1,'2026-04-30 14:28:44'),(6,1,'Nido','🥛','Balde',10,6,1,6,1,'2026-04-30 14:28:44'),(7,1,'Paçoca','🥜','Balde',3,2,1,7,1,'2026-04-30 14:28:44'),(8,1,'Pistacho','🌰','Balde',3,2,1,8,1,'2026-04-30 14:28:44'),(9,1,'Frutilla','🍓','Balde',10,5,1,9,1,'2026-04-30 14:28:44'),(10,1,'Mango','🥭','Balde',5,3,1,10,1,'2026-04-30 14:28:44'),(11,1,'Cupuaçu','🥥','Balde',5,3,1,11,1,'2026-04-30 14:28:44'),(12,1,'Tapioca','🌾','Balde',3,2,1,12,1,'2026-04-30 14:28:44'),(13,2,'Hielo','🧊','Bolsa',20,10,1,13,1,'2026-04-30 14:28:44'),(14,2,'Vaso PP 300 ml','🥤','Caja x 1000 unid',5,2,1,1,1,'2026-04-30 14:28:44'),(15,2,'Vaso PP 400 ml','🥤','Caja x 1000 unid',5,2,1,2,1,'2026-04-30 14:28:44'),(16,2,'Vaso PP 500 ml','🥤','Caja x 1000 unid',5,2,1,3,1,'2026-04-30 14:28:44'),(17,2,'Vaso PP 700 ml','🥤','Caja x 500 unid',5,2,1,4,1,'2026-04-30 14:28:44'),(18,2,'Vaso Paperfood 1000 ml','🥡','Caja x 300 unid',5,2,1,5,1,'2026-04-30 14:28:44'),(19,2,'Vaso Paperfood 750 ml','🥡','Caja x 300 unid',5,2,1,6,1,'2026-04-30 14:28:44'),(20,2,'Tapa Paperfood 750 ml','🔘','Caja x 300 unid',5,2,1,7,1,'2026-04-30 14:28:44'),(21,2,'Guantes transparentes','🧤','Caja x 100 unid',5,2,1,8,1,'2026-04-30 14:28:44'),(22,2,'Cuchara postre blanca','🥄','Caja x 1000 unid',5,2,1,9,1,'2026-04-30 14:28:44'),(23,2,'Cuchara sundae negra','🥄','Caja x 1000 unid',5,2,1,10,1,'2026-04-30 14:28:44'),(24,2,'Tapa ovalada','⭕','Caja x 1000 unid',5,2,1,11,1,'2026-04-30 14:28:44'),(25,2,'Tapa recta 550cc','⬜','Caja x 1000 unid',5,2,1,12,1,'2026-04-30 14:28:44'),(26,2,'Tapa recta 300cc','⬜','Caja x 1000 unid',5,2,1,13,1,'2026-04-30 14:28:44'),(27,2,'Cuchara ACAI fucsia c/logo','🥄','Caja x 500 unid',100,50,1,14,1,'2026-04-30 14:58:06'),(28,1,'Pitaya','🐲','Pote',10,5,1,13,1,'2026-06-12 17:41:47'),(29,2,'Rollos de papel termico para comanderas (80 mm)','🧻','unid',10,5,0,15,1,'2026-06-12 17:43:31'),(30,2,'Rollo de papel termico para Posnet','🧻','unid',10,5,0,16,1,'2026-06-12 17:46:07'),(31,2,'Bolsa para residuos - 60x90 cm','🚮','Paq x 10 unid',10,5,0,17,1,'2026-06-12 17:51:34'),(32,2,'Bolsa para residuos - 80x110 cm','🚮','Paq x 10 unid',10,5,0,18,1,'2026-06-12 17:51:50'),(33,2,'Bolsa para residuos - 90x120 cm','🚮','Paq x 10 unid',10,5,0,19,1,'2026-06-12 17:52:07'),(34,2,'Bolsa eCommerce chica','💸','unid',100,50,0,20,1,'2026-06-12 17:54:00'),(35,2,'Servilletas 24x24 cm','🧻','Caja',10,5,0,21,1,'2026-06-12 18:40:16'),(36,2,'Vaso DARNEL 266 ml','🥛','Caja x 300 unid',5,2,1,22,1,'2026-06-26 12:52:04'),(37,2,'Tapa vaso DARNEL 266 ml','🥛','Caja x 600 unid',5,2,1,23,1,'2026-06-26 12:52:39');
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `log_movimientos`
--
DROP TABLE IF EXISTS `log_movimientos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_movimientos` (
`id` int NOT NULL AUTO_INCREMENT,
`tipo` enum('login_admin','login_sucursal','login_fail','stock_update','pedido_enviado','item_create','item_edit','item_delete') COLLATE utf8mb4_unicode_ci NOT NULL,
`actor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`detalle` text COLLATE utf8mb4_unicode_ci,
`ip` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fecha` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_tipo` (`tipo`),
KEY `idx_fecha` (`fecha`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `log_movimientos`
--
LOCK TABLES `log_movimientos` WRITE;
/*!40000 ALTER TABLE `log_movimientos` DISABLE KEYS */;
INSERT INTO `log_movimientos` VALUES (1,'login_admin','admin','Login exitoso','148.227.74.199','2026-04-30 11:56:29'),(2,'item_create','admin','Item \'Cuchara ACAI fucsia c/logo\' (id 27)','148.227.74.199','2026-04-30 11:58:06'),(3,'stock_update','admin','item_id=27 cantidad=526','148.227.74.199','2026-04-30 12:08:04'),(4,'login_admin','SOCIO','Login exitoso','148.227.74.199','2026-04-30 12:17:20'),(5,'login_admin','SOCIO','Login socio exitoso','148.227.74.199','2026-04-30 12:22:31'),(6,'login_admin','SOCIO','Login socio exitoso','148.227.74.199','2026-04-30 12:25:45'),(7,'login_admin','SOCIO','Login socio exitoso','148.227.74.199','2026-04-30 12:26:10'),(8,'login_admin','SOCIO','Login socio exitoso','148.227.74.199','2026-04-30 12:32:50'),(9,'login_admin','SOCIO','Login socio exitoso','148.227.74.199','2026-04-30 12:34:26'),(10,'login_admin','admin','Login exitoso','148.227.74.199','2026-04-30 12:37:36'),(11,'login_admin','admin','Login exitoso','148.227.74.199','2026-04-30 12:41:08'),(12,'item_edit','admin','Item id 1 editado','148.227.74.199','2026-04-30 12:41:18'),(13,'item_edit','admin','Item id 2 editado','148.227.74.199','2026-04-30 12:41:23'),(14,'item_edit','admin','Item id 4 editado','148.227.74.199','2026-04-30 12:41:29'),(15,'item_edit','admin','Item id 3 editado','148.227.74.199','2026-04-30 12:41:36'),(16,'item_edit','admin','Item id 11 editado','148.227.74.199','2026-04-30 12:41:42'),(17,'item_edit','admin','Item id 9 editado','148.227.74.199','2026-04-30 12:41:46'),(18,'item_edit','admin','Item id 13 editado','148.227.74.199','2026-04-30 12:42:11'),(19,'item_edit','admin','Item id 18 editado','148.227.74.199','2026-04-30 12:42:39'),(20,'item_edit','admin','Item id 19 editado','148.227.74.199','2026-04-30 12:42:47'),(21,'item_edit','admin','Item id 10 editado','148.227.74.199','2026-04-30 12:42:53'),(22,'item_edit','admin','Item id 6 editado','148.227.74.199','2026-04-30 12:43:05'),(23,'item_edit','admin','Item id 7 editado','148.227.74.199','2026-04-30 12:43:12'),(24,'item_edit','admin','Item id 8 editado','148.227.74.199','2026-04-30 12:43:18'),(25,'item_edit','admin','Item id 12 editado','148.227.74.199','2026-04-30 12:43:26'),(26,'login_sucursal','ACAI Infinito','Login exitoso','148.227.74.199','2026-04-30 13:47:58'),(27,'pedido_enviado','ACAI Infinito','Pedido #00001 con 8 items','148.227.74.199','2026-04-30 13:48:49'),(28,'login_sucursal','ACAI Infinito','Login exitoso','148.227.74.199','2026-04-30 14:00:09'),(29,'login_sucursal','ACAI Infinito','Login exitoso','148.227.74.199','2026-04-30 17:12:35'),(30,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','148.227.74.199','2026-04-30 17:13:11'),(31,'login_admin','admin','Login exitoso','148.227.74.199','2026-04-30 19:57:17'),(32,'login_sucursal','ACAI Infinito','Login exitoso','186.122.224.5','2026-05-01 12:46:49'),(33,'login_admin','SOCIO','Login socio exitoso','186.122.224.5','2026-05-01 12:49:43'),(34,'login_fail','sucursal','Login sucursal fallido','104.28.59.13','2026-05-01 12:52:03'),(35,'login_fail','sucursal','Login sucursal fallido','104.28.59.13','2026-05-01 12:52:12'),(36,'login_admin','SOCIO','Login socio exitoso','104.28.59.13','2026-05-01 12:52:22'),(37,'login_sucursal','ACAI Infinito','Login exitoso','186.122.224.5','2026-05-01 12:52:39'),(38,'login_fail','sucursal','Login sucursal fallido','181.92.83.232','2026-05-07 19:16:01'),(39,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.92.83.232','2026-05-07 19:16:16'),(40,'login_fail','sucursal','Login sucursal fallido','186.122.88.30','2026-05-07 19:31:23'),(41,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','186.122.88.30','2026-05-07 19:31:36'),(42,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','74.244.135.110','2026-05-08 02:22:25'),(43,'login_fail','sucursal','Login sucursal fallido','181.92.83.232','2026-05-08 02:52:16'),(44,'login_fail','sucursal','Login sucursal fallido','181.92.83.232','2026-05-08 02:52:22'),(45,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.92.83.232','2026-05-08 02:52:33'),(46,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.95.38.242','2026-05-08 03:06:07'),(47,'login_fail','sucursal','Login sucursal fallido','74.244.135.110','2026-05-08 03:12:13'),(48,'login_fail','sucursal','Login sucursal fallido','74.244.135.110','2026-05-08 03:12:23'),(49,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','74.244.135.110','2026-05-08 03:13:09'),(50,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00001 con 6 items','74.244.135.110','2026-05-08 03:29:35'),(51,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.95.38.242','2026-05-08 03:31:53'),(52,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.95.38.242','2026-05-08 10:27:03'),(53,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.95.38.242','2026-05-08 10:27:04'),(54,'login_admin','admin','Login exitoso','148.222.222.207','2026-05-08 13:05:33'),(55,'login_fail','admin','Login admin fallido','148.222.222.207','2026-05-08 20:02:18'),(56,'login_admin','admin','Login exitoso','148.222.222.207','2026-05-08 20:02:51'),(57,'stock_update','admin','BULK update 26 items','148.222.222.207','2026-05-08 20:03:44'),(58,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','153.67.15.248','2026-05-09 03:37:53'),(59,'login_fail','sucursal','Login sucursal fallido','181.92.83.232','2026-05-13 20:29:45'),(60,'login_fail','sucursal','Login sucursal fallido','181.92.83.232','2026-05-13 20:30:41'),(61,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','186.157.62.30','2026-05-15 01:21:03'),(62,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00002 con 8 items','186.157.62.30','2026-05-15 01:35:29'),(63,'login_admin','admin','Login exitoso','153.67.15.211','2026-05-15 19:06:57'),(64,'login_admin','admin','Login exitoso','153.67.15.211','2026-05-15 19:30:40'),(65,'stock_update','admin','BULK update 26 items','153.67.15.211','2026-05-15 19:31:15'),(66,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','148.222.223.101','2026-05-22 15:04:15'),(67,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00003 con 8 items','148.222.223.101','2026-05-22 15:07:58'),(68,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','148.222.223.101','2026-05-22 17:02:43'),(69,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.106.123.87','2026-05-28 18:43:37'),(70,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','74.244.135.241','2026-05-29 13:38:10'),(71,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00004 con 4 items','74.244.135.241','2026-05-29 13:39:30'),(72,'login_admin','admin','Login exitoso','148.227.74.91','2026-05-29 16:07:19'),(73,'item_edit','admin','Item id 22 editado','148.227.74.91','2026-05-29 16:07:55'),(74,'item_edit','admin','Item id 23 editado','148.227.74.91','2026-05-29 16:08:02'),(75,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','190.31.165.244','2026-05-29 16:23:41'),(76,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','186.141.225.142','2026-06-05 01:30:45'),(77,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','186.141.225.142','2026-06-05 01:43:47'),(78,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00005 con 7 items','186.141.225.142','2026-06-05 01:46:53'),(79,'login_admin','admin','Login exitoso','148.222.194.66','2026-06-05 16:19:26'),(80,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','148.222.194.177','2026-06-05 17:19:45'),(81,'login_admin','admin','Login exitoso','181.9.227.215','2026-06-09 20:24:35'),(82,'login_fail','sucursal','Login sucursal fallido','186.143.198.18','2026-06-09 20:28:20'),(83,'login_sucursal','Açaí Shell Select','Login exitoso','186.143.198.18','2026-06-09 20:28:31'),(84,'pedido_enviado','Açaí Shell Select','Pedido #00006 con 1 items','186.143.198.18','2026-06-09 20:29:58'),(85,'login_fail','sucursal','Login sucursal fallido','186.157.76.170','2026-06-10 23:01:55'),(86,'login_fail','sucursal','Login sucursal fallido','186.157.76.170','2026-06-10 23:02:14'),(87,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','186.157.76.170','2026-06-10 23:02:51'),(88,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00007 con 5 items','186.157.76.170','2026-06-10 23:08:21'),(89,'login_admin','admin','Login exitoso','153.67.13.48','2026-06-11 11:34:10'),(90,'login_sucursal','ACAI Shell Select','Login exitoso','148.222.222.101','2026-06-12 03:05:57'),(91,'pedido_enviado','ACAI Shell Select','Pedido #00008 con 8 items','148.222.222.101','2026-06-12 03:19:10'),(92,'login_sucursal','ACAI Shell Select','Login exitoso','186.141.229.140','2026-06-12 17:00:35'),(93,'login_admin','admin','Login exitoso','148.227.69.159','2026-06-12 17:20:16'),(94,'stock_update','admin','BULK update 26 items','148.227.69.159','2026-06-12 17:21:14'),(95,'item_create','admin','Item \'Pitaya\' (id 28)','148.227.69.159','2026-06-12 17:41:47'),(96,'item_create','admin','Item \'Rollos de papel termico para comanderas (80 mm)\' (id 29)','148.227.69.159','2026-06-12 17:43:31'),(97,'item_create','admin','Item \'Rollo de papel termico para Posnet\' (id 30)','148.227.69.159','2026-06-12 17:46:07'),(98,'item_create','admin','Item \'Bolsa para residuos - 60x90 cm\' (id 31)','148.227.69.159','2026-06-12 17:51:34'),(99,'item_create','admin','Item \'Bolsa para residuos - 80x110 cm\' (id 32)','148.227.69.159','2026-06-12 17:51:50'),(100,'item_create','admin','Item \'Bolsa para residuos - 90x120 cm\' (id 33)','148.227.69.159','2026-06-12 17:52:07'),(101,'item_create','admin','Item \'Bolsa eCommerce chica\' (id 34)','148.227.69.159','2026-06-12 17:54:00'),(102,'login_admin','admin','Login exitoso','148.227.69.159','2026-06-12 18:39:57'),(103,'item_create','admin','Item \'Servilletas 24x24 cm\' (id 35)','148.227.69.159','2026-06-12 18:40:16'),(104,'login_sucursal','ACAI Shell Select','Login exitoso','186.143.133.187','2026-06-18 21:15:16'),(105,'pedido_enviado','ACAI Shell Select','Pedido #00009 con 10 items','186.143.133.187','2026-06-18 21:18:59'),(106,'login_fail','sucursal','Login sucursal fallido','181.95.32.164','2026-06-19 01:03:14'),(107,'login_fail','sucursal','Login sucursal fallido','181.95.32.164','2026-06-19 01:03:31'),(108,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.95.32.164','2026-06-19 01:03:56'),(109,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.95.32.164','2026-06-19 03:25:53'),(110,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00010 con 11 items','181.95.32.164','2026-06-19 03:30:06'),(111,'login_admin','admin','Login exitoso','153.67.181.56','2026-06-19 12:38:57'),(112,'login_admin','admin','Login exitoso','153.67.181.56','2026-06-19 13:16:30'),(113,'login_admin','admin','Login exitoso','153.67.181.56','2026-06-19 14:33:40'),(114,'item_edit','admin','Item id 28 editado','153.67.181.56','2026-06-19 14:33:53'),(115,'login_admin','admin','Login exitoso','153.67.181.56','2026-06-19 14:39:16'),(116,'item_edit','admin','Item id 28 editado','153.67.181.56','2026-06-19 14:39:32'),(117,'login_admin','admin','Login exitoso','153.67.181.56','2026-06-19 14:40:32'),(118,'login_sucursal','ACAI Shell Select','Login exitoso','186.141.204.134','2026-06-22 01:44:20'),(119,'pedido_enviado','ACAI Shell Select','Pedido #00011 con 7 items','186.141.204.134','2026-06-22 01:58:08'),(120,'login_fail','sucursal','Login sucursal fallido','181.85.184.151','2026-06-26 02:39:44'),(121,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.85.184.151','2026-06-26 02:39:53'),(122,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00012 con 1 items','181.85.184.151','2026-06-26 02:48:00'),(123,'login_admin','admin','Login exitoso','148.227.69.86','2026-06-26 12:01:52'),(124,'login_admin','admin','Login exitoso','148.227.69.86','2026-06-26 12:51:47'),(125,'item_create','admin','Item \'Vaso DARNEL 266 ml\' (id 36)','148.227.69.86','2026-06-26 12:52:04'),(126,'item_create','admin','Item \'Tapa vaso DARNEL 266 ml\' (id 37)','148.227.69.86','2026-06-26 12:52:39'),(127,'stock_update','admin','BULK update 29 items','148.227.69.86','2026-06-26 13:36:28'),(128,'login_admin','admin','Login exitoso','148.227.69.86','2026-06-26 13:57:35'),(129,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','186.157.77.28','2026-07-03 00:42:28'),(130,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00013 con 4 items','186.157.77.28','2026-07-03 00:43:44'),(131,'login_sucursal','ACAI Shell Select','Login exitoso','138.36.54.50','2026-07-03 01:49:39'),(132,'login_sucursal','ACAI Shell Select','Login exitoso','143.105.136.88','2026-07-03 06:47:59'),(133,'pedido_enviado','ACAI Shell Select','Pedido #00014 con 9 items','143.105.136.88','2026-07-03 06:49:54'),(134,'login_admin','admin','Login exitoso','153.67.15.139','2026-07-03 14:09:50'),(135,'login_admin','admin','Login exitoso','153.67.15.139','2026-07-07 11:18:54'),(136,'login_admin','admin','Login exitoso','153.67.15.139','2026-07-07 13:15:23'),(137,'stock_update','admin','BULK update 30 items','153.67.15.139','2026-07-07 13:15:58'),(138,'login_sucursal','ACAI Shell Select','Login exitoso','186.141.198.14','2026-07-09 19:57:19'),(139,'pedido_enviado','ACAI Shell Select','Pedido #00015 con 3 items','186.141.198.14','2026-07-09 20:01:22'),(140,'login_fail','sucursal','Login sucursal fallido','181.95.38.6','2026-07-10 05:01:46'),(141,'login_fail','sucursal','Login sucursal fallido','181.95.38.6','2026-07-10 05:02:03'),(142,'login_sucursal','ACAI Nueva Córdoba','Login exitoso','181.95.38.6','2026-07-10 05:04:40'),(143,'pedido_enviado','ACAI Nueva Córdoba','Pedido #00016 con 13 items','181.95.38.6','2026-07-10 05:09:13'),(144,'login_admin','admin','Login exitoso','179.64.37.216','2026-07-14 18:12:30'),(145,'stock_update','admin','BULK update 29 items','179.64.37.216','2026-07-14 18:12:59');
/*!40000 ALTER TABLE `log_movimientos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pedido_items`
--
DROP TABLE IF EXISTS `pedido_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pedido_items` (
`id` int NOT NULL AUTO_INCREMENT,
`pedido_id` int NOT NULL,
`item_id` int NOT NULL,
`item_nombre` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`categoria_nombre` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`cantidad` int NOT NULL,
`unidad_medida` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `pedido_id` (`pedido_id`),
KEY `idx_item` (`item_id`),
CONSTRAINT `pedido_items_ibfk_1` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE,
CONSTRAINT `pedido_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pedido_items`
--
LOCK TABLES `pedido_items` WRITE;
/*!40000 ALTER TABLE `pedido_items` DISABLE KEYS */;
INSERT INTO `pedido_items` VALUES (1,1,1,'Açaí','AÇAÍ y CREMAS',43,'Pote'),(2,1,6,'Nido','AÇAÍ y CREMAS',5,'Balde'),(3,1,8,'Pistacho','AÇAÍ y CREMAS',4,'Balde'),(4,1,10,'Mango','AÇAÍ y CREMAS',2,'Balde'),(5,1,12,'Tapioca','AÇAÍ y CREMAS',2,'Balde'),(6,1,27,'Cuchara ACAI fucsia c/logo','INSUMOS',1,'Caja x 500 unid'),(7,2,3,'Coco','AÇAÍ y CREMAS',2,'Balde'),(8,2,5,'Maracuyá','AÇAÍ y CREMAS',2,'Pote'),(9,2,8,'Pistacho','AÇAÍ y CREMAS',2,'Balde'),(10,2,9,'Frutilla','AÇAÍ y CREMAS',1,'Balde'),(11,2,16,'Vaso PP 500 ml','INSUMOS',2,'Caja x 1000 unid'),(12,2,17,'Vaso PP 700 ml','INSUMOS',2,'Caja x 500 unid'),(13,2,19,'Vaso Paperfood 750 ml','INSUMOS',2,'Caja x 300 unid'),(14,2,27,'Cuchara ACAI fucsia c/logo','INSUMOS',2,'Caja x 500 unid'),(15,3,1,'Açaí','AÇAÍ y CREMAS',20,'Pote'),(16,3,3,'Coco','AÇAÍ y CREMAS',2,'Balde'),(17,3,5,'Maracuyá','AÇAÍ y CREMAS',3,'Pote'),(18,3,7,'Paçoca','AÇAÍ y CREMAS',2,'Balde'),(19,3,8,'Pistacho','AÇAÍ y CREMAS',3,'Balde'),(20,3,9,'Frutilla','AÇAÍ y CREMAS',2,'Balde'),(21,3,10,'Mango','AÇAÍ y CREMAS',2,'Balde'),(22,3,16,'Vaso PP 500 ml','INSUMOS',1,'Caja x 1000 unid'),(27,4,10,'Mango','AÇAÍ y CREMAS',2,'Balde'),(28,4,27,'Cuchara ACAI fucsia c/logo','INSUMOS',2,'Caja x 500 unid'),(29,4,23,'Cuchara sundae negra','INSUMOS',1,'Caja x 1000 unid'),(30,4,19,'Vaso Paperfood 750 ml','INSUMOS',1,'Caja x 300 unid'),(38,5,1,'Açaí','AÇAÍ y CREMAS',20,'Pote'),(39,5,2,'Açaí Zero','AÇAÍ y CREMAS',1,'Pote'),(40,5,3,'Coco','AÇAÍ y CREMAS',1,'Balde'),(41,5,9,'Frutilla','AÇAÍ y CREMAS',2,'Balde'),(42,5,10,'Mango','AÇAÍ y CREMAS',1,'Balde'),(43,5,8,'Pistacho','AÇAÍ y CREMAS',2,'Balde'),(44,5,19,'Vaso Paperfood 750 ml','INSUMOS',2,'Caja x 300 unid'),(45,6,24,'Tapa ovalada','INSUMOS',1,'Caja x 1000 unid'),(46,7,1,'Açaí','AÇAÍ y CREMAS',10,'Pote'),(47,7,2,'Açaí Zero','AÇAÍ y CREMAS',2,'Pote'),(48,7,3,'Coco','AÇAÍ y CREMAS',1,'Balde'),(49,7,16,'Vaso PP 500 ml','INSUMOS',1,'Caja x 1000 unid'),(50,7,27,'Cuchara ACAI fucsia c/logo','INSUMOS',1,'Caja x 500 unid'),(51,8,5,'Maracuyá','AÇAÍ y CREMAS',2,'Pote'),(52,8,7,'Paçoca','AÇAÍ y CREMAS',2,'Balde'),(53,8,8,'Pistacho','AÇAÍ y CREMAS',2,'Balde'),(54,8,9,'Frutilla','AÇAÍ y CREMAS',2,'Balde'),(55,8,10,'Mango','AÇAÍ y CREMAS',2,'Balde'),(56,8,11,'Cupuaçu','AÇAÍ y CREMAS',2,'Balde'),(57,8,12,'Tapioca','AÇAÍ y CREMAS',2,'Balde'),(58,8,13,'Hielo','INSUMOS',2,'Bolsa'),(59,9,1,'Açaí','AÇAÍ y CREMAS',8,'Pote'),(60,9,4,'Agua de coco','AÇAÍ y CREMAS',1,'Balde'),(61,9,5,'Maracuyá','AÇAÍ y CREMAS',2,'Pote'),(62,9,7,'Paçoca','AÇAÍ y CREMAS',2,'Balde'),(63,9,8,'Pistacho','AÇAÍ y CREMAS',2,'Balde'),(64,9,9,'Frutilla','AÇAÍ y CREMAS',1,'Balde'),(65,9,11,'Cupuaçu','AÇAÍ y CREMAS',1,'Balde'),(66,9,12,'Tapioca','AÇAÍ y CREMAS',1,'Balde'),(67,9,32,'Bolsa para residuos - 80x110 cm','INSUMOS',2,'Paq x 10 unid'),(68,9,33,'Bolsa para residuos - 90x120 cm','INSUMOS',4,'Paq x 10 unid'),(93,10,3,'Coco','AÇAÍ y CREMAS',1,'Balde'),(94,10,9,'Frutilla','AÇAÍ y CREMAS',3,'Balde'),(95,10,10,'Mango','AÇAÍ y CREMAS',3,'Balde'),(96,10,7,'Paçoca','AÇAÍ y CREMAS',4,'Balde'),(97,10,8,'Pistacho','AÇAÍ y CREMAS',3,'Balde'),(98,10,12,'Tapioca','AÇAÍ y CREMAS',1,'Balde'),(99,10,31,'Bolsa para residuos - 60x90 cm','INSUMOS',5,'Paq x 10 unid'),(100,10,32,'Bolsa para residuos - 80x110 cm','INSUMOS',5,'Paq x 10 unid'),(101,10,27,'Cuchara ACAI fucsia c/logo','INSUMOS',2,'Caja x 500 unid'),(102,10,23,'Cuchara sundae negra','INSUMOS',2,'Caja x 1000 unid'),(103,10,35,'Servilletas 24x24 cm','INSUMOS',2,'Caja'),(104,10,28,'Pitaya','AÇAÍ y CREMAS',3,'Pote'),(105,11,8,'Pistacho','AÇAÍ y CREMAS',3,'Balde'),(106,11,9,'Frutilla','AÇAÍ y CREMAS',2,'Balde'),(107,11,10,'Mango','AÇAÍ y CREMAS',2,'Balde'),(108,11,12,'Tapioca','AÇAÍ y CREMAS',1,'Balde'),(109,11,31,'Bolsa para residuos - 60x90 cm','INSUMOS',4,'Paq x 10 unid'),(110,11,32,'Bolsa para residuos - 80x110 cm','INSUMOS',4,'Paq x 10 unid'),(111,11,33,'Bolsa para residuos - 90x120 cm','INSUMOS',4,'Paq x 10 unid'),(113,12,10,'Mango','AÇAÍ y CREMAS',2,'Balde'),(114,12,1,'Açaí','AÇAÍ y CREMAS',20,'Pote'),(115,12,2,'Açaí Zero','AÇAÍ y CREMAS',5,'Pote'),(116,12,8,'Pistacho','AÇAÍ y CREMAS',2,'Balde'),(117,12,3,'Coco','AÇAÍ y CREMAS',2,'Balde'),(118,12,6,'Nido','AÇAÍ y CREMAS',2,'Balde'),(119,13,1,'Açaí','AÇAÍ y CREMAS',10,'Pote'),(120,13,10,'Mango','AÇAÍ y CREMAS',1,'Balde'),(121,13,27,'Cuchara ACAI fucsia c/logo','INSUMOS',2,'Caja x 500 unid'),(122,13,35,'Servilletas 24x24 cm','INSUMOS',2,'Caja'),(123,14,1,'Açaí','AÇAÍ y CREMAS',8,'Pote'),(124,14,2,'Açaí Zero','AÇAÍ y CREMAS',1,'Pote'),(125,14,3,'Coco','AÇAÍ y CREMAS',1,'Balde'),(126,14,5,'Maracuyá','AÇAÍ y CREMAS',2,'Pote'),(127,14,6,'Nido','AÇAÍ y CREMAS',3,'Balde'),(128,14,8,'Pistacho','AÇAÍ y CREMAS',1,'Balde'),(129,14,9,'Frutilla','AÇAÍ y CREMAS',1,'Balde'),(130,14,10,'Mango','AÇAÍ y CREMAS',2,'Balde'),(131,14,28,'Pitaya','AÇAÍ y CREMAS',2,'Pote'),(132,15,1,'Açaí','AÇAÍ y CREMAS',4,'Pote'),(133,15,5,'Maracuyá','AÇAÍ y CREMAS',1,'Pote'),(134,15,28,'Pitaya','AÇAÍ y CREMAS',1,'Pote'),(135,16,1,'Açaí','AÇAÍ y CREMAS',15,'Pote'),(136,16,2,'Açaí Zero','AÇAÍ y CREMAS',4,'Pote'),(137,16,3,'Coco','AÇAÍ y CREMAS',2,'Balde'),(138,16,4,'Agua de coco','AÇAÍ y CREMAS',1,'Balde'),(139,16,5,'Maracuyá','AÇAÍ y CREMAS',1,'Pote'),(140,16,6,'Nido','AÇAÍ y CREMAS',2,'Balde'),(141,16,8,'Pistacho','AÇAÍ y CREMAS',2,'Balde'),(142,16,9,'Frutilla','AÇAÍ y CREMAS',1,'Balde'),(143,16,10,'Mango','AÇAÍ y CREMAS',3,'Balde'),(144,16,28,'Pitaya','AÇAÍ y CREMAS',1,'Pote'),(145,16,23,'Cuchara sundae negra','INSUMOS',2,'Caja x 1000 unid'),(146,16,27,'Cuchara ACAI fucsia c/logo','INSUMOS',2,'Caja x 500 unid'),(147,16,35,'Servilletas 24x24 cm','INSUMOS',2,'Caja');
/*!40000 ALTER TABLE `pedido_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pedidos`
--
DROP TABLE IF EXISTS `pedidos`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pedidos` (
`id` int NOT NULL AUTO_INCREMENT,
`numero` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`sucursal_id` int NOT NULL,
`fecha` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`total_items` int DEFAULT '0',
`observaciones` text COLLATE utf8mb4_unicode_ci,
`mail_enviado` tinyint(1) DEFAULT '0',
`ip_origen` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `numero` (`numero`),
KEY `idx_fecha` (`fecha`),
KEY `idx_sucursal` (`sucursal_id`),
CONSTRAINT `pedidos_ibfk_1` FOREIGN KEY (`sucursal_id`) REFERENCES `sucursales` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `pedidos`
--
LOCK TABLES `pedidos` WRITE;
/*!40000 ALTER TABLE `pedidos` DISABLE KEYS */;
INSERT INTO `pedidos` VALUES (1,'#00001',1,'2026-05-08 03:29:35',6,'Adicional (no están las opciones)\r\nRollos térmicos 80×30: un paquete\r\nPrecintos para caja\r\nBolsas de basura 80×110',1,'74.244.135.110'),(2,'#00002',1,'2026-05-15 01:35:29',8,'Bolsas de basura 80×90',1,'186.157.62.30'),(3,'#00003',1,'2026-05-22 15:07:58',8,'Crema nido: 6',1,'148.222.223.101'),(4,'#00004',1,'2026-05-29 13:39:29',4,'Bolsas de residuos 80×110\r\nCarpeta con folios (para recetas)',1,'74.244.135.241'),(5,'#00005',1,'2026-06-05 01:46:53',7,'Servilletas (para clientes)',1,'186.141.225.142'),(6,'#00006',4,'2026-06-09 20:29:58',1,'Guantes de nitrilo: 2 cajas',1,'186.143.198.18'),(7,'#00007',1,'2026-06-10 23:08:21',5,'2 cajas de servilletas para cliente\r\n3 Crema nido si es que llegó el pedido\r\n2 rollos papel film\r\nBolsas de basura 60×90',1,'186.157.76.170'),(8,'#00008',4,'2026-06-12 03:19:10',8,'Rollos de posnet 57×80\r\nBolsas de polipropileno 15×20\r\nBolsas de basura 80×110\r\nBolsas de basura 60×90\r\nFibron permanente \r\nLigas para cierre de caja',1,'148.222.222.101'),(9,'#00009',4,'2026-06-18 21:18:59',10,NULL,1,'186.143.133.187'),(10,'#00010',1,'2026-06-19 03:30:06',12,'Rollo film\r\nRollos papel para cocina',1,'181.95.32.164'),(11,'#00011',4,'2026-06-22 01:58:08',7,NULL,1,'186.141.204.134'),(12,'#00012',1,'2026-06-26 02:48:00',6,'Bobina de papel grande.',1,'181.85.184.151'),(13,'#00013',1,'2026-07-03 00:43:44',4,'2 Bovina de papel',1,'186.157.77.28'),(14,'#00014',4,'2026-07-03 06:49:54',9,'Cartón corrugado para tapar autoservicio \r\nTijera\r\nPlumero',1,'143.105.136.88'),(15,'#00015',4,'2026-07-09 20:01:22',3,NULL,1,'186.141.198.14'),(16,'#00016',1,'2026-07-10 05:09:13',13,NULL,1,'181.95.38.6');
/*!40000 ALTER TABLE `pedidos` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `reservas`
--
DROP TABLE IF EXISTS `reservas`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reservas` (
`id` int NOT NULL AUTO_INCREMENT,
`item_id` int NOT NULL,
`pedido_id` int NOT NULL,
`cantidad` int NOT NULL,
`fecha` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `pedido_id` (`pedido_id`),
KEY `idx_item` (`item_id`),
CONSTRAINT `reservas_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
CONSTRAINT `reservas_ibfk_2` FOREIGN KEY (`pedido_id`) REFERENCES `pedidos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `reservas`
--
LOCK TABLES `reservas` WRITE;
/*!40000 ALTER TABLE `reservas` DISABLE KEYS */;
/*!40000 ALTER TABLE `reservas` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stock`
--
DROP TABLE IF EXISTS `stock`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `stock` (
`id` int NOT NULL AUTO_INCREMENT,
`item_id` int NOT NULL,
`cantidad` int NOT NULL DEFAULT '0',
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`updated_by` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `item_id` (`item_id`),
CONSTRAINT `stock_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stock`
--
LOCK TABLES `stock` WRITE;
/*!40000 ALTER TABLE `stock` DISABLE KEYS */;
INSERT INTO `stock` VALUES (1,1,8,'2026-07-14 18:12:59','admin'),(2,2,2,'2026-07-14 18:12:59','admin'),(3,3,7,'2026-07-14 18:12:59','admin'),(4,4,5,'2026-07-14 18:12:59','admin'),(5,5,8,'2026-07-14 18:12:59','admin'),(6,6,7,'2026-07-14 18:12:59','admin'),(7,7,11,'2026-07-07 13:15:58','admin'),(8,8,6,'2026-07-14 18:12:59','admin'),(9,9,11,'2026-07-14 18:12:59','admin'),(10,10,3,'2026-07-14 18:12:59','admin'),(11,11,8,'2026-07-07 13:15:58','admin'),(12,12,4,'2026-07-07 13:15:58','admin'),(13,13,37,'2026-06-12 17:21:14','admin'),(14,14,8,'2026-05-08 20:03:44','admin'),(15,15,6,'2026-05-08 20:03:44','admin'),(16,16,3,'2026-06-26 13:36:28','admin'),(17,17,3,'2026-06-26 13:36:28','admin'),(18,18,4,'2026-06-26 13:36:28','admin'),(19,19,7,'2026-06-26 13:36:28','admin'),(20,20,1,'2026-05-08 20:03:44','admin'),(21,21,2,'2026-05-08 20:03:44','admin'),(22,22,5,'2026-05-15 19:31:15','admin'),(23,23,0,'2026-07-14 18:12:59','admin'),(24,24,1,'2026-05-08 20:03:44','admin'),(25,25,2,'2026-05-08 20:03:44','admin'),(26,26,2,'2026-05-08 20:03:44','admin'),(27,27,411,'2026-07-07 13:15:58','admin'),(28,28,5,'2026-07-14 18:12:59','admin'),(29,29,30,'2026-06-12 17:43:31','admin'),(30,30,30,'2026-06-12 17:46:07','admin'),(31,31,30,'2026-06-12 17:51:34','admin'),(32,32,30,'2026-06-12 17:51:50','admin'),(33,33,30,'2026-06-12 17:52:07','admin'),(34,34,500,'2026-06-12 17:54:00','admin'),(35,35,30,'2026-06-12 18:40:16','admin'),(36,36,1,'2026-06-26 12:52:04','admin'),(37,37,1,'2026-06-26 12:52:39','admin');
/*!40000 ALTER TABLE `stock` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sucursales`
--
DROP TABLE IF EXISTS `sucursales`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sucursales` (
`id` int NOT NULL AUTO_INCREMENT,
`nombre` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`password_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`activo` tinyint(1) DEFAULT '1',
`orden` int DEFAULT '0',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`last_login` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sucursales`
--
LOCK TABLES `sucursales` WRITE;
/*!40000 ALTER TABLE `sucursales` DISABLE KEYS */;
INSERT INTO `sucursales` VALUES (1,'ACAI Nueva Córdoba','$2y$10$U.20IPZCoJCoSDGuPDQoUu9JFC/HJFCWuCBJ0LTITHGUgYHI5wga6',1,1,'2026-04-30 14:28:44','2026-07-10 05:04:40'),(2,'ACAI Infinito','$2y$10$HvbpLJJ7SGNa86sJ8W4ZhOeEJFwTaFrL8fqjGx8l3vKkwGpE1pM4i',1,2,'2026-04-30 14:28:44','2026-05-01 12:52:39'),(3,'ACAI Food Truck','$2y$10$naDvd9KCUBvbWYE1Py2soujHiiYaCWYunB8undjTWV505mEKpFWwK',1,3,'2026-04-30 14:28:44',NULL),(4,'ACAI Shell Select','$2y$10$c8XZYYCAxdrNPmiU6pY8Nerd7/Ii5GpIut4I6IMXwbc7CzVVIPrDy',1,4,'2026-06-09 20:25:13','2026-07-09 19:57:18');
/*!40000 ALTER TABLE `sucursales` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `unidades_medida`
--
DROP TABLE IF EXISTS `unidades_medida`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `unidades_medida` (
`id` int NOT NULL AUTO_INCREMENT,
`nombre` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`orden` int DEFAULT '0',
`activo` tinyint(1) DEFAULT '1',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `nombre` (`nombre`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `unidades_medida`
--
LOCK TABLES `unidades_medida` WRITE;
/*!40000 ALTER TABLE `unidades_medida` DISABLE KEYS */;
INSERT INTO `unidades_medida` VALUES (1,'Balde',0,1,'2026-04-30 15:40:48'),(2,'Bolsa',0,1,'2026-04-30 15:40:48'),(3,'Bolsa x 1000',0,1,'2026-04-30 15:40:48'),(4,'Botella',0,1,'2026-04-30 15:40:48'),(5,'Caja',0,1,'2026-04-30 15:40:48'),(6,'Caja x 100 unid',0,1,'2026-04-30 15:40:48'),(7,'Caja x 1000 unid',0,1,'2026-04-30 15:40:48'),(8,'Caja x 300 unid',0,1,'2026-04-30 15:40:48'),(9,'Caja x 500 unid',0,1,'2026-04-30 15:40:48'),(10,'Lata',0,1,'2026-04-30 15:40:48'),(11,'Pote',0,1,'2026-04-30 15:40:48'),(12,'unid',0,1,'2026-06-12 17:42:59'),(13,'Paq x 10 unid',0,1,'2026-06-12 17:51:23'),(14,'Caja x 600 unid',0,1,'2026-06-26 12:52:36');
/*!40000 ALTER TABLE `unidades_medida` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2026-07-15 9:14:04
|