-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 27-08-2024 a las 21:44:11
-- Versión del servidor: 10.4.32-MariaDB
-- Versión de PHP: 8.2.12

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: `planbasico`
--

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

--
-- Estructura de tabla para la tabla `academiatienda`
--

CREATE TABLE `academiatienda` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcourse` 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 `anuncios`
--

CREATE TABLE `anuncios` (
  `id` int(11) NOT NULL,
  `titulo` longtext DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `color` varchar(250) DEFAULT NULL,
  `inicio` date DEFAULT NULL,
  `vencimiento` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `archivos`
--

CREATE TABLE `archivos` (
  `id` int(10) UNSIGNED NOT NULL,
  `titulo` varchar(191) DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `archivo` longtext DEFAULT NULL,
  `imagen_muestra` text DEFAULT NULL,
  `pdf` text 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;

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

--
-- Estructura de tabla para la tabla `asignacioncupon`
--

CREATE TABLE `asignacioncupon` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcupon` int(11) DEFAULT NULL,
  `idcompra` int(11) DEFAULT NULL,
  `idpagocarrito` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 - sin usar  1 - usado compra sin aprobar  2 - cupon vencido',
  `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 `atributosfotos`
--

CREATE TABLE `atributosfotos` (
  `id` int(11) NOT NULL,
  `idproducto` int(11) NOT NULL,
  `foto` 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 `avatares`
--

CREATE TABLE `avatares` (
  `id` int(11) NOT NULL,
  `avatar` longtext DEFAULT NULL,
  `activo_mujer` varchar(300) DEFAULT NULL,
  `activo_hombre` varchar(300) DEFAULT NULL,
  `inactivo_mujer` varchar(300) DEFAULT NULL,
  `inactivo_hombre` varchar(300) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `avatares` (`id`, `avatar`, `activo_mujer`, `activo_hombre`, `inactivo_mujer`, `inactivo_hombre`, `created_at`, `updated_at`) VALUES
(1, '[{\"avatar\":\"avatar_1576185092.png\"},{\"avatar\":\"avatar_1576189159.png\"},{\"avatar\":\"avatar_1576189177.png\"},{\"avatar\":\"avatar_1576189187.png\"},{\"avatar\":\"avatar_1576189196.png\"},{\"avatar\":\"avatar_1576189203.png\"},{\"avatar\":\"avatar_1576189213.png\"},{\"avatar\":\"avatar_15762497471.png\"},{\"avatar\":\"avatar_15762497472.png\"},{\"avatar\":\"avatar_15762497473.png\"},{\"avatar\":\"avatar_15762497474.png\"},{\"avatar\":\"avatar_15763101171.png\"}]', 'avatar_1576189159.png', 'avatar_1576185092.png', 'avatar_1576189213.png', 'avatar_1576189203.png', '2022-06-23 23:09:59', '2020-10-16 18:18:08');

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

--
-- Estructura de tabla para la tabla `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `imagen` text DEFAULT NULL,
  `destacado` int(11) NOT NULL DEFAULT 0,
  `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 `banneracademia`
--

CREATE TABLE `banneracademia` (
  `id` int(11) NOT NULL,
  `imagen` 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 `binario`
--

CREATE TABLE `binario` (
  `id` int(11) NOT NULL,
  `binario` double DEFAULT NULL,
  `pata` varchar(250) DEFAULT NULL,
  `autobinario` int(11) DEFAULT NULL COMMENT '1 - automitico 0 - semiautomatico',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `bonosettings`
--

CREATE TABLE `bonosettings` (
  `id` int(11) NOT NULL,
  `nivel` int(11) DEFAULT NULL,
  `monto` decimal(65,5) NOT NULL DEFAULT 0.00000,
  `tipoporcentaje` int(11) DEFAULT NULL,
  `rango` int(11) DEFAULT NULL,
  `nombre` text DEFAULT NULL,
  `idproducto` int(11) DEFAULT NULL,
  `idcategoria` int(11) DEFAULT NULL,
  `porcentaje` decimal(65,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `calendarios`
--

CREATE TABLE `calendarios` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `titulo` text DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `color` text DEFAULT NULL,
  `inicio` datetime NOT NULL,
  `vence` datetime NOT NULL,
  `lugar` text DEFAULT NULL,
  `tipo` text DEFAULT NULL,
  `especifico` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `canjes`
--

CREATE TABLE `canjes` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `cantidad` double NOT NULL,
  `total` double DEFAULT NULL COMMENT 'total en pesos',
  `tipo` int(11) NOT NULL COMMENT '0 - puntos propios 1 - puntos grupales ',
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `capital`
--

CREATE TABLE `capital` (
  `id` int(11) NOT NULL,
  `nombre` text NOT NULL,
  `departa` int(11) DEFAULT NULL,
  `costo` double NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `carritos`
--

CREATE TABLE `carritos` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `producto` varchar(250) NOT NULL,
  `precio` decimal(65,2) NOT NULL,
  `idproducto` int(11) NOT NULL,
  `cantidad` int(11) NOT NULL,
  `total` decimal(65,2) NOT NULL,
  `iva` decimal(65,2) DEFAULT NULL,
  `ip` varchar(250) DEFAULT NULL,
  `referido` int(11) DEFAULT NULL,
  `info` decimal(65,2) DEFAULT NULL,
  `porcentaje` text DEFAULT NULL,
  `tienda` text DEFAULT NULL,
  `puntos` decimal(65,2) DEFAULT NULL,
  `descuento` decimal(65,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `categoria`
--

CREATE TABLE `categoria` (
  `id` int(11) NOT NULL,
  `titulo` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `categorias` (
  `id` int(11) NOT NULL,
  `titulo` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `categorias` (`id`, `titulo`, `created_at`, `updated_at`) VALUES
(1, 'prueba 5', '2023-05-13 15:04:44', '2023-05-13 15:04:48'),
(2, 'Noticias', '2023-05-13 15:07:23', '2023-05-13 15:07:23'),
(3, 'Tutoriales', '2023-05-13 15:07:37', '2023-05-13 15:07:37'),
(4, 'Entrenamientos', '2023-05-13 15:07:46', '2023-05-13 15:07:46'),
(5, 'Negocios', '2023-05-13 15:07:56', '2023-05-13 15:07:56'),
(6, 'Finanzas', '2023-05-13 15:08:06', '2023-05-13 15:08:06');

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

--
-- Estructura de tabla para la tabla `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `icon` text DEFAULT NULL,
  `cover` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `chats`
--

