openfire_sqlserver.sql

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

/* create table jiveUserFlag */
CREATE TABLE jiveUserFlag (
  username              NVARCHAR(64)    NOT NULL,
  name                  NVARCHAR(100)   NOT NULL,
  startTime             CHAR(15),
  endTime               CHAR(15),
  CONSTRAINT jiveUserFlag_pk PRIMARY KEY (username, name)
);
CREATE INDEX jiveUserFlag_sTime_idx ON jiveUserFlag (startTime ASC);
CREATE INDEX jiveUserFlag_eTime_idx ON jiveUserFlag (endTime ASC);

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