rem Generated for Warehouse Builder by cwmgen

create table CMPFCOStorage
(
    WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null,
    SnapshotID NUMBER(9) default 0,
    CompUOID VARCHAR2(255),
    isSeed NUMBER(1) default 1,
    active NUMBER(1) default 0,
    DeletionParent NUMBER(9),
    LoadingParent NUMBER(9),
    b_1 CHAR(1),
    b_2 CHAR(1),
    b_3 CHAR(1),
    b_4 CHAR(1),
    b_5 CHAR(1),
    b_6 CHAR(1),
    b_7 CHAR(1),
    b_8 CHAR(1),
    b_9 CHAR(1),
    b_10 CHAR(1),
    b_11 CHAR(1),
    b_12 CHAR(1),
    b_13 CHAR(1),
    b_14 CHAR(1),
    b_15 CHAR(1),
    b_16 CHAR(1),
    b_17 CHAR(1),
    b_18 CHAR(1),
    i_1 NUMBER(9),
    i_2 NUMBER(9),
    i_3 NUMBER(9),
    i_4 NUMBER(9),
    i_5 NUMBER(9),
    i_6 NUMBER(9),
    i_7 NUMBER(9),
    i_8 NUMBER(9),
    i_9 NUMBER(9),
    i_10 NUMBER(9),
    i_11 NUMBER(9),
    d_1 DATE,
    d_2 DATE,
    t_1 TIMESTAMP,
    t_2 TIMESTAMP,
    t_3 TIMESTAMP,
    t_4 TIMESTAMP,
    t_5 TIMESTAMP,
    t_6 TIMESTAMP,
    t_7 TIMESTAMP,
    t_8 TIMESTAMP,
    t_9 TIMESTAMP,
    t_10 TIMESTAMP,
    t_11 TIMESTAMP,
    t_12 TIMESTAMP,
    t_13 TIMESTAMP,
    t_14 TIMESTAMP,
    t_15 TIMESTAMP,
    f_1 FLOAT,
    f_2 FLOAT,
    s1_1 VARCHAR2(40),
    s1_2 VARCHAR2(40),
    s1_3 VARCHAR2(40),
    s1_4 VARCHAR2(40),
    s1_5 VARCHAR2(40),
    s1_6 VARCHAR2(40),
    s1_7 VARCHAR2(40),
    s1_8 VARCHAR2(40),
    s1_9 VARCHAR2(40),
    s1_10 VARCHAR2(40),
    s1_11 VARCHAR2(40),
    s1_12 VARCHAR2(40),
    s1_13 VARCHAR2(40),
    s1_14 VARCHAR2(40),
    s1_15 VARCHAR2(40),
    s2_1 VARCHAR2(255),
    s2_2 VARCHAR2(255),
    s2_3 VARCHAR2(255),
    s2_4 VARCHAR2(255),
    s2_5 VARCHAR2(255),
    s2_6 VARCHAR2(255),
    s2_7 VARCHAR2(255),
    s2_8 VARCHAR2(255),
    s2_9 VARCHAR2(255),
    s2_10 VARCHAR2(255),
    s2_11 VARCHAR2(255),
    s2_12 VARCHAR2(255),
    s2_13 VARCHAR2(255),
    s2_14 VARCHAR2(255),
    s2_15 VARCHAR2(255),
    s2_16 VARCHAR2(255),
    s2_17 VARCHAR2(255),
    s4_1 VARCHAR2(1000),
    s4_2 VARCHAR2(1000),
    s3_1 VARCHAR2(4000),
    s3_2 VARCHAR2(4000),
    s3_3 VARCHAR2(4000),
    s3_4 VARCHAR2(4000),
    s3_5 VARCHAR2(4000),
    s3_6 VARCHAR2(4000),
    s3_7 VARCHAR2(4000),
    s3_8 VARCHAR2(4000),
    s3_9 VARCHAR2(4000),
    cl_1 CLOB,
    cl_2 CLOB,
    cl_3 CLOB,
    cl_4 CLOB,
    cl_5 CLOB,
    bl_1 BLOB,
    r_1 NUMBER(9),
    r_2 NUMBER(9),
    r_3 NUMBER(9),
    r_4 NUMBER(9),
    r_5 NUMBER(9),
    r_6 NUMBER(9),
    r_7 NUMBER(9),
    r_8 NUMBER(9),
    r_9 NUMBER(9),
    r_10 NUMBER(9),
    r_11 NUMBER(9),
    r_12 NUMBER(9),
    r_13 NUMBER(9),
    r_14 NUMBER(9),
    r_15 NUMBER(9),
    r_16 NUMBER(9),
    r_17 NUMBER(9),
    r_18 NUMBER(9),
    r_19 NUMBER(9)
)
 TABLESPACE %snapshot_store_ts;

