-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 04-08-2024 a las 16:10:32
-- Versión del servidor: 10.6.18-MariaDB
-- Versión de PHP: 8.1.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `fundaci4_pqta-back`
--

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

--
-- Estructura de tabla para la tabla `bank_accounts`
--

CREATE TABLE `bank_accounts` (
  `bank_accounts_id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(255) NOT NULL,
  `money_available` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `bank_accounts_tours`
--

CREATE TABLE `bank_accounts_tours` (
  `bank_account_tour_id` bigint(20) UNSIGNED NOT NULL,
  `bank_accounts_id` bigint(20) UNSIGNED NOT NULL,
  `monthly_tour_id` bigint(20) UNSIGNED NOT NULL,
  `utility` double(8,2) NOT NULL,
  `money_before_tour` double(8,2) NOT NULL,
  `money_after_tour` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `categories`
--

CREATE TABLE `categories` (
  `categories_id` bigint(20) UNSIGNED NOT NULL,
  `Description` text DEFAULT 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 `categories`
--

INSERT INTO `categories` (`categories_id`, `Description`, `created_at`, `updated_at`) VALUES
(1, 'Sin Categoría', '2024-04-07 17:06:52', '2024-04-07 17:06:52'),
(2, 'bebidas', '2024-04-07 18:56:13', '2024-04-07 18:56:13'),
(3, 'abastos', '2024-04-07 18:56:51', '2024-04-07 18:56:51'),
(4, 'lacteos', '2024-04-07 18:57:24', '2024-04-07 18:57:24'),
(5, 'galletas', '2024-04-07 18:57:44', '2024-04-07 18:57:44'),
(6, 'chicles', '2024-04-07 18:57:50', '2024-04-07 19:00:00'),
(10, 'harinas', '2024-04-07 19:02:33', '2024-04-07 19:02:33'),
(11, 'plasticos', '2024-04-07 19:03:00', '2024-04-07 19:03:00'),
(12, 'Balanceado', '2024-04-07 19:17:31', '2024-04-07 19:17:31'),
(13, 'BEBIDAS ALCOLICAS', '2024-04-07 19:39:53', '2024-04-07 19:39:53');

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

--
-- Estructura de tabla para la tabla `credits`
--

CREATE TABLE `credits` (
  `credit_id` bigint(20) UNSIGNED NOT NULL,
  `ci` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `loan` double(8,2) DEFAULT NULL,
  `parcial_pay` double(8,2) DEFAULT NULL,
  `interest` double(8,2) DEFAULT NULL,
  `total_loan` double(8,2) DEFAULT NULL,
  `to_collect` double(8,2) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `limit_date` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `enterprises`
--

CREATE TABLE `enterprises` (
  `enterprise_id` bigint(20) UNSIGNED NOT NULL,
  `enterprise_name` varchar(255) DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `manager` text DEFAULT NULL,
  `img` text DEFAULT NULL,
  `software_type_id` int(11) 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 `enterprises`
--

INSERT INTO `enterprises` (`enterprise_id`, `enterprise_name`, `phone`, `address`, `manager`, `img`, `software_type_id`, `created_at`, `updated_at`) VALUES
(1, 'Paquita', '0961119670', 'Esteban Marañon y Lope Antonio de Munive', 'Luis Yumiseba', 'paquita-logo.png', 2, '2024-08-04 01:46:46', '2024-08-04 01:46:46');

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

--
-- Estructura de tabla para la tabla `equipment`
--

CREATE TABLE `equipment` (
  `equipment_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `cost` double(8,2) NOT NULL,
  `img_1` varchar(255) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `type` varchar(255) NOT NULL,
  `discount` double(8,2) NOT NULL,
  `discount_description` varchar(255) NOT NULL,
  `contact_phone` varchar(255) NOT NULL,
  `messagge_for_contact` varchar(255) NOT NULL,
  `varchar_1` varchar(255) DEFAULT NULL,
  `varchar_2` varchar(255) DEFAULT NULL,
  `varchar_3` varchar(255) DEFAULT NULL,
  `last_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `equipment_rents`
--

CREATE TABLE `equipment_rents` (
  `equipment_rent_id` bigint(20) UNSIGNED NOT NULL,
  `inventories_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `cost` double(8,2) DEFAULT NULL,
  `img_1` varchar(255) DEFAULT NULL,
  `state` tinyint(1) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `isActive` tinyint(1) DEFAULT NULL,
  `discount` double(8,2) DEFAULT NULL,
  `discount_description` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `messagge_for_contact` varchar(255) DEFAULT NULL,
  `cch_points` double(8,2) DEFAULT NULL,
  `varchar_1` varchar(255) DEFAULT NULL,
  `varchar_2` varchar(255) DEFAULT NULL,
  `varchar_3` varchar(255) DEFAULT NULL,
  `last_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `expenses_tours`
--

CREATE TABLE `expenses_tours` (
  `expense_tour_id` bigint(20) UNSIGNED NOT NULL,
  `list_id` int(11) NOT NULL,
  `quantity` double(8,2) NOT NULL,
  `description` text NOT NULL,
  `unit_cost` double(8,2) NOT NULL,
  `total_cost` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `exposition_tours`
--

CREATE TABLE `exposition_tours` (
  `exposition_tour_id` bigint(20) UNSIGNED NOT NULL,
  `tour_name` varchar(255) NOT NULL,
  `tour_destiny` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `include` text NOT NULL,
  `cost_1` double(8,2) NOT NULL,
  `cost_2` double(8,2) NOT NULL,
  `cost_3` double(8,2) NOT NULL,
  `cost_4` double(8,2) NOT NULL,
  `img_1` varchar(255) NOT NULL,
  `img_2` varchar(255) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `type` varchar(255) NOT NULL,
  `discount` double(8,2) NOT NULL,
  `varchar_1` varchar(255) NOT NULL,
  `varchar_2` varchar(255) NOT NULL,
  `varchar_3` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `galleries`
--

CREATE TABLE `galleries` (
  `gallery_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `img_1` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `incomes_tours`
--

CREATE TABLE `incomes_tours` (
  `income_tour_id` bigint(20) UNSIGNED NOT NULL,
  `expense_tour_id` int(11) NOT NULL,
  `quantity` double(8,2) NOT NULL,
  `description` text NOT NULL,
  `unit_cost` double(8,2) NOT NULL,
  `total_cost` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `inventories`
--

CREATE TABLE `inventories` (
  `inventories_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `stock` double(8,2) DEFAULT NULL,
  `inWarehouse` double(8,2) DEFAULT NULL,
  `withoutWarehouse` double(8,2) DEFAULT NULL,
  `Observation` text DEFAULT NULL,
  `status_id` int(11) DEFAULT NULL,
  `varchar2` text DEFAULT NULL,
  `varchar3` text DEFAULT 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 `inventories`
--

INSERT INTO `inventories` (`inventories_id`, `product_id`, `stock`, `inWarehouse`, `withoutWarehouse`, `Observation`, `status_id`, `varchar2`, `varchar3`, `created_at`, `updated_at`) VALUES
(1, 1, 15.00, 15.00, 0.00, NULL, 1, NULL, NULL, NULL, NULL);

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

--
-- Estructura de tabla para la tabla `listas`
--

CREATE TABLE `listas` (
  `list_id` bigint(20) UNSIGNED NOT NULL,
  `monthly_tour_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `Description` text DEFAULT NULL,
  `status_list` text DEFAULT NULL,
  `varchar1` text DEFAULT NULL,
  `int1` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2019_08_19_000000_create_failed_jobs_table', 1),
(9, '2022_06_14_073855_create_exposition_tours_table', 1),
(10, '2022_06_14_073925_create_monthly_tours_table', 1),
(11, '2022_06_14_074030_create_montly_tours_users_table', 1),
(12, '2022_06_14_074120_create_incomes_tours_table', 1),
(13, '2022_06_14_074200_create_expenses_tours_table', 1),
(14, '2022_06_14_074238_create_bank_accounts_table', 1),
(15, '2022_06_14_074306_create_bank_accounts_tours_table', 1),
(16, '2022_09_18_201603_create_tour_catalogues_table', 1),
(17, '2022_10_11_221452_create_equipment_table', 1),
(18, '2023_01_08_191159_create_equipment_rents_table', 1),
(19, '2023_03_22_154149_create_galleries_table', 1),
(20, '2023_06_27_151131_create_passenger_list_monthly_tours_table', 1),
(21, '2023_06_27_151622_create_passenger_lists_table', 1),
(22, '2023_06_30_193810_create_passengers_table', 1),
(23, '2023_09_09_064759_create_listas_table', 1),
(24, '2023_09_10_184656_create_categories_table', 1),
(25, '2023_09_10_184738_create_products_table', 1),
(26, '2023_09_10_184812_create_inventories_table', 1),
(27, '2023_09_10_190020_create_warehouses_table', 1),
(28, '2023_09_10_190040_create_product_warehouses_table', 1),
(29, '2023_09_10_191436_create_suppliers_table', 1),
(30, '2023_09_16_064402_create_statuses_table', 1),
(31, '2023_11_15_171614_create_produts_list_warehouses_table', 1),
(32, '2023_11_17_111401_create_request_products_to_warehouses_table', 1),
(33, '2023_11_20_170946_create_request_complete_products_table', 1),
(34, '2024_03_08_042339_create_software_tipes_table', 1),
(35, '2024_03_08_044305_create_enterprises_table', 1),
(36, '2024_03_08_140135_create_credits_table', 1),
(37, '2024_04_28_135701_create_sales_products_table', 1),
(38, '2024_05_11_084648_create_total_account_sales_table', 1),
(39, '2024_05_11_093811_create_secuential_bills_table', 1);

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

--
-- Estructura de tabla para la tabla `monthly_tours`
--

CREATE TABLE `monthly_tours` (
  `monthly_tour_id` bigint(20) UNSIGNED NOT NULL,
  `tour_name` varchar(255) NOT NULL,
  `tour_destiny` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `include` text NOT NULL,
  `img_1` varchar(255) NOT NULL,
  `img_2` varchar(255) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `type` varchar(255) NOT NULL,
  `dificulty` varchar(255) NOT NULL,
  `person_cost` double(8,2) NOT NULL,
  `group_cost` double(8,2) NOT NULL,
  `discount` double(8,2) DEFAULT NULL,
  `income` double(8,2) DEFAULT NULL,
  `egress` double(8,2) DEFAULT NULL,
  `utility` double(8,2) DEFAULT NULL,
  `contact_phone` varchar(255) NOT NULL,
  `messagge_for_contact` varchar(255) NOT NULL,
  `departure_date` date NOT NULL,
  `return_date` date NOT NULL,
  `varchar_1` varchar(255) DEFAULT NULL,
  `varchar_2` varchar(255) DEFAULT NULL,
  `varchar_3` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `monthly_tours_users`
--

CREATE TABLE `monthly_tours_users` (
  `monthly_tour_user_id` bigint(20) UNSIGNED NOT NULL,
  `monthly_tour_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `seats` int(11) NOT NULL,
  `coment` text NOT NULL,
  `img_voucher` text NOT NULL,
  `ammount_deposited` double(8,2) NOT NULL,
  `missing_ammount` double(8,2) NOT NULL,
  `messagge` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('ed1bb1259cac6eb44f2811af729e4660872617b6334d639ef4a4742094830577aea7fac663129f61', 1, 1, 'authToken', '[]', 1, '2024-08-04 02:33:09', '2024-08-04 02:33:09', '2024-09-03 21:33:09');

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

--
-- Estructura de tabla para la tabla `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `secret` varchar(100) DEFAULT NULL,
  `provider` varchar(255) DEFAULT NULL,
  `redirect` text NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) 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 `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Laravel Personal Access Client', 'tflbXv5h6V0Ql0zoKbqmw4SkbKBp789CPa4woI5l', NULL, 'http://localhost', 1, 0, 0, '2024-08-04 01:46:42', '2024-08-04 01:46:42'),
(2, NULL, 'Laravel Password Grant Client', 'EYoXhgKb4NhS9PFkSDOeNpZPMR6gpzOWoCs6mmNX', 'users', 'http://localhost', 0, 1, 0, '2024-08-04 01:46:42', '2024-08-04 01:46:42');

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

--
-- Estructura de tabla para la tabla `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED 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 `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2024-08-04 01:46:42', '2024-08-04 01:46:42');

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

--
-- Estructura de tabla para la tabla `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) NOT NULL,
  `access_token_id` varchar(100) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `passengers`
--

CREATE TABLE `passengers` (
  `passenger_id` bigint(20) UNSIGNED NOT NULL,
  `ci` text NOT NULL,
  `name` text NOT NULL,
  `phone` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `correo` text DEFAULT NULL,
  `age` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `born_date` text DEFAULT NULL,
  `password` text DEFAULT 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 `passengers`
--

INSERT INTO `passengers` (`passenger_id`, `ci`, `name`, `phone`, `city`, `correo`, `age`, `address`, `born_date`, `password`, `created_at`, `updated_at`) VALUES
(1, '9999999999', 'Consumidor Final', '9999999999', 'No Aplica', 'consumidorfinal@gmail.com', '18', 'No Aplica', '2022-06-10', '$2y$10$xDV5ioCPHCBCTSsZVLAz2eVtuJzxX0yllFNbOyD.Yu4cL6IQKj2xa', '2024-08-04 01:46:46', '2024-08-04 01:46:46');

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

--
-- Estructura de tabla para la tabla `passenger_lists`
--

CREATE TABLE `passenger_lists` (
  `passenger_lists_id` bigint(20) UNSIGNED NOT NULL,
  `list_id` int(11) NOT NULL,
  `passenger_ci` text NOT NULL,
  `seat` int(11) DEFAULT NULL,
  `unit_cost` double(8,2) DEFAULT NULL,
  `total_cost` double(8,2) DEFAULT NULL,
  `collected` double(8,2) DEFAULT NULL,
  `bus_extra` double(8,2) DEFAULT NULL,
  `to_collect` double(8,2) DEFAULT NULL,
  `bank` text DEFAULT NULL,
  `responsable` text DEFAULT NULL,
  `meeting_point` text DEFAULT NULL,
  `observation` text DEFAULT NULL,
  `passenger_type` varchar(255) DEFAULT NULL,
  `passenger_group_leader_ci` text DEFAULT NULL,
  `img_cmp_1` varchar(255) DEFAULT NULL,
  `img_cmp_2` varchar(255) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `state_passenger` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `passenger_list_monthly_tours`
--

CREATE TABLE `passenger_list_monthly_tours` (
  `passenger_list_monthly_tours` bigint(20) UNSIGNED NOT NULL,
  `list_id` int(11) NOT NULL,
  `monthly_tour_id` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

--
-- Estructura de tabla para la tabla `products`
--

CREATE TABLE `products` (
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `description` text DEFAULT NULL,
  `buying_price` double(8,2) DEFAULT NULL,
  `min_selling_price` double(8,2) DEFAULT NULL,
  `selling_price` double(8,2) DEFAULT NULL,
  `rent_price` double(8,2) DEFAULT NULL,
  `entry_date` date DEFAULT NULL,
  `img` text DEFAULT NULL,
  `observation` text DEFAULT 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 `products`
--

INSERT INTO `products` (`product_id`, `category_id`, `supplier_id`, `description`, `buying_price`, `min_selling_price`, `selling_price`, `rent_price`, `entry_date`, `img`, `observation`, `created_at`, `updated_at`) VALUES
(1, 13, 9, 'AGUA ARDIENTE', 0.55, 1.00, 1.00, 1.00, '2024-04-07', NULL, NULL, '2024-04-07 19:42:31', NULL),
(2, 13, 20, 'PILSENER DE LITRO', 2.15, 2.25, 2.25, 2.25, '2024-04-07', NULL, NULL, '2024-04-07 19:51:43', NULL);

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

--
-- Estructura de tabla para la tabla `product_warehouses`
--

CREATE TABLE `product_warehouses` (
  `product_warehouses_id` bigint(20) UNSIGNED NOT NULL,
  `inventories_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `product_status_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `observation` text DEFAULT 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 `product_warehouses`
--

INSERT INTO `product_warehouses` (`product_warehouses_id`, `inventories_id`, `product_id`, `product_status_id`, `warehouse_id`, `quantity`, `observation`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, 1, 15, NULL, '2024-04-07 19:55:11', '2024-04-07 19:55:11');

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

--
-- Estructura de tabla para la tabla `produts_list_warehouses`
--

CREATE TABLE `produts_list_warehouses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `request_complete_products`
--

CREATE TABLE `request_complete_products` (
  `request_complete_products_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `detail` varchar(255) NOT NULL,
  `fecha` date NOT NULL,
  `status_request` text DEFAULT NULL,
  `status_acquisition` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `request_products_to_warehouses`
--

CREATE TABLE `request_products_to_warehouses` (
  `request_products_to_warehouses_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `quantity_products` int(11) NOT NULL,
  `request_complete_products_id` int(11) NOT NULL,
  `product_warehouses_id` int(11) NOT NULL,
  `status` text DEFAULT NULL,
  `unit_price` double(8,2) DEFAULT NULL,
  `total_price` double(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `sales_products`
--

CREATE TABLE `sales_products` (
  `sales_products_id` bigint(20) UNSIGNED NOT NULL,
  `passengers_ci` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_warehouse_id` int(11) DEFAULT NULL,
  `quantity_prod` int(11) DEFAULT NULL,
  `status_sales_products` text DEFAULT NULL,
  `sale_type` text DEFAULT NULL,
  `description_sale_free` text DEFAULT NULL,
  `price_sale_free` text DEFAULT NULL,
  `secuential_bill_id` int(11) DEFAULT NULL,
  `sale_date` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `secuential_bills`
--

CREATE TABLE `secuential_bills` (
  `secuential_bill_id` bigint(20) UNSIGNED NOT NULL,
  `description` text DEFAULT 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 `secuential_bills`
--

INSERT INTO `secuential_bills` (`secuential_bill_id`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Fact 1', '2024-08-03 22:05:42', '2024-08-03 22:05:42'),
(2, 'Fact 2', '2024-08-03 22:05:42', '2024-08-03 22:05:42');

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

--
-- Estructura de tabla para la tabla `software_tipes`
--

CREATE TABLE `software_tipes` (
  `software_type_id` bigint(20) UNSIGNED NOT NULL,
  `description` varchar(255) 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 `software_tipes`
--

INSERT INTO `software_tipes` (`software_type_id`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Full', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(2, 'Inventario', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(3, 'Demo', '2024-08-04 01:46:46', '2024-08-04 01:46:46');

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

--
-- Estructura de tabla para la tabla `statuses`
--

CREATE TABLE `statuses` (
  `status_id` bigint(20) UNSIGNED NOT NULL,
  `description` text NOT NULL,
  `category_status` text DEFAULT 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 `statuses`
--

INSERT INTO `statuses` (`status_id`, `description`, `category_status`, `created_at`, `updated_at`) VALUES
(1, 'Nuevo', 'Productos', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(2, 'Bueno', 'Productos', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(3, 'Regular', 'Productos', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(4, 'Malo Funcional', 'Productos', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(5, 'Malo No funcional', 'Productos', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(6, 'No paga nada', 'Pagos de Pasajeros', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(7, 'Pagado Todo', 'Pagos de Pasajeros', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(8, 'Pago Parcial', 'Pagos de Pasajeros', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(9, 'No Aplica - Acompañante', 'Pagos de Pasajeros', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(10, 'No pagado', 'Creditos', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(11, 'Pagado', 'Creditos', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(12, 'Vencido', 'Creditos', '2024-08-04 01:46:46', '2024-08-04 01:46:46');

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

--
-- Estructura de tabla para la tabla `suppliers`
--

CREATE TABLE `suppliers` (
  `suppliers_id` bigint(20) UNSIGNED NOT NULL,
  `name_store` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `owner` text DEFAULT 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 `suppliers`
--

INSERT INTO `suppliers` (`suppliers_id`, `name_store`, `phone`, `address`, `owner`, `created_at`, `updated_at`) VALUES
(1, 'Desconocido', '0963124578', 'Riobamba - Guayaquil y 5 de junio', 'Mayor', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(2, 'Dicosavi', '0999', 'LA Merced', 'Santillas', '2024-04-07 19:05:43', '2024-04-07 19:05:43'),
(4, 'AHIES', '0999', 'LA CONDAMINES', 'Santillas MARCO ANTONIO', '2024-04-07 19:08:46', '2024-04-07 19:08:46'),
(5, 'ONMILIFE', '593384308', 'MEXICO', 'AMAURI VERGARA', '2024-04-07 19:10:17', '2024-04-07 19:10:17'),
(7, 'Martha Colas', '593384308', 'la condamine', 'Martha Colas', '2024-04-07 19:12:30', '2024-04-07 19:12:30'),
(8, 'molinos Anita', '099999', 'Santa Rosa', 'Anita', '2024-04-07 19:18:57', '2024-04-07 19:18:57'),
(9, 'Agua Ardiente', '099999', 'Santa Rosa', 'joven agua ardiente', '2024-04-07 19:22:23', '2024-04-07 19:22:23'),
(10, 'Procan', '0989716660', 'Riobamba', 'Anderson Perez', '2024-04-07 19:24:36', '2024-04-07 19:24:36'),
(12, 'Helados topsy', '0999999', 'Riobamba', 'Gualberto', '2024-04-07 19:26:07', '2024-04-07 19:26:07'),
(13, 'Minerva', '0999999', 'Riobamba', 'Minerva', '2024-04-07 19:28:30', '2024-04-07 19:28:30'),
(15, 'Velas concepcion', '0999999', 'Riobamba', 'velas concepción', '2024-04-07 19:30:51', '2024-04-07 19:30:51'),
(16, 'Panadería Britany', '0999999', 'Riobamba', 'Sr, CECIÑÑI', '2024-04-07 19:32:35', '2024-04-07 19:32:35'),
(19, 'Mi negocio efectivo', '0933333', 'Riobamba', 'Sr, CECILIO', '2024-04-07 19:35:23', '2024-04-07 19:35:23'),
(20, 'BEES', '09999', 'RIOBAMBA', 'PILSEMER', '2024-04-07 19:46:44', '2024-04-07 19:46:44');

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

--
-- Estructura de tabla para la tabla `total_account_sales`
--

CREATE TABLE `total_account_sales` (
  `total_account_sales_id` bigint(20) UNSIGNED NOT NULL,
  `secuential_bill_id` int(11) NOT NULL,
  `total_price` double(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `tour_catalogues`
--

CREATE TABLE `tour_catalogues` (
  `tour_catalogues_id` bigint(20) UNSIGNED NOT NULL,
  `tour_name` varchar(255) NOT NULL,
  `tour_destiny` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `include` text NOT NULL,
  `cost_1` double(8,2) NOT NULL,
  `cost_2` double(8,2) NOT NULL,
  `cost_3` double(8,2) NOT NULL,
  `cost_4` double(8,2) NOT NULL,
  `img_1` varchar(255) NOT NULL,
  `img_2` varchar(255) NOT NULL,
  `state` tinyint(1) NOT NULL,
  `type` varchar(255) NOT NULL,
  `dificulty` varchar(255) NOT NULL,
  `discount` double(8,2) NOT NULL,
  `discount_description` varchar(255) NOT NULL,
  `contact_phone` varchar(255) NOT NULL,
  `messagge_for_contact` varchar(255) NOT NULL,
  `varchar_1` varchar(255) DEFAULT NULL,
  `varchar_2` varchar(255) DEFAULT NULL,
  `varchar_3` varchar(255) DEFAULT NULL,
  `last_user` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `external_id` varchar(255) DEFAULT NULL,
  `external_auth` varchar(255) DEFAULT NULL,
  `ci` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `cellphone` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `rol` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT 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 `users`
--

INSERT INTO `users` (`id`, `external_id`, `external_auth`, `ci`, `name`, `last_name`, `country`, `city`, `cellphone`, `img`, `rol`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, NULL, NULL, NULL, 'Administrador', 'Sistema', NULL, NULL, NULL, NULL, 'admin', 'adminsistema@gmail.com', NULL, '$2y$10$719RZarJpXQnloYsMOKmWO0gqN7oIvjabXbSUUYcU3Kfhwpp2uyUu', NULL, '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(2, NULL, NULL, NULL, 'Darío', 'Janeta', NULL, NULL, NULL, NULL, 'guide', 'dariojaneta@gmail.com', NULL, '$2y$10$yLL5kTAd4voM39c9RNGbKeGlGxx1yOlt3EDbjUc5cE0kTBRFtgm9G', NULL, '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(3, NULL, NULL, NULL, 'María', 'Paca', NULL, NULL, NULL, NULL, 'shopkeeper', 'mariapaca@gmail.com', NULL, '$2y$10$CamN2GByhJPsId6vS8JnfuuCbBSr0meMjpcWLc5c3Pv1Tbn4KkkPa', NULL, '2024-08-04 01:46:46', '2024-08-04 01:46:46');

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

--
-- Estructura de tabla para la tabla `warehouses`
--

CREATE TABLE `warehouses` (
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `description` text DEFAULT NULL,
  `address` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `observation` text DEFAULT 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 `warehouses`
--

INSERT INTO `warehouses` (`warehouse_id`, `description`, `address`, `phone`, `observation`, `created_at`, `updated_at`) VALUES
(1, 'Almacenamiento Paquita', 'TIenda', '0995300403', 'Aquí están las cosas para vender', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(2, 'Bodega Almacenamiento 1', 'Tierra Nueva', '0961119670', '', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(3, 'Bodega Almacenamiento 2', 'Mercado la esperanza', '0997159098', '', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(4, 'Bodega Almacenamiento 3', 'Complejo la Panadería', '0993786135', 'Bodega casa Luchin', '2024-08-04 01:46:46', '2024-08-04 01:46:46'),
(5, 'Paquita Bodega 2', 'Redondel del Libro', '0995300403', 'Mamá Darío - María Paca', '2024-08-04 01:46:46', '2024-08-04 01:46:46');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `bank_accounts`
--
ALTER TABLE `bank_accounts`
  ADD PRIMARY KEY (`bank_accounts_id`);

--
-- Indices de la tabla `bank_accounts_tours`
--
ALTER TABLE `bank_accounts_tours`
  ADD PRIMARY KEY (`bank_account_tour_id`);

--
-- Indices de la tabla `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`categories_id`);

--
-- Indices de la tabla `credits`
--
ALTER TABLE `credits`
  ADD PRIMARY KEY (`credit_id`);

--
-- Indices de la tabla `enterprises`
--
ALTER TABLE `enterprises`
  ADD PRIMARY KEY (`enterprise_id`);

--
-- Indices de la tabla `equipment`
--
ALTER TABLE `equipment`
  ADD PRIMARY KEY (`equipment_id`);

--
-- Indices de la tabla `equipment_rents`
--
ALTER TABLE `equipment_rents`
  ADD PRIMARY KEY (`equipment_rent_id`);

--
-- Indices de la tabla `expenses_tours`
--
ALTER TABLE `expenses_tours`
  ADD PRIMARY KEY (`expense_tour_id`);

--
-- Indices de la tabla `exposition_tours`
--
ALTER TABLE `exposition_tours`
  ADD PRIMARY KEY (`exposition_tour_id`);

--
-- Indices de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indices de la tabla `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`gallery_id`);

--
-- Indices de la tabla `incomes_tours`
--
ALTER TABLE `incomes_tours`
  ADD PRIMARY KEY (`income_tour_id`);

--
-- Indices de la tabla `inventories`
--
ALTER TABLE `inventories`
  ADD PRIMARY KEY (`inventories_id`);

--
-- Indices de la tabla `listas`
--
ALTER TABLE `listas`
  ADD PRIMARY KEY (`list_id`);

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

--
-- Indices de la tabla `monthly_tours`
--
ALTER TABLE `monthly_tours`
  ADD PRIMARY KEY (`monthly_tour_id`);

--
-- Indices de la tabla `monthly_tours_users`
--
ALTER TABLE `monthly_tours_users`
  ADD PRIMARY KEY (`monthly_tour_user_id`);

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

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

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

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

--
-- Indices de la tabla `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

--
-- Indices de la tabla `passengers`
--
ALTER TABLE `passengers`
  ADD PRIMARY KEY (`passenger_id`),
  ADD UNIQUE KEY `passengers_ci_unique` (`ci`) USING HASH;

--
-- Indices de la tabla `passenger_lists`
--
ALTER TABLE `passenger_lists`
  ADD PRIMARY KEY (`passenger_lists_id`);

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

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

--
-- Indices de la tabla `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`product_id`);

--
-- Indices de la tabla `product_warehouses`
--
ALTER TABLE `product_warehouses`
  ADD PRIMARY KEY (`product_warehouses_id`);

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

--
-- Indices de la tabla `request_complete_products`
--
ALTER TABLE `request_complete_products`
  ADD PRIMARY KEY (`request_complete_products_id`);

--
-- Indices de la tabla `request_products_to_warehouses`
--
ALTER TABLE `request_products_to_warehouses`
  ADD PRIMARY KEY (`request_products_to_warehouses_id`);

--
-- Indices de la tabla `sales_products`
--
ALTER TABLE `sales_products`
  ADD PRIMARY KEY (`sales_products_id`);

--
-- Indices de la tabla `secuential_bills`
--
ALTER TABLE `secuential_bills`
  ADD PRIMARY KEY (`secuential_bill_id`);

--
-- Indices de la tabla `software_tipes`
--
ALTER TABLE `software_tipes`
  ADD PRIMARY KEY (`software_type_id`);

--
-- Indices de la tabla `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`status_id`);

--
-- Indices de la tabla `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`suppliers_id`);

--
-- Indices de la tabla `total_account_sales`
--
ALTER TABLE `total_account_sales`
  ADD PRIMARY KEY (`total_account_sales_id`);

--
-- Indices de la tabla `tour_catalogues`
--
ALTER TABLE `tour_catalogues`
  ADD PRIMARY KEY (`tour_catalogues_id`);

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

--
-- Indices de la tabla `warehouses`
--
ALTER TABLE `warehouses`
  ADD PRIMARY KEY (`warehouse_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `bank_accounts`
--
ALTER TABLE `bank_accounts`
  MODIFY `bank_accounts_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `bank_accounts_tours`
--
ALTER TABLE `bank_accounts_tours`
  MODIFY `bank_account_tour_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `categories`
--
ALTER TABLE `categories`
  MODIFY `categories_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT de la tabla `credits`
--
ALTER TABLE `credits`
  MODIFY `credit_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `enterprises`
--
ALTER TABLE `enterprises`
  MODIFY `enterprise_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `equipment`
--
ALTER TABLE `equipment`
  MODIFY `equipment_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `equipment_rents`
--
ALTER TABLE `equipment_rents`
  MODIFY `equipment_rent_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `expenses_tours`
--
ALTER TABLE `expenses_tours`
  MODIFY `expense_tour_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `exposition_tours`
--
ALTER TABLE `exposition_tours`
  MODIFY `exposition_tour_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `galleries`
--
ALTER TABLE `galleries`
  MODIFY `gallery_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `incomes_tours`
--
ALTER TABLE `incomes_tours`
  MODIFY `income_tour_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `inventories`
--
ALTER TABLE `inventories`
  MODIFY `inventories_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `listas`
--
ALTER TABLE `listas`
  MODIFY `list_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;

--
-- AUTO_INCREMENT de la tabla `monthly_tours`
--
ALTER TABLE `monthly_tours`
  MODIFY `monthly_tour_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `monthly_tours_users`
--
ALTER TABLE `monthly_tours_users`
  MODIFY `monthly_tour_user_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `passengers`
--
ALTER TABLE `passengers`
  MODIFY `passenger_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `passenger_lists`
--
ALTER TABLE `passenger_lists`
  MODIFY `passenger_lists_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `passenger_list_monthly_tours`
--
ALTER TABLE `passenger_list_monthly_tours`
  MODIFY `passenger_list_monthly_tours` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `products`
--
ALTER TABLE `products`
  MODIFY `product_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `product_warehouses`
--
ALTER TABLE `product_warehouses`
  MODIFY `product_warehouses_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `produts_list_warehouses`
--
ALTER TABLE `produts_list_warehouses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `request_complete_products`
--
ALTER TABLE `request_complete_products`
  MODIFY `request_complete_products_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `request_products_to_warehouses`
--
ALTER TABLE `request_products_to_warehouses`
  MODIFY `request_products_to_warehouses_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `sales_products`
--
ALTER TABLE `sales_products`
  MODIFY `sales_products_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `secuential_bills`
--
ALTER TABLE `secuential_bills`
  MODIFY `secuential_bill_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `software_tipes`
--
ALTER TABLE `software_tipes`
  MODIFY `software_type_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `statuses`
--
ALTER TABLE `statuses`
  MODIFY `status_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT de la tabla `suppliers`
--
ALTER TABLE `suppliers`
  MODIFY `suppliers_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT de la tabla `total_account_sales`
--
ALTER TABLE `total_account_sales`
  MODIFY `total_account_sales_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tour_catalogues`
--
ALTER TABLE `tour_catalogues`
  MODIFY `tour_catalogues_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `warehouses`
--
ALTER TABLE `warehouses`
  MODIFY `warehouse_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
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 */;