-- ============================================================
-- MUVR Labs - MySQL Database Schema + Seed Data
-- Compatible with Laravel 10 / MySQL 8+
-- ============================================================

CREATE DATABASE IF NOT EXISTS muvr_labs CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE muvr_labs;

-- ─────────────────────────────────────────
-- ADMIN USERS
-- ─────────────────────────────────────────
CREATE TABLE users (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL UNIQUE,
    email_verified_at TIMESTAMP NULL,
    password VARCHAR(255) NOT NULL,
    role ENUM('admin','editor') DEFAULT 'editor',
    remember_token VARCHAR(100) NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- ─────────────────────────────────────────
-- SITE SETTINGS (key-value)
-- ─────────────────────────────────────────
CREATE TABLE site_settings (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    `key` VARCHAR(100) NOT NULL UNIQUE,
    `value` TEXT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- ─────────────────────────────────────────
-- PRODUCTS
-- ─────────────────────────────────────────
CREATE TABLE products (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    slug VARCHAR(255) NOT NULL UNIQUE,
    subtitle VARCHAR(255) NULL,
    standard_badge VARCHAR(100) NULL,
    short_description TEXT NULL,
    full_description LONGTEXT NULL,
    hero_image VARCHAR(255) NULL,
    thumbnail VARCHAR(255) NULL,
    brochure_file VARCHAR(255) NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1,
    meta_title VARCHAR(255) NULL,
    meta_description TEXT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE product_features (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    product_id BIGINT UNSIGNED NOT NULL,
    feature VARCHAR(255) NOT NULL,
    sort_order INT DEFAULT 0,
    FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE CASCADE
);

CREATE TABLE product_images (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    product_id BIGINT UNSIGNED NOT NULL,
    image_path VARCHAR(255) NOT NULL,
    alt_text VARCHAR(255) NULL,
    sort_order INT DEFAULT 0,
    FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE CASCADE
);

-- ─────────────────────────────────────────
-- SOLUTIONS
-- ─────────────────────────────────────────
CREATE TABLE solutions (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(255) NOT NULL UNIQUE,
    icon_svg TEXT NULL,
    short_description TEXT NULL,
    full_description LONGTEXT NULL,
    hero_image VARCHAR(255) NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1,
    meta_title VARCHAR(255) NULL,
    meta_description TEXT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- ─────────────────────────────────────────
-- CASE STUDIES
-- ─────────────────────────────────────────
CREATE TABLE case_studies (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    slug VARCHAR(255) NOT NULL UNIQUE,
    tab_label VARCHAR(100) NULL,
    summary TEXT NULL,
    full_content LONGTEXT NULL,
    hero_image VARCHAR(255) NULL,
    category VARCHAR(100) NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1,
    meta_title VARCHAR(255) NULL,
    meta_description TEXT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- ─────────────────────────────────────────
-- RESOURCES
-- ─────────────────────────────────────────
CREATE TABLE resource_categories (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    slug VARCHAR(100) NOT NULL UNIQUE,
    sort_order INT DEFAULT 0
);

CREATE TABLE resources (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    category_id BIGINT UNSIGNED NOT NULL,
    title VARCHAR(255) NOT NULL,
    description TEXT NULL,
    file_path VARCHAR(255) NULL,
    external_url VARCHAR(500) NULL,
    resource_type ENUM('pdf','video','link','article') DEFAULT 'pdf',
    youtube_embed_id VARCHAR(100) NULL,
    thumbnail VARCHAR(255) NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (category_id) REFERENCES resource_categories(id) ON DELETE CASCADE
);

-- ─────────────────────────────────────────
-- CAREERS
-- ─────────────────────────────────────────
CREATE TABLE jobs (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    department VARCHAR(100) NULL,
    location VARCHAR(100) NULL,
    job_type VARCHAR(100) NULL,
    description LONGTEXT NULL,
    requirements TEXT NULL,
    is_active TINYINT(1) DEFAULT 1,
    sort_order INT DEFAULT 0,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE job_applications (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    job_id BIGINT UNSIGNED NULL,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    phone VARCHAR(50) NULL,
    position_applied VARCHAR(255) NULL,
    message TEXT NULL,
    cv_file VARCHAR(255) NULL,
    status ENUM('new','reviewed','shortlisted','rejected') DEFAULT 'new',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (job_id) REFERENCES jobs(id) ON DELETE SET NULL
);

-- ─────────────────────────────────────────
-- ENQUIRIES / CONTACT FORMS
-- ─────────────────────────────────────────
CREATE TABLE enquiries (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    company VARCHAR(255) NULL,
    email VARCHAR(255) NOT NULL,
    phone VARCHAR(50) NULL,
    enquiry_type ENUM('product','custom_test_rig','engineering_development','partnership','general') DEFAULT 'general',
    product_id BIGINT UNSIGNED NULL,
    message TEXT NULL,
    status ENUM('new','read','replied') DEFAULT 'new',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE SET NULL
);

-- ─────────────────────────────────────────
-- ABOUT PAGE (dynamic content)
-- ─────────────────────────────────────────
CREATE TABLE about_sections (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    section_key VARCHAR(100) NOT NULL UNIQUE,
    heading VARCHAR(255) NULL,
    subheading VARCHAR(255) NULL,
    content LONGTEXT NULL,
    image VARCHAR(255) NULL,
    sort_order INT DEFAULT 0,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

-- ─────────────────────────────────────────
-- HOME PAGE HERO / CTA (editable)
-- ─────────────────────────────────────────
CREATE TABLE hero_slides (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    eyebrow VARCHAR(255) NULL,
    heading VARCHAR(500) NOT NULL,
    subheading TEXT NULL,
    support_line TEXT NULL,
    primary_btn_text VARCHAR(100) NULL,
    primary_btn_url VARCHAR(255) NULL,
    secondary_btn_text VARCHAR(100) NULL,
    secondary_btn_url VARCHAR(255) NULL,
    background_type ENUM('gradient','image') DEFAULT 'gradient',
    image VARCHAR(255) NULL,
    is_active TINYINT(1) DEFAULT 1,
    sort_order INT DEFAULT 0
);

-- ─────────────────────────────────────────
-- HOW WE WORK STEPS
-- ─────────────────────────────────────────
CREATE TABLE process_steps (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    step_number INT NOT NULL,
    title VARCHAR(255) NOT NULL,
    description TEXT NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1
);

-- ─────────────────────────────────────────
-- WHY MUVR LABS BULLETS
-- ─────────────────────────────────────────
CREATE TABLE why_us_points (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    heading VARCHAR(255) NOT NULL,
    description TEXT NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1
);

-- ─────────────────────────────────────────
-- STANDARDS & REFERENCES
-- ─────────────────────────────────────────
CREATE TABLE standards_references (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description TEXT NULL,
    external_url VARCHAR(500) NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1
);

-- ─────────────────────────────────────────
-- NAVIGATION MENUS (optional dynamic)
-- ─────────────────────────────────────────
CREATE TABLE nav_items (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    label VARCHAR(100) NOT NULL,
    url VARCHAR(255) NOT NULL,
    parent_id BIGINT UNSIGNED NULL,
    sort_order INT DEFAULT 0,
    is_active TINYINT(1) DEFAULT 1,
    FOREIGN KEY (parent_id) REFERENCES nav_items(id) ON DELETE SET NULL
);

-- ─────────────────────────────────────────
-- SEED DATA
-- ─────────────────────────────────────────

-- Admin user (password: Admin@1234 — bcrypt hash below)
INSERT INTO users (name, email, password, role) VALUES
('Admin', 'admin@muvrlabs.com', '$2y$12$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uHxL0/EB.', 'admin');

-- Site settings
INSERT INTO site_settings (`key`, `value`) VALUES
('site_name', 'MUVR Labs'),
('site_tagline', 'Engineering-driven solutions built for real-world performance.'),
('contact_email', 'info@muvrlabs.com'),
('contact_phone', ''),
('address', ''),
('hero_section_title', 'Custom Test Rigs and Engineering Development for Demanding Applications'),
('footer_tagline', 'Engineering-driven solutions built for real-world performance.'),
('google_maps_embed', ''),
('meta_title', 'MUVR Labs — Custom Test Rigs & Engineering Solutions'),
('meta_description', 'MUVR Labs builds automated test systems, standards-compliant rigs, and project-based engineering solutions for industrial, research, and advanced technology applications.');

-- Products
INSERT INTO products (name, slug, subtitle, standard_badge, short_description, full_description, sort_order) VALUES
('AERONIX A100', 'aeronix-a100', 'Universal Gas Phase Test Rig — EN14387 Compliant', 'EN14387', 
 'AERONIX A100 is a gas phase filter test rig developed for EN14387-standard testing, capable of evaluating both carbon bed modules and mask canister testing configurations.',
 '<p>The AERONIX A100 is a fully automated gas phase filter test rig developed in compliance with EN14387 standards. Designed for use in compliance testing laboratories, research facilities, and industrial quality assurance environments, the A100 delivers precise, repeatable test execution with automated data capture.</p><h5>Key Capabilities</h5><p>The system supports both carbon bed module testing and mask canister evaluation within a single platform. The modular design allows configuration changes without additional hardware.</p><p>Built for demanding environments, the A100 provides stable and controlled gas exposure profiles, real-time monitoring, and automated data logging that integrates with standard reporting workflows.</p>',
 1),
('ASTM D6646 Test Rig', 'astm-d6646-test-rig', 'Automated Breakthrough Test System — ASTM D6646 Compliant', 'ASTM D6646',
 'An automated test rig developed in compliance with ASTM D6646 for evaluating gas phase adsorption performance and breakthrough characteristics under controlled test conditions.',
 '<p>The ASTM D6646 Test Rig is an automated test system specifically designed and built to meet the requirements of ASTM D6646 for evaluating gas phase adsorption and breakthrough performance.</p><h5>System Overview</h5><p>Designed for precision, repeatability, and dependable data logging, this system is used in industrial testing, research, and compliance verification environments.</p><p>The automated controls ensure consistent test conditions across multiple runs, while the data acquisition system captures all critical parameters in real time.</p>',
 2);

INSERT INTO product_features (product_id, feature, sort_order) VALUES
(1, 'Gas phase exposure control', 1),
(1, 'Carbon bed module testing', 2),
(1, 'Mask canister evaluation', 3),
(1, 'Automated data logging', 4),
(1, 'EN14387 compliance', 5),
(1, 'Repeatable test execution', 6),
(2, 'Breakthrough characteristic testing', 1),
(2, 'Gas adsorption evaluation', 2),
(2, 'Precision flow control', 3),
(2, 'ASTM D6646 compliance', 4),
(2, 'High-repeatability design', 5),
(2, 'Data logging system', 6);

-- Solutions
INSERT INTO solutions (title, slug, icon_svg, short_description, full_description, sort_order) VALUES
('Custom Test Rig Development', 'custom-test-rig-development',
 '<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"><rect x="3" y="3" width="18" height="18" rx="2"/><line x1="9" y1="3" x2="9" y2="21"/><line x1="3" y1="9" x2="21" y2="9"/></svg>',
 'Bespoke automated test systems engineered to your specification and standards requirements.',
 '<p>We design and build fully bespoke automated test systems tailored to your exact specification. From requirements capture through to commissioning, we manage the full engineering lifecycle.</p><p>Our test rig development capability spans mechanical design, control systems, instrumentation, software, and validation. We work with your team to understand the test standard or technical requirement, and deliver a system that performs reliably from day one.</p>',
 1),
('Automation & Instrumentation Systems', 'automation-instrumentation',
 '<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"><circle cx="12" cy="12" r="3"/><path d="M12 1v4M12 19v4M4.22 4.22l2.83 2.83M16.95 16.95l2.83 2.83M1 12h4M19 12h4M4.22 19.78l2.83-2.83M16.95 7.05l2.83-2.83"/></svg>',
 'Integrated automation solutions with precision instrumentation for industrial and research use.',
 '<p>We deliver integrated automation solutions for industrial and research applications. Our capabilities span PLC-based control systems, sensor integration, HMI development, and data acquisition system design.</p><p>Whether you need to automate an existing manual process or build a new automated system from scratch, we bring the engineering depth to deliver reliable, maintainable solutions.</p>',
 2),
('Medical Technology Development', 'medical-technology',
 '<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"><path d="M22 12h-4l-3 9L9 3l-3 9H2"/></svg>',
 'Engineering support for medical device development, testing validation, and compliance projects.',
 '<p>We provide engineering development support for medical technology companies, covering device development, testing validation, and compliance-oriented engineering programs.</p><p>Our team brings rigorous engineering practice to medtech development, supporting companies through the technical challenges of product development in a regulated environment.</p>',
 3),
('Advanced Engineering & Deep-Tech Projects', 'advanced-engineering',
 '<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="1.5" stroke-linecap="round" stroke-linejoin="round"><polygon points="12 2 15.09 8.26 22 9.27 17 14.14 18.18 21.02 12 17.77 5.82 21.02 7 14.14 2 9.27 8.91 8.26 12 2"/></svg>',
 'Complex technical programs from concept through to deployment for specialized applications.',
 '<p>We take on complex, multi-disciplinary engineering programs that sit at the boundary of what is technically feasible. From advanced product development to specialized test and measurement systems, we work on projects that require broad and deep engineering capability.</p><p>Our deep-tech engineering capability covers concept development, systems engineering, hardware and software integration, and deployment support.</p>',
 4);

-- Case Studies
INSERT INTO case_studies (title, slug, tab_label, summary, full_content, category, sort_order) VALUES
('EN14387 Test Rig Development and Deployment', 'en14387-test-rig-development', 'EN14387 Case', 
 'Development and commissioning of a complete EN14387 gas phase filter test rig. Covers design, build, calibration, and site deployment for a compliance-testing laboratory.',
 '<h4>Project Overview</h4><p>MUVR Labs was engaged to develop and commission a complete EN14387-compliant gas phase filter test rig for a specialist testing laboratory. The project scope covered full system design, mechanical build, control system integration, calibration, and on-site deployment.</p><h4>Challenge</h4><p>The client required a standards-compliant system capable of testing both carbon bed filters and mask canisters, with automated data capture and full traceability of test results.</p><h4>Solution</h4><p>We designed and built the AERONIX A100 platform, which met all EN14387 test requirements. The system was delivered, installed, and commissioned at the client site, with full documentation and operator training provided.</p><h4>Outcome</h4><p>The client achieved compliance with EN14387 testing requirements and has been using the system for ongoing product qualification and compliance verification.</p>',
 'Products', 1),
('ASTM D6646 Test System Development', 'astm-d6646-test-system', 'ASTM Case',
 'Full development of an automated ASTM D6646 breakthrough test system, including controls, data acquisition, and software interface for industrial testing.',
 '<h4>Project Overview</h4><p>A full development project to build an automated ASTM D6646 breakthrough test system for an industrial client. The project included mechanical design, control system development, data acquisition, and software interface.</p><h4>Challenge</h4><p>The client needed a highly repeatable test system capable of running long-duration breakthrough tests with automated parameter control and reliable data capture.</p><h4>Solution</h4><p>MUVR Labs developed the ASTM D6646 Test Rig with precision flow control, automated test sequencing, and a real-time data logging interface that exports results in standard formats.</p><h4>Outcome</h4><p>The client now runs automated ASTM D6646 tests with consistent results and significantly reduced manual intervention compared to their previous setup.</p>',
 'Products', 2),
('Custom Engineering and Development Projects', 'custom-engineering-projects', 'Engineering Projects',
 'A collection of custom engineering programs including automation builds, product development support, and specialized technical programs delivered for industrial clients.',
 '<h4>Overview</h4><p>This case study represents a selection of custom engineering programs delivered by MUVR Labs for industrial and technology clients. Each project involved a different combination of engineering disciplines and delivery requirements.</p><h4>Programme Examples</h4><p>Projects have included custom automation builds for manufacturing processes, product development support for hardware companies, specialized test and measurement system builds, and instrumentation integration projects.</p><h4>Engineering Approach</h4><p>In each case, we start with a thorough requirements review, produce a design proposal, and execute through to delivery and commissioning with full documentation.</p>',
 'Engineering', 3);

-- Resource Categories
INSERT INTO resource_categories (name, slug, sort_order) VALUES
('Product Brochures', 'product-brochures', 1),
('Standards & References', 'standards-references', 2),
('Videos & Media', 'videos-media', 3),
('Insights & Articles', 'insights-articles', 4);

-- Resources
INSERT INTO resources (category_id, title, description, resource_type, sort_order) VALUES
(1, 'AERONIX A100 Brochure', 'Technical specifications, applications, and compliance details for the A100 gas phase test rig.', 'pdf', 1),
(1, 'ASTM D6646 Rig Brochure', 'Full product documentation for the automated ASTM D6646 breakthrough test system.', 'pdf', 2),
(1, 'Company Profile', 'Overview of MUVR Labs capabilities, portfolio, and engineering approach.', 'pdf', 3),
(2, 'EN14387 Standard', 'Respiratory protective devices — Gas filters and combined filters — Requirements, testing, marking.', 'link', 1),
(2, 'ASTM D6646', 'Standard Test Method for Determination of the Accelerated Hydrogen Sulfide Breakthrough Capacity of Granular and Pelletized Activated Carbon.', 'link', 2),
(3, 'AERONIX A100 Demo', 'Product demonstration video for the AERONIX A100 gas phase test rig.', 'video', 1),
(3, 'ASTM D6646 Rig Demo', 'Product demonstration video for the ASTM D6646 automated test system.', 'video', 2),
(3, 'Installation Walkthrough', 'Step-by-step installation and commissioning walkthrough.', 'video', 3),
(4, 'Understanding EN14387 Gas Phase Filter Testing', 'An overview of EN14387 gas phase filter testing requirements, methodology, and system considerations.', 'article', 1),
(4, 'Breakthrough Testing and ASTM D6646 Explained', 'A technical overview of breakthrough testing for activated carbon and the ASTM D6646 test method.', 'article', 2),
(4, 'AERONIX A100 — What''s New in the Latest Build', 'Updates and improvements in the latest AERONIX A100 build cycle.', 'article', 3);

-- Process Steps
INSERT INTO process_steps (step_number, title, description, sort_order) VALUES
(1, 'Requirement Understanding', 'We start with your technical brief', 1),
(2, 'System Design', 'Engineering design and architecture', 2),
(3, 'Build & Integration', 'Fabrication and system assembly', 3),
(4, 'Testing & Validation', 'Performance verification and QA', 4),
(5, 'Deployment & Support', 'Commissioning and ongoing support', 5);

-- Why Us Points
INSERT INTO why_us_points (heading, description, sort_order) VALUES
('Focused Engineering Expertise', 'Deep domain knowledge in test systems, automation, and precision instrumentation.', 1),
('Product + Project Capability', 'We deliver both off-the-shelf compliant products and fully custom engineering programs.', 2),
('Built for Real Applications', 'Every system is designed and validated for real-world performance, not just lab conditions.', 3),
('From Design to Commissioning', 'End-to-end support from requirement definition through installation and support.', 4);

-- Jobs
INSERT INTO jobs (title, department, location, job_type, description, requirements, sort_order) VALUES
('Mechanical Design Engineer', 'Engineering', 'On-site', 'Full-time',
 'Design and develop mechanical components and assemblies for test rigs and automation systems. Experience with CAD tools and manufacturing processes required.',
 'Degree in Mechanical Engineering or equivalent. Proficiency in SolidWorks or similar CAD tools. Experience with fabrication and manufacturing processes.',
 1),
('Controls & Automation Engineer', 'Engineering', 'On-site', 'Full-time',
 'Develop PLC-based control systems, instrumentation integration, and HMI software for industrial and test system applications.',
 'Degree in Electrical/Electronic/Controls Engineering. Experience with PLC programming (Siemens/Allen Bradley). Knowledge of industrial instrumentation and data acquisition.',
 2);

-- About Sections
INSERT INTO about_sections (section_key, heading, subheading, content, sort_order) VALUES
('overview', 'Company Overview', 'About MUVR Labs',
 'MUVR Labs is an engineering company focused on building automated test systems, standards-compliant rigs, and custom engineering solutions for industrial, research, and advanced technology applications. We combine rigorous engineering methodology with practical system-building capability to deliver products and projects that perform reliably in real-world environments. Our current flagship products — the AERONIX A100 and ASTM D6646 Test Rig — represent our commitment to compliance-oriented engineering at the highest level.',
 1),
('mission', 'Mission', 'Engineering that performs',
 'To build automated test systems and engineering solutions that meet real technical demands — designed for precision, reliability, and compliance from concept to commissioning.',
 2),
('vision', 'Vision', 'A trusted engineering partner',
 'To be the go-to engineering development partner for organizations needing standards-compliant testing systems and technically complex product development support.',
 3);

-- Standards References
INSERT INTO standards_references (name, description, external_url, sort_order) VALUES
('EN14387', 'Respiratory protective devices — Gas filters and combined filters — Requirements, testing, marking.', 'https://www.en-standard.eu/', 1),
('ASTM D6646', 'Standard Test Method for Determination of the Accelerated Hydrogen Sulfide Breakthrough Capacity of Granular and Pelletized Activated Carbon.', 'https://www.astm.org/', 2);

-- Hero Slide
INSERT INTO hero_slides (eyebrow, heading, subheading, support_line, primary_btn_text, primary_btn_url, secondary_btn_text, secondary_btn_url) VALUES
('Engineering · Testing · Automation',
 'Custom Test Rigs and Engineering Development for Demanding Applications',
 'MUVR Labs builds automated test systems, standards-compliant rigs, and project-based engineering solutions for industrial, research, and advanced technology applications.',
 'From concept to commissioning — engineered for performance, precision, and real-world deployment.',
 'Explore Products', '/products',
 'Discuss Your Requirement', '/contact');