-- Aldakkah dump from local SQLite
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

DROP TABLE IF EXISTS `blog_posts`;
CREATE TABLE `blog_posts` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` VARCHAR(255) NOT NULL,
  `title_ar` VARCHAR(255) NOT NULL,
  `title_en` VARCHAR(255) NOT NULL,
  `excerpt_ar` LONGTEXT NULL DEFAULT NULL,
  `excerpt_en` LONGTEXT NULL DEFAULT NULL,
  `body_ar` LONGTEXT NULL DEFAULT NULL,
  `body_en` LONGTEXT NULL DEFAULT NULL,
  `cover_image` VARCHAR(255) NULL DEFAULT NULL,
  `published_at` LONGTEXT NULL DEFAULT NULL,
  `is_published` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `blog_posts` (`id`,`slug`,`title_ar`,`title_en`,`excerpt_ar`,`excerpt_en`,`body_ar`,`body_en`,`cover_image`,`published_at`,`is_published`,`created_at`,`updated_at`) VALUES
('1','business-studios-mena','استوديوهات الأعمال في الشرق الأوسط','Business Studios in the Middle East','نموذج استوديوهات الأعمال ينمو بسرعة في المنطقة.','Business studios are a rapidly growing model in the region.','استوديوهات الأعمال (أو استوديوهات الشركات الناشئة) نموذج يجمع فرقاً متعددة التخصصات لبناء وتمويل وتوسيع الشركات بشكل متكرر.\n\nفي الدكة الرقمية نعتمد نموذجاً Inventory-led يولّد الأفكار داخلياً ثم يستقطب مؤسسين تقنيين لقيادتها.','Business studios assemble multidisciplinary teams to build, fund, and scale startups repeatedly.\n\nAt Aldakkah we use an inventory-led model that generates ideas internally then recruits technical founders to lead them.','https://images.unsplash.com/photo-1559136555-9303baea8ebd?w=1200&q=80','2026-09-22 16:53:32','1','2026-09-24 16:51:56','2026-09-24 16:53:32'),
('2','future-is-built','المستقبل يُبنى ولا يُنتظر','The Future Is Built, Not Waited For','نظرة قصيرة حول كيف نبني الشركات بقصد واستراتيجية.','A short perspective on building startups with intention and strategy.','نبني الشركات بقصد: استراتيجية واضحة، تنفيذ منضبط، ورؤية طويلة الأمد لخلق شركات قابلة للتوسع وذات أثر.','We build with intention: clear strategy, disciplined execution, and long-term vision to create scalable, impactful companies.','https://images.unsplash.com/photo-1451187580459-43490279c0fa?w=1200&q=80','2026-09-20 16:53:32','1','2026-09-24 16:51:56','2026-09-24 16:53:32');

DROP TABLE IF EXISTS `cache`;
CREATE TABLE `cache` (
  `key` VARCHAR(255) NOT NULL,
  `value` LONGTEXT NOT NULL,
  `expiration` BIGINT UNSIGNED NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `cache` (`key`,`value`,`expiration`) VALUES
('aldakkah-cache-aldakkah.settings','a:2:{s:11:"trial_hours";i:48;s:4:"site";a:20:{s:7:"general";a:9:{s:4:"mode";s:5:"light";s:12:"site_name_ar";s:25:"الدكة الرقمية";s:12:"site_name_en";s:8:"ALDAKKAH";s:10:"color_gold";s:7:"#B8922A";s:10:"brand_desc";s:100:"استديو أعمال سعودي متخصص في SaaS وFinTech والذكاء الاصطناعي.";s:13:"brand_desc_en";s:61:"A Saudi venture studio specializing in SaaS, FinTech, and AI.";s:10:"logo_light";s:0:"";s:9:"logo_dark";s:0:"";s:14:"default_locale";s:2:"ar";}s:8:"sections";a:17:{s:4:"hero";s:1:"1";s:5:"stats";s:1:"1";s:5:"about";s:1:"1";s:9:"landmarks";s:1:"0";s:8:"partners";s:1:"1";s:5:"model";s:1:"0";s:9:"lifecycle";s:1:"1";s:9:"financial";s:1:"0";s:4:"team";s:1:"0";s:4:"kpis";s:1:"1";s:9:"marketing";s:1:"1";s:7:"contact";s:1:"1";s:9:"ecosystem";s:1:"1";s:8:"strategy";s:1:"1";s:8:"benefits";s:1:"1";s:8:"insights";s:1:"1";s:9:"portfolio";s:1:"1";}s:4:"hero";a:27:{s:5:"badge";s:65:"Venture Studio — المملكة العربية السعودية";s:8:"badge_en";s:42:"Venture Studio — Kingdom of Saudi Arabia";s:10:"title_gold";s:10:"الدكة";s:13:"title_gold_en";s:5:"Dakka";s:10:"title_rest";s:25:"نصنع المستقبل";s:13:"title_rest_en";s:19:"We Build the Future";s:7:"tagline";s:35:"From the Dakka, We Build the Future";s:4:"desc";s:314:"استديو أعمال سعودي متخصص في إطلاق وتطوير الشركات التقنية الناشئة في قطاعات البرمجيات كخدمة (SaaS)، التقنية المالية (FinTech)، والذكاء الاصطناعي (AI)، بما يتوافق مع رؤية المملكة 2030.";s:7:"desc_en";s:132:"A Saudi venture studio specialized in launching and scaling tech startups across SaaS, FinTech, and AI — aligned with Vision 2030.";s:4:"btn1";s:32:"تعرف على الاستديو";s:7:"btn1_en";s:19:"Discover the Studio";s:5:"btn1u";s:6:"#about";s:4:"btn2";s:19:"تواصل معنا";s:7:"btn2_en";s:10:"Contact Us";s:5:"btn2u";s:8:"#contact";s:3:"s1v";s:4:"2030";s:3:"s1l";s:26:"متوافق مع رؤية";s:6:"s1l_en";s:14:"Vision aligned";s:3:"s2v";s:3:"53%";s:3:"s2l";s:25:"معدل العائد IRR";s:6:"s2l_en";s:8:"IRR rate";s:3:"s3v";s:3:"72%";s:3:"s3l";s:17:"وصول Series A";s:6:"s3l_en";s:14:"Reach Series A";s:3:"s4v";s:4:"25.2";s:3:"s4l";s:25:"شهراً للإطلاق";s:6:"s4l_en";s:16:"Months to launch";}s:5:"about";a:30:{s:5:"label";s:31:"الميثاق التأسيسي";s:8:"label_en";s:16:"Founding Charter";s:5:"title";s:55:"استديو الأعمال "الدكة الرقمية"";s:8:"title_en";s:31:"Aldakkah Digital Venture Studio";s:5:"intro";s:140:"تمثل الدكة الرقمية استديو أعمال متكاملاً يهدف إلى إطلاق وتطوير مشاريع تقنية.";s:8:"intro_en";s:88:"Aldakkah Digital is an integrated venture studio built to launch and grow tech ventures.";s:6:"vision";s:131:"أن نكون المصنع الرائد للشركات التقنية الناشئة في المملكة والشرق الأوسط.";s:9:"vision_en";s:69:"To be the leading startup factory in the Kingdom and the Middle East.";s:7:"mission";s:131:"بناء جيل جديد من الشركات التقنية عبر بيئة متكاملة من رأس المال والخبرات.";s:10:"mission_en";s:74:"Building a new generation of tech companies through capital and expertise.";s:3:"v1i";s:4:"🌱";s:3:"v1t";s:28:"من جذورنا نبتكر";s:6:"v1t_en";s:17:"Rooted Innovation";s:3:"v1d";s:59:"الحلول من احتياجات السوق المحلي.";s:6:"v1d_en";s:34:"Solutions from local market needs.";s:3:"v2i";s:3:"⚡";s:3:"v2t";s:14:"Lean & Agility";s:6:"v2t_en";s:14:"Lean & Agility";s:3:"v2d";s:53:"منهجية رشيقة في بناء النماذج.";s:6:"v2d_en";s:42:"Agile methodology for building prototypes.";s:3:"v3i";s:4:"🤝";s:3:"v3t";s:26:"شركاء في الدكة";s:6:"v3t_en";s:21:"Partners in the Dakka";s:3:"v3d";s:42:"كفريق واحد مع المؤسسين.";s:6:"v3d_en";s:23:"One team with founders.";s:3:"v4i";s:6:"♾️";s:3:"v4t";s:15:"أثر يدوم";s:6:"v4t_en";s:14:"Lasting Impact";s:3:"v4d";s:44:"نماذج ربحية وقيمة مضافة.";s:6:"v4d_en";s:36:"Profitable models and lasting value.";}s:6:"images";a:6:{s:4:"lm1c";s:70:"مدينة الرياض — عاصمة الاقتصاد السعودي";s:7:"lm1c_en";s:33:"Riyadh — Saudi economic capital";s:4:"lm2c";s:40:"نيوم — مدينة المستقبل";s:7:"lm2c_en";s:27:"NEOM — City of the future";s:4:"lm3c";s:43:"العُلا — إرث حضاري خالد";s:7:"lm3c_en";s:27:"AlUla — Timeless heritage";}s:5:"model";a:6:{s:5:"label";s:21:"نموذج العمل";s:8:"label_en";s:14:"Business Model";s:5:"title";s:19:"Inventory-led Model";s:8:"title_en";s:19:"Inventory-led Model";s:4:"desc";s:240:"النموذج القائم على المخزون الداخلي للأفكار — يقوم الاستديو بتوليد الأفكار داخلياً والتحقق منها ثم استقطاب مؤسسين تقنيين لقيادتها.";s:7:"desc_en";s:121:"An inventory-led model: ideas are generated and validated internally, then technical founders are recruited to lead them.";}s:9:"lifecycle";a:4:{s:5:"label";s:29:"الخطة التشغيلية";s:8:"label_en";s:14:"Operating Plan";s:5:"title";s:32:"دورة حياة المشروع";s:8:"title_en";s:17:"Venture Lifecycle";}s:9:"financial";a:8:{s:5:"label";s:27:"الجدوى المالية";s:8:"label_en";s:21:"Financial Feasibility";s:5:"title";s:42:"النموذج المالي المقترح";s:8:"title_en";s:24:"Proposed Financial Model";s:4:"desc";s:71:"سيناريو معتدل لخمس سنوات — IRR بين 35%–50%.";s:7:"desc_en";s:56:"A moderate five-year scenario — IRR between 35%–50%.";s:4:"note";s:78:"معدل بقاء 60%–70% للوصول إلى Seed ومعدل IRR 35%–50%.";s:7:"note_en";s:48:"60%–70% survival to Seed and IRR of 35%–50%.";}s:4:"team";a:4:{s:5:"label";s:16:"مشاريعنا";s:8:"label_en";s:12:"Our Projects";s:5:"title";s:35:"مشاريعنا الإبداعية";s:8:"title_en";s:17:"Creative Ventures";}s:4:"kpis";a:4:{s:5:"label";s:25:"مؤشرات الأداء";s:8:"label_en";s:22:"Performance Indicators";s:5:"title";s:28:"KPIs لقياس النجاح";s:8:"title_en";s:23:"KPIs to Measure Success";}s:9:"marketing";a:4:{s:5:"label";s:31:"التسويق والعلامة";s:8:"label_en";s:17:"Marketing & Brand";s:5:"title";s:42:"استراتيجية جذب الشركاء";s:8:"title_en";s:27:"Partner Attraction Strategy";}s:7:"contact";a:15:{s:5:"label";s:19:"تواصل معنا";s:8:"label_en";s:10:"Contact Us";s:5:"title";s:41:"هل أنت مستعد للانضمام؟";s:8:"title_en";s:14:"Ready to Join?";s:4:"desc";s:96:"سواء كنت مؤسساً أو مستثمراً أو شركة — الدكة هي مكانك.";s:7:"desc_en";s:78:"Whether you are a founder, investor, or enterprise — Aldakkah is your place.";s:5:"email";s:17:"hello@aldakkah.sa";s:5:"phone";s:16:"+966 5X XXX XXXX";s:4:"city";s:12:"الرياض";s:7:"city_en";s:6:"Riyadh";s:7:"country";s:46:"المملكة العربية السعودية";s:10:"country_en";s:23:"Kingdom of Saudi Arabia";s:4:"btn1";s:21:"راسلنا الآن";s:7:"btn1_en";s:8:"Email Us";s:4:"btn2";s:8:"LinkedIn";}s:6:"footer";a:10:{s:5:"about";s:122:"استديو أعمال سعودي يحوّل الأفكار الطموحة إلى كيانات رقمية مستدامة.";s:8:"about_en";s:82:"A Saudi venture studio turning ambitious ideas into sustainable digital companies.";s:8:"linkedin";s:1:"#";s:7:"twitter";s:1:"#";s:9:"instagram";s:1:"#";s:7:"youtube";s:1:"#";s:4:"copy";s:34:"جميع الحقوق محفوظة";s:7:"copy_en";s:19:"All rights reserved";s:6:"credit";s:42:"أُعِدَّ بواسطة Madani Halwani";s:9:"credit_en";s:26:"Prepared by Madani Halwani";}s:8:"partners";a:4:{s:5:"label";s:14:"شركاؤنا";s:8:"label_en";s:12:"Our Partners";s:5:"title";s:17:"يثقون بنا";s:8:"title_en";s:13:"They Trust Us";}s:5:"stats";a:12:{s:3:"s1v";s:6:"$1.72B";s:3:"s1l";s:58:"الاستثمار الجريء في السعودية 2025";s:6:"s1l_en";s:25:"VC investment in KSA 2025";s:3:"s2v";s:4:"145%";s:3:"s2l";s:54:"نمو الاستثمار عن العام السابق";s:6:"s2l_en";s:21:"YoY investment growth";s:3:"s3v";s:6:"$13.4B";s:3:"s3l";s:47:"سوق التحول الرقمي السعودي";s:6:"s3l_en";s:35:"Saudi digital transformation market";s:3:"s4v";s:6:"22.18%";s:3:"s4l";s:57:"معدل النمو السنوي المركب حتى 2034";s:6:"s4l_en";s:17:"CAGR through 2034";}s:9:"ecosystem";a:8:{s:5:"label";s:16:"منظومتنا";s:8:"label_en";s:13:"Our Ecosystem";s:5:"title";s:61:"بنية متكاملة من الفكرة حتى التوسع";s:8:"title_en";s:44:"A complete infrastructure from idea to scale";s:4:"desc";s:150:"أربع أذرع مترابطة. استوديو واحد. كل ما يحتاجه المؤسس للانتقال من الفكرة إلى الشركة.";s:7:"desc_en";s:92:"Four connected arms. One studio. Everything a founder needs to move from concept to company.";s:4:"more";s:29:"استكشف المزيد ←";s:7:"more_en";s:16:"Explore more →";}s:8:"strategy";a:6:{s:5:"label";s:31:"استراتيجية الدكة";s:8:"label_en";s:21:"The Aldakkah Strategy";s:5:"title";s:57:"إطار عمل مثبت لبناء شركات رائدة";s:8:"title_en";s:51:"A proven framework to build market-leading ventures";s:4:"desc";s:91:"تسع خطوات مدروسة — من التحقق من الطلب حتى التخارج.";s:7:"desc_en";s:65:"Nine deliberate steps — from validating demand to a clean exit.";}s:8:"benefits";a:8:{s:5:"label";s:21:"لماذا الدكة";s:8:"label_en";s:12:"Why Aldakkah";s:5:"title";s:48:"ماذا تحصل عليه كمؤسس مشارك";s:8:"title_en";s:28:"What You Get as a Co-Founder";s:4:"desc";s:64:"لا نكتفي بالتمويل — نبني إلى جانبك.";s:7:"desc_en";s:44:"We do not just fund — we build beside you.";s:3:"cta";s:30:"انضم كمؤسس مشارك";s:6:"cta_en";s:19:"Become a Co-Founder";}s:8:"insights";a:6:{s:5:"label";s:19:"أحدث الرؤى";s:8:"label_en";s:15:"Latest Insights";s:5:"title";s:19:"رؤى وأفكار";s:8:"title_en";s:16:"Insights & Ideas";s:4:"more";s:28:"عرض كل المقالات";s:7:"more_en";s:14:"View all posts";}s:9:"portfolio";a:8:{s:5:"label";s:14:"المحفظة";s:8:"label_en";s:9:"Portfolio";s:5:"title";s:37:"شركات تُبنى من الدكة";s:8:"title_en";s:29:"Ventures built from the Dakka";s:4:"desc";s:133:"شركات حقيقية من الاستوديو — تُعرض بطاقات تجريبية حتى تُضاف مشاريع فعلية.";s:7:"desc_en";s:81:"Real companies from our studio — demo cards appear until you add live ventures.";s:10:"demo_badge";s:19:"عرض تجريبي";s:13:"demo_badge_en";s:12:"Demo preview";}}}','1790289089');

DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE `cache_locks` (
  `key` VARCHAR(255) NOT NULL,
  `owner` VARCHAR(255) NOT NULL,
  `expiration` BIGINT UNSIGNED NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `cache_locks`

DROP TABLE IF EXISTS `cofounder_applications`;
CREATE TABLE `cofounder_applications` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `status` VARCHAR(255) NOT NULL DEFAULT 'new',
  `data` LONGTEXT NOT NULL,
  `locale` VARCHAR(255) NOT NULL DEFAULT 'ar',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `cofounder_applications` (`id`,`status`,`data`,`locale`,`created_at`,`updated_at`) VALUES
('1','new','{"full_name":"Test Cofounder Auto","email":"test.cofounder@example.com","phone":"+966500000001","linkedin":"https:\\/\\/linkedin.com\\/in\\/test","website":null,"background":"10 years product","achievements":"Built two startups","skills":"Product, Growth","motivation":"Join Aldakkah studio"}','ar','2026-09-24 17:52:58','2026-09-24 17:53:05');

DROP TABLE IF EXISTS `cofounder_benefits`;
CREATE TABLE `cofounder_benefits` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `icon` VARCHAR(255) NULL DEFAULT NULL,
  `title_ar` VARCHAR(255) NOT NULL,
  `title_en` VARCHAR(255) NOT NULL,
  `desc_ar` LONGTEXT NULL DEFAULT NULL,
  `desc_en` LONGTEXT NULL DEFAULT NULL,
  `sort_order` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `cofounder_benefits` (`id`,`icon`,`title_ar`,`title_en`,`desc_ar`,`desc_en`,`sort_order`,`is_active`,`created_at`,`updated_at`) VALUES
('1','💰','تمويل كامل','Full Funding','نستثمر في كل مرحلة من pre-seed إلى Series A.','We invest at every stage from pre-seed to Series A.','1','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('2','🎓','إرشاد خبير','Expert Mentorship','شبكة رواد أعمال وخبراء قطاع.','Network of seasoned entrepreneurs and domain experts.','2','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('3','🛠️','موارد شاملة','End-to-End Resources','منتج، قانوني، موارد بشرية، ومالية.','Product, legal, HR, and finance backbone.','3','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('4','🌐','شبكة إقليمية','Regional Network','شراكات وعملاء عبر السعودية والشرق الأوسط.','Partnerships across KSA and MENA.','4','1','2026-09-24 16:51:56','2026-09-24 16:51:56');

DROP TABLE IF EXISTS `contact_messages`;
CREATE TABLE `contact_messages` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `phone` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `message` LONGTEXT NOT NULL,
  `status` VARCHAR(255) NOT NULL DEFAULT 'new',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `contact_messages`

DROP TABLE IF EXISTS `ecosystem_pages`;
CREATE TABLE `ecosystem_pages` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` VARCHAR(255) NOT NULL,
  `name_ar` VARCHAR(255) NOT NULL,
  `name_en` VARCHAR(255) NOT NULL,
  `eyebrow_ar` VARCHAR(255) NULL DEFAULT NULL,
  `eyebrow_en` VARCHAR(255) NULL DEFAULT NULL,
  `title_ar` VARCHAR(255) NOT NULL,
  `title_en` VARCHAR(255) NOT NULL,
  `intro_ar` LONGTEXT NULL DEFAULT NULL,
  `intro_en` LONGTEXT NULL DEFAULT NULL,
  `hero_image` VARCHAR(255) NULL DEFAULT NULL,
  `card_image` VARCHAR(255) NULL DEFAULT NULL,
  `card_desc_ar` LONGTEXT NULL DEFAULT NULL,
  `card_desc_en` LONGTEXT NULL DEFAULT NULL,
  `stats` LONGTEXT NULL DEFAULT NULL,
  `sections` LONGTEXT NULL DEFAULT NULL,
  `sort_order` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `ecosystem_pages` (`id`,`slug`,`name_ar`,`name_en`,`eyebrow_ar`,`eyebrow_en`,`title_ar`,`title_en`,`intro_ar`,`intro_en`,`hero_image`,`card_image`,`card_desc_ar`,`card_desc_en`,`stats`,`sections`,`sort_order`,`is_active`,`created_at`,`updated_at`) VALUES