alter table CMPFCOStorage
  modify r_6 default 0;

create unique index IDX_FCOELEMENTID_VER on CMPFCOStorage (
WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex;
alter table CMPFCOStorage nologging
 add constraint IDX_FCOELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID);
	create index IDX_FCOSNAPID_Ver on CMPFCOStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex;
	create index IDX_FCOCompUOID_Ver on CMPFCOStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex;
	create index IDX_FCOUOID_Ver on CMPFCOStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex;
	create index IDX_FCOActiveClassName_Ver on CMPFCOStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex;

	create index IDX_FCOLoadingParent_Ver on CMPFCOStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex;
	create index IDX_FCOOwningFolder_Ver on CMPFCOStorage (WorkspaceID, r_6) nologging compress tablespace %tndex;
	create index IDX_FCOFCOClass_Ver on CMPFCOStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex;
create table CMPMMMStorage
(
    WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null,
    SnapshotID NUMBER(9) default 0,
    CompUOID VARCHAR2(255),
    isSeed NUMBER(1) default 1,
    active NUMBER(1) default 0,
    DeletionParent NUMBER(9),
    LoadingParent NUMBER(9),
    b_1 CHAR(1),
    b_2 CHAR(1),
    b_3 CHAR(1),
    b_4 CHAR(1),
    b_5 CHAR(1),
    b_6 CHAR(1),
    b_7 CHAR(1),
    b_8 CHAR(1),
    b_9 CHAR(1),
    b_10 CHAR(1),
    b_11 CHAR(1),
    b_12 CHAR(1),
    b_13 CHAR(1),
    b_14 CHAR(1),
    b_15 CHAR(1),
    b_16 CHAR(1),
    b_17 CHAR(1),
    b_18 CHAR(1),
    b_19 CHAR(1),
    b_20 CHAR(1),
    i_1 NUMBER(9),
    i_2 NUMBER(9),
    i_3 NUMBER(9),
    i_4 NUMBER(9),
    i_5 NUMBER(9),
    d_1 DATE,
    d_2 DATE,
    t_1 TIMESTAMP,
    t_2 TIMESTAMP,
    s1_1 VARCHAR2(40),
    s1_2 VARCHAR2(40),
    s1_3 VARCHAR2(40),
    s2_1 VARCHAR2(255),
    s2_2 VARCHAR2(255),
    s2_3 VARCHAR2(255),
    s2_4 VARCHAR2(255),
    s2_5 VARCHAR2(255),
    s2_6 VARCHAR2(255),
    s2_7 VARCHAR2(255),
    s2_8 VARCHAR2(255),
    s2_9 VARCHAR2(255),
    s4_1 VARCHAR2(1000),
    s3_1 VARCHAR2(4000),
    s3_2 VARCHAR2(4000),
    s3_3 VARCHAR2(4000),
    s3_4 VARCHAR2(4000),
    r_1 NUMBER(9),
    r_2 NUMBER(9),
    r_3 NUMBER(9),
    r_4 NUMBER(9),
    r_5 NUMBER(9),
    r_6 NUMBER(9)
)
 TABLESPACE %snapshot_store_ts;

