wildfire_sybase.sql 514 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 MODIFY password NVARCHAR(32);
Gaston Dombiak's avatar
Gaston Dombiak committed
15
ALTER TABLE jiveUser ADD encryptedPassword NVARCHAR(255);