   subdomain             VARCHAR(255)    NOT NULL,
   secret                VARCHAR(255),
   permission            VARCHAR(10)     NOT NULL,
-  CONSTRAINT jiveExtComponentConf_pk PRIMARY KEY (subdomain)
+  CONSTRAINT jiveExtCmpConf_pk PRIMARY KEY (subdomain)
 );
 
 CREATE TABLE jiveRemoteServerConf (
   domain                VARCHAR(255)    NOT NULL,
   remotePort            INTEGER,
   permission            VARCHAR(10)     NOT NULL,
-  CONSTRAINT jiveRemoteServerConf_pk PRIMARY KEY (domain)
+  CONSTRAINT jiveRmSrvConf_pk PRIMARY KEY (domain)
 );
 
 -- MUC tables

  CONSTRAINT mucRoom_pk PRIMARY KEY (name)
);

CREATE INDEX mucRoom_roomid_idx ON mucRoom (roomID);

CREATE TABLE mucRoomProp (
  roomID                INTEGER         NOT NULL,

  username              VARCHAR(32)     NOT NULL,
  name                  VARCHAR(100)    NOT NULL,
  namespace             VARCHAR(200)    NOT NULL,
  value                 VARCHAR(2000)   NOT NULL,
  CONSTRAINT jivePrivate_pk PRIMARY KEY (username, name, namespace)
);

