wildfire_oracle.sql 1.82 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
REM // $RCSfile$
REM // $Revision: 1650 $
REM // $Date: 2005-07-20 00:18:17 -0300 (Wed, 20 Jul 2005) $

REM // upgrades from Wildfire 2.1.x to 2.2.0

REM // Update jiveVersion to JM 2.2
UPDATE jiveVersion SET majorVersion=2, minorVersion=2;

REM // jiveExtComponentConf: Create new table
CREATE TABLE jiveExtComponentConf (
  subdomain             VARCHAR2(255)    NOT NULL,
  secret                VARCHAR2(255),
  permission            VARCHAR2(10)     NOT NULL,
  CONSTRAINT jiveExtComponentConf_pk PRIMARY KEY (subdomain)
);

REM // jiveRemoteServerConf: Create new table
CREATE TABLE jiveRemoteServerConf (
  domain                VARCHAR2(255)    NOT NULL,
  remotePort            INTEGER,
  permission            VARCHAR2(10)     NOT NULL,
  CONSTRAINT jiveRemoteServerConf_pk PRIMARY KEY (domain)
);

REM // mucRoomProp: Create new table
CREATE TABLE mucRoomProp (
  roomID                INT             NOT NULL,
  name                  VARCHAR2(100)   NOT NULL,
  propValue             VARCHAR2(1024)  NOT NULL,
  CONSTRAINT mucRoomProp_pk PRIMARY KEY (roomID, name)
);

REM // mucRoom: Add new columns: "useReservedNick", "canChangeNick" and "canRegister".
35 36 37
ALTER TABLE mucRoom ADD useReservedNick INTEGER NULL;
ALTER TABLE mucRoom ADD canChangeNick INTEGER NULL;
ALTER TABLE mucRoom ADD canRegister INTEGER NULL;
38
UPDATE mucRoom set useReservedNick=0, canChangeNick=1, canRegister=1;
39 40 41
ALTER TABLE mucRoom MODIFY useReservedNick INTEGER NOT NULL;
ALTER TABLE mucRoom MODIFY canChangeNick INTEGER NOT NULL;
ALTER TABLE mucRoom MODIFY canRegister INTEGER NOT NULL;
42 43 44 45 46 47 48 49

REM // jiveVCard: Recreate table from scratch
DROP TABLE jiveVCard;
CREATE TABLE jiveVCard (
  username              VARCHAR2(32)    NOT NULL,
  value                 LONG            NOT NULL,
  CONSTRAINT JiveVCard_pk PRIMARY KEY (username)
);