47 lines
9.0 KiB
SQL
47 lines
9.0 KiB
SQL
-- generated by seed-7d.mjs
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '6 days' + interval '00 hours 00 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '6 days' + interval '00 hours 00 minutes 00 seconds' WHERE id = 1;
|
|
UPDATE issues SET closed_at = created_at + interval '2 days' WHERE id = 1;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '6 days' + interval '10 hours 20 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '6 days' + interval '10 hours 20 minutes 00 seconds' WHERE id = 2;
|
|
UPDATE issues SET closed_at = created_at + interval '3 days' WHERE id = 2;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '6 days' + interval '00 hours 00 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '6 days' + interval '00 hours 00 minutes 00 seconds' WHERE id = 3;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '6 days' + interval '14 hours 05 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '6 days' + interval '14 hours 05 minutes 00 seconds' WHERE id = 4;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '6 days' + interval '16 hours 40 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '6 days' + interval '16 hours 40 minutes 00 seconds' WHERE id = 5;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '5 days' + interval '09 hours 30 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '5 days' + interval '09 hours 30 minutes 00 seconds' WHERE id = 6;
|
|
UPDATE issues SET closed_at = created_at + interval '2 days' WHERE id = 6;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '5 days' + interval '11 hours 10 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '5 days' + interval '11 hours 10 minutes 00 seconds' WHERE id = 7;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '5 days' + interval '13 hours 45 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '5 days' + interval '13 hours 45 minutes 00 seconds' WHERE id = 8;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '5 days' + interval '15 hours 20 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '5 days' + interval '15 hours 20 minutes 00 seconds' WHERE id = 9;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '5 days' + interval '17 hours 55 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '5 days' + interval '17 hours 55 minutes 00 seconds' WHERE id = 10;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '4 days' + interval '09 hours 00 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '4 days' + interval '09 hours 00 minutes 00 seconds' WHERE id = 11;
|
|
UPDATE issues SET closed_at = created_at + interval '2 days' WHERE id = 11;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '4 days' + interval '10 hours 15 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '4 days' + interval '10 hours 15 minutes 00 seconds' WHERE id = 12;
|
|
UPDATE issues SET closed_at = created_at + interval '3 days' WHERE id = 12;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '4 days' + interval '12 hours 30 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '4 days' + interval '12 hours 30 minutes 00 seconds' WHERE id = 13;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '4 days' + interval '14 hours 50 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '4 days' + interval '14 hours 50 minutes 00 seconds' WHERE id = 14;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '4 days' + interval '16 hours 25 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '4 days' + interval '16 hours 25 minutes 00 seconds' WHERE id = 15;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '3 days' + interval '09 hours 10 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '3 days' + interval '09 hours 10 minutes 00 seconds' WHERE id = 16;
|
|
UPDATE issues SET closed_at = created_at + interval '2 days' WHERE id = 16;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '3 days' + interval '10 hours 40 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '3 days' + interval '10 hours 40 minutes 00 seconds' WHERE id = 17;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '3 days' + interval '13 hours 20 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '3 days' + interval '13 hours 20 minutes 00 seconds' WHERE id = 18;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '3 days' + interval '15 hours 35 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '3 days' + interval '15 hours 35 minutes 00 seconds' WHERE id = 19;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '3 days' + interval '17 hours 10 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '3 days' + interval '17 hours 10 minutes 00 seconds' WHERE id = 20;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '2 days' + interval '09 hours 25 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '2 days' + interval '09 hours 25 minutes 00 seconds' WHERE id = 21;
|
|
UPDATE issues SET closed_at = created_at + interval '1 days' WHERE id = 21;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '2 days' + interval '10 hours 50 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '2 days' + interval '10 hours 50 minutes 00 seconds' WHERE id = 22;
|
|
UPDATE issues SET closed_at = created_at + interval '2 days' WHERE id = 22;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '2 days' + interval '12 hours 00 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '2 days' + interval '12 hours 00 minutes 00 seconds' WHERE id = 23;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '2 days' + interval '14 hours 30 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '2 days' + interval '14 hours 30 minutes 00 seconds' WHERE id = 24;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '2 days' + interval '16 hours 05 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '2 days' + interval '16 hours 05 minutes 00 seconds' WHERE id = 25;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '1 days' + interval '09 hours 15 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '1 days' + interval '09 hours 15 minutes 00 seconds' WHERE id = 26;
|
|
UPDATE issues SET closed_at = created_at + interval '1 days' WHERE id = 26;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '1 days' + interval '10 hours 30 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '1 days' + interval '10 hours 30 minutes 00 seconds' WHERE id = 27;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '1 days' + interval '11 hours 50 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '1 days' + interval '11 hours 50 minutes 00 seconds' WHERE id = 28;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '1 days' + interval '14 hours 10 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '1 days' + interval '14 hours 10 minutes 00 seconds' WHERE id = 29;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '1 days' + interval '16 hours 45 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '1 days' + interval '16 hours 45 minutes 00 seconds' WHERE id = 30;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '0 days' + interval '09 hours 05 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '0 days' + interval '09 hours 05 minutes 00 seconds' WHERE id = 31;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '0 days' + interval '10 hours 35 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '0 days' + interval '10 hours 35 minutes 00 seconds' WHERE id = 32;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '0 days' + interval '14 hours 20 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '0 days' + interval '14 hours 20 minutes 00 seconds' WHERE id = 33;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '0 days' + interval '16 hours 00 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '0 days' + interval '16 hours 00 minutes 00 seconds' WHERE id = 34;
|
|
UPDATE issues SET created_at = date_trunc('day', now()) - interval '0 days' + interval '17 hours 30 minutes 00 seconds', updated_at = date_trunc('day', now()) - interval '0 days' + interval '17 hours 30 minutes 00 seconds' WHERE id = 35;
|
|
UPDATE issue_logs l SET created_at = i.created_at + (rn.rn * interval '30 minutes') FROM issues i, (SELECT id, row_number() OVER (PARTITION BY issue_id ORDER BY id) rn FROM issue_logs) rn WHERE l.id = rn.id AND l.issue_id = i.id;
|