wildfire_mysql.sql 745 Bytes
Newer Older
Gaston Dombiak's avatar
Gaston Dombiak committed
1 2 3
# $Revision:  $
# $Date:  $

4 5 6
# Increase size of username field
ALTER TABLE jiveUser MODIFY username VARCHAR(64);
ALTER TABLE jiveUserProp MODIFY username VARCHAR(64);
7

Gaston Dombiak's avatar
Gaston Dombiak committed
8
ALTER TABLE jivePrivate DROP PRIMARY KEY;
9
ALTER TABLE jivePrivate MODIFY username VARCHAR(64);
10 11
ALTER TABLE jivePrivate ADD PRIMARY KEY (username, name, namespace(100));

12 13 14 15 16
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);

Gaston Dombiak's avatar
Gaston Dombiak committed
17 18 19 20
# Increase size of column digest_frequency in pubsubSubscription
ALTER TABLE pubsubSubscription MODIFY digest_frequency INT NOT NULL;

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