-- phpMyAdmin SQL Dump -- version 4.7.9 -- 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 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Base de datos: `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); -- -------------------------------------------------------- -- -- Estructura de tabla para la tabla `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(190) 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 `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(190) 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; -- -- Volcado de datos para la tabla `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Breiner Sanchez', 'breiner.sv@gmail.com', '$2y$10$hbKVNqYwU3C/EUi7DcktRefwY4u9nrAykAa9Uk7KgC9.fR.k/Vj66', NULL, '2018-10-06 01:05:18', '2018-10-06 01:05:18'); -- -- Í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`); -- -- Indices de la tabla `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`email`); -- -- 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 `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; -- -- AUTO_INCREMENT de la tabla `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- 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; /*!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 */;