/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 5.7.31 : Database - practice_toelvo_anexa
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`practice_toelvo_anexa` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `practice_toelvo_anexa`;

/*Table structure for table `__log_evento` */


CREATE TABLE `__log_evento` (
  `id_registro` int(11) NOT NULL AUTO_INCREMENT,
  `nombre_evento` varchar(1000) DEFAULT NULL,
  `fe_ejecucion` datetime DEFAULT NULL,
  PRIMARY KEY (`id_registro`)
) ENGINE=InnoDB AUTO_INCREMENT=733 DEFAULT CHARSET=latin1;

/*Table structure for table `af_articulo` */




/*Table structure for table `af_categoria` */




/*Table structure for table `af_color` */




/*Table structure for table `af_disciplina` */




/*Table structure for table `af_grupo` */




/*Table structure for table `af_marca_producto` */




/*Table structure for table `af_proveedor` */




/*Table structure for table `af_rubro` */




/*Table structure for table `af_tags` */




/*Table structure for table `af_talle` */




/*Table structure for table `rsp_articulo` */




/*Table structure for table `rsp_categoria` */




/*Table structure for table `rsp_color` */




/*Table structure for table `rsp_disciplina` */




/*Table structure for table `rsp_grupo` */




/*Table structure for table `rsp_marca_producto` */




/*Table structure for table `rsp_proveedor` */




/*Table structure for table `rsp_rubro` */




/*Table structure for table `rsp_tags` */




/*Table structure for table `rsp_talle` */




/*Table structure for table `tmp_art_updateables` */


