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.
29 lines
664 B
29 lines
664 B
3 years ago
|
alter table ACT_HI_DETAIL
|
||
|
|
add DUE_DATE_ TIMESTAMP(6);
|
||
|
|
|
||
|
|
alter table ACT_HI_TASKINST
|
||
|
|
add DUE_DATE_ TIMESTAMP(6);
|
||
|
|
|
||
|
|
create table ACT_HI_COMMENT (
|
||
|
|
ID_ NVARCHAR2(64) not null,
|
||
|
|
TIME_ TIMESTAMP(6) not null,
|
||
|
|
USER_ID_ NVARCHAR2(255),
|
||
|
|
TASK_ID_ NVARCHAR2(64),
|
||
|
|
PROC_INST_ID_ NVARCHAR2(64),
|
||
|
|
MESSAGE_ NVARCHAR2(255),
|
||
|
|
primary key (ID_)
|
||
|
|
);
|
||
|
|
|
||
|
|
create table ACT_HI_ATTACHMENT (
|
||
|
|
ID_ NVARCHAR2(64) not null,
|
||
|
|
REV_ integer,
|
||
|
|
NAME_ NVARCHAR2(255),
|
||
|
|
DESCRIPTION_ NVARCHAR2(255),
|
||
|
|
TYPE_ NVARCHAR2(255),
|
||
|
|
TASK_ID_ NVARCHAR2(64),
|
||
|
|
PROC_INST_ID_ NVARCHAR2(64),
|
||
|
|
URL_ NVARCHAR2(255),
|
||
|
|
CONTENT_ID_ NVARCHAR2(64),
|
||
|
|
primary key (ID_)
|
||
|
|
);
|