`
knight_black_bob
  • 浏览: 851296 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

sqlserver jbpm 4.4 建表语句

    博客分类:
  • jbpm
阅读更多

 

 

 

    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 for mssql建表语句

    工作流jbpm4.4,建表语句,已修正错误,希望后来人能够节约时间。

    jBPM4.4.rar_jbpm4.4_jbpm4.4 PDF

    《jBPM4.4开发指南》与《jBPM4.4中文用户手册》是深入理解jBPM4.4这一开源工作流管理系统的重要参考资料。jBPM,全称Java Business Process Management,是一个用于执行业务流程的轻量级、灵活的开源框架,它为业务...

    SSH+jbpm4.4 demo 内含建表语句

    SSH+jbpm4.4 Demo 是一个集成Spring Security(SSH)和jBPM 4.4的示例项目,主要用于展示如何在实际应用中结合这两个技术来实现业务流程管理。SSH,即Spring Security,是一个强大的安全框架,用于保护Java应用程序...

    jbpm4.4下载地址

    在深入探讨jBPM 4.4的相关知识点之前,我们首先需要理解jBPM是什么以及它在企业级应用中的重要性。jBPM是“Java Business Process Model”的缩写,是一个开源的工作流引擎,用于执行业务流程管理(BPM)。它提供了...

    jbpm4.4文档+学习资料

    jbpm4.4是JBoss企业级业务流程管理(Business Process Management)平台的一个重要版本,它为开发者提供了全面的工作流和业务流程管理解决方案。本文将深入解析jbpm4.4的相关知识点,帮助那些寻找优质学习资源的朋友...

    jBPM4.4开发实例

    **jBPM4.4开发实例** jBPM(Java Business Process Management)是一个开源的工作流管理系统,用于管理和执行业务流程。jBPM4.4是该框架的一个版本,它提供了强大的工作流服务,包括流程定义、流程实例管理、任务...

    jbpm4.4中文开发指南

    **jbpm4.4中文开发指南** JBPM(Java Business Process Management)是一个开源的工作流管理系统,专注于业务流程的建模、执行和管理。jbpm4.4是该系统的某一版本,它提供了丰富的功能,包括流程定义、流程实例的...

    jBPM4.4 SQLSERVER 精简 包

    【标题】"jBPM4.4 SQLSERVER 精简 包"涉及的主要知识点是jBPM(Java Business Process Management)4.4版本与SQL Server数据库的集成和使用。jBPM是一个开源的工作流管理系统,它允许开发者设计、部署和执行业务流程...

    jBPM 4.4用户手册 中文PDF

    **jBPM 4.4 用户手册 中文PDF** **jBPM 4.4** 是一个开源的工作流程管理系统,由Red Hat公司开发并维护,主要用于业务流程管理(BPM)和工作流自动化。该系统提供了强大的流程建模、执行和监控功能,支持Java平台,...

    JBPM4.4资料的其他补充

    JBPM4.4是JBPM的其中一个稳定版本,发布于2009年,它提供了强大的工作流服务,包括流程定义、流程实例管理、任务管理和监控等功能。在JBPM4.4版本中,开发者可以利用其提供的API和工具来设计、部署和执行复杂的业务...

    jbpm4.4 sqlserver脚本

    由于jbpm4.4没有提供SqlServer 相关建表语句,需要我们自己去建立,个人拿原来的sql文件修改了一下,希望对大家有用。。直接打开执行就可以了!!

    jbpm4.4 shh2 项目示例

    jbpm4.4 shh2 项目示例是基于jbpm4.4版本与SSH2(Struts2、Spring和Hibernate)集成的一个实战项目。jbPM(Business Process Management)是一款开源的工作流管理系统,用于实现业务流程自动化。SSH2是Java开发中的...

    jbpm4.4 schema.xsd

    jbpm4.4 schema.xsd jbpm4.4 schema.xsd jbpm4.4 schema.xsd jbpm4.4 schema.xsd jbpm4.4 schema.xsd

    jbpm4.4_sql_server_数据库创建

    标题与描述均提到了“jbpm4.4_sql_server_数据库创建”,这表明主题是关于在SQL Server上为JBPM 4.4版本创建数据库结构的过程。JBPM(JBoss Business Process Management)是一个开源的工作流管理系统,用于实现业务...

    经过我修正的JBPM4.4数据库mysql5.5建表SQL命令

    经过我修正的JBPM4.4数据库mysql5.5建表SQL命令,共18张表

    JBPM4.4与SSH2之整合(附可运行源码和jar包列表)(my_jbpm4.4_ssh2.rar)

    JBPM4.4与SSH2之整合(附完整源码) 这些天,想着把jbpm4.4与ssh2整合一下,由于之前从来没用过jbpm,也不知道各版本之间会有什么差异(经过网上的收集对比,还真有些差异),整合起来,还真是有些步履艰难。收集了...

    jBPM4.4 详解 API 中文

    ### jBPM4.4 API 详解:工作流自动化的核心技术 #### 一、工作流基础知识 工作流,作为业务过程的部分或整体自动化,旨在通过计算机应用环境实现文档、信息或任务在多个参与者间的自动传递,以达到预期的业务目标...

    jBPM4.4.rar_jbpm4_jbpm4.4

    "jBPM4.4.docx" 文件可能是关于 jbPM 4.4 示例的详细文档,它可能包含如何安装、配置、创建和运行流程实例的步骤,以及可能遇到的问题和解决办法,对于学习和使用 jbPM 4.4 是非常有价值的参考资料。 总结,jbPM ...

Global site tag (gtag.js) - Google Analytics