Software: Apache. PHP/5.3.29 uname -a: Linux tardis23.nocplanet.net 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024
Safe-mode: OFF (not secure) /home/memoriacel/public_html/2018/panel/backups/ drwxr-xr-x | |
| Viewing file: Select action/file-type: --
-- Structure for the table atributo_producto
--
DROP TABLE IF EXISTS `atributo_producto`;
CREATE TABLE `atributo_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(50) NOT NULL,
`nombre_web` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Data dump for the table atributo_producto
--
INSERT INTO `atributo_producto` VALUES
("1","Color","Color");
--
-- Structure for the table caracteristica
--
DROP TABLE IF EXISTS `caracteristica`;
CREATE TABLE `caracteristica` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Data dump for the table caracteristica
--
INSERT INTO `caracteristica` VALUES
("1","Tiempo de ciclo"),
("2","Longitud del cable");
--
-- Structure for the table categoria
--
DROP TABLE IF EXISTS `categoria`;
CREATE TABLE `categoria` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nivel` int(11) NOT NULL,
`nombre` varchar(150) NOT NULL,
`id_padre` int(11) NOT NULL,
`destacado` varchar(10) NOT NULL,
`orden` int(11) NOT NULL,
`suspendido` varchar(2) NOT NULL DEFAULT 'no',
`color` varchar(10) NOT NULL,
`visible` varchar(10) NOT NULL,
`color_interior` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Structure for the table categoria_clasificado
--
DROP TABLE IF EXISTS `categoria_clasificado`;
CREATE TABLE `categoria_clasificado` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nivel` int(11) NOT NULL,
`nombre` varchar(150) NOT NULL,
`id_padre` int(11) NOT NULL,
`destacado` varchar(10) NOT NULL,
`orden` int(11) NOT NULL,
`suspendido` varchar(2) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table categoria_cliente
--
DROP TABLE IF EXISTS `categoria_cliente`;
CREATE TABLE `categoria_cliente` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_padre` int(11) NOT NULL,
`nombre` varchar(50) NOT NULL,
`menu` varchar(2) NOT NULL,
`icono` varchar(50) NOT NULL,
`visible` varchar(10) NOT NULL DEFAULT 'no',
`footer` varchar(10) NOT NULL,
`descripcion` text NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `id_2` (`id`),
KEY `id_3` (`id`),
KEY `id_padre` (`id_padre`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
--
-- Data dump for the table categoria_cliente
--
INSERT INTO `categoria_cliente` VALUES
("24","0","test","","","si","","","1"),
("25","0","test con subs","","","si","","test con subs","3"),
("26","25","test con subs","","","si","","test con subs","0"),
("27","25","sub +1","","","si","","","0"),
("28","25","sub +1","","","si","","","0"),
("29","25","sub +1","","","si","","","0"),
("30","0","test con autogenerar modulos","","","si","","test con autogenerar modulos","2"),
("31","0","Natatorios","","","si","","","4"),
("32","31","Robots Limpiadores","","","si","","","0");
--
-- Structure for the table clasificado
--
DROP TABLE IF EXISTS `clasificado`;
CREATE TABLE `clasificado` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_categoria` int(11) NOT NULL,
`titulo` varchar(150) NOT NULL,
`email` varchar(200) NOT NULL,
`detalle` text NOT NULL,
`destacado` varchar(2) NOT NULL,
`fecha` date NOT NULL,
`imagen` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table clima
--
DROP TABLE IF EXISTS `clima`;
CREATE TABLE `clima` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL,
`json` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table color
--
DROP TABLE IF EXISTS `color`;
CREATE TABLE `color` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(50) NOT NULL,
`valor` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Data dump for the table color
--
INSERT INTO `color` VALUES
("1","Blanco","fff"),
("2","Rojo","ff0000");
--
-- Structure for the table consulta
--
DROP TABLE IF EXISTS `consulta`;
CREATE TABLE `consulta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL,
`email` varchar(200) NOT NULL,
`mensaje` text NOT NULL,
`tipo` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
--
-- Data dump for the table consulta
--
INSERT INTO `consulta` VALUES
("1","2017-01-03 14:37:25","posicionamiento@creadoresdesitios.com.ar","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Ignacio Martinez\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: Tandil\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: posicionamiento@creadoresdesitios.com.ar\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 123\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: 123\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto"),
("2","2017-01-03 14:41:01","posicionamiento@creadoresdesitios.com.ar","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Ignacio Martinez\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: Tandil\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: posicionamiento@creadoresdesitios.com.ar\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 123\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: 123\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto"),
("3","2017-01-03 14:43:29","posicionamiento@creadoresdesitios.com.ar","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Ignacio Martinez\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: Tandil\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: posicionamiento@creadoresdesitios.com.ar\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 123\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: 123\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto"),
("4","2017-01-03 14:45:49","posicionamiento@creadoresdesitios.com.ar","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Ignacio Martinez\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: Tandil\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: posicionamiento@creadoresdesitios.com.ar\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 123\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: 123\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto"),
("5","2017-01-03 14:53:58","tuvieja@gmail.com","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Ignacio Martinez\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: Tandil\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: tuvieja@gmail.com\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 123\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: test asd\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto"),
("6","2017-01-03 14:58:45","tengotodalaguita@microsoft.com","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Bill Gates\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: New York\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: tengotodalaguita@microsoft.com\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 123123123\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: Test de spam\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto"),
("7","2017-02-24 11:56:45","posicionamiento@creadoresdesitios.com.ar","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Ignacio Martinez\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: Tandil\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: posicionamiento@creadoresdesitios.com.ar\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 1231231\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: test\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto"),
("8","2017-02-24 11:57:18","posicionamiento@creadoresdesitios.com.ar","\r\n<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Transitional//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\\\">\r\n<html xmlns=\\\"http://www.w3.org/1999/xhtml\\\">\r\n<head>\r\n<meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html; charset=UTF-8\\\" />\r\n<title>Ghezan</title>\r\n<meta name=\\\"viewport\\\" content=\\\"width=device-width, initial-scale=1.0\\\"/>\r\n</head>\r\n<body style=\\\"margin: 0; padding: 0;\\\">\r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\"> \r\n <tr>\r\n <td style=\\\"padding: 10px 0 30px 0;\\\">\r\n <table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"600\\\" style=\\\"border: 1px solid #cccccc; border-collapse: collapse;\\\">\r\n <tr>\r\n <td bgcolor=\\\"#041639\\\" style=\\\"padding: 15px; color: #153643; font-size: 28px; font-weight: bold; font-family: Arial, sans-serif;\\\">\r\n <img src=\\\"http://notebookcds/ghezan/mail/logo.png\\\" alt=\\\"Ghezan\\\" width=\\\"402\\\" height=\\\"134\\\" style=\\\"display: block;\\\" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td bgcolor=\\\"#ffffff\\\" style=\\\"padding: 40px 30px 40px 30px;\\\">\r\n \r\n <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" width=\\\"100%\\\">\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #1a888b; font-family: Arial, sans-serif; font-size: 18px;\\\">\r\n <b>Nueva consulta desde Ghezan!</b>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Nombre: Ignacio Martinez\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Ciudad: Tandil\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Email: posicionamiento@creadoresdesitios.com.ar\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Teléfono: 1231231\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style=\\\"padding: 0px 0 10px 0; color: #153643; font-family: Arial, sans-serif; font-size: 12px; line-height: 20px;\\\">\r\n Consulta: test\r\n </td>\r\n </tr>\r\n\r\n \r\n </td>\r\n </tr> \r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n\r\n\r\n</body>\r\n</html>\r\n","consulta desde contacto");
--
-- Structure for the table consulta_clasificado
--
DROP TABLE IF EXISTS `consulta_clasificado`;
CREATE TABLE `consulta_clasificado` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_clasificado` int(11) NOT NULL,
`nombre` varchar(100) NOT NULL,
`email` varchar(150) NOT NULL,
`consulta` text NOT NULL,
`fecha` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table cupon
--
DROP TABLE IF EXISTS `cupon`;
CREATE TABLE `cupon` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(200) NOT NULL,
`fecha_inicio` date NOT NULL,
`fecha_fin` date NOT NULL,
`tipo` varchar(20) NOT NULL,
`valor` decimal(9,2) NOT NULL,
`codigo` varchar(200) NOT NULL,
`stock` int(11) NOT NULL,
`compra_minima` decimal(9,2) NOT NULL,
`estado` varchar(20) NOT NULL DEFAULT 'visible',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Data dump for the table cupon
--
INSERT INTO `cupon` VALUES
("1","cupon 1","2016-12-26","2016-12-30","%","10.00","123","100","500.00","visible");
--
-- Structure for the table datos_panel
--
DROP TABLE IF EXISTS `datos_panel`;
CREATE TABLE `datos_panel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titulo` varchar(250) NOT NULL,
`color_titulo` varchar(10) NOT NULL,
`color_boton` varchar(10) NOT NULL,
`texto_footer` text NOT NULL,
`color_texto_footer` varchar(10) NOT NULL,
`mercadopago` varchar(100) NOT NULL,
`frase_inicio` varchar(200) NOT NULL,
`color_fondo_logo` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Data dump for the table datos_panel
--
INSERT INTO `datos_panel` VALUES
("1","Gestor de contenidos","333333","006300","Ghezan Hnos.","fff","Sandbox","Productos destacados 2","17437a");
--
-- Structure for the table edicion_impresa
--
DROP TABLE IF EXISTS `edicion_impresa`;
CREATE TABLE `edicion_impresa` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` date NOT NULL,
`foto` varchar(30) NOT NULL,
`pdf` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table empresa
--
DROP TABLE IF EXISTS `empresa`;
CREATE TABLE `empresa` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(200) NOT NULL,
`cuit` varchar(50) NOT NULL,
`telefono` varchar(100) NOT NULL,
`email` varchar(150) NOT NULL,
`ciudad` varchar(200) NOT NULL,
`nombre_contacto` varchar(200) NOT NULL,
`email_contacto` varchar(150) NOT NULL,
`telefono_contacto` varchar(100) NOT NULL,
`ciudad_contacto` varchar(200) NOT NULL,
`nombre_web` varchar(200) NOT NULL,
`direccion_web` varchar(200) NOT NULL,
`telefono_web` varchar(100) NOT NULL,
`email_web` varchar(150) NOT NULL,
`logo` varchar(50) NOT NULL,
`tipo_precio` varchar(30) NOT NULL,
`url_precio_externo` varchar(200) NOT NULL,
`user_precio_externo` varchar(100) NOT NULL,
`clave_precio_externo` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table encuesta
--
DROP TABLE IF EXISTS `encuesta`;
CREATE TABLE `encuesta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titulo` varchar(200) NOT NULL,
`fecha` date NOT NULL,
`estado` varchar(20) NOT NULL DEFAULT 'visible',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table estadisticas_amplia_noticia
--
DROP TABLE IF EXISTS `estadisticas_amplia_noticia`;
CREATE TABLE `estadisticas_amplia_noticia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL,
`ip` varchar(30) NOT NULL,
`id_noticia` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table estadisticas_busqueda
--
DROP TABLE IF EXISTS `estadisticas_busqueda`;
CREATE TABLE `estadisticas_busqueda` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`busqueda` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
--
-- Data dump for the table estadisticas_busqueda
--
INSERT INTO `estadisticas_busqueda` VALUES
("1","2016-12-06 11:44:57","test2"),
("2","2016-12-06 11:45:54","test2"),
("3","2016-12-06 11:49:36","test2"),
("4","2016-12-06 11:50:58","test2"),
("5","2016-12-06 11:51:00","test2"),
("6","2016-12-06 11:51:07","test2"),
("7","2016-12-06 11:59:13","test2"),
("8","2016-12-06 11:59:29","test2"),
("9","2016-12-06 12:03:12","test2"),
("10","2016-12-06 12:04:59","test2"),
("11","2016-12-06 12:05:04","test2"),
("12","2016-12-06 12:05:06","test2"),
("13","2016-12-06 12:05:07","test2"),
("14","2016-12-06 12:05:08","test2"),
("15","2016-12-06 12:06:29","test2"),
("16","2016-12-06 12:07:30","te"),
("17","2016-12-06 12:07:34","test2"),
("18","2016-12-06 12:16:27","test2"),
("19","2016-12-12 11:52:36","test"),
("20","2016-12-12 11:54:26","test dos"),
("21","2016-12-12 13:48:50","test"),
("22","2016-12-12 13:50:33","test"),
("23","2016-12-12 13:55:17","test"),
("24","2016-12-13 11:34:20","tes"),
("25","2016-12-13 11:40:32","tes"),
("26","2016-12-26 08:19:08","test"),
("27","2016-12-26 08:19:16","test"),
("28","2016-12-26 14:28:48","etiqueta"),
("29","2016-12-27 16:53:24","Dolphin Diagnostic"),
("30","2016-12-28 13:55:24","asd"),
("31","2017-02-24 14:04:02","test2");
--
-- Structure for the table estadisticas_categoria
--
DROP TABLE IF EXISTS `estadisticas_categoria`;
CREATE TABLE `estadisticas_categoria` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`id_categoria` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_ec_id_categoria` (`id_categoria`),
CONSTRAINT `fk_ec_id_categoria` FOREIGN KEY (`id_categoria`) REFERENCES `categoria_cliente` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=438 DEFAULT CHARSET=latin1;
--
-- Data dump for the table estadisticas_categoria
--
INSERT INTO `estadisticas_categoria` VALUES
("62","2016-12-05 15:54:09","24"),
("63","2016-12-05 15:55:07","24"),
("64","2016-12-05 15:55:44","24"),
("65","2016-12-05 15:55:58","24"),
("66","2016-12-05 15:56:30","24"),
("67","2016-12-05 15:57:36","24"),
("68","2016-12-06 09:34:42","24"),
("70","2016-12-06 09:35:11","24"),
("71","2016-12-06 09:35:39","24"),
("72","2016-12-06 09:36:02","24"),
("74","2016-12-06 10:51:04","24"),
("75","2016-12-06 10:59:20","24"),
("76","2016-12-06 10:59:34","24"),
("77","2016-12-06 10:59:44","24"),
("78","2016-12-06 11:00:28","24"),
("79","2016-12-06 11:02:19","24"),
("80","2016-12-06 11:05:25","24"),
("81","2016-12-06 11:05:47","24"),
("82","2016-12-06 11:06:59","24"),
("83","2016-12-06 11:07:39","24"),
("84","2016-12-06 11:07:44","26"),
("85","2016-12-06 11:07:44","24"),
("86","2016-12-06 11:07:51","24"),
("87","2016-12-06 11:07:54","26"),
("88","2016-12-06 11:08:06","24"),
("89","2016-12-06 11:08:43","26"),
("90","2016-12-06 11:08:46","24"),
("91","2016-12-06 11:08:48","24"),
("92","2016-12-06 11:09:06","26"),
("93","2016-12-06 11:16:51","26"),
("94","2016-12-06 11:18:26","26"),
("95","2016-12-06 11:20:00","26"),
("96","2016-12-06 11:20:19","26"),
("98","2016-12-06 11:20:37","24"),
("99","2016-12-06 11:21:29","24"),
("100","2016-12-06 11:21:29","24"),
("101","2016-12-06 11:21:41","24"),
("102","2016-12-06 11:21:45","24"),
("103","2016-12-06 11:21:58","24"),
("104","2016-12-06 11:22:14","24"),
("105","2016-12-06 11:23:46","24"),
("106","2016-12-06 11:24:23","24"),
("107","2016-12-06 11:24:23","24"),
("108","2016-12-06 11:24:36","24"),
("109","2016-12-06 11:33:39","24"),
("110","2016-12-06 11:34:07","24"),
("111","2016-12-06 11:36:32","24"),
("112","2016-12-06 11:37:40","24"),
("113","2016-12-06 11:37:42","24"),
("114","2016-12-06 11:37:43","24"),
("115","2016-12-06 11:37:43","24"),
("116","2016-12-06 11:38:11","24"),
("117","2016-12-06 11:38:17","24"),
("118","2016-12-06 11:38:21","24"),
("119","2016-12-06 11:38:21","24"),
("120","2016-12-06 11:38:21","24"),
("121","2016-12-06 11:38:24","24"),
("122","2016-12-06 11:38:25","24"),
("123","2016-12-06 11:40:59","24"),
("124","2016-12-06 11:41:24","24"),
("125","2016-12-06 11:44:40","24"),
("126","2016-12-06 11:57:15","24"),
("127","2016-12-06 11:58:35","24"),
("128","2016-12-06 11:58:45","24"),
("129","2016-12-06 11:58:48","24"),
("130","2016-12-06 11:59:03","24"),
("131","2016-12-06 11:59:09","24"),
("132","2016-12-06 11:59:19","24"),
("133","2016-12-06 11:59:20","24"),
("134","2016-12-06 11:59:21","24"),
("135","2016-12-06 11:59:21","24"),
("136","2016-12-06 11:59:22","24"),
("137","2016-12-06 11:59:22","24"),
("138","2016-12-06 11:59:22","24"),
("139","2016-12-06 11:59:22","24"),
("140","2016-12-06 12:01:00","24"),
("141","2016-12-06 12:01:00","24"),
("142","2016-12-06 12:01:43","24"),
("143","2016-12-06 12:03:07","24"),
("144","2016-12-06 12:03:08","24"),
("145","2016-12-06 12:03:08","24"),
("146","2016-12-06 12:03:11","24"),
("147","2016-12-06 12:05:04","24"),
("148","2016-12-06 12:05:07","24"),
("149","2016-12-06 12:05:08","24"),
("150","2016-12-06 12:06:30","24"),
("151","2016-12-06 12:10:20","24"),
("152","2016-12-06 12:12:30","24"),
("153","2016-12-06 12:13:40","24"),
("154","2016-12-06 13:17:59","24"),
("155","2016-12-06 13:18:13","27"),
("156","2016-12-06 13:33:41","24"),
("157","2016-12-06 13:57:27","24"),
("158","2016-12-06 14:03:13","24"),
("159","2016-12-06 14:12:14","24"),
("160","2016-12-06 14:30:18","24"),
("161","2016-12-06 14:54:52","24"),
("162","2016-12-06 14:55:02","24"),
("163","2016-12-06 14:55:35","27"),
("164","2016-12-06 14:55:40","26"),
("165","2016-12-07 08:34:37","24"),
("166","2016-12-07 09:49:47","24"),
("167","2016-12-07 10:16:09","24"),
("168","2016-12-07 10:54:58","24"),
("169","2016-12-07 14:43:23","24"),
("170","2016-12-07 14:43:23","24"),
("171","2016-12-07 14:45:14","24"),
("172","2016-12-07 14:56:07","24"),
("173","2016-12-07 15:02:21","24"),
("174","2016-12-07 15:02:31","24"),
("175","2016-12-07 15:20:42","24"),
("176","2016-12-07 15:22:00","24"),
("177","2016-12-07 15:24:03","24"),
("178","2016-12-12 12:00:04","24"),
("179","2016-12-12 12:21:00","24"),
("180","2016-12-12 13:03:01","24"),
("181","2016-12-12 13:31:22","24"),
("182","2016-12-12 13:36:02","24"),
("183","2016-12-12 13:41:06","24"),
("184","2016-12-12 13:41:38","24"),
("185","2016-12-12 13:47:55","24"),
("186","2016-12-12 13:50:21","24"),
("187","2016-12-12 13:50:36","24"),
("188","2016-12-12 13:55:14","24"),
("189","2016-12-12 14:42:11","24"),
("190","2016-12-12 14:42:58","24"),
("191","2016-12-12 14:44:14","24"),
("192","2016-12-12 14:45:32","24"),
("193","2016-12-12 14:46:38","24"),
("194","2016-12-12 14:46:57","24"),
("195","2016-12-12 14:47:05","24"),
("196","2016-12-12 14:53:44","24"),
("197","2016-12-12 14:54:41","24"),
("198","2016-12-12 14:55:00","24"),
("199","2016-12-12 14:55:22","24"),
("200","2016-12-12 15:08:58","24"),
("201","2016-12-12 15:50:02","24"),
("202","2016-12-12 15:50:56","24"),
("203","2016-12-12 15:54:49","24"),
("204","2016-12-12 15:56:26","24"),
("205","2016-12-12 15:56:47","24"),
("206","2016-12-12 15:57:05","24"),
("207","2016-12-12 15:57:07","24"),
("208","2016-12-12 15:57:12","24"),
("209","2016-12-12 16:02:57","24"),
("210","2016-12-12 16:03:03","24"),
("211","2016-12-12 16:03:22","24"),
("212","2016-12-12 16:12:08","24"),
("213","2016-12-12 16:12:17","24"),
("214","2016-12-12 16:12:22","24"),
("215","2016-12-12 16:13:06","24"),
("216","2016-12-12 16:13:09","24"),
("217","2016-12-12 16:13:14","24"),
("218","2016-12-12 16:13:17","24"),
("219","2016-12-12 16:14:30","24"),
("220","2016-12-12 16:14:59","24"),
("221","2016-12-12 16:15:03","24"),
("222","2016-12-12 16:15:06","24"),
("223","2016-12-12 16:15:55","24"),
("224","2016-12-12 16:15:58","24"),
("225","2016-12-12 16:16:02","24"),
("226","2016-12-12 16:16:05","24"),
("227","2016-12-12 16:17:48","24"),
("228","2016-12-12 16:17:54","24"),
("229","2016-12-12 16:48:50","24"),
("230","2016-12-12 16:58:04","24"),
("231","2016-12-12 16:58:06","30"),
("232","2016-12-13 11:27:49","24"),
("233","2016-12-13 11:33:54","24"),
("234","2016-12-13 11:34:00","24"),
("235","2016-12-13 11:40:45","24"),
("236","2016-12-13 11:45:24","24"),
("237","2016-12-13 11:45:56","24"),
("238","2016-12-13 11:46:00","24"),
("239","2016-12-13 11:46:28","24"),
("240","2016-12-13 11:46:49","24"),
("243","2016-12-13 11:48:03","24"),
("244","2016-12-13 11:48:10","24"),
("245","2016-12-13 11:49:26","24"),
("246","2016-12-13 11:49:30","24"),
("247","2016-12-13 11:49:34","24"),
("248","2016-12-13 11:55:06","24"),
("249","2016-12-13 11:55:17","24"),
("250","2016-12-13 11:55:21","24"),
("251","2016-12-13 11:55:26","24"),
("252","2016-12-13 11:58:25","24"),
("253","2016-12-13 11:58:40","24"),
("254","2016-12-13 12:14:38","24"),
("255","2016-12-13 12:14:49","24"),
("256","2016-12-13 12:17:06","24"),
("257","2016-12-13 12:17:52","24"),
("258","2016-12-13 12:18:29","24"),
("259","2016-12-13 12:20:21","24"),
("260","2016-12-13 12:20:42","24"),
("261","2016-12-13 12:20:51","24"),
("262","2016-12-13 12:24:34","24"),
("263","2016-12-13 12:24:36","24"),
("264","2016-12-13 12:26:42","24"),
("265","2016-12-13 12:27:41","24"),
("266","2016-12-13 12:33:07","24"),
("267","2016-12-13 12:33:08","24"),
("268","2016-12-13 12:36:47","24"),
("269","2016-12-13 12:37:55","24"),
("270","2016-12-13 12:38:01","24"),
("271","2016-12-13 12:38:05","24"),
("272","2016-12-13 12:38:12","24"),
("273","2016-12-13 12:38:19","24"),
("274","2016-12-13 12:38:22","24"),
("275","2016-12-13 12:38:25","24"),
("276","2016-12-13 12:38:31","24"),
("277","2016-12-13 12:38:34","24"),
("278","2016-12-13 12:38:40","24"),
("279","2016-12-13 12:42:52","24"),
("280","2016-12-13 12:42:56","24"),
("281","2016-12-13 12:43:00","24"),
("282","2016-12-13 12:43:03","24"),
("283","2016-12-13 12:53:27","24"),
("284","2016-12-13 12:53:33","24"),
("285","2016-12-13 12:53:35","24"),
("286","2016-12-13 12:54:09","24"),
("287","2016-12-13 12:59:49","24"),
("288","2016-12-13 13:00:20","24"),
("289","2016-12-13 13:00:54","24"),
("290","2016-12-13 13:02:01","24"),
("291","2016-12-13 13:02:04","24"),
("292","2016-12-13 13:02:27","24"),
("293","2016-12-13 13:15:15","24"),
("294","2016-12-13 13:15:20","24"),
("295","2016-12-13 13:16:28","24"),
("296","2016-12-13 14:06:34","24"),
("297","2016-12-13 14:06:55","24"),
("298","2016-12-13 14:07:00","24"),
("299","2016-12-13 14:07:04","24"),
("300","2016-12-13 14:07:28","24"),
("301","2016-12-13 14:07:33","24"),
("302","2016-12-13 14:07:39","24"),
("303","2016-12-13 14:07:44","24"),
("304","2016-12-13 14:07:53","24"),
("305","2016-12-13 14:08:25","24"),
("306","2016-12-13 14:08:40","24"),
("307","2016-12-13 14:09:38","24"),
("308","2016-12-14 13:03:18","24"),
("309","2016-12-14 13:03:43","24"),
("310","2016-12-14 13:20:26","24"),
("312","2016-12-19 10:59:10","24"),
("313","2016-12-19 11:01:02","24"),
("314","2016-12-19 11:19:53","24"),
("315","2016-12-19 11:21:18","24"),
("316","2016-12-19 11:21:51","26"),
("317","2016-12-19 11:22:23","24"),
("318","2016-12-19 11:32:10","24"),
("319","2016-12-19 11:32:13","24"),
("320","2016-12-19 11:32:15","24"),
("321","2016-12-19 11:32:28","24"),
("322","2016-12-19 11:35:54","24"),
("323","2016-12-19 11:37:06","24"),
("324","2016-12-19 11:45:32","24"),
("325","2016-12-19 11:47:42","24"),
("326","2016-12-19 11:48:59","24"),
("327","2016-12-19 11:49:21","24"),
("328","2016-12-19 11:50:12","24"),
("329","2016-12-19 11:50:56","24"),
("330","2016-12-19 11:51:18","24"),
("331","2016-12-19 11:52:19","24"),
("332","2016-12-19 11:53:15","24"),
("333","2016-12-19 11:53:31","24"),
("334","2016-12-19 11:53:35","24"),
("335","2016-12-19 11:53:36","24"),
("336","2016-12-19 11:53:38","24"),
("337","2016-12-19 11:53:52","24"),
("338","2016-12-19 11:53:52","24"),
("339","2016-12-19 11:54:03","24"),
("340","2016-12-19 11:54:56","24"),
("341","2016-12-19 11:54:59","24"),
("342","2016-12-19 11:55:00","24"),
("343","2016-12-19 11:55:04","26"),
("344","2016-12-19 11:57:43","26"),
("345","2016-12-19 11:58:57","26"),
("346","2016-12-19 11:59:21","26"),
("347","2016-12-19 11:59:57","26"),
("348","2016-12-19 12:01:22","26"),
("349","2016-12-19 12:01:43","26"),
("350","2016-12-19 12:02:31","26"),
("351","2016-12-19 12:03:45","26"),
("352","2016-12-19 12:13:20","24"),
("353","2016-12-19 12:29:10","24"),
("354","2016-12-19 12:39:52","32"),
("355","2016-12-19 12:44:28","32"),
("356","2016-12-19 12:44:58","24"),
("357","2016-12-19 12:45:13","26"),
("358","2016-12-19 12:45:23","27"),
("359","2016-12-19 12:45:27","24"),
("360","2016-12-19 12:49:31","32"),
("361","2016-12-19 12:49:34","24"),
("362","2016-12-19 12:49:37","32"),
("363","2016-12-19 12:49:40","24"),
("364","2016-12-19 12:49:46","30"),
("365","2016-12-19 12:50:00","32"),
("366","2016-12-19 12:50:05","24"),
("367","2016-12-19 12:50:40","32"),
("368","2016-12-19 12:52:01","32"),
("369","2016-12-19 13:01:44","32"),
("370","2016-12-19 13:03:16","32"),
("371","2016-12-19 13:03:20","32"),
("372","2016-12-19 13:03:27","32"),
("373","2016-12-19 13:04:50","32"),
("374","2016-12-19 13:07:34","32"),
("375","2016-12-19 13:11:25","32"),
("376","2016-12-19 13:19:46","32"),
("377","2016-12-19 13:19:47","32"),
("378","2016-12-19 13:20:49","32"),
("379","2016-12-19 13:21:12","32"),
("380","2016-12-19 13:28:44","32"),
("381","2016-12-19 13:29:04","32"),
("382","2016-12-19 13:30:30","24"),
("383","2016-12-19 13:30:41","30"),
("384","2016-12-19 13:30:43","24"),
("385","2016-12-19 13:30:45","30"),
("386","2016-12-19 13:30:45","32"),
("387","2016-12-19 14:57:04","24"),
("388","2016-12-19 14:57:08","26"),
("389","2016-12-19 14:57:12","32"),
("390","2016-12-19 15:41:57","32"),
("391","2016-12-19 15:42:06","32"),
("392","2016-12-19 15:45:05","32"),
("393","2016-12-19 15:51:10","32"),
("394","2016-12-20 10:27:00","32"),
("395","2016-12-20 10:32:45","32"),
("396","2016-12-20 10:32:46","32"),
("398","2016-12-21 09:01:29","32"),
("399","2016-12-21 09:01:37","32"),
("400","2016-12-21 10:09:53","24"),
("401","2016-12-21 14:37:45","32"),
("402","2016-12-21 14:38:19","24"),
("403","2016-12-23 09:14:19","32"),
("404","2016-12-23 09:47:58","32"),
("405","2016-12-26 08:18:55","24"),
("406","2016-12-26 12:50:05","24"),
("407","2016-12-26 13:16:08","32"),
("408","2016-12-26 14:24:50","24"),
("409","2016-12-26 14:24:54","24"),
("410","2016-12-26 14:24:57","24"),
("411","2016-12-26 14:25:01","24"),
("412","2016-12-26 14:29:11","24"),
("413","2016-12-26 14:29:15","24"),
("414","2016-12-26 14:29:23","24"),
("415","2016-12-26 14:29:55","32"),
("416","2016-12-26 15:29:42","32"),
("417","2016-12-26 15:35:57","24"),
("418","2016-12-27 09:36:47","32"),
("419","2016-12-27 09:43:19","32"),
("420","2016-12-27 09:43:35","32"),
("421","2016-12-27 10:31:10","32"),
("422","2016-12-27 16:53:34","32"),
("423","2016-12-27 16:53:39","32"),
("424","2016-12-27 16:53:41","32"),
("425","2016-12-28 08:28:02","32"),
("426","2016-12-28 08:32:17","32"),
("427","2017-01-02 10:51:54","32"),
("428","2017-01-02 15:56:10","24"),
("429","2017-01-03 10:20:19","32"),
("430","2017-01-03 14:50:32","28"),
("431","2017-01-03 14:52:33","32"),
("432","2017-01-09 11:02:48","32"),
("433","2017-01-27 13:47:26","32"),
("434","2017-01-27 14:02:33","24"),
("435","2017-02-02 11:37:54","24"),
("436","2017-02-24 12:04:47","24"),
("437","2017-02-24 12:07:10","30");
--
-- Structure for the table estadisticas_producto
--
DROP TABLE IF EXISTS `estadisticas_producto`;
CREATE TABLE `estadisticas_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL,
`id_producto` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_ep_id_producto` (`id_producto`),
CONSTRAINT `fk_ep_id_producto` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=695 DEFAULT CHARSET=latin1;
--
-- Data dump for the table estadisticas_producto
--
INSERT INTO `estadisticas_producto` VALUES
("82","2016-12-05 15:56:17","40"),
("83","2016-12-05 15:57:38","40"),
("85","2016-12-06 09:35:24","39"),
("86","2016-12-06 09:35:48","40"),
("87","2016-12-06 09:36:11","39"),
("88","2016-12-06 09:45:34","39"),
("89","2016-12-06 09:49:37","39"),
("90","2016-12-06 09:50:55","39"),
("91","2016-12-06 09:53:02","39"),
("92","2016-12-06 09:53:06","39"),
("93","2016-12-06 10:04:40","39"),
("94","2016-12-06 10:04:41","39"),
("95","2016-12-06 10:04:52","39"),
("96","2016-12-06 10:04:52","39"),
("97","2016-12-06 10:05:06","39"),
("98","2016-12-06 10:05:06","39"),
("99","2016-12-06 10:06:58","39"),
("100","2016-12-06 10:46:04","39"),
("101","2016-12-06 12:14:01","39"),
("102","2016-12-06 12:14:05","39"),
("103","2016-12-06 12:19:57","39"),
("104","2016-12-06 12:19:57","39"),
("105","2016-12-06 12:19:59","39"),
("106","2016-12-06 12:20:01","39"),
("107","2016-12-06 12:20:01","39"),
("108","2016-12-06 12:20:02","39"),
("109","2016-12-06 12:20:02","39"),
("110","2016-12-06 12:20:18","39"),
("111","2016-12-06 12:20:19","39"),
("112","2016-12-06 12:20:19","39"),
("113","2016-12-06 12:20:19","39"),
("114","2016-12-06 12:20:19","39"),
("115","2016-12-06 12:20:20","39"),
("116","2016-12-06 12:20:20","39"),
("117","2016-12-06 12:20:20","39"),
("118","2016-12-06 12:20:20","39"),
("119","2016-12-06 12:20:20","39"),
("120","2016-12-06 12:20:20","39"),
("121","2016-12-06 12:20:20","39"),
("122","2016-12-06 12:20:20","39"),
("123","2016-12-06 12:20:20","39"),
("124","2016-12-06 12:20:20","39"),
("125","2016-12-06 12:20:20","39"),
("126","2016-12-06 12:20:20","39"),
("127","2016-12-06 12:20:20","39"),
("128","2016-12-06 12:20:21","39"),
("129","2016-12-06 12:20:21","39"),
("130","2016-12-06 12:20:21","39"),
("131","2016-12-06 12:20:21","39"),
("132","2016-12-06 12:20:32","39"),
("133","2016-12-06 12:21:02","39"),
("134","2016-12-06 12:30:57","39"),
("135","2016-12-06 12:31:00","39"),
("136","2016-12-06 12:31:00","39"),
("137","2016-12-06 12:34:54","39"),
("138","2016-12-06 12:38:00","39"),
("139","2016-12-06 12:38:19","39"),
("140","2016-12-06 12:38:59","39"),
("141","2016-12-06 12:39:07","39"),
("142","2016-12-06 12:41:52","39"),
("143","2016-12-06 12:41:53","39"),
("144","2016-12-06 12:41:53","39"),
("145","2016-12-06 12:42:04","39"),
("146","2016-12-06 12:42:22","39"),
("147","2016-12-06 12:42:38","39"),
("148","2016-12-06 12:43:00","39"),
("149","2016-12-06 12:44:40","39"),
("150","2016-12-06 12:45:30","39"),
("151","2016-12-06 12:51:03","39"),
("152","2016-12-06 12:51:50","39"),
("153","2016-12-06 12:52:10","39"),
("154","2016-12-06 12:52:11","39"),
("155","2016-12-06 12:53:47","39"),
("156","2016-12-06 12:53:49","39"),
("157","2016-12-06 13:01:33","39"),
("158","2016-12-06 13:01:35","39"),
("159","2016-12-06 13:09:08","39"),
("160","2016-12-06 13:17:44","39"),
("161","2016-12-06 13:18:03","40"),
("162","2016-12-06 13:18:07","40"),
("163","2016-12-06 13:18:15","40"),
("164","2016-12-06 13:57:31","39"),
("165","2016-12-06 14:23:55","39"),
("166","2016-12-06 14:29:25","39"),
("167","2016-12-06 14:29:26","39"),
("168","2016-12-06 14:30:14","39"),
("169","2016-12-06 14:30:22","39"),
("170","2016-12-06 14:36:39","39"),
("171","2016-12-06 14:54:55","39"),
("172","2016-12-06 14:55:04","40"),
("173","2016-12-07 09:49:36","39"),
("174","2016-12-07 09:49:50","40"),
("175","2016-12-07 09:55:27","40"),
("176","2016-12-07 10:03:55","40"),
("177","2016-12-07 10:14:41","40"),
("178","2016-12-07 10:16:25","39"),
("179","2016-12-07 10:19:52","39"),
("180","2016-12-07 10:19:57","39"),
("181","2016-12-07 10:22:17","39"),
("182","2016-12-07 10:27:37","39"),
("183","2016-12-07 10:31:34","39"),
("184","2016-12-07 10:31:41","39"),
("185","2016-12-07 10:32:58","39"),
("186","2016-12-07 11:05:10","39"),
("187","2016-12-07 11:18:23","39"),
("188","2016-12-07 15:24:06","39"),
("189","2016-12-07 15:25:34","39"),
("190","2016-12-12 12:40:12","39"),
("191","2016-12-12 12:40:15","39"),
("192","2016-12-13 12:50:03","39"),
("193","2016-12-14 13:03:23","39"),
("194","2016-12-14 13:20:30","39"),
("195","2016-12-19 10:49:09","40"),
("196","2016-12-19 10:55:33","40"),
("197","2016-12-19 10:56:52","40"),
("198","2016-12-19 11:01:12","39"),
("199","2016-12-19 11:04:03","39"),
("200","2016-12-19 11:49:31","39"),
("201","2016-12-19 11:57:41","39"),
("202","2016-12-19 12:18:45","39"),
("203","2016-12-19 12:19:01","39"),
("204","2016-12-19 12:28:59","39"),
("205","2016-12-19 12:36:33","39"),
("206","2016-12-19 12:41:07","39"),
("207","2016-12-19 12:41:38","39"),
("208","2016-12-19 12:45:29","40"),
("209","2016-12-19 12:49:31","39"),
("210","2016-12-19 12:50:15","40"),
("211","2016-12-19 12:50:51","41"),
("212","2016-12-19 12:51:36","40"),
("213","2016-12-19 12:51:47","40"),
("214","2016-12-19 12:52:04","41"),
("215","2016-12-19 12:53:21","40"),
("216","2016-12-19 12:55:46","40"),
("217","2016-12-19 13:03:36","41"),
("218","2016-12-19 13:05:01","41"),
("219","2016-12-19 13:05:04","42"),
("220","2016-12-19 13:06:45","41"),
("221","2016-12-19 13:06:47","42"),
("222","2016-12-19 13:07:46","42"),
("223","2016-12-19 13:07:46","41"),
("224","2016-12-19 13:07:48","42"),
("225","2016-12-19 13:07:52","41"),
("226","2016-12-19 13:07:55","42"),
("227","2016-12-19 13:08:42","42"),
("228","2016-12-19 13:08:42","42"),
("229","2016-12-19 13:11:58","41"),
("230","2016-12-19 13:12:04","42"),
("231","2016-12-19 13:13:47","41"),
("232","2016-12-19 13:16:05","41"),
("233","2016-12-19 13:16:12","41"),
("234","2016-12-19 13:18:34","42"),
("235","2016-12-19 13:19:44","41"),
("236","2016-12-19 13:20:59","41"),
("237","2016-12-19 13:20:59","41"),
("238","2016-12-19 13:21:00","41"),
("239","2016-12-19 13:24:43","41"),
("240","2016-12-19 13:24:44","41"),
("241","2016-12-19 13:26:24","41"),
("242","2016-12-19 13:28:01","41"),
("243","2016-12-19 13:28:46","42"),
("244","2016-12-19 13:29:05","41"),
("245","2016-12-19 13:30:34","40"),
("246","2016-12-19 13:30:53","42"),
("247","2016-12-19 13:30:57","41"),
("248","2016-12-19 13:31:12","41"),
("249","2016-12-19 13:33:10","41"),
("250","2016-12-19 13:34:39","41"),
("251","2016-12-19 13:35:19","41"),
("252","2016-12-19 13:36:08","41"),
("253","2016-12-19 13:40:50","41"),
("254","2016-12-19 13:42:58","41"),
("255","2016-12-19 13:43:02","41"),
("256","2016-12-19 13:44:07","41"),
("257","2016-12-19 13:44:07","41"),
("258","2016-12-19 13:45:08","41"),
("259","2016-12-19 13:45:08","41"),
("260","2016-12-19 13:45:22","41"),
("261","2016-12-19 13:48:47","41"),
("262","2016-12-19 13:48:50","41"),
("263","2016-12-19 13:49:10","41"),
("264","2016-12-19 13:49:10","41"),
("265","2016-12-19 13:49:23","42"),
("266","2016-12-19 13:49:29","41"),
("267","2016-12-19 13:50:19","41"),
("268","2016-12-19 13:50:20","41"),
("269","2016-12-19 13:50:20","41"),
("270","2016-12-19 13:50:20","41"),
("271","2016-12-19 13:50:20","41"),
("272","2016-12-19 13:50:20","41"),
("273","2016-12-19 13:50:20","41"),
("274","2016-12-19 13:53:10","41"),
("275","2016-12-19 13:55:03","41"),
("276","2016-12-19 13:55:22","41"),
("277","2016-12-19 13:57:03","41"),
("278","2016-12-19 14:40:16","41"),
("279","2016-12-19 14:40:20","41"),
("280","2016-12-19 14:41:18","41"),
("281","2016-12-19 14:42:16","41"),
("282","2016-12-19 14:44:52","41"),
("283","2016-12-19 14:57:44","41"),
("284","2016-12-19 15:42:12","41"),
("285","2016-12-19 15:48:37","42"),
("286","2016-12-19 16:10:39","41"),
("287","2016-12-19 16:32:30","42"),
("288","2016-12-19 16:32:49","42"),
("289","2016-12-19 16:32:52","42"),
("290","2016-12-19 17:17:51","42"),
("291","2016-12-20 09:18:52","40"),
("292","2016-12-20 09:18:59","40"),
("293","2016-12-20 09:19:07","40"),
("294","2016-12-20 09:36:36","41"),
("295","2016-12-20 10:18:58","41"),
("296","2016-12-20 10:19:03","41"),
("297","2016-12-20 10:26:30","41"),
("298","2016-12-20 10:26:33","41"),
("299","2016-12-20 10:26:42","41"),
("300","2016-12-20 10:32:51","41"),
("301","2016-12-20 10:33:21","41"),
("302","2016-12-20 10:34:14","41"),
("303","2016-12-20 10:35:14","41"),
("304","2016-12-20 10:35:29","41"),
("305","2016-12-20 10:45:56","41"),
("306","2016-12-20 10:46:37","41"),
("307","2016-12-20 10:46:43","41"),
("308","2016-12-20 10:47:49","41"),
("309","2016-12-20 10:48:32","41"),
("310","2016-12-20 10:49:02","41"),
("311","2016-12-20 10:49:02","41"),
("312","2016-12-20 10:50:07","41"),
("313","2016-12-20 10:55:29","41"),
("314","2016-12-20 10:56:42","41"),
("315","2016-12-20 10:56:56","41"),
("316","2016-12-20 10:57:55","41"),
("317","2016-12-20 10:59:26","41"),
("318","2016-12-20 11:01:02","41"),
("319","2016-12-20 11:01:19","41"),
("320","2016-12-20 11:04:51","41"),
("321","2016-12-20 11:08:55","41"),
("322","2016-12-20 11:10:51","41"),
("323","2016-12-20 11:11:35","41"),
("324","2016-12-20 11:11:57","41"),
("325","2016-12-20 11:13:14","41"),
("326","2016-12-20 11:13:38","41"),
("327","2016-12-20 11:15:42","41"),
("328","2016-12-20 11:17:11","41"),
("329","2016-12-20 11:17:13","41"),
("330","2016-12-20 11:18:08","41"),
("331","2016-12-20 11:18:41","41"),
("332","2016-12-20 11:24:35","41"),
("333","2016-12-20 11:24:35","41"),
("334","2016-12-20 11:24:51","41"),
("335","2016-12-20 11:25:34","41"),
("336","2016-12-20 11:26:38","41"),
("337","2016-12-20 11:26:38","41"),
("338","2016-12-20 11:27:21","41"),
("339","2016-12-20 11:29:24","41"),
("340","2016-12-20 12:23:44","41"),
("341","2016-12-21 09:01:34","41"),
("342","2016-12-23 09:13:39","39"),
("343","2016-12-23 09:14:31","41"),
("344","2016-12-23 10:50:07","42"),
("345","2016-12-23 10:50:51","42"),
("346","2016-12-23 10:50:53","42"),
("347","2016-12-26 11:26:14","39"),
("348","2016-12-26 12:43:02","41"),
("349","2016-12-26 12:43:08","41"),
("350","2016-12-26 12:43:44","42"),
("351","2016-12-26 12:43:55","41"),
("352","2016-12-26 12:44:04","41"),
("353","2016-12-26 12:45:00","41"),
("354","2016-12-26 13:05:45","41"),
("355","2016-12-26 13:07:24","41"),
("356","2016-12-26 13:09:41","41"),
("357","2016-12-26 13:13:42","41"),
("358","2016-12-26 13:13:44","41"),
("359","2016-12-26 13:13:59","41"),
("360","2016-12-26 13:14:23","41"),
("361","2016-12-26 13:15:40","39"),
("362","2016-12-26 13:16:10","41"),
("363","2016-12-26 13:16:23","39"),
("364","2016-12-26 13:16:33","39"),
("365","2016-12-26 13:16:43","39"),
("366","2016-12-26 13:18:50","39"),
("367","2016-12-26 13:20:05","39"),
("368","2016-12-26 13:20:28","39"),
("369","2016-12-26 13:20:43","39"),
("370","2016-12-26 13:21:00","39"),
("371","2016-12-26 13:21:39","41"),
("372","2016-12-26 13:23:52","41"),
("373","2016-12-26 13:25:54","41"),
("374","2016-12-26 13:26:28","41"),
("375","2016-12-26 13:28:08","41"),
("376","2016-12-26 13:29:32","41"),
("377","2016-12-26 13:30:00","41"),
("378","2016-12-26 13:30:23","41"),
("379","2016-12-26 13:31:57","41"),
("380","2016-12-26 13:32:24","41"),
("381","2016-12-26 13:32:27","41"),
("382","2016-12-26 13:32:32","41"),
("383","2016-12-26 13:32:46","41"),
("384","2016-12-26 13:32:55","41"),
("385","2016-12-26 13:34:40","41"),
("386","2016-12-26 13:38:32","41"),
("387","2016-12-26 13:38:33","41"),
("388","2016-12-26 13:38:36","41"),
("389","2016-12-26 13:38:37","41"),
("390","2016-12-26 13:38:49","41"),
("391","2016-12-26 14:00:30","41"),
("392","2016-12-26 14:01:28","41"),
("393","2016-12-26 14:01:31","41"),
("394","2016-12-26 14:01:51","41"),
("395","2016-12-26 14:02:32","41"),
("396","2016-12-26 14:04:21","41"),
("397","2016-12-26 14:04:23","41"),
("398","2016-12-26 14:04:25","41"),
("399","2016-12-26 14:04:34","41"),
("400","2016-12-26 14:04:51","41"),
("401","2016-12-26 14:06:08","41"),
("402","2016-12-26 14:06:41","41"),
("403","2016-12-26 14:07:52","41"),
("404","2016-12-26 14:09:30","41"),
("405","2016-12-26 14:10:21","41"),
("406","2016-12-26 14:10:59","41"),
("407","2016-12-26 14:11:14","41"),
("408","2016-12-26 14:12:29","41"),
("409","2016-12-26 14:12:42","41"),
("410","2016-12-26 14:13:00","41"),
("411","2016-12-26 14:29:57","42"),
("412","2016-12-26 14:30:30","41"),
("413","2016-12-26 14:36:38","41"),
("414","2016-12-26 14:37:53","41"),
("415","2016-12-26 14:38:28","41"),
("416","2016-12-26 14:39:28","41"),
("417","2016-12-26 14:39:46","41"),
("418","2016-12-26 14:43:13","41"),
("419","2016-12-26 14:45:33","41"),
("420","2016-12-26 15:14:55","41"),
("421","2016-12-26 15:30:26","39"),
("422","2016-12-26 15:30:44","41"),
("423","2016-12-26 15:35:59","39"),
("424","2016-12-26 15:38:20","39"),
("425","2016-12-26 16:08:34","41"),
("426","2016-12-26 16:10:37","41"),
("427","2016-12-26 16:18:38","40"),
("428","2016-12-27 09:36:36","39"),
("429","2016-12-27 09:36:49","41"),
("430","2016-12-27 09:41:14","41"),
("431","2016-12-27 09:42:21","41"),
("432","2016-12-27 09:43:24","42"),
("433","2016-12-27 09:43:37","41"),
("434","2016-12-27 09:45:12","41"),
("435","2016-12-27 09:47:07","41"),
("436","2016-12-27 10:31:13","41"),
("437","2016-12-27 11:08:47","41"),
("438","2016-12-27 11:12:07","41"),
("439","2016-12-27 11:12:08","41"),
("440","2016-12-27 12:07:31","40"),
("441","2016-12-27 12:07:37","40"),
("442","2016-12-27 12:07:39","41"),
("443","2016-12-27 12:46:02","41"),
("444","2016-12-27 13:02:11","41"),
("445","2016-12-27 13:24:04","40"),
("446","2016-12-27 13:42:55","41"),
("447","2016-12-27 13:47:44","40"),
("448","2016-12-27 13:48:48","40"),
("449","2016-12-27 14:14:58","40"),
("450","2016-12-27 14:15:07","41"),
("451","2016-12-27 14:15:48","41"),
("452","2016-12-27 14:29:58","40"),
("453","2016-12-27 15:26:47","40"),
("454","2016-12-27 15:27:52","40"),
("455","2016-12-27 15:28:17","40"),
("456","2016-12-27 15:45:15","40"),
("457","2016-12-27 16:51:27","41"),
("458","2016-12-28 13:52:52","41"),
("459","2017-01-02 10:52:00","42"),
("460","2017-01-02 10:52:04","42"),
("461","2017-01-02 15:45:15","41"),
("462","2017-01-02 15:46:24","41"),
("463","2017-01-02 15:56:11","40"),
("464","2017-01-02 15:56:17","42"),
("465","2017-01-02 15:56:22","41"),
("466","2017-01-02 15:56:32","41"),
("467","2017-01-02 15:56:58","41"),
("468","2017-01-03 14:48:55","40"),
("469","2017-01-03 14:49:04","40"),
("470","2017-01-03 14:50:02","40"),
("471","2017-01-03 14:50:42","40"),
("472","2017-01-10 12:16:00","41"),
("473","2017-01-19 08:02:51","40"),
("474","2017-01-19 08:41:23","39"),
("476","2017-01-20 10:08:18","41"),
("477","2017-01-20 10:09:00","41"),
("478","2017-01-20 10:09:46","41"),
("479","2017-01-20 10:10:02","41"),
("480","2017-01-20 10:10:39","41"),
("481","2017-01-20 10:10:42","41"),
("482","2017-01-20 10:12:06","41"),
("483","2017-01-20 10:16:39","41"),
("484","2017-01-20 10:16:49","41"),
("485","2017-01-20 10:17:29","41"),
("486","2017-01-20 10:21:35","41"),
("487","2017-01-20 10:56:27","41"),
("488","2017-01-20 10:58:13","41"),
("489","2017-01-20 11:00:02","41"),
("490","2017-01-20 11:00:33","41"),
("491","2017-01-20 11:01:42","41"),
("492","2017-01-20 11:02:09","41"),
("493","2017-01-20 11:02:11","41"),
("494","2017-01-20 11:02:13","41"),
("495","2017-01-20 11:02:22","41"),
("496","2017-01-20 11:03:09","41"),
("497","2017-01-20 11:03:18","41"),
("498","2017-01-20 11:03:20","41"),
("499","2017-01-20 11:03:24","41"),
("500","2017-01-20 11:03:56","41"),
("501","2017-01-20 11:04:15","41"),
("502","2017-01-20 11:05:38","41"),
("503","2017-01-20 11:05:47","41"),
("504","2017-01-20 11:08:58","41"),
("505","2017-01-20 11:08:58","41"),
("506","2017-01-20 11:08:59","41"),
("507","2017-01-20 11:09:41","41"),
("508","2017-01-20 11:09:41","41"),
("509","2017-01-20 11:09:42","41"),
("510","2017-01-20 11:13:12","41"),
("511","2017-01-20 11:13:26","41"),
("512","2017-01-20 11:14:05","41"),
("513","2017-01-20 11:17:11","41"),
("514","2017-01-20 11:17:13","41"),
("515","2017-01-20 11:17:14","41"),
("516","2017-01-20 11:18:08","41"),
("517","2017-01-20 11:18:28","41"),
("518","2017-01-20 11:18:39","41"),
("519","2017-01-20 11:20:35","41"),
("520","2017-01-20 11:20:35","41"),
("521","2017-01-20 11:20:36","41"),
("522","2017-01-20 11:20:36","41"),
("523","2017-01-20 11:20:36","41"),
("524","2017-01-20 11:21:01","41"),
("525","2017-01-20 11:23:38","41"),
("526","2017-01-20 11:24:33","41"),
("527","2017-01-20 11:25:48","41"),
("528","2017-01-20 11:25:57","41"),
("529","2017-01-20 11:26:08","41"),
("530","2017-01-20 11:26:47","41"),
("531","2017-01-20 11:27:00","41"),
("532","2017-01-20 11:27:01","41"),
("533","2017-01-20 11:27:37","41"),
("534","2017-01-20 11:29:23","41"),
("535","2017-01-20 11:32:31","41"),
("536","2017-01-20 11:33:28","41"),
("537","2017-01-20 11:33:29","41"),
("538","2017-01-20 11:33:34","41"),
("539","2017-01-20 11:35:21","41"),
("540","2017-01-20 11:36:08","41"),
("541","2017-01-20 11:37:03","41"),
("542","2017-01-20 11:37:55","41"),
("543","2017-01-20 11:38:54","41"),
("544","2017-01-20 11:39:38","41"),
("545","2017-01-20 11:41:35","41"),
("546","2017-01-20 11:46:02","41"),
("547","2017-01-20 11:46:09","41"),
("548","2017-01-20 11:46:42","41"),
("549","2017-01-20 11:47:08","41"),
("550","2017-01-20 11:47:08","41"),
("551","2017-01-20 11:49:15","42"),
("552","2017-01-20 11:49:33","39"),
("554","2017-01-20 11:51:02","40"),
("555","2017-01-20 11:51:02","40"),
("559","2017-01-20 11:51:03","39"),
("560","2017-01-20 11:51:03","42"),
("561","2017-01-20 11:52:00","41"),
("562","2017-01-20 11:54:53","41"),
("563","2017-01-20 11:54:53","41"),
("564","2017-01-20 11:59:22","41"),
("565","2017-01-20 12:02:41","41"),
("566","2017-01-20 12:03:19","41"),
("567","2017-01-20 12:05:20","41"),
("568","2017-01-20 12:05:20","41"),
("569","2017-01-20 12:05:20","41"),
("570","2017-01-20 12:05:23","41"),
("571","2017-01-20 12:05:25","41"),
("572","2017-01-20 12:06:38","41"),
("573","2017-01-20 12:06:39","41"),
("574","2017-01-20 12:06:39","41"),
("575","2017-01-20 12:06:41","41"),
("576","2017-01-20 12:09:04","41"),
("577","2017-01-20 12:18:49","41"),
("578","2017-01-20 12:18:51","41"),
("579","2017-01-20 12:18:59","41"),
("580","2017-01-20 12:18:59","41"),
("581","2017-01-20 12:22:23","41"),
("582","2017-01-20 12:22:25","41"),
("583","2017-01-20 12:22:34","41"),
("584","2017-01-20 12:22:39","41"),
("585","2017-01-20 12:24:16","41"),
("586","2017-01-20 12:24:20","41"),
("588","2017-01-23 09:44:44","41"),
("589","2017-01-23 10:06:10","41"),
("590","2017-01-23 10:06:15","41"),
("591","2017-01-23 11:35:59","41"),
("592","2017-01-23 11:37:17","41"),
("593","2017-01-23 11:40:00","41"),
("594","2017-01-23 11:43:28","41"),
("595","2017-01-23 11:47:19","41"),
("596","2017-01-23 11:51:30","41"),
("597","2017-01-23 11:51:30","41"),
("598","2017-01-23 11:52:12","41"),
("599","2017-01-23 11:52:48","41"),
("600","2017-01-23 14:03:52","41"),
("601","2017-01-23 14:03:53","41"),
("602","2017-01-23 14:04:17","41"),
("603","2017-01-23 14:04:28","41"),
("604","2017-01-23 14:09:03","41"),
("605","2017-01-23 14:09:03","41"),
("606","2017-01-24 11:19:47","39"),
("607","2017-01-24 11:19:53","41"),
("608","2017-01-24 11:19:59","39"),
("609","2017-01-24 11:20:04","41"),
("610","2017-01-24 11:20:12","41"),
("611","2017-01-24 11:21:28","41"),
("612","2017-01-24 11:21:59","41"),
("613","2017-01-24 11:23:40","41"),
("614","2017-01-24 11:23:43","41"),
("615","2017-01-24 11:25:20","41"),
("616","2017-01-24 11:25:37","41"),
("617","2017-01-24 11:25:39","41"),
("618","2017-01-24 11:26:18","41"),
("619","2017-01-24 11:26:33","41"),
("620","2017-01-24 11:26:58","41"),
("621","2017-01-24 11:27:25","41"),
("622","2017-01-24 11:27:51","41"),
("623","2017-01-24 11:33:00","41"),
("624","2017-01-24 11:39:38","41"),
("625","2017-01-24 11:40:16","41"),
("626","2017-01-24 11:42:23","41"),
("627","2017-01-24 11:44:48","41"),
("628","2017-01-24 11:52:24","41"),
("629","2017-01-24 11:53:19","41"),
("630","2017-01-24 12:00:40","41"),
("631","2017-01-24 12:02:05","41"),
("632","2017-01-24 12:02:10","41"),
("633","2017-01-24 12:02:33","41"),
("639","2017-01-25 14:49:46","41"),
("640","2017-01-27 13:21:45","42"),
("641","2017-01-27 13:30:14","39"),
("642","2017-01-27 13:33:24","39"),
("643","2017-01-27 13:47:01","40"),
("644","2017-01-27 13:47:33","41"),
("646","2017-02-14 09:31:49","40"),
("647","2017-02-20 15:47:41","40"),
("648","2017-02-20 15:52:08","40"),
("649","2017-02-22 13:46:51","39"),
("650","2017-02-22 14:09:44","40"),
("651","2017-02-23 12:26:54","40"),
("652","2017-02-23 13:26:18","40"),
("653","2017-02-23 13:32:46","40"),
("654","2017-02-23 13:33:02","41"),
("655","2017-02-23 13:54:51","41"),
("656","2017-02-23 15:44:51","43"),
("657","2017-02-23 15:44:58","43"),
("658","2017-02-23 15:45:01","43"),
("659","2017-02-24 11:47:54","40"),
("660","2017-02-24 11:48:06","43"),
("661","2017-02-24 11:48:11","43"),
("662","2017-02-24 11:48:56","43"),
("663","2017-02-24 11:48:58","43"),
("664","2017-02-24 11:50:06","43"),
("665","2017-02-24 11:50:14","43"),
("666","2017-02-24 11:51:25","39"),
("667","2017-02-24 12:06:35","40"),
("668","2017-02-24 12:22:58","40"),
("669","2017-02-24 13:08:08","40"),
("670","2017-02-24 13:09:17","40"),
("671","2017-02-24 13:09:26","40"),
("672","2017-02-24 13:10:00","40"),
("673","2017-02-24 13:10:11","40"),
("674","2017-02-24 13:14:45","40"),
("675","2017-02-24 13:19:19","40"),
("676","2017-02-24 13:24:46","41"),
("677","2017-02-24 13:24:46","41"),
("678","2017-02-24 13:24:46","41"),
("679","2017-02-24 13:24:46","41"),
("680","2017-02-24 13:25:02","40"),
("681","2017-02-24 13:25:22","40"),
("682","2017-02-24 13:26:18","42"),
("683","2017-02-24 13:26:26","42"),
("684","2017-02-24 13:26:29","42"),
("685","2017-02-24 13:29:11","40"),
("686","2017-02-24 13:29:11","40"),
("687","2017-02-24 13:29:30","40"),
("688","2017-02-24 13:30:05","40"),
("689","2017-02-24 13:30:06","40"),
("690","2017-02-24 13:34:30","40"),
("691","2017-02-24 13:36:30","40"),
("692","2017-02-24 13:38:50","40"),
("693","2017-02-24 13:39:27","40"),
("694","2017-02-24 14:04:05","39");
--
-- Structure for the table etiqueta
--
DROP TABLE IF EXISTS `etiqueta`;
CREATE TABLE `etiqueta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Data dump for the table etiqueta
--
INSERT INTO `etiqueta` VALUES
("1","etiqueta de prueba");
--
-- Structure for the table evento
--
DROP TABLE IF EXISTS `evento`;
CREATE TABLE `evento` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` date NOT NULL,
`titulo` varchar(150) NOT NULL,
`copete` text NOT NULL,
`detalle` text NOT NULL,
`id_pais` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
--
-- Data dump for the table evento
--
INSERT INTO `evento` VALUES
("5","2016-12-05","test","test","test","0");
--
-- Structure for the table farmacia
--
DROP TABLE IF EXISTS `farmacia`;
CREATE TABLE `farmacia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(200) NOT NULL,
`direccion` varchar(200) NOT NULL,
`telefono` varchar(150) NOT NULL,
`grupo` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table filtro
--
DROP TABLE IF EXISTS `filtro`;
CREATE TABLE `filtro` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(50) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
--
-- Data dump for the table filtro
--
INSERT INTO `filtro` VALUES
("2","Filtro 1","0"),
("3","filtro 2","0");
--
-- Structure for the table foto_clasificado
--
DROP TABLE IF EXISTS `foto_clasificado`;
CREATE TABLE `foto_clasificado` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_clasificado` int(11) NOT NULL,
`nombre` varchar(50) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_clasificado` (`id_clasificado`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table foto_evento
--
DROP TABLE IF EXISTS `foto_evento`;
CREATE TABLE `foto_evento` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_evento` int(11) NOT NULL,
`nombre` varchar(20) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
--
-- Data dump for the table foto_evento
--
INSERT INTO `foto_evento` VALUES
("13","5","1480964514.jpeg","99999");
--
-- Structure for the table foto_fotogaleria
--
DROP TABLE IF EXISTS `foto_fotogaleria`;
CREATE TABLE `foto_fotogaleria` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_fotogaleria` int(11) NOT NULL,
`nombre` varchar(50) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_fotogaleria` (`id_fotogaleria`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table foto_fotogaleria_noticia
--
DROP TABLE IF EXISTS `foto_fotogaleria_noticia`;
CREATE TABLE `foto_fotogaleria_noticia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_noticia` int(11) NOT NULL,
`nombre` varchar(30) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table foto_noticia
--
DROP TABLE IF EXISTS `foto_noticia`;
CREATE TABLE `foto_noticia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_noticia` int(11) NOT NULL,
`nombre` varchar(255) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_noticia` (`id_noticia`),
KEY `id_noticia_2` (`id_noticia`),
KEY `id` (`id`),
KEY `id_noticia_3` (`id_noticia`),
KEY `id_2` (`id`),
KEY `id_noticia_4` (`id_noticia`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table foto_novedad
--
DROP TABLE IF EXISTS `foto_novedad`;
CREATE TABLE `foto_novedad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_novedad` int(11) NOT NULL,
`nombre` varchar(20) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_id_novedad` (`id_novedad`),
CONSTRAINT `fk_id_novedad` FOREIGN KEY (`id_novedad`) REFERENCES `novedad` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table foto_producto
--
DROP TABLE IF EXISTS `foto_producto`;
CREATE TABLE `foto_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`nombre` varchar(20) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_fp_id_producto` (`id_producto`),
CONSTRAINT `fk_fp_id_producto` FOREIGN KEY (`id_producto`) REFERENCES `producto` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
--
-- Data dump for the table foto_producto
--
INSERT INTO `foto_producto` VALUES
("28","40","1480963945.jpeg","99999"),
("29","39","1480963959.jpeg","99999"),
("30","41","1482161752.jpeg","99999"),
("31","41","1482161765.jpeg","99999"),
("32","42","1482163163.jpeg","99999"),
("33","43","1487875472.jpeg","99999");
--
-- Structure for the table foto_stock
--
DROP TABLE IF EXISTS `foto_stock`;
CREATE TABLE `foto_stock` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(50) NOT NULL,
`palabras_clave` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table fotogaleria
--
DROP TABLE IF EXISTS `fotogaleria`;
CREATE TABLE `fotogaleria` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL,
`titulo` varchar(100) NOT NULL,
`copete` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table marca
--
DROP TABLE IF EXISTS `marca`;
CREATE TABLE `marca` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(200) NOT NULL,
`icono` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
--
-- Data dump for the table marca
--
INSERT INTO `marca` VALUES
("3","marca dos",""),
("2","test","1487874511.png");
--
-- Structure for the table modulos_administrables
--
DROP TABLE IF EXISTS `modulos_administrables`;
CREATE TABLE `modulos_administrables` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(50) NOT NULL,
`estado` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
--
-- Data dump for the table modulos_administrables
--
INSERT INTO `modulos_administrables` VALUES
("1","productos","activo"),
("2","etiquetas","activo"),
("3","noticias",""),
("4","publicidades","activo"),
("5","estadisticas","activo"),
("6","administrar-categorias","activo"),
("7","administrar-categorias-menu","activo"),
("8","filtros","activo"),
("9","unidad_venta","activo"),
("10","usuarios",""),
("11","backup","activo"),
("12","atributos-productos","activo"),
("13","rotador","activo"),
("14","administrar-categorias-menu-footer",""),
("15","stock-productos",""),
("16","novedades",""),
("17","eventos",""),
("18","preguntas-frecuentes",""),
("19","cupones",""),
("20","modulos","activo"),
("21","publicidades","activo"),
("22","colores","activo"),
("23","popup-inicio",""),
("24","consultas","activo"),
("25","marcas","activo");
--
-- Structure for the table modulos_noticias
--
DROP TABLE IF EXISTS `modulos_noticias`;
CREATE TABLE `modulos_noticias` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_categoria` int(11) NOT NULL,
`id_modulo` int(11) NOT NULL,
`orden` int(11) NOT NULL,
`color_fondo` varchar(20) NOT NULL,
`id_categoria_noticias` int(11) NOT NULL,
`titulo` varchar(255) NOT NULL,
`cantidad` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
--
-- Data dump for the table modulos_noticias
--
INSERT INTO `modulos_noticias` VALUES
("57","24","121","3","","0","","0"),
("30","0","103","1","","0","","0"),
("58","24","102","2","","0","","0"),
("59","24","107","4","","0","","0"),
("60","31","120","1","","0","","0"),
("56","24","120","1","","0","","0"),
("31","0","104","13","","0","Ofertas del mes de Diciembre!","0"),
("32","0","105","14","","0","","12"),
("33","0","101","9","","0","","0"),
("29","0","102","7","","0","","0"),
("34","0","106","10","","0","","0"),
("35","0","107","17","","0","","0"),
("36","0","104","15","","0","Ghezan Técnico!","0"),
("37","0","105","16","","30","","4"),
("38","0","120","8","","0","","0"),
("39","0","121","11","","0","","0"),
("40","27","102","1","","0","","0"),
("41","27","103","2","","0","","0"),
("42","27","104","3","","0","","0"),
("43","27","105","4","","0","","0"),
("44","27","106","5","","0","","0"),
("45","27","101","6","","0","","0"),
("46","27","107","7","","0","","0"),
("47","30","120","1","","0","","0"),
("48","30","121","2","","0","","0"),
("61","31","121","2","","0","","0"),
("62","32","120","1","","0","","0"),
("63","32","121","2","","0","","0"),
("64","0","104","6","","0","","0"),
("65","0","101","3","","0","","0"),
("66","0","106","5","","0","","0"),
("67","0","120","2","","0","","0"),
("68","0","121","4","","0","","0"),
("69","0","120","12","","0","","0");
--
-- Structure for the table nacimiento
--
DROP TABLE IF EXISTS `nacimiento`;
CREATE TABLE `nacimiento` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` date NOT NULL,
`sexo` varchar(20) NOT NULL,
`nombre` varchar(200) NOT NULL,
`detalle` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table necrologica
--
DROP TABLE IF EXISTS `necrologica`;
CREATE TABLE `necrologica` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` date NOT NULL,
`nombre` varchar(200) NOT NULL,
`detalle` text NOT NULL,
PRIMARY KEY (`id`),
KEY `fecha` (`fecha`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table noticia
--
DROP TABLE IF EXISTS `noticia`;
CREATE TABLE `noticia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_categoria` int(11) NOT NULL,
`ultimo_momento` varchar(2) NOT NULL,
`fecha` date NOT NULL,
`titulo` varchar(200) NOT NULL,
`copete` text NOT NULL,
`detalle` text NOT NULL,
`video` varchar(200) NOT NULL,
`inicio` varchar(2) NOT NULL,
`orden_categoria` int(11) NOT NULL,
`orden_inicio` int(11) NOT NULL,
`copetin` text NOT NULL,
`encuesta` varchar(2) NOT NULL,
`etiqueta` varchar(200) NOT NULL,
`en_modulo` varchar(2) NOT NULL,
`id_periodista` int(11) NOT NULL,
`autor` varchar(200) NOT NULL,
`html_extra` text NOT NULL,
`id_usuario` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`),
KEY `id_categoria` (`id_categoria`),
KEY `id_2` (`id`),
KEY `fecha` (`fecha`),
KEY `orden_inicio` (`orden_inicio`),
KEY `orden_categoria` (`orden_categoria`),
KEY `id_3` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table novedad
--
DROP TABLE IF EXISTS `novedad`;
CREATE TABLE `novedad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` date NOT NULL,
`titulo` varchar(150) NOT NULL,
`copete` text NOT NULL,
`detalle` text NOT NULL,
`id_pais` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table opcion_atributo_producto
--
DROP TABLE IF EXISTS `opcion_atributo_producto`;
CREATE TABLE `opcion_atributo_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_atributo` int(11) NOT NULL,
`nombre` varchar(100) NOT NULL,
`valor` varchar(100) NOT NULL,
`codigo` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_atributo` (`id_atributo`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Data dump for the table opcion_atributo_producto
--
INSERT INTO `opcion_atributo_producto` VALUES
("1","1","Rojo","ff0000","1");
--
-- Structure for the table opcion_encuesta
--
DROP TABLE IF EXISTS `opcion_encuesta`;
CREATE TABLE `opcion_encuesta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_encuesta` int(11) NOT NULL,
`valor` varchar(200) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table opciones_filtro
--
DROP TABLE IF EXISTS `opciones_filtro`;
CREATE TABLE `opciones_filtro` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_filtro` int(11) NOT NULL,
`nombre` varchar(50) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_of_id_filtro` (`id_filtro`),
CONSTRAINT `fk_of_id_filtro` FOREIGN KEY (`id_filtro`) REFERENCES `filtro` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
--
-- Data dump for the table opciones_filtro
--
INSERT INTO `opciones_filtro` VALUES
("4","2","opcion 1","1000"),
("5","2","opcion 2","1000"),
("6","3","opcion 1 de filtro 2","1000"),
("7","3","opcion 2 de filtro 2","1000");
--
-- Structure for the table opinion_noticia
--
DROP TABLE IF EXISTS `opinion_noticia`;
CREATE TABLE `opinion_noticia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_noticia` int(11) NOT NULL,
`opinion` varchar(50) NOT NULL,
`ip` varchar(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_noticia` (`id_noticia`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table pedido_carrito
--
DROP TABLE IF EXISTS `pedido_carrito`;
CREATE TABLE `pedido_carrito` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_usuario_carrito` int(11) NOT NULL,
`id_cupon` int(11) NOT NULL,
`tipo_envio` varchar(100) NOT NULL,
`costo_envio` varchar(50) NOT NULL,
`fecha_envio` varchar(100) NOT NULL,
`total` decimal(9,2) NOT NULL,
`envio_direccion` varchar(200) NOT NULL,
`envio_ciudad` varchar(100) NOT NULL,
`envio_numero` varchar(50) NOT NULL,
`envio_piso` varchar(20) NOT NULL,
`envio_provincia` varchar(50) NOT NULL,
`envio_codigo_postal` varchar(10) NOT NULL,
`envio_informacion` text NOT NULL,
`envio_telefono_fijo` varchar(100) NOT NULL,
`envio_telefono_movil` varchar(100) NOT NULL,
`personal_nombre` varchar(100) NOT NULL,
`personal_apellido` varchar(100) NOT NULL,
`personal_cuit` varchar(20) NOT NULL,
`personal_dni` varchar(20) NOT NULL,
`personal_ciudad` varchar(100) NOT NULL,
`personal_direccion` varchar(200) NOT NULL,
`personal_numero` varchar(20) NOT NULL,
`personal_piso` varchar(20) NOT NULL,
`personal_provincia` varchar(100) NOT NULL,
`personal_codigo_postal` varchar(10) NOT NULL,
`personal_informacion` text NOT NULL,
`personal_telefono_fijo` varchar(100) NOT NULL,
`personal_telefono_movil` varchar(100) NOT NULL,
`fecha` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`estado` varchar(30) NOT NULL DEFAULT 'pendiente',
`cancelar_razon` text NOT NULL,
`texto_oca` text NOT NULL,
`merchant_order_id` varchar(50) NOT NULL,
`encargado_proceso` varchar(200) NOT NULL,
`encargado_proceso_fecha` datetime NOT NULL,
`encargado_finalizar` varchar(200) NOT NULL,
`encargado_finalizar_fecha` datetime NOT NULL,
`encargado_facturacion` varchar(200) NOT NULL,
`fecha_facturacion_proceso` datetime NOT NULL,
`fecha_facturacion_finalizado` datetime NOT NULL,
`encargado_envio` varchar(200) NOT NULL,
`fecha_envio_proceso` datetime NOT NULL,
`fecha_envio_finalizado` datetime NOT NULL,
`mp_response` text NOT NULL,
`envie_mail_pendiente` varchar(11) NOT NULL DEFAULT 'no',
`envie_mail_pago` varchar(11) NOT NULL DEFAULT 'no',
`payments` int(30) NOT NULL,
`datos_facturacion` text NOT NULL,
`ip` varchar(60) NOT NULL,
`tipo_pago` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_usuario_carrito` (`id_usuario_carrito`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Data dump for the table pedido_carrito
--
INSERT INTO `pedido_carrito` VALUES
("1","2","0","Retira en el local | Arana 122 Tandil | Buenos Aires","0","","30500.00","","","","","","","","","","Ignacio","Martinez","12313123","1233212","Tandil","Arana","122","","Buenos Aires","7000","123123","","","2017-01-02 16:10:54","finalizado","","","","nacho","2017-01-02 16:12:17","","2017-01-02 16:12:13","","0000-00-00 00:00:00","0000-00-00 00:00:00","","0000-00-00 00:00:00","0000-00-00 00:00:00","","no","no","0","","192.168.1.57",""),
("2","2","0","Retira en el local | Av. 12 de Octubre 626 - Venado Tuerto - Santa Fé","0","","999.00","","","","","Provincia","","","","","Ignacio","Martinez","12313123","1233212","Tandil","Arana","122","","Buenos Aires","7000","123123","","2494123123","2017-02-23 13:25:51","pendiente","","","","","0000-00-00 00:00:00","","0000-00-00 00:00:00","","0000-00-00 00:00:00","0000-00-00 00:00:00","","0000-00-00 00:00:00","0000-00-00 00:00:00","","no","no","0","","192.168.1.48","todopago");
--
-- Structure for the table periodista
--
DROP TABLE IF EXISTS `periodista`;
CREATE TABLE `periodista` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(200) NOT NULL,
`foto` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table popup_inicio
--
DROP TABLE IF EXISTS `popup_inicio`;
CREATE TABLE `popup_inicio` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`foto` varchar(50) NOT NULL,
`tipo_link` varchar(20) NOT NULL,
`link` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table precio_producto
--
DROP TABLE IF EXISTS `precio_producto`;
CREATE TABLE `precio_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`codigo` varchar(200) NOT NULL,
`sku_individual` varchar(200) NOT NULL,
`precio` decimal(9,2) NOT NULL,
`precio_oferta` decimal(9,2) NOT NULL,
`stock` int(11) NOT NULL,
`stock_minimo` int(11) NOT NULL,
`codigo_shope` varchar(200) NOT NULL,
`envio_gratis` varchar(2) DEFAULT 'no',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
--
-- Data dump for the table precio_producto
--
INSERT INTO `precio_producto` VALUES
("1","0505001 ","0505001 ","32000.00","30500.00","1","2","0505001 ","no"),
("2","0505001a","0505001a","32000.00","30500.00","0","3","0505001a","no"),
("3","123","123","500.00","450.00","4","1","123","no"),
("4","1234","1234","999.00","0.00","4","1","1234","no");
--
-- Structure for the table pregunta_frecuente
--
DROP TABLE IF EXISTS `pregunta_frecuente`;
CREATE TABLE `pregunta_frecuente` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pregunta` varchar(200) NOT NULL,
`respuesta` text NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
--
-- Data dump for the table pregunta_frecuente
--
INSERT INTO `pregunta_frecuente` VALUES
("3","pregunta2","respuesta2","0");
--
-- Structure for the table producto
--
DROP TABLE IF EXISTS `producto`;
CREATE TABLE `producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(100) NOT NULL,
`codigo` varchar(50) NOT NULL,
`detalle` text NOT NULL,
`copete` text NOT NULL,
`destacado` varchar(10) NOT NULL,
`video` varchar(100) NOT NULL,
`pdf_manual` varchar(20) NOT NULL,
`pdf_detalle` varchar(20) NOT NULL,
`oferta` varchar(10) NOT NULL,
`nuevo` varchar(10) NOT NULL,
`stock` int(11) NOT NULL,
`precio` decimal(9,2) NOT NULL,
`precio_oferta` decimal(9,2) NOT NULL,
`destacado_medio` varchar(2) NOT NULL DEFAULT 'no',
`incluye` text NOT NULL,
`promedio_valoracion_precio` decimal(9,2) NOT NULL,
`promedio_valoracion_calidad` decimal(9,2) NOT NULL,
`promedio_valoracion_uso` decimal(9,2) NOT NULL,
`id_unidad_venta` int(11) NOT NULL,
`fecha_modificacion` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`sku_individual` varchar(50) NOT NULL,
`peso` decimal(9,2) NOT NULL,
`alto` decimal(9,2) NOT NULL,
`ancho` decimal(9,2) NOT NULL,
`largo` decimal(9,2) NOT NULL,
`stock_minimo` int(11) NOT NULL,
`envio_gratis` varchar(2) DEFAULT 'no',
`unidad_compra` int(11) NOT NULL DEFAULT '1',
`id_marca` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `codigo` (`codigo`),
KEY `id` (`id`),
KEY `fk_id_unidad_venta` (`id_unidad_venta`),
CONSTRAINT `fk_id_unidad_venta` FOREIGN KEY (`id_unidad_venta`) REFERENCES `unidad_venta` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
--
-- Data dump for the table producto
--
INSERT INTO `producto` VALUES
("39","test2","123","test","test","si","","","","si","si","0","0.00","0.00","si","test","0.00","0.00","0.00","2","2017-01-02 16:30:49","","0.00","0.00","0.00","0.00","0","no","1","0"),
("40","test dos","1234","test dos","test dos","si","","","","si","si","0","0.00","0.00","si","test dos","3.00","3.00","3.00","2","2017-01-02 16:30:49","","0.00","0.00","0.00","0.00","0","no","1","0"),
("41","Dolphin Diagnostic","0505001 ","Es el robusto y confiable miembro de la familia Dolphin, famoso por su capacidad de trepar paredes y limpiar bordes. \r\nDolphin Diagnostic recorrerá, cepillará, barrerá, aspirará, y filtrará la piscina entera en tan solo 3 horas. \r\nUn filtro de gran superficie garantiza que su piscina quedará cristalinamente limpia al tiempo que ayuda a minimizar el uso de sustancias de limpieza químicas. ","Dolphin Diagnostic es el robot incansable programado para recorrer toda su piscina. ","","https://www.youtube.com/watch?v=ELrW_VS2kjA","1482162400.pdf","","si","si","0","0.00","0.00","no","Carrito","5.00","5.00","5.00","2","2017-01-02 16:30:49","","50.00","10.00","5.00","5.00","0","no","1","0"),
("42","Dolphin Diagnostic","0505001a","Es el robusto y confiable miembro de la familia Dolphin, famoso por su capacidad de trepar paredes y limpiar bordes. \r\nDolphin Diagnostic recorrerá, cepillará, barrerá, aspirará, y filtrará la piscina entera en tan solo 3 horas. \r\nUn filtro de gran superficie garantiza que su piscina quedará cristalinamente limpia al tiempo que ayuda a minimizar el uso de sustancias de limpieza químicas. ","Dolphin Diagnostic es el robot incansable programado para recorrer toda su piscina. ","","https://www.youtube.com/watch?v=ELrW_VS2kjA","","","no","si","0","0.00","0.00","no","Carrito","0.00","0.00","0.00","2","2017-01-02 16:30:49","","0.00","0.00","0.00","0.00","0","no","1","0"),
("43","test con marca","123","test con marca","test con marca","","","","","","si","0","0.00","0.00","no","","0.00","0.00","0.00","2","2017-02-23 15:59:40","","0.00","0.00","0.00","0.00","0","no","1","2");
--
-- Structure for the table publicar_redes
--
DROP TABLE IF EXISTS `publicar_redes`;
CREATE TABLE `publicar_redes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_noticia` int(11) NOT NULL,
`red` varchar(20) NOT NULL,
`estado` varchar(20) NOT NULL DEFAULT 'pendiente',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table publicidad
--
DROP TABLE IF EXISTS `publicidad`;
CREATE TABLE `publicidad` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(100) NOT NULL,
`tipo` varchar(100) NOT NULL,
`foto_escritorio` varchar(20) NOT NULL,
`foto_celular` varchar(20) NOT NULL,
`fecha_inicio` date NOT NULL,
`fecha_fin` date NOT NULL,
`estado` varchar(20) NOT NULL,
`link` varchar(150) NOT NULL,
`tipo_link` varchar(20) NOT NULL,
`adwords` text NOT NULL,
`fecha_ultima_visualizacion` datetime NOT NULL,
`intervalo` int(11) NOT NULL,
`visualizaciones` int(11) NOT NULL,
`clicks` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
--
-- Data dump for the table publicidad
--
INSERT INTO `publicidad` VALUES
("1","test publicidad contenido","Contenido","1481552045.jpg","1481550234.jpg","2016-12-12","2016-12-16","activo","http://www.creadoresdesitios.com.ar/","externo","","0000-00-00 00:00:00","15","0","0"),
("2","separador doble","Contenido doble","1481552074.jpg","1481550279.jpg","2016-12-12","2016-12-15","activo","","interno","","0000-00-00 00:00:00","15","0","0"),
("3","segundo separador","Contenido doble","1481552787.jpg","","2016-12-12","2016-12-15","activo","","interno","","0000-00-00 00:00:00","15","0","0");
--
-- Structure for the table publicidades_vistas
--
DROP TABLE IF EXISTS `publicidades_vistas`;
CREATE TABLE `publicidades_vistas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` datetime NOT NULL,
`id_publicidad` int(11) NOT NULL,
`id_modulo` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_publicidad` (`id_publicidad`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table renglon_caracteristica_producto
--
DROP TABLE IF EXISTS `renglon_caracteristica_producto`;
CREATE TABLE `renglon_caracteristica_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`id_caracteristica` int(11) NOT NULL,
`valor` text NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_rcp_id_caracteristica` (`id_caracteristica`),
KEY `fk_rcp_id_producto` (`id_producto`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_caracteristica_producto
--
INSERT INTO `renglon_caracteristica_producto` VALUES
("1","41","1","3 Horas","0"),
("2","41","2","20 m","0");
--
-- Structure for the table renglon_categoria_empresa
--
DROP TABLE IF EXISTS `renglon_categoria_empresa`;
CREATE TABLE `renglon_categoria_empresa` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_categoria` int(11) NOT NULL,
`id_empresa` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_rce_id_categoria` (`id_categoria`),
KEY `fk_rce_id_empresa` (`id_empresa`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table renglon_categoria_filtro
--
DROP TABLE IF EXISTS `renglon_categoria_filtro`;
CREATE TABLE `renglon_categoria_filtro` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_categoria` int(11) NOT NULL,
`id_filtro` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_categoria` (`id_categoria`),
KEY `id_filtro` (`id_filtro`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_categoria_filtro
--
INSERT INTO `renglon_categoria_filtro` VALUES
("8","24","0"),
("9","24","2"),
("10","24","3");
--
-- Structure for the table renglon_categoria_filtro_2
--
DROP TABLE IF EXISTS `renglon_categoria_filtro_2`;
CREATE TABLE `renglon_categoria_filtro_2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_categoria` int(11) NOT NULL,
`id_filtro` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table renglon_fecha_grupo_farmacias
--
DROP TABLE IF EXISTS `renglon_fecha_grupo_farmacias`;
CREATE TABLE `renglon_fecha_grupo_farmacias` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` date NOT NULL,
`grupo` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table renglon_noticia_relacionada
--
DROP TABLE IF EXISTS `renglon_noticia_relacionada`;
CREATE TABLE `renglon_noticia_relacionada` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_noticia1` int(11) NOT NULL,
`id_noticia2` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table renglon_pedido_producto
--
DROP TABLE IF EXISTS `renglon_pedido_producto`;
CREATE TABLE `renglon_pedido_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`codigo_producto` varchar(200) NOT NULL,
`id_pedido` int(11) NOT NULL,
`cantidad` int(11) NOT NULL,
`precio` decimal(9,2) NOT NULL,
`atributos` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_pedido_producto
--
INSERT INTO `renglon_pedido_producto` VALUES
("1","41","0505001 ","0","1","30500.00",""),
("2","41","0505001 ","0","1","30500.00",""),
("3","41","0505001 ","0","1","30500.00",""),
("4","41","0505001 ","0","1","30500.00",""),
("5","41","0505001 ","0","1","30500.00",""),
("6","41","0505001 ","0","1","30500.00",""),
("7","41","0505001 ","1","1","30500.00",""),
("8","40","1234","2","1","999.00","");
--
-- Structure for the table renglon_producto_atributo
--
DROP TABLE IF EXISTS `renglon_producto_atributo`;
CREATE TABLE `renglon_producto_atributo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`id_atributo` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_rpa_id_atributo` (`id_atributo`),
KEY `fk_rpa_id_producto` (`id_producto`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table renglon_producto_categoria
--
DROP TABLE IF EXISTS `renglon_producto_categoria`;
CREATE TABLE `renglon_producto_categoria` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`id_categoria` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_producto` (`id_producto`),
KEY `id_categoria` (`id_categoria`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_producto_categoria
--
INSERT INTO `renglon_producto_categoria` VALUES
("69","40","24"),
("70","39","24"),
("71","40","30"),
("72","39","30"),
("74","41","32"),
("75","42","32");
--
-- Structure for the table renglon_producto_complementario
--
DROP TABLE IF EXISTS `renglon_producto_complementario`;
CREATE TABLE `renglon_producto_complementario` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto1` int(11) NOT NULL,
`id_producto2` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_producto1` (`id_producto1`),
KEY `id_producto2` (`id_producto2`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_producto_complementario
--
INSERT INTO `renglon_producto_complementario` VALUES
("1","41","39"),
("2","41","40");
--
-- Structure for the table renglon_producto_mercado
--
DROP TABLE IF EXISTS `renglon_producto_mercado`;
CREATE TABLE `renglon_producto_mercado` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`id_mercado` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_id_etiqueta` (`id_mercado`),
KEY `fk_id_producto` (`id_producto`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_producto_mercado
--
INSERT INTO `renglon_producto_mercado` VALUES
("1","40","1");
--
-- Structure for the table renglon_producto_opcion
--
DROP TABLE IF EXISTS `renglon_producto_opcion`;
CREATE TABLE `renglon_producto_opcion` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`id_opcion` int(11) NOT NULL,
`id_filtro` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_rpo_id_filtro` (`id_filtro`),
KEY `fk_rpo_id_opcion` (`id_opcion`),
KEY `fk_rpo_id_producto` (`id_producto`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_producto_opcion
--
INSERT INTO `renglon_producto_opcion` VALUES
("4","40","4","2"),
("5","40","5","2"),
("6","40","6","3"),
("7","40","7","3"),
("8","39","4","2"),
("9","39","6","3");
--
-- Structure for the table renglon_producto_relacionado
--
DROP TABLE IF EXISTS `renglon_producto_relacionado`;
CREATE TABLE `renglon_producto_relacionado` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto1` int(11) NOT NULL,
`id_producto2` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `id_producto1` (`id_producto1`),
KEY `id_producto2` (`id_producto2`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_producto_relacionado
--
INSERT INTO `renglon_producto_relacionado` VALUES
("2","40","39"),
("3","41","39"),
("4","41","40");
--
-- Structure for the table renglon_producto_sustituto
--
DROP TABLE IF EXISTS `renglon_producto_sustituto`;
CREATE TABLE `renglon_producto_sustituto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto1` int(11) NOT NULL,
`id_producto2` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_rps_id_producto1` (`id_producto1`),
KEY `fk_rps_id_producto2` (`id_producto2`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table renglon_publicidad_pagina
--
DROP TABLE IF EXISTS `renglon_publicidad_pagina`;
CREATE TABLE `renglon_publicidad_pagina` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_publicidad` int(11) NOT NULL,
`pagina` varchar(50) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
--
-- Data dump for the table renglon_publicidad_pagina
--
INSERT INTO `renglon_publicidad_pagina` VALUES
("7","1","Inicio","0"),
("8","1","24","0"),
("9","1","26","0"),
("10","1","27","0"),
("11","1","28","0"),
("12","1","29","0"),
("13","2","Inicio","2"),
("14","2","24","0"),
("15","2","26","0"),
("16","2","27","0"),
("17","2","28","0"),
("18","2","29","0"),
("19","3","Inicio","1"),
("20","3","24","0"),
("21","3","26","0"),
("22","3","27","0"),
("23","3","28","0"),
("24","3","29","0");
--
-- Structure for the table rotador_notas
--
DROP TABLE IF EXISTS `rotador_notas`;
CREATE TABLE `rotador_notas` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titulo` varchar(200) NOT NULL,
`link` varchar(200) NOT NULL,
`foto` varchar(50) NOT NULL,
`foto2` varchar(50) DEFAULT NULL,
`tipo_link` varchar(30) NOT NULL,
`copete` text NOT NULL,
`texto_boton` varchar(100) NOT NULL,
`frase` text NOT NULL,
`link2` varchar(200) NOT NULL,
`tipo_link2` varchar(50) NOT NULL,
`texto_boton2` varchar(200) NOT NULL,
`orden` int(11) NOT NULL,
`id_categoria` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table rotador_productos_destacados
--
DROP TABLE IF EXISTS `rotador_productos_destacados`;
CREATE TABLE `rotador_productos_destacados` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`fecha_visualizacion` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table tapa_diarios
--
DROP TABLE IF EXISTS `tapa_diarios`;
CREATE TABLE `tapa_diarios` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fecha` date DEFAULT NULL,
`titulo` varchar(150) DEFAULT NULL,
`foto` varchar(150) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table unidad_venta
--
DROP TABLE IF EXISTS `unidad_venta`;
CREATE TABLE `unidad_venta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nombre` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Data dump for the table unidad_venta
--
INSERT INTO `unidad_venta` VALUES
("2","precio por unidad");
--
-- Structure for the table usuario
--
DROP TABLE IF EXISTS `usuario`;
CREATE TABLE `usuario` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(100) NOT NULL,
`clave` varchar(50) NOT NULL,
`nivel` int(11) NOT NULL,
`ciudad` varchar(100) NOT NULL,
`nombre` varchar(100) NOT NULL,
`apellido` varchar(100) NOT NULL,
`telefono` varchar(50) NOT NULL,
`rango_inicial` varchar(11) NOT NULL,
`rango_final` varchar(11) NOT NULL,
`foto` varchar(50) NOT NULL,
`profesion` varchar(100) NOT NULL,
`sexo` varchar(50) NOT NULL,
`fecha_nacimiento` varchar(50) NOT NULL,
`estado` varchar(100) NOT NULL,
`cookie` varchar(50) NOT NULL,
`id_empresa` int(11) NOT NULL,
`fecha_sincronizacion` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
--
-- Data dump for the table usuario
--
INSERT INTO `usuario` VALUES
("1","cds","cds","99","","cds","","","","","","","","","","","0","0000-00-00 00:00:00"),
("2","admin","admin","10","","admin","","","","","","","","","","","0","0000-00-00 00:00:00"),
("3","posicionamiento@creadoresdesitios.com.ar","","0","","nacho","","","","","","","","","","","0","0000-00-00 00:00:00");
--
-- Structure for the table usuario_carrito
--
DROP TABLE IF EXISTS `usuario_carrito`;
CREATE TABLE `usuario_carrito` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Data dump for the table usuario_carrito
--
INSERT INTO `usuario_carrito` VALUES
("1","man@hotmail.com"),
("2","posicionamiento@creadoresdesitios.com.ar");
--
-- Structure for the table usuario_suscripcion
--
DROP TABLE IF EXISTS `usuario_suscripcion`;
CREATE TABLE `usuario_suscripcion` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(250) NOT NULL,
`fecha` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Structure for the table valoracion_producto
--
DROP TABLE IF EXISTS `valoracion_producto`;
CREATE TABLE `valoracion_producto` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_producto` int(11) NOT NULL,
`id_usuario` int(11) NOT NULL,
`valoracion_precio` int(11) NOT NULL,
`comentario` text NOT NULL,
`valoracion_calidad` int(11) NOT NULL,
`valoracion_uso` int(11) NOT NULL,
`estado` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `fk_vp_id_producto` (`id_producto`),
KEY `fk_vp_id_usuarioo` (`id_usuario`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
--
-- Data dump for the table valoracion_producto
--
INSERT INTO `valoracion_producto` VALUES
("2","41","3","5","groso","5","5","activo"),
("14","40","3","3","123123","3","3","activo");
--
-- Structure for the table video_galeria_multimedia
--
DROP TABLE IF EXISTS `video_galeria_multimedia`;
CREATE TABLE `video_galeria_multimedia` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titulo` varchar(200) NOT NULL,
`youtube` varchar(200) NOT NULL,
`orden` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Structure for the table vista_cantidad_atributos_producto
--
DROP TABLE IF EXISTS `vista_cantidad_atributos_producto`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_cantidad_atributos_producto` AS select `p`.`id` AS `id_producto`,count(`rpa`.`id_atributo`) AS `cantidad` from (`producto` `p` left join `renglon_producto_atributo` `rpa` on((`rpa`.`id_producto` = `p`.`id`))) group by `p`.`id`;
--
-- Data dump for the table vista_cantidad_atributos_producto
--
INSERT INTO `vista_cantidad_atributos_producto` VALUES
("39","0"),
("40","0"),
("41","0"),
("42","0"),
("43","0");
--
-- Structure for the table vista_cantidad_etiquetas
--
DROP TABLE IF EXISTS `vista_cantidad_etiquetas`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_cantidad_etiquetas` AS select count(1) AS `cantidad`,`rpm`.`id_mercado` AS `id_mercado` from (`renglon_producto_mercado` `rpm` join `producto` `p` on((`p`.`id` = `rpm`.`id_producto`))) group by `rpm`.`id_mercado`;
--
-- Data dump for the table vista_cantidad_etiquetas
--
INSERT INTO `vista_cantidad_etiquetas` VALUES
("1","1");
--
-- Structure for the table vista_categoria_base
--
DROP TABLE IF EXISTS `vista_categoria_base`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_categoria_base` AS (select ifnull(`c3`.`id`,ifnull(`c2`.`id`,`c`.`id`)) AS `categoria_base`,`c`.`id` AS `c1`,`c2`.`id` AS `c2`,`c3`.`id` AS `c3` from ((`categoria_cliente` `c` left join `categoria_cliente` `c2` on((`c2`.`id` = `c`.`id_padre`))) left join `categoria_cliente` `c3` on((`c3`.`id` = `c2`.`id_padre`))));
--
-- Data dump for the table vista_categoria_base
--
INSERT INTO `vista_categoria_base` VALUES
("24","24","",""),
("25","25","",""),
("30","30","",""),
("31","31","",""),
("25","26","25",""),
("25","27","25",""),
("25","28","25",""),
("25","29","25",""),
("31","32","31","");
--
-- Structure for the table vista_categorias_hojas
--
DROP TABLE IF EXISTS `vista_categorias_hojas`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_categorias_hojas` AS select `categoria_cliente`.`id` AS `id`,`categoria_cliente`.`nombre` AS `nombre`,`categoria_cliente`.`id_padre` AS `id_padre`,`categoria_cliente`.`orden` AS `orden` from `categoria_cliente` where (not(`categoria_cliente`.`id` in (select `categoria_cliente`.`id_padre` from `categoria_cliente`)));
--
-- Data dump for the table vista_categorias_hojas
--
INSERT INTO `vista_categorias_hojas` VALUES
("24","test","0","1"),
("26","test con subs","25","0"),
("27","sub +1","25","0"),
("28","sub +1","25","0"),
("29","sub +1","25","0"),
("30","test con autogenerar modulos","0","2"),
("32","Robots Limpiadores","31","0");
--
-- Structure for the table vista_fotos_principales_clasificados
--
DROP TABLE IF EXISTS `vista_fotos_principales_clasificados`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_fotos_principales_clasificados` AS select `foto_clasificado`.`id` AS `id_foto_principal_clasificado`,`foto_clasificado`.`id_clasificado` AS `id_clasificado`,`foto_clasificado`.`nombre` AS `nombre_foto` from `foto_clasificado` where (not(`foto_clasificado`.`id` in (select `fn`.`id` from (`foto_clasificado` `fn` join `foto_clasificado` `fnaux` on(((`fn`.`id_clasificado` = `fnaux`.`id_clasificado`) and (`fn`.`orden` > `fnaux`.`orden`))))))) group by `foto_clasificado`.`id_clasificado`;
--
-- Structure for the table vista_fotos_principales_fotogalerias
--
DROP TABLE IF EXISTS `vista_fotos_principales_fotogalerias`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_fotos_principales_fotogalerias` AS select `foto_fotogaleria`.`id` AS `id_foto_principal_fotogaleria`,`foto_fotogaleria`.`id_fotogaleria` AS `id_fotogaleria`,`foto_fotogaleria`.`nombre` AS `nombre_foto` from `foto_fotogaleria` where (not(`foto_fotogaleria`.`id` in (select `fn`.`id` from (`foto_fotogaleria` `fn` join `foto_fotogaleria` `fnaux` on(((`fn`.`id_fotogaleria` = `fnaux`.`id_fotogaleria`) and (`fn`.`orden` > `fnaux`.`orden`))))))) group by `foto_fotogaleria`.`id_fotogaleria`;
--
-- Structure for the table vista_fotos_principales_noticias
--
DROP TABLE IF EXISTS `vista_fotos_principales_noticias`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_fotos_principales_noticias` AS select `foto_noticia`.`id` AS `id_foto_principal_noticia`,`foto_noticia`.`id_noticia` AS `id_noticia`,`foto_noticia`.`nombre` AS `nombre_foto` from `foto_noticia` where (not(`foto_noticia`.`id` in (select `fn`.`id` from (`foto_noticia` `fn` join `foto_noticia` `fnaux` on(((`fn`.`id_noticia` = `fnaux`.`id_noticia`) and (`fn`.`orden` > `fnaux`.`orden`))))))) group by `foto_noticia`.`id_noticia`;
--
-- Structure for the table vista_fotos_principales_producto
--
DROP TABLE IF EXISTS `vista_fotos_principales_producto`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_fotos_principales_producto` AS (select `foto_producto`.`id` AS `id_foto_principal_producto`,`foto_producto`.`id_producto` AS `id_producto`,`foto_producto`.`nombre` AS `nombre_foto_principal_producto` from `foto_producto` where (not(`foto_producto`.`id` in (select `fn`.`id` from (`foto_producto` `fn` join `foto_producto` `fnaux` on(((`fn`.`id_producto` = `fnaux`.`id_producto`) and (`fn`.`orden` > `fnaux`.`orden`))))))) group by `foto_producto`.`id_producto`);
--
-- Data dump for the table vista_fotos_principales_producto
--
INSERT INTO `vista_fotos_principales_producto` VALUES
("29","39","1480963959.jpeg"),
("28","40","1480963945.jpeg"),
("30","41","1482161752.jpeg"),
("32","42","1482163163.jpeg"),
("33","43","1487875472.jpeg");
--
-- Structure for the table vista_precio_producto
--
DROP TABLE IF EXISTS `vista_precio_producto`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vista_precio_producto` AS select `p`.`id` AS `id`,`pp`.`codigo` AS `codigo`,min(`pp`.`precio`) AS `precio`,min(`pp`.`precio_oferta`) AS `precio_oferta`,`pp`.`stock` AS `stock`,`pp`.`stock_minimo` AS `stock_minimo` from (`precio_producto` `pp` left join `producto` `p` on((`p`.`codigo` = `pp`.`codigo_shope`))) where ((`pp`.`precio` > '0.00') and (`pp`.`stock` >= 0)) group by `p`.`id`;
--
-- Data dump for the table vista_precio_producto
--
INSERT INTO `vista_precio_producto` VALUES
("39","123","500.00","450.00","4","1"),
("40","1234","999.00","0.00","4","1"),
("41","0505001 ","32000.00","30500.00","1","2"),
("42","0505001a","32000.00","30500.00","0","3"),
("43","123","500.00","450.00","4","1");
--
-- Structure for the table voto_encuesta
--
DROP TABLE IF EXISTS `voto_encuesta`;
CREATE TABLE `voto_encuesta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_encuesta` int(11) NOT NULL,
`id_opcion` int(11) NOT NULL,
`ip` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1008 DEFAULT CHARSET=latin1;
--
-- Data dump for the table voto_encuesta
--
INSERT INTO `voto_encuesta` VALUES
("1","3","6","152.170.27.207"),
("2","3","5","152.170.32.193"),
("3","3","5","152.170.5.24"),
("4","3","6","190.231.121.240"),
("5","3","5","152.170.16.187"),
("6","3","4","190.49.116.5"),
("7","3","6","181.92.116.135"),
("8","3","5","186.137.90.74"),
("9","3","6","152.170.19.129"),
("10","3","5","190.246.30.120"),
("11","3","5","152.170.1.10"),
("12","3","5","181.118.133.182"),
("13","3","4","190.191.127.9"),
("14","3","5","186.138.167.94"),
("15","3","5","190.247.232.170"),
("16","3","5","152.170.39.22"),
("17","3","5","152.170.4.26"),
("18","3","5","152.170.21.84"),
("19","3","5","152.170.13.112"),
("20","3","5","181.47.182.96"),
("21","3","5","190.247.225.172"),
("22","3","4","152.170.52.13"),
("23","3","5","190.178.206.121"),
("24","3","5","186.137.211.45"),
("25","3","6","190.178.205.11"),
("26","3","6","201.235.90.150"),
("27","3","5","186.137.208.216"),
("28","3","5","192.168.1.165"),
("29","3","4","192.168.1.238"),
("30","3","5","190.246.30.42"),
("31","3","4","186.13.2.182"),
("32","3","5","192.168.1.199"),
("33","3","6","152.170.4.231"),
("34","3","4","190.247.241.235"),
("35","3","5","191.81.199.68"),
("36","3","4","152.170.11.4"),
("37","3","5","181.118.137.83"),
("38","3","5","152.170.35.40"),
("39","3","5","152.170.4.81"),
("40","3","4","186.129.167.238"),
("41","3","5","181.28.197.223"),
("42","3","5","190.247.225.85"),
("43","3","5","129.34.20.19"),
("44","3","5","190.247.224.9"),
("45","3","5","186.137.208.112"),
("46","3","5","152.170.25.47"),
("47","3","5","181.228.222.203"),
("48","3","4","181.104.126.59"),
("49","3","5","152.170.23.59"),
("50","3","5","152.170.23.84"),
("51","3","5","186.129.143.176"),
("52","3","4","190.49.105.178"),
("53","3","5","186.62.201.225"),
("54","3","5","152.170.20.232"),
("55","3","6","191.81.132.140"),
("56","3","5","191.81.170.191"),
("57","3","5","181.28.197.35"),
("58","3","5","192.168.229.130"),
("59","3","5","190.229.36.182"),
("60","3","5","152.170.25.173"),
("61","3","6","191.81.140.78"),
("62","3","5","201.235.90.173"),
("63","3","5","152.170.7.225"),
("64","3","6","201.235.119.170"),
("65","3","5","152.170.18.174"),
("66","3","5","179.40.22.8"),
("67","3","5","186.0.207.68"),
("68","3","5","190.246.96.184"),
("69","3","5","152.170.21.142"),
("70","3","5","152.170.11.159"),
("71","3","4","152.170.45.5"),
("72","3","5","181.118.138.34"),
("73","3","5","186.129.160.245"),
("74","3","6","190.178.206.193"),
("75","3","5","152.170.24.231"),
("76","3","5","190.178.208.252"),
("77","3","5","96.57.200.42"),
("78","3","5","186.138.167.5"),
("79","3","5","190.231.104.244"),
("80","3","5","152.170.16.36"),
("81","3","5","192.168.0.153"),
("82","3","6","201.251.210.178"),
("83","3","6","181.117.5.42"),
("84","3","5","152.170.20.142"),
("85","3","5","190.247.224.17"),
("86","3","4","181.168.152.252"),
("87","3","5","191.81.175.81"),
("88","3","5","152.170.4.202"),
("89","3","5","190.49.109.123"),
("90","3","5","191.81.171.12"),
("91","3","4","190.178.205.166"),
("92","3","5","190.247.227.68"),
("93","3","5","186.13.4.193"),
("94","3","5","186.138.168.10"),
("95","3","5","190.246.30.14"),
("96","3","5","181.26.41.114"),
("97","3","5","200.49.206.193"),
("98","3","5","152.170.27.27"),
("99","3","5","191.81.207.79"),
("100","3","6","186.18.187.148"),
("101","3","5","191.81.180.68"),
("102","3","5","190.49.127.76"),
("103","3","5","152.170.8.166"),
("104","3","6","181.118.139.92"),
("105","3","5","190.19.173.240"),
("106","3","5","152.170.8.184"),
("107","3","5","152.170.22.154"),
("108","3","4","190.191.12.15"),
("109","3","4","181.165.228.106"),
("110","3","4","152.170.21.139"),
("111","3","4","190.178.194.55"),
("112","3","4","190.178.194.55"),
("113","3","4","191.81.165.91"),
("114","3","5","190.138.224.36"),
("115","3","5","190.231.96.218"),
("116","3","5","152.170.17.38"),
("117","3","5","190.247.227.152"),
("118","3","5","186.62.168.11"),
("119","3","4","186.129.188.82"),
("120","3","5","190.19.174.23"),
("121","3","5","186.129.181.37"),
("122","3","5","152.170.18.8"),
("123","3","4","191.81.200.166"),
("124","3","5","190.247.229.10"),
("125","3","5","152.170.36.37"),
("126","3","5","181.118.132.63"),
("127","3","5","181.117.0.56"),
("128","3","5","186.136.232.45"),
("129","3","5","190.139.94.96"),
("130","3","5","152.170.18.186"),
("131","3","4","190.178.211.98"),
("132","3","5","181.90.110.17"),
("133","3","5","181.26.24.156"),
("134","3","5","190.175.181.27"),
("135","3","5","152.170.8.35"),
("136","3","5","186.141.131.175"),
("137","3","5","190.246.96.151"),
("138","3","4","201.235.91.3"),
("139","3","6","186.62.157.30"),
("140","3","5","152.170.9.38"),
("141","3","5","190.246.96.132"),
("142","3","4","190.246.96.5"),
("143","3","5","152.170.46.2"),
("144","3","4","192.9.200.102"),
("145","3","5","10.240.28.5, 10.240."),
("146","3","5","186.129.135.30"),
("147","3","5","186.137.90.168"),
("148","3","4","152.170.25.38"),
("149","3","6","152.170.2.23"),
("150","3","5","168.226.35.38"),
("151","3","5","190.49.111.152"),
("152","3","6","191.81.128.126"),
("153","4","7","186.137.120.152"),
("154","4","8","172.16.41.4"),
("155","4","8","181.24.71.14"),
("156","4","7","192.168.1.199"),
("157","4","7","190.49.98.166"),
("158","4","9","152.170.16.36"),
("159","4","9","152.170.27.148"),
("160","4","8","152.170.35.40"),
("161","4","9","152.170.12.226"),
("162","4","8","152.170.32.193"),
("163","4","7","152.170.24.228"),
("164","4","8","186.129.159.218"),
("165","4","7","190.49.123.154"),
("166","4","8","186.129.136.246"),
("167","4","7","190.246.102.24"),
("168","4","9","152.170.25.61"),
("169","4","7","192.168.133.236"),
("170","4","9","152.170.27.85"),
("171","4","9","186.141.197.38"),
("172","4","9","190.49.104.104"),
("173","4","8","186.137.91.27"),
("174","4","8","186.136.226.47"),
("175","4","9","152.170.16.108"),
("176","4","9","152.170.31.22"),
("177","4","9","201.251.210.178"),
("178","4","9","201.235.91.131"),
("179","4","8","186.0.207.68"),
("180","4","8","152.170.24.95"),
("181","4","8","181.228.93.33"),
("182","4","7","172.20.20.119"),
("183","4","9","190.231.108.25"),
("184","4","7","10.240.28.5, 10.240."),
("185","4","9","186.108.73.46"),
("186","4","9","192.168.110.41"),
("187","4","8","10.240.28.5, 10.240."),
("188","4","8","192.168.228.85"),
("189","4","8","186.129.186.171"),
("190","4","9","181.118.133.182"),
("191","4","7","152.170.16.205"),
("192","4","9","190.247.232.170"),
("193","4","8","186.129.129.160"),
("194","4","7","186.62.194.205"),
("195","4","8","192.168.150.116"),
("196","4","8","190.231.121.240"),
("197","4","8","191.81.154.45"),
("198","4","8","152.170.28.162"),
("199","4","7","191.81.198.34"),
("200","4","8","181.92.116.135"),
("201","4","9","190.178.192.139"),
("202","4","8","190.247.222.142"),
("203","4","8","152.170.15.58"),
("204","4","7","190.175.191.206"),
("205","4","9","187.237.14.243"),
("206","4","8","152.170.22.197"),
("207","4","7","181.30.43.90"),
("208","4","7","186.138.167.94"),
("209","4","8","186.129.186.253"),
("210","4","9","186.137.90.74"),
("211","4","8","181.118.138.34"),
("212","4","9","186.62.170.138"),
("213","4","8","190.247.227.68"),
("214","4","8","190.247.241.235"),
("215","4","8","190.18.68.63"),
("216","4","8","201.235.95.66"),
("217","4","9","191.81.211.142"),
("218","4","8","152.168.66.78"),
("219","4","8","186.62.148.60"),
("220","4","7","186.129.178.12"),
("221","4","9","152.170.24.235"),
("222","4","7","152.170.32.76"),
("223","4","7","190.191.127.9"),
("224","4","9","192.9.200.170"),
("225","4","9","186.129.138.205"),
("226","4","8","168.226.35.38"),
("227","4","8","190.49.91.134"),
("228","4","8","190.175.185.244"),
("229","4","8","186.137.208.112"),
("230","4","7","181.118.136.23"),
("231","4","9","152.170.19.34"),
("232","4","9","190.247.235.32"),
("233","4","8","152.170.16.187"),
("234","4","9","152.170.22.154"),
("235","4","8","186.62.177.144"),
("236","4","8","190.191.143.27"),
("237","4","8","186.125.66.46"),
("238","4","8","190.49.127.80"),
("239","4","8","181.228.223.233"),
("240","4","7","190.246.96.184"),
("241","4","8","152.170.12.8"),
("242","4","7","152.170.2.119"),
("243","4","9","152.170.21.142"),
("244","4","8","186.109.12.152"),
("245","4","7","152.170.11.159"),
("246","4","8","190.247.232.58"),
("247","4","9","152.170.27.207"),
("248","4","7","190.246.103.129"),
("249","4","8","190.49.116.236"),
("250","4","8","186.137.211.45"),
("251","4","8","190.194.155.204"),
("252","4","8","190.178.201.22"),
("253","4","7","190.50.122.132"),
("254","4","8","152.170.30.183"),
("255","4","7","190.246.102.10"),
("256","4","7","186.0.233.163"),
("257","4","8","181.118.132.170"),
("258","4","9","191.81.157.126"),
("259","4","9","190.246.30.7"),
("260","4","8","190.246.30.42"),
("261","4","8","201.235.119.170"),
("262","4","7","181.228.222.203"),
("263","4","9","186.62.169.58"),
("264","4","9","181.28.197.223"),
("265","4","7","186.129.154.106"),
("266","4","7","190.18.218.50"),
("267","4","8","186.62.197.164"),
("268","4","8","186.129.146.201"),
("269","4","8","186.129.146.201"),
("270","4","7","168.226.35.205"),
("271","4","8","186.62.157.88"),
("272","4","8","152.170.39.22"),
("273","4","8","190.18.216.36"),
("274","4","9","181.30.25.98"),
("275","4","9","186.129.159.189"),
("276","4","8","186.137.208.216"),
("277","4","7","190.49.98.166"),
("278","4","8","186.62.138.106"),
("279","4","8","190.17.59.98"),
("280","4","8","201.235.94.116"),
("281","4","8","186.62.182.20"),
("282","4","8","10.240.28.5, 10.240."),
("283","4","8","190.49.124.159"),
("284","4","8","181.228.253.114"),
("285","4","8","152.170.50.37"),
("286","4","9","152.170.20.232"),
("287","4","7","190.175.171.15"),
("288","4","7","152.170.13.184"),
("289","4","7","186.125.67.148"),
("290","4","8","190.246.30.120"),
("291","4","9","190.175.172.228"),
("292","4","8","190.137.119.121"),
("293","4","8","190.246.101.28"),
("294","4","7","168.101.128.52"),
("295","4","8","152.170.6.216"),
("296","4","7","191.81.169.106"),
("297","4","8","191.81.137.237"),
("298","4","8","152.170.37.28"),
("299","4","9","190.246.30.254"),
("300","4","7","190.247.233.226"),
("301","4","9","152.170.9.37"),
("302","4","8","186.62.156.113"),
("303","4","8","152.170.27.100"),
("304","4","9","152.168.29.238"),
("305","4","9","152.170.8.71"),
("306","4","8","186.0.207.72"),
("307","4","8","152.170.4.174"),
("308","4","9","152.170.22.2"),
("309","4","7","181.28.197.19"),
("310","4","7","201.255.41.170"),
("311","4","9","181.14.168.49"),
("312","4","8","190.191.113.150"),
("313","4","9","152.170.28.89"),
("314","4","9","191.81.148.175"),
("315","4","7","192.168.1.165"),
("316","4","8","191.81.192.39"),
("317","4","9","201.250.239.210"),
("318","4","8","190.19.175.252"),
("319","4","9","192.168.224.85"),
("320","4","8","186.143.130.111"),
("321","4","9","152.170.13.211"),
("322","4","8","152.170.22.141"),
("323","4","8","186.62.182.248"),
("324","4","7","168.96.251.98"),
("325","4","8","190.49.94.157"),
("326","4","8","152.170.4.231"),
("327","4","7","200.49.206.193"),
("328","4","7","200.49.206.193"),
("329","4","7","200.49.206.193"),
("330","4","8","105.158.86.210"),
("331","4","9","152.170.1.198"),
("332","4","8","181.118.137.168"),
("333","4","9","152.170.36.37"),
("334","4","7","152.170.20.111"),
("335","4","7","191.81.186.239"),
("336","4","8","186.59.131.60"),
("337","4","7","181.228.222.93"),
("338","4","9","186.62.196.140"),
("339","4","8","186.109.19.160"),
("340","4","7","190.50.108.207"),
("341","4","8","152.170.26.237"),
("342","4","8","201.235.90.150"),
("343","4","9","201.235.91.173"),
("344","4","9","181.118.138.11"),
("345","4","8","190.49.97.42"),
("346","4","7","186.129.159.112"),
("347","4","7","152.170.6.123"),
("348","4","9","190.246.52.169"),
("349","4","8","192.168.203.61"),
("350","4","7","181.1.225.249"),
("351","4","8","186.129.251.126"),
("352","4","7","190.191.143.34"),
("353","4","7","191.81.210.40"),
("354","4","8","186.62.154.187"),
("355","4","7","186.129.152.88"),
("356","4","8","181.28.197.74"),
("357","4","9","186.141.198.205"),
("358","4","8","190.247.233.64"),
("359","4","7","190.49.105.42"),
("360","4","9","191.81.207.185"),
("361","4","8","190.191.8.103"),
("362","4","7","190.246.96.5"),
("363","4","9","152.170.26.162"),
("364","4","7","190.178.197.155"),
("365","4","7","190.178.197.155"),
("366","4","8","181.1.26.165"),
("367","4","9","152.170.2.23"),
("368","4","7","152.170.26.130"),
("369","4","8","190.175.152.0"),
("370","4","7","190.49.91.227"),
("371","4","9","152.170.58.37"),
("372","4","7","152.170.28.178"),
("373","4","7","191.81.142.95"),
("374","4","8","192.168.77.10"),
("375","4","7","191.81.152.114"),
("376","4","7","217.212.85.162"),
("377","4","8","152.170.9.115"),
("378","4","9","190.247.233.10"),
("379","4","7","192.168.224.96"),
("380","4","7","191.81.130.181"),
("381","4","9","186.22.120.5"),
("382","4","9","190.247.223.61"),
("383","4","8","46.193.179.27"),
("384","4","7","190.50.121.145"),
("385","4","7","190.49.98.91"),
("386","4","8","186.13.4.87"),
("387","4","8","190.175.180.179"),
("388","4","7","186.129.156.227"),
("389","4","8","190.137.167.174"),
("390","4","8","186.129.134.243"),
("391","4","8","152.170.32.139"),
("392","4","9","190.178.212.60"),
("393","4","7","190.19.174.61"),
("394","4","8","152.170.57.38"),
("395","4","7","186.19.241.24"),
("396","4","9","152.170.41.70"),
("397","4","9","186.158.136.100"),
("398","4","8","186.129.151.2"),
("399","4","7","152.170.15.176"),
("400","4","7","190.178.201.183"),
("401","4","9","190.231.108.207"),
("402","4","7","181.118.137.145"),
("403","4","9","181.28.197.77"),
("404","4","8","152.170.30.210"),
("405","4","7","181.28.197.205"),
("406","4","8","186.129.157.31"),
("407","4","7","152.170.36.14"),
("408","4","7","190.139.251.56"),
("409","4","7","191.81.134.208"),
("410","4","8","186.62.162.70"),
("411","4","7","186.138.167.5"),
("412","4","7","181.28.197.97"),
("413","4","9","190.18.216.55"),
("414","4","7","217.214.112.214"),
("415","4","8","186.129.162.21"),
("416","4","7","186.109.16.51"),
("417","4","7","186.129.173.100"),
("418","4","9","190.231.121.56"),
("419","4","8","186.62.156.188"),
("420","4","8","190.175.183.125"),
("421","4","7","181.24.5.165"),
("422","6","10","186.129.179.253"),
("423","6","10","181.229.132.56"),
("424","6","11","190.18.218.50"),
("425","6","11","152.170.27.207"),
("426","6","11","190.48.32.250"),
("427","6","11","190.247.241.235"),
("428","6","11","186.129.144.213"),
("429","6","11","181.16.91.88"),
("430","6","11","152.170.20.232"),
("431","6","10","190.178.203.174"),
("432","6","11","186.137.208.112"),
("433","6","11","190.247.222.16"),
("434","6","10","152.170.39.22"),
("435","6","10","186.62.150.254"),
("436","6","11","190.191.143.34"),
("437","6","10","190.247.233.226"),
("438","6","11","181.109.164.244"),
("439","6","11","186.62.155.218"),
("440","6","10","190.49.108.137"),
("441","6","10","201.235.119.170"),
("442","6","10","190.138.226.135"),
("443","6","11","191.81.141.232"),
("444","6","11","152.170.32.193"),
("445","6","10","192.168.203.15"),
("446","6","11","186.129.165.26"),
("447","6","10","190.231.122.248"),
("448","6","11","190.50.124.159"),
("449","6","11","190.175.159.195"),
("450","6","11","190.247.227.68"),
("451","6","10","190.178.192.246"),
("452","6","11","181.228.222.44"),
("453","6","11","190.31.38.94"),
("454","6","10","201.235.90.150"),
("455","6","11","190.136.232.86"),
("456","6","11","190.194.123.6"),
("457","6","10","190.247.232.58"),
("458","6","11","152.170.22.154"),
("459","6","10","186.137.208.50"),
("460","6","10","152.170.26.213"),
("461","6","10","190.50.121.97"),
("462","6","11","190.178.199.78"),
("463","6","10","186.141.130.24"),
("464","6","11","152.170.16.187"),
("465","6","11","181.29.207.181"),
("466","6","10","190.246.102.10"),
("467","6","11","190.178.208.211"),
("468","6","11","190.49.101.149"),
("469","6","10","186.141.197.15"),
("470","6","11","172.21.12.15, 172.21"),
("471","6","10","190.246.30.42"),
("472","6","11","152.170.9.171"),
("473","6","11","152.170.35.40"),
("474","6","11","170.210.113.26"),
("475","6","11","191.81.202.110"),
("476","6","11","190.195.67.147"),
("477","6","11","191.81.182.37"),
("478","6","11","190.175.160.113"),
("479","6","11","186.138.167.94"),
("480","6","11","94.83.187.155"),
("481","6","10","186.0.233.178"),
("482","6","10","186.62.180.57"),
("483","6","10","152.170.26.237"),
("484","6","11","190.49.92.32"),
("485","6","11","152.170.2.123"),
("486","6","11","186.22.120.5"),
("487","6","11","191.81.143.180"),
("488","6","10","190.246.96.5"),
("489","6","11","190.246.31.188"),
("490","6","10","190.19.175.252"),
("491","6","10","186.137.208.216"),
("492","6","10","190.191.143.27"),
("493","6","10","190.191.141.19"),
("494","6","11","152.170.58.9"),
("495","6","11","181.28.197.223"),
("496","6","10","190.195.68.27"),
("497","6","10","190.247.233.10"),
("498","6","11","190.226.190.183"),
("499","6","11","191.81.200.180"),
("500","6","11","186.141.130.35"),
("501","6","11","186.143.131.100"),
("502","6","11","152.170.56.38"),
("503","6","11","152.168.29.238"),
("504","6","10","181.28.197.19"),
("505","6","10","10.1.10.52"),
("506","6","11","201.219.64.91"),
("507","6","10","190.247.237.181"),
("508","6","11","190.138.226.80"),
("509","6","10","190.19.172.63"),
("510","6","11","168.226.35.38"),
("511","6","10","201.235.117.157"),
("512","6","11","181.92.116.135"),
("513","6","11","186.0.207.68"),
("514","6","11","186.0.207.68"),
("515","6","11","186.0.207.68"),
("516","6","11","186.0.207.68"),
("517","6","10","190.139.94.174"),
("518","6","10","192.9.200.102"),
("519","6","11","172.20.20.119"),
("520","6","10","152.170.42.24"),
("521","6","10","152.170.45.7"),
("522","6","10","152.170.26.72"),
("523","6","11","152.170.33.65"),
("524","6","10","152.170.22.197"),
("525","6","11","190.225.173.125"),
("526","6","11","152.170.15.71"),
("527","6","11","181.118.137.77"),
("528","6","11","191.81.151.129"),
("529","6","11","186.109.247.143"),
("530","6","11","191.81.148.106"),
("531","6","10","190.247.228.154"),
("532","6","11","190.19.174.61"),
("533","6","10","152.170.23.72"),
("534","6","11","181.24.152.244"),
("535","6","11","181.118.134.166"),
("536","6","11","72.90.252.202"),
("537","6","10","190.246.96.184"),
("538","6","10","190.18.218.13"),
("539","6","11","181.165.128.81"),
("540","6","10","190.49.118.239"),
("541","6","11","190.49.118.92"),
("542","6","11","186.158.142.121"),
("543","6","11","201.253.84.68"),
("544","6","11","186.129.176.84"),
("545","6","11","192.9.200.3"),
("546","6","11","186.129.136.14"),
("547","6","11","181.165.129.181"),
("548","6","10","192.168.203.92"),
("549","6","11","152.170.27.85"),
("550","6","11","152.170.23.13"),
("551","6","11","190.18.218.43"),
("552","6","11","191.81.138.109"),
("553","6","11","190.225.76.139"),
("554","6","11","190.19.174.224"),
("555","6","11","192.168.77.10"),
("556","6","11","201.235.94.14"),
("557","6","11","83.60.166.166"),
("558","6","10","152.170.12.149"),
("559","6","10","191.81.195.73"),
("560","6","11","152.170.13.68"),
("561","6","10","201.235.119.2"),
("562","6","11","181.118.138.11"),
("563","6","11","152.170.20.142"),
("564","6","11","191.81.163.163"),
("565","6","10","186.129.159.202"),
("566","6","11","190.246.103.252"),
("567","6","11","190.175.143.165"),
("568","6","11","152.170.1.130"),
("569","6","11","190.175.168.15"),
("570","6","11","152.170.55.4"),
("571","6","11","181.45.52.127"),
("572","6","10","191.81.131.19"),
("573","6","10","152.170.21.139"),
("574","6","11","186.129.190.93"),
("575","6","11","186.62.147.232"),
("576","6","11","186.141.131.169"),
("577","6","10","181.168.152.252"),
("578","6","11","191.81.169.160"),
("579","6","10","186.143.131.207"),
("580","6","11","186.13.7.93"),
("581","6","11","181.118.134.68"),
("582","6","11","152.170.11.159"),
("583","6","10","186.138.167.173"),
("584","6","10","181.118.139.242"),
("585","6","10","190.50.112.230"),
("586","6","10","190.50.125.42"),
("587","6","10","152.170.14.190"),
("588","6","11","181.95.147.72"),
("589","6","11","152.170.13.204"),
("590","6","11","181.165.129.217"),
("591","6","10","190.246.96.85"),
("592","6","11","190.49.123.25"),
("593","6","11","190.245.229.84"),
("594","6","11","186.129.162.153"),
("595","6","10","152.170.12.35"),
("596","6","10","190.247.239.40"),
("597","6","11","186.136.228.43"),
("598","6","11","152.170.2.40"),
("599","6","11","186.0.207.72"),
("600","6","10","186.13.2.224"),
("601","6","11","186.129.139.151"),
("602","6","10","186.138.168.44"),
("603","6","11","186.141.131.185"),
("604","6","11","191.81.191.79"),
("605","6","11","179.40.22.8"),
("606","6","11","186.182.172.27"),
("607","6","10","152.170.27.42"),
("608","6","11","190.49.106.138"),
("609","6","11","24.105.157.94"),
("610","6","11","191.81.160.163"),
("611","6","11","152.170.8.184"),
("612","6","10","181.1.238.227"),
("613","6","11","201.235.21.20"),
("614","6","10","190.137.167.33"),
("615","6","11","181.116.201.138"),
("616","6","11","152.170.28.89"),
("617","6","10","191.81.187.233"),
("618","6","11","152.170.12.8"),
("619","6","11","191.81.168.149"),
("620","6","10","186.137.211.12"),
("621","6","11","152.170.3.224"),
("622","6","11","186.141.131.231"),
("623","6","10","152.170.26.111"),
("624","6","11","190.191.12.158"),
("625","6","11","190.178.194.207"),
("626","6","11","152.170.18.76"),
("627","6","11","191.81.155.121"),
("628","6","11","186.129.169.47"),
("629","6","11","191.81.165.167"),
("630","6","10","186.129.148.58"),
("631","6","10","186.136.229.181"),
("632","6","11","186.141.198.89"),
("633","6","11","186.137.90.74"),
("634","6","11","152.170.30.210"),
("635","6","11","190.247.224.209"),
("636","6","11","186.129.158.86"),
("637","6","10","152.170.46.49"),
("638","6","10","190.50.125.18"),
("639","6","10","186.129.153.255"),
("640","7","12","186.137.208.216"),
("641","7","12","152.170.5.7"),
("642","7","13","181.118.134.166"),
("643","7","14","201.235.90.173"),
("644","7","14","186.136.232.13"),
("645","7","12","191.81.158.165"),
("646","7","13","190.178.202.22"),
("647","7","12","186.138.167.239"),
("648","7","14","186.137.211.45"),
("649","7","14","190.49.110.15"),
("650","7","13","152.170.27.207"),
("651","7","12","190.244.184.38"),
("652","7","12","200.69.243.161"),
("653","7","12","190.49.113.225"),
("654","7","12","181.164.52.129"),
("655","7","14","186.137.208.112"),
("656","7","12","190.246.96.5"),
("657","7","14","186.158.138.125"),
("658","7","14","186.158.138.125"),
("659","7","14","186.158.138.125"),
("660","7","12","190.246.102.10"),
("661","7","12","79.147.167.11"),
("662","7","12","152.170.14.56"),
("663","7","14","190.247.241.235"),
("664","7","12","190.246.30.42"),
("665","7","12","186.129.168.161"),
("666","7","12","190.49.111.85"),
("667","7","12","172.16.231.230"),
("668","7","13","172.20.20.119"),
("669","7","13","186.62.152.21"),
("670","7","13","152.170.32.193"),
("671","7","12","192.168.203.15"),
("672","7","12","200.55.36.194"),
("673","7","12","186.137.211.4"),
("674","7","12","186.143.131.246"),
("675","7","12","152.170.22.141"),
("676","7","12","181.24.15.70"),
("677","7","12","190.18.216.36"),
("678","7","12","192.168.150.133"),
("679","7","13","181.16.91.88"),
("680","7","12","190.191.143.27"),
("681","7","12","192.168.110.12"),
("682","7","12","152.170.3.56"),
("683","7","14","190.191.143.34"),
("684","7","13","190.175.160.55"),
("685","7","13","186.62.179.165"),
("686","7","12","181.229.132.56"),
("687","7","13","200.123.164.97"),
("688","7","13","186.141.198.11"),
("689","7","13","190.246.101.168"),
("690","7","14","186.137.120.39"),
("691","7","12","152.170.16.23"),
("692","7","13","152.170.33.65"),
("693","7","12","152.170.19.97"),
("694","7","12","186.129.144.203"),
("695","7","14","152.170.58.9"),
("696","7","12","181.166.74.116"),
("697","7","13","190.178.194.105"),
("698","7","14","186.136.226.156"),
("699","7","13","190.225.76.139"),
("700","7","12","190.225.76.139"),
("701","7","12","190.137.118.159"),
("702","7","12","190.50.120.67"),
("703","7","12","190.50.118.100"),
("704","7","12","186.129.138.73"),
("705","7","12","152.170.51.16"),
("706","7","12","181.118.138.11"),
("707","7","12","181.168.152.252"),
("708","7","14","186.141.130.186"),
("709","7","12","186.0.207.68"),
("710","7","12","190.247.233.226"),
("711","7","12","186.129.151.173"),
("712","7","12","190.247.227.68"),
("713","7","12","181.14.174.13"),
("714","7","12","181.165.128.72"),
("715","7","14","186.129.188.125"),
("716","7","12","152.170.8.228"),
("717","7","12","186.62.176.195"),
("718","7","12","186.0.207.72"),
("719","7","12","190.230.133.162"),
("720","7","12","191.81.198.54"),
("721","7","12","152.170.0.204"),
("722","7","12","190.246.30.105"),
("723","7","13","181.118.135.78"),
("724","7","12","186.182.172.27"),
("725","7","12","152.170.21.142"),
("726","7","12","152.170.15.58"),
("727","7","12","186.141.131.195"),
("728","7","13","152.170.16.187"),
("729","7","12","186.129.142.45"),
("730","7","13","152.170.19.17"),
("731","7","12","186.129.189.28"),
("732","7","13","181.165.129.47"),
("733","7","14","190.138.225.31"),
("734","7","13","192.168.1.165"),
("735","7","12","191.81.137.35"),
("736","7","12","192.168.1.116"),
("737","7","14","181.165.128.81"),
("738","7","12","190.178.208.199"),
("739","7","12","181.29.208.24"),
("740","7","12","191.81.183.198"),
("741","7","13","186.129.178.114"),
("742","7","14","152.170.13.16"),
("743","7","14","192.168.1.149"),
("744","7","13","190.247.239.217"),
("745","7","12","186.137.211.156"),
("746","7","12","190.49.96.21"),
("747","7","14","186.129.146.77"),
("748","7","12","186.143.197.195"),
("749","7","12","201.251.210.178"),
("750","7","12","152.170.7.225"),
("751","7","12","152.170.19.129"),
("752","7","12","190.175.156.143"),
("753","7","12","192.168.109.199"),
("754","7","12","186.13.4.222"),
("755","7","12","186.13.4.222"),
("756","7","13","152.170.21.8"),
("757","7","12","152.170.14.190"),
("758","7","12","152.170.23.212"),
("759","7","12","152.170.3.119"),
("760","7","14","186.138.166.3"),
("761","7","12","152.170.31.220"),
("762","7","13","146.158.247.192"),
("763","7","14","181.228.222.44"),
("764","7","14","181.228.222.44"),
("765","7","12","201.235.90.150"),
("766","7","14","201.235.94.14"),
("767","7","14","190.175.165.198"),
("768","7","12","191.81.159.146"),
("769","7","12","186.129.188.73"),
("770","7","12","186.129.178.22"),
("771","7","12","190.178.200.86"),
("772","7","14","190.17.59.233"),
("773","7","12","152.170.30.39"),
("774","7","12","181.29.207.64"),
("775","7","13","190.49.96.238"),
("776","7","12","152.170.45.4"),
("777","7","13","152.170.11.159"),
("778","7","12","190.50.112.175"),
("779","7","12","181.24.44.222"),
("780","7","12","152.170.12.149"),
("781","7","14","186.13.6.249"),
("782","7","14","186.13.6.249"),
("783","7","12","152.170.22.154"),
("784","7","12","152.170.32.39"),
("785","7","13","181.228.223.233"),
("786","7","14","186.141.198.143"),
("787","7","13","190.178.210.125"),
("788","7","13","181.118.135.21"),
("789","7","12","152.170.28.49"),
("790","7","13","186.141.197.155"),
("791","7","14","172.21.12.15, 172.21"),
("792","7","13","186.129.185.159"),
("793","7","12","201.235.119.170"),
("794","7","12","186.109.14.53"),
("795","7","12","191.81.191.5"),
("796","7","12","152.170.1.26"),
("797","7","12","152.170.2.5"),
("798","7","13","168.226.35.38"),
("799","7","12","192.168.1.93"),
("800","7","12","152.170.16.36"),
("801","7","12","186.129.145.66"),
("802","7","13","191.81.201.74"),
("803","7","12","186.62.190.116"),
("804","7","12","186.143.197.73"),
("805","7","12","186.0.233.163"),
("806","7","13","152.170.30.65"),
("807","7","12","152.170.25.38"),
("808","7","12","191.81.180.252"),
("809","7","14","186.138.168.11"),
("810","7","12","152.170.27.85"),
("811","7","13","10.9.4.233"),
("812","7","13","190.175.180.242"),
("813","7","12","209.13.159.125"),
("814","7","13","152.170.43.7"),
("815","7","13","192.168.229.130"),
("816","7","12","152.170.25.48"),
("817","7","12","186.129.184.220"),
("818","7","12","186.129.149.115"),
("819","7","12","200.49.219.55"),
("820","7","12","200.49.219.55"),
("821","7","13","186.108.72.206"),
("822","7","12","191.81.149.114"),
("823","7","12","190.175.185.96"),
("824","7","12","190.50.106.55"),
("825","7","12","186.129.141.192"),
("826","7","12","181.28.218.117"),
("827","7","12","190.247.234.242"),
("828","7","14","191.81.186.223"),
("829","7","13","191.81.179.212"),
("830","7","14","186.62.129.229"),
("831","7","12","186.136.230.4"),
("832","7","12","192.168.110.41"),
("833","7","12","191.81.174.58"),
("834","7","12","200.49.193.193"),
("835","7","12","192.168.138.69"),
("836","7","12","186.129.156.22"),
("837","7","12","152.170.8.180"),
("838","7","13","192.168.10.61"),
("839","7","14","152.170.34.101"),
("840","7","12","152.170.1.10"),
("841","7","12","186.109.16.220"),
("842","7","14","190.189.33.7"),
("843","7","12","10.240.28.11"),
("844","7","13","186.0.207.68"),
("845","7","13","186.0.207.68"),
("846","7","13","186.129.171.166"),
("847","7","13","190.138.226.1"),
("848","7","12","190.191.13.231"),
("849","7","12","89.101.209.18"),
("850","7","12","152.170.9.37"),
("851","7","12","190.246.103.112"),
("852","7","13","190.18.217.42"),
("853","7","12","191.81.136.126"),
("854","7","12","200.117.85.52"),
("855","7","13","186.137.91.27"),
("856","7","12","152.170.2.231"),
("857","7","12","186.13.0.43"),
("858","7","12","152.170.0.174"),
("859","7","12","186.62.149.137"),
("860","7","12","186.138.168.44"),
("861","7","13","186.129.155.214"),
("862","7","13","190.31.36.175"),
("863","7","12","10.240.28.5, 10.240."),
("864","7","14","181.28.135.109"),
("865","7","14","191.81.150.98"),
("866","7","12","152.170.9.212"),
("867","7","12","190.49.111.125"),
("868","7","12","200.5.253.45"),
("869","7","12","201.219.64.91"),
("870","7","13","152.170.2.23"),
("871","7","12","192.168.155.68"),
("872","7","12","186.143.131.205"),
("873","7","12","95.242.167.85"),
("874","7","12","190.247.240.239"),
("875","7","12","190.18.218.50"),
("876","7","13","190.178.211.4"),
("877","7","14","152.170.57.18"),
("878","7","14","190.175.134.97"),
("879","7","12","181.92.119.205"),
("880","7","12","186.129.152.64"),
("881","7","12","66.50.105.86"),
("882","7","12","186.141.131.43"),
("883","7","12","152.170.25.128"),
("884","7","12","152.170.30.160"),
("885","7","13","201.235.95.16"),
("886","7","12","186.129.139.92"),
("887","7","12","192.168.0.153"),
("888","7","12","181.28.197.97"),
("889","7","13","186.62.22.137"),
("890","7","12","181.24.28.29"),
("891","7","12","152.170.3.199"),
("892","7","13","190.178.200.17"),
("893","7","12","152.170.32.246"),
("894","7","12","186.129.162.82"),
("895","7","12","190.191.143.58"),
("896","7","12","190.191.143.58"),
("897","7","14","186.129.174.215"),
("898","7","14","181.224.178.210"),
("899","7","12","152.170.47.11"),
("900","7","12","190.225.97.105"),
("901","7","12","152.170.54.32"),
("902","7","13","186.129.155.137"),
("903","7","13","152.170.12.8"),
("904","7","12","181.24.32.150"),
("905","7","12","191.81.165.161"),
("906","7","13","186.158.141.111"),
("907","7","13","186.129.143.14"),
("908","7","13","186.129.143.14"),
("909","7","12","152.170.12.97"),
("910","7","13","190.138.193.8"),
("911","7","12","152.170.13.137"),
("912","7","12","186.138.167.94"),
("913","7","12","181.170.254.76"),
("914","7","12","152.170.21.139"),
("915","7","12","152.170.34.96"),
("916","7","14","191.81.144.180"),
("917","7","12","152.170.17.38"),
("918","7","12","186.129.176.183"),
("919","7","12","181.116.201.78"),
("920","7","14","186.129.248.168"),
("921","7","13","190.19.174.58"),
("922","7","12","181.1.245.190"),
("923","7","12","181.95.117.157"),
("924","7","12","191.81.165.76"),
("925","7","13","179.51.90.139"),
("926","7","13","186.137.90.118"),
("927","7","12","181.111.248.234"),
("928","8","16","191.81.196.253"),
("929","8","15","152.170.27.218"),
("930","8","16","152.170.14.66"),
("931","8","16","186.137.208.112"),
("932","8","16","152.170.21.8"),
("933","8","16","191.81.131.99"),
("934","8","16","152.170.14.48"),
("935","8","15","190.229.38.156"),
("936","8","16","152.170.32.193"),
("937","8","16","201.235.94.116"),
("938","8","16","152.170.21.142"),
("939","8","16","152.170.30.119"),
("940","8","16","190.139.250.2"),
("941","8","15","190.138.195.189"),
("942","8","16","201.235.91.3"),
("943","8","15","190.138.226.239"),
("944","8","15","152.170.32.189"),
("945","8","15","152.170.32.189"),
("946","8","15","152.170.2.123"),
("947","8","15","152.170.34.101"),
("948","8","15","191.81.139.144"),
("949","8","15","152.170.27.207"),
("950","8","16","152.170.5.7"),
("951","8","15","181.228.222.44"),
("952","8","15","200.49.193.194"),
("953","8","16","190.231.104.244"),
("954","8","16","192.168.110.41"),
("955","8","15","191.81.142.97"),
("956","8","15","191.81.203.240"),
("957","8","16","201.140.188.58"),
("958","8","16","200.63.167.13"),
("959","8","16","190.178.6.14"),
("960","8","16","181.118.137.77"),
("961","8","16","152.170.27.85"),
("962","8","15","152.170.17.125"),
("963","8","16","190.231.247.135"),
("964","8","16","186.62.197.141"),
("965","8","15","172.20.20.119"),
("966","8","15","191.81.133.190"),
("967","8","16","186.129.164.84"),
("968","8","16","190.49.119.126"),
("969","8","16","190.247.229.118"),
("970","8","16","186.129.160.59"),
("971","8","16","186.62.186.12"),
("972","8","15","190.247.234.2"),
("973","8","16","186.129.154.245"),
("974","8","15","152.170.33.65"),
("975","8","15","190.247.227.152"),
("976","8","15","190.138.226.1"),
("977","8","16","152.170.15.58"),
("978","8","16","200.51.95.2"),
("979","8","15","190.191.138.135"),
("980","8","15","152.170.19.34"),
("981","8","16","186.137.211.45"),
("982","8","16","190.49.126.213"),
("983","8","16","152.170.11.79"),
("984","8","16","181.29.207.82"),
("985","8","16","191.81.204.198"),
("986","8","15","152.170.54.59"),
("987","8","16","186.129.153.42"),
("988","8","16","190.246.96.5"),
("989","8","15","190.175.162.185"),
("990","8","16","181.28.197.205"),
("991","8","16","191.81.135.29"),
("992","8","16","152.170.11.159"),
("993","8","15","190.246.100.188"),
("994","8","16","190.50.126.202"),
("995","8","16","191.81.207.194"),
("996","8","15","190.49.123.254"),
("997","8","15","201.235.117.157"),
("998","8","15","192.168.1.165"),
("999","8","16","190.246.30.42"),
("1000","8","15","181.28.197.97"),
("1001","8","16","152.170.26.130"),
("1002","8","16","192.168.1.173"),
("1003","8","16","190.50.117.149"),
("1004","10","19","190.49.117.208"),
("1005","10","19","181.169.111.124"),
("1006","10","20","190.50.106.41"),
("1007","10","20","190.247.89.29");
|
:: Command execute :: | |
--[ c99shell v.2.1 [PHP 7 Update] [1.12.2019] maintained by KaizenLouie and updated by cermmik | C99Shell Github (MySQL update) | Generation time: 0.3385 ]-- |