openfire_mysql.sql 531 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14
# create table jiveSecurityAuditLog
CREATE TABLE jiveSecurityAuditLog (
  msgID                 BIGINT          NOT NULL,
  username              VARCHAR(64)     NOT NULL,
  entryStamp            BIGINT          NOT NULL,
  summary               VARCHAR(255)    NOT NULL,
  node                  VARCHAR(255)    NOT NULL,
  details               TEXT,
  PRIMARY KEY (msgID),
  INDEX jiveSecAuditLog_tstamp_idx (entryStamp),
  INDEX jiveSecAuditLog_uname_idx (username)
);

UPDATE jiveVersion set version=16 where name = 'openfire';