wildfire_oracle.sql 558 Bytes
Newer Older
1 2
-- $Revision:  $
-- $Date:  $
Gaston Dombiak's avatar
Gaston Dombiak committed
3

4
-- Update jiveVersion to Wildfire 2.5
Gaston Dombiak's avatar
Gaston Dombiak committed
5 6
UPDATE jiveVersion SET majorVersion=2, minorVersion=5;

7
-- jivePrivacyList: Create new table
Gaston Dombiak's avatar
Gaston Dombiak committed
8 9 10 11 12 13 14 15
CREATE TABLE jivePrivacyList (
  username              VARCHAR2(32)    NOT NULL,
  name                  VARCHAR2(100)   NOT NULL,
  isDefault             INTEGER         NOT NULL,
  list                  LONG            NOT NULL,
  CONSTRAINT jivePrivacyList_pk PRIMARY KEY (username, name)
);
CREATE INDEX jivePList_default_idx ON jivePrivacyList (username, isDefault);
16 17

commit;