wildfire_oracle.sql 549 Bytes
Newer Older
1 2
-- $Revision: 795 $
-- $Date: 2005-01-06 07:44:42 -0300 (Thu, 06 Jan 2005) $
3

4
-- Update the jiveVersion table to new definition.
5 6 7 8 9 10
DROP TABLE jiveVersion;
CREATE TABLE jiveVersion (
  name     VARCHAR2(50)  NOT NULL,
  version  INTEGER  NOT NULL,
  CONSTRAINT jiveVersion_pk PRIMARY KEY (name)
);
Gaston Dombiak's avatar
Gaston Dombiak committed
11
INSERT INTO jiveVersion (name, version) VALUES ('wildfire', 6);
12

13
-- Make password column accept null, add encrypted password column.
14
ALTER TABLE jiveUser MODIFY password VARCHAR2(32) NULL;
15 16 17
ALTER TABLE jiveUser ADD encryptedPassword VARCHAR(255);

commit;