 
 CREATE TABLE jiveVCard (
   username              VARCHAR(32)     NOT NULL,
-  value                 LONG VARCHAR    NOT NULL,
+  value                 VARCHAR(2000)   NOT NULL,
   CONSTRAINT jiveVCard_pk PRIMARY KEY (username)
 );
 

CREATE TABLE jiveRoster (
  rosterID              INTEGER         NOT NULL,
  username              VARCHAR(32)     NOT NULL,
  jid                   VARCHAR(1000)   NOT NULL,
  sub                   INTEGER         NOT NULL,
  ask                   INTEGER         NOT NULL,
  recv                  INTEGER         NOT NULL,

  CONSTRAINT mucRoom_pk PRIMARY KEY (name)
);

CREATE INDEX mucRm_roomid_idx ON mucRoom (roomID);

CREATE TABLE mucRoomProp (
  roomID                INTEGER         NOT NULL,
