-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for osx10.10 (x86_64) -- -- Host: localhost Database: bp-coke -- ------------------------------------------------------ -- Server version 10.4.28-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `activity_log` -- DROP TABLE IF EXISTS `activity_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_log` -- LOCK TABLES `activity_log` WRITE; /*!40000 ALTER TABLE `activity_log` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `activity_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `album_picture` -- DROP TABLE IF EXISTS `album_picture`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `album_picture` -- LOCK TABLES `album_picture` WRITE; /*!40000 ALTER TABLE `album_picture` DISABLE KEYS */; /*!40000 ALTER TABLE `album_picture` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `album_tag` -- DROP TABLE IF EXISTS `album_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `album_tag` -- LOCK TABLES `album_tag` WRITE; /*!40000 ALTER TABLE `album_tag` DISABLE KEYS */; /*!40000 ALTER TABLE `album_tag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `albums` -- DROP TABLE IF EXISTS `albums`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `albums` -- LOCK TABLES `albums` WRITE; /*!40000 ALTER TABLE `albums` DISABLE KEYS */; /*!40000 ALTER TABLE `albums` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assets` -- DROP TABLE IF EXISTS `assets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assets` -- LOCK TABLES `assets` WRITE; /*!40000 ALTER TABLE `assets` DISABLE KEYS */; /*!40000 ALTER TABLE `assets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `carousel_picture` -- DROP TABLE IF EXISTS `carousel_picture`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `carousel_picture` -- LOCK TABLES `carousel_picture` WRITE; /*!40000 ALTER TABLE `carousel_picture` DISABLE KEYS */; /*!40000 ALTER TABLE `carousel_picture` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `carousels` -- DROP TABLE IF EXISTS `carousels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `carousels` -- LOCK TABLES `carousels` WRITE; /*!40000 ALTER TABLE `carousels` DISABLE KEYS */; /*!40000 ALTER TABLE `carousels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `company_logos` -- DROP TABLE IF EXISTS `company_logos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `company_logos` -- LOCK TABLES `company_logos` WRITE; /*!40000 ALTER TABLE `company_logos` DISABLE KEYS */; /*!40000 ALTER TABLE `company_logos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_messages` -- DROP TABLE IF EXISTS `contact_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_messages` -- LOCK TABLES `contact_messages` WRITE; /*!40000 ALTER TABLE `contact_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demos` -- DROP TABLE IF EXISTS `demos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `demos` -- LOCK TABLES `demos` WRITE; /*!40000 ALTER TABLE `demos` DISABLE KEYS */; /*!40000 ALTER TABLE `demos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs_categories` -- DROP TABLE IF EXISTS `faqs_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs_categories` -- LOCK TABLES `faqs_categories` WRITE; /*!40000 ALTER TABLE `faqs_categories` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `faqs_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gallery` -- DROP TABLE IF EXISTS `gallery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gallery` -- LOCK TABLES `gallery` WRITE; /*!40000 ALTER TABLE `gallery` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `gallery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gallery_categories` -- DROP TABLE IF EXISTS `gallery_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gallery_categories` -- LOCK TABLES `gallery_categories` WRITE; /*!40000 ALTER TABLE `gallery_categories` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `gallery_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gallery_gallery_tag` -- DROP TABLE IF EXISTS `gallery_gallery_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gallery_gallery_tag` -- LOCK TABLES `gallery_gallery_tag` WRITE; /*!40000 ALTER TABLE `gallery_gallery_tag` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `gallery_gallery_tag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gallery_tags` -- DROP TABLE IF EXISTS `gallery_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gallery_tags` -- LOCK TABLES `gallery_tags` WRITE; /*!40000 ALTER TABLE `gallery_tags` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `gallery_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `languages` -- DROP TABLE IF EXISTS `languages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `languages` -- LOCK TABLES `languages` WRITE; /*!40000 ALTER TABLE `languages` DISABLE KEYS */; /*!40000 ALTER TABLE `languages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_categories` -- DROP TABLE IF EXISTS `menu_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_categories` -- LOCK TABLES `menu_categories` WRITE; /*!40000 ALTER TABLE `menu_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `menu_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_menu_product` -- DROP TABLE IF EXISTS `menu_menu_product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_menu_product` -- LOCK TABLES `menu_menu_product` WRITE; /*!40000 ALTER TABLE `menu_menu_product` DISABLE KEYS */; /*!40000 ALTER TABLE `menu_menu_product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu_products` -- DROP TABLE IF EXISTS `menu_products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu_products` -- LOCK TABLES `menu_products` WRITE; /*!40000 ALTER TABLE `menu_products` DISABLE KEYS */; /*!40000 ALTER TABLE `menu_products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menus` -- DROP TABLE IF EXISTS `menus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menus` -- LOCK TABLES `menus` WRITE; /*!40000 ALTER TABLE `menus` DISABLE KEYS */; /*!40000 ALTER TABLE `menus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_permissions` -- DROP TABLE IF EXISTS `model_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_permissions` -- LOCK TABLES `model_has_permissions` WRITE; /*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `model_has_roles` -- DROP TABLE IF EXISTS `model_has_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `model_has_roles` -- LOCK TABLES `model_has_roles` WRITE; /*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */; INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(2,'App\\Models\\User',3); /*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `newsletter_subscribers` -- DROP TABLE IF EXISTS `newsletter_subscribers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `newsletter_subscribers` -- LOCK TABLES `newsletter_subscribers` WRITE; /*!40000 ALTER TABLE `newsletter_subscribers` DISABLE KEYS */; /*!40000 ALTER TABLE `newsletter_subscribers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'create content','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(2,'read content','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(3,'update content','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(4,'delete content','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(5,'create user','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(6,'read user','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(7,'update user','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(8,'delete user','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(9,'create role','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(10,'read role','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(11,'update role','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(12,'delete role','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(13,'create permission','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(14,'read permission','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(15,'update permission','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(16,'delete permission','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(17,'create products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(18,'read products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(19,'update products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(20,'delete products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(21,'view_products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(22,'create_products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(23,'edit_products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(24,'delete_products','web','2026-03-23 15:04:31','2026-03-23 15:04:31'),(25,'view_blog','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(26,'create_blog','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(27,'edit_blog','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(28,'delete_blog','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(29,'view_services','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(30,'create_services','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(31,'edit_services','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(32,'delete_services','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(33,'view_projects','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(34,'create_projects','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(35,'edit_projects','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(36,'delete_projects','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(37,'view_gallery','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(38,'create_gallery','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(39,'edit_gallery','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(40,'delete_gallery','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(41,'view_newsletter','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(42,'create_newsletter','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(43,'edit_newsletter','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(44,'delete_newsletter','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(45,'view_faqs','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(46,'create_faqs','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(47,'edit_faqs','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(48,'delete_faqs','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(49,'view_references','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(50,'create_references','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(51,'edit_references','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(52,'delete_references','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(53,'view_menus','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(54,'create_menus','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(55,'edit_menus','web','2026-03-23 15:04:32','2026-03-23 15:04:32'),(56,'delete_menus','web','2026-03-23 15:04:32','2026-03-23 15:04:32'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `picture_tag` -- DROP TABLE IF EXISTS `picture_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `picture_tag` -- LOCK TABLES `picture_tag` WRITE; /*!40000 ALTER TABLE `picture_tag` DISABLE KEYS */; /*!40000 ALTER TABLE `picture_tag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pictures` -- DROP TABLE IF EXISTS `pictures`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pictures` -- LOCK TABLES `pictures` WRITE; /*!40000 ALTER TABLE `pictures` DISABLE KEYS */; /*!40000 ALTER TABLE `pictures` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `post_categories` -- DROP TABLE IF EXISTS `post_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `post_categories` -- LOCK TABLES `post_categories` WRITE; /*!40000 ALTER TABLE `post_categories` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `post_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `post_category_translations` -- DROP TABLE IF EXISTS `post_category_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `post_category_translations` -- LOCK TABLES `post_category_translations` WRITE; /*!40000 ALTER TABLE `post_category_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `post_category_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `post_translations` -- DROP TABLE IF EXISTS `post_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `post_translations` -- LOCK TABLES `post_translations` WRITE; /*!40000 ALTER TABLE `post_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `post_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `posts` -- DROP TABLE IF EXISTS `posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `posts` -- LOCK TABLES `posts` WRITE; /*!40000 ALTER TABLE `posts` DISABLE KEYS */; 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,'

