create table ftp_upload_queue
(
    id          int auto_increment
        primary key,
    sale_no       varchar(30) default '' not null comment '訂單編號',
    inv_num       varchar(10) default '' not null comment '發票號碼',
    type       varchar(5) default '' not null comment '發票XML上傳類別',
    uploaded       varchar(1) default '0' not null comment '已經上傳',
    created timestamp default '0000-00-00 00:00:00',
    updated timestamp default now() on update now()
) charset = utf8;
