ALTER DATABASE eae CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
ALTER DATABASE jive CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;


-- Change EAE tables to utf8mb4

ALTER TABLE `eae`.`jiveaaprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivitycontent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivityfirehose` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivitypipeline` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveallstreamitem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveallstreamparentgroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveantimatterstreamitem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveantimatterstreamparent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveaprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivecontentbody` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivecontextstreamitem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivecontextstreamparentgroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivefirehose` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveinstanceproperty` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivelastseen` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivemovedcontent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivenodeproperty` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveprofilestreamitem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveprofilestreamparentgroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivequeuestatistics` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiverecentuserstreamupdate` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiverecommendationscores` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiverejectedreco` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivestreamassociation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivestreamconfiguration` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivetaskelection` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivetraceractivity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveupgradeversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuseractivity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserexclusions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserinboxitem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserinboxparentgroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserobjuntracking` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserrecommendations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserstreamitem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserstreamparentgroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveusertorecommendationlookup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Change JIVE tables to utf8mb4

ALTER TABLE `jive`.`boxcollaborations` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxcomments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfiles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfileversions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfolders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisartifactupdateevents` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapiscontainerconnect` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabconnections` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodulecontent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodules` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjaburlpatterns` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisstats` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisstatsactive` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfiles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfileversions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfolders` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`gamificationprtcp` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`gamificationrequestqueue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveabuse` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveacccontainer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveacclaim` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveacclaimprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveacclaimvote` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveaccvoteprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveactivity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveactivityhistry` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveannounce` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveannounceprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveanswer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapiaccessor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapientitlement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappactiontext` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappalert` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappalertack` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapperror` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappinstalert` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapprovalwrkflw` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappsecurity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappview` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivearchivepolicy` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachmentprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachsettings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachtypes` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattemptinfo` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveauditlog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveavatar` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveavatarprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveavataruser` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveavscanrecord` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebadgerole` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebadgerolerel` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveban` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinstore` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebintoken` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogpost` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogpostprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebookmark` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridge` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgedcont` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgedcontmsg` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgeoption` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgeuser` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebrowsecnt` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebrowsecntr` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebrowsefol` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebrowseprtd` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecarouselcontainer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecluster` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtauthstyle` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtconnection` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtcredtype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtsvcheader` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtsvcowner` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtsvcprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxttag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecomment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommentprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunityprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontaineraprvr` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentbackup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentmeta` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentmtprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentplacerel` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecredential` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmadaptercapabilities` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmcasemapping` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmconfiguration` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmescalationqueue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmescalationsettings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmsyncedusers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecustompermlvl` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedashboard` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedatatype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedefobjpermlvl` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedeletedusername` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedemoreco` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedevsettings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedirsyncuser` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocbodyconfig` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocbodytypes` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocbodyversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoccollab` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocelementtype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctypeelement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctypeprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocument` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentaudit` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentbody` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocversioncmmt` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedraft` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedraftimage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedraftprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevartifact` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevision` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevstatus` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveeaeuserprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveemailtoken` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveentitlement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveentitlementmsk` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveentlmntinherit` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveeptagjoin` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveerror` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveeventattendee` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexpertisetag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexportrequest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextcomments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextcontext` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensionalert` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensioncert` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensiongroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensioni18n` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensiontag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalidentity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternallogin` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextinvite` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextprops` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefeatured` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefield` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldfrmtprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldoption` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldtype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldvalue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldvldtrprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefollow` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveformattedtext` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveformtoken` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegrantedpermlvl` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroupperm` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroupprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroupuser` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroupuserhist` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivei18ntext` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveid` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidea` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideacollab` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaextfield` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaextfieldvalue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaextfldopt` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideastage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideatou` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideavote` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidentitytable` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidmembership` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimageversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimusersexternalid` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimuserspresence` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxcategory` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxentry` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxentryprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinstanceapp` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinstapppref` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinvite` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinviteprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelabel` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelabelelement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelabelmap` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelabeltype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelinkobject` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelocalizedprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelock` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelockproperty` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemarketoutmsg` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessageprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessagequeue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemetering` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemobilepushcertificate` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemobilepushregistration` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2client` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2code` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthaccesslog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthpairing` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthpasscode` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthstore` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthtoken` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjapiaccessor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjecttag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjecttagset` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjecttype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjpermlvl` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjpermlvlext` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjpermlvlmap` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjpermlvlmsk` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjtypemsk` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveocservicestats` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveofficecoauthors` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosappdata` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosfileitem` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveospropentry` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoutcome` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoutcomeprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepageviewconfig` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepalette` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepaletteimage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepaletteprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepassworddata` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepasswordhistory` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepcheckpoint` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepermlevel` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepermlvlmsk` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepermmask` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephoto` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoalbum` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoalbumprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplaceheaderbanner` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplacetopic` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplacetopic_place` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplugin` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepluginprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepoll` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepolloption` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepollvote` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepopularity` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepresenter` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprivateprops` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofilefield` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofilefldopt` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofilefldsec` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofileseclvl` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveproject` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprojectprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprojectstatus` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveproperty` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveptask` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveptaskprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepublication` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveqcompletion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveqstepprog` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveqstepprogprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivequestion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivequestionprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiverating` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveratingtype` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivereadtracker` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveredirectrules` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivereference` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveremotestore` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiverenderedcontent` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiverenderedcontentversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionaggregatebinary` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionattachment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionattachmentusers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbin` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbinary` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionimage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagebinaries` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivermtbridgedcont` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollabinteraction` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollaboration` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollaborationstate` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollaborationuser` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertcinteractionidmap` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertcinteractionperiod` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesamlauthnrequest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesecondfactorkey` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesectionelement` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveserverscript` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroup` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroupmember` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroupprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveshindigsecuritytokeninfo` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveslide` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivespamdomainwhitelist` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatelesssessioninfo` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatics` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatlvlscen` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevel` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevelpnt` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevelpntsum` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageattachment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragecomment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragecontainer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefresource` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageentupdate` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragefile` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragefileversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageinsconfig` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageinstance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragemember` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragepreview` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageresource` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageresourcename` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamaction` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamapprover` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamchannel` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamenttext` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestrnotpref` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesubscription` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesubscriptionassociation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesubscriptionsubscriber` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetagcloud` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetagset` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetagsetmap` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_1` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_2` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetasklateststatus` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskqueue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetemplatecategory` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetemplatecategorydef` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetermsandcond` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethememap` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethread` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethreadlatest` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethreadprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilecategory` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilecategorydef` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilei18n` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstgone` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepage` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepageprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileprops` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletmplassoc` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetypevldtrprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuser` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuseraltemail` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserannprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusercontainer` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusercontnrprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserimhandle` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusermesgcount` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserperm` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserprofile` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserrel` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserrelgraph` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserroster` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusersecretkey` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserstatus` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusertoremovementions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusrrelgrapr` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusrrelgrntf` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusrrellist` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusrrellistmap` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuuid` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuuidext` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveversion` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideoscreens` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveviewcount` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewatch` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewatchsettings` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhook` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhooklocks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhookqueue` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfcurrentstep` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfcurrstepprev` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfentry` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfhistorystep` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfhiststepprev` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewidget` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewidgetframe` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewidgetfrmprop` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewikilink` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewlayout` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewlayoutframe` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spattachments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spauthenticationtokens` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spcontainers` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spdocuments` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spdocumentversions` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedocpreviewtranslation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedoctranslation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spusertranslation` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Change EAE columns to utf8mb4

ALTER TABLE `eae`.`jiveaaprop` CHANGE `propName` `propName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveaaprop` CHANGE `propValue` `propValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivitycontent` CHANGE `activityID` `activityID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivityfirehose` CHANGE `activitySystemID` `activitySystemID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivityfirehose` CHANGE `activityLocaleCode` `activityLocaleCode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivityfirehose` CHANGE `activityProperties` `activityProperties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivityfirehose` CHANGE `activityAddProperties` `activityAddProperties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivitypipeline` CHANGE `authors` `authors` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivitypipeline` CHANGE `hiders` `hiders` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveactivitypipeline` CHANGE `participants` `participants` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveaprop` CHANGE `propName` `propName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivecontentbody` CHANGE `contentBody` `contentBody` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveinstanceproperty` CHANGE `propName` `propName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveinstanceproperty` CHANGE `propValue` `propValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivenodeproperty` CHANGE `nodeID` `nodeID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivenodeproperty` CHANGE `propName` `propName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivenodeproperty` CHANGE `propValue` `propValue` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivequeuestatistics` CHANGE `queueName` `queueName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiverecentuserstreamupdate` CHANGE `processingNodeID` `processingNodeID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiverecentuserstreamupdate` CHANGE `users` `users` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiverecommendationscores` CHANGE `rankName` `rankName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivestreamconfiguration` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivetaskelection` CHANGE `taskName` `taskName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jivetaskelection` CHANGE `taskNodeID` `taskNodeID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveupgradeversion` CHANGE `name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveuserrecommendations` CHANGE `recoID` `recoID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveusertorecommendationlookup` CHANGE `queryKey` `queryKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `eae`.`jiveusertorecommendationlookup` CHANGE `recoID` `recoID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Change Jive columns to utf8mb4

