paste.as

CREATE TABLE photos (
    id           char(10) collate latin1_general_cs not null
        primary key,
    owner_id     int                                   not null,
    app_use_key  varchar(32)                           null,
    app_use_id   int                                   null,
    created      datetime                              not null,
    filename     varchar(200)                          not null,
    filekey      varchar(255)                          not null,
    size         int default 0                         not null,
    body         text                                  null,
    alt_text     text                                  null,
    constraint snap_photos_app_use_key_app_use_id_uindex
        unique (app_use_key, app_use_id)
) collate = utf8mb4_bin;