wildfire_oracle.sql

来自「基于Jabber协议的即时消息服务器」· SQL 代码 · 共 15 行

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

commit;