text: # create jiveUserFlag table
  CREATE TABLE jiveUserFlag (
    username              VARCHAR(64)     NOT NULL,
    name                  VARCHAR(100)    NOT NULL,
    startTime             CHAR(15),
    endTime               CHAR(15),
    PRIMARY KEY (username, name),
    INDEX jiveUser_sTime_idx (startTime),
    INDEX jiveUser_eTime_idx (endTime)
  );
  
  UPDATE jiveVersion set version=15 where name = 'openfire';