/* create table jiveSecurityAuditLog */ CREATE TABLE jiveSecurityAuditLog ( msgID INTEGER NOT NULL, username NVARCHAR(64) NOT NULL, entryStamp BIGINT NOT NULL, summary NVARCHAR(255) NOT NULL, node NVARCHAR(255) NOT NULL, details NTEXT, CONSTRAINT jiveSecAuditLog_pk PRIMARY KEY (msgID) ); CREATE INDEX jiveSecAuditLog_tstamp_idx ON jiveSecurityAuditLog (entryStamp); CREATE INDEX jiveSecAuditLog_uname_idx ON jiveSecurityAuditLog (username); UPDATE jiveVersion set version=16 where name = 'openfire';