-- Set timestamps on selected test records to a sliding window so that
-- various tests expecting to find various expired, expiring, or valid-after
-- records work correctly

UPDATE records SET stamp = date_trunc('day', now() - interval '5 day') + '18:30' WHERE record_id = 47;
UPDATE records SET stamp = date_trunc('day', now() + interval '3 day') + '07:00' WHERE record_id = 48;
UPDATE records SET stamp = date_trunc('day', now() + interval '5 day') + '11:30' WHERE record_id = 49;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '14:00' WHERE record_id = 50;

UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 59;
UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 60;
UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 61;
UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 62;

UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 64;
UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 65;
UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 66;
UPDATE records SET stamp = date_trunc('day', now() + interval '1 day') + '11:30' WHERE record_id = 67;

UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 75;
UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 76;
UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 77;
UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 78;

UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 84;
UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 85;
UPDATE records SET stamp = date_trunc('day', now() + interval '2 day') + '11:30' WHERE record_id = 86;
UPDATE records SET stamp = date_trunc('day', now() - interval '2 day') + '11:30' WHERE record_id = 87;
UPDATE records SET stamp = date_trunc('day', now() + interval '5 day') + '11:30' WHERE record_id = 88;

UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 96;
UPDATE records SET stamp = date_trunc('day', now() + interval '1 day') + '11:30' WHERE record_id = 97;
UPDATE records SET stamp = date_trunc('day', now() + interval '4 day') + '11:30' WHERE record_id = 98;
UPDATE records SET stamp = date_trunc('day', now() + interval '1 day') + '11:30' WHERE record_id = 99;

UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 114;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 115;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 117;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 118;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 119;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 121;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 122;
UPDATE records SET stamp = date_trunc('day', now() - interval '3 day') + '20:20' WHERE record_id = 123;
