create table DEF_ACTIVITY (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, NAME_ varchar2(255 char), UUID_ varchar2(500 char), CHILD_NODE_ number(19,0), FAULT_QNAME_ varchar2(255 char), catchVariableDefinition number(19,0), IS_DEFAULT_CH_ number(1,0), DEL_JOIN_FAIL_ number(1,0), EXEC_SRC_ASYNC number(1,0), SCOPE_ number(19,0), TARG_JOIN_COND_ number(19,0), EXT_ACTIVITY_NAME varchar2(255 char), EXT_ACTIVITY_ID number(19,0), PARTNER_LINK_ varchar2(255 char), OPERATION_NAME_ varchar2(255 char), IN_VAR_NAME_ varchar2(255 char), OUT_VAR_NAME_ varchar2(255 char), ONE_WAY_ number(1,0), PT_QNAME_ varchar2(255 char), ANON_OUT_MESS_ number(19,0), ANON_IN_MESS_ number(19,0), MSG_TYPE_QNAME_ varchar2(255 char), MSG_EXCHANGE_ varchar2(255 char), CREATE_INST_ number(1,0), OP_KEY_ varchar2(3999 char), INPUT_TYPE_ varchar2(255 char), VALIDATE_ number(1,0), ISOLATED_ number(1,0), EXIT_ON_FAULT_ number(1,0), NODE_ number(19,0), COND_ number(19,0), ACTIVITY_ number(19,0), ELSE_ACTIVITY_ number(19,0), COUNTER_NAME_ varchar2(255 char), PARALLEL_ number(1,0), SUC_BRANCHES_ number(1,0), START_COUNT_ number(19,0), FINAL_COUNT_ number(19,0), COMPL_COND_ number(19,0), DURATION_ number(19,0), DEADLINE_ number(19,0), FAULT_VAR_ varchar2(255 char), TARGET_ varchar2(255 char), INBOUND_PROCESS_ number(19,0), EXT_PROCESS_ number(19,0), primary key (DBID_));
create table DEF_COPY_ELT (DBID_ number(19,0) not null, KEEP_SRC_ELT_ number(1,0), IGNORE_MISS_DATA_ number(1,0), FROM_ number(19,0), TO_ number(19,0), INVOKE_IN_ID_ number(19,0), INDEX_ number(10,0), INVOKE_OUT_ID_ number(19,0), REPLY_ID_ number(19,0), RECEIVE_IN_ID_ number(19,0), ASSIGN_ID_ number(19,0), ASSIGN_INDEX_ number(10,0), ON_MSG_IN_ID_ number(19,0), ON_EVT_IN_ID_ number(19,0), primary key (DBID_));
create table DEF_CORREL (DBID_ number(19,0) not null, INITIATE_ varchar2(255 char), CS_ number(19,0), INVOKE_REQ_ID_ number(19,0), INVOKE_RES_ID_ number(19,0), REPLY_ID_ number(19,0), RECEIVE_ID_ number(19,0), ON_MSG_ID_ number(19,0), ON_EVT_ID_ number(19,0), primary key (DBID_));
create table DEF_CS (DBID_ number(19,0) not null, NAME_ varchar2(255 char), SCOPE_ID_ number(19,0), CS_NAME_ varchar2(255 char), primary key (DBID_));
create table DEF_CS_PROPERTIES_ (CS_ID_ number(19,0) not null, elt number(19,0) not null, NAME_QNAME_ varchar2(255 char) not null, primary key (CS_ID_, NAME_QNAME_));
create table DEF_ELSE_IF (IF_ID_ number(19,0) not null, CONDITION_ number(19,0), ACTIVITY_ number(19,0), INDEX_ number(10,0) not null, primary key (IF_ID_, INDEX_));
create table DEF_EXCEPTHNDLR (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, DBVERSION_ number(10,0) not null, EXCEPT_CLASS_ varchar2(255 char), TRANSACT_ number(1,0), RETHROW_MASKED_ number(1,0), NODENAME_ varchar2(255 char), primary key (DBID_));
create table DEF_FROM_PART (DBID_ number(19,0) not null, PART_ varchar2(255 char), TO_VAR_ varchar2(255 char), primary key (DBID_));
create table DEF_FROM_TO_ELT (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, VARIANT_ varchar2(255 char), VARIABLE_ varchar2(255 char), PART_ varchar2(255 char), PARTNER_LINK_ varchar2(255 char), PROP_QNAME_ varchar2(255 char), VAR_QUERY_ number(19,0), EXPRESSION_ number(19,0), LITERAL_VAL_ clob, ENDPOINT_REF_ varchar2(255 char), primary key (DBID_));
create table DEF_LINK (DBID_ number(19,0) not null, NAME_ varchar2(255 char), SOURCE_ACTIVITY_ number(19,0), TARGET_ACTIVITY_ number(19,0), FLOW_ID_ number(19,0), primary key (DBID_));
create table DEF_LINK_SOURCE (DBID_ number(19,0) not null, LINK_NAME_ varchar2(255 char), LINK_ number(19,0), TRANS_COND_ number(19,0), ACTIVITY_ID_ number(19,0), primary key (DBID_));
create table DEF_LINK_TARGET (DBID_ number(19,0) not null, LINK_NAME_ varchar2(255 char), LINK_ number(19,0), ACTIVITY_ID_ number(19,0), primary key (DBID_));
create table DEF_NAMESPACE (DBID_ number(19,0) not null, URI_ varchar2(255 char), PREFIX_ varchar2(255 char), SNIPPET_ID_ number(19,0), primary key (DBID_));
create table DEF_NODE (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, PROCESS_ number(19,0), EXCEPTHNDLR_ number(19,0), NAME_ varchar2(255 char) not null unique, DESCR_ varchar2(255 char), PARENT_ number(19,0), BEHAV_OBJ_ number(19,0), PARENT_IDX_ number(10,0), primary key (DBID_));
create table DEF_ON_ALARM (DBID_ number(19,0) not null, UUID_ varchar2(255 char), DURATION_ number(19,0), DEADLINE_ number(19,0), REPEAT_ number(19,0), ACTIVITY_ number(19,0), ACTIVITY_ID_ number(19,0), PICK_ID_ number(19,0), primary key (DBID_));
create table DEF_ON_EVT (DBID_ number(19,0) not null, PARTNER_LINK_ varchar2(255 char), IN_VAR_NAME_ varchar2(255 char), MSG_EXCHANGE_ varchar2(255 char), ANON_IN_MESS_ number(19,0), OP_KEY_ varchar2(3999 char), ACTIVITY_ number(19,0), INBOUND_ELT_ number(19,0), INPUT_TYPE_ varchar2(255 char), ACTIVITY_ID_ number(19,0), primary key (DBID_));
create table DEF_ON_MSG (DBID_ number(19,0) not null, PARTNER_LINK_ varchar2(255 char), IN_VAR_NAME_ varchar2(255 char), MSG_EXCHANGE_ varchar2(255 char), ANON_IN_MESS_ number(19,0), OP_KEY_ varchar2(3999 char), ACTIVITY_ number(19,0), INBOUND_ELT_ number(19,0), INPUT_TYPE_ varchar2(255 char), PICK_ID_ number(19,0), primary key (DBID_));
create table DEF_PLNK (DBID_ number(19,0) not null, NAME_ varchar2(255 char), MYROLEPT_QNAME_ varchar2(255 char), PARTROLEPT_QNAME_ varchar2(255 char), P_END_REF clob, MY_END_REF clob, SCOPE_ID_ number(19,0), PLNK_NAME_ varchar2(255 char), primary key (DBID_));
create table DEF_PLNKTYPE (DBID_ number(19,0) not null, NAME_QNAME_ varchar2(255 char), WSDLINFOS_ID_ number(19,0), PLNK_QNAME_ varchar2(255 char), primary key (DBID_));
create table DEF_PLNKT_ROLES (PLNKTYPE_ID_ number(19,0) not null, PT_QNAME_ varchar2(255 char), ROLE_NAME_ varchar2(255 char) not null, primary key (PLNKTYPE_ID_, ROLE_NAME_));
create table DEF_PROCESS (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, EXCEPTHNDLR_ number(19,0), NAME_ varchar2(255 char), VERSION_ number(10,0), DEPLOYED_ timestamp, INITIAL_ number(19,0), PROCESS_UUID_ varchar2(255 char), QUERY_LANG_ varchar2(255 char), EXPR_LANG_ varchar2(255 char), DEL_JOIN_FAIL_ number(1,0), EXIT_ON_FAULT_ number(1,0), TARGET_NS_ varchar2(255 char), START_ELTS_ number(10,0), WSDL_INFOS_ number(19,0), instanceCreationLock number(19,0), primary key (DBID_));
create table DEF_PROC_COMMON_CS (PROCESS_ID_ number(19,0) not null, CS_ID_ number(19,0) not null);
create table DEF_PROC_RESOURCES (PROCESS_ID_ number(19,0) not null, CONTENT_ blob, NAME_ varchar2(255 char) not null, primary key (PROCESS_ID_, NAME_));
create table DEF_PROPALIAS (DBID_ number(19,0) not null, PROP_PART_ varchar2(255 char), PROP_QNAME_ varchar2(255 char), MSGTYPE_QNAME_ varchar2(255 char), TYPE_QNAME_ varchar2(255 char), ELT_QNAME_ varchar2(255 char), QUERY_ number(19,0), WSDLINFOS_ID_ number(19,0), primary key (DBID_));
create table DEF_SCOPE_MESSEXS (SCOPE_ID_ number(19,0) not null, MESSEX_NAME_ varchar2(255 char));
create table DEF_SCOPE_VARINIT (SCOPE_ID_ number(19,0) not null, VAR_NAME_ varchar2(255 char));
create table DEF_SNIPPET (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, TXT_ varchar2(3999 char), LANG_ varchar2(255 char), primary key (DBID_));
create table DEF_TESTS (ACTIVITY_ID_ number(19,0) not null, event varchar2(255 char), varNames raw(255), plnkNames raw(255), primary key (ACTIVITY_ID_));
create table DEF_TO_PART (DBID_ number(19,0) not null, PART_ varchar2(255 char), FROM_VAR_ varchar2(255 char), primary key (DBID_));
create table DEF_VARIABLE (DBID_ number(19,0) not null, NAME_ varchar2(255 char), MSGTYPE_QNAME_ varchar2(255 char), TYPE_QNAME_ varchar2(255 char), ELT_QNAME_ varchar2(255 char), VIRTUAL_COPY_ number(19,0), DEFAULT_VAL_ clob, SCOPE_ID_ number(19,0), VAR_NAME_ varchar2(255 char), primary key (DBID_));
create table DEF_VAR_PARTS (VAR_ID_ number(19,0) not null, TYPE_QNAME_ varchar2(255 char), ELT_QNAME_ varchar2(255 char), NAME_ varchar2(255 char) not null, primary key (VAR_ID_, NAME_));
create table DEF_WSDLINFOS (DBID_ number(19,0) not null, primary key (DBID_));
create table DEF_WSDLINFOS_wsdlDefinitions (WSDLINFOS_ID_ number(19,0) not null, WSDLINFOS_DEF_ blob);
create table DEF_WSDL_PROPERTY (DBID_ number(19,0) not null, ELT_QNAME_ varchar2(255 char), NAME_QNAME_ varchar2(255 char), TYPE_QNAME_ varchar2(255 char), WSDLINFOS_ID_ number(19,0), primary key (DBID_));
create table MON_DEF_ACTIVITY (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, dbversion number(19,0) not null, ACT_DEF_UUID_ varchar2(500 char), PROCESS_DEF_UUID_ varchar2(255 char), NAME_ varchar2(255 char), DOCUMENTATION_ varchar2(4000 char), SUPPR_JN_FL_ number(1,0), TGT_JN_CDT_EXP_LG_ varchar2(255 char), TGT_JN_CDT_BLN_LG_ varchar2(255 char), CHILD_ACT_DEF_ID_ number(19,0), FAULT_NAME_QNAME_ varchar2(255 char), FAULT_MESSAGE_TYPE_QNAME_ varchar2(255 char), FAULT_ELEMENT_QNAME_ varchar2(255 char), faultVariable varchar2(255 char), EX_ON_STA_FAULT_ number(1,0), TERMINATION_HANDLER_ number(19,0), COMPENSATION_HANDLER_ number(19,0), NAMESPACE_ varchar2(255 char), VERSION_ number(10,0), EXPR_LANG_ varchar2(255 char), QUERY_LANG_ varchar2(255 char), DPLY_DATE_ timestamp, UNDPLY_DATE timestamp, STATE_ varchar2(255 char), TARGET_ varchar2(255 char), IVK_PRTLNK_ varchar2(255 char), IVK_IN_VAR_ varchar2(255 char), IVK_OUT_VAR_ varchar2(255 char), IVK_OPERATION_ varchar2(255 char), IVK_PRT_PT_QNAME_ varchar2(255 char), PT_QNAME_ varchar2(255 char), FAULT_VARIABLE_ varchar2(255 char), WHL_EXP_LANG_ varchar2(255 char), WHL_BOOL_EXP_ varchar2(255 char), RPU_EXP_LANG_ varchar2(255 char), RPU_BOOL_EXP_ varchar2(255 char), REC_CRT_INST_ number(1,0), REC_VAR_ varchar2(255 char), REC_PARTN_LNK_ varchar2(255 char), REC_OPERATION_ varchar2(255 char), REC_MSG_EXCHNG_ varchar2(255 char), REC_PRT_PT_QNAME_ varchar2(255 char), REP_VAR_ varchar2(255 char), REP_PARTN_LNK_ varchar2(255 char), REP_OPERATION_ varchar2(255 char), REP_MSG_EXCHNG_ varchar2(255 char), REP_PRT_PT_QNAME_ varchar2(255 char), REP_FLT_NM_QNAME_ varchar2(255 char), ASSIGN_VLDT_ number(1,0), FOR_EXPR_LANG_ varchar2(255 char), FOR_DUR_LANG_ varchar2(255 char), UNTIL_EXPR_LANG_ varchar2(255 char), UNTIL_DEAD_LANG_ varchar2(255 char), IF_EXPR_LANG_ varchar2(255 char), IF_EXPR_ varchar2(255 char), ELSE_ACT_DEF_ID_ number(19,0), ELSE_ACT_UUID_ varchar2(500 char), PK_DF_CR_INST_ number(1,0), FRCH_C_N_EXPR_ varchar2(255 char), FRCH_PARLLL_EXPR_ number(1,0), FRCH_FINL_EXPR_ varchar2(255 char), FRCH_FINL_EXPR_LG_ varchar2(255 char), FRCH_STRT_EXPR_ varchar2(255 char), FRCH_STRT_EXPR_LG_ varchar2(255 char), FRCH_CD_EXPR_ varchar2(255 char), FRCH_CD_EXPR_LG_ varchar2(255 char), FRCH_CD_SUCC_ number(1,0), PARENT_ACT_DEF_ID_ number(19,0), INDEX_ number(10,0), SCOPE_ID_ number(19,0), primary key (DBID_));
create table MON_DEF_COPY (DBID_ number(19,0) not null, KEEP_SRC_ELT_NAME number(1,0), COPY_LST_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_CORR (DBID_ number(19,0) not null, SETVALUE_ varchar2(255 char), INITIATE_ varchar2(255 char), ON_MSG_CORR_ID_ number(19,0), INDEX_ number(10,0), ON_EVT_CORR_ID_ number(19,0), IVK_CR_DEF_ID_ number(19,0), REC_CR_DEF_ID_ number(19,0), RP_CR_DEF_ID_ number(19,0), primary key (DBID_));
create table MON_DEF_ELSEIF (DBID_ number(19,0) not null, ELSEIF_EXPR_ varchar2(255 char), ELSEIF_EXPR_LANG_ varchar2(255 char), ELSEIF_ACT_DEF_ID_ number(19,0), ELSEIF_ACT_UUID_ varchar2(500 char), IF_ELSEIF_LST_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_EXT (DBID_ number(19,0) not null, NAMESPACE varchar2(255 char), MUST_UNDERSTAND number(1,0), SUPPORTED number(1,0), PROCESS_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_FROM_PART (DBID_ number(19,0) not null, FP_PART_ varchar2(255 char), FP_TO_VAR_ varchar2(255 char), ON_MSG_FRM_PRT_ID_ number(19,0), INDEX_ number(10,0), ON_EVT_FRM_PRT_ID_ number(19,0), IVK_FR_PT_ID_ number(19,0), REC_FR_PT_ID_ number(19,0), primary key (DBID_));
create table MON_DEF_FROM_TO (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, FT_VARIANT_ varchar2(255 char), FT_EXP_LANG_ varchar2(255 char), FT_VARIABLE_ varchar2(255 char), FT_PART_ varchar2(255 char), FT_PARTNER_LINK_ varchar2(255 char), FT_ENDPOINT_REF_ varchar2(255 char), FT_PROP_QNAME_ varchar2(255 char), FT_EXPRESSION_ varchar2(255 char), FT_QUERY_ varchar2(255 char), FT_QUERY_LANG_ varchar2(255 char), LITRL_VALUE_ varchar2(3999 char), FROM_LST_ID_ number(19,0), INDEX_ number(10,0), TO_LST_ID_ number(19,0), primary key (DBID_));
create table MON_DEF_LINK (FLOW_LINKS_ID_ number(19,0) not null, FLOW_LINKS_ varchar2(255 char), INDEX_ number(10,0) not null, primary key (FLOW_LINKS_ID_, INDEX_));
create table MON_DEF_LINK_SRC (DBID_ number(19,0) not null, LNK_NAME varchar2(255 char), TR_CND_EXP_LG varchar2(255 char), TR_CND_BOL_EXP varchar2(255 char), SRC_LST_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_LINK_TGT (DBID_ number(19,0) not null, LNK_NAME varchar2(255 char), TRGT_LST_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_MSG_EXCHG (SCOPE_ID_ number(19,0) not null, elt varchar2(255 char), INDEX_ number(10,0) not null, primary key (SCOPE_ID_, INDEX_));
create table MON_DEF_ON_ALRM (DBID_ number(19,0) not null, ON_ALRM_ACT_DEF_ID_ number(19,0), ON_ALRM_ACT_UUID_ varchar2(500 char), FOR_EXPR_LANG_ varchar2(255 char), FOR_DUR_LANG_ varchar2(255 char), UNTIL_EXPR_LANG_ varchar2(255 char), UNTIL_DEAD_LANG_ varchar2(255 char), REPETE_EXPR_LANG_ varchar2(255 char), REPEAT_DEAD_LANG_ varchar2(255 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), PK_DF_ON_AL_ID_ number(19,0), primary key (DBID_));
create table MON_DEF_ON_EVT (DBID_ number(19,0) not null, PICK_VAR_ varchar2(255 char), PICK_PART_LNK_ varchar2(255 char), PICK_OPTN_ varchar2(255 char), PICK_MSG_EXCHG_ varchar2(255 char), PICK_PT_TP_QNAME_ varchar2(255 char), ON_EVT_ACT_DEF_ID_ number(19,0), ON_EVT_ACT_UUID_ varchar2(500 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_ON_MSG (DBID_ number(19,0) not null, PICK_VAR_ varchar2(255 char), PICK_PART_LNK_ varchar2(255 char), PICK_OPTN_ varchar2(255 char), PICK_MSG_EXCHG_ varchar2(255 char), PICK_PT_TP_QNAME_ varchar2(255 char), ON_MSG_ACT_DEF_ID_ number(19,0), ON_MSG_ACT_UUID_ varchar2(500 char), PK_DF_ON_MSG_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_PART_LNK (DBID_ number(19,0) not null, NAME_ varchar2(255 char), MY_ROLE_ varchar2(255 char), PARTNER_ROLE_ varchar2(255 char), INIT_PRTN_ROLE_ number(1,0), PRT_LNK_QNAME_ varchar2(255 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_PROC_STATE (DBID_ number(19,0) not null, DATE_ timestamp, STATE_ varchar2(255 char), PROCESS_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_RESOURCES (PROCESS_ID_ number(19,0) not null, CONTENT_ blob, NAME_ varchar2(255 char) not null, primary key (PROCESS_ID_, NAME_));
create table MON_DEF_TO_PART (DBID_ number(19,0) not null, TP_PART_ varchar2(255 char), TP_FRM_VAR_ varchar2(255 char), IVK_TO_PT_ID_ number(19,0), INDEX_ number(10,0), RP_TO_PT_ID_ number(19,0), primary key (DBID_));
create table MON_DEF_VAR (DBID_ number(19,0) not null, MSGTYPE_QNAME_ varchar2(255 char), TYPE_QNAME_ varchar2(255 char), ELT_QNAME_ varchar2(255 char), NAME_ varchar2(255 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_VAR_CS (DBID_ number(19,0) not null, NAME_ varchar2(255 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_DEF_VAR_CS_properties (CORR_ST_DEF_ID_ number(19,0) not null, PROP_QNAME_ varchar2(255 char), INDEX_ number(10,0) not null, primary key (CORR_ST_DEF_ID_, INDEX_));
create table MON_RUNT_ACTIVITY (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, dbversion number(19,0) not null, ACT_INST_UUID_ varchar2(255 char), ACT_DEF_UUID_ varchar2(500 char), PROCESS_UUID_ varchar2(255 char), INST_UUID_ varchar2(255 char), STARTED_DATE_ timestamp, ENDED_DATE_ timestamp, ACTIVITY_STATE_ varchar2(255 char), LAST_EXCEPTION_ number(19,0), CHILD_ACT_INST_ID_ number(19,0), OPERATION_ varchar2(255 char), VARIABLE_ varchar2(255 char), MESSAGE_EXCHANGE_ varchar2(255 char), FH_INST_ number(19,0), TH_INST_ number(19,0), CH_INST_ number(19,0), START_VALUE_ number(10,0), STOP_VALUE_ number(10,0), COMPLETION_CONDITION_VALUE_ number(10,0), CHILD_WAIT_ACT_ number(19,0), PARENT_ACT_INST_ID_ number(19,0), INDEX_ number(10,0), PARENT_SCOPE_ID_ number(19,0), primary key (DBID_));
create table MON_RUNT_BPEL_FAULT_ (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, FAULT_QNAME_ varchar2(255 char), MSG_PARTS_ clob, ELT_ clob, primary key (DBID_));
create table MON_RUNT_CS_INIT (DBID_ number(19,0) not null, ACT_INST_UUID_ varchar2(255 char), DATE_ timestamp, NAME_ varchar2(255 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_RUNT_CS_PROP (CS_ID_ number(19,0) not null, VALUE_ clob, QNAME_ varchar2(255 char) not null, primary key (CS_ID_, QNAME_));
create table MON_RUNT_INST_STATE (DBID_ number(19,0) not null, DATE_ timestamp, STATE_ varchar2(255 char), PROCESS_INST_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_RUNT_PLNK_UPDATE (DBID_ number(19,0) not null, ACT_INST_UUID_ varchar2(255 char), DATE_ timestamp, NAME_ varchar2(255 char), P_END_REF clob, PLNK_UPD_TYPE_ varchar2(255 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_RUNT_RECORD (DBID_ number(19,0) not null, TYPE_ varchar2(255 char), ACT_INST_UUID_ varchar2(255 char), PROCESS_UUID_ varchar2(255 char), INST_UUID_ varchar2(255 char), DATA_ blob, primary key (DBID_));
create table MON_RUNT_SCOPE_STATE (DBID_ number(19,0) not null, ACT_INST_UUID_ varchar2(255 char), DATE_ timestamp, STATE_ varchar2(255 char), SCOPE_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_RUNT_TR_COND_UPD_ (DBID_ number(19,0) not null, STATUS_ number(1,0), NAME_ varchar2(255 char), DATE_ timestamp, FLOW_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table MON_RUNT_VAR_UPDATE (DBID_ number(19,0) not null, ACT_INST_UUID_ varchar2(255 char), DATE_ timestamp, NAME_ varchar2(255 char), IS_MESSAGE_ number(1,0), VALUE_ clob, INDEX_ number(10,0), SCOPE_ID_ number(19,0), primary key (DBID_));
create table MON_RUNT_WAITING (DBID_ number(19,0) not null, EXPECTED_STARTED_DATE_ timestamp, PICK_ID_ number(19,0), INDEX_ number(10,0), primary key (DBID_));
create table RUNT_ACTIV_PROC (DBID_ number(19,0) not null, PROCESS_UUID_ varchar2(255 char), PROCESS_QNAME_ varchar2(255 char) unique, primary key (DBID_));
create table RUNT_BPEL_FAULT_ (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, FAULT_QNAME_ varchar2(255 char), CONTENT_ clob, primary key (DBID_));
create table RUNT_CS_RUNTIME (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, SCOPE_ID_ number(19,0) not null, NAME_ varchar2(255 char) not null, INITIALIZED_ number(1,0), primary key (DBID_));
create table RUNT_CS_RUN_PROP (CS_ID_ number(19,0) not null, VALUE_ clob, QNAME_ varchar2(255 char) not null, primary key (CS_ID_, QNAME_));
create table RUNT_EXECUTION (DBID_ number(19,0) not null, CLASS_ char(1 char) not null, DBVERSION_ number(10,0) not null, NODE_ varchar2(255 char), ID_ varchar2(255 char) not null unique, STATE_ varchar2(255 char), RESUME_STATE_ varchar2(255 char), PARENT_ number(19,0), INSTANCE_ number(19,0), ACTIVITY_UUID_ varchar2(255 char), FOREACH_ID_ number(19,0), SCOPE_RT_ID_ number(19,0), WAITING_EXEC_ID_ number(19,0), INSTANCE_UUID_ varchar2(255 char), PROCESS_UUID_ varchar2(255 char), INSTANCE_STATE_ varchar2(255 char), PARENT_INST_START_TIME_ timestamp, primary key (DBID_));
create table RUNT_EXEC_INVOKE_DATA (DBID_ number(19,0) not null, OP_KEY_ varchar2(3999 char), MSG_PARTS_ clob, ENDPOINT_ clob, primary key (DBID_));
create table RUNT_FOREACH_RUNTIME (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, COUNTER_FINAL_ number(10,0), COUNTER_CURRENT_ number(10,0), BRANCH_COUNT_ number(10,0), primary key (DBID_));
create table RUNT_INST_COUNT (DBID_ number(19,0) not null, PROCESS_UUID_ varchar2(255 char), PROCESS_QNAME_ varchar2(255 char), primary key (DBID_));
create table RUNT_JOB (DBID_ number(19,0) not null, CLASS_ varchar2(255 char) not null, DBVERSION_ number(10,0) not null, DUEDATE_ timestamp, ISSUSPENDED_ number(1,0), LOCKOWNER_ varchar2(255 char), LOCKEXPTIME_ timestamp, PRIORITY_ number(10,0), RETRIES_ number(10,0), DELAY_ number(19,0), EXCEPTION_ number(19,0), EXECUTION_ number(19,0), SIGNAL_ varchar2(255 char), REPEAT_ number(19,0), INVOKE_DATA_ number(19,0), SIG_INVOKE_DATA_ number(19,0), primary key (DBID_));
create table RUNT_JOB_EXCEPTION_ (DBID_ number(19,0) not null, EXCEPTION_ blob, primary key (DBID_));
create table RUNT_LINK_RUNTIME (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, STATUS_ varchar2(255 char), WAITING_EXEC_ number(19,0), NAME_ varchar2(255 char), ACT_INST_UUID_ varchar2(255 char), FLOW_RUNTIME_ID_ number(19,0), primary key (DBID_));
create table RUNT_PENDING_MESS (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, MSG_PARTS_ clob, MSG_CARRIER_ID_ varchar2(255 char), OP_KEY_ varchar2(3999 char), ADDED_DATE_ timestamp, primary key (DBID_));
create table RUNT_PEND_MSG_CS_KEYS (MSG_ID_ number(19,0) not null, KEY_ number(10,0));
create table RUNT_PL_RUNTIME (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, NAME_ varchar2(255 char) not null, SCOPE_ID_ number(19,0) not null, P_END_REF clob, primary key (DBID_));
create table RUNT_PROC_COUNT (DBID_ number(19,0) not null, DBVERSION_ number(19,0) not null, COUNTER_ number(19,0), primary key (DBID_));
create table RUNT_REPLIER (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, MSG_EXCHG_ varchar2(255 char), OP_KEY_ varchar2(3999 char), SCOPE_RUNTIME_ number(19,0), primary key (DBID_));
create table RUNT_SCOPE_RUNTIME (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, PARENT_ number(19,0), END_DATE_ number(19,0), ACTIVITY_UUID_ varchar2(255 char), SCOPE_DEF_ varchar2(255 char), SCOPE_STATE_ raw(255), LAST_EXCEPTION_ number(19,0), COMPENSATE_EXEC_ number(19,0), primary key (DBID_));
create table RUNT_SIG_INVOKE_DATA (DBID_ number(19,0) not null, MSG_PARTS_ clob, FAULT_QNAME_ varchar2(255 char), INVOKE_EXCEPTION_ blob, primary key (DBID_));
create table RUNT_VAR_RUNTIME (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, NAME_ varchar2(255 char) not null, VALUE_ clob, IS_MSG_ number(1,0) not null, SCOPE_ID_ number(19,0) not null, primary key (DBID_));
create table RUNT_WAIT_EXEC (DBID_ number(19,0) not null, DBVERSION_ number(10,0) not null, EXEC_ID_ number(19,0), IN_ELT_ varchar2(255 char), primary key (DBID_));
create table RUNT_WAIT_EXEC_CS_ (WAIT_ID_ number(19,0) not null, CS_ID_ number(19,0) not null, primary key (WAIT_ID_, CS_ID_));
create table RUNT_WAIT_EXEC_CS_KEYS (WAIT_ID_ number(19,0) not null, KEY_ number(10,0));
create index IF_COND_IDX on DEF_ACTIVITY (COND_);
create index IF_ACT_IDX on DEF_ACTIVITY (ACTIVITY_);
create index ACT_SCOPE_IDX on DEF_ACTIVITY (SCOPE_);
create index WAIT_DLINE_IDX on DEF_ACTIVITY (DEADLINE_);
create index FOR_FINAL_IDX on DEF_ACTIVITY (FINAL_COUNT_);
create index FOR_START_IDX on DEF_ACTIVITY (START_COUNT_);
create index ELSE_ACT_IDX on DEF_ACTIVITY (ELSE_ACTIVITY_);
create index RECV_IN_MSG_IDX on DEF_ACTIVITY (ANON_IN_MESS_);
create index ACT_CHILD_IDX on DEF_ACTIVITY (CHILD_NODE_);
create index FOR_COND_IDX on DEF_ACTIVITY (COMPL_COND_);
create index ACT_JOIN_COND_IDX on DEF_ACTIVITY (TARG_JOIN_COND_);
create index REPLY_OUT_IDX on DEF_ACTIVITY (ANON_OUT_MESS_);
create index WAIT_DUR_IDX on DEF_ACTIVITY (DURATION_);
alter table DEF_ACTIVITY add constraint REPLY_OUT_FK foreign key (ANON_OUT_MESS_) references DEF_VARIABLE;
alter table DEF_ACTIVITY add constraint ELSE_ACT_FK foreign key (ELSE_ACTIVITY_) references DEF_NODE;
alter table DEF_ACTIVITY add constraint FOR_START_FK foreign key (START_COUNT_) references DEF_SNIPPET;
alter table DEF_ACTIVITY add constraint ACT_SCOPE_FK foreign key (SCOPE_) references DEF_ACTIVITY;
alter table DEF_ACTIVITY add constraint IF_ACT_FK foreign key (ACTIVITY_) references DEF_NODE;
alter table DEF_ACTIVITY add constraint ACT_CHILD_FK foreign key (CHILD_NODE_) references DEF_NODE;
alter table DEF_ACTIVITY add constraint FOR_COND_FK foreign key (COMPL_COND_) references DEF_SNIPPET;
alter table DEF_ACTIVITY add constraint WAIT_DLINE_FK foreign key (DEADLINE_) references DEF_SNIPPET;
alter table DEF_ACTIVITY add constraint IF_COND_FK foreign key (COND_) references DEF_SNIPPET;
alter table DEF_ACTIVITY add constraint WAIT_DUR_FK foreign key (DURATION_) references DEF_SNIPPET;
alter table DEF_ACTIVITY add constraint FKCA401E295BE3B464 foreign key (catchVariableDefinition) references DEF_VARIABLE;
alter table DEF_ACTIVITY add constraint ACT_JOIN_COND_FK foreign key (TARG_JOIN_COND_) references DEF_SNIPPET;
alter table DEF_ACTIVITY add constraint FKCA401E2934D2137C foreign key (EXT_PROCESS_) references DEF_PROCESS;
alter table DEF_ACTIVITY add constraint FKCA401E29EBD7E30B foreign key (NODE_) references DEF_NODE;
alter table DEF_ACTIVITY add constraint FOR_FINAL_FK foreign key (FINAL_COUNT_) references DEF_SNIPPET;
alter table DEF_ACTIVITY add constraint RECV_IN_MSG_FK foreign key (ANON_IN_MESS_) references DEF_VARIABLE;
alter table DEF_ACTIVITY add constraint FKCA401E299D390524 foreign key (INBOUND_PROCESS_) references DEF_PROCESS;
create index ASSIGN_COPY_IDX on DEF_COPY_ELT (ASSIGN_ID_);
create index INVOKE_OUT_IDX on DEF_COPY_ELT (INVOKE_OUT_ID_);
create index RECEIVE_IN_IDX on DEF_COPY_ELT (RECEIVE_IN_ID_);
create index INVOKE_IN_IDX on DEF_COPY_ELT (INVOKE_IN_ID_);
create index REPLY_MSG_EX_IDX on DEF_COPY_ELT (REPLY_ID_);
alter table DEF_COPY_ELT add constraint RECEIVE_IN_FK foreign key (RECEIVE_IN_ID_) references DEF_ACTIVITY;
alter table DEF_COPY_ELT add constraint FKEDF5BDD5C53F732 foreign key (ON_MSG_IN_ID_) references DEF_ON_MSG;
alter table DEF_COPY_ELT add constraint REPLY_MSG_EX_FK foreign key (REPLY_ID_) references DEF_ACTIVITY;
alter table DEF_COPY_ELT add constraint FKEDF5BDDDE1523BD foreign key (FROM_) references DEF_FROM_TO_ELT;
alter table DEF_COPY_ELT add constraint ASSIGN_COPY_FK foreign key (ASSIGN_ID_) references DEF_ACTIVITY;
alter table DEF_COPY_ELT add constraint INVOKE_IN_FK foreign key (INVOKE_IN_ID_) references DEF_ACTIVITY;
alter table DEF_COPY_ELT add constraint INVOKE_OUT_FK foreign key (INVOKE_OUT_ID_) references DEF_ACTIVITY;
alter table DEF_COPY_ELT add constraint FKEDF5BDD6464ED5D foreign key (TO_) references DEF_FROM_TO_ELT;
alter table DEF_COPY_ELT add constraint FKEDF5BDD3A9909E3 foreign key (ON_EVT_IN_ID_) references DEF_ON_EVT;
create index REPLY_COR_IDX on DEF_CORREL (REPLY_ID_);
create index INV_RES_IDX on DEF_CORREL (INVOKE_RES_ID_);
create index INV_REQ_IDX on DEF_CORREL (INVOKE_REQ_ID_);
create index RECV_COR_IDX on DEF_CORREL (RECEIVE_ID_);
alter table DEF_CORREL add constraint FK59CAAEED6F00CA0D foreign key (CS_) references DEF_CS;
alter table DEF_CORREL add constraint REPLY_COR_FK foreign key (REPLY_ID_) references DEF_ACTIVITY;
alter table DEF_CORREL add constraint FK59CAAEED1BC92050 foreign key (ON_MSG_ID_) references DEF_ON_MSG;
alter table DEF_CORREL add constraint INV_RES_FK foreign key (INVOKE_RES_ID_) references DEF_ACTIVITY;
alter table DEF_CORREL add constraint RECV_COR_FK foreign key (RECEIVE_ID_) references DEF_ACTIVITY;
alter table DEF_CORREL add constraint FK59CAAEEDF7C10905 foreign key (ON_EVT_ID_) references DEF_ON_EVT;
alter table DEF_CORREL add constraint INV_REQ_FK foreign key (INVOKE_REQ_ID_) references DEF_ACTIVITY;
create index SCOPE_CS_IDX on DEF_CS (SCOPE_ID_);
alter table DEF_CS add constraint SCOPE_CS_FK foreign key (SCOPE_ID_) references DEF_ACTIVITY;
alter table DEF_CS_PROPERTIES_ add constraint FK1882EBD71E706273 foreign key (CS_ID_) references DEF_CS;
alter table DEF_CS_PROPERTIES_ add constraint FK1882EBD72B0757BD foreign key (elt) references DEF_WSDL_PROPERTY;
create index ELSIF_IDX on DEF_ELSE_IF (IF_ID_);
create index ELSIF_ACT_IDX on DEF_ELSE_IF (ACTIVITY_);
create index ELSIF_COND_IDX on DEF_ELSE_IF (CONDITION_);
alter table DEF_ELSE_IF add constraint ELSIF_FK foreign key (IF_ID_) references DEF_ACTIVITY;
alter table DEF_ELSE_IF add constraint ELSIF_ACT_FK foreign key (ACTIVITY_) references DEF_NODE;
alter table DEF_ELSE_IF add constraint ELSIF_COND_FK foreign key (CONDITION_) references DEF_SNIPPET;
alter table DEF_FROM_TO_ELT add constraint FKFD0421A4C4132A10 foreign key (EXPRESSION_) references DEF_SNIPPET;
alter table DEF_FROM_TO_ELT add constraint FKFD0421A43ADD900A foreign key (VAR_QUERY_) references DEF_SNIPPET;
create index FLOW_LINK_IDX on DEF_LINK (FLOW_ID_);
alter table DEF_LINK add constraint FLOW_LINK_FK foreign key (FLOW_ID_) references DEF_ACTIVITY;
alter table DEF_LINK add constraint FK56AF8014C74809C5 foreign key (SOURCE_ACTIVITY_) references DEF_ACTIVITY;
alter table DEF_LINK add constraint FK56AF8014A26937BB foreign key (TARGET_ACTIVITY_) references DEF_ACTIVITY;
create index ACT_SRC_LNK_IDX on DEF_LINK_SOURCE (ACTIVITY_ID_);
alter table DEF_LINK_SOURCE add constraint FK7E0B5AA6DE682DBD foreign key (LINK_) references DEF_LINK;
alter table DEF_LINK_SOURCE add constraint ACT_SRC_LNK_FK foreign key (ACTIVITY_ID_) references DEF_ACTIVITY;
alter table DEF_LINK_SOURCE add constraint FK7E0B5AA635D1566F foreign key (TRANS_COND_) references DEF_SNIPPET;
create index ACT_TGT_LNK_IDX on DEF_LINK_TARGET (ACTIVITY_ID_);
alter table DEF_LINK_TARGET add constraint FK7EF9641CDE682DBD foreign key (LINK_) references DEF_LINK;
alter table DEF_LINK_TARGET add constraint ACT_TGT_LNK_FK foreign key (ACTIVITY_ID_) references DEF_ACTIVITY;
alter table DEF_NAMESPACE add constraint FKBC348D61329E08E foreign key (SNIPPET_ID_) references DEF_SNIPPET;
create index IDX_NODE_PROCESS on DEF_NODE (PROCESS_);
create index IDX_EXHDLR_NODE on DEF_NODE (EXCEPTHNDLR_);
create index IDX_NODE_BEHAV_OBJ on DEF_NODE (BEHAV_OBJ_);
create index IDX_NODE_PARENT on DEF_NODE (PARENT_);
alter table DEF_NODE add constraint FK_NODE_PROCESS foreign key (PROCESS_) references DEF_PROCESS;
alter table DEF_NODE add constraint FK_NODE_BEHAV_OBJ foreign key (BEHAV_OBJ_) references DEF_ACTIVITY;
alter table DEF_NODE add constraint FK_EXHDLR_NODE foreign key (EXCEPTHNDLR_) references DEF_EXCEPTHNDLR;
alter table DEF_NODE add constraint FK_NODE_PARENT foreign key (PARENT_) references DEF_NODE;
create index PICK_ON_ALRM_IDX on DEF_ON_ALARM (PICK_ID_);
create index ACT_ON_ALARM_IDX on DEF_ON_ALARM (ACTIVITY_ID_);
alter table DEF_ON_ALARM add constraint FKD0C506EBFAD5EF6D foreign key (REPEAT_) references DEF_SNIPPET;
alter table DEF_ON_ALARM add constraint ACT_ON_ALARM_FK foreign key (ACTIVITY_ID_) references DEF_ACTIVITY;
alter table DEF_ON_ALARM add constraint FKD0C506EB58E1CE94 foreign key (DURATION_) references DEF_SNIPPET;
alter table DEF_ON_ALARM add constraint FKD0C506EBF1C83F9E foreign key (ACTIVITY_) references DEF_NODE;
alter table DEF_ON_ALARM add constraint PICK_ON_ALRM_FK foreign key (PICK_ID_) references DEF_ACTIVITY;
alter table DEF_ON_ALARM add constraint FKD0C506EB5C32DA50 foreign key (DEADLINE_) references DEF_SNIPPET;
create index ACT_ON_EVT_IDX on DEF_ON_EVT (ACTIVITY_ID_);
alter table DEF_ON_EVT add constraint ACT_ON_EVT_FK foreign key (ACTIVITY_ID_) references DEF_ACTIVITY;
alter table DEF_ON_EVT add constraint FK6E3C78FD9F1241FC foreign key (INBOUND_ELT_) references DEF_ACTIVITY;
alter table DEF_ON_EVT add constraint FK6E3C78FDF1C83F9E foreign key (ACTIVITY_) references DEF_NODE;
alter table DEF_ON_EVT add constraint FK6E3C78FDF7237F7A foreign key (ANON_IN_MESS_) references DEF_VARIABLE;
create index PICK_ON_MSG_IDX on DEF_ON_MSG (PICK_ID_);
alter table DEF_ON_MSG add constraint FK6E3C969B9F1241FC foreign key (INBOUND_ELT_) references DEF_ACTIVITY;
alter table DEF_ON_MSG add constraint FK6E3C969BF1C83F9E foreign key (ACTIVITY_) references DEF_NODE;
alter table DEF_ON_MSG add constraint PICK_ON_MSG_FK foreign key (PICK_ID_) references DEF_ACTIVITY;
alter table DEF_ON_MSG add constraint FK6E3C969BF7237F7A foreign key (ANON_IN_MESS_) references DEF_VARIABLE;
create index SCOPE_PL_IDX on DEF_PLNK (SCOPE_ID_);
alter table DEF_PLNK add constraint SCOPE_PL_FK foreign key (SCOPE_ID_) references DEF_ACTIVITY;
alter table DEF_PLNKTYPE add constraint FKB268428D64EEA1B7 foreign key (WSDLINFOS_ID_) references DEF_WSDLINFOS;
alter table DEF_PLNKT_ROLES add constraint FK7D378ABFA4BE5179 foreign key (PLNKTYPE_ID_) references DEF_PLNKTYPE;
create index IDX_EXHDLR_PROCESS on DEF_PROCESS (EXCEPTHNDLR_);
create index PROCESS_INST_CNT_IDX on DEF_PROCESS (instanceCreationLock);
create index IDX_PROCDEF_INIT on DEF_PROCESS (INITIAL_);
create index PROCESS_UUID_IDX on DEF_PROCESS (PROCESS_UUID_);
alter table DEF_PROCESS add constraint FK_PROCDEF_INITIAL foreign key (INITIAL_) references DEF_NODE;
alter table DEF_PROCESS add constraint FK9429A3F5E142EB34 foreign key (instanceCreationLock) references RUNT_INST_COUNT;
alter table DEF_PROCESS add constraint FK_EXHDLR_PROCESS foreign key (EXCEPTHNDLR_) references DEF_EXCEPTHNDLR;
alter table DEF_PROCESS add constraint FK9429A3F59A504866 foreign key (WSDL_INFOS_) references DEF_WSDLINFOS;
alter table DEF_PROC_COMMON_CS add constraint FK4295E5351E706273 foreign key (CS_ID_) references DEF_CS;
alter table DEF_PROC_COMMON_CS add constraint FK4295E535F1DBFC22 foreign key (PROCESS_ID_) references DEF_PROCESS;
alter table DEF_PROC_RESOURCES add constraint FK24F1AFF6F1DBFC22 foreign key (PROCESS_ID_) references DEF_PROCESS;
alter table DEF_PROPALIAS add constraint FK4643D0D364EEA1B7 foreign key (WSDLINFOS_ID_) references DEF_WSDLINFOS;
alter table DEF_PROPALIAS add constraint FK4643D0D32E48839 foreign key (QUERY_) references DEF_SNIPPET;
create index SCOPE_MSG_EX_IDX on DEF_SCOPE_MESSEXS (SCOPE_ID_);
alter table DEF_SCOPE_MESSEXS add constraint SCOPE_MSG_EX_FK foreign key (SCOPE_ID_) references DEF_ACTIVITY;
create index SCOPE_INIT_VAR_IDX on DEF_SCOPE_VARINIT (SCOPE_ID_);
alter table DEF_SCOPE_VARINIT add constraint SCOPE_INIT_VAR_FK foreign key (SCOPE_ID_) references DEF_ACTIVITY;
alter table DEF_TESTS add constraint FK7FAF81279E066E73 foreign key (ACTIVITY_ID_) references DEF_ACTIVITY;
create index SCOPE_VAR_IDX on DEF_VARIABLE (SCOPE_ID_);
alter table DEF_VARIABLE add constraint FKE278FD9681EEAE9 foreign key (VIRTUAL_COPY_) references DEF_COPY_ELT;
alter table DEF_VARIABLE add constraint SCOPE_VAR_FK foreign key (SCOPE_ID_) references DEF_ACTIVITY;
alter table DEF_VAR_PARTS add constraint FK930457AECC8F6326 foreign key (VAR_ID_) references DEF_VARIABLE;
alter table DEF_WSDLINFOS_wsdlDefinitions add constraint FK26B03DE464EEA1B7 foreign key (WSDLINFOS_ID_) references DEF_WSDLINFOS;
alter table DEF_WSDL_PROPERTY add constraint FK3542887664EEA1B7 foreign key (WSDLINFOS_ID_) references DEF_WSDLINFOS;
create index SCOPE_DEF_FAULT_HANDLERS_IDX on MON_DEF_ACTIVITY (SCOPE_ID_);
alter table MON_DEF_ACTIVITY add constraint FKB2087C9CF1C5FAB0 foreign key (PARENT_ACT_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ACTIVITY add constraint FKB2087C9C82112BDD foreign key (CHILD_ACT_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ACTIVITY add constraint FKB2087C9C614874B5 foreign key (TERMINATION_HANDLER_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ACTIVITY add constraint FKB2087C9CDE3B31AF foreign key (COMPENSATION_HANDLER_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ACTIVITY add constraint FKB2087C9CD4D0807A foreign key (ELSE_ACT_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ACTIVITY add constraint SCOPE_DEF_FAULT_HANDLERS_FK foreign key (SCOPE_ID_) references MON_DEF_ACTIVITY;
create index COPY_LST_IDX on MON_DEF_COPY (COPY_LST_ID_);
alter table MON_DEF_COPY add constraint COPY_LST_FK foreign key (COPY_LST_ID_) references MON_DEF_ACTIVITY;
create index RP_CR_DEF_LST_IDX on MON_DEF_CORR (RP_CR_DEF_ID_);
create index IVK_CR_DEF_LST_IDX on MON_DEF_CORR (IVK_CR_DEF_ID_);
create index ON_MSG_CORR_IDX on MON_DEF_CORR (ON_MSG_CORR_ID_);
create index REC_CR_DEF_LST_IDX on MON_DEF_CORR (REC_CR_DEF_ID_);
create index ON_EVT_CORR_IDX on MON_DEF_CORR (ON_EVT_CORR_ID_);
alter table MON_DEF_CORR add constraint REC_CR_DEF_LST_FK foreign key (REC_CR_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_CORR add constraint IVK_CR_DEF_LST_FK foreign key (IVK_CR_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_CORR add constraint RP_CR_DEF_LST_FK foreign key (RP_CR_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_CORR add constraint ON_EVT_CORR_FK foreign key (ON_EVT_CORR_ID_) references MON_DEF_ON_EVT;
alter table MON_DEF_CORR add constraint ON_MSG_CORR_FK foreign key (ON_MSG_CORR_ID_) references MON_DEF_ON_MSG;
create index IF_ELSEIF_LST_IDX on MON_DEF_ELSEIF (IF_ELSEIF_LST_ID_);
alter table MON_DEF_ELSEIF add constraint IF_ELSEIF_LST_FK foreign key (IF_ELSEIF_LST_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ELSEIF add constraint FK802DBCE366DBBFD7 foreign key (ELSEIF_ACT_DEF_ID_) references MON_DEF_ACTIVITY;
create index PROCESS_EXT_IDX on MON_DEF_EXT (PROCESS_ID_);
alter table MON_DEF_EXT add constraint PROCESS_EXT_FK foreign key (PROCESS_ID_) references MON_DEF_ACTIVITY;
create index IVK_FR_PT_LST_IDX on MON_DEF_FROM_PART (IVK_FR_PT_ID_);
create index ON_MSG_FRM_PRT_IDX on MON_DEF_FROM_PART (ON_MSG_FRM_PRT_ID_);
create index ON_EVT_FRM_PRT_IDX on MON_DEF_FROM_PART (ON_EVT_FRM_PRT_ID_);
create index REC_FR_PT_LST_IDX on MON_DEF_FROM_PART (REC_FR_PT_ID_);
alter table MON_DEF_FROM_PART add constraint REC_FR_PT_LST_FK foreign key (REC_FR_PT_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_FROM_PART add constraint IVK_FR_PT_LST_FK foreign key (IVK_FR_PT_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_FROM_PART add constraint ON_MSG_FRM_PRT_FK foreign key (ON_MSG_FRM_PRT_ID_) references MON_DEF_ON_MSG;
alter table MON_DEF_FROM_PART add constraint ON_EVT_FRM_PRT_FK foreign key (ON_EVT_FRM_PRT_ID_) references MON_DEF_ON_EVT;
create index TO_LST_IDX on MON_DEF_FROM_TO (TO_LST_ID_);
create index FROM_LST_IDX on MON_DEF_FROM_TO (FROM_LST_ID_);
alter table MON_DEF_FROM_TO add constraint FROM_LST_FK foreign key (FROM_LST_ID_) references MON_DEF_COPY;
alter table MON_DEF_FROM_TO add constraint TO_LST_FK foreign key (TO_LST_ID_) references MON_DEF_COPY;
create index FLOW_LINKS_IDX on MON_DEF_LINK (FLOW_LINKS_ID_);
alter table MON_DEF_LINK add constraint FLOW_LINKS_FK foreign key (FLOW_LINKS_ID_) references MON_DEF_ACTIVITY;
create index SRC_LST_IDX on MON_DEF_LINK_SRC (SRC_LST_ID_);
alter table MON_DEF_LINK_SRC add constraint SRC_LST_FK foreign key (SRC_LST_ID_) references MON_DEF_ACTIVITY;
create index TRGT_LST_IDX on MON_DEF_LINK_TGT (TRGT_LST_ID_);
alter table MON_DEF_LINK_TGT add constraint TRGT_LST_FK foreign key (TRGT_LST_ID_) references MON_DEF_ACTIVITY;
create index SCOPE_DEF_M_E_IDX on MON_DEF_MSG_EXCHG (SCOPE_ID_);
alter table MON_DEF_MSG_EXCHG add constraint SCOPE_DEF_M_E_FK foreign key (SCOPE_ID_) references MON_DEF_ACTIVITY;
create index SCOPE_DEF_ALARMS_IDX on MON_DEF_ON_ALRM (SCOPE_ID_);
create index PK_DF_ON_AL_IDX on MON_DEF_ON_ALRM (PK_DF_ON_AL_ID_);
alter table MON_DEF_ON_ALRM add constraint PK_DF_ON_AL_FK foreign key (PK_DF_ON_AL_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ON_ALRM add constraint FK9A9936D9735C61C7 foreign key (ON_ALRM_ACT_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ON_ALRM add constraint SCOPE_DEF_ALARMS_FK foreign key (SCOPE_ID_) references MON_DEF_ACTIVITY;
create index SCOPE_DEF_EVTS_IDX on MON_DEF_ON_EVT (SCOPE_ID_);
alter table MON_DEF_ON_EVT add constraint FK915FD83099EA93C4 foreign key (ON_EVT_ACT_DEF_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ON_EVT add constraint SCOPE_DEF_EVTS_FK foreign key (SCOPE_ID_) references MON_DEF_ACTIVITY;
create index PK_DF_ON_MSG_IDX on MON_DEF_ON_MSG (PK_DF_ON_MSG_ID_);
alter table MON_DEF_ON_MSG add constraint PK_DF_ON_MSG_FK foreign key (PK_DF_ON_MSG_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_ON_MSG add constraint FK915FF5CEA6853462 foreign key (ON_MSG_ACT_DEF_ID_) references MON_DEF_ACTIVITY;
create index SCOPE_DEF_PL_IDX on MON_DEF_PART_LNK (SCOPE_ID_);
alter table MON_DEF_PART_LNK add constraint SCOPE_DEF_PL_FK foreign key (SCOPE_ID_) references MON_DEF_ACTIVITY;
create index PROCESS_STATE_IDX on MON_DEF_PROC_STATE (PROCESS_ID_);
alter table MON_DEF_PROC_STATE add constraint PROCESS_STATE_FK foreign key (PROCESS_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_RESOURCES add constraint FKCA16618F2951188 foreign key (PROCESS_ID_) references MON_DEF_ACTIVITY;
create index IVK_TO_PT_LST_IDX on MON_DEF_TO_PART (IVK_TO_PT_ID_);
create index RP_TO_PT_LST_IDX on MON_DEF_TO_PART (RP_TO_PT_ID_);
alter table MON_DEF_TO_PART add constraint RP_TO_PT_LST_FK foreign key (RP_TO_PT_ID_) references MON_DEF_ACTIVITY;
alter table MON_DEF_TO_PART add constraint IVK_TO_PT_LST_FK foreign key (IVK_TO_PT_ID_) references MON_DEF_ACTIVITY;
create index SCOPE_DEF_VAR_IDX on MON_DEF_VAR (SCOPE_ID_);
alter table MON_DEF_VAR add constraint SCOPE_DEF_VAR_FK foreign key (SCOPE_ID_) references MON_DEF_ACTIVITY;
create index SCOPE_DEF_CS_IDX on MON_DEF_VAR_CS (SCOPE_ID_);
alter table MON_DEF_VAR_CS add constraint SCOPE_DEF_CS_FK foreign key (SCOPE_ID_) references MON_DEF_ACTIVITY;
create index CORR_ST_DEF_IDX on MON_DEF_VAR_CS_properties (CORR_ST_DEF_ID_);
alter table MON_DEF_VAR_CS_properties add constraint CORR_ST_DEF_FK foreign key (CORR_ST_DEF_ID_) references MON_DEF_VAR_CS;
create index ACT_INST_EXCEPTION_IDX on MON_RUNT_ACTIVITY (LAST_EXCEPTION_);
create index ACT_INST_PARENT_IDK on MON_RUNT_ACTIVITY (PARENT_ACT_INST_ID_);
create index SCOPE_INST_EVT_IDX on MON_RUNT_ACTIVITY (PARENT_SCOPE_ID_);
create index ACT_INST_CHILD_IDX on MON_RUNT_ACTIVITY (CHILD_ACT_INST_ID_);
create index ACT_PROC_INST_UUID_IDX on MON_RUNT_ACTIVITY (INST_UUID_);
create index ACT_INST_FH_IDX on MON_RUNT_ACTIVITY (FH_INST_);
create index ACT_INST_CH_IDX on MON_RUNT_ACTIVITY (CH_INST_);
create index ACT_INST_WAIT_IDX on MON_RUNT_ACTIVITY (CHILD_WAIT_ACT_);
create index ACT_INST_UUID_IDX on MON_RUNT_ACTIVITY (ACT_INST_UUID_);
create index ACT_INST_TH_IDX on MON_RUNT_ACTIVITY (TH_INST_);
alter table MON_RUNT_ACTIVITY add constraint ACT_INST_PARENT_FK foreign key (PARENT_ACT_INST_ID_) references MON_RUNT_ACTIVITY;
alter table MON_RUNT_ACTIVITY add constraint ACT_INST_CH_FK foreign key (CH_INST_) references MON_RUNT_ACTIVITY;
alter table MON_RUNT_ACTIVITY add constraint ACT_INST_TH_FK foreign key (TH_INST_) references MON_RUNT_ACTIVITY;
alter table MON_RUNT_ACTIVITY add constraint ACT_INST_FH_FK foreign key (FH_INST_) references MON_RUNT_ACTIVITY;
alter table MON_RUNT_ACTIVITY add constraint ACT_INST_EXCEPTION_FK foreign key (LAST_EXCEPTION_) references MON_RUNT_BPEL_FAULT_;
alter table MON_RUNT_ACTIVITY add constraint ACT_INST_WAIT_FK foreign key (CHILD_WAIT_ACT_) references MON_RUNT_WAITING;
alter table MON_RUNT_ACTIVITY add constraint ACT_INST_CHILD_FK foreign key (CHILD_ACT_INST_ID_) references MON_RUNT_ACTIVITY;
alter table MON_RUNT_ACTIVITY add constraint SCOPE_INST_EVT_FK foreign key (PARENT_SCOPE_ID_) references MON_RUNT_ACTIVITY;
create index SCOPE_INST_CS_IDX on MON_RUNT_CS_INIT (SCOPE_ID_);
alter table MON_RUNT_CS_INIT add constraint SCOPE_INST_CS_FK foreign key (SCOPE_ID_) references MON_RUNT_ACTIVITY;
create index CS_INST_PROP_IDX on MON_RUNT_CS_PROP (CS_ID_);
alter table MON_RUNT_CS_PROP add constraint CS_INST_PROP_FK foreign key (CS_ID_) references MON_RUNT_CS_INIT;
create index PROCESS_INST_STATE_IDX on MON_RUNT_INST_STATE (PROCESS_INST_ID_);
alter table MON_RUNT_INST_STATE add constraint PROCESS_INST_STATE_FK foreign key (PROCESS_INST_ID_) references MON_RUNT_ACTIVITY;
create index SCOPE_INST_PLNK_IDX on MON_RUNT_PLNK_UPDATE (SCOPE_ID_);
alter table MON_RUNT_PLNK_UPDATE add constraint SCOPE_INST_PLNK_FK foreign key (SCOPE_ID_) references MON_RUNT_ACTIVITY;
create index IDX_REC_PROC_INST on MON_RUNT_RECORD (INST_UUID_);
create index IDX_REC_ACT_INST on MON_RUNT_RECORD (ACT_INST_UUID_);
create index IDX_REC_PROC_DEF on MON_RUNT_RECORD (PROCESS_UUID_);
create index SCOPE_INST_STATE_IDX on MON_RUNT_SCOPE_STATE (SCOPE_ID_);
alter table MON_RUNT_SCOPE_STATE add constraint SCOPE_INST_STATE_FK foreign key (SCOPE_ID_) references MON_RUNT_ACTIVITY;
create index FLOW_INST_TR_COND_IDX on MON_RUNT_TR_COND_UPD_ (FLOW_ID_);
alter table MON_RUNT_TR_COND_UPD_ add constraint FLOW_INST_TR_COND_FK foreign key (FLOW_ID_) references MON_RUNT_ACTIVITY;
create index SCOPE_INST_VAR_IDX on MON_RUNT_VAR_UPDATE (SCOPE_ID_);
alter table MON_RUNT_VAR_UPDATE add constraint SCOPE_INST_VAR_FK foreign key (SCOPE_ID_) references MON_RUNT_ACTIVITY;
create index PICK_WAIT_IDX on MON_RUNT_WAITING (PICK_ID_);
alter table MON_RUNT_WAITING add constraint PICK_WAIT_FK foreign key (PICK_ID_) references MON_RUNT_ACTIVITY;
create index BPEL_SCOPE_CS_IDX on RUNT_CS_RUNTIME (SCOPE_ID_);
alter table RUNT_CS_RUNTIME add constraint BPEL_SCOPE_CS_FK foreign key (SCOPE_ID_) references RUNT_SCOPE_RUNTIME;
create index IDX_CS_RUN_PROP_CS_ on RUNT_CS_RUN_PROP (CS_ID_);
create index IDX_CS_RUN_PROP_QNAME_ on RUNT_CS_RUN_PROP (QNAME_);
alter table RUNT_CS_RUN_PROP add constraint FK_CS_RUN_PROP_CS_ foreign key (CS_ID_) references RUNT_CS_RUNTIME;
create index IDX_EXEC_PARENT on RUNT_EXECUTION (PARENT_);
create index IDX_EXEC_INST_UUID_ on RUNT_EXECUTION (INSTANCE_UUID_);
create index BPEL_EXEC_FOREACH_IDX on RUNT_EXECUTION (FOREACH_ID_);
create index BPEL_EXEC_WAIT_IDX on RUNT_EXECUTION (WAITING_EXEC_ID_);
create index BPEL_EXEC_SCOPE_IDX on RUNT_EXECUTION (SCOPE_RT_ID_);
create index IDX_EXEC_INSTANCE on RUNT_EXECUTION (INSTANCE_);
alter table RUNT_EXECUTION add constraint BPEL_EXEC_FOREACH_FK foreign key (FOREACH_ID_) references RUNT_FOREACH_RUNTIME;
alter table RUNT_EXECUTION add constraint BPEL_EXEC_SCOPE_FK foreign key (SCOPE_RT_ID_) references RUNT_SCOPE_RUNTIME;
alter table RUNT_EXECUTION add constraint BPEL_EXEC_WAIT_FK foreign key (WAITING_EXEC_ID_) references RUNT_WAIT_EXEC;
alter table RUNT_EXECUTION add constraint FK_EXEC_INSTANCE foreign key (INSTANCE_) references RUNT_EXECUTION;
alter table RUNT_EXECUTION add constraint FK_EXEC_PARENT foreign key (PARENT_) references RUNT_EXECUTION;
create index COUNT_PROCESS_UUID_IDX on RUNT_INST_COUNT (PROCESS_UUID_);
create index IDX_INVOKE_JOB_DATA_ on RUNT_JOB (INVOKE_DATA_);
create index IDX_JOB_DUE_DATE_ on RUNT_JOB (DUEDATE_);
create index IDX_SIG_JOB_DATA_ on RUNT_JOB (SIG_INVOKE_DATA_);
create index IDX_JOB_EXECUTION on RUNT_JOB (EXECUTION_);
create index IDX_JOB_EXCEPT_ on RUNT_JOB (EXCEPTION_);
create index IDX_JOB_PRIORITY_ on RUNT_JOB (PRIORITY_);
alter table RUNT_JOB add constraint FK_INVOKE_JOB_DATA_ foreign key (INVOKE_DATA_) references RUNT_EXEC_INVOKE_DATA;
alter table RUNT_JOB add constraint FK_JOB_EXCEPT_ foreign key (EXCEPTION_) references RUNT_JOB_EXCEPTION_;
alter table RUNT_JOB add constraint FK_SIG_JOB_DATA_ foreign key (SIG_INVOKE_DATA_) references RUNT_SIG_INVOKE_DATA;
alter table RUNT_JOB add constraint FK_JOB_EXECUTION foreign key (EXECUTION_) references RUNT_EXECUTION;
create index BPEL_LINK_EXEC_IDX on RUNT_LINK_RUNTIME (WAITING_EXEC_);
create index BPEL_FLOW_LINK_IDX on RUNT_LINK_RUNTIME (FLOW_RUNTIME_ID_);
alter table RUNT_LINK_RUNTIME add constraint BPEL_LINK_EXEC_FK foreign key (WAITING_EXEC_) references RUNT_EXECUTION;
alter table RUNT_LINK_RUNTIME add constraint BPEL_FLOW_LINK_FK foreign key (FLOW_RUNTIME_ID_) references RUNT_EXECUTION;
create index PENDING_MSG_OP_KEY_IDX on RUNT_PENDING_MESS (OP_KEY_);
create index IDX_MSG_CS_KEY on RUNT_PEND_MSG_CS_KEYS (MSG_ID_);
create index PENDING_MSG_CS_KEY_IDX on RUNT_PEND_MSG_CS_KEYS (KEY_);
alter table RUNT_PEND_MSG_CS_KEYS add constraint FK_MSG_CS_KEY foreign key (MSG_ID_) references RUNT_PENDING_MESS;
create index BPEL_SCOPE_PLK_IDX on RUNT_PL_RUNTIME (SCOPE_ID_);
alter table RUNT_PL_RUNTIME add constraint BPEL_SCOPE_PLK_FK foreign key (SCOPE_ID_) references RUNT_SCOPE_RUNTIME;
create index REPLIER_SCOPE_IDX on RUNT_REPLIER (SCOPE_RUNTIME_);
alter table RUNT_REPLIER add constraint REPLIER_SCOPE_FK foreign key (SCOPE_RUNTIME_) references RUNT_SCOPE_RUNTIME;
create index SR_EXCEPTION_IDX on RUNT_SCOPE_RUNTIME (LAST_EXCEPTION_);
create index BPEL_SR_PARENT_IDX on RUNT_SCOPE_RUNTIME (PARENT_);
create index SR_COMP_EXEC_IDX on RUNT_SCOPE_RUNTIME (COMPENSATE_EXEC_);
alter table RUNT_SCOPE_RUNTIME add constraint SR_EXCEPTION_FK foreign key (LAST_EXCEPTION_) references RUNT_BPEL_FAULT_;
alter table RUNT_SCOPE_RUNTIME add constraint SR_COMP_EXEC_FK foreign key (COMPENSATE_EXEC_) references RUNT_EXECUTION;
alter table RUNT_SCOPE_RUNTIME add constraint BPEL_SR_PARENT_FK foreign key (PARENT_) references RUNT_SCOPE_RUNTIME;
create index BPEL_SCOPE_VAR_IDX on RUNT_VAR_RUNTIME (SCOPE_ID_);
alter table RUNT_VAR_RUNTIME add constraint BPEL_SCOPE_VAR_FK foreign key (SCOPE_ID_) references RUNT_SCOPE_RUNTIME;
create index WAIT_EXEC_EXEC_IDX on RUNT_WAIT_EXEC (EXEC_ID_);
alter table RUNT_WAIT_EXEC add constraint WAIT_EXEC_EXEC_FK foreign key (EXEC_ID_) references RUNT_EXECUTION;
create index WAIT_EXEC_CS_IDX on RUNT_WAIT_EXEC_CS_ (CS_ID_);
create index IDX_WAIT_CS on RUNT_WAIT_EXEC_CS_ (WAIT_ID_);
alter table RUNT_WAIT_EXEC_CS_ add constraint FK_WAIT_CS foreign key (WAIT_ID_) references RUNT_WAIT_EXEC;
alter table RUNT_WAIT_EXEC_CS_ add constraint WAIT_EXEC_CS_FK foreign key (CS_ID_) references RUNT_CS_RUNTIME;
create index IDX_WAIT_CS_KEY on RUNT_WAIT_EXEC_CS_KEYS (WAIT_ID_);
create index WAIT_EXEC_CS_KEY_IDX on RUNT_WAIT_EXEC_CS_KEYS (KEY_);
alter table RUNT_WAIT_EXEC_CS_KEYS add constraint FK_WAIT_CS_KEY foreign key (WAIT_ID_) references RUNT_WAIT_EXEC;
create table BPEL_CORE_SEQS ( sequence_name varchar2(255 char) not null ,  next_val number(19,0), primary key ( sequence_name ) ) ;
create table BPEL_HISTORY_SEQS ( sequence_name varchar2(255 char) not null ,  next_val number(19,0), primary key ( sequence_name ) ) ;
create sequence hibernate_sequence;