create table CMPSCOStorage
(
    WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null,
    SnapshotID NUMBER(9) default 0,
    CompUOID VARCHAR2(255),
    isSeed NUMBER(1) default 1,
    active NUMBER(1) default 0,
    DeletionParent NUMBER(9),
    LoadingParent NUMBER(9),
    b_1 CHAR(1),
    b_2 CHAR(1),
    b_3 CHAR(1),
    b_4 CHAR(1),
    b_5 CHAR(1),
    b_6 CHAR(1),
    b_7 CHAR(1),
    b_8 CHAR(1),
    b_9 CHAR(1),
    b_10 CHAR(1),
    b_11 CHAR(1),
    b_12 CHAR(1),
    b_13 CHAR(1),
    b_14 CHAR(1),
    b_15 CHAR(1),
    b_16 CHAR(1),
    b_17 CHAR(1),
    b_18 CHAR(1),
    b_19 CHAR(1),
    b_20 CHAR(1),
    b_21 CHAR(1),
    b_22 CHAR(1),
    i_1 NUMBER(9),
    i_2 NUMBER(9),
    i_3 NUMBER(9),
    i_4 NUMBER(9),
    i_5 NUMBER(9),
    i_6 NUMBER(9),
    i_7 NUMBER(9),
    i_8 NUMBER(9),
    i_9 NUMBER(9),
    i_10 NUMBER(9),
    i_11 NUMBER(9),
    i_12 NUMBER(9),
    i_13 NUMBER(9),
    i_14 NUMBER(9),
    i_15 NUMBER(9),
    i_16 NUMBER(9),
    i_17 NUMBER(9),
    i_18 NUMBER(9),
    i_19 NUMBER(9),
    i_20 NUMBER(9),
    d_1 DATE,
    d_2 DATE,
    d_3 DATE,
    t_1 TIMESTAMP,
    t_2 TIMESTAMP,
    t_3 TIMESTAMP,
    t_4 TIMESTAMP,
    t_5 TIMESTAMP,
    t_6 TIMESTAMP,
    t_7 TIMESTAMP,
    t_8 TIMESTAMP,
    t_9 TIMESTAMP,
    t_10 TIMESTAMP,
    t_11 TIMESTAMP,
    t_12 TIMESTAMP,
    t_13 TIMESTAMP,
    s1_1 VARCHAR2(40),
    s1_2 VARCHAR2(40),
    s1_3 VARCHAR2(40),
    s1_4 VARCHAR2(40),
    s1_5 VARCHAR2(40),
    s1_6 VARCHAR2(40),
    s1_7 VARCHAR2(40),
    s1_8 VARCHAR2(40),
    s1_9 VARCHAR2(40),
    s1_10 VARCHAR2(40),
    s1_11 VARCHAR2(40),
    s2_1 VARCHAR2(255),
    s2_2 VARCHAR2(255),
    s2_3 VARCHAR2(255),
    s2_4 VARCHAR2(255),
    s2_5 VARCHAR2(255),
    s2_6 VARCHAR2(255),
    s2_7 VARCHAR2(255),
    s2_8 VARCHAR2(255),
    s2_9 VARCHAR2(255),
    s2_10 VARCHAR2(255),
    s2_11 VARCHAR2(255),
    s2_12 VARCHAR2(255),
    s2_13 VARCHAR2(255),
    s2_14 VARCHAR2(255),
    s2_15 VARCHAR2(255),
    s4_1 VARCHAR2(1000),
    s4_2 VARCHAR2(1000),
    s3_1 VARCHAR2(4000),
    s3_2 VARCHAR2(4000),
    s3_3 VARCHAR2(4000),
    s3_4 VARCHAR2(4000),
    s3_5 VARCHAR2(4000),
    s3_6 VARCHAR2(4000),
    s3_7 VARCHAR2(4000),
    s3_8 VARCHAR2(4000),
    cl_1 CLOB,
    cl_2 CLOB,
    cl_3 CLOB,
    r_1 NUMBER(9),
    r_2 NUMBER(9),
    r_3 NUMBER(9),
    r_4 NUMBER(9),
    r_5 NUMBER(9),
    r_6 NUMBER(9),
    r_7 NUMBER(9),
    r_8 NUMBER(9),
    r_9 NUMBER(9),
    r_10 NUMBER(9),
    r_11 NUMBER(9),
    r_12 NUMBER(9),
    r_13 NUMBER(9),
    r_14 NUMBER(9),
    r_15 NUMBER(9),
    r_16 NUMBER(9),
    r_17 NUMBER(9),
    r_18 NUMBER(9)
)
 TABLESPACE %snapshot_store_ts;

