Creacion de db jbpm 4 - mysql

Solo disponible en BuenasTareas
  • Páginas : 7 (1596 palabras )
  • Descarga(s) : 0
  • Publicado : 29 de abril de 2011
Leer documento completo
Vista previa del texto
-------------------------
-- BORRADO DE TABLAS --
-------------------------

alter table JBPM4_DEPLOYPROP
drop
foreign key FK_DEPLPROP_DEPL;

alter table JBPM4_EXECUTION
drop
foreign key FK_EXEC_PARENT;

alter table JBPM4_EXECUTION
drop
foreign key FK_EXEC_SUBPI;

alter table JBPM4_EXECUTION
dropforeign key FK_EXEC_INSTANCE;

alter table JBPM4_EXECUTION
drop
foreign key FK_EXEC_SUPEREXEC;

alter table JBPM4_HIST_ACTINST
drop
foreign key FK_HACTI_HPROCI;

alter table JBPM4_HIST_ACTINST
drop
foreign key FK_HTI_HTASK;

alter table JBPM4_HIST_DETAIL
drop
foreign keyFK_HDETAIL_HPROCI;

alter table JBPM4_HIST_DETAIL
drop
foreign key FK_HDETAIL_HACTI;

alter table JBPM4_HIST_DETAIL
drop
foreign key FK_HDETAIL_HTASK;

alter table JBPM4_HIST_DETAIL
drop
foreign key FK_HDETAIL_HVAR;

alter table JBPM4_HIST_TASK
drop
foreign key FK_HSUPERT_SUB;

alter table JBPM4_HIST_VARdrop
foreign key FK_HVAR_HPROCI;

alter table JBPM4_HIST_VAR
drop
foreign key FK_HVAR_HTASK;

alter table JBPM4_ID_GROUP
drop
foreign key FK_GROUP_PARENT;

alter table JBPM4_ID_MEMBERSHIP
drop
foreign key FK_MEM_GROUP;

alter table JBPM4_ID_MEMBERSHIP
drop
foreign keyFK_MEM_USER;

alter table JBPM4_JOB
drop
foreign key FK_JOB_CFG;

alter table JBPM4_LOB
drop
foreign key FK_LOB_DEPLOYMENT;

alter table JBPM4_PARTICIPATION
drop
foreign key FK_PART_SWIMLANE;

alter table JBPM4_PARTICIPATION
drop
foreign key FK_PART_TASK;

alter table JBPM4_SWIMLANEdrop
foreign key FK_SWIMLANE_EXEC;

alter table JBPM4_TASK
drop
foreign key FK_TASK_SWIML;

alter table JBPM4_TASK
drop
foreign key FK_TASK_SUPERTASK;

alter table JBPM4_VARIABLE
drop
foreign key FK_VAR_LOB;

alter table JBPM4_VARIABLE
drop
foreign key FK_VAR_EXECUTION;

altertable JBPM4_VARIABLE
drop
foreign key FK_VAR_EXESYS;

alter table JBPM4_VARIABLE
drop
foreign key FK_VAR_TASK;

drop table if exists JBPM4_DEPLOYMENT;

drop table if exists JBPM4_DEPLOYPROP;

drop table if exists JBPM4_EXECUTION;

drop table if exists JBPM4_HIST_ACTINST;

drop table if exists JBPM4_HIST_DETAIL;

droptable if exists JBPM4_HIST_PROCINST;

drop table if exists JBPM4_HIST_TASK;

drop table if exists JBPM4_HIST_VAR;

drop table if exists JBPM4_ID_GROUP;

drop table if exists JBPM4_ID_MEMBERSHIP;

drop table if exists JBPM4_ID_USER;

drop table if exists JBPM4_JOB;

drop table if exists JBPM4_LOB;

drop table if exists JBPM4_PARTICIPATION;

droptable if exists JBPM4_PROPERTY;

drop table if exists JBPM4_SWIMLANE;

drop table if exists JBPM4_TASK;

drop table if exists JBPM4_VARIABLE;

--------------------------
-- CREACION DE TABLAS --
--------------------------

create table JBPM4_DEPLOYMENT (
DBID_ bigint not null,
NAME_ longtext,
TIMESTAMP_ bigint,
STATE_varchar(255),
primary key (DBID_)
) type=InnoDB;

create table JBPM4_DEPLOYPROP (
DBID_ bigint not null,
DEPLOYMENT_ bigint,
OBJNAME_ varchar(255),
KEY_ varchar(255),
STRINGVAL_ varchar(255),
LONGVAL_ bigint,
primary key (DBID_)
) type=InnoDB;

create table JBPM4_EXECUTION (
DBID_ bigint not null,...
tracking img