-- phpMyAdmin SQL Dump
-- version 4.6.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 08, 2017 at 07:23 PM
-- Server version: 5.7.13
-- PHP Version: 5.5.38

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `madira`
--

--
-- Dumping data for table `condicion_de_pago`
--

INSERT INTO `condicion_de_pago` (`id`, `diferido_id`, `contra_entrega_id`, `discr`) VALUES
(1, NULL, NULL, 'Contra Entrega'),
(2, NULL, NULL, 'Diferido'),
(3, NULL, NULL, 'Dos Pagos'),
(4, NULL, NULL, 'Contra Factura');

--
-- Dumping data for table `impuesto_valor_agregado`
--

INSERT INTO `impuesto_valor_agregado` (`id`, `porcentaje`) VALUES
(1, '0.00'),
(2, '21.00'),
(3, '10.50');

--
-- Dumping data for table `proveedor`
--

INSERT INTO `proveedor` (`id`, `razonSocial`, `codigo`, `cuit`, `nombre_fantasia`, `domicilio`, `telefono`, `url_web`, `localidad`, `provincia`, `codigo_postal`, `contacto`, `cargo`, `email`, `telefono_contacto`, `rubro`, `entidad_bancaria`, `nro_cuenta`, `cbu`, `descuento`, `condicion_entrega`, `observaciones`) VALUES
(1, 'Giliberto Hnos.', '135', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.0', '', ''),
(2, 'Juan Navarro SA', '138', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.0', '', ''),
(4, 'Allutec SA', '222', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'SIMET', '213', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);



--
-- Dumping data for table `producto`
--

INSERT INTO `producto` (`id`, `descripcion`, `minimo`, `codigo`, `stock_id`, `proveedor_id`) VALUES
(6, 'Poly espuma aluminizada 5mm 1 x 20 mts', 10, '897', NULL, 1),
(7, 'Poly espuma aluminizada 10mm 1 x 20 mts', 10, '8857', NULL, 1);



--
-- Dumping data for table `precio_lista`
--

INSERT INTO `precio_lista` (`id`, `proveedor_id`, `producto_id`, `valor`, `fecha`, `moneda`) VALUES
(5, 1, 6, '50.00', '2012-01-01', '$');


--
-- Dumping data for table `proveedor_condiciones_pago`
--

INSERT INTO `proveedor_condiciones_pago` (`proveedor_id`, `condicion_pago_id`) VALUES
(5, 1),
(5, 2),
(5, 3),
(5, 4);

--
-- Dumping data for table `tipo_cuenta`
--

INSERT INTO `tipo_cuenta` (`id`, `descripcion`) VALUES
(1, 'Cuenta 1'),
(2, 'Cuenta 2');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