create unique index IDX_SCOELEMENTID_VER on CMPSCOStorage (
WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex;
alter table CMPSCOStorage nologging
 add constraint IDX_SCOELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID);
	create index IDX_SCOSNAPID_Ver on CMPSCOStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex;
	create index IDX_SCOCompUOID_Ver on CMPSCOStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex;
	create index IDX_SCOUOID_Ver on CMPSCOStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex;
	create index IDX_SCOActiveClassName_Ver on CMPSCOStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex;

	create index IDX_SCOLoadingParent_Ver on CMPSCOStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex;
	create index IDX_SCOOwningFolder_Ver on CMPSCOStorage (WorkspaceID, r_6) nologging compress tablespace %tndex;
	create index IDX_SCOFCOClass_Ver on CMPSCOStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex;
create table CMPSCOCfgStorage
(
    WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null,
    SnapshotID NUMBER(9) default 0,
    CompUOID VARCHAR2(255),
    isSeed NUMBER(1) default 1,
    active NUMBER(1) default 0,
    DeletionParent NUMBER(9),
    LoadingParent NUMBER(9),
    b_1 CHAR(1),
    b_2 CHAR(1),
    b_3 CHAR(1),
    b_4 CHAR(1),
    b_5 CHAR(1),
    b_6 CHAR(1),
    b_7 CHAR(1),
    b_8 CHAR(1),
    b_9 CHAR(1),
    b_10 CHAR(1),
    b_11 CHAR(1),
    b_12 CHAR(1),
    b_13 CHAR(1),
    b_14 CHAR(1),
    b_15 CHAR(1),
    b_16 CHAR(1),
    b_17 CHAR(1),
    b_18 CHAR(1),
    b_19 CHAR(1),
    i_1 NUMBER(9),
    i_2 NUMBER(9),
    i_3 NUMBER(9),
    i_4 NUMBER(9),
    i_5 NUMBER(9),
    i_6 NUMBER(9),
    i_7 NUMBER(9),
    i_8 NUMBER(9),
    i_9 NUMBER(9),
    i_10 NUMBER(9),
    i_11 NUMBER(9),
    i_12 NUMBER(9),
    i_13 NUMBER(9),
    i_14 NUMBER(9),
    i_15 NUMBER(9),
    i_16 NUMBER(9),
    i_17 NUMBER(9),
    i_18 NUMBER(9),
    i_19 NUMBER(9),
    i_20 NUMBER(9),
    i_21 NUMBER(9),
    i_22 NUMBER(9),
    i_23 NUMBER(9),
    d_1 DATE,
    d_2 DATE,
    d_3 DATE,
    d_4 DATE,
    t_1 TIMESTAMP,
    t_2 TIMESTAMP,
    t_3 TIMESTAMP,
    t_4 TIMESTAMP,
    t_5 TIMESTAMP,
    t_6 TIMESTAMP,
    t_7 TIMESTAMP,
    t_8 TIMESTAMP,
    t_9 TIMESTAMP,
    t_10 TIMESTAMP,
    t_11 TIMESTAMP,
    t_12 TIMESTAMP,
    t_13 TIMESTAMP,
    t_14 TIMESTAMP,
    t_15 TIMESTAMP,
    t_16 TIMESTAMP,
    t_17 TIMESTAMP,
    t_18 TIMESTAMP,
    t_19 TIMESTAMP,
    t_20 TIMESTAMP,
    t_21 TIMESTAMP,
    t_22 TIMESTAMP,
    t_23 TIMESTAMP,
    f_1 FLOAT,
    f_2 FLOAT,
    s1_1 VARCHAR2(40),
    s1_2 VARCHAR2(40),
    s1_3 VARCHAR2(40),
    s1_4 VARCHAR2(40),
    s1_5 VARCHAR2(40),
    s1_6 VARCHAR2(40),
    s1_7 VARCHAR2(40),
    s1_8 VARCHAR2(40),
    s1_9 VARCHAR2(40),
    s1_10 VARCHAR2(40),
    s1_11 VARCHAR2(40),
    s1_12 VARCHAR2(40),
    s1_13 VARCHAR2(40),
    s1_14 VARCHAR2(40),
    s1_15 VARCHAR2(40),
    s1_16 VARCHAR2(40),
    s2_1 VARCHAR2(255),
    s2_2 VARCHAR2(255),
    s2_3 VARCHAR2(255),
    s2_4 VARCHAR2(255),
    s2_5 VARCHAR2(255),
    s2_6 VARCHAR2(255),
    s2_7 VARCHAR2(255),
    s2_8 VARCHAR2(255),
    s2_9 VARCHAR2(255),
    s4_1 VARCHAR2(1000),
    s4_2 VARCHAR2(1000),
    s3_1 VARCHAR2(4000),
    s3_2 VARCHAR2(4000),
    s3_3 VARCHAR2(4000),
    s3_4 VARCHAR2(4000),
    s3_5 VARCHAR2(4000),
    s3_6 VARCHAR2(4000),
    s3_7 VARCHAR2(4000),
    s3_8 VARCHAR2(4000),
    s3_9 VARCHAR2(4000),
    s3_10 VARCHAR2(4000),
    s3_11 VARCHAR2(4000),
    s3_12 VARCHAR2(4000),
    s3_13 VARCHAR2(4000),
    cl_1 CLOB,
    cl_2 CLOB,
    cl_3 CLOB,
    r_1 NUMBER(9),
    r_2 NUMBER(9),
    r_3 NUMBER(9),
    r_4 NUMBER(9),
    r_5 NUMBER(9),
    r_6 NUMBER(9),
    r_7 NUMBER(9),
    r_8 NUMBER(9),
    r_9 NUMBER(9),
    r_10 NUMBER(9),
    r_11 NUMBER(9),
    r_12 NUMBER(9),
    r_13 NUMBER(9),
    r_14 NUMBER(9),
    r_15 NUMBER(9),
    r_16 NUMBER(9),
    r_17 NUMBER(9),
    r_18 NUMBER(9),
    r_19 NUMBER(9),
    r_20 NUMBER(9),
    r_21 NUMBER(9),
    r_22 NUMBER(9),
    r_23 NUMBER(9)
)
 TABLESPACE %snapshot_store_ts;

