sqlserver jbpm 4.4 建表语句

?

?

?

    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,DEPLOYMENT_ numeric(19,OBJNAME_ varchar(255),KEY_ varchar(255),STRINGVAL_ varchar(255),LONGVAL_ numeric(19,primary key (DBID_)
    );

    create table JBPM4_EXECUTION (
        DBID_ numeric(19,CLASS_ varchar(255) not null,DBVERSION_ numeric(10,ACTIVITYNAME_ varchar(255),PROCDEFID_ varchar(255),HASVARS_ numeric(1,ID_ varchar(255) unique,SUSPHISTSTATE_ varchar(255),PRIORITY_ numeric(10,HISACTINST_ numeric(19,PARENT_ numeric(19,INSTANCE_ numeric(19,SUPEREXEC_ numeric(19,SUBPROCINST_ numeric(19,PARENT_IDX_ numeric(10,primary key (DBID_)
    );

    create table JBPM4_HIST_ACTINST (
        DBID_ numeric(19,HPROCI_ numeric(19,TYPE_ varchar(255),EXECUTION_ varchar(255),ACTIVITY_NAME_ varchar(255),START_ datetime,END_ datetime,DURATION_ numeric(19,TRANSITION_ varchar(255),NEXTIDX_ numeric(10,HTASK_ numeric(19,primary key (DBID_)
    );

    create table JBPM4_HIST_DETAIL (
        DBID_ numeric(19,USERID_ varchar(255),TIME_ datetime,HPROCIIDX_ numeric(10,HACTI_ numeric(19,HACTIIDX_ numeric(10,HTASKIDX_ numeric(10,HVAR_ numeric(19,HVARIDX_ numeric(10,MESSAGE_ varchar(255),OLD_STR_ varchar(255),NEW_STR_ varchar(255),OLD_INT_ numeric(10,NEW_INT_ numeric(10,OLD_TIME_ datetime,NEW_TIME_ datetime,primary key (DBID_)
    );

    create table JBPM4_HIST_PROCINST (
        DBID_ numeric(19,ID_ varchar(255),ENDACTIVITY_ varchar(255),primary key (DBID_)
    );

    create table JBPM4_HIST_TASK (
        DBID_ numeric(19,OUTCOME_ varchar(255),ASSIGNEE_ varchar(255),CREATE_ datetime,SUPERTASK_ numeric(19,primary key (DBID_)
    );

    create table JBPM4_HIST_VAR (
        DBID_ numeric(19,PROCINSTID_ varchar(255),EXECUTIONID_ varchar(255),VARNAME_ varchar(255),VALUE_ varchar(255),primary key (DBID_)
    );

    create table JBPM4_ID_GROUP (
        DBID_ numeric(19,primary key (DBID_)
    );

    create table JBPM4_ID_MEMBERSHIP (
        DBID_ numeric(19,USER_ numeric(19,GROUP_ numeric(19,primary key (DBID_)
    );

    create table JBPM4_ID_USER (
        DBID_ numeric(19,PASSWORD_ varchar(255),GIVENNAME_ varchar(255),FAMILYNAME_ varchar(255),BUSINESSEMAIL_ varchar(255),primary key (DBID_)
    );

    create table JBPM4_JOB (
        DBID_ numeric(19,DUEDATE_ datetime,ISEXCLUSIVE_ numeric(1,LOCKOWNER_ varchar(255),LOCKEXPTIME_ datetime,EXCEPTION_ text,RETRIES_ numeric(10,PROCESSINSTANCE_ numeric(19,EXECUTION_ numeric(19,CFG_ numeric(19,SIGNAL_ varchar(255),EVENT_ varchar(255),REPEAT_ varchar(255),primary key (DBID_)
    );

    create table JBPM4_LOB (
        DBID_ numeric(19,BLOB_VALUE_ image,NAME_ text,primary key (DBID_)
    );

    create table JBPM4_PARTICIPATION (
        DBID_ numeric(19,GROUPID_ varchar(255),TASK_ numeric(19,SWIMLANE_ numeric(19,primary key (DBID_)
    );

    create table JBPM4_PROPERTY (
        KEY_ varchar(255) not null,VERSION_ numeric(10,primary key (KEY_)
    );

    create table JBPM4_SWIMLANE (
        DBID_ numeric(19,primary key (DBID_)
    );

    create table JBPM4_TASK (
        DBID_ numeric(19,CLASS_ char(1) not null,DESCR_ text,FORM_ varchar(255),PROGRESS_ numeric(10,SIGNALLING_ numeric(1,EXECUTION_ID_ varchar(255),PROCINST_ numeric(19,TASKDEFNAME_ varchar(255),primary key (DBID_)
    );

    create table JBPM4_VARIABLE (
        DBID_ numeric(19,CONVERTER_ varchar(255),HIST_ numeric(1,LOB_ numeric(19,DATE_VALUE_ datetime,DOUBLE_VALUE_ double precision,CLASSNAME_ varchar(255),LONG_VALUE_ numeric(19,STRING_VALUE_ varchar(255),TEXT_VALUE_ text,EXESYS_ numeric(19,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捐助），没钱捧个人场，谢谢各位。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!