drop table if exists OOOTemp;

create table OOOTemp (
    ID INTEGER primary key,
    OOOUserID INTEGER not null,
    DelegatedTo INTEGER not null,
    OOOStartDate TEXT not null,
    OOOExpirationDate TEXT not null,
    Processed INTEGER default 0
);

insert into OOOTemp (OOOUserID, DelegatedTo, OOOStartDate, OOOExpirationDate)
values (15, 22, '2024-03-19 00:00:00', '2024-04-19 00:00:00'),
(34, 19, '2024-03-19 00:00:00', '2024-04-19 00:00:00'),
(2, 15, '2024-03-19 00:00:00', '2024-04-01 00:00:00'),
(19, 18, '2024-04-01 00:00:00', '2033-06-01 00:00:00');