
alter table apps add column PREOPTIMIZED boolean;

create table APPS_ASSETS (
    ID uuid not null,
    APPID varchar(255) not null,
    CONTENT oid not null,
    ENCODING varchar(255) not null,
    FRIENDLY_NAME varchar(255) not null,
    TAG varchar(255) not null,
    primary key (ID)
);

create index app_assets_appid_idx on APPS_ASSETS (APPID);
