-- $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);