-- This file is just to structure the data.

drop table if exists skip_scan_t;
drop table if exists skip_scan;

create table skip_scan_t(
id int auto_increment primary key,
dt varchar(8) not null,
prj_id varchar(120) not null,
index index_1(dt,prj_id));

insert into skip_scan_t (dt,prj_id) values('20220101','TEST001'),('20220101','TEST002'),('20220101','TEST003'),('20220101','TEST004'),('20220101','TEST005'),('20220101','TEST005'),('20220101','TEST006'),('20220101','TEST007'),('20220101','TEST008'),('20220101','TEST009'),('20220101','TEST010');

insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST009';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST009';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST009';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST009';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST009';

insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t where prj_id = 'TEST010';

insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t;
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t;
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t;
insert into skip_scan_t (dt,prj_id) select dt,prj_id from skip_scan_t;

create table skip_scan like skip_scan_t;

insert into skip_scan (dt,prj_id) select '20220101',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220102',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220103',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220104',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220105',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220106',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220107',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220108',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220109',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220110',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220111',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220112',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220113',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220114',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220115',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220116',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220117',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220118',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220119',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220120',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220121',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220122',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220123',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220124',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220125',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220126',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220127',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220128',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220129',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220130',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220131',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220201',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220202',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220203',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220204',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220205',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220206',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220207',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220208',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220209',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220210',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220211',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220212',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220213',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220214',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220215',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220216',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220217',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220218',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220219',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220220',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220221',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220222',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220223',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220224',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220225',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220226',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220227',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220228',prj_id from skip_scan_t;
insert into skip_scan (dt,prj_id) select '20220229',prj_id from skip_scan_t;

analyze table skip_scan;