drop table collect_logs;
create table collect_logs
(
    id bigint AUTO_INCREMENT primary key,
    business_id varchar(300),
    business_table_name varchar(100),
    db_partition varchar(5),
    last_sync_version varchar(50),
    created_time TIMESTAMP not null default CURRENT_TIMESTAMP
);


create table collect_log_errors
(
    id bigint AUTO_INCREMENT primary key,
    business_id text,
    business_table_name varchar(500),
    message varchar(50),
    exception text,
    created_time TIMESTAMP not null default CURRENT_TIMESTAMP
);

alter table collect_logs add step varchar(50);
alter table collect_log_errors add count_of_error int not null default 0;
alter table collect_log_errors add status tinyint(2) not null default 0;

alter table collect_log_errors modify message text;