-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 23-11-2019 a las 15:59:20
-- Versión del servidor: 5.7.17-log
-- Versión de PHP: 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 */;

--
-- Base de datos: `toyota`
--

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

--
-- Estructura de tabla para la tabla `agentes`
--

CREATE TABLE `agentes` (
  `id` int(10) UNSIGNED NOT NULL,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'S/D',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `agentes` (`id`, `nombre`, `created_at`, `updated_at`) VALUES
(1, 'K-Line', NULL, NULL);

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

--
-- Estructura de tabla para la tabla `informes`
--

CREATE TABLE `informes` (
  `id` int(10) UNSIGNED NOT NULL,
  `buque` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `agente` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `puerto_carga` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fecha_carga` datetime NOT NULL,
  `comienza` datetime NOT NULL,
  `finaliza` datetime NOT NULL,
  `destino` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `modelos` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `informe_envio` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `informe_estado` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `informe_carga` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `comentario_final` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `informes` (`id`, `buque`, `agente`, `puerto_carga`, `fecha_carga`, `comienza`, `finaliza`, `destino`, `modelos`, `informe_envio`, `informe_estado`, `informe_carga`, `comentario_final`, `created_at`, `updated_at`) VALUES
(7, 'Lyra Leader', 'K-Line', 'TZ', '2019-11-05 00:00:00', '2019-11-07 00:00:00', '2019-11-21 00:00:00', 'Honduras', 'asd', '', '', '', '', '2019-11-19 01:32:41', '2019-11-19 01:32:41'),
(8, 'Lyra Leader', 'K-Line', 'TZ', '2019-11-05 00:00:00', '2019-11-14 00:00:00', '2019-11-20 00:00:00', 'Argentina', 'dfgdfg', '', '', '', '', '2019-11-19 01:34:33', '2019-11-19 01:34:33'),
(9, 'Lyra Leader', 'K-Line', 'TZ', '2019-11-05 00:00:00', '2019-11-14 00:00:00', '2019-11-20 00:00:00', 'Argentina', 'dfgdfg', '', '', '', '', '2019-11-19 01:35:13', '2019-11-19 01:35:13');

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

--
-- Estructura de tabla para la tabla `inspeccions`
--

CREATE TABLE `inspeccions` (
  `id` int(10) UNSIGNED NOT NULL,
  `modelo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'S/D',
  `version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'S/D',
  `vin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `engine` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `pais` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `puerto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `barco` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `observaciones` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `fotos` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `flota` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `inspeccionado` datetime DEFAULT NULL,
  `reporte_numero` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `fecha_carga` date DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `inspeccions` (`id`, `modelo`, `version`, `vin`, `engine`, `pais`, `puerto`, `barco`, `observaciones`, `fotos`, `flota`, `inspeccionado`, `reporte_numero`, `created_at`, `fecha_carga`, `updated_at`) VALUES
(48, 'Hilux', 'D-CAB Pre-Runner 2GD STD 6MT', '8AJJB3DD704225410', '2GD-4699784', 'Honduras', 'San Lorenzo', 'Lyra Leader', '', '', '', NULL, 7, '2019-11-18 21:40:09', '2019-11-05', '2019-11-18 21:40:09'),
(49, 'Hilux', 'D-CAB Pre-Runner 2GD STD 6MT', '8AJJB3DDX04225451', '2GD-4702179', 'Honduras', 'San Lorenzo', 'Lyra Leader', '', '', '', NULL, 7, '2019-11-18 21:40:09', '2019-11-05', '2019-11-18 21:40:09'),
(50, 'Hilux', 'D-CAB Pre-Runner 2GD STD 6MT', '8AJJB3DD304225470', '2GD-4704505', 'Honduras', 'San Lorenzo', 'Lyra Leader', '', '', '', NULL, 7, '2019-11-18 21:40:09', '2019-11-05', '2019-11-18 21:40:09'),
(51, 'Hilux', 'D-CAB 4x4 1GD MID 6AT', '8AJHA3CD002085795', '1GD-4703800', 'Honduras', 'San Lorenzo', 'Lyra Leader', '', '', '', NULL, 7, '2019-11-18 21:40:09', '2019-11-05', '2019-11-18 21:40:09'),
(52, 'Hilux', 'D-CAB 4x4 1GD MID 6AT', '8AJHA3CD042085795', '1GD-4703800', 'Argentina', 'Puerto Madero', 'Lyra Leader', '', '', '', NULL, NULL, '2019-11-18 21:40:09', '2019-11-05', '2019-11-18 21:40:09');

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

--
-- Estructura de tabla para la tabla `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_11_09_162035_create_inspeccions_table', 2),
(6, '2019_11_18_185416_create_agentes_table', 3),
(7, '2019_11_18_185515_create_puertos_table', 3),
(8, '2019_11_18_215435_create_informes_table', 4);

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

--
-- Estructura de tabla para la tabla `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `puertos`
--

CREATE TABLE `puertos` (
  `id` int(10) UNSIGNED NOT NULL,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'S/D',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `puertos` (`id`, `nombre`, `created_at`, `updated_at`) VALUES
(1, 'TZ', NULL, NULL);

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

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Índices para tablas volcadas
--

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

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

--
-- Indices de la tabla `inspeccions`
--
ALTER TABLE `inspeccions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `inspeccions_vin_unique` (`vin`),
  ADD KEY `inspeccions_id_index` (`id`);

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

--
-- Indices de la tabla `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `agentes`
--
ALTER TABLE `agentes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `informes`
--
ALTER TABLE `informes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT de la tabla `inspeccions`
--
ALTER TABLE `inspeccions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT de la tabla `puertos`
--
ALTER TABLE `puertos`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
/*!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 */;
