Page MenuHomeSoftware Heritage
Paste P664

T2310: 147-bis.sql ; 147-ter.sql
ActivePublic
Actions

Authored by ardumont on May 6 2020, 4:19 PM.
-- Crawling history of software origin visits by Software Heritage. Each
-- visit see its history change through new origin visit status updates
create table origin_visit_status
(
origin bigint not null,
visit bigint not null,
date timestamptz not null,
status origin_visit_state not null,
metadata jsonb,
snapshot sha1_git
);
comment on column origin_visit_status.origin is 'Origin concerned by the visit update';
comment on column origin_visit_status.visit is 'Visit concerned by the visit update';
comment on column origin_visit_status.date is 'Visit update timestamp';
comment on column origin_visit_status.status is 'Visit status (ongoing, failed, full)';
comment on column origin_visit_status.metadata is 'Optional origin visit metadata';
comment on column origin_visit_status.snapshot is 'Optional, possibly partial, snapshot of the origin visit.';
alter table origin_visit_status owner to swhstorage;
grant select
on all tables in schema public
to guest;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 0 <= origin and origin < 1000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 1000000 <= origin and origin < 2000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 2000000 <= origin and origin < 3000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 3000000 <= origin and origin < 4000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 4000000 <= origin and origin < 5000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 5000000 <= origin and origin < 6000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 6000000 <= origin and origin < 7000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 7000000 <= origin and origin < 8000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 8000000 <= origin and origin < 9000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 9000000 <= origin and origin < 10000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 10000000 <= origin and origin < 11000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 11000000 <= origin and origin < 12000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 12000000 <= origin and origin < 13000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 13000000 <= origin and origin < 14000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 14000000 <= origin and origin < 15000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 15000000 <= origin and origin < 16000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 16000000 <= origin and origin < 17000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 17000000 <= origin and origin < 18000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 18000000 <= origin and origin < 19000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 19000000 <= origin and origin < 20000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 20000000 <= origin and origin < 21000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 21000000 <= origin and origin < 22000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 22000000 <= origin and origin < 23000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 23000000 <= origin and origin < 24000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 24000000 <= origin and origin < 25000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 25000000 <= origin and origin < 26000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 26000000 <= origin and origin < 27000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 27000000 <= origin and origin < 28000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 28000000 <= origin and origin < 29000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 29000000 <= origin and origin < 30000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 30000000 <= origin and origin < 31000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 31000000 <= origin and origin < 32000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 32000000 <= origin and origin < 33000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 33000000 <= origin and origin < 34000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 34000000 <= origin and origin < 35000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 35000000 <= origin and origin < 36000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 36000000 <= origin and origin < 37000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 37000000 <= origin and origin < 38000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 38000000 <= origin and origin < 39000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 39000000 <= origin and origin < 40000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 40000000 <= origin and origin < 41000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 41000000 <= origin and origin < 42000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 42000000 <= origin and origin < 43000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 43000000 <= origin and origin < 44000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 44000000 <= origin and origin < 45000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 45000000 <= origin and origin < 46000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 46000000 <= origin and origin < 47000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 47000000 <= origin and origin < 48000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 48000000 <= origin and origin < 49000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 49000000 <= origin and origin < 50000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 50000000 <= origin and origin < 51000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 51000000 <= origin and origin < 52000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 52000000 <= origin and origin < 53000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 53000000 <= origin and origin < 54000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 54000000 <= origin and origin < 55000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 55000000 <= origin and origin < 56000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 56000000 <= origin and origin < 57000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 57000000 <= origin and origin < 58000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 58000000 <= origin and origin < 59000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 59000000 <= origin and origin < 60000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 60000000 <= origin and origin < 61000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 61000000 <= origin and origin < 62000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 62000000 <= origin and origin < 63000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 63000000 <= origin and origin < 64000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 64000000 <= origin and origin < 65000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 65000000 <= origin and origin < 66000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 66000000 <= origin and origin < 67000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 67000000 <= origin and origin < 68000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 68000000 <= origin and origin < 69000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 69000000 <= origin and origin < 70000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 70000000 <= origin and origin < 71000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 71000000 <= origin and origin < 72000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 72000000 <= origin and origin < 73000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 73000000 <= origin and origin < 74000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 74000000 <= origin and origin < 75000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 75000000 <= origin and origin < 76000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 76000000 <= origin and origin < 77000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 77000000 <= origin and origin < 78000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 78000000 <= origin and origin < 79000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 79000000 <= origin and origin < 80000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 80000000 <= origin and origin < 81000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 81000000 <= origin and origin < 82000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 82000000 <= origin and origin < 83000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 83000000 <= origin and origin < 84000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 84000000 <= origin and origin < 85000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 85000000 <= origin and origin < 86000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 86000000 <= origin and origin < 87000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 87000000 <= origin and origin < 88000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 88000000 <= origin and origin < 89000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 89000000 <= origin and origin < 90000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 90000000 <= origin and origin < 91000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 91000000 <= origin and origin < 92000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 92000000 <= origin and origin < 93000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 93000000 <= origin and origin < 94000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 94000000 <= origin and origin < 95000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 95000000 <= origin and origin < 96000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 96000000 <= origin and origin < 97000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 97000000 <= origin and origin < 98000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 98000000 <= origin and origin < 99000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 99000000 <= origin and origin < 100000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 100000000 <= origin and origin < 101000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 101000000 <= origin and origin < 102000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 102000000 <= origin and origin < 103000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 103000000 <= origin and origin < 104000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 104000000 <= origin and origin < 105000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 105000000 <= origin and origin < 106000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 106000000 <= origin and origin < 107000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 107000000 <= origin and origin < 108000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 108000000 <= origin and origin < 109000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 109000000 <= origin and origin < 110000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 110000000 <= origin and origin < 111000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 111000000 <= origin and origin < 112000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 112000000 <= origin and origin < 113000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 113000000 <= origin and origin < 114000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 114000000 <= origin and origin < 115000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 115000000 <= origin and origin < 116000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 116000000 <= origin and origin < 117000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 117000000 <= origin and origin < 118000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 118000000 <= origin and origin < 119000000;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 119000000 <= origin and origin < 120000000;
-- on belvedere
create unique index origin_visit_status_pkey on origin_visit_status(origin, visit, date);
alter table origin_visit_status add primary key using index origin_visit_status_pkey;
alter table origin_visit_status
add constraint origin_visit_status_origin_visit_fkey
foreign key (origin, visit)
references origin_visit(origin, visit) not valid;
alter table origin_visit_status validate constraint origin_visit_status_origin_visit_fkey;