CREATE TABLE `tmp_art_updateables` (
  `id` int(11) NOT NULL DEFAULT '0',
  `proveedor_id` int(11) NOT NULL,
  `talle_id` int(11) NOT NULL,
  `color_id` int(11) NOT NULL,
  `tags_id` int(11) DEFAULT NULL COMMENT 'Id Tags',
  `disciplina_id` int(11) NOT NULL,
  `marca_id` int(11) NOT NULL,
  `categoria_id` int(11) NOT NULL,
  `grupo_id` int(11) NOT NULL,
  `rubro_id` int(11) NOT NULL,
  `descripcion` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `genero` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `stock_minimo` int(11) DEFAULT NULL,
  `precio` decimal(10,2) DEFAULT NULL,
  `fe_ult_act_l1` datetime DEFAULT NULL,
  `precio2` decimal(10,2) DEFAULT NULL,
  `fe_ult_act_l2` datetime DEFAULT NULL,
  `precio3` decimal(11,2) DEFAULT NULL,
  `fe_ult_act_l3` datetime DEFAULT NULL,
  `dolar_cotizacion` decimal(11,2) DEFAULT NULL,
  `precio_costo_dolar` decimal(11,2) DEFAULT NULL,
  `costo` decimal(11,2) DEFAULT NULL,
  `stock_minimo_pagina` int(11) DEFAULT NULL,
  `stock_pagina` int(11) DEFAULT NULL,
  `stock_sucursal` int(11) DEFAULT NULL,
  `observaciones` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `transferido` tinyint(1) DEFAULT NULL,
  `modificado` tinyint(1) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `iva_venta` decimal(10,0) DEFAULT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `cantidad_imagenes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modificado_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agregado_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modificado_stock` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_articulos` */


CREATE TABLE `tmp_articulos` (
  `id` int(11) NOT NULL DEFAULT '0',
  `proveedor_id` int(11) NOT NULL,
  `talle_id` int(11) NOT NULL,
  `color_id` int(11) NOT NULL,
  `tags_id` int(11) DEFAULT NULL COMMENT 'Id Tags',
  `disciplina_id` int(11) NOT NULL,
  `marca_id` int(11) NOT NULL,
  `categoria_id` int(11) NOT NULL,
  `grupo_id` int(11) NOT NULL,
  `rubro_id` int(11) NOT NULL,
  `descripcion` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `genero` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `stock_minimo` int(11) DEFAULT NULL,
  `precio` decimal(10,2) DEFAULT NULL,
  `fe_ult_act_l1` datetime DEFAULT NULL,
  `precio2` decimal(10,2) DEFAULT NULL,
  `fe_ult_act_l2` datetime DEFAULT NULL,
  `precio3` decimal(11,2) DEFAULT NULL,
  `fe_ult_act_l3` datetime DEFAULT NULL,
  `dolar_cotizacion` decimal(11,2) DEFAULT NULL,
  `precio_costo_dolar` decimal(11,2) DEFAULT NULL,
  `costo` decimal(11,2) DEFAULT NULL,
  `stock_minimo_pagina` int(11) DEFAULT NULL,
  `stock_pagina` int(11) DEFAULT NULL,
  `stock_sucursal` int(11) DEFAULT NULL,
  `observaciones` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `transferido` tinyint(1) DEFAULT NULL,
  `modificado` tinyint(1) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `iva_venta` decimal(10,0) DEFAULT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `cantidad_imagenes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modificado_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agregado_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modificado_stock` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_articulos2` */


CREATE TABLE `tmp_articulos2` (
  `proveedor_id` int(11) NOT NULL,
  `talle_id` int(11) NOT NULL,
  `color_id` int(11) NOT NULL,
  `tags_id` int(11) DEFAULT NULL COMMENT 'Id Tags',
  `disciplina_id` int(11) NOT NULL,
  `marca_id` int(11) NOT NULL,
  `categoria_id` int(11) NOT NULL,
  `grupo_id` int(11) NOT NULL,
  `rubro_id` int(11) NOT NULL,
  `descripcion` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `genero` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stock` int(11) DEFAULT NULL,
  `stock_minimo` int(11) DEFAULT NULL,
  `precio` decimal(10,2) DEFAULT NULL,
  `fe_ult_act_l1` datetime DEFAULT NULL,
  `precio2` decimal(10,2) DEFAULT NULL,
  `fe_ult_act_l2` datetime DEFAULT NULL,
  `precio3` decimal(11,2) DEFAULT NULL,
  `fe_ult_act_l3` datetime DEFAULT NULL,
  `dolar_cotizacion` decimal(11,2) DEFAULT NULL,
  `precio_costo_dolar` decimal(11,2) DEFAULT NULL,
  `costo` decimal(11,2) DEFAULT NULL,
  `stock_minimo_pagina` int(11) DEFAULT NULL,
  `stock_pagina` int(11) DEFAULT NULL,
  `stock_sucursal` int(11) DEFAULT NULL,
  `observaciones` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `transferido` tinyint(1) DEFAULT NULL,
  `modificado` tinyint(1) DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `iva_venta` decimal(10,0) DEFAULT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `cantidad_imagenes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modificado_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agregado_local` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modificado_stock` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_categoriaes` */


CREATE TABLE `tmp_categoriaes` (
  `id` int(11) NOT NULL DEFAULT '0',
  `grupo_id` int(11) NOT NULL,
  `nombre` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_colores` */


CREATE TABLE `tmp_colores` (
  `id` int(11) NOT NULL DEFAULT '0',
  `color` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_disciplinaes` */


CREATE TABLE `tmp_disciplinaes` (
  `id` int(11) NOT NULL DEFAULT '0',
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_grupoes` */


CREATE TABLE `tmp_grupoes` (
  `id` int(11) NOT NULL DEFAULT '0',
  `rubro_id` int(11) DEFAULT NULL,
  `nom_grupo` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_marca_productoes` */


CREATE TABLE `tmp_marca_productoes` (
  `id` int(11) NOT NULL DEFAULT '0',
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_proveedores` */


CREATE TABLE `tmp_proveedores` (
  `id` int(11) NOT NULL DEFAULT '0',
  `cond_iva_id` int(11) DEFAULT NULL,
  `nombre` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `domicilio` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ciudad` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provincia` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pais` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telefonos` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel_comercial` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comentarios` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cod_postal` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `web` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `porc_lista1` int(11) DEFAULT NULL,
  `porc_lista2` int(11) DEFAULT NULL,
  `porc_lista3` int(11) DEFAULT NULL,
  `no_acepta_descuentos` tinyint(1) DEFAULT NULL,
  `cuilt` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nom_banco` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_banco` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cbu` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `razon_social` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_cond_ante_iva` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_rubroes` */


CREATE TABLE `tmp_rubroes` (
  `id` int(11) NOT NULL DEFAULT '0',
  `descripcion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_tagses` */


CREATE TABLE `tmp_tagses` (
  `id` int(11) NOT NULL DEFAULT '0' COMMENT 'Id Tags',
  `descripcion` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Descripcion Tag',
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `tmp_tallees` */


CREATE TABLE `tmp_tallees` (
  `id` int(11) NOT NULL DEFAULT '0',
  `talle` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activo` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

