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,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捐助），没钱捧个人场，谢谢各位。
谢谢您的赞助，我会做的更好！