En 2020 arranqué Compañía Digital sin plan de negocios, sin inversores y sin oficina. Solo tenía una laptop, conexión a internet y la convicción de que podía construir algo que funcionara.

\r\n

Hoy, 6 años después, la agencia lleva 50+ proyectos entregados, un equipo que creció orgánicamente y una operación que funciona sin que yo esté encima de cada detalle.

\r\n

Lo que aprendí

\r\n

Lo más importante no fue aprender a programar mejor o a vender más. Fue entender que un sistema bien diseñado se sostiene solo. Que la clave no es trabajar más horas, sino construir procesos que funcionen cuando no estás.

\r\n

Eso mismo aplica al entrenamiento, a la montaña, a todo. Si el sistema es sólido, los resultados vienen.

\r\n

El error más grande

\r\n

Querer hacer todo yo. Tardé años en entender que delegar no es perder control — es escalar. La misma lección que me dio el 75Hard: no negociar con vos mismo.

\r\n

Lo que viene

\r\n

Compañía Digital hoy es el brazo ejecutor. BewPro es la plataforma que escala. Y este espacio es donde comparto el proceso real — sin filtros, sin marketing.

','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,'

BewPro nació de una frustración: cada cliente de Compañía Digital necesitaba un sitio web, y yo estaba construyendo cada uno desde cero. Era insostenible.

