INSERT INTO `aircraft_profiles`
(
    `slug`, `name`, `manufacturer`, `simulator`, `developer`, `aircraft_type`,
    `description`, `thumbnail_path`, `preview_model_path`, `profile_data`,
    `is_active`, `is_certified`, `supports_3d_paint`, `supports_export`,
    `sort_order`, `created_at`, `updated_at`
)
VALUES
(
    'fbw-a32nx',
    'FlyByWire A32NX',
    'Airbus',
    'msfs2020',
    'FlyByWire Simulations',
    'A320neo',
    'Nexus Studio preview profile for the freeware FlyByWire A32NX. Includes direct browser 3D painting on an independently generated A320-style preview model. Simulator export remains disabled until a production-safe texture/export profile is finalized.',
    NULL,
    NULL,
    '{"renderer":"procedural-a32nx-v1","compatibility_target":"FlyByWire A32NX","texture_size":2048,"surfaces":["fuselage","tail","engine_left","engine_right","sharklet_left","sharklet_right"],"export":{"status":"pending","target_package":"flybywire-a32nx","notes":"No FlyByWire 3D model or paint-kit assets are bundled in Nexus Studio."}}',
    1,
    0,
    1,
    0,
    0,
    NOW(),
    NOW()
)
ON DUPLICATE KEY UPDATE
    `name` = VALUES(`name`),
    `manufacturer` = VALUES(`manufacturer`),
    `simulator` = VALUES(`simulator`),
    `developer` = VALUES(`developer`),
    `aircraft_type` = VALUES(`aircraft_type`),
    `description` = VALUES(`description`),
    `profile_data` = VALUES(`profile_data`),
    `is_active` = VALUES(`is_active`),
    `is_certified` = VALUES(`is_certified`),
    `supports_3d_paint` = VALUES(`supports_3d_paint`),
    `supports_export` = VALUES(`supports_export`),
    `sort_order` = VALUES(`sort_order`),
    `updated_at` = NOW();