openfire_hsqldb.sql 547 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
// $Revision:  $
// $Date:  $

// Update jiveVersion to Openfire 2.5
UPDATE jiveVersion SET majorVersion=2, minorVersion=5;

// jivePrivacyList: Create new table
CREATE TABLE jivePrivacyList (
  username              VARCHAR(32)     NOT NULL,
  name                  VARCHAR(100)    NOT NULL,
  isDefault             INTEGER         NOT NULL,
  list                  LONGVARCHAR     NOT NULL,
  CONSTRAINT jivePrivacyList_pk PRIMARY KEY (username, name)
);
CREATE INDEX jivePList_default_idx ON jivePrivacyList (username, isDefault);