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