create table invoice_errors
(
    id          int auto_increment
        primary key,
    sale_no       varchar(30) default '' not null comment '訂單編號',
    inv_num       varchar(10) default '' not null comment '發票號碼',
    error         varchar(50) default '' not null comment '錯誤訊息',
    created timestamp default '1980-01-01 00:00:01',
    updated timestamp default now() on update now()
) charset = utf8;
