/* $Revision: $ */ /* $Date: $ */ /* Update the jiveVersion table to new definition. */ DROP TABLE jiveVersion; CREATE TABLE jiveVersion ( name NVARCHAR(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 NVARCHAR(32);
ALTER TABLE jiveUser ADD encryptedPassword NVARCHAR(255);