wildfire_sybase.sql 563 Bytes
Newer Older
Gaston Dombiak's avatar
Gaston Dombiak committed
1 2 3 4 5 6 7
/* $Revision:  $ */
/* $Date:  $ */

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


Gaston Dombiak's avatar
Gaston Dombiak committed
8
/* jivePrivacyList: Create new table */
Gaston Dombiak's avatar
Gaston Dombiak committed
9 10 11 12 13 14 15 16
CREATE TABLE jivePrivacyList (
  username              NVARCHAR(32)    NOT NULL,
  name                  NVARCHAR(100)   NOT NULL,
  isDefault             INT             NOT NULL,
  list                  TEXT            NOT NULL,
  CONSTRAINT jivePrivacyList_pk PRIMARY KEY (username, name)
);
CREATE INDEX jivePList_default_idx ON jivePrivacyList (username, isDefault);