-- $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.
ALTER TABLE jiveuser ALTER COLUMN "password" DROP NOT NULL;
ALTER TABLE jiveUser ADD COLUMN encryptedPassword VARCHAR(255);