-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: May 17, 2021 at 02:46 AM
-- Server version: 5.7.17-log
-- PHP Version: 5.6.30

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: `green_fresh2`
--

-- --------------------------------------------------------

--
-- Table structure for table `almacen`
--

CREATE TABLE `almacen` (
  `id_almacen` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL,
  `encargado` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `almacen`
--

INSERT INTO `almacen` (`id_almacen`, `nombre`, `encargado`) VALUES
(1, 'almacen-1', 'sandro'),
(4, 'ALMACEN-2', 'asdasd'),
(5, 'ALMACEN-3', '123');

-- --------------------------------------------------------

--
-- Table structure for table `apertura_caja`
--

CREATE TABLE `apertura_caja` (
  `id` int(11) NOT NULL,
  `fecha_apertura` date NOT NULL,
  `hora_apertura` datetime NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci NOT NULL,
  `monto_apertura` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `contado` float(19,2) NOT NULL,
  `diferencia` float(19,2) NOT NULL,
  `hora_cierre` datetime NOT NULL,
  `fecha_cierre` date NOT NULL,
  `caja` text COLLATE utf8_spanish2_ci NOT NULL,
  `estado` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `apertura_caja`
--

INSERT INTO `apertura_caja` (`id`, `fecha_apertura`, `hora_apertura`, `usuario`, `monto_apertura`, `balance`, `contado`, `diferencia`, `hora_cierre`, `fecha_cierre`, `caja`, `estado`) VALUES
(1, '2021-05-13', '2021-05-13 21:34:19', 'admin', 10.00, -8340.00, 9000.00, 17340.00, '2021-05-15 01:02:27', '2021-05-15', '01', 'Cerrado'),
(2, '2021-05-15', '2021-05-15 07:25:20', 'admin', 0.00, -950.00, 1500.00, 2450.00, '2021-05-15 22:24:36', '2021-05-15', '01', 'Cerrado'),
(3, '2021-05-15', '2021-05-15 22:27:19', 'admin', 100.00, 100.00, 85.00, -15.00, '2021-05-15 22:27:28', '2021-05-15', '01', 'Cerrado'),
(4, '2021-05-15', '2021-05-15 22:29:04', 'admin', 1500.00, 1500.00, 1950.00, 450.00, '2021-05-15 22:29:13', '2021-05-15', '01', 'Cerrado'),
(5, '2021-05-15', '2021-05-15 22:47:43', 'admin', 0.00, 44750.00, 44750.00, 0.00, '2021-05-16 17:30:47', '2021-05-16', '01', 'Cerrado'),
(6, '2021-05-16', '2021-05-16 17:31:13', 'admin', 1500.00, 0.00, 0.00, 0.00, '0000-00-00 00:00:00', '0000-00-00', '01', 'Abierto');

-- --------------------------------------------------------

--
-- Table structure for table `cajas`
--

CREATE TABLE `cajas` (
  `id` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL,
  `estado` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `cajas`
--

INSERT INTO `cajas` (`id`, `nombre`, `estado`) VALUES
(1, '01', ''),
(2, 'CAJA-1', '');

-- --------------------------------------------------------

--
-- Table structure for table `cheques`
--

CREATE TABLE `cheques` (
  `id_cheque` int(11) NOT NULL,
  `numero_cheque` varchar(12) NOT NULL DEFAULT '..',
  `pagado_a` varchar(75) NOT NULL DEFAULT '..',
  `fecha_emision` date NOT NULL,
  `fecha_limit` date NOT NULL,
  `referencia` varchar(100) NOT NULL DEFAULT '..',
  `monto` double NOT NULL,
  `estado` varchar(25) NOT NULL DEFAULT '..',
  `cuenta` varchar(65) NOT NULL DEFAULT '..',
  `usuario` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `choferes`
--

CREATE TABLE `choferes` (
  `id_chofer` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL,
  `cedula` text COLLATE utf8_spanish2_ci NOT NULL,
  `telefono` text COLLATE utf8_spanish2_ci NOT NULL,
  `direccion` text COLLATE utf8_spanish2_ci NOT NULL,
  `tipo` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `choferes`
--

INSERT INTO `choferes` (`id_chofer`, `nombre`, `cedula`, `telefono`, `direccion`, `tipo`) VALUES
(1, 'Chofer de prueba', '334', '344', '34', 'Sindicato');

-- --------------------------------------------------------

--
-- Table structure for table `clientes`
--

CREATE TABLE `clientes` (
  `id_cliente` int(11) NOT NULL,
  `nombre` varchar(100) NOT NULL DEFAULT '[..]',
  `balance` double NOT NULL DEFAULT '0',
  `alow_vencidas` int(11) NOT NULL DEFAULT '0',
  `ultimo_pago` date DEFAULT NULL,
  `telefono` varchar(20) NOT NULL DEFAULT '..',
  `direccion` varchar(150) NOT NULL DEFAULT '[..]',
  `cedula` varchar(45) NOT NULL DEFAULT '..',
  `clave` varchar(45) NOT NULL DEFAULT '..',
  `max_credito` double NOT NULL DEFAULT '0',
  `max_dias` int(11) NOT NULL DEFAULT '0',
  `precio` int(2) NOT NULL DEFAULT '1',
  `enviado` int(11) NOT NULL,
  `termino_venta` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `clientes`
--

INSERT INTO `clientes` (`id_cliente`, `nombre`, `balance`, `alow_vencidas`, `ultimo_pago`, `telefono`, `direccion`, `cedula`, `clave`, `max_credito`, `max_dias`, `precio`, `enviado`, `termino_venta`) VALUES
(1, 'Cliente de pruebas', 0, 0, NULL, '000001', 'Dajabon', '0000001', '..', 0, 0, 1, 0, NULL),
(2, 'Proveedor de prueba', 0, 0, NULL, '00001', '0', '000001', '..', 0, 0, 1, 0, NULL),
(6, 'ALEXANDRO SANTANA MENDEZ', 0, 0, NULL, '8493587693', 'DAJABON', '07300173916', '..', 10, 0, 1, 0, NULL),
(4, 'erw', 0, 0, NULL, 'erwer', 'werwer', 'erwerw', '..', 10000, 0, 1, 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `compras`
--

CREATE TABLE `compras` (
  `id_venta` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `proveedor` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `impuesto` float(19,2) NOT NULL,
  `descuento` float(19,2) NOT NULL,
  `total` float(19,2) NOT NULL,
  `pagado` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci NOT NULL,
  `folio` text COLLATE utf8_spanish2_ci NOT NULL,
  `termino` text COLLATE utf8_spanish2_ci NOT NULL,
  `pago_con` float(19,2) NOT NULL,
  `devuelta` float(19,2) NOT NULL,
  `ncf` text COLLATE utf8_spanish2_ci NOT NULL,
  `tipo_ncf` text COLLATE utf8_spanish2_ci NOT NULL,
  `nota` text COLLATE utf8_spanish2_ci NOT NULL,
  `fecha_pago` date NOT NULL,
  `estado` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `compras`
--

INSERT INTO `compras` (`id_venta`, `fecha`, `hora`, `proveedor`, `costo`, `precio`, `impuesto`, `descuento`, `total`, `pagado`, `balance`, `usuario`, `folio`, `termino`, `pago_con`, `devuelta`, `ncf`, `tipo_ncf`, `nota`, `fecha_pago`, `estado`) VALUES
(1, '2021-05-15', '2021-05-15 22:08:27', 'Proveedor de prueba', 190.00, 0.00, 28.98, 0.00, 190.00, 150.00, 40.00, 'admin', '1', 'Credito', 0.00, 0.00, '', '', '\n              ', '2021-05-15', ''),
(2, '2021-05-15', '2021-05-15 22:09:16', 'Proveedor de prueba', 100.00, 0.00, 0.00, 0.00, 100.00, 0.00, 100.00, 'admin', '2', 'Credito', 0.00, 0.00, '', '', '', '0000-00-00', '');

-- --------------------------------------------------------

--
-- Table structure for table `compra_factoria`
--

CREATE TABLE `compra_factoria` (
  `id` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `folio` text COLLATE utf8_german2_ci NOT NULL,
  `variedad` text COLLATE utf8_german2_ci NOT NULL,
  `sacos` float(19,2) NOT NULL,
  `tara` float(19,2) NOT NULL,
  `fanega` float(19,2) NOT NULL,
  `per_descuento` float(19,2) NOT NULL,
  `descuento_saco` float(19,2) NOT NULL,
  `neto` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `produccion` float(19,2) NOT NULL,
  `fecha_entrega` date NOT NULL,
  `hora` datetime NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `sacos_devueltos` float(19,2) NOT NULL,
  `chofer` text COLLATE utf8_german2_ci NOT NULL,
  `tipo_chofer` text COLLATE utf8_german2_ci NOT NULL,
  `pago_flete` text COLLATE utf8_german2_ci NOT NULL,
  `productor` text COLLATE utf8_german2_ci NOT NULL,
  `nota` text COLLATE utf8_german2_ci NOT NULL,
  `ncf` text COLLATE utf8_german2_ci NOT NULL,
  `balance` float(19,2) NOT NULL,
  `pagado` float NOT NULL,
  `fecha_pago` date NOT NULL,
  `estado` text COLLATE utf8_german2_ci NOT NULL,
  `placa` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `compra_factoria`
--

INSERT INTO `compra_factoria` (`id`, `fecha`, `folio`, `variedad`, `sacos`, `tara`, `fanega`, `per_descuento`, `descuento_saco`, `neto`, `precio`, `produccion`, `fecha_entrega`, `hora`, `usuario`, `sacos_devueltos`, `chofer`, `tipo_chofer`, `pago_flete`, `productor`, `nota`, `ncf`, `balance`, `pagado`, `fecha_pago`, `estado`, `placa`) VALUES
(1, '2021-05-15', '1', 'PUITA', 150.00, 0.75, 135.00, 7.00, 9.45, 124.80, 2500.00, 312000.00, '2021-05-15', '2021-05-15 01:00:11', 'admin', 0.00, 'Chofer de prueba', 'Sindicato', '10000', 'Proveedor de prueba', '', '', 312000.00, 0, '0000-00-00', '', '6+9+9+'),
(2, '2021-05-15', '2', 'PUITA', 99.00, 0.50, 100.00, 6.00, 6.00, 93.50, 2350.00, 219736.75, '2021-05-15', '2021-05-15 21:55:07', 'admin', 0.00, 'Chofer de prueba', 'Empleado', '500', 'Proveedor de prueba', '', '', 219736.75, 0, '0000-00-00', '', '4514');

-- --------------------------------------------------------

--
-- Table structure for table `cuentas`
--

CREATE TABLE `cuentas` (
  `id_cuenta` int(11) NOT NULL,
  `numero_cuenta` text COLLATE utf8_german2_ci NOT NULL,
  `descripcion` text COLLATE utf8_german2_ci NOT NULL,
  `total_ingreso` float(19,2) NOT NULL,
  `total_egreso` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `cuentas`
--

INSERT INTO `cuentas` (`id_cuenta`, `numero_cuenta`, `descripcion`, `total_ingreso`, `total_egreso`, `balance`) VALUES
(1, '11001', 'BANRESERVAS', 0.00, 0.00, 25000.00);

-- --------------------------------------------------------

--
-- Table structure for table `cuentas_corrientes`
--

CREATE TABLE `cuentas_corrientes` (
  `id_cuenta` int(11) NOT NULL,
  `numero_cuenta` varchar(55) NOT NULL,
  `banco` varchar(55) NOT NULL,
  `concepto` varchar(55) NOT NULL,
  `siguiente_cheque` int(11) NOT NULL,
  `saldo` double NOT NULL,
  `fecha_apertura` date NOT NULL,
  `saldo_inicial` double DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `depo_reti`
--

CREATE TABLE `depo_reti` (
  `id_transaccion` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `tipo` varchar(45) NOT NULL,
  `referencia` varchar(65) NOT NULL,
  `monto` double NOT NULL,
  `id_cuenta` int(12) NOT NULL,
  `por_quien` varchar(65) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `detalle_compra`
--

CREATE TABLE `detalle_compra` (
  `id_detalle` int(11) NOT NULL,
  `folio` text COLLATE utf8_spanish2_ci NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` double(19,2) NOT NULL,
  `total_costo` float(19,2) NOT NULL,
  `total_precio` float(19,2) NOT NULL,
  `importe` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci,
  `fecha` date DEFAULT NULL,
  `cantidad` float(19,2) DEFAULT NULL,
  `tipo_impuesto` float(19,2) NOT NULL,
  `valor_impuesto` float(19,2) NOT NULL,
  `total_impuesto` float(19,2) NOT NULL,
  `devuelto` int(11) NOT NULL,
  `proveedor` text COLLATE utf8_spanish2_ci NOT NULL,
  `unidad` text COLLATE utf8_spanish2_ci NOT NULL,
  `variedad` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `detalle_compra`
--

INSERT INTO `detalle_compra` (`id_detalle`, `folio`, `codigo`, `descripcion`, `costo`, `precio`, `total_costo`, `total_precio`, `importe`, `usuario`, `fecha`, `cantidad`, `tipo_impuesto`, `valor_impuesto`, `total_impuesto`, `devuelto`, `proveedor`, `unidad`, `variedad`) VALUES
(1, '1', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 18.00, 15.25, 15.25, 0, 'Proveedor de prueba', 'null', 'null'),
(2, '1', '001', 'ARROZ ', 0.00, 0.00, 0.00, 0.00, 0.00, 'admin', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 'Proveedor de prueba', 'null', 'null'),
(3, '1', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 18.00, 13.73, 13.73, 0, 'Proveedor de prueba', 'UNIDAD', 'PUITA'),
(4, '1', '001', 'ARROZ ', 0.00, 0.00, 0.00, 0.00, 0.00, 'admin', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 'Proveedor de prueba', 'null', 'null'),
(5, '2', '001', 'ARROZ ', 100.00, 200.00, 100.00, 200.00, 0.00, 'admin', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 'Proveedor de prueba', 'null', 'null');

-- --------------------------------------------------------

--
-- Table structure for table `detalle_compra_factoria`
--

CREATE TABLE `detalle_compra_factoria` (
  `id_detalle` int(11) NOT NULL,
  `folio` text COLLATE utf8_spanish2_ci NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` double(19,2) NOT NULL,
  `total_costo` float(19,2) NOT NULL,
  `total_precio` float(19,2) NOT NULL,
  `importe` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci,
  `fecha` date DEFAULT NULL,
  `cantidad` float(19,2) DEFAULT NULL,
  `tipo_impuesto` float(19,2) NOT NULL,
  `valor_impuesto` float(19,2) NOT NULL,
  `total_impuesto` float(19,2) NOT NULL,
  `devuelto` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `detalle_compra_factoria`
--

INSERT INTO `detalle_compra_factoria` (`id_detalle`, `folio`, `codigo`, `descripcion`, `costo`, `precio`, `total_costo`, `total_precio`, `importe`, `usuario`, `fecha`, `cantidad`, `tipo_impuesto`, `valor_impuesto`, `total_impuesto`, `devuelto`) VALUES
(1, '1', '001', 'ARROZ ', 2500.00, 0.00, 375000.00, 0.00, 0.00, 'admin', '2021-05-15', 150.00, 0.00, 0.00, 0.00, 0),
(2, '2', '001', 'ARROZ ', 2350.00, 0.00, 232650.00, 0.00, 0.00, 'admin', '2021-05-15', 99.00, 0.00, 0.00, 0.00, 0);

-- --------------------------------------------------------

--
-- Table structure for table `detalle_pendiente`
--

CREATE TABLE `detalle_pendiente` (
  `caja` text COLLATE utf8_spanish2_ci NOT NULL,
  `id_detalle` int(11) DEFAULT NULL,
  `folio` text COLLATE utf8_spanish2_ci NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` double(19,2) NOT NULL,
  `total_costo` float(19,2) NOT NULL,
  `total_precio` float(19,2) NOT NULL,
  `importe` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci,
  `fecha` date DEFAULT NULL,
  `cantidad` float(19,2) DEFAULT NULL,
  `tipo_impuesto` float(19,2) NOT NULL,
  `valor_impuesto` float(19,2) NOT NULL,
  `total_impuesto` float(19,2) NOT NULL,
  `devuelto` int(11) NOT NULL,
  `id_venta` int(11) NOT NULL,
  `precio2` double(19,2) NOT NULL,
  `anulado` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `detalle_pendiente`
--

INSERT INTO `detalle_pendiente` (`caja`, `id_detalle`, `folio`, `codigo`, `descripcion`, `costo`, `precio`, `total_costo`, `total_precio`, `importe`, `usuario`, `fecha`, `cantidad`, `tipo_impuesto`, `valor_impuesto`, `total_impuesto`, `devuelto`, `id_venta`, `precio2`, `anulado`, `nombre`) VALUES
('01', 159, '0130', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 450.00, 'admin', '2021-05-16', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, 'dsa'),
('01', 160, '0130', '1254', 'cerveza corona ', 85.00, 150.00, 85.00, 150.00, 450.00, 'admin', '2021-05-16', 1.00, 0.00, 0.00, 0.00, 0, 0, 0.00, 0, 'dsa'),
('01', 161, '0130', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 450.00, 'admin', '2021-05-16', 1.00, 0.00, 0.00, 0.00, 0, 0, 0.00, 0, 'dsa');

-- --------------------------------------------------------

--
-- Table structure for table `detalle_venta`
--

CREATE TABLE `detalle_venta` (
  `caja` text COLLATE utf8_spanish2_ci NOT NULL,
  `id_detalle` int(11) NOT NULL,
  `folio` text COLLATE utf8_spanish2_ci NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` double(19,2) NOT NULL,
  `total_costo` float(19,2) NOT NULL,
  `total_precio` float(19,2) NOT NULL,
  `importe` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci,
  `fecha` date DEFAULT NULL,
  `cantidad` float(19,2) DEFAULT NULL,
  `tipo_impuesto` float(19,2) NOT NULL,
  `valor_impuesto` float(19,2) NOT NULL,
  `total_impuesto` float(19,2) NOT NULL,
  `devuelto` int(11) NOT NULL,
  `id_venta` int(11) NOT NULL,
  `precio2` double(19,2) NOT NULL,
  `anulado` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `detalle_venta`
--

INSERT INTO `detalle_venta` (`caja`, `id_detalle`, `folio`, `codigo`, `descripcion`, `costo`, `precio`, `total_costo`, `total_precio`, `importe`, `usuario`, `fecha`, `cantidad`, `tipo_impuesto`, `valor_impuesto`, `total_impuesto`, `devuelto`, `id_venta`, `precio2`, `anulado`, `nombre`) VALUES
('01', 68, '013', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 0.00, 0.00, 0.00, 0, 0, 185.00, 1, ''),
('01', 83, '014', '1254', 'cerveza corona ', 85.00, 150.00, 85.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 0.00, 0.00, 0.00, 0, 0, 0.00, 1, 'pooosdd'),
('01', 84, '014', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 30.00, 90.00, 30.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 0.00, 0, 0, 0.00, 1, 'pooosdd'),
('01', 85, '015', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 1, ''),
('01', 86, '015', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 0, 185.00, 1, ''),
('01', 87, '016', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 185.00, 0, ''),
('01', 88, '017', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 89, '017', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 185.00, 0, ''),
('01', 90, '017', '1254', 'cerveza corona ', 85.00, 150.00, 85.00, 150.00, 0.00, 'admin', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 0, 160.00, 0, ''),
('01', 91, '017', '001', 'ARROZ ', 100.00, 0.00, 100.00, 0.00, 0.00, 'admin', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 0, 0.00, 0, ''),
('01', 93, '018', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 8500.00, 12750.00, 0.00, 'admin', '2021-05-15', 85.00, 18.00, 22.88, 0.00, 0, 0, 185.00, 0, ''),
('01', 106, '0110', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, 'ewrwer'),
('01', 107, '0111', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 108, '0112', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 109, '0113', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 0, 185.00, 0, ''),
('01', 110, '0114', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 111, '0114', '1254', 'cerveza corona ', 85.00, 150.00, 85.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 0, 160.00, 0, ''),
('01', 112, '0115', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '4545665'),
('01', 113, '0116', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, 'eerr'),
('01', 114, '0117', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 0, 185.00, 0, ''),
('01', 115, '0118', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '88745'),
('01', 116, '0119', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 117, '0120', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 118, '0120', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'Prueba', '2021-05-15', 1.00, 0.00, 0.00, 0.00, 0, 0, 185.00, 0, ''),
('01', 119, '0121', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '4545'),
('01', 120, '0122', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, 'fffd'),
('01', 121, '0122', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, 'fffd'),
('01', 122, '0122', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, 'fffd'),
('01', 123, '0122', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, 'fffd'),
('01', 127, '0123', '1254', 'cerveza corona ', 85.00, 800.00, 72250000.00, 680000000.00, 0.00, 'admin', '2021-05-14', 850000.00, 0.00, 0.00, 0.00, 0, 0, 0.00, 0, 'dfgdfg'),
('01', 130, '0124', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '8874'),
('01', 131, '0124', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '8874'),
('01', 132, '0124', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '8874'),
('01', 133, '0124', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '8874'),
('01', 134, '0124', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-14', 1.00, 18.00, 22.88, 22.88, 0, 0, 0.00, 0, '8874'),
('01', 135, '0124', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 10.00, 7650.00, 850.00, 0.00, 'admin', '2021-05-14', 85.00, 18.00, 22.88, 129.62, 0, 0, 0.00, 0, '8874'),
('01', 146, '0126', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 100.00, 90.00, 100.00, 0.00, 'admin', '2021-05-16', 1.00, 18.00, 22.88, 0.00, 1, 0, 145.00, 0, ''),
('01', 147, '0126', '1254', 'cerveza corona ', 85.00, 150.00, 85.00, 150.00, 0.00, 'admin', '2021-05-16', 1.00, 0.00, 0.00, 0.00, 0, 0, 160.00, 0, ''),
('01', 148, '0126', 'A0012254', 'ARROZ LA GARZA 125 LB.', 1100.00, 1500.00, 22000.00, 30000.00, 0.00, 'admin', '2021-05-16', 20.00, 0.00, 0.00, 0.00, 0, 0, 1485.00, 0, ''),
('01', 149, '0127', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-16', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 150, '0128', '1254', 'cerveza corona ', 85.00, 150.00, 1700.00, 3000.00, 0.00, 'admin', '2021-05-16', 20.00, 0.00, 0.00, 0.00, 0, 0, 160.00, 0, ''),
('01', 151, '0128', '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 100.00, 150.00, 0.00, 'admin', '2021-05-16', 1.00, 0.00, 0.00, 0.00, 0, 0, 185.00, 0, ''),
('01', 152, '0128', '1254', 'cerveza corona ', 85.00, 150.00, 85.00, 150.00, 0.00, 'admin', '2021-05-16', 1.00, 0.00, 0.00, 0.00, 0, 0, 160.00, 0, ''),
('01', 153, '0128', 'A0012254', 'ARROZ LA GARZA 125 LB.', 1100.00, 1500.00, 220000.00, 300000.00, 0.00, 'admin', '2021-05-16', 200.00, 0.00, 0.00, 0.00, 0, 0, 1485.00, 0, ''),
('01', 154, '0128', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 90.00, 150.00, 0.00, 'admin', '2021-05-16', 1.00, 18.00, 22.88, 22.88, 0, 0, 145.00, 0, ''),
('01', 155, '0128', '1254', 'cerveza corona ', 85.00, 150.00, 85.00, 150.00, 0.00, 'admin', '2021-05-16', 1.00, 0.00, 0.00, 0.00, 0, 0, 160.00, 0, ''),
('01', 162, '0129', 'A0012254', 'ARROZ LA GARZA 125 LB.', 1100.00, 1500.00, 1100.00, 1500.00, 0.00, 'admin', '2021-05-16', 1.00, 0.00, 0.00, 0.00, 0, 0, 1485.00, 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `devoluciones`
--

CREATE TABLE `devoluciones` (
  `id` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `hora` text COLLATE utf8_german2_ci NOT NULL,
  `folio` text COLLATE utf8_german2_ci NOT NULL,
  `codigo` text COLLATE utf8_german2_ci NOT NULL,
  `descripcion` text COLLATE utf8_german2_ci NOT NULL,
  `cantidad` float(19,2) NOT NULL,
  `importe` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `nota` text COLLATE utf8_german2_ci NOT NULL,
  `cliente` text COLLATE utf8_german2_ci NOT NULL,
  `secuencia` text COLLATE utf8_german2_ci NOT NULL,
  `impuestos` float(19,2) NOT NULL,
  `costo` float(19,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `devoluciones`
--

INSERT INTO `devoluciones` (`id`, `fecha`, `hora`, `folio`, `codigo`, `descripcion`, `cantidad`, `importe`, `usuario`, `nota`, `cliente`, `secuencia`, `impuestos`, `costo`) VALUES
(1, '2021-05-16', '2021-05-16 17:33:26', '0126', 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 1.00, 100.00, 'admin', 'ERROR', 'ALEXANDRO SANTANA MENDEZ', '6-01', 22.88, 90.00);

-- --------------------------------------------------------

--
-- Table structure for table `egresos`
--

CREATE TABLE `egresos` (
  `id` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `monto` float(19,2) NOT NULL,
  `cliente` text COLLATE utf8_german2_ci NOT NULL,
  `tipo` text COLLATE utf8_german2_ci NOT NULL,
  `concepto` text COLLATE utf8_german2_ci NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `secuencia` text COLLATE utf8_german2_ci NOT NULL,
  `chofer` text COLLATE utf8_german2_ci NOT NULL,
  `efectivo` float(19,2) NOT NULL,
  `cheque` float(19,2) NOT NULL,
  `numero_cheque` text COLLATE utf8_german2_ci NOT NULL,
  `tarjeta` float(19,2) NOT NULL,
  `folio_egreso` text COLLATE utf8_german2_ci NOT NULL,
  `proveedor` text COLLATE utf8_german2_ci NOT NULL,
  `pagado_a` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `egresos`
--

INSERT INTO `egresos` (`id`, `fecha`, `hora`, `monto`, `cliente`, `tipo`, `concepto`, `usuario`, `secuencia`, `chofer`, `efectivo`, `cheque`, `numero_cheque`, `tarjeta`, `folio_egreso`, `proveedor`, `pagado_a`) VALUES
(1, '2021-05-15', '2021-05-15 01:00:11', 10000.00, '', 'Flete', 'Pago flete chofer: Chofer de prueba, por carga arroz en cascara, compra #: 1', 'admin', '1-01', '', 0.00, 0.00, '', 0.00, '', '', ''),
(2, '2021-05-15', '2021-05-15 21:52:19', 1000.00, 'ghghuj', 'Otros', '4512', 'admin', '2-01', '', 0.00, 0.00, '', 0.00, '', '', ''),
(3, '2021-05-15', '2021-05-15 21:55:07', 500.00, '', 'Flete', 'Pago flete chofer: Chofer de prueba, por carga arroz en cascara, compra #: 2', 'admin', '2-01', '', 0.00, 0.00, '', 0.00, '', '', ''),
(4, '2021-05-15', '2021-05-15 22:31:28', 150.00, '', 'Compra', 'Pago de facturas de compra<br>Proveedor de prueba<br>Distribucion de pago: | Factura #: (1), abono: 150.00,', 'admin', '', '', 150.00, 0.00, '', 0.00, 'admin1', '', 'Proveedor de prueba'),
(5, '2021-05-16', '2021-05-16 21:21:07', 45.00, '100', 'Flete', 'l;jklj', 'admin', '6-01', '', 0.00, 0.00, '', 0.00, '', '', ''),
(6, '2021-05-16', '2021-05-16 21:22:03', 100.00, 'kjjkhjh', 'Flete', '5645644', 'admin', '6-01', '', 0.00, 0.00, '', 0.00, '', '', ''),
(7, '2021-05-16', '2021-05-16 21:51:18', 100.00, '45', 'Flete', '655', 'admin', '6-01', '', 0.00, 0.00, '', 0.00, '', '', ''),
(8, '2021-05-16', '2021-05-16 21:53:47', 1000.00, 'SANDRO', 'Flete', '411111', 'admin', '6-01', '', 0.00, 0.00, '', 0.00, '', '', 'SANDRO');

-- --------------------------------------------------------

--
-- Table structure for table `empleados`
--

CREATE TABLE `empleados` (
  `id_empleado` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL,
  `cedula` text COLLATE utf8_spanish2_ci NOT NULL,
  `telefono` text COLLATE utf8_spanish2_ci NOT NULL,
  `direccion` text COLLATE utf8_spanish2_ci NOT NULL,
  `cargo` text COLLATE utf8_spanish2_ci NOT NULL,
  `salario` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

-- --------------------------------------------------------

--
-- Table structure for table `empresa`
--

CREATE TABLE `empresa` (
  `id` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL,
  `telefono` text COLLATE utf8_spanish2_ci NOT NULL,
  `direccion` text COLLATE utf8_spanish2_ci NOT NULL,
  `rnc` text COLLATE utf8_spanish2_ci NOT NULL,
  `email` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `empresa`
--

INSERT INTO `empresa` (`id`, `nombre`, `telefono`, `direccion`, `rnc`, `email`) VALUES
(1, 'kuykh', 'jkhghg', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `impuestos`
--

CREATE TABLE `impuestos` (
  `id` int(11) NOT NULL,
  `nombre` text COLLATE utf8_german2_ci NOT NULL,
  `valor` float(19,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `impuestos`
--

INSERT INTO `impuestos` (`id`, `nombre`, `valor`) VALUES
(1, 'ITBIS', 18.00);

-- --------------------------------------------------------

--
-- Table structure for table `ingresos`
--

CREATE TABLE `ingresos` (
  `id` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `monto` float(19,2) NOT NULL,
  `cliente` text COLLATE utf8_german2_ci NOT NULL,
  `tipo` text COLLATE utf8_german2_ci NOT NULL,
  `concepto` text COLLATE utf8_german2_ci NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `secuencia` text COLLATE utf8_german2_ci NOT NULL,
  `efectivo` float(19,2) NOT NULL,
  `tarjeta` float(19,2) NOT NULL,
  `cheque` float(19,2) NOT NULL,
  `numero_cheque` text COLLATE utf8_german2_ci NOT NULL,
  `folio_ingreso` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `ingresos`
--

INSERT INTO `ingresos` (`id`, `fecha`, `hora`, `monto`, `cliente`, `tipo`, `concepto`, `usuario`, `secuencia`, `efectivo`, `tarjeta`, `cheque`, `numero_cheque`, `folio_ingreso`) VALUES
(1, '2021-05-15', '2021-05-15 01:03:10', 800.00, 'ERTERT', 'Otros', 'ERTERT', 'admin', '1-01', 800.00, 0.00, 0.00, '', ''),
(2, '2021-05-15', '2021-05-15 21:51:13', 100.00, 'dfgh', 'Otros', 'dfgdfg', 'admin', '2-01', 100.00, 0.00, 0.00, '', ''),
(3, '2021-05-16', '2021-05-16 01:02:33', 200.00, 'Cliente de pruebas', 'Credito', 'Pago de facturas a credito,  | Venta #: (016), abono: [150.00, | Venta #: (0117), abono: 50.00,', 'Prueba', '5-01', 200.00, 0.00, 0.00, '', 'Prueba1'),
(4, '2021-05-16', '2021-05-16 01:03:08', 2000.00, 'erw', 'Credito', 'Pago de facturas a credito,  | Venta #: (0110), abono: [150.00, | Venta #: (0111), abono: [150.00, | Venta #: (0112), abono: [150.00, | Venta #: (0113), abono: [150.00, | Venta #: (0114), abono: [300.00, | Venta #: (0115), abono: [150.00, | Venta #: (0116), abono: [150.00,', 'Prueba', '5-01', 2000.00, 0.00, 0.00, '', 'Prueba2'),
(5, '2021-05-16', '2021-05-16 21:19:00', 500.00, 'Cliente de pruebas', 'Credito', 'Pago de facturas a credito,  | Venta #: (0117), abono: [100.00,', 'admin', '6-01', 500.00, 0.00, 0.00, '', 'admin3'),
(6, '2021-05-16', '2021-05-16 21:48:08', 100.00, 'ALEXANDRO SANTANA MENDEZ', 'Credito', 'Pago de facturas a credito,  | Venta #: (), abono: 100.00,', 'admin', '6-01', 100.00, 0.00, 0.00, '', 'admin4');

-- --------------------------------------------------------

--
-- Table structure for table `inventario`
--

CREATE TABLE `inventario` (
  `id_inventario` int(11) NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `impuesto` float(19,2) NOT NULL,
  `almacen` text COLLATE utf8_spanish2_ci NOT NULL,
  `cantidad` float(19,2) NOT NULL,
  `tipo_impuestos` float(19,2) NOT NULL,
  `valor_impuestos` float(19,2) NOT NULL,
  `precio2` double(19,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `inventario`
--

INSERT INTO `inventario` (`id_inventario`, `codigo`, `descripcion`, `costo`, `precio`, `impuesto`, `almacen`, `cantidad`, `tipo_impuestos`, `valor_impuestos`, `precio2`) VALUES
(1, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', 90.00, 150.00, 0.00, 'almacen-1', -284.00, 18.00, 22.88, 145.00),
(2, '100', 'CERVEZA MODELO RUBIA PEQUENA', 100.00, 150.00, 0.00, 'almacen-1', -255.00, 0.00, 22.88, 185.00),
(3, '1254', 'cerveza corona ', 85.00, 150.00, 0.00, 'almacen-1', -850018.00, 0.00, 22.88, 160.00),
(4, '001', 'asdasdf', 56.00, 0.00, 0.00, 'almacen-1', 106.00, 0.00, 0.00, 0.00),
(5, '001', 'asdasdf', 56.00, 0.00, 0.00, 'ALMACEN-2', 145.00, 0.00, 0.00, 0.00),
(6, '001', 'asdasdf', 56.00, 0.00, 0.00, 'almacen-1', 5.00, 0.00, 0.00, 0.00),
(7, '002', 'sdfsd', 100.00, 150.00, 0.00, 'almacen-1', 0.00, 0.00, 0.00, 10.00),
(8, 'A0012254', 'ARROZ LA GARZA 125 LB.', 1100.00, 1500.00, 0.00, 'almacen-1', -121.00, 0.00, 0.00, 1485.00);

-- --------------------------------------------------------

--
-- Table structure for table `kardex`
--

CREATE TABLE `kardex` (
  `id_kardex` int(11) NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `fecha` date NOT NULL,
  `tipo` text COLLATE utf8_spanish2_ci NOT NULL,
  `cantidad` float(19,2) NOT NULL,
  `concepto` text COLLATE utf8_spanish2_ci NOT NULL,
  `hora` datetime NOT NULL,
  `almacen` text COLLATE utf8_spanish2_ci NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `kardex`
--

INSERT INTO `kardex` (`id_kardex`, `codigo`, `descripcion`, `fecha`, `tipo`, `cantidad`, `concepto`, `hora`, `almacen`, `usuario`) VALUES
(1, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-13', 'Recibido', 10.00, 'sdfsdf', '2021-05-13 19:51:49', 'almacen-1', 'admin'),
(2, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-13', 'Retirado', 1.00, 'Venta : 011', '2021-05-13 21:34:36', 'almacen-1', 'admin'),
(3, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-13', 'Retirado', 1.00, 'Venta : 011', '2021-05-13 21:34:36', 'almacen-1', 'admin'),
(4, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-13', 'Retirado', 1.00, 'Venta : 011', '2021-05-13 21:34:36', 'almacen-1', 'admin'),
(5, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-13', 'Retirado', 1.00, 'Venta : 011', '2021-05-13 21:34:36', 'almacen-1', 'admin'),
(6, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-13', 'Retirado', 1.00, 'Venta : 011', '2021-05-13 21:34:36', 'almacen-1', 'admin'),
(7, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-13', 'Retirado', 1.00, 'Venta : 011', '2021-05-13 21:34:36', 'almacen-1', 'admin'),
(8, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-14', 'Retirado', 10.00, 'Venta : 012', '2021-05-14 13:05:56', 'almacen-1', 'admin'),
(9, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-14', 'Retirado', 1.00, 'Venta : 013', '2021-05-14 22:28:45', 'almacen-1', 'admin'),
(10, '001', 'ARROZ ', '2021-05-15', 'Entrada', 150.00, 'Compra : 1', '2021-05-15 01:00:11', 'ALMACEN-2', 'admin'),
(11, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 014', '2021-05-15 21:50:34', 'almacen-1', 'admin'),
(12, '1254', 'cerveza corona ', '2021-05-15', 'Retirado', 1.00, 'Venta : 014', '2021-05-15 21:50:34', 'almacen-1', 'admin'),
(13, '001', 'ARROZ ', '2021-05-15', 'Entrada', 99.00, 'Compra : 2', '2021-05-15 21:55:07', 'almacen-1', 'admin'),
(14, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 015', '2021-05-15 21:56:26', 'almacen-1', 'admin'),
(15, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 1.00, 'Venta : 015', '2021-05-15 21:56:26', 'almacen-1', 'admin'),
(16, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Entrada', 1.00, 'Compra : 1', '2021-05-15 22:08:27', 'almacen-1', 'admin'),
(17, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Entrada', 1.00, 'Compra : 1', '2021-05-15 22:08:27', 'almacen-1', 'admin'),
(18, '001', 'ARROZ ', '2021-05-15', 'Entrada', 1.00, 'Compra : 1', '2021-05-15 22:08:27', 'almacen-1', 'admin'),
(19, '001', 'ARROZ ', '2021-05-15', 'Entrada', 1.00, 'Compra : 1', '2021-05-15 22:08:27', 'almacen-1', 'admin'),
(20, '001', 'ARROZ ', '2021-05-15', 'Entrada', 1.00, 'Compra : 2', '2021-05-15 22:09:16', 'almacen-1', 'admin'),
(21, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 1.00, 'Venta : 016', '2021-05-15 22:10:07', 'almacen-1', 'admin'),
(22, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 017', '2021-05-15 22:14:16', 'almacen-1', 'admin'),
(23, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 1.00, 'Venta : 017', '2021-05-15 22:14:16', 'almacen-1', 'admin'),
(24, '1254', 'cerveza corona ', '2021-05-15', 'Retirado', 1.00, 'Venta : 017', '2021-05-15 22:14:16', 'almacen-1', 'admin'),
(25, '001', 'ARROZ ', '2021-05-15', 'Retirado', 1.00, 'Venta : 017', '2021-05-15 22:14:16', 'almacen-1', 'admin'),
(26, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 85.00, 'Venta : 018', '2021-05-15 23:14:12', 'almacen-1', 'admin'),
(27, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 85.00, 'Venta : 018', '2021-05-15 23:14:12', 'almacen-1', 'admin'),
(28, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 85.00, 'Venta : 018', '2021-05-15 23:14:13', 'almacen-1', 'admin'),
(29, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0110', '2021-05-15 23:42:16', 'almacen-1', 'Prueba'),
(30, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0111', '2021-05-15 23:44:01', 'almacen-1', 'Prueba'),
(31, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0112', '2021-05-15 23:44:50', 'almacen-1', 'Prueba'),
(32, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 1.00, 'Venta : 0113', '2021-05-15 23:46:59', 'almacen-1', 'Prueba'),
(33, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0114', '2021-05-15 23:47:58', 'almacen-1', 'Prueba'),
(34, '1254', 'cerveza corona ', '2021-05-15', 'Retirado', 1.00, 'Venta : 0114', '2021-05-15 23:47:58', 'almacen-1', 'Prueba'),
(35, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0115', '2021-05-15 23:51:26', 'almacen-1', 'Prueba'),
(36, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0116', '2021-05-15 23:52:00', 'almacen-1', 'Prueba'),
(37, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-15', 'Retirado', 1.00, 'Venta : 0117', '2021-05-15 23:56:07', 'almacen-1', 'Prueba'),
(38, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0118', '2021-05-15 23:57:05', 'almacen-1', 'Prueba'),
(39, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-15', 'Retirado', 1.00, 'Venta : 0119', '2021-05-15 23:57:29', 'almacen-1', 'Prueba'),
(40, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0120', '2021-05-16 00:32:33', 'almacen-1', 'Prueba'),
(41, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-16', 'Retirado', 1.00, 'Venta : 0120', '2021-05-16 00:32:33', 'almacen-1', 'Prueba'),
(42, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0121', '2021-05-16 00:33:24', 'almacen-1', 'Prueba'),
(43, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0122', '2021-05-16 00:36:19', 'almacen-1', 'Prueba'),
(44, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0122', '2021-05-16 00:36:19', 'almacen-1', 'Prueba'),
(45, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0122', '2021-05-16 00:36:19', 'almacen-1', 'Prueba'),
(46, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0122', '2021-05-16 00:36:19', 'almacen-1', 'Prueba'),
(47, '1254', 'cerveza corona ', '2021-05-16', 'Retirado', 850000.00, 'Venta : 0123', '2021-05-16 00:39:36', 'almacen-1', 'Prueba'),
(48, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(49, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 85.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(50, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(51, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(52, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(53, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(54, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(55, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(56, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:03', 'almacen-1', 'Prueba'),
(57, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(58, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(59, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 85.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(60, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(61, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(62, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(63, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(64, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(65, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 85.00, 'Venta : 0124', '2021-05-16 17:04:04', 'almacen-1', 'Prueba'),
(66, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-16', 'Salida', 1.00, 'tyutyu', '2021-05-16 17:07:36', 'almacen-1', ''),
(67, 'A0012254', 'ARROZ LA GARZA 125 LB.', '2021-05-16', 'Retirado', 20.00, 'Venta : 0126', '2021-05-16 17:32:17', 'almacen-1', 'admin'),
(68, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0126', '2021-05-16 17:32:17', 'almacen-1', 'admin'),
(69, '1254', 'cerveza corona ', '2021-05-16', 'Retirado', 1.00, 'Venta : 0126', '2021-05-16 17:32:17', 'almacen-1', 'admin'),
(70, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0127', '2021-05-16 17:34:18', 'almacen-1', 'admin'),
(71, '1254', 'cerveza corona ', '2021-05-16', 'Retirado', 20.00, 'Venta : 0128', '2021-05-16 20:40:23', 'almacen-1', 'admin'),
(72, '1254', 'cerveza corona ', '2021-05-16', 'Retirado', 1.00, 'Venta : 0128', '2021-05-16 20:40:23', 'almacen-1', 'admin'),
(73, 'A0012254', 'ARROZ LA GARZA 125 LB.', '2021-05-16', 'Retirado', 200.00, 'Venta : 0128', '2021-05-16 20:40:23', 'almacen-1', 'admin'),
(74, 'C001', 'CERVEZA PRESIDENTE LIGHT NORMAL', '2021-05-16', 'Retirado', 1.00, 'Venta : 0128', '2021-05-16 20:40:23', 'almacen-1', 'admin'),
(75, '100', 'CERVEZA MODELO RUBIA PEQUENA', '2021-05-16', 'Retirado', 1.00, 'Venta : 0128', '2021-05-16 20:40:23', 'almacen-1', 'admin'),
(76, '1254', 'cerveza corona ', '2021-05-16', 'Retirado', 1.00, 'Venta : 0128', '2021-05-16 20:40:23', 'almacen-1', 'admin'),
(77, '001', 'asdasdf', '2021-05-16', 'Tranferencia', 5.00, 'Transf. de ALMACEN-2 hasta almacen-1', '2021-05-16 21:20:09', '', ''),
(78, 'A0012254', 'ARROZ LA GARZA 125 LB.', '2021-05-16', 'Retirado', 1.00, 'Venta : 0129', '2021-05-16 22:09:18', 'almacen-1', 'admin');

-- --------------------------------------------------------

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id_usuario` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL,
  `clave` text COLLATE utf8_spanish2_ci NOT NULL,
  `nivel` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id_usuario`, `nombre`, `clave`, `nivel`) VALUES
(1, 'caja', '001', 'Cajero'),
(2, 'admin', '003', 'Master');

-- --------------------------------------------------------

--
-- Table structure for table `movimientos_cuenta`
--

CREATE TABLE `movimientos_cuenta` (
  `id` int(11) NOT NULL,
  `cuenta` text COLLATE utf8_german2_ci NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `concepto` text COLLATE utf8_german2_ci NOT NULL,
  `monto` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `tipo` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ncf`
--

CREATE TABLE `ncf` (
  `id` int(11) NOT NULL,
  `tipo` text COLLATE utf8_german2_ci NOT NULL,
  `prefijo` text COLLATE utf8_german2_ci NOT NULL,
  `secuencia` int(11) NOT NULL,
  `hasta` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `ncf`
--

INSERT INTO `ncf` (`id`, `tipo`, `prefijo`, `secuencia`, `hasta`) VALUES
(1, 'Factura valida para Credito Fiscal', 'B01', 2, 1000),
(2, 'Consumidor final', 'B02', 160, 500);

-- --------------------------------------------------------

--
-- Table structure for table `pagos_compra`
--

CREATE TABLE `pagos_compra` (
  `id` int(11) NOT NULL,
  `monto` float NOT NULL,
  `id_compra` int(11) NOT NULL,
  `folio` text COLLATE utf8_german2_ci NOT NULL,
  `proveedor` text COLLATE utf8_german2_ci NOT NULL,
  `secuencia` text COLLATE utf8_german2_ci NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `efectivo` float NOT NULL,
  `tarjeta` float NOT NULL,
  `cheque` float NOT NULL,
  `numero_cheque` text COLLATE utf8_german2_ci NOT NULL,
  `folio_egreso` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `pagos_compra`
--

INSERT INTO `pagos_compra` (`id`, `monto`, `id_compra`, `folio`, `proveedor`, `secuencia`, `usuario`, `fecha`, `hora`, `efectivo`, `tarjeta`, `cheque`, `numero_cheque`, `folio_egreso`) VALUES
(1, 150, 1, '1', 'Proveedor de prueba', '', '', '2021-05-15', '2021-05-15 22:31:28', 0, 0, 0, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `pagos_credito`
--

CREATE TABLE `pagos_credito` (
  `id` int(11) NOT NULL,
  `monto` float NOT NULL,
  `id_factura` int(11) NOT NULL,
  `folio` text COLLATE utf8_german2_ci NOT NULL,
  `cliente` text COLLATE utf8_german2_ci NOT NULL,
  `secuencia` text COLLATE utf8_german2_ci NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `efectivo` float NOT NULL,
  `tarjeta` float NOT NULL,
  `cheque` float NOT NULL,
  `numero_cheque` text COLLATE utf8_german2_ci NOT NULL,
  `folio_ingreso` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `pagos_credito`
--

INSERT INTO `pagos_credito` (`id`, `monto`, `id_factura`, `folio`, `cliente`, `secuencia`, `usuario`, `fecha`, `hora`, `efectivo`, `tarjeta`, `cheque`, `numero_cheque`, `folio_ingreso`) VALUES
(1, 150, 6, '016', 'Cliente de pruebas', '5-01', '', '2021-05-16', '2021-05-16 01:02:33', 0, 0, 0, '', 'Prueba1'),
(2, 50, 18, '0117', 'Cliente de pruebas', '5-01', '', '2021-05-16', '2021-05-16 01:02:33', 0, 0, 0, '', 'Prueba1'),
(3, 150, 11, '0110', 'erw', '5-01', '', '2021-05-16', '2021-05-16 01:03:07', 0, 0, 0, '', 'Prueba2'),
(4, 150, 12, '0111', 'erw', '5-01', '', '2021-05-16', '2021-05-16 01:03:07', 0, 0, 0, '', 'Prueba2'),
(5, 150, 13, '0112', 'erw', '5-01', '', '2021-05-16', '2021-05-16 01:03:07', 0, 0, 0, '', 'Prueba2'),
(6, 150, 14, '0113', 'erw', '5-01', '', '2021-05-16', '2021-05-16 01:03:07', 0, 0, 0, '', 'Prueba2'),
(7, 300, 15, '0114', 'erw', '5-01', '', '2021-05-16', '2021-05-16 01:03:08', 0, 0, 0, '', 'Prueba2'),
(8, 150, 16, '0115', 'erw', '5-01', '', '2021-05-16', '2021-05-16 01:03:08', 0, 0, 0, '', 'Prueba2'),
(9, 150, 17, '0116', 'erw', '5-01', '', '2021-05-16', '2021-05-16 01:03:08', 0, 0, 0, '', 'Prueba2'),
(10, 100, 18, '0117', 'Cliente de pruebas', '6-01', '', '2021-05-16', '2021-05-16 21:19:00', 0, 0, 0, '', 'admin3'),
(11, 100, 31, '', 'ALEXANDRO SANTANA MENDEZ', '6-01', '', '2021-05-16', '2021-05-16 21:48:08', 0, 0, 0, '', 'admin4');

-- --------------------------------------------------------

--
-- Table structure for table `pagos_producciones`
--

CREATE TABLE `pagos_producciones` (
  `id` int(11) NOT NULL,
  `efectivo` float(19,2) NOT NULL,
  `cheque` float(19,2) NOT NULL,
  `tarjeta` float(19,2) NOT NULL,
  `monto` float(19,2) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `numero_cheque` text COLLATE utf8_german2_ci NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL,
  `productor` text COLLATE utf8_german2_ci NOT NULL,
  `id_compra` int(11) NOT NULL,
  `folio` text COLLATE utf8_german2_ci NOT NULL,
  `secuencia` text COLLATE utf8_german2_ci NOT NULL,
  `folio_egreso` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

-- --------------------------------------------------------

--
-- Table structure for table `parametros`
--

CREATE TABLE `parametros` (
  `id` int(11) NOT NULL,
  `folio_ventas` int(11) NOT NULL,
  `folio_compra` int(11) NOT NULL,
  `folio_compra_factoria` int(11) NOT NULL,
  `folio_ingreso` int(11) NOT NULL,
  `folio_egreso` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `parametros`
--

INSERT INTO `parametros` (`id`, `folio_ventas`, `folio_compra`, `folio_compra_factoria`, `folio_ingreso`, `folio_egreso`) VALUES
(1, 30, 3, 3, 5, 2);

-- --------------------------------------------------------

--
-- Table structure for table `productos`
--

CREATE TABLE `productos` (
  `id_producto` int(11) NOT NULL,
  `descripcion` text COLLATE utf8_spanish2_ci NOT NULL,
  `codigo` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `proveedor` text COLLATE utf8_spanish2_ci NOT NULL,
  `stock` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci,
  `fecha` date DEFAULT NULL,
  `cantidad` float(19,2) DEFAULT NULL,
  `tipo_impuestos` varchar(25) COLLATE utf8_spanish2_ci NOT NULL,
  `valor_impuestos` float(19,2) NOT NULL,
  `variedad` text COLLATE utf8_spanish2_ci NOT NULL,
  `unidad` text COLLATE utf8_spanish2_ci NOT NULL,
  `precio2` float(19,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `productos`
--

INSERT INTO `productos` (`id_producto`, `descripcion`, `codigo`, `costo`, `precio`, `proveedor`, `stock`, `usuario`, `fecha`, `cantidad`, `tipo_impuestos`, `valor_impuestos`, `variedad`, `unidad`, `precio2`) VALUES
(1, 'CERVEZA PRESIDENTE LIGHT NORMAL', 'C001', 90.00, 150.00, 'Proveedor de prueba', 10.00, NULL, NULL, NULL, '18.00', 22.88, 'PUITA', 'UNIDAD', 145.00),
(2, 'CERVEZA MODELO RUBIA PEQUENA', '100', 100.00, 150.00, 'null', 8.00, NULL, NULL, NULL, '18.00', 22.88, 'null', 'null', 185.00),
(3, 'cerveza corona ', '1254', 85.00, 150.00, 'null', 8.00, NULL, NULL, NULL, '18.00', 22.88, 'null', 'null', 160.00),
(4, 'ARROZ ', '001', 0.00, 0.00, 'null', 0.00, NULL, NULL, NULL, '', 0.00, 'null', 'null', 0.00),
(5, 'asdasdf', '001', 56.00, 0.00, 'null', 0.00, NULL, NULL, NULL, '', 0.00, 'null', 'null', 0.00),
(6, 'sdfsd', '002', 100.00, 0.00, 'null', 0.00, NULL, NULL, NULL, '', 0.00, 'null', 'null', 0.00),
(7, 'ARROZ LA GARZA 125 LB.', 'A0012254', 1100.00, 1500.00, 'ALEXANDRO SANTANA MENDEZ', 100.00, NULL, NULL, NULL, '', 0.00, 'null', 'LIBRA', 1485.00);

-- --------------------------------------------------------

--
-- Table structure for table `proveedores`
--

CREATE TABLE `proveedores` (
  `id_proveedor` int(11) NOT NULL,
  `nombre` text COLLATE utf8_spanish2_ci NOT NULL,
  `cedula` text COLLATE utf8_spanish2_ci NOT NULL,
  `telefono` text COLLATE utf8_spanish2_ci NOT NULL,
  `direccion` text COLLATE utf8_spanish2_ci NOT NULL,
  `tipo` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `proveedores`
--

INSERT INTO `proveedores` (`id_proveedor`, `nombre`, `cedula`, `telefono`, `direccion`, `tipo`) VALUES
(1, 'Proveedor de prueba', '000001', '00001', '0', 'Productor'),
(2, 'ALEXANDRO SANTANA MENDEZ', '07300173916', '8493587693', 'DAJABON', 'Productor');

-- --------------------------------------------------------

--
-- Table structure for table `transferencias_almacen`
--

CREATE TABLE `transferencias_almacen` (
  `id` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `mercancia` text COLLATE utf8_german2_ci NOT NULL,
  `desde` text COLLATE utf8_german2_ci NOT NULL,
  `hasta` text COLLATE utf8_german2_ci NOT NULL,
  `cantidad` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `transferencias_almacen`
--

INSERT INTO `transferencias_almacen` (`id`, `fecha`, `hora`, `mercancia`, `desde`, `hasta`, `cantidad`, `usuario`) VALUES
(1, '2021-05-16', '2021-05-16 21:20:09', 'asdasdf', 'ALMACEN-2', 'almacen-1', 5.00, '');

-- --------------------------------------------------------

--
-- Table structure for table `variedad_productos`
--

CREATE TABLE `variedad_productos` (
  `id` int(11) NOT NULL,
  `variedad` text COLLATE utf8_german2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_german2_ci;

--
-- Dumping data for table `variedad_productos`
--

INSERT INTO `variedad_productos` (`id`, `variedad`) VALUES
(1, 'PUITA');

-- --------------------------------------------------------

--
-- Table structure for table `ventas`
--

CREATE TABLE `ventas` (
  `id_venta` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `cliente` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `impuesto` float(19,2) NOT NULL,
  `descuento` float(19,2) NOT NULL,
  `total` float(19,2) NOT NULL,
  `pagado` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci NOT NULL,
  `folio` text COLLATE utf8_spanish2_ci NOT NULL,
  `termino` text COLLATE utf8_spanish2_ci NOT NULL,
  `pago_con` float(19,2) NOT NULL,
  `devuelta` float(19,2) NOT NULL,
  `ncf` text COLLATE utf8_spanish2_ci NOT NULL,
  `tipo_ncf` text COLLATE utf8_spanish2_ci NOT NULL,
  `nota` text COLLATE utf8_spanish2_ci NOT NULL,
  `secuencia` text COLLATE utf8_spanish2_ci NOT NULL,
  `fecha_pago` date NOT NULL,
  `concepto` text COLLATE utf8_spanish2_ci NOT NULL,
  `cheque` float NOT NULL,
  `efectivo` float NOT NULL,
  `numero_cheque` text COLLATE utf8_spanish2_ci NOT NULL,
  `estado` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `ventas`
--

INSERT INTO `ventas` (`id_venta`, `fecha`, `hora`, `cliente`, `costo`, `precio`, `impuesto`, `descuento`, `total`, `pagado`, `balance`, `usuario`, `folio`, `termino`, `pago_con`, `devuelta`, `ncf`, `tipo_ncf`, `nota`, `secuencia`, `fecha_pago`, `concepto`, `cheque`, `efectivo`, `numero_cheque`, `estado`) VALUES
(1, '2021-05-13', '2021-05-13 21:34:36', 'Generico', 540.00, 150.00, 137.28, 0.00, 900.00, 900.00, 0.00, 'admin', '011', 'Tarjeta', 12254.00, 11354.00, 'B0200000129', 'Consumidor final', '\n              ', '1-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(2, '2021-05-14', '2021-05-14 13:05:55', 'Generico', 900.00, 0.00, 228.81, 0.00, 1500.00, 1500.00, 0.00, 'admin', '012', 'Contado', 2000.00, 500.00, 'B0200000130', 'Consumidor final', '\n              ', '1-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(3, '2021-05-14', '2021-05-14 22:28:45', 'Generico', 100.00, 0.00, 0.00, 0.00, 150.00, 150.00, 0.00, 'admin', '013', 'Contado', 500.00, 350.00, 'B0200000131', 'Consumidor final', '\n              ', '1-01', '0000-00-00', 'Venta', 0, 0, '', 'Anulada'),
(4, '2021-05-15', '2021-05-15 21:50:33', 'Generico', 175.00, 0.00, 0.00, 0.00, 180.00, 180.00, 0.00, 'admin', '014', 'Contado', 200.00, 20.00, 'B0200000132', 'Consumidor final', '\n              ', '2-01', '0000-00-00', 'Venta', 0, 0, '', 'Anulada'),
(5, '2021-05-15', '2021-05-15 21:56:26', 'Generico', 190.00, 150.00, 22.88, 0.00, 300.00, 300.00, 0.00, 'admin', '015', 'Tarjeta', 400.00, 100.00, 'B0200000133', 'Consumidor final', '\n              ', '2-01', '0000-00-00', 'Venta', 0, 0, '', 'Anulada'),
(6, '2021-05-15', '2021-05-15 22:10:06', 'Cliente de pruebas', 100.00, 150.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'admin', '016', 'Credito', 0.00, 0.00, 'B0200000134', 'Consumidor final', 'ertrtyrtyry', '2-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(7, '2021-05-15', '2021-05-15 22:14:15', 'Generico', 375.00, 0.00, 45.76, 0.00, 450.00, 450.00, 0.00, 'admin', '017', 'Contado', 1800.00, 1350.00, 'B0200000135', 'Consumidor final', 'Mesa1 - Al lado e la banca ', '2-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(8, '2021-05-15', '2021-05-15 23:14:12', 'Generico', 8500.00, 0.00, 0.00, 0.00, 12750.00, 12750.00, 0.00, 'admin', '018', 'Contado', 13000.00, 250.00, 'B0200000136', 'Consumidor final', ' - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(9, '2021-05-15', '2021-05-15 23:14:12', 'Generico', 8500.00, 0.00, 0.00, 0.00, 12750.00, 12750.00, 0.00, 'admin', '018', 'Contado', 13000.00, 250.00, 'B0200000136', 'Consumidor final', ' - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(10, '2021-05-15', '2021-05-15 23:14:12', 'Generico', 8500.00, 0.00, 0.00, 0.00, 12750.00, 12750.00, 0.00, 'admin', '018', 'Contado', 13000.00, 250.00, 'B0200000136', 'Consumidor final', ' - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(11, '2021-05-15', '2021-05-15 23:42:16', 'erw', 90.00, 0.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0110', 'Credito', 0.00, 0.00, 'B0200000139', 'Consumidor final', ' - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(12, '2021-05-15', '2021-05-15 23:44:01', 'erw', 90.00, 150.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0111', 'Credito', 0.00, 0.00, 'B0200000140', 'Consumidor final', ' - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(13, '2021-05-15', '2021-05-15 23:44:50', 'erw', 90.00, 150.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0112', 'Credito', 0.00, 0.00, 'B0200000141', 'Consumidor final', ' - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(14, '2021-05-15', '2021-05-15 23:46:58', 'erw', 100.00, 150.00, 0.00, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0113', 'Credito', 0.00, 0.00, 'B0200000142', 'Consumidor final', ' - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(15, '2021-05-15', '2021-05-15 23:47:58', 'erw', 175.00, 150.00, 22.88, 0.00, 300.00, 300.00, 0.00, 'Prueba', '0114', 'Credito', 0.00, 0.00, 'B0200000143', 'Consumidor final', ' - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(16, '2021-05-15', '2021-05-15 23:51:26', 'erw', 90.00, 0.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0115', 'Credito', 0.00, 0.00, 'B0200000144', 'Consumidor final', ' - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(17, '2021-05-15', '2021-05-15 23:52:00', 'erw', 90.00, 0.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0116', 'Credito', 0.00, 0.00, 'B0200000145', 'Consumidor final', 'eerr - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(18, '2021-05-15', '2021-05-15 23:56:07', 'Cliente de pruebas', 100.00, 0.00, 0.00, 0.00, 150.00, 100.00, 0.00, 'Prueba', '0117', 'Credito', 0.00, 0.00, 'B0200000146', 'Consumidor final', ' - \n              ', '5-01', '2021-05-16', 'Venta', 0, 0, '', ''),
(19, '2021-05-15', '2021-05-15 23:57:05', 'Proveedor de prueba', 90.00, 0.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0118', 'Contado', 1000.00, 850.00, 'B0200000147', 'Consumidor final', '88745 - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(20, '2021-05-15', '2021-05-15 23:57:29', 'erw', 90.00, 150.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'Prueba', '0119', 'Contado', 1000.00, 850.00, 'B0200000148', 'Consumidor final', ' - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(21, '2021-05-16', '2021-05-16 00:32:33', 'Generico', 190.00, 0.00, 22.88, 0.00, 300.00, 0.00, 0.00, 'Prueba', '0120', 'Tarjeta', 0.00, 0.00, 'B0200000149', 'Consumidor final', ' - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(22, '2021-05-16', '2021-05-16 00:33:24', 'erw', 90.00, 0.00, 22.88, 0.00, 150.00, 0.00, 0.00, 'Prueba', '0121', 'Cheque', 0.00, 0.00, 'B0200000150', 'Consumidor final', ' - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(23, '2021-05-16', '2021-05-16 00:36:18', 'Generico', 360.00, 0.00, 91.52, 0.00, 600.00, 600.00, 0.00, 'Prueba', '0122', 'Tarjeta', 1000.00, 400.00, 'B0200000151', 'Consumidor final', 'fffd - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(24, '2021-05-16', '2021-05-16 00:39:36', 'Generico', 72250000.00, 0.00, 0.00, 0.00, 680000000.00, 680000000.00, 0.00, 'Prueba', '0123', 'Tarjeta', 1000000000.00, 320000000.00, 'B0200000152', 'Consumidor final', 'dfgdfg - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(25, '2021-05-16', '2021-05-16 17:04:03', 'Generico', 8100.00, 0.00, 244.02, 0.00, 1600.00, 1600.00, 0.00, 'Prueba', '0124', 'Contado', 3000.00, 1400.00, 'B0200000153', 'Consumidor final', '8874 - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(26, '2021-05-16', '2021-05-16 17:04:03', 'Generico', 8100.00, 0.00, 244.02, 0.00, 1600.00, 1600.00, 0.00, 'Prueba', '0124', 'Contado', 3000.00, 1400.00, 'B0200000153', 'Consumidor final', '8874 - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(27, '2021-05-16', '2021-05-16 17:04:03', 'Generico', 8100.00, 0.00, 244.02, 0.00, 1600.00, 1600.00, 0.00, 'Prueba', '0124', 'Contado', 3000.00, 1400.00, 'B0200000153', 'Consumidor final', '8874 - \n              ', '5-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(28, '2021-05-16', '2021-05-16 17:32:17', 'ALEXANDRO SANTANA MENDEZ', 22175.00, 1500.00, 0.00, 0.00, 30250.00, 30250.00, 0.00, 'admin', '0126', 'Contado', 40000.00, 9750.00, 'B0200000156', 'Consumidor final', ' - \n              ', '6-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(29, '2021-05-16', '2021-05-16 17:34:17', 'ALEXANDRO SANTANA MENDEZ', 90.00, 150.00, 22.88, 0.00, 150.00, 150.00, 0.00, 'admin', '0127', 'Contado', 200.00, 50.00, 'B0200000157', 'Consumidor final', ' - \n              ', '6-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(30, '2021-05-16', '2021-05-16 20:40:23', 'Generico', 222060.00, 150.00, 22.88, 0.00, 303600.00, 303600.00, 0.00, 'admin', '0128', 'Contado', 2000000000.00, 1999696384.00, 'B0200000158', 'Consumidor final', ' - \n              ', '6-01', '0000-00-00', 'Venta', 0, 0, '', ''),
(31, '2021-05-16', '0000-00-00 00:00:00', 'ALEXANDRO SANTANA MENDEZ', 0.00, 0.00, 0.00, 0.00, 2000.00, 100.00, 1900.00, '', '', '', 0.00, 0.00, '', '', '677666', '', '2021-05-16', 'Prestamo', 0, 0, '11544', ''),
(32, '2021-05-16', '2021-05-16 22:09:18', 'Cliente de pruebas', 1100.00, 0.00, 0.00, 0.00, 1500.00, 0.00, 1500.00, 'admin', '0129', 'Credito', 0.00, 0.00, 'B0200000159', 'Consumidor final', ' - \n              ', '6-01', '0000-00-00', 'Venta', 0, 0, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `ventas_pendiente`
--

CREATE TABLE `ventas_pendiente` (
  `id_venta` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `hora` datetime NOT NULL,
  `cliente` text COLLATE utf8_spanish2_ci NOT NULL,
  `costo` float(19,2) NOT NULL,
  `precio` float(19,2) NOT NULL,
  `impuesto` float(19,2) NOT NULL,
  `descuento` float(19,2) NOT NULL,
  `total` float(19,2) NOT NULL,
  `pagado` float(19,2) NOT NULL,
  `balance` float(19,2) NOT NULL,
  `usuario` text COLLATE utf8_spanish2_ci NOT NULL,
  `folio` text COLLATE utf8_spanish2_ci NOT NULL,
  `termino` text COLLATE utf8_spanish2_ci NOT NULL,
  `pago_con` float(19,2) NOT NULL,
  `devuelta` float(19,2) NOT NULL,
  `ncf` text COLLATE utf8_spanish2_ci NOT NULL,
  `tipo_ncf` text COLLATE utf8_spanish2_ci NOT NULL,
  `nota` text COLLATE utf8_spanish2_ci NOT NULL,
  `secuencia` text COLLATE utf8_spanish2_ci NOT NULL,
  `fecha_pago` date NOT NULL,
  `concepto` text COLLATE utf8_spanish2_ci NOT NULL,
  `cheque` float NOT NULL,
  `efectivo` float NOT NULL,
  `numero_cheque` text COLLATE utf8_spanish2_ci NOT NULL,
  `estado` text COLLATE utf8_spanish2_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish2_ci;

--
-- Dumping data for table `ventas_pendiente`
--

INSERT INTO `ventas_pendiente` (`id_venta`, `fecha`, `hora`, `cliente`, `costo`, `precio`, `impuesto`, `descuento`, `total`, `pagado`, `balance`, `usuario`, `folio`, `termino`, `pago_con`, `devuelta`, `ncf`, `tipo_ncf`, `nota`, `secuencia`, `fecha_pago`, `concepto`, `cheque`, `efectivo`, `numero_cheque`, `estado`) VALUES
(90, '2021-05-11', '2021-05-11 20:50:44', 'Ticket-1', 0.00, 0.00, 0.00, 0.00, 635.00, 0.00, 0.00, '', '', '', 0.00, 0.00, '', '', '', '', '0000-00-00', '', 0, 0, '', ''),
(91, '2021-05-12', '2021-05-12 04:06:54', 'null', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', '', '', 0.00, 0.00, '', '', '', '', '0000-00-00', '', 0, 0, '', ''),
(92, '2021-05-12', '2021-05-12 04:07:08', 'Ticket-10000', 0.00, 0.00, 0.00, 0.00, 285.00, 0.00, 0.00, '', '', '', 0.00, 0.00, '', '', '', '', '0000-00-00', '', 0, 0, '', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `almacen`
--
ALTER TABLE `almacen`
  ADD PRIMARY KEY (`id_almacen`);

--
-- Indexes for table `apertura_caja`
--
ALTER TABLE `apertura_caja`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cajas`
--
ALTER TABLE `cajas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cheques`
--
ALTER TABLE `cheques`
  ADD PRIMARY KEY (`id_cheque`);

--
-- Indexes for table `choferes`
--
ALTER TABLE `choferes`
  ADD PRIMARY KEY (`id_chofer`);

--
-- Indexes for table `clientes`
--
ALTER TABLE `clientes`
  ADD PRIMARY KEY (`id_cliente`);

--
-- Indexes for table `compras`
--
ALTER TABLE `compras`
  ADD PRIMARY KEY (`id_venta`);

--
-- Indexes for table `compra_factoria`
--
ALTER TABLE `compra_factoria`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cuentas`
--
ALTER TABLE `cuentas`
  ADD PRIMARY KEY (`id_cuenta`);

--
-- Indexes for table `cuentas_corrientes`
--
ALTER TABLE `cuentas_corrientes`
  ADD PRIMARY KEY (`id_cuenta`);

--
-- Indexes for table `depo_reti`
--
ALTER TABLE `depo_reti`
  ADD PRIMARY KEY (`id_transaccion`);

--
-- Indexes for table `detalle_compra`
--
ALTER TABLE `detalle_compra`
  ADD PRIMARY KEY (`id_detalle`);

--
-- Indexes for table `detalle_compra_factoria`
--
ALTER TABLE `detalle_compra_factoria`
  ADD PRIMARY KEY (`id_detalle`);

--
-- Indexes for table `detalle_venta`
--
ALTER TABLE `detalle_venta`
  ADD PRIMARY KEY (`id_detalle`);

--
-- Indexes for table `devoluciones`
--
ALTER TABLE `devoluciones`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `egresos`
--
ALTER TABLE `egresos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `empleados`
--
ALTER TABLE `empleados`
  ADD PRIMARY KEY (`id_empleado`);

--
-- Indexes for table `empresa`
--
ALTER TABLE `empresa`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `impuestos`
--
ALTER TABLE `impuestos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ingresos`
--
ALTER TABLE `ingresos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inventario`
--
ALTER TABLE `inventario`
  ADD PRIMARY KEY (`id_inventario`);

--
-- Indexes for table `kardex`
--
ALTER TABLE `kardex`
  ADD PRIMARY KEY (`id_kardex`);

--
-- Indexes for table `login`
--
ALTER TABLE `login`
  ADD PRIMARY KEY (`id_usuario`);

--
-- Indexes for table `movimientos_cuenta`
--
ALTER TABLE `movimientos_cuenta`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ncf`
--
ALTER TABLE `ncf`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pagos_compra`
--
ALTER TABLE `pagos_compra`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pagos_credito`
--
ALTER TABLE `pagos_credito`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pagos_producciones`
--
ALTER TABLE `pagos_producciones`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `parametros`
--
ALTER TABLE `parametros`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `productos`
--
ALTER TABLE `productos`
  ADD PRIMARY KEY (`id_producto`);

--
-- Indexes for table `proveedores`
--
ALTER TABLE `proveedores`
  ADD PRIMARY KEY (`id_proveedor`);

--
-- Indexes for table `transferencias_almacen`
--
ALTER TABLE `transferencias_almacen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `variedad_productos`
--
ALTER TABLE `variedad_productos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ventas`
--
ALTER TABLE `ventas`
  ADD PRIMARY KEY (`id_venta`);

--
-- Indexes for table `ventas_pendiente`
--
ALTER TABLE `ventas_pendiente`
  ADD PRIMARY KEY (`id_venta`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `almacen`
--
ALTER TABLE `almacen`
  MODIFY `id_almacen` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `apertura_caja`
--
ALTER TABLE `apertura_caja`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `cajas`
--
ALTER TABLE `cajas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `cheques`
--
ALTER TABLE `cheques`
  MODIFY `id_cheque` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `choferes`
--
ALTER TABLE `choferes`
  MODIFY `id_chofer` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `clientes`
--
ALTER TABLE `clientes`
  MODIFY `id_cliente` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `compras`
--
ALTER TABLE `compras`
  MODIFY `id_venta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `compra_factoria`
--
ALTER TABLE `compra_factoria`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `cuentas`
--
ALTER TABLE `cuentas`
  MODIFY `id_cuenta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `cuentas_corrientes`
--
ALTER TABLE `cuentas_corrientes`
  MODIFY `id_cuenta` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `depo_reti`
--
ALTER TABLE `depo_reti`
  MODIFY `id_transaccion` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `detalle_compra`
--
ALTER TABLE `detalle_compra`
  MODIFY `id_detalle` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `detalle_compra_factoria`
--
ALTER TABLE `detalle_compra_factoria`
  MODIFY `id_detalle` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `detalle_venta`
--
ALTER TABLE `detalle_venta`
  MODIFY `id_detalle` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=163;
--
-- AUTO_INCREMENT for table `devoluciones`
--
ALTER TABLE `devoluciones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `egresos`
--
ALTER TABLE `egresos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `empleados`
--
ALTER TABLE `empleados`
  MODIFY `id_empleado` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `empresa`
--
ALTER TABLE `empresa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `impuestos`
--
ALTER TABLE `impuestos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `ingresos`
--
ALTER TABLE `ingresos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `inventario`
--
ALTER TABLE `inventario`
  MODIFY `id_inventario` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `kardex`
--
ALTER TABLE `kardex`
  MODIFY `id_kardex` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;
--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
  MODIFY `id_usuario` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `movimientos_cuenta`
--
ALTER TABLE `movimientos_cuenta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ncf`
--
ALTER TABLE `ncf`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `pagos_compra`
--
ALTER TABLE `pagos_compra`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `pagos_credito`
--
ALTER TABLE `pagos_credito`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `pagos_producciones`
--
ALTER TABLE `pagos_producciones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `parametros`
--
ALTER TABLE `parametros`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `productos`
--
ALTER TABLE `productos`
  MODIFY `id_producto` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `proveedores`
--
ALTER TABLE `proveedores`
  MODIFY `id_proveedor` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `transferencias_almacen`
--
ALTER TABLE `transferencias_almacen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `variedad_productos`
--
ALTER TABLE `variedad_productos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `ventas`
--
ALTER TABLE `ventas`
  MODIFY `id_venta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
--
-- AUTO_INCREMENT for table `ventas_pendiente`
--
ALTER TABLE `ventas_pendiente`
  MODIFY `id_venta` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;
/*!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 */;