('1','consultancy','الاستشارات','Consultancy','خدمات النمو','Growth Services','استشارات الدكة','Aldakkah Consultancy','نقدّم خدمات بناء النمو للاقتصاد الرقمي عبر نهج متكامل لبناء الشركات.','We empower the ecosystem with Growth Builder Services for the digital economy.',NULL,'https://images.unsplash.com/photo-1556761175-5973dc0f32e7?w=900&q=80','إرشاد استراتيجي من مشغّلين وخبراء لدعم المؤسسين في القرارات الحاسمة.','Strategic guidance from experienced operators at critical decision points.',NULL,'[{"title_ar":"\\u0628\\u0646\\u0627\\u0621 \\u0645\\u0634\\u0627\\u0631\\u064a\\u0639 \\u0627\\u0644\\u0634\\u0631\\u0643\\u0627\\u062a","title_en":"Corporate Venture Building","desc_ar":"\\u0628\\u0646\\u0627\\u0621 \\u0645\\u0646\\u062a\\u062c\\u0627\\u062a \\u0648\\u0625\\u064a\\u0631\\u0627\\u062f\\u0627\\u062a \\u0627\\u0633\\u062a\\u0643\\u0634\\u0627\\u0641\\u064a\\u0629 \\u062e\\u0627\\u0631\\u062c \\u0627\\u0644\\u0623\\u0639\\u0645\\u0627\\u0644 \\u0627\\u0644\\u0623\\u0633\\u0627\\u0633\\u064a\\u0629.","desc_en":"Building explorative products and revenue streams outside the core business.","items":[{"title_ar":"\\u062a\\u0648\\u0644\\u064a\\u062f \\u0648\\u0625\\u0637\\u0644\\u0627\\u0642 \\u0627\\u0644\\u0645\\u0634\\u0627\\u0631\\u064a\\u0639","title_en":"Venture Ideation & Launch","desc_ar":"\\u0645\\u0646 \\u0627\\u0644\\u0641\\u0643\\u0631\\u0629 \\u0625\\u0644\\u0649 \\u0627\\u0644\\u0625\\u0637\\u0644\\u0627\\u0642.","desc_en":"From idea to launch."},{"title_ar":"\\u0625\\u0646\\u0634\\u0627\\u0621 \\u0627\\u0633\\u062a\\u0648\\u062f\\u064a\\u0648\\u0647\\u0627\\u062a","title_en":"Venture Studio Creation","desc_ar":"\\u062a\\u0635\\u0645\\u064a\\u0645 \\u0648\\u062a\\u0634\\u063a\\u064a\\u0644 \\u0627\\u0633\\u062a\\u0648\\u062f\\u064a\\u0648\\u0647\\u0627\\u062a \\u062f\\u0627\\u062e\\u0644\\u064a\\u0629.","desc_en":"Design and operate internal studios."},{"title_ar":"\\u062a\\u062d\\u0648\\u0644 \\u0631\\u0642\\u0645\\u064a","title_en":"Digital Transformation","desc_ar":"\\u0631\\u062d\\u0644\\u0627\\u062a \\u062a\\u062d\\u0648\\u0644 \\u0634\\u0627\\u0645\\u0644\\u0629.","desc_en":"End-to-end transformation journeys."}]}]','1','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('2','lab','مختبر الدكة','Aldakkah Lab','مركز الابتكار','Innovation Hub','مختبر الدكة','Aldakkah Lab','حيث تتحول الأفكار إلى منتجات قابلة للتوسع — من المنصات الرقمية إلى الحلول المتقدمة.','Where ideas become scalable products — from digital platforms to advanced solutions.',NULL,'https://images.unsplash.com/photo-1581091226825-a6a2a5aee158?w=900&q=80','تطوير شامل من الفكرة إلى المنتج.','End-to-end development from idea to product.','[{"value":"40+","label_ar":"\\u0645\\u0646\\u062a\\u062c\\u0627\\u062a \\u0645\\u0628\\u0646\\u064a\\u0629","label_en":"Products Built"},{"value":"25+","label_ar":"\\u0634\\u0631\\u0643\\u0627\\u062a \\u0645\\u062f\\u0639\\u0648\\u0645\\u0629","label_en":"Ventures Supported"},{"value":"12","label_ar":"\\u0623\\u0633\\u0627\\u0628\\u064a\\u0639 \\u0645\\u062a\\u0648\\u0633\\u0637 MVP","label_en":"Weeks Avg MVP"}]','[{"title_ar":"\\u0645\\u0627\\u0630\\u0627 \\u0646\\u0628\\u0646\\u064a","title_en":"What We Build","desc_ar":"\\u0645\\u0646 \\u0627\\u0644\\u0645\\u0641\\u0647\\u0648\\u0645 \\u0625\\u0644\\u0649 \\u0627\\u0644\\u0625\\u0646\\u062a\\u0627\\u062c.","desc_en":"From concept to production.","items":[{"title_ar":"\\u0645\\u0646\\u062a\\u062c\\u0627\\u062a \\u0631\\u0642\\u0645\\u064a\\u0629","title_en":"Digital Products","desc_ar":"\\u0648\\u064a\\u0628 \\u0648\\u0645\\u0648\\u0628\\u0627\\u064a\\u0644.","desc_en":"Web and mobile."},{"title_ar":"\\u062a\\u0635\\u0645\\u064a\\u0645 UX\\/UI","title_en":"UX\\/UI Design","desc_ar":"\\u062a\\u062c\\u0627\\u0631\\u0628 \\u0645\\u0645\\u062a\\u0639\\u0629.","desc_en":"Delightful experiences."},{"title_ar":"AI \\u0648\\u0623\\u062a\\u0645\\u062a\\u0629","title_en":"AI & Automation","desc_ar":"\\u062d\\u0644\\u0648\\u0644 \\u0630\\u0643\\u064a\\u0629.","desc_en":"Intelligent solutions."},{"title_ar":"MVP \\u0633\\u0631\\u064a\\u0639","title_en":"MVP Development","desc_ar":"\\u062a\\u062d\\u0642\\u0642 \\u0633\\u0631\\u064a\\u0639.","desc_en":"Rapid validation."}]}]','2','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('3','vc','استثمار الدكة','Aldakkah VC','الذراع الاستثماري','Investment Arm','استثمار الدكة','Aldakkah VC','تمويل بذري وقيادة جولات وربط بشبكة مستثمرين موثوقة.','Seed funding, leading rounds, and access to a trusted investor network.',NULL,'https://images.unsplash.com/photo-1563986768609-322da13575f3?w=900&q=80','رأس مال وشبكة للمستثمرين.','Capital and investor network access.','[{"value":"180M","label_ar":"AUM","label_en":"AUM"},{"value":"19+","label_ar":"\\u0634\\u0631\\u0643\\u0627\\u062a \\u0627\\u0644\\u0645\\u062d\\u0641\\u0638\\u0629","label_en":"Portfolio"},{"value":"35%+","label_ar":"\\u0639\\u0627\\u0626\\u062f \\u0645\\u062a\\u0648\\u0642\\u0639","label_en":"Target IRR"}]','[{"title_ar":"\\u0645\\u0639\\u0627\\u064a\\u064a\\u0631 \\u0627\\u0644\\u0627\\u0633\\u062a\\u062b\\u0645\\u0627\\u0631","title_en":"Investment Criteria","desc_ar":"\\u0646\\u0628\\u062d\\u062b \\u0639\\u0646 \\u0641\\u0631\\u0642 \\u0627\\u0633\\u062a\\u062b\\u0646\\u0627\\u0626\\u064a\\u0629 \\u0641\\u064a \\u0623\\u0633\\u0648\\u0627\\u0642 \\u0643\\u0628\\u064a\\u0631\\u0629.","desc_en":"We look for exceptional teams in large markets.","items":[{"title_ar":"\\u0645\\u0624\\u0633\\u0633\\u0648\\u0646 \\u0631\\u0624\\u064a\\u0648\\u064a\\u0648\\u0646","title_en":"Visionary Founders","desc_ar":"\\u062e\\u0628\\u0631\\u0629 \\u0648\\u062a\\u0646\\u0641\\u064a\\u0630.","desc_en":"Expertise and execution."},{"title_ar":"\\u0641\\u0631\\u0635\\u0629 \\u0627\\u0644\\u0633\\u0648\\u0642","title_en":"Market Opportunity","desc_ar":"\\u0623\\u0633\\u0648\\u0627\\u0642 \\u0643\\u0628\\u064a\\u0631\\u0629.","desc_en":"Large markets."},{"title_ar":"\\u0623\\u062b\\u0631 \\u0625\\u0642\\u0644\\u064a\\u0645\\u064a","title_en":"Regional Impact","desc_ar":"\\u0645\\u062a\\u0648\\u0627\\u0641\\u0642 \\u0645\\u0639 \\u0631\\u0624\\u064a\\u0629 2030.","desc_en":"Aligned with Vision 2030."}]}]','3','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('4','space','فضاء الدكة','Aldakkah Space','مساحة عمل','Co-Working Space','فضاء الدكة','Aldakkah Space','مساحة عمل فاخرة للتواصل والنمو في قلب الرياض.','Premium co-working for collaboration and growth in the heart of Riyadh.',NULL,'https://images.unsplash.com/photo-1497366216548-37526070297c?w=900&q=80','مجتمع مؤسسين ومستثمرين.','A premium founder ecosystem.',NULL,'[{"title_ar":"\\u0644\\u0645\\u0627\\u0630\\u0627 \\u0641\\u0636\\u0627\\u0621 \\u0627\\u0644\\u062f\\u0643\\u0629","title_en":"Why Aldakkah Space","desc_ar":"\\u0645\\u0643\\u0627\\u0646 \\u062b\\u0627\\u0644\\u062b \\u0644\\u0644\\u0646\\u0645\\u0648 \\u0648\\u0627\\u0644\\u0639\\u0645\\u0644 \\u0627\\u0644\\u0645\\u0634\\u062a\\u0631\\u0643.","desc_en":"Your third place to grow.","items":[{"title_ar":"\\u0645\\u062c\\u062a\\u0645\\u0639 \\u0645\\u0646\\u062a\\u0642\\u0649","title_en":"Curated Community","desc_ar":"\\u0645\\u0624\\u0633\\u0633\\u0648\\u0646 \\u0648\\u0645\\u0633\\u062a\\u062b\\u0645\\u0631\\u0648\\u0646.","desc_en":"Founders and investors."},{"title_ar":"\\u0648\\u0635\\u0648\\u0644 \\u062d\\u0635\\u0631\\u064a","title_en":"Exclusive Access","desc_ar":"\\u0641\\u0639\\u0627\\u0644\\u064a\\u0627\\u062a \\u0648\\u0625\\u0631\\u0634\\u0627\\u062f.","desc_en":"Events and mentorship."},{"title_ar":"\\u0645\\u0631\\u0627\\u0641\\u0642 \\u0641\\u0627\\u062e\\u0631\\u0629","title_en":"Premium Amenities","desc_ar":"\\u0642\\u0627\\u0639\\u0627\\u062a \\u0648\\u0627\\u062c\\u062a\\u0645\\u0627\\u0639\\u0627\\u062a.","desc_en":"Meeting rooms and facilities."}]}]','4','1','2026-09-24 16:51:56','2026-09-24 16:51:56');

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE `failed_jobs` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` VARCHAR(255) NOT NULL,
  `connection` VARCHAR(255) NOT NULL,
  `queue` VARCHAR(255) NOT NULL,
  `payload` LONGTEXT NOT NULL,
  `exception` LONGTEXT NOT NULL,
  `failed_at` LONGTEXT NOT NULL DEFAULT 'CURRENT_TIMESTAMP',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `failed_jobs`

DROP TABLE IF EXISTS `investor_files`;
CREATE TABLE `investor_files` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `investor_id` BIGINT UNSIGNED NOT NULL,
  `label` VARCHAR(255) NULL DEFAULT NULL,
  `file_path` VARCHAR(255) NOT NULL,
  `original_name` VARCHAR(255) NULL DEFAULT NULL,
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `investor_files`

DROP TABLE IF EXISTS `investors`;
CREATE TABLE `investors` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT UNSIGNED NULL DEFAULT NULL,
  `name` VARCHAR(255) NOT NULL,
  `name_en` VARCHAR(255) NULL DEFAULT NULL,
  `interests` LONGTEXT NULL DEFAULT NULL,
  `mobile` VARCHAR(255) NULL DEFAULT NULL,
  `email` VARCHAR(255) NULL DEFAULT NULL,
  `identity_number` VARCHAR(255) NULL DEFAULT NULL,
  `photo_path` VARCHAR(255) NULL DEFAULT NULL,
  `cv_path` VARCHAR(255) NULL DEFAULT NULL,
  `identity_file_path` VARCHAR(255) NULL DEFAULT NULL,
  `status` VARCHAR(255) NOT NULL DEFAULT 'pending',
  `notes` LONGTEXT NULL DEFAULT NULL,
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `investors` (`id`,`user_id`,`name`,`name_en`,`interests`,`mobile`,`email`,`identity_number`,`photo_path`,`cv_path`,`identity_file_path`,`status`,`notes`,`created_at`,`updated_at`) VALUES
('1',NULL,'أحمد المستثمر','Ahmed','SaaS','+966501000000','ahmed@example.com',NULL,NULL,NULL,NULL,'approved',NULL,'2026-09-24 16:38:26','2026-09-24 16:38:26'),
('2',NULL,'سارة فنتشر','Sara','AI','+966501000001','sara@example.com',NULL,NULL,NULL,NULL,'approved',NULL,'2026-09-24 16:38:26','2026-09-24 16:38:26'),
('3',NULL,'خالد كابيتال','Khalid','PropTech','+966501000002','khalid@example.com',NULL,NULL,NULL,NULL,'approved',NULL,'2026-09-24 16:38:26','2026-09-24 16:38:26'),
('4',NULL,'نورة انفست','Noura','FinTech','+966501000003','noura@example.com',NULL,NULL,NULL,NULL,'approved',NULL,'2026-09-24 16:38:26','2026-09-24 16:38:26'),
('5',NULL,'ماجد هولدنج','Majed','Ecom','+966501000004','majed@example.com',NULL,NULL,NULL,NULL,'approved',NULL,'2026-09-24 16:38:26','2026-09-24 16:38:26'),
('6',NULL,'ليلى فند','Layla','EdTech','+966501000005','layla@example.com',NULL,NULL,NULL,NULL,'approved',NULL,'2026-09-24 16:38:26','2026-09-24 16:38:26');

DROP TABLE IF EXISTS `job_applications`;
CREATE TABLE `job_applications` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `job_posting_id` BIGINT UNSIGNED NOT NULL,
  `first_name` VARCHAR(255) NOT NULL,
  `last_name` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `phone` VARCHAR(255) NULL DEFAULT NULL,
  `linkedin` VARCHAR(255) NULL DEFAULT NULL,
  `cv_path` VARCHAR(255) NULL DEFAULT NULL,
  `cover_note` LONGTEXT NULL DEFAULT NULL,
  `status` VARCHAR(255) NOT NULL DEFAULT 'new',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `job_applications`

DROP TABLE IF EXISTS `job_batches`;
CREATE TABLE `job_batches` (
  `id` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) NOT NULL,
  `total_jobs` BIGINT UNSIGNED NOT NULL,
  `pending_jobs` BIGINT UNSIGNED NOT NULL,
  `failed_jobs` BIGINT UNSIGNED NOT NULL,
  `failed_job_ids` LONGTEXT NOT NULL,
  `options` LONGTEXT NULL DEFAULT NULL,
  `cancelled_at` BIGINT UNSIGNED NULL DEFAULT NULL,
  `created_at` BIGINT UNSIGNED NOT NULL,
  `finished_at` BIGINT UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `job_batches`

DROP TABLE IF EXISTS `job_postings`;
CREATE TABLE `job_postings` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` VARCHAR(255) NOT NULL,
  `title_ar` VARCHAR(255) NOT NULL,
  `title_en` VARCHAR(255) NOT NULL,
  `department` VARCHAR(255) NOT NULL,
  `location_ar` VARCHAR(255) NULL DEFAULT NULL,
  `location_en` VARCHAR(255) NULL DEFAULT NULL,
  `work_type` VARCHAR(255) NOT NULL DEFAULT 'hybrid',
  `summary_ar` LONGTEXT NULL DEFAULT NULL,
  `summary_en` LONGTEXT NULL DEFAULT NULL,
  `responsibilities` LONGTEXT NULL DEFAULT NULL,
  `qualifications` LONGTEXT NULL DEFAULT NULL,
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `sort_order` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `job_postings` (`id`,`slug`,`title_ar`,`title_en`,`department`,`location_ar`,`location_en`,`work_type`,`summary_ar`,`summary_en`,`responsibilities`,`qualifications`,`is_active`,`sort_order`,`created_at`,`updated_at`) VALUES
('1','senior-product-manager','مدير منتج أول','Senior Product Manager','Product','الرياض / عن بُعد','Riyadh / Remote','hybrid','انضم إلى فريق الدكة الرقمية لبناء شركات تقنية رائدة.','Join Aldakkah Digital to build market-leading tech ventures.','[{"ar":"\\u0642\\u064a\\u0627\\u062f\\u0629 \\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0648\\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Lead strategy and execution."},{"ar":"\\u0627\\u0644\\u0639\\u0645\\u0644 \\u0639\\u0628\\u0631 \\u0627\\u0644\\u0641\\u0631\\u0642 \\u0645\\u062a\\u0639\\u062f\\u062f\\u0629 \\u0627\\u0644\\u062a\\u062e\\u0635\\u0635\\u0627\\u062a.","en":"Work across cross-functional teams."}]','[{"ar":"\\u062e\\u0628\\u0631\\u0629 3+ \\u0633\\u0646\\u0648\\u0627\\u062a \\u0641\\u064a \\u0627\\u0644\\u0645\\u062c\\u0627\\u0644.","en":"3+ years of relevant experience."},{"ar":"\\u0642\\u062f\\u0631\\u0629 \\u0639\\u0627\\u0644\\u064a\\u0629 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Strong execution capability."}]','1','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('2','venture-architect','مهندس مشاريع','Venture Architect','Venture Studio','الرياض','Riyadh','onsite','انضم إلى فريق الدكة الرقمية لبناء شركات تقنية رائدة.','Join Aldakkah Digital to build market-leading tech ventures.','[{"ar":"\\u0642\\u064a\\u0627\\u062f\\u0629 \\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0648\\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Lead strategy and execution."},{"ar":"\\u0627\\u0644\\u0639\\u0645\\u0644 \\u0639\\u0628\\u0631 \\u0627\\u0644\\u0641\\u0631\\u0642 \\u0645\\u062a\\u0639\\u062f\\u062f\\u0629 \\u0627\\u0644\\u062a\\u062e\\u0635\\u0635\\u0627\\u062a.","en":"Work across cross-functional teams."}]','[{"ar":"\\u062e\\u0628\\u0631\\u0629 3+ \\u0633\\u0646\\u0648\\u0627\\u062a \\u0641\\u064a \\u0627\\u0644\\u0645\\u062c\\u0627\\u0644.","en":"3+ years of relevant experience."},{"ar":"\\u0642\\u062f\\u0631\\u0629 \\u0639\\u0627\\u0644\\u064a\\u0629 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Strong execution capability."}]','1','2','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('3','fullstack-developer','مطور Full-Stack','Full-Stack Developer','Engineering','عن بُعد','Remote','remote','انضم إلى فريق الدكة الرقمية لبناء شركات تقنية رائدة.','Join Aldakkah Digital to build market-leading tech ventures.','[{"ar":"\\u0642\\u064a\\u0627\\u062f\\u0629 \\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0648\\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Lead strategy and execution."},{"ar":"\\u0627\\u0644\\u0639\\u0645\\u0644 \\u0639\\u0628\\u0631 \\u0627\\u0644\\u0641\\u0631\\u0642 \\u0645\\u062a\\u0639\\u062f\\u062f\\u0629 \\u0627\\u0644\\u062a\\u062e\\u0635\\u0635\\u0627\\u062a.","en":"Work across cross-functional teams."}]','[{"ar":"\\u062e\\u0628\\u0631\\u0629 3+ \\u0633\\u0646\\u0648\\u0627\\u062a \\u0641\\u064a \\u0627\\u0644\\u0645\\u062c\\u0627\\u0644.","en":"3+ years of relevant experience."},{"ar":"\\u0642\\u062f\\u0631\\u0629 \\u0639\\u0627\\u0644\\u064a\\u0629 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Strong execution capability."}]','1','3','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('4','ai-engineer','مهندس ذكاء اصطناعي','AI / ML Engineer','AI & Innovation','عن بُعد','Remote','remote','انضم إلى فريق الدكة الرقمية لبناء شركات تقنية رائدة.','Join Aldakkah Digital to build market-leading tech ventures.','[{"ar":"\\u0642\\u064a\\u0627\\u062f\\u0629 \\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0648\\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Lead strategy and execution."},{"ar":"\\u0627\\u0644\\u0639\\u0645\\u0644 \\u0639\\u0628\\u0631 \\u0627\\u0644\\u0641\\u0631\\u0642 \\u0645\\u062a\\u0639\\u062f\\u062f\\u0629 \\u0627\\u0644\\u062a\\u062e\\u0635\\u0635\\u0627\\u062a.","en":"Work across cross-functional teams."}]','[{"ar":"\\u062e\\u0628\\u0631\\u0629 3+ \\u0633\\u0646\\u0648\\u0627\\u062a \\u0641\\u064a \\u0627\\u0644\\u0645\\u062c\\u0627\\u0644.","en":"3+ years of relevant experience."},{"ar":"\\u0642\\u062f\\u0631\\u0629 \\u0639\\u0627\\u0644\\u064a\\u0629 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Strong execution capability."}]','1','4','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('5','investment-analyst','محلل استثمار','Investment Analyst','Investment','هجين','Hybrid','hybrid','انضم إلى فريق الدكة الرقمية لبناء شركات تقنية رائدة.','Join Aldakkah Digital to build market-leading tech ventures.','[{"ar":"\\u0642\\u064a\\u0627\\u062f\\u0629 \\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0648\\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Lead strategy and execution."},{"ar":"\\u0627\\u0644\\u0639\\u0645\\u0644 \\u0639\\u0628\\u0631 \\u0627\\u0644\\u0641\\u0631\\u0642 \\u0645\\u062a\\u0639\\u062f\\u062f\\u0629 \\u0627\\u0644\\u062a\\u062e\\u0635\\u0635\\u0627\\u062a.","en":"Work across cross-functional teams."}]','[{"ar":"\\u062e\\u0628\\u0631\\u0629 3+ \\u0633\\u0646\\u0648\\u0627\\u062a \\u0641\\u064a \\u0627\\u0644\\u0645\\u062c\\u0627\\u0644.","en":"3+ years of relevant experience."},{"ar":"\\u0642\\u062f\\u0631\\u0629 \\u0639\\u0627\\u0644\\u064a\\u0629 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u062a\\u0646\\u0641\\u064a\\u0630.","en":"Strong execution capability."}]','1','5','2026-09-24 16:51:56','2026-09-24 16:51:56');

DROP TABLE IF EXISTS `jobs`;
CREATE TABLE `jobs` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` VARCHAR(255) NOT NULL,
  `payload` LONGTEXT NOT NULL,
  `attempts` BIGINT UNSIGNED NOT NULL,
  `reserved_at` BIGINT UNSIGNED NULL DEFAULT NULL,
  `available_at` BIGINT UNSIGNED NOT NULL,
  `created_at` BIGINT UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `jobs`

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` VARCHAR(255) NOT NULL,
  `batch` BIGINT UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `migrations` (`id`,`migration`,`batch`) VALUES
('1','0001_01_01_000000_create_users_table','1'),
('2','0001_01_01_000001_create_cache_table','1'),
('3','0001_01_01_000002_create_jobs_table','1'),
('4','2024_01_01_000010_create_aldakkah_tables','1'),
('5','2024_01_02_000020_create_mars_features_tables','2'),
('6','2024_01_03_000030_create_portfolio_ventures_table','3');

DROP TABLE IF EXISTS `partner_logos`;
CREATE TABLE `partner_logos` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name_ar` VARCHAR(255) NULL DEFAULT NULL,
  `name_en` VARCHAR(255) NULL DEFAULT NULL,
  `image_path` VARCHAR(255) NOT NULL,
  `url` VARCHAR(255) NULL DEFAULT NULL,
  `sort_order` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  `is_demo` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `partner_logos` (`id`,`name_ar`,`name_en`,`image_path`,`url`,`sort_order`,`is_active`,`created_at`,`updated_at`,`is_demo`) VALUES
('1','SVC','Saudi Venture Capital','partners/logo-0.webp',NULL,'1','1','2026-09-24 16:51:56','2026-09-24 17:35:07','1'),
('2','منشآت','Monshaat','partners/logo-1.webp',NULL,'2','1','2026-09-24 16:51:56','2026-09-24 17:35:07','1'),
('3','نيوم','NEOM','partners/logo-2.webp',NULL,'3','1','2026-09-24 16:51:56','2026-09-24 17:35:07','1'),
('4','أرامكو','Aramco Ventures','partners/logo-3.webp',NULL,'4','1','2026-09-24 16:51:56','2026-09-24 17:35:07','1'),
('5','STC','STC Ventures','partners/logo-4.webp',NULL,'5','1','2026-09-24 16:51:56','2026-09-24 17:35:07','1'),
('6','الراجحي','Al Rajhi Partners','partners/logo-5.webp',NULL,'6','0','2026-09-24 16:51:56','2026-09-24 17:35:07','1'),
('7','LEAP','LEAP','partners/logo-6.webp',NULL,'7','0','2026-09-24 16:51:56','2026-09-24 17:35:07','1'),
('8','FII','FII Institute','partners/logo-7.webp',NULL,'8','0','2026-09-24 16:51:56','2026-09-24 17:35:07','1');

DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE `password_reset_tokens` (
  `email` VARCHAR(255) NOT NULL,
  `token` VARCHAR(255) NOT NULL,
  `created_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `password_reset_tokens`

DROP TABLE IF EXISTS `pitches`;
CREATE TABLE `pitches` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `status` VARCHAR(255) NOT NULL DEFAULT 'new',
  `data` LONGTEXT NOT NULL,
  `locale` VARCHAR(255) NOT NULL DEFAULT 'ar',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `pitches`

DROP TABLE IF EXISTS `portfolio_ventures`;
CREATE TABLE `portfolio_ventures` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name_ar` VARCHAR(255) NOT NULL,
  `name_en` VARCHAR(255) NULL DEFAULT NULL,
  `tagline_ar` VARCHAR(255) NULL DEFAULT NULL,
  `tagline_en` VARCHAR(255) NULL DEFAULT NULL,
  `sector_ar` VARCHAR(255) NULL DEFAULT NULL,
  `sector_en` VARCHAR(255) NULL DEFAULT NULL,
  `stage` VARCHAR(255) NULL DEFAULT NULL,
  `logo_path` VARCHAR(255) NULL DEFAULT NULL,
  `cover_image` VARCHAR(255) NULL DEFAULT NULL,
  `website_url` VARCHAR(255) NULL DEFAULT NULL,
  `desc_ar` LONGTEXT NULL DEFAULT NULL,
  `desc_en` LONGTEXT NULL DEFAULT NULL,
  `sort_order` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `is_featured` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `is_demo` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `portfolio_ventures` (`id`,`name_ar`,`name_en`,`tagline_ar`,`tagline_en`,`sector_ar`,`sector_en`,`stage`,`logo_path`,`cover_image`,`website_url`,`desc_ar`,`desc_en`,`sort_order`,`is_featured`,`is_active`,`is_demo`,`created_at`,`updated_at`) VALUES
('1','نَبض','Nabdh','منصة صحة رقمية للرعاية الأولية','Digital health platform for primary care','الصحة الرقمية','HealthTech','seed',NULL,'https://images.unsplash.com/photo-1576091160399-112ba8d25d1d?w=900&q=80',NULL,'مشروع تجريبي — استبدل بشركة حقيقية من لوحة التحكم.','Demo venture — replace with a real company from the admin panel.','1','1','1','1','2026-09-24 17:35:07','2026-09-24 17:35:07'),
('2','رِيال لينك','RiyalLink','مدفوعات B2B عبر الحدود للشرق الأوسط','Cross-border B2B payments for MENA','تقنية مالية','FinTech','mvp',NULL,'https://images.unsplash.com/photo-1563986768609-322da13575f3?w=900&q=80',NULL,'مشروع تجريبي — يظهر حتى تُضاف شركات حقيقية.','Demo venture — shown until real companies are added.','2','1','1','1','2026-09-24 17:35:07','2026-09-24 17:35:07'),
('3','سُحُب','Suhub','تشغيل سحابي للشركات الصغيرة','Cloud operations for SMEs','برمجيات كخدمة','SaaS','series_a',NULL,'https://images.unsplash.com/photo-1451187580459-43490279c0fa?w=900&q=80',NULL,'مشروع تجريبي ضمن محفظة الدكة.','Demo venture in the Aldakkah portfolio.','3','1','1','1','2026-09-24 17:35:07','2026-09-24 17:35:07'),
('4','رؤى','Roaa','ذكاء اصطناعي لتحليل أسواق التجزئة','AI for retail market intelligence','ذكاء اصطناعي','AI','seed',NULL,'https://images.unsplash.com/photo-1677442135703-1787eea5ce01?w=900&q=80',NULL,'مشروع تجريبي — احذفه بعد إضافة بيانات حقيقية.','Demo venture — remove after adding real data.','4','1','1','1','2026-09-24 17:35:07','2026-09-24 17:35:07');

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE `sessions` (
  `id` VARCHAR(255) NOT NULL,
  `user_id` BIGINT UNSIGNED NULL DEFAULT NULL,
  `ip_address` VARCHAR(255) NULL DEFAULT NULL,
  `user_agent` LONGTEXT NULL DEFAULT NULL,
  `payload` LONGTEXT NOT NULL,
  `last_activity` BIGINT UNSIGNED NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `sessions` (`id`,`user_id`,`ip_address`,`user_agent`,`payload`,`last_activity`) VALUES
('f4PxDXTTr5itJj5sqppFgIoPYY3Fdv6nQsKK346n',NULL,'127.0.0.1','','eyJfdG9rZW4iOiJwMlcxSEhMMXI5cER5d1JJdTZCTTVlZVY3YzVXWHdlSWpINmE5YnpnIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790268766'),
('0CYcaHoX6UBBhSmAixcC85b0HXUB4TQTuifqi5Si',NULL,'127.0.0.1','','eyJfdG9rZW4iOiJmdXF5a3c4QjJvVktBMDdIQUdYNk9mMVdaeTlGMFNJd2w0Um1TS0U4IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9waXRjaC1pZGVhIiwicm91dGUiOiJwaXRjaC5jcmVhdGUifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790268766'),
('ZxttqggYnRR1933EHXo8UJWJuO4WA941aq76M3Ab',NULL,'127.0.0.1','','eyJfdG9rZW4iOiIxTWFhaUE5N3lXYVNQY2F3QW9tUTEyU2VrUVRDbE5nbnB3S1BKZkJuIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9iZWNvbWUtY29mb3VuZGVyIiwicm91dGUiOiJjb2ZvdW5kZXIuY3JlYXRlIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790268766'),
('HX4ewCnEmUuwzLsbhtLNok6A9alU8RGQkYP6YBUY',NULL,'127.0.0.1','','eyJfdG9rZW4iOiJkQ3h1YnFnVDk0WHRLbkpTckQwakRuUXFzeERNcXZPWVFJaHlibTQ4IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9jYXJlZXJzIiwicm91dGUiOiJjYXJlZXJzLmluZGV4In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790268766'),
('737qrDI63SVPXT3G6eJcJmCW6mgMOdRwaAs1QXHR',NULL,'127.0.0.1','','eyJfdG9rZW4iOiI0ZVJZTEZuQzQwNGhHeUUwYkZSdk81UURZbHdTTXBweURXdkV1cXFwIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9ibG9ncyIsInJvdXRlIjoiYmxvZy5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790268766'),
('lXg6V6g68ySq96I44Zq7ayL5pkWBHMu1zIdgQ46l',NULL,'127.0.0.1','','eyJfdG9rZW4iOiI0blhUdVBtVllnREVnOVVvdmNGb01mRlBCWkVEOEFiOXgxWDVhd2xpIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9lY29zeXN0ZW1cL2xhYiIsInJvdXRlIjoiZWNvc3lzdGVtLnNob3cifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790268767'),
('GLUK7Z7CLumrUJ6CDhxM8CMHFHhQyCNZgAlITW27',NULL,'127.0.0.1','','eyJfdG9rZW4iOiIzUHJVTWJhbExuYnBsVnE3UDBXWFptMWhOck5kVU9PcmwwdVF6djJPIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9lY29zeXN0ZW1cL3ZjIiwicm91dGUiOiJlY29zeXN0ZW0uc2hvdyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790268767'),
('zRFHOGp7mGXjx6PDUOe3UZ6AZjX3iCMPRv7DYEeq',NULL,'127.0.0.1','','eyJfdG9rZW4iOiJQVXl2amZyZ0JUSUFSMGdyT1dOQzFmWG9MT0NGZHVrbEJ1bkx6d1lwIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9lY29zeXN0ZW1cL2NvbnN1bHRhbmN5Iiwicm91dGUiOiJlY29zeXN0ZW0uc2hvdyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790268767'),
('GNFlq9qgZ683c5ayP1k7oiTBMb8qCgw2mk9U9g2l',NULL,'127.0.0.1','','eyJfdG9rZW4iOiJ5Tlg4NE1VSVRUaUZYdEYwTk5IdHAwTXpmdldhSWdabkRnajBRQTJBIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9lY29zeXN0ZW1cL3NwYWNlIiwicm91dGUiOiJlY29zeXN0ZW0uc2hvdyJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790268767'),
('vRaVlVw3udf9Pjs1DEZGPr5Urt25RzKKRoYCAz8H',NULL,'127.0.0.1','','eyJfdG9rZW4iOiJOU1FhNTI4NEdwa2l1RWFIOVE2ZE1Nbzg1VmttV1N1TVZtcUc4azNKIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790268821'),
('79lQ96nNYpRJVxTfPQbTY6SeFSUDifOo7LDFDhSw',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJWbHRGemVOb2hwUUVINkkwY0xKZk9NVWJWQ2Y1cmthNHhKbU4yVmM2IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790268915'),
('aqWUmbkLQ6Ja9ppjQ5TfM737QhBOdCf8BrfQxgh3',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Cursor/3.21.13 Chrome/148.0.7778.280 Electron/42.10.0 Safari/537.36','eyJfdG9rZW4iOiJBeFExZmZmVzRCOXRZc3c5RDRkNFV6SXloc3d0eXFLbFhsUkFsYmxPIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790268945'),
('0UFYSQckZwWbrITTPKYnT7nvmWmpmX0bNX1EfFQD',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Cursor/3.21.13 Chrome/148.0.7778.280 Electron/42.10.0 Safari/537.36','eyJfdG9rZW4iOiJ5VHFKZWxINktQOTBtTnd3QmliemQ5Mmg4djVqRUJJWDBWM09BUFFyIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9ibG9ncyIsInJvdXRlIjoiYmxvZy5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX0sImxvY2FsZSI6ImVuIn0=','1790274038'),
('lchDXj1PCWa133Tckj7l08pkyyoSlfAtTlfYxVqW',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJZZkRxUjRDNVV2M1dTZUdSRDA1OXBKYWFBYzBGd0RZM2RneWI1dFpZIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790268946'),
('Ed8paEc5oxCuWzZrBkRFn6cgAzqL3pkvhz9dsk4l',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJ0alZndnltdU42V2ZVa1pjM0dDMXBSMzdiNkVqWE82d0hXd0xPclJaIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790269729'),
('p3s57DDVtLcEmb7BrL2BdyLzKQdLgu7gkihD7pHM',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJBSlRPYVF0U0Z1WWE5RTB6UzZNVW9CaUZRc3RlalhIR1BIQlFNc0oyIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790269783'),
('6ONvxuEzM2eelKAA6dYjGHx3CrjF15CSTWBbUTeR',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJTaWxLQW9NMkZxd0VzMkMybTBWcGRkUXNZcDNUakJwSkFGb2lDY1B4IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9waXRjaC1pZGVhIiwicm91dGUiOiJwaXRjaC5jcmVhdGUifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2NhbGUiOiJhciJ9','1790274092'),
('QQg3svaqryR2vLs8CWrUXcnwezeFgOIZmmEONv7o',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJjakFFTUxucUtxQTlTY2swYmdKcGRaSlRucXhCQ2hUUkR5dmo3aGhlIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790270309'),
('PiZkYpxmLjsAzht1ESQacQF1LTtELRst0qkvJQB3',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiIwTVhKdHhaUGN0c2NHc01NdHhpdEpWdUN3YktVZEF6bEhvY3l0SnVEIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790270311'),
('QiWjdwRFAZ1pcn5aBmkZPBI9CcDnp6h6Zwju8BO3',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJGNm1IcElEc2ZzU21INjlDbWNaMlYzQ0hPaVdMMzVlbWlYUmQ3WFNTIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790270516'),
('wx7Rb5SHYGfIwZEDBtAHaBqrl2sVdOV9Ofx28jRI',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiIzMThaeGh0ZUtXWlh4ejl3NGprSUI1STJMblZ1alVEM08yWlZtNTlYIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790270530'),
('hueVxmf0jvlT3ITVWV4csdFc0EvwAUjrHoxGetet',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiI1ekV2TWNNZXJHZmVZSFJ2VUJPd3RZODhxNmZhVWxMZnVnbkxyeFUzIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790270687'),
('Q08j5Zw9AecKmfHrXYsH1b3DqcfGOVcM90lEXuNY',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJmeTJPWks0SGFtVzh5MjVXOWoxcUxwTUQ2UENGdWVBRTFtYjhtYjZuIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790270977'),
('TFkA7GIMR0QOAXEHmH5uYb0PBiqKe08fLf0eDI6R',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJtWTR5NFZOZk1hSEp1eDdrakVqTHdlWFM2SHNKRW00UFJXVERkdFpnIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjg3NjVcL2FkbWluXC9tYW5hZ2Utc2l0ZS1zZXR0aW5ncyJ9LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjg3NjVcL2FkbWluXC9tYW5hZ2Utc2l0ZS1zZXR0aW5ncyIsInJvdXRlIjoiZmlsYW1lbnQuYWRtaW4ucGFnZXMubWFuYWdlLXNpdGUtc2V0dGluZ3MifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790270977'),
('Y5aduymM9d4UP6G81bE5m5ZUOwVXywWKJgr6cbgO',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJtVG1qaVJESFRTczBBVnYzUGpRUjNmM1I3QXp6dFdZdjJVZ0tBWldNIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790271321'),
('nbDgTpEaUbvH2Td4309cuoZQWH2rlNRbVeruuRZX',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJEd2oyWFRMcm8zMnlzZG5ZQWo2Z3BKcWRxcHVLbnVqVFdwT3RiUkpIIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790271444'),
('DG8BLum7M0Ypyf15cVsK25V8ly235WdmzLtIn5rn',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJkejhkSkRib0NQbEdYV1o5aWRCY3pNWDN0bXNiWmowSTR6emZaRzdwIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790271727'),
('YjwwTUVoYPthuaP4TErvltUn8aFsugjWfomPymNI',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJKZ3VVTnQxVE5ORk9jOWdCUTQ5bThrbHVra2NlaEtkOU9vN1BzR1JJIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790271733'),
('uy1pDJuQTRMbfKucMpntsc9ANtG2rMO8Dwjo4I20',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJHbkJPN2lhdlEyWE9vOWJWTEdRdTZGUHlBSHlNSmxZemVhZnpYczk3IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9iZWNvbWUtY29mb3VuZGVyIiwicm91dGUiOiJjb2ZvdW5kZXIuY3JlYXRlIn0sIl9mbGFzaCI6eyJvbGQiOlsic3VjY2VzcyJdLCJuZXciOltdfSwic3VjY2VzcyI6Ilx1MDYyYVx1MDY0NSBcdTA2MjVcdTA2MzFcdTA2MzNcdTA2MjdcdTA2NDQgXHUwNjM3XHUwNjQ0XHUwNjI4XHUwNjQzIFx1MDY0M1x1MDY0NVx1MDYyNFx1MDYzM1x1MDYzMyBcdTA2NDVcdTA2MzRcdTA2MjdcdTA2MzFcdTA2NDMgXHUwNjI4XHUwNjQ2XHUwNjJjXHUwNjI3XHUwNjJkLiJ9','1790272378'),
('LNKvif0RF0oioUMzlLeI4CDBuNQNLD7oVdjGsPZb',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJHdXhBQWlNb1lRTHdYNjdwZDM4Q0xLOVdtNkdnREJTNERXZDA0T1hGIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9iZWNvbWUtY29mb3VuZGVyIiwicm91dGUiOiJjb2ZvdW5kZXIuY3JlYXRlIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790272385'),
('JLsctEK1O07DTj38bjtjdEbA3iyFp3oKTzgSQ5mo',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJjQ3lNQjZ2TVZWbXJoeUx5RVNMWDVINUZEazA5UFZvekRsbnJPZGo5IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9jYXJlZXJzIiwicm91dGUiOiJjYXJlZXJzLmluZGV4In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790272482'),
('TA1BGrnXNs0W0ZoFQhe5hy7ovzSHIzVKEpUXOXXS',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJzb0VzU2FoZjNLSlhjanlVYkU3MXhyWlRlU3J1cjFEeUM1RUFLYkxxIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjg3NjVcL2ludmVzdG9ycyJ9LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvMTI3LjAuMC4xOjg3NjVcL2ludmVzdG9ycyIsInJvdXRlIjoiaW52ZXN0b3JzLmluZGV4In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790272482'),
('EITlzr910EDlvSN2F056aNA8u0EPD2bcA9WuS3SN',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiIyV3kyeFJMT2RkTUp3bmNWSFBTaWs0MUhkbjF6bGFVV3dUVWJ3M1VpIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9waXRjaC1pZGVhIiwicm91dGUiOiJwaXRjaC5jcmVhdGUifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790272519'),
('bP1RG7uMEPMLBmduqKr45J4uZoGaHlhWHqI0cM1a',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJreHVVSHRSSG1PWmNCcUJnczF5YU5KZzdFRVlCSzhYWVFBNjAyTUR3IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9waXRjaC1pZGVhIiwicm91dGUiOiJwaXRjaC5jcmVhdGUifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790272520'),
('t7F8Mt7E9186dSHjtaOwmqKwtCoHmHGLPJMEBrOo',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJaVjl0TGxBN0J6dFZvNGdHcHdjRzhhSFZvQkpKN3dMcWdldDh6aEpsIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9jYXJlZXJzIiwicm91dGUiOiJjYXJlZXJzLmluZGV4In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790272521'),
('6VH8KLjzF9JGwXRmbT911B5ymPunvZxor9S3CcJ1',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJIWVVFOW5Ed2tBdHFNMEw5dGFEYTVGNHZoRDc3UVl1VkxuMk5JUkl5IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9jYXJlZXJzIiwicm91dGUiOiJjYXJlZXJzLmluZGV4In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790272522'),
('9EGlOMQHTkgADPXHqs46YN8DGTuxffRVu0Y03Lc0',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJydUl5UmhjSWpiZHVmQVJKck9HdFp6ZWtQMG1qSnA1TWdQTjRYU1dCIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9pbnZlc3RvcnNcL3JlZ2lzdGVyIiwicm91dGUiOiJpbnZlc3RvcnMucmVnaXN0ZXIifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790272523'),
('h1dy7nesU9ALd5tNIndPw4yabECxuXuoyUcc5Yje',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJKSXRJb0dIRk9YQkl6ZTc1YVpiQkthWFhqM1ZyU1BGRzhGNHJ2STY1IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9pbnZlc3RvcnNcL3JlZ2lzdGVyIiwicm91dGUiOiJpbnZlc3RvcnMucmVnaXN0ZXIifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790272523'),
('z9o3HhwmmPj50Jnn0qPIKouNGn7M2WlcvKipNawm',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiI2Z2gxYlNPVjQxdjB5eGtOcWFZaEZFSzVKWGFsbUdJbU01U0x3a0JlIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9ibG9ncyIsInJvdXRlIjoiYmxvZy5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790272525'),
('qRpFpn3OWbFmDqp4AvMEh2mDiwHxoETkxvZcnjdN',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJrek02Zm9EVWlFWXNOdlVpNTZKSG1vckhkTURkaHM4ZkprNVVSeWRyIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9ibG9ncyIsInJvdXRlIjoiYmxvZy5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790272526'),
('RyygmoMmuNfLETXw1cORt90vHWTh2py9UnhqVRTp',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJBRG5WRnE5cENFdGgwRzBzZnljVTVNcE80WWJ4TXhtOVcxVGE1UFBDIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9zdWJzY3JpcHRpb24iLCJyb3V0ZSI6InN1YnNjcmlwdGlvbi5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790272526'),
('FYTOBzdKEskkW7pC7IPtUcFXE9N8w9i1w5RDcVRE',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJrMzFxYzJ3UTQ4TWNkQml6RXNsdVI4dlZlSEgwZWFBMFhCeWV6SFZnIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9zdWJzY3JpcHRpb24iLCJyb3V0ZSI6InN1YnNjcmlwdGlvbi5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790272527'),
('InAv3O9GsKNejJPyUK3FnNw3fXUyJLGjMrTLcUD2',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJDako5SkNTUUl3elplV2Z1eGRLT25JOTZWT0NPRVRBTVhIOTRMMnltIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9sb2dpbiIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790273072'),
('9oHgIMZcYRbSDrPfftKVlvOx0gyFT11SaaIrgnSC',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJGcjVkRlZFamlrNXQ2WVl2RGVSWFFSSERqRFcxSFBReGhXb2VNYUlJIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9sb2dpbiIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790273072'),
('KamcfD7yTImPDZZX8JRPJJp01PIvIs4F1soUgmbi',NULL,'127.0.0.1','curl/8.7.1','eyJfdG9rZW4iOiJiVUU5bFd4cnd3WW1iYkRmVm93a0xwUE10UWd4a09lS1VXUEtSOFNoIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1Iiwicm91dGUiOiJob21lIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwibG9jYWxlIjoiZW4ifQ==','1790273471'),
('ygWkRcMGhpANAAYVm8rGuAsA0yghUHtFoisLzDsi','1','127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwiX3Rva2VuIjoiTzJNZ21oa0NqOUt1UmNIZDlvV3NmaHpVY1liYWp1TTl2b2NiMUtqUyIsInBhc3N3b3JkX2hhc2hfd2ViIjoiMjMxODlkZTQ5ODZlZDExODI3NWU1MTc3NzE1NDU0ZGM5MTBjZjk1YWYxZjMxMDExNGM3OTQxZmY4ZGMzM2Q4MyIsInRhYmxlcyI6eyIzYjM0Zjg1OGUwZTkyNjVmNjMxYzgwZDI5MjE5OWNiYV9jb2x1bW5zIjpbeyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6ImRhdGEuZnVsbF9uYW1lIiwibGFiZWwiOiJcdTA2MjdcdTA2NDRcdTA2MjdcdTA2MzNcdTA2NDUiLCJpc0hpZGRlbiI6ZmFsc2UsImlzVG9nZ2xlZCI6dHJ1ZSwiaXNUb2dnbGVhYmxlIjpmYWxzZSwiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjpudWxsfSx7InR5cGUiOiJjb2x1bW4iLCJuYW1lIjoiZGF0YS5lbWFpbCIsImxhYmVsIjoiXHUwNjI3XHUwNjQ0XHUwNjI1XHUwNjRhXHUwNjQ1XHUwNjRhXHUwNjQ0IiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH0seyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6ImRhdGEucGhvbmUiLCJsYWJlbCI6Ilx1MDYyN1x1MDY0NFx1MDYyY1x1MDY0OFx1MDYyN1x1MDY0NCIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJzdGF0dXMiLCJsYWJlbCI6Ilx1MDYyN1x1MDY0NFx1MDYyZFx1MDYyN1x1MDY0NFx1MDYyOSIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJjcmVhdGVkX2F0IiwibGFiZWwiOiJcdTA2MjdcdTA2NDRcdTA2MmFcdTA2MjdcdTA2MzFcdTA2NGFcdTA2MmUiLCJpc0hpZGRlbiI6ZmFsc2UsImlzVG9nZ2xlZCI6dHJ1ZSwiaXNUb2dnbGVhYmxlIjpmYWxzZSwiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjpudWxsfV19LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9hZG1pblwvY29mb3VuZGVyLWFwcGxpY2F0aW9ucyIsInJvdXRlIjoiZmlsYW1lbnQuYWRtaW4ucmVzb3VyY2VzLmNvZm91bmRlci1hcHBsaWNhdGlvbnMuaW5kZXgifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==','1790286380'),
('wUPBtw708CZuSXm35A2leTL1APqaWzFikUiVIOdp','1','127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwiX3Rva2VuIjoiNWdaYXYzOTBucnlPR3J3d3ZEMFVoSXVBSW4xWHVqWUR2dUk2a0RQMSIsInBhc3N3b3JkX2hhc2hfd2ViIjoiMjMxODlkZTQ5ODZlZDExODI3NWU1MTc3NzE1NDU0ZGM5MTBjZjk1YWYxZjMxMDExNGM3OTQxZmY4ZGMzM2Q4MyIsInRhYmxlcyI6eyIzYjM0Zjg1OGUwZTkyNjVmNjMxYzgwZDI5MjE5OWNiYV9jb2x1bW5zIjpbeyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6ImRhdGEuZnVsbF9uYW1lIiwibGFiZWwiOiJcdTA2MjdcdTA2NDRcdTA2MjdcdTA2MzNcdTA2NDUiLCJpc0hpZGRlbiI6ZmFsc2UsImlzVG9nZ2xlZCI6dHJ1ZSwiaXNUb2dnbGVhYmxlIjpmYWxzZSwiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjpudWxsfSx7InR5cGUiOiJjb2x1bW4iLCJuYW1lIjoiZGF0YS5lbWFpbCIsImxhYmVsIjoiXHUwNjI3XHUwNjQ0XHUwNjI1XHUwNjRhXHUwNjQ1XHUwNjRhXHUwNjQ0IiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH0seyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6ImRhdGEucGhvbmUiLCJsYWJlbCI6Ilx1MDYyN1x1MDY0NFx1MDYyY1x1MDY0OFx1MDYyN1x1MDY0NCIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJzdGF0dXMiLCJsYWJlbCI6Ilx1MDYyN1x1MDY0NFx1MDYyZFx1MDYyN1x1MDY0NFx1MDYyOSIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJjcmVhdGVkX2F0IiwibGFiZWwiOiJcdTA2MjdcdTA2NDRcdTA2MmFcdTA2MjdcdTA2MzFcdTA2NGFcdTA2MmUiLCJpc0hpZGRlbiI6ZmFsc2UsImlzVG9nZ2xlZCI6dHJ1ZSwiaXNUb2dnbGVhYmxlIjpmYWxzZSwiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjpudWxsfV19LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cDpcL1wvbG9jYWxob3N0XC9hZG1pblwvY29mb3VuZGVyLWFwcGxpY2F0aW9ucz90YWJsZVNlYXJjaD10ZXN0Iiwicm91dGUiOiJmaWxhbWVudC5hZG1pbi5yZXNvdXJjZXMuY29mb3VuZGVyLWFwcGxpY2F0aW9ucy5pbmRleCJ9LCJfZmxhc2giOnsib2xkIjpbXSwibmV3IjpbXX19','1790286520'),
('OkFnemuYykBwyGPTDBqA3TELV3byFTnLK1uBCzVd','1','127.0.0.1','Symfony','eyJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwiX3Rva2VuIjoibjd5Nkd4dU1XUTJVQXBWOE95Q2NKR2Q3dkF2T0NjbkJYRDFDVUd1SiIsInBhc3N3b3JkX2hhc2hfd2ViIjoiMjMxODlkZTQ5ODZlZDExODI3NWU1MTc3NzE1NDU0ZGM5MTBjZjk1YWYxZjMxMDExNGM3OTQxZmY4ZGMzM2Q4MyIsIl9wcmV2aW91cyI6eyJ1cmwiOiJodHRwOlwvXC9sb2NhbGhvc3RcL2FkbWluXC9jb2ZvdW5kZXItYXBwbGljYXRpb25zXC8xXC9lZGl0Iiwicm91dGUiOiJmaWxhbWVudC5hZG1pbi5yZXNvdXJjZXMuY29mb3VuZGVyLWFwcGxpY2F0aW9ucy5lZGl0In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=','1790286538'),
('MsfsiYswlGHE5v8CD6CmIyEGKyHZh5AgdsK0AupJ','1','127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36','eyJfdG9rZW4iOiJqVkZiZ3ZlTGlGSXF5Qm92YlBKNUlDZ0VQcFVKM0VPVFNxTG0xYVVPIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4NzY1XC9hZG1pblwvY29mb3VuZGVyLWFwcGxpY2F0aW9ucyIsInJvdXRlIjoiZmlsYW1lbnQuYWRtaW4ucmVzb3VyY2VzLmNvZm91bmRlci1hcHBsaWNhdGlvbnMuaW5kZXgifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwicGFzc3dvcmRfaGFzaF93ZWIiOiIyMzE4OWRlNDk4NmVkMTE4Mjc1ZTUxNzc3MTU0NTRkYzkxMGNmOTVhZjFmMzEwMTE0Yzc5NDFmZjhkYzMzZDgzIiwidGFibGVzIjp7IjY5OGVmY2JkMjIyMzY2MzMyMzVjMTdmZGJiZTJkMmRlX2NvbHVtbnMiOlt7InR5cGUiOiJjb2x1bW4iLCJuYW1lIjoidGl0bGVfYXIiLCJsYWJlbCI6Ilx1MDYyN1x1MDY0NFx1MDYzOVx1MDY0Nlx1MDY0OFx1MDYyN1x1MDY0NiIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJwdWJsaXNoZWRfYXQiLCJsYWJlbCI6IlB1Ymxpc2hlZCBhdCIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJpc19wdWJsaXNoZWQiLCJsYWJlbCI6Ilx1MDY0NVx1MDY0Nlx1MDYzNFx1MDY0OFx1MDYzMSIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9XSwiM2IzNGY4NThlMGU5MjY1ZjYzMWM4MGQyOTIxOTljYmFfY29sdW1ucyI6W3sidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJhcHBsaWNhbnRfbmFtZSIsImxhYmVsIjoiXHUwNjI3XHUwNjQ0XHUwNjI3XHUwNjMzXHUwNjQ1IiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH0seyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6ImFwcGxpY2FudF9lbWFpbCIsImxhYmVsIjoiXHUwNjI3XHUwNjQ0XHUwNjI1XHUwNjRhXHUwNjQ1XHUwNjRhXHUwNjQ0IiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH0seyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6ImFwcGxpY2FudF9waG9uZSIsImxhYmVsIjoiXHUwNjI3XHUwNjQ0XHUwNjJjXHUwNjQ4XHUwNjI3XHUwNjQ0IiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH0seyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6InN0YXR1cyIsImxhYmVsIjoiXHUwNjI3XHUwNjQ0XHUwNjJkXHUwNjI3XHUwNjQ0XHUwNjI5IiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH0seyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6ImNyZWF0ZWRfYXQiLCJsYWJlbCI6Ilx1MDYyN1x1MDY0NFx1MDYyYVx1MDYyN1x1MDYzMVx1MDY0YVx1MDYyZSIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9XSwiNDczYWRiYzk2ZmJiNTYzYzE5ZTQxM2QwNWJjMDUwNjFfY29sdW1ucyI6W3sidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJuYW1lIiwibGFiZWwiOiJOYW1lIiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH0seyJ0eXBlIjoiY29sdW1uIiwibmFtZSI6InBob25lIiwibGFiZWwiOiJQaG9uZSIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJlbWFpbCIsImxhYmVsIjoiRW1haWwiLCJpc0hpZGRlbiI6ZmFsc2UsImlzVG9nZ2xlZCI6dHJ1ZSwiaXNUb2dnbGVhYmxlIjpmYWxzZSwiaXNUb2dnbGVkSGlkZGVuQnlEZWZhdWx0IjpudWxsfSx7InR5cGUiOiJjb2x1bW4iLCJuYW1lIjoibWVzc2FnZSIsImxhYmVsIjoiTWVzc2FnZSIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJzdGF0dXMiLCJsYWJlbCI6IlN0YXR1cyIsImlzSGlkZGVuIjpmYWxzZSwiaXNUb2dnbGVkIjp0cnVlLCJpc1RvZ2dsZWFibGUiOmZhbHNlLCJpc1RvZ2dsZWRIaWRkZW5CeURlZmF1bHQiOm51bGx9LHsidHlwZSI6ImNvbHVtbiIsIm5hbWUiOiJjcmVhdGVkX2F0IiwibGFiZWwiOiJDcmVhdGVkIGF0IiwiaXNIaWRkZW4iOmZhbHNlLCJpc1RvZ2dsZWQiOnRydWUsImlzVG9nZ2xlYWJsZSI6ZmFsc2UsImlzVG9nZ2xlZEhpZGRlbkJ5RGVmYXVsdCI6bnVsbH1dfX0=','1790289112');

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` VARCHAR(255) NOT NULL,
  `value` LONGTEXT NULL DEFAULT NULL,
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`id`,`key`,`value`,`created_at`,`updated_at`) VALUES
('1','trial_hours','48','2026-09-24 16:38:23','2026-09-24 16:38:23'),
('2','site','{"general":{"mode":"light","site_name_ar":"\\u0627\\u0644\\u062f\\u0643\\u0629 \\u0627\\u0644\\u0631\\u0642\\u0645\\u064a\\u0629","site_name_en":"ALDAKKAH","color_gold":"#B8922A","brand_desc":"\\u0627\\u0633\\u062a\\u062f\\u064a\\u0648 \\u0623\\u0639\\u0645\\u0627\\u0644 \\u0633\\u0639\\u0648\\u062f\\u064a \\u0645\\u062a\\u062e\\u0635\\u0635 \\u0641\\u064a SaaS \\u0648FinTech \\u0648\\u0627\\u0644\\u0630\\u0643\\u0627\\u0621 \\u0627\\u0644\\u0627\\u0635\\u0637\\u0646\\u0627\\u0639\\u064a.","brand_desc_en":"A Saudi venture studio specializing in SaaS, FinTech, and AI.","logo_light":"","logo_dark":"","default_locale":"ar"},"sections":{"hero":"1","stats":"1","about":"1","landmarks":"0","partners":"1","model":"0","lifecycle":"1","financial":"0","team":"0","kpis":"1","marketing":"1","contact":"1","ecosystem":"1","strategy":"1","benefits":"1","insights":"1","portfolio":"1"},"hero":{"badge":"Venture Studio \\u2014 \\u0627\\u0644\\u0645\\u0645\\u0644\\u0643\\u0629 \\u0627\\u0644\\u0639\\u0631\\u0628\\u064a\\u0629 \\u0627\\u0644\\u0633\\u0639\\u0648\\u062f\\u064a\\u0629","badge_en":"Venture Studio \\u2014 Kingdom of Saudi Arabia","title_gold":"\\u0627\\u0644\\u062f\\u0643\\u0629","title_gold_en":"Dakka","title_rest":"\\u0646\\u0635\\u0646\\u0639 \\u0627\\u0644\\u0645\\u0633\\u062a\\u0642\\u0628\\u0644","title_rest_en":"We Build the Future","tagline":"From the Dakka, We Build the Future","desc":"\\u0627\\u0633\\u062a\\u062f\\u064a\\u0648 \\u0623\\u0639\\u0645\\u0627\\u0644 \\u0633\\u0639\\u0648\\u062f\\u064a \\u0645\\u062a\\u062e\\u0635\\u0635 \\u0641\\u064a \\u0625\\u0637\\u0644\\u0627\\u0642 \\u0648\\u062a\\u0637\\u0648\\u064a\\u0631 \\u0627\\u0644\\u0634\\u0631\\u0643\\u0627\\u062a \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0629 \\u0627\\u0644\\u0646\\u0627\\u0634\\u0626\\u0629 \\u0641\\u064a \\u0642\\u0637\\u0627\\u0639\\u0627\\u062a \\u0627\\u0644\\u0628\\u0631\\u0645\\u062c\\u064a\\u0627\\u062a \\u0643\\u062e\\u062f\\u0645\\u0629 (SaaS)\\u060c \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0629 \\u0627\\u0644\\u0645\\u0627\\u0644\\u064a\\u0629 (FinTech)\\u060c \\u0648\\u0627\\u0644\\u0630\\u0643\\u0627\\u0621 \\u0627\\u0644\\u0627\\u0635\\u0637\\u0646\\u0627\\u0639\\u064a (AI)\\u060c \\u0628\\u0645\\u0627 \\u064a\\u062a\\u0648\\u0627\\u0641\\u0642 \\u0645\\u0639 \\u0631\\u0624\\u064a\\u0629 \\u0627\\u0644\\u0645\\u0645\\u0644\\u0643\\u0629 2030.","desc_en":"A Saudi venture studio specialized in launching and scaling tech startups across SaaS, FinTech, and AI \\u2014 aligned with Vision 2030.","btn1":"\\u062a\\u0639\\u0631\\u0641 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u0627\\u0633\\u062a\\u062f\\u064a\\u0648","btn1_en":"Discover the Studio","btn1u":"#about","btn2":"\\u062a\\u0648\\u0627\\u0635\\u0644 \\u0645\\u0639\\u0646\\u0627","btn2_en":"Contact Us","btn2u":"#contact","s1v":"2030","s1l":"\\u0645\\u062a\\u0648\\u0627\\u0641\\u0642 \\u0645\\u0639 \\u0631\\u0624\\u064a\\u0629","s1l_en":"Vision aligned","s2v":"53%","s2l":"\\u0645\\u0639\\u062f\\u0644 \\u0627\\u0644\\u0639\\u0627\\u0626\\u062f IRR","s2l_en":"IRR rate","s3v":"72%","s3l":"\\u0648\\u0635\\u0648\\u0644 Series A","s3l_en":"Reach Series A","s4v":"25.2","s4l":"\\u0634\\u0647\\u0631\\u0627\\u064b \\u0644\\u0644\\u0625\\u0637\\u0644\\u0627\\u0642","s4l_en":"Months to launch"},"about":{"label":"\\u0627\\u0644\\u0645\\u064a\\u062b\\u0627\\u0642 \\u0627\\u0644\\u062a\\u0623\\u0633\\u064a\\u0633\\u064a","label_en":"Founding Charter","title":"\\u0627\\u0633\\u062a\\u062f\\u064a\\u0648 \\u0627\\u0644\\u0623\\u0639\\u0645\\u0627\\u0644 \\"\\u0627\\u0644\\u062f\\u0643\\u0629 \\u0627\\u0644\\u0631\\u0642\\u0645\\u064a\\u0629\\"","title_en":"Aldakkah Digital Venture Studio","intro":"\\u062a\\u0645\\u062b\\u0644 \\u0627\\u0644\\u062f\\u0643\\u0629 \\u0627\\u0644\\u0631\\u0642\\u0645\\u064a\\u0629 \\u0627\\u0633\\u062a\\u062f\\u064a\\u0648 \\u0623\\u0639\\u0645\\u0627\\u0644 \\u0645\\u062a\\u0643\\u0627\\u0645\\u0644\\u0627\\u064b \\u064a\\u0647\\u062f\\u0641 \\u0625\\u0644\\u0649 \\u0625\\u0637\\u0644\\u0627\\u0642 \\u0648\\u062a\\u0637\\u0648\\u064a\\u0631 \\u0645\\u0634\\u0627\\u0631\\u064a\\u0639 \\u062a\\u0642\\u0646\\u064a\\u0629.","intro_en":"Aldakkah Digital is an integrated venture studio built to launch and grow tech ventures.","vision":"\\u0623\\u0646 \\u0646\\u0643\\u0648\\u0646 \\u0627\\u0644\\u0645\\u0635\\u0646\\u0639 \\u0627\\u0644\\u0631\\u0627\\u0626\\u062f \\u0644\\u0644\\u0634\\u0631\\u0643\\u0627\\u062a \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0629 \\u0627\\u0644\\u0646\\u0627\\u0634\\u0626\\u0629 \\u0641\\u064a \\u0627\\u0644\\u0645\\u0645\\u0644\\u0643\\u0629 \\u0648\\u0627\\u0644\\u0634\\u0631\\u0642 \\u0627\\u0644\\u0623\\u0648\\u0633\\u0637.","vision_en":"To be the leading startup factory in the Kingdom and the Middle East.","mission":"\\u0628\\u0646\\u0627\\u0621 \\u062c\\u064a\\u0644 \\u062c\\u062f\\u064a\\u062f \\u0645\\u0646 \\u0627\\u0644\\u0634\\u0631\\u0643\\u0627\\u062a \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0629 \\u0639\\u0628\\u0631 \\u0628\\u064a\\u0626\\u0629 \\u0645\\u062a\\u0643\\u0627\\u0645\\u0644\\u0629 \\u0645\\u0646 \\u0631\\u0623\\u0633 \\u0627\\u0644\\u0645\\u0627\\u0644 \\u0648\\u0627\\u0644\\u062e\\u0628\\u0631\\u0627\\u062a.","mission_en":"Building a new generation of tech companies through capital and expertise.","v1i":"\\ud83c\\udf31","v1t":"\\u0645\\u0646 \\u062c\\u0630\\u0648\\u0631\\u0646\\u0627 \\u0646\\u0628\\u062a\\u0643\\u0631","v1t_en":"Rooted Innovation","v1d":"\\u0627\\u0644\\u062d\\u0644\\u0648\\u0644 \\u0645\\u0646 \\u0627\\u062d\\u062a\\u064a\\u0627\\u062c\\u0627\\u062a \\u0627\\u0644\\u0633\\u0648\\u0642 \\u0627\\u0644\\u0645\\u062d\\u0644\\u064a.","v1d_en":"Solutions from local market needs.","v2i":"\\u26a1","v2t":"Lean & Agility","v2t_en":"Lean & Agility","v2d":"\\u0645\\u0646\\u0647\\u062c\\u064a\\u0629 \\u0631\\u0634\\u064a\\u0642\\u0629 \\u0641\\u064a \\u0628\\u0646\\u0627\\u0621 \\u0627\\u0644\\u0646\\u0645\\u0627\\u0630\\u062c.","v2d_en":"Agile methodology for building prototypes.","v3i":"\\ud83e\\udd1d","v3t":"\\u0634\\u0631\\u0643\\u0627\\u0621 \\u0641\\u064a \\u0627\\u0644\\u062f\\u0643\\u0629","v3t_en":"Partners in the Dakka","v3d":"\\u0643\\u0641\\u0631\\u064a\\u0642 \\u0648\\u0627\\u062d\\u062f \\u0645\\u0639 \\u0627\\u0644\\u0645\\u0624\\u0633\\u0633\\u064a\\u0646.","v3d_en":"One team with founders.","v4i":"\\u267e\\ufe0f","v4t":"\\u0623\\u062b\\u0631 \\u064a\\u062f\\u0648\\u0645","v4t_en":"Lasting Impact","v4d":"\\u0646\\u0645\\u0627\\u0630\\u062c \\u0631\\u0628\\u062d\\u064a\\u0629 \\u0648\\u0642\\u064a\\u0645\\u0629 \\u0645\\u0636\\u0627\\u0641\\u0629.","v4d_en":"Profitable models and lasting value."},"images":{"lm1c":"\\u0645\\u062f\\u064a\\u0646\\u0629 \\u0627\\u0644\\u0631\\u064a\\u0627\\u0636 \\u2014 \\u0639\\u0627\\u0635\\u0645\\u0629 \\u0627\\u0644\\u0627\\u0642\\u062a\\u0635\\u0627\\u062f \\u0627\\u0644\\u0633\\u0639\\u0648\\u062f\\u064a","lm1c_en":"Riyadh \\u2014 Saudi economic capital","lm2c":"\\u0646\\u064a\\u0648\\u0645 \\u2014 \\u0645\\u062f\\u064a\\u0646\\u0629 \\u0627\\u0644\\u0645\\u0633\\u062a\\u0642\\u0628\\u0644","lm2c_en":"NEOM \\u2014 City of the future","lm3c":"\\u0627\\u0644\\u0639\\u064f\\u0644\\u0627 \\u2014 \\u0625\\u0631\\u062b \\u062d\\u0636\\u0627\\u0631\\u064a \\u062e\\u0627\\u0644\\u062f","lm3c_en":"AlUla \\u2014 Timeless heritage"},"model":{"label":"\\u0646\\u0645\\u0648\\u0630\\u062c \\u0627\\u0644\\u0639\\u0645\\u0644","label_en":"Business Model","title":"Inventory-led Model","title_en":"Inventory-led Model","desc":"\\u0627\\u0644\\u0646\\u0645\\u0648\\u0630\\u062c \\u0627\\u0644\\u0642\\u0627\\u0626\\u0645 \\u0639\\u0644\\u0649 \\u0627\\u0644\\u0645\\u062e\\u0632\\u0648\\u0646 \\u0627\\u0644\\u062f\\u0627\\u062e\\u0644\\u064a \\u0644\\u0644\\u0623\\u0641\\u0643\\u0627\\u0631 \\u2014 \\u064a\\u0642\\u0648\\u0645 \\u0627\\u0644\\u0627\\u0633\\u062a\\u062f\\u064a\\u0648 \\u0628\\u062a\\u0648\\u0644\\u064a\\u062f \\u0627\\u0644\\u0623\\u0641\\u0643\\u0627\\u0631 \\u062f\\u0627\\u062e\\u0644\\u064a\\u0627\\u064b \\u0648\\u0627\\u0644\\u062a\\u062d\\u0642\\u0642 \\u0645\\u0646\\u0647\\u0627 \\u062b\\u0645 \\u0627\\u0633\\u062a\\u0642\\u0637\\u0627\\u0628 \\u0645\\u0624\\u0633\\u0633\\u064a\\u0646 \\u062a\\u0642\\u0646\\u064a\\u064a\\u0646 \\u0644\\u0642\\u064a\\u0627\\u062f\\u062a\\u0647\\u0627.","desc_en":"An inventory-led model: ideas are generated and validated internally, then technical founders are recruited to lead them."},"lifecycle":{"label":"\\u0627\\u0644\\u062e\\u0637\\u0629 \\u0627\\u0644\\u062a\\u0634\\u063a\\u064a\\u0644\\u064a\\u0629","label_en":"Operating Plan","title":"\\u062f\\u0648\\u0631\\u0629 \\u062d\\u064a\\u0627\\u0629 \\u0627\\u0644\\u0645\\u0634\\u0631\\u0648\\u0639","title_en":"Venture Lifecycle"},"financial":{"label":"\\u0627\\u0644\\u062c\\u062f\\u0648\\u0649 \\u0627\\u0644\\u0645\\u0627\\u0644\\u064a\\u0629","label_en":"Financial Feasibility","title":"\\u0627\\u0644\\u0646\\u0645\\u0648\\u0630\\u062c \\u0627\\u0644\\u0645\\u0627\\u0644\\u064a \\u0627\\u0644\\u0645\\u0642\\u062a\\u0631\\u062d","title_en":"Proposed Financial Model","desc":"\\u0633\\u064a\\u0646\\u0627\\u0631\\u064a\\u0648 \\u0645\\u0639\\u062a\\u062f\\u0644 \\u0644\\u062e\\u0645\\u0633 \\u0633\\u0646\\u0648\\u0627\\u062a \\u2014 IRR \\u0628\\u064a\\u0646 35%\\u201350%.","desc_en":"A moderate five-year scenario \\u2014 IRR between 35%\\u201350%.","note":"\\u0645\\u0639\\u062f\\u0644 \\u0628\\u0642\\u0627\\u0621 60%\\u201370% \\u0644\\u0644\\u0648\\u0635\\u0648\\u0644 \\u0625\\u0644\\u0649 Seed \\u0648\\u0645\\u0639\\u062f\\u0644 IRR 35%\\u201350%.","note_en":"60%\\u201370% survival to Seed and IRR of 35%\\u201350%."},"team":{"label":"\\u0645\\u0634\\u0627\\u0631\\u064a\\u0639\\u0646\\u0627","label_en":"Our Projects","title":"\\u0645\\u0634\\u0627\\u0631\\u064a\\u0639\\u0646\\u0627 \\u0627\\u0644\\u0625\\u0628\\u062f\\u0627\\u0639\\u064a\\u0629","title_en":"Creative Ventures"},"kpis":{"label":"\\u0645\\u0624\\u0634\\u0631\\u0627\\u062a \\u0627\\u0644\\u0623\\u062f\\u0627\\u0621","label_en":"Performance Indicators","title":"KPIs \\u0644\\u0642\\u064a\\u0627\\u0633 \\u0627\\u0644\\u0646\\u062c\\u0627\\u062d","title_en":"KPIs to Measure Success"},"marketing":{"label":"\\u0627\\u0644\\u062a\\u0633\\u0648\\u064a\\u0642 \\u0648\\u0627\\u0644\\u0639\\u0644\\u0627\\u0645\\u0629","label_en":"Marketing & Brand","title":"\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u062c\\u0630\\u0628 \\u0627\\u0644\\u0634\\u0631\\u0643\\u0627\\u0621","title_en":"Partner Attraction Strategy"},"contact":{"label":"\\u062a\\u0648\\u0627\\u0635\\u0644 \\u0645\\u0639\\u0646\\u0627","label_en":"Contact Us","title":"\\u0647\\u0644 \\u0623\\u0646\\u062a \\u0645\\u0633\\u062a\\u0639\\u062f \\u0644\\u0644\\u0627\\u0646\\u0636\\u0645\\u0627\\u0645\\u061f","title_en":"Ready to Join?","desc":"\\u0633\\u0648\\u0627\\u0621 \\u0643\\u0646\\u062a \\u0645\\u0624\\u0633\\u0633\\u0627\\u064b \\u0623\\u0648 \\u0645\\u0633\\u062a\\u062b\\u0645\\u0631\\u0627\\u064b \\u0623\\u0648 \\u0634\\u0631\\u0643\\u0629 \\u2014 \\u0627\\u0644\\u062f\\u0643\\u0629 \\u0647\\u064a \\u0645\\u0643\\u0627\\u0646\\u0643.","desc_en":"Whether you are a founder, investor, or enterprise \\u2014 Aldakkah is your place.","email":"hello@aldakkah.sa","phone":"+966 5X XXX XXXX","city":"\\u0627\\u0644\\u0631\\u064a\\u0627\\u0636","city_en":"Riyadh","country":"\\u0627\\u0644\\u0645\\u0645\\u0644\\u0643\\u0629 \\u0627\\u0644\\u0639\\u0631\\u0628\\u064a\\u0629 \\u0627\\u0644\\u0633\\u0639\\u0648\\u062f\\u064a\\u0629","country_en":"Kingdom of Saudi Arabia","btn1":"\\u0631\\u0627\\u0633\\u0644\\u0646\\u0627 \\u0627\\u0644\\u0622\\u0646","btn1_en":"Email Us","btn2":"LinkedIn"},"footer":{"about":"\\u0627\\u0633\\u062a\\u062f\\u064a\\u0648 \\u0623\\u0639\\u0645\\u0627\\u0644 \\u0633\\u0639\\u0648\\u062f\\u064a \\u064a\\u062d\\u0648\\u0651\\u0644 \\u0627\\u0644\\u0623\\u0641\\u0643\\u0627\\u0631 \\u0627\\u0644\\u0637\\u0645\\u0648\\u062d\\u0629 \\u0625\\u0644\\u0649 \\u0643\\u064a\\u0627\\u0646\\u0627\\u062a \\u0631\\u0642\\u0645\\u064a\\u0629 \\u0645\\u0633\\u062a\\u062f\\u0627\\u0645\\u0629.","about_en":"A Saudi venture studio turning ambitious ideas into sustainable digital companies.","linkedin":"#","twitter":"#","instagram":"#","youtube":"#","copy":"\\u062c\\u0645\\u064a\\u0639 \\u0627\\u0644\\u062d\\u0642\\u0648\\u0642 \\u0645\\u062d\\u0641\\u0648\\u0638\\u0629","copy_en":"All rights reserved","credit":"\\u0623\\u064f\\u0639\\u0650\\u062f\\u064e\\u0651 \\u0628\\u0648\\u0627\\u0633\\u0637\\u0629 Madani Halwani","credit_en":"Prepared by Madani Halwani"},"partners":{"label":"\\u0634\\u0631\\u0643\\u0627\\u0624\\u0646\\u0627","label_en":"Our Partners","title":"\\u064a\\u062b\\u0642\\u0648\\u0646 \\u0628\\u0646\\u0627","title_en":"They Trust Us"},"stats":{"s1v":"$1.72B","s1l":"\\u0627\\u0644\\u0627\\u0633\\u062a\\u062b\\u0645\\u0627\\u0631 \\u0627\\u0644\\u062c\\u0631\\u064a\\u0621 \\u0641\\u064a \\u0627\\u0644\\u0633\\u0639\\u0648\\u062f\\u064a\\u0629 2025","s1l_en":"VC investment in KSA 2025","s2v":"145%","s2l":"\\u0646\\u0645\\u0648 \\u0627\\u0644\\u0627\\u0633\\u062a\\u062b\\u0645\\u0627\\u0631 \\u0639\\u0646 \\u0627\\u0644\\u0639\\u0627\\u0645 \\u0627\\u0644\\u0633\\u0627\\u0628\\u0642","s2l_en":"YoY investment growth","s3v":"$13.4B","s3l":"\\u0633\\u0648\\u0642 \\u0627\\u0644\\u062a\\u062d\\u0648\\u0644 \\u0627\\u0644\\u0631\\u0642\\u0645\\u064a \\u0627\\u0644\\u0633\\u0639\\u0648\\u062f\\u064a","s3l_en":"Saudi digital transformation market","s4v":"22.18%","s4l":"\\u0645\\u0639\\u062f\\u0644 \\u0627\\u0644\\u0646\\u0645\\u0648 \\u0627\\u0644\\u0633\\u0646\\u0648\\u064a \\u0627\\u0644\\u0645\\u0631\\u0643\\u0628 \\u062d\\u062a\\u0649 2034","s4l_en":"CAGR through 2034"},"ecosystem":{"label":"\\u0645\\u0646\\u0638\\u0648\\u0645\\u062a\\u0646\\u0627","label_en":"Our Ecosystem","title":"\\u0628\\u0646\\u064a\\u0629 \\u0645\\u062a\\u0643\\u0627\\u0645\\u0644\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u0641\\u0643\\u0631\\u0629 \\u062d\\u062a\\u0649 \\u0627\\u0644\\u062a\\u0648\\u0633\\u0639","title_en":"A complete infrastructure from idea to scale","desc":"\\u0623\\u0631\\u0628\\u0639 \\u0623\\u0630\\u0631\\u0639 \\u0645\\u062a\\u0631\\u0627\\u0628\\u0637\\u0629. \\u0627\\u0633\\u062a\\u0648\\u062f\\u064a\\u0648 \\u0648\\u0627\\u062d\\u062f. \\u0643\\u0644 \\u0645\\u0627 \\u064a\\u062d\\u062a\\u0627\\u062c\\u0647 \\u0627\\u0644\\u0645\\u0624\\u0633\\u0633 \\u0644\\u0644\\u0627\\u0646\\u062a\\u0642\\u0627\\u0644 \\u0645\\u0646 \\u0627\\u0644\\u0641\\u0643\\u0631\\u0629 \\u0625\\u0644\\u0649 \\u0627\\u0644\\u0634\\u0631\\u0643\\u0629.","desc_en":"Four connected arms. One studio. Everything a founder needs to move from concept to company.","more":"\\u0627\\u0633\\u062a\\u0643\\u0634\\u0641 \\u0627\\u0644\\u0645\\u0632\\u064a\\u062f \\u2190","more_en":"Explore more \\u2192"},"strategy":{"label":"\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0627\\u0644\\u062f\\u0643\\u0629","label_en":"The Aldakkah Strategy","title":"\\u0625\\u0637\\u0627\\u0631 \\u0639\\u0645\\u0644 \\u0645\\u062b\\u0628\\u062a \\u0644\\u0628\\u0646\\u0627\\u0621 \\u0634\\u0631\\u0643\\u0627\\u062a \\u0631\\u0627\\u0626\\u062f\\u0629","title_en":"A proven framework to build market-leading ventures","desc":"\\u062a\\u0633\\u0639 \\u062e\\u0637\\u0648\\u0627\\u062a \\u0645\\u062f\\u0631\\u0648\\u0633\\u0629 \\u2014 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u062d\\u0642\\u0642 \\u0645\\u0646 \\u0627\\u0644\\u0637\\u0644\\u0628 \\u062d\\u062a\\u0649 \\u0627\\u0644\\u062a\\u062e\\u0627\\u0631\\u062c.","desc_en":"Nine deliberate steps \\u2014 from validating demand to a clean exit."},"benefits":{"label":"\\u0644\\u0645\\u0627\\u0630\\u0627 \\u0627\\u0644\\u062f\\u0643\\u0629","label_en":"Why Aldakkah","title":"\\u0645\\u0627\\u0630\\u0627 \\u062a\\u062d\\u0635\\u0644 \\u0639\\u0644\\u064a\\u0647 \\u0643\\u0645\\u0624\\u0633\\u0633 \\u0645\\u0634\\u0627\\u0631\\u0643","title_en":"What You Get as a Co-Founder","desc":"\\u0644\\u0627 \\u0646\\u0643\\u062a\\u0641\\u064a \\u0628\\u0627\\u0644\\u062a\\u0645\\u0648\\u064a\\u0644 \\u2014 \\u0646\\u0628\\u0646\\u064a \\u0625\\u0644\\u0649 \\u062c\\u0627\\u0646\\u0628\\u0643.","desc_en":"We do not just fund \\u2014 we build beside you.","cta":"\\u0627\\u0646\\u0636\\u0645 \\u0643\\u0645\\u0624\\u0633\\u0633 \\u0645\\u0634\\u0627\\u0631\\u0643","cta_en":"Become a Co-Founder"},"insights":{"label":"\\u0623\\u062d\\u062f\\u062b \\u0627\\u0644\\u0631\\u0624\\u0649","label_en":"Latest Insights","title":"\\u0631\\u0624\\u0649 \\u0648\\u0623\\u0641\\u0643\\u0627\\u0631","title_en":"Insights & Ideas","more":"\\u0639\\u0631\\u0636 \\u0643\\u0644 \\u0627\\u0644\\u0645\\u0642\\u0627\\u0644\\u0627\\u062a","more_en":"View all posts"},"portfolio":{"label":"\\u0627\\u0644\\u0645\\u062d\\u0641\\u0638\\u0629","label_en":"Portfolio","title":"\\u0634\\u0631\\u0643\\u0627\\u062a \\u062a\\u064f\\u0628\\u0646\\u0649 \\u0645\\u0646 \\u0627\\u0644\\u062f\\u0643\\u0629","title_en":"Ventures built from the Dakka","desc":"\\u0634\\u0631\\u0643\\u0627\\u062a \\u062d\\u0642\\u064a\\u0642\\u064a\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u0627\\u0633\\u062a\\u0648\\u062f\\u064a\\u0648 \\u2014 \\u062a\\u064f\\u0639\\u0631\\u0636 \\u0628\\u0637\\u0627\\u0642\\u0627\\u062a \\u062a\\u062c\\u0631\\u064a\\u0628\\u064a\\u0629 \\u062d\\u062a\\u0649 \\u062a\\u064f\\u0636\\u0627\\u0641 \\u0645\\u0634\\u0627\\u0631\\u064a\\u0639 \\u0641\\u0639\\u0644\\u064a\\u0629.","desc_en":"Real companies from our studio \\u2014 demo cards appear until you add live ventures.","demo_badge":"\\u0639\\u0631\\u0636 \\u062a\\u062c\\u0631\\u064a\\u0628\\u064a","demo_badge_en":"Demo preview"}}','2026-09-24 16:38:24','2026-09-24 17:37:03');

DROP TABLE IF EXISTS `strategy_steps`;
CREATE TABLE `strategy_steps` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `step_number` BIGINT UNSIGNED NOT NULL,
  `title_ar` VARCHAR(255) NOT NULL,
  `title_en` VARCHAR(255) NOT NULL,
  `desc_ar` LONGTEXT NULL DEFAULT NULL,
  `desc_en` LONGTEXT NULL DEFAULT NULL,
  `activities` LONGTEXT NULL DEFAULT NULL,
  `deliverables` LONGTEXT NULL DEFAULT NULL,
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `strategy_steps` (`id`,`step_number`,`title_ar`,`title_en`,`desc_ar`,`desc_en`,`activities`,`deliverables`,`is_active`,`created_at`,`updated_at`) VALUES
('1','1','توليد الأفكار','Ideation','فهم المشكلة والتحقق من الطلب.','Understand the problem and validate demand.','[{"ar":"\\u0628\\u062d\\u062b \\u0627\\u0644\\u0633\\u0648\\u0642","en":"Market research"},{"ar":"\\u0627\\u0644\\u062a\\u062d\\u0642\\u0642 \\u0645\\u0646 \\u0627\\u0644\\u0623\\u0644\\u0645","en":"Problem validation"},{"ar":"\\u062d\\u062c\\u0645 \\u0627\\u0644\\u0641\\u0631\\u0635\\u0629","en":"Opportunity sizing"}]','[{"ar":"\\u0645\\u0644\\u062e\\u0635 \\u0641\\u0631\\u0635\\u0629","en":"Opportunity brief"},{"ar":"\\u0641\\u0631\\u0636\\u064a\\u0627\\u062a \\u0623\\u0648\\u0644\\u064a\\u0629","en":"Initial hypotheses"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('2','2','الجدوى','Feasibility','اختبار الجدوى التقنية والتجارية.','Test technical and commercial feasibility.','[{"ar":"\\u0646\\u0645\\u0630\\u062c\\u0629 \\u0645\\u0627\\u0644\\u064a\\u0629","en":"Financial modeling"},{"ar":"\\u0645\\u0642\\u0627\\u0628\\u0644\\u0627\\u062a \\u0639\\u0645\\u0644\\u0627\\u0621","en":"Customer interviews"}]','[{"ar":"\\u062a\\u0642\\u0631\\u064a\\u0631 \\u062c\\u062f\\u0648\\u0649","en":"Feasibility report"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('3','3','MVP','MVP','بناء الحد الأدنى القابل للتشغيل.','Build the minimum viable product.','[{"ar":"\\u062a\\u0635\\u0645\\u064a\\u0645","en":"Design"},{"ar":"\\u062a\\u0637\\u0648\\u064a\\u0631","en":"Build"}]','[{"ar":"MVP \\u062c\\u0627\\u0647\\u0632","en":"Working MVP"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('4','4','الفريق','Team','استقطاب المؤسسين التقنيين والقيادات.','Recruit technical founders and leaders.','[{"ar":"\\u062a\\u0648\\u0638\\u064a\\u0641 EIR","en":"EIR hiring"},{"ar":"\\u062a\\u0648\\u0632\\u064a\\u0639 \\u062d\\u0635\\u0635","en":"Equity split"}]','[{"ar":"\\u0641\\u0631\\u064a\\u0642 \\u0623\\u0633\\u0627\\u0633\\u064a","en":"Core team"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('5','5','الذهاب للسوق','Go-to-Market','إطلاق تجاري واستحواذ عملاء.','Commercial launch and customer acquisition.','[{"ar":"GTM","en":"GTM"},{"ar":"\\u0642\\u0646\\u0648\\u0627\\u062a \\u0646\\u0645\\u0648","en":"Growth channels"}]','[{"ar":"\\u062e\\u0637\\u0629 \\u0625\\u0637\\u0644\\u0627\\u0642","en":"Launch plan"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('6','6','الاستقرار','Stability','تثبيت العمليات والمؤشرات.','Stabilize operations and KPIs.','[{"ar":"\\u0639\\u0645\\u0644\\u064a\\u0627\\u062a","en":"Ops"},{"ar":"\\u0648\\u062d\\u062f\\u0629 \\u0627\\u0642\\u062a\\u0635\\u0627\\u062f\\u064a\\u0627\\u062a","en":"Unit economics"}]','[{"ar":"\\u0644\\u0648\\u062d\\u0629 \\u0645\\u0624\\u0634\\u0631\\u0627\\u062a","en":"KPI dashboard"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('7','7','الاستثمار','Investment','جمع جولة Seed / Series A.','Raise Seed / Series A.','[{"ar":"\\u0625\\u0639\\u062f\\u0627\\u062f \\u063a\\u0631\\u0641\\u0629 \\u0628\\u064a\\u0627\\u0646\\u0627\\u062a","en":"Data room"},{"ar":"\\u0645\\u0633\\u062a\\u062b\\u0645\\u0631\\u064a\\u0646","en":"Investors"}]','[{"ar":"\\u0627\\u0644\\u062a\\u0632\\u0627\\u0645 \\u062a\\u0645\\u0648\\u064a\\u0644","en":"Funding commitment"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('8','8','النمو','Growth','توسيع السوق والمنتج.','Scale market and product.','[{"ar":"\\u062a\\u0648\\u0633\\u0639 \\u062c\\u063a\\u0631\\u0627\\u0641\\u064a","en":"Geo expansion"},{"ar":"\\u0645\\u0646\\u062a\\u062c\\u0627\\u062a \\u062c\\u062f\\u064a\\u062f\\u0629","en":"New products"}]','[{"ar":"\\u062e\\u0637\\u0629 \\u0646\\u0645\\u0648","en":"Growth plan"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56'),
('9','9','التخارج','Exit','M&A أو IPO أو توزيعات.','M&A, IPO, or distributions.','[{"ar":"\\u062a\\u0642\\u064a\\u064a\\u0645","en":"Valuation"},{"ar":"\\u062a\\u0641\\u0627\\u0648\\u0636","en":"Negotiation"}]','[{"ar":"\\u062a\\u062e\\u0627\\u0631\\u062c \\u0646\\u0627\\u062c\\u062d","en":"Successful exit"}]','1','2026-09-24 16:51:56','2026-09-24 16:51:56');

DROP TABLE IF EXISTS `subscription_plans`;
CREATE TABLE `subscription_plans` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` VARCHAR(255) NOT NULL,
  `name_ar` VARCHAR(255) NOT NULL,
  `name_en` VARCHAR(255) NOT NULL,
  `description_ar` LONGTEXT NULL DEFAULT NULL,
  `description_en` LONGTEXT NULL DEFAULT NULL,
  `price` LONGTEXT NOT NULL DEFAULT '0',
  `currency` VARCHAR(255) NOT NULL DEFAULT 'SAR',
  `duration_days` BIGINT UNSIGNED NOT NULL,
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `subscription_plans` (`id`,`slug`,`name_ar`,`name_en`,`description_ar`,`description_en`,`price`,`currency`,`duration_days`,`is_active`,`created_at`,`updated_at`) VALUES
('1','monthly','اشتراك شهري','Monthly Plan','وصول كامل لجميع الأدوات وبنك المستثمرين لمدة شهر.','Full access to all tools and the Investors Bank for one month.','299','SAR','30','1','2026-09-24 16:38:24','2026-09-24 16:38:24'),
('2','yearly','اشتراك سنوي','Yearly Plan','وصول كامل لجميع الأدوات وبنك المستثمرين لمدة سنة.','Full access to all tools and the Investors Bank for one year.','2990','SAR','365','1','2026-09-24 16:38:24','2026-09-24 16:38:24');

DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE `subscriptions` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT UNSIGNED NOT NULL,
  `subscription_plan_id` BIGINT UNSIGNED NOT NULL,
  `status` VARCHAR(255) NOT NULL DEFAULT 'pending',
  `starts_at` LONGTEXT NULL DEFAULT NULL,
  `ends_at` LONGTEXT NULL DEFAULT NULL,
  `admin_notes` LONGTEXT NULL DEFAULT NULL,
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `subscriptions`

DROP TABLE IF EXISTS `tools`;
CREATE TABLE `tools` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `slug` VARCHAR(255) NOT NULL,
  `name_ar` VARCHAR(255) NOT NULL,
  `name_en` VARCHAR(255) NOT NULL,
  `description_ar` LONGTEXT NULL DEFAULT NULL,
  `description_en` LONGTEXT NULL DEFAULT NULL,
  `is_active` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `available_on_trial` BIGINT UNSIGNED NOT NULL DEFAULT '1',
  `trial_limit` BIGINT UNSIGNED NULL DEFAULT NULL,
  `sort_order` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `tools` (`id`,`slug`,`name_ar`,`name_en`,`description_ar`,`description_en`,`is_active`,`available_on_trial`,`trial_limit`,`sort_order`,`created_at`,`updated_at`) VALUES
('1','investors','بنك المستثمرين','Investors Bank','قاعدة بيانات المستثمرين مع بيانات التواصل والملفات.','Investor database with contact details and documents.','1','1','5','1','2026-09-24 16:38:24','2026-09-24 16:38:24');

DROP TABLE IF EXISTS `trials`;
CREATE TABLE `trials` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` BIGINT UNSIGNED NOT NULL,
  `started_at` LONGTEXT NOT NULL,
  `ends_at` LONGTEXT NOT NULL,
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- no rows in `trials`

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `email_verified_at` LONGTEXT NULL DEFAULT NULL,
  `password` VARCHAR(255) NOT NULL,
  `remember_token` VARCHAR(255) NULL DEFAULT NULL,
  `created_at` LONGTEXT NULL DEFAULT NULL,
  `updated_at` LONGTEXT NULL DEFAULT NULL,
  `role` VARCHAR(255) NOT NULL DEFAULT 'user',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`id`,`name`,`email`,`email_verified_at`,`password`,`remember_token`,`created_at`,`updated_at`,`role`) VALUES
('1','Admin','admin@aldakkah.sa','2026-09-24 16:53:34','$2y$12$WiU8QF1VUNrocFD7XMYEtuoBPwJRb0VNIrR/ziz385Ufnb2UI3yVu',NULL,'2026-09-24 16:38:23','2026-09-24 16:53:34','admin');

SET FOREIGN_KEY_CHECKS=1;