alter table captureorg.library_items
    add metric_label varchar(250) default NULL null;

alter table captureorg.library_items
    add score_preference varchar(250) default 'high' not null;

    create table captureorg.translations_library_item_settings
(
    translation_id  int auto_increment,
    language_id     int          null,
    library_item_id int          null,
    setting_key     varchar(250) null,
    translation     text         null,
    constraint translations_library_item_settings_pk
        primary key (translation_id),
    constraint translations_library_item_settings_languages_language_id_fk
        foreign key (language_id) references configure.languages (language_id),
    constraint translations_lbry_item_settings_lbry_items_lbry_item_id_fk
        foreign key (library_item_id) references captureorg.library_items (library_item_id)
            on delete cascade
);

