/* $Revision: $ *//* $Date: $ *//* Drop old columns of pubSubNode */ALTERTABLEpubsubNodeDROPCOLUMNcontacts;ALTERTABLEpubsubNodeDROPCOLUMNrosterGroups;ALTERTABLEpubsubNodeDROPCOLUMNreplyRooms;ALTERTABLEpubsubNodeDROPCOLUMNreplyTo;ALTERTABLEpubsubNodeDROPCOLUMNassociationTrusted;/* Add new pubsub tables */CREATETABLEpubsubNodeJIDs(serviceIDNVARCHAR(100)NOTNULL,nodeIDNVARCHAR(100)NOTNULL,jidNVARCHAR(1024)NOTNULL,associationTypeNVARCHAR(20)NOTNULL,CONSTRAINTpubsubJID_pkPRIMARYKEY(serviceID,nodeID,jid));CREATETABLEpubsubNodeGroups(serviceIDNVARCHAR(100)NOTNULL,nodeIDNVARCHAR(100)NOTNULL,rosterGroupNVARCHAR(100)NOTNULL);CREATEINDEXpubsubNodeGroups_idxONpubsubNodeGroups(serviceID,nodeID);UPDATEjiveVersionsetversion=8wherename='openfire';