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 ;
分享到:
相关推荐
由于jbpm4.4没有提供SqlServer 相关建表语句,需要我们自己去建立,个人拿原来的sql文件修改了一下,希望对大家有用。。直接打开执行就可以了!!
【标题】"jBPM4.4 SQLSERVER 精简 包"涉及的主要知识点是jBPM(Java Business Process Management)4.4版本与SQL Server数据库的集成和使用。jBPM是一个开源的工作流管理系统,它允许开发者设计、部署和执行业务流程...
在实际运行时,"两张表的sql要设置下"可能指的是需要对jbpm4.4的数据库配置进行调整。jbpm在初始化时会创建一些核心的系统表,用于存储流程定义、实例、任务等信息。因此,用户需要确保数据库中已创建了这些表,或者...
jbpm4.4 DB2数据库脚本,可直接执行sql脚本,创建jbpm4.4 数据库表
3. **SQL脚本**:用于创建和初始化数据库表的SQL文件,这是JBPM4运行的基础,因为流程实例、任务和其他元数据需要存储在数据库中。 4. **测试用例**:可能包含测试流程执行和审批逻辑的JUnit或其他测试框架的测试类...
这些表可以通过Hibernate的自动表结构生成策略(hibernate.hbm2ddl.auto属性)创建,或者手动执行SQL脚本。 **3. JBPM基础知识** 理解JBPM的基础概念至关重要,包括任务、事件、工作流实例等。流程定义文件(jpdl)...
- **执行 SQL 脚本**: - 在命令行中切换到 `jbpm-4.4\install` 目录下,运行 `ant create.jbpm.schema` 来创建数据库表结构。 - **安装服务器**: - 将 `apache-tomcat-6.0.29.zip` 解压缩到 `jbpm-4.4\install\...
### jBPM4.4 在 Tomcat + MySQL 环境下的安装指南 #### 一、准备工作 在开始安装之前,我们需要确保以下几项准备工作已经完成: 1. **下载相关软件**: - [jBPM 4.4](http://sourceforge.net/projects/jbpm):一...
jBPM4.4提供了强大的脚本支持,允许在流程中嵌入JavaScript、Groovy等多种脚本语言,增强了流程的灵活性和扩展性。 ### 配置与管理 - **配置文件**:包括对邮件服务、数据库连接等系统资源的配置。 - **控制台工具...
因此,项目中可能会包含初始化数据库的SQL脚本。 3. **jbpm核心库**:包括jbpm-runtime、jbpm-persistence、jbpm-human-task等,这些都是jbpm框架的核心依赖,负责流程的执行和管理。 4. **示例应用**:可能是一个...
SSH和Jbpm4.4是企业级应用开发中的两个重要技术栈,它们在实际项目中经常被结合使用。SSH代表Struts、Spring和Hibernate,是Java Web开发中经典的MVC(模型-视图-控制器)框架组合。而JBPM4.4则是Business Process ...
这些SQL脚本可能包括创建流程定义表、任务表、历史表等,它们确保了jBPM能够正确地运行和管理流程。 在实践中,开发者需要将这些SQL语句执行到目标数据库中,以便jBPM能够正常工作。同时,还需要配置jBPM连接到这个...
SQL脚本可能是用来初始化数据库的,包括创建表、填充测试数据等。Tomcat是一个广泛使用的Java应用服务器,通常用于部署和运行Java Web应用程序,如SSH+JBPM4.4项目。 总的来说,这个项目展示了如何将传统的MVC框架...
这东西很少见啊,共享给大家,是jbpm4的数据库表sql脚本,不知道怎么建库的朋友可以参考。
### Myeclipse8.6搭建jbpm4.4的开发环境详尽步骤 #### 一、Myeclipse中安装jbpm4.4 要在Myeclipse8.6中搭建jbpm4.4的开发环境,首先需确保已解压jbpm4.4,并通过以下步骤进行安装: 1. **启动Myeclipse8.6**:...
在整合过程中,数据库的创建可以通过 Hibernate 的 `hibernate.hbm2ddl.auto` 属性自动完成,或者手动执行 SQL 脚本。jBPM 提供了创建数据库的脚本,位于 `jbpm_home/install/src/db/create` 目录下。需要注意的是,...
SSH整合JBPM4.4是将Spring、Struts和Hibernate这三大开源框架与Business Process Management System (BPMS)工具jbPM进行集成的过程。jbPM是一个开源的工作流管理系统,用于管理和执行业务流程。在这个过程中,SSH...