wildfire_postgresql.sql 519 Bytes
Newer Older
Gaston Dombiak's avatar
Gaston Dombiak committed
1 2 3 4 5 6 7 8 9 10 11 12 13
-- $Revision:  $
-- $Date:  $

-- Update the jiveVersion table to new definition.
DROP TABLE jiveVersion;
CREATE TABLE jiveVersion (
  name     VARCHAR(50)  NOT NULL,
  version  INTEGER  NOT NULL,
  CONSTRAINT jiveVersion_pk PRIMARY KEY (name)
);
INSERT INTO jiveVersion (name, version) VALUES ('wildfire', 6);

-- Make password column accept null, add encrypted password column.
14
ALTER TABLE jiveuser ALTER COLUMN "password" DROP NOT NULL;
Gaston Dombiak's avatar
Gaston Dombiak committed
15
ALTER TABLE jiveUser ADD COLUMN encryptedPassword VARCHAR(255);