openfire_postgresql.sql 474 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12
-- create table jiveUserFlag
CREATE TABLE jiveUserFlag (
  username              VARCHAR(64)     NOT NULL,
  name                  VARCHAR(100)    NOT NULL,
  startTime             CHAR(15),
  endTime               CHAR(15),
  CONSTRAINT jiveUserFlag_pk PRIMARY KEY (username, name)
);
CREATE INDEX jiveUserFlag_sTime_idx ON jiveUserFlag (startTime);
CREATE INDEX jiveUserFlag_eTime_idx ON jiveUserFlag (endTime);

UPDATE jiveVersion set version=15 where name = 'openfire';