openfire_postgresql.sql 285 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10
-- $Revision:  $
-- $Date:  $

CREATE TABLE jiveSASLAuthorized (
  username          VARCHAR(64)   NOT NULL,
  principal         VARCHAR(4000) NOT NULL,
  CONSTRAINT jiveSASLAuthoirzed_pk PRIMARY KEY (username, principal)
);

UPDATE jiveVersion set version=10 where name = 'openfire';