\r\n

La pregunta fue simple: ¿y si construyo un sistema que me permita crear sitios profesionales en horas en vez de semanas?

\r\n

La decisión

\r\n

Podría haber usado WordPress, Wix, o cualquier plataforma existente. Pero ninguna me daba el control que necesitaba. Quería módulos que se combinaran como bloques, demos visuales que se adaptaran a cada industria, y una arquitectura que escalara sin depender de mí.

\r\n

El modelo

\r\n

BewPro funciona con resellers. No vendo directo al cliente final — vendo la plataforma a agencias y profesionales que la usan para sus propios clientes. Es escalar sin centralizar.

\r\n

Lo que aprendí construyéndola

\r\n

Construir un SaaS es muy diferente a hacer sitios para clientes. Es pensar en sistemas, no en páginas. Es diseñar para 100 proyectos, no para uno. La misma mentalidad que uso cuando planeo una travesía en la montaña: preparación, sistema, ejecución.

','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,'

La gente me pregunta: ¿cuándo es el Ironman? Y la respuesta honesta es: no importa cuándo sea. Lo que importa es que entreno todos los días.

\r\n

Un Ironman son 3.8 km de natación, 180 km de bici y 42 km de running. Pero la carrera es solo el resultado. El proceso es lo que te cambia.

\r\n

Mi rutina semanal

\r\n

Natación 3 veces por semana. Bici (ruta o MTB) 3-4 veces. Running 2-3 veces. Gym 2 veces. No todos los días son épicos — la mayoría son comunes. Y eso es exactamente el punto.

\r\n

Lo que el entrenamiento me enseñó sobre emprender

\r\n

Que los días comunes son los que te construyen. Que la motivación es mentira — lo que funciona es el sistema. Que si negociás con vos mismo una vez, negociás siempre.

\r\n

Andy Frisella lo dice mejor que nadie: no es sobre sentirte bien, es sobre hacer lo que hay que hacer.

\r\n

75Hard fue el reset

\r\n

Antes del Ironman hice 75Hard. 75 días de dos entrenamientos diarios, dieta estricta, 10 páginas de lectura, un galón de agua y cero alcohol. Sin excepciones. Fue el programa que reseteó mi relación con la disciplina.

','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,'

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.

El proyecto

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.

El gear

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í.

Lo que aprendí

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.

La conexión con lo digital

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.

','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,'

75Hard no es un programa de fitness. Es un programa de mentalidad. Andy Frisella lo diseñó para resetear tu relación con la disciplina, y funciona.

Las reglas

Si fallás en cualquiera, volvés al día 1. Sin excepciones.

Lo que aprendí

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.

Cómo impactó en mi trabajo

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.

Si estás pensando en hacerlo: hacelo. No busques el momento perfecto. El momento perfecto es hoy.

','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,'

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í.

Mi gear actual

Tips para volar en altura

El error que más cometí

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.

