Testing Outage Creation

<h1>Testing Outage Creation</h1><h2>1. Checking database table structure...</h2><strong>Outages table structure:</strong><br><pre>id - int(11) - NO - 
title - varchar(255) - NO - 
description - text - YES - 
status - enum('planned','ongoing','resolved') - YES - planned
severity - enum('low','medium','high','critical') - YES - medium
affected_services - text - YES - 
affected_areas - text - YES - 
start_time - datetime - NO - 
end_time - datetime - YES - 
estimated_resolution - datetime - YES - 
resolved_at - datetime - YES - 
created_by - varchar(255) - YES - 
created_at - timestamp - YES - current_timestamp()
updated_at - timestamp - YES - current_timestamp()
</pre><h2>2. Test data to be inserted:</h2><pre>{
    "title": "Test Outage Creation",
    "description": "This is a test outage to verify creation functionality",
    "status": "planned",
    "severity": "medium",
    "affected_services": [
        "Internet",
        "Email"
    ],
    "affected_areas": [
        "Cape Town",
        "Johannesburg"
    ],
    "start_time": "2024-01-20 10:00:00",
    "end_time": "2024-01-20 12:00:00",
    "estimated_resolution": "2024-01-20 12:00:00",
    "created_by": "admin"
}</pre><h2>3. Attempting to create outage...</h2><strong>Result:</strong><br><pre>{
    "success": true,
    "data": {
        "outage_id": "44"
    },
    "message": "Outage created successfully"
}</pre><p style='color: green;'>SUCCESS: Outage created successfully!</p><h2>4. Verifying insertion (ID: 44)...</h2><strong>Inserted record:</strong><br><pre>{
    "id": 44,
    "title": "Test Outage Creation",
    "description": "This is a test outage to verify creation functionality",
    "status": "planned",
    "severity": "medium",
    "affected_services": "[\"Internet\",\"Email\"]",
    "affected_areas": "[\"Cape Town\",\"Johannesburg\"]",
    "start_time": "2024-01-20 10:00:00",
    "end_time": "2024-01-20 12:00:00",
    "estimated_resolution": "2024-01-20 12:00:00",
    "resolved_at": null,
    "created_by": "admin",
    "created_at": "2026-07-05 22:11:41",
    "updated_at": "2026-07-05 22:11:41"
}</pre>