
alter table APPS add PREOPTIMIZED number(1,0);

create table APPS_ASSETS (
    ID raw(255) not null,
    APPID varchar2(255 char) not null,
    CONTENT blob not null,
    ENCODING varchar2(255 char) not null,
    FRIENDLY_NAME varchar2(255 char) not null,
    TAG varchar2(255 char) not null,
    primary key (ID)
);

create index app_assets_appid_idx on APPS_ASSETS (APPID);
