// $Revision: $ // $Date: $ // Drop old columns of pubSubNode ALTER TABLE pubsubNode DROP COLUMN contacts; ALTER TABLE pubsubNode DROP COLUMN rosterGroups; ALTER TABLE pubsubNode DROP COLUMN replyRooms; ALTER TABLE pubsubNode DROP COLUMN replyTo; ALTER TABLE pubsubNode DROP COLUMN associationTrusted; // Add new pubsub tables CREATE TABLE pubsubNodeJIDs ( serviceID VARCHAR(100) NOT NULL, nodeID VARCHAR(100) NOT NULL, jid VARCHAR(1024) NOT NULL, associationType VARCHAR(20) NOT NULL, CONSTRAINT pubsubJID_pk PRIMARY KEY (serviceID, nodeID, jid) ); CREATE TABLE pubsubNodeGroups ( serviceID VARCHAR(100) NOT NULL, nodeID VARCHAR(100) NOT NULL, rosterGroup VARCHAR(100) NOT NULL ); CREATE INDEX pubsubNodeGroups_idx ON pubsubNodeGroups (serviceID, nodeID); UPDATE jiveVersion set version=8 where name = 'openfire';