wildfire_sqlserver.sql 546 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     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. */
14
ALTER TABLE jiveUser ALTER COLUMN password NVARCHAR(32);
Gaston Dombiak's avatar
Gaston Dombiak committed
15
ALTER TABLE jiveUser ADD encryptedPassword NVARCHAR(255);