INSERT INTO application (id,name) VALUES (1,'incident management system');
INSERT INTO application (id,name) VALUES (2,'coffee machine');
INSERT INTO application (id,name) VALUES (3,'web site');
INSERT INTO application (id,name) VALUES (4,'internet');

INSERT INTO incident (id,title,description,estimated_duration,who_is_affected,date_time,severity, status)
VALUES (1,"incident system down", "incident management system is down", '2h','everyone','2025-04-01 10:15', 2, 'ANALYSIS');
INSERT INTO incident (id,title,description,estimated_duration,who_is_affected,date_time,severity, status)
VALUES (2,"network issue", "there is a network issue impacting performance", '2h','everyone','2025-04-01 14:15', 1, 'DETECTION');
INSERT INTO incident (id,title,description,estimated_duration,who_is_affected,date_time,severity, status)
VALUES (3,"slowness", "general slowness", '2h','everyone','2025-04-01 07:15', 1, 'CLOSED');

INSERT INTO incident_application(incident_id, application_id) VALUES (1,1);
INSERT INTO incident_application(incident_id, application_id) VALUES (2,1);
INSERT INTO incident_application(incident_id, application_id) VALUES (2,3);
INSERT INTO incident_application(incident_id, application_id) VALUES (2,4);
INSERT INTO incident_application(incident_id, application_id) VALUES (3,2);