activiti.mysql.upgradestep.50.to.51.history.sql 512 B

123456789101112131415161718
  1. alter table ACT_HI_DETAIL
  2. add TASK_ID_ varchar(64);
  3. create table ACT_HI_TASKINST (
  4. ID_ varchar(64) not null,
  5. PROC_DEF_ID_ varchar(64),
  6. TASK_DEF_KEY_ varchar(255),
  7. PROC_INST_ID_ varchar(64),
  8. EXECUTION_ID_ varchar(64),
  9. NAME_ varchar(255),
  10. DESCRIPTION_ varchar(255),
  11. ASSIGNEE_ varchar(64),
  12. START_TIME_ datetime not null,
  13. END_TIME_ datetime,
  14. DURATION_ bigint,
  15. DELETE_REASON_ varchar(255),
  16. primary key (ID_)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;