HaxorSec [ www.sistemasyusa.icu ]

Code Editor : yampos_res.sql

-- phpMyAdmin SQL Dump
-- version 4.8.0.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 22-11-2019 a las 00:27:56
-- Versión del servidor: 10.1.32-MariaDB
-- Versión de PHP: 7.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 */;

--
-- Base de datos: `yampos_res`
--

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

--
-- Estructura de tabla para la tabla `box`
--

CREATE TABLE `box` (
  `id` int(11) NOT NULL,
  `stock_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `box`
--

INSERT INTO `box` (`id`, `stock_id`, `created_at`) VALUES
(1, 7690, '2019-11-20 23:55:17'),
(2, 450, '2019-11-21 00:05:11'),
(3, 150, '2019-11-21 00:06:42'),
(4, 150, '2019-11-21 00:18:46'),
(5, 168, '2019-11-21 00:22:08'),
(6, 990, '2019-11-21 11:00:18'),
(7, 4101, '2019-11-21 17:14:28');

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

--
-- Estructura de tabla para la tabla `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `category`
--

INSERT INTO `category` (`id`, `name`, `is_active`) VALUES
(1, 'TACOS', 1),
(2, 'CALDOS', 1),
(3, 'REFRESCOS', 1),
(4, 'PULPOS', 1),
(5, 'ENTRADAS', 1),
(6, 'ANGELITOS', 1),
(7, 'DEL PUERTO', 1),
(8, 'ENSALADAS', 1),
(9, 'ESPECIALIDADES SALMÃ“N', 1),
(10, 'ESPECIALIDADES PULPO', 1),
(11, 'ESPECIALIDADES CAMARON', 1),
(12, 'ESPECIALIDADES FILETE', 1),
(13, 'MEDALLON DE ATUN Y MARLIN', 1),
(14, 'ARROZ  Y PASTAS', 1),
(15, 'ESPECIALIDADES PUERTO ', 1),
(16, 'MOJARRAS', 1),
(17, 'PAELLA', 1),
(18, 'AGUAS FRESCAS', 1),
(19, 'POSTRES', 1);

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

--
-- Estructura de tabla para la tabla `configuration`
--

CREATE TABLE `configuration` (
  `id` int(11) NOT NULL,
  `short` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `kind` int(11) DEFAULT NULL,
  `val` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `configuration`
--

INSERT INTO `configuration` (`id`, `short`, `name`, `kind`, `val`) VALUES
(1, 'company_name', 'Nombre de la empresa', 2, 'MARISCOS PUERTO ANGELITO'),
(2, 'title', 'Titulo del Sistema', 2, 'RestaurantMax'),
(3, 'admin_email', 'CORREO', 2, 'syusa19802014@gmail.com'),
(4, 'report_image', 'Imagen en Reportes', 4, ''),
(5, 'imp-name', 'Nombre Impuesto', 2, 'IVA'),
(6, 'imp-val', 'Valor Impuesto (%)', 2, '16'),
(7, 'currency', 'Simbolo de Moneda', 2, '$'),
(8, 'rfc_val', 'RFC', 2, 'AAAI800508K2A'),
(9, 'name_val', 'NOMBRE', 2, 'ISRAEL ALVARADO AGUILAR'),
(10, 'add_val', 'CALLE', 2, 'Calle  Beethovenâ€‹'),
(11, 'no_int', 'NUMERO INT', 2, 'Local #1'),
(12, 'no_ext', 'NUMERO EXT', 2, 'A'),
(13, 'col_val', 'COLONIA', 2, 'Adelina Patti, Peralvillo, 06220'),
(14, 'ciudad_val', 'CIUDAD', 2, ' Ciudad de MÃ©xico, CDMX'),
(15, 'est_val', 'ESTADO', 2, 'CDMX'),
(16, 'cp_val', 'CODIGO POSTAL', 2, '06220'),
(17, 'Serie_val', 'SerieFacturas', 2, 'A'),
(18, 'descuento_val', 'DESCUENTO GENERAL EN %', 2, '0'),
(19, 'activardescuento_val', 'ACTIVAR DESCUENTO GENERAL (SI/NO)', 2, 'NO'),
(20, 'cambiarprecio_val', 'CAMBIAR PRECIO POR ARTICULO (SI/NO)', 2, 'NO'),
(21, 'ventarapida_val', 'VENTA RAPIDA (SI/NO)', 2, 'NO'),
(22, 'descuentoenventa_val', 'BLOQUEAR DESCUENTO EN VENTA (SI/NO)', 2, 'SI'),
(23, 'capturarcantidad_val', 'CAPTURAR CANTIDAD (SI/NO)', 2, 'SI');

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

--
-- Estructura de tabla para la tabla `gps`
--

CREATE TABLE `gps` (
  `id` int(11) NOT NULL,
  `dispositivo` varchar(50) NOT NULL,
  `latitud` double DEFAULT NULL,
  `longitud` double DEFAULT NULL,
  `velocidad` double DEFAULT NULL,
  `fecha` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `ingredient`
--

CREATE TABLE `ingredient` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `price_in` float NOT NULL,
  `price_out` float DEFAULT NULL,
  `unit` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `ingredient`
--

INSERT INTO `ingredient` (`id`, `code`, `name`, `price_in`, `price_out`, `unit`, `is_active`, `user_id`) VALUES
(1, '12', 'pulpo', 0, 23, 'kg', 1, 1),
(2, '35', 'tomate', 0, 10, 'kg', 1, 1),
(3, '5677', 'chile serrano', 0, 20, 'kg', 1, 1),
(4, '57', 'coca cola', 0, 8, 'pz', 1, 1),
(5, 'Ent', 'Filete rebosado', 0, 35, 'Pza', 1, 1);

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

--
-- Estructura de tabla para la tabla `item`
--

CREATE TABLE `item` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `capacity` int(11) DEFAULT NULL,
  `count_sillas` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `item`
--

INSERT INTO `item` (`id`, `name`, `capacity`, `count_sillas`) VALUES
(1, '1', 1, 6),
(2, '2', 1, 0),
(3, '3', 1, 0),
(4, '4', 1, 0),
(5, '5', 1, 0),
(6, '6', 1, 0),
(7, '7', 1, 0),
(8, '8', 1, 0),
(9, '9', 1, 0),
(10, '10', 1, 0),
(11, 'mesa11', 2, 0),
(12, 'mesa21', 3, 0),
(13, 'mesa22', 3, 0),
(14, 'mesa23', 3, 0),
(15, 'mostrador', 1, 6),
(16, 'barra1A', 3, 0),
(17, 'BARRA2B', 3, 0),
(18, '11', 1, 4);

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

--
-- Estructura de tabla para la tabla `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `user_from` int(11) NOT NULL,
  `user_to` int(11) NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estructura de tabla para la tabla `operation`
--

CREATE TABLE `operation` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `q` float NOT NULL,
  `operation_type_id` int(11) NOT NULL,
  `sell_id` int(11) DEFAULT NULL,
  `is_oficial` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `operation`
--

INSERT INTO `operation` (`id`, `product_id`, `q`, `operation_type_id`, `sell_id`, `is_oficial`, `created_at`) VALUES
(1, 1, 6, 2, 7, 0, '2019-11-19 21:21:33'),
(2, 1, 3, 1, 1, 1, '2019-11-19 21:29:31'),
(3, 1, 3, 1, 1, 1, '2019-11-19 21:29:59'),
(4, 1, 3, 1, 1, 1, '2019-11-19 21:31:52'),
(5, 1, 6, 1, 2, 1, '2019-11-19 21:33:03'),
(6, 2, 3, 1, 3, 1, '2019-11-19 21:36:07'),
(7, 2, 2, 1, 1, 1, '2019-11-19 22:07:50'),
(9, 1, 3, 1, 10, 1, '2019-11-19 23:53:02'),
(10, 2, 1, 1, 11, 1, '2019-11-19 23:54:43'),
(11, 2, 2, 1, 12, 1, '2019-11-19 23:55:37'),
(12, 2, 3, 1, 12, 1, '2019-11-19 23:56:24'),
(13, 2, 2, 1, 14, 1, '2019-11-19 23:58:04'),
(14, 1, 2, 1, 15, 1, '2019-11-19 23:59:24'),
(15, 2, 1, 1, 1, 1, '2019-11-20 00:01:02'),
(16, 1, 1, 1, 1, 1, '2019-11-20 00:01:46'),
(17, 2, 1, 1, 13, 1, '2019-11-20 00:02:09'),
(18, 1, 2, 1, 2, 1, '2019-11-20 00:07:48'),
(19, 1, 3, 1, 16, 1, '2019-11-20 00:08:35'),
(20, 1, 1, 1, 17, 1, '2019-11-20 00:09:06'),
(21, 2, 3, 1, 18, 1, '2019-11-20 00:13:15'),
(22, 1, 1, 1, 20, 1, '2019-11-20 01:23:03'),
(23, 1, 1, 1, 21, 1, '2019-11-20 01:30:39'),
(24, 1, 1, 1, 22, 1, '2019-11-20 01:32:19'),
(25, 2, 3, 1, 23, 1, '2019-11-20 01:36:23'),
(26, 2, 1, 1, 24, 1, '2019-11-20 01:37:52'),
(27, 2, 1, 1, 25, 1, '2019-11-20 01:38:50'),
(28, 1, 1, 1, 26, 1, '2019-11-20 10:52:59'),
(29, 2, 2, 1, 27, 1, '2019-11-20 11:02:00'),
(30, 1, 7, 1, 26, 1, '2019-11-20 11:35:48'),
(31, 2, 1, 1, 29, 1, '2019-11-20 19:42:19'),
(32, 2, 1, 1, 30, 1, '2019-11-20 19:43:49'),
(33, 2, 1, 1, 4, 1, '2019-11-20 19:55:20'),
(34, 2, 1, 1, 4, 1, '2019-11-20 19:56:05'),
(35, 2, 1, 1, 4, 1, '2019-11-20 19:56:46'),
(36, 2, 1, 1, 4, 1, '2019-11-20 19:57:20'),
(37, 2, 1, 1, 4, 1, '2019-11-20 19:59:35'),
(38, 2, 2, 1, 4, 1, '2019-11-20 20:01:06'),
(39, 2, 1, 1, 31, 1, '2019-11-20 20:01:39'),
(40, 2, 2, 1, 35, 1, '2019-11-20 20:42:52'),
(41, 2, 1, 1, 32, 1, '2019-11-20 21:06:27'),
(42, 2, 1, 1, 32, 1, '2019-11-20 21:10:10'),
(43, 2, 1, 1, 2, 1, '2019-11-20 21:39:07'),
(44, 2, 1, 1, 33, 1, '2019-11-20 21:39:28'),
(45, 1, 1, 1, 34, 1, '2019-11-20 21:49:13'),
(46, 1, 1, 2, 36, 0, '2019-11-20 22:14:39'),
(47, 1, 1, 2, 37, 0, '2019-11-20 22:21:03'),
(48, 1, 1, 2, 38, 0, '2019-11-20 22:27:15'),
(49, 2, 2, 2, 38, 0, '2019-11-20 22:27:15'),
(50, 1, 2, 1, 39, 1, '2019-11-21 00:03:37'),
(51, 1, 1, 1, 40, 1, '2019-11-21 00:06:13'),
(52, 1, 1, 1, 41, 1, '2019-11-21 00:18:11'),
(53, 2, 1, 1, 42, 1, '2019-11-21 00:20:56'),
(54, 1, 1, 1, 43, 1, '2019-11-21 00:21:23'),
(55, 2, 2, 1, 44, 1, '2019-11-21 10:15:50'),
(56, 1, 1, 1, 44, 1, '2019-11-21 10:17:11'),
(57, 1, 2, 1, 45, 1, '2019-11-21 10:20:37'),
(58, 2, 3, 1, 46, 1, '2019-11-21 10:25:43'),
(59, 1, 1, 2, 47, 0, '2019-11-21 10:29:40'),
(60, 1, 3, 2, 48, 0, '2019-11-21 10:33:46'),
(61, 1, 1, 1, 49, 1, '2019-11-21 10:40:53'),
(62, 2, 2, 1, 49, 1, '2019-11-21 10:43:07'),
(63, 1, 2, 1, 49, 1, '2019-11-21 10:43:35'),
(64, 1, 4, 1, 49, 1, '2019-11-21 10:43:49'),
(65, 2, 1, 1, 47, 1, '2019-11-21 10:44:11'),
(66, 1, 1, 1, 50, 1, '2019-11-21 10:47:38'),
(67, 4, 1, 1, 49, 1, '2019-11-21 10:57:38'),
(68, 4, 2, 1, 52, 1, '2019-11-21 11:07:21'),
(69, 1, 7, 1, 51, 1, '2019-11-21 11:08:46'),
(70, 3, 1, 1, 52, 1, '2019-11-21 11:10:37'),
(71, 1, 1, 1, 53, 1, '2019-11-21 11:29:07'),
(72, 1, 10, 2, 57, 0, '2019-11-21 13:05:10'),
(73, 1, 1, 2, 58, 0, '2019-11-21 13:07:55'),
(74, 4, 1, 1, 55, 1, '2019-11-21 13:21:19'),
(75, 17, 5, 1, 35, 1, '2019-11-21 14:28:10'),
(76, 3, 1, 2, 59, 0, '2019-11-21 14:38:23'),
(77, 5, 1, 1, 55, 1, '2019-11-21 14:54:55'),
(78, 5, 1, 1, 55, 1, '2019-11-21 14:57:45'),
(79, 5, 1, 1, 55, 1, '2019-11-21 14:58:22'),
(80, 5, 1, 1, 55, 1, '2019-11-21 14:58:48'),
(81, 5, 1, 1, 55, 1, '2019-11-21 14:59:04'),
(82, 5, 1, 1, 55, 1, '2019-11-21 14:59:23'),
(83, 5, 1, 1, 55, 1, '2019-11-21 14:59:47'),
(84, 5, 1, 1, 55, 1, '2019-11-21 15:00:42'),
(85, 5, 1, 1, 55, 1, '2019-11-21 15:01:04'),
(86, 5, 1, 1, 55, 1, '2019-11-21 15:02:02'),
(87, 5, 1, 1, 55, 1, '2019-11-21 15:02:31'),
(88, 5, 1, 1, 55, 1, '2019-11-21 15:02:58'),
(89, 5, 1, 1, 55, 1, '2019-11-21 15:03:11'),
(90, 5, 1, 1, 55, 1, '2019-11-21 15:03:57'),
(91, 5, 1, 1, 55, 1, '2019-11-21 15:04:42'),
(92, 5, 1, 1, 55, 1, '2019-11-21 15:05:07'),
(93, 5, 1, 1, 55, 1, '2019-11-21 15:06:08'),
(94, 5, 1, 1, 55, 1, '2019-11-21 15:06:21'),
(95, 5, 1, 1, 55, 1, '2019-11-21 15:07:06'),
(96, 5, 1, 1, 55, 1, '2019-11-21 15:07:23'),
(97, 5, 1, 1, 55, 1, '2019-11-21 15:08:00'),
(98, 5, 1, 1, 55, 1, '2019-11-21 15:08:24'),
(99, 5, 1, 1, 55, 1, '2019-11-21 15:09:07'),
(100, 5, 1, 1, 55, 1, '2019-11-21 15:10:01'),
(101, 5, 1, 1, 55, 1, '2019-11-21 15:10:40'),
(102, 5, 1, 1, 55, 1, '2019-11-21 15:10:59'),
(103, 5, 1, 1, 55, 1, '2019-11-21 15:11:32'),
(104, 5, 1, 1, 55, 1, '2019-11-21 15:15:26'),
(105, 5, 1, 1, 55, 1, '2019-11-21 15:16:45'),
(106, 5, 1, 1, 55, 1, '2019-11-21 15:17:05'),
(107, 5, 1, 1, 55, 1, '2019-11-21 15:17:28'),
(108, 5, 1, 1, 55, 1, '2019-11-21 15:17:50'),
(109, 5, 1, 1, 55, 1, '2019-11-21 15:18:38'),
(110, 5, 1, 1, 55, 1, '2019-11-21 15:19:08'),
(111, 5, 1, 1, 55, 1, '2019-11-21 15:19:27'),
(112, 5, 1, 1, 55, 1, '2019-11-21 15:21:03'),
(113, 5, 1, 1, 55, 1, '2019-11-21 15:21:39'),
(114, 5, 1, 1, 55, 1, '2019-11-21 15:22:09'),
(115, 5, 1, 1, 55, 1, '2019-11-21 15:22:54'),
(116, 5, 1, 1, 55, 1, '2019-11-21 15:23:25'),
(117, 5, 1, 1, 55, 1, '2019-11-21 15:23:43'),
(118, 5, 1, 1, 55, 1, '2019-11-21 15:24:10'),
(119, 5, 1, 1, 55, 1, '2019-11-21 15:24:41'),
(120, 23, 1, 1, 60, 1, '2019-11-21 17:00:19'),
(121, 23, 1, 1, 60, 1, '2019-11-21 17:07:35'),
(122, 23, 1, 1, 60, 1, '2019-11-21 17:08:03'),
(123, 23, 1, 1, 56, 1, '2019-11-21 17:10:41'),
(124, 33, 1, 1, 56, 1, '2019-11-21 17:11:59'),
(125, 64, 1, 1, 56, 1, '2019-11-21 17:20:39'),
(126, 64, 2, 1, 56, 1, '2019-11-21 17:23:48');

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

--
-- Estructura de tabla para la tabla `operation2`
--

CREATE TABLE `operation2` (
  `id` int(11) NOT NULL,
  `ingredient_id` int(11) NOT NULL,
  `q` float NOT NULL,
  `operation_type_id` int(11) NOT NULL,
  `sell_id` int(11) DEFAULT NULL,
  `is_oficial` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `operation2`
--

INSERT INTO `operation2` (`id`, `ingredient_id`, `q`, `operation_type_id`, `sell_id`, `is_oficial`, `created_at`) VALUES
(1, 1, 1, 1, 19, 0, '2019-11-20 00:55:42'),
(2, 1, 2, 1, 20, 0, '2019-11-20 00:56:39'),
(3, 1, 20, 1, 21, 0, '2019-11-20 00:57:34'),
(4, 1, 10, 2, 22, 0, '2019-11-20 01:23:16'),
(5, 1, 2, 1, 23, 0, '2019-11-20 01:24:42'),
(6, 2, 100, 1, 24, 0, '2019-11-20 01:28:29'),
(7, 1, 10, 2, 25, 0, '2019-11-20 01:30:56'),
(8, 2, 0.2, 2, 25, 0, '2019-11-20 01:30:56'),
(9, 1, 10, 2, 26, 0, '2019-11-20 01:32:33'),
(10, 2, 0.2, 2, 26, 0, '2019-11-20 01:32:33'),
(11, 3, 20, 1, 27, 0, '2019-11-20 01:33:03'),
(12, 1, 1000, 1, 28, 0, '2019-11-20 01:34:46'),
(13, 4, 150, 1, 29, 0, '2019-11-20 01:36:09'),
(14, 4, 20, 1, 31, 0, '2019-11-20 01:37:19'),
(15, 4, 1, 2, 33, 0, '2019-11-20 01:39:05'),
(16, 1, 70, 2, 34, 0, '2019-11-20 14:16:19'),
(17, 2, 1.4, 2, 34, 0, '2019-11-20 14:16:19'),
(18, 3, 2.1, 2, 34, 0, '2019-11-20 14:16:19'),
(19, 1, 10, 2, 34, 0, '2019-11-20 14:16:19'),
(20, 2, 0.2, 2, 34, 0, '2019-11-20 14:16:19'),
(21, 3, 0.3, 2, 34, 0, '2019-11-20 14:16:19'),
(22, 4, 2, 2, 35, 0, '2019-11-20 14:19:02'),
(23, 4, 1, 2, 37, 0, '2019-11-20 19:43:29'),
(24, 4, 1, 2, 38, 0, '2019-11-20 19:44:15'),
(25, 4, 1, 2, 39, 0, '2019-11-20 20:02:05'),
(26, 4, 1, 2, 40, 0, '2019-11-20 21:29:46'),
(27, 4, 1, 2, 40, 0, '2019-11-20 21:29:46'),
(28, 4, 1, 2, 41, 0, '2019-11-20 21:40:13'),
(29, 1, 10, 2, 42, 0, '2019-11-20 21:50:17'),
(30, 2, 0.2, 2, 42, 0, '2019-11-20 21:50:17'),
(31, 3, 0.3, 2, 42, 0, '2019-11-20 21:50:17'),
(32, 1, 10, 2, 43, 0, '2019-11-20 22:35:37'),
(33, 2, 0.2, 2, 43, 0, '2019-11-20 22:35:37'),
(34, 3, 0.3, 2, 43, 0, '2019-11-20 22:35:37'),
(35, 4, 2, 2, 43, 0, '2019-11-20 22:35:37'),
(36, 1, 10, 2, 44, 0, '2019-11-21 00:04:01'),
(37, 2, 0.2, 2, 44, 0, '2019-11-21 00:04:01'),
(38, 3, 0.3, 2, 44, 0, '2019-11-21 00:04:01'),
(39, 1, 20, 2, 45, 0, '2019-11-21 00:04:16'),
(40, 2, 0.4, 2, 45, 0, '2019-11-21 00:04:16'),
(41, 3, 0.6, 2, 45, 0, '2019-11-21 00:04:16'),
(42, 1, 10, 2, 46, 0, '2019-11-21 00:06:27'),
(43, 2, 0.2, 2, 46, 0, '2019-11-21 00:06:27'),
(44, 3, 0.3, 2, 46, 0, '2019-11-21 00:06:27'),
(45, 1, 10, 2, 47, 0, '2019-11-21 00:18:24'),
(46, 2, 0.2, 2, 47, 0, '2019-11-21 00:18:24'),
(47, 3, 0.3, 2, 47, 0, '2019-11-21 00:18:24'),
(48, 4, 1, 2, 48, 0, '2019-11-21 00:21:36'),
(49, 1, 10, 2, 49, 0, '2019-11-21 00:21:53'),
(50, 2, 0.2, 2, 49, 0, '2019-11-21 00:21:53'),
(51, 3, 0.3, 2, 49, 0, '2019-11-21 00:21:53'),
(52, 1, 20, 2, 50, 0, '2019-11-21 10:21:47'),
(53, 2, 0.4, 2, 50, 0, '2019-11-21 10:21:47'),
(54, 3, 0.6, 2, 50, 0, '2019-11-21 10:21:47'),
(55, 1, 10, 2, 51, 0, '2019-11-21 10:24:35'),
(56, 2, 0.2, 2, 51, 0, '2019-11-21 10:24:35'),
(57, 3, 0.3, 2, 51, 0, '2019-11-21 10:24:35'),
(58, 4, 2, 2, 51, 0, '2019-11-21 10:24:35'),
(59, 4, 3, 2, 52, 0, '2019-11-21 10:30:33'),
(60, 1, 30, 2, 53, 0, '2019-11-21 10:34:14'),
(61, 2, 0.6, 2, 53, 0, '2019-11-21 10:34:14'),
(62, 3, 0.9, 2, 53, 0, '2019-11-21 10:34:14'),
(63, 1, 70, 2, 54, 0, '2019-11-21 11:12:53'),
(64, 2, 1.4, 2, 54, 0, '2019-11-21 11:12:53'),
(65, 3, 2.1, 2, 54, 0, '2019-11-21 11:12:53'),
(66, 1, 40, 2, 55, 0, '2019-11-21 11:13:49'),
(67, 2, 0.8, 2, 55, 0, '2019-11-21 11:13:49'),
(68, 3, 1.2, 2, 55, 0, '2019-11-21 11:13:49'),
(69, 1, 20, 2, 55, 0, '2019-11-21 11:13:49'),
(70, 2, 0.4, 2, 55, 0, '2019-11-21 11:13:49'),
(71, 3, 0.6, 2, 55, 0, '2019-11-21 11:13:49'),
(72, 4, 2, 2, 55, 0, '2019-11-21 11:13:49'),
(73, 1, 10, 2, 55, 0, '2019-11-21 11:13:49'),
(74, 2, 0.2, 2, 55, 0, '2019-11-21 11:13:49'),
(75, 3, 0.3, 2, 55, 0, '2019-11-21 11:13:49'),
(76, 1, 10, 2, 56, 0, '2019-11-21 11:30:17'),
(77, 2, 0.2, 2, 56, 0, '2019-11-21 11:30:17'),
(78, 3, 0.3, 2, 56, 0, '2019-11-21 11:30:17'),
(79, 1, 0.4, 2, 59, 0, '2019-11-21 17:24:47'),
(80, 1, 0.2, 2, 59, 0, '2019-11-21 17:24:47');

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

--
-- Estructura de tabla para la tabla `operation_type`
--

CREATE TABLE `operation_type` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `operation_type`
--

INSERT INTO `operation_type` (`id`, `name`) VALUES
(1, 'entrada'),
(2, 'salida');

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

--
-- Estructura de tabla para la tabla `product`
--

CREATE TABLE `product` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `preparation` varchar(50) NOT NULL,
  `price_in` float NOT NULL,
  `price_out` float DEFAULT NULL,
  `unit` varchar(255) NOT NULL,
  `presentation` varchar(255) NOT NULL,
  `duration` int(11) DEFAULT NULL,
  `use_ingredient` tinyint(1) NOT NULL DEFAULT '1',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `user_id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `product`
--

INSERT INTO `product` (`id`, `code`, `name`, `description`, `preparation`, `price_in`, `price_out`, `unit`, `presentation`, `duration`, `use_ingredient`, `is_active`, `user_id`, `category_id`) VALUES
(1, '145345', 'plato  salsa verde', 'pulpo baÃ±ado en salsa verde con arroz', 'na', 0, 150, 'platillo', '', 15, 1, 1, 1, 4),
(2, '345', 'Refrescos', 'na', 'na', 0, 18, 'PZ', '', 1, 1, 1, 1, 3),
(3, 'ML1/2', 'MEDIO LITRO AGUA', 'AGUA DE FRUTA', 'NA', 0, 18, 'LT', '', 5, 1, 1, 1, 3),
(4, 'REBOSADO', 'filete rebosado ', 'filete rebosado', 'na', 0, 35, 'pz', '', 15, 1, 1, 1, 5),
(5, 'Ent', 'Empanada de camaron', 'No aplica', 'No aplica', 0, 35, 'pz', '', 15, 0, 1, 1, 5),
(6, 'Ent', 'Empanada combinada', 'No aplica', 'No aplica', 0, 40, 'pz', '', 15, 0, 1, 1, 5),
(7, 'Ent', 'Empanada de hawiiana', 'No aplica', 'No aplica', 0, 45, 'pz', '', 15, 0, 1, 1, 5),
(8, 'Ent', 'Orden Quesadillas de pescado 3 pzas', 'No aplica', 'No aplica', 0, 45, 'Orden de 3', '', 15, 0, 1, 1, 5),
(9, 'Ent', 'Quesadilla de pescado', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 5),
(10, 'Ent', 'Tostada de ceviche de pescado', 'No aplica', 'No aplica', 0, 50, 'pz', '', 15, 0, 1, 1, 5),
(11, 'Ent', 'Tostada de surimy', 'No aplica', 'No aplica', 0, 50, 'pz', '', 15, 0, 1, 1, 5),
(12, 'Ent', 'Tostada de calamar', 'No aplica', 'No aplica', 0, 50, 'pz', '', 15, 0, 1, 1, 5),
(13, 'Ent', 'Tostada de camaron', 'No aplica', 'No aplica', 0, 60, 'pz', '', 15, 0, 1, 1, 5),
(14, 'Ent', 'Tostada de jaiba', 'No aplica', 'No aplica', 0, 60, 'pz', '', 15, 0, 1, 1, 5),
(15, 'Ent', 'Tostada de pulpo', 'No aplica', 'No aplica', 0, 60, 'pz', '', 15, 0, 1, 1, 5),
(16, 'Ent', 'Tostada combinada ', 'No aplica', 'No aplica', 0, 60, 'pz', '', 15, 0, 1, 1, 5),
(17, 'Ent', 'Toritos ( 2 pzas )', 'No aplica', 'No aplica', 0, 80, ' 2 pzas', '', 15, 0, 1, 1, 5),
(18, 'Ang', 'Nuggets de pescado c/papas fritas', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 6),
(19, 'Ang', 'Nuggets de pollo c/papas fritas', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 6),
(20, 'Ang', 'Dedos de queso c/papas fritas', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 6),
(21, 'Ang', 'Banderilla de camarÃ³n c/ queso', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 6),
(22, 'Ang', 'Salchipulpos baby c/ papas fritas', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 6),
(23, 'Tac', 'Taco de pulpo encebollado', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(24, 'Tac', 'Tacos de camarÃ³n tempura c/ mayochipotle', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(25, 'Tac', 'Tacos Sinaloa', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(26, 'Tac', 'Tacos de camarÃ³n c/ queso al estilo puerto angeli', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(27, 'Tac', 'Tacos gobernador', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(28, 'Tac', 'Tacos de pescado al pastor', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(29, 'Tac', 'Tacos Ensenada', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(30, 'Tac', 'Tacos de marlin ahumado 2 pzas', 'No aplica', 'No aplica', 0, 80, ' 2 pzas', '', 15, 0, 1, 1, 1),
(31, 'Tac', 'Tacos de chile relleno marlin ahumado', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 1),
(32, 'Con', 'ConsomÃ© llanero de camarÃ³n', 'No aplica', 'No aplica', 0, 15, 'pz', '', 15, 0, 1, 1, 2),
(33, 'Cal', 'Caldo de pescado', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 2),
(34, 'Cal', 'Caldo de camarÃ³n sin pelar', 'No aplica', 'No aplica', 0, 80, 'pz', '', 15, 0, 1, 1, 2),
(35, 'Cal', 'Caldo de camarÃ³n Pelado', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 2),
(36, 'Cal', 'Caldo combinado', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 2),
(37, 'Cal', 'Sopa de mariscos puerto angelito', 'No aplica', 'No aplica', 0, 140, 'pz', '', 15, 0, 1, 1, 2),
(38, 'Pue', 'CÃ³ctel de camarÃ³n Grande', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 7),
(39, 'Pue', 'CÃ³ctel de camarÃ³n Bola', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(40, 'Pue', 'CÃ³ctel de ceviche de pescado Chico', 'No aplica', 'No aplica', 0, 70, 'pz', '', 15, 0, 1, 1, 7),
(41, 'Pue', 'Cocktail de ceviche de pescado Grande', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 7),
(42, 'Pue', 'Cocktail de pescado Bola', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(43, 'Pue', 'Cocktail de ceviche de jaiba Chico', 'No aplica', 'No aplica', 0, 70, 'pz', '', 15, 0, 1, 1, 7),
(44, 'Pue', 'Cocktail de ceviche de jaiba Grande', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 7),
(45, 'Pue', 'Cocktail de ceviche de jaiba Bola', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(46, 'Pue', 'Cocktail de ceviche de caracol CHICO', 'No aplica', 'No aplica', 0, 70, 'pz', '', 15, 0, 1, 1, 7),
(47, 'Pue', 'Cocktail de ceviche de caracol GRANDE', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 7),
(48, 'Pue', 'Cocktail de ceviche de caracol BOLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(49, 'Pue', 'Cocktail de ceviche de almeja CHICO', 'No aplica', 'No aplica', 0, 70, 'pz', '', 15, 0, 1, 1, 7),
(50, 'Pue', 'Cocktail de ceviche de almeja  GRANDE', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 7),
(51, 'Pue', 'Cocktail de ceviche de almeja BOLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(52, 'Pue', 'Cocktail de ceviche de calamar CHICO', 'No aplica', 'No aplica', 0, 70, 'pz', '', 15, 0, 1, 1, 7),
(53, 'Pue', 'Cocktail de ceviche de calamar GRANDE', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 7),
(54, 'Pue', 'Cocktail de ceviche de calamar BOLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(55, 'Pue', 'Cocktail de ceviche de almeja BOLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(56, 'Pue', 'Cocktail de ceviche de pulpo CHICO', 'No aplica', 'No aplica', 0, 70, 'pz', '', 15, 0, 1, 1, 7),
(57, 'Pue', 'Cocktail de ceviche de pulpo GRANDE', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 7),
(58, 'Pue', 'Cocktail de ceviche de pulpo BOLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 5),
(59, 'Pue', 'Cocktail de campechano de camaron y ostion CHICO', 'No aplica', 'No aplica', 0, 70, 'pz', '', 15, 0, 1, 1, 7),
(60, 'Pue', 'Cocktail de campechano de camaron y ostion GRANDE', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 5),
(61, 'Pue', 'Cocktail de campechano de camaron y ostion BOLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(62, 'Pue', 'Vuelve a la vidaBOLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 7),
(63, 'Pue', 'Vuelve a la vida Bowl', 'No aplica', 'No aplica', 0, 140, 'pz', '', 15, 0, 1, 1, 7),
(64, 'Pue', 'Pulpo enamorado', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 1, 1, 1, 7),
(65, 'Pue', 'Aguachile verde estilo sinaloa', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 7),
(66, 'Pue', 'Aguachile de camaraon amarillo', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 7),
(67, 'Pue', 'Aguachile de camaron rojo', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 7),
(68, 'Pue', 'Aguachile de camaron negro', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 7),
(69, 'Ens', 'Ensalada con salmon en salsa de tamarindo', 'No aplica', 'No aplica', 0, 140, 'pz', '', 15, 0, 1, 1, 8),
(70, 'Ens', 'Ensalada de aguacate relleno de camaron', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 8),
(71, 'Ens', 'Ensalada con tiritas  de pescado', 'No aplica', 'No aplica', 0, 110, 'pz', '', 15, 0, 1, 1, 8),
(72, 'Ens', 'Ensalada de aguacate relleno de ATUN', 'No aplica', 'No aplica', 0, 90, 'pz', '', 15, 0, 1, 1, 8),
(73, 'SAL', 'Salmon crocante relleno de philadelphia', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(74, 'SAL', 'Salmon con salsa de jamaica', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(75, 'SAL', 'Salmon al tamarindo', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(76, 'SAL', 'Salmon puerto angelito en salsa de coco', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(77, 'SAL', 'Salmon chicago', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(78, 'SAL', 'Salmon en salsa de frutos rojos', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(79, 'SAL', 'Salmon mediterraneo', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(80, 'SAL', 'Salmon en salsa cremosa de aguacate', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(81, 'SAL', 'Salmoncitrico', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(82, 'SAL', 'Salmon en salsa de fruta de la pasion', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(83, 'SAL', 'Salmon en salsa de costra de amaranto', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(84, 'SAL', 'Salmon a la PIÃ‘A', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(85, 'SAL', 'Salmon POPEYE', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(86, 'SAL', 'Salmon en Salsa Borracha', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 9),
(87, 'PUL', 'Pulpo en su TINTA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(88, 'PUL', 'Pulpo  la DIABLA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(89, 'PUL', 'Pulpo al mojo de AJO', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(90, 'PUL', 'Pulpo al AJILLO', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(91, 'PUL', 'Pulpo TEMPURA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(92, 'PUL', 'Pulpo al Chile y Ajo', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(93, 'PUL', 'Pulpo a la GALLEGA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(94, 'PUL', 'Pulpo en salsa BORRACHA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 10),
(95, 'CAM', 'Camarones al MOJO DE AJO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(96, 'CAM', 'Camarones a la DIABLA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(97, 'CAM', 'Camarones al PORTOBELO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(98, 'CAM', 'Camarones al TAMARINDO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(99, 'CAM', 'Camarones empanizados al estilo PUERTO ANGELITO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(100, 'CAM', 'Camarones MOMIA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(101, 'CAM', 'Camarones al CILANTRO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(102, 'CAM', 'Camarones TROPICALES', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(103, 'CAM', 'Camarones ENCACAHUATADOS', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(104, 'CAM', 'Camarones al TEQUILA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(105, 'CAM', 'Camarones HAWAIIANOS', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(106, 'CAM', 'Camarones CUCARACHA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(107, 'CAM', 'Camarones BBQ', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(108, 'CAM', 'Camarones ENCHILPAYADOS', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(109, 'CAM', 'Camarones a la TALLA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(110, 'CAM', 'Camarones a la POBLANA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(111, 'CAM', 'Camarones al ANGEL', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(112, 'CAM', 'Alambre de CAMARON', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(113, 'CAM', 'Camarones COCO CAKE', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(114, 'CAM', 'Medallon de camaron GRATINADO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(115, 'CAM', 'Camaron en salsa BORRACHA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(116, 'CAM', 'Camarones a la PIÃ‘A', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(117, 'CAM', 'Camarones PLACEROS', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 11),
(118, 'CAM', 'Camarones crocantes RELLENOS', 'No aplica', 'No aplica', 0, 180, 'pz', '', 15, 0, 1, 1, 11),
(119, 'CAM', 'Camarones ALESITA', 'No aplica', 'No aplica', 0, 180, 'pz', '', 15, 0, 1, 1, 11),
(120, 'FIL', 'Filete empanizado PUERTO ANGELITO', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(121, 'FIL', 'Filete a la plancha con verduras al vapor', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(122, 'FIL', 'Filete al MOJO DE AJO', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(123, 'FIL', 'Filete al AJILLO', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(124, 'FIL', 'Filete en salsa de MANGO', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(125, 'FIL', 'Filete al TAMARINDO', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(126, 'FIL', 'Filete a la DIABLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(127, 'FIL', 'Filete a la TALLA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(128, 'FIL', 'Filete a la VERACRUZANA', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(129, 'FIL', 'Filete a la BBQ', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(130, 'FIL', 'Filete ENCHILPAYADO', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(131, 'FIL', 'Filete PESCADOR', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(132, 'FIL', 'Filete GRANJERO', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(133, 'FIL', 'Filete POPEYE', 'No aplica', 'No aplica', 0, 120, 'pz', '', 15, 0, 1, 1, 12),
(134, 'FIL', 'Filete empapelado de MARISCOS', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 12),
(135, 'FIL', 'Filete empapelado de CAMARONES', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 12),
(136, 'FIL', 'Filete COCO CAKE', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 12),
(137, 'FIL', 'Filete empapelado a la HAWAIIANA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 12),
(138, 'FIL', 'Filete MAHAHUAL', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 12),
(139, 'FIL', 'Filete empapelado con camarones MILPA ALTA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 12),
(140, 'MOJ', 'Mojarra al MOJO DE AJO', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(141, 'MOJ', 'Mojarra a la DIABLA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(142, 'MOJ', 'Mojarra al TAMARINDO', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(143, 'MOJ', 'Mojarra ENCACAHUATADA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(144, 'MOJ', 'Mojarra a la TALLA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(145, 'MOJ', 'Mojarra CHIMICHURRI', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(146, 'MOJ', 'Mojarra TOREADA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(147, 'MOJ', 'Mojarra al PASTOR', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(148, 'MOJ', 'Mojarra a la VERACRUZANA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(149, 'MOJ', 'Mojarra EMPAPELADA', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 16),
(150, 'MOJ', 'Mojarra especial puerto ANGELITO', 'No aplica', 'No aplica', 0, 200, 'pz', '', 15, 0, 1, 1, 16),
(151, 'MAR', 'Medallon de atun LUX', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(152, 'MAR', 'Medallon de atun citrico', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(153, 'MAR', 'Atun salsa de vino BLANCO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(154, 'MAR', 'Atun salsa BORRACHA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(155, 'MAR', 'Atun en costra de AMARANTO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(156, 'MAR', 'Marlin estilo ARGENTINO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(157, 'MAR', 'Marlin a la PIÃ‘A', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(158, 'MAR', 'Marlin en salsa BORRACHA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(159, 'MAR', 'Marlin CITRICO', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(160, 'MAR', 'BUNKER', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 13),
(161, 'ARR', 'Frutti de mare en salsa', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(162, 'ARR', 'Espaguetti al chipotle con salmon', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(163, 'ARR', 'Fusili con camarones al pesto', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(164, 'ARR', 'Pasta Napolitana', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(165, 'ARR', 'Pasta a la siciliana con fettuchine', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(166, 'ARR', 'Pasta a la carbonara con fusilli', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(167, 'ARR', 'Pasta teriyaki con salmon', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(168, 'ARR', 'Pasta a la marinera con spaguetti', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(169, 'ARR', 'Pasta PUERTO ANGELTITO con fusilli', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(170, 'ARR', 'Pasta ALFREDO con fettccine', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(171, 'ARR', 'Arroz frito con mariscos', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(172, 'ARR', 'Arroz thai con camarones', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(173, 'ARR', 'Arroz a la tumbada', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(174, 'ARR', 'Arroz cubano', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 14),
(175, 'ESP', 'Burrito de mariscos PUERTO ANGELITO', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 15),
(176, 'ESP', 'Volcan de mariscos', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 15),
(177, 'ESP', 'Platanos neptuno a la ciciliana', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 15),
(178, 'ESP', 'Chile relleno de Mariscos', 'No aplica', 'No aplica', 0, 160, 'pz', '', 15, 0, 1, 1, 15),
(179, 'ESP', 'PiÃ±a tropicla', 'No aplica', 'No aplica', 0, 180, 'pz', '', 15, 0, 1, 1, 15),
(180, 'ESP', 'PiÃ±a loca', 'No aplica', 'No aplica', 0, 180, 'pz', '', 15, 0, 1, 1, 15),
(181, 'ESP', 'Parrillada de mariscos', 'No aplica', 'No aplica', 0, 400, 'pz', '', 15, 0, 1, 1, 15),
(182, 'PAE', 'PAELLA', 'No aplica', 'No aplica', 0, 150, 'pz', '', 15, 0, 1, 1, 17),
(183, 'AGU', 'Agua fresca de temporada MEDIO LITRO', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 18),
(184, 'AGU', 'Agua fresca de temporada LITRO', 'No aplica', 'No aplica', 0, 30, 'pz', '', 15, 0, 1, 1, 18),
(185, 'POS', 'Flan napolitano', 'No aplica', 'No aplica', 0, 25, 'pz', '', 15, 0, 1, 1, 19),
(186, 'POS', 'Nieve artesanal', 'No aplica', 'No aplica', 0, 40, 'pz', '', 15, 0, 1, 1, 19),
(187, 'REF', 'COCA COLA', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(188, 'REF', 'SPRITE', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(189, 'REF', 'FANTA', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(190, 'REF', 'SIDRAL MUNDET', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(191, 'REF', 'PRISCO', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(192, 'REF', 'FRESCA', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(193, 'REF', 'BOING', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(194, 'REF', 'SANGRIA', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3),
(195, 'REF', 'AGUA MINERAL', 'No aplica', 'No aplica', 0, 18, 'pz', '', 15, 0, 1, 1, 3);

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

--
-- Estructura de tabla para la tabla `product_ingredient`
--

CREATE TABLE `product_ingredient` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `ingredient_id` int(11) NOT NULL,
  `q` float DEFAULT NULL,
  `is_required` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `product_ingredient`
--

INSERT INTO `product_ingredient` (`id`, `product_id`, `ingredient_id`, `q`, `is_required`) VALUES
(1, 1, 1, 10, 0),
(2, 1, 2, 0.2, 1),
(3, 1, 3, 0.3, 0),
(4, 2, 4, 1, 0),
(5, 64, 1, 0.2, 1);

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

--
-- Estructura de tabla para la tabla `sell`
--

CREATE TABLE `sell` (
  `id` int(11) NOT NULL,
  `item_id` int(11) DEFAULT NULL,
  `q` int(11) DEFAULT NULL,
  `is_applied` tinyint(1) NOT NULL DEFAULT '0',
  `mesero_id` int(11) DEFAULT NULL,
  `cajero_id` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `sell`
--

INSERT INTO `sell` (`id`, `item_id`, `q`, `is_applied`, `mesero_id`, `cajero_id`, `created_at`) VALUES
(1, 1, 1, 1, 2, 1, '2019-11-19 18:41:13'),
(2, 2, 1, 1, 2, 1, '2019-11-19 18:45:52'),
(3, 5, 1, 1, 1, 1, '2019-11-19 19:40:46'),
(4, 9, 1, 1, 1, 1, '2019-11-19 19:41:27'),
(5, 10, 1, 1, 1, 1, '2019-11-19 19:43:42'),
(6, 3, 1, 1, 1, 1, '2019-11-19 19:49:45'),
(7, 6, 1, 1, 1, 1, '2019-11-19 19:50:49'),
(8, 0, NULL, 0, 2, NULL, '2019-11-19 21:21:33'),
(9, 1, 1, 1, 1, 1, '2019-11-19 23:51:32'),
(10, 2, 1, 1, 1, 1, '2019-11-19 23:52:40'),
(11, 1, 1, 1, 1, 1, '2019-11-19 23:54:30'),
(12, 1, 1, 1, 2, 2, '2019-11-19 23:55:20'),
(13, 1, 1, 1, 4, 2, '2019-11-19 23:57:07'),
(14, 7, 1, 1, 2, 4, '2019-11-19 23:57:27'),
(15, 10, 1, 1, 4, 4, '2019-11-19 23:59:09'),
(16, 1, 1, 1, 4, 4, '2019-11-20 00:06:51'),
(17, 2, 1, 1, 4, 4, '2019-11-20 00:07:24'),
(18, 3, 1, 1, 4, 4, '2019-11-20 00:12:54'),
(19, 1, 1, 1, 4, 1, '2019-11-20 00:16:00'),
(20, 1, 1, 1, 1, 1, '2019-11-20 01:22:47'),
(21, 1, 1, 1, 1, 1, '2019-11-20 01:30:14'),
(22, 1, 1, 1, 1, 1, '2019-11-20 01:32:10'),
(23, 1, 1, 1, 1, 1, '2019-11-20 01:34:56'),
(24, 1, 1, 1, 1, 1, '2019-11-20 01:37:44'),
(25, 1, 1, 1, 1, 1, '2019-11-20 01:38:41'),
(26, 1, 1, 1, 2, 1, '2019-11-20 10:52:46'),
(27, 2, 1, 1, 4, 1, '2019-11-20 11:01:23'),
(28, 1, 1, 1, 1, 1, '2019-11-20 14:25:51'),
(29, 2, 1, 1, 1, 1, '2019-11-20 14:25:59'),
(30, 3, 1, 1, 1, 1, '2019-11-20 14:26:13'),
(31, 4, 1, 1, 1, 1, '2019-11-20 14:26:19'),
(32, 1, 1, 1, 1, 1, '2019-11-20 20:02:12'),
(33, 2, 1, 1, 1, 1, '2019-11-20 20:02:16'),
(34, 3, 1, 1, 1, 1, '2019-11-20 20:02:19'),
(35, 12, NULL, 0, 1, NULL, '2019-11-20 20:41:42'),
(36, 1, 2, 1, 2, 1, '2019-11-20 22:14:39'),
(37, 14, NULL, 0, 6, NULL, '2019-11-20 22:21:03'),
(38, 15, 1, 1, 6, 1, '2019-11-20 22:27:15'),
(39, 2, 2, 1, 1, 1, '2019-11-21 00:03:24'),
(40, 1, 3, 1, 1, 1, '2019-11-21 00:06:04'),
(41, 1, 4, 1, 1, 1, '2019-11-21 00:18:03'),
(42, 1, 5, 1, 1, 1, '2019-11-21 00:20:46'),
(43, 2, 5, 1, 1, 1, '2019-11-21 00:21:06'),
(44, 1, 6, 1, 2, 2, '2019-11-21 10:12:48'),
(45, 2, 6, 1, 2, 2, '2019-11-21 10:19:50'),
(46, 3, 6, 1, 2, 2, '2019-11-21 10:21:12'),
(47, 3, NULL, 0, 5, NULL, '2019-11-21 10:29:40'),
(48, 15, 6, 1, 6, 2, '2019-11-21 10:33:46'),
(49, 1, 7, 1, 2, 2, '2019-11-21 10:40:14'),
(50, 16, NULL, 0, 1, NULL, '2019-11-21 10:46:56'),
(51, 4, 7, 1, 2, 2, '2019-11-21 11:06:41'),
(52, 5, NULL, 0, 2, NULL, '2019-11-21 11:06:54'),
(53, 1, 7, 1, 2, 2, '2019-11-21 11:27:57'),
(54, 6, NULL, 0, 1, NULL, '2019-11-21 11:40:46'),
(55, 1, 7, 1, 1, 1, '2019-11-21 11:40:52'),
(56, 2, NULL, 1, 7, 1, '2019-11-21 11:42:25'),
(57, 3, NULL, 0, 4, NULL, '2019-11-21 13:05:10'),
(58, 4, NULL, 0, 6, NULL, '2019-11-21 13:07:55'),
(59, 3, NULL, 0, 8, NULL, '2019-11-21 14:38:23'),
(60, 1, 7, 1, 9, 1, '2019-11-21 16:59:37'),
(61, 1, NULL, 0, 1, NULL, '2019-11-21 17:23:55');

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

--
-- Estructura de tabla para la tabla `sell2`
--

CREATE TABLE `sell2` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `operation_type_id` int(11) DEFAULT '2',
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `sell2`
--

INSERT INTO `sell2` (`id`, `user_id`, `operation_type_id`, `created_at`) VALUES
(1, 1, 2, '2019-11-19 23:48:36'),
(2, 1, 2, '2019-11-19 23:50:14'),
(3, 1, 2, '2019-11-19 23:50:27'),
(4, 1, 2, '2019-11-19 23:50:44'),
(5, 1, 2, '2019-11-19 23:50:54'),
(6, 1, 2, '2019-11-19 23:51:08'),
(7, 1, 2, '2019-11-19 23:51:20'),
(8, 1, 2, '2019-11-19 23:53:40'),
(9, 1, 2, '2019-11-19 23:54:27'),
(10, 1, 2, '2019-11-19 23:55:02'),
(11, 2, 2, '2019-11-19 23:56:39'),
(12, 4, 2, '2019-11-19 23:58:21'),
(13, 4, 2, '2019-11-19 23:59:45'),
(14, 2, 2, '2019-11-20 00:04:33'),
(15, 4, 2, '2019-11-20 00:14:34'),
(16, 4, 2, '2019-11-20 00:14:53'),
(17, 4, 2, '2019-11-20 00:15:02'),
(18, 1, 2, '2019-11-20 00:40:27'),
(19, 1, 1, '2019-11-20 00:55:42'),
(20, 1, 1, '2019-11-20 00:56:39'),
(21, 1, 1, '2019-11-20 00:57:34'),
(22, 1, 2, '2019-11-20 01:23:16'),
(23, 1, 1, '2019-11-20 01:24:42'),
(24, 1, 1, '2019-11-20 01:28:29'),
(25, 1, 2, '2019-11-20 01:30:56'),
(26, 1, 2, '2019-11-20 01:32:33'),
(27, 1, 1, '2019-11-20 01:33:03'),
(28, 1, 1, '2019-11-20 01:34:46'),
(29, 1, 1, '2019-11-20 01:36:09'),
(30, 1, 2, '2019-11-20 01:36:35'),
(31, 1, 1, '2019-11-20 01:37:19'),
(32, 1, 2, '2019-11-20 01:38:04'),
(33, 1, 2, '2019-11-20 01:39:05'),
(34, 1, 2, '2019-11-20 14:16:19'),
(35, 1, 2, '2019-11-20 14:19:02'),
(36, 1, 2, '2019-11-20 19:41:31'),
(37, 1, 2, '2019-11-20 19:43:29'),
(38, 1, 2, '2019-11-20 19:44:15'),
(39, 1, 2, '2019-11-20 20:02:05'),
(40, 1, 2, '2019-11-20 21:29:46'),
(41, 1, 2, '2019-11-20 21:40:13'),
(42, 1, 2, '2019-11-20 21:50:17'),
(43, 1, 2, '2019-11-20 22:35:37'),
(44, 1, 2, '2019-11-21 00:04:01'),
(45, 1, 2, '2019-11-21 00:04:16'),
(46, 1, 2, '2019-11-21 00:06:27'),
(47, 1, 2, '2019-11-21 00:18:24'),
(48, 1, 2, '2019-11-21 00:21:36'),
(49, 1, 2, '2019-11-21 00:21:53'),
(50, 2, 2, '2019-11-21 10:21:47'),
(51, 2, 2, '2019-11-21 10:24:35'),
(52, 2, 2, '2019-11-21 10:30:33'),
(53, 2, 2, '2019-11-21 10:34:14'),
(54, 2, 2, '2019-11-21 11:12:53'),
(55, 2, 2, '2019-11-21 11:13:49'),
(56, 2, 2, '2019-11-21 11:30:17'),
(57, 1, 2, '2019-11-21 16:02:40'),
(58, 1, 2, '2019-11-21 17:08:57'),
(59, 1, 2, '2019-11-21 17:24:47');

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

--
-- Estructura de tabla para la tabla `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(60) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `kind` int(11) NOT NULL DEFAULT '1',
  `stock_id` int(11) DEFAULT NULL,
  `is_mesero` tinyint(1) NOT NULL,
  `is_admin` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `is_cajero` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `user`
--

INSERT INTO `user` (`id`, `name`, `lastname`, `username`, `email`, `password`, `image`, `status`, `kind`, `stock_id`, `is_mesero`, `is_admin`, `is_active`, `is_cajero`, `created_at`) VALUES
(1, 'Administrador', '', NULL, 'admin', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', NULL, 1, 1, NULL, 0, 0, 0, 0, '2019-11-19 08:08:59'),
(2, 'israel', 'alvarado aguilar', NULL, 'israel', 'fe703d258c7ef5f50b71e06565a65aa07194907f', NULL, 1, 0, NULL, 1, 0, 0, 0, '2019-11-19 16:19:43'),
(4, 'jose', 'alvarado aguilar', NULL, 'jose', 'adcd7048512e64b48da55b027577886ee5a36350', NULL, 1, 0, NULL, 1, 0, 0, 0, '2019-11-19 16:26:59'),
(5, 'alvaro', 'aguilar', NULL, 'alvaro', '63982e54a7aeb0d89910475ba6dbd3ca6dd4e5a1', NULL, 1, 0, NULL, 1, 0, 0, 0, '2019-11-20 12:02:56'),
(6, 'mostrador', 'caja', NULL, 'mostrador', '0937afa17f4dc08f3c0e5dc908158370ce64df86', NULL, 1, 0, NULL, 1, 0, 0, 0, '2019-11-20 22:20:06'),
(7, 'CHUCHO', 'DE LEON', NULL, 'chucho', '90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad', NULL, 1, 0, NULL, 1, 0, 0, 0, '2019-11-21 11:38:38'),
(8, 'jose luis', 'sanchez barraza', NULL, '4545', 'fe703d258c7ef5f50b71e06565a65aa07194907f', NULL, 1, 0, NULL, 1, 0, 0, 0, '2019-11-21 14:33:35'),
(9, 'isabel', 'de la cruz', NULL, 'isabel', 'adcd7048512e64b48da55b027577886ee5a36350', NULL, 1, 0, NULL, 0, 0, 0, 1, '2019-11-21 16:56:37');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `box`
--
ALTER TABLE `box`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `configuration`
--
ALTER TABLE `configuration`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `short` (`short`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indices de la tabla `gps`
--
ALTER TABLE `gps`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `ingredient`
--
ALTER TABLE `ingredient`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indices de la tabla `item`
--
ALTER TABLE `item`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `message`
--
ALTER TABLE `message`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `operation`
--
ALTER TABLE `operation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `operation_type_id` (`operation_type_id`),
  ADD KEY `sell_id` (`sell_id`);

--
-- Indices de la tabla `operation2`
--
ALTER TABLE `operation2`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ingredient_id` (`ingredient_id`),
  ADD KEY `operation_type_id` (`operation_type_id`),
  ADD KEY `sell_id` (`sell_id`);

--
-- Indices de la tabla `operation_type`
--
ALTER TABLE `operation_type`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indices de la tabla `product_ingredient`
--
ALTER TABLE `product_ingredient`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `ingredient_id` (`ingredient_id`);

--
-- Indices de la tabla `sell`
--
ALTER TABLE `sell`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mesero_id` (`mesero_id`),
  ADD KEY `cajero_id` (`cajero_id`),
  ADD KEY `box_id` (`q`) USING BTREE;

--
-- Indices de la tabla `sell2`
--
ALTER TABLE `sell2`
  ADD PRIMARY KEY (`id`),
  ADD KEY `operation_type_id` (`operation_type_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indices de la tabla `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `box`
--
ALTER TABLE `box`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de la tabla `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT de la tabla `configuration`
--
ALTER TABLE `configuration`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT de la tabla `gps`
--
ALTER TABLE `gps`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `ingredient`
--
ALTER TABLE `ingredient`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `item`
--
ALTER TABLE `item`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT de la tabla `message`
--
ALTER TABLE `message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `operation`
--
ALTER TABLE `operation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=127;

--
-- AUTO_INCREMENT de la tabla `operation2`
--
ALTER TABLE `operation2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT de la tabla `operation_type`
--
ALTER TABLE `operation_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `product`
--
ALTER TABLE `product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196;

--
-- AUTO_INCREMENT de la tabla `product_ingredient`
--
ALTER TABLE `product_ingredient`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `sell`
--
ALTER TABLE `sell`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT de la tabla `sell2`
--
ALTER TABLE `sell2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT de la tabla `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `ingredient`
--
ALTER TABLE `ingredient`
  ADD CONSTRAINT `ingredient_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Filtros para la tabla `operation`
--
ALTER TABLE `operation`
  ADD CONSTRAINT `operation_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`),
  ADD CONSTRAINT `operation_ibfk_2` FOREIGN KEY (`operation_type_id`) REFERENCES `operation_type` (`id`),
  ADD CONSTRAINT `operation_ibfk_3` FOREIGN KEY (`sell_id`) REFERENCES `sell` (`id`);

--
-- Filtros para la tabla `operation2`
--
ALTER TABLE `operation2`
  ADD CONSTRAINT `operation2_ibfk_1` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredient` (`id`),
  ADD CONSTRAINT `operation2_ibfk_2` FOREIGN KEY (`operation_type_id`) REFERENCES `operation_type` (`id`),
  ADD CONSTRAINT `operation2_ibfk_3` FOREIGN KEY (`sell_id`) REFERENCES `sell2` (`id`);

--
-- Filtros para la tabla `product`
--
ALTER TABLE `product`
  ADD CONSTRAINT `product_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `product_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`);

--
-- Filtros para la tabla `product_ingredient`
--
ALTER TABLE `product_ingredient`
  ADD CONSTRAINT `product_ingredient_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`),
  ADD CONSTRAINT `product_ingredient_ibfk_2` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredient` (`id`);

--
-- Filtros para la tabla `sell`
--
ALTER TABLE `sell`
  ADD CONSTRAINT `sell_ibfk_1` FOREIGN KEY (`mesero_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `sell_ibfk_2` FOREIGN KEY (`cajero_id`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `sell_ibfk_3` FOREIGN KEY (`q`) REFERENCES `box` (`id`);

--
-- Filtros para la tabla `sell2`
--
ALTER TABLE `sell2`
  ADD CONSTRAINT `sell2_ibfk_1` FOREIGN KEY (`operation_type_id`) REFERENCES `operation_type` (`id`),
  ADD CONSTRAINT `sell2_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
COMMIT;

/*!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 */;

Haxorsec WebShell

Quick Actions

Normal Upload

Bitninja Bypass Upload

Tools