# $Revision: $
# $Date: $
# Increase size of username field
ALTER TABLE jiveUser MODIFY username VARCHAR(64);
ALTER TABLE jiveUserProp MODIFY username VARCHAR(64);
ALTER TABLE jivePrivate DROP PRIMARY KEY;
ALTER TABLE jivePrivate MODIFY username VARCHAR(64);
ALTER TABLE jivePrivate ADD PRIMARY KEY (username, name, namespace(100));
ALTER TABLE jiveOffline MODIFY username VARCHAR(64);
ALTER TABLE jiveRoster MODIFY username VARCHAR(64);
ALTER TABLE jiveVCard MODIFY username VARCHAR(64);
ALTER TABLE jivePrivacyList MODIFY username VARCHAR(64);
# Increase size of column digest_frequency in pubsubSubscription
ALTER TABLE pubsubSubscription MODIFY digest_frequency INT NOT NULL;
UPDATE jiveVersion set version=9 where name = 'openfire';
-
Gaston Dombiak authored
git-svn-id: http://svn.igniterealtime.org/svn/repos/openfire/branches@8124 b35dd754-fafc-0310-a699-88a17e54d16e
89c7b203