把ACT_HI_DETAIL的数据导入到ACT_HI_VARINST

import-vars-to-varinst-from-detail.sql

INSERT
INTO act_hi_varinst
  (
    ID_,
    PROC_INST_ID_,
    EXECUTION_ID_,
    TASK_ID_,
    NAME_,
    VAR_TYPE_,
    REV_,
    BYTEARRAY_ID_,
    DOUBLE_,
    LONG_,
    TEXT_,
    TEXT2_
  )
SELECT ID_,
  PROC_INST_ID_,
  EXECUTION_ID_,
  TASK_ID_,
  NAME_,
  VAR_TYPE_,
  REV_,
  BYTEARRAY_ID_,
  DOUBLE_,
  LONG_,
  TEXT_,
  TEXT2_
FROM act_hi_detail
where TYPE_ = 'VariableUpdate'