create table BPEL_ACTIVITY_INST (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, dbversion bigint not null, ACT_INST_UUID_ varchar(3999), ACT_DEF_UUID_ varchar(3999), PROCESS_UUID_ varchar(3999), INST_UUID_ varchar(3999), STARTED_DATE_ datetime, ENDED_DATE_ datetime, ACTIVITY_STATE_ varchar(255), LAST_EXCEPTION_ bigint, CHILD_ACT_INST_ID_ bigint, OPERATION_ varchar(255), VARIABLE_ varchar(255), MESSAGE_EXCHANGE_ varchar(255), FH_INST_ bigint, TH_INST_ bigint, CH_INST_ bigint, START_VALUE_ integer, STOP_VALUE_ integer, COMPLETION_CONDITION_VALUE_ integer, CHILD_WAIT_ACT_ bigint, PARENT_ACT_INST_ID_ bigint, INDEX_ integer, PARENT_SCOPE_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table BPEL_BASE_ACTIVITY_DEF (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, dbversion bigint not null, ACT_DEF_UUID_ varchar(3999), PROCESS_DEF_UUID_ varchar(3999), NAME_ varchar(255), SUPPR_JN_FL_ bit, TGT_JN_CDT_EXP_LG_ varchar(255), TGT_JN_CDT_BLN_LG_ varchar(255), CHILD_ACT_DEF_ID_ bigint, FAULT_NAME_NS_URI_ varchar(255), FAULT_NAME_LOCAL_ varchar(255), FAULT_MESSAGE_TYPE_NS_URI_ varchar(255), FAULT_MESSAGE_TYPE_LOCAL_ varchar(255), FAULT_ELEMENT_NS_URI_ varchar(255), FAULT_ELEMENT_LOCAL_ varchar(255), faultVariable varchar(255), EX_ON_STA_FAULT_ bit, TERMINATION_HANDLER_ bigint, COMPENSATION_HANDLER_ bigint, NAMESPACE_ varchar(255), EXPR_LANG_ varchar(255), QUERY_LANG_ varchar(255), DPLY_DATE_ datetime, UNDPLY_DATE datetime, STATE_ varchar(255), TARGET_ varchar(255), IVK_PRTLNK_ varchar(255), IVK_IN_VAR_ varchar(255), IVK_OUT_VAR_ varchar(255), IVK_OPERATION_ varchar(255), IVK_PRT_PT_NS_URI_ varchar(255), IVK_PRT_PT_LOCAL_ varchar(255), PT_NS_URI_ varchar(255), PT_LOCAL_ varchar(255), FAULT_VARIABLE_ varchar(255), WHL_EXP_LANG_ varchar(255), WHL_BOOL_EXP_ varchar(255), RPU_EXP_LANG_ varchar(255), RPU_BOOL_EXP_ varchar(255), REC_CRT_INST_ bit, REC_VAR_ varchar(255), REC_PARTN_LNK_ varchar(255), REC_OPERATION_ varchar(255), REC_MSG_EXCHNG_ varchar(255), REC_PRT_PT_NS_URI_ varchar(255), REC_PRT_PT_LOCAL_ varchar(255), REP_VAR_ varchar(255), REP_PARTN_LNK_ varchar(255), REP_OPERATION_ varchar(255), REP_MSG_EXCHNG_ varchar(255), REP_PRT_PT_NS_URI_ varchar(255), REP_PRT_PT_LOCAL_ varchar(255), REP_FLT_NM_NS_URI_ varchar(255), REP_FLT_NM_LOCAL_ varchar(255), ASSIGN_VLDT_ bit, FOR_EXPR_LANG_ varchar(255), FOR_DUR_LANG_ varchar(255), UNTIL_EXPR_LANG_ varchar(255), UNTIL_DEAD_LANG_ varchar(255), IF_EXPR_LANG_ varchar(255), IF_EXPR_ varchar(255), ELSE_ACT_DEF_ID_ bigint, ELSE_ACT_UUID_ varchar(3999), PK_DF_CR_INST_ bit, FRCH_C_N_EXPR_ varchar(255), FRCH_PARLLL_EXPR_ bit, FRCH_FINL_EXPR_ varchar(255), FRCH_FINL_EXPR_LG_ varchar(255), FRCH_STRT_EXPR_ varchar(255), FRCH_STRT_EXPR_LG_ varchar(255), FRCH_CD_EXPR_ varchar(255), FRCH_CD_EXPR_LG_ varchar(255), FRCH_CD_SUCC_ bit, PARENT_ACT_DEF_ID_ bigint, INDEX_ integer, SCOPE_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table BPEL_FAULT_ (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, FAULT_NS_URI_ varchar(255), FAULT_LOCAL_ varchar(255), ELT_ longtext, primary key (DBID_)) ENGINE=InnoDB;
create table BPEL_FAULT_MSG_PART (PENDING_ID_ bigint not null, ELT_ longtext, PART_NAME_ varchar(255) not null, primary key (PENDING_ID_, PART_NAME_)) ENGINE=InnoDB;
create table BPEL_PROC_COMMON_CS_ (PROCESS_ID_ bigint not null, CS_ID_ bigint not null) ENGINE=InnoDB;
create table COPY_FULL_IMPL (DBID_ bigint not null auto_increment, KEEP_SRC_ELT_NAME bit, COPY_LST_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table CORR_DEF_ (DBID_ bigint not null auto_increment, SETVALUE_ varchar(255), INITIATE_ varchar(255), ON_MSG_CORR_ID_ bigint, INDEX_ integer, ON_EVT_CORR_ID_ bigint, IVK_CR_DEF_ID_ bigint, REC_CR_DEF_ID_ bigint, RP_CR_DEF_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table CS_INIT_FULL_IMPL (DBID_ bigint not null auto_increment, ACT_INST_UUID_ varchar(3999), DATE_ datetime, NAME_ varchar(255), SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table CS_PROPERTIES_ (CS_ID_ bigint not null, elt bigint not null, NAME_NS_ varchar(255) not null, NAME_LOCAL_ varchar(255) not null, primary key (CS_ID_, NAME_NS_, NAME_LOCAL_)) ENGINE=InnoDB;
create table ELSEIF_DEF_ (DBID_ bigint not null auto_increment, ELSEIF_EXPR_ varchar(255), ELSEIF_EXPR_LANG_ varchar(255), ELSEIF_ACT_DEF_ID_ bigint, ELSEIF_ACT_UUID_ varchar(3999), IF_ELSEIF_LST_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table FRM_PRT_DEF_ (DBID_ bigint not null auto_increment, FP_PART_ varchar(255), FP_TO_VAR_ varchar(255), ON_MSG_FRM_PRT_ID_ bigint, INDEX_ integer, ON_EVT_FRM_PRT_ID_ bigint, IVK_FR_PT_ID_ bigint, REC_FR_PT_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table FROM_TO_FULL (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, FT_VARIANT_ varchar(255), FT_EXP_LANG_ varchar(255), FT_VARIABLE_ varchar(255), FT_PART_ varchar(255), FT_PARTNER_LINK_ varchar(255), FT_ENDPOINT_REF_ varchar(255), FT_PROP_NS_URI_ varchar(255), FT_PROP_LOCAL_ varchar(255), FT_EXPRESSION_ varchar(255), FT_QUERY_ varchar(255), FT_QUERY_LANG_ varchar(255), LITRL_VALUE_ varchar(3999), FROM_LST_ID_ bigint, INDEX_ integer, TO_LST_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table INVOKE_IN_MSG_PART (INVOKE_JOB_ID_ bigint not null, ELT_ longtext, PART_NAME_ varchar(255) not null, primary key (INVOKE_JOB_ID_, PART_NAME_)) ENGINE=InnoDB;
create table INVOKE_OUT_MSG_PART (INVOKE_JOB_ID_ bigint not null, ELT_ longtext, PART_NAME_ varchar(255) not null, primary key (INVOKE_JOB_ID_, PART_NAME_)) ENGINE=InnoDB;
create table NOVA_ACTIVITY (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, NAME_ varchar(255), UUID_ varchar(3999), CHILD_NODE_ bigint, FAULT_NS_URI_ varchar(255), FAULT_LOCAL_ varchar(255), catchVariableDefinition bigint, SCOPE_NODE_ bigint, DEL_JOIN_FAIL_ bit, EXEC_SRC_ASYNC bit, SCOPE_ bigint, TARG_JOIN_COND_ bigint, PARTNER_LINK_ varchar(255), OPERATION_NAME_ varchar(255), IN_VAR_NAME_ varchar(255), OUT_VAR_NAME_ varchar(255), ONE_WAY_ bit, PT_NS_URI_ varchar(255), PT_LOCAL_ varchar(255), ANON_OUT_MESS_ bigint, ANON_IN_MESS_ bigint, MSG_EXCHANGE_ varchar(255), CREATE_INST_ bit, OP_KEY_ bigint, VALIDATE_ bit, ISOLATED_ bit, EXIT_ON_FAULT_ bit, NODE_ bigint, COND_ bigint, ACTIVITY_ bigint, ELSE_ACTIVITY_ bigint, COUNTER_NAME_ varchar(255), PARALLEL_ bit, SUC_BRANCHES_ bit, START_COUNT_ bigint, FINAL_COUNT_ bigint, COMPL_COND_ bigint, DURATION_ bigint, DEADLINE_ bigint, FAULT_VAR_ varchar(255), TARGET_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_ARGDESCRIPTOR (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, TYPENAME_ varchar(255), DESCRIPTOR_ bigint, OBJDESCR_ bigint, OBJDESCR_IDX_ integer, OPER_ bigint, OPER_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_BLOB_CHOPS (BLOB_ID_ bigint not null, CHOP_VALUE_ tinyblob, CHOP_INDEX_ integer not null, primary key (BLOB_ID_, CHOP_INDEX_)) ENGINE=InnoDB;
create table NOVA_BPEL_EXEC (DBID_ bigint not null, STARTED_DATE_ datetime, INSTANCE_UUID_ varchar(3999), ACTIVITY_UUID_ varchar(3999), INSTANCE_STATE_ varchar(255), PROCESS_ bigint, PARENT_ bigint, INSTANCE_ bigint, FLOW_RT_ID_ bigint, FOREACH_ID_ bigint, SCOPE_RT_ID_ bigint, UUID_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_BPEL_PROCESS (DBID_ bigint not null, PROCESS_UUID_ varchar(3999), QUERY_LANG_ varchar(255), EXPR_LANG_ varchar(255), DEL_JOIN_FAIL_ bit, EXIT_ON_FAULT_ bit, TARGET_NS_ varchar(255), WSDL_INFOS_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_BPEL_TESTS (ACTIVITY_ID_ bigint not null, event varchar(255), varNames tinyblob, plnkNames tinyblob, primary key (ACTIVITY_ID_)) ENGINE=InnoDB;
create table NOVA_BPEL_VARIABLE (DBID_ bigint not null, MSGTYPE_NS_URI_ varchar(255), MSGTYPE_LOCAL_ varchar(255), TYPE_NS_URI_ varchar(255), TYPE_LOCAL_ varchar(255), ELT_NS_URI_ varchar(255), ELT_LOCAL_ varchar(255), VIRTUAL_COPY_ bigint, SCOPE_ID_ bigint, VAR_NAME_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_CLOB_CHOPS (CLOB_ID_ bigint not null, CHOP_VALUE_ varchar(255), CHOP_INDEX_ integer not null, primary key (CLOB_ID_, CHOP_INDEX_)) ENGINE=InnoDB;
create table NOVA_COMMENT (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, DBVERSION_ integer not null, USERID_ varchar(255), TIME_ datetime, MESSAGE_ varchar(255), PARENT_ bigint, PARENT_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_COPY_ELT (DBID_ bigint not null auto_increment, KEEP_SRC_ELT_ bit, IGNORE_MISS_DATA_ bit, FROM_ bigint, TO_ bigint, INVOKE_IN_ID_ bigint, INDEX_ integer, INVOKE_OUT_ID_ bigint, REPLY_ID_ bigint, RECEIVE_IN_ID_ bigint, ASSIGN_ID_ bigint, ASSIGN_INDEX_ integer, ON_MSG_IN_ID_ bigint, ON_EVT_IN_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_CORREL (DBID_ bigint not null auto_increment, INITIATE_ varchar(255), CS_ bigint, INVOKE_REQ_ID_ bigint, INVOKE_RES_ID_ bigint, REPLY_ID_ bigint, RECEIVE_ID_ bigint, ON_MSG_ID_ bigint, ON_EVT_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_CS (DBID_ bigint not null auto_increment, NAME_ varchar(255), SCOPE_ID_ bigint, CS_NAME_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_CS_INST_PROP (CS_ID_ bigint not null, VALUE_ longtext, QNAME_NS_ varchar(255) not null, QNAME_LOCAL_ varchar(255) not null, primary key (CS_ID_, QNAME_NS_, QNAME_LOCAL_)) ENGINE=InnoDB;
create table NOVA_CS_RUNTIME (DBID_ bigint not null auto_increment, ACT_INST_UUID_ varchar(3999), NAME_ varchar(255), INITIALIZED_ bit, CS_DEF_ bigint, SCOPE_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_CS_RUN_PROP (CS_ID_ bigint not null, VALUE_ longtext, QNAME_NS_ varchar(255) not null, QNAME_LOCAL_ varchar(255) not null, primary key (CS_ID_, QNAME_NS_, QNAME_LOCAL_)) ENGINE=InnoDB;
create table NOVA_DESCRIPTOR (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, DBVERSION_ integer not null, NAME_ varchar(255), INIT_ char(1), TEXT_ varchar(255), DOUBLEVAL_ double precision, LONGVAL_ bigint, CLASSNAME_ varchar(255), METHOD_ varchar(255), BOOLVAL_ bit, FACTORYNAME_ varchar(255), FACTORYDESCR_ bigint, VALUEDESCR_ bigint, VALUEDESCR_IDX_ integer, KEYDESCR_ bigint, KEYDESCR_IDX_ integer, PROPS_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_ELSE_IF (IF_ID_ bigint not null, CONDITION_ bigint, ACTIVITY_ bigint, INDEX_ integer not null, primary key (IF_ID_, INDEX_)) ENGINE=InnoDB;
create table NOVA_EVENT (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, PROCESSDEF_ bigint, PROPS_ bigint, NAME_ varchar(255), PROCESS_ bigint, NODE_ bigint, TRANSITION_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_EXCEPTHNDLR (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, DBVERSION_ integer not null, EXCEPT_CLASS_ varchar(255), TRANSACT_ bit, RETHROW_MASKED_ bit, TRANSITIONNAME_ varchar(255), NODENAME_ varchar(255), PROCESS_ bigint, PROCESS_IDX_ integer, NODE_ bigint, NODE_IDX_ integer, TRANSITION_ bigint, TRANSITION_IDX_ integer, EVENT_ bigint, EVENT_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_EXECUTION (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, NODE_ bigint, PREV_NODE_ bigint, PREV_TRANS_ bigint, HASVARS_ bit, NAME_ varchar(255), KEY_ varchar(255), ID_ varchar(255) unique, STATE_ varchar(255), PRIORITY_ integer, NEXTLOGIDX_ integer, PROCESS_ bigint, TRANSITION_ bigint, TRANSORIG_ bigint, PARENT_ bigint, INSTANCE_ bigint, SUPEREXEC_ bigint, PARENT_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_FLOW_RUNTIME (DBID_ bigint not null auto_increment, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_FOREACH_RUNTIME (DBID_ bigint not null auto_increment, COUNTER_START_ integer, COUNTER_FINAL_ integer, COUNTER_CURRENT_ integer, COMPL_VALUE_ integer, ONLY_SUCCESS_ bit, BRANCH_COUNT_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_FROM_PART (DBID_ bigint not null auto_increment, PART_ varchar(255), TO_VAR_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_FROM_TO_ELT (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, VARIANT_ varchar(255), EXP_LANG_ varchar(255), VARIABLE_ varchar(255), PART_ varchar(255), PARTNER_LINK_ varchar(255), ENDPOINT_REF_ varchar(255), PROP_NS_URI_ varchar(255), PROP_LOCAL_ varchar(255), VAR_QUERY_ bigint, PROP_QUERY_ bigint, EXPRESSION_ bigint, LITERAL_VAL_ longtext, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_INST_WAITING_EXEC (INSTANCE_ID_ bigint not null, EXECUTION_ bigint not null, primary key (INSTANCE_ID_, EXECUTION_)) ENGINE=InnoDB;
create table NOVA_JOB (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, DBVERSION_ integer not null, DUEDATE_ datetime, ISSUSPENDED_ bit, ISEXCLUSIVE_ bit, LOCKOWNER_ varchar(255), LOCKEXPTIME_ datetime, EXCEPTION_ longtext, RETRIES_ integer, PROCESSINSTANCE_ bigint, EXECUTION_ bigint, CMDDESCR_ bigint, SIGNAL_ varchar(255), NODE_ bigint, EVENT_ varchar(255), REPEAT_ varchar(255), PROCESS_NS_URI_ varchar(255), PROCESS_LOCAL_ varchar(255), IS_EXECUTING_ bit, OP_KEY_ bigint, ENDPOINT_ longtext, FAULT_NS_URI_ varchar(255), FAULT_LOCAL_ varchar(255), INVOKE_EXCEPTION_ longtext, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_LINK (DBID_ bigint not null auto_increment, NAME_ varchar(255), SOURCE_ACTIVITY_ bigint, TARGET_ACTIVITY_ bigint, FLOW_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_LINK_RUNTIME (DBID_ bigint not null auto_increment, STATUS_ bit, WAITING_EXEC_ bigint, NAME_ varchar(255), ACT_INST_UUID_ varchar(3999), FLOW_RUNTIME_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_NAMESPACE (DBID_ bigint not null auto_increment, URI_ varchar(255), PREFIX_ varchar(255), SNIPPET_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_NODE (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, PROCESS_ bigint, PROPS_ bigint, NAME_ varchar(255), DESCR_ varchar(255), HAS_VAR_DEF_ bit, HAS_TIMER_DEF_ bit, LOCAL_SCOPE_ bit, EXEC_ASYNC_ bit, SIGNAL_ASYNC_ bit, PREV_NEEDED_ bit, PARENT_ bigint, DEFTRANS_ bigint, BEHAV_DESCR_ bigint, BEHAV_CLASS_ varchar(255), BEHAV_ID_ bigint, NODESPROCESS_ bigint, NODESPROCESS_IDX_ integer, PARENT_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_OBJECTREF (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, DBVERSION_ integer not null, OBJ_DESCR_ bigint, OBJ_CLASS_ varchar(255), OBJ_ID_ bigint, OBJ_EXPRESSION_ varchar(255), OBJ_EXPRLANG_ varchar(255), PROPAGATE_ bit, EVENT_ bigint, EVENT_IDX_ integer, EXHNDLR_ bigint, EXHNDLR_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_ON_ALARM (DBID_ bigint not null auto_increment, UUID_ varchar(255), DURATION_ bigint, DEADLINE_ bigint, REPEAT_ bigint, ACTIVITY_ bigint, ACTIVITY_ID_ bigint, PICK_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_ON_EVT (DBID_ bigint not null auto_increment, PARTNER_LINK_ varchar(255), IN_VAR_NAME_ varchar(255), MSG_EXCHANGE_ varchar(255), ANON_IN_MESS_ bigint, OP_KEY_ bigint, ACTIVITY_ bigint, ACTIVITY_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_ON_MSG (DBID_ bigint not null auto_increment, PARTNER_LINK_ varchar(255), IN_VAR_NAME_ varchar(255), MSG_EXCHANGE_ varchar(255), ANON_IN_MESS_ bigint, OP_KEY_ bigint, ACTIVITY_ bigint, PICK_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_OPERATION (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, DBVERSION_ integer not null, TEXT_ varchar(255), FIELDDESCR_ bigint, PROPDESCR_ bigint, OBJDESCR_ bigint, OBJDESCR_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_OP_KEY (DBID_ bigint not null auto_increment, PT_NS_URI_ varchar(255), PT_LOCAL_ varchar(255), PROCESS_NS_URI_ varchar(255), PROCESS_LOCAL_ varchar(255), OPERATION_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_PENDING_MESS (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, MSG_CARRIER_ID_ varchar(255), RECEIVER_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_PENDING_MSG_PART (PENDING_ID_ bigint not null, ELT_ longtext, PART_NAME_ varchar(255) not null, primary key (PENDING_ID_, PART_NAME_)) ENGINE=InnoDB;
create table NOVA_PLNK (DBID_ bigint not null auto_increment, NAME_ varchar(255), MYROLEPT_NS_URI_ varchar(255), MYROLEPT_LOCAL_ varchar(255), PARTROLEPT_NS_URI_ varchar(255), PARTROLEPT_LOCAL_ varchar(255), SCOPE_ID_ bigint, PLNK_NAME_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_PLNKTYPE (DBID_ bigint not null auto_increment, NAME_NS_ varchar(255), NAME_LOCAL_ varchar(255), WSDLINFOS_ID_ bigint, PLNK_NS_ varchar(255), PLNK_LOCAL_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_PLNKT_ROLES (PLNKTYPE_ID_ bigint not null, PT_NS_ varchar(255), PT_LOCAL_ varchar(255), ROLE_NAME_ varchar(255) not null, primary key (PLNKTYPE_ID_, ROLE_NAME_)) ENGINE=InnoDB;
create table NOVA_PL_RUNTIME (DBID_ bigint not null auto_increment, ACT_INST_UUID_ varchar(3999), NAME_ varchar(255), PL_DEF_ bigint, P_END_REF longtext, MY_END_REF longtext, SCOPE_RUN_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_PROCESS (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, PROPS_ bigint, NAME_ varchar(255), DESCR_ varchar(255), HAS_VAR_DEF_ bit, HAS_TIMER_DEF_ bit, KEY_ varchar(255), ID_ varchar(255) unique, PACKAGE_ varchar(255), VERSION_ integer, DEPLOYED_ datetime, INITIAL_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_PROCESS_START (BPEL_PROCESS_ bigint not null, elt bigint not null, PT_NS_URI_ varchar(255) not null, PT_LOCAL_ varchar(255) not null, PROCESS_NS_URI_ varchar(255) not null, PROCESS_LOCAL_ varchar(255) not null, OPERATION_ varchar(255) not null, primary key (BPEL_PROCESS_, PT_NS_URI_, PT_LOCAL_, PROCESS_NS_URI_, PROCESS_LOCAL_, OPERATION_)) ENGINE=InnoDB;
create table NOVA_PROPALIAS (DBID_ bigint not null auto_increment, PROP_PART_ varchar(255), PROP_NS_ varchar(255), PROP_LOCAL_ varchar(255), MSGTYPE_NS_ varchar(255), MSGTYPE_LOCAL_ varchar(255), TYPE_NS_ varchar(255), TYPE_LOCAL_ varchar(255), ELT_NS_ varchar(255), ELT_LOCAL_ varchar(255), QUERY_ bigint, WSDLINFOS_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_RECEIVER (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, OP_KEY_ bigint, BPEL_PROCESS_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_REPLIER (DBID_ bigint not null auto_increment, MSG_EXCHG_ varchar(255), OP_KEY_ID_ bigint, SCOPE_RUNTIME_ bigint, BPEL_INSTANCE_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_SCOPE_MESSEXS (SCOPE_ID_ bigint not null, MESSEX_NAME_ varchar(255)) ENGINE=InnoDB;
create table NOVA_SCOPE_RUNTIME (DBID_ bigint not null auto_increment, UUID_ varchar(255), ACTIVITY_UUID_ varchar(3999), SCOPE_DEF_ bigint, SCOPE_STATE_ tinyblob, LAST_EXCEPTION_ bigint, COMPENSATE_EXEC_ bigint, PARENT_ bigint, PARENT_INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_SCOPE_VARINIT (SCOPE_ID_ bigint not null, VAR_NAME_ varchar(255)) ENGINE=InnoDB;
create table NOVA_SNIPPET (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, TXT_ varchar(255), LANG_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_SOURCE (DBID_ bigint not null auto_increment, LINK_NAME_ varchar(255), LINK_ bigint, TRANS_COND_ bigint, ACTIVITY_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_STYLESHEET (PROCESS_ID_ bigint not null, CONTENT_ longblob, STYLE_SHEET_ varchar(255) not null, primary key (PROCESS_ID_, STYLE_SHEET_)) ENGINE=InnoDB;
create table NOVA_TARGET (DBID_ bigint not null auto_increment, LINK_NAME_ varchar(255), LINK_ bigint, ACTIVITY_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_TIMERDEF (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, DUEDATEDESCR_ varchar(255), REPEAT_ varchar(255), ISEXCL_ bit, RETRIES_ integer, EVENT_ varchar(255), SIGNAL_ varchar(255), DUEDATE_ datetime, PROCESS_ bigint, NODE_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_TO_PART (DBID_ bigint not null auto_increment, PART_ varchar(255), FROM_VAR_ varchar(255), primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_TRANSITION (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, PROCESS_ bigint, PROPS_ bigint, NAME_ varchar(255), DESCR_ varchar(255), SRC_ bigint, DEST_ bigint, COND_DESCR_ bigint, TAKEASYNC_ bit, DESTINATION_ bigint, IN_IDX_ integer, SOURCE_ bigint, OUT_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_VARIABLE (DBID_ bigint not null auto_increment, CLASS_ varchar(255) not null, DBVERSION_ integer not null, KEY_ varchar(255), QUERYTEXT_ varchar(255), CONVERTER_ varchar(255), PROCINST_ bigint, DATE_VALUE_ datetime, DOUBLE_VALUE_ double precision, LONG_VALUE_ bigint, STRING_VALUE_ varchar(255), BLOB_VALUE_ longblob, BINARY_VALUE_ tinyblob, CLOB_VALUE_ longtext, TEXT_VALUE_ longtext, EXECUTION_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_VARIABLEDEF (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, KEY_ varchar(255), DESCR_ varchar(255), SRC_ varchar(255), SRCEXPR_ varchar(255), SRCDESCR_ bigint, DEST_ varchar(255), DESTEXPR_ varchar(255), TYPE_VARCLASS_ varchar(255), TYPE_CONVERTER_ varchar(255), PROCESS_ bigint, PROCESS_IDX_ integer, NODE_ bigint, NODE_IDX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_VAR_MSG_PART (VAR_ID_ bigint not null, ELT_ longtext, PART_NAME_ varchar(255) not null, primary key (VAR_ID_, PART_NAME_)) ENGINE=InnoDB;
create table NOVA_VAR_MSG_PART2 (VAR_ID_ bigint not null, ELT_ longtext, PART_NAME_ varchar(255) not null, primary key (VAR_ID_, PART_NAME_)) ENGINE=InnoDB;
create table NOVA_VAR_RUNTIME (DBID_ bigint not null auto_increment, ACT_INST_UUID_ varchar(3999), NAME_ varchar(255), XML_VALUE_ longtext, VAR_RUNT_VAR_DEF_ bigint, SCOPE_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_WAITING_EXEC (RECEIVER_ID_ bigint not null, EXEC_ID_ bigint not null, primary key (RECEIVER_ID_, EXEC_ID_)) ENGINE=InnoDB;
create table NOVA_WIREPROPS (DBID_ bigint not null auto_increment, DBVERSION_ integer not null, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_WSDLINFOS (DBID_ bigint not null auto_increment, primary key (DBID_)) ENGINE=InnoDB;
create table NOVA_WSDL_PROPERTY (DBID_ bigint not null auto_increment, ELT_NS_ varchar(255), ELT_LOCAL_ varchar(255), NAME_NS_ varchar(255), NAME_LOCAL_ varchar(255), TYPE_NS_ varchar(255), TYPE_LOCAL_ varchar(255), WSDLINFOS_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table ON_ALRM_DEF_ (DBID_ bigint not null auto_increment, ON_ALRM_ACT_DEF_ID_ bigint, ON_ALRM_ACT_UUID_ varchar(3999), FOR_EXPR_LANG_ varchar(255), FOR_DUR_LANG_ varchar(255), UNTIL_EXPR_LANG_ varchar(255), UNTIL_DEAD_LANG_ varchar(255), REPETE_EXPR_LANG_ varchar(255), REPEAT_DEAD_LANG_ varchar(255), SCOPE_ID_ bigint, INDEX_ integer, PK_DF_ON_AL_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table ON_EVT_DEF_ (DBID_ bigint not null auto_increment, PICK_VAR_ varchar(255), PICK_PART_LNK_ varchar(255), PICK_OPTN_ varchar(255), PICK_MSG_EXCHG_ varchar(255), PICK_PT_TP_NS_URI_ varchar(255), PICK_PT_TP_LOCAL_ varchar(255), ON_EVT_ACT_DEF_ID_ bigint, ON_EVT_ACT_UUID_ varchar(3999), SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table ON_MSG_DEF_ (DBID_ bigint not null auto_increment, PICK_VAR_ varchar(255), PICK_PART_LNK_ varchar(255), PICK_OPTN_ varchar(255), PICK_MSG_EXCHG_ varchar(255), PICK_PT_TP_NS_URI_ varchar(255), PICK_PT_TP_LOCAL_ varchar(255), ON_MSG_ACT_DEF_ID_ bigint, ON_MSG_ACT_UUID_ varchar(3999), PK_DF_ON_MSG_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table PART_LNK_DEF_ (DBID_ bigint not null auto_increment, NAME_ varchar(255), MY_ROLE_ varchar(255), PARTNER_ROLE_ varchar(255), INIT_PRTN_ROLE_ bit, PRT_LNK_NS_URI_ varchar(255), PRT_LNK_LOCAL_ varchar(255), SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table PLNK_UPDATE_FULL_IMPL (DBID_ bigint not null auto_increment, ACT_INST_UUID_ varchar(3999), DATE_ datetime, NAME_ varchar(255), P_END_REF longtext, PLNK_UPD_TYPE_ varchar(255), SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table PROCESS_INST_STATE_UPDATE_ (DBID_ bigint not null auto_increment, DATE_ datetime, STATE_ varchar(255), PROCESS_INST_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table SCOPE_STATE_UPDATE_ (DBID_ bigint not null auto_increment, ACT_INST_UUID_ varchar(3999), DATE_ datetime, STATE_ varchar(255), SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table SRC_FULL_IMPL (DBID_ bigint not null auto_increment, LNK_NAME varchar(255), TR_CND_EXP_LG varchar(255), TR_CND_BOL_EXP varchar(255), SRC_LST_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table TGT_FULL_IMPL (DBID_ bigint not null auto_increment, LNK_NAME varchar(255), TRGT_LST_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table TO_PRT_DEF_ (DBID_ bigint not null auto_increment, TP_PART_ varchar(255), TP_FRM_VAR_ varchar(255), IVK_TO_PT_ID_ bigint, INDEX_ integer, RP_TO_PT_ID_ bigint, primary key (DBID_)) ENGINE=InnoDB;
create table TR_COND_UPD_ (DBID_ bigint not null auto_increment, STATUS_ bit, NAME_ varchar(255), DATE_ datetime, FLOW_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table VAR_DEF_ (DBID_ bigint not null auto_increment, MSGTYPE_NS_URI_ varchar(255), MSGTYPE_LOCAL_ varchar(255), TYPE_NS_URI_ varchar(255), TYPE_LOCAL_ varchar(255), ELT_NS_URI_ varchar(255), ELT_LOCAL_ varchar(255), NAME_ varchar(255), SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table VAR_DEF_CS_ (DBID_ bigint not null auto_increment, NAME_ varchar(255), SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table VAR_UPDATE_FULL_IMPL (DBID_ bigint not null auto_increment, ACT_INST_UUID_ varchar(3999), DATE_ datetime, NAME_ varchar(255), XML_VALUE_ longtext, SCOPE_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table WAITING_FULL_IMPL (DBID_ bigint not null auto_increment, EXPECTED_STARTED_DATE_ datetime, PICK_ID_ bigint, INDEX_ integer, primary key (DBID_)) ENGINE=InnoDB;
create table linkList (FLOW_LINKS_ID_ bigint not null, FLOW_LINKS_ varchar(255), INDEX_ integer not null, primary key (FLOW_LINKS_ID_, INDEX_)) ENGINE=InnoDB;
create table messageExchanges (SCOPE_ID_ bigint not null, elt varchar(255), INDEX_ integer not null, primary key (SCOPE_ID_, INDEX_)) ENGINE=InnoDB;
create table properties (CORR_ST_DEF_ID_ bigint not null, PROP_NS_URI_ varchar(255), PROP_LOCAL_ varchar(255), INDEX_ integer not null, primary key (CORR_ST_DEF_ID_, INDEX_)) ENGINE=InnoDB;
create table wsdlDefinitions (WSDLINFOS_ID_ bigint not null, WSDLINFOS_DEF_ longblob) ENGINE=InnoDB;
create index ACT_INST_EXCEPTION_IDX on BPEL_ACTIVITY_INST (LAST_EXCEPTION_);
create index ACT_INST_PARENT_IDK on BPEL_ACTIVITY_INST (PARENT_ACT_INST_ID_);
create index SCOPE_INST_EVT_IDX on BPEL_ACTIVITY_INST (PARENT_SCOPE_ID_);
create index ACT_INST_CHILD_IDX on BPEL_ACTIVITY_INST (CHILD_ACT_INST_ID_);
create index ACT_INST_FH_IDX on BPEL_ACTIVITY_INST (FH_INST_);
create index ACT_INST_CH_IDX on BPEL_ACTIVITY_INST (CH_INST_);
create index ACT_INST_WAIT_IDX on BPEL_ACTIVITY_INST (CHILD_WAIT_ACT_);
create index ACT_INST_TH_IDX on BPEL_ACTIVITY_INST (TH_INST_);
alter table BPEL_ACTIVITY_INST add index ACT_INST_PARENT_FK (PARENT_ACT_INST_ID_), add constraint ACT_INST_PARENT_FK foreign key (PARENT_ACT_INST_ID_) references BPEL_ACTIVITY_INST (DBID_);
alter table BPEL_ACTIVITY_INST add index ACT_INST_CH_FK (CH_INST_), add constraint ACT_INST_CH_FK foreign key (CH_INST_) references BPEL_ACTIVITY_INST (DBID_);
alter table BPEL_ACTIVITY_INST add index ACT_INST_TH_FK (TH_INST_), add constraint ACT_INST_TH_FK foreign key (TH_INST_) references BPEL_ACTIVITY_INST (DBID_);
alter table BPEL_ACTIVITY_INST add index ACT_INST_FH_FK (FH_INST_), add constraint ACT_INST_FH_FK foreign key (FH_INST_) references BPEL_ACTIVITY_INST (DBID_);
alter table BPEL_ACTIVITY_INST add index ACT_INST_EXCEPTION_FK (LAST_EXCEPTION_), add constraint ACT_INST_EXCEPTION_FK foreign key (LAST_EXCEPTION_) references BPEL_FAULT_ (DBID_);
alter table BPEL_ACTIVITY_INST add index ACT_INST_WAIT_FK (CHILD_WAIT_ACT_), add constraint ACT_INST_WAIT_FK foreign key (CHILD_WAIT_ACT_) references WAITING_FULL_IMPL (DBID_);
alter table BPEL_ACTIVITY_INST add index ACT_INST_CHILD_FK (CHILD_ACT_INST_ID_), add constraint ACT_INST_CHILD_FK foreign key (CHILD_ACT_INST_ID_) references BPEL_ACTIVITY_INST (DBID_);
alter table BPEL_ACTIVITY_INST add index SCOPE_INST_EVT_FK (PARENT_SCOPE_ID_), add constraint SCOPE_INST_EVT_FK foreign key (PARENT_SCOPE_ID_) references BPEL_ACTIVITY_INST (DBID_);
create index SCOPE_DEF_FAULT_HANDLERS_IDX on BPEL_BASE_ACTIVITY_DEF (SCOPE_ID_);
alter table BPEL_BASE_ACTIVITY_DEF add index FK90444D19F1C5FAB0 (PARENT_ACT_DEF_ID_), add constraint FK90444D19F1C5FAB0 foreign key (PARENT_ACT_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table BPEL_BASE_ACTIVITY_DEF add index FK90444D1982112BDD (CHILD_ACT_DEF_ID_), add constraint FK90444D1982112BDD foreign key (CHILD_ACT_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table BPEL_BASE_ACTIVITY_DEF add index FK90444D19614874B5 (TERMINATION_HANDLER_), add constraint FK90444D19614874B5 foreign key (TERMINATION_HANDLER_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table BPEL_BASE_ACTIVITY_DEF add index FK90444D19DE3B31AF (COMPENSATION_HANDLER_), add constraint FK90444D19DE3B31AF foreign key (COMPENSATION_HANDLER_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table BPEL_BASE_ACTIVITY_DEF add index FK90444D19D4D0807A (ELSE_ACT_DEF_ID_), add constraint FK90444D19D4D0807A foreign key (ELSE_ACT_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table BPEL_BASE_ACTIVITY_DEF add index SCOPE_DEF_FAULT_HANDLERS_FK (SCOPE_ID_), add constraint SCOPE_DEF_FAULT_HANDLERS_FK foreign key (SCOPE_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index BPEL_FAULT_MSG_PART_IDX on BPEL_FAULT_MSG_PART (PENDING_ID_);
alter table BPEL_FAULT_MSG_PART add index BPEL_FAULT_MSG_PART_FK (PENDING_ID_), add constraint BPEL_FAULT_MSG_PART_FK foreign key (PENDING_ID_) references BPEL_FAULT_ (DBID_);
alter table BPEL_PROC_COMMON_CS_ add index FK4FD7CF5A1E706273 (CS_ID_), add constraint FK4FD7CF5A1E706273 foreign key (CS_ID_) references NOVA_CS (DBID_);
alter table BPEL_PROC_COMMON_CS_ add index FK4FD7CF5AF1DBFC22 (PROCESS_ID_), add constraint FK4FD7CF5AF1DBFC22 foreign key (PROCESS_ID_) references NOVA_BPEL_PROCESS (DBID_);
create index COPY_LST_IDX on COPY_FULL_IMPL (COPY_LST_ID_);
alter table COPY_FULL_IMPL add index COPY_LST_FK (COPY_LST_ID_), add constraint COPY_LST_FK foreign key (COPY_LST_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index RP_CR_DEF_LST_IDX on CORR_DEF_ (RP_CR_DEF_ID_);
create index IVK_CR_DEF_LST_IDX on CORR_DEF_ (IVK_CR_DEF_ID_);
create index ON_MSG_CORR_IDX on CORR_DEF_ (ON_MSG_CORR_ID_);
create index REC_CR_DEF_LST_IDX on CORR_DEF_ (REC_CR_DEF_ID_);
create index ON_EVT_CORR_IDX on CORR_DEF_ (ON_EVT_CORR_ID_);
alter table CORR_DEF_ add index REC_CR_DEF_LST_FK (REC_CR_DEF_ID_), add constraint REC_CR_DEF_LST_FK foreign key (REC_CR_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table CORR_DEF_ add index IVK_CR_DEF_LST_FK (IVK_CR_DEF_ID_), add constraint IVK_CR_DEF_LST_FK foreign key (IVK_CR_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table CORR_DEF_ add index RP_CR_DEF_LST_FK (RP_CR_DEF_ID_), add constraint RP_CR_DEF_LST_FK foreign key (RP_CR_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table CORR_DEF_ add index ON_EVT_CORR_FK (ON_EVT_CORR_ID_), add constraint ON_EVT_CORR_FK foreign key (ON_EVT_CORR_ID_) references ON_EVT_DEF_ (DBID_);
alter table CORR_DEF_ add index ON_MSG_CORR_FK (ON_MSG_CORR_ID_), add constraint ON_MSG_CORR_FK foreign key (ON_MSG_CORR_ID_) references ON_MSG_DEF_ (DBID_);
create index SCOPE_INST_CS_IDX on CS_INIT_FULL_IMPL (SCOPE_ID_);
alter table CS_INIT_FULL_IMPL add index SCOPE_INST_CS_FK (SCOPE_ID_), add constraint SCOPE_INST_CS_FK foreign key (SCOPE_ID_) references BPEL_ACTIVITY_INST (DBID_);
alter table CS_PROPERTIES_ add index FK1DAAEC3D1E706273 (CS_ID_), add constraint FK1DAAEC3D1E706273 foreign key (CS_ID_) references NOVA_CS (DBID_);
alter table CS_PROPERTIES_ add index FK1DAAEC3D2B0757BD (elt), add constraint FK1DAAEC3D2B0757BD foreign key (elt) references NOVA_WSDL_PROPERTY (DBID_);
create index IF_ELSEIF_LST_IDX on ELSEIF_DEF_ (IF_ELSEIF_LST_ID_);
alter table ELSEIF_DEF_ add index IF_ELSEIF_LST_FK (IF_ELSEIF_LST_ID_), add constraint IF_ELSEIF_LST_FK foreign key (IF_ELSEIF_LST_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table ELSEIF_DEF_ add index FK4BC7A7A366DBBFD7 (ELSEIF_ACT_DEF_ID_), add constraint FK4BC7A7A366DBBFD7 foreign key (ELSEIF_ACT_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index IVK_FR_PT_LST_IDX on FRM_PRT_DEF_ (IVK_FR_PT_ID_);
create index ON_MSG_FRM_PRT_IDX on FRM_PRT_DEF_ (ON_MSG_FRM_PRT_ID_);
create index ON_EVT_FRM_PRT_IDX on FRM_PRT_DEF_ (ON_EVT_FRM_PRT_ID_);
create index REC_FR_PT_LST_IDX on FRM_PRT_DEF_ (REC_FR_PT_ID_);
alter table FRM_PRT_DEF_ add index REC_FR_PT_LST_FK (REC_FR_PT_ID_), add constraint REC_FR_PT_LST_FK foreign key (REC_FR_PT_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table FRM_PRT_DEF_ add index IVK_FR_PT_LST_FK (IVK_FR_PT_ID_), add constraint IVK_FR_PT_LST_FK foreign key (IVK_FR_PT_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table FRM_PRT_DEF_ add index ON_MSG_FRM_PRT_FK (ON_MSG_FRM_PRT_ID_), add constraint ON_MSG_FRM_PRT_FK foreign key (ON_MSG_FRM_PRT_ID_) references ON_MSG_DEF_ (DBID_);
alter table FRM_PRT_DEF_ add index ON_EVT_FRM_PRT_FK (ON_EVT_FRM_PRT_ID_), add constraint ON_EVT_FRM_PRT_FK foreign key (ON_EVT_FRM_PRT_ID_) references ON_EVT_DEF_ (DBID_);
create index TO_LST_IDX on FROM_TO_FULL (TO_LST_ID_);
create index FROM_LST_IDX on FROM_TO_FULL (FROM_LST_ID_);
alter table FROM_TO_FULL add index FROM_LST_FK (FROM_LST_ID_), add constraint FROM_LST_FK foreign key (FROM_LST_ID_) references COPY_FULL_IMPL (DBID_);
alter table FROM_TO_FULL add index TO_LST_FK (TO_LST_ID_), add constraint TO_LST_FK foreign key (TO_LST_ID_) references COPY_FULL_IMPL (DBID_);
alter table INVOKE_IN_MSG_PART add index FK402D22A4F1CF451D (INVOKE_JOB_ID_), add constraint FK402D22A4F1CF451D foreign key (INVOKE_JOB_ID_) references NOVA_JOB (DBID_);
alter table INVOKE_OUT_MSG_PART add index FKD6F3446955C3FE6 (INVOKE_JOB_ID_), add constraint FKD6F3446955C3FE6 foreign key (INVOKE_JOB_ID_) references NOVA_JOB (DBID_);
create index IF_COND_IDX on NOVA_ACTIVITY (COND_);
create index IF_ACT_IDX on NOVA_ACTIVITY (ACTIVITY_);
create index ACT_SCOPE_IDX on NOVA_ACTIVITY (SCOPE_);
create index WAIT_DLINE_IDX on NOVA_ACTIVITY (DEADLINE_);
create index ACT_TH_SCOPE_IDX on NOVA_ACTIVITY (SCOPE_NODE_);
create index FOR_FINAL_IDX on NOVA_ACTIVITY (FINAL_COUNT_);
create index FOR_START_IDX on NOVA_ACTIVITY (START_COUNT_);
create index ELSE_ACT_IDX on NOVA_ACTIVITY (ELSE_ACTIVITY_);
create index RECV_IN_MSG_IDX on NOVA_ACTIVITY (ANON_IN_MESS_);
create index ACT_CHILD_IDX on NOVA_ACTIVITY (CHILD_NODE_);
create index FOR_COND_IDX on NOVA_ACTIVITY (COMPL_COND_);
create index ACT_JOIN_COND_IDX on NOVA_ACTIVITY (TARG_JOIN_COND_);
create index REPLY_OUT_IDX on NOVA_ACTIVITY (ANON_OUT_MESS_);
create index WAIT_DUR_IDX on NOVA_ACTIVITY (DURATION_);
alter table NOVA_ACTIVITY add index REPLY_OUT_FK (ANON_OUT_MESS_), add constraint REPLY_OUT_FK foreign key (ANON_OUT_MESS_) references NOVA_BPEL_VARIABLE (DBID_);
alter table NOVA_ACTIVITY add index ELSE_ACT_FK (ELSE_ACTIVITY_), add constraint ELSE_ACT_FK foreign key (ELSE_ACTIVITY_) references NOVA_NODE (DBID_);
alter table NOVA_ACTIVITY add index FOR_START_FK (START_COUNT_), add constraint FOR_START_FK foreign key (START_COUNT_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ACTIVITY add index ACT_SCOPE_FK (SCOPE_), add constraint ACT_SCOPE_FK foreign key (SCOPE_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_ACTIVITY add index IF_ACT_FK (ACTIVITY_), add constraint IF_ACT_FK foreign key (ACTIVITY_) references NOVA_NODE (DBID_);
alter table NOVA_ACTIVITY add index FOR_COND_FK (COMPL_COND_), add constraint FOR_COND_FK foreign key (COMPL_COND_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ACTIVITY add index ACT_CHILD_FK (CHILD_NODE_), add constraint ACT_CHILD_FK foreign key (CHILD_NODE_) references NOVA_NODE (DBID_);
alter table NOVA_ACTIVITY add index WAIT_DLINE_FK (DEADLINE_), add constraint WAIT_DLINE_FK foreign key (DEADLINE_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ACTIVITY add index ACT_TH_SCOPE_FK (SCOPE_NODE_), add constraint ACT_TH_SCOPE_FK foreign key (SCOPE_NODE_) references NOVA_NODE (DBID_);
alter table NOVA_ACTIVITY add index IF_COND_FK (COND_), add constraint IF_COND_FK foreign key (COND_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ACTIVITY add index WAIT_DUR_FK (DURATION_), add constraint WAIT_DUR_FK foreign key (DURATION_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ACTIVITY add index FKE88EDDC25BE3B464 (catchVariableDefinition), add constraint FKE88EDDC25BE3B464 foreign key (catchVariableDefinition) references NOVA_BPEL_VARIABLE (DBID_);
alter table NOVA_ACTIVITY add index ACT_JOIN_COND_FK (TARG_JOIN_COND_), add constraint ACT_JOIN_COND_FK foreign key (TARG_JOIN_COND_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ACTIVITY add index FOR_FINAL_FK (FINAL_COUNT_), add constraint FOR_FINAL_FK foreign key (FINAL_COUNT_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ACTIVITY add index FKE88EDDC25F9F3677 (OP_KEY_), add constraint FKE88EDDC25F9F3677 foreign key (OP_KEY_) references NOVA_OP_KEY (DBID_);
alter table NOVA_ACTIVITY add index FKE88EDDC2220B15BF (NODE_), add constraint FKE88EDDC2220B15BF foreign key (NODE_) references NOVA_NODE (DBID_);
alter table NOVA_ACTIVITY add index RECV_IN_MSG_FK (ANON_IN_MESS_), add constraint RECV_IN_MSG_FK foreign key (ANON_IN_MESS_) references NOVA_BPEL_VARIABLE (DBID_);
alter table NOVA_ARGDESCRIPTOR add index FK_OBJDESCR_ARGS (OBJDESCR_), add constraint FK_OBJDESCR_ARGS foreign key (OBJDESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_ARGDESCRIPTOR add index FK_ARGDESCR_DESCR (DESCRIPTOR_), add constraint FK_ARGDESCR_DESCR foreign key (DESCRIPTOR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_ARGDESCRIPTOR add index FK_OPER_ARGS (OPER_), add constraint FK_OPER_ARGS foreign key (OPER_) references NOVA_OPERATION (DBID_);
create index IDX_BLOB_CHOP_OWN on NOVA_BLOB_CHOPS (BLOB_ID_);
alter table NOVA_BLOB_CHOPS add index FK_BLOB_CHOP_OWN (BLOB_ID_), add constraint FK_BLOB_CHOP_OWN foreign key (BLOB_ID_) references NOVA_VARIABLE (DBID_);
create index BPEL_EXEC_PARENT_IDX on NOVA_BPEL_EXEC (PARENT_);
create index BPEL_EXEC_FOREACH_IDX on NOVA_BPEL_EXEC (FOREACH_ID_);
create index BPEL_EXEC_SCOPE_IDX on NOVA_BPEL_EXEC (SCOPE_RT_ID_);
create index BPEL_EXEC_INST_IDX on NOVA_BPEL_EXEC (INSTANCE_);
create index BPEL_EXEC_PROC_IDX on NOVA_BPEL_EXEC (PROCESS_);
create index BPEL_EXEC_FLOW_IDX on NOVA_BPEL_EXEC (FLOW_RT_ID_);
alter table NOVA_BPEL_EXEC add index BPEL_EXEC_FOREACH_FK (FOREACH_ID_), add constraint BPEL_EXEC_FOREACH_FK foreign key (FOREACH_ID_) references NOVA_FOREACH_RUNTIME (DBID_);
alter table NOVA_BPEL_EXEC add index BPEL_EXEC_FLOW_FK (FLOW_RT_ID_), add constraint BPEL_EXEC_FLOW_FK foreign key (FLOW_RT_ID_) references NOVA_FLOW_RUNTIME (DBID_);
alter table NOVA_BPEL_EXEC add index BPEL_EXEC_PROC_FK (PROCESS_), add constraint BPEL_EXEC_PROC_FK foreign key (PROCESS_) references NOVA_BPEL_PROCESS (DBID_);
alter table NOVA_BPEL_EXEC add index BPEL_EXEC_SCOPE_FK (SCOPE_RT_ID_), add constraint BPEL_EXEC_SCOPE_FK foreign key (SCOPE_RT_ID_) references NOVA_SCOPE_RUNTIME (DBID_);
alter table NOVA_BPEL_EXEC add index BPEL_EXEC_INST_FK (INSTANCE_), add constraint BPEL_EXEC_INST_FK foreign key (INSTANCE_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_BPEL_EXEC add index FKF01EB0C8B2F982DE (DBID_), add constraint FKF01EB0C8B2F982DE foreign key (DBID_) references NOVA_EXECUTION (DBID_);
alter table NOVA_BPEL_EXEC add index BPEL_EXEC_PARENT_FK (PARENT_), add constraint BPEL_EXEC_PARENT_FK foreign key (PARENT_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_BPEL_PROCESS add index FK3FB3AAB8398073E8 (DBID_), add constraint FK3FB3AAB8398073E8 foreign key (DBID_) references NOVA_PROCESS (DBID_);
alter table NOVA_BPEL_PROCESS add index FK3FB3AAB89A504866 (WSDL_INFOS_), add constraint FK3FB3AAB89A504866 foreign key (WSDL_INFOS_) references NOVA_WSDLINFOS (DBID_);
alter table NOVA_BPEL_TESTS add index FK14825CAA8DCEEF2D (ACTIVITY_ID_), add constraint FK14825CAA8DCEEF2D foreign key (ACTIVITY_ID_) references NOVA_ACTIVITY (DBID_);
create index SCOPE_VAR_IDX on NOVA_BPEL_VARIABLE (SCOPE_ID_);
alter table NOVA_BPEL_VARIABLE add index FKA82FCF3381EEAE9 (VIRTUAL_COPY_), add constraint FKA82FCF3381EEAE9 foreign key (VIRTUAL_COPY_) references NOVA_COPY_ELT (DBID_);
alter table NOVA_BPEL_VARIABLE add index FKA82FCF33BA6A18F5 (DBID_), add constraint FKA82FCF33BA6A18F5 foreign key (DBID_) references NOVA_VARIABLEDEF (DBID_);
alter table NOVA_BPEL_VARIABLE add index SCOPE_VAR_FK (SCOPE_ID_), add constraint SCOPE_VAR_FK foreign key (SCOPE_ID_) references NOVA_ACTIVITY (DBID_);
create index IDX_CLOB_CHOP_OWN on NOVA_CLOB_CHOPS (CLOB_ID_);
alter table NOVA_CLOB_CHOPS add index FK_CLOB_CHOP_OWN (CLOB_ID_), add constraint FK_CLOB_CHOP_OWN foreign key (CLOB_ID_) references NOVA_VARIABLE (DBID_);
create index IDX_COMMENT_PARENT on NOVA_COMMENT (PARENT_);
alter table NOVA_COMMENT add index FK_COMMENT_PARENT (PARENT_), add constraint FK_COMMENT_PARENT foreign key (PARENT_) references NOVA_COMMENT (DBID_);
create index ASSIGN_COPY_IDX on NOVA_COPY_ELT (ASSIGN_ID_);
create index INVOKE_OUT_IDX on NOVA_COPY_ELT (INVOKE_OUT_ID_);
create index RECEIVE_IN_IDX on NOVA_COPY_ELT (RECEIVE_IN_ID_);
create index INVOKE_IN_IDX on NOVA_COPY_ELT (INVOKE_IN_ID_);
create index REPLY_MSG_EX_IDX on NOVA_COPY_ELT (REPLY_ID_);
alter table NOVA_COPY_ELT add index RECEIVE_IN_FK (RECEIVE_IN_ID_), add constraint RECEIVE_IN_FK foreign key (RECEIVE_IN_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_COPY_ELT add index FK2D2E1B765C53F732 (ON_MSG_IN_ID_), add constraint FK2D2E1B765C53F732 foreign key (ON_MSG_IN_ID_) references NOVA_ON_MSG (DBID_);
alter table NOVA_COPY_ELT add index REPLY_MSG_EX_FK (REPLY_ID_), add constraint REPLY_MSG_EX_FK foreign key (REPLY_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_COPY_ELT add index FK2D2E1B76DE1523BD (FROM_), add constraint FK2D2E1B76DE1523BD foreign key (FROM_) references NOVA_FROM_TO_ELT (DBID_);
alter table NOVA_COPY_ELT add index ASSIGN_COPY_FK (ASSIGN_ID_), add constraint ASSIGN_COPY_FK foreign key (ASSIGN_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_COPY_ELT add index INVOKE_IN_FK (INVOKE_IN_ID_), add constraint INVOKE_IN_FK foreign key (INVOKE_IN_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_COPY_ELT add index INVOKE_OUT_FK (INVOKE_OUT_ID_), add constraint INVOKE_OUT_FK foreign key (INVOKE_OUT_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_COPY_ELT add index FK2D2E1B766464ED5D (TO_), add constraint FK2D2E1B766464ED5D foreign key (TO_) references NOVA_FROM_TO_ELT (DBID_);
alter table NOVA_COPY_ELT add index FK2D2E1B763A9909E3 (ON_EVT_IN_ID_), add constraint FK2D2E1B763A9909E3 foreign key (ON_EVT_IN_ID_) references NOVA_ON_EVT (DBID_);
create index REPLY_COR_IDX on NOVA_CORREL (REPLY_ID_);
create index INV_RES_IDX on NOVA_CORREL (INVOKE_RES_ID_);
create index INV_REQ_IDX on NOVA_CORREL (INVOKE_REQ_ID_);
create index RECV_COR_IDX on NOVA_CORREL (RECEIVE_ID_);
alter table NOVA_CORREL add index FK7C680C66F00CA0D (CS_), add constraint FK7C680C66F00CA0D foreign key (CS_) references NOVA_CS (DBID_);
alter table NOVA_CORREL add index REPLY_COR_FK (REPLY_ID_), add constraint REPLY_COR_FK foreign key (REPLY_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_CORREL add index FK7C680C61BC92050 (ON_MSG_ID_), add constraint FK7C680C61BC92050 foreign key (ON_MSG_ID_) references NOVA_ON_MSG (DBID_);
alter table NOVA_CORREL add index INV_RES_FK (INVOKE_RES_ID_), add constraint INV_RES_FK foreign key (INVOKE_RES_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_CORREL add index RECV_COR_FK (RECEIVE_ID_), add constraint RECV_COR_FK foreign key (RECEIVE_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_CORREL add index FK7C680C6F7C10905 (ON_EVT_ID_), add constraint FK7C680C6F7C10905 foreign key (ON_EVT_ID_) references NOVA_ON_EVT (DBID_);
alter table NOVA_CORREL add index INV_REQ_FK (INVOKE_REQ_ID_), add constraint INV_REQ_FK foreign key (INVOKE_REQ_ID_) references NOVA_ACTIVITY (DBID_);
create index SCOPE_CS_IDX on NOVA_CS (SCOPE_ID_);
alter table NOVA_CS add index SCOPE_CS_FK (SCOPE_ID_), add constraint SCOPE_CS_FK foreign key (SCOPE_ID_) references NOVA_ACTIVITY (DBID_);
create index CS_INST_PROP_IDX on NOVA_CS_INST_PROP (CS_ID_);
alter table NOVA_CS_INST_PROP add index CS_INST_PROP_FK (CS_ID_), add constraint CS_INST_PROP_FK foreign key (CS_ID_) references CS_INIT_FULL_IMPL (DBID_);
create index BPEL_SCOPE_CS_IDX on NOVA_CS_RUNTIME (SCOPE_ID_);
alter table NOVA_CS_RUNTIME add index FK7E7EB4DCADAF3787 (CS_DEF_), add constraint FK7E7EB4DCADAF3787 foreign key (CS_DEF_) references NOVA_CS (DBID_);
alter table NOVA_CS_RUNTIME add index BPEL_SCOPE_CS_FK (SCOPE_ID_), add constraint BPEL_SCOPE_CS_FK foreign key (SCOPE_ID_) references NOVA_SCOPE_RUNTIME (DBID_);
alter table NOVA_CS_RUN_PROP add index FK51F62C1341321DA8 (CS_ID_), add constraint FK51F62C1341321DA8 foreign key (CS_ID_) references NOVA_CS_RUNTIME (DBID_);
create index IDX_DESCR_PROPS on NOVA_DESCRIPTOR (PROPS_);
alter table NOVA_DESCRIPTOR add index FK_DESCR_KEYDESCR (KEYDESCR_), add constraint FK_DESCR_KEYDESCR foreign key (KEYDESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_DESCRIPTOR add index DESCR_ARG_REF_FK (FACTORYDESCR_), add constraint DESCR_ARG_REF_FK foreign key (FACTORYDESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_DESCRIPTOR add index FK_DESCR_PROPS (PROPS_), add constraint FK_DESCR_PROPS foreign key (PROPS_) references NOVA_WIREPROPS (DBID_);
alter table NOVA_DESCRIPTOR add index FK_DESCR_VALDESCR (VALUEDESCR_), add constraint FK_DESCR_VALDESCR foreign key (VALUEDESCR_) references NOVA_DESCRIPTOR (DBID_);
create index ELSIF_IDX on NOVA_ELSE_IF (IF_ID_);
create index ELSIF_ACT_IDX on NOVA_ELSE_IF (ACTIVITY_);
create index ELSIF_COND_IDX on NOVA_ELSE_IF (CONDITION_);
alter table NOVA_ELSE_IF add index ELSIF_FK (IF_ID_), add constraint ELSIF_FK foreign key (IF_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_ELSE_IF add index ELSIF_ACT_FK (ACTIVITY_), add constraint ELSIF_ACT_FK foreign key (ACTIVITY_) references NOVA_NODE (DBID_);
alter table NOVA_ELSE_IF add index ELSIF_COND_FK (CONDITION_), add constraint ELSIF_COND_FK foreign key (CONDITION_) references NOVA_SNIPPET (DBID_);
create index IDX_EVENT_PROCESS on NOVA_EVENT (PROCESS_);
create index IDX_EVENT_TRANS on NOVA_EVENT (TRANSITION_);
create index IDX_EVENT_PROCDEF on NOVA_EVENT (PROCESSDEF_);
create index IDX_EVENT_PROPS on NOVA_EVENT (PROPS_);
create index IDX_EVENT_NODE on NOVA_EVENT (NODE_);
alter table NOVA_EVENT add index FK_EVENT_PROCESS (PROCESS_), add constraint FK_EVENT_PROCESS foreign key (PROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_EVENT add index FK_EVENT_PROCDEF (PROCESSDEF_), add constraint FK_EVENT_PROCDEF foreign key (PROCESSDEF_) references NOVA_PROCESS (DBID_);
alter table NOVA_EVENT add index FK_EVENT_TRANS (TRANSITION_), add constraint FK_EVENT_TRANS foreign key (TRANSITION_) references NOVA_TRANSITION (DBID_);
alter table NOVA_EVENT add index FK_EVENT_NODE (NODE_), add constraint FK_EVENT_NODE foreign key (NODE_) references NOVA_NODE (DBID_);
alter table NOVA_EVENT add index FK_EVENT_PROPS (PROPS_), add constraint FK_EVENT_PROPS foreign key (PROPS_) references NOVA_WIREPROPS (DBID_);
create index IDX_EXHDLR_TRANS on NOVA_EXCEPTHNDLR (TRANSITION_);
create index IDX_EXHDLR_PROCESS on NOVA_EXCEPTHNDLR (PROCESS_);
create index IDX_EXHDLR_NODE on NOVA_EXCEPTHNDLR (NODE_);
create index IDX_EXHDLR_EVENT on NOVA_EXCEPTHNDLR (EVENT_);
alter table NOVA_EXCEPTHNDLR add index FK_EXHDLR_PROCESS (PROCESS_), add constraint FK_EXHDLR_PROCESS foreign key (PROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_EXCEPTHNDLR add index FK_EXHDLR_TRANS (TRANSITION_), add constraint FK_EXHDLR_TRANS foreign key (TRANSITION_) references NOVA_TRANSITION (DBID_);
alter table NOVA_EXCEPTHNDLR add index FK_EXHDLR_EVENT (EVENT_), add constraint FK_EXHDLR_EVENT foreign key (EVENT_) references NOVA_EVENT (DBID_);
alter table NOVA_EXCEPTHNDLR add index FK_EXHDLR_NODE (NODE_), add constraint FK_EXHDLR_NODE foreign key (NODE_) references NOVA_NODE (DBID_);
create index IDX_EXEC_TRANSORIG on NOVA_EXECUTION (TRANSORIG_);
create index IDX_EXEC_PARENT on NOVA_EXECUTION (PARENT_);
create index IDX_EXEC_NODE on NOVA_EXECUTION (NODE_);
create index IDX_EXEC_PREV_TRANS on NOVA_EXECUTION (PREV_TRANS_);
create index IDX_EXEC_SUPEREXEC on NOVA_EXECUTION (SUPEREXEC_);
create index IDX_EXEC_PROCESS on NOVA_EXECUTION (PROCESS_);
create index IDX_EXEC_INSTANCE on NOVA_EXECUTION (INSTANCE_);
create index IDX_EXEC_PREV_NODE on NOVA_EXECUTION (PREV_NODE_);
alter table NOVA_EXECUTION add index FK_EXEC_TRANSORIG (TRANSORIG_), add constraint FK_EXEC_TRANSORIG foreign key (TRANSORIG_) references NOVA_NODE (DBID_);
alter table NOVA_EXECUTION add index FK_EXEC_PROCESS (PROCESS_), add constraint FK_EXEC_PROCESS foreign key (PROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_EXECUTION add index FK_EXEC_INSTANCE (INSTANCE_), add constraint FK_EXEC_INSTANCE foreign key (INSTANCE_) references NOVA_EXECUTION (DBID_);
alter table NOVA_EXECUTION add index FKDC1376A56B99B69F (TRANSITION_), add constraint FKDC1376A56B99B69F foreign key (TRANSITION_) references NOVA_TRANSITION (DBID_);
alter table NOVA_EXECUTION add index FK_EXEC_PREV_TRANS (PREV_TRANS_), add constraint FK_EXEC_PREV_TRANS foreign key (PREV_TRANS_) references NOVA_TRANSITION (DBID_);
alter table NOVA_EXECUTION add index FK_EXEC_PREV_NODE (PREV_NODE_), add constraint FK_EXEC_PREV_NODE foreign key (PREV_NODE_) references NOVA_NODE (DBID_);
alter table NOVA_EXECUTION add index FK_EXEC_NODE (NODE_), add constraint FK_EXEC_NODE foreign key (NODE_) references NOVA_NODE (DBID_);
alter table NOVA_EXECUTION add index FK_EXEC_SUPEREXEC (SUPEREXEC_), add constraint FK_EXEC_SUPEREXEC foreign key (SUPEREXEC_) references NOVA_EXECUTION (DBID_);
alter table NOVA_EXECUTION add index FK_EXEC_PARENT (PARENT_), add constraint FK_EXEC_PARENT foreign key (PARENT_) references NOVA_EXECUTION (DBID_);
alter table NOVA_FROM_TO_ELT add index FKEB0E8F6BC4132A10 (EXPRESSION_), add constraint FKEB0E8F6BC4132A10 foreign key (EXPRESSION_) references NOVA_SNIPPET (DBID_);
alter table NOVA_FROM_TO_ELT add index FKEB0E8F6B3ADD900A (VAR_QUERY_), add constraint FKEB0E8F6B3ADD900A foreign key (VAR_QUERY_) references NOVA_SNIPPET (DBID_);
alter table NOVA_FROM_TO_ELT add index FKEB0E8F6B4D46DC95 (PROP_QUERY_), add constraint FKEB0E8F6B4D46DC95 foreign key (PROP_QUERY_) references NOVA_SNIPPET (DBID_);
create index BPEL_EXEC_WAITING_IDX on NOVA_INST_WAITING_EXEC (EXECUTION_);
create index BPEL_INST_WAITING_IDX on NOVA_INST_WAITING_EXEC (INSTANCE_ID_);
alter table NOVA_INST_WAITING_EXEC add index BPEL_INST_WAITING_FK (INSTANCE_ID_), add constraint BPEL_INST_WAITING_FK foreign key (INSTANCE_ID_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_INST_WAITING_EXEC add index BPEL_EXEC_WAITING_FK (EXECUTION_), add constraint BPEL_EXEC_WAITING_FK foreign key (EXECUTION_) references NOVA_BPEL_EXEC (DBID_);
create index JOB_INV_OP_KEY_IDX on NOVA_JOB (OP_KEY_);
create index IDX_JOB_EXECUTION on NOVA_JOB (EXECUTION_);
create index IDX_JOB_CMDDESCR on NOVA_JOB (CMDDESCR_);
create index IDX_JOB_PRINST on NOVA_JOB (PROCESSINSTANCE_);
alter table NOVA_JOB add index FK_JOB_CMDDESCR (CMDDESCR_), add constraint FK_JOB_CMDDESCR foreign key (CMDDESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_JOB add index FK_JOB_PRINST (PROCESSINSTANCE_), add constraint FK_JOB_PRINST foreign key (PROCESSINSTANCE_) references NOVA_EXECUTION (DBID_);
alter table NOVA_JOB add index JOB_INV_OP_KEY_FK (OP_KEY_), add constraint JOB_INV_OP_KEY_FK foreign key (OP_KEY_) references NOVA_OP_KEY (DBID_);
alter table NOVA_JOB add index FK_JOB_NODE (NODE_), add constraint FK_JOB_NODE foreign key (NODE_) references NOVA_NODE (DBID_);
alter table NOVA_JOB add index FK9029010A722C9785 (EXECUTION_), add constraint FK9029010A722C9785 foreign key (EXECUTION_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_JOB add index FK_JOB_EXECUTION (EXECUTION_), add constraint FK_JOB_EXECUTION foreign key (EXECUTION_) references NOVA_EXECUTION (DBID_);
create index FLOW_LINK_IDX on NOVA_LINK (FLOW_ID_);
alter table NOVA_LINK add index FLOW_LINK_FK (FLOW_ID_), add constraint FLOW_LINK_FK foreign key (FLOW_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_LINK add index FK74F7F42DC74809C5 (SOURCE_ACTIVITY_), add constraint FK74F7F42DC74809C5 foreign key (SOURCE_ACTIVITY_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_LINK add index FK74F7F42DA26937BB (TARGET_ACTIVITY_), add constraint FK74F7F42DA26937BB foreign key (TARGET_ACTIVITY_) references NOVA_ACTIVITY (DBID_);
create index BPEL_LINK_EXEC_IDX on NOVA_LINK_RUNTIME (WAITING_EXEC_);
create index BPEL_FLOW_LINK_IDX on NOVA_LINK_RUNTIME (FLOW_RUNTIME_ID_);
alter table NOVA_LINK_RUNTIME add index BPEL_LINK_EXEC_FK (WAITING_EXEC_), add constraint BPEL_LINK_EXEC_FK foreign key (WAITING_EXEC_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_LINK_RUNTIME add index BPEL_FLOW_LINK_FK (FLOW_RUNTIME_ID_), add constraint BPEL_FLOW_LINK_FK foreign key (FLOW_RUNTIME_ID_) references NOVA_FLOW_RUNTIME (DBID_);
alter table NOVA_NAMESPACE add index FK67BDC0E8329E08E (SNIPPET_ID_), add constraint FK67BDC0E8329E08E foreign key (SNIPPET_ID_) references NOVA_SNIPPET (DBID_);
create index IDX_NODE_PROCESS on NOVA_NODE (PROCESS_);
create index IDX_NODE_PROPS on NOVA_NODE (PROPS_);
create index IDX_NODE_BEHAV_DESCR on NOVA_NODE (BEHAV_DESCR_);
create index IDX_NODE_DEFTRANS on NOVA_NODE (DEFTRANS_);
create index IDX_NODES_PROCESS on NOVA_NODE (NODESPROCESS_);
create index IDX_NODE_PARENT on NOVA_NODE (PARENT_);
alter table NOVA_NODE add index FK_NODES_PROCESS (NODESPROCESS_), add constraint FK_NODES_PROCESS foreign key (NODESPROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_NODE add index FK_NODE_PROCESS (PROCESS_), add constraint FK_NODE_PROCESS foreign key (PROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_NODE add index FK_NODE_DEFTRANS (DEFTRANS_), add constraint FK_NODE_DEFTRANS foreign key (DEFTRANS_) references NOVA_TRANSITION (DBID_);
alter table NOVA_NODE add index FK_NODE_PROPS (PROPS_), add constraint FK_NODE_PROPS foreign key (PROPS_) references NOVA_WIREPROPS (DBID_);
alter table NOVA_NODE add index FK_NODE_BEHAV_DESCR (BEHAV_DESCR_), add constraint FK_NODE_BEHAV_DESCR foreign key (BEHAV_DESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_NODE add index FK_NODE_PARENT (PARENT_), add constraint FK_NODE_PARENT foreign key (PARENT_) references NOVA_NODE (DBID_);
create index IDX_OBJREF_EXHNDLR on NOVA_OBJECTREF (EXHNDLR_);
create index IDX_OBJREF_EVENT on NOVA_OBJECTREF (OBJ_DESCR_, EVENT_);
alter table NOVA_OBJECTREF add index FK_OBJREF_EVENT (OBJ_DESCR_), add constraint FK_OBJREF_EVENT foreign key (OBJ_DESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_OBJECTREF add index FK_OBJREF_EXHNDLR (EXHNDLR_), add constraint FK_OBJREF_EXHNDLR foreign key (EXHNDLR_) references NOVA_EXCEPTHNDLR (DBID_);
alter table NOVA_OBJECTREF add index FK_OBJECTREF_EVENT (EVENT_), add constraint FK_OBJECTREF_EVENT foreign key (EVENT_) references NOVA_EVENT (DBID_);
create index PICK_ON_ALRM_IDX on NOVA_ON_ALARM (PICK_ID_);
create index ACT_ON_ALARM_IDX on NOVA_ON_ALARM (ACTIVITY_ID_);
alter table NOVA_ON_ALARM add index FKEF13C684FAD5EF6D (REPEAT_), add constraint FKEF13C684FAD5EF6D foreign key (REPEAT_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ON_ALARM add index ACT_ON_ALARM_FK (ACTIVITY_ID_), add constraint ACT_ON_ALARM_FK foreign key (ACTIVITY_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_ON_ALARM add index FKEF13C68458E1CE94 (DURATION_), add constraint FKEF13C68458E1CE94 foreign key (DURATION_) references NOVA_SNIPPET (DBID_);
alter table NOVA_ON_ALARM add index FKEF13C68427FB7252 (ACTIVITY_), add constraint FKEF13C68427FB7252 foreign key (ACTIVITY_) references NOVA_NODE (DBID_);
alter table NOVA_ON_ALARM add index PICK_ON_ALRM_FK (PICK_ID_), add constraint PICK_ON_ALRM_FK foreign key (PICK_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_ON_ALARM add index FKEF13C6845C32DA50 (DEADLINE_), add constraint FKEF13C6845C32DA50 foreign key (DEADLINE_) references NOVA_SNIPPET (DBID_);
create index ACT_ON_EVT_IDX on NOVA_ON_EVT (ACTIVITY_ID_);
alter table NOVA_ON_EVT add index ACT_ON_EVT_FK (ACTIVITY_ID_), add constraint ACT_ON_EVT_FK foreign key (ACTIVITY_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_ON_EVT add index FK1C384AD627FB7252 (ACTIVITY_), add constraint FK1C384AD627FB7252 foreign key (ACTIVITY_) references NOVA_NODE (DBID_);
alter table NOVA_ON_EVT add index FK1C384AD65F9F3677 (OP_KEY_), add constraint FK1C384AD65F9F3677 foreign key (OP_KEY_) references NOVA_OP_KEY (DBID_);
alter table NOVA_ON_EVT add index FK1C384AD6F7237F7A (ANON_IN_MESS_), add constraint FK1C384AD6F7237F7A foreign key (ANON_IN_MESS_) references NOVA_BPEL_VARIABLE (DBID_);
create index PICK_ON_MSG_IDX on NOVA_ON_MSG (PICK_ID_);
alter table NOVA_ON_MSG add index FK1C38687427FB7252 (ACTIVITY_), add constraint FK1C38687427FB7252 foreign key (ACTIVITY_) references NOVA_NODE (DBID_);
alter table NOVA_ON_MSG add index PICK_ON_MSG_FK (PICK_ID_), add constraint PICK_ON_MSG_FK foreign key (PICK_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_ON_MSG add index FK1C3868745F9F3677 (OP_KEY_), add constraint FK1C3868745F9F3677 foreign key (OP_KEY_) references NOVA_OP_KEY (DBID_);
alter table NOVA_ON_MSG add index FK1C386874F7237F7A (ANON_IN_MESS_), add constraint FK1C386874F7237F7A foreign key (ANON_IN_MESS_) references NOVA_BPEL_VARIABLE (DBID_);
alter table NOVA_OPERATION add index FK_OPER_PROPDESC (PROPDESCR_), add constraint FK_OPER_PROPDESC foreign key (PROPDESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_OPERATION add index FK_OPER_FIELDDESC (FIELDDESCR_), add constraint FK_OPER_FIELDDESC foreign key (FIELDDESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_OPERATION add index FK_OPER_OBJDESCR (OBJDESCR_), add constraint FK_OPER_OBJDESCR foreign key (OBJDESCR_) references NOVA_DESCRIPTOR (DBID_);
create index BPEL_PEND_MSG_RECV_IDX on NOVA_PENDING_MESS (RECEIVER_ID_);
alter table NOVA_PENDING_MESS add index BPEL_PEND_MSG_RECV_FK (RECEIVER_ID_), add constraint BPEL_PEND_MSG_RECV_FK foreign key (RECEIVER_ID_) references NOVA_RECEIVER (DBID_);
create index NOVA_PENDING_MSG_PART_IDX on NOVA_PENDING_MSG_PART (PENDING_ID_);
alter table NOVA_PENDING_MSG_PART add index NOVA_PENDING_MSG_PART_FK (PENDING_ID_), add constraint NOVA_PENDING_MSG_PART_FK foreign key (PENDING_ID_) references NOVA_PENDING_MESS (DBID_);
create index SCOPE_PL_IDX on NOVA_PLNK (SCOPE_ID_);
alter table NOVA_PLNK add index SCOPE_PL_FK (SCOPE_ID_), add constraint SCOPE_PL_FK foreign key (SCOPE_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_PLNKTYPE add index FKD0B7022664EEA1B7 (WSDLINFOS_ID_), add constraint FKD0B7022664EEA1B7 foreign key (WSDLINFOS_ID_) references NOVA_WSDLINFOS (DBID_);
alter table NOVA_PLNKT_ROLES add index FK6B41F886A4BE5179 (PLNKTYPE_ID_), add constraint FK6B41F886A4BE5179 foreign key (PLNKTYPE_ID_) references NOVA_PLNKTYPE (DBID_);
create index BPEL_SCOPE_PLK_IDX on NOVA_PL_RUNTIME (SCOPE_RUN_ID_);
alter table NOVA_PL_RUNTIME add index FKD85A6A68EA5B661 (PL_DEF_), add constraint FKD85A6A68EA5B661 foreign key (PL_DEF_) references NOVA_PLNK (DBID_);
alter table NOVA_PL_RUNTIME add index BPEL_SCOPE_PLK_FK (SCOPE_RUN_ID_), add constraint BPEL_SCOPE_PLK_FK foreign key (SCOPE_RUN_ID_) references NOVA_SCOPE_RUNTIME (DBID_);
create index IDX_PROCDEF_PROPS on NOVA_PROCESS (PROPS_);
create index IDX_PROCDEF_INIT on NOVA_PROCESS (INITIAL_);
alter table NOVA_PROCESS add index FK_PROCDEF_INITIAL (INITIAL_), add constraint FK_PROCDEF_INITIAL foreign key (INITIAL_) references NOVA_NODE (DBID_);
alter table NOVA_PROCESS add index FK_PROCDEF_PROPS (PROPS_), add constraint FK_PROCDEF_PROPS foreign key (PROPS_) references NOVA_WIREPROPS (DBID_);
alter table NOVA_PROCESS_START add index FK85755F7FA088E666 (elt), add constraint FK85755F7FA088E666 foreign key (elt) references NOVA_ACTIVITY (DBID_);
alter table NOVA_PROCESS_START add index FK85755F7F2857DEA8 (BPEL_PROCESS_), add constraint FK85755F7F2857DEA8 foreign key (BPEL_PROCESS_) references NOVA_BPEL_PROCESS (DBID_);
alter table NOVA_PROPALIAS add index FKF1CD045A64EEA1B7 (WSDLINFOS_ID_), add constraint FKF1CD045A64EEA1B7 foreign key (WSDLINFOS_ID_) references NOVA_WSDLINFOS (DBID_);
alter table NOVA_PROPALIAS add index FKF1CD045A2E48839 (QUERY_), add constraint FKF1CD045A2E48839 foreign key (QUERY_) references NOVA_SNIPPET (DBID_);
create index BPEL_RECV_OP_KEY_IDX on NOVA_RECEIVER (OP_KEY_);
alter table NOVA_RECEIVER add index BPEL_RECV_OP_KEY_FK (OP_KEY_), add constraint BPEL_RECV_OP_KEY_FK foreign key (OP_KEY_) references NOVA_OP_KEY (DBID_);
alter table NOVA_RECEIVER add index FK1B0ED4A22857DEA8 (BPEL_PROCESS_), add constraint FK1B0ED4A22857DEA8 foreign key (BPEL_PROCESS_) references NOVA_BPEL_PROCESS (DBID_);
create index BPEL_EXEC_REPLIERS_IDX on NOVA_REPLIER (BPEL_INSTANCE_);
create index BPEL_REPKEY_OP_KEY_IDX on NOVA_REPLIER (OP_KEY_ID_);
create index BPEL_REPLIER_SCOPE_IDX on NOVA_REPLIER (SCOPE_RUNTIME_);
alter table NOVA_REPLIER add index BPEL_REPLIER_SCOPE_FK (SCOPE_RUNTIME_), add constraint BPEL_REPLIER_SCOPE_FK foreign key (SCOPE_RUNTIME_) references NOVA_SCOPE_RUNTIME (DBID_);
alter table NOVA_REPLIER add index BPEL_EXEC_REPLIERS_FK (BPEL_INSTANCE_), add constraint BPEL_EXEC_REPLIERS_FK foreign key (BPEL_INSTANCE_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_REPLIER add index BPEL_REPKEY_OP_KEY_FK (OP_KEY_ID_), add constraint BPEL_REPKEY_OP_KEY_FK foreign key (OP_KEY_ID_) references NOVA_OP_KEY (DBID_);
create index SCOPE_MSG_EX_IDX on NOVA_SCOPE_MESSEXS (SCOPE_ID_);
alter table NOVA_SCOPE_MESSEXS add index SCOPE_MSG_EX_FK (SCOPE_ID_), add constraint SCOPE_MSG_EX_FK foreign key (SCOPE_ID_) references NOVA_ACTIVITY (DBID_);
create index SR_EXCEPTION_IDX on NOVA_SCOPE_RUNTIME (LAST_EXCEPTION_);
create index BPEL_SR_PARENT_IDX on NOVA_SCOPE_RUNTIME (PARENT_);
create index SR_COMP_EXEC_IDX on NOVA_SCOPE_RUNTIME (COMPENSATE_EXEC_);
alter table NOVA_SCOPE_RUNTIME add index SR_EXCEPTION_FK (LAST_EXCEPTION_), add constraint SR_EXCEPTION_FK foreign key (LAST_EXCEPTION_) references BPEL_FAULT_ (DBID_);
alter table NOVA_SCOPE_RUNTIME add index SR_COMP_EXEC_FK (COMPENSATE_EXEC_), add constraint SR_COMP_EXEC_FK foreign key (COMPENSATE_EXEC_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_SCOPE_RUNTIME add index FKDDA191DAA36EF1E6 (SCOPE_DEF_), add constraint FKDDA191DAA36EF1E6 foreign key (SCOPE_DEF_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_SCOPE_RUNTIME add index BPEL_SR_PARENT_FK (PARENT_), add constraint BPEL_SR_PARENT_FK foreign key (PARENT_) references NOVA_SCOPE_RUNTIME (DBID_);
create index SCOPE_INIT_VAR_IDX on NOVA_SCOPE_VARINIT (SCOPE_ID_);
alter table NOVA_SCOPE_VARINIT add index SCOPE_INIT_VAR_FK (SCOPE_ID_), add constraint SCOPE_INIT_VAR_FK foreign key (SCOPE_ID_) references NOVA_ACTIVITY (DBID_);
create index ACT_SRC_LNK_IDX on NOVA_SOURCE (ACTIVITY_ID_);
alter table NOVA_SOURCE add index FK2315678EDE682DBD (LINK_), add constraint FK2315678EDE682DBD foreign key (LINK_) references NOVA_LINK (DBID_);
alter table NOVA_SOURCE add index ACT_SRC_LNK_FK (ACTIVITY_ID_), add constraint ACT_SRC_LNK_FK foreign key (ACTIVITY_ID_) references NOVA_ACTIVITY (DBID_);
alter table NOVA_SOURCE add index FK2315678E35D1566F (TRANS_COND_), add constraint FK2315678E35D1566F foreign key (TRANS_COND_) references NOVA_SNIPPET (DBID_);
alter table NOVA_STYLESHEET add index FK8FA12C41F1DBFC22 (PROCESS_ID_), add constraint FK8FA12C41F1DBFC22 foreign key (PROCESS_ID_) references NOVA_BPEL_PROCESS (DBID_);
create index ACT_TGT_LNK_IDX on NOVA_TARGET (ACTIVITY_ID_);
alter table NOVA_TARGET add index FK24037104DE682DBD (LINK_), add constraint FK24037104DE682DBD foreign key (LINK_) references NOVA_LINK (DBID_);
alter table NOVA_TARGET add index ACT_TGT_LNK_FK (ACTIVITY_ID_), add constraint ACT_TGT_LNK_FK foreign key (ACTIVITY_ID_) references NOVA_ACTIVITY (DBID_);
create index IDX_TMRDEF_NODE on NOVA_TIMERDEF (NODE_);
create index IDX_TMRDEF_PROCESS on NOVA_TIMERDEF (PROCESS_);
alter table NOVA_TIMERDEF add index FK_TMRDEF_PROCESS (PROCESS_), add constraint FK_TMRDEF_PROCESS foreign key (PROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_TIMERDEF add index FK_TMRDEF_NODE (NODE_), add constraint FK_TMRDEF_NODE foreign key (NODE_) references NOVA_NODE (DBID_);
create index IDX_TRANS_COND on NOVA_TRANSITION (COND_DESCR_);
create index IDX_TRANS_PROCDEF on NOVA_TRANSITION (PROCESS_);
create index IDX_TRANS_SRC on NOVA_TRANSITION (SRC_);
create index IDX_TRANS_PROPS on NOVA_TRANSITION (PROPS_);
create index IDX_TRANS_DST on NOVA_TRANSITION (DEST_);
alter table NOVA_TRANSITION add index FK_TRANS_PROCDEF (PROCESS_), add constraint FK_TRANS_PROCDEF foreign key (PROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_TRANSITION add index FK1F6E7348C9CB4133 (DESTINATION_), add constraint FK1F6E7348C9CB4133 foreign key (DESTINATION_) references NOVA_NODE (DBID_);
alter table NOVA_TRANSITION add index FK1F6E7348A3459EC6 (SOURCE_), add constraint FK1F6E7348A3459EC6 foreign key (SOURCE_) references NOVA_NODE (DBID_);
alter table NOVA_TRANSITION add index FK_TRANS_DST (DEST_), add constraint FK_TRANS_DST foreign key (DEST_) references NOVA_NODE (DBID_);
alter table NOVA_TRANSITION add index FK_TRANS_SRC (SRC_), add constraint FK_TRANS_SRC foreign key (SRC_) references NOVA_NODE (DBID_);
alter table NOVA_TRANSITION add index FK_TRANS_PROPS (PROPS_), add constraint FK_TRANS_PROPS foreign key (PROPS_) references NOVA_WIREPROPS (DBID_);
alter table NOVA_TRANSITION add index FK_TRANS_COND (COND_DESCR_), add constraint FK_TRANS_COND foreign key (COND_DESCR_) references NOVA_DESCRIPTOR (DBID_);
create index IDX_VAR_PROCINST on NOVA_VARIABLE (PROCINST_);
create index IDX_VAR_EXECUTION on NOVA_VARIABLE (EXECUTION_);
alter table NOVA_VARIABLE add index FK_VAR_PROCINST (PROCINST_), add constraint FK_VAR_PROCINST foreign key (PROCINST_) references NOVA_EXECUTION (DBID_);
alter table NOVA_VARIABLE add index FK_VAR_EXECUTION (EXECUTION_), add constraint FK_VAR_EXECUTION foreign key (EXECUTION_) references NOVA_EXECUTION (DBID_);
create index IDX_VARDEF_NODE on NOVA_VARIABLEDEF (NODE_);
create index IDX_VARDEF_PROCESS on NOVA_VARIABLEDEF (PROCESS_);
create index IDX_VARDEF_SRCDES on NOVA_VARIABLEDEF (SRCDESCR_);
alter table NOVA_VARIABLEDEF add index FK_VARDEF_PROCESS (PROCESS_), add constraint FK_VARDEF_PROCESS foreign key (PROCESS_) references NOVA_PROCESS (DBID_);
alter table NOVA_VARIABLEDEF add index FK_VARDEF_NODE (NODE_), add constraint FK_VARDEF_NODE foreign key (NODE_) references NOVA_NODE (DBID_);
alter table NOVA_VARIABLEDEF add index FK_VARDEF_SRCDES (SRCDESCR_), add constraint FK_VARDEF_SRCDES foreign key (SRCDESCR_) references NOVA_DESCRIPTOR (DBID_);
alter table NOVA_VAR_MSG_PART add index FKC7FCA57CAD9A96A3 (VAR_ID_), add constraint FKC7FCA57CAD9A96A3 foreign key (VAR_ID_) references NOVA_VAR_RUNTIME (DBID_);
create index VAR_UPD_MSG_PART_IDX on NOVA_VAR_MSG_PART2 (VAR_ID_);
alter table NOVA_VAR_MSG_PART2 add index VAR_UPD_MSG_PART_FK (VAR_ID_), add constraint VAR_UPD_MSG_PART_FK foreign key (VAR_ID_) references VAR_UPDATE_FULL_IMPL (DBID_);
create index BPEL_SCOPE_VAR_IDX on NOVA_VAR_RUNTIME (SCOPE_ID_);
alter table NOVA_VAR_RUNTIME add index FK5D0C7AED5A7F55CA (VAR_RUNT_VAR_DEF_), add constraint FK5D0C7AED5A7F55CA foreign key (VAR_RUNT_VAR_DEF_) references NOVA_BPEL_VARIABLE (DBID_);
alter table NOVA_VAR_RUNTIME add index BPEL_SCOPE_VAR_FK (SCOPE_ID_), add constraint BPEL_SCOPE_VAR_FK foreign key (SCOPE_ID_) references NOVA_SCOPE_RUNTIME (DBID_);
create index BPEL_WAIT_EXEC_IDX on NOVA_WAITING_EXEC (EXEC_ID_);
create index BPEL_WAIT_EXEC_RECV_IDX on NOVA_WAITING_EXEC (RECEIVER_ID_);
alter table NOVA_WAITING_EXEC add index BPEL_WAIT_EXEC_FK (EXEC_ID_), add constraint BPEL_WAIT_EXEC_FK foreign key (EXEC_ID_) references NOVA_BPEL_EXEC (DBID_);
alter table NOVA_WAITING_EXEC add index BPEL_WAIT_EXEC_RECV_FK (RECEIVER_ID_), add constraint BPEL_WAIT_EXEC_RECV_FK foreign key (RECEIVER_ID_) references NOVA_RECEIVER (DBID_);
alter table NOVA_WSDL_PROPERTY add index FKCA68A07D64EEA1B7 (WSDLINFOS_ID_), add constraint FKCA68A07D64EEA1B7 foreign key (WSDLINFOS_ID_) references NOVA_WSDLINFOS (DBID_);
create index SCOPE_DEF_ALARMS_IDX on ON_ALRM_DEF_ (SCOPE_ID_);
create index PK_DF_ON_AL_IDX on ON_ALRM_DEF_ (PK_DF_ON_AL_ID_);
alter table ON_ALRM_DEF_ add index PK_DF_ON_AL_FK (PK_DF_ON_AL_ID_), add constraint PK_DF_ON_AL_FK foreign key (PK_DF_ON_AL_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table ON_ALRM_DEF_ add index FK5B79CBB3735C61C7 (ON_ALRM_ACT_DEF_ID_), add constraint FK5B79CBB3735C61C7 foreign key (ON_ALRM_ACT_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table ON_ALRM_DEF_ add index SCOPE_DEF_ALARMS_FK (SCOPE_ID_), add constraint SCOPE_DEF_ALARMS_FK foreign key (SCOPE_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index SCOPE_DEF_EVTS_IDX on ON_EVT_DEF_ (SCOPE_ID_);
alter table ON_EVT_DEF_ add index FKC013947699EA93C4 (ON_EVT_ACT_DEF_ID_), add constraint FKC013947699EA93C4 foreign key (ON_EVT_ACT_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table ON_EVT_DEF_ add index SCOPE_DEF_EVTS_FK (SCOPE_ID_), add constraint SCOPE_DEF_EVTS_FK foreign key (SCOPE_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index PK_DF_ON_MSG_IDX on ON_MSG_DEF_ (PK_DF_ON_MSG_ID_);
alter table ON_MSG_DEF_ add index PK_DF_ON_MSG_FK (PK_DF_ON_MSG_ID_), add constraint PK_DF_ON_MSG_FK foreign key (PK_DF_ON_MSG_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table ON_MSG_DEF_ add index FK4A3B4998A6853462 (ON_MSG_ACT_DEF_ID_), add constraint FK4A3B4998A6853462 foreign key (ON_MSG_ACT_DEF_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index SCOPE_DEF_PL_IDX on PART_LNK_DEF_ (SCOPE_ID_);
alter table PART_LNK_DEF_ add index SCOPE_DEF_PL_FK (SCOPE_ID_), add constraint SCOPE_DEF_PL_FK foreign key (SCOPE_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index SCOPE_INST_PLNK_IDX on PLNK_UPDATE_FULL_IMPL (SCOPE_ID_);
alter table PLNK_UPDATE_FULL_IMPL add index SCOPE_INST_PLNK_FK (SCOPE_ID_), add constraint SCOPE_INST_PLNK_FK foreign key (SCOPE_ID_) references BPEL_ACTIVITY_INST (DBID_);
create index PROCESS_INST_STATE_IDX on PROCESS_INST_STATE_UPDATE_ (PROCESS_INST_ID_);
alter table PROCESS_INST_STATE_UPDATE_ add index PROCESS_INST_STATE_FK (PROCESS_INST_ID_), add constraint PROCESS_INST_STATE_FK foreign key (PROCESS_INST_ID_) references BPEL_ACTIVITY_INST (DBID_);
create index SCOPE_INST_STATE_IDX on SCOPE_STATE_UPDATE_ (SCOPE_ID_);
alter table SCOPE_STATE_UPDATE_ add index SCOPE_INST_STATE_FK (SCOPE_ID_), add constraint SCOPE_INST_STATE_FK foreign key (SCOPE_ID_) references BPEL_ACTIVITY_INST (DBID_);
create index SRC_LST_IDX on SRC_FULL_IMPL (SRC_LST_ID_);
alter table SRC_FULL_IMPL add index SRC_LST_FK (SRC_LST_ID_), add constraint SRC_LST_FK foreign key (SRC_LST_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index TRGT_LST_IDX on TGT_FULL_IMPL (TRGT_LST_ID_);
alter table TGT_FULL_IMPL add index TRGT_LST_FK (TRGT_LST_ID_), add constraint TRGT_LST_FK foreign key (TRGT_LST_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index IVK_TO_PT_LST_IDX on TO_PRT_DEF_ (IVK_TO_PT_ID_);
create index RP_TO_PT_LST_IDX on TO_PRT_DEF_ (RP_TO_PT_ID_);
alter table TO_PRT_DEF_ add index RP_TO_PT_LST_FK (RP_TO_PT_ID_), add constraint RP_TO_PT_LST_FK foreign key (RP_TO_PT_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
alter table TO_PRT_DEF_ add index IVK_TO_PT_LST_FK (IVK_TO_PT_ID_), add constraint IVK_TO_PT_LST_FK foreign key (IVK_TO_PT_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index FLOW_INST_TR_COND_IDX on TR_COND_UPD_ (FLOW_ID_);
alter table TR_COND_UPD_ add index FLOW_INST_TR_COND_FK (FLOW_ID_), add constraint FLOW_INST_TR_COND_FK foreign key (FLOW_ID_) references BPEL_ACTIVITY_INST (DBID_);
create index SCOPE_DEF_VAR_IDX on VAR_DEF_ (SCOPE_ID_);
alter table VAR_DEF_ add index SCOPE_DEF_VAR_FK (SCOPE_ID_), add constraint SCOPE_DEF_VAR_FK foreign key (SCOPE_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index SCOPE_DEF_CS_IDX on VAR_DEF_CS_ (SCOPE_ID_);
alter table VAR_DEF_CS_ add index SCOPE_DEF_CS_FK (SCOPE_ID_), add constraint SCOPE_DEF_CS_FK foreign key (SCOPE_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index SCOPE_INST_VAR_IDX on VAR_UPDATE_FULL_IMPL (SCOPE_ID_);
alter table VAR_UPDATE_FULL_IMPL add index SCOPE_INST_VAR_FK (SCOPE_ID_), add constraint SCOPE_INST_VAR_FK foreign key (SCOPE_ID_) references BPEL_ACTIVITY_INST (DBID_);
create index PICK_WAIT_IDX on WAITING_FULL_IMPL (PICK_ID_);
alter table WAITING_FULL_IMPL add index PICK_WAIT_FK (PICK_ID_), add constraint PICK_WAIT_FK foreign key (PICK_ID_) references BPEL_ACTIVITY_INST (DBID_);
create index FLOW_LINKS_IDX on linkList (FLOW_LINKS_ID_);
alter table linkList add index FLOW_LINKS_FK (FLOW_LINKS_ID_), add constraint FLOW_LINKS_FK foreign key (FLOW_LINKS_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index SCOPE_DEF_M_E_IDX on messageExchanges (SCOPE_ID_);
alter table messageExchanges add index SCOPE_DEF_M_E_FK (SCOPE_ID_), add constraint SCOPE_DEF_M_E_FK foreign key (SCOPE_ID_) references BPEL_BASE_ACTIVITY_DEF (DBID_);
create index CORR_ST_DEF_IDX on properties (CORR_ST_DEF_ID_);
alter table properties add index CORR_ST_DEF_FK (CORR_ST_DEF_ID_), add constraint CORR_ST_DEF_FK foreign key (CORR_ST_DEF_ID_) references VAR_DEF_CS_ (DBID_);
alter table wsdlDefinitions add index FKB6C7627C64EEA1B7 (WSDLINFOS_ID_), add constraint FKB6C7627C64EEA1B7 foreign key (WSDLINFOS_ID_) references NOVA_WSDLINFOS (DBID_);
