DROP TABLE ofGatewayAvatars;
CREATE TABLE ofGatewayAvatars (
   jid               VARCHAR2(255)  NOT NULL,
   imageData         CLOB           NOT NULL,
   xmppHash          VARCHAR2(255),
   legacyIdentifier  VARCHAR2(255),
   createDate        INTEGER        NOT NULL,
   lastUpdate        INTEGER,
   imageType         VARCHAR2(25)
);
CREATE INDEX ofGatewayAvatars_jid_idx ON ofGatewayAvatars (jid);

DROP TABLE ofGatewayVCards;
CREATE TABLE ofGatewayVCards (
   jid               VARCHAR2(255)  NOT NULL,
   value             CLOB           NOT NULL
);
CREATE INDEX ofGatewayVCards_jid_idx ON ofGatewayVCards (jid);
