wildfire_oracle.sql 524 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13
-- $Revision:  $
-- $Date:  $

-- Increase size of username field
ALTER TABLE jiveUser MODIFY username VARCHAR2(64);
ALTER TABLE jiveUserProp MODIFY username VARCHAR2(64);
ALTER TABLE jivePrivate MODIFY username VARCHAR2(64);
ALTER TABLE jiveOffline MODIFY username VARCHAR2(64);
ALTER TABLE jiveRoster MODIFY username VARCHAR2(64);
ALTER TABLE jiveVCard MODIFY username VARCHAR2(64);
ALTER TABLE jivePrivacyList MODIFY username VARCHAR2(64);

UPDATE jiveVersion set version=9 where name = 'wildfire';
14 15

commit;