openfire_db2.sql

来自「开源OA办公系统！！！！！！！！！！！！！！！！！！！！！」· SQL 代码 · 共 11 行

-- $Revision:  $
-- $Date:  $

CREATE TABLE jivePresence (
  username              VARCHAR(64)     NOT NULL,
  offlinePresence       VARCHAR(2000),
  offlineDate           CHAR(15)     NOT NULL,
  CONSTRAINT jivePresence_pk PRIMARY KEY (username)
);

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