ALTER TABLE `jive`.`boxcomments` CHANGE `boxCommentId` `boxCommentId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfiles` CHANGE `boxFileId` `boxFileId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfiles` CHANGE `etag` `etag` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfiles` CHANGE `sequenceId` `sequenceId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfiles` CHANGE `boxFileUrl` `boxFileUrl` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfileversions` CHANGE `boxFileId` `boxFileId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfileversions` CHANGE `boxFileVersionId` `boxFileVersionId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`boxfolders` CHANGE `boxFolderId` `boxFolderId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisartifactupdateevents` CHANGE `eventType` `eventType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisartifactupdateevents` CHANGE `feature` `feature` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisartifactupdateevents` CHANGE `description` `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabconnections` CHANGE `url` `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodulecontent` CHANGE `contentKey` `contentKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodulecontent` CHANGE `binKey` `binKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodulecontent` CHANGE `moduleName` `moduleName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodules` CHANGE `moduleName` `moduleName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodules` CHANGE `moduleDisplayName` `moduleDisplayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjabmodules` CHANGE `ext_key` `ext_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisjaburlpatterns` CHANGE `pattern` `pattern` varchar(350) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`eapisstatsactive` CHANGE `knownVersion` `knownVersion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfiles` CHANGE `boxFileId` `boxFileId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfiles` CHANGE `etag` `etag` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfiles` CHANGE `sequenceId` `sequenceId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfileversions` CHANGE `boxFileId` `boxFileId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfileversions` CHANGE `boxFileVersionId` `boxFileVersionId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfolders` CHANGE `boxFolderId` `boxFolderId` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfolders` CHANGE `jiveURL` `jiveURL` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfolders` CHANGE `jiveContainerRelativeURL` `jiveContainerRelativeURL` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfolders` CHANGE `jiveAccessToken` `jiveAccessToken` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`espboxfolders` CHANGE `jiveRefreshToken` `jiveRefreshToken` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`gamificationrequestqueue` CHANGE `data` `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveabuse` CHANGE `comments` `comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveacclaim` CHANGE `acclaimType` `acclaimType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveacclaimprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveacclaimprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveaccvoteprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveaccvoteprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveannounce` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveannounce` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveannounce` CHANGE `subjectURL` `subjectURL` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveannounceprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveannounceprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapientitlement` CHANGE `entitlementType` `entitlementType` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `appUUID` `appUUID` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `appPath` `appPath` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `systemLicenseURL` `systemLicenseURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `sysLicenseURLMD5` `sysLicenseURLMD5` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `gadgetHash` `gadgetHash` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `internalName` `internalName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `refreshState` `refreshState` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `extensionUUID` `extensionUUID` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapp` CHANGE `installOrigin` `installOrigin` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `contributionID` `contributionID` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `iconURL` `iconURL` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `style` `style` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `appView` `appView` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `viewTarget` `viewTarget` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `path` `path` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `filter` `filter` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `url` `url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappaction` CHANGE `windowSpec` `windowSpec` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappactiontext` CHANGE `locale` `locale` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappactiontext` CHANGE `text` `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappalert` CHANGE `notes` `notes` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappalert` CHANGE `creatorName` `creatorName` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapperror` CHANGE `source` `source` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapperror` CHANGE `sourceDescription` `sourceDescription` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappinstalert` CHANGE `notes` `notes` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappinstalert` CHANGE `creatorName` `creatorName` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapprovalwrkflw` CHANGE `requestMessage` `requestMessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveapprovalwrkflw` CHANGE `responseMessage` `responseMessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappview` CHANGE `title` `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveappview` CHANGE `initialHeights` `initialHeights` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachment` CHANGE `documentID` `documentID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachment` CHANGE `fileName` `fileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachment` CHANGE `contentType` `contentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachmentprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachmentprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachtypes` CHANGE `allowedType` `allowedType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattachtypes` CHANGE `disallowedType` `disallowedType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveattemptinfo` CHANGE `identifier` `identifier` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveauditlog` CHANGE `description` `description` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveauditlog` CHANGE `node` `node` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveauditlog` CHANGE `details` `details` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveavatarprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveavatarprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveavscanrecord` CHANGE `violations` `violations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebadgerole` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebadgerolerel` CHANGE `badgeImageURI` `badgeImageURI` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveban` CHANGE `ipAddress` `ipAddress` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveban` CHANGE `comments` `comments` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `contentEncoding` `contentEncoding` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `contentLanguage` `contentLanguage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `contentLocation` `contentLocation` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `contentMD5` `contentMD5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `contentType` `contentType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `description` `description` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinmetadata` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinstore` CHANGE `binKey` `binKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebinstore` CHANGE `namespace` `namespace` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebintoken` CHANGE `token` `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebintoken` CHANGE `url` `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebintoken` CHANGE `verb` `verb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblog` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblog` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblog` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblog` CHANGE `pingServices` `pingServices` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogpost` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogpost` CHANGE `permalink` `permalink` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogpost` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogpostprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogpostprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveblogprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebookmark` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebookmark` CHANGE `notes` `notes` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridge` CHANGE `url` `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridge` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridge` CHANGE `description` `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgedcont` CHANGE `origSubject` `origSubject` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgedcont` CHANGE `origTags` `origTags` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgedcont` CHANGE `url` `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgedcont` CHANGE `uuid` `uuid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgedcontmsg` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgeuser` CHANGE `uuid` `uuid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebridgeuser` CHANGE `remoteUsername` `remoteUsername` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebrowsecnt` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebrowsecntr` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivebrowsecntr` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecarouselcontainer` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecluster` CHANGE `id` `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecluster` CHANGE `hostName` `hostName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtauthstyle` CHANGE `description` `description` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtauthstyle` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtauthstyle` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtauthstyle` CHANGE `credentialsTypes` `credentialsTypes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtconnection` CHANGE `alias` `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtcredtype` CHANGE `description` `description` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtcredtype` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtcredtype` CHANGE `format` `format` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtcredtype` CHANGE `helpKey` `helpKey` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtcredtype` CHANGE `labelKey` `labelKey` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtcredtype` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CHANGE `description` `description` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CHANGE `documentationUrl` `documentationUrl` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CHANGE `iconUrl` `iconUrl` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CHANGE `url` `url` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtendpoint` CHANGE `wsdlUrl` `wsdlUrl` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtsvcheader` CHANGE `headerName` `headerName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtsvcheader` CHANGE `headerValue` `headerValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtsvcprop` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxtsvcprop` CHANGE `value` `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxttag` CHANGE `description` `description` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxttag` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecnxttag` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecomment` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecomment` CHANGE `email` `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecomment` CHANGE `url` `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecomment` CHANGE `ip` `ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecomment` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommentprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommentprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunity` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunity` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunity` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunity` CHANGE `localeCode` `localeCode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunityprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecommunityprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontent` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontent` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentbackup` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentmtprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentmtprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentprop` CHANGE `propName` `propName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecontentprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmadaptercapabilities` CHANGE `adapterName` `adapterName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmadaptercapabilities` CHANGE `description` `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmcasemapping` CHANGE `caseID` `caseID` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmconfiguration` CHANGE `adapterName` `adapterName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecrmconfiguration` CHANGE `configurationType` `configurationType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivecustompermlvl` CHANGE `description` `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedashboard` CHANGE `displayName` `displayName` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedatatype` CHANGE `dataType` `dataType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedeletedusername` CHANGE `username` `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedirsyncuser` CHANGE `username` `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedirsyncuser` CHANGE `dn` `dn` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedirsyncuser` CHANGE `ldif` `ldif` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocbodytypes` CHANGE `allowedType` `allowedType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocbodytypes` CHANGE `disallowedType` `disallowedType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocelementtype` CHANGE `name` `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctype` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctype` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctype` CHANGE `validator` `validator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctypeprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedoctypeprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocument` CHANGE `documentID` `documentID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentaudit` CHANGE `oldValue` `oldValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentbody` CHANGE `bodyText` `bodyText` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentbody` CHANGE `fileName` `fileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentbody` CHANGE `contentType` `contentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocumentprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocversion` CHANGE `state` `state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocversion` CHANGE `title` `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocversion` CHANGE `summary` `summary` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedocversioncmmt` CHANGE `comments` `comments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedraft` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedraft` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedraftprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedraftprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevartifact` CHANGE `instanceID` `instanceID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevartifact` CHANGE `artifactType` `artifactType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevartifact` CHANGE `fileName` `fileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevartifact` CHANGE `contentType` `contentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevartifact` CHANGE `htmlSubType` `htmlSubType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevartifact` CHANGE `htmlComponentName` `htmlComponentName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevision` CHANGE `fileName` `fileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivedvrevstatus` CHANGE `message` `message` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveeaeuserprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveeaeuserprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveentitlementmsk` CHANGE `name` `name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveerror` CHANGE `source` `source` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveerror` CHANGE `message` `message` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `name` `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `tagline` `tagline` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `description` `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `host` `host` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `location` `location` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `street` `street` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `city` `city` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `phone` `phone` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `email` `email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `url` `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `country` `country` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `locale` `locale` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveevent` CHANGE `icsUid` `icsUid` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexportrequest` CHANGE `error` `error` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexportrequest` CHANGE `searchQuery` `searchQuery` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextcomments` CHANGE `externalID` `externalID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextcontext` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `extensionUUID` `extensionUUID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `authorData` `authorData` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `definition` `definition` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `metadata` `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `serviceURL` `serviceURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `tenancyURI` `tenancyURI` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `targetConfig` `targetConfig` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `description` `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `publishedUUID` `publishedUUID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `publishedClientId` `publishedClientId` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `publishedClientSecret` `publishedClientSecret` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `status` `status` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `type` `type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `pluginSourceSHA1` `pluginSourceSHA1` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextension` CHANGE `publicResourceHash` `publicResourceHash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensionalert` CHANGE `message` `message` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensionalert` CHANGE `alertType` `alertType` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensionalert` CHANGE `severity` `severity` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensionalert` CHANGE `contextData` `contextData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensioncert` CHANGE `certificate` `certificate` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensioni18n` CHANGE `locale` `locale` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensioni18n` CHANGE `bundle` `bundle` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextensiontag` CHANGE `value` `value` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalidentity` CHANGE `identityValue` `identityValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalidentity` CHANGE `identityValueMD5` `identityValueMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalidentity` CHANGE `identityValueMD5lowerCase` `identityValueMD5lowerCase` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternallogin` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternallogin` CHANGE `url` `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CHANGE `protocol` `protocol` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CHANGE `host` `host` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CHANGE `path` `path` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CHANGE `query` `query` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CHANGE `ref` `ref` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CHANGE `title` `title` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveexternalurl` CHANGE `mimeType` `mimeType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextprops` CHANGE `clientID` `clientID` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextprops` CHANGE `clientIDMD5` `clientIDMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextprops` CHANGE `extPropsKey` `extPropsKey` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextprops` CHANGE `extPropsKeyMD5` `extPropsKeyMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextprops` CHANGE `extPropsValue` `extPropsValue` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveextprops` CHANGE `extPropsValueMD5` `extPropsValueMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefield` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefield` CHANGE `displayName` `displayName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefield` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefield` CHANGE `defValue` `defValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldfrmtprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldfrmtprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldoption` CHANGE `optionValue` `optionValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldtype` CHANGE `name` `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldtype` CHANGE `displayName` `displayName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldtype` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldtype` CHANGE `formatter` `formatter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldtype` CHANGE `validator` `validator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldvalue` CHANGE `strValue` `strValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldvldtrprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivefieldvldtrprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveformtoken` CHANGE `tokenKey` `tokenKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveformtoken` CHANGE `tokenValue` `tokenValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroup` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroup` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroupprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivegroupprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivei18ntext` CHANGE `locale` `locale` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivei18ntext` CHANGE `text` `text` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivei18ntext` CHANGE `aliasKey` `aliasKey` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivei18ntext` CHANGE `defaultText` `defaultText` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidea` CHANGE `ideaSubject` `ideaSubject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidea` CHANGE `ideaBody` `ideaBody` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidea` CHANGE `ideaState` `ideaState` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaextfield` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaextfieldvalue` CHANGE `fieldValue` `fieldValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaextfldopt` CHANGE `optionValue` `optionValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaprop` CHANGE `ideaPropName` `ideaPropName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideaprop` CHANGE `ideaPropValue` `ideaPropValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideastage` CHANGE `stageName` `stageName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideastage` CHANGE `stageBackgroundColor` `stageBackgroundColor` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideastage` CHANGE `stageForegroundColor` `stageForegroundColor` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveideatou` CHANGE `ideaTOUText` `ideaTOUText` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidentitytable` CHANGE `dummy` `dummy` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveidmembership` CHANGE `slug` `slug` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimage` CHANGE `fileName` `fileName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimage` CHANGE `contentType` `contentType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimusersexternalid` CHANGE `externalId` `externalId` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimuserspresence` CHANGE `userId` `userId` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveimuserspresence` CHANGE `statusMessage` `statusMessage` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxcategory` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxcategory` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxcategory` CHANGE `iconClass` `iconClass` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxentry` CHANGE `requestMessage` `requestMessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxentry` CHANGE `responseMessage` `responseMessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxentryprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinboxentryprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinstanceapp` CHANGE `appInstanceUUID` `appInstanceUUID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinstanceapp` CHANGE `appURL` `appURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinstanceapp` CHANGE `appURLMD5` `appURLMD5` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinstapppref` CHANGE `name` `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinstapppref` CHANGE `propValue` `propValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinvite` CHANGE `email` `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinviteprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveinviteprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelabel` CHANGE `name` `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelabel` CHANGE `style` `style` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelabelelement` CHANGE `value` `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelinkobject` CHANGE `linkKey` `linkKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelocalizedprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelocalizedprop` CHANGE `propValue` `propValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelocalizedprop` CHANGE `locale` `locale` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelock` CHANGE `lockName` `lockName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelockproperty` CHANGE `lockName` `lockName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelockproperty` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivelockproperty` CHANGE `value` `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemarketoutmsg` CHANGE `message` `message` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessage` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessage` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessageprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessageprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessagequeue` CHANGE `description` `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemessagequeue` CHANGE `originator` `originator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemetering` CHANGE `encryptedDate` `encryptedDate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemetering` CHANGE `component` `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemetering` CHANGE `resourceType` `resourceType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemetering` CHANGE `encryptedUsageAmt` `encryptedUsageAmt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemobilepushcertificate` CHANGE `service` `service` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemobilepushregistration` CHANGE `deviceToken` `deviceToken` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemobilepushregistration` CHANGE `pushPreference` `pushPreference` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivemobilepushregistration` CHANGE `supportedTypes` `supportedTypes` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2client` CHANGE `clientID` `clientID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2client` CHANGE `clientSecret` `clientSecret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2client` CHANGE `redirectURI` `redirectURI` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2code` CHANGE `value` `value` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2code` CHANGE `scope` `scope` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2code` CHANGE `redirectURI` `redirectURI` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauth2code` CHANGE `agent` `agent` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthpairing` CHANGE `pairingSubTypeID` `pairingSubTypeID` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthpairing` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthpairing` CHANGE `oneTimeCode` `oneTimeCode` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthpairing` CHANGE `tempPassCodeEncoded` `tempPassCodeEncoded` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthpasscode` CHANGE `passcodeEncoded` `passcodeEncoded` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthstore` CHANGE `servicename` `servicename` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthstore` CHANGE `tokenname` `tokenname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthstore` CHANGE `tokenvalue` `tokenvalue` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthstore` CHANGE `tokensecret` `tokensecret` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthtoken` CHANGE `clientID` `clientID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthtoken` CHANGE `clientSecret` `clientSecret` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthtoken` CHANGE `refreshToken` `refreshToken` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthtoken` CHANGE `accessToken` `accessToken` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoauthtoken` CHANGE `sessionID` `sessionID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjecttype` CHANGE `code` `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjpermlvl` CHANGE `name` `name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjpermlvl` CHANGE `description` `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveobjpermlvl` CHANGE `lvlType` `lvlType` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveocservicestats` CHANGE `httpMethod` `httpMethod` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveocservicestats` CHANGE `serviceName` `serviceName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveocservicestats` CHANGE `appUUID` `appUUID` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosappdata` CHANGE `gadgetID` `gadgetID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosappdata` CHANGE `fieldName` `fieldName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosappdata` CHANGE `fieldValue` `fieldValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosappdata` CHANGE `fieldType` `fieldType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosfileitem` CHANGE `appID` `appID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosfileitem` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveosfileitem` CHANGE `mimetype` `mimetype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveospropentry` CHANGE `globalKey` `globalKey` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveospropentry` CHANGE `itemKey` `itemKey` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveospropentry` CHANGE `stringValue` `stringValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoutcome` CHANGE `note` `note` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoutcomeprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveoutcomeprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepageviewconfig` CHANGE `component` `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepageviewconfig` CHANGE `configXml` `configXml` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepalette` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepaletteimage` CHANGE `fileName` `fileName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepaletteprop` CHANGE `propKey` `propKey` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepaletteprop` CHANGE `propValue` `propValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepasswordhistory` CHANGE `passwordHash` `passwordHash` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepcheckpoint` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepcheckpoint` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepermlevel` CHANGE `name` `name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepermmask` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephoto` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephoto` CHANGE `description` `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoalbum` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoalbum` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoalbum` CHANGE `description` `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoalbumprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoalbumprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivephotoprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplaceheaderbanner` CHANGE `location` `location` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplaceheaderbanner` CHANGE `thumbnailLocation` `thumbnailLocation` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplaceheaderbanner` CHANGE `bgRepeat` `bgRepeat` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplaceheaderbanner` CHANGE `textColor` `textColor` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplaceheaderbanner` CHANGE `bgColor` `bgColor` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplaceheaderbanner` CHANGE `bgPosition` `bgPosition` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplacetopic` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveplugin` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepluginprop` CHANGE `pluginName` `pluginName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepluginprop` CHANGE `propName` `propName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepluginprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepoll` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepoll` CHANGE `description` `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepolloption` CHANGE `optionText` `optionText` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepollvote` CHANGE `guestID` `guestID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepresenter` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepresenter` CHANGE `template` `template` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprivateprops` CHANGE `clientID` `clientID` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprivateprops` CHANGE `clientIDMD5` `clientIDMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprivateprops` CHANGE `privatePropsKey` `privatePropsKey` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprivateprops` CHANGE `privatePropsKeyMD5` `privatePropsKeyMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprivateprops` CHANGE `privatePropsValue` `privatePropsValue` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprivateprops` CHANGE `privatePropsValueMD5` `privatePropsValueMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofilefield` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofilefield` CHANGE `extMapping` `extMapping` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofilefldopt` CHANGE `fieldValue` `fieldValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofileseclvl` CHANGE `nameKey` `nameKey` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprofileseclvl` CHANGE `strategyName` `strategyName` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveproject` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveproject` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveproject` CHANGE `displayname` `displayname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprojectprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprojectprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveprojectstatus` CHANGE `statusDesc` `statusDesc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveproperty` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveproperty` CHANGE `propValue` `propValue` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveptask` CHANGE `subject` `subject` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveptask` CHANGE `body` `body` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveptaskprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveptaskprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivepublication` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveqcompletion` CHANGE `questName` `questName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveqstepprog` CHANGE `stepName` `stepName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveqstepprogprop` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveqstepprogprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivequestionprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivequestionprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveratingtype` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveredirectrules` CHANGE `input` `input` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveredirectrules` CHANGE `output` `output` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveremotestore` CHANGE `storeKey` `storeKey` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiverenderedcontent` CHANGE `locale` `locale` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiverenderedcontent` CHANGE `value` `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `contentType` `contentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `authorAddress` `authorAddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `ccAddresses` `ccAddresses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `actionType` `actionType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `tags` `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `metadata` `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `containerLink` `containerLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `containerLabel` `containerLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `authorLink` `authorLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `authorLabel` `authorLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `itemLink` `itemLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `itemLabel` `itemLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionactiance` CHANGE `content` `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionaggregatebinary` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionaggregatebinary` CHANGE `originalType` `originalType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionaggregatebinary` CHANGE `originalDisplayType` `originalDisplayType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionaggregatebinary` CHANGE `contentType` `contentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionaggregatebinary` CHANGE `binstoreName` `binstoreName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbin` CHANGE `binaryName` `binaryName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbin` CHANGE `binaryDisplayType` `binaryDisplayType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbin` CHANGE `binaryContentType` `binaryContentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbin` CHANGE `binstoreName` `binstoreName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbinary` CHANGE `binaryName` `binaryName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbinary` CHANGE `binaryDisplayType` `binaryDisplayType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentioncapturedbinary` CHANGE `binaryContentType` `binaryContentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `contentType` `contentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `authorAddress` `authorAddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `ccAddresses` `ccAddresses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `actionType` `actionType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `tags` `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `metadata` `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `containerLink` `containerLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `containerLabel` `containerLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `authorLink` `authorLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `authorLabel` `authorLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `itemLink` `itemLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `itemLabel` `itemLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionmessagearchive` CHANGE `content` `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `contentType` `contentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `authorAddress` `authorAddress` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `ccAddresses` `ccAddresses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `subject` `subject` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `actionType` `actionType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `tags` `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `metadata` `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `containerLink` `containerLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `containerLabel` `containerLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `authorLink` `authorLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `authorLabel` `authorLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `itemLink` `itemLink` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `itemLabel` `itemLabel` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveretentionqueue` CHANGE `content` `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivermtbridgedcont` CHANGE `url` `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivermtbridgedcont` CHANGE `uuid` `uuid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollabinteraction` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollaboration` CHANGE `externalID` `externalID` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollaboration` CHANGE `subject` `subject` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivertccollaboration` CHANGE `subjectUrl` `subjectUrl` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesamlauthnrequest` CHANGE `requestID` `requestID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesamlauthnrequest` CHANGE `messageXml` `messageXml` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `shortName` `shortName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `description` `description` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `descriptorURL` `descriptorURL` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `iconURL` `iconURL` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `searchContentType` `searchContentType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `searchHttpMethod` `searchHttpMethod` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `searchURL` `searchURL` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `externalSearchURL` `externalSearchURL` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `queryTestTerm` `queryTestTerm` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `username` `username` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesearchengine` CHANGE `password` `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesecondfactorkey` CHANGE `secretKey` `secretKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveserverscript` CHANGE `filename` `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveserverscript` CHANGE `extensionUUID` `extensionUUID` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveserverscript` CHANGE `jsHash` `jsHash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveserverscript` CHANGE `js` `js` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroup` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroup` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroup` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroupprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivesgroupprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveshindigsecuritytokeninfo` CHANGE `gadgetUrlMD5` `gadgetUrlMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveslide` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveslide` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveslide` CHANGE `targetLink` `targetLink` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveslide` CHANGE `imageURI` `imageURI` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivespamdomainwhitelist` CHANGE `whitelistURL` `whitelistURL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatelesssessioninfo` CHANGE `userAgent` `userAgent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatelesssessioninfo` CHANGE `ip` `ip` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatics` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatics` CHANGE `filename` `filename` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatics` CHANGE `cryptHash` `cryptHash` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatlvlscen` CHANGE `i18nKey` `i18nKey` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatlvlscen` CHANGE `code` `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevel` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevel` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevel` CHANGE `imagePath` `imagePath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevel` CHANGE `largeImagePath` `largeImagePath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestatuslevelpnt` CHANGE `code` `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageattachment` CHANGE `espAttID` `espAttID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragecomment` CHANGE `espCommentID` `espCommentID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragecontainer` CHANGE `externalID` `externalID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragecontainer` CHANGE `containerConfig` `containerConfig` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragefile` CHANGE `espFileID` `espFileID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragefile` CHANGE `previewAppID` `previewAppID` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragefile` CHANGE `previewAppURL` `previewAppURL` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragefileversion` CHANGE `espFileVersionID` `espFileVersionID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragefileversion` CHANGE `previewAppContext` `previewAppContext` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageinsconfig` CHANGE `instanceConfig` `instanceConfig` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageinstance` CHANGE `displayName` `displayName` varchar(1027) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragemember` CHANGE `espID` `espID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragepreview` CHANGE `espPreviewID` `espPreviewID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragepreview` CHANGE `exStorageFileID` `exStorageFileID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageresource` CHANGE `URL` `URL` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestorageresourcename` CHANGE `name` `name` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamaction` CHANGE `type` `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamaction` CHANGE `method` `method` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamaction` CHANGE `url` `url` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamaction` CHANGE `label` `label` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamchannel` CHANGE `channelSigMD5` `channelSigMD5` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamchannel` CHANGE `channelSignature` `channelSignature` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamchannel` CHANGE `generatorID` `generatorID` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `verb` `verb` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `title` `title` varchar(420) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `body` `body` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `summary` `summary` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `activityIDMD5` `activityIDMD5` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `activityID` `activityID` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `activityFaviconURL` `activityFaviconURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `objectTitle` `objectTitle` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `objectMediaType` `objectMediaType` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `unmappedValues` `unmappedValues` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `releaseKeySHA1` `releaseKeySHA1` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamentry` CHANGE `activitySpec` `activitySpec` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamenttext` CHANGE `locale` `locale` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestreamenttext` CHANGE `text` `text` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetag` CHANGE `tagname` `tagname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetagset` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetagset` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory` CHANGE `taskUid` `taskUid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory` CHANGE `executor` `executor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory` CHANGE `executionError` `executionError` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_1` CHANGE `taskUid` `taskUid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_1` CHANGE `executor` `executor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_1` CHANGE `executionError` `executionError` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_2` CHANGE `taskUid` `taskUid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_2` CHANGE `executor` `executor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskhistory_2` CHANGE `executionError` `executionError` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetasklateststatus` CHANGE `taskUid` `taskUid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetasklateststatus` CHANGE `executor` `executor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskqueue` CHANGE `taskUid` `taskUid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskqueue` CHANGE `lockingNode` `lockingNode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetaskqueue` CHANGE `taskDigest` `taskDigest` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetemplatecategorydef` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetemplatecategorydef` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetermsandcond` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethememap` CHANGE `theme` `theme` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethememap` CHANGE `mapType` `mapType` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethememap` CHANGE `stringValue` `stringValue` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethreadprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivethreadprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `tileName` `tileName` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `clientID` `clientID` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `description` `description` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `productName` `productName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `visualStyle` `visualStyle` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `displayWidth` `displayWidth` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `pageType` `pageType` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `defaultSharing` `defaultSharing` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `sampleData` `sampleData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `configurationURL` `configurationURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `actionURL` `actionURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `registerURL` `registerURL` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `unregisterURL` `unregisterURL` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `viewURL` `viewURL` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `dataProviderKey` `dataProviderKey` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `enabledProviderKey` `enabledProviderKey` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `state` `state` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `extensionUUID` `extensionUUID` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetile` CHANGE `internalI18nKeys` `internalI18nKeys` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilecategorydef` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilecategorydef` CHANGE `description` `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilei18n` CHANGE `locale` `locale` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilei18n` CHANGE `bundle` `bundle` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `state` `state` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `instanceData` `instanceData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `config` `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `status` `status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `pushErrorDetail` `pushErrorDetail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `externalID` `externalID` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `privatePath` `privatePath` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileinstance` CHANGE `streamIconURL` `streamIconURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepage` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepage` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepage` CHANGE `layout` `layout` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepage` CHANGE `pageType` `pageType` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepageprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilepageprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileprops` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetileprops` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `openGraphType` `openGraphType` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `externalURL` `externalURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `iconURL` `iconURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `imageURL` `imageURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `attributionEmail` `attributionEmail` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `attributionName` `attributionName` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `actionName` `actionName` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `actionDescription` `actionDescription` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `externalID` `externalID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `context` `context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `modifiername` `modifiername` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `modifieremail` `modifieremail` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetilestreamentry` CHANGE `externalGroupName` `externalGroupName` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `extensionUUID` `extensionUUID` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `templateName` `templateName` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `displayName` `displayName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `subtitle` `subtitle` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `blurb` `blurb` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `description` `description` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `backgroundImageURL` `backgroundImageURL` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `bgColor` `bgColor` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `textColor` `textColor` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `bgRepeat` `bgRepeat` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `bgPosition` `bgPosition` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `contentTypes` `contentTypes` varchar(1500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetiletemplate` CHANGE `state` `state` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetypevldtrprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivetypevldtrprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuser` CHANGE `username` `username` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuser` CHANGE `passwordHash` `passwordHash` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuser` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuser` CHANGE `firstName` `firstName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuser` CHANGE `lastName` `lastName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuser` CHANGE `email` `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuseraltemail` CHANGE `email` `email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusercontnrprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusercontnrprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserimhandle` CHANGE `imHandle` `imHandle` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserprofile` CHANGE `value` `value` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserprop` CHANGE `propValue` `propValue` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserrel` CHANGE `state` `state` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserrelgraph` CHANGE `name` `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserrelgraph` CHANGE `labelPeer` `labelPeer` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserrelgraph` CHANGE `labelManager` `labelManager` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserrelgraph` CHANGE `labelDirRpt` `labelDirRpt` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusersecretkey` CHANGE `keyValue` `keyValue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuserstatus` CHANGE `userStatusText` `userStatusText` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusertoremovementions` CHANGE `metadata` `metadata` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusrrellist` CHANGE `name` `name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveusrrellist` CHANGE `labelStyle` `labelStyle` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuuid` CHANGE `uuid` `uuid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuuidext` CHANGE `uuid` `uuid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuuidext` CHANGE `externalIDType` `externalIDType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveuuidext` CHANGE `externalID` `externalID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jiveversion` CHANGE `name` `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `subject` `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `body` `body` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `externalID` `externalID` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `videoType` `videoType` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `videoSource` `videoSource` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `videoMetadata` `videoMetadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `videoThumbnail` `videoThumbnail` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivevideo` CHANGE `embedSource` `embedSource` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhook` CHANGE `url` `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhook` CHANGE `bugDetail` `bugDetail` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhook` CHANGE `types` `types` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhook` CHANGE `typesMD5` `typesMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhook` CHANGE `fields` `fields` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhooklocks` CHANGE `urlMD5` `urlMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhooklocks` CHANGE `lockingNode` `lockingNode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhookqueue` CHANGE `url` `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewebhookqueue` CHANGE `urlMD5` `urlMD5` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfcurrentstep` CHANGE `owner` `owner` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfcurrentstep` CHANGE `status` `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfcurrentstep` CHANGE `caller` `caller` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfentry` CHANGE `name` `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfhistorystep` CHANGE `owner` `owner` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfhistorystep` CHANGE `status` `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewfhistorystep` CHANGE `caller` `caller` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewidget` CHANGE `className` `className` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewidget` CHANGE `type` `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewidgetfrmprop` CHANGE `name` `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewidgetfrmprop` CHANGE `propValue` `propValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewikilink` CHANGE `targetURL` `targetURL` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewikilink` CHANGE `targetText` `targetText` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewikilink` CHANGE `targetDescription` `targetDescription` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewikilink` CHANGE `targetAnchorText` `targetAnchorText` varchar(3500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivewlayout` CHANGE `className` `className` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spattachments` CHANGE `attachmentGuid` `attachmentGuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spattachments` CHANGE `originalSubmittedFileType` `originalSubmittedFileType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spattachments` CHANGE `originalFileName` `originalFileName` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spauthenticationtokens` CHANGE `authToken` `authToken` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `url` `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `credentialsType` `credentialsType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `description` `description` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `domain` `domain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `username` `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `everyonePrincipal` `everyonePrincipal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `fullControlPrincipal` `fullControlPrincipal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `sharepoint_facing_address` `sharepoint_facing_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `kdc` `kdc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `registrationtoken` `registrationtoken` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `sitecollectionid` `sitecollectionid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `WST2005wctx` `WST2005wctx` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `WST2005wtrealm` `WST2005wtrealm` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `WST2005wreply` `WST2005wreply` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `WST2005STSUrl` `WST2005STSUrl` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `default_parent_site_url` `default_parent_site_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `default_parent_site_guid` `default_parent_site_guid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `is_default` `is_default` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `searchiconurl` `searchiconurl` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `searchexternalurl` `searchexternalurl` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `searchscopetype` `searchscopetype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `searchscope` `searchscope` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `searchtestkeywords` `searchtestkeywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `sp_version` `sp_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spconnectionproperties` CHANGE `connection_type` `connection_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spcontainers` CHANGE `containerMode` `containerMode` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spcontainers` CHANGE `siteGuid` `siteGuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spcontainers` CHANGE `siteUrl` `siteUrl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spcontainers` CHANGE `remotedocuments` `remotedocuments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spdocuments` CHANGE `documentGuid` `documentGuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spdocumentversions` CHANGE `sharepointVersion` `sharepointVersion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spdocumentversions` CHANGE `originalSubmittedFileType` `originalSubmittedFileType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spdocumentversions` CHANGE `originalFileName` `originalFileName` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedocpreviewtranslation` CHANGE `id` `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedocpreviewtranslation` CHANGE `spsiteguid` `spsiteguid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedocpreviewtranslation` CHANGE `spfileguid` `spfileguid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedoctranslation` CHANGE `spguid` `spguid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedoctranslation` CHANGE `filename` `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedoctranslation` CHANGE `spuser` `spuser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedoctranslation` CHANGE `status` `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedoctranslation` CHANGE `modificationdate` `modificationdate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spremotedoctranslation` CHANGE `creationdate` `creationdate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spusertranslation` CHANGE `spUserID` `spUserID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `url` `url` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `credentialsType` `credentialsType` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `description` `description` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `domain` `domain` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `username` `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `everyonePrincipal` `everyonePrincipal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `fullControlPrincipal` `fullControlPrincipal` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `jive_facing_address` `jive_facing_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `kdc` `kdc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `is_default` `is_default` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `sp_version` `sp_version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `managed_path_web_application` `managed_path_web_application` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `new_site_creation_policy` `new_site_creation_policy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `WST2005wctx` `WST2005wctx` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `WST2005wtrealm` `WST2005wtrealm` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `WST2005wreply` `WST2005wreply` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`spwebappconnectionproperties` CHANGE `WST2005STSUrl` `WST2005STSUrl` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Special case where row size exceeds max limit
-- ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `description` `description` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `description` `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `healthCheckURL` `healthCheckURL` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `healthCheckURL` `healthCheckURL` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `name` `name` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `displayName` `displayName` varchar(1027) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `configInstanceURL` `configInstanceURL` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `configContainerURL` `configContainerURL` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `registerURL` `registerURL` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `resolveResourcesURL` `resolveResourcesURL` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `perfixURL` `perfixURL` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `userMappingOptions` `userMappingOptions` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `extensionUUID` `extensionUUID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `clientID` `clientID` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `goToContainerName` `goToContainerName` varchar(1027) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `goToFileName` `goToFileName` varchar(1027) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `internalI18nKeys` `internalI18nKeys` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE `jive`.`jivestoragedefinition` CHANGE `userFaceURL` `userFaceURL` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

ALTER TABLE `jive`.`jivestoragedefinition` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
