text: -- $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 ('openfire', 6);
  
  -- Make password column accept null, add encrypted password column.
  ALTER TABLE jiveuser ALTER COLUMN "password" DROP NOT NULL;
  ALTER TABLE jiveUser ADD COLUMN encryptedPassword VARCHAR(255);
  