-- $Revision: $-- $Date: $-- Drop old columns of pubSubNodeALTERTABLEpubsubNodeDROPCOLUMNcontacts;ALTERTABLEpubsubNodeDROPCOLUMNrosterGroups;ALTERTABLEpubsubNodeDROPCOLUMNreplyRooms;ALTERTABLEpubsubNodeDROPCOLUMNreplyTo;ALTERTABLEpubsubNodeDROPCOLUMNassociationTrusted;-- Add new pubsub tablesCREATETABLEpubsubNodeJIDs(serviceIDVARCHAR(100)NOTNULL,nodeIDVARCHAR(100)NOTNULL,jidVARCHAR(1024)NOTNULL,associationTypeVARCHAR(20)NOTNULL,CONSTRAINTpubsubJID_pkPRIMARYKEY(serviceID,nodeID,jid));CREATETABLEpubsubNodeGroups(serviceIDVARCHAR(100)NOTNULL,nodeIDVARCHAR(100)NOTNULL,rosterGroupVARCHAR(100)NOTNULL);CREATEINDEXpubsubNodeGroups_idxONpubsubNodeGroups(serviceID,nodeID);UPDATEjiveVersionsetversion=8wherename='openfire';