create unique index IDX_SCOCfgELEMENTID_VER on CMPSCOCfgStorage (
WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex;
alter table CMPSCOCfgStorage nologging
 add constraint IDX_SCOCfgELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID);
	create index IDX_SCOCfgSNAPID_Ver on CMPSCOCfgStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex;
	create index IDX_SCOCfgCompUOID_Ver on CMPSCOCfgStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex;
	create index IDX_SCOCfgUOID_Ver on CMPSCOCfgStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex;
	create index IDX_SCOCfgActiveClassName_Ver on CMPSCOCfgStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex;

	create index IDX_SCOCfgLoadingParent_Ver on CMPSCOCfgStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex;
	create index IDX_SCOCfgOwningFolder_Ver on CMPSCOCfgStorage (WorkspaceID, r_6) nologging compress tablespace %tndex;
	create index IDX_SCOCfgFCOClass_Ver on CMPSCOCfgStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex;
create table CMPSCOMapStorage
(
    WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null,
    SnapshotID NUMBER(9) default 0,
    CompUOID VARCHAR2(255),
    isSeed NUMBER(1) default 1,
    active NUMBER(1) default 0,
    DeletionParent NUMBER(9),
    LoadingParent NUMBER(9),
    b_1 CHAR(1),
    b_2 CHAR(1),
    b_3 CHAR(1),
    b_4 CHAR(1),
    b_5 CHAR(1),
    b_6 CHAR(1),
    b_7 CHAR(1),
    b_8 CHAR(1),
    b_9 CHAR(1),
    b_10 CHAR(1),
    b_11 CHAR(1),
    i_1 NUMBER(9),
    i_2 NUMBER(9),
    i_3 NUMBER(9),
    i_4 NUMBER(9),
    i_5 NUMBER(9),
    i_6 NUMBER(9),
    i_7 NUMBER(9),
    i_8 NUMBER(9),
    i_9 NUMBER(9),
    i_10 NUMBER(9),
    i_11 NUMBER(9),
    i_12 NUMBER(9),
    i_13 NUMBER(9),
    d_1 DATE,
    d_2 DATE,
    t_1 TIMESTAMP,
    t_2 TIMESTAMP,
    t_3 TIMESTAMP,
    t_4 TIMESTAMP,
    t_5 TIMESTAMP,
    t_6 TIMESTAMP,
    t_7 TIMESTAMP,
    t_8 TIMESTAMP,
    t_9 TIMESTAMP,
    t_10 TIMESTAMP,
    t_11 TIMESTAMP,
    t_12 TIMESTAMP,
    t_13 TIMESTAMP,
    s1_1 VARCHAR2(40),
    s1_2 VARCHAR2(40),
    s1_3 VARCHAR2(40),
    s1_4 VARCHAR2(40),
    s1_5 VARCHAR2(40),
    s1_6 VARCHAR2(40),
    s1_7 VARCHAR2(40),
    s1_8 VARCHAR2(40),
    s1_9 VARCHAR2(40),
    s1_10 VARCHAR2(40),
    s2_1 VARCHAR2(255),
    s2_2 VARCHAR2(255),
    s2_3 VARCHAR2(255),
    s4_1 VARCHAR2(1000),
    s4_2 VARCHAR2(1000),
    s3_1 VARCHAR2(4000),
    s3_2 VARCHAR2(4000),
    s3_3 VARCHAR2(4000),
    s3_4 VARCHAR2(4000),
    s3_5 VARCHAR2(4000),
    s3_6 VARCHAR2(4000),
    s3_7 VARCHAR2(4000),
    s3_8 VARCHAR2(4000),
    s3_9 VARCHAR2(4000),
    s3_10 VARCHAR2(4000),
    s3_11 VARCHAR2(4000),
    s3_12 VARCHAR2(4000),
    cl_1 CLOB,
    cl_2 CLOB,
    r_1 NUMBER(9),
    r_2 NUMBER(9),
    r_3 NUMBER(9),
    r_4 NUMBER(9),
    r_5 NUMBER(9),
    r_6 NUMBER(9),
    r_7 NUMBER(9),
    r_8 NUMBER(9),
    r_9 NUMBER(9),
    r_10 NUMBER(9),
    r_11 NUMBER(9),
    r_12 NUMBER(9),
    r_13 NUMBER(9),
    r_14 NUMBER(9),
    r_15 NUMBER(9),
    r_16 NUMBER(9),
    r_17 NUMBER(9),
    r_18 NUMBER(9),
    r_19 NUMBER(9)
)
 TABLESPACE %snapshot_store_ts;