Event Timeline

ardumont created this paste.May 6 2020, 4:19 PM

Related to T2310

ardumont mentioned this in T2310: Make origin visits immutable.May 6 2020, 8:40 PM
ardumont added a comment.May 25 2020, 3:42 PM
  • 147-ter.sql: Migrate the remaining data which were written during the initial migration

insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 0 <= origin and origin < 1000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 1000000 <= origin and origin < 2000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 2000000 <= origin and origin < 3000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 3000000 <= origin and origin < 4000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 4000000 <= origin and origin < 5000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 5000000 <= origin and origin < 6000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 6000000 <= origin and origin < 7000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 7000000 <= origin and origin < 8000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 8000000 <= origin and origin < 9000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 9000000 <= origin and origin < 10000000
on conflict(origin, visit, date) do nothing;

insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 10000000 <= origin and origin < 11000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 11000000 <= origin and origin < 12000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 12000000 <= origin and origin < 13000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 13000000 <= origin and origin < 14000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 14000000 <= origin and origin < 15000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 15000000 <= origin and origin < 16000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 16000000 <= origin and origin < 17000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 17000000 <= origin and origin < 18000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 18000000 <= origin and origin < 19000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 19000000 <= origin and origin < 20000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 20000000 <= origin and origin < 21000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 21000000 <= origin and origin < 22000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 22000000 <= origin and origin < 23000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 23000000 <= origin and origin < 24000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 24000000 <= origin and origin < 25000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 25000000 <= origin and origin < 26000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 26000000 <= origin and origin < 27000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 27000000 <= origin and origin < 28000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 28000000 <= origin and origin < 29000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 29000000 <= origin and origin < 30000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 30000000 <= origin and origin < 31000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 31000000 <= origin and origin < 32000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 32000000 <= origin and origin < 33000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 33000000 <= origin and origin < 34000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 34000000 <= origin and origin < 35000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 35000000 <= origin and origin < 36000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 36000000 <= origin and origin < 37000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 37000000 <= origin and origin < 38000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 38000000 <= origin and origin < 39000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 39000000 <= origin and origin < 40000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 40000000 <= origin and origin < 41000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 41000000 <= origin and origin < 42000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 42000000 <= origin and origin < 43000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 43000000 <= origin and origin < 44000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 44000000 <= origin and origin < 45000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 45000000 <= origin and origin < 46000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 46000000 <= origin and origin < 47000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 47000000 <= origin and origin < 48000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 48000000 <= origin and origin < 49000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 49000000 <= origin and origin < 50000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 50000000 <= origin and origin < 51000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 51000000 <= origin and origin < 52000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 52000000 <= origin and origin < 53000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 53000000 <= origin and origin < 54000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 54000000 <= origin and origin < 55000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 55000000 <= origin and origin < 56000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 56000000 <= origin and origin < 57000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 57000000 <= origin and origin < 58000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 58000000 <= origin and origin < 59000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 59000000 <= origin and origin < 60000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 60000000 <= origin and origin < 61000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 61000000 <= origin and origin < 62000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 62000000 <= origin and origin < 63000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 63000000 <= origin and origin < 64000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 64000000 <= origin and origin < 65000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 65000000 <= origin and origin < 66000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 66000000 <= origin and origin < 67000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 67000000 <= origin and origin < 68000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 68000000 <= origin and origin < 69000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 69000000 <= origin and origin < 70000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 70000000 <= origin and origin < 71000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 71000000 <= origin and origin < 72000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 72000000 <= origin and origin < 73000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 73000000 <= origin and origin < 74000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 74000000 <= origin and origin < 75000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 75000000 <= origin and origin < 76000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 76000000 <= origin and origin < 77000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 77000000 <= origin and origin < 78000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 78000000 <= origin and origin < 79000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 79000000 <= origin and origin < 80000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 80000000 <= origin and origin < 81000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 81000000 <= origin and origin < 82000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 82000000 <= origin and origin < 83000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 83000000 <= origin and origin < 84000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 84000000 <= origin and origin < 85000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 85000000 <= origin and origin < 86000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 86000000 <= origin and origin < 87000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 87000000 <= origin and origin < 88000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 88000000 <= origin and origin < 89000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 89000000 <= origin and origin < 90000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 90000000 <= origin and origin < 91000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 91000000 <= origin and origin < 92000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 92000000 <= origin and origin < 93000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 93000000 <= origin and origin < 94000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 94000000 <= origin and origin < 95000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 95000000 <= origin and origin < 96000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 96000000 <= origin and origin < 97000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 97000000 <= origin and origin < 98000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 98000000 <= origin and origin < 99000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 99000000 <= origin and origin < 100000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 100000000 <= origin and origin < 101000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 101000000 <= origin and origin < 102000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 102000000 <= origin and origin < 103000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 103000000 <= origin and origin < 104000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 104000000 <= origin and origin < 105000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 105000000 <= origin and origin < 106000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 106000000 <= origin and origin < 107000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 107000000 <= origin and origin < 108000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 108000000 <= origin and origin < 109000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 109000000 <= origin and origin < 110000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 110000000 <= origin and origin < 111000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 111000000 <= origin and origin < 112000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 112000000 <= origin and origin < 113000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 113000000 <= origin and origin < 114000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 114000000 <= origin and origin < 115000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 115000000 <= origin and origin < 116000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 116000000 <= origin and origin < 117000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 117000000 <= origin and origin < 118000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 118000000 <= origin and origin < 119000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 119000000 <= origin and origin < 120000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 120000000 <= origin and origin < 121000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 121000000 <= origin and origin < 122000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 122000000 <= origin and origin < 123000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 123000000 <= origin and origin < 124000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 124000000 <= origin and origin < 125000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 125000000 <= origin and origin < 126000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 126000000 <= origin and origin < 127000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 127000000 <= origin and origin < 128000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 128000000 <= origin and origin < 129000000
on conflict(origin, visit, date) do nothing;
insert into origin_visit_status(origin, visit, date, status, metadata, snapshot)
select origin, visit, date, status, metadata, snapshot
from origin_visit
where 129000000 <= origin and origin < 130000000
on conflict(origin, visit, date) do nothing;

ardumont changed the title of this paste from T2310: 147-bis.sql to T2310: 147-bis.sql ; 147-ter.sql.May 25 2020, 4:03 PM
About · Developer information · Legal