-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: almacen2 -- ------------------------------------------------------ -- Server version 10.4.28-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 */; -- -- Current Database: `almacen2` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `almacen2` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */; USE `almacen2`; -- -- Table structure for table `auditoria_producto` -- DROP TABLE IF EXISTS `auditoria_producto`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auditoria_producto` ( `id` int(11) NOT NULL AUTO_INCREMENT, `accion` varchar(255) DEFAULT NULL, `fecha_hora` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auditoria_producto` -- LOCK TABLES `auditoria_producto` WRITE; /*!40000 ALTER TABLE `auditoria_producto` DISABLE KEYS */; INSERT INTO `auditoria_producto` VALUES (1,'Se insert el producto Vestido_nuevo','2023-11-20 11:35:15'),(2,'Se insert el producto Camisa_Hombre','2023-11-20 11:35:15'),(3,'Se insert el producto Camisa_Hombre','2023-11-20 11:35:15'); /*!40000 ALTER TABLE `auditoria_producto` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ciudad` -- DROP TABLE IF EXISTS `ciudad`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ciudad` ( `idciudad` int(10) NOT NULL AUTO_INCREMENT, `descripcion` varchar(60) NOT NULL, `estado` enum('activo','inactivo') NOT NULL, `iddepartamento` int(10) NOT NULL, PRIMARY KEY (`idciudad`), KEY `iddepartamento` (`iddepartamento`), CONSTRAINT `ciudad_ibfk_1` FOREIGN KEY (`iddepartamento`) REFERENCES `departamento` (`iddepartamento`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ciudad` -- LOCK TABLES `ciudad` WRITE; /*!40000 ALTER TABLE `ciudad` DISABLE KEYS */; INSERT INTO `ciudad` VALUES (1,'medellin','activo',1),(2,'barranquilla','activo',2),(3,'bogota','activo',3); /*!40000 ALTER TABLE `ciudad` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cliente` -- DROP TABLE IF EXISTS `cliente`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cliente` ( `cedula_cliente` varchar(15) NOT NULL, `primer_nombre` varchar(60) NOT NULL, `segundo_nombre` varchar(60) NOT NULL, `primero_apellido` varchar(60) NOT NULL, `segundo_apellido` varchar(60) NOT NULL, `fecha_nacimiento` date NOT NULL, `idciudad` int(10) NOT NULL, `direccion` varchar(80) NOT NULL, `telefono` int(11) NOT NULL, `correo` varchar(60) NOT NULL, `genero` varchar(25) NOT NULL, `estado` enum('activo','inactivo') NOT NULL, PRIMARY KEY (`cedula_cliente`), KEY `idciudad` (`idciudad`), CONSTRAINT `cliente_ibfk_1` FOREIGN KEY (`idciudad`) REFERENCES `ciudad` (`idciudad`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cliente` -- LOCK TABLES `cliente` WRITE; /*!40000 ALTER TABLE `cliente` DISABLE KEYS */; INSERT INTO `cliente` VALUES ('11023','Maria','Victoria','Ceballos','Ruedas','1990-01-01',3,'Valdivia Cra 48 # 90-36',2147483647,'mceballos@gmail.com','femenino','activo'),('1107659','Katherin','Cecilia','Thomas','Garcia','1996-08-09',1,'Medell n Cra 28 # 38-72',2147483647,'kthomas@gmail.com','femenino','activo'),('11203','Carlos ','Eduardo','Campo','Giraldo','1987-05-06',2,'El Bagre Cra 32 # 65-69',2147483647,'ccampo@gmail.com','masculino','activo'),('43200','lesdy','Vanesa','Mejia','Lopera','1995-11-18',1,'Andes Cra 35 # 51-85',2147483647,'lmejia@gmail.com','femenino','activo'),('43894','Ana','Maria','Llano','Rendon','1993-07-04',1,'Sabaneta Cra 51 # 29-45',2147483647,'allano@gmail.com','femenino','activo'),('46578','Silvia','Lorena','Dioses','Osorio','1985-07-05',2,'La Ceja Cra 74 # 13-33',5060385,'sdioses@gmail.com','femenino','activo'),('96234','Maria','Nataly','Torres','Toro','1997-12-09',1,'Copacabana Cra 65 # 45-83',2147483647,'mtorres@gmail.com','femenino','activo'),('96780','Cristian','Camilo','Sanchez','Casta o','1996-09-10',2,'Guatape Cra 54 # 26-33',5026754,'csanchez@gmail.com','masculino','activo'),('985423','Michael ','Steven','Jimenez','Toro','1987-06-03',3,'Rionegro Cra 37 # 7-78',2115147,'mjimenez@gmail.com','masculino','activo'),('98986','Andres','Felipe','Gomez','Arias','1994-10-25',3,'Guarne Cra 35 # 88-74',2147483647,'agomez@gmail.com','masculino','activo'); /*!40000 ALTER TABLE `cliente` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `departamento` -- DROP TABLE IF EXISTS `departamento`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `departamento` ( `iddepartamento` int(10) NOT NULL AUTO_INCREMENT, `descripcion` varchar(60) NOT NULL, `estado` enum('activo','inactivo') NOT NULL, PRIMARY KEY (`iddepartamento`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `departamento` -- LOCK TABLES `departamento` WRITE; /*!40000 ALTER TABLE `departamento` DISABLE KEYS */; INSERT INTO `departamento` VALUES (1,'antioquia','activo'),(2,'atlantico','activo'),(3,'cundinamarca','activo'); /*!40000 ALTER TABLE `departamento` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `detallespedido` -- DROP TABLE IF EXISTS `detallespedido`; /*!50001 DROP VIEW IF EXISTS `detallespedido`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE VIEW `detallespedido` AS SELECT 1 AS `idpedido`, 1 AS `idfactura`, 1 AS `idproducto`, 1 AS `cantidad`, 1 AS `valor_unitario`, 1 AS `subtotal`, 1 AS `iva`, 1 AS `total`, 1 AS `nombre_producto`, 1 AS `valor_producto`, 1 AS `nombre_cliente`, 1 AS `cedula_cliente` */; SET character_set_client = @saved_cs_client; -- -- Table structure for table `empleado` -- DROP TABLE IF EXISTS `empleado`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `empleado` ( `cedula_empleado` varchar(15) NOT NULL, `primer_nombre` varchar(60) NOT NULL, `segundo_nombre` varchar(60) NOT NULL, `primero_apellido` varchar(60) NOT NULL, `segundo_apellido` varchar(60) NOT NULL, `fecha_nacimiento` date NOT NULL, `direccion` varchar(80) NOT NULL, `telefono` int(11) NOT NULL, `correo` varchar(60) NOT NULL, `genero` varchar(25) NOT NULL, `estado` enum('activo','inactivo') NOT NULL, PRIMARY KEY (`cedula_empleado`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `empleado` -- LOCK TABLES `empleado` WRITE; /*!40000 ALTER TABLE `empleado` DISABLE KEYS */; INSERT INTO `empleado` VALUES ('10043','Isabel','Carolina','Benitez','Rodriguez','1987-10-20','carrera 40 nro 68-76',2113476,'dbenitez@gmail.com','femenino','activo'),('110243','Jaqueline','Isabel','Castrillon','Botero','1996-08-15','carrera50 nro 68-19',2124576,'lcastrillon@gmail.com','femenino','activo'),('43418','Marcela','Carolina','Arboleda','Tabares','1982-11-12','Carrera 48 nro 67-77',2119876,'marboleda@gmail.com','femenino','activo'),('98620','Andres','Esteban','Garcia','Acevedo','1985-06-02','calle 92a nro36',2128976,'jgarcia@gmail.com','masculino','activo'); /*!40000 ALTER TABLE `empleado` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `factura` -- DROP TABLE IF EXISTS `factura`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `factura` ( `idfactura` int(9) NOT NULL AUTO_INCREMENT, `cedula_cliente` varchar(15) NOT NULL, `cedula_empleado` varchar(15) NOT NULL, `fecha` date NOT NULL, `hora` time NOT NULL, `subtotal` int(20) NOT NULL, `total_iva` int(20) NOT NULL, `descuento` int(20) DEFAULT NULL, `total` int(20) NOT NULL, `idtipopago` int(10) NOT NULL, `descripcion` varchar(500) DEFAULT NULL, `estado_sistema` enum('activo','inactivo') NOT NULL, `estado_factura` enum('activo','inactivo') NOT NULL, PRIMARY KEY (`idfactura`), KEY `cedula_cliente` (`cedula_cliente`), KEY `idtipopago` (`idtipopago`), CONSTRAINT `factura_ibfk_1` FOREIGN KEY (`cedula_cliente`) REFERENCES `cliente` (`cedula_cliente`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `factura_ibfk_2` FOREIGN KEY (`idtipopago`) REFERENCES `tipo_pago` (`idtipopago`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `factura` -- LOCK TABLES `factura` WRITE; /*!40000 ALTER TABLE `factura` DISABLE KEYS */; INSERT INTO `factura` VALUES (1,'46578','110243','2023-01-10','11:30:34',952000,152000,95200,1104000,1,'','activo','activo'),(2,'985423','10043','2023-02-25','09:27:35',642600,102600,64260,745200,2,'','activo','activo'),(3,'11023','10043','2023-02-25','11:00:00',809200,129200,80920,938400,1,'','activo','activo'),(4,'1107659','43418','2023-03-02','12:27:34',554500,104500,55450,659000,3,'','activo','activo'),(5,'96780','98620','2023-03-02','10:09:55',999600,159600,99960,1159200,2,'','activo','activo'),(6,'11203','98620','2023-04-12','07:24:10',1285200,205200,128520,1490400,1,'','activo','activo'),(7,'96234','110243','2023-04-12','11:10:03',975800,155800,97580,1131600,1,'','activo','activo'),(8,'43200','43418','2023-05-01','12:20:46',0,0,0,0,2,'','activo','activo'),(9,'98986','43418','2023-05-01','10:20:46',0,0,0,0,4,'','activo','activo'),(10,'43894','98620','2023-05-05','12:00:00',0,0,0,0,2,'','activo','activo'); /*!40000 ALTER TABLE `factura` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `facturaspendientes` -- DROP TABLE IF EXISTS `facturaspendientes`; /*!50001 DROP VIEW IF EXISTS `facturaspendientes`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE VIEW `facturaspendientes` AS SELECT 1 AS `idfactura`, 1 AS `cedula_cliente`, 1 AS `fecha`, 1 AS `hora`, 1 AS `subtotal`, 1 AS `total_iva`, 1 AS `descuento`, 1 AS `total`, 1 AS `idtipopago`, 1 AS `descripcion`, 1 AS `estado_sistema`, 1 AS `estado_factura` */; SET character_set_client = @saved_cs_client; -- -- Table structure for table `pagos` -- DROP TABLE IF EXISTS `pagos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pagos` ( `idpagos` int(10) NOT NULL AUTO_INCREMENT, `idfactura` int(10) NOT NULL, `fecha` date NOT NULL, `hora` time NOT NULL, `monto_pagado` int(20) NOT NULL, `monto_restante` int(20) DEFAULT NULL, `observacion` varchar(500) DEFAULT NULL, PRIMARY KEY (`idpagos`), KEY `idfactura` (`idfactura`), CONSTRAINT `pagos_ibfk_1` FOREIGN KEY (`idfactura`) REFERENCES `factura` (`idfactura`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pagos` -- LOCK TABLES `pagos` WRITE; /*!40000 ALTER TABLE `pagos` DISABLE KEYS */; INSERT INTO `pagos` VALUES (7,1,'2023-01-10','11:30:34',40000,1064000,''),(8,2,'2023-02-25','09:27:35',680940,64260,''),(9,3,'2023-02-25','11:00:00',882700,55700,''),(10,4,'2023-03-02','12:27:34',0,659000,''),(11,5,'2023-03-02','10:09:55',1059240,99960,''),(12,6,'2023-04-12','07:24:10',1361880,128520,''),(13,7,'2023-04-12','11:10:03',1008800,122800,''); /*!40000 ALTER TABLE `pagos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pedido` -- DROP TABLE IF EXISTS `pedido`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pedido` ( `idpedido` int(10) NOT NULL AUTO_INCREMENT, `idfactura` int(10) NOT NULL, `idproducto` int(10) NOT NULL, `cantidad` int(20) NOT NULL, `valor_unitario` int(11) NOT NULL, `subtotal` int(20) DEFAULT NULL, `iva` int(20) DEFAULT NULL, `total` int(20) NOT NULL, PRIMARY KEY (`idpedido`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pedido` -- LOCK TABLES `pedido` WRITE; /*!40000 ALTER TABLE `pedido` DISABLE KEYS */; INSERT INTO `pedido` VALUES (1,1,2,5,95200,476000,76000,552000),(2,1,1,4,119000,476000,76000,552000),(3,2,4,3,71400,214200,34200,248400),(4,2,6,2,214200,428400,68400,496800),(5,3,2,1,95200,95200,15200,110400),(6,3,7,4,178500,714000,114000,828000),(7,4,8,2,119000,238000,38000,276000),(8,4,10,5,63300,316500,66500,383000),(9,5,6,3,214200,642600,102600,745200),(10,5,8,3,119000,357000,57000,414000),(11,6,6,6,214200,1285200,205200,1490400),(12,7,1,5,119000,595000,95000,690000),(13,7,2,4,95200,380800,60800,441600); /*!40000 ALTER TABLE `pedido` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = cp850 */ ; /*!50003 SET character_set_results = cp850 */ ; /*!50003 SET collation_connection = cp850_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger stock after insert on pedido for each row begin update producto set stock = stock - NEW.cantidad where producto.idproducto=NEW.idproducto; end */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = cp850 */ ; /*!50003 SET character_set_results = cp850 */ ; /*!50003 SET collation_connection = cp850_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER actualizar_valores_pedido AFTER INSERT ON pedido FOR EACH ROW BEGIN DECLARE sub DECIMAL(10, 2); DECLARE imp DECIMAL(10, 2); DECLARE tot DECIMAL(10, 2); SET sub = NEW.cantidad * NEW.valor_unitario; SET imp = sub * 0.19; SET tot = sub + imp; UPDATE pedido SET subtotal = sub, iva = imp, total = tot WHERE idpedido = NEW.idpedido; END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `perfil` -- DROP TABLE IF EXISTS `perfil`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `perfil` ( `idperfil` varchar(10) NOT NULL, `descripcion` varchar(60) NOT NULL, PRIMARY KEY (`idperfil`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `perfil` -- LOCK TABLES `perfil` WRITE; /*!40000 ALTER TABLE `perfil` DISABLE KEYS */; INSERT INTO `perfil` VALUES ('111','Alexander'),('112','Brayan'),('113','Estiven'),('114','Yiset'); /*!40000 ALTER TABLE `perfil` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `producto` -- DROP TABLE IF EXISTS `producto`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `producto` ( `idproducto` int(10) NOT NULL AUTO_INCREMENT, `codigotp` int(10) NOT NULL, `nombre` varchar(60) NOT NULL, `img_ref` blob DEFAULT NULL, `stock` int(11) NOT NULL, `valor` int(11) NOT NULL, `iva` int(11) DEFAULT NULL, `valor_venta` int(11) DEFAULT NULL, `estado` enum('activo','inactivo') NOT NULL, PRIMARY KEY (`idproducto`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `producto` -- LOCK TABLES `producto` WRITE; /*!40000 ALTER TABLE `producto` DISABLE KEYS */; INSERT INTO `producto` VALUES (1,2,'pantalon_mujer',NULL,111,100000,19000,119000,'activo'),(2,1,'pantalon_hombre',NULL,110,80000,15200,95200,'activo'),(3,3,'pantalon_niños',NULL,110,70000,13300,83300,'activo'),(4,2,'blusa_mujer',NULL,212,60000,11400,71400,'activo'),(5,3,'blusa_niños',NULL,200,40000,7600,47600,'activo'),(6,1,'chaqueta_hombre',NULL,99,180000,34200,214200,'activo'),(7,2,'chaqueta_mujer',NULL,146,150000,28500,178500,'activo'),(8,3,'chaqueta_niños',NULL,295,100000,19000,119000,'activo'),(9,2,'vestido_mujer',NULL,300,80000,15200,95200,'activo'),(10,3,'vestido_niños',NULL,395,50000,13300,63300,'activo'),(11,1,'camiseta_hombre',NULL,180,70000,13300,83300,'activo'),(12,2,'falda',NULL,250,70000,13300,83300,'activo'),(13,1,'pijama_hombre',NULL,190,40000,7600,47600,'activo'),(14,2,'pijama_mujer',NULL,260,50000,9500,59500,'activo'),(15,3,'pijama_niños',NULL,180,40000,7600,47600,'activo'),(16,1,'sudadera_hombre',NULL,150,100000,19000,119000,'activo'),(17,2,'sudadera_mujer',NULL,190,80000,15200,95200,'activo'),(18,3,'sudadera_niños',NULL,190,70000,13300,83300,'activo'),(19,1,'Vestido_nuevo',NULL,100,120000,20000,140000,'activo'),(20,2,'Camisa_Hombre',NULL,300,100000,50000,200000,'activo'),(21,3,'Camisa_Hombre',NULL,300,100000,50000,200000,'activo'); /*!40000 ALTER TABLE `producto` ENABLE KEYS */; UNLOCK TABLES; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = cp850 */ ; /*!50003 SET character_set_results = cp850 */ ; /*!50003 SET collation_connection = cp850_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER registro_auditoria_producto AFTER INSERT ON producto FOR EACH ROW BEGIN INSERT INTO auditoria_producto (accion, fecha_hora) VALUES (CONCAT('Se insert el producto ', NEW.nombre), NOW()); END */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `productos_copia` -- DROP TABLE IF EXISTS `productos_copia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `productos_copia` ( `idproducto` int(10) NOT NULL DEFAULT 0, `nombre` varchar(60) NOT NULL, `valor` int(11) NOT NULL, `estado` enum('activo','inactivo') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `productos_copia` -- LOCK TABLES `productos_copia` WRITE; /*!40000 ALTER TABLE `productos_copia` DISABLE KEYS */; INSERT INTO `productos_copia` VALUES (1,'pantalon_mujer',100000,'activo'),(2,'pantalon_hombre',80000,'activo'),(3,'pantalon_niños',70000,'activo'),(4,'blusa_mujer',60000,'activo'),(5,'blusa_niños',40000,'activo'),(6,'chaqueta_hombre',180000,'activo'),(7,'chaqueta_mujer',150000,'activo'),(8,'chaqueta_niños',100000,'activo'),(9,'vestido_mujer',80000,'activo'),(10,'vestido_niños',50000,'activo'),(11,'camiseta_hombre',70000,'activo'),(12,'falda',70000,'activo'),(13,'pijama_hombre',40000,'activo'),(14,'pijama_mujer',50000,'activo'),(15,'pijama_niños',40000,'activo'),(16,'sudadera_hombre',100000,'activo'),(17,'sudadera_mujer',80000,'activo'),(18,'sudadera_niños',70000,'activo'),(19,'Vestido_nuevo',120000,'activo'),(20,'Camisa_Hombre',100000,'activo'),(21,'Camisa_Hombre',100000,'activo'); /*!40000 ALTER TABLE `productos_copia` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tipo_pago` -- DROP TABLE IF EXISTS `tipo_pago`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tipo_pago` ( `idtipopago` int(10) NOT NULL AUTO_INCREMENT, `descripcion` varchar(60) NOT NULL, PRIMARY KEY (`idtipopago`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tipo_pago` -- LOCK TABLES `tipo_pago` WRITE; /*!40000 ALTER TABLE `tipo_pago` DISABLE KEYS */; INSERT INTO `tipo_pago` VALUES (1,'efectivo'),(2,'transferencia'),(3,'tarjeta'),(4,'credito'); /*!40000 ALTER TABLE `tipo_pago` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tipo_producto` -- DROP TABLE IF EXISTS `tipo_producto`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tipo_producto` ( `codigotp` int(10) NOT NULL AUTO_INCREMENT, `descripcion` varchar(60) NOT NULL, PRIMARY KEY (`codigotp`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tipo_producto` -- LOCK TABLES `tipo_producto` WRITE; /*!40000 ALTER TABLE `tipo_producto` DISABLE KEYS */; INSERT INTO `tipo_producto` VALUES (1,'Hombre'),(2,'Mujer'),(3,'Niños'); /*!40000 ALTER TABLE `tipo_producto` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `usuario` -- DROP TABLE IF EXISTS `usuario`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `usuario` ( `idusuario` varchar(10) NOT NULL, `usuario` varchar(20) NOT NULL, `contrasena` varchar(20) NOT NULL, `idperfil` varchar(10) NOT NULL, PRIMARY KEY (`idusuario`), KEY `idperfil` (`idperfil`), CONSTRAINT `usuario_ibfk_1` FOREIGN KEY (`idperfil`) REFERENCES `perfil` (`idperfil`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `usuario` -- LOCK TABLES `usuario` WRITE; /*!40000 ALTER TABLE `usuario` DISABLE KEYS */; INSERT INTO `usuario` VALUES ('11','Alexander11','??e','111'),('12','Brayan12','t?%','112'),('13','Estiven13',' ??','113'),('14','Yiset14','??\0','114'); /*!40000 ALTER TABLE `usuario` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `almacen2` -- USE `almacen2`; -- -- Final view structure for view `detallespedido` -- /*!50001 DROP VIEW IF EXISTS `detallespedido`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = cp850 */; /*!50001 SET character_set_results = cp850 */; /*!50001 SET collation_connection = cp850_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `detallespedido` AS select `p`.`idpedido` AS `idpedido`,`p`.`idfactura` AS `idfactura`,`p`.`idproducto` AS `idproducto`,`p`.`cantidad` AS `cantidad`,`p`.`valor_unitario` AS `valor_unitario`,`p`.`subtotal` AS `subtotal`,`p`.`iva` AS `iva`,`p`.`total` AS `total`,`pr`.`nombre` AS `nombre_producto`,`pr`.`valor` AS `valor_producto`,concat_ws(' ',`c`.`primer_nombre`,`c`.`segundo_nombre`) AS `nombre_cliente`,`c`.`cedula_cliente` AS `cedula_cliente` from (((`pedido` `p` join `producto` `pr` on(`p`.`idproducto` = `pr`.`idproducto`)) join `factura` `f` on(`p`.`idfactura` = `f`.`idfactura`)) join `cliente` `c` on(`f`.`cedula_cliente` = `c`.`cedula_cliente`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `facturaspendientes` -- /*!50001 DROP VIEW IF EXISTS `facturaspendientes`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = cp850 */; /*!50001 SET character_set_results = cp850 */; /*!50001 SET collation_connection = cp850_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `facturaspendientes` AS select `factura`.`idfactura` AS `idfactura`,`factura`.`cedula_cliente` AS `cedula_cliente`,`factura`.`fecha` AS `fecha`,`factura`.`hora` AS `hora`,`factura`.`subtotal` AS `subtotal`,`factura`.`total_iva` AS `total_iva`,`factura`.`descuento` AS `descuento`,`factura`.`total` AS `total`,`factura`.`idtipopago` AS `idtipopago`,`factura`.`descripcion` AS `descripcion`,`factura`.`estado_sistema` AS `estado_sistema`,`factura`.`estado_factura` AS `estado_factura` from `factura` where `factura`.`estado_factura` = 'activo' and `factura`.`total` > 0 */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!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 2023-11-20 15:23:17