create table app_package
(
    id           int auto_increment
        primary key,
    name         varchar(255)  not null,
    package_name varchar(255)  not null,
    create_time  datetime      not null,
    update_time  datetime      not null,
    status       int default 0 not null,
    constraint project_code_unique
        unique (package_name)
);

create table channel
(
    id           int auto_increment
        primary key,
    name         varchar(255)  not null,
    channel_name varchar(255)  not null,
    create_time  datetime      not null,
    update_time  datetime      not null,
    status       int default 0 not null,
    constraint project_code_unique
        unique (channel_name)
);

