openfire_sqlserver.sql

来自「xmpp协议的客户端软件」· SQL 代码 · 共 11 行

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

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

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