openfire_oracle.sql 304 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11
-- $Revision:  $
-- $Date:  $

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

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