-- 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', '
', 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', 'Bienvenido a Sinergia Red Internacional. Se parte de nuestro negocio.
\r\n\r\n @nombre
\r\n\r\n@usuario
\r\n\r\n@correo
\r\n\r\n @clave
', '2022-06-23 23:10:02', '2020-07-16 22:05:46'),
(2, 'Pedido Recibido', 'Su pedido ha sido recibido satisfactoriamente: Gracias.
', '2022-06-23 23:10:02', '2020-07-16 22:18:47'),
(3, 'Compra Carrito', 'hola @nombre @correo @fecha @total
\r\n\r\n
\r\n\r\ndescripcion @datos
', '2022-06-23 23:10:02', '2020-07-16 22:34:27'),
(4, 'Pago Compra', 'hola @nombre @correo @fecha @total
descripcion de la liquidacion @datosbancarios
', '2022-06-23 23:10:02', '2020-02-07 22:46:42'),
(5, 'liquidacion', 'hola @nombre @correo @fecha @total
gracias por comprar
descripcion de la liquidacion @datosbancarios
', '2022-06-23 23:10:02', '2019-12-17 00:11:25'),
(6, 'Prueba de prospeccion', 'hola @nombrecompleto esto es una prueba @usuario a tu @correo y este es tu patrocinador @idpatrocinio
', '2022-06-23 23:10:02', '2020-02-07 22:47:53'),
(7, 'Nuevo usuario Registrado', '
\r\n\r\nNuevo Usuario registrado.
\r\n\r\n Nombre Y apellido: @nombre
\r\n\r\n Usuario: @usuario
\r\n\r\nEmail: @correo
\r\n\r\nContraseña: @clave
\r\n\r\nEl id de su Patrocinador: @idpatrocinio
\r\n\r\n Bienvenido a Aprendemlm
', '2022-06-23 23:10:02', '2020-09-24 14:34:30'),
(8, 'Nueva Compra realizada', '
\r\n\r\nNueva compra realizada
\r\n\r\nNombre Y apellido: @nombre
\r\n\r\nEmail: @correo
\r\n\r\n Detalle de la Compra: @datos
\r\n\r\n Fecha de la compra: @fecha
\r\n\r\nMonto Pagado: @total
\r\n\r\n GRACIAS POR SU COMPRA
', '2022-06-23 23:10:02', '2020-09-24 14:34:51'),
(9, 'Nueva Compra aprobada', '
\r\n\r\nCompra Aprobada Exitosamente
\r\n\r\nNombre y apellido: @nombre
\r\n\r\nEmail: @correo
\r\n\r\nDetalle comprado: @datos
\r\n\r\nFecha del pago de la compra: @fecha
\r\n\r\nMonto aprobado: @total
\r\n\r\n Ahora empieza a Ganar con nuestro sistema de negocio
\r\n\r\nTE recordamos los pagos se realizaran en un periodo de 5 dias habiles
', '2022-06-23 23:10:02', '2020-09-24 14:35:16'),
(10, 'Nueva liquidacion generada', '
\r\n\r\nNueva Liquidación Registrada
\r\n\r\n Fecha de Liquidación: @fecha
\r\n\r\n Monto Pagado: @total
\r\n\r\n Tu pago se realizara a los 5 días habiles de tu corte
', '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 */;