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

  status VARCHAR(20) NOT NULL,
  timestamp Timestamp NOT NULL,
  update_at Timestamp,
  closed_at Timestamp,
  closed_note VARCHAR(200),
  user_modified int(10) unsigned,

  ENGINE =InnoDB
  DEFAULT CHARSET =utf8;


DROP TABLE IF EXISTS event_note;
CREATE TABLE IF NOT EXISTS event_note (
  id MEDIUMINT NOT NULL AUTO_INCREMENT,
  event_caseId VARCHAR(50),
  note    VARCHAR(300),
  case_id VARCHAR(20),
  status VARCHAR(15),
  timestamp Timestamp,
  user_id int(10) unsigned,
  PRIMARY KEY (id),
  INDEX (event_caseId),
  FOREIGN KEY (event_caseId) REFERENCES event_cases(id)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  FOREIGN KEY (user_id) REFERENCES uic.user(id)
    ON DELETE CASCADE
    ON UPDATE CASCADE
)
 ENGINE =InnoDB
 DEFAULT CHARSET =utf8;

DROP TABLE IF EXISTS events;
CREATE TABLE events (
  id MEDIUMINT NOT NULL AUTO_INCREMENT,
