-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: americanb
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!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 `combos`
--

DROP TABLE IF EXISTS `combos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `combos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imagen` varchar(100) NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `productos` varchar(1000) NOT NULL,
  `estado` varchar(100) NOT NULL,
  `precio_venta` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combos`
--

LOCK TABLES `combos` WRITE;
/*!40000 ALTER TABLE `combos` DISABLE KEYS */;
INSERT INTO `combos` VALUES (1,'1.jpg','Hamburguesa Especial','[{\"id\":\"6\",\"cantidad\":\"1\"},{\"id\":\"1\",\"cantidad\":\"1\"}]','Activo','15000'),(2,'2.jpg','Hamburguesa Doble','[{\"id\":\"6\",\"cantidad\":\"1\"},{\"id\":\"1\",\"cantidad\":\"2\"}]','Activo','22000'),(3,'3.jpg','Carne De Cerdo','[{\"id\":\"2\",\"cantidad\":\"1\"}]','Activo','18000'),(4,'4.jpg','Chuzo De Pollo','[{\"id\":\"3\",\"cantidad\":\"1\"}]','Activo','18000'),(5,'5.jpg','Gaseosa 400 Ml','[{\"id\":\"4\",\"cantidad\":\"1\"}]','Activo','3000'),(6,'6.jpg','Porción De Papas','[]','Activo','4000'),(7,'7.jpg','Sandwich Pollo','[{\"id\":\"5\",\"cantidad\":\"1\"}]','Activo','15000');
/*!40000 ALTER TABLE `combos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `productos`
--

DROP TABLE IF EXISTS `productos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `productos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) NOT NULL,
  `stock` int(11) NOT NULL,
  `imagen` varchar(100) NOT NULL,
  `estado` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `productos`
--

LOCK TABLES `productos` WRITE;
/*!40000 ALTER TABLE `productos` DISABLE KEYS */;
INSERT INTO `productos` VALUES (1,'Carne Hamburguesa',17,'1.jpg','Activo'),(2,'Carne Cerdo',3,'2.jpg','Activo'),(3,'Chuzo Pollo',6,'3.jpg','Activo'),(4,'Gaseosa 400 Ml',0,'4.jpg','Activo'),(5,'Pan Sandwich',3,'5.jpg','Activo'),(6,'Pan Hamburguesa',12,'6.jpg','Activo');
/*!40000 ALTER TABLE `productos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `surtido`
--

DROP TABLE IF EXISTS `surtido`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `surtido` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `productos` varchar(1000) NOT NULL,
  `valor` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `surtido`
--

LOCK TABLES `surtido` WRITE;
/*!40000 ALTER TABLE `surtido` DISABLE KEYS */;
INSERT INTO `surtido` VALUES (1,'2025-03-20','[{\"id\":\"1\",\"cantidad\":\"48\"},{\"id\":\"2\",\"cantidad\":\"7\"},{\"id\":\"3\",\"cantidad\":\"11\"}]','356000'),(2,'2025-03-23','[{\"id\":\"1\",\"cantidad\":\"27\"}]','232000'),(3,'2025-03-22','[{\"id\":\"2\",\"cantidad\":\"5\"}]','40000'),(9,'2025-04-03','[{\"id\":\"1\",\"cantidad\":\"23\"},{\"id\":\"2\",\"cantidad\":\"5\"}]','287000'),(13,'2025-05-22','[{\"id\":\"1\",\"cantidad\":\"25\"},{\"id\":\"3\",\"cantidad\":\"10\"},{\"id\":\"2\",\"cantidad\":\"5\"}]','340000'),(14,'2025-05-30','[{\"id\":\"1\",\"cantidad\":\"35\"},{\"id\":\"2\",\"cantidad\":\"6\"},{\"id\":\"6\",\"cantidad\":\"30\"},{\"id\":\"5\",\"cantidad\":\"10\"}]','400000');
/*!40000 ALTER TABLE `surtido` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ventas`
--

DROP TABLE IF EXISTS `ventas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ventas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cliente` varchar(100) NOT NULL,
  `productos` varchar(1000) NOT NULL,
  `fecha` date NOT NULL,
  `valor` int(11) NOT NULL,
  `pago` varchar(100) NOT NULL,
  `entregado` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ventas`
--

LOCK TABLES `ventas` WRITE;
/*!40000 ALTER TABLE `ventas` DISABLE KEYS */;
INSERT INTO `ventas` VALUES (3,'1001','[{\"id\":\"2\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-03-21',30000,'Efectivo','1'),(4,'1207','[{\"id\":\"1\",\"cantidad\":\"4\",\"tp\":\"combo\"}]','2025-03-21',60000,'Efectivo','1'),(5,'416','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-03-21',15000,'Efectivo','1'),(6,'2106','[{\"id\":\"1\",\"cantidad\":\"4\",\"tp\":\"combo\"}]','2025-03-21',60000,'Transferencia','1'),(7,'1507','[{\"id\":\"1\",\"cantidad\":\"3\",\"tp\":\"combo\"}]','2025-03-21',45000,'Efectivo','1'),(8,'1508','[{\"id\":\"3\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-03-21',36000,'Efectivo','1'),(9,'1020','[{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-03-21',33000,'Efectivo','1'),(10,'1507','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-03-21',15000,'Efectivo','1'),(11,'1903','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-03-21',15000,'Transferencia','1'),(12,'416','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"4\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-03-22',51000,'Efectivo','1'),(13,'Julian','[{\"id\":\"1\",\"cantidad\":\"4\",\"tp\":\"combo\"},{\"id\":\"4\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"3\",\"cantidad\":\"4\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-03-22',154000,'Efectivo','1'),(14,'1230','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-03-22',30000,'Efectivo','1'),(16,'424','[{\"id\":\"4\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-03-22',36000,'Efectivo','1'),(17,'Camila','[{\"id\":\"1\",\"cantidad\":\"4\",\"tp\":\"combo\"},{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-03-22',78000,'Efectivo','1'),(18,'1316','[{\"id\":\"1\",\"cantidad\":\"3\",\"tp\":\"combo\"}]','2025-03-22',45000,'Efectivo','1'),(21,'9829','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-03-22',15000,'Efectivo','1'),(22,'1808','[{\"id\":\"1\",\"cantidad\":\"3\",\"tp\":\"combo\"}]','2025-03-22',45000,'Efectivo','1'),(23,'1508','[{\"id\":\"3\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-03-22',36000,'Efectivo','1'),(24,'Viviana','[{\"id\":\"6\",\"cantidad\":\"23\",\"tp\":\"combo\"},{\"id\":\"1\",\"cantidad\":\"26\",\"tp\":\"combo\"}]','2025-03-23',482000,'Efectivo','1'),(31,'NN','[{\"id\":\"1\",\"cantidad\":\"20\",\"tp\":\"combo\"},{\"id\":\"3\",\"cantidad\":\"5\",\"tp\":\"combo\"},{\"id\":\"4\",\"cantidad\":\"4\",\"tp\":\"combo\"}]','2025-04-04',462000,'Transferencia','1'),(45,'1719','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-23',30000,'Transferencia','1'),(46,'2116','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-23',30000,'Efectivo','1'),(47,'1316','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-23',30000,'Transferencia','1'),(48,'1508','[{\"id\":\"3\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-23',36000,'Efectivo','1'),(49,'1207','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-23',15000,'Transferencia','1'),(51,'1616','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-23',30000,'Transferencia','1'),(52,'1507','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"},{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',48000,'Efectivo','1'),(53,'901','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',15000,'Efectivo','1'),(54,'9812','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"5\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',22000,'Efectivo','1'),(55,'1328','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-24',30000,'Transferencia','1'),(56,'2213','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',15000,'Transferencia','1'),(57,'2106','[{\"id\":\"1\",\"cantidad\":\"3\",\"tp\":\"combo\"}]','2025-05-24',45000,'Efectivo','1'),(58,'529','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"5\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',22000,'Efectivo','1'),(59,'2131','[{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',18000,'Efectivo','1'),(60,'1020','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"5\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',22000,'Transferencia','1'),(61,'1112','[{\"id\":\"4\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',18000,'Efectivo','1'),(62,'726','[{\"id\":\"4\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-24',18000,'Transferencia','1'),(63,'1903','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-25',15000,'Transferencia','1'),(64,'1033','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-25',30000,'Efectivo','1'),(65,'1914','[{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-25',18000,'Efectivo','1'),(66,'1403','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-25',30000,'Efectivo','1'),(67,'9613','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-25',30000,'Efectivo','1'),(68,'1727','[{\"id\":\"1\",\"cantidad\":\"3\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-30',49000,'Efectivo','1'),(69,'9611','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"5\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-30',40000,'Transferencia','1'),(70,'1508','[{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-30',18000,'Efectivo','1'),(71,'9812','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"},{\"id\":\"6\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-30',23000,'Efectivo','1'),(72,'1914','[{\"id\":\"3\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-30',18000,'Efectivo','1'),(73,'Julian','[{\"id\":\"1\",\"cantidad\":\"6\",\"tp\":\"combo\"},{\"id\":\"7\",\"cantidad\":\"7\",\"tp\":\"combo\"},{\"id\":\"4\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-30',213000,'Pendiente',''),(74,'1340','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-30',15000,'Efectivo','1'),(75,'1207','[{\"id\":\"1\",\"cantidad\":\"3\",\"tp\":\"combo\"}]','2025-05-30',45000,'Transferencia','1'),(76,'1440','[{\"id\":\"1\",\"cantidad\":\"1\",\"tp\":\"combo\"}]','2025-05-30',15000,'Transferencia','1'),(77,'1604','[{\"id\":\"1\",\"cantidad\":\"2\",\"tp\":\"combo\"}]','2025-05-30',30000,'Efectivo','1');
/*!40000 ALTER TABLE `ventas` 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 2025-05-31  1:30:02
