create table JBPM4_DEPLOYMENT ( DBID_ numeric(19,0) not null, NAME_ varchar(255), TIMESTAMP_ numeric(19,0), STATE_ varchar(255), primary key (DBID_) ); create table JBPM4_DEPLOYPROP ( DBID_ numeric(19,0) not null, DEPLOYMENT_ numeric(19,0), OBJNAME_ varchar(255), KEY_ varchar(255), STRINGVAL_ varchar(255), LONGVAL_ numeric(19,0), primary key (DBID_) ); create table JBPM4_EXECUTION ( DBID_ numeric(19,0) not null, CLASS_ varchar(255) not null, DBVERSION_ numeric(10,0) not null, ACTIVITYNAME_ varchar(255), PROCDEFID_ varchar(255), HASVARS_ numeric(1,0), NAME_ varchar(255), KEY_ varchar(255), ID_ varchar(255) unique, STATE_ varchar(255), SUSPHISTSTATE_ varchar(255), PRIORITY_ numeric(10,0), HISACTINST_ numeric(19,0), PARENT_ numeric(19,0), INSTANCE_ numeric(19,0), SUPEREXEC_ numeric(19,0), SUBPROCINST_ numeric(19,0), PARENT_IDX_ numeric(10,0), primary key (DBID_) ); create table JBPM4_HIST_ACTINST ( DBID_ numeric(19,0) not null, CLASS_ varchar(255) not null, DBVERSION_ numeric(10,0) not null, HPROCI_ numeric(19,0), TYPE_ varchar(255), EXECUTION_ varchar(255), ACTIVITY_NAME_ varchar(255), START_ datetime, END_ datetime, DURATION_ numeric(19,0), TRANSITION_ varchar(255), NEXTIDX_ numeric(10,0), HTASK_ numeric(19,0), primary key (DBID_) ); create table JBPM4_HIST_DETAIL ( DBID_ numeric(19,0) not null, CLASS_ varchar(255) not null, DBVERSION_ numeric(10,0) not null, USERID_ varchar(255), TIME_ datetime, HPROCI_ numeric(19,0), HPROCIIDX_ numeric(10,0), HACTI_ numeric(19,0), HACTIIDX_ numeric(10,0), HTASK_ numeric(19,0), HTASKIDX_ numeric(10,0), HVAR_ numeric(19,0), HVARIDX_ numeric(10,0), MESSAGE_ varchar(255), OLD_STR_ varchar(255), NEW_STR_ varchar(255), OLD_INT_ numeric(10,0), NEW_INT_ numeric(10,0), OLD_TIME_ datetime, NEW_TIME_ datetime, PARENT_ numeric(19,0), PARENT_IDX_ numeric(10,0), primary key (DBID_) ); create table JBPM4_HIST_PROCINST ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, ID_ varchar(255), PROCDEFID_ varchar(255), KEY_ varchar(255), START_ datetime, END_ datetime, DURATION_ numeric(19,0), STATE_ varchar(255), ENDACTIVITY_ varchar(255), NEXTIDX_ numeric(10,0), primary key (DBID_) ); create table JBPM4_HIST_TASK ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, EXECUTION_ varchar(255), OUTCOME_ varchar(255), ASSIGNEE_ varchar(255), PRIORITY_ numeric(10,0), STATE_ varchar(255), CREATE_ datetime, END_ datetime, DURATION_ numeric(19,0), NEXTIDX_ numeric(10,0), SUPERTASK_ numeric(19,0), primary key (DBID_) ); create table JBPM4_HIST_VAR ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, PROCINSTID_ varchar(255), EXECUTIONID_ varchar(255), VARNAME_ varchar(255), VALUE_ varchar(255), HPROCI_ numeric(19,0), HTASK_ numeric(19,0), primary key (DBID_) ); create table JBPM4_ID_GROUP ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, ID_ varchar(255), NAME_ varchar(255), TYPE_ varchar(255), PARENT_ numeric(19,0), primary key (DBID_) ); create table JBPM4_ID_MEMBERSHIP ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, USER_ numeric(19,0), GROUP_ numeric(19,0), NAME_ varchar(255), primary key (DBID_) ); create table JBPM4_ID_USER ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, ID_ varchar(255), PASSWORD_ varchar(255), GIVENNAME_ varchar(255), FAMILYNAME_ varchar(255), BUSINESSEMAIL_ varchar(255), primary key (DBID_) ); create table JBPM4_JOB ( DBID_ numeric(19,0) not null, CLASS_ varchar(255) not null, DBVERSION_ numeric(10,0) not null, DUEDATE_ datetime, STATE_ varchar(255), ISEXCLUSIVE_ numeric(1,0), LOCKOWNER_ varchar(255), LOCKEXPTIME_ datetime, EXCEPTION_ text, RETRIES_ numeric(10,0), PROCESSINSTANCE_ numeric(19,0), EXECUTION_ numeric(19,0), CFG_ numeric(19,0), SIGNAL_ varchar(255), EVENT_ varchar(255), REPEAT_ varchar(255), primary key (DBID_) ); create table JBPM4_LOB ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, BLOB_VALUE_ image, DEPLOYMENT_ numeric(19,0), NAME_ text, primary key (DBID_) ); create table JBPM4_PARTICIPATION ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, GROUPID_ varchar(255), USERID_ varchar(255), TYPE_ varchar(255), TASK_ numeric(19,0), SWIMLANE_ numeric(19,0), primary key (DBID_) ); create table JBPM4_PROPERTY ( KEY_ varchar(255) not null, VERSION_ numeric(10,0) not null, VALUE_ varchar(255), primary key (KEY_) ); create table JBPM4_SWIMLANE ( DBID_ numeric(19,0) not null, DBVERSION_ numeric(10,0) not null, NAME_ varchar(255), ASSIGNEE_ varchar(255), EXECUTION_ numeric(19,0), primary key (DBID_) ); create table JBPM4_TASK ( DBID_ numeric(19,0) not null, CLASS_ char(1) not null, DBVERSION_ numeric(10,0) not null, NAME_ varchar(255), DESCR_ text, STATE_ varchar(255), SUSPHISTSTATE_ varchar(255), ASSIGNEE_ varchar(255), FORM_ varchar(255), PRIORITY_ numeric(10,0), CREATE_ datetime, DUEDATE_ datetime, PROGRESS_ numeric(10,0), SIGNALLING_ numeric(1,0), EXECUTION_ID_ varchar(255), ACTIVITY_NAME_ varchar(255), HASVARS_ numeric(1,0), SUPERTASK_ numeric(19,0), EXECUTION_ numeric(19,0), PROCINST_ numeric(19,0), SWIMLANE_ numeric(19,0), TASKDEFNAME_ varchar(255), primary key (DBID_) ); create table JBPM4_VARIABLE ( DBID_ numeric(19,0) not null, CLASS_ varchar(255) not null, DBVERSION_ numeric(10,0) not null, KEY_ varchar(255), CONVERTER_ varchar(255), HIST_ numeric(1,0), EXECUTION_ numeric(19,0), TASK_ numeric(19,0), LOB_ numeric(19,0), DATE_VALUE_ datetime, DOUBLE_VALUE_ double precision, CLASSNAME_ varchar(255), LONG_VALUE_ numeric(19,0), STRING_VALUE_ varchar(255), TEXT_VALUE_ text, EXESYS_ numeric(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;
捐助开发者
在兴趣的驱动下,写一个免费
的东西,有欣喜,也还有汗水,希望你喜欢我的作品,同时也能支持一下。 当然,有钱捧个钱场(右上角的爱心标志,支持支付宝和PayPal捐助),没钱捧个人场,谢谢各位。
谢谢您的赞助,我会做的更好!
相关推荐
工作流jbpm4.4,建表语句,已修正错误,希望后来人能够节约时间。
jbpm4.4 的简单demo流程。 内含建表sql语句
jbpm4.4 jar 包下载jbpm4.4 jar 包下载jbpm4.4 jar 包下载jbpm4.4 jar 包下载
jbpm4.4_sql_server_数据库创建
由于jbpm4.4没有提供SqlServer 相关建表语句,需要我们自己去建立,个人拿原来的sql文件修改了一下,希望对大家有用。。直接打开执行就可以了!!
jbpm4.4 schema.xsd jbpm4.4 schema.xsd jbpm4.4 schema.xsd jbpm4.4 schema.xsd jbpm4.4 schema.xsd
jBPM4.4开发指南 开发手册 JBPM4.4 开发
经过我修正的JBPM4.4数据库mysql5.5建表SQL命令,共18张表
JBPM4.4与SSH2之整合(附完整源码) 这些天,想着把jbpm4.4与ssh2整合一下,由于之前从来没用过jbpm,也不知道各版本之间会有什么差异(经过网上的收集对比,还真有些差异),整合起来,还真是有些步履艰难。收集了...
jbpm4.4下载地址
资源名称:JBPM4.4视频教程(22集附源码)资源目录:【】(01)jbpm4.4简介【】(02)JBPM4.4开发环境搭建【】(03)jbpm4.4环境搭建续【】(04)jbpm4.4配置文件和开发前准备【】(05)jbpm4.4部署流程发起流程实例【】(06)...
jbpm4.4开发指南,jbpm4.4用户指南
由于jbpm4.4没有提供SqlServer 相关建表语句,需要我们自己去建立,个人拿原来的sql文件修改了一下,希望对大家有用。。
这东西很少见啊,共享给大家,是jbpm4的数据库表sql脚本,不知道怎么建库的朋友可以参考。
jBPM4.4入门开发实例
首先感谢原创,相关信息请查询原创。... 看到好多朋友找不到相应的jar包,致使jbpm4.4的学习遇到困难,现提供除jbpm4.4自身jar包外的所有包,以便大家更快的学习jbpm4.4,希望能帮朋友们少走弯路!
JBPM4.4学习文档.ppt
jBPM4.4课程文档
终于把jbpm4.4上传完了,由于csdn最大容量才50m,所以我把这个jar包分成三个部分。
JBPM4.4之HelloWorld示例