openfire_db2.sql 680 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
-- $Revision:  $
-- $Date:  $

CREATE TABLE mucConversationLog2 (
  roomID              INTEGER       NOT NULL,
  sender              VARCHAR(2000) NOT NULL,
  nickname            VARCHAR(255),
  logTime             CHAR(15)      NOT NULL,
  subject             VARCHAR(255),
  body                CLOB
);

INSERT INTO mucConversationLog2 (roomID, sender, nickname, logTime, subject, body)
SELECT roomID, sender, nickname, time, subject, body FROM mucConversationLog;

DROP TABLE mucConversationLog;
RENAME TABLE mucConversationLog2 TO mucConversationLog;
CREATE INDEX mucLog_logtime_idx ON mucConversationLog (logTime);

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