
alter table APPS add PREOPTIMIZED bit;

create table APPS_ASSETS (
    ID binary(255) not null,
    APPID varchar(255) not null,
    CONTENT varbinary(MAX) 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);
