Файловый менеджер

Файловый менеджер - Редактировать - /home2/cocinasdalloway/public_html/grupodly.com/public/bd/comercializadora_dly.sql

Назад
/* SQLyog Community v12.4.2 (64 bit) MySQL - 5.6.46-cll-lve : Database - comercializadora_dly ********************************************************************* / /!40101 SET NAMES utf8 /; /!40101 SET SQL_MODE=''/; /!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 /; CREATE DATABASE /!32312 IF NOT EXISTS/`comercializadora_dly` /!40100 DEFAULT CHARACTER SET latin1 /; USE `comercializadora_dly`; /Table structure for table `t01_cliente` / DROP TABLE IF EXISTS `t01_cliente`; CREATE TABLE `t01_cliente` ( `t01_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Cliente Key', `t01_f001` varchar(45) DEFAULT NULL COMMENT 'Nombre', `t01_f002` varchar(45) DEFAULT NULL COMMENT 'Apellido', `t01_f003` varchar(45) DEFAULT NULL COMMENT 'Telefono', `t01_f004` varchar(45) DEFAULT NULL COMMENT 'Password', `t01_f005` varchar(45) DEFAULT NULL COMMENT 'Activo', `t01_f006` varchar(100) DEFAULT NULL COMMENT 'Correo Eléctronico', `t01_f098` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registro', `t01_f099` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha actualización', PRIMARY KEY (`t01_pk01`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /Data for the table `t01_cliente` / insert into `t01_cliente`(`t01_pk01`,`t01_f001`,`t01_f002`,`t01_f003`,`t01_f004`,`t01_f005`,`t01_f006`,`t01_f098`,`t01_f099`) values (1,'Jesus','Herrera','4423569374','123456','1','chucho_herrera7@hotmail.com','2019-12-13 07:22:22','2019-12-26 08:17:07'), (2,'Jesus','Herrera','2342342332','123456','1','jesus.herrera@gmail.com','2019-12-13 17:31:38','2019-12-13 17:31:38'), (3,'Luis ','Martinez','4481695819','C0nnect+1','1','luis.martinez@splittel.com','2019-12-18 16:09:22','2019-12-18 16:09:22'), (4,'Aaron','Cuevas','4421917076','A.cuevas2017','1','aaron0609.ac@gmail.com','2019-12-20 17:06:56','2019-12-20 17:06:56'); /Table structure for table `t02_datos_envio` / DROP TABLE IF EXISTS `t02_datos_envio`; CREATE TABLE `t02_datos_envio` ( `t02_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Datos de envio Key', `t02_f001` varchar(45) DEFAULT NULL COMMENT 'Nombre', `t02_f002` varchar(45) DEFAULT NULL COMMENT 'Apellido', `t02_f003` int(11) DEFAULT NULL COMMENT 'Celular', `t02_f004` int(11) DEFAULT NULL COMMENT 'Telefono', `t02_f005` varchar(100) DEFAULT NULL COMMENT 'Calle', `t02_f006` varchar(5) DEFAULT NULL COMMENT 'Numero exterior', `t02_f007` varchar(5) DEFAULT NULL COMMENT 'Numero Inteior', `t02_f008` int(5) DEFAULT NULL COMMENT 'Codigo postal', `t02_f009` varchar(45) DEFAULT NULL COMMENT 'Estado', `t02_f010` varchar(45) DEFAULT NULL COMMENT 'Municipio', `t02_f011` varchar(45) DEFAULT NULL COMMENT 'Colonia', `t02_f012` varchar(45) DEFAULT NULL COMMENT 'Referencia', `t02_f013` varchar(45) DEFAULT NULL COMMENT 'Activo', `t01_pk01` int(11) DEFAULT NULL COMMENT 'Cliente Key', `t02_f0098` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registo', `t02_f099` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización', PRIMARY KEY (`t02_pk01`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /Data for the table `t02_datos_envio` / insert into `t02_datos_envio`(`t02_pk01`,`t02_f001`,`t02_f002`,`t02_f003`,`t02_f004`,`t02_f005`,`t02_f006`,`t02_f007`,`t02_f008`,`t02_f009`,`t02_f010`,`t02_f011`,`t02_f012`,`t02_f013`,`t01_pk01`,`t02_f0098`,`t02_f099`) values (1,'JESUS','RTYURT',1234567890,1234567890,'FGHJ','23','23',12345,'FGHJ','GHJ','FGH','GHJ','1',1,'2019-12-18 09:29:18','2019-12-20 17:02:58'); /Table structure for table `t03_datos_facturacion` / DROP TABLE IF EXISTS `t03_datos_facturacion`; CREATE TABLE `t03_datos_facturacion` ( `t03_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Datos de facturación Key', `t03_f001` varchar(45) DEFAULT NULL COMMENT 'Razón social', `t03_f002` varchar(45) DEFAULT NULL COMMENT 'Tipo ', `t03_f003` varchar(15) DEFAULT NULL COMMENT 'RFC', `t03_f004` varchar(100) DEFAULT NULL COMMENT 'Calle', `t03_f005` varchar(5) DEFAULT NULL COMMENT 'Numero exterior', `t03_f006` varchar(5) DEFAULT NULL COMMENT 'Numero Interior', `t03_f007` int(5) DEFAULT NULL COMMENT 'Codigo Postal', `t03_f008` varchar(45) DEFAULT NULL COMMENT 'Estado', `t03_f009` varchar(45) DEFAULT NULL COMMENT 'Municipio', `t03_f010` varchar(45) DEFAULT NULL COMMENT 'Colonia', `t03_f011` int(11) DEFAULT NULL COMMENT 'Activo', `t01_pk01` int(11) DEFAULT NULL, `t03_f098` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registro', `t03_f099` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización', PRIMARY KEY (`t03_pk01`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /Data for the table `t03_datos_facturacion` / insert into `t03_datos_facturacion`(`t03_pk01`,`t03_f001`,`t03_f002`,`t03_f003`,`t03_f004`,`t03_f005`,`t03_f006`,`t03_f007`,`t03_f008`,`t03_f009`,`t03_f010`,`t03_f011`,`t01_pk01`,`t03_f098`,`t03_f099`) values (1,'wer','wer','HEVJ970312S10','FGHJ','FGH','RTY',12345,'GHJ','GHJ','FGH',1,1,'2019-12-18 15:30:24','2019-12-20 17:03:05'); /Table structure for table `t04_pedido` / DROP TABLE IF EXISTS `t04_pedido`; CREATE TABLE `t04_pedido` ( `t04_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Pedido Key', `t04_f001` float DEFAULT NULL COMMENT 'Subtotal', `t04_f002` float DEFAULT NULL COMMENT 'Iva', `t04_f003` float DEFAULT NULL COMMENT 'Total', `t04_f004` int(11) DEFAULT NULL COMMENT 'Estatus', `t04_f005` varchar(45) DEFAULT NULL COMMENT 'Numero de guia', `t01_pk01` int(11) DEFAULT NULL COMMENT 'Cliente Key', `t02_pk01` int(11) DEFAULT NULL COMMENT 'Datos de envio key', `t03_pk01` int(11) DEFAULT NULL COMMENT 'Datos de facturación key', `t04_f098` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registro', `t04_f099` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualizacion', PRIMARY KEY (`t04_pk01`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1; /Data for the table `t04_pedido` / insert into `t04_pedido`(`t04_pk01`,`t04_f001`,`t04_f002`,`t04_f003`,`t04_f004`,`t04_f005`,`t01_pk01`,`t02_pk01`,`t03_pk01`,`t04_f098`,`t04_f099`) values (26,0,0.4,0,1,NULL,3,NULL,NULL,'2019-12-23 11:32:22','2019-12-23 12:32:34'), (27,6438,2575.2,9013.2,1,NULL,3,NULL,NULL,'2019-12-23 12:33:56','2019-12-23 13:31:04'), (28,0,0.4,0,1,NULL,1,NULL,NULL,'2019-12-31 07:54:53','2019-12-31 07:54:53'), (29,0,0.4,0,1,NULL,1,NULL,NULL,'2019-12-31 08:07:01','2019-12-31 08:07:01'), (30,0,0.4,0,1,NULL,0,NULL,NULL,'2019-12-31 08:46:35','2019-12-31 08:46:35'), (31,0,0.4,0,1,NULL,0,NULL,NULL,'2020-01-02 09:11:48','2020-01-02 09:11:48'), (32,0,0.4,0,1,NULL,0,NULL,NULL,'2020-01-02 16:04:50','2020-01-02 16:04:50'); /Table structure for table `t05_pedido_detalle` / DROP TABLE IF EXISTS `t05_pedido_detalle`; CREATE TABLE `t05_pedido_detalle` ( `t05_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Pedido Detalle Key', `t05_f001` float DEFAULT NULL COMMENT 'Subtotal', `t05_f002` float DEFAULT NULL COMMENT 'Iva', `t05_f003` float DEFAULT NULL COMMENT 'Total', `t05_f004` int(11) DEFAULT NULL COMMENT 'Cantidad', `t05_f005` int(11) DEFAULT NULL COMMENT 'Estatus', `t05_f006` float DEFAULT NULL COMMENT 'Precio Unitario', `t06_pk01` int(11) DEFAULT NULL COMMENT 'Producto key', `t04_pk01` int(11) DEFAULT NULL COMMENT 'Pedido Key', `t05_f098` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registro ', `t05_f099` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización', PRIMARY KEY (`t05_pk01`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1; /Data for the table `t05_pedido_detalle` / insert into `t05_pedido_detalle`(`t05_pk01`,`t05_f001`,`t05_f002`,`t05_f003`,`t05_f004`,`t05_f005`,`t05_f006`,`t06_pk01`,`t04_pk01`,`t05_f098`,`t05_f099`) values (13,2146,858.4,3004.4,2,1,1073,2,26,'2019-12-23 11:32:23','2019-12-23 11:35:39'), (14,6438,2575.2,9013.2,6,1,1073,2,27,'2019-12-23 12:33:56','2019-12-23 13:31:04'), (15,1073,429.2,1502.2,1,1,1073,2,29,'2019-12-31 08:07:01','2019-12-31 08:07:01'), (17,313,125.2,438.2,2,1,156.5,21,30,'2019-12-31 08:46:50','2019-12-31 08:46:55'), (18,42,16.8,58.8,1,1,42,10,29,'2019-12-31 09:13:07','2019-12-31 09:13:07'), (19,339.58,135.832,475.412,1,1,339.58,13,29,'2019-12-31 10:01:49','2019-12-31 10:01:49'), (20,8,3.2,11.2,1,1,8,8,29,'2019-12-31 10:03:43','2019-12-31 10:03:43'), (21,5000,2000,7000,1,1,5000,18,29,'2019-12-31 10:04:54','2019-12-31 10:04:54'), (22,145,58,203,1,1,145,14,31,'2020-01-02 09:11:49','2020-01-02 09:11:49'), (23,39,15.6,54.6,3,1,13,16,31,'2020-01-02 09:13:52','2020-01-02 09:14:28'), (24,5000,2000,7000,1,1,5000,18,31,'2020-01-02 09:15:10','2020-01-02 09:15:10'), (25,4,1.6,5.6,1,1,4,4,32,'2020-01-02 16:04:51','2020-01-02 16:04:51'); /Table structure for table `t06_productos` / DROP TABLE IF EXISTS `t06_productos`; CREATE TABLE `t06_productos` ( `t06_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Producto Key', `t06_f001` varchar(45) DEFAULT NULL COMMENT 'Codigo', `t06_f002` varchar(100) DEFAULT NULL COMMENT 'Descripción', `t06_f003` text COMMENT 'Img Path', `t06_f004` float DEFAULT NULL COMMENT 'Ancho', `t06_f005` float DEFAULT NULL COMMENT 'Alto', `t06_f006` float DEFAULT NULL COMMENT 'Grosor', `t06_f007` int(11) DEFAULT NULL COMMENT 'Existencia', `t06_f008` float DEFAULT NULL COMMENT 'Precio', `t07_pk01` int(11) DEFAULT NULL COMMENT 'Categoria Key', `t08_pk01` int(11) DEFAULT NULL COMMENT 'Proveedor Key', `t10_pk01` int(11) DEFAULT NULL COMMENT 'Unidad de medida', `t06_f098` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registro ', `t06_f099` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización', PRIMARY KEY (`t06_pk01`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1; /Data for the table `t06_productos` / insert into `t06_productos`(`t06_pk01`,`t06_f001`,`t06_f002`,`t06_f003`,`t06_f004`,`t06_f005`,`t06_f006`,`t06_f007`,`t06_f008`,`t07_pk01`,`t08_pk01`,`t10_pk01`,`t06_f098`,`t06_f099`) values (1,'011001','MDP Acacia Arauco Nacional','011001',1830,2500,15,3,790,1,1,1,'2019-12-18 21:47:36','2019-12-31 07:46:55'), (2,'011012','MDP Loto Arauco Nacional HR','011012',1830,2500,15,0,1073,1,1,1,'2019-12-18 21:56:21','2019-12-30 11:22:59'), (4,'31066','Borde Sakura Frosty 19x1 mm','31066',1,2,19,625,4,2,2,2,'2019-12-21 18:02:14','2019-12-30 11:23:20'), (8,'31065','Borde Canna','31065',150,25,1,60,8,2,3,2,'2019-12-21 18:12:46','2019-12-30 11:23:32'), (9,'81025','Mazo de hule 16 oz. c/mango MH-16 Truper','81025',0,0,0,1,76,3,3,1,'2019-12-21 18:14:33','2019-12-30 11:23:39'), (10,'191105','Colador para pintura','191105',0,0,0,1,42,3,3,1,'2019-12-21 18:15:52','2019-12-30 11:23:46'), (11,'71003','Mascarilla blanca Truper','71003',0,0,0,207,3,4,3,1,'2019-12-21 18:21:46','2019-12-30 11:23:51'), (12,'71008','Lentes de seguridad','71008',0,0,0,1,15,4,3,1,'2019-12-21 18:23:27','2019-12-30 11:23:57'), (13,'61005','Pegamento de contacto, Ralph Wilson','61005',0,0,0,2,339.58,1,1,1,'2019-12-21 18:25:30','2019-12-30 11:24:02'), (14,'61051','Pegamento blanco 850','61051',0,0,0,1,145,5,3,3,'2019-12-21 18:27:27','2019-12-30 11:24:10'), (15,'51025','Correderas Extension 30 mm. Handy Home','51025',0,0,0,0,47,6,4,1,'2019-12-21 18:28:57','2019-12-30 11:24:29'), (16,'51002','Bisagra 110 Sobrepuesta cuello 00 48x6 mm','51002',0,0,0,762,13,6,5,1,'2019-12-21 18:30:00','2019-12-30 11:24:37'), (17,'91006','Campana extractora Axcent CXW-218-A19D1 (90 CM) Mamma Mia','91006',0,0,0,0,9000,7,6,1,'2019-12-21 18:31:58','2019-12-30 11:24:46'), (18,'91007','Parrilla a gas Tecnolam VETRO915.NE','91007',0,0,0,0,5000,7,6,1,'2019-12-21 18:32:55','2019-12-30 11:24:54'), (19,'061009','Pintura Berel Blanco','061009',0,0,0,1,86,8,3,4,'2019-12-30 00:43:29','2019-12-30 11:25:04'), (20,'061013','Pintura Behr Color Menta','061013',0,0,0,2,689,8,3,4,'2019-12-30 00:45:46','2019-12-30 11:25:14'), (21,'051061','RESANADOR SAYER NITROLACA BRILLANTE BLANCA','051061',0,0,0,5,156.5,9,7,4,'2019-12-30 00:53:19','2019-12-30 11:25:25'), (22,'051062','Barniz al agua Alba cristalba','051062',0,0,0,1,387.28,9,3,4,'2019-12-30 00:55:35','2019-12-30 11:25:33'), (23,'061049','Tinta al aceite Mancha Sayer Lack Color Amarillo Ocre','061049',0,0,0,2,173,10,3,1,'2019-12-30 01:30:43','2019-12-30 11:25:43'), (24,'061042','Tinta Mancha Sayer Color Verde Ficus','061042',0,0,0,1,155,10,3,1,'2019-12-30 01:32:08','2019-12-30 11:25:52'), (25,'061062','Disco Zodec-lija','061062',0,0,0,4,31,11,3,1,'2019-12-30 01:34:20','2019-12-30 11:26:01'), (26,'091019','Lija negra Fandeli 220','091019',0,0,0,3,6,11,3,1,'2019-12-30 01:35:30','2019-12-30 11:26:08'), (27,'091015','Yeso ceramico ','091015',0,0,0,20,487.23,12,3,3,'2019-12-30 01:40:40','2019-12-30 11:26:18'); /Table structure for table `t07_categorias` / DROP TABLE IF EXISTS `t07_categorias`; CREATE TABLE `t07_categorias` ( `t07_pk01` int(11) NOT NULL AUTO_INCREMENT, `t07_f001` varchar(45) NOT NULL, `t07_f098` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `t07_f099` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`t07_pk01`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; /Data for the table `t07_categorias` / insert into `t07_categorias`(`t07_pk01`,`t07_f001`,`t07_f098`,`t07_f099`) values (1,'Tablero','2019-12-18 15:54:23','2019-12-18 15:54:23'), (2,'Borde','2019-12-18 15:54:23','2019-12-18 15:54:23'), (3,'Herramienta','2019-12-18 15:54:23','2019-12-18 15:54:23'), (4,'MIsceleaneos','2019-12-18 15:54:24','2019-12-18 15:54:24'), (5,'Pegamento','2019-12-18 15:54:24','2019-12-18 15:54:24'), (6,'Herraje','2019-12-18 15:54:24','2019-12-18 15:54:24'), (7,'Equipos','2019-12-18 15:54:24','2019-12-18 15:54:24'), (8,'Pinturas','2019-12-18 15:54:24','2019-12-18 15:54:24'), (9,'Laca','2019-12-18 15:54:24','2019-12-18 15:54:24'), (10,'Tinta','2019-12-18 15:54:25','2019-12-18 15:54:25'), (11,'Abrasivos','2019-12-18 15:54:25','2019-12-18 15:54:25'), (12,'Acabados','2019-12-18 15:54:25','2019-12-18 15:54:25'), (13,'Solventes','2019-12-18 15:54:25','2019-12-18 15:54:25'), (14,'Perfiles','2019-12-18 15:54:25','2019-12-18 15:54:25'), (15,'Equipos','2019-12-18 15:54:25','2019-12-18 15:54:25'), (16,'Tornilleria','2019-12-18 15:54:26','2019-12-18 15:54:26'); /Table structure for table `t08_proveedores` / DROP TABLE IF EXISTS `t08_proveedores`; CREATE TABLE `t08_proveedores` ( `t08_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Proveedor Key', `t08_f001` varchar(45) NOT NULL, `t08_f098` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `t08_f099` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de registro', PRIMARY KEY (`t08_pk01`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; /Data for the table `t08_proveedores` / insert into `t08_proveedores`(`t08_pk01`,`t08_f001`,`t08_f098`,`t08_f099`) values (1,'El Mundo del Triplay SA de CV','2019-12-18 16:01:15','2019-12-18 15:51:41'), (2,'Luís Daniel Flores Campos','2019-12-18 16:01:15','2019-12-18 15:51:42'), (3,'Generico','2019-12-18 16:01:15','2019-12-18 15:51:42'), (4,'Comercializadora Diavec SA de CV','2019-12-18 16:01:15','2019-12-18 15:51:42'), (5,'Tiendas Cerrajes SA de CV','2019-12-18 16:01:15','2019-12-18 15:51:42'), (6,'Cubiertas y Laminados del Centro SA de CV','2019-12-18 16:01:15','2019-12-18 15:51:42'), (7,'CARPIMAX','2019-12-18 16:01:15','2019-12-18 15:51:43'), (8,'Vetrata SA de CV','2019-12-18 16:01:15','2019-12-18 15:51:43'); /Table structure for table `t09_comentarios_producto` / DROP TABLE IF EXISTS `t09_comentarios_producto`; CREATE TABLE `t09_comentarios_producto` ( `t09_pk01` int(11) NOT NULL AUTO_INCREMENT, `t09_f001` varchar(45) NOT NULL COMMENT 'Titulo', `t09_f002` text NOT NULL COMMENT 'Descripción', `t09_f003` int(11) NOT NULL COMMENT 'Total Estrellas', `t01_pk01` int(11) DEFAULT NULL, `t06_pk01` int(11) NOT NULL COMMENT 'ProductoKey', `t09_f098` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registro', `t09_f099` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización', PRIMARY KEY (`t09_pk01`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /Data for the table `t09_comentarios_producto` / insert into `t09_comentarios_producto`(`t09_pk01`,`t09_f001`,`t09_f002`,`t09_f003`,`t01_pk01`,`t06_pk01`,`t09_f098`,`t09_f099`) values (2,'tt','trrtrttrtr',5,0,2,'2019-12-19 18:04:53','2019-12-19 18:04:53'), (3,'you','ooooooooooooooooooooooooooooooooooooooooooooo',4,1,2,'2019-12-19 18:17:52','2019-12-19 18:17:52'), (4,'test','teeeeeeeeeeeeeeeeeest',5,0,18,'2020-01-02 09:15:36','2020-01-02 09:15:36'), (5,'test','teeeeeeeeeeeeeeeeeest',5,0,18,'2020-01-02 09:15:41','2020-01-02 09:15:41'); /Table structure for table `t10_unidades_medida` / DROP TABLE IF EXISTS `t10_unidades_medida`; CREATE TABLE `t10_unidades_medida` ( `t10_pk01` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Unidad medida key', `t10_f001` varchar(45) NOT NULL COMMENT 'Descripción', `t10_f002` varchar(5) NOT NULL COMMENT 'Abreviación', `t10_f098` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de registro', `t10_f099` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización', PRIMARY KEY (`t10_pk01`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; /Data for the table `t10_unidades_medida` / insert into `t10_unidades_medida`(`t10_pk01`,`t10_f001`,`t10_f002`,`t10_f098`,`t10_f099`) values (1,'Pieza(s)','Pza','2019-12-30 11:01:12','2019-12-30 11:01:42'), (2,'Metro(s)','Mts','2019-12-30 11:01:13','2019-12-30 11:01:13'), (3,'Kilogramo(s)','Kg','2019-12-30 11:01:13','2019-12-30 11:01:13'), (4,'Litro(s)','Lts','2019-12-30 11:01:13','2019-12-30 11:01:13'); / Procedure structure for procedure `ClienteDatosEnvio` / /!50003 DROP PROCEDURE IF EXISTS `ClienteDatosEnvio` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `ClienteDatosEnvio`( IN DatosEnvioKey INT, IN DatosEnvioNombre NVARCHAR(45), IN DatosEnvioApellido NVARCHAR(45), IN DatosEnvioCelular INT, IN DatosEnvioTelefono INT, IN DatosEnvioCalle NVARCHAR(100), IN DatosEnvioNumeroExt NVARCHAR(5), IN DatosEnvioNumeroInt NVARCHAR(5), IN DatosEnvioCP INT, IN DatosEnvioEstado NVARCHAR(45), IN DatosEnvioMunicipio NVARCHAR(45), IN DatosEnvioColonia NVARCHAR(45), IN DatosEnvioReferencia NVARCHAR(45), IN DatosEnvioActivo INT, IN ClienteKey INT, OUT RESULT TEXT ) BEGIN IF(SELECT COUNT() FROM t02_datos_envio WHERE t02_pk01 = DatosEnvioKey) <= 0 THEN INSERT INTO t02_datos_envio VALUES( NULL, DatosEnvioNombre, DatosEnvioApellido, DatosEnvioCelular, DatosEnvioTelefono, DatosEnvioCalle, DatosEnvioNumeroExt, DatosEnvioNumeroInt, DatosEnvioCP, DatosEnvioEstado, DatosEnvioMunicipio, DatosEnvioColonia, DatosEnvioReferencia, DatosEnvioActivo, ClienteKey, NOW(), NOW() ); SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!" }'); ELSE UPDATE t02_datos_envio SET t02_f001 = DatosEnvioNombre, t02_f002 = DatosEnvioApellido, t02_f003 = DatosEnvioCelular, t02_f004 = DatosEnvioTelefono, t02_f005 = DatosEnvioCalle, t02_f006 = DatosEnvioNumeroExt, t02_f007 = DatosEnvioNumeroInt, t02_f008 = DatosEnvioCP, t02_f009 = DatosEnvioEstado, t02_f010 = DatosEnvioMunicipio, t02_f011 = DatosEnvioColonia, t02_f012 = DatosEnvioReferencia, t02_f013 = DatosEnvioActivo, t02_f099 = NOW() WHERE t02_pk01 = DatosEnvioKey; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Actualizado exitosamente!" }'); END IF; END /$$ DELIMITER ; /* Procedure structure for procedure `ClienteDatosFacturacion` / /!50003 DROP PROCEDURE IF EXISTS `ClienteDatosFacturacion` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `ClienteDatosFacturacion`( IN DatosFacturacionKey INT, IN DatosFacturacionRazonSocial NVARCHAR(45), IN DatosFacturacionTipo NVARCHAR(45), IN DatosFacturacionRFC NVARCHAR(15), IN DatosFacturacionCalle NVARCHAR(100), IN DatosFacturacionNumeroExt NVARCHAR(5), IN DatosFacturacionNumeroInt NVARCHAR(5), IN DatosFacturacionCP INT, IN DatosFacturacionEstado NVARCHAR(45), IN DatosFacturacionMunicipio NVARCHAR(45), IN DatosFacturacionColonia NVARCHAR(45), IN DatosFacturacionActivo INT, IN ClienteKey INT, OUT RESULT TEXT ) BEGIN IF(SELECT COUNT() FROM t03_datos_facturacion WHERE t03_pk01 = DatosFacturacionKey) <= 0 THEN INSERT INTO t03_datos_facturacion VALUES( NULL, DatosFacturacionRazonSocial, DatosFacturacionTipo, DatosFacturacionRFC, DatosFacturacionCalle, DatosFacturacionNumeroExt, DatosFacturacionNumeroInt, DatosFacturacionCP, DatosFacturacionEstado, DatosFacturacionMunicipio, DatosFacturacionColonia, DatosFacturacionActivo, ClienteKey, NOW(), NOW() ); SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!" }'); ELSE UPDATE t03_datos_facturacion SET t03_f001 = DatosFacturacionRazonSocial, t03_f002 = DatosFacturacionTipo, t03_f003 = DatosFacturacionRFC, t03_f004 = DatosFacturacionCalle, t03_f005 = DatosFacturacionNumeroExt, t03_f006 = DatosFacturacionNumeroInt, t03_f007 = DatosFacturacionCP, t03_f008 = DatosFacturacionEstado, t03_f009 = DatosFacturacionMunicipio, t03_f010 = DatosFacturacionColonia, t03_f011 = DatosFacturacionActivo, t03_f099 = NOW() WHERE t03_pk01 = DatosFacturacionKey; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Actualizado exitosamente!" }'); END IF; END /$$ DELIMITER ; /* Procedure structure for procedure `ClienteRegistro` / /!50003 DROP PROCEDURE IF EXISTS `ClienteRegistro` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `ClienteRegistro`( IN ClienteKey INT, IN Nombre NVARCHAR(45), IN Apellido NVARCHAR(45), IN Telefono NVARCHAR(45), IN ClientePassword NVARCHAR(45), IN ClientePasswordConfirm NVARCHAR(45), IN Correo NVARCHAR(100), OUT RESULT TEXT ) BEGIN IF(ClientePassword = ClientePasswordConfirm) THEN IF(SELECT COUNT() FROM t01_cliente WHERE ClienteKey = t01_pk01) <= 0 THEN IF(SELECT COUNT() FROM t01_cliente WHERE Correo = t01_f006) <= 0 THEN INSERT INTO t01_cliente VALUES( NULL, Nombre, Apellido, Telefono, ClientePassword, 1, -- 1. Activo Correo, NOW(), NOW() ); SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!" }'); ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"warning", "ErrorCode": 100, "message":"¡Ya existe un cliente resgistrado con el mismo correo!" }'); END IF; ELSE UPDATE t01_cliente SET t01_f001 = Nombre, t01_f002 = Apellido, t01_f003 = Telefono, t01_f004 = ClientePassword, t01_f099 = NOW() WHERE t01_pk01 = ClienteKey; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Actualizado exitosamente!" }'); END IF; ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"warning", "ErrorCode": 200, "message":"¡Las contraseñas no coinciden, por favor intenta de nuevo!!" }'); END IF; END /$$ DELIMITER ; / Procedure structure for procedure `Login` / /!50003 DROP PROCEDURE IF EXISTS `Login` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `Login`( IN Email NVARCHAR(100), IN ClientePassword NVARCHAR(45), OUT RESULT TEXT ) BEGIN IF(SELECT COUNT() FROM t01_cliente WHERE t01_f006 = Email) >= 0 THEN IF(SELECT COUNT() FROM t01_cliente WHERE t01_f006 = Email AND t01_f004 = ClientePassword) >= 0 THEN SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Redireccionando E-commerce DLY!" }'); ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"warning", "ErrorCode": 100, "message":"¡La contraseña que ingresaste no es correcta, por favor verifica e intenta de nuevo!" }'); END IF; ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"warning", "ErrorCode": 200, "message":"¡No se encuentra aún registrado con este correo, por favor verifica que sea correcto e intenta de nuevo!" }'); END IF; END /$$ DELIMITER ; / Procedure structure for procedure `PedidoActualizarCliente` / /!50003 DROP PROCEDURE IF EXISTS `PedidoActualizarCliente` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `PedidoActualizarCliente`( IN keyy INT, IN Cliente INT, OUT RESULT TEXT ) BEGIN IF(SELECT COUNT() FROM t04_pedido WHERE t04_pk01 = keyy) > 0 THEN UPDATE t04_pedido SET t01_pk01 = Cliente, `t03_f099` = now() WHERE t04_pk01 = keyy; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Actualizado exitosamente!", "key": ',keyy,' }'); ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"success", "ErrorCode": 0, "message":"¡Pedido no encontrado!" }'); END IF; END /$$ DELIMITER ; /* Procedure structure for procedure `PedidoCrear` / /!50003 DROP PROCEDURE IF EXISTS `PedidoCrear` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `PedidoCrear`( IN keyy INT, IN Cliente INT, IN SubTotal FLOAT, IN Iva FLOAT, IN Total FLOAT, IN Estatus INT, IN Numeroguia VARCHAR(45), IN DatosEnvio INT, IN DatosFacturacion INT, OUT RESULT TEXT ) BEGIN IF(keyy IS NULL ) THEN -- PEDIDO NUEVO INSERT INTO t04_pedido( `t04_pk01`, `t04_f001`, `t04_f002`, `t04_f003`, `t04_f004`, `t04_f005`, `t01_pk01`, `t02_pk01`, `t03_pk01`, `t04_f098`, `t04_f099` )VALUES( NULL, SubTotal, Iva, Total, Estatus, Numeroguia, Cliente, DatosEnvio, DatosFacturacion, NOW(), NOW() ); SELECT MAX(t04_pk01) INTO keyy FROM t04_pedido WHERE t01_pk01 = Cliente; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!", "key": ',keyy,' }'); ELSE -- PEDIDO EXISTENTE SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Actualizado exitosamente!", "key": ',keyy,' }'); END IF; END /$$ DELIMITER ; / Procedure structure for procedure `PedidoDetalleActualizarCantidadItem` / /!50003 DROP PROCEDURE IF EXISTS `PedidoDetalleActualizarCantidadItem` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `PedidoDetalleActualizarCantidadItem`( IN Cantidad FLOAT, IN ItemCode INT, IN Pedido INT, OUT RESULT TEXT ) BEGIN IF(SELECT COUNT() FROM `t04_pedido` WHERE `t04_pk01` = Pedido) > 0 THEN IF(SELECT COUNT() FROM t05_pedido_detalle WHERE `t04_pk01` = Pedido AND `t06_pk01` = ItemCode) <= 0 THEN SET RESULT = CONCAT(' { "error": true, "typeError":"danger", "ErrorCode": 0, "message":"¡El articulo no ha sido agregado aun al pedido solicitado!" }'); ELSE UPDATE t05_pedido_detalle SET t05_f004 = Cantidad WHERE t04_pk01 = Pedido AND t06_pk01 = ItemCode; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Actualziado exitosamente!" }'); END IF; ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"danger", "ErrorCode": 0, "message":"¡No existe el pedido solicitado!" }'); END IF; END /$$ DELIMITER ; / Procedure structure for procedure `PedidoDetalleAgregar` / /!50003 DROP PROCEDURE IF EXISTS `PedidoDetalleAgregar` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `PedidoDetalleAgregar`( IN key_ INT, IN Subtotal FLOAT, IN Iva FLOAT, IN Total FLOAT, IN Cantidad FLOAT, IN Estatus INT, IN ItemCode INT, IN Pedido INT, IN PrecioUnitario FLOAT, OUT RESULT TEXT ) BEGIN DECLARE SUBTOTAL FLOAT; DECLARE TOTALIVA FLOAT; DECLARE TOTAL FLOAT; SET SUBTOTAL = 0; SET TOTALIVA = 0; SET TOTAL = 0; IF(SELECT COUNT() FROM `t04_pedido` WHERE `t04_pk01` = Pedido) > 0 THEN IF(SELECT COUNT() FROM t05_pedido_detalle WHERE `t04_pk01` = Pedido AND `t06_pk01` = ItemCode) <= 0 THEN INSERT INTO t05_pedido_detalle( `t05_pk01`, `t05_f001`, `t05_f002`, `t05_f003`, `t05_f004`, `t05_f005`, `t05_f006`, `t06_pk01`, `t04_pk01`, `t05_f098`, `t05_f099` )VALUES( NULL, PrecioUnitario * Cantidad, PrecioUnitario * Cantidad * Iva, PrecioUnitario * Cantidad + PrecioUnitario * Cantidad * Iva, Cantidad, Estatus, PrecioUnitario, ItemCode, Pedido, NOW(), NOW() ); SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!" }'); ELSE UPDATE t05_pedido_detalle SET t05_f001 = PrecioUnitario * (t05_f004 + Cantidad), t05_f002 = PrecioUnitario * (t05_f004 + Cantidad) * Iva, t05_f003 = PrecioUnitario * (t05_f004 + Cantidad) + PrecioUnitario * (t05_f004 + Cantidad) * Iva, t05_f004 = t05_f004 + Cantidad, t05_f099 = NOW() WHERE t04_pk01 = Pedido AND t06_pk01 = ItemCode; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!" }'); END IF; -- UPDATE CANTIDADES SELECT SUM(t05_f001) INTO SUBTOTAL FROM t05_pedido_detalle WHERE `t04_pk01` = Pedido; SELECT SUM(t05_f002) INTO TOTALIVA FROM t05_pedido_detalle WHERE `t04_pk01` = Pedido; SELECT SUM(t05_f003) INTO TOTAL FROM t05_pedido_detalle WHERE `t04_pk01` = Pedido; UPDATE t04_pedido SET t04_f001 = SUBTOTAL, t04_f002 = TOTALIVA, t04_f003 = TOTAL, t03_f099 = NOW() WHERE t04_pk01 = Pedido; ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"danger", "ErrorCode": 0, "message":"¡No existe el pedido solicitado!" }'); END IF; END /$$ DELIMITER ; / Procedure structure for procedure `PedidoDetalleEliminarItem` / /!50003 DROP PROCEDURE IF EXISTS `PedidoDetalleEliminarItem` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `PedidoDetalleEliminarItem`( IN ItemCode INT, IN Pedido INT, OUT RESULT TEXT ) BEGIN IF(SELECT COUNT() FROM `t04_pedido` WHERE `t04_pk01` = Pedido) > 0 THEN IF(SELECT COUNT() FROM t05_pedido_detalle WHERE `t04_pk01` = Pedido AND `t06_pk01` = ItemCode) <= 0 THEN SET RESULT = CONCAT(' { "error": true, "typeError":"danger", "ErrorCode": 0, "message":"¡El articulo no ha sido agregado aun al pedido solicitado!" }'); ELSE DELETE FROM t05_pedido_detalle WHERE t04_pk01 = Pedido AND t06_pk01 = ItemCode; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Eliminado exitosamente!" }'); END IF; ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"danger", "ErrorCode": 0, "message":"¡No existe el pedido solicitado!" }'); END IF; END /$$ DELIMITER ; / Procedure structure for procedure `ProductoComentarios` / /!50003 DROP PROCEDURE IF EXISTS `ProductoComentarios` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `ProductoComentarios`( IN ComentariosKey INT, IN Titulo NVARCHAR(45), IN Descripcion TEXT, IN TotalEstrellas INT, IN ClienteKey INT, IN ProductoKey INT, OUT Result TEXT ) BEGIN IF(SELECT COUNT() FROM t09_comentarios_producto WHERE t09_pk01 = ComentariosKey) <= 0 THEN INSERT INTO t09_comentarios_producto VALUES( NULL, Titulo, Descripcion, TotalEstrellas, ClienteKey, ProductoKey, NOW(), NOW() ); SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!" }'); ELSE SET RESULT = CONCAT(' { "error": true, "typeError":"danger", "ErrorCode": 0, "message":"¡Existe un registro con el mismo identificador, por favor contactanos!" }'); END IF; END /$$ DELIMITER ; /* Procedure structure for procedure `ProductoCrear` / /!50003 DROP PROCEDURE IF EXISTS `ProductoCrear` /; DELIMITER $$ /!50003 CREATE DEFINER=`dly_ecommerce`@`201.116.205.18` PROCEDURE `ProductoCrear`( IN ProductoKey INT, IN Codigo NVARCHAR(45), IN Descripcion NVARCHAR(100), IN Img TEXT, IN Ancho FLOAT, IN Alto FLOAT, IN Grosor FLOAT, IN Existencia INT , IN Precio FLOAT, IN CategoriaKey INT, IN ProveedorKey INT, IN UnidadMedidaKey INT, OUT RESULT TEXT ) BEGIN IF(SELECT COUNT() FROM t06_productos WHERE t06_pk01 = ProductoKey) <= 0 THEN INSERT INTO t06_productos VALUES( NULL, Codigo, Descripcion, Img, Ancho, Alto, Grosor, Existencia, Precio, CategoriaKey, ProveedorKey, UnidadMedidaKey, NOW(), NOW() ); SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Registrado exitosamente!" }'); ELSE UPDATE t06_productos SET t06_f001 = Codigo, t06_f002 = Descripcion, t06_f003 = Img, t06_f004 = Ancho, t06_f005 = Alto, t06_f006 = Grosor, t06_f007 = Existencia, t06_f008 = Precio, t10_pk01 = UnidadMedidaKey, t07_pk01 = CategoriaKey, t08_pk01 = ProveedorKey, t06_f099 = NOW() WHERE t06_pk01 = ProductoKey; SET RESULT = CONCAT(' { "error": false, "typeError":"success", "ErrorCode": 0, "message":"¡Actualizado exitosamente!" }'); END IF; END /$$ DELIMITER ; /Table structure for table `list_detalle_pedido` / DROP TABLE IF EXISTS `list_detalle_pedido`; /!50001 DROP VIEW IF EXISTS `list_detalle_pedido` /; /!50001 DROP TABLE IF EXISTS `list_detalle_pedido` /; /!50001 CREATE TABLE `list_detalle_pedido`( `t04_pk01` int(11) , `t04_f001` float , `t04_f002` float , `t04_f003` float , `t04_f098` timestamp , `t05_pk01` int(11) , `t05_f001` float , `t05_f002` float , `t05_f003` float , `t05_f004` int(11) , `t05_f006` float , `t06_pk01` int(11) , `t06_f001` varchar(45) , `t06_f002` varchar(100) , `t06_f003` text , `t06_f007` int(11) , `t06_f008` float )/; /Table structure for table `list_producto_comentarios` / DROP TABLE IF EXISTS `list_producto_comentarios`; /!50001 DROP VIEW IF EXISTS `list_producto_comentarios` /; /!50001 DROP TABLE IF EXISTS `list_producto_comentarios` /; /!50001 CREATE TABLE `list_producto_comentarios`( `t09_pk01` int(11) , `t09_f001` varchar(45) , `t09_f002` text , `t09_f003` int(11) , `t01_pk01` int(11) , `t06_pk01` int(11) , `nombre` varchar(91) )/; /Table structure for table `list_producto_ranking` / DROP TABLE IF EXISTS `list_producto_ranking`; /!50001 DROP VIEW IF EXISTS `list_producto_ranking` /; /!50001 DROP TABLE IF EXISTS `list_producto_ranking` /; /!50001 CREATE TABLE `list_producto_ranking`( `t06_pk01` bigint(11) , `Ranking` decimal(35,2) , `TotalComentarios` bigint(21) )/; /View structure for view list_detalle_pedido / /!50001 DROP TABLE IF EXISTS `list_detalle_pedido` /; /!50001 DROP VIEW IF EXISTS `list_detalle_pedido` /; /!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`dly_ecommerce`@`201.116.205.18` SQL SECURITY DEFINER VIEW `list_detalle_pedido` AS select `t04`.`t04_pk01` AS `t04_pk01`,`t04`.`t04_f001` AS `t04_f001`,`t04`.`t04_f002` AS `t04_f002`,`t04`.`t04_f003` AS `t04_f003`,`t04`.`t04_f098` AS `t04_f098`,`t05`.`t05_pk01` AS `t05_pk01`,`t05`.`t05_f001` AS `t05_f001`,`t05`.`t05_f002` AS `t05_f002`,`t05`.`t05_f003` AS `t05_f003`,`t05`.`t05_f004` AS `t05_f004`,`t05`.`t05_f006` AS `t05_f006`,`t06`.`t06_pk01` AS `t06_pk01`,`t06`.`t06_f001` AS `t06_f001`,`t06`.`t06_f002` AS `t06_f002`,`t06`.`t06_f003` AS `t06_f003`,`t06`.`t06_f007` AS `t06_f007`,`t06`.`t06_f008` AS `t06_f008` from ((`t04_pedido` `t04` join `t05_pedido_detalle` `t05` on((`t04`.`t04_pk01` = `t05`.`t04_pk01`))) join `t06_productos` `t06` on((`t05`.`t06_pk01` = `t06`.`t06_pk01`))) /; /View structure for view list_producto_comentarios / /!50001 DROP TABLE IF EXISTS `list_producto_comentarios` /; /!50001 DROP VIEW IF EXISTS `list_producto_comentarios` /; /!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`dly_ecommerce`@`201.116.205.18` SQL SECURITY DEFINER VIEW `list_producto_comentarios` AS select `t09`.`t09_pk01` AS `t09_pk01`,`t09`.`t09_f001` AS `t09_f001`,`t09`.`t09_f002` AS `t09_f002`,`t09`.`t09_f003` AS `t09_f003`,`t09`.`t01_pk01` AS `t01_pk01`,`t09`.`t06_pk01` AS `t06_pk01`,(select concat(`t01`.`t01_f001`,' ',`t01`.`t01_f002`) from `t01_cliente` `t01` where (`t01`.`t01_pk01` = `t09`.`t01_pk01`)) AS `nombre` from `t09_comentarios_producto` `t09` /; /View structure for view list_producto_ranking / /!50001 DROP TABLE IF EXISTS `list_producto_ranking` /; /!50001 DROP VIEW IF EXISTS `list_producto_ranking` /; /!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`dly_ecommerce`@`201.116.205.18` SQL SECURITY DEFINER VIEW `list_producto_ranking` AS select `t09_comentarios_producto`.`t06_pk01` AS `t06_pk01`,round((sum(`t09_comentarios_producto`.`t09_f003`) / count(0)),2) AS `Ranking`,count(0) AS `TotalComentarios` from `t09_comentarios_producto` /; /!40101 SET SQL_MODE=@OLD_SQL_MODE /; /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /; /!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /; /!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;

| ver. 1.4 | Github | . | PHP 8.2.22 | Генерация страницы: 0 | proxy | phpinfo | Настройка