| 1234567891011121314151617181920212223242526272829303132 | 
							- create table ACT_HI_VARINST (
 
-     ID_ NVARCHAR2(64) not null,
 
-     PROC_INST_ID_ NVARCHAR2(64),
 
-     EXECUTION_ID_ NVARCHAR2(64),
 
-     TASK_ID_ NVARCHAR2(64),
 
-     NAME_ NVARCHAR2(255) not null,
 
-     VAR_TYPE_ NVARCHAR2(100),
 
-     REV_ INTEGER,
 
-     BYTEARRAY_ID_ NVARCHAR2(64),
 
-     DOUBLE_ NUMBER(*,10),
 
-     LONG_ NUMBER(19,0),
 
-     TEXT_ NVARCHAR2(2000),
 
-     TEXT2_ NVARCHAR2(2000),
 
-     primary key (ID_)
 
- );
 
- create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
 
- create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
 
- alter table ACT_HI_ACTINST
 
- add TASK_ID_ NVARCHAR2(64);
 
- alter table ACT_HI_ACTINST
 
- add CALL_PROC_INST_ID_ NVARCHAR2(64);
 
- alter table ACT_HI_DETAIL
 
- 	modify PROC_INST_ID_ NVARCHAR2(64) null;
 
- alter table ACT_HI_DETAIL
 
- 	modify EXECUTION_ID_ NVARCHAR2(64) null;
 
- 	
 
- create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
 
 
  |