You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
28 lines
730 B
28 lines
730 B
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;
|
|
|