create unique index IDX_SCOMapELEMENTID_VER on CMPSCOMapStorage (
WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex;
alter table CMPSCOMapStorage nologging
 add constraint IDX_SCOMapELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID);
	create index IDX_SCOMapSNAPID_Ver on CMPSCOMapStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex;
	create index IDX_SCOMapCompUOID_Ver on CMPSCOMapStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex;
	create index IDX_SCOMapUOID_Ver on CMPSCOMapStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex;
	create index IDX_SCOMapActiveClassName_Ver on CMPSCOMapStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex;

	create index IDX_SCOMapLoadingParent_Ver on CMPSCOMapStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex;
	create index IDX_SCOMapOwningFolder_Ver on CMPSCOMapStorage (WorkspaceID, r_6) nologging compress tablespace %tndex;
	create index IDX_SCOMapFCOClass_Ver on CMPSCOMapStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex;
create table CMPSCOPrpStorage
(
    WorkspaceID NUMBER(9) default sys_context('owb_workspace','workspaceID') not null,
    SnapshotID NUMBER(9) default 0,
    CompUOID VARCHAR2(255),
    isSeed NUMBER(1) default 1,
    active NUMBER(1) default 0,
    DeletionParent NUMBER(9),
    LoadingParent NUMBER(9),
    b_1 CHAR(1),
    b_2 CHAR(1),
    b_3 CHAR(1),
    b_4 CHAR(1),
    b_5 CHAR(1),
    b_6 CHAR(1),
    b_7 CHAR(1),
    b_8 CHAR(1),
    b_9 CHAR(1),
    b_10 CHAR(1),
    b_11 CHAR(1),
    i_1 NUMBER(9),
    i_2 NUMBER(9),
    i_3 NUMBER(9),
    i_4 NUMBER(9),
    i_5 NUMBER(9),
    i_6 NUMBER(9),
    i_7 NUMBER(9),
    d_1 DATE,
    d_2 DATE,
    t_1 TIMESTAMP,
    t_2 TIMESTAMP,
    t_3 TIMESTAMP,
    t_4 TIMESTAMP,
    t_5 TIMESTAMP,
    t_6 TIMESTAMP,
    t_7 TIMESTAMP,
    t_8 TIMESTAMP,
    t_9 TIMESTAMP,
    t_10 TIMESTAMP,
    t_11 TIMESTAMP,
    s1_1 VARCHAR2(40),
    s1_2 VARCHAR2(40),
    s1_3 VARCHAR2(40),
    s1_4 VARCHAR2(40),
    s1_5 VARCHAR2(40),
    s1_6 VARCHAR2(40),
    s1_7 VARCHAR2(40),
    s1_8 VARCHAR2(40),
    s1_9 VARCHAR2(40),
    s2_1 VARCHAR2(255),
    s2_2 VARCHAR2(255),
    s2_3 VARCHAR2(255),
    s4_1 VARCHAR2(1000),
    s4_2 VARCHAR2(1000),
    s3_1 VARCHAR2(4000),
    s3_2 VARCHAR2(4000),
    s3_3 VARCHAR2(4000),
    s3_4 VARCHAR2(4000),
    s3_5 VARCHAR2(4000),
    s3_6 VARCHAR2(4000),
    s3_7 VARCHAR2(4000),
    cl_1 CLOB,
    cl_2 CLOB,
    cl_3 CLOB,
    r_1 NUMBER(9),
    r_2 NUMBER(9),
    r_3 NUMBER(9),
    r_4 NUMBER(9),
    r_5 NUMBER(9),
    r_6 NUMBER(9),
    r_7 NUMBER(9),
    r_8 NUMBER(9),
    r_9 NUMBER(9),
    r_10 NUMBER(9),
    r_11 NUMBER(9),
    r_12 NUMBER(9),
    r_13 NUMBER(9),
    r_14 NUMBER(9),
    r_15 NUMBER(9),
    r_16 NUMBER(9)
)
 TABLESPACE %snapshot_store_ts;

