set foreign_key_checks = 0;
delete from concern;
delete from current_task;
delete from next_period_task;
delete from completed_task;
delete from suggestion;
delete from report;
delete from report_directory;
delete from profile_picture;

insert into report_directory (id, created_on, owner_code, owner_username)
values (1, utc_timestamp, 'F9981CA', 'moises'),
       (2, utc_timestamp, 'EMD8754', 'john.doe'),
       (3, utc_timestamp, 'E7F3AC3', 'mary.jane');

insert into report_directory_supervisor_code (report_directory_id, supervisor_code)
values (2, 'F9981CA');

insert into report (id, created_on, description, end_date, note, start_date, report_directory_id)
values (1, utc_timestamp, 'Moises first SOW.', '2022-08-15', '1 Report note...', '2022-08-01', 1),
       (2, utc_timestamp, 'Moises second SOW.', '2022-08-30', '2 Report note...', '2022-08-15', 1),
       (3, utc_timestamp, 'Moises third SOW.', '2022-09-15', '3 Report note...', '2022-09-01', 1),
       (4, utc_timestamp, 'John first SOW.', '2022-08-15', '4 Report note...', '2022-08-01', 2),
       (5, utc_timestamp, 'John second SOW.', '2022-08-30', '5 Report note...', '2022-08-15', 2),
       (6, utc_timestamp, 'John third SOW.', '2022-09-15', '6 Report note...', '2022-09-01', 2);

insert into completed_task (id, completed_date, created_on, description, due_date, hours_spent, note, status, report_id)
values (1, '2022-08-10', utc_timestamp, '1 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 5.5, '1 Completed task note....', 'Completed', 1),
       (2, '2022-08-14', utc_timestamp, '2 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 2.5, '2 Completed task note....', 'Completed', 1),
       (3, '2022-08-10', utc_timestamp, '3 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 6.5, '3 Completed task note....', 'Completed', 2),
       (4, '2022-08-14', utc_timestamp, '4 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 3.0, '4 Completed task note....', 'Completed', 2),
       (5, '2022-08-14', utc_timestamp, '5 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 2.5, '5 Completed task note....', 'Completed', 4),
       (6, '2022-08-10', utc_timestamp, '6 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 6.5, '6 Completed task note....', 'Completed', 4),
       (7, '2022-08-14', utc_timestamp, '7 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 2.5, '7 Completed task note....', 'Completed', 5),
       (8, '2022-08-10', utc_timestamp, '8 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-15', 6.5, '8 Completed task note....', 'Completed', 6);

insert into current_task (id, created_on, description, due_date, hours_spent, note, report_id)
values (1, utc_timestamp, '1 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        7.0, '1 Current Task note...', 1),
       (2, utc_timestamp, '2 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        3.5, '2 Current Task note...', 1),
       (3, utc_timestamp, '3 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        7.0, '3 Current Task note...', 2),
       (4, utc_timestamp, '4 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        3.5, '4 Current Task note...', 2),
       (5, utc_timestamp, '5 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        7.0, '5 Current Task note...', 4),
       (6, utc_timestamp, '6 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        3.5, '6 Current Task note...', 4),
       (7, utc_timestamp, '7 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        7.0, '7 Current Task note...', 5),
       (8, utc_timestamp, '8 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.', '2022-08-10',
        3.5, '8 Current Task note...', 5);

insert into concern (id, created_on, date, description, note, report_id)
values (1, utc_timestamp, '2022-08-10', '1 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '1 Concern note...', 1),
       (2, utc_timestamp, '2022-08-05', '2 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2 Concern note...', 2),
       (3, utc_timestamp, '2022-08-10', '3 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '3 Concern note...', 3),
       (4, utc_timestamp, '2022-08-05', '4 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '4 Concern note...', 4),
       (5, utc_timestamp, '2022-08-10', '5 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '5 Concern note...', 5),
       (6, utc_timestamp, '2022-08-05', '6 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '6 Concern note...', 6);

insert into next_period_task (id, created_on, description, date, note, report_id)
values (1, utc_timestamp, '1 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-10', '1 Next Period note...', 1),
       (2, utc_timestamp, '2 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-14', '2 Next Period note...', 2),
       (3, utc_timestamp, '3 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-10', '3 Next Period note...', 3),
       (4, utc_timestamp, '4 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-14', '4 Next Period note...', 4),
       (5, utc_timestamp, '5 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-10', '5 Next Period note...', 5),
       (6, utc_timestamp, '6 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2022-08-14', '6 Next Period note...', 6);

insert into suggestion (id, created_on, description, note, report_id)
values (1, utc_timestamp, '1 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '1 Suggestion note...', 1),
       (2, utc_timestamp, '2 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '2 Suggestion note...', 2),
       (3, utc_timestamp, '3 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '3 Suggestion note...', 3),
       (4, utc_timestamp, '4 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '4 Suggestion note...', 4),
       (5, utc_timestamp, '5 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '5 Suggestion note...', 5),
       (6, utc_timestamp, '6 Lorem ipsum dolor sit amet. Aut illo consectetur eum quia fugit et velit.',
        '6 Suggestion note...', 6);

set foreign_key_checks = 1;

