create table `JOB` (`OID` bigint unsigned, `SOURCE` text, `CLASS_NAME` text, `OID_ROOT` bigint unsigned, `EXECUTOR_CLASS` text, `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT)) type=InnoDB, character set latin1;
create table `JOB_EXECUTION_CONTEXT` (`OID` bigint unsigned, `OID_RESULT` bigint unsigned, `OID_QUEUE` bigint unsigned, `OID_JOB` bigint unsigned, `OID_STALLED_QUEUE` bigint unsigned, `OID_LOG` bigint unsigned, `REQUEST` timestamp NULL default NULL, `OID_INPUT` bigint unsigned, `OID_SCHEDULE` bigint unsigned, `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `PARAMETER` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_QUEUE), index (OID_JOB), index (OID_STALLED_QUEUE)) type=InnoDB, character set latin1;
create table `JOB_PLUGIN_ROOT` (`OID` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID)) type=InnoDB, character set latin1;
create table `JOB_SCHEDULE` (`PATTERN` text, `OID` bigint unsigned, `OID_ROOT` bigint unsigned, `OID_CONTEXT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT)) type=InnoDB, character set latin1;
create table `JOB_EXECUTION_LOG` (`SUCCESSFUL` tinyint(1), `OID` bigint unsigned, `START` timestamp NULL default NULL, `END` timestamp NULL default NULL, `OUTPUT` text, `OID_RETRY` bigint unsigned, `OID_PREVIOUS` bigint unsigned, `OID_CONTEXT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID)) type=InnoDB, character set latin1;
alter table `GENERIC_FILE` add `OID_IO_EXECUTION_CONTEXT` bigint unsigned, add `OID_EXECUTION_CONTEXT` bigint unsigned;