create unique index IDX_SCOPrpELEMENTID_VER on CMPSCOPrpStorage (
WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex;
alter table CMPSCOPrpStorage nologging
 add constraint IDX_SCOPrpELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID);
	create index IDX_SCOPrpSNAPID_Ver on CMPSCOPrpStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex;
	create index IDX_SCOPrpCompUOID_Ver on CMPSCOPrpStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex;
	create index IDX_SCOPrpUOID_Ver on CMPSCOPrpStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex;
	create index IDX_SCOPrpActiveClassName_Ver on CMPSCOPrpStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex;

	create index IDX_SCOPrpLoadingParent_Ver on CMPSCOPrpStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex;
	create index IDX_SCOPrpOwningFolder_Ver on CMPSCOPrpStorage (WorkspaceID, r_6) nologging compress tablespace %tndex;
	create index IDX_SCOPrpFCOClass_Ver on CMPSCOPrpStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex;
create table CMPSYSStorage
(
    WorkspaceID NUMBER(9) default 1 not null,
    SnapshotID NUMBER(9) default 0,
    CompUOID VARCHAR2(255),
    isSeed NUMBER(1) default 1,
    active NUMBER(1) default 0,
    DeletionParent NUMBER(9),
    LoadingParent NUMBER(9),
    b_1 CHAR(1),
    b_2 CHAR(1),
    b_3 CHAR(1),
    b_4 CHAR(1),
    b_5 CHAR(1),
    b_6 CHAR(1),
    b_7 CHAR(1),
    b_8 CHAR(1),
    b_9 CHAR(1),
    b_10 CHAR(1),
    b_11 CHAR(1),
    b_12 CHAR(1),
    i_1 NUMBER(9),
    i_2 NUMBER(9),
    i_3 NUMBER(9),
    i_4 NUMBER(9),
    i_5 NUMBER(9),
    i_6 NUMBER(9),
    i_7 NUMBER(9),
    d_1 DATE,
    d_2 DATE,
    d_3 DATE,
    t_1 TIMESTAMP,
    t_2 TIMESTAMP,
    t_3 TIMESTAMP,
    t_4 TIMESTAMP,
    t_5 TIMESTAMP,
    t_6 TIMESTAMP,
    t_7 TIMESTAMP,
    t_8 TIMESTAMP,
    t_9 TIMESTAMP,
    s1_1 VARCHAR2(40),
    s1_2 VARCHAR2(40),
    s1_3 VARCHAR2(40),
    s1_4 VARCHAR2(40),
    s1_5 VARCHAR2(40),
    s1_6 VARCHAR2(40),
    s1_7 VARCHAR2(40),
    s1_8 VARCHAR2(40),
    s1_9 VARCHAR2(40),
    s1_10 VARCHAR2(40),
    s1_11 VARCHAR2(40),
    s2_1 VARCHAR2(255),
    s2_2 VARCHAR2(255),
    s2_3 VARCHAR2(255),
    s4_1 VARCHAR2(1000),
    s4_2 VARCHAR2(1000),
    s3_1 VARCHAR2(4000),
    s3_2 VARCHAR2(4000),
    s3_3 VARCHAR2(4000),
    s3_4 VARCHAR2(4000),
    s3_5 VARCHAR2(4000),
    s3_6 VARCHAR2(4000),
    cl_1 CLOB,
    cl_2 CLOB,
    bl_1 BLOB,
    r_1 NUMBER(9),
    r_2 NUMBER(9),
    r_3 NUMBER(9),
    r_4 NUMBER(9),
    r_5 NUMBER(9),
    r_6 NUMBER(9),
    r_7 NUMBER(9),
    r_8 NUMBER(9),
    r_9 NUMBER(9),
    r_10 NUMBER(9),
    r_11 NUMBER(9),
    r_12 NUMBER(9),
    r_13 NUMBER(9),
    r_14 NUMBER(9),
    r_15 NUMBER(9)
)
 TABLESPACE %snapshot_store_ts;