CREATE TABLE `chats` (
  `id` int(11) NOT NULL,
  `user_sent` int(11) DEFAULT NULL,
  `user_recive` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `codigo`
--

CREATE TABLE `codigo` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idpadre` int(11) NOT NULL,
  `idcompra` int(11) DEFAULT NULL,
  `codigo` text DEFAULT NULL,
  `pin` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `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 `colonias`
--

CREATE TABLE `colonias` (
  `id` int(11) NOT NULL,
  `nombre` varchar(100) NOT NULL DEFAULT '',
  `ciudad` varchar(50) DEFAULT NULL,
  `municipio` int(6) DEFAULT NULL,
  `asentamiento` varchar(25) DEFAULT NULL,
  `codigo_postal` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Estructura de tabla para la tabla `comentarioacademia`
--

CREATE TABLE `comentarioacademia` (
  `id` int(11) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `idcurso` int(11) DEFAULT NULL,
  `comentario` text DEFAULT NULL,
  `fecha` date 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 `comentarioacademia`
--

INSERT INTO `comentarioacademia` (`id`, `iduser`, `idcurso`, `comentario`, `fecha`, `created_at`, `updated_at`) VALUES
(4, 15, 34, 'Hola', '2024-03-25', '2024-03-25 16:01:01', '2024-03-25 16:01:01'),
(5, 4, 35, 'Excelente Curso', '2024-05-30', '2024-05-31 01:52:29', '2024-05-31 01:52:29');

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

--
-- Estructura de tabla para la tabla `comentarios`
--

CREATE TABLE `comentarios` (
  `id` int(10) UNSIGNED NOT NULL,
  `tickets_id` int(11) NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `comentario` longtext NOT NULL,
  `archivo` varchar(250) 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;

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

--
-- Estructura de tabla para la tabla `commissions`
--

CREATE TABLE `commissions` (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `compra_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `total` decimal(65,2) NOT NULL DEFAULT 0.00,
  `referred_email` text NOT NULL,
  `referred_level` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `edo_liquidacion` tinyint(1) NOT NULL DEFAULT 0,
  `concepto` text NOT NULL,
  `tipo_comision` text NOT NULL,
  `eliminada` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 - activa, 1 - eliminada',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `component`
--

CREATE TABLE `component` (
  `id` int(11) NOT NULL,
  `slider` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `compradirectas`
--

CREATE TABLE `compradirectas` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcompra` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `precio` double DEFAULT NULL,
  `referido_correo` varchar(250) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `configuracioninicio`
--

CREATE TABLE `configuracioninicio` (
  `id` int(11) NOT NULL,
  `tipo_bono` text DEFAULT NULL,
  `niveles` int(11) NOT NULL DEFAULT 0,
  `tipo_compra` text DEFAULT NULL,
  `tipo` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `configuracioninicio` (`id`, `tipo_bono`, `niveles`, `tipo_compra`, `tipo`, `created_at`, `updated_at`) VALUES
(1, NULL, 0, NULL, NULL, NULL, NULL);

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

--
-- Estructura de tabla para la tabla `consultacrypto`
--

CREATE TABLE `consultacrypto` (
  `id` int(11) NOT NULL,
  `idcompra` text DEFAULT NULL,
  `idconsulta` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `tipo` int(11) NOT NULL COMMENT '1 -coinpayments 2 - coinbase 3 - openpay 4 - conekta',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `contenidos`
--

CREATE TABLE `contenidos` (
  `id` int(10) UNSIGNED NOT NULL,
  `titulo` varchar(191) DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `imagen` longtext DEFAULT NULL,
  `idcategoria` int(11) 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;

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

--
-- Estructura de tabla para la tabla `costo`
--

CREATE TABLE `costo` (
  `id` int(11) NOT NULL,
  `iduser` text NOT NULL,
  `localidad` text NOT NULL,
  `idlocalidad` int(11) DEFAULT NULL,
  `provincia` text NOT NULL,
  `costo` double NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `courses`
--

CREATE TABLE `courses` (
  `id` int(11) NOT NULL,
  `mentor_id` int(11) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `subcategory_id` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `cover` varchar(255) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 = No Disponible. 1 = Disponible',
  `likes` int(10) UNSIGNED DEFAULT 0 COMMENT 'Para guardar el numero de likes que tiene ese curso',
  `shares` int(10) UNSIGNED DEFAULT 0 COMMENT 'Para guardar el numero de veces que ha sido compartido',
  `views` int(10) UNSIGNED DEFAULT 0 COMMENT 'Para guardar el numero de visualizaciones',
  `price` double(65,2) NOT NULL DEFAULT 0.00,
  `tipocurso` int(11) NOT NULL DEFAULT 0,
  `idproducto_sinergia` int(11) DEFAULT NULL,
  `tiempo` text DEFAULT NULL,
  `url_introduccion` text DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `cupon`
--

CREATE TABLE `cupon` (
  `id` int(11) NOT NULL,
  `titulo` text DEFAULT NULL,
  `tipo` int(11) DEFAULT NULL,
  `descuento` decimal(65,2) DEFAULT NULL,
  `vencimiento` date 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 `defender`
--

CREATE TABLE `defender` (
  `id` int(11) NOT NULL,
  `ip` 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 `departamento`
--

CREATE TABLE `departamento` (
  `id` int(11) NOT NULL,
  `nombre` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `descuento`
--

CREATE TABLE `descuento` (
  `id` int(11) NOT NULL,
  `rango1` decimal(65,2) NOT NULL DEFAULT 0.00,
  `rango2` decimal(65,2) NOT NULL DEFAULT 0.00,
  `porcentaje` decimal(65,2) NOT NULL DEFAULT 0.00,
  `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 `estados`
--

CREATE TABLE `estados` (
  `id` int(4) NOT NULL,
  `nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `pais` int(3) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) NOT NULL,
  `idcourse` int(11) NOT NULL,
  `pregunta` text DEFAULT NULL,
  `respuesta` 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 `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcourse` int(11) DEFAULT NULL,
  `orden` int(11) NOT NULL DEFAULT 0,
  `leccion` int(11) DEFAULT NULL,
  `porcentaje` decimal(65,2) NOT NULL DEFAULT 0.00,
  `fecha` date DEFAULT NULL,
  `expedicion` date DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `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 `examenes`
--

CREATE TABLE `examenes` (
  `id` int(11) NOT NULL,
  `idevaluacion` int(11) NOT NULL,
  `acierto` text DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `idcourse` 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 `firma`
--

CREATE TABLE `firma` (
  `id` int(11) NOT NULL,
  `firma` 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 `formulario`
--

CREATE TABLE `formulario` (
  `id` int(11) NOT NULL,
  `label` varchar(250) NOT NULL,
  `nameinput` varchar(200) NOT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 1,
  `requerido` tinyint(1) NOT NULL DEFAULT 0,
  `input_edad` tinyint(1) NOT NULL DEFAULT 0,
  `tipo` varchar(200) NOT NULL DEFAULT 'text',
  `min` int(11) DEFAULT NULL,
  `max` int(11) DEFAULT NULL,
  `desactivable` tinyint(1) NOT NULL DEFAULT 1,
  `unico` int(11) DEFAULT NULL,
  `tip` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `formulario` (`id`, `label`, `nameinput`, `estado`, `requerido`, `input_edad`, `tipo`, `min`, `max`, `desactivable`, `unico`, `tip`, `created_at`, `updated_at`) VALUES
(1, 'Nombre', 'firstname', 1, 1, 0, 'text', 0, 0, 0, 0, 0, '2022-06-23 23:10:01', '2021-03-06 14:16:30'),
(2, 'Apellido', 'lastname', 1, 1, 0, 'text', 0, 0, 0, 0, 0, '2022-06-23 23:10:01', '2020-11-20 14:49:10'),
(3, 'Sexo', 'genero', 1, 1, 0, 'select', 0, 0, 1, 0, 0, '2022-06-23 23:10:01', '2020-07-07 19:26:27'),
(4, 'Fecha de Nacimiento', 'edad', 1, 1, 1, 'text', 0, 0, 1, 0, 0, '2023-12-16 13:33:40', '2019-12-06 23:36:19'),
(5, 'Usuario', 'nameuser', 1, 1, 0, 'text', 0, 0, 0, 1, 0, '2022-06-23 23:10:01', '2019-01-08 04:55:50'),
(7, 'Dirección', 'direccion', 0, 0, 0, 'text', 0, 0, 1, 0, 0, '2022-11-19 20:48:50', '2022-11-20 01:48:50'),
(12, 'N° de Documento de Identidad', 'document', 0, 1, 0, 'text', 1, 20, 1, 1, 0, '2022-11-19 20:48:46', '2022-11-20 01:48:46'),
(13, 'Dirección 2', 'direccion2', 0, 0, 0, 'text', 1, 100, 1, 0, 0, '2022-08-05 01:40:27', '2019-12-06 23:37:27'),
(18, 'Estado', 'estado', 0, 0, 0, 'text', 1, 100, 1, 0, 0, '2022-08-05 01:40:23', '2019-12-06 23:38:03'),
(19, 'Ciudad', 'ciudad', 1, 1, 0, 'text', 1, 100, 1, 0, 0, '2022-08-05 01:40:33', '2021-03-03 18:52:30'),
(20, 'Codigo Postal', 'codigo', 0, 0, 0, 'text', 1, 20, 1, 0, 0, '2022-08-05 01:40:51', '2019-01-30 03:52:34'),
(22, 'Teléfono fijo', 'fijo', 0, 0, 0, 'number', 1, 20, 1, 0, 0, '2022-08-05 01:41:00', '2019-01-30 03:54:11'),
(23, 'Facebook', 'facebook', 0, 0, 0, 'url', 30, 200, 1, 0, 0, '2022-08-05 01:41:07', '2019-01-30 03:59:43'),
(24, 'Twitter', 'twitter', 0, 0, 0, 'url', 30, 200, 1, 0, 0, '2022-08-05 01:41:11', '2019-01-30 04:01:10'),
(25, 'Nombre del Banco', 'banco', 0, 0, 0, 'text', 2, 200, 1, 0, 0, '2022-08-05 01:41:34', '2019-01-30 04:01:45'),
(26, 'Tipo de Cuenta', 'tipocuenta', 0, 0, 0, 'text', 2, 50, 1, 0, 0, '2022-09-18 21:29:53', '2019-01-30 04:03:42'),
(27, 'Titular de la cuenta', 'titular', 0, 0, 0, 'text', 2, 200, 1, 0, 0, '2022-08-05 01:41:41', '2019-01-30 04:04:11'),
(28, 'Numero de cuenta', 'cuenta', 0, 0, 0, 'number', 1, 200, 1, 0, 0, '2022-08-05 01:41:49', '2019-01-30 04:04:38'),
(29, 'Codigo swift', 'swift', 0, 0, 0, 'text', 0, 0, 1, 0, 0, '2022-06-23 23:10:01', '2019-02-01 18:47:25'),
(30, 'Numero PAN', 'pan', 0, 0, 0, 'number', 0, 0, 1, 0, 0, '2022-06-23 23:10:01', '2019-01-30 04:07:15'),
(31, 'Cuenta Paypal', 'paypal', 0, 0, 0, 'text', 10, 20, 1, 0, 0, '2022-06-23 23:10:01', '2019-01-30 04:08:26'),
(32, 'Direccion de Blocktrail', 'blocktrail', 0, 0, 0, 'text', 10, 20, 1, 0, 0, '2022-06-23 23:10:01', '2019-01-30 04:09:16'),
(33, 'Direccion de blockchain', 'blockchain', 0, 0, 0, 'text', 10, 20, 1, 0, 0, '2022-06-23 23:10:01', '2019-01-30 04:09:40'),
(34, 'Direccion de Bitgo', 'bitgo', 0, 0, 0, 'text', 10, 20, 1, 0, 0, '2022-11-19 20:56:57', '2022-11-20 01:56:57'),
(38, 'País', 'pais', 1, 1, 0, 'select', 0, 0, 1, 0, 0, '2023-02-23 19:52:36', '2019-12-09 14:28:43'),
(39, 'Celular', 'phone', 1, 1, 0, 'number', 1, 20, 1, 0, 0, '2023-12-16 15:45:55', '2020-12-29 23:41:53');

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

--
-- Estructura de tabla para la tabla `historias`
--

CREATE TABLE `historias` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `fecha` date DEFAULT NULL,
  `titulo` text DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `imagen` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `informacionbancaria`
--

CREATE TABLE `informacionbancaria` (
  `id` int(11) NOT NULL,
  `titulo` varchar(250) DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `inicio`
--

CREATE TABLE `inicio` (
  `id` int(11) NOT NULL,
  `nivel` int(11) DEFAULT NULL,
  `monto` decimal(65,4) NOT NULL DEFAULT 0.0000,
  `idproducto` int(11) DEFAULT NULL,
  `nombre` text DEFAULT NULL,
  `porcentaje` decimal(65,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `inventario`
--

CREATE TABLE `inventario` (
  `id` int(11) NOT NULL,
  `idproducto` text DEFAULT NULL,
  `nombre` text DEFAULT NULL,
  `inventario` int(11) NOT NULL DEFAULT 0,
  `visible` int(11) NOT NULL DEFAULT 0,
  `tiempo` int(11) NOT NULL DEFAULT 0,
  `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 `ip`
--

CREATE TABLE `ip` (
  `id` int(11) NOT NULL,
  `ip` text DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `iva`
--

CREATE TABLE `iva` (
  `id` int(11) NOT NULL,
  `configuracion` longtext NOT NULL,
  `tipo` varchar(250) NOT NULL,
  `tipocalculo` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `lessons`
--

CREATE TABLE `lessons` (
  `id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `title` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `url` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `megusta`
--

CREATE TABLE `megusta` (
  `id` int(11) NOT NULL,
  `idproducto` int(11) DEFAULT NULL,
  `iduser` 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 `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL,
  `inicio` text DEFAULT NULL,
  `actualizar` text DEFAULT NULL,
  `registro` text DEFAULT NULL,
  `registro_cliente` text DEFAULT NULL,
  `red_usuario` text DEFAULT NULL,
  `transacciones` text DEFAULT NULL,
  `billetera` text DEFAULT NULL,
  `calendario` text DEFAULT NULL,
  `informes` text DEFAULT NULL,
  `prospeccion` text DEFAULT NULL,
  `correos` text DEFAULT NULL,
  `tickets` text DEFAULT NULL,
  `ranking` text DEFAULT NULL,
  `tienda` text DEFAULT NULL,
  `herramientas` text DEFAULT NULL,
  `presentacion` text DEFAULT NULL,
  `puntos` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `menu` (`id`, `inicio`, `actualizar`, `registro`, `registro_cliente`, `red_usuario`, `transacciones`, `billetera`, `calendario`, `informes`, `prospeccion`, `correos`, `tickets`, `ranking`, `tienda`, `herramientas`, `presentacion`, `puntos`, `created_at`, `updated_at`) VALUES
(1, '{\"activo\":1}', '{\"activo\":1}', '{\"activo\":1}', '{\"activo\":0}', '{\"activo\":1,\"usuario\":1,\"cliente\":0,\"directos\":1,\"red\":1,\"volumen\":0}', '{\"activo\":1,\"personales\":1,\"red\":1,\"directos\":0,\"link\":1}', '{\"activo\":1,\"billetera\":1,\"transferencia\":1,\"corte\":1,\"canje\":1}', '{\"activo\":1}', '{\"activo\":1,\"activacion\":1,\"comisiones\":1,\"liquidacion\":1,\"repor_comisiones\":1,\"afiliados\":1}', '{\"activo\":1}', '{\"activo\":1}', '{\"activo\":1,\"mios\":1,\"generar\":1}', '{\"activo\":1}', '{\"activo\":1,\"productos\":1,\"bancaria\":1,\"pagos\":1,\"lista_pagos\":1,\"paypal\":1,\"paga_paypal\":1}', '{\"activo\":1,\"documentos\":1,\"articulos\":1,\"activacion_correos\":1}', '{\"activo\":0}', '{\"activo\":1,\"red\":1,\"mios\":1,\"almacenados\":0,\"debitables\":0}', NULL, '0000-00-00 00:00:00'),
(2, '{\"activo\":1}', '{\"activo\":1}', '{\"activo\":0}', '{\"activo\":0}', '{\"activo\":0,\"usuario\":0,\"cliente\":0,\"directos\":0,\"red\":0,\"volumen\":0}', '{\"activo\":1,\"personales\":1,\"red\":0,\"directos\":0,\"link\":0}', '{\"activo\":1,\"billetera\":1,\"transferencia\":1,\"corte\":1,\"canje\":1}', '{\"activo\":0}', '{\"activo\":0,\"activacion\":0,\"comisiones\":0,\"liquidacion\":0,\"repor_comisiones\":0,\"afiliados\":0}', '{\"activo\":1}', '{\"activo\":0}', '{\"activo\":1,\"mios\":1,\"generar\":1}', '{\"activo\":0}', '{\"activo\":1,\"productos\":1,\"bancaria\":1,\"pagos\":1,\"lista_pagos\":1,\"paypal\":1,\"paga_paypal\":1}', '{\"activo\":1,\"documentos\":1,\"articulos\":1,\"activacion_correos\":1}', '{\"activo\":0}', '{\"activo\":0,\"red\":1,\"mios\":1,\"almacenados\":0,\"debitables\":0}', NULL, '0000-00-00 00:00:00');

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

--
-- Estructura de tabla para la tabla `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `chatid` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `menssage` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `monedas`
--

CREATE TABLE `monedas` (
  `id` int(11) NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `simbolo` varchar(200) NOT NULL,
  `mostrar_a_d` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 o false - despue del monto, 1 o true - antes del monto',
  `principal` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `municipios`
--

CREATE TABLE `municipios` (
  `id` int(6) NOT NULL,
  `nombre` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `estado` int(4) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `notificacion_tickets`
--

CREATE TABLE `notificacion_tickets` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user` varchar(250) NOT NULL,
  `ticket` varchar(250) NOT NULL,
  `contenido` varchar(250) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `notification_type` varchar(5) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `route` varchar(200) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `calendario` int(11) DEFAULT NULL,
  `onsignal` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `onsignal`
--

CREATE TABLE `onsignal` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `id_onsignal` 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 `opciones_select`
--

CREATE TABLE `opciones_select` (
  `id` int(11) NOT NULL,
  `idselect` int(11) NOT NULL,
  `valor` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `opciones_select` (`id`, `idselect`, `valor`, `created_at`, `updated_at`) VALUES
(1, 3, 'M', '2022-06-23 23:10:01', '2019-01-08 02:13:50'),
(2, 3, 'F', '2022-06-23 23:10:01', '2019-01-08 02:13:50'),
(3, 38, 'United States', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(4, 38, 'Canada', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(5, 38, 'Afghanistan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(6, 38, 'Albania', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(7, 38, 'Algeria', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(8, 38, 'American Samoa', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(9, 38, 'Andorra', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(10, 38, 'Angola', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(11, 38, 'Anguilla', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(12, 38, 'Antartica', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(13, 38, 'Antigua and/or Barbuda', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(14, 38, 'Argentina', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(15, 38, 'Armenia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(16, 38, 'Aruba', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(17, 38, 'Australia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(18, 38, 'Austria', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(19, 38, 'Azerbaijan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(20, 38, 'Bahamas', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(21, 38, 'Bahrain', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(22, 38, 'Bangladesh', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(23, 38, 'Barbados', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(24, 38, 'Belarus', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(25, 38, 'Belgium', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(26, 38, 'Belize', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(27, 38, 'Benin', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(28, 38, 'Bermuda', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(29, 38, 'Bhutan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(30, 38, 'Bolivia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(31, 38, 'Bosnia and Herzegovina', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(32, 38, 'Botswana', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(33, 38, 'Bouvet Island', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(34, 38, 'Brazil', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(35, 38, 'Brunei Darussalam', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(36, 38, 'Bulgaria', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(37, 38, 'Burkina Faso', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(38, 38, 'Burundi', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(39, 38, 'Cambodia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(40, 38, 'Camerum', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(41, 38, 'Cabo Verde', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(42, 38, 'Cayman Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(43, 38, 'Central African Republic', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(44, 38, 'Chad', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(45, 38, 'Chile', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(46, 38, 'China', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(47, 38, 'Christmas Island', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(48, 38, 'Cocos (Keeling) Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(49, 38, 'Colombia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(50, 38, 'Comoras', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(51, 38, 'Congo', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(52, 38, 'Cook Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(53, 38, 'Costa Rica', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(54, 38, 'Croatia (Hrvatska)', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(55, 38, 'Cuba', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(56, 38, 'Cyprus', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(57, 38, 'Czech Republic', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(58, 38, 'Denmark', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(59, 38, 'Djibouti', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(60, 38, 'Dominica', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(61, 38, 'Dominican Republic', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(62, 38, 'East Timor', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(63, 38, 'Ecuador', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(64, 38, 'Egypt', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(65, 38, 'El Salvador', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(66, 38, 'Equatorial Guinea', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(67, 38, 'Eritrea', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(68, 38, 'Estonia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(69, 38, 'Ethiopia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(70, 38, 'Falkland Islands (Malvinas)', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(71, 38, 'Faroe Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(72, 38, 'Fiji', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(73, 38, 'Finland', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(74, 38, 'France', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(75, 38, 'France, Metropolitan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(76, 38, 'French Guiana', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(77, 38, 'French Polynesia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(78, 38, 'French Southern Territories', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(79, 38, 'Gabon', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(80, 38, 'Gambia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(81, 38, 'Georgia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(82, 38, 'Germany', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(83, 38, 'Ghana', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(84, 38, 'Gibraltar', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(85, 38, 'Greece', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(86, 38, 'Greenland', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(87, 38, 'Grenada', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(88, 38, 'Guadeloupe', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(89, 38, 'Guam', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(90, 38, 'Guatemala', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(91, 38, 'Guinea', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(92, 38, 'Guinea-Bissau', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(93, 38, 'Guyana', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(94, 38, 'Haiti', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(95, 38, 'Heard and Mc Donald Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(96, 38, 'Honduras', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(97, 38, 'Hong Kong', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(98, 38, 'Hungary', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(99, 38, 'Iceland', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(100, 38, 'India', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(101, 38, 'Indonesia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(102, 38, 'Iran (Islamic Republic of)', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(103, 38, 'Iraq', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(104, 38, 'Ireland', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(105, 38, 'Israel', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(106, 38, 'Italy', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(107, 38, 'Ivory Coast', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(108, 38, 'Jamaica', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(109, 38, 'Japan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(110, 38, 'Jordan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(111, 38, 'Kazakhstan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(112, 38, 'Kenya', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(113, 38, 'Kiribati', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(114, 38, 'Korea, Democratic People\'s Republic of', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(115, 38, 'Korea, Republic of', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(116, 38, 'Kosovo', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(117, 38, 'Kuwait', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(118, 38, 'Kyrgyzstan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(119, 38, 'Lao People\'s Democratic Republic', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(120, 38, 'Latvia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(121, 38, 'Lebanon', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(122, 38, 'Lesotho', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(123, 38, 'Liberia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(124, 38, 'Libyan Arab Jamahiriya', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(125, 38, 'Liechtenstein', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(126, 38, 'Lithuania', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(127, 38, 'Luxembourg', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(128, 38, 'Macau', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(129, 38, 'Macedonia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(130, 38, 'Madagascar', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(131, 38, 'Malawi', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(132, 38, 'Malaysia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(133, 38, 'Maldives', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(134, 38, 'Mali', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(135, 38, 'Malta', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(136, 38, 'Marshall Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(137, 38, 'Martinique', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(138, 38, 'Mauritania', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(139, 38, 'Mauritius', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(140, 38, 'Mayotte', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(141, 38, 'México', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(142, 38, 'Micronesia, Federated States of', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(143, 38, 'Moldova, Republic of', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(144, 38, 'Monaco', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(145, 38, 'Mongolia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(146, 38, 'Montenegro', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(147, 38, 'Montserrat', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(148, 38, 'Morocco', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(149, 38, 'Mozambique', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(150, 38, 'Myanmar', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(151, 38, 'Namibia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(152, 38, 'Nauru', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(153, 38, 'Nepal', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(154, 38, 'Netherlands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(155, 38, 'Netherlands Antilles', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(156, 38, 'New Caledonia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(157, 38, 'New Zealand', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(158, 38, 'Nicaragua', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(159, 38, 'Niger', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(160, 38, 'Nigeria', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(161, 38, 'Niue', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(162, 38, 'Norfork Island', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(163, 38, 'Northern Mariana Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(164, 38, 'Norway', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(165, 38, 'Oman', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(166, 38, 'Pakistan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(167, 38, 'Palau', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(168, 38, 'Panama', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(169, 38, 'Papua New Guinea', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(170, 38, 'Paraguay', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(171, 38, 'Peru', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(172, 38, 'Philippines', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(173, 38, 'Pitcairn', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(174, 38, 'Poland', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(175, 38, 'Portugal', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(176, 38, 'Puerto Rico', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(177, 38, 'Qatar', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(178, 38, 'Reunion', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(179, 38, 'Romania', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(180, 38, 'Russian Federation', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(181, 38, 'Rwanda', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(182, 38, 'Saint Kitts and Nevis', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(183, 38, 'Saint Lucia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(184, 38, 'Saint Vincent and the Grenadines', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(185, 38, 'Samoa', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(186, 38, 'San Marino', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(187, 38, 'Sao Tome and Principe', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(188, 38, 'Saudi Arabia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(189, 38, 'Senegal', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(190, 38, 'Serbia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(191, 38, 'Seychelles', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(192, 38, 'Sierra Leone', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(193, 38, 'Singapore', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(194, 38, 'Slovakia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(195, 38, 'Slovenia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(196, 38, 'Solomon Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(197, 38, 'Somalia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(198, 38, 'South Africa', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(199, 38, 'South Georgia South Sandwich Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(200, 38, 'Spain', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(201, 38, 'Sri Lanka', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(202, 38, 'St. Helena', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(203, 38, 'St. Pierre and Miquelon', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(204, 38, 'Sudan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(205, 38, 'Suriname', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(206, 38, 'Svalbarn and Jan Mayen Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(207, 38, 'Swaziland', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(208, 38, 'Sweden', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(209, 38, 'Switzerland', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(210, 38, 'Syrian Arab Republic', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(211, 38, 'Taiwan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(212, 38, 'Tajikistan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(213, 38, 'Tanzania, United Republic of', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(214, 38, 'Thailand', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(215, 38, 'Togo', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(216, 38, 'Tokelau', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(217, 38, 'Tonga', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(218, 38, 'Trinidad and Tobago', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(219, 38, 'Tunisia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(220, 38, 'Turkey', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(221, 38, 'Turkmenistan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(222, 38, 'Turks and Caicos Islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(223, 38, 'Tuvalu', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(224, 38, 'Uganda', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(225, 38, 'Ukraine', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(226, 38, 'United Arab Emirates', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(227, 38, 'United Kingdom', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(228, 38, 'United States minor outlying islands', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(229, 38, 'Uruguay', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(230, 38, 'Uzbekistan', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(231, 38, 'Vanuatu', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(232, 38, 'Vatican City State', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(233, 38, 'Venezuela', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(234, 38, 'Vietnam', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(235, 38, 'Yemen', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(236, 38, 'Yugoslavia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(237, 38, 'Zaire', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(238, 38, 'Zambia', '2022-09-19 02:35:41', '2022-09-19 02:35:41'),
(239, 38, 'Zimbawe', '2022-09-19 02:35:41', '2022-09-19 02:35:41');

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

--
-- Estructura de tabla para la tabla `optioncarritos`
--

CREATE TABLE `optioncarritos` (
  `id` int(11) NOT NULL,
  `nombre` varchar(250) NOT NULL,
  `modal` text DEFAULT NULL,
  `imagen` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 - inactivo 1 - activo',
  `aprobado_automatico` int(11) NOT NULL DEFAULT 0 COMMENT '0 - el admin debe aceptar la compra 1 - la compra que da aprobada de una ves ',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `optioncarritos` (`id`, `nombre`, `modal`, `imagen`, `status`, `aprobado_automatico`, `created_at`, `updated_at`) VALUES
(1, 'Billetera', NULL, NULL, 1, 1, '2022-10-08 20:33:36', '2020-11-15 23:31:49'),
(2, 'Transferencia Bancaria', NULL, NULL, 1, 0, '2022-10-08 20:33:38', '2021-06-10 02:14:35'),
(3, 'Efectivo', NULL, NULL, 1, 0, '2023-07-08 16:40:53', '2023-02-25 18:01:55'),
(4, 'PayPal', 'paypal', NULL, 0, 0, '2022-10-08 20:33:28', '2021-03-13 18:05:17'),
(5, 'Coinpayment', 'coinpayment', 'coinpayments.png', 0, 0, '2022-11-19 23:00:47', '2022-11-20 04:00:47'),
(6, 'Coinbase', 'coinbase', 'coinbase.png', 0, 0, '2022-08-07 21:03:58', '2021-06-09 19:50:14'),
(7, 'Payu', 'payutarjeta', 'payu.png', 0, 0, '2023-07-08 16:40:47', '2021-06-04 19:01:22'),
(9, 'Stripe', 'stripe', 'stripe.png', 0, 0, '2022-10-08 20:33:23', '2021-03-23 17:25:51'),
(10, 'Mercado Pago', 'mercadopago', 'mercadopago.png', 0, 0, '2023-07-08 16:40:45', '2023-02-25 18:01:28'),
(11, 'Openpay Card', 'openpay', 'openpay.png', 0, 0, '2023-08-22 22:23:08', '2021-03-13 21:23:34'),
(12, 'Conekta', 'conekta', 'conekta.png', 0, 0, '2022-08-07 21:03:44', '2021-03-13 21:23:34'),
(13, 'TuCompra', 'tucompra', 'tucompra.png', 0, 0, '2022-08-07 21:03:42', '2021-04-30 17:44:27'),
(14, 'Authorize.net', 'autorize', NULL, 0, 0, '2022-11-20 16:30:48', '2022-11-20 04:00:41'),
(15, 'Izipay', 'izipay', '', 0, 0, '2022-11-20 17:04:36', '2022-11-20 22:04:36'),
(16, 'Openpay Banco', 'openpay', 'logoOpenpay.jpg', 0, 0, '2023-08-22 22:23:30', '2023-08-22 22:23:27'),
(17, 'Openpay Paynet', 'openpay', 'logoOpenpay.jpg', 0, 0, '2023-08-22 22:23:34', '2023-08-22 22:23:31'),
(18, 'Openpay Card 3D Secure', 'openpay', 'logoOpenpay.jpg', 0, 0, '2023-08-22 22:23:34', '2023-08-22 22:23:31'),
(19, 'Nowpayments', '', 'nowpayments.png', 0, 0, '2023-08-22 22:23:34', '2023-08-22 22:23:31');

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

--
-- Estructura de tabla para la tabla `pagocarritos`
--

CREATE TABLE `pagocarritos` (
  `id` int(11) NOT NULL,
  `name` text DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `idcompra` int(11) NOT NULL,
  `metodo` int(11) NOT NULL,
  `nombre` text NOT NULL,
  `informacion` longtext DEFAULT NULL,
  `datoscompra` longtext DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 - en espera 1 - aprobada 2 - cancelada',
  `fecha` date DEFAULT NULL,
  `pais` int(11) NOT NULL DEFAULT 1,
  `soporte` text DEFAULT NULL,
  `descuento` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `pagos`
--

CREATE TABLE `pagos` (
  `id` int(11) NOT NULL,
  `iduser` bigint(20) NOT NULL,
  `username` text NOT NULL,
  `email` text NOT NULL,
  `monto` decimal(65,2) NOT NULL,
  `fechasoli` date NOT NULL,
  `fechapago` date DEFAULT NULL,
  `metodo` text NOT NULL,
  `estado` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `tipopago` text DEFAULT NULL,
  `descuento` decimal(65,2) DEFAULT NULL,
  `automatico` int(11) NOT NULL DEFAULT 0,
  `idmetodo` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `paises`
--

CREATE TABLE `paises` (
  `id` int(11) NOT NULL,
  `nombre` mediumtext NOT NULL,
  `idface` int(11) NOT NULL,
  `abbreviation` varchar(5) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `paises` (`id`, `nombre`, `idface`, `abbreviation`, `created_at`, `updated_at`) VALUES
(1, 'United States', 1, 'EU', '2022-11-02 19:38:36', NULL),
(2, 'Canada', 1, 'CA', '2022-11-02 19:38:36', NULL),
(3, 'Afghanistan', 93, 'AF', '2022-11-02 19:38:36', NULL),
(4, 'Albania', 355, 'AL', '2022-11-02 19:38:36', NULL),
(5, 'Algeria', 213, 'DZ', '2023-11-15 20:48:09', NULL),
(6, 'American Samoa', 1, 'AS', '2023-11-15 20:48:21', NULL),
(7, 'Andorra', 376, 'AD', '2022-11-02 19:38:36', NULL),
(8, 'Angola', 244, 'AO	', '2022-11-02 19:38:36', NULL),
(11, 'Antigua and/or Barbuda', 1, 'AG', '2022-11-02 19:38:36', NULL),
(12, 'Argentina', 54, 'AR', '2022-11-02 19:38:36', NULL),
(13, 'Armenia', 374, 'AM', '2022-11-02 19:38:36', NULL),
(14, 'Aruba', 297, 'AW', '2022-11-02 19:38:36', NULL),
(15, 'Australia', 61, 'AU', '2022-11-02 19:38:36', NULL),
(16, 'Austria', 43, 'AT', '2022-11-02 19:38:36', NULL),
(17, 'Azerbaijan', 994, 'AZ', '2023-11-15 20:50:42', NULL),
(18, 'Bahamas', 1, 'BS', '2022-11-02 19:38:36', NULL),
(19, 'Bahrain', 973, 'BH', '2023-11-15 20:50:59', NULL),
(20, 'Bangladesh', 880, 'BD', '2022-11-02 19:38:36', NULL),
(21, 'Barbados', 1, 'BB', '2022-11-02 19:38:36', NULL),
(22, 'Belarus', 375, 'BY', '2022-11-02 19:38:36', NULL),
(23, 'Belgium', 32, 'BE', '2023-11-15 21:41:03', NULL),
(24, 'Belize', 501, 'BZ', '2023-11-15 21:41:11', NULL),
(25, 'Benin', 229, 'BJ', '2022-11-02 19:38:36', NULL),
(26, 'Bermudas', 1, 'BM', '2022-11-02 19:38:36', NULL),
(27, 'Bhutan', 975, 'BT', '2023-11-15 21:41:38', NULL),
(28, 'Bolivia', 591, 'BO', '2022-11-02 19:38:36', NULL),
(29, 'Bosnia and Herzegovina', 387, 'BA', '2023-11-15 21:41:56', NULL),
(30, 'Botswana', 267, 'BW', '2023-11-15 21:42:03', NULL),
(31, 'Bouvet Island', 47, 'BV', '2023-11-15 21:42:12', NULL),
(32, 'Brazil', 55, 'BR', '2023-11-15 21:42:20', NULL),
(34, 'Brunei', 673, 'BN', '2023-11-15 21:42:28', NULL),
(35, 'Bulgaria', 359, 'BG', '2022-11-02 19:38:36', NULL),
(36, 'Burkina Faso', 226, 'BF', '2022-11-02 19:38:36', NULL),
(37, 'Burundi', 257, 'BI', '2022-11-02 19:38:36', NULL),
(38, 'Cambodia', 855, 'KH', '2022-11-02 19:38:36', NULL),
(39, 'Cameroon', 237, 'CM', '2023-11-15 21:43:01', NULL),
(40, 'Cabo Verde', 238, 'CV', '2022-11-02 19:38:36', NULL),
(41, 'Cayman Islands', 1, 'KY', '2022-11-02 19:38:36', NULL),
(42, 'Central African Republic', 236, 'CF', '2023-11-15 21:43:36', NULL),
(43, 'Chad', 235, 'TD', '2022-11-02 19:38:36', NULL),
(44, 'Chile', 56, 'CH', '2022-11-02 19:38:36', NULL),
(45, 'China', 86, 'CN', '2022-11-02 19:38:36', NULL),
(46, 'Christmas Island', 61, 'CX', '2023-11-15 21:44:04', NULL),
(47, 'Cocos Islands', 61, 'CC', '2023-11-15 21:44:13', NULL),
(48, 'Colombia', 57, 'CO', '2022-11-02 19:38:36', NULL),
(50, 'Congo', 242, 'CG', '2022-11-02 19:38:36', NULL),
(51, 'Cook Islands', 682, 'CK', '2022-11-02 19:38:36', NULL),
(52, 'Costa Rica', 506, 'CR', '2022-11-02 19:38:36', NULL),
(53, 'Croatia', 385, 'HR', '2023-11-15 21:44:42', NULL),
(54, 'Cuba', 53, 'CU', '2022-11-02 19:38:36', NULL),
(55, 'Cyprus', 357, 'CY', '2023-11-15 21:44:57', NULL),
(56, 'Czech Republic', 3, 'CZ', '2023-11-15 21:45:07', NULL),
(57, 'Denmark', 45, 'DK', '2023-11-15 21:45:16', NULL),
(58, 'Djibouti', 253, 'DJ', '2022-11-02 19:38:36', NULL),
(59, 'Dominica', 1, 'DM', '2022-11-02 19:38:36', NULL),
(60, 'Dominican Republic', 1, 'DO', '2023-11-15 21:45:38', NULL),
(61, 'East Timor', 670, 'TL', '2023-11-15 21:45:47', NULL),
(62, 'Ecuador', 593, 'EC', '2022-11-02 19:38:36', NULL),
(63, 'Egypt', 20, 'EG', '2023-11-15 21:45:59', NULL),
(64, 'El Salvador', 503, 'SV', '2022-11-02 19:38:36', NULL),
(65, 'Equatorial Guinea', 240, 'GQ', '2023-11-15 21:46:07', NULL),
(66, 'Eritrea', 291, 'ER', '2022-11-02 19:38:36', NULL),
(67, 'Estonia', 372, 'EE', '2022-11-02 19:38:36', NULL),
(68, 'Ethiopia', 251, 'ET', '2023-11-15 21:46:26', NULL),
(69, 'Malvinas Islands', 500, 'FK', '2023-11-15 21:46:36', NULL),
(70, 'Faroe Islands', 298, 'FO', '2023-11-15 21:46:43', NULL),
(71, 'Fiji', 679, 'FJ', '2022-11-02 19:38:36', NULL),
(72, 'Finland', 358, 'FI', '2023-11-15 21:46:58', NULL),
(73, 'France', 33, 'FR', '2023-11-15 21:47:03', NULL),
(75, 'French Guiana', 594, 'GF', '2022-11-02 19:38:36', NULL),
(76, 'French Polynesia', 689, 'PF', '2023-11-15 21:47:17', NULL),
(78, 'Gabon', 241, 'GA', '2022-11-02 19:38:36', NULL),
(79, 'Gambia', 220, 'GM', '2022-11-02 19:38:36', NULL),
(80, 'Georgia', 995, 'GE', '2022-11-02 19:38:36', NULL),
(81, 'Germany', 49, 'DE', '2023-11-15 21:47:38', NULL),
(82, 'Ghana', 233, 'GH', '2022-11-02 19:38:36', NULL),
(83, 'Gibraltar', 350, 'GI', '2022-11-02 19:38:36', NULL),
(84, 'Greece', 30, 'GR', '2023-11-15 21:48:01', NULL),
(85, 'Greenland', 299, 'GL', '2023-11-15 21:48:09', NULL),
(86, 'Grenada', 1, 'GD', '2023-11-15 21:48:17', NULL),
(87, 'Guadalupe', 590, 'GP', '2022-11-02 19:38:36', NULL),
(88, 'Guam', 1, 'GU', '2022-11-02 19:38:36', NULL),
(89, 'Guatemala', 502, 'GT', '2022-11-02 19:38:36', NULL),
(90, 'Guinea', 224, 'GN', '2022-11-02 19:38:36', NULL),
(91, 'Guinea-Bissau', 245, 'GW', '2022-11-02 19:38:36', NULL),
(92, 'Guyana', 592, 'GY', '2022-11-02 19:38:36', NULL),
(93, 'Haiti', 509, 'HT', '2022-11-02 19:38:36', NULL),
(94, 'Heard Island and McDonald Islands', 94, 'HM', '2023-11-15 21:49:11', NULL),
(95, 'Honduras', 504, 'HN', '2022-11-02 19:38:36', NULL),
(96, 'Hong Kong', 852, 'HK', '2022-11-02 19:38:36', NULL),
(97, 'Hungary', 36, 'HU', '2023-11-15 21:49:30', NULL),
(98, 'Iceland', 354, 'IS', '2023-11-15 21:49:37', NULL),
(99, 'India', 91, 'IN', '2022-11-02 19:38:36', NULL),
(100, 'Indonesia', 62, 'ID', '2022-11-02 19:38:36', NULL),
(101, 'Iran', 98, 'IR', '2022-11-02 19:38:36', NULL),
(102, 'Iraq', 964, 'IQ', '2022-11-02 19:38:36', NULL),
(103, 'Ireland', 353, 'IE', '2023-11-15 21:50:08', NULL),
(104, 'Israel', 972, 'IL', '2022-11-02 19:38:36', NULL),
(105, 'Italy', 39, 'IT', '2022-11-02 19:38:36', NULL),
(106, 'Ivory Coast', 225, 'CI', '2023-11-15 21:50:48', NULL),
(107, 'Jamaica', 1, 'JM', '2022-11-02 19:38:36', NULL),
(108, 'Japan', 81, 'JP', '2023-11-15 21:51:03', NULL),
(109, 'Jordan', 962, 'JO', '2022-11-02 19:38:36', NULL),
(110, 'Kazakhstan', 7, 'KZ', '2023-11-15 21:51:16', NULL),
(111, 'Kenya', 254, 'KE', '2023-11-15 21:51:24', NULL),
(112, 'Kiribati', 686, 'KI', '2022-11-02 19:38:36', NULL),
(113, 'North Korea', 850, 'KP', '2023-11-15 21:51:36', NULL),
(114, 'South Korea', 82, 'KR', '2023-11-15 21:51:43', NULL),
(115, 'Kosovo', 383, 'XK', '2022-11-02 19:38:36', NULL),
(116, 'Kuwait', 965, 'KW', '2022-11-02 19:38:36', NULL),
(117, 'Kyrgyzstan', 996, 'KG', '2023-11-15 21:52:01', NULL),
(118, 'Laos', 856, 'LA', '2022-11-02 19:38:36', NULL),
(119, 'Latvia', 371, 'LV', '2023-11-15 21:52:14', NULL),
(120, 'Lebanon', 961, 'LB', '2023-11-15 21:52:22', NULL),
(122, 'Liberia', 231, 'LR', '2022-11-02 19:38:36', NULL),
(123, 'Libya', 218, 'LY', '2023-11-15 21:52:37', NULL),
(124, 'Liechtenstein', 423, 'LI', '2022-11-02 19:38:36', NULL),
(125, 'Lithuania', 370, 'LT', '2023-11-15 21:53:03', NULL),
(126, 'Luxembourg', 352, 'LU', '2023-11-15 21:53:12', NULL),
(127, 'Macao', 853, 'MO', '2022-11-02 19:38:36', NULL),
(128, 'North Macedonia', 389, 'MK', '2023-11-15 21:53:51', NULL),
(129, 'Madagascar', 261, 'MG', '2022-11-02 19:38:36', NULL),
(130, 'Malawi', 265, 'MW', '2023-11-15 21:54:05', NULL),
(131, 'Malaysia', 60, 'MY', '2023-11-15 21:54:11', NULL),
(132, 'Maldives', 960, 'MV', '2023-11-15 21:54:18', NULL),
(133, 'Mali', 223, 'ML', '2022-11-02 19:38:36', NULL),
(134, 'Malta', 356, 'MT', '2022-11-02 19:38:36', NULL),
(135, 'Marshall Islands', 692, 'MH', '2023-11-15 21:54:33', NULL),
(136, 'Martinique', 596, 'MQ', '2023-11-15 21:54:42', NULL),
(137, 'Mauritania', 222, 'MR', '2022-11-02 19:38:36', NULL),
(138, 'Mauritius', 230, 'MU', '2023-11-15 21:54:55', NULL),
(139, 'Mayotte', 262, 'YT', '2022-11-02 19:38:36', NULL),
(140, 'México', 52, 'MEX', '2022-11-02 19:38:36', NULL),
(141, 'Federated States of Micronesia', 691, 'FM', '2023-11-15 21:55:12', NULL),
(142, 'Moldova', 373, 'MD', '2023-11-15 21:55:20', NULL),
(143, 'Principality of Monaco', 377, 'MC', '2023-11-15 21:55:27', NULL),
(144, 'Mongolia', 976, 'MN', '2022-11-02 19:38:36', NULL),
(145, 'Montenegro', 382, 'ME', '2022-11-02 19:38:36', NULL),
(146, 'Montserrat', 1, 'MS', '2022-11-02 19:38:36', NULL),
(147, 'Morocco', 212, 'MA', '2023-11-15 21:55:50', NULL),
(148, 'Mozambique', 258, 'MZ', '2022-11-02 19:38:36', NULL),
(149, 'Myanmar', 95, 'MM', '2022-11-02 19:38:36', NULL),
(150, 'Namibia', 264, 'NA', '2022-11-02 19:38:36', NULL),
(151, 'Nauru', 674, 'NR', '2022-11-02 19:38:36', NULL),
(152, 'Nepal', 977, 'NP', '2022-11-02 19:38:36', NULL),
(153, 'The Netherlands', 31, 'NL', '2023-11-15 21:56:27', NULL),
(155, 'New Caledonia', 687, 'NC', '2023-11-15 21:56:33', NULL),
(157, 'Nicaragua', 505, 'NI', '2022-11-02 19:38:36', NULL),
(158, 'Niger', 227, 'NE', '2022-11-02 19:38:36', NULL),
(159, 'Nigeria', 234, 'NG', '2022-11-02 19:38:36', NULL),
(160, 'Niue', 683, 'NU', '2022-11-02 19:38:36', NULL),
(161, 'Norfork Island', 672, 'NF', '2022-11-02 19:38:36', NULL),
(162, 'Northern Mariana Islands', 1, 'MP', '2023-11-15 21:57:04', NULL),
(163, 'Norway', 47, 'NO', '2023-11-15 21:57:13', NULL),
(164, 'Oman', 968, 'OM', '2022-11-02 19:38:36', NULL),
(165, 'Pakistan', 92, 'PK', '2022-11-02 19:38:36', NULL),
(166, 'Palau', 680, 'PW', '2023-11-15 21:57:34', NULL),
(167, 'Panama', 507, 'PA', '2022-11-02 19:38:36', NULL),
(168, 'Papua New Guinea', 675, 'PG', '2023-11-15 21:57:47', NULL),
(169, 'Paraguay', 595, 'PY', '2022-11-02 19:38:36', NULL),
(170, 'Peru', 51, 'PE', '2022-11-02 19:38:36', NULL),
(171, 'Philippines', 63, 'PH', '2023-11-15 21:58:03', NULL),
(172, 'Pitcairn Islands', 64, 'PN', '2023-11-15 21:58:09', NULL),
(173, 'Poland', 48, 'PL', '2023-11-15 21:58:14', NULL),
(174, 'Portugal', 351, 'PT', '2022-11-02 19:38:36', NULL),
(175, 'Puerto Rico', 1, 'PR', '2022-11-02 19:38:36', NULL),
(176, 'Qatar', 974, 'QA', '2023-11-15 21:58:28', NULL),
(177, 'Meeting', 262, 'RE', '2023-11-15 21:58:33', NULL),
(178, 'Romania', 40, 'RO	', '2023-11-15 21:58:39', NULL),
(179, 'Russia', 7, 'RU', '2023-11-15 21:58:44', NULL),
(180, 'Rwanda', 250, 'RW', '2023-11-15 21:58:50', NULL),
(181, 'St. Kitts and Nevis', 1, 'KN', '2023-11-15 21:58:57', NULL),
(182, 'Saint Lucia', 1, 'LC', '2023-11-15 21:59:04', NULL),
(183, 'Saint Vincent and the Grenadines', 1, 'VC', '2023-11-15 21:59:10', NULL),
(184, 'Samoa', 685, 'WS', '2022-11-02 19:38:36', NULL),
(185, 'San Marino', 378, 'SM', '2022-11-02 19:38:36', NULL),
(186, 'Sao Tome and Principe', 239, 'ST', '2023-11-15 21:59:27', NULL),
(187, 'Saudi Arabia', 966, 'SA', '2023-11-15 21:59:34', NULL),
(188, 'Senegal', 221, 'SN', '2022-11-02 19:38:36', NULL),
(189, 'Serbia', 381, 'RS', '2022-11-02 19:38:36', NULL),
(190, 'Seychelles', 248, 'SC', '2022-11-02 19:38:36', NULL),
(191, 'Sierra Leone', 232, 'SL', '2023-11-15 21:59:59', NULL),
(192, 'Singapore', 65, 'SG', '2023-11-15 22:00:07', NULL),
(193, 'Slovakia', 421, 'SK', '2023-11-15 22:00:14', NULL),
(194, 'Slovenia', 386, 'SI', '2023-11-15 22:00:23', NULL),
(195, 'Solomon Islands', 677, 'SB', '2023-11-15 22:00:29', NULL),
(196, 'Somalia', 252, 'SO', '2022-11-02 19:38:36', NULL),
(197, 'South Africa', 27, 'ZA', '2023-11-15 22:00:39', NULL),
(198, 'South Georgia and the South Sandwich Islands	', 500, 'GS', '2023-11-15 22:00:46', NULL),
(199, 'Spain', 34, 'ES', '2023-11-15 22:00:52', NULL),
(200, 'Sri Lanka', 94, 'LK', '2022-11-02 19:38:36', NULL),
(201, 'St. Helena, Ascensión and Tristán de Acuña', 290, 'SH', '2023-11-15 22:01:02', NULL),
(202, 'Saint Pierre and Miquelon', 508, 'PM', '2023-11-15 22:01:11', NULL),
(203, 'Sudan', 249, 'SD', '2022-11-02 19:38:36', NULL),
(204, 'Suriname', 597, 'SR', '2023-11-15 22:01:21', NULL),
(205, 'Svalbard and Jan Mayen', 47, 'SJ', '2023-11-15 22:01:26', NULL),
(206, 'Esuatini', 268, 'SZ', '2022-11-02 19:38:36', NULL),
(207, 'Sweden', 46, 'SE', '2023-11-15 22:01:38', NULL),
(208, 'Switzerland', 41, 'CH', '2023-11-15 22:01:43', NULL),
(209, 'Syria', 963, 'SY', '2023-11-15 22:01:48', NULL),
(210, 'Taiwan', 886, 'TW', '2022-11-02 19:38:36', NULL),
(211, 'Tajikistan', 992, 'TJ', '2023-11-15 22:02:02', NULL),
(212, 'Tanzania', 255, 'TZ', '2022-11-02 19:38:36', NULL),
(213, 'Thailand', 66, 'TH', '2023-11-15 22:02:13', NULL),
(214, 'Togo', 228, 'TG', '2022-11-02 19:38:36', NULL),
(215, 'Tokelau', 690, 'TK', '2022-11-02 19:38:36', NULL),
(216, 'Tonga', 676, 'TO', '2022-11-02 19:38:36', NULL),
(217, 'Trinidad and Tobago', 1, 'TT', '2023-11-15 22:02:31', NULL),
(218, 'Tunisia', 216, 'TN', '2023-11-15 22:02:37', NULL),
(219, 'Turkey', 90, 'TR', '2023-11-15 22:02:45', NULL),
(220, 'Turkmenistan', 993, 'TM', '2023-11-15 22:02:51', NULL),
(221, 'Turks and Caicos Islands', 1, 'TC', '2023-11-15 22:02:58', NULL),
(222, 'Tuvalu', 688, 'TV', '2022-11-02 19:38:36', NULL),
(223, 'Uganda', 256, 'UG', '2022-11-02 19:38:36', NULL),
(224, 'Ukraine', 380, 'UA', '2023-11-15 22:03:14', NULL),
(225, 'United Arab Emirates', 971, 'AE', '2023-11-15 22:03:21', NULL),
(226, 'United Kingdom', 44, 'GB', '2023-11-15 22:03:26', NULL),
(228, 'Uruguay', 598, 'UY', '2022-11-02 19:38:36', NULL),
(229, 'Uzbekistan', 998, 'UZ', '2022-11-02 19:38:36', NULL),
(230, 'Vanuatu', 67, 'VU', '2022-11-02 19:38:36', NULL),
(231, 'Vatican City', 2, 'VA', '2023-11-15 22:03:51', NULL),
(232, 'Venezuela', 58, 'VE', '2022-11-02 19:38:36', NULL),
(233, 'Vietnam', 84, 'VN', '2022-11-02 19:38:36', NULL),
(238, 'Yemen', 967, 'YE', '2022-11-02 19:38:36', NULL),
(241, 'Zambia', 260, 'ZM', '2022-11-02 19:38:36', NULL),
(242, 'Zimbabwe', 263, 'ZW', '2023-11-15 22:04:15', NULL);

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

--
-- Estructura de tabla para la tabla `perfilproductos`
--

CREATE TABLE `perfilproductos` (
  `id` int(11) NOT NULL,
  `idproducto` text DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL 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 `pop`
--

CREATE TABLE `pop` (
  `id` int(11) NOT NULL,
  `titulo` varchar(250) DEFAULT NULL,
  `contenido` longtext NOT NULL,
  `activado` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pop` (`id`, `titulo`, `contenido`, `activado`, `created_at`, `updated_at`) VALUES
(1, 'Presentación', '<p style=\"text-align: center; \"><iframe frameborder=\"0\" src=\"//www.youtube.com/embed/LjmAG25sQQU\" width=\"640\" height=\"360\" class=\"note-video-clip\"></iframe><br></p>', 1, '2023-02-25 14:35:27', '2023-02-25 14:35:27');

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

--
-- Estructura de tabla para la tabla `presentacion`
--

CREATE TABLE `presentacion` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `titulo` text DEFAULT NULL,
  `contenido_modal` text DEFAULT NULL,
  `fondo` text DEFAULT NULL,
  `facebook` text DEFAULT NULL,
  `instagram` text DEFAULT NULL,
  `whatsap` text DEFAULT NULL,
  `tiktok` text DEFAULT NULL,
  `twitter` text DEFAULT NULL,
  `color` text DEFAULT NULL,
  `subtitulo` 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 `prospeccion`
--

CREATE TABLE `prospeccion` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `persona_natural` text DEFAULT NULL,
  `firstname` text DEFAULT NULL,
  `lastname` text DEFAULT NULL,
  `direccion` text DEFAULT NULL,
  `ciudad` text DEFAULT NULL,
  `estado` text DEFAULT NULL,
  `user_email` text DEFAULT NULL,
  `local` text DEFAULT NULL,
  `zip` text DEFAULT NULL,
  `pais` text DEFAULT NULL,
  `telefono` text DEFAULT NULL,
  `website` text DEFAULT NULL,
  `referred_id` int(11) DEFAULT NULL,
  `position_id` int(11) DEFAULT NULL,
  `comentario` longtext DEFAULT NULL,
  `observaciones` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `pruebas`
--

CREATE TABLE `pruebas` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcourse` int(11) NOT NULL,
  `calificacion` decimal(65,2) NOT NULL DEFAULT 0.00,
  `fecha` date DEFAULT NULL,
  `idexamen` 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;

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

INSERT INTO `pruebas` (`id`, `iduser`, `idcourse`, `calificacion`, `fecha`, `idexamen`, `created_at`, `updated_at`) VALUES
(5, 15, 34, 100.00, '2024-03-25', NULL, '2024-03-25 15:58:00', '2024-03-25 15:58:00');

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

--
-- Estructura de tabla para la tabla `puntos`
--

CREATE TABLE `puntos` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcompra` int(11) NOT NULL,
  `usuario` text NOT NULL,
  `concepto` text NOT NULL,
  `puntos` decimal(65,2) DEFAULT 0.00,
  `cantidad` decimal(65,2) DEFAULT 0.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `puntosbonos`
--

CREATE TABLE `puntosbonos` (
  `id` int(11) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `idcompra` int(11) DEFAULT NULL,
  `usuario` text DEFAULT NULL,
  `concepto` text DEFAULT NULL,
  `puntos` decimal(65,2) DEFAULT 0.00,
  `tipo` text DEFAULT NULL COMMENT '1 - puntos que se pueden descontar 2 - puntos que se almacenan 3 - puntos descontados del 1',
  `lado` text DEFAULT NULL,
  `balance` decimal(65,2) DEFAULT 0.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `puntosred`
--

CREATE TABLE `puntosred` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `usuario` text DEFAULT NULL,
  `idcompra` int(11) DEFAULT NULL,
  `concepto` text NOT NULL,
  `puntos` decimal(65,2) DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `redes_sociales`
--

CREATE TABLE `redes_sociales` (
  `id` int(11) NOT NULL,
  `nombre` text DEFAULT NULL,
  `link` text NOT NULL,
  `tipo` int(11) DEFAULT NULL COMMENT '1- glyphicon 2-imagen',
  `imagen` text NOT NULL,
  `color` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `redes_sociales` (`id`, `nombre`, `link`, `tipo`, `imagen`, `color`, `created_at`, `updated_at`) VALUES
(2, 'whatsapp', 'https://web.whatsapp.com/', 1, 'fa-brands fa-square-whatsapp', '6fd96f', '2023-02-24 22:51:14', '2023-02-24 22:51:14'),
(3, 'Facebook', 'https://es-la.facebook.com/login/', 1, 'fa-brands fa-square-facebook', '3b5998', '2023-02-24 22:53:06', '2023-02-24 22:53:06'),
(12, 'Instagram', 'https://www.instagram.com/', 1, 'fa-brands fa-square-instagram', 'db4439', '2023-02-24 22:52:14', '2023-02-24 22:52:14'),
(13, 'Telegram', 'https://web.telegram.org/k/', 1, 'fa-brands fa-telegram', '007bb6', '2023-02-24 23:07:00', '2023-02-24 23:07:00'),
(14, 'TikTok', 'https://www.tiktok.com/', 1, 'fa-brands fa-tiktok', '0D0D0D', '2023-02-25 13:47:50', '2023-02-25 13:47:50'),
(15, 'Twitter', 'https://twitter.com/', 1, 'fa-brands fa-twitter', '11BEF6', '2023-02-25 13:47:11', '2023-02-25 13:47:11'),
(16, 'Youtube', 'https://youtube.com/', 1, 'fa-brands fa-youtube', 'F61137', '2023-02-25 13:45:28', '2023-02-25 13:45:28');

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

--
-- Estructura de tabla para la tabla `reporteinventario`
--

CREATE TABLE `reporteinventario` (
  `id` int(11) NOT NULL,
  `iduser` text DEFAULT NULL,
  `idcompra` int(11) NOT NULL,
  `tipo` text DEFAULT NULL,
  `idproducto` int(11) NOT NULL,
  `fecha` date NOT NULL,
  `concepto` text DEFAULT NULL,
  `cantidad` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `represado`
--

CREATE TABLE `represado` (
  `id` int(11) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `idpago` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `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 `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(200) NOT NULL,
  `referidos` int(11) DEFAULT 0,
  `refeact` int(11) DEFAULT 0,
  `referidosd` int(11) DEFAULT NULL,
  `referidosInd` int(11) DEFAULT NULL,
  `compras` float DEFAULT 0,
  `grupal` float DEFAULT NULL COMMENT 'puntos grupales',
  `comisiones` float DEFAULT 0,
  `bonos` float DEFAULT 0,
  `niveles` int(11) DEFAULT 0,
  `rolprevio` int(11) DEFAULT NULL,
  `acepta_comision` tinyint(1) DEFAULT 1,
  `rolnecesario` int(11) DEFAULT NULL,
  `rolnecesariocant` 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 `seguridad`
--

CREATE TABLE `seguridad` (
  `id` int(11) NOT NULL,
  `titulo` text DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `concepto` text DEFAULT NULL,
  `tipo` int(11) DEFAULT 1 COMMENT '1 - una ves al dia 2 - siempre 3 - cada treinta dias ',
  `status` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `seguridad` (`id`, `titulo`, `contenido`, `concepto`, `tipo`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'hola @nombre @correo le hemos enviamos un codigo de seguridad para verificar que es usted su codigo es: @codigo', NULL, 1, 0, '2022-06-23 23:10:02', '2020-05-10 21:38:37'),
(2, 'Codigo Qr', NULL, 'Al activar el codigo Qr puede usar google autenticador, Authy o cualquier otra aplicacion para escanear los codigo qr este sera requerido al iniciar sesion\r\n', 2, 0, '2022-10-23 21:18:54', '2021-08-16 08:03:46'),
(3, 'Verificacion por correo', 'Hola @nombre @correo se a enviado un codigo para verificar que es usted su codigo es: @codigo', 'Se envia un codigo al correo el cual debera ingresar al iniciar sesion ', 1, 0, '2022-09-17 19:27:03', '2020-05-11 03:11:57');

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

--
-- Estructura de tabla para la tabla `semiautobinario`
--

CREATE TABLE `semiautobinario` (
  `id` int(11) NOT NULL,
  `usuario` text DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `idcomision` int(11) DEFAULT NULL,
  `total` decimal(65,2) DEFAULT 0.00,
  `correo` text DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `lado` text DEFAULT NULL,
  `derecha` decimal(65,2) NOT NULL DEFAULT 0.00,
  `izquierda` decimal(65,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `sesions`
--

CREATE TABLE `sesions` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `fecha` date NOT NULL,
  `ip` varchar(191) NOT NULL,
  `actividad` longtext 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;

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

--
-- Estructura de tabla para la tabla `settingactivacion`
--

CREATE TABLE `settingactivacion` (
  `id` int(11) NOT NULL,
  `tipoactivacion` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1 - producto, 2 - dinero',
  `tiporecompra` tinyint(4) DEFAULT 0 COMMENT '1 - producto, 2 - dinero',
  `requisitoactivacion` float NOT NULL,
  `requisitorecompra` float DEFAULT NULL,
  `desativar_usuarios` tinyint(4) DEFAULT NULL COMMENT '0 - desactivar a fin de mes, 1 - desctivar despues de haber cumplido un mes en el sistema ',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `settingcliente`
--

CREATE TABLE `settingcliente` (
  `id` int(11) NOT NULL,
  `cliente` tinyint(1) NOT NULL,
  `permiso` tinyint(1) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `settingcomision`
--

CREATE TABLE `settingcomision` (
  `id` int(11) NOT NULL,
  `niveles` int(11) NOT NULL,
  `tipocomision` varchar(200) NOT NULL,
  `valorgeneral` float DEFAULT NULL,
  `valordetallado` text DEFAULT NULL,
  `tipopago` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `tipotransferencia` tinyint(1) DEFAULT NULL COMMENT '0 - monto fijo 1 - monto por porcentaje',
  `comisiontransf` float DEFAULT NULL COMMENT 'esta es para el metodo de pago, es la comision por transferencia de dinero en la billetera',
  `bonoactivacion` longtext DEFAULT NULL,
  `directos` tinyint(1) DEFAULT 1 COMMENT 'si solo los directos aceptan el bono de activacion',
  `tipobono` varchar(50) DEFAULT NULL,
  `primera_compra` tinyint(1) DEFAULT 1,
  `activacioncomision` tinyint(1) DEFAULT NULL COMMENT '1 - cobrar comision desde la fecha de activacion, 2 - cobrar comision desde inicio del mes'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `settingpagos`
--

CREATE TABLE `settingpagos` (
  `id` int(11) NOT NULL,
  `nombre` varchar(200) NOT NULL,
  `logo` varchar(200) DEFAULT NULL,
  `feed` float NOT NULL,
  `monto_min` float DEFAULT 0,
  `tipofeed` tinyint(1) NOT NULL COMMENT '0 - monto fijo 1 - porcentaje',
  `estado` tinyint(1) NOT NULL DEFAULT 0,
  `correo` tinyint(1) DEFAULT 0,
  `wallet` tinyint(1) DEFAULT 0,
  `datosbancarios` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `settingpermiso`
--

CREATE TABLE `settingpermiso` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `nameuser` varchar(200) NOT NULL,
  `nuevo_registro` tinyint(4) DEFAULT 0,
  `red_usuario` tinyint(4) DEFAULT 0,
  `vision_usuario` tinyint(4) DEFAULT 0,
  `billetera` tinyint(4) DEFAULT 0,
  `pago` tinyint(4) DEFAULT 0,
  `informes` tinyint(4) DEFAULT 0,
  `tickets` tinyint(4) DEFAULT 0,
  `buzon` tinyint(4) DEFAULT 0,
  `ranking` tinyint(4) DEFAULT 0,
  `historial_actividades` tinyint(4) DEFAULT 0,
  `email_marketing` tinyint(4) DEFAULT 0,
  `administrar_redes` tinyint(4) DEFAULT 0,
  `soporte` tinyint(4) DEFAULT 0,
  `ajuste` tinyint(4) DEFAULT 0,
  `herramienta` tinyint(4) DEFAULT 0,
  `calendario` tinyint(4) DEFAULT 0,
  `correos` tinyint(4) DEFAULT 0,
  `prospeccion` tinyint(4) DEFAULT 0,
  `puntos` tinyint(4) DEFAULT 0,
  `binario` tinyint(4) DEFAULT 0,
  `proyectos` tinyint(4) DEFAULT 0,
  `gastos` tinyint(4) DEFAULT 0,
  `transacciones` tinyint(4) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL,
  `usuario` tinyint(4) DEFAULT 0,
  `tienda` tinyint(4) DEFAULT 0,
  `codigo` tinyint(4) DEFAULT 0,
  `cupon` tinyint(4) DEFAULT 0,
  `presentacion` tinyint(4) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `settingplantilla`
--

CREATE TABLE `settingplantilla` (
  `id` int(11) NOT NULL,
  `titulo` varchar(200) DEFAULT NULL,
  `contenido` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `settingplantilla` (`id`, `titulo`, `contenido`, `created_at`, `updated_at`) VALUES
(1, 'Bienvenido a Sinergia Red Internacional', '<p>Bienvenido a Sinergia Red Internacional. Se parte de nuestro negocio.</p>\r\n\r\n<p>&nbsp;@nombre</p>\r\n\r\n<p>@usuario</p>\r\n\r\n<p>@correo</p>\r\n\r\n<p>&nbsp;@clave&nbsp;</p>', '2022-06-23 23:10:02', '2020-07-16 22:05:46'),
(2, 'Pedido Recibido', '<p>Su pedido ha sido recibido satisfactoriamente: Gracias.</p>', '2022-06-23 23:10:02', '2020-07-16 22:18:47'),
(3, 'Compra Carrito', '<p>hola @nombre @correo @fecha @total</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>descripcion @datos</p>', '2022-06-23 23:10:02', '2020-07-16 22:34:27'),
(4, 'Pago Compra', '<p>hola @nombre @correo @fecha @total</p><p>descripcion de la liquidacion @datosbancarios</p>', '2022-06-23 23:10:02', '2020-02-07 22:46:42'),
(5, 'liquidacion', '<p>hola @nombre @correo @fecha @total</p><p>gracias por comprar</p><p>descripcion de la liquidacion @datosbancarios</p>', '2022-06-23 23:10:02', '2019-12-17 00:11:25'),
(6, 'Prueba de prospeccion', '<p>hola @nombrecompleto esto es una prueba @usuario a tu @correo y este es tu patrocinador @idpatrocinio</p>', '2022-06-23 23:10:02', '2020-02-07 22:47:53'),
(7, 'Nuevo usuario Registrado', '<h5>&nbsp;</h5>\r\n\r\n<p><strong>Nuevo Usuario registrado.</strong></p>\r\n\r\n<p>&nbsp;<strong>Nombre Y apellido:</strong>&nbsp;@nombre</p>\r\n\r\n<p><strong>&nbsp;Usuario:</strong>&nbsp;@usuario</p>\r\n\r\n<p><strong>Email:</strong>&nbsp;@correo</p>\r\n\r\n<p><strong>Contrase&ntilde;a:&nbsp;</strong>@clave</p>\r\n\r\n<p><strong>El id de su Patrocinador:</strong>&nbsp;@idpatrocinio</p>\r\n\r\n<p>&nbsp;<strong>Bienvenido a Aprendemlm</strong></p>', '2022-06-23 23:10:02', '2020-09-24 14:34:30'),
(8, 'Nueva Compra realizada', '<h5>&nbsp;</h5>\r\n\r\n<p><strong>Nueva compra realizada</strong></p>\r\n\r\n<p><strong>Nombre Y apellido:</strong>&nbsp;@nombre&nbsp;</p>\r\n\r\n<p><strong>Email:</strong>&nbsp;@correo&nbsp;</p>\r\n\r\n<p><strong>&nbsp;Detalle de la Compra:</strong>&nbsp;@datos&nbsp;</p>\r\n\r\n<p>&nbsp;<strong>Fecha de la compra:</strong>&nbsp;@fecha&nbsp;</p>\r\n\r\n<p><strong>Monto Pagado</strong>: @total</p>\r\n\r\n<p><strong>&nbsp;GRACIAS POR SU COMPRA</strong></p>', '2022-06-23 23:10:02', '2020-09-24 14:34:51'),
(9, 'Nueva Compra aprobada', '<h5>&nbsp;</h5>\r\n\r\n<p><strong>Compra Aprobada Exitosamente</strong></p>\r\n\r\n<p><strong>Nombre y apellido:&nbsp;</strong>@nombre&nbsp;</p>\r\n\r\n<p><strong>Email:&nbsp;</strong>@correo&nbsp;</p>\r\n\r\n<p><strong>Detalle comprado:</strong>&nbsp;@datos&nbsp;</p>\r\n\r\n<p><strong>Fecha del pago de la compra:</strong>&nbsp;@fecha&nbsp;</p>\r\n\r\n<p><strong>Monto aprobado:</strong>&nbsp;@total</p>\r\n\r\n<p>&nbsp;<strong>Ahora empieza a Ganar con nuestro sistema de negocio</strong></p>\r\n\r\n<p><strong>TE recordamos los pagos se realizaran en un periodo de 5 dias habiles</strong></p>', '2022-06-23 23:10:02', '2020-09-24 14:35:16'),
(10, 'Nueva liquidacion generada', '<h5>&nbsp;</h5>\r\n\r\n<p><strong>Nueva Liquidaci&oacute;n Registrada</strong></p>\r\n\r\n<p>&nbsp;<strong>Fecha de Liquidaci&oacute;n</strong>: @fecha</p>\r\n\r\n<p>&nbsp;<strong>Monto Pagado</strong>: @total</p>\r\n\r\n<p><strong>&nbsp;Tu pago se realizara a los 5 d&iacute;as habiles de tu corte</strong></p>', '2022-06-23 23:10:02', '2020-09-24 14:35:38');

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

--
-- Estructura de tabla para la tabla `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL DEFAULT 'AIO System',
  `referred_id_default` int(11) NOT NULL DEFAULT 1,
  `edad_minino` int(11) NOT NULL COMMENT 'edad minimo para ingresar al sistema',
  `licencia` text DEFAULT NULL,
  `fecha_vencimiento` text DEFAULT NULL,
  `tipo_licencia` int(11) NOT NULL DEFAULT 0,
  `prefijo_wp` varchar(191) DEFAULT NULL,
  `id_no_comision` text DEFAULT NULL,
  `activarBotones` text DEFAULT NULL COMMENT 'permite activar los botones de transferencia, retiro, pago total y pago masivo',
  `activarCorreos` longtext DEFAULT NULL COMMENT 'permite activar los 4 correos pago, compra, compra de pago, liquidacion',
  `firma` longtext DEFAULT NULL,
  `limitar` int(11) NOT NULL DEFAULT 0,
  `traductor` int(11) DEFAULT 0,
  `recarga` int(11) NOT NULL DEFAULT 0,
  `defender` int(11) NOT NULL DEFAULT 0 COMMENT '0 - inactivo 1 - activo',
  `canje` int(11) NOT NULL DEFAULT 0,
  `total_canje` double DEFAULT NULL,
  `estilo` int(11) DEFAULT 1,
  `posicionamiento` int(11) NOT NULL DEFAULT 0,
  `login` int(11) NOT NULL DEFAULT 1,
  `registro` int(11) NOT NULL DEFAULT 1,
  `correonotificacion` text DEFAULT NULL,
  `recaptcha` int(11) NOT NULL DEFAULT 0,
  `liquidaciontipo` int(11) NOT NULL DEFAULT 0,
  `fechacorte` date DEFAULT NULL,
  `liquidacioninicio` date DEFAULT NULL,
  `liquidacionfin` date DEFAULT NULL,
  `productos_home` int(11) NOT NULL DEFAULT 0 COMMENT '0 - no se aceptan productos en el home 1 - si se aceptan productos en el home',
  `idcupon` int(11) DEFAULT NULL,
  `footer` text DEFAULT NULL,
  `tipo_descuento` int(11) NOT NULL DEFAULT 1,
  `porcentaje_descuento` decimal(65,2) NOT NULL DEFAULT 0.50,
  `uso_descuento` int(11) NOT NULL DEFAULT 2,
  `mantenimiento` int(11) NOT NULL DEFAULT 0,
  `whatsap` text DEFAULT NULL,
  `tiny` int(11) NOT NULL DEFAULT 0,
  `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 `settingsestructura`
--

CREATE TABLE `settingsestructura` (
  `id` int(11) NOT NULL,
  `tipoestructura` varchar(50) NOT NULL,
  `cantnivel` int(11) NOT NULL,
  `cantfilas` int(11) DEFAULT NULL,
  `estructuraprincipal` tinyint(1) DEFAULT NULL COMMENT '1: arbol - 2: matriz',
  `usuarioprincipal` tinyint(1) DEFAULT NULL COMMENT '1: admin - 2:user',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `settingspuntos`
--

CREATE TABLE `settingspuntos` (
  `id` int(11) NOT NULL,
  `configuracion` text NOT NULL,
  `valor` varchar(250) NOT NULL,
  `tipopuntos` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `setttingsroles`
--

CREATE TABLE `setttingsroles` (
  `id` int(11) NOT NULL,
  `rangos` int(11) NOT NULL,
  `compras` tinyint(1) DEFAULT 0,
  `comisiones` tinyint(1) DEFAULT 0,
  `niveles` tinyint(1) DEFAULT 0,
  `referidos` tinyint(1) DEFAULT 0,
  `referidosact` tinyint(1) DEFAULT 0,
  `referidosd` tinyint(1) DEFAULT 0,
  `referidosInd` tinyint(1) DEFAULT 0,
  `grupal` tinyint(1) DEFAULT 0 COMMENT 'puntos grupales',
  `valorpuntos` float DEFAULT NULL,
  `bonos` tinyint(1) DEFAULT 0,
  `rolnecesario` tinyint(1) DEFAULT 0,
  `reseteomensual` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `solicitudes`
--

CREATE TABLE `solicitudes` (
  `id` int(11) NOT NULL,
  `iduser` int(11) DEFAULT NULL,
  `total` decimal(65,2) NOT NULL DEFAULT 0.00,
  `datos` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`datos`)),
  `fecha` date DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `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 `support_material`
--

CREATE TABLE `support_material` (
  `id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(20) NOT NULL COMMENT 'Archivo o Link',
  `material` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `tablaposiciones`
--

CREATE TABLE `tablaposiciones` (
  `id` int(11) NOT NULL,
  `iduser` text NOT NULL,
  `display_name` text NOT NULL,
  `referred_id` text NOT NULL,
  `sponsor_id` text NOT NULL,
  `position_id` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `tickets`
--

CREATE TABLE `tickets` (
  `id` int(10) UNSIGNED NOT NULL,
  `titulo` varchar(100) NOT NULL,
  `comentario` longtext NOT NULL,
  `tipo` longtext DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `admin` int(11) NOT NULL,
  `archivo` varchar(250) DEFAULT NULL,
  `status` varchar(191) NOT 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;

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

--
-- Estructura de tabla para la tabla `tienda`
--

CREATE TABLE `tienda` (
  `id` int(11) NOT NULL,
  `idproducto` int(11) NOT NULL,
  `orden` int(11) NOT NULL DEFAULT 0,
  `precio` decimal(65,2) NOT NULL DEFAULT 0.00,
  `corta` text DEFAULT NULL,
  `detalles` 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 `tiendacomentarios`
--

CREATE TABLE `tiendacomentarios` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idproducto` int(11) DEFAULT NULL,
  `comentario` 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 `urlcapt`
--

CREATE TABLE `urlcapt` (
  `id` int(11) NOT NULL,
  `url` text DEFAULT NULL,
  `imagen` text DEFAULT NULL,
  `whatsap` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `users2`
--

CREATE TABLE `users2` (
  `ID` int(10) UNSIGNED NOT NULL,
  `birthdate` date DEFAULT NULL,
  `gender` char(1) DEFAULT NULL,
  `user_login` varchar(60) NOT NULL DEFAULT '',
  `user_pass` varchar(255) NOT NULL DEFAULT '',
  `user_nicename` varchar(50) NOT NULL DEFAULT '',
  `user_email` varchar(100) NOT NULL DEFAULT '',
  `user_url` varchar(100) NOT NULL DEFAULT '',
  `user_registered` datetime DEFAULT NULL,
  `user_activation_key` varchar(255) NOT NULL DEFAULT '',
  `user_status` int(11) NOT NULL DEFAULT 0,
  `display_name` varchar(250) NOT NULL DEFAULT '',
  `password` varchar(191) DEFAULT NULL,
  `avatar` varchar(191) DEFAULT 'fondo.png',
  `fondo` varchar(250) NOT NULL DEFAULT '4.jpg',
  `provider` varchar(20) DEFAULT NULL,
  `provider_id` varchar(191) DEFAULT NULL,
  `access_token` varchar(191) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `referred_id` int(11) DEFAULT 0,
  `sponsor_id` bigint(20) DEFAULT 0,
  `position_id` int(11) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `rol_id` int(11) NOT NULL DEFAULT 1,
  `wallet_amount` decimal(65,2) NOT NULL DEFAULT 0.00,
  `billetera` decimal(65,2) NOT NULL DEFAULT 0.00,
  `bank_amount` decimal(65,2) NOT NULL DEFAULT 0.00,
  `clave` varchar(255) DEFAULT NULL,
  `activacion` tinyint(1) DEFAULT 0,
  `fecha_activacion` datetime DEFAULT NULL,
  `token_correo` varchar(200) DEFAULT NULL,
  `tipouser` varchar(200) DEFAULT 'Normal',
  `ladomatriz` char(1) DEFAULT NULL,
  `puntosPro` decimal(65,2) DEFAULT 0.00,
  `puntosRed` decimal(65,2) DEFAULT 0.00,
  `puntosDer` decimal(65,2) DEFAULT 0.00,
  `puntosIzq` decimal(65,2) DEFAULT 0.00,
  `debiDer` decimal(65,2) DEFAULT 0.00,
  `debiIzq` decimal(65,2) DEFAULT 0.00,
  `binario` date DEFAULT NULL,
  `codigo` varchar(250) NOT NULL DEFAULT '0',
  `correos` longtext DEFAULT NULL,
  `limitar` int(11) NOT NULL DEFAULT 1,
  `pop_up` int(11) NOT NULL DEFAULT 0,
  `autenticacion` text DEFAULT NULL,
  `factor2` text DEFAULT NULL,
  `fechaver` date DEFAULT NULL,
  `modo_oscuro` int(11) NOT NULL DEFAULT 0,
  `bono_patrocinador` int(11) NOT NULL DEFAULT 0,
  `activar` date DEFAULT NULL,
  `desactivar` date DEFAULT NULL,
  `bloqueo` int(11) NOT NULL DEFAULT 0,
  `pin` text DEFAULT NULL,
  `codigo_usado` int(11) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `user_campo`
--

CREATE TABLE `user_campo` (
  `ID` bigint(20) NOT NULL,
  `firstname` text DEFAULT NULL,
  `lastname` text DEFAULT NULL,
  `genero` text DEFAULT NULL,
  `edad` date DEFAULT NULL,
  `nameuser` text DEFAULT NULL,
  `direccion` text DEFAULT NULL,
  `document` text DEFAULT NULL,
  `direccion2` text DEFAULT NULL,
  `departamento` text DEFAULT NULL,
  `estado` text DEFAULT NULL,
  `ciudad` text DEFAULT NULL,
  `codigo` text DEFAULT NULL,
  `phone` text DEFAULT NULL,
  `fijo` text DEFAULT NULL,
  `facebook` text DEFAULT NULL,
  `twitter` text DEFAULT NULL,
  `instagram` text DEFAULT NULL,
  `youtube` text DEFAULT NULL,
  `linkedin` text DEFAULT NULL,
  `banco` text DEFAULT NULL,
  `tipocuenta` text DEFAULT NULL,
  `titular` text DEFAULT NULL,
  `documento_identidad_titular` text DEFAULT NULL,
  `cuenta` text DEFAULT NULL,
  `swift` text DEFAULT NULL,
  `pan` text DEFAULT NULL,
  `paypal` text DEFAULT NULL,
  `blocktrail` text DEFAULT NULL,
  `blockchain` text DEFAULT NULL,
  `bitgo` text DEFAULT NULL,
  `pais` text DEFAULT NULL,
  `idpais` int(11) DEFAULT 1,
  `pago` text DEFAULT NULL,
  `btc` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `videollamadas`
--

CREATE TABLE `videollamadas` (
  `id` int(11) NOT NULL,
  `tituloboton` text NOT NULL,
  `acepto` int(11) NOT NULL DEFAULT 0,
  `codigo` longtext NOT NULL,
  `nombre_modal` text DEFAULT NULL,
  `url` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Estructura de tabla para la tabla `walletlog`
--

CREATE TABLE `walletlog` (
  `id` int(11) NOT NULL,
  `iduser` int(11) NOT NULL,
  `idcomision` text NOT NULL,
  `usuario` text NOT NULL,
  `descripcion` text NOT NULL,
  `debito` decimal(65,2) NOT NULL DEFAULT 0.00,
  `credito` decimal(65,2) NOT NULL DEFAULT 0.00,
  `balance` decimal(65,2) NOT NULL DEFAULT 0.00,
  `descuento` decimal(65,2) NOT NULL DEFAULT 0.00,
  `tipotransacion` tinyint(4) NOT NULL COMMENT '0 - transferencia, 1 - retiros, 2 - comisiones,  3 - liquidaciones 4 - recarga billetera',
  `date` date DEFAULT NULL,
  `nivel` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Índices para tablas volcadas
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `colonias`
--
ALTER TABLE `colonias`
  ADD PRIMARY KEY (`id`),
  ADD KEY `index_municipio` (`municipio`) USING BTREE,
  ADD KEY `index_nombre` (`nombre`) USING BTREE,
  ADD KEY `index_asentamiento` (`asentamiento`) USING BTREE,
  ADD KEY `index_codigo_postal` (`codigo_postal`) USING BTREE,
  ADD KEY `index_ciudad` (`ciudad`) USING BTREE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `estados`
--
ALTER TABLE `estados`
  ADD PRIMARY KEY (`id`),
  ADD KEY `index_pais` (`pais`) USING BTREE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `municipios`
--
ALTER TABLE `municipios`
  ADD PRIMARY KEY (`id`),
  ADD KEY `index_estado` (`estado`) USING BTREE;

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `users2`
--
ALTER TABLE `users2`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `rol_id` (`rol_id`);

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

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

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `academiatienda`
--
ALTER TABLE `academiatienda`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `anuncios`
--
ALTER TABLE `anuncios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `archivos`
--
ALTER TABLE `archivos`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `asignacioncupon`
--
ALTER TABLE `asignacioncupon`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `atributosfotos`
--
ALTER TABLE `atributosfotos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `avatares`
--
ALTER TABLE `avatares`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `banneracademia`
--
ALTER TABLE `banneracademia`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `binario`
--
ALTER TABLE `binario`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `bonosettings`
--
ALTER TABLE `bonosettings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `calendarios`
--
ALTER TABLE `calendarios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `canjes`
--
ALTER TABLE `canjes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `capital`
--
ALTER TABLE `capital`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `carritos`
--
ALTER TABLE `carritos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `categoria`
--
ALTER TABLE `categoria`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `categorias`
--
ALTER TABLE `categorias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `chats`
--
ALTER TABLE `chats`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `codigo`
--
ALTER TABLE `codigo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `colonias`
--
ALTER TABLE `colonias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1607710190;

--
-- AUTO_INCREMENT de la tabla `comentarioacademia`
--
ALTER TABLE `comentarioacademia`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `comentarios`
--
ALTER TABLE `comentarios`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT de la tabla `component`
--
ALTER TABLE `component`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `compradirectas`
--
ALTER TABLE `compradirectas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `configuracioninicio`
--
ALTER TABLE `configuracioninicio`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `consultacrypto`
--
ALTER TABLE `consultacrypto`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `contenidos`
--
ALTER TABLE `contenidos`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `costo`
--
ALTER TABLE `costo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `courses`
--
ALTER TABLE `courses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `cupon`
--
ALTER TABLE `cupon`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `defender`
--
ALTER TABLE `defender`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `departamento`
--
ALTER TABLE `departamento`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `descuento`
--
ALTER TABLE `descuento`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `estados`
--
ALTER TABLE `estados`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT de la tabla `evaluation`
--
ALTER TABLE `evaluation`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `examenes`
--
ALTER TABLE `examenes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `firma`
--
ALTER TABLE `firma`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `formulario`
--
ALTER TABLE `formulario`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT de la tabla `historias`
--
ALTER TABLE `historias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `informacionbancaria`
--
ALTER TABLE `informacionbancaria`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `inicio`
--
ALTER TABLE `inicio`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `inventario`
--
ALTER TABLE `inventario`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `ip`
--
ALTER TABLE `ip`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `iva`
--
ALTER TABLE `iva`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `lessons`
--
ALTER TABLE `lessons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `megusta`
--
ALTER TABLE `megusta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `monedas`
--
ALTER TABLE `monedas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `municipios`
--
ALTER TABLE `municipios`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32059;

--
-- AUTO_INCREMENT de la tabla `notificacion_tickets`
--
ALTER TABLE `notificacion_tickets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `onsignal`
--
ALTER TABLE `onsignal`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `opciones_select`
--
ALTER TABLE `opciones_select`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;

--
-- AUTO_INCREMENT de la tabla `optioncarritos`
--
ALTER TABLE `optioncarritos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT de la tabla `pagocarritos`
--
ALTER TABLE `pagocarritos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `pagos`
--
ALTER TABLE `pagos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `paises`
--
ALTER TABLE `paises`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247;

--
-- AUTO_INCREMENT de la tabla `perfilproductos`
--
ALTER TABLE `perfilproductos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT de la tabla `pop`
--
ALTER TABLE `pop`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `presentacion`
--
ALTER TABLE `presentacion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `prospeccion`
--
ALTER TABLE `prospeccion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `pruebas`
--
ALTER TABLE `pruebas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `puntos`
--
ALTER TABLE `puntos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `puntosbonos`
--
ALTER TABLE `puntosbonos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `puntosred`
--
ALTER TABLE `puntosred`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `redes_sociales`
--
ALTER TABLE `redes_sociales`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT de la tabla `reporteinventario`
--
ALTER TABLE `reporteinventario`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `represado`
--
ALTER TABLE `represado`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `seguridad`
--
ALTER TABLE `seguridad`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `semiautobinario`
--
ALTER TABLE `semiautobinario`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `sesions`
--
ALTER TABLE `sesions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingactivacion`
--
ALTER TABLE `settingactivacion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingcliente`
--
ALTER TABLE `settingcliente`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingcomision`
--
ALTER TABLE `settingcomision`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingpagos`
--
ALTER TABLE `settingpagos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingpermiso`
--
ALTER TABLE `settingpermiso`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingplantilla`
--
ALTER TABLE `settingplantilla`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT de la tabla `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingsestructura`
--
ALTER TABLE `settingsestructura`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `settingspuntos`
--
ALTER TABLE `settingspuntos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `setttingsroles`
--
ALTER TABLE `setttingsroles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `solicitudes`
--
ALTER TABLE `solicitudes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `support_material`
--
ALTER TABLE `support_material`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tablaposiciones`
--
ALTER TABLE `tablaposiciones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tickets`
--
ALTER TABLE `tickets`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tienda`
--
ALTER TABLE `tienda`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tiendacomentarios`
--
ALTER TABLE `tiendacomentarios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `urlcapt`
--
ALTER TABLE `urlcapt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `users2`
--
ALTER TABLE `users2`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT de la tabla `videollamadas`
--
ALTER TABLE `videollamadas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `walletlog`
--
ALTER TABLE `walletlog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `colonias`
--
ALTER TABLE `colonias`
  ADD CONSTRAINT `fk_municipio` FOREIGN KEY (`municipio`) REFERENCES `municipios` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `municipios`
--
ALTER TABLE `municipios`
  ADD CONSTRAINT `fk_estado` FOREIGN KEY (`estado`) REFERENCES `estados` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
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 */;
