INSERT INTO redirects (
    source_path, target_url, status_code, is_active, note, created_at, updated_at
)
SELECT
    '/contact/',
    '/pages/contact/',
    301,
    1,
    'Alias public page contact avec slash final',
    CURRENT_TIMESTAMP,
    CURRENT_TIMESTAMP
WHERE NOT EXISTS (
    SELECT 1 FROM redirects WHERE source_path = '/contact/'
);

INSERT INTO redirects (
    source_path, target_url, status_code, is_active, note, created_at, updated_at
)
SELECT
    '/demo/',
    '/pages/demande-de-demonstration/',
    301,
    1,
    'Alias public page demonstration avec slash final',
    CURRENT_TIMESTAMP,
    CURRENT_TIMESTAMP
WHERE NOT EXISTS (
    SELECT 1 FROM redirects WHERE source_path = '/demo/'
);

INSERT INTO redirects (
    source_path, target_url, status_code, is_active, note, created_at, updated_at
)
SELECT
    '/demande-de-demo/',
    '/pages/demande-de-demonstration/',
    301,
    1,
    'Alias court page demonstration avec slash final',
    CURRENT_TIMESTAMP,
    CURRENT_TIMESTAMP
WHERE NOT EXISTS (
    SELECT 1 FROM redirects WHERE source_path = '/demande-de-demo/'
);
