-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `plex-panel`
--

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

--
-- Table structure for table `credits`
--

CREATE TABLE `credits` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `qty` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_parent_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `plex_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `plex_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plex_user_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invited_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration_id` bigint UNSIGNED NOT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `server_id` int NOT NULL,
  `screens` int NOT NULL DEFAULT '4',
  `proxy_id` int DEFAULT NULL,
  `pin` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telegram_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `observation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `package_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `data_rows`
--

CREATE TABLE `data_rows` (
  `id` int UNSIGNED NOT NULL,
  `data_type_id` int UNSIGNED NOT NULL,
  `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `browse` tinyint(1) NOT NULL DEFAULT '1',
  `read` tinyint(1) NOT NULL DEFAULT '1',
  `edit` tinyint(1) NOT NULL DEFAULT '1',
  `add` tinyint(1) NOT NULL DEFAULT '1',
  `delete` tinyint(1) NOT NULL DEFAULT '1',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `order` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `data_rows`
--

INSERT INTO `data_rows` (`id`, `data_type_id`, `field`, `type`, `display_name`, `required`, `browse`, `read`, `edit`, `add`, `delete`, `details`, `order`) VALUES
(1, 1, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, '{}', 1),
(2, 1, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, '{}', 2),
(3, 1, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, '{}', 3),
(4, 1, 'password', 'password', 'Password', 1, 0, 0, 1, 1, 0, '{}', 4),
(5, 1, 'remember_token', 'text', 'Remember Token', 0, 0, 0, 0, 0, 0, '{}', 5),
(6, 1, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, '{}', 6),
(7, 1, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 8),
(8, 1, 'avatar', 'image', 'Avatar', 0, 1, 1, 1, 1, 1, '{}', 9),
(9, 1, 'user_belongsto_role_relationship', 'relationship', 'Role', 1, 1, 1, 1, 1, 0, '{\"scope\":\"filterrole\",\"model\":\"App\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":\"0\",\"taggable\":\"0\"}', 11),
(10, 1, 'user_belongstomany_role_relationship', 'relationship', 'Roles', 0, 0, 0, 0, 0, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}', 12),
(11, 1, 'settings', 'hidden', 'Settings', 0, 0, 0, 0, 0, 0, '{}', 14),
(12, 2, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(13, 2, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(14, 2, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(15, 2, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(16, 3, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, '{}', 1),
(17, 3, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, '{}', 2),
(18, 3, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, '{}', 3),
(19, 3, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 4),
(20, 3, 'display_name', 'text', 'Display Name', 1, 1, 1, 1, 1, 1, '{}', 5),
(21, 1, 'role_id', 'text', 'Role', 0, 1, 1, 1, 1, 1, '{}', 10),
(22, 4, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(23, 4, 'user_id', 'text', 'User Id', 1, 1, 1, 1, 1, 1, '{}', 3),
(24, 4, 'qty', 'text', 'Cantidad', 1, 1, 1, 1, 1, 1, '{}', 4),
(25, 4, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, '{}', 5),
(26, 4, 'updated_at', 'timestamp', 'Updated At', 0, 1, 1, 0, 0, 0, '{}', 6),
(27, 4, 'credit_hasone_user_relationship', 'relationship', 'Vendedor', 1, 1, 1, 1, 1, 1, '{\"scope\":\"user\",\"model\":\"App\\\\Models\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 2),
(28, 5, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(29, 5, 'name', 'text', 'Nombre', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 2),
(30, 5, 'months', 'text', 'Cantidad de Meses', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 3),
(31, 5, 'created_at', 'timestamp', 'Creado', 0, 1, 1, 0, 0, 0, '{}', 7),
(32, 5, 'updated_at', 'timestamp', 'Actualizado', 0, 1, 1, 0, 0, 0, '{}', 8),
(33, 6, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(34, 6, 'user_id', 'text', 'User Id', 1, 0, 0, 0, 0, 0, '{}', 2),
(35, 6, 'name', 'text', 'Nombre', 0, 1, 1, 1, 1, 1, '{}', 5),
(36, 6, 'phone', 'text', 'Telefono', 0, 0, 1, 1, 1, 1, '{}', 7),
(37, 6, 'email', 'text', 'Correo', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required|email|unique:customers\",\"messages\":{\"required\":\"The email field is required\",\"email\":\"The email must be a valid email address\",\"unique\":\"Ya este correo existe registrado, por favor ingrese otro\"}}}', 8),
(38, 6, 'password', 'text', 'Clave', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required|min:10|regex:\\/^(?=.*[a-z])(?=.*[A-Z])(?=.*\\\\d)(?=.*[^a-zA-Z\\\\d]).+$\\/\",\"messages\":{\"required\":\"The :attribute field is required.\",\"min\":\"The :attribute must be at least :min characters.\",\"regex\":\"The :attribute must contain at least one lowercase letter, one uppercase letter, and one number.\"}}}', 9),
(39, 6, 'status', 'select_dropdown', 'Estatus', 1, 1, 1, 1, 0, 1, '{\"default\":\"active\",\"options\":{\"active\":\"Activo\",\"inactive\":\"Inactivo\"}}', 13),
(40, 6, 'plex_user_id', 'text', 'Plex User Id', 0, 0, 0, 0, 0, 0, '{}', 14),
(41, 6, 'created_at', 'timestamp', 'Creado', 0, 0, 1, 0, 0, 0, '{}', 18),
(42, 6, 'updated_at', 'timestamp', 'Actualizado', 0, 0, 1, 0, 0, 0, '{}', 22),
(43, 1, 'email_verified_at', 'timestamp', 'Email Verified At', 0, 0, 0, 0, 0, 0, '{}', 7),
(44, 1, 'total_credits', 'text', 'Creditos Totales', 1, 1, 1, 0, 0, 0, '{}', 13),
(45, 1, 'status', 'select_dropdown', 'Estado', 1, 1, 1, 1, 1, 1, '{\"default\":\"active\",\"options\":{\"active\":\"Activo\",\"inactive\":\"Inactivo\"}}', 15),
(58, 6, 'plex_user_name', 'text', 'Plex User Name', 0, 1, 1, 0, 0, 0, '{}', 15),
(59, 6, 'plex_user_token', 'text', 'Plex User Token', 0, 0, 1, 0, 0, 0, '{}', 16),
(60, 6, 'invited_id', 'text', 'Invited Id', 0, 0, 1, 0, 0, 0, '{}', 17),
(61, 6, 'customer_belongsto_duration_relationship', 'relationship', 'Duracion', 1, 1, 1, 1, 1, 1, '{\"scope\":\"onlyplex\",\"model\":\"App\\\\Models\\\\Duration\",\"table\":\"durations\",\"type\":\"belongsTo\",\"column\":\"duration_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 10),
(62, 6, 'duration_id', 'text', 'Duration Id', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 6),
(63, 6, 'date_from', 'date', 'Fecha Desde', 0, 0, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 11),
(64, 6, 'date_to', 'date', 'Fecha Hasta', 0, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 12),
(65, 8, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(66, 8, 'name', 'text', 'Nombre', 1, 1, 1, 0, 0, 1, '{}', 5),
(67, 8, 'url', 'text', 'Username or Email', 1, 1, 1, 1, 1, 1, '{}', 2),
(68, 8, 'token', 'text', 'Password', 1, 0, 1, 1, 1, 1, '{}', 3),
(69, 8, 'is_demo', 'checkbox', 'Es Demo', 1, 1, 1, 1, 1, 1, '{\"on\":\"Si\",\"off\":\"No\",\"checked\":false}', 6),
(70, 8, 'status', 'checkbox', 'Estado', 1, 1, 1, 1, 1, 1, '{\"on\":\"Activo\",\"off\":\"Inactivo\",\"checked\":true}', 7),
(71, 8, 'created_at', 'timestamp', 'Creado', 0, 1, 1, 0, 0, 0, '{}', 8),
(72, 8, 'updated_at', 'timestamp', 'Actualizado', 0, 1, 1, 0, 0, 0, '{}', 9),
(73, 6, 'customer_belongsto_server_relationship', 'relationship', 'Servidor', 1, 1, 1, 1, 1, 1, '{\"scope\":\"Server\",\"model\":\"App\\\\Models\\\\Server\",\"table\":\"servers\",\"type\":\"belongsTo\",\"column\":\"server_id\",\"key\":\"id\",\"label\":\"name_and_local_name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 3),
(74, 6, 'server_id', 'text', 'Server Id', 1, 0, 1, 1, 1, 0, '{}', 20),
(75, 9, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(76, 9, 'server_id', 'text', 'Server Id', 1, 1, 1, 1, 1, 1, '{}', 2),
(77, 9, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required|email|unique:demos\",\"messages\":{\"required\":\"Este Campo es Obligatorio\",\"email\":\"Ingresa un Correo Valido\",\"unique\":\"El correo ya exste en los Demos\"}}}', 3),
(78, 9, 'password', 'text', 'Clave', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required|min:10|regex:\\/^(?=.*[a-z])(?=.*[A-Z])(?=.*\\\\d)(?=.*[^a-zA-Z\\\\d]).+$\\/\",\"messages\":{\"required\":\"The :attribute field is required.\",\"min\":\"The :attribute must be at least :min characters.\",\"regex\":\"The :attribute must contain at least one lowercase letter, one uppercase letter, and one number.\"}}}', 4),
(79, 9, 'hours', 'select_dropdown', 'Horas', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}},\"default\":\"4\",\"options\":{\"4\":\"4\",\"5\":\"5\",\"6\":\"6\"}}', 7),
(80, 9, 'start_date', 'text', 'Fecha Desde', 1, 0, 1, 0, 0, 0, '{}', 8),
(81, 9, 'end_date', 'text', 'Fecha Hasta', 1, 1, 1, 0, 0, 0, '{}', 9),
(82, 9, 'created_at', 'timestamp', 'Creado', 0, 0, 0, 0, 0, 0, '{}', 10),
(83, 9, 'updated_at', 'timestamp', 'Actualizado', 0, 0, 0, 0, 0, 0, '{}', 12),
(84, 9, 'demo_belongsto_server_relationship', 'relationship', 'Servidor', 1, 1, 1, 1, 1, 1, '{\"scope\":\"serverdemo\",\"model\":\"App\\\\Models\\\\Server\",\"table\":\"servers\",\"type\":\"belongsTo\",\"column\":\"server_id\",\"key\":\"id\",\"label\":\"name_and_local_name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 5),
(85, 9, 'plex_user_name', 'text', 'Plex User Name', 0, 1, 1, 0, 0, 0, '{}', 11),
(86, 9, 'invited_id', 'text', 'Invited Id', 0, 0, 1, 0, 0, 0, '{}', 13),
(87, 9, 'plex_user_token', 'text', 'Plex User Token', 0, 0, 1, 0, 0, 0, '{}', 14),
(88, 8, 'accounts_count', 'text', 'Cantidad de Cuentas (Plex)', 0, 1, 1, 1, 1, 0, '{}', 10),
(89, 9, 'user_id', 'text', 'User Id', 0, 0, 0, 0, 0, 0, '{}', 15),
(90, 1, 'parent_user_id', 'text', 'Parent User Id', 0, 0, 0, 0, 0, 0, '{}', 17),
(91, 4, 'user_parent_id', 'text', 'User Parent Id', 0, 0, 0, 0, 0, 0, '{}', 6),
(92, 4, 'credit_belongsto_user_relationship', 'relationship', 'Usuario Padre', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Models\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_parent_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 7),
(93, 6, 'customer_belongsto_user_relationship', 'relationship', 'Creador', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Models\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name_email_creator\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 23),
(94, 8, 'user_id', 'text', 'User Id', 0, 0, 0, 0, 0, 0, '{}', 11),
(95, 1, 'user_belongsto_user_relationship', 'relationship', 'Usuario Creador', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Models\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"parent_user_id\",\"key\":\"id\",\"label\":\"name_email_creator\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 16),
(96, 8, 'limit_accounts', 'number', 'Cantidad Limite de Cuentas', 0, 1, 1, 1, 1, 1, '{}', 12),
(97, 1, 'user_belongstomany_server_relationship', 'relationship', 'Servidores Asigandos', 0, 1, 1, 1, 1, 1, '{\"scope\":\"Server\",\"model\":\"App\\\\Models\\\\Server\",\"table\":\"servers\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"user_servers\",\"pivot\":\"1\",\"taggable\":\"0\"}', 18),
(98, 6, 'screens', 'select_dropdown', 'Pantallas', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}},\"default\":\"4\",\"options\":{\"1\":\"1\",\"2\":\"2\",\"3\":\"3\",\"4\":\"4\"}}', 19),
(99, 11, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(100, 11, 'name', 'text', 'Nombre', 1, 1, 1, 1, 1, 1, '{\"validations\":{\"rules\":\"required\",\"messages\":{\"required\":\"Este campo es Requerido\"}}}', 2),
(101, 11, 'type', 'select_dropdown', 'Valido Para', 1, 1, 1, 1, 1, 1, '{\"default\":\"all\",\"options\":{\"all\":\"Ambos\",\"account\":\"Cuenta\",\"demo\":\"Demo\"},\"validations\":{\"rules\":\"required\",\"messages\":{\"required\":\"Este campo es obligatorio!!\"}}}', 3),
(102, 11, 'created_at', 'timestamp', 'Creado', 0, 1, 0, 0, 0, 0, '{}', 4),
(103, 11, 'updated_at', 'timestamp', 'Actualizado', 0, 0, 1, 0, 0, 0, '{}', 5),
(104, 13, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(105, 13, 'ip', 'text', 'Ip', 1, 1, 1, 1, 1, 1, '{\"validations\":{\"rules\":\"required\",\"messages\":{\"required\":\"Este campo es Requerido\"}}}', 2),
(106, 13, 'port', 'text', 'Puerto', 1, 1, 1, 1, 1, 1, '{\"validations\":{\"rules\":\"required\",\"messages\":{\"required\":\"Este campo es Requerido\"}}}', 3),
(107, 13, 'created_at', 'timestamp', 'Creado', 0, 1, 0, 0, 0, 0, '{}', 4),
(108, 13, 'updated_at', 'timestamp', 'Actualizado', 0, 0, 1, 0, 0, 0, '{}', 5),
(109, 6, 'customer_belongsto_proxy_relationship', 'relationship', 'Direccion Ip', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Models\\\\Proxy\",\"table\":\"proxies\",\"type\":\"belongsTo\",\"column\":\"proxy_id\",\"key\":\"id\",\"label\":\"ip\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 25),
(110, 6, 'proxy_id', 'text', 'Proxy Id', 0, 0, 0, 0, 0, 0, '{}', 21),
(111, 6, 'pin', 'text', 'Pin', 0, 1, 1, 0, 0, 0, '{}', 24),
(112, 8, 'is_plex_pass', 'checkbox', 'Con Plex Pass', 1, 1, 1, 1, 1, 1, '{\"on\":\"Si\",\"off\":\"No\",\"checked\":false}', 13),
(113, 8, 'local_name', 'text', 'Nombre Local', 0, 1, 1, 1, 1, 1, '{}', 4),
(114, 5, 'amount', 'number', 'Monto en Creditos', 0, 1, 1, 1, 1, 1, '{}', 6),
(115, 6, 'telegram_user_name', 'text', 'Nombre de Usuario en Telegram', 0, 0, 0, 0, 0, 0, '{}', 26),
(116, 14, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(117, 14, 'server_id', 'text', 'Servidor', 1, 1, 1, 1, 1, 1, '{}', 3),
(118, 14, 'name', 'text', 'Nombre', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rules\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 2),
(119, 14, 'libraries', 'text', 'Libraries', 1, 0, 0, 1, 1, 0, '{}', 5),
(120, 14, 'created_at', 'timestamp', 'Creado', 0, 1, 1, 0, 0, 0, '{}', 6),
(121, 14, 'updated_at', 'timestamp', 'Actualizado', 0, 1, 1, 0, 0, 0, '{}', 7),
(122, 14, 'package_belongsto_server_relationship', 'relationship', 'Servidor', 1, 1, 1, 1, 1, 1, '{\"scope\":\"server\",\"model\":\"App\\\\Models\\\\Server\",\"table\":\"servers\",\"type\":\"belongsTo\",\"column\":\"server_id\",\"key\":\"id\",\"label\":\"name_and_local_name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 4),
(124, 6, 'observation', 'text', 'Observation', 0, 0, 0, 0, 0, 0, '{}', 27),
(125, 6, 'package_id', 'select_dropdown', 'Paquetes', 0, 1, 1, 1, 1, 0, '{}', 4),
(126, 9, 'package_id', 'select_dropdown', 'Paquete', 0, 1, 1, 1, 1, 1, '{}', 6),
(127, 5, 'service', 'select_dropdown', 'Servicio', 1, 1, 1, 1, 1, 1, '{\"default\":\"plex\",\"options\":{\"plex\":\"Plex\"}}', 4),
(128, 17, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(129, 17, 'name', 'text', 'Nombre', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 2),
(130, 17, 'host', 'text', 'Host', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 3),
(131, 17, 'port', 'text', 'Puerto', 0, 1, 1, 1, 1, 1, '{}', 4),
(132, 17, 'api_key', 'text', 'Api Key', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}}}', 5),
(133, 17, 'created_at', 'timestamp', 'Creado', 0, 1, 1, 0, 0, 0, '{}', 6),
(134, 17, 'updated_at', 'timestamp', 'Actualziado', 0, 0, 1, 0, 0, 0, '{}', 7),
(135, 18, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(136, 18, 'name', 'text', 'Nombre', 1, 1, 1, 1, 1, 1, '{\"validatios\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este campo es obligatorio\"}}}', 3),
(137, 18, 'jellyfinserver_id', 'text', 'Jellyfinserver Id', 1, 1, 1, 1, 1, 1, '{}', 2),
(138, 18, 'libraries', 'select_dropdown', 'Librerias', 1, 0, 0, 1, 1, 1, '{\"validatios\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este campo es obligatorio\"}}}', 5),
(139, 18, 'created_at', 'timestamp', 'Creado', 0, 1, 1, 0, 0, 0, '{}', 6),
(140, 18, 'updated_at', 'timestamp', 'Actualizado', 0, 0, 0, 0, 0, 0, '{}', 7),
(141, 18, 'jellyfinpackage_belongsto_jellyfinserver_relationship', 'relationship', 'Servidor', 1, 1, 1, 1, 1, 1, '{\"model\":\"App\\\\Models\\\\JellyfinServer\",\"table\":\"jellyfinservers\",\"type\":\"belongsTo\",\"column\":\"jellyfinserver_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 4),
(142, 19, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(143, 19, 'jellyfinserver_id', 'text', 'Jellyfinserver Id', 1, 1, 1, 1, 1, 1, '{}', 2),
(144, 19, 'duration_id', 'text', 'Duration Id', 1, 1, 1, 1, 1, 1, '{}', 6),
(145, 19, 'jellyfinpackage_id', 'select_dropdown', 'Paquete', 0, 1, 1, 1, 1, 1, '{}', 4),
(146, 19, 'name', 'text', 'Nombre de Usuario', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required|unique:jellyfincustomers\",\"messages\":{\"required\":\"Campo Obligatorio\",\"unique\":\"este mombre de usuario ya existe!!\"}}}', 7),
(147, 19, 'email', 'text', 'Email', 0, 1, 1, 1, 1, 1, '{\"validations\":{\"rule\":\"email\",\"messages\":{\"email\":\"Debes escribir el correo correctamente\"}}}', 9),
(148, 19, 'password', 'text', 'Password', 1, 0, 1, 1, 1, 1, '{\"validations\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este campo es obligatorio\"}}}', 8),
(149, 19, 'phone', 'text', 'Telefono', 0, 0, 1, 1, 1, 1, '{}', 10),
(150, 19, 'comment', 'text_area', 'Comentario', 0, 1, 1, 1, 1, 0, '{}', 13),
(151, 19, 'date_to', 'date', 'Fecha Hasta', 1, 1, 1, 1, 1, 1, '{\"validations\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este campo es obligatorio\"}}}', 12),
(152, 19, 'created_at', 'timestamp', 'Creado', 0, 1, 1, 0, 0, 0, '{}', 17),
(153, 19, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 18),
(154, 19, 'jellyfincustomer_belongsto_jellyfinserver_relationship', 'relationship', 'Servidor', 1, 1, 1, 1, 1, 1, '{\"scope\":\"bystatus\",\"model\":\"App\\\\Models\\\\JellyfinServer\",\"table\":\"jellyfinservers\",\"type\":\"belongsTo\",\"column\":\"jellyfinserver_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 3),
(155, 19, 'jellyfincustomer_belongsto_duration_relationship', 'relationship', 'Duracion', 1, 1, 1, 1, 1, 1, '{\"scope\":\"onlyjelly\",\"model\":\"App\\\\Models\\\\Duration\",\"table\":\"durations\",\"type\":\"belongsTo\",\"column\":\"duration_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 5),
(156, 20, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(157, 20, 'jellyfinserver_id', 'text', 'Jellyfinserver Id', 1, 1, 1, 1, 1, 1, '{}', 2),
(159, 20, 'jellyfinpackage_id', 'select_dropdown', 'Paquete', 0, 1, 1, 1, 1, 1, '{}', 4),
(160, 20, 'name', 'text', 'Nombre de Usuario', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required|unique:jellyfindemos\",\"messages\":{\"required\":\"Campo Obligatorio\",\"unique\":\"este mombre de usuario ya existe!!\"}}}', 5),
(161, 20, 'email', 'text', 'Email', 0, 1, 1, 1, 1, 1, '{\"validations\":{\"rule\":\"email\",\"messages\":{\"email\":\"Ingresa un correo valido\"}}}', 7),
(162, 20, 'password', 'text', 'Password', 1, 0, 1, 1, 1, 1, '{\"validations\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este campo es Requerido\"}}}', 6),
(165, 20, 'date_to', 'date', 'Fecha Hasta', 1, 1, 1, 0, 0, 0, '{\"validations\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este campo es Requerido\"}}}', 9),
(166, 20, 'user_id', 'text', 'User Id', 1, 0, 0, 0, 0, 0, '{}', 10),
(167, 20, 'created_at', 'timestamp', 'Creado', 0, 1, 1, 0, 0, 0, '{}', 12),
(168, 20, 'updated_at', 'timestamp', 'Updated At', 0, 0, 1, 0, 0, 0, '{}', 14),
(169, 20, 'hours', 'select_dropdown', 'Horas', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}},\"default\":\"4\",\"options\":{\"4\":\"4\",\"5\":\"5\",\"6\":\"6\"}}', 8),
(170, 20, 'jellyfindemo_belongsto_jellyfinserver_relationship', 'relationship', 'Servidor', 1, 1, 1, 1, 1, 1, '{\"scope\":\"bystatus\",\"model\":\"App\\\\Models\\\\JellyfinServer\",\"table\":\"jellyfinservers\",\"type\":\"belongsTo\",\"column\":\"jellyfinserver_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 3),
(171, 19, 'user_id', 'text', 'User Id', 1, 0, 0, 0, 0, 0, '{}', 14),
(172, 19, 'screens', 'select_dropdown', 'Pantallas', 1, 1, 1, 1, 1, 1, '{\"validation\":{\"rule\":\"required\",\"messages\":{\"required\":\"Este Campo es Obligatorio\"}},\"default\":\"4\",\"options\":{\"1\":\"1\",\"2\":\"2\",\"3\":\"3\",\"4\":\"4\"}}', 11),
(173, 19, 'json_data', 'text', 'Json Data', 0, 0, 1, 0, 0, 0, '{}', 19),
(175, 20, 'json_data', 'text', 'Json Data', 0, 0, 1, 0, 0, 0, '{}', 13),
(176, 5, 'screens', 'text', 'Pantallas', 0, 1, 1, 1, 1, 1, '{}', 5),
(177, 17, 'status', 'checkbox', 'Estatus', 1, 1, 1, 1, 1, 1, '{\"on\":\"Activo\",\"off\":\"Inactivo\",\"checked\":true}', 8),
(178, 19, 'status', 'checkbox', 'Estatus', 1, 1, 1, 0, 0, 0, '{\"on\":\"Activo\",\"off\":\"Inactivo\",\"checked\":true}', 15),
(179, 19, 'jellyfincustomer_belongsto_user_relationship', 'relationship', 'Creador', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Models\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name_email_creator\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 16),
(180, 20, 'jellyfindemo_belongsto_user_relationship', 'relationship', 'Creador', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Models\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name_email_creator\",\"pivot_table\":\"credits\",\"pivot\":\"0\",\"taggable\":\"0\"}', 11);

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

--
-- Table structure for table `data_types`
--

CREATE TABLE `data_types` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
  `server_side` tinyint NOT NULL DEFAULT '0',
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `data_types`
--

INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES
(1, 'users', 'users', 'User', 'Users', 'voyager-person', 'App\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', 'App\\Http\\Controllers\\Voyager\\UserController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"desc\",\"default_search_key\":null,\"scope\":\"user\"}', '2023-07-30 22:59:57', '2024-04-15 21:11:04'),
(2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'App\\Models\\Role', NULL, 'TCG\\Voyager\\Http\\Controllers\\VoyagerRoleController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"desc\",\"default_search_key\":null,\"scope\":null}', '2023-07-30 22:59:57', '2023-09-12 16:38:47'),
(4, 'credits', 'credits', 'Credito', 'Creditos', 'voyager-dollar', 'App\\Models\\Credit', NULL, 'App\\Http\\Controllers\\Voyager\\CreditController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":\"byUser\"}', '2023-07-31 00:03:14', '2023-09-12 18:58:11'),
(5, 'durations', 'durations', 'Duracion', 'Duraciones', 'voyager-alarm-clock', 'App\\Models\\Duration', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2023-07-31 00:11:11', '2024-10-08 16:24:19'),
(6, 'customers', 'customers', 'Cliente', 'Clientes', 'voyager-people', 'App\\Models\\Customer', NULL, 'App\\Http\\Controllers\\Voyager\\CustomerController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":\"byUser\"}', '2023-07-31 00:13:46', '2024-06-20 02:34:27'),
(8, 'servers', 'servers', 'Servidor', 'Servidores', 'voyager-laptop', 'App\\Models\\Server', NULL, 'App\\Http\\Controllers\\Voyager\\ServerController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":\"serverByUser\"}', '2023-08-12 18:21:43', '2023-11-13 19:38:51'),
(9, 'demos', 'demos', 'Cuenta Demo', 'Cuentas Demos', 'voyager-bell', 'App\\Models\\Demo', NULL, 'App\\Http\\Controllers\\Voyager\\DemoController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":\"byUser\"}', '2023-09-01 16:46:11', '2024-02-19 19:24:09'),
(11, 'domains', 'domains', 'Dominio', 'Dominios', 'voyager-font', 'App\\Models\\Domain', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2023-11-04 19:03:42', '2023-11-04 20:07:43'),
(13, 'proxies', 'proxies', 'Proxy', 'Proxys', 'voyager-window-list', 'App\\Models\\Proxy', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2023-11-04 19:05:14', '2023-11-04 20:07:51'),
(14, 'packages', 'packages', 'Paquete', 'Paquetes', 'voyager-logbook', 'App\\Models\\Package', NULL, 'App\\Http\\Controllers\\Voyager\\PackageController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":\"byUser\"}', '2024-02-05 13:24:03', '2024-04-15 21:02:39'),
(17, 'jellyfinservers', 'jellyfinservers', 'Servidor JellyFin', 'Servidores JellyFin', 'voyager-laptop', 'App\\Models\\JellyfinServer', NULL, 'App\\Http\\Controllers\\Voyager\\JellyfinServerController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2024-02-19 17:49:30', '2024-08-29 14:13:33'),
(18, 'jellyfinpackages', 'jellyfinpackages', 'Paquete JellyFin', 'Paquetes Jellyfin', 'voyager-logbook', 'App\\Models\\JellyfinPackage', NULL, 'App\\Http\\Controllers\\Voyager\\JellyfinPackageController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2024-02-19 18:30:36', '2024-02-20 13:30:06'),
(19, 'jellyfincustomers', 'jellyfincustomers', 'Cliente Jellyfin', 'Clientes Jellyfin', 'voyager-people', 'App\\Models\\JellyfinCustomer', NULL, 'App\\Http\\Controllers\\Voyager\\JellyfinCustomerController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":\"byUser\"}', '2024-02-19 18:50:50', '2024-09-25 20:24:19'),
(20, 'jellyfindemos', 'jellyfindemos', 'Demo Jellyfin', 'Demos Jellyfin', 'voyager-bell', 'App\\Models\\JellyfinDemo', NULL, 'App\\Http\\Controllers\\Voyager\\JellyfinDemoController', NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":\"byUser\"}', '2024-02-19 19:12:45', '2024-09-25 20:24:51');

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

--
-- Table structure for table `demos`
--

CREATE TABLE `demos` (
  `id` bigint UNSIGNED NOT NULL,
  `server_id` bigint UNSIGNED NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hours` int NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `plex_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invited_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plex_user_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `package_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `domains`
--

CREATE TABLE `domains` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('account','demo','all') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `domains`
--

INSERT INTO `domains` (`id`, `name`, `type`, `created_at`, `updated_at`) VALUES
(16, 'gmail.com', 'all', '2023-12-06 18:54:25', '2023-12-06 18:54:25'),
(17, 'hotmail.com', 'all', '2023-12-06 18:54:30', '2023-12-06 18:54:30'),
(18, 'outlook.com', 'all', '2024-03-11 20:23:22', '2024-03-11 20:23:22'),
(19, 'yahoo.com', 'all', '2024-03-11 20:23:30', '2024-03-11 20:23:30');

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

--
-- Table structure for table `durations`
--

CREATE TABLE `durations` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `months` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `amount` int DEFAULT NULL,
  `service` enum('plex','jellyfin','emby','all') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'all',
  `screens` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `durations`
--

INSERT INTO `durations` (`id`, `name`, `months`, `created_at`, `updated_at`, `amount`, `service`, `screens`) VALUES
(2, '1 Mes', 1, '2023-07-31 01:51:15', '2024-10-08 16:25:09', NULL, 'plex', NULL),
(3, '2 Meses', 2, '2023-07-31 23:14:00', '2024-10-08 16:25:05', NULL, 'plex', NULL),
(4, '3 Meses', 3, '2023-08-08 15:51:27', '2024-10-08 16:25:01', NULL, 'plex', NULL),
(5, '4 Meses', 4, '2023-08-08 15:51:33', '2024-10-08 16:24:59', NULL, 'plex', NULL),
(6, '5 Meses', 5, '2023-08-08 15:51:41', '2024-10-08 16:24:56', NULL, 'plex', NULL),
(7, '6 Meses', 6, '2023-08-08 15:51:47', '2024-10-08 16:24:53', NULL, 'plex', NULL),
(8, '7 Meses', 7, '2023-08-08 15:51:56', '2024-10-08 16:24:50', NULL, 'plex', NULL),
(9, '8 Meses', 8, '2023-08-08 15:52:02', '2024-10-08 16:24:47', NULL, 'plex', NULL),
(10, '9 Meses', 9, '2023-08-08 15:52:11', '2024-10-08 16:24:44', NULL, 'plex', NULL),
(11, '10 Meses', 10, '2023-08-08 15:52:22', '2024-10-08 16:24:41', NULL, 'plex', NULL),
(12, '11 Meses', 11, '2023-08-08 15:52:29', '2024-10-08 16:24:38', NULL, 'plex', NULL),
(13, '12 Meses', 12, '2023-08-08 15:52:36', '2024-10-08 16:24:35', NULL, 'plex', NULL);

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

--
-- Table structure for table `failed_jobs`
--

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

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

--
-- Table structure for table `jellyfincustomers`
--

CREATE TABLE `jellyfincustomers` (
  `id` bigint UNSIGNED NOT NULL,
  `jellyfinserver_id` int NOT NULL,
  `duration_id` int NOT NULL,
  `jellyfinpackage_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date_to` date NOT NULL,
  `user_id` int NOT NULL,
  `screens` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `json_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jellyfindemos`
--

CREATE TABLE `jellyfindemos` (
  `id` bigint UNSIGNED NOT NULL,
  `jellyfinserver_id` int NOT NULL,
  `jellyfinpackage_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hours` int NOT NULL,
  `date_to` datetime NOT NULL,
  `user_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `json_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jellyfinpackages`
--

CREATE TABLE `jellyfinpackages` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `jellyfinserver_id` bigint UNSIGNED NOT NULL,
  `libraries` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jellyfinservers`
--

CREATE TABLE `jellyfinservers` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `api_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2023-07-30 22:59:57', '2023-07-30 22:59:57');

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

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int UNSIGNED NOT NULL,
  `menu_id` int UNSIGNED DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `icon_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int DEFAULT NULL,
  `order` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `route` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES
(1, 1, 'Dashboard', '', '_self', 'voyager-boat', '#60e2d9', NULL, 1, '2023-07-30 22:59:57', '2024-03-09 01:33:08', 'voyager.dashboard', 'null'),
(2, 1, 'Media', '', '_self', 'voyager-images', NULL, NULL, 12, '2023-07-30 22:59:57', '2024-10-08 16:23:36', 'voyager.media.index', NULL),
(3, 1, 'Revendedores', '', '_self', 'voyager-person', '#43a7e5', NULL, 9, '2023-07-30 22:59:57', '2024-10-08 16:23:36', 'voyager.users.index', 'null'),
(4, 1, 'Roles', '', '_self', 'voyager-lock', NULL, NULL, 11, '2023-07-30 22:59:57', '2024-10-08 16:23:36', 'voyager.roles.index', NULL),
(5, 1, 'Tools', '', '_self', 'voyager-tools', NULL, NULL, 13, '2023-07-30 22:59:57', '2024-10-08 16:23:36', NULL, NULL),
(6, 1, 'Menu Builder', '', '_self', 'voyager-list', NULL, 5, 1, '2023-07-30 22:59:57', '2023-07-31 00:11:52', 'voyager.menus.index', NULL),
(7, 1, 'Database', '', '_self', 'voyager-data', NULL, 5, 2, '2023-07-30 22:59:57', '2023-07-31 00:11:52', 'voyager.database.index', NULL),
(8, 1, 'Compass', '', '_self', 'voyager-compass', NULL, 5, 3, '2023-07-30 22:59:57', '2023-07-31 00:11:52', 'voyager.compass.index', NULL),
(9, 1, 'BREAD', '', '_self', 'voyager-bread', NULL, 5, 4, '2023-07-30 22:59:57', '2023-07-31 00:11:52', 'voyager.bread.index', NULL),
(10, 1, 'Settings', '', '_self', 'voyager-settings', NULL, NULL, 14, '2023-07-30 22:59:57', '2024-10-08 16:23:36', 'voyager.settings.index', NULL),
(11, 1, 'Creditos', '', '_self', 'voyager-dollar', '#39be09', NULL, 10, '2023-07-31 00:03:14', '2024-10-08 16:23:36', 'voyager.credits.index', 'null'),
(12, 1, 'Duraciones', '', '_self', 'voyager-alarm-clock', '#f4870b', NULL, 17, '2023-07-31 00:11:11', '2024-10-08 16:23:36', 'voyager.durations.index', 'null'),
(13, 1, 'Lista de Clientes', '', '_self', 'voyager-people', '#e8d46d', NULL, 4, '2023-07-31 00:13:46', '2024-10-08 16:23:36', 'voyager.customers.index', 'null'),
(15, 1, 'Servidores', '', '_self', 'voyager-laptop', '#e8d46d', NULL, 7, '2023-08-12 18:21:43', '2024-10-08 16:23:36', 'voyager.servers.index', 'null'),
(16, 1, 'Demos Activas', '', '_self', 'voyager-bell', '#e8d46d', NULL, 6, '2023-09-01 16:46:11', '2024-10-08 16:23:36', 'voyager.demos.index', 'null'),
(17, 1, 'Dominios', '', '_self', 'voyager-font', '#a9f39b', NULL, 15, '2023-11-04 19:03:42', '2024-10-08 16:23:36', 'voyager.domains.index', 'null'),
(18, 1, 'Proxys', '', '_self', 'voyager-window-list', '#5f70ec', NULL, 16, '2023-11-04 19:05:14', '2024-10-08 16:23:36', 'voyager.proxies.index', 'null'),
(19, 1, 'Paquetes', '', '_self', 'voyager-logbook', '#e8d46d', NULL, 8, '2024-02-05 13:24:04', '2024-10-08 16:23:36', 'voyager.packages.index', 'null'),
(22, 1, 'Servidores JellyFin', '', '_self', 'voyager-laptop', '#8012ed', 21, 5, '2024-02-19 17:49:30', '2024-03-09 01:29:17', 'voyager.jellyfinservers.index', 'null'),
(23, 1, 'Paquetes Jellyfin', '', '_self', 'voyager-logbook', '#8012ed', 21, 6, '2024-02-19 18:30:36', '2024-03-09 01:29:17', 'voyager.jellyfinpackages.index', 'null'),
(24, 1, 'Lista de Clientes', '', '_self', 'voyager-people', '#8012ed', 21, 2, '2024-02-19 18:50:50', '2024-03-09 01:28:17', 'voyager.jellyfincustomers.index', 'null'),
(25, 1, 'Demos Activas', '', '_self', 'voyager-bell', '#8012ed', 21, 4, '2024-02-19 19:12:45', '2024-03-09 01:29:17', 'voyager.jellyfindemos.index', 'null'),
(26, 1, 'Nuevo Cliente', '', '_self', 'voyager-new', '#e8d46d', NULL, 3, '2024-03-09 01:23:14', '2024-10-08 16:23:36', 'voyager.customers.create', 'null'),
(27, 1, 'Nueva Demo', '', '_self', 'voyager-new', '#e8d46d', NULL, 5, '2024-03-09 01:25:06', '2024-10-08 16:23:36', 'voyager.demos.create', 'null'),
(28, 1, 'Nuevo Cliente', '', '_self', 'voyager-new', '#8012ed', 21, 1, '2024-03-09 01:27:30', '2024-03-09 01:28:07', 'voyager.jellyfincustomers.create', 'null'),
(29, 1, 'Nueva Demo', '', '_self', 'voyager-new', '#7612ed', 21, 3, '2024-03-09 01:29:10', '2024-03-09 01:29:17', 'voyager.jellyfindemos.create', NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_01_000000_add_voyager_user_fields', 1),
(4, '2016_01_01_000000_create_data_types_table', 1),
(5, '2016_05_19_173453_create_menu_table', 1),
(6, '2016_10_21_190000_create_roles_table', 1),
(7, '2016_10_21_190000_create_settings_table', 1),
(8, '2016_11_30_135954_create_permission_table', 1),
(9, '2016_11_30_141208_create_permission_role_table', 1),
(10, '2016_12_26_201236_data_types__add__server_side', 1),
(11, '2017_01_13_000000_add_route_to_menu_items_table', 1),
(12, '2017_01_14_005015_create_translations_table', 1),
(13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1),
(14, '2017_03_06_000000_add_controller_to_data_types_table', 1),
(15, '2017_04_21_000000_add_order_to_data_rows_table', 1),
(16, '2017_07_05_210000_add_policyname_to_data_types_table', 1),
(17, '2017_08_05_000000_add_group_to_settings_table', 1),
(18, '2017_11_26_013050_add_user_role_relationship', 1),
(19, '2017_11_26_015000_create_user_roles_table', 1),
(20, '2018_03_11_000000_add_user_settings', 1),
(21, '2018_03_14_000000_add_details_to_data_types_table', 1),
(22, '2018_03_16_000000_make_settings_value_nullable', 1),
(23, '2019_08_19_000000_create_failed_jobs_table', 1),
(24, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(25, '2023_07_30_194702_add_fields_in_user_table', 2),
(26, '2023_07_30_194744_create_credits_table', 2),
(27, '2023_07_30_194804_create_durations_table', 2),
(28, '2023_07_30_194821_create_customers_table', 2),
(29, '2023_07_30_194840_create_purchases_table', 2),
(30, '2023_07_30_220328_add_field_in_customers_table', 3),
(31, '2023_08_07_142516_add_user_name_and_token_in_customers_table', 4),
(32, '2023_08_07_153907_add_invited_id_field_in_customer', 5),
(33, '2023_08_07_203238_add_more_fields_in_customers_table', 6),
(34, '2023_08_12_131539_create_servers_table', 7),
(35, '2023_08_12_141720_add_server_id_in_customer_table', 8),
(37, '2023_09_01_123502_create_demos_table', 9),
(38, '2023_08_30_144103_add_accounts_count_field_in_server_table', 10),
(39, '2023_09_01_160405_add_fields_in_demos_table', 11),
(40, '2023_09_05_185418_add_user_id_in_demos_table', 12),
(41, '2023_09_12_125655_add_parent_user_field_in_users_table', 13),
(42, '2023_09_12_144707_add_user_id_field_in_credits_table', 14),
(43, '2023_10_02_071119_add_user_id_in_servers_table', 15),
(44, '2023_10_22_175246_add_limit_accounts_field_in_servers_table', 16),
(45, '2023_10_22_184424_create_table_user_servers', 17),
(46, '2023_10_22_201807_add_screens_field_in_customer_table', 18),
(48, '2023_10_22_205120_create_sessions_table', 19),
(49, '2023_11_03_154855_add_ip_field_in_customers_table', 20),
(50, '2023_11_03_155852_add_ip_field_in_demos_table', 21),
(51, '2023_11_04_103429_create_proxies_table', 22),
(52, '2023_11_04_103442_create_domains_table', 22),
(53, '2023_11_04_145547_add_domain_id_field_in_customers_table', 22),
(54, '2023_11_04_160303_add_proxy_id_field_in_customers_table', 23),
(55, '2023_11_06_174624_add_is_plex_pass_field_in_servers_table', 24),
(56, '2023_11_06_174650_add_pin_field_in_csutomers_table', 24),
(57, '2023_11_09_191754_add_local_name_field_in_servers_table', 25),
(58, '2023_11_09_192328_remove_nullable_false_in_name_in_customers_table', 26),
(59, '2023_11_24_151416_create_server_libraries_table', 27),
(60, '2023_12_06_085225_create_movements_table', 28),
(61, '2023_12_06_125617_create_movements_table', 29),
(62, '2023_12_06_140020_add_server_field_in_movements_table', 29),
(63, '2023_12_08_100443_add_amount_field_in_durations_table', 30),
(64, '2024_01_08_141501_add_telegram_user_name_field_in_customers_table', 31),
(65, '2024_01_08_151823_add_library_secion_for_remove_field_in_servers_table', 31),
(66, '2024_02_04_095603_add_observation_field_in_customers_table', 32),
(67, '2024_02_05_090600_create_packages_table', 33),
(68, '2024_02_05_091651_add_package_id_field_in_customerstable', 33),
(69, '2024_02_05_140417_add_package_id_field_in_demos_table', 34),
(70, '2024_02_19_132424_create_jellyfin_servers_table', 35),
(71, '2024_02_19_134156_add_type_service_field_in_durations_table', 36),
(72, '2024_02_19_141906_create_jellyfin_packages', 37),
(79, '2024_02_19_143945_create_jellyfin_customers_table', 38),
(80, '2024_02_19_150958_craete_jellyfin_demos_table', 38),
(82, '2024_02_20_095851_add_json_data_field_in_jellyfin_customers_table', 39),
(83, '2024_02_20_155802_add_json_data_field_in_jellyfin_demos_table', 40),
(84, '2024_02_28_201848_add_last_update_token_field_in_servers_table', 41),
(85, '2024_02_28_202218_add_json_data_field_in_servers_table', 42),
(86, '2024_04_15_183416_add_parent_user_id_field_in_movements_table', 43),
(87, '2024_05_20_155059_add_screen_field_in_durations_table', 44),
(88, '2024_08_29_101053_add_status_field_in_jellyfin_servers_table', 45),
(89, '2024_08_29_101805_add_status_field_in_jellyfin_customers_table', 46);

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

--
-- Table structure for table `movements`
--

CREATE TABLE `movements` (
  `id` bigint UNSIGNED NOT NULL,
  `user` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `credits` int NOT NULL,
  `movement_time` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `server` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_user_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint UNSIGNED NOT NULL,
  `server_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `libraries` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `password_resets`
--

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

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint UNSIGNED NOT NULL,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES
(1, 'browse_admin', NULL, '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(2, 'browse_bread', NULL, '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(3, 'browse_database', NULL, '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(4, 'browse_media', NULL, '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(5, 'browse_compass', NULL, '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(6, 'browse_menus', 'menus', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(7, 'read_menus', 'menus', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(8, 'edit_menus', 'menus', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(9, 'add_menus', 'menus', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(10, 'delete_menus', 'menus', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(11, 'browse_roles', 'roles', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(12, 'read_roles', 'roles', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(13, 'edit_roles', 'roles', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(14, 'add_roles', 'roles', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(15, 'delete_roles', 'roles', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(16, 'browse_users', 'users', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(17, 'read_users', 'users', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(18, 'edit_users', 'users', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(19, 'add_users', 'users', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(20, 'delete_users', 'users', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(21, 'browse_settings', 'settings', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(22, 'read_settings', 'settings', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(23, 'edit_settings', 'settings', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(24, 'add_settings', 'settings', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(25, 'delete_settings', 'settings', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(26, 'browse_credits', 'credits', '2023-07-31 00:03:14', '2023-07-31 00:03:14'),
(27, 'read_credits', 'credits', '2023-07-31 00:03:14', '2023-07-31 00:03:14'),
(28, 'edit_credits', 'credits', '2023-07-31 00:03:14', '2023-07-31 00:03:14'),
(29, 'add_credits', 'credits', '2023-07-31 00:03:14', '2023-07-31 00:03:14'),
(30, 'delete_credits', 'credits', '2023-07-31 00:03:14', '2023-07-31 00:03:14'),
(31, 'browse_durations', 'durations', '2023-07-31 00:11:11', '2023-07-31 00:11:11'),
(32, 'read_durations', 'durations', '2023-07-31 00:11:11', '2023-07-31 00:11:11'),
(33, 'edit_durations', 'durations', '2023-07-31 00:11:11', '2023-07-31 00:11:11'),
(34, 'add_durations', 'durations', '2023-07-31 00:11:11', '2023-07-31 00:11:11'),
(35, 'delete_durations', 'durations', '2023-07-31 00:11:11', '2023-07-31 00:11:11'),
(36, 'browse_customers', 'customers', '2023-07-31 00:13:46', '2023-07-31 00:13:46'),
(37, 'read_customers', 'customers', '2023-07-31 00:13:46', '2023-07-31 00:13:46'),
(38, 'edit_customers', 'customers', '2023-07-31 00:13:46', '2023-07-31 00:13:46'),
(39, 'add_customers', 'customers', '2023-07-31 00:13:46', '2023-07-31 00:13:46'),
(40, 'delete_customers', 'customers', '2023-07-31 00:13:46', '2023-07-31 00:13:46'),
(46, 'browse_servers', 'servers', '2023-08-12 18:21:43', '2023-08-12 18:21:43'),
(47, 'read_servers', 'servers', '2023-08-12 18:21:43', '2023-08-12 18:21:43'),
(48, 'edit_servers', 'servers', '2023-08-12 18:21:43', '2023-08-12 18:21:43'),
(49, 'add_servers', 'servers', '2023-08-12 18:21:43', '2023-08-12 18:21:43'),
(50, 'delete_servers', 'servers', '2023-08-12 18:21:43', '2023-08-12 18:21:43'),
(51, 'browse_demos', 'demos', '2023-09-01 16:46:11', '2023-09-01 16:46:11'),
(52, 'read_demos', 'demos', '2023-09-01 16:46:11', '2023-09-01 16:46:11'),
(53, 'edit_demos', 'demos', '2023-09-01 16:46:11', '2023-09-01 16:46:11'),
(54, 'add_demos', 'demos', '2023-09-01 16:46:11', '2023-09-01 16:46:11'),
(55, 'delete_demos', 'demos', '2023-09-01 16:46:11', '2023-09-01 16:46:11'),
(56, 'browse_domains', 'domains', '2023-11-04 19:03:42', '2023-11-04 19:03:42'),
(57, 'read_domains', 'domains', '2023-11-04 19:03:42', '2023-11-04 19:03:42'),
(58, 'edit_domains', 'domains', '2023-11-04 19:03:42', '2023-11-04 19:03:42'),
(59, 'add_domains', 'domains', '2023-11-04 19:03:42', '2023-11-04 19:03:42'),
(60, 'delete_domains', 'domains', '2023-11-04 19:03:42', '2023-11-04 19:03:42'),
(61, 'browse_proxies', 'proxies', '2023-11-04 19:05:14', '2023-11-04 19:05:14'),
(62, 'read_proxies', 'proxies', '2023-11-04 19:05:14', '2023-11-04 19:05:14'),
(63, 'edit_proxies', 'proxies', '2023-11-04 19:05:14', '2023-11-04 19:05:14'),
(64, 'add_proxies', 'proxies', '2023-11-04 19:05:14', '2023-11-04 19:05:14'),
(65, 'delete_proxies', 'proxies', '2023-11-04 19:05:14', '2023-11-04 19:05:14'),
(66, 'browse_packages', 'packages', '2024-02-05 13:24:03', '2024-02-05 13:24:03'),
(67, 'read_packages', 'packages', '2024-02-05 13:24:03', '2024-02-05 13:24:03'),
(68, 'edit_packages', 'packages', '2024-02-05 13:24:03', '2024-02-05 13:24:03'),
(69, 'add_packages', 'packages', '2024-02-05 13:24:03', '2024-02-05 13:24:03'),
(70, 'delete_packages', 'packages', '2024-02-05 13:24:03', '2024-02-05 13:24:03'),
(71, 'browse_jellyfinservers', 'jellyfinservers', '2024-02-19 17:49:30', '2024-02-19 17:49:30'),
(72, 'read_jellyfinservers', 'jellyfinservers', '2024-02-19 17:49:30', '2024-02-19 17:49:30'),
(73, 'edit_jellyfinservers', 'jellyfinservers', '2024-02-19 17:49:30', '2024-02-19 17:49:30'),
(74, 'add_jellyfinservers', 'jellyfinservers', '2024-02-19 17:49:30', '2024-02-19 17:49:30'),
(75, 'delete_jellyfinservers', 'jellyfinservers', '2024-02-19 17:49:30', '2024-02-19 17:49:30'),
(76, 'browse_jellyfinpackages', 'jellyfinpackages', '2024-02-19 18:30:36', '2024-02-19 18:30:36'),
(77, 'read_jellyfinpackages', 'jellyfinpackages', '2024-02-19 18:30:36', '2024-02-19 18:30:36'),
(78, 'edit_jellyfinpackages', 'jellyfinpackages', '2024-02-19 18:30:36', '2024-02-19 18:30:36'),
(79, 'add_jellyfinpackages', 'jellyfinpackages', '2024-02-19 18:30:36', '2024-02-19 18:30:36'),
(80, 'delete_jellyfinpackages', 'jellyfinpackages', '2024-02-19 18:30:36', '2024-02-19 18:30:36'),
(81, 'browse_jellyfincustomers', 'jellyfincustomers', '2024-02-19 18:50:50', '2024-02-19 18:50:50'),
(82, 'read_jellyfincustomers', 'jellyfincustomers', '2024-02-19 18:50:50', '2024-02-19 18:50:50'),
(83, 'edit_jellyfincustomers', 'jellyfincustomers', '2024-02-19 18:50:50', '2024-02-19 18:50:50'),
(84, 'add_jellyfincustomers', 'jellyfincustomers', '2024-02-19 18:50:50', '2024-02-19 18:50:50'),
(85, 'delete_jellyfincustomers', 'jellyfincustomers', '2024-02-19 18:50:50', '2024-02-19 18:50:50'),
(86, 'browse_jellyfindemos', 'jellyfindemos', '2024-02-19 19:12:45', '2024-02-19 19:12:45'),
(87, 'read_jellyfindemos', 'jellyfindemos', '2024-02-19 19:12:45', '2024-02-19 19:12:45'),
(88, 'edit_jellyfindemos', 'jellyfindemos', '2024-02-19 19:12:45', '2024-02-19 19:12:45'),
(89, 'add_jellyfindemos', 'jellyfindemos', '2024-02-19 19:12:45', '2024-02-19 19:12:45'),
(90, 'delete_jellyfindemos', 'jellyfindemos', '2024-02-19 19:12:45', '2024-02-19 19:12:45');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(16, 3),
(16, 4),
(16, 6),
(17, 1),
(17, 3),
(17, 4),
(17, 6),
(18, 1),
(18, 3),
(18, 4),
(18, 6),
(19, 1),
(19, 3),
(19, 4),
(19, 6),
(20, 1),
(20, 3),
(20, 4),
(20, 6),
(21, 1),
(21, 4),
(22, 1),
(22, 4),
(23, 1),
(23, 4),
(24, 1),
(24, 4),
(25, 1),
(26, 1),
(26, 3),
(26, 4),
(26, 6),
(27, 1),
(27, 3),
(27, 4),
(27, 6),
(28, 1),
(29, 1),
(29, 3),
(29, 4),
(29, 6),
(30, 1),
(31, 1),
(31, 4),
(32, 1),
(32, 4),
(33, 1),
(33, 4),
(34, 1),
(34, 4),
(35, 1),
(36, 1),
(36, 3),
(36, 4),
(36, 5),
(36, 6),
(37, 1),
(37, 3),
(37, 4),
(37, 5),
(37, 6),
(38, 1),
(38, 3),
(38, 4),
(38, 5),
(38, 6),
(39, 1),
(39, 3),
(39, 4),
(39, 5),
(39, 6),
(40, 1),
(40, 4),
(40, 6),
(46, 1),
(46, 4),
(46, 6),
(47, 1),
(47, 4),
(47, 6),
(48, 1),
(48, 4),
(48, 6),
(49, 1),
(49, 4),
(49, 6),
(50, 1),
(50, 4),
(50, 6),
(51, 1),
(51, 3),
(51, 4),
(51, 5),
(51, 6),
(52, 1),
(52, 3),
(52, 4),
(52, 5),
(52, 6),
(53, 1),
(53, 3),
(53, 4),
(53, 5),
(53, 6),
(54, 1),
(54, 3),
(54, 4),
(54, 5),
(54, 6),
(55, 1),
(55, 3),
(55, 4),
(55, 5),
(55, 6),
(56, 1),
(56, 4),
(57, 1),
(57, 4),
(58, 1),
(58, 4),
(59, 1),
(59, 4),
(60, 1),
(60, 4),
(61, 1),
(61, 4),
(62, 1),
(62, 4),
(63, 1),
(63, 4),
(64, 1),
(64, 4),
(65, 1),
(65, 4),
(66, 1),
(66, 4),
(67, 1),
(67, 4),
(68, 1),
(68, 4),
(69, 1),
(69, 4),
(70, 1),
(70, 4),
(71, 1),
(71, 4),
(72, 1),
(72, 4),
(73, 1),
(73, 4),
(74, 1),
(74, 4),
(75, 1),
(75, 4),
(76, 1),
(76, 4),
(77, 1),
(77, 4),
(78, 1),
(78, 4),
(79, 1),
(79, 4),
(80, 1),
(80, 4),
(81, 1),
(81, 3),
(81, 4),
(81, 5),
(82, 1),
(82, 3),
(82, 4),
(82, 5),
(83, 1),
(83, 3),
(83, 4),
(83, 5),
(84, 1),
(84, 3),
(84, 4),
(84, 5),
(85, 1),
(85, 3),
(85, 4),
(85, 5),
(86, 1),
(86, 3),
(86, 4),
(86, 5),
(87, 1),
(87, 3),
(87, 4),
(87, 5),
(88, 1),
(88, 3),
(88, 4),
(88, 5),
(89, 1),
(89, 3),
(89, 4),
(89, 5),
(90, 1),
(90, 3),
(90, 4),
(90, 5);

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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;

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

--
-- Table structure for table `proxies`
--

CREATE TABLE `proxies` (
  `id` bigint UNSIGNED NOT NULL,
  `ip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `port` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator', '2023-07-30 22:59:57', '2023-07-30 22:59:57'),
(3, 'Super Reseller', 'Super Vendedor', '2023-07-31 00:05:24', '2023-09-12 15:50:36'),
(4, 'general_admin', 'Administrador General', '2023-07-31 01:21:27', '2023-07-31 01:21:27'),
(5, 'Reseller', 'Vendedor', '2023-09-12 15:51:06', '2023-09-12 15:51:06'),
(6, 'Limited Admin', 'Administrador Limitado', '2023-10-02 10:56:59', '2023-10-02 10:57:32');

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

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_demo` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `accounts_count` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `limit_accounts` int DEFAULT '0',
  `is_plex_pass` tinyint(1) NOT NULL DEFAULT '0',
  `local_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `library_section_for_remove` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_token_update` datetime DEFAULT NULL,
  `json_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `server_libraries`
--

CREATE TABLE `server_libraries` (
  `id` bigint UNSIGNED NOT NULL,
  `server_id` bigint UNSIGNED NOT NULL,
  `library_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` bigint UNSIGNED NOT NULL,
  `server_id` int NOT NULL,
  `plex_user_id` int NOT NULL,
  `plex_session_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int UNSIGNED NOT NULL,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '1',
  `group` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`) VALUES
(1, 'site.title', 'Site Title', 'Site Title', '', 'text', 1, 'Site'),
(2, 'site.description', 'Site Description', 'Site Description', '', 'text', 2, 'Site'),
(3, 'site.logo', 'Site Logo', '', '', 'image', 3, 'Site'),
(4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', 'https://www.google.com', '', 'text', 4, 'Site'),
(5, 'admin.bg_image', 'Admin Background Image', 'settings/October2024/yA7zGDPQC6JmKsRyIxqc.jpg', '', 'image', 5, 'Admin'),
(6, 'admin.title', 'Admin Title', 'Panel Plex', '', 'text', 1, 'Admin'),
(7, 'admin.description', 'Admin Description', 'Controla de manera optima tus servicios de Plex', '', 'text', 2, 'Admin'),
(8, 'admin.loader', 'Admin Loader', 'settings/October2024/IliSzVqbLAchDjsvsFLR.png', '', 'image', 3, 'Admin'),
(9, 'admin.icon_image', 'Admin Icon Image', 'settings/October2024/VPS6X6sjTPumCbbnfzuW.png', '', 'image', 4, 'Admin'),
(10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', '19455541', '', 'text', 1, 'Admin'),
(13, 'admin.credits_number', 'Whatsapp Para Solicitar Creditos', NULL, NULL, 'text', 8, 'Admin'),
(15, 'admin.dynamic_server', 'Servidor Dinamico', '0', '', 'checkbox', 1, 'Admin'),
(16, 'admin.iphone_for_all', 'Convertir a Iphone Para Todos', '0', '', 'checkbox', 1, 'Admin'),
(17, 'admin.show_only_server_local_name', 'Mostrar solo el nombre local en los servidores', '0', '', 'checkbox', 1, 'Admin'),
(18, 'admin.iphone_only_server', 'Mostrar Servidores Solo Para Convertir a Iphone', '0', '', 'checkbox', 1, 'Admin'),
(19, 'admin.server_for_alls', 'Mostrar Servidores Para Cuentas y Demos', '1', '', 'checkbox', 1, 'Admin'),
(20, 'admin.screen_message', 'Mensaje para mostrar cuando sobre pasen las pantallas Asignadas', NULL, '', 'text', 1, 'Admin'),
(21, 'admin.extra_options_limited', 'Opciones Extras Limitadas', '1', '', 'checkbox', 1, 'Admin'),
(22, 'admin.show_ip_address_all', 'Mostrar Ip Proxy A Todos Roles', '0', '', 'checkbox', 1, 'Admin'),
(23, 'admin.add_account_not_password_for_all', 'Agregar Cuentas Sin Clave Para Todos', '0', '', 'checkbox', 1, 'Admin'),
(24, 'admin.account_expiration_days', 'Dias de aviso, vencimiento de cuenta', '31', '', 'text', 1, 'Admin'),
(25, 'admin.active_proxies', 'Activar Uso de Proxy', '0', '', 'checkbox', 1, 'Admin'),
(26, 'admin.only_remove_libraries', 'Solo remover librerias al momento de quitar el Servicio', '0', '', 'checkbox', 1, 'Admin'),
(27, 'admin.days_of_grace', 'Dias de Gracia', '3', '', 'text', 1, 'Admin'),
(28, 'admin.register_without_password_always', 'Registrar Siempre Sin Clave', '0', '', 'checkbox', 1, 'Admin'),
(29, 'admin.ssl_force', 'Forzar Conexion Https', '0', '', 'checkbox', 1, 'Admin'),
(30, 'admin.limit_the_sessions', 'Limitar las Sessiones', '1', '', 'checkbox', 1, 'Admin'),
(31, 'admin.max_reseller_screen', 'Cantidad Maxima de Pantallas para Revendedores', '2', '', 'text', 1, 'Admin'),
(32, 'admin.onlyemaildomain', 'Generar Solo Nombre de Dominio', '0', '', 'checkbox', 1, 'Admin');

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

--
-- Table structure for table `translations`
--

CREATE TABLE `translations` (
  `id` int UNSIGNED NOT NULL,
  `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int UNSIGNED NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png',
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `settings` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `total_credits` int NOT NULL DEFAULT '0',
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `parent_user_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `email_verified_at`, `password`, `remember_token`, `settings`, `created_at`, `updated_at`, `total_credits`, `status`, `parent_user_id`) VALUES
(33, 1, 'Carlos Vargas', 'admin@gmail.com', 'users/September2024/ZDH6PCWnWYorqrf4AXG1.png', NULL, '$2y$10$M6VpBqtYowC9aA7Nx8iSR.RjbCns1ZGnhMTNXjcJYgTCoonwy9xFW', NULL, NULL, '2023-10-15 23:50:31', '2024-09-18 19:31:00', 0, 'active', 33),
(59, 4, 'administrador', 'administrador@gmail.com', 'users/October2024/GDI6ERsbhhCeS3hJPoh3.webp', NULL, '$2y$10$LwpOV375ds1Jei83BxrUHu/mer7l4U9KqqWinAo9k6Sw6H1oG83Cq', NULL, NULL, '2023-12-23 16:20:21', '2024-10-01 14:43:19', 0, 'active', 33);

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_servers`
--

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

--
-- Indexes for dumped tables
--

--
-- Indexes for table `credits`
--
ALTER TABLE `credits`
  ADD PRIMARY KEY (`id`),
  ADD KEY `credits_user_id_foreign` (`user_id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customers_user_id_foreign` (`user_id`),
  ADD KEY `customers_duration_id_foreign` (`duration_id`);

--
-- Indexes for table `data_rows`
--
ALTER TABLE `data_rows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`);

--
-- Indexes for table `data_types`
--
ALTER TABLE `data_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `data_types_name_unique` (`name`),
  ADD UNIQUE KEY `data_types_slug_unique` (`slug`);

--
-- Indexes for table `demos`
--
ALTER TABLE `demos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `demos_server_id_foreign` (`server_id`);

--
-- Indexes for table `domains`
--
ALTER TABLE `domains`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `durations`
--
ALTER TABLE `durations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jellyfincustomers`
--
ALTER TABLE `jellyfincustomers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jellyfindemos`
--
ALTER TABLE `jellyfindemos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jellyfinpackages`
--
ALTER TABLE `jellyfinpackages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jellyfinpackages_jellyfinserver_id_foreign` (`jellyfinserver_id`);

--
-- Indexes for table `jellyfinservers`
--
ALTER TABLE `jellyfinservers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menus_name_unique` (`name`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_menu_id_foreign` (`menu_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `movements`
--
ALTER TABLE `movements`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `packages_server_id_foreign` (`server_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permissions_key_index` (`key`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Indexes for table `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`);

--
-- Indexes for table `proxies`
--
ALTER TABLE `proxies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Indexes for table `servers`
--
ALTER TABLE `servers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `server_libraries`
--
ALTER TABLE `server_libraries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `server_libraries_server_id_foreign` (`server_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

--
-- Indexes for table `translations`
--
ALTER TABLE `translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_role_id_foreign` (`role_id`);

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `user_roles_user_id_index` (`user_id`),
  ADD KEY `user_roles_role_id_index` (`role_id`);

--
-- Indexes for table `user_servers`
--
ALTER TABLE `user_servers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_servers_server_id_foreign` (`server_id`),
  ADD KEY `user_servers_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `credits`
--
ALTER TABLE `credits`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2260;

--
-- AUTO_INCREMENT for table `data_rows`
--
ALTER TABLE `data_rows`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- AUTO_INCREMENT for table `data_types`
--
ALTER TABLE `data_types`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `demos`
--
ALTER TABLE `demos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT for table `domains`
--
ALTER TABLE `domains`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `durations`
--
ALTER TABLE `durations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jellyfincustomers`
--
ALTER TABLE `jellyfincustomers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `jellyfindemos`
--
ALTER TABLE `jellyfindemos`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `jellyfinpackages`
--
ALTER TABLE `jellyfinpackages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `jellyfinservers`
--
ALTER TABLE `jellyfinservers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- AUTO_INCREMENT for table `movements`
--
ALTER TABLE `movements`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `proxies`
--
ALTER TABLE `proxies`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=202;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `servers`
--
ALTER TABLE `servers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=136;

--
-- AUTO_INCREMENT for table `server_libraries`
--
ALTER TABLE `server_libraries`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `sessions`
--
ALTER TABLE `sessions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=616;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `translations`
--
ALTER TABLE `translations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `user_servers`
--
ALTER TABLE `user_servers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `credits`
--
ALTER TABLE `credits`
  ADD CONSTRAINT `credits_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `customers`
--
ALTER TABLE `customers`
  ADD CONSTRAINT `customers_duration_id_foreign` FOREIGN KEY (`duration_id`) REFERENCES `durations` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  ADD CONSTRAINT `customers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `data_rows`
--
ALTER TABLE `data_rows`
  ADD CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `demos`
--
ALTER TABLE `demos`
  ADD CONSTRAINT `demos_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE;

--
-- Constraints for table `jellyfinpackages`
--
ALTER TABLE `jellyfinpackages`
  ADD CONSTRAINT `jellyfinpackages_jellyfinserver_id_foreign` FOREIGN KEY (`jellyfinserver_id`) REFERENCES `jellyfinservers` (`id`);

--
-- Constraints for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `packages`
--
ALTER TABLE `packages`
  ADD CONSTRAINT `packages_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`);

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `server_libraries`
--
ALTER TABLE `server_libraries`
  ADD CONSTRAINT `server_libraries_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Constraints for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_servers`
--
ALTER TABLE `user_servers`
  ADD CONSTRAINT `user_servers_server_id_foreign` FOREIGN KEY (`server_id`) REFERENCES `servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `user_servers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

