-- $Revision: $-- $Date: $-- Drop old columns of pubSubNodeALTERTABLEpubsubNodeDROPCOLUMNcontacts;ALTERTABLEpubsubNodeDROPCOLUMNrosterGroups;ALTERTABLEpubsubNodeDROPCOLUMNreplyRooms;ALTERTABLEpubsubNodeDROPCOLUMNreplyTo;ALTERTABLEpubsubNodeDROPCOLUMNassociationTrusted;-- Add new pubsub tablesCREATETABLEpubsubNodeJIDs(serviceIDVARCHAR2(100)NOTNULL,nodeIDVARCHAR2(100)NOTNULL,jidVARCHAR2(1024)NOTNULL,associationTypeVARCHAR2(20)NOTNULL,CONSTRAINTpubsubJID_pkPRIMARYKEY(serviceID,nodeID,jid));CREATETABLEpubsubNodeGroups(serviceIDVARCHAR2(100)NOTNULL,nodeIDVARCHAR2(100)NOTNULL,rosterGroupVARCHAR2(100)NOTNULL);CREATEINDEXpubsubNodeGroups_idxONpubsubNodeGroups(serviceID,nodeID);UPDATEjiveVersionsetversion=8wherename='openfire';commit;