openfire_oracle.sql

xmpp协议的客户端软件

-- $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 = 'openfire';

commit;