# jiveRoster: Change jid column to varchar
ALTER TABLE jiveRoster ALTER COLUMN jid jid varchar(1024) not null;

# jiveRoster: Add new index
ALTER TABLE jiveRoster ADD INDEX jiveRoster_jid_idx (jid);

UPDATE jiveVersion set version=14 where name = 'openfire';

# jiveRoster: Change jid column to varchar
ALTER TABLE jiveRoster CHANGE COLUMN jid jid varchar(1024) not null;

# jiveRoster: Add new index
ALTER TABLE jiveRoster ADD INDEX jiveRoster_jid_idx (jid);

UPDATE jiveVersion set version=14 where name = 'openfire';

Switch from ALTER COLUMN to CHANGE COLUMN.
[JM-1315] Switch from ALTER COLUMN to CHANGE COLUMN.


git-svn-id: 2e83ce7f183c9abd424edb3952fab2cdab7acd7f@10182 b35dd754-fafc-0310-a699-88a17e54d16e
