-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 23, 2009 at 03:11 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `ode`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_activity_recovery`
-- 

CREATE TABLE `ode_activity_recovery` (
  `ID` bigint(20) NOT NULL,
  `ACTIONS` varchar(255) collate latin1_general_ci default NULL,
  `ACTIVITY_ID` bigint(20) default NULL,
  `CHANNEL` varchar(255) collate latin1_general_ci default NULL,
  `DATE_TIME` datetime default NULL,
  `DETAILS` text collate latin1_general_ci,
  `INSTANCE_ID` bigint(20) default NULL,
  `REASON` varchar(255) collate latin1_general_ci default NULL,
  `RETRIES` int(11) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `I_D_CTVRY_INSTANCE` (`INSTANCE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_correlation_set`
-- 

CREATE TABLE `ode_correlation_set` (
  `CORRELATION_SET_ID` bigint(20) NOT NULL,
  `CORRELATION_KEY` varchar(255) collate latin1_general_ci default NULL,
  `NAME` varchar(255) collate latin1_general_ci default NULL,
  `SCOPE_ID` bigint(20) default NULL,
  PRIMARY KEY  (`CORRELATION_SET_ID`),
  KEY `I_D_CR_ST_SCOPE` (`SCOPE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_correlator`
-- 

CREATE TABLE `ode_correlator` (
  `CORRELATOR_ID` bigint(20) NOT NULL,
  `CORRELATOR_KEY` varchar(255) collate latin1_general_ci default NULL,
  `PROC_ID` bigint(20) default NULL,
  PRIMARY KEY  (`CORRELATOR_ID`),
  KEY `I_D_CRLTR_PROCESS` (`PROC_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_corset_prop`
-- 

CREATE TABLE `ode_corset_prop` (
  `ID` bigint(20) NOT NULL,
  `CORRSET_ID` bigint(20) default NULL,
  `PROP_KEY` varchar(255) collate latin1_general_ci default NULL,
  `PROP_VALUE` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID`),
  KEY `I_D_CRPRP_CORRSET` (`CORRSET_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_event`
-- 

CREATE TABLE `ode_event` (
  `EVENT_ID` bigint(20) NOT NULL,
  `DETAIL` varchar(255) collate latin1_general_ci default NULL,
  `DATA` blob,
  `SCOPE_ID` bigint(20) default NULL,
  `TSTAMP` datetime default NULL,
  `TYPE` varchar(255) collate latin1_general_ci default NULL,
  `INSTANCE_ID` bigint(20) default NULL,
  `PROCESS_ID` bigint(20) default NULL,
  PRIMARY KEY  (`EVENT_ID`),
  KEY `I_OD_VENT_INSTANCE` (`INSTANCE_ID`),
  KEY `I_OD_VENT_PROCESS` (`PROCESS_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_fault`
-- 

CREATE TABLE `ode_fault` (
  `FAULT_ID` bigint(20) NOT NULL,
  `ACTIVITY_ID` int(11) default NULL,
  `DATA` text collate latin1_general_ci,
  `MESSAGE` varchar(4000) collate latin1_general_ci default NULL,
  `LINE_NUMBER` int(11) default NULL,
  `NAME` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`FAULT_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_job`
-- 

CREATE TABLE `ode_job` (
  `jobid` char(64) collate latin1_general_ci NOT NULL default '',
  `ts` bigint(20) NOT NULL default '0',
  `nodeid` char(64) collate latin1_general_ci default NULL,
  `scheduled` int(11) NOT NULL default '0',
  `transacted` int(11) NOT NULL default '0',
  `details` blob,
  PRIMARY KEY  (`jobid`),
  KEY `IDX_ODE_JOB_TS` (`ts`),
  KEY `IDX_ODE_JOB_NODEID` (`nodeid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_message`
-- 

CREATE TABLE `ode_message` (
  `MESSAGE_ID` bigint(20) NOT NULL,
  `DATA` text collate latin1_general_ci,
  `HEADER` text collate latin1_general_ci,
  `TYPE` varchar(255) collate latin1_general_ci default NULL,
  `MESSAGE_EXCHANGE_ID` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`MESSAGE_ID`),
  KEY `I_OD_MSSG_MESSAGEEXCHANGE` (`MESSAGE_EXCHANGE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_message_exchange`
-- 

CREATE TABLE `ode_message_exchange` (
  `MESSAGE_EXCHANGE_ID` varchar(255) collate latin1_general_ci NOT NULL,
  `CALLEE` varchar(255) collate latin1_general_ci default NULL,
  `CHANNEL` varchar(255) collate latin1_general_ci default NULL,
  `CORRELATION_ID` varchar(255) collate latin1_general_ci default NULL,
  `CORRELATION_KEYS` varchar(255) collate latin1_general_ci default NULL,
  `CORRELATION_STATUS` varchar(255) collate latin1_general_ci default NULL,
  `CREATE_TIME` datetime default NULL,
  `DIRECTION` int(11) default NULL,
  `EPR` text collate latin1_general_ci,
  `FAULT` varchar(255) collate latin1_general_ci default NULL,
  `FAULT_EXPLANATION` varchar(255) collate latin1_general_ci default NULL,
  `OPERATION` varchar(255) collate latin1_general_ci default NULL,
  `PARTNER_LINK_MODEL_ID` int(11) default NULL,
  `PATTERN` varchar(255) collate latin1_general_ci default NULL,
  `PIPED_ID` varchar(255) collate latin1_general_ci default NULL,
  `PORT_TYPE` varchar(255) collate latin1_general_ci default NULL,
  `PROPAGATE_TRANS` bit(1) default NULL,
  `STATUS` varchar(255) collate latin1_general_ci default NULL,
  `SUBSCRIBER_COUNT` int(11) default NULL,
  `PROCESS_INSTANCE_ID` bigint(20) default NULL,
  `CORR_ID` bigint(20) default NULL,
  `PARTNER_LINK_ID` bigint(20) default NULL,
  `PROCESS_ID` bigint(20) default NULL,
  `REQUEST_MESSAGE_ID` bigint(20) default NULL,
  `RESPONSE_MESSAGE_ID` bigint(20) default NULL,
  PRIMARY KEY  (`MESSAGE_EXCHANGE_ID`),
  KEY `I_D_MSHNG_CORRELATOR` (`CORR_ID`),
  KEY `I_D_MSHNG_PARTNERLINK` (`PARTNER_LINK_ID`),
  KEY `I_D_MSHNG_PROCESS` (`PROCESS_ID`),
  KEY `I_D_MSHNG_PROCESSINST` (`PROCESS_INSTANCE_ID`),
  KEY `I_D_MSHNG_REQUEST` (`REQUEST_MESSAGE_ID`),
  KEY `I_D_MSHNG_RESPONSE` (`RESPONSE_MESSAGE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_message_route`
-- 

CREATE TABLE `ode_message_route` (
  `MESSAGE_ROUTE_ID` bigint(20) NOT NULL,
  `CORRELATION_KEY` varchar(255) collate latin1_general_ci default NULL,
  `GROUP_ID` varchar(255) collate latin1_general_ci default NULL,
  `ROUTE_INDEX` int(11) default NULL,
  `PROCESS_INSTANCE_ID` int(11) default NULL,
  `ROUTE_POLICY` varchar(16) collate latin1_general_ci default NULL,
  `CORR_ID` bigint(20) default NULL,
  PRIMARY KEY  (`MESSAGE_ROUTE_ID`),
  KEY `I_D_MS_RT_CORRELATOR` (`CORR_ID`),
  KEY `I_D_MS_RT_PROCESSINST` (`PROCESS_INSTANCE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_mex_prop`
-- 

CREATE TABLE `ode_mex_prop` (
  `ID` bigint(20) NOT NULL,
  `MEX_ID` varchar(255) collate latin1_general_ci default NULL,
  `PROP_KEY` varchar(255) collate latin1_general_ci default NULL,
  `PROP_VALUE` varchar(2000) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID`),
  KEY `I_D_MXPRP_MEX` (`MEX_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_partner_link`
-- 

CREATE TABLE `ode_partner_link` (
  `PARTNER_LINK_ID` bigint(20) NOT NULL,
  `MY_EPR` text collate latin1_general_ci,
  `MY_ROLE_NAME` varchar(255) collate latin1_general_ci default NULL,
  `MY_ROLE_SERVICE_NAME` varchar(255) collate latin1_general_ci default NULL,
  `MY_SESSION_ID` varchar(255) collate latin1_general_ci default NULL,
  `PARTNER_EPR` text collate latin1_general_ci,
  `PARTNER_LINK_MODEL_ID` int(11) default NULL,
  `PARTNER_LINK_NAME` varchar(255) collate latin1_general_ci default NULL,
  `PARTNER_ROLE_NAME` varchar(255) collate latin1_general_ci default NULL,
  `PARTNER_SESSION_ID` varchar(255) collate latin1_general_ci default NULL,
  `SCOPE_ID` bigint(20) default NULL,
  PRIMARY KEY  (`PARTNER_LINK_ID`),
  KEY `I_D_PRLNK_SCOPE` (`SCOPE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_process`
-- 

CREATE TABLE `ode_process` (
  `ID` bigint(20) NOT NULL,
  `GUID` varchar(255) collate latin1_general_ci default NULL,
  `PROCESS_ID` varchar(255) collate latin1_general_ci default NULL,
  `PROCESS_TYPE` varchar(255) collate latin1_general_ci default NULL,
  `VERSION` bigint(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_process_instance`
-- 

CREATE TABLE `ode_process_instance` (
  `ID` bigint(20) NOT NULL,
  `DATE_CREATED` datetime default NULL,
  `EXECUTION_STATE` blob,
  `FAULT_ID` bigint(20) default NULL,
  `LAST_ACTIVE_TIME` datetime default NULL,
  `LAST_RECOVERY_DATE` datetime default NULL,
  `PREVIOUS_STATE` smallint(6) default NULL,
  `SEQUENCE` bigint(20) default NULL,
  `INSTANCE_STATE` smallint(6) default NULL,
  `INSTANTIATING_CORRELATOR_ID` bigint(20) default NULL,
  `PROCESS_ID` bigint(20) default NULL,
  `ROOT_SCOPE_ID` bigint(20) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `I_D_PRTNC_FAULT` (`FAULT_ID`),
  KEY `I_D_PRTNC_INSTANTIATINGCORRELATOR` (`INSTANTIATING_CORRELATOR_ID`),
  KEY `I_D_PRTNC_PROCESS` (`PROCESS_ID`),
  KEY `I_D_PRTNC_ROOTSCOPE` (`ROOT_SCOPE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_scope`
-- 

CREATE TABLE `ode_scope` (
  `SCOPE_ID` bigint(20) NOT NULL,
  `MODEL_ID` int(11) default NULL,
  `SCOPE_NAME` varchar(255) collate latin1_general_ci default NULL,
  `SCOPE_STATE` varchar(255) collate latin1_general_ci default NULL,
  `PARENT_SCOPE_ID` bigint(20) default NULL,
  `PROCESS_INSTANCE_ID` bigint(20) default NULL,
  PRIMARY KEY  (`SCOPE_ID`),
  KEY `I_OD_SCOP_PARENTSCOPE` (`PARENT_SCOPE_ID`),
  KEY `I_OD_SCOP_PROCESSINSTANCE` (`PROCESS_INSTANCE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_xml_data`
-- 

CREATE TABLE `ode_xml_data` (
  `XML_DATA_ID` bigint(20) NOT NULL,
  `DATA` text collate latin1_general_ci,
  `IS_SIMPLE_TYPE` bit(1) default NULL,
  `NAME` varchar(255) collate latin1_general_ci default NULL,
  `SCOPE_ID` bigint(20) default NULL,
  PRIMARY KEY  (`XML_DATA_ID`),
  KEY `I_D_XM_DT_SCOPE` (`SCOPE_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `ode_xml_data_prop`
-- 

CREATE TABLE `ode_xml_data_prop` (
  `ID` bigint(20) NOT NULL,
  `XML_DATA_ID` bigint(20) default NULL,
  `PROP_KEY` varchar(255) collate latin1_general_ci default NULL,
  `PROP_VALUE` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ID`),
  KEY `I_D_XMPRP_XMLDATA` (`XML_DATA_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `openjpa_sequence_table`
-- 

CREATE TABLE `openjpa_sequence_table` (
  `ID` tinyint(4) NOT NULL,
  `SEQUENCE_VALUE` bigint(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `store_du`
-- 

CREATE TABLE `store_du` (
  `NAME` varchar(255) collate latin1_general_ci NOT NULL,
  `DEPLOYDT` datetime default NULL,
  `DEPLOYER` varchar(255) collate latin1_general_ci default NULL,
  `DIR` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `store_process`
-- 

CREATE TABLE `store_process` (
  `PID` varchar(255) collate latin1_general_ci NOT NULL,
  `STATE` varchar(255) collate latin1_general_ci default NULL,
  `TYPE` varchar(255) collate latin1_general_ci default NULL,
  `VERSION` bigint(20) default NULL,
  `DU` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`PID`),
  KEY `I_STR_CSS_DU` (`DU`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `store_process_prop`
-- 

CREATE TABLE `store_process_prop` (
  `id` bigint(20) NOT NULL,
  `PROP_KEY` varchar(255) collate latin1_general_ci default NULL,
  `PROP_VAL` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `store_proc_to_prop`
-- 

CREATE TABLE `store_proc_to_prop` (
  `PROCESSCONFDAOIMPL_PID` varchar(255) collate latin1_general_ci default NULL,
  `ELEMENT_ID` bigint(20) default NULL,
  KEY `I_STR_PRP_ELEMENT` (`ELEMENT_ID`),
  KEY `I_STR_PRP_PROCESSCONFDAOIMPL_PID` (`PROCESSCONFDAOIMPL_PID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `store_versions`
-- 

CREATE TABLE `store_versions` (
  `id` bigint(20) NOT NULL,
  `VERSION` bigint(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
