org.activiti.db.upgrade.activiti.mysql.upgradestep.53.to.54.history.sql Maven / Gradle / Ivy
The newest version!
alter table ACT_HI_DETAIL
add DUE_DATE_ datetime;
alter table ACT_HI_TASKINST
add DUE_DATE_ datetime;
create table ACT_HI_COMMENT (
ID_ varchar(64) not null,
TIME_ datetime not null,
USER_ID_ varchar(255),
TASK_ID_ varchar(64),
PROC_INST_ID_ varchar(64),
MESSAGE_ varchar(255),
primary key (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
create table ACT_HI_ATTACHMENT (
ID_ varchar(64) not null,
REV_ integer,
NAME_ varchar(255),
DESCRIPTION_ varchar(255),
TYPE_ varchar(255),
TASK_ID_ varchar(64),
PROC_INST_ID_ varchar(64),
URL_ varchar(255),
CONTENT_ID_ varchar(64),
primary key (ID_)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;