--
-- Host: localhost    Database: bp-coke
-- ------------------------------------------------------


--
-- Table structure for table `activity_log`
--

CREATE TABLE `activity_log` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `log_name` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `subject_type` varchar(255) DEFAULT NULL,
  `event` varchar(255) DEFAULT NULL,
  `subject_id` bigint(20) unsigned DEFAULT NULL,
  `causer_type` varchar(255) DEFAULT NULL,
  `causer_id` bigint(20) unsigned DEFAULT NULL,
  `properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`properties`)),
  `batch_uuid` char(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subject` (`subject_type`,`subject_id`),
  KEY `causer` (`causer_type`,`causer_id`),
  KEY `activity_log_log_name_index` (`log_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `activity_log`
--

INSERT INTO `activity_log` VALUES (1,'default','created','App\\Models\\User','created',1,NULL,NULL,'{\"attributes\":{\"id\":1,\"first_name\":\"Admin\",\"last_name\":\"Bewpro\",\"slug\":\"admin-bewpro\",\"email\":\"admin@bewpro.com\",\"email_verified_at\":\"2026-03-23T15:04:32.000000Z\",\"password\":\"$2y$10$uObHU89ZMAIQUkAz\\/gUv8uTQN\\/9O7F71eLCwsT8gmlbAmAc6luZ4O\",\"role_id\":1,\"two_step\":0,\"api_token\":\"$2y$10$TD.zipxy2Ny144PzpvovxuR2OO2F9oQ3pPtrDzSTwVR.oD.9fVD5m\",\"remember_token\":null,\"created_at\":\"2026-03-23T15:04:32.000000Z\",\"updated_at\":\"2026-03-23T15:04:32.000000Z\",\"stripe_id\":null,\"pm_type\":null,\"pm_last_four\":null,\"trial_ends_at\":null,\"last_login_at\":null,\"last_login_ip\":null}}',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32'),(2,'default','created','App\\Models\\UserInfo','created',1,NULL,NULL,'{\"attributes\":{\"id\":1,\"user_id\":1,\"avatar\":null,\"avatar_public_id\":null,\"avatar_url\":\"http:\\/\\/localhost\\/demo1\\/media\\/avatars\\/blank.png\",\"phone\":\"944-15-8925\",\"mobile\":\"+34 968-195097\",\"status\":null,\"country\":null,\"file\":null,\"type\":null,\"details\":null,\"language\":null,\"created_at\":\"2026-03-23T15:04:32.000000Z\",\"updated_at\":\"2026-03-23T15:04:32.000000Z\",\"address\":null,\"member_since\":null,\"linkedin\":null}}',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32'),(3,'default','created','App\\Models\\User','created',2,NULL,NULL,'{\"attributes\":{\"id\":2,\"first_name\":\"User\",\"last_name\":\"Bewpro\",\"slug\":\"user-bewpro\",\"email\":\"user@bewpro.com\",\"email_verified_at\":\"2026-03-23T15:04:32.000000Z\",\"password\":\"$2y$10$.PqiDmVHeGRIsZJx1NAJiecYR6mQbTq3UqAnTFtKkF.0OIYvlnjue\",\"role_id\":2,\"two_step\":0,\"api_token\":\"$2y$10$DnuzcTBsxVnZBrIQrx7KWuO8YWxwVyYqgwcP3FDrgjN3lw3cSg53q\",\"remember_token\":null,\"created_at\":\"2026-03-23T15:04:32.000000Z\",\"updated_at\":\"2026-03-23T15:04:32.000000Z\",\"stripe_id\":null,\"pm_type\":null,\"pm_last_four\":null,\"trial_ends_at\":null,\"last_login_at\":null,\"last_login_ip\":null}}',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32'),(4,'default','created','App\\Models\\UserInfo','created',2,NULL,NULL,'{\"attributes\":{\"id\":2,\"user_id\":2,\"avatar\":null,\"avatar_public_id\":null,\"avatar_url\":\"http:\\/\\/localhost\\/demo1\\/media\\/avatars\\/blank.png\",\"phone\":\"964 364248\",\"mobile\":\"+34 983-71-9235\",\"status\":null,\"country\":null,\"file\":null,\"type\":null,\"details\":null,\"language\":null,\"created_at\":\"2026-03-23T15:04:32.000000Z\",\"updated_at\":\"2026-03-23T15:04:32.000000Z\",\"address\":null,\"member_since\":null,\"linkedin\":null}}',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32'),(5,'default','created','App\\Models\\User','created',3,NULL,NULL,'{\"attributes\":{\"id\":3,\"first_name\":\"Admin\",\"last_name\":\"Client\",\"slug\":\"admin-client\",\"email\":\"coke_colombres@hotmail.com\",\"email_verified_at\":\"2026-03-23T15:04:32.000000Z\",\"password\":\"$2y$10$okHs.eVvhVg.bN5Q1vOQhO2tdqe5ksucfNfEMHzZFdiaFSHoBmdqG\",\"role_id\":2,\"two_step\":0,\"api_token\":\"$2y$10$Uw\\/FkBbEe.Ik0\\/s26tvShuMpNs9VBC7XBclpewCogZnNqv5.UxPBW\",\"remember_token\":null,\"created_at\":\"2026-03-23T15:04:32.000000Z\",\"updated_at\":\"2026-03-23T15:04:32.000000Z\",\"stripe_id\":null,\"pm_type\":null,\"pm_last_four\":null,\"trial_ends_at\":null,\"last_login_at\":null,\"last_login_ip\":null}}',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32'),(6,'default','created','App\\Models\\UserInfo','created',3,NULL,NULL,'{\"attributes\":{\"id\":3,\"user_id\":3,\"avatar\":null,\"avatar_public_id\":null,\"avatar_url\":\"http:\\/\\/localhost\\/demo1\\/media\\/avatars\\/blank.png\",\"phone\":null,\"mobile\":null,\"status\":null,\"country\":null,\"file\":null,\"type\":null,\"details\":null,\"language\":null,\"created_at\":\"2026-03-23T15:04:32.000000Z\",\"updated_at\":\"2026-03-23T15:04:32.000000Z\",\"address\":null,\"member_since\":null,\"linkedin\":null}}',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32');

--
-- Table structure for table `album_picture`
--

CREATE TABLE `album_picture` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) unsigned NOT NULL,
  `picture_id` bigint(20) unsigned NOT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `album_picture_album_id_foreign` (`album_id`),
  KEY `album_picture_picture_id_foreign` (`picture_id`),
  CONSTRAINT `album_picture_album_id_foreign` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`) ON DELETE CASCADE,
  CONSTRAINT `album_picture_picture_id_foreign` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `album_picture`
--


--
-- Table structure for table `album_tag`
--

CREATE TABLE `album_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `album_tag_album_id_foreign` (`album_id`),
  KEY `album_tag_tag_id_foreign` (`tag_id`),
  CONSTRAINT `album_tag_album_id_foreign` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`) ON DELETE CASCADE,
  CONSTRAINT `album_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `album_tag`
--


--
-- Table structure for table `albums`
--

CREATE TABLE `albums` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `albums_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `albums`
--


