messenger_postgresql.sql 1.58 KB
Newer Older
1 2 3 4 5 6
-- $RCSfile$
-- $Revision$
-- $Date$

-- upgrades from Messenger 2.1.x to 2.2.0

7
-- Update jiveVersion to JM 2.2
Gaston Dombiak's avatar
Gaston Dombiak committed
8
UPDATE jiveVersion SET majorVersion=2, minorVersion=2;
9

10 11 12 13 14 15 16 17 18 19 20 21 22 23
-- jiveExtComponentConf: Create new table
CREATE TABLE jiveExtComponentConf (
  subdomain             VARCHAR(255)    NOT NULL,
  secret                VARCHAR(255),
  permission            VARCHAR(10)     NOT NULL,
  CONSTRAINT jiveExtComponentConf_pk PRIMARY KEY (subdomain)
);

-- jiveRemoteServerConf: Create new table
CREATE TABLE jiveRemoteServerConf (
  domain                VARCHAR(255)    NOT NULL,
  remotePort            INTEGER,
  permission            VARCHAR(10)     NOT NULL,
  CONSTRAINT jiveRemoteServerConf_pk PRIMARY KEY (domain)
24 25 26 27 28 29 30 31 32
);

-- mucRoomProp: Create new table
CREATE TABLE mucRoomProp (
  roomID                INTEGER         NOT NULL,
  name                  VARCHAR(100)    NOT NULL,
  propValue             TEXT            NOT NULL,
  CONSTRAINT mucRoomProp_pk PRIMARY KEY (roomID, name)
);
33

34
-- mucRoom: Add new columns: "useReservedNick", "canChangeNick" and "canRegister".
35 36
ALTER TABLE mucRoom ADD COLUMN useReservedNick     INTEGER       NOT NULL;
ALTER TABLE mucRoom ADD COLUMN canChangeNick       INTEGER       NOT NULL;
37
ALTER TABLE mucRoom ADD COLUMN canRegister         INTEGER       NOT NULL;
38 39

UPDATE mucRoom set useReservedNick=0, canChangeNick=1, canRegister=1;
40 41 42 43 44 45 46 47

-- jiveVCard: Recreate table from scratch
DROP TABLE jiveVCard;
CREATE TABLE jiveVCard (
  username              VARCHAR(32)     NOT NULL,
  value                 TEXT            NOT NULL,
  CONSTRAINT jiveVCard_pk PRIMARY KEY (username)
);