openfire_sybase.sql

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

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

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

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