- 浏览: 47197 次
- 性别:
- 来自: 广州
最新评论
JBPM的ORACLE脚本
create table JBPM4_DEPLOYMENT (
DBID_ number(19,0) not null,
NAME_ clob,
TIMESTAMP_ number(19,0),
STATE_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_DEPLOYPROP (
DBID_ number(19,0) not null,
DEPLOYMENT_ number(19,0),
OBJNAME_ varchar2(255 char),
KEY_ varchar2(255 char),
STRINGVAL_ varchar2(255 char),
LONGVAL_ number(19,0),
primary key (DBID_)
);
create table JBPM4_EXECUTION (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
ACTIVITYNAME_ varchar2(255 char),
PROCDEFID_ varchar2(255 char),
HASVARS_ number(1,0),
NAME_ varchar2(255 char),
KEY_ varchar2(255 char),
ID_ varchar2(255 char) unique,
STATE_ varchar2(255 char),
SUSPHISTSTATE_ varchar2(255 char),
PRIORITY_ number(10,0),
HISACTINST_ number(19,0),
PARENT_ number(19,0),
INSTANCE_ number(19,0),
SUPEREXEC_ number(19,0),
SUBPROCINST_ number(19,0),
PARENT_IDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_ACTINST (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
HPROCI_ number(19,0),
TYPE_ varchar2(255 char),
EXECUTION_ varchar2(255 char),
ACTIVITY_NAME_ varchar2(255 char),
START_ timestamp,
END_ timestamp,
DURATION_ number(19,0),
TRANSITION_ varchar2(255 char),
NEXTIDX_ number(10,0),
HTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_DETAIL (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
USERID_ varchar2(255 char),
TIME_ timestamp,
HPROCI_ number(19,0),
HPROCIIDX_ number(10,0),
HACTI_ number(19,0),
HACTIIDX_ number(10,0),
HTASK_ number(19,0),
HTASKIDX_ number(10,0),
HVAR_ number(19,0),
HVARIDX_ number(10,0),
MESSAGE_ clob,
OLD_STR_ varchar2(255 char),
NEW_STR_ varchar2(255 char),
OLD_INT_ number(10,0),
NEW_INT_ number(10,0),
OLD_TIME_ timestamp,
NEW_TIME_ timestamp,
PARENT_ number(19,0),
PARENT_IDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_PROCINST (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar2(255 char),
PROCDEFID_ varchar2(255 char),
KEY_ varchar2(255 char),
START_ timestamp,
END_ timestamp,
DURATION_ number(19,0),
STATE_ varchar2(255 char),
ENDACTIVITY_ varchar2(255 char),
NEXTIDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_TASK (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
EXECUTION_ varchar2(255 char),
OUTCOME_ varchar2(255 char),
ASSIGNEE_ varchar2(255 char),
PRIORITY_ number(10,0),
STATE_ varchar2(255 char),
CREATE_ timestamp,
END_ timestamp,
DURATION_ number(19,0),
NEXTIDX_ number(10,0),
SUPERTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_VAR (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
PROCINSTID_ varchar2(255 char),
EXECUTIONID_ varchar2(255 char),
VARNAME_ varchar2(255 char),
VALUE_ varchar2(255 char),
HPROCI_ number(19,0),
HTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_ID_GROUP (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar2(255 char),
NAME_ varchar2(255 char),
TYPE_ varchar2(255 char),
PARENT_ number(19,0),
primary key (DBID_)
);
create table JBPM4_ID_MEMBERSHIP (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
USER_ number(19,0),
GROUP_ number(19,0),
NAME_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_ID_USER (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar2(255 char),
PASSWORD_ varchar2(255 char),
GIVENNAME_ varchar2(255 char),
FAMILYNAME_ varchar2(255 char),
BUSINESSEMAIL_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_JOB (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
DUEDATE_ timestamp,
STATE_ varchar2(255 char),
ISEXCLUSIVE_ number(1,0),
LOCKOWNER_ varchar2(255 char),
LOCKEXPTIME_ timestamp,
EXCEPTION_ clob,
RETRIES_ number(10,0),
PROCESSINSTANCE_ number(19,0),
EXECUTION_ number(19,0),
CFG_ number(19,0),
SIGNAL_ varchar2(255 char),
EVENT_ varchar2(255 char),
REPEAT_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_LOB (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
BLOB_VALUE_ blob,
DEPLOYMENT_ number(19,0),
NAME_ clob,
primary key (DBID_)
);
create table JBPM4_PARTICIPATION (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
GROUPID_ varchar2(255 char),
USERID_ varchar2(255 char),
TYPE_ varchar2(255 char),
TASK_ number(19,0),
SWIMLANE_ number(19,0),
primary key (DBID_)
);
create table JBPM4_PROPERTY (
KEY_ varchar2(255 char) not null,
VERSION_ number(10,0) not null,
VALUE_ varchar2(255 char),
primary key (KEY_)
);
create table JBPM4_SWIMLANE (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
NAME_ varchar2(255 char),
ASSIGNEE_ varchar2(255 char),
EXECUTION_ number(19,0),
primary key (DBID_)
);
create table JBPM4_TASK (
DBID_ number(19,0) not null,
CLASS_ char(1 char) not null,
DBVERSION_ number(10,0) not null,
NAME_ varchar2(255 char),
DESCR_ clob,
STATE_ varchar2(255 char),
SUSPHISTSTATE_ varchar2(255 char),
ASSIGNEE_ varchar2(255 char),
FORM_ varchar2(255 char),
PRIORITY_ number(10,0),
CREATE_ timestamp,
DUEDATE_ timestamp,
PROGRESS_ number(10,0),
SIGNALLING_ number(1,0),
EXECUTION_ID_ varchar2(255 char),
ACTIVITY_NAME_ varchar2(255 char),
HASVARS_ number(1,0),
SUPERTASK_ number(19,0),
EXECUTION_ number(19,0),
PROCINST_ number(19,0),
SWIMLANE_ number(19,0),
TASKDEFNAME_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_VARIABLE (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
KEY_ varchar2(255 char),
CONVERTER_ varchar2(255 char),
HIST_ number(1,0),
EXECUTION_ number(19,0),
TASK_ number(19,0),
LOB_ number(19,0),
DATE_VALUE_ timestamp,
DOUBLE_VALUE_ double precision,
CLASSNAME_ varchar2(255 char),
LONG_VALUE_ number(19,0),
STRING_VALUE_ varchar2(255 char),
TEXT_VALUE_ clob,
EXESYS_ number(19,0),
primary key (DBID_)
);
create index IDX_DEPLPROP_DEPL on JBPM4_DEPLOYPROP (DEPLOYMENT_);
alter table JBPM4_DEPLOYPROP
add constraint FK_DEPLPROP_DEPL
foreign key (DEPLOYMENT_)
references JBPM4_DEPLOYMENT;
create index IDX_EXEC_SUPEREXEC on JBPM4_EXECUTION (SUPEREXEC_);
create index IDX_EXEC_INSTANCE on JBPM4_EXECUTION (INSTANCE_);
create index IDX_EXEC_SUBPI on JBPM4_EXECUTION (SUBPROCINST_);
create index IDX_EXEC_PARENT on JBPM4_EXECUTION (PARENT_);
alter table JBPM4_EXECUTION
add constraint FK_EXEC_PARENT
foreign key (PARENT_)
references JBPM4_EXECUTION;
alter table JBPM4_EXECUTION
add constraint FK_EXEC_SUBPI
foreign key (SUBPROCINST_)
references JBPM4_EXECUTION;
alter table JBPM4_EXECUTION
add constraint FK_EXEC_INSTANCE
foreign key (INSTANCE_)
references JBPM4_EXECUTION;
alter table JBPM4_EXECUTION
add constraint FK_EXEC_SUPEREXEC
foreign key (SUPEREXEC_)
references JBPM4_EXECUTION;
create index IDX_HACTI_HPROCI on JBPM4_HIST_ACTINST (HPROCI_);
create index IDX_HTI_HTASK on JBPM4_HIST_ACTINST (HTASK_);
alter table JBPM4_HIST_ACTINST
add constraint FK_HACTI_HPROCI
foreign key (HPROCI_)
references JBPM4_HIST_PROCINST;
alter table JBPM4_HIST_ACTINST
add constraint FK_HTI_HTASK
foreign key (HTASK_)
references JBPM4_HIST_TASK;
create index IDX_HDET_HACTI on JBPM4_HIST_DETAIL (HACTI_);
create index IDX_HDET_HPROCI on JBPM4_HIST_DETAIL (HPROCI_);
create index IDX_HDET_HVAR on JBPM4_HIST_DETAIL (HVAR_);
create index IDX_HDET_HTASK on JBPM4_HIST_DETAIL (HTASK_);
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HPROCI
foreign key (HPROCI_)
references JBPM4_HIST_PROCINST;
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HACTI
foreign key (HACTI_)
references JBPM4_HIST_ACTINST;
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HTASK
foreign key (HTASK_)
references JBPM4_HIST_TASK;
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HVAR
foreign key (HVAR_)
references JBPM4_HIST_VAR;
create index IDX_HSUPERT_SUB on JBPM4_HIST_TASK (SUPERTASK_);
alter table JBPM4_HIST_TASK
add constraint FK_HSUPERT_SUB
foreign key (SUPERTASK_)
references JBPM4_HIST_TASK;
create index IDX_HVAR_HPROCI on JBPM4_HIST_VAR (HPROCI_);
create index IDX_HVAR_HTASK on JBPM4_HIST_VAR (HTASK_);
alter table JBPM4_HIST_VAR
add constraint FK_HVAR_HPROCI
foreign key (HPROCI_)
references JBPM4_HIST_PROCINST;
alter table JBPM4_HIST_VAR
add constraint FK_HVAR_HTASK
foreign key (HTASK_)
references JBPM4_HIST_TASK;
create index IDX_GROUP_PARENT on JBPM4_ID_GROUP (PARENT_);
alter table JBPM4_ID_GROUP
add constraint FK_GROUP_PARENT
foreign key (PARENT_)
references JBPM4_ID_GROUP;
create index IDX_MEM_USER on JBPM4_ID_MEMBERSHIP (USER_);
create index IDX_MEM_GROUP on JBPM4_ID_MEMBERSHIP (GROUP_);
alter table JBPM4_ID_MEMBERSHIP
add constraint FK_MEM_GROUP
foreign key (GROUP_)
references JBPM4_ID_GROUP;
alter table JBPM4_ID_MEMBERSHIP
add constraint FK_MEM_USER
foreign key (USER_)
references JBPM4_ID_USER;
create index IDX_JOBRETRIES on JBPM4_JOB (RETRIES_);
create index IDX_JOB_CFG on JBPM4_JOB (CFG_);
create index IDX_JOB_PRINST on JBPM4_JOB (PROCESSINSTANCE_);
create index IDX_JOB_EXE on JBPM4_JOB (EXECUTION_);
create index IDX_JOBLOCKEXP on JBPM4_JOB (LOCKEXPTIME_);
create index IDX_JOBDUEDATE on JBPM4_JOB (DUEDATE_);
alter table JBPM4_JOB
add constraint FK_JOB_CFG
foreign key (CFG_)
references JBPM4_LOB;
create index IDX_LOB_DEPLOYMENT on JBPM4_LOB (DEPLOYMENT_);
alter table JBPM4_LOB
add constraint FK_LOB_DEPLOYMENT
foreign key (DEPLOYMENT_)
references JBPM4_DEPLOYMENT;
create index IDX_PART_TASK on JBPM4_PARTICIPATION (TASK_);
alter table JBPM4_PARTICIPATION
add constraint FK_PART_SWIMLANE
foreign key (SWIMLANE_)
references JBPM4_SWIMLANE;
alter table JBPM4_PARTICIPATION
add constraint FK_PART_TASK
foreign key (TASK_)
references JBPM4_TASK;
create index IDX_SWIMLANE_EXEC on JBPM4_SWIMLANE (EXECUTION_);
alter table JBPM4_SWIMLANE
add constraint FK_SWIMLANE_EXEC
foreign key (EXECUTION_)
references JBPM4_EXECUTION;
create index IDX_TASK_SUPERTASK on JBPM4_TASK (SUPERTASK_);
alter table JBPM4_TASK
add constraint FK_TASK_SWIML
foreign key (SWIMLANE_)
references JBPM4_SWIMLANE;
alter table JBPM4_TASK
add constraint FK_TASK_SUPERTASK
foreign key (SUPERTASK_)
references JBPM4_TASK;
create index IDX_VAR_EXESYS on JBPM4_VARIABLE (EXESYS_);
create index IDX_VAR_TASK on JBPM4_VARIABLE (TASK_);
create index IDX_VAR_EXECUTION on JBPM4_VARIABLE (EXECUTION_);
create index IDX_VAR_LOB on JBPM4_VARIABLE (LOB_);
alter table JBPM4_VARIABLE
add constraint FK_VAR_LOB
foreign key (LOB_)
references JBPM4_LOB;
alter table JBPM4_VARIABLE
add constraint FK_VAR_EXECUTION
foreign key (EXECUTION_)
references JBPM4_EXECUTION;
alter table JBPM4_VARIABLE
add constraint FK_VAR_EXESYS
foreign key (EXESYS_)
references JBPM4_EXECUTION;
alter table JBPM4_VARIABLE
add constraint FK_VAR_TASK
foreign key (TASK_)
references JBPM4_TASK;
DBID_ number(19,0) not null,
NAME_ clob,
TIMESTAMP_ number(19,0),
STATE_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_DEPLOYPROP (
DBID_ number(19,0) not null,
DEPLOYMENT_ number(19,0),
OBJNAME_ varchar2(255 char),
KEY_ varchar2(255 char),
STRINGVAL_ varchar2(255 char),
LONGVAL_ number(19,0),
primary key (DBID_)
);
create table JBPM4_EXECUTION (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
ACTIVITYNAME_ varchar2(255 char),
PROCDEFID_ varchar2(255 char),
HASVARS_ number(1,0),
NAME_ varchar2(255 char),
KEY_ varchar2(255 char),
ID_ varchar2(255 char) unique,
STATE_ varchar2(255 char),
SUSPHISTSTATE_ varchar2(255 char),
PRIORITY_ number(10,0),
HISACTINST_ number(19,0),
PARENT_ number(19,0),
INSTANCE_ number(19,0),
SUPEREXEC_ number(19,0),
SUBPROCINST_ number(19,0),
PARENT_IDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_ACTINST (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
HPROCI_ number(19,0),
TYPE_ varchar2(255 char),
EXECUTION_ varchar2(255 char),
ACTIVITY_NAME_ varchar2(255 char),
START_ timestamp,
END_ timestamp,
DURATION_ number(19,0),
TRANSITION_ varchar2(255 char),
NEXTIDX_ number(10,0),
HTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_DETAIL (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
USERID_ varchar2(255 char),
TIME_ timestamp,
HPROCI_ number(19,0),
HPROCIIDX_ number(10,0),
HACTI_ number(19,0),
HACTIIDX_ number(10,0),
HTASK_ number(19,0),
HTASKIDX_ number(10,0),
HVAR_ number(19,0),
HVARIDX_ number(10,0),
MESSAGE_ clob,
OLD_STR_ varchar2(255 char),
NEW_STR_ varchar2(255 char),
OLD_INT_ number(10,0),
NEW_INT_ number(10,0),
OLD_TIME_ timestamp,
NEW_TIME_ timestamp,
PARENT_ number(19,0),
PARENT_IDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_PROCINST (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar2(255 char),
PROCDEFID_ varchar2(255 char),
KEY_ varchar2(255 char),
START_ timestamp,
END_ timestamp,
DURATION_ number(19,0),
STATE_ varchar2(255 char),
ENDACTIVITY_ varchar2(255 char),
NEXTIDX_ number(10,0),
primary key (DBID_)
);
create table JBPM4_HIST_TASK (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
EXECUTION_ varchar2(255 char),
OUTCOME_ varchar2(255 char),
ASSIGNEE_ varchar2(255 char),
PRIORITY_ number(10,0),
STATE_ varchar2(255 char),
CREATE_ timestamp,
END_ timestamp,
DURATION_ number(19,0),
NEXTIDX_ number(10,0),
SUPERTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_HIST_VAR (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
PROCINSTID_ varchar2(255 char),
EXECUTIONID_ varchar2(255 char),
VARNAME_ varchar2(255 char),
VALUE_ varchar2(255 char),
HPROCI_ number(19,0),
HTASK_ number(19,0),
primary key (DBID_)
);
create table JBPM4_ID_GROUP (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar2(255 char),
NAME_ varchar2(255 char),
TYPE_ varchar2(255 char),
PARENT_ number(19,0),
primary key (DBID_)
);
create table JBPM4_ID_MEMBERSHIP (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
USER_ number(19,0),
GROUP_ number(19,0),
NAME_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_ID_USER (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
ID_ varchar2(255 char),
PASSWORD_ varchar2(255 char),
GIVENNAME_ varchar2(255 char),
FAMILYNAME_ varchar2(255 char),
BUSINESSEMAIL_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_JOB (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
DUEDATE_ timestamp,
STATE_ varchar2(255 char),
ISEXCLUSIVE_ number(1,0),
LOCKOWNER_ varchar2(255 char),
LOCKEXPTIME_ timestamp,
EXCEPTION_ clob,
RETRIES_ number(10,0),
PROCESSINSTANCE_ number(19,0),
EXECUTION_ number(19,0),
CFG_ number(19,0),
SIGNAL_ varchar2(255 char),
EVENT_ varchar2(255 char),
REPEAT_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_LOB (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
BLOB_VALUE_ blob,
DEPLOYMENT_ number(19,0),
NAME_ clob,
primary key (DBID_)
);
create table JBPM4_PARTICIPATION (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
GROUPID_ varchar2(255 char),
USERID_ varchar2(255 char),
TYPE_ varchar2(255 char),
TASK_ number(19,0),
SWIMLANE_ number(19,0),
primary key (DBID_)
);
create table JBPM4_PROPERTY (
KEY_ varchar2(255 char) not null,
VERSION_ number(10,0) not null,
VALUE_ varchar2(255 char),
primary key (KEY_)
);
create table JBPM4_SWIMLANE (
DBID_ number(19,0) not null,
DBVERSION_ number(10,0) not null,
NAME_ varchar2(255 char),
ASSIGNEE_ varchar2(255 char),
EXECUTION_ number(19,0),
primary key (DBID_)
);
create table JBPM4_TASK (
DBID_ number(19,0) not null,
CLASS_ char(1 char) not null,
DBVERSION_ number(10,0) not null,
NAME_ varchar2(255 char),
DESCR_ clob,
STATE_ varchar2(255 char),
SUSPHISTSTATE_ varchar2(255 char),
ASSIGNEE_ varchar2(255 char),
FORM_ varchar2(255 char),
PRIORITY_ number(10,0),
CREATE_ timestamp,
DUEDATE_ timestamp,
PROGRESS_ number(10,0),
SIGNALLING_ number(1,0),
EXECUTION_ID_ varchar2(255 char),
ACTIVITY_NAME_ varchar2(255 char),
HASVARS_ number(1,0),
SUPERTASK_ number(19,0),
EXECUTION_ number(19,0),
PROCINST_ number(19,0),
SWIMLANE_ number(19,0),
TASKDEFNAME_ varchar2(255 char),
primary key (DBID_)
);
create table JBPM4_VARIABLE (
DBID_ number(19,0) not null,
CLASS_ varchar2(255 char) not null,
DBVERSION_ number(10,0) not null,
KEY_ varchar2(255 char),
CONVERTER_ varchar2(255 char),
HIST_ number(1,0),
EXECUTION_ number(19,0),
TASK_ number(19,0),
LOB_ number(19,0),
DATE_VALUE_ timestamp,
DOUBLE_VALUE_ double precision,
CLASSNAME_ varchar2(255 char),
LONG_VALUE_ number(19,0),
STRING_VALUE_ varchar2(255 char),
TEXT_VALUE_ clob,
EXESYS_ number(19,0),
primary key (DBID_)
);
create index IDX_DEPLPROP_DEPL on JBPM4_DEPLOYPROP (DEPLOYMENT_);
alter table JBPM4_DEPLOYPROP
add constraint FK_DEPLPROP_DEPL
foreign key (DEPLOYMENT_)
references JBPM4_DEPLOYMENT;
create index IDX_EXEC_SUPEREXEC on JBPM4_EXECUTION (SUPEREXEC_);
create index IDX_EXEC_INSTANCE on JBPM4_EXECUTION (INSTANCE_);
create index IDX_EXEC_SUBPI on JBPM4_EXECUTION (SUBPROCINST_);
create index IDX_EXEC_PARENT on JBPM4_EXECUTION (PARENT_);
alter table JBPM4_EXECUTION
add constraint FK_EXEC_PARENT
foreign key (PARENT_)
references JBPM4_EXECUTION;
alter table JBPM4_EXECUTION
add constraint FK_EXEC_SUBPI
foreign key (SUBPROCINST_)
references JBPM4_EXECUTION;
alter table JBPM4_EXECUTION
add constraint FK_EXEC_INSTANCE
foreign key (INSTANCE_)
references JBPM4_EXECUTION;
alter table JBPM4_EXECUTION
add constraint FK_EXEC_SUPEREXEC
foreign key (SUPEREXEC_)
references JBPM4_EXECUTION;
create index IDX_HACTI_HPROCI on JBPM4_HIST_ACTINST (HPROCI_);
create index IDX_HTI_HTASK on JBPM4_HIST_ACTINST (HTASK_);
alter table JBPM4_HIST_ACTINST
add constraint FK_HACTI_HPROCI
foreign key (HPROCI_)
references JBPM4_HIST_PROCINST;
alter table JBPM4_HIST_ACTINST
add constraint FK_HTI_HTASK
foreign key (HTASK_)
references JBPM4_HIST_TASK;
create index IDX_HDET_HACTI on JBPM4_HIST_DETAIL (HACTI_);
create index IDX_HDET_HPROCI on JBPM4_HIST_DETAIL (HPROCI_);
create index IDX_HDET_HVAR on JBPM4_HIST_DETAIL (HVAR_);
create index IDX_HDET_HTASK on JBPM4_HIST_DETAIL (HTASK_);
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HPROCI
foreign key (HPROCI_)
references JBPM4_HIST_PROCINST;
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HACTI
foreign key (HACTI_)
references JBPM4_HIST_ACTINST;
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HTASK
foreign key (HTASK_)
references JBPM4_HIST_TASK;
alter table JBPM4_HIST_DETAIL
add constraint FK_HDETAIL_HVAR
foreign key (HVAR_)
references JBPM4_HIST_VAR;
create index IDX_HSUPERT_SUB on JBPM4_HIST_TASK (SUPERTASK_);
alter table JBPM4_HIST_TASK
add constraint FK_HSUPERT_SUB
foreign key (SUPERTASK_)
references JBPM4_HIST_TASK;
create index IDX_HVAR_HPROCI on JBPM4_HIST_VAR (HPROCI_);
create index IDX_HVAR_HTASK on JBPM4_HIST_VAR (HTASK_);
alter table JBPM4_HIST_VAR
add constraint FK_HVAR_HPROCI
foreign key (HPROCI_)
references JBPM4_HIST_PROCINST;
alter table JBPM4_HIST_VAR
add constraint FK_HVAR_HTASK
foreign key (HTASK_)
references JBPM4_HIST_TASK;
create index IDX_GROUP_PARENT on JBPM4_ID_GROUP (PARENT_);
alter table JBPM4_ID_GROUP
add constraint FK_GROUP_PARENT
foreign key (PARENT_)
references JBPM4_ID_GROUP;
create index IDX_MEM_USER on JBPM4_ID_MEMBERSHIP (USER_);
create index IDX_MEM_GROUP on JBPM4_ID_MEMBERSHIP (GROUP_);
alter table JBPM4_ID_MEMBERSHIP
add constraint FK_MEM_GROUP
foreign key (GROUP_)
references JBPM4_ID_GROUP;
alter table JBPM4_ID_MEMBERSHIP
add constraint FK_MEM_USER
foreign key (USER_)
references JBPM4_ID_USER;
create index IDX_JOBRETRIES on JBPM4_JOB (RETRIES_);
create index IDX_JOB_CFG on JBPM4_JOB (CFG_);
create index IDX_JOB_PRINST on JBPM4_JOB (PROCESSINSTANCE_);
create index IDX_JOB_EXE on JBPM4_JOB (EXECUTION_);
create index IDX_JOBLOCKEXP on JBPM4_JOB (LOCKEXPTIME_);
create index IDX_JOBDUEDATE on JBPM4_JOB (DUEDATE_);
alter table JBPM4_JOB
add constraint FK_JOB_CFG
foreign key (CFG_)
references JBPM4_LOB;
create index IDX_LOB_DEPLOYMENT on JBPM4_LOB (DEPLOYMENT_);
alter table JBPM4_LOB
add constraint FK_LOB_DEPLOYMENT
foreign key (DEPLOYMENT_)
references JBPM4_DEPLOYMENT;
create index IDX_PART_TASK on JBPM4_PARTICIPATION (TASK_);
alter table JBPM4_PARTICIPATION
add constraint FK_PART_SWIMLANE
foreign key (SWIMLANE_)
references JBPM4_SWIMLANE;
alter table JBPM4_PARTICIPATION
add constraint FK_PART_TASK
foreign key (TASK_)
references JBPM4_TASK;
create index IDX_SWIMLANE_EXEC on JBPM4_SWIMLANE (EXECUTION_);
alter table JBPM4_SWIMLANE
add constraint FK_SWIMLANE_EXEC
foreign key (EXECUTION_)
references JBPM4_EXECUTION;
create index IDX_TASK_SUPERTASK on JBPM4_TASK (SUPERTASK_);
alter table JBPM4_TASK
add constraint FK_TASK_SWIML
foreign key (SWIMLANE_)
references JBPM4_SWIMLANE;
alter table JBPM4_TASK
add constraint FK_TASK_SUPERTASK
foreign key (SUPERTASK_)
references JBPM4_TASK;
create index IDX_VAR_EXESYS on JBPM4_VARIABLE (EXESYS_);
create index IDX_VAR_TASK on JBPM4_VARIABLE (TASK_);
create index IDX_VAR_EXECUTION on JBPM4_VARIABLE (EXECUTION_);
create index IDX_VAR_LOB on JBPM4_VARIABLE (LOB_);
alter table JBPM4_VARIABLE
add constraint FK_VAR_LOB
foreign key (LOB_)
references JBPM4_LOB;
alter table JBPM4_VARIABLE
add constraint FK_VAR_EXECUTION
foreign key (EXECUTION_)
references JBPM4_EXECUTION;
alter table JBPM4_VARIABLE
add constraint FK_VAR_EXESYS
foreign key (EXESYS_)
references JBPM4_EXECUTION;
alter table JBPM4_VARIABLE
add constraint FK_VAR_TASK
foreign key (TASK_)
references JBPM4_TASK;
相关推荐
生成基于Oracle的jBPM数据库脚本 1. 下载最新版本的 JBoss jBPM Starters kit。解压这个文件,假设解压目录为 "${jbpm.starters.kit}",它的下面应该有 jbpm, jbpm-bpel,jbpm-db,jbpm-designer,jbpm-server 五...
jbpm一些常用脚本
在网上找了很多关于怎样生成jbpm-oracle数据库脚本的文章,没有一个能真正解决实际过程中遇到的问题。后来才知道,那里有一个包的java文件方法同名了,删除之后,就生成成功了!下载我打个包上传给需要的人。
JBPM采购申请系统——07_JBPM中的脚本语言.7z JBPM采购申请系统——07_JBPM中的脚本语言.7z JBPM采购申请系统——07_JBPM中的脚本语言.7z JBPM采购申请系统——07_JBPM中的脚本语言.7z JBPM采购申请系统——07_JBPM...
jbpm项目数据库脚本,项目框架:SSH+extjs+jbpm 项目地址:http://www.zuidaima.com/share/1989287537953792.htm
JBPM数据库表创建\jbpm.jpdl.oracle.sqlJBPM数据库表创建\jbpm.jpdl.oracle.sqlJBPM数据库表创建\jbpm.jpdl.oracle.sqlJBPM数据库表创建\jbpm.jpdl.oracle.sqlJBPM数据库表创建\jbpm.jpdl.oracle.sql
JBPM4.4 mysql数据库创建脚本,修正ant create.jbpm.schema不能创建数据库的bug。
jbpm常用数据库脚本 博文链接:https://yxgyh.iteye.com/blog/223599
jbpm tomcat oracle 集成环境配置以及开发
BeanShell是一种非常宽松的脚本语言,BeanShell中使用的语言与Java语言一致。
jbpm4.4 DB2数据库脚本,可直接执行sql脚本,创建jbpm4.4 数据库表
jbpm所南的新sql脚本mysql.identity.script.jbpm321
jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍jbpm介绍
jbpm_jboss+oracle集成
jbpm jbpm4.3.jar DDDDDDDD
\jbpm简介\jbpm简介\jbpm简介\jbpm简介\jbpm简介
jbpm4.3数据库创建的sqlserver脚本
由于jbpm4.4没有提供SqlServer 相关建表语句,需要我们自己去建立,个人拿原来的sql文件修改了一下,希望对大家有用。。直接打开执行就可以了!!
jbpm 数据库jbpm 数据库jbpm 数据库jbpm 数据库jbpm 数据库
jbpm使用案例,非常不错,大家都来看看吧。