   status VARCHAR(20) NOT NULL,
   timestamp Timestamp NOT NULL,
   update_at Timestamp,
+  process_note mediumint(9),
+  process_status  varchar(20) DEFAULT 'unresolved',
   closed_at Timestamp,
   closed_note VARCHAR(200),
   user_modified int(10) unsigned,

  step int(10) unsigned,
  cond VARCHAR(200) NOT NULL,
  timestamp Timestamp,
  PRIMARY KEY (id),
  INDEX(event_caseId),
  FOREIGN KEY (event_caseId) REFERENCES event_cases(id)

  ENGINE =InnoDB
  DEFAULT CHARSET =utf8;

DROP TABLE IF EXISTS event_cases;
CREATE TABLE event_cases (
  id VARCHAR(50),
