openfire_hsqldb.sql

来自「openfire 服务器源码下载」· SQL 代码 · 共 11 行

// $Revision:  $
// $Date:  $

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

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