wildfire_mysql.sql

来自「基于Jabber协议的即时消息服务器」· SQL 代码 · 共 11 行

# $Revision:  $
# $Date:  $

CREATE TABLE jiveSASLAuthorized (
  username            VARCHAR(64)   NOT NULL,
  principal           TEXT          NOT NULL,
  PRIMARY KEY (username, principal(200))
);

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