','2026-03-23 15:51:13','2026-03-23 15:51:13',NULL); /*!40000 ALTER TABLE `posts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_category_translations` -- DROP TABLE IF EXISTS `product_category_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_category_translations` -- LOCK TABLES `product_category_translations` WRITE; /*!40000 ALTER TABLE `product_category_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `product_category_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_images` -- DROP TABLE IF EXISTS `product_images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_images` -- LOCK TABLES `product_images` WRITE; /*!40000 ALTER TABLE `product_images` DISABLE KEYS */; /*!40000 ALTER TABLE `product_images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_product_tag` -- DROP TABLE IF EXISTS `product_product_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_product_tag` -- LOCK TABLES `product_product_tag` WRITE; /*!40000 ALTER TABLE `product_product_tag` DISABLE KEYS */; /*!40000 ALTER TABLE `product_product_tag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_tags` -- DROP TABLE IF EXISTS `product_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_tags` -- LOCK TABLES `product_tags` WRITE; /*!40000 ALTER TABLE `product_tags` DISABLE KEYS */; /*!40000 ALTER TABLE `product_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_translations` -- DROP TABLE IF EXISTS `product_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_translations` -- LOCK TABLES `product_translations` WRITE; /*!40000 ALTER TABLE `product_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `product_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project_categories` -- DROP TABLE IF EXISTS `project_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `project_categories` -- LOCK TABLES `project_categories` WRITE; /*!40000 ALTER TABLE `project_categories` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `project_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project_category_project` -- DROP TABLE IF EXISTS `project_category_project`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `project_category_project` -- LOCK TABLES `project_category_project` WRITE; /*!40000 ALTER TABLE `project_category_project` DISABLE KEYS */; INSERT INTO `project_category_project` VALUES (4,2),(5,2),(6,4),(7,4),(8,4),(9,3),(10,3); /*!40000 ALTER TABLE `project_category_project` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project_project_tag` -- DROP TABLE IF EXISTS `project_project_tag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `project_project_tag` -- LOCK TABLES `project_project_tag` WRITE; /*!40000 ALTER TABLE `project_project_tag` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `project_project_tag` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project_settings` -- DROP TABLE IF EXISTS `project_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `project_settings` -- LOCK TABLES `project_settings` WRITE; /*!40000 ALTER TABLE `project_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `project_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project_tags` -- DROP TABLE IF EXISTS `project_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `project_tags` -- LOCK TABLES `project_tags` WRITE; /*!40000 ALTER TABLE `project_tags` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `project_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `projects` -- DROP TABLE IF EXISTS `projects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `projects` -- LOCK TABLES `projects` WRITE; /*!40000 ALTER TABLE `projects` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `projects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reference_categories` -- DROP TABLE IF EXISTS `reference_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reference_categories` -- LOCK TABLES `reference_categories` WRITE; /*!40000 ALTER TABLE `reference_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `reference_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `references` -- DROP TABLE IF EXISTS `references`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `references` -- LOCK TABLES `references` WRITE; /*!40000 ALTER TABLE `references` DISABLE KEYS */; /*!40000 ALTER TABLE `references` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_has_permissions` -- DROP TABLE IF EXISTS `role_has_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_has_permissions` -- LOCK TABLES `role_has_permissions` WRITE; /*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */; INSERT INTO `role_has_permissions` VALUES (21,1),(21,2),(22,1),(22,2),(23,1),(23,2),(24,1),(24,2); /*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `service_categories` -- DROP TABLE IF EXISTS `service_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `service_categories` -- LOCK TABLES `service_categories` WRITE; /*!40000 ALTER TABLE `service_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `service_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `services` -- DROP TABLE IF EXISTS `services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `services` -- LOCK TABLES `services` WRITE; /*!40000 ALTER TABLE `services` DISABLE KEYS */; /*!40000 ALTER TABLE `services` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `key` varchar(255) NOT NULL, `value` text NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `settings_key_index` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'description','LCD CMS',1),(2,'plan','Full Plan',1),(3,'title','La Compañía Digital',1),(4,'description','Content Management System Standard - Version 1.0',1),(5,'keywords','Words separated with \",\" to will found on internet',1),(6,'home_maintenance','0',1),(7,'about_maintenance','0',1),(8,'contact_maintenance','0',1),(9,'blog','0',1),(10,'personal_blog','0',1),(11,'gallery_maintenance','0',1),(12,'maintenance_mode','0',1),(13,'services_maintenance','0',1),(14,'faqs_maintenance','0',1),(15,'team_maintenance','0',1),(16,'portfolio_maintenance','0',1),(17,'news_maintenance','0',1),(18,'tokko_maintenance','0',1),(19,'cd-system.theme.demo','demo-accounting-2',1),(20,'cd-system.theme.skin','auto',1),(21,'cd-system.theme.fonts.primary','Space Grotesk',1),(22,'cd-system.theme.fonts.secondary','Space Grotesk',1),(23,'cd-system.theme.fonts.tertiary','Inter',1),(24,'cd-system.modules.blog.active','1',1),(25,'cd-system.modules.blog.navigation.header','1',1),(26,'cd-system.modules.blog.navigation.footer','1',1),(27,'cd-system.modules.products.active','0',1),(28,'cd-system.modules.services.active','0',1),(29,'cd-system.modules.projects.active','1',1),(30,'cd-system.modules.projects.navigation.header','1',1),(31,'cd-system.modules.projects.navigation.footer','1',1),(32,'cd-system.modules.gallery.active','1',1),(33,'cd-system.modules.gallery.navigation.header','1',1),(34,'cd-system.modules.gallery.navigation.footer','1',1),(35,'cd-system.modules.newsletter.active','0',1),(36,'cd-system.modules.faqs.active','1',1),(37,'cd-system.modules.faqs.navigation.header','0',1),(38,'cd-system.modules.faqs.navigation.footer','1',1),(39,'cd-system.modules.team.active','0',1),(40,'cd-system.modules.about.active','1',1),(41,'cd-system.modules.about.navigation.header','1',1),(42,'cd-system.modules.about.navigation.footer','1',1),(43,'cd-system.modules.contact.active','1',1),(44,'cd-system.modules.contact.navigation.header','1',1),(45,'cd-system.modules.contact.navigation.footer','1',1),(46,'cd-system.modules.news.active','0',1),(47,'cd-system.modules.references.active','0',1),(48,'cd-system.modules.project-setup.active','1',1),(49,'cd-system.modules.translations.active','0',1),(50,'cd-system.modules.menu.active','0',1),(51,'cd-system.maintenance.enabled','0',1),(52,'cd-system.maintenance.allowed_ips','[\"127.0.0.1\",\"::1\"]',1),(53,'site.name','COKE',1),(54,'site.tagline','Human Intelligence for a Modular World',1),(55,'site.url','https://cokecolombres.com',1),(56,'site.author','Coke Colombres',1),(57,'site.description','Coke Colombres — Proyectos, aventuras y proceso. Todo conectado.',1),(58,'site.contact.phone','',1),(59,'site.contact.email','hello@cokecolombres.com',1),(60,'site.contact.address','Tucumán, Argentina',1),(61,'site.contact.hours','',1),(62,'site.social_media.instagram.url','https://www.instagram.com/cokecolombres',2),(63,'site.social_media.instagram.icon','fab fa-instagram',2),(64,'site.social_media.instagram.title','Instagram',2),(65,'site.social_media.instagram.active','1',2),(66,'site.social_media.facebook.url','https://www.facebook.com/cokecolombres/',2),(67,'site.social_media.facebook.icon','fab fa-facebook-f',2),(68,'site.social_media.facebook.title','Facebook',2),(69,'site.social_media.facebook.active','1',2),(70,'site.social_media.linkedin.url','https://www.linkedin.com/in/cokecolombres',2),(71,'site.social_media.linkedin.icon','fab fa-linkedin-in',2),(72,'site.social_media.linkedin.title','Linkedin',2),(73,'site.social_media.linkedin.active','1',2),(74,'site.social_media.youtube.url','https://www.youtube.com/@cokecolombres',2),(75,'site.social_media.youtube.icon','fab fa-youtube',2),(76,'site.social_media.youtube.title','Youtube',2),(77,'site.social_media.youtube.active','1',2),(78,'site.social_media.whatsapp.url','https://api.whatsapp.com/send?phone=5493812481001',2),(79,'site.social_media.whatsapp.icon','fab fa-whatsapp',2),(80,'site.social_media.whatsapp.title','Whatsapp',2),(81,'site.social_media.whatsapp.active','0',2),(82,'site.social_media.tripadvisor.url','',2),(83,'site.social_media.tripadvisor.icon','fab fa-tripadvisor',2),(84,'site.social_media.tripadvisor.title','Tripadvisor',2),(85,'site.social_media.tripadvisor.active','0',2),(86,'site.header.cta_button.active','1',1),(87,'site.header.cta_button.title','Blog',1),(88,'site.header.cta_button.url','/blog',1),(89,'site.header.cta_button.target','_self',1),(90,'site.header.cta_button.style','primary',1),(91,'site.development.enabled','0',1),(92,'site.seo.keywords','coke colombres, marca personal, emprendedor tucuman, ironman argentina, splitboard, montaña, outdoor, tecnología, BewPro, Compañía Digital, 75hard, MTB, drone, trekking',1),(93,'site.seo.description','Coke Colombres — Founder de Compañía Digital y BewPro. Ironman en preparación. Explorador de montaña. Tips, aventuras y proyectos desde Tucumán.',1),(94,'site.seo.title','COKE — Crear · Entrenar · Explorar',1),(95,'site.seo.title_template','{title} | {site_name}',1),(96,'site.seo.schema.type','Person',1),(97,'site.seo.schema.name','Coke Colombres',1),(98,'site.seo.schema.url','https://cokecolombres.com',1),(99,'site.seo.schema.logo','cd-project/assets/logo.png',1),(100,'site.seo.schema.description','Founder de Compañía Digital y BewPro. En preparación para un Ironman. Explorador de montaña. Tucumán, Argentina.',1),(101,'site.og.title','COKE — Crear · Entrenar · Explorar',1),(102,'site.og.description','Founder de Compañía Digital y BewPro. Ironman en preparación. Explorador de montaña. Tips, aventuras y proyectos — todo conectado.',1),(103,'site.og.url','https://cokecolombres.com',1),(104,'site.og.site_name','COKE',1),(105,'site.og.image','cd-project/assets/og-image.png',1),(106,'site.og.image_alt','COKE — Crear · Entrenar · Explorar',1),(107,'site.twitter.title','COKE — Crear · Entrenar · Explorar',1),(108,'site.twitter.description','Founder de CD y BewPro. Ironman en prep. Explorador de montaña. Tips, aventuras y proyectos.',1),(109,'site.twitter.image','cd-project/assets/twitter-image.png',1),(110,'site.twitter.image_alt','COKE — Crear · Entrenar · Explorar',1),(111,'site.assets.main_logo_alt','COKE — Crear · Entrenar · Explorar',1),(112,'site.assets.favicon','cd-project/assets/favicon.ico',1),(113,'site.assets.apple_touch_icon','cd-project/assets/apple-touch-icon.png',1),(114,'site.assets.loader_logo','cd-project/assets/logo-2.png',1),(115,'site.assets.main_logo','cd-project/assets/logo.png',1),(116,'site.assets.main_logo_sticky','cd-project/assets/logo.png',1),(117,'site.assets.footer_logo','cd-project/assets/logo-alternative.png',1),(118,'site.assets.main_logo_height','60',1),(119,'site.auth.login_title','Panel de Administración',1),(120,'site.auth.login_subtitle','COKE',1),(121,'site.google_analytics','{\"enabled\":true,\"tracking_id\":\"G-HE51BDB59B\",\"tracking_id_dev\":null,\"track_in_local\":false}',1),(122,'site.footer.tagline','Crear.',NULL),(123,'site.footer.tagline_highlight','Entrenar.',NULL),(124,'site.footer.tagline_suffix','Explorar.',NULL),(125,'site.footer.tagline_emphasis','',NULL),(126,'site.footer.description','Proyectos. Aventuras. Proceso. Todo conectado. Founder de Compañía Digital y BewPro.',NULL),(127,'site.footer.copyright_text','Todos los derechos reservados.',NULL),(128,'site.about.badge','Founder · Director · Explorer',NULL),(129,'site.about.main_title','Tecnología. Aventura. Disciplina.',NULL),(130,'site.about.main_subtitle','Todo al mismo nivel.',NULL),(131,'site.about.main_description','Creo empresas con la misma intensidad con la que entreno y exploro. La tecnología me da el método, la montaña me da la claridad, la disciplina sostiene todo lo demás.',NULL),(132,'site.about.description_1','Fundé Compañía Digital hace más de 10 años. Después creé BewPro como plataforma SaaS. Hoy dirijo ambas mientras me preparo para un Ironman y exploro montañas con splitboard, MTB y drones.',NULL),(133,'site.about.description_2','No estudié en una universidad tradicional. Estudié construyendo empresas, subiendo montañas y entrenando todos los días. Platzi, 75Hard, y 10+ años de ejecución real.',NULL),(134,'site.about.description_3','La disciplina es libertad. Lo que repetís te construye. Ganar días comunes crea resultados extraordinarios.',NULL),(135,'site.about.value_1_title','Crear',NULL),(136,'site.about.value_1_description','Compañía Digital, BewPro, y cada emprendimiento. 45+ proyectos entregados en 10+ años.',NULL),(137,'site.about.value_2_title','Entrenar',NULL),(138,'site.about.value_2_description','Ironman en preparación. 75Hard completado. 8+ deportes activos. La disciplina sostiene todo.',NULL),(139,'site.about.value_3_title','Explorar',NULL),(140,'site.about.value_3_description','Snowboard, MTB, trekking, kayak, drones. 15+ destinos documentados. La montaña ordena.',NULL),(141,'site.about.team_title','¿Querés saber más? Escribime.',NULL),(142,'site.contact.page_title','Escribime.',NULL),(143,'site.contact.page_subtitle','No vendo servicios acá. Pero si tenés un proyecto interesante, una idea que vale la pena, o simplemente querés conectar — escribime.',NULL),(144,'site.contact.availability_text','Siempre en movimiento. Si hay algo que vale la pena, hablamos.',NULL),(145,'site.contact.company_label','Asunto',NULL),(146,'site.contact.location_label','Ubicación',NULL),(147,'site.contact.social_label','Seguime',NULL),(148,'site.contact.phone_label','Llamame',NULL),(149,'site.contact.email_label','Escribime',NULL),(150,'site.footer.newsletter_title','Newsletter',NULL),(151,'site.footer.newsletter_text','Tips, aventuras, proyectos y novedades directo a tu email.',NULL),(152,'site.about.tagline','La montaña ordena. La disciplina sostiene.',NULL),(153,'site.about.connect_description','¿Querés saber más sobre lo que hago? Conectemos.',NULL),(154,'site.modules.blog.page_header.title','Blog',NULL),(155,'site.modules.blog.page_header.subtitle','Tips, aventuras, proyectos y reflexiones. Todo conectado.',NULL),(156,'site.modules.projects.page_header.title','Proyectos',NULL),(157,'site.modules.projects.page_header.subtitle','Lo que fundé, lo que construí y lo que sigo explorando.',NULL),(158,'site.modules.gallery.page_header.title','Galería',NULL),(159,'site.modules.gallery.page_header.subtitle','Snowboard, drone, MTB, trekking, training y más. Documentación visual del proceso.',NULL),(160,'site.modules.faqs.page_header.title','Preguntas Frecuentes',NULL),(161,'site.modules.faqs.page_header.subtitle','Lo que más me preguntan sobre lo que hago, la montaña y el entrenamiento.',NULL),(162,'site.modules.about.page_header.title','Sobre Mí',NULL),(163,'site.modules.about.page_header.subtitle','Founder de Compañía Digital y BewPro. En preparación para un Ironman. Explorador de montaña.',NULL),(164,'site.modules.contact.page_header.title','Contacto',NULL),(165,'site.modules.contact.page_header.subtitle','¿Querés saber más? Escribime.',NULL),(166,'site.footer.navegacion_principal.blog.title','Blog',NULL),(167,'site.footer.navegacion_principal.blog.url','/blog',NULL),(168,'site.footer.navegacion_principal.blog.active','1',NULL),(169,'site.footer.navegacion_principal.blog.order','1',NULL),(170,'site.footer.navegacion_principal.projects.title','Proyectos',NULL),(171,'site.footer.navegacion_principal.projects.url','/projects',NULL),(172,'site.footer.navegacion_principal.projects.active','1',NULL),(173,'site.footer.navegacion_principal.projects.order','2',NULL),(174,'site.footer.navegacion_principal.gallery.title','Galería',NULL),(175,'site.footer.navegacion_principal.gallery.url','/gallery',NULL),(176,'site.footer.navegacion_principal.gallery.active','1',NULL),(177,'site.footer.navegacion_principal.gallery.order','3',NULL),(178,'site.footer.navegacion_principal.about.title','Sobre Mí',NULL),(179,'site.footer.navegacion_principal.about.url','/about',NULL),(180,'site.footer.navegacion_principal.about.active','1',NULL),(181,'site.footer.navegacion_principal.about.order','4',NULL),(182,'site.footer.navegacion_principal.faqs.title','FAQs',NULL),(183,'site.footer.navegacion_principal.faqs.url','/faqs',NULL),(184,'site.footer.navegacion_principal.faqs.active','1',NULL),(185,'site.footer.navegacion_principal.faqs.order','5',NULL),(186,'site.footer.navegacion_principal.contact.title','Contacto',NULL),(187,'site.footer.navegacion_principal.contact.url','/contact',NULL),(188,'site.footer.navegacion_principal.contact.active','1',NULL),(189,'site.footer.navegacion_principal.contact.order','6',NULL),(190,'site.footer.modulos_principales_title','Explorar',NULL),(191,'site.contact.company_placeholder','Proyecto, colaboración, idea, consulta...',NULL),(192,'site.contact.success_message','¡Mensaje enviado! Te respondo pronto.',NULL),(193,'site.contact.error_message','Hubo un error al enviar tu mensaje. Intentá de nuevo.',NULL),(194,'site.social_media.x.url','',2),(195,'site.social_media.x.active','0',2),(196,'site.social_media.x.icon','fab fa-x-twitter',2),(197,'site.social_media.x.title','X',2),(198,'site.page_header.show_phone','0',NULL),(199,'site.page_header.show_cta','1',NULL),(200,'site.page_header.cta_title','Blog',NULL),(201,'site.page_header.cta_url','/blog',NULL),(202,'site.gallery.sidebar_title','Categorías',NULL),(203,'site.gallery.tags_title','Pilares',NULL),(204,'site.gallery.empty_title','Contenido en camino',NULL),(205,'site.gallery.empty_text','Las fotos se están cargando. Snowboard, drone, MTB, trekking y más — volvé pronto.',NULL),(206,'site.page_header.compact','1',NULL),(207,'site.header.show_search','0',NULL),(208,'site.mail.from_name','COKE',NULL); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscription_items` -- DROP TABLE IF EXISTS `subscription_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscription_items` -- LOCK TABLES `subscription_items` WRITE; /*!40000 ALTER TABLE `subscription_items` DISABLE KEYS */; /*!40000 ALTER TABLE `subscription_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subscriptions` -- DROP TABLE IF EXISTS `subscriptions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subscriptions` -- LOCK TABLES `subscriptions` WRITE; /*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tags` -- DROP TABLE IF EXISTS `tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tags` -- LOCK TABLES `tags` WRITE; /*!40000 ALTER TABLE `tags` DISABLE KEYS */; /*!40000 ALTER TABLE `tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_categories` -- DROP TABLE IF EXISTS `team_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_categories` -- LOCK TABLES `team_categories` WRITE; /*!40000 ALTER TABLE `team_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `team_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_members` -- DROP TABLE IF EXISTS `team_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_members` -- LOCK TABLES `team_members` WRITE; /*!40000 ALTER TABLE `team_members` DISABLE KEYS */; /*!40000 ALTER TABLE `team_members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tokko_settings` -- DROP TABLE IF EXISTS `tokko_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tokko_settings` -- LOCK TABLES `tokko_settings` WRITE; /*!40000 ALTER TABLE `tokko_settings` DISABLE KEYS */; /*!40000 ALTER TABLE `tokko_settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_infos` -- DROP TABLE IF EXISTS `user_infos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_infos` -- LOCK TABLES `user_infos` WRITE; /*!40000 ALTER TABLE `user_infos` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `user_infos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `slug` varchar(50) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `role_id` bigint(20) unsigned NOT NULL, `two_step` tinyint(1) NOT NULL DEFAULT 0, `api_token` varchar(80) DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `stripe_id` varchar(255) DEFAULT NULL, `pm_type` varchar(255) DEFAULT NULL, `pm_last_four` varchar(4) DEFAULT NULL, `trial_ends_at` timestamp NULL DEFAULT NULL, `last_login_at` datetime DEFAULT NULL, `last_login_ip` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), UNIQUE KEY `users_api_token_unique` (`api_token`), KEY `users_stripe_id_index` (`stripe_id`), KEY `users_role_id_foreign` (`role_id`), CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Admin','Bewpro','admin-bewpro','admin@bewpro.com','2026-03-23 15:04:32','$2y$10$uObHU89ZMAIQUkAz/gUv8uTQN/9O7F71eLCwsT8gmlbAmAc6luZ4O',1,0,'$2y$10$TD.zipxy2Ny144PzpvovxuR2OO2F9oQ3pPtrDzSTwVR.oD.9fVD5m',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32',NULL,NULL,NULL,NULL,NULL,NULL),(2,'User','Bewpro','user-bewpro','user@bewpro.com','2026-03-23 15:04:32','$2y$10$.PqiDmVHeGRIsZJx1NAJiecYR6mQbTq3UqAnTFtKkF.0OIYvlnjue',2,0,'$2y$10$DnuzcTBsxVnZBrIQrx7KWuO8YWxwVyYqgwcP3FDrgjN3lw3cSg53q',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32',NULL,NULL,NULL,NULL,NULL,NULL),(3,'Admin','Client','admin-client','coke_colombres@hotmail.com','2026-03-23 15:04:32','$2y$10$okHs.eVvhVg.bN5Q1vOQhO2tdqe5ksucfNfEMHzZFdiaFSHoBmdqG',2,0,'$2y$10$Uw/FkBbEe.Ik0/s26tvShuMpNs9VBC7XBclpewCogZnNqv5.UxPBW',NULL,'2026-03-23 15:04:32','2026-03-23 15:04:32',NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `welcome_carousels` -- DROP TABLE IF EXISTS `welcome_carousels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `welcome_carousels` -- LOCK TABLES `welcome_carousels` WRITE; /*!40000 ALTER TABLE `welcome_carousels` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `welcome_carousels` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-03-24 18:24:04