create unique index IDX_SYSELEMENTID_VER on CMPSYSStorage (
WorkspaceID, i_1, SnapshotID) nologging compress tablespace %tndex;
alter table CMPSYSStorage nologging
 add constraint IDX_SYSELEMENTID_VER primary key (WorkspaceID, i_1, SnapshotID);
	create index IDX_SYSSNAPID_Ver on CMPSYSStorage (WorkspaceID, SnapshotID) nologging compress tablespace %tndex;
	create index IDX_SYSCompUOID_Ver on CMPSYSStorage (WorkspaceID, CompUOID) nologging compress tablespace %tndex;
	create index IDX_SYSUOID_Ver on CMPSYSStorage (WorkspaceID, s1_2) nologging compress tablespace %tndex;
	create index IDX_SYSActiveClassName_Ver on CMPSYSStorage (WorkspaceID, active, s2_1) nologging compress tablespace %tndex;

	create index IDX_SYSLoadingParent_Ver on CMPSYSStorage (WorkspaceID, LoadingParent) nologging compress tablespace %tndex;
	create index IDX_SYSOwningFolder_Ver on CMPSYSStorage (WorkspaceID, r_6) nologging compress tablespace %tndex;
	create index IDX_SYSFCOClass_Ver on CMPSYSStorage (WorkspaceID, r_7, s2_1) nologging compress tablespace %tndex;