drop table if exists test1;

create table test1 (
    id              char(8),
    num             int,
    primary key (id)
);