--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `public_id` varchar(255) DEFAULT NULL,
  `secure_url` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `assets_path_unique` (`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `assets`
--


--
-- Table structure for table `carousel_picture`
--

CREATE TABLE `carousel_picture` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `carousel_id` bigint(20) unsigned NOT NULL,
  `picture_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `carousel_picture_carousel_id_foreign` (`carousel_id`),
  KEY `carousel_picture_picture_id_foreign` (`picture_id`),
  CONSTRAINT `carousel_picture_carousel_id_foreign` FOREIGN KEY (`carousel_id`) REFERENCES `carousels` (`id`) ON DELETE CASCADE,
  CONSTRAINT `carousel_picture_picture_id_foreign` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `carousel_picture`
--


--
-- Table structure for table `carousels`
--

CREATE TABLE `carousels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `items` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `carousels`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `company_logos`
--

CREATE TABLE `company_logos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `public_id` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `company_logos`
--


--
-- Table structure for table `contact_messages`
--

CREATE TABLE `contact_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `status` enum('new','read','replied','archived') NOT NULL DEFAULT 'new',
  `ip_address` varchar(255) DEFAULT NULL,
  `email_sent` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `contact_messages`
--


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

CREATE TABLE `demos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `cd_system_config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`cd_system_config`)),
  `site_config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`site_config`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `demos_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demos`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `faqs_category_id_foreign` (`category_id`),
  CONSTRAINT `faqs_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `faqs_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'¿A qué te dedicás?','Fundé y dirijo Compañía Digital (agencia) y BewPro (plataforma SaaS). El resto del tiempo entreno para un Ironman y exploro montañas.',1,1,1,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(2,'¿Qué es Compañía Digital?','Mi agencia digital. 10+ años acompañando empresas con sitios web, identidad digital y estrategia.',1,0,2,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(3,'¿Qué es BewPro?','Una plataforma SaaS modular para crear sitios web profesionales. La tecnología que construí para escalar.',1,0,3,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(4,'¿Cuándo la próxima aventura a la montaña?','Siempre hay una próxima. La montaña no es un hobby — es donde se ordenan las prioridades. Seguí la galería para las últimas.',2,1,1,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(5,'¿Vas a la nieve este año?','Si hay nieve, hay splitboard. Esquí de travesía y snowboard son mi forma de conectar con la montaña en invierno.',2,0,2,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(6,'¿Cómo va la preparación para el Ironman?','En proceso. Natación, bici y running — todo el año. No es solo un evento, es el sistema de disciplina que alimenta todo lo demás.',2,1,3,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(7,'¿Qué es 75Hard?','Un programa de disciplina mental de 75 días creado por Andy Frisella. Dos entrenamientos diarios, dieta, lectura, sin alcohol, sin excusas. Framework de mentalidad.',3,0,1,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(8,'¿Qué significa HI > AI?','Human Intelligence sobre Artificial Intelligence. La IA es una herramienta poderosa, pero el criterio humano marca la diferencia.',3,1,2,'2026-03-23 15:10:31','2026-03-23 15:10:31');

--
-- Table structure for table `faqs_categories`
--

CREATE TABLE `faqs_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `faqs_categories_name_unique` (`name`),
  UNIQUE KEY `faqs_categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `faqs_categories`
--

INSERT INTO `faqs_categories` VALUES (1,'General','general',NULL,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(2,'Outdoor','outdoor',NULL,'2026-03-23 15:10:31','2026-03-23 15:10:31'),(3,'Visión','vision',NULL,'2026-03-23 15:10:31','2026-03-23 15:10:31');

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `img` varchar(255) NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gallery_category_id_index` (`category_id`),
  CONSTRAINT `gallery_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `gallery_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` VALUES (4,'5',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774299577/Muma/gallery/gallery_69c1a9b8a888b.jpg',13,1,'2026-03-23 20:59:38','2026-03-23 20:59:38'),(5,'2',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774299740/Muma/gallery/gallery_69c1aa5ac64e6.jpg',13,0,'2026-03-23 21:02:20','2026-03-23 21:02:20'),(6,'DJI 0478',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774299855/Muma/gallery/gallery_69c1aacb6b38f.jpg',3,1,'2026-03-23 21:04:16','2026-03-23 22:19:05'),(7,'Dia 3   Bici Captura de pantalla(3)',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774300069/Muma/gallery/gallery_69c1aba29b861.jpg',13,0,'2026-03-23 21:07:50','2026-03-23 21:07:50'),(8,'IMG 7760 jpg',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774300072/Muma/gallery/gallery_69c1aba67ba97.jpg',13,1,'2026-03-23 21:07:52','2026-03-23 21:51:20'),(9,'IMG 20230817 190923 031',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774301506/Muma/gallery/gallery_69c1b140859d3.jpg',3,0,'2026-03-23 21:31:46','2026-03-23 21:31:46'),(10,'IMG 20240525 171812 810',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774301511/Muma/gallery/gallery_69c1b142f3d76.jpg',3,1,'2026-03-23 21:31:52','2026-03-23 21:51:18'),(11,'IMG 20240713 143136 00 119',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774301513/Muma/gallery/gallery_69c1b14805716.jpg',3,0,'2026-03-23 21:31:55','2026-03-23 21:31:55'),(12,'IMG 20240714 114020 00 159',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774301516/Muma/gallery/gallery_69c1b14b21783.jpg',3,1,'2026-03-23 21:31:57','2026-03-23 21:51:17'),(13,'IMG 20240714 115708 00 182',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774301519/Muma/gallery/gallery_69c1b14d32a6e.jpg',3,0,'2026-03-23 21:32:00','2026-03-23 21:32:00'),(14,'IMG 20250820 185606 131',NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774301521/Muma/gallery/gallery_69c1b150118cb.jpg',3,1,'2026-03-23 21:32:02','2026-03-23 22:19:02');

--
-- Table structure for table `gallery_categories`
--

CREATE TABLE `gallery_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `gallery_categories_name_unique` (`name`),
  UNIQUE KEY `gallery_categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `gallery_categories`
--

INSERT INTO `gallery_categories` VALUES (3,'Snowboard','Nieve, splitboard, montaña invernal','snowboard','2026-03-23 15:51:21','2026-03-23 15:51:21'),(4,'Drone','Perspectiva aérea, paisajes, documentación desde arriba','drone','2026-03-23 15:51:21','2026-03-23 15:51:21'),(5,'Entrenamientos','Gym, running, proceso diario de training','entrenamientos','2026-03-23 15:51:21','2026-03-23 15:51:21'),(6,'Bici de Montaña','Trail, enduro, naturaleza sobre dos ruedas','mtb','2026-03-23 15:51:21','2026-03-23 15:51:21'),(7,'Bici de Ruta','Resistencia, kilómetros, ruta y foco','bici-ruta','2026-03-23 15:51:21','2026-03-23 15:51:21'),(8,'Kayak','Agua, calma, exploración de nuevos territorios','kayak','2026-03-23 15:51:21','2026-03-23 15:51:21'),(9,'Trekking','Sendero, cumbre, paisaje, la montaña a pie','trekking','2026-03-23 15:51:21','2026-03-23 15:51:21'),(10,'Camping','Base camp, conexión, simpleza, vida al aire libre','camping','2026-03-23 15:51:21','2026-03-23 15:51:21'),(11,'Enduro','Resistencia extrema, límite, adrenalina','enduro','2026-03-23 15:51:21','2026-03-23 15:51:21'),(12,'Natación','Ironman prep, técnica, agua, disciplina','natacion','2026-03-23 15:51:21','2026-03-23 15:51:21'),(13,'Patagonia',NULL,'patagonia','2026-03-23 20:59:36','2026-03-23 20:59:36');

--
-- Table structure for table `gallery_gallery_tag`
--

CREATE TABLE `gallery_gallery_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `gallery_id` bigint(20) unsigned NOT NULL,
  `gallery_tag_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `gallery_gallery_tag_gallery_id_gallery_tag_id_unique` (`gallery_id`,`gallery_tag_id`),
  KEY `gallery_gallery_tag_gallery_tag_id_foreign` (`gallery_tag_id`),
  CONSTRAINT `gallery_gallery_tag_gallery_id_foreign` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`) ON DELETE CASCADE,
  CONSTRAINT `gallery_gallery_tag_gallery_tag_id_foreign` FOREIGN KEY (`gallery_tag_id`) REFERENCES `gallery_tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `gallery_gallery_tag`
--

INSERT INTO `gallery_gallery_tag` VALUES (4,4,4,NULL,NULL),(5,5,4,NULL,NULL),(6,6,4,NULL,NULL),(7,7,4,NULL,NULL),(8,8,4,NULL,NULL),(9,9,4,NULL,NULL),(10,10,4,NULL,NULL),(11,11,4,NULL,NULL),(12,12,4,NULL,NULL),(13,13,4,NULL,NULL),(14,14,4,NULL,NULL);

--
-- Table structure for table `gallery_tags`
--

CREATE TABLE `gallery_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `color` varchar(20) NOT NULL DEFAULT 'primary',
  `slug` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `gallery_tags`
--

INSERT INTO `gallery_tags` VALUES (1,'Destacado','Para mostrar en el welcome','primary','destacado','2026-03-23 15:04:32','2026-03-23 15:51:21'),(2,'Crear','Pilar Crear','primary','crear','2026-03-23 15:51:21','2026-03-23 15:51:21'),(3,'Entrenar','Pilar Entrenar','primary','entrenar','2026-03-23 15:51:21','2026-03-23 15:51:21'),(4,'Explorar','Pilar Explorar','primary','explorar','2026-03-23 15:51:21','2026-03-23 15:51:21');

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `native_name` varchar(255) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `languages_code_unique` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `languages`
--


--
-- Table structure for table `menu_categories`
--

CREATE TABLE `menu_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menu_categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `menu_categories`
--


--
-- Table structure for table `menu_menu_product`
--

CREATE TABLE `menu_menu_product` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_id` bigint(20) unsigned NOT NULL,
  `menu_product_id` bigint(20) unsigned NOT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menu_menu_product_menu_id_menu_product_id_unique` (`menu_id`,`menu_product_id`),
  KEY `menu_menu_product_menu_product_id_foreign` (`menu_product_id`),
  CONSTRAINT `menu_menu_product_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE,
  CONSTRAINT `menu_menu_product_menu_product_id_foreign` FOREIGN KEY (`menu_product_id`) REFERENCES `menu_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `menu_menu_product`
--


--
-- Table structure for table `menu_products`
--

CREATE TABLE `menu_products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `order` int(11) NOT NULL DEFAULT 0,
  `menu_category_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menu_products_slug_unique` (`slug`),
  KEY `menu_products_slug_index` (`slug`),
  KEY `menu_products_is_active_index` (`is_active`),
  KEY `menu_products_menu_category_id_index` (`menu_category_id`),
  CONSTRAINT `menu_products_menu_category_id_foreign` FOREIGN KEY (`menu_category_id`) REFERENCES `menu_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `menu_products`
--


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

CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `menu_category_id` bigint(20) unsigned NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `menus_slug_unique` (`slug`),
  KEY `menus_menu_category_id_foreign` (`menu_category_id`),
  CONSTRAINT `menus_menu_category_id_foreign` FOREIGN KEY (`menu_category_id`) REFERENCES `menu_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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


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

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_05_03_000001_create_customer_columns',1),(4,'2019_05_03_000002_create_subscriptions_table',1),(5,'2019_05_03_000003_create_subscription_items_table',1),(6,'2019_08_19_000000_create_failed_jobs_table',1),(7,'2021_03_22_144618_create_permission_tables',1),(8,'2021_04_14_044507_create_settings_table',1),(9,'2021_06_15_022916_create_user_infos_table',1),(10,'2021_06_23_041411_create_activity_log_table',1),(11,'2021_06_23_041412_add_event_column_to_activity_log_table',1),(12,'2021_06_23_041413_add_batch_uuid_column_to_activity_log_table',1),(13,'2021_11_04_200820_add_api_token_column',1),(14,'2022_10_28_011905_create_post_categories_table',1),(15,'2022_10_28_013743_create_posts_table',1),(16,'2022_11_27_174317_add_columns_user_infos_table',1),(17,'2022_11_27_213151_add_role_column_to_users_table',1),(18,'2022_11_28_183514_add_header_column_to_posts_table',1),(19,'2022_11_28_230301_add_2steps_boolean_column_to_users_table',1),(20,'2022_11_29_001654_add_description_column_to_roles_table',1),(21,'2022_11_29_010232_add_login_fields_to_users_table',1),(22,'2022_11_30_012122_add_slug_column_to_users_table',1),(23,'2022_11_30_015822_remove_infos_column_in_user_infos_table',1),(24,'2022_12_01_145953_create_albums_table',1),(25,'2022_12_01_150118_create_pictures_table',1),(26,'2022_12_01_150217_create_tags_table',1),(27,'2022_12_01_153440_create_album_tag_table',1),(28,'2022_12_01_153536_create_picture_tag_table',1),(29,'2022_12_03_110421_create_album_picture_table',1),(30,'2022_12_14_125955_add_featured_column_to_pictures_table',1),(31,'2023_01_03_132602_create_carousels_table',1),(32,'2023_01_03_133219_create_carousel_picture_table',1),(33,'2023_01_30_214920_create_categories_table',1),(34,'2023_01_30_215103_create_products_table',1),(35,'2023_01_30_231208_create_projects_table',1),(36,'2023_03_08_192259_add_slug_column_to_roles_table',1),(37,'2023_03_08_203351_modify_columns_on_user_infos_table',1),(38,'2023_03_14_013201_modify_columns_in_user_infos_table',1),(39,'2023_03_14_013447_modify_column_content_in_posts_table',1),(40,'2023_03_14_015848_add_column_in_user_infos_table',1),(41,'2023_03_14_020506_drop_columns_city_and_zipcode_in_user_infos_table',1),(42,'2023_03_14_125135_drop_social_columns_on_user_infos_table',1),(43,'2023_03_19_200738_rename_column_born_date_on_user_infos_table',1),(44,'2024_09_28_112149_add_category_id_to_products_table',1),(45,'2024_10_16_094040_create_project_categories_table',1),(46,'2024_10_16_094131_create_project_category_project_table',1),(47,'2024_10_16_094821_add_image_path_and_is_active_to_projects_table',1),(48,'2024_10_16_111812_rename_image_path_to_image_in_projects_table',1),(49,'2024_10_29_123145_remove_description_from_categories_table',1),(50,'2024_10_29_141636_create_product_tags_table',1),(51,'2024_10_29_141914_create_product_product_tag_table',1),(52,'2024_10_29_172710_create_product_images_table',1),(53,'2024_10_29_175900_remove_image_path_from_products_table',1),(54,'2024_11_05_161233_create_welcome_carousels_table',1),(55,'2024_11_07_131830_add_cloudinary_fields_to_user_infos_table',1),(56,'2024_11_07_153540_add_country_to_user_infos_table',1),(57,'2024_12_30_150554_create_gallery_table',1),(58,'2024_12_30_150637_create_gallery_categories_table',1),(59,'2024_12_30_150709_add_category_id_to_gallery_table',1),(60,'2024_12_30_150802_add_category_id_index_to_gallery_table',1),(61,'2025_01_14_125955_create_faqs_categories_table',1),(62,'2025_01_14_142859_create_faqs_table',1),(63,'2025_01_14_142959_modify_order_in_faqs_table',1),(64,'2025_01_15_100659_create_news_categories_table',1),(65,'2025_01_15_100734_create_news_table',1),(66,'2025_01_15_100754_update_slug_default_in_news_table',1),(67,'2025_01_23_124707_create_gallery_tags_table',1),(68,'2025_01_23_124818_create_gallery_gallery_tag_table',1),(69,'2025_01_28_000001_create_languages_table',1),(70,'2025_01_28_000002_create_post_translations_table',1),(71,'2025_01_28_000003_create_product_translations_table',1),(72,'2025_01_28_000004_create_post_category_translations_table',1),(73,'2025_01_28_000005_create_product_category_translations_table',1),(74,'2025_02_10_082609_create_reference_categories_table',1),(75,'2025_02_10_082939_create_references_table',1),(76,'2025_02_10_082950_update_references_table',1),(77,'2025_02_10_125803_create_services_table',1),(78,'2025_02_11_124507_create_team_members_and_categories_tables',1),(79,'2025_02_11_125015_update_team_members_table_with_extra_fields',1),(80,'2025_03_05_125737_add_slug_and_description_to_project_categories_table',1),(81,'2025_03_07_111602_add_public_id_to_posts_table',1),(82,'2025_03_07_111646_drop_category_id_from_news_table',1),(83,'2025_03_07_111716_drop_news_categories_table',1),(84,'2025_03_10_160158_create_projects_table',1),(85,'2025_03_15_155805_create_tokko_settings_table',1),(86,'2025_03_19_224401_add_slug_and_description_to_faqs_categories_table',1),(87,'2025_03_26_102753_add_slug_and_description_to_team_categories',1),(88,'2025_04_01_103909_add_description_to_product_tags_table',1),(89,'2025_04_01_125717_add_url_and_description_to_project__table',1),(90,'2025_04_14_165729_create_newsletter_subscribers_table',1),(91,'2025_04_15_210225_add_is_featured_to_faqs_table',1),(92,'2025_05_13_180427_add_slug_to_products_table',1),(93,'2025_07_19_044618_add_new_fields_to_newsletter_subscribers_table',1),(94,'2025_07_20_222120_add_color_to_gallery_tags_table',1),(95,'2025_07_22_230849_create_service_categories_table',1),(96,'2025_07_22_231055_add_foreign_key_to_services_table',1),(97,'2025_07_23_133415_add_landing_content_to_services_table',1),(98,'2025_08_08_122632_add_maintenance_settings_for_modules',1),(99,'2025_09_05_110544_add_is_sold_to_products_table',1),(100,'2025_09_05_170638_add_description_back_to_categories_table',1),(101,'2025_09_22_104344_add_description_to_reference_categories_table',1),(102,'2025_10_22_193702_add_slug_to_project_categories_table',1),(103,'2025_10_22_194748_add_slug_to_projects_table',1),(104,'2025_10_30_100001_create_project_tags_table',1),(105,'2025_10_30_100002_create_project_project_tag_table',1),(106,'2025_11_22_230658_make_category_id_nullable_in_faqs_table',1),(107,'2026_01_05_151704_create_assets_table',1),(108,'2026_01_22_141428_create_project_settings_table',1),(109,'2026_01_23_125222_add_secure_url_to_assets_table',1),(110,'2026_01_27_000000_create_demos_table',1),(111,'2026_01_30_114735_create_menu_categories_table',1),(112,'2026_01_30_114936_create_menus_table',1),(113,'2026_02_02_150102_create_menu_products_table',1),(114,'2026_02_02_150346_create_menu_menu_product_table',1),(115,'2026_02_09_165950_make_title_nullable_in_posts_table',1),(116,'2026_02_18_163830_add_image_to_menu_categories_table',1),(117,'2026_02_18_164324_add_image_to_menus_table',1),(118,'2026_02_23_174325_make_services_description_nullable_in_services_table',1),(119,'2026_02_26_120000_add_is_featured_to_posts_table',1),(120,'2026_03_02_000001_add_title_subtitle_to_welcome_carousels_table',1),(121,'2026_03_02_130251_add_image_to_categories_table',1),(122,'2026_03_02_130258_add_quantity_label_to_products_table',1),(123,'2026_03_06_234846_add_landing_fields_to_products_table',1),(124,'2026_03_09_142205_add_stripe_price_id_to_products_table',1),(125,'2026_03_10_000001_add_marketing_fields_to_products_table',1),(126,'2026_03_13_000000_add_is_featured_to_gallery_table',1),(127,'2026_03_21_000000_create_company_logos_table',1),(128,'2026_03_21_100000_create_contact_messages_table',1);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` VALUES (1,'App\\Models\\User',2),(2,'App\\Models\\User',2),(3,'App\\Models\\User',2),(4,'App\\Models\\User',2),(25,'App\\Models\\User',2),(26,'App\\Models\\User',2),(27,'App\\Models\\User',2),(28,'App\\Models\\User',2),(29,'App\\Models\\User',2),(30,'App\\Models\\User',2),(31,'App\\Models\\User',2),(32,'App\\Models\\User',2),(33,'App\\Models\\User',2),(34,'App\\Models\\User',2),(35,'App\\Models\\User',2),(36,'App\\Models\\User',2),(37,'App\\Models\\User',2),(38,'App\\Models\\User',2),(39,'App\\Models\\User',2),(40,'App\\Models\\User',2),(41,'App\\Models\\User',2),(42,'App\\Models\\User',2),(43,'App\\Models\\User',2),(44,'App\\Models\\User',2),(45,'App\\Models\\User',2),(46,'App\\Models\\User',2),(47,'App\\Models\\User',2),(48,'App\\Models\\User',2),(49,'App\\Models\\User',2),(50,'App\\Models\\User',2),(51,'App\\Models\\User',2),(52,'App\\Models\\User',2),(53,'App\\Models\\User',2),(54,'App\\Models\\User',2),(55,'App\\Models\\User',2),(56,'App\\Models\\User',2);

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(2,'App\\Models\\User',3);

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `slug` varchar(255) NOT NULL DEFAULT 'default-slug',
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_slug_unique` (`slug`),
  KEY `news_user_id_foreign` (`user_id`),
  CONSTRAINT `news_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `news`
--


--
-- Table structure for table `newsletter_subscribers`
--

CREATE TABLE `newsletter_subscribers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `subscribed_at` timestamp NULL DEFAULT NULL,
  `unsubscribed_at` timestamp NULL DEFAULT NULL,
  `verification_token` varchar(255) DEFAULT NULL,
  `verified_at` timestamp NULL DEFAULT NULL,
  `source` varchar(100) NOT NULL DEFAULT 'website',
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `newsletter_subscribers_email_unique` (`email`),
  KEY `newsletter_subscribers_status_index` (`status`),
  KEY `newsletter_subscribers_source_index` (`source`),
  KEY `newsletter_subscribers_subscribed_at_index` (`subscribed_at`),
  KEY `newsletter_subscribers_verification_token_index` (`verification_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `newsletter_subscribers`
--


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

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

--
-- Dumping data for table `password_resets`
--


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

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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



--
-- Table structure for table `picture_tag`
--

CREATE TABLE `picture_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `picture_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `picture_tag_picture_id_foreign` (`picture_id`),
  KEY `picture_tag_tag_id_foreign` (`tag_id`),
  CONSTRAINT `picture_tag_picture_id_foreign` FOREIGN KEY (`picture_id`) REFERENCES `pictures` (`id`) ON DELETE CASCADE,
  CONSTRAINT `picture_tag_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `picture_tag`
--


--
-- Table structure for table `pictures`
--

CREATE TABLE `pictures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `pictures`
--


--
-- Table structure for table `post_categories`
--

CREATE TABLE `post_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `post_categories`
--

INSERT INTO `post_categories` VALUES (3,'Proyectos','proyectos','Behind the scenes de lo que construyo — CD, BewPro, emprendimientos','2026-03-23 15:51:13','2026-03-23 15:51:13'),(4,'Aventuras','aventuras','Rutas, destinos, expediciones y lo que la montaña enseña','2026-03-23 15:51:13','2026-03-23 15:51:13'),(5,'Training','training','Entrenamiento, disciplina, mentalidad y proceso real','2026-03-23 15:51:13','2026-03-23 15:51:13'),(6,'Tips','tips','Consejos prácticos de tech, gear, entrenamiento y más','2026-03-23 15:51:13','2026-03-23 15:51:13'),(7,'Mentalidad','mentalidad','Reflexiones sobre proceso, disciplina y lo que aprendí','2026-03-23 15:51:13','2026-03-23 15:51:13');

--
-- Table structure for table `post_category_translations`
--

CREATE TABLE `post_category_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_category_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `post_category_translations_post_category_id_locale_unique` (`post_category_id`,`locale`),
  KEY `post_category_translations_locale_index` (`locale`),
  CONSTRAINT `post_category_translations_post_category_id_foreign` FOREIGN KEY (`post_category_id`) REFERENCES `post_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `post_category_translations`
--


--
-- Table structure for table `post_translations`
--

CREATE TABLE `post_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `excerpt` text DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `post_translations_post_id_locale_unique` (`post_id`,`locale`),
  KEY `post_translations_locale_index` (`locale`),
  KEY `post_translations_slug_index` (`slug`),
  CONSTRAINT `post_translations_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `post_translations`
--


--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `header` varchar(255) DEFAULT NULL,
  `public_id` varchar(255) DEFAULT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(20) NOT NULL,
  `status` enum('Published','Paused','Draft') NOT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `content` longtext NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `posts_user_id_foreign` (`user_id`),
  KEY `posts_category_id_foreign` (`category_id`),
  CONSTRAINT `posts_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `post_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `posts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` VALUES (3,2,'Cómo fundé Compañía Digital y qué aprendí en 10 años','como-funde-compania-digital-y-que-aprendi-en-10-anos','https://res.cloudinary.com/dupf7vvwj/image/upload/v1774305510/muma/blog/blog/post_3.png','muma/blog/blog/post_3',3,'La historia real de fundar una agencia digital en Tucumán. 10 años, 45+ proyectos, y las lecciones que no enseña ningún curso.','post','Published',1,'<p>En 2020 arranqu&eacute; Compa&ntilde;&iacute;a Digital sin plan de negocios, sin inversores y sin oficina. Solo ten&iacute;a una laptop, conexi&oacute;n a internet y la convicci&oacute;n de que pod&iacute;a construir algo que funcionara.</p>\r\n<p>Hoy, 6 a&ntilde;os despu&eacute;s, la agencia lleva 50+ proyectos entregados, un equipo que creci&oacute; org&aacute;nicamente y una operaci&oacute;n que funciona sin que yo est&eacute; encima de cada detalle.</p>\r\n<h3>Lo que aprend&iacute;</h3>\r\n<p>Lo m&aacute;s importante no fue aprender a programar mejor o a vender m&aacute;s. Fue entender que <strong>un sistema bien dise&ntilde;ado se sostiene solo</strong>. Que la clave no es trabajar m&aacute;s horas, sino construir procesos que funcionen cuando no est&aacute;s.</p>\r\n<p>Eso mismo aplica al entrenamiento, a la monta&ntilde;a, a todo. Si el sistema es s&oacute;lido, los resultados vienen.</p>\r\n<h3>El error m&aacute;s grande</h3>\r\n<p>Querer hacer todo yo. Tard&eacute; a&ntilde;os en entender que delegar no es perder control &mdash; es escalar. La misma lecci&oacute;n que me dio el 75Hard: no negociar con vos mismo.</p>\r\n<h3>Lo que viene</h3>\r\n<p>Compa&ntilde;&iacute;a Digital hoy es el brazo ejecutor. BewPro es la plataforma que escala. Y este espacio es donde comparto el proceso real &mdash; sin filtros, sin marketing.</p>','2026-03-23 15:51:13','2026-03-23 22:38:31',NULL),(4,2,'BewPro: de idea a plataforma SaaS','bewpro-de-idea-a-plataforma-saas','https://res.cloudinary.com/dupf7vvwj/image/upload/v1774305607/Muma/blog/blog/post_4.png','Muma/blog/blog/post_4',3,'Cómo nació BewPro, por qué decidí construir una plataforma propia y qué implica mantener un SaaS modular.','post','Published',1,'<p>BewPro naci&oacute; de una frustraci&oacute;n: cada cliente de Compa&ntilde;&iacute;a Digital necesitaba un sitio web, y yo estaba construyendo cada uno desde cero. Era insostenible.</p>\r\n<p>La pregunta fue simple: <strong>&iquest;y si construyo un sistema que me permita crear sitios profesionales en horas en vez de semanas?</strong></p>\r\n<h3>La decisi&oacute;n</h3>\r\n<p>Podr&iacute;a haber usado WordPress, Wix, o cualquier plataforma existente. Pero ninguna me daba el control que necesitaba. Quer&iacute;a m&oacute;dulos que se combinaran como bloques, demos visuales que se adaptaran a cada industria, y una arquitectura que escalara sin depender de m&iacute;.</p>\r\n<h3>El modelo</h3>\r\n<p>BewPro funciona con resellers. No vendo directo al cliente final &mdash; vendo la plataforma a agencias y profesionales que la usan para sus propios clientes. Es escalar sin centralizar.</p>\r\n<h3>Lo que aprend&iacute; construy&eacute;ndola</h3>\r\n<p>Construir un SaaS es muy diferente a hacer sitios para clientes. Es pensar en sistemas, no en p&aacute;ginas. Es dise&ntilde;ar para 100 proyectos, no para uno. La misma mentalidad que uso cuando planeo una traves&iacute;a en la monta&ntilde;a: preparaci&oacute;n, sistema, ejecuci&oacute;n.</p>','2026-03-23 15:51:13','2026-03-23 22:40:08',NULL),(5,2,'Preparación Ironman: por qué entreno para algo que todavía no llegó','preparacion-ironman-por-que-entreno-para-algo-que-todavia-no-llego','https://res.cloudinary.com/dupf7vvwj/image/upload/v1774309225/Muma/blog/blog/post_5.jpg','Muma/blog/blog/post_5',5,'El proceso real de preparar un Ironman. Natación, bici, running — todo el año. No es solo un evento, es un sistema de disciplina.','post','Published',1,'<p>La gente me pregunta: <em>&iquest;cu&aacute;ndo es el Ironman?</em> Y la respuesta honesta es: <strong>no importa cu&aacute;ndo sea. Lo que importa es que entreno todos los d&iacute;as.</strong></p>\r\n<p>Un Ironman son 3.8 km de nataci&oacute;n, 180 km de bici y 42 km de running. Pero la carrera es solo el resultado. El proceso es lo que te cambia.</p>\r\n<h3>Mi rutina semanal</h3>\r\n<p>Nataci&oacute;n 3 veces por semana. Bici (ruta o MTB) 3-4 veces. Running 2-3 veces. Gym 2 veces. No todos los d&iacute;as son &eacute;picos &mdash; la mayor&iacute;a son comunes. Y eso es exactamente el punto.</p>\r\n<h3>Lo que el entrenamiento me ense&ntilde;&oacute; sobre emprender</h3>\r\n<p>Que los d&iacute;as comunes son los que te construyen. Que la motivaci&oacute;n es mentira &mdash; lo que funciona es el sistema. Que si negoci&aacute;s con vos mismo una vez, negoci&aacute;s siempre.</p>\r\n<p>Andy Frisella lo dice mejor que nadie: <strong>no es sobre sentirte bien, es sobre hacer lo que hay que hacer.</strong></p>\r\n<h3>75Hard fue el reset</h3>\r\n<p>Antes del Ironman hice 75Hard. 75 d&iacute;as de dos entrenamientos diarios, dieta estricta, 10 p&aacute;ginas de lectura, un gal&oacute;n de agua y cero alcohol. Sin excepciones. Fue el programa que resete&oacute; mi relaci&oacute;n con la disciplina.</p>','2026-03-23 15:51:13','2026-03-23 23:40:26',NULL),(6,1,'Cerro Tronador 360: documentar una montaña icónica','cerro-tronador-360-documentar-montana',NULL,NULL,4,'La experiencia de documentar el Cerro Tronador en 360°. Rutas, gear, drones y lo que se siente estar arriba de todo.','post','Published',1,'<p>El Cerro Tronador es una de esas montañas que te cambia la perspectiva — literalmente. A 3.478 metros, en la frontera entre Argentina y Chile, el mundo se ve diferente.</p><h3>El proyecto</h3><p>Tronador 360 nació como una idea simple: documentar la montaña desde todos los ángulos posibles. Drone, cámara, GoPro. Capturar lo que se siente estar ahí arriba, no solo lo que se ve.</p><h3>El gear</h3><p>DJI Mini 3 Pro para el drone (liviano, portátil, calidad suficiente). GoPro Hero para las tomas de acción. Y la cámara del celular para el detrás de escena. No necesitás el mejor equipo — necesitás estar ahí.</p><h3>Lo que aprendí</h3><p>Que la planificación es todo. Que el clima en la montaña cambia en 15 minutos. Que la paciencia es una skill más importante que cualquier técnica de fotografía. Y que hay momentos que ninguna foto captura — esos te los llevás adentro.</p><h3>La conexión con lo digital</h3><p>Documentar una montaña y documentar un sistema tienen más en común de lo que parece. Ambos requieren planificación, paciencia y la capacidad de adaptarte cuando las condiciones cambian.</p>','2026-03-23 15:51:13','2026-03-23 15:51:13',NULL),(7,1,'75Hard: lo que cambió después de 75 días sin negociar conmigo mismo','75hard-lo-que-cambio',NULL,NULL,7,'Mi experiencia con 75Hard de Andy Frisella. 75 días, dos entrenamientos diarios, dieta, lectura, cero excusas.','post','Published',0,'<p>75Hard no es un programa de fitness. Es un programa de <strong>mentalidad</strong>. Andy Frisella lo diseñó para resetear tu relación con la disciplina, y funciona.</p><h3>Las reglas</h3><ul><li>Dos entrenamientos de 45 minutos por día (uno tiene que ser al aire libre)</li><li>Dieta sin alcohol ni cheat meals</li><li>10 páginas de lectura de no-ficción</li><li>1 galón (3.7 litros) de agua</li><li>Foto de progreso diaria</li></ul><p>Si fallás en cualquiera, volvés al día 1. Sin excepciones.</p><h3>Lo que aprendí</h3><p>Que la mayoría de las limitaciones son negociaciones internas. Que cuando eliminás las opciones de escape, descubrís que podés mucho más de lo que creías. Que la disciplina no es restricción — es libertad.</p><h3>Cómo impactó en mi trabajo</h3><p>Después de 75Hard, mi forma de trabajar cambió. Menos procrastinación. Más ejecución directa. La misma mentalidad de \"no hay excusas\" aplicada a cada proyecto, cada decisión, cada día.</p><p>Si estás pensando en hacerlo: hacelo. No busques el momento perfecto. El momento perfecto es hoy.</p>','2026-03-23 15:51:13','2026-03-23 15:51:13',NULL),(8,1,'Mi setup de drone para montaña: gear list y consejos','setup-drone-montana-gear-list',NULL,NULL,6,'El equipo que uso para volar drones en montaña. Gear list, tips de vuelo en altura y errores que cometí.','post','Published',0,'<p>Volar un drone en montaña no es lo mismo que en la ciudad. El viento, la altura, el frío y las regulaciones cambian todo. Acá comparto mi setup y lo que aprendí.</p><h3>Mi gear actual</h3><ul><li><strong>Drone:</strong> DJI Mini 3 Pro — menos de 250g, no necesita registro en la mayoría de países, calidad excelente</li><li><strong>Baterías:</strong> Siempre llevo 3 mínimo. En frío duran menos</li><li><strong>Mochila:</strong> Case compacto que entra en cualquier mochila de trekking</li><li><strong>Filtros ND:</strong> Esenciales para nieve y mucha luz</li></ul><h3>Tips para volar en altura</h3><ul><li>A más de 2.500m el drone pierde sustentación. Volá más conservador</li><li>Calibrá la brújula antes de cada vuelo</li><li>Tené siempre visual del drone. En montaña las distancias engañan</li><li>Guardá las baterías en el bolsillo interior de la campera para mantenerlas tibias</li></ul><h3>El error que más cometí</h3><p>Subestimar el viento. En la montaña, una ráfaga puede aparecer de la nada. Si el drone marca más de 30 km/h de viento, no vale la pena arriesgarse.</p>','2026-03-23 15:51:13','2026-03-23 15:51:13',NULL);

--
-- Table structure for table `product_category_translations`
--

CREATE TABLE `product_category_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_category_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_category_translations_product_category_id_locale_unique` (`product_category_id`,`locale`),
  KEY `product_category_translations_locale_index` (`locale`),
  CONSTRAINT `product_category_translations_product_category_id_foreign` FOREIGN KEY (`product_category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `product_category_translations`
--


--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_images_product_id_foreign` (`product_id`),
  CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `product_images`
--


--
-- Table structure for table `product_product_tag`
--

CREATE TABLE `product_product_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `product_tag_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_product_tag_product_id_product_tag_id_unique` (`product_id`,`product_tag_id`),
  KEY `product_product_tag_product_tag_id_foreign` (`product_tag_id`),
  CONSTRAINT `product_product_tag_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_product_tag_product_tag_id_foreign` FOREIGN KEY (`product_tag_id`) REFERENCES `product_tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `product_product_tag`
--


--
-- Table structure for table `product_tags`
--

CREATE TABLE `product_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_tags_name_unique` (`name`),
  UNIQUE KEY `product_tags_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `product_tags`
--


--
-- Table structure for table `product_translations`
--

CREATE TABLE `product_translations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `locale` varchar(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_translations_product_id_locale_unique` (`product_id`,`locale`),
  KEY `product_translations_locale_index` (`locale`),
  KEY `product_translations_slug_index` (`slug`),
  CONSTRAINT `product_translations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `product_translations`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `landing_slug` varchar(255) DEFAULT NULL,
  `card_image` varchar(255) DEFAULT NULL,
  `card_specs` text DEFAULT NULL,
  `hero_poster` varchar(255) DEFAULT NULL,
  `hero_video_mp4` varchar(255) DEFAULT NULL,
  `hero_video_mov` varchar(255) DEFAULT NULL,
  `parallax_image` varchar(255) DEFAULT NULL,
  `parallax_description` text DEFAULT NULL,
  `parallax_components` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`parallax_components`)),
  `grid_image_1` varchar(255) DEFAULT NULL,
  `grid_image_2` varchar(255) DEFAULT NULL,
  `grid_image_3` varchar(255) DEFAULT NULL,
  `specs_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`specs_data`)),
  `description` text DEFAULT NULL,
  `tagline` varchar(255) DEFAULT NULL,
  `core_slug` varchar(100) DEFAULT NULL,
  `target_persona` text DEFAULT NULL,
  `pain_points` text DEFAULT NULL,
  `value_props` text DEFAULT NULL,
  `cta_primary` varchar(255) DEFAULT NULL,
  `keywords` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `stripe_price_id` varchar(255) DEFAULT NULL,
  `quantity_label` varchar(100) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_sold` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_slug_unique` (`slug`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `project_categories`
--

CREATE TABLE `project_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `project_categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `project_categories`
--

INSERT INTO `project_categories` VALUES (2,'Empresas','empresas','Las empresas que fundé y dirijo','2026-03-23 15:51:17','2026-03-23 15:51:17'),(3,'Emprendimientos','emprendimientos','Proyectos emprendedores pasados y presentes','2026-03-23 15:51:17','2026-03-23 15:51:17'),(4,'Aventura','aventura','Proyectos de exploración, expediciones y documentación outdoor','2026-03-23 15:51:17','2026-03-23 15:51:17');

--
-- Table structure for table `project_category_project`
--

CREATE TABLE `project_category_project` (
  `project_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  KEY `project_category_project_project_id_foreign` (`project_id`),
  KEY `project_category_project_category_id_foreign` (`category_id`),
  CONSTRAINT `project_category_project_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `project_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `project_category_project_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `project_category_project`
--

INSERT INTO `project_category_project` VALUES (4,2),(5,2),(6,4),(7,4),(8,4),(9,3),(10,3);

--
-- Table structure for table `project_project_tag`
--

CREATE TABLE `project_project_tag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` bigint(20) unsigned NOT NULL,
  `project_tag_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `project_project_tag_project_id_project_tag_id_unique` (`project_id`,`project_tag_id`),
  KEY `project_project_tag_project_tag_id_foreign` (`project_tag_id`),
  CONSTRAINT `project_project_tag_project_id_foreign` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `project_project_tag_project_tag_id_foreign` FOREIGN KEY (`project_tag_id`) REFERENCES `project_tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `project_project_tag`
--

INSERT INTO `project_project_tag` VALUES (4,4,2,NULL,NULL),(5,4,4,NULL,NULL),(6,5,2,NULL,NULL),(7,5,4,NULL,NULL),(8,6,2,NULL,NULL),(9,6,5,NULL,NULL),(10,7,2,NULL,NULL),(11,7,6,NULL,NULL),(12,8,2,NULL,NULL),(13,8,6,NULL,NULL),(14,9,3,NULL,NULL),(15,9,4,NULL,NULL),(16,10,3,NULL,NULL),(17,10,4,NULL,NULL);

--
-- Table structure for table `project_settings`
--

CREATE TABLE `project_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `project_settings`
--


--
-- Table structure for table `project_tags`
--

CREATE TABLE `project_tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `project_tags_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `project_tags`
--

INSERT INTO `project_tags` VALUES (1,'Destacado','destacado','Proyectos destacados','2026-03-23 15:04:38','2026-03-23 15:04:38'),(2,'Activo','activo','Proyectos en actividad','2026-03-23 15:51:17','2026-03-23 15:51:17'),(3,'Pasado','pasado','Proyectos finalizados','2026-03-23 15:51:17','2026-03-23 15:51:17'),(4,'Crear','crear','Pilar Crear','2026-03-23 15:51:17','2026-03-23 15:51:17'),(5,'Entrenar','entrenar','Pilar Entrenar','2026-03-23 15:51:17','2026-03-23 15:51:17'),(6,'Explorar','explorar','Pilar Explorar','2026-03-23 15:51:17','2026-03-23 15:51:17');

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `description` text DEFAULT NULL,
  `url` text DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `projects_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` VALUES (4,'Mi agencia digital. 10+ años acompañando empresas con sitios web profesionales, identidad digital y estrategia. 45+ proyectos entregados. El brazo ejecutor del ecosistema.','https://lacompaniadigital.com','Compañía Digital','compania-digital','','https://res.cloudinary.com/dupf7vvwj/image/upload/v1774309417/projects/dxucewbwvb752qtvyrpb.png',1,'2026-03-23 15:51:17','2026-03-23 23:43:38',NULL,NULL),(5,'Mi plataforma SaaS. Sistema modular de sitios web profesionales con modelo reseller. La tecnología que construí para escalar sin depender de mí.','https://bewpro.com','BewPro','bewpro','','',1,'2026-03-23 15:51:17','2026-03-23 15:51:17',NULL,NULL),(6,'Preparación para Ironman. Natación, bici y running — todo el año. No es solo un evento, es el sistema de disciplina que alimenta todo lo demás.','','Iron Man','iron-man','','',1,'2026-03-23 15:51:17','2026-03-23 15:51:17',NULL,NULL),(7,'Documentación 360° de una de las montañas icónicas de Patagonia. Drone, cámara, GoPro. Capturar lo que se siente estar arriba de todo.','','Cerro Tronador 360','cerro-tronador-360','','',1,'2026-03-23 15:51:17','2026-03-23 15:51:17',NULL,NULL),(8,'Rutas de nieve, splitboard y montaña invernal documentada. Experiencia y conocimiento técnico de travesía compartido.','','Guía de Esquí de Travesía y Splitboard','guia-de-esqui-de-travesia-y-splitboard','','',1,'2026-03-23 15:51:17','2026-03-23 15:51:17',NULL,NULL),(9,'Emprendimiento gastronómico. No todo es tech — emprender es emprender en cualquier rubro. Cada intento enseña más que cualquier curso.','','Taws & Fretta Pastas','taws-fretta-pastas','','',1,'2026-03-23 15:51:17','2026-03-23 15:51:17',NULL,NULL),(10,'Uno de mis primeros proyectos emprendedores. Experiencia temprana en producto digital. La base sobre la que se construyó todo lo demás.','','Ditrabajo','ditrabajo','','',1,'2026-03-23 15:51:17','2026-03-23 15:51:17',NULL,NULL);

--
-- Table structure for table `reference_categories`
--

CREATE TABLE `reference_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reference_categories_name_unique` (`name`),
  UNIQUE KEY `reference_categories_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `reference_categories`
--


--
-- Table structure for table `references`
--

CREATE TABLE `references` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `references_category_id_foreign` (`category_id`),
  CONSTRAINT `references_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `reference_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `references`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (21,1),(21,2),(22,1),(22,2),(23,1),(23,2),(24,1),(24,2);

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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `roles` VALUES (1,'System Admin','system-admin','An administrator has full power. In addition to everything an editor can do, administrators can manage users, themes, settings, widgets and plugins. This role is good for team leaders, or whoever will be “in charge” of the blog.','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(2,'Administrator','administrator','An administrator has full power. In addition to everything an editor can do, administrators can manage users, themes, settings, widgets and plugins. This role is good for team leaders, or whoever will be “in charge” of the blog.','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(3,'Editor','editor','An editor can create, edit, publish and delete any post or page. They can also moderate all comments, and manage categories and tags. This role is good for team members.','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(4,'Contributor','contributor','A contributor can only create and edit their own posts, but only an editor or administrator can publish them. Contributors have no access to anyone else’s posts, and cannot edit their own posts once they have published. This role is perfect for guest or student bloggers.','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(5,'Author','author','An author has the ability to create, edit, delete and publish their own posts. They can also upload media content, and edit comments on their own posts. However, they cannot touch anyone else’s posts or modify pages.','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(6,'Member','member','A member role is assigned to those users who do not have access to the administration panel.','web','2026-03-23 15:04:31','2026-03-23 15:04:31');

--
-- Table structure for table `service_categories`
--

CREATE TABLE `service_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `color` varchar(7) DEFAULT '#007bff',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `service_categories_slug_unique` (`slug`),
  KEY `service_categories_slug_index` (`slug`),
  KEY `service_categories_sort_order_index` (`sort_order`),
  KEY `service_categories_is_active_index` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `service_categories`
--


--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `service_category_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `benefits` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`benefits`)),
  `process_steps` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`process_steps`)),
  `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features`)),
  `faq` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`faq`)),
  `cta_config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`cta_config`)),
  `meta_keywords` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `slug` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `services_slug_unique` (`slug`),
  KEY `services_service_category_id_index` (`service_category_id`),
  CONSTRAINT `services_service_category_id_foreign` FOREIGN KEY (`service_category_id`) REFERENCES `service_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `services`
--


--
-- Table structure for table `subscription_items`
--

CREATE TABLE `subscription_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subscription_id` bigint(20) unsigned NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_product` varchar(255) NOT NULL,
  `stripe_price` varchar(255) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscription_items_stripe_id_unique` (`stripe_id`),
  KEY `subscription_items_subscription_id_stripe_price_index` (`subscription_id`,`stripe_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `subscription_items`
--


--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `stripe_id` varchar(255) NOT NULL,
  `stripe_status` varchar(255) NOT NULL,
  `stripe_price` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `trial_ends_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subscriptions_stripe_id_unique` (`stripe_id`),
  KEY `subscriptions_user_id_stripe_status_index` (`user_id`,`stripe_status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `subscriptions`
--


--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tags_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tags`
--


--
-- Table structure for table `team_categories`
--

CREATE TABLE `team_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `slug` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `team_categories_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `team_categories`
--


--
-- Table structure for table `team_members`
--

CREATE TABLE `team_members` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `linkedin` varchar(255) DEFAULT NULL,
  `languages` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`languages`)),
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `description` text DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `team_members_slug_unique` (`slug`),
  KEY `team_members_category_id_foreign` (`category_id`),
  CONSTRAINT `team_members_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `team_categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `team_members`
--


--
-- Table structure for table `tokko_settings`
--

CREATE TABLE `tokko_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tokko_settings_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tokko_settings`
--


--
-- Table structure for table `user_infos`
--

CREATE TABLE `user_infos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `avatar` text DEFAULT NULL,
  `avatar_public_id` varchar(255) DEFAULT NULL,
  `avatar_url` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `member_since` date DEFAULT NULL,
  `linkedin` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_infos_user_id_foreign` (`user_id`),
  CONSTRAINT `user_infos_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `user_infos`
--

INSERT INTO `user_infos` VALUES (1,1,NULL,NULL,NULL,'944-15-8925','+34 968-195097',NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32',NULL,NULL,NULL),(2,2,NULL,NULL,NULL,'964 364248','+34 983-71-9235',NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32',NULL,NULL,NULL),(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32',NULL,NULL,NULL);

--
-- Table structure for table `welcome_carousels`
--

CREATE TABLE `welcome_carousels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image_path` varchar(255) NOT NULL,
  `public_id` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `welcome_carousels`
--

INSERT INTO `welcome_carousels` VALUES (1,'7',NULL,NULL,'https://res.cloudinary.com/dupf7vvwj/image/upload/v1774297651/jlg81rqpjeau8vlgmm3d.jpg','jlg81rqpjeau8vlgmm3d',1,'2026-03-23 20:27:32','2026-03-23 20:27:32');


