-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 06-10-2018 a las 01:52:01
-- Versión del servidor: 10.1.31-MariaDB
-- Versión de PHP: 7.2.3

START TRANSACTION;



--
-- Base de datos: `db_directorio`
--

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

--
-- Estructura de tabla para la tabla `categorias`
--

CREATE TABLE `categorias` (
  `id` int(10) UNSIGNED NOT NULL,
  `cat_nombre` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cat_imagen` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cat_slug` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cat_estado` enum('ACTIVO','INACTIVO') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVO',
  `cat_tipo` enum('EMPRESA','PROFESIONAL') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMPRESA',
  `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 `categorias`
--

INSERT INTO `categorias` (`id`, `cat_nombre`, `cat_imagen`, `cat_slug`, `cat_estado`, `cat_tipo`, `created_at`, `updated_at`) VALUES
(1, 'Restaurantes', 'cat1.jpg', 'restaurantes', 'ACTIVO', 'EMPRESA', '2018-10-05 00:16:55', '2018-10-05 00:16:55'),
(2, 'Electricistas', 'cat2.jpg', 'electricistas', 'ACTIVO', 'PROFESIONAL', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(3, 'Centros Comerciales', 'cat3.jpg', 'centros-comerciales', 'ACTIVO', 'EMPRESA', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(4, 'Ingenieros', 'cat4.jpg', 'ingenieros', 'ACTIVO', 'PROFESIONAL', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(5, 'Moda', 'cat5.jpg', 'moda', 'ACTIVO', 'EMPRESA', '2018-10-05 00:16:56', '2018-10-05 00:16:56');

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

--
-- Estructura de tabla para la tabla `clientes`
--

CREATE TABLE `clientes` (
  `id` int(10) UNSIGNED NOT NULL,
  `categoria_id` int(10) UNSIGNED NOT NULL,
  `cli_tipo_id` int(10) UNSIGNED NOT NULL,
  `cli_nombre` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cli_telefono` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cli_direccion` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cli_correo` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cli_descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cli_pagina_web` varchar(190) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cli_ubicacion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cli_slug` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cli_logo` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cli_visualizacion` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `cli_estado` enum('ACTIVO','INACTIVO') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVO',
  `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 `clientes`
--

INSERT INTO `clientes` (`id`, `categoria_id`, `cli_tipo_id`, `cli_nombre`, `cli_telefono`, `cli_direccion`, `cli_correo`, `cli_descripcion`, `cli_pagina_web`, `cli_ubicacion`, `cli_slug`, `cli_logo`, `cli_visualizacion`, `cli_estado`, `created_at`, `updated_at`) VALUES
(1, 4, 1, 'Jast-Koepp', '+3024896164762', '2994 Alycia Common', 'richmond95@example.org', 'Ut qui est quaerat qui voluptas. Qui a ut quo quis harum.', 'https://www.konopelski.com/aut-est-perspiciatis-incidunt', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'jast-koepp', '18.jpg', 0, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(2, 2, 1, 'Grady, Douglas and Wehner', '+8728846877424', '911 Elody Bypass Apt. 752', 'welch.cruz@example.com', 'Est quae voluptates ipsum tempora ipsum voluptas. Quod est et praesentium in est et. Temporibus est perferendis id nemo. Ut dolores qui iste quia enim.', 'http://www.turcotte.com/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'grady-douglas-and-wehner', '9.jpg', 0, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(3, 5, 1, 'Hermiston Ltd', '+8888389665941', '670 Hunter Flat', 'dooley.zoie@example.org', 'Saepe voluptatem vel qui est maxime et. Repellat quo perspiciatis tempore eum ea nisi et inventore. Qui molestiae et accusantium ut. Nisi odit excepturi sint sunt.', 'http://www.hill.com/minus-hic-et-aliquam-mollitia-qui-qui-aut-eum.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'hermiston-ltd', '6.jpg', 1, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:23:10'),
(4, 1, 1, 'Herzog-Hammes', '+5395440171690', '71469 Braulio Rapid Apt. 346', 'lacey72@example.net', 'Facere voluptatem suscipit magnam quod. Voluptates ab odit a libero. Repudiandae dolor aspernatur consectetur sint ipsam laborum ipsum.', 'http://von.net/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'herzog-hammes', '8.jpg', 3, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-06 01:04:47'),
(5, 4, 1, 'Gerhold-Sporer', '+6823421310446', '74405 Purdy Cliffs', 'monserrate.friesen@example.com', 'Quia eligendi hic dolorum dolores nihil. Officia sit consequatur dicta minima totam. Consectetur sit ut non iure harum eos.', 'https://pollich.com/tempore-quos-rerum-velit-amet-rerum-voluptatem-iusto.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'gerhold-sporer', '10.jpg', 0, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(6, 1, 1, 'Johnson-Watsica', '+5512739343492', '893 Astrid Overpass', 'rempel.garfield@example.com', 'Quasi quo aut repellat similique laborum beatae earum. Possimus illo illo atque voluptas. Occaecati ullam omnis soluta aspernatur natus sit nihil.', 'http://www.prosacco.info/minus-adipisci-possimus-reiciendis-dolore', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'johnson-watsica', '12.jpg', 0, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(7, 5, 2, 'O\'Conner, Bernhard and Batz', '+2554773643062', '918 Mabelle Walks', 'raegan90@example.com', 'Nisi qui officia odio ducimus. Eos inventore qui reprehenderit iusto. Optio sequi cumque commodi repellendus. At maxime eveniet sed.', 'http://www.hills.com/rem-voluptate-voluptatem-laborum-in-quod.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'oconner-bernhard-and-batz', '14.jpg', 1, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:41:20'),
(8, 1, 1, 'Bogisich Ltd', '+6726887027757', '9328 Lela Meadows Suite 717', 'ethan64@example.net', 'Consequatur architecto architecto vero dicta ullam dolor molestiae. Pariatur qui eum hic qui repudiandae eum. Dolorum amet expedita architecto illum qui placeat. Excepturi quasi quia nam vel est.', 'http://swaniawski.info/atque-quae-et-repellendus-magni-quia-alias-eius', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'bogisich-ltd', '18.jpg', 0, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(9, 4, 1, 'Rohan LLC', '+2534306391177', '80214 Destini Manors', 'schmitt.jazmyne@example.org', 'Nobis quas voluptatibus impedit vel aut est consectetur. Dignissimos ut nobis ex quibusdam molestiae est. Iste ut quis sapiente debitis. Dolores quia excepturi excepturi occaecati mollitia sapiente.', 'https://okuneva.com/dolore-error-aut-est-ratione.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'rohan-llc', '15.jpg', 0, 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(10, 3, 1, 'Larson Ltd', '+2813499068651', '8580 Dooley Mountain Suite 276', 'ztrantow@example.com', 'Ratione vel quaerat sit quia. Officiis veritatis eveniet et iste. Sint sint aut impedit perferendis. Quis accusantium pariatur praesentium temporibus in. Beatae est cupiditate dolorem eaque enim.', 'http://emmerich.com/provident-autem-perferendis-accusantium-aut-quia-quasi-voluptatibus-ut', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'larson-ltd', '6.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(11, 1, 1, 'Fadel LLC', '+5362552668072', '7727 O\'Reilly Lakes', 'rklocko@example.net', 'Itaque nisi doloribus rerum culpa repellendus dicta. Repellendus doloribus ducimus itaque in eaque aut.', 'https://www.roob.biz/voluptatem-reiciendis-totam-consequatur-occaecati', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'fadel-llc', '15.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(12, 4, 1, 'McClure, Connelly and Pouros', '+6168101907765', '992 Grady Forge Suite 161', 'ashlynn.hintz@example.org', 'Et quos ea nihil quaerat perspiciatis et eum. Itaque quia accusamus nesciunt et facilis vitae voluptatem. Tenetur inventore voluptas sit ipsam enim iure sequi.', 'http://bradtke.com/totam-dignissimos-rerum-ullam-autem-et-error.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'mcclure-connelly-and-pouros', '19.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(13, 4, 1, 'Schroeder, Wyman and Crona', '+5097095872482', '8832 Mittie Village Apt. 427', 'dlesch@example.com', 'Aut atque et aut expedita est mollitia tempore aut. Cupiditate error fugiat et nulla vel. Maiores in odio et ullam fugiat sed quia.', 'http://www.block.net/quibusdam-dolorem-ut-similique-veniam-quaerat-quia-dolore', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'schroeder-wyman-and-crona', '16.jpg', 1, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:23:19'),
(14, 1, 1, 'Raynor, Simonis and Nader', '+2531321159987', '235 Kobe Stravenue Apt. 985', 'ypfeffer@example.org', 'Laborum et cumque tempora non vel voluptas ab. Unde accusantium temporibus harum. Consequatur quam quos et explicabo alias et voluptas vel.', 'https://www.wolf.com/dolorum-veniam-aut-harum-in-est-esse-vel', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'raynor-simonis-and-nader', '10.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(15, 5, 1, 'Erdman and Sons', '+4308751307551', '16110 Thiel Glens Apt. 189', 'beier.jessica@example.org', 'Quidem dolorum fuga accusamus natus. Nesciunt et molestias provident est aspernatur debitis nam. Reprehenderit molestiae vel sunt aliquam asperiores. Possimus dolorum totam mollitia quae ut.', 'http://weber.com/nobis-et-tempore-ea-nihil-excepturi-iusto-illo-in.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'erdman-and-sons', '17.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(16, 5, 1, 'Pollich-Senger', '+4317840248451', '867 Justice Coves Apt. 326', 'khauck@example.net', 'Ipsam facilis voluptas labore omnis eaque odit accusantium. Fugiat corporis ullam dolorem quo magni veritatis tempore. Qui non est velit architecto.', 'http://www.mcglynn.com/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'pollich-senger', '12.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(17, 3, 2, 'Dach-O\'Hara', '+8639467076346', '69945 Cordell Neck', 'bernhard.chasity@example.com', 'Architecto officiis aut incidunt iure occaecati eius consequatur quis. Eos voluptatem corrupti quas pariatur voluptatem. Quo sint et magnam rem a inventore quam. Dolorem impedit et eum.', 'https://nitzsche.com/error-dolores-maiores-facere-quidem-reiciendis-ut.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'dach-ohara', '6.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(18, 5, 1, 'Rath PLC', '+5966120444770', '4837 Kuhic Plain', 'maggio.ilene@example.org', 'Ea animi quidem quo veniam aliquam aut nemo nobis. Aut recusandae necessitatibus temporibus et molestias nihil. Est consectetur repellat ex voluptatem vel libero.', 'http://schultz.biz/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'rath-plc', '5.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(19, 4, 2, 'Casper, Torp and Steuber', '+3168280126819', '59094 Jarod Meadows Suite 499', 'bernier.emmet@example.net', 'Minima sed ab voluptates nobis. Error maiores quia aliquid accusamus vitae nemo tenetur. Fugit sed quaerat illum qui cumque. Quos voluptate in autem. Quibusdam ea illum aliquam iusto.', 'http://herzog.com/placeat-magni-maxime-aperiam-sunt', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'casper-torp-and-steuber', '11.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(20, 3, 1, 'Bogan Group', '+4593443779630', '6133 Frami Via', 'iwitting@example.net', 'Odio minus iste et rem. Numquam omnis in sequi eveniet. Libero molestiae est perspiciatis placeat porro quia et nihil.', 'http://www.hills.com/voluptatem-et-rem-voluptatem-ab-recusandae-possimus-quis-eveniet', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'bogan-group', '14.jpg', 1, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-06 00:18:11'),
(21, 3, 1, 'Nienow and Sons', '+3930466608351', '786 Edison Path Apt. 762', 'gstiedemann@example.com', 'Consequatur autem rerum laboriosam sint. Omnis qui expedita quas architecto beatae autem. Ea eos et odit quia autem nisi.', 'http://www.lesch.biz/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'nienow-and-sons', '3.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(22, 4, 2, 'Stiedemann PLC', '+1643218572084', '427 Candelario Loop Suite 868', 'rheathcote@example.org', 'Qui voluptatibus qui eaque nam. Ipsum dolor debitis dolore tempora fugit vel similique. Dolorem est voluptatum facilis sapiente. Iure accusamus quaerat fugiat voluptatem vel nobis aut.', 'http://hahn.com/et-eum-sint-explicabo-est-perferendis-ut-et-et', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'stiedemann-plc', '14.jpg', 1, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:35:18'),
(23, 1, 1, 'Hauck, Funk and Daugherty', '+3427816402708', '25289 Ali Ways', 'connor.watsica@example.net', 'Autem nihil autem ea corporis. Nesciunt dolor illo eveniet in optio quo. Quas eligendi qui similique placeat delectus iure iure. Tempore et sit ea nobis.', 'http://pouros.com/fuga-delectus-perspiciatis-placeat-atque-ut-voluptatum', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'hauck-funk-and-daugherty', '5.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(24, 1, 1, 'Torp LLC', '+1452493496203', '2063 Kira Plaza Suite 069', 'julie78@example.org', 'Repudiandae ut aliquam sed optio sed hic vitae. Sunt mollitia omnis officia incidunt. Assumenda repellendus possimus itaque ipsum.', 'http://www.steuber.com/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'torp-llc', '4.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(25, 3, 1, 'Schumm, Jaskolski and Jakubowski', '+4765278857153', '603 Cleveland Camp', 'lupe.braun@example.net', 'Commodi praesentium vero minima molestiae est. Iure omnis provident unde impedit. Animi voluptatem consequuntur quis consectetur quae quia.', 'http://www.sauer.com/quis-ducimus-autem-vel.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'schumm-jaskolski-and-jakubowski', '11.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(26, 4, 1, 'Donnelly-Olson', '+5976155092950', '1456 McDermott Walk Suite 119', 'mthompson@example.com', 'Ipsa voluptates et et ducimus accusantium. Nobis error recusandae velit. Dolor aspernatur qui pariatur veniam.', 'https://www.wilderman.net/dolores-vero-ut-non-magni-et-assumenda-quis', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'donnelly-olson', '3.jpg', 1, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:22:24'),
(27, 4, 1, 'Hammes, Herzog and Rohan', '+1052543538402', '5454 Fahey Creek Apt. 776', 'maia.gorczany@example.net', 'Qui tenetur ut fuga alias aut expedita illo. Aut tenetur sed labore nesciunt quia et. Natus temporibus modi molestias.', 'http://mante.org/officia-suscipit-eum-maxime-rerum.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'hammes-herzog-and-rohan', '19.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(28, 2, 1, 'Hudson-Gutmann', '+6415869165959', '17331 Moshe Trail Suite 271', 'ehirthe@example.org', 'Aut harum iste consequatur voluptatem aut doloribus inventore. Recusandae nesciunt sit voluptas quos. Ipsam qui quo saepe eaque sit. Officiis et qui quod facere dicta natus.', 'http://www.frami.com/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'hudson-gutmann', '12.jpg', 10, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-06 01:04:22'),
(29, 2, 1, 'Rowe-Ziemann', '+4925353618435', '53589 Hortense Vista Apt. 724', 'lakin.corine@example.org', 'Tenetur in vero in nostrum consectetur. Maxime modi dolor placeat aut consequatur est mollitia. Voluptatum expedita sit sit eligendi qui iusto.', 'http://www.mcclure.com/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'rowe-ziemann', '6.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(30, 3, 2, 'Farrell, Hettinger and Collins', '+4035656968124', '180 Erdman Loaf', 'evalyn.murray@example.com', 'Eligendi quo itaque voluptatibus accusamus soluta occaecati. Quis quasi ea enim quia illum fugiat. Error cupiditate vel tempore asperiores dolore quia.', 'http://www.crist.biz/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'farrell-hettinger-and-collins', '18.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(31, 2, 1, 'Stehr-Hegmann', '+2748718712035', '3405 Wehner Point Suite 519', 'keven.lindgren@example.org', 'Inventore architecto sit voluptates rerum sequi quo dignissimos aut. Labore possimus est illum dolorem.', 'http://www.corwin.com/', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'stehr-hegmann', '19.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(32, 3, 1, 'McLaughlin, Wiegand and Rice', '+6829934621765', '82395 Ed Trafficway', 'ecrooks@example.net', 'Aperiam eius nemo aspernatur. Odio modi sint ipsam nobis. Doloribus ex illo consequuntur qui. Odio ducimus necessitatibus alias animi totam ad.', 'http://www.langosh.com/aut-quisquam-quo-maxime-et-sit-et-dicta', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'mclaughlin-wiegand-and-rice', '15.jpg', 1, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-06 02:56:02'),
(33, 4, 1, 'Heaney, Lindgren and Wisoky', '+9199947299682', '1804 Cassin Valleys Suite 194', 'spinka.santa@example.org', 'Quibusdam et vel qui quo fugiat corporis. Error ipsum facere quas beatae porro eos similique. Molestias esse odio nostrum asperiores aut praesentium. Error aut explicabo harum corporis.', 'https://mills.com/alias-qui-est-tempore-quia-autem-mollitia.html', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'heaney-lindgren-and-wisoky', '1.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(34, 4, 1, 'Swaniawski-Toy', '+7249461386043', '79348 Ferry Village Apt. 298', 'vdavis@example.com', 'Omnis saepe quisquam et est. Voluptas et eveniet similique ut quia ratione. Consectetur ab natus nesciunt deserunt velit maxime non. Mollitia laborum sit eius blanditiis.', 'http://smith.com/ut-eius-temporibus-laboriosam-culpa', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'swaniawski-toy', '12.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(35, 5, 2, 'Adams LLC', '+8968042024534', '90213 Armstrong Route Apt. 246', 'robbie.huels@example.org', 'Ad architecto at laudantium occaecati nemo quo nobis fugiat. Et delectus magni ad dolorem. Possimus sint ut animi. Voluptas quia asperiores sit est ipsa saepe.', 'http://www.jenkins.com/in-officia-quo-iste-perferendis-ipsa', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d987.1692000730718!2d-73.35388364349866!3d8.23521865397664!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xbe39d0470d3e62f8!2ssomosocana.com!5e0!3m2!1ses-419!2sco!4v1538769460038', 'adams-llc', '10.jpg', 0, 'ACTIVO', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(36, 3, 1, 'Exito', '365891482', '86719 Ortiz Road Suite 4171', 'tianna.torp@example.net', 'almacenes Exito', 'www.paajn.comsdfgsdfg', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d698.0371141336836!2d-73.35422186851851!3d8.233472489971648!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x8e677beea6429c2f%3A0x66353d2baef58322!2sCafeter%C3%ADa+TIMANA!5e0!3m2!1ses-419!2sco', 'exito', '1538772938.jpg', 0, 'ACTIVO', '2018-10-06 01:55:38', '2018-10-06 01:55:38');

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

--
-- Estructura de tabla para la tabla `cliente_tipo`
--

CREATE TABLE `cliente_tipo` (
  `id` int(10) UNSIGNED NOT NULL,
  `cli_tipo_nombre` varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cli_tipo_estado` enum('ACTIVO','INACTIVO') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVO',
  `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 `cliente_tipo`
--

INSERT INTO `cliente_tipo` (`id`, `cli_tipo_nombre`, `cli_tipo_estado`, `created_at`, `updated_at`) VALUES
(1, 'Estandar', 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56'),
(2, 'Patrocinador', 'ACTIVO', '2018-10-05 00:16:56', '2018-10-05 00:16:56');

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

--
-- Estructura de tabla para la tabla `imagen`
--

CREATE TABLE `imagen` (
  `id` int(10) UNSIGNED NOT NULL,
  `cliente_id` int(10) UNSIGNED NOT NULL,
  `ima_url` varchar(190) 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 `imagen`
--

INSERT INTO `imagen` (`id`, `cliente_id`, `ima_url`, `created_at`, `updated_at`) VALUES
(1, 31, '15.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(2, 29, '16.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(3, 4, '13.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(4, 34, '14.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(5, 5, '9.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(6, 17, '10.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(7, 30, '13.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(8, 4, '9.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(9, 35, '5.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(10, 35, '14.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(11, 34, '19.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(12, 30, '13.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(13, 8, '5.jpg', '2018-10-05 00:16:57', '2018-10-05 00:16:57'),
(14, 22, '12.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(15, 11, '17.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(16, 3, '7.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(17, 20, '12.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(18, 10, '8.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(19, 25, '17.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(20, 12, '18.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(21, 23, '2.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(22, 8, '4.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(23, 32, '5.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(24, 15, '16.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(25, 7, '7.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(26, 3, '11.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(27, 16, '5.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(28, 35, '10.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(29, 17, '7.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(30, 4, '9.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(31, 4, '18.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(32, 15, '7.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(33, 8, '3.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(34, 32, '14.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(35, 20, '7.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(36, 22, '1.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(37, 32, '19.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(38, 21, '8.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(39, 8, '10.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(40, 32, '9.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(41, 3, '17.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(42, 30, '4.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(43, 18, '1.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(44, 5, '16.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(45, 5, '19.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(46, 7, '14.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(47, 5, '20.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(48, 32, '6.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(49, 14, '7.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(50, 31, '17.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(51, 25, '3.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(52, 7, '1.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(53, 4, '16.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(54, 7, '5.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(55, 30, '10.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(56, 3, '5.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(57, 7, '7.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(58, 8, '1.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(59, 21, '8.jpg', '2018-10-05 00:16:58', '2018-10-05 00:16:58'),
(60, 1, '14.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(61, 4, '6.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(62, 11, '20.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(63, 6, '1.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(64, 16, '13.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(65, 28, '18.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(66, 12, '8.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(67, 7, '20.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(68, 14, '10.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(69, 35, '18.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(70, 3, '15.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(71, 25, '16.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(72, 26, '1.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(73, 5, '5.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(74, 15, '14.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(75, 7, '15.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(76, 7, '17.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(77, 33, '14.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(78, 26, '2.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(79, 26, '3.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(80, 4, '9.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(81, 14, '12.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(82, 33, '8.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(83, 30, '9.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(84, 11, '1.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(85, 31, '9.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(86, 3, '18.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(87, 27, '11.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(88, 22, '16.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(89, 18, '20.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(90, 10, '4.jpg', '2018-10-05 00:16:59', '2018-10-05 00:16:59'),
(91, 36, '1538776604.jpg', '2018-10-06 02:56:44', '2018-10-06 02:56:44'),
(92, 36, '1538776606.jpg', '2018-10-06 02:56:46', '2018-10-06 02:56:46');

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

--
-- 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, '2018_08_28_235133_create_categorias_table', 1),
(4, '2018_08_28_235140_create_cliente_tipo_table', 1),
(5, '2018_08_28_235158_create_clientes_table', 1),
(6, '2018_08_28_235225_create_imagen_table', 1);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `categorias`
--
ALTER TABLE `categorias`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categorias_cat_slug_unique` (`cat_slug`);

--
-- Indices de la tabla `clientes`
--
ALTER TABLE `clientes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `clientes_cli_slug_unique` (`cli_slug`),
  ADD KEY `clientes_categoria_id_foreign` (`categoria_id`),
  ADD KEY `clientes_cli_tipo_id_foreign` (`cli_tipo_id`);

--
-- Indices de la tabla `cliente_tipo`
--
ALTER TABLE `cliente_tipo`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `cliente_tipo_cli_tipo_nombre_unique` (`cli_tipo_nombre`);

--
-- Indices de la tabla `imagen`
--
ALTER TABLE `imagen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `imagen_cliente_id_foreign` (`cliente_id`);

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

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

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

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

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

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

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `clientes`
--
ALTER TABLE `clientes`
  ADD CONSTRAINT `clientes_categoria_id_foreign` FOREIGN KEY (`categoria_id`) REFERENCES `categorias` (`id`),
  ADD CONSTRAINT `clientes_cli_tipo_id_foreign` FOREIGN KEY (`cli_tipo_id`) REFERENCES `cliente_tipo` (`id`);

--
-- Filtros para la tabla `imagen`
--
ALTER TABLE `imagen`
  ADD CONSTRAINT `imagen_cliente_id_foreign` FOREIGN KEY (`cliente_id`) REFERENCES `clientes` (`id`);
COMMIT;

