前言
真的非常震撼，过去的一个月，在工作中遇到了两个问题，通过ChatGPT很好的帮我解决了问题和大家一起分享一下
问题一[环境变量问题]
在安装nextcloud时有一个语言环境的问题一直困扰着我。提示没有安装对应的语言包，但实际情况是所有的语言包都已经安装好了。我一直怀疑是php8.1-fpm或者apache2中对应的环境变量没有传递过去导致的。所以我用ChatGPT试一下如何解决在php8.1-fpm和apache2程序环境中添加环境变量。
PHP8.1-FPM环境变量如何设置
edu_vlovev_cn :
how to set enviroment in php8.1-fpm ?
ChatGPT :
To set environment variables in PHP 8.1-fpm, you can follow these steps:
1. Open your PHP FPM configuration file located at `/etc/php/8.1/fpm/pool.d/www.conf`
2. Add the following line to the bottom of the file (replace `ENV_VAR_NAME` and `ENV_VAR_VALUE` with your actual environment variable name and value):
```
env[ENV_VAR_NAME] = ENV_VAR_VALUE
```
3. Save the file and restart the PHP FPM service with the following command:
```
sudo systemctl restart php8.1-fpm
```
That's it! Your environment variable should now be set and accessible in your PHP scripts running under PHP 8.1-fpm.
Apache2环境变量如何设置
edu_vlovev_cn :
how to set enviroment in apache2 ?
ChatGPT :
To set the environment in Apache2, follow these steps:
1. Open the Apache2 configuration file located at /etc/apache2/apache2.conf using a text editor.
2. Add the following lines at the bottom of the file:
SetEnv ENVIRONMENT_VARIABLE value
Replace "ENVIRONMENT_VARIABLE" with the name of the environment variable you want to set, and "value" with the value you want to assign to the variable.
3. Save the file and exit the text editor.
4. Restart Apache2 by running the following command in the terminal:
sudo service apache2 restart
5. Verify that the environment variable has been set by writing a simple PHP script and accessing it via a web browser. For example, if you set an environment variable named "DATABASE_URL" to "mysql://user:password@localhost/mydatabase", you can test it with the following PHP code:
<?php
echo getenv('DATABASE_URL');
?>
When you access this script via a web browser, it should display the value of the "DATABASE_URL" environment variable.
问题二[Shell脚本编写]
由于JIRA版本utf8mb4编码的要求（目前公司的Jira版本较高为9.4.1），需要修改相应表的字符集设置，由于jira做了很的配置，jiradb已经有400多个表,需要用shell生成对应的sql脚本。
我正愁没有验证ChatGPT编程能力的场景(>_<)，所以特别试了一下。效果只能用震撼来形容。
JIRA对应版本对数据库字符集的要求
必须使用 utf8mb4 | 可以使用 utf8mb4 | 必须使用 utf8 |
|
|
|
第一次提问结果
ChatGPT :
Hello, I'm ChatGPT
edu_vlovev_cn :
麻烦给用shell读table.txt文件中的每一行文件，
假设table.txt中的内容如下所示：
upgradehistory
upgradetaskhistory
将table.txt中的内容其赋值给一个变量，并利用变量值替换掉下面文本中的"table_name"
SELECT CONCAT('ALTER TABLE `', table_name, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;')
FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C
WHERE C.collation_name = T.table_collation
AND T.table_schema = 'jiradb'
AND
(
C.CHARACTER_SET_NAME != 'utf8mb4'
OR
C.COLLATION_NAME != 'utf8mb4_bin'
);
ChatGPT :
#!/bin/bash
filename="table.txt"
while read -r line
do
query="SELECT CONCAT('ALTER TABLE `', $line, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;')"
result=$(mysql -u <username> -p<password> -D <database_name> -e "$query" -sN)
echo $result
done < "$filename"第一次提问由于SQL格式理解的问题ChatGPT只给出一个还算不错的答案，该有的都有了，甚至还给出了SQL语句-如何在Shell中执行的命令Demo，效果很不错了。第二次我优化了SQL语句格式，把它写成了一行。
第二次提问结果
edu_vlovev_cn :
麻烦给用shell读table.txt文件中的每一行文件，
假设table.txt中的内容如下所示：
upgradehistory
upgradetaskhistory
将table.txt中的内容其赋值给一个变量，并利用变量值替换掉下面文本中的"table_name"
SELECT CONCAT('ALTER TABLE `', table_name, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;')
FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
ChatGPT :
使用以下命令可以实现：
#!/bin/bash
# 读取文件并赋值给变量
while read line
do
table_name=$line
# 替换文本中的 "table_name"
sql="SELECT CONCAT('ALTER TABLE \`', $table_name, '\` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;')
FROM information_schema.TABLES AS T, information_schema.\`COLLATION_CHARACTER_SET_APPLICABILITY\` AS C
WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND
( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');"
echo $sql
done < table.txt
echo "Done."由于我只是想生成400多条SQL语句，并不想让shell脚本自动帮我执行，因为脚本需要调试，测试过才能执行。所以第二次给出的答案更让人惊喜。
调试记录
mjira@edu-vlovev-cn-jira01:~/liumin$ vim table.txt
mjira@edu-vlovev-cn-jira01:~/liumin$
mjira@edu-vlovev-cn-jira01:~/liumin$
mjira@edu-vlovev-cn-jira01:~/liumin$ cat table.txt
AO_0A5972_NOTIFICATION_SETTING
AO_0A5972_PUSH_REGISTRATION
AO_0AC321_RECOMMENDATION_AO
AO_21D670_WHITELIST_RULES
AO_21F425_MESSAGE_AO
AO_21F425_MESSAGE_MAPPING_AO
AO_21F425_USER_PROPERTY_AO
AO_38321B_CUSTOM_CONTENT_LINK
AO_3B1893_LOOP_DETECTION
AO_4789DD_DISABLED_CHECKS
AO_4789DD_HEALTH_CHECK_STATUS
AO_4789DD_HEALTH_CHECK_WATCHER
AO_4789DD_PROPERTIES
AO_4789DD_READ_NOTIFICATIONS
AO_4789DD_SHORTENED_KEY
AO_4789DD_TASK_MONITOR
AO_4AEACD_WEBHOOK_DAO
AO_550953_SHORTCUT
AO_563AEE_ACTIVITY_ENTITY
AO_563AEE_ACTOR_ENTITY
AO_563AEE_MEDIA_LINK_ENTITY
AO_563AEE_OBJECT_ENTITY
AO_563AEE_TARGET_ENTITY
AO_575BF5_DEV_SUMMARY
AO_575BF5_PROCESSED_COMMITS
AO_575BF5_PROVIDER_ISSUE
AO_575BF5_PROVIDER_SEQ_NO
AO_589059_AUDIT_ITEM
AO_589059_AUDIT_ITEM_ASC_ITEM
AO_589059_AUDIT_ITEM_CGE_ITEM
AO_589059_AUDIT_ITEM_COMP_CGE
AO_589059_AUDIT_ITEM_PROJECT
AO_589059_AUTOMATION_QUEUE
AO_589059_COUNTERS
AO_589059_LEGACY_RULE_LINK
AO_589059_RULE_CFG_COMPONENT
AO_589059_RULE_CFG_PROJ_ASSOC
AO_589059_RULE_CONFIG
AO_589059_RULE_LABEL
AO_589059_RULE_SCHEDULE
AO_589059_RULE_STAT
AO_589059_RULE_STATE_LATEST
AO_589059_RULE_STAT_ROLLUP_DAY
AO_589059_RULE_STAT_ROLLUP_HR
AO_589059_RULE_STAT_ROLLUP_MIN
AO_589059_RULE_TAG
AO_589059_RULE_TO_LABEL
AO_60DB71_AUDITENTRY
AO_60DB71_BOARDADMINS
AO_60DB71_CARDCOLOR
AO_60DB71_CARDLAYOUT
AO_60DB71_COLUMN
AO_60DB71_COLUMNSTATUS
AO_60DB71_DETAILVIEWFIELD
AO_60DB71_ESTIMATESTATISTIC
AO_60DB71_ISSUERANKING
AO_60DB71_ISSUERANKINGLOG
AO_60DB71_LEXORANK
AO_60DB71_LEXORANKBALANCER
AO_60DB71_NONWORKINGDAY
AO_60DB71_QUICKFILTER
AO_60DB71_RANKABLEOBJECT
AO_60DB71_RAPIDVIEW
AO_60DB71_SPRINT
AO_60DB71_STATSFIELD
AO_60DB71_SUBQUERY
AO_60DB71_SWIMLANE
AO_60DB71_TRACKINGSTATISTIC
AO_60DB71_VERSION
AO_60DB71_WORKINGDAYS
AO_6FF49D_ACTUAL_MIG_COUNTS
AO_6FF49D_ANALYTICS_EVENT
AO_6FF49D_APP_ASSESSMENT_INFO
AO_6FF49D_CLOUD_SITE
AO_6FF49D_CONFIG_ITEMS
AO_6FF49D_CORRECTED_EMAIL
AO_6FF49D_EXPECTED_MIG_COUNTS
AO_6FF49D_EXPELLED_USER
AO_6FF49D_GBL_EXPORT_CONTEXT
AO_6FF49D_INCORRECT_EMAIL
AO_6FF49D_LINKED_MEDIA
AO_6FF49D_MIGRATED_AVATAR
AO_6FF49D_MIGRATED_FILE
AO_6FF49D_MIGRATION_ENTITY
AO_6FF49D_MIGRATION_INCREMENT
AO_6FF49D_MIGRATION_SCOPE
AO_6FF49D_MIG_REPORT_STATUS
AO_6FF49D_PLAN_ENTITY
AO_6FF49D_TOMBSTONE_ACCOUNT
AO_6FF49D_UNSUPPORTED_ENTITY
AO_6FF49D_USERS_GROUPS_EXTRACT
AO_6FF49D_USER_EMAIL_EVENT_LOG
AO_723324_CLIENT_CONFIG
AO_723324_CLIENT_TOKEN
AO_733371_EVENT
AO_733371_EVENT_PARAMETER
AO_733371_EVENT_RECIPIENT
AO_81F455_PERSONAL_TOKEN
AO_82B313_ABILITY
AO_82B313_ABSENCE
AO_82B313_AVAILABILITY
AO_82B313_INIT
AO_82B313_PERSON
AO_82B313_RESOURCE
AO_82B313_SKILL
AO_82B313_TEAM
AO_8752F1_DATA_PIPELINE_CONFIG
AO_8752F1_DATA_PIPELINE_EOO
AO_8752F1_DATA_PIPELINE_JOB
AO_97EDAB_USERINVITATION
AO_A0B856_WEB_HOOK_LISTENER_AO
AO_A415DF_AOABILITY
AO_A415DF_AOABSENCE
AO_A415DF_AOAVAILABILITY
AO_A415DF_AOCONFIGURATION
AO_A415DF_AOCUSTOM_WORDING
AO_A415DF_AODEPENDENCY
AO_A415DF_AODOOR_STOP
AO_A415DF_AOESTIMATE
AO_A415DF_AOEXTENSION_LINK
AO_A415DF_AONON_WORKING_DAYS
AO_A415DF_AOPERMISSION
AO_A415DF_AOPERSON
AO_A415DF_AOPLAN
AO_A415DF_AOPLAN_CONFIGURATION
AO_A415DF_AOPRESENCE
AO_A415DF_AORELEASE
AO_A415DF_AOREPLANNING
AO_A415DF_AORESOURCE
AO_A415DF_AOSKILL
AO_A415DF_AOSOLUTION_STORE
AO_A415DF_AOSPRINT
AO_A415DF_AOSTAGE
AO_A415DF_AOSTREAM
AO_A415DF_AOSTREAM_TO_TEAM
AO_A415DF_AOTEAM
AO_A415DF_AOTHEME
AO_A415DF_AOWORK_ITEM
AO_A415DF_AOWORK_ITEM_TO_RES
AO_AC3877_RL_USER_COUNTER
AO_AC3877_SETTINGS_VERSION
AO_AC3877_SYSTEM_RL_SETTINGS
AO_AC3877_USER_RL_SETTINGS
AO_B9A0F0_APPLIED_TEMPLATE
AO_C16815_ALERT_AO
AO_C77861_AUDIT_DENY_LISTED
AO_C77861_AUDIT_ENTITY
AO_CFF990_AOTRANSITION_FAILURE
AO_D9132D_ASSIGNMENT
AO_D9132D_ASSIGNMENT_EXT
AO_D9132D_CONFIGURATION
AO_D9132D_DEP_ISSUE_LINK_TYPES
AO_D9132D_DISTRIBUTION
AO_D9132D_EXCLUDED_ISSUE_TYPES
AO_D9132D_EXCLUDED_STATUSCATS
AO_D9132D_EXCLUDED_STATUSES
AO_D9132D_EXCLUDED_VERSIONS
AO_D9132D_GENERICREPORT
AO_D9132D_HIERARCHY_CONFIG
AO_D9132D_INIT
AO_D9132D_ISSUE_SOURCE
AO_D9132D_NONWORKINGDAYS
AO_D9132D_PERMISSIONS
AO_D9132D_PLAN
AO_D9132D_PLANNED_CAPACITY
AO_D9132D_PLANSKILL
AO_D9132D_PLANTEAM
AO_D9132D_PLANTHEME
AO_D9132D_PLANVERSION
AO_D9132D_PLAN_CUSTOM_FIELD
AO_D9132D_PLAN_USER_PROPERTY
AO_D9132D_PLAN_US_PR_MAPPING
AO_D9132D_PROGRAM
AO_D9132D_PROGRAM_CUSTOM_FIELD
AO_D9132D_RANK_ITEM
AO_D9132D_SAVED_VIEW
AO_D9132D_SAVED_VIEW2
AO_D9132D_SCENARIO
AO_D9132D_SCENARIO_ABILITY
AO_D9132D_SCENARIO_AVLBLTY
AO_D9132D_SCENARIO_CHANGES
AO_D9132D_SCENARIO_ISSUES
AO_D9132D_SCENARIO_ISSUE_CMPNT
AO_D9132D_SCENARIO_ISSUE_LABEL
AO_D9132D_SCENARIO_ISSUE_LINKS
AO_D9132D_SCENARIO_ISSUE_RES
AO_D9132D_SCENARIO_PERSON
AO_D9132D_SCENARIO_PLAN_CAP
AO_D9132D_SCENARIO_RESOURCE
AO_D9132D_SCENARIO_SKILL
AO_D9132D_SCENARIO_STAGE
AO_D9132D_SCENARIO_TEAM
AO_D9132D_SCENARIO_THEME
AO_D9132D_SCENARIO_VERSION
AO_D9132D_SCENARIO_XPVERSION
AO_D9132D_SCEN_CSTM_FLD_MVAL
AO_D9132D_SCEN_CUSTOM_FIELD
AO_D9132D_SCEN_TEAM_EX_SPRINT
AO_D9132D_SHARED_REPORT
AO_D9132D_SOLUTION
AO_D9132D_STAGE
AO_D9132D_TEAM_EX_SPRINT
AO_D9132D_THEME
AO_D9132D_VERSION_ENRICHMENT
AO_D9132D_X_PROJECT_VERSION
AO_E8B6CC_BRANCH
AO_E8B6CC_BRANCH_HEAD_MAPPING
AO_E8B6CC_CHANGESET_MAPPING
AO_E8B6CC_COMMIT
AO_E8B6CC_GIT_HUB_EVENT
AO_E8B6CC_ISSUE_MAPPING
AO_E8B6CC_ISSUE_MAPPING_V2
AO_E8B6CC_ISSUE_TO_BRANCH
AO_E8B6CC_ISSUE_TO_CHANGESET
AO_E8B6CC_MESSAGE
AO_E8B6CC_MESSAGE_QUEUE_ITEM
AO_E8B6CC_MESSAGE_TAG
AO_E8B6CC_ORGANIZATION_MAPPING
AO_E8B6CC_ORG_TO_PROJECT
AO_E8B6CC_PROJECT_MAPPING
AO_E8B6CC_PROJECT_MAPPING_V2
AO_E8B6CC_PR_ISSUE_KEY
AO_E8B6CC_PR_PARTICIPANT
AO_E8B6CC_PR_TO_COMMIT
AO_E8B6CC_PULL_REQUEST
AO_E8B6CC_REPOSITORY_MAPPING
AO_E8B6CC_REPO_TO_CHANGESET
AO_E8B6CC_REPO_TO_PROJECT
AO_E8B6CC_SYNC_AUDIT_LOG
AO_E8B6CC_SYNC_EVENT
AO_ED669C_IDP_CONFIG
AO_ED669C_SEEN_ASSERTIONS
AO_FE1BC5_ACCESS_TOKEN
AO_FE1BC5_AUTHORIZATION
AO_FE1BC5_CLIENT
AO_FE1BC5_REDIRECT_URI
AO_FE1BC5_REFRESH_TOKEN
JQUARTZ_BLOB_TRIGGERS
JQUARTZ_CALENDARS
JQUARTZ_CRON_TRIGGERS
JQUARTZ_FIRED_TRIGGERS
JQUARTZ_JOB_DETAILS
JQUARTZ_JOB_LISTENERS
JQUARTZ_LOCKS
JQUARTZ_PAUSED_TRIGGER_GRPS
JQUARTZ_SCHEDULER_STATE
JQUARTZ_SIMPLE_TRIGGERS
JQUARTZ_SIMPROP_TRIGGERS
JQUARTZ_TRIGGERS
JQUARTZ_TRIGGER_LISTENERS
OS_CURRENTSTEP
OS_CURRENTSTEP_PREV
OS_HISTORYSTEP
OS_HISTORYSTEP_PREV
OS_WFENTRY
SEQUENCE_VALUE_ITEM
app_user
audit_changed_value
audit_item
audit_log
avatar
board
boardproject
changegroup
changeitem
clusteredjob
clusterlockstatus
clustermessage
clusternode
clusternodeheartbeat
clusterupgradestate
columnlayout
columnlayoutitem
comment_reaction
comment_version
component
configurationcontext
customfield
customfieldoption
customfieldvalue
cwd_application
cwd_application_address
cwd_directory
cwd_directory_attribute
cwd_directory_operation
cwd_group
cwd_group_attributes
cwd_membership
cwd_synchronisation_status
cwd_synchronisation_token
cwd_user
cwd_user_attributes
deadletter
draftworkflowscheme
draftworkflowschemeentity
entity_property
entity_property_index_document
entity_translation
external_entities
externalgadget
favouriteassociations
feature
fieldconfigscheme
fieldconfigschemeissuetype
fieldconfiguration
fieldlayout
fieldlayoutitem
fieldlayoutscheme
fieldlayoutschemeassociation
fieldlayoutschemeentity
fieldscreen
fieldscreenlayoutitem
fieldscreenscheme
fieldscreenschemeitem
fieldscreentab
fileattachment
filtersubscription
gadgetuserpreference
genericconfiguration
globalpermissionentry
groupbase
issue_field_option
issue_field_option_scope
issue_version
issuelink
issuelinktype
issuesecurityscheme
issuestatus
issuetype
issuetypescreenscheme
issuetypescreenschemeentity
jiraaction
jiradraftworkflows
jiraeventtype
jiraissue
jiraperms
jiraworkflows
jiraworkflowstatuses
label
licenserolesdefault
licenserolesgroup
listenerconfig
mailserver
managedconfigurationitem
membershipbase
moved_issue_key
nodeassociation
nodeindexcounter
nomenclature_entries
notification
notificationinstance
notificationscheme
oauthconsumer
oauthconsumertoken
oauthspconsumer
oauthsptoken
optionconfiguration
permissionscheme
permissionschemeattribute
pluginstate
pluginversion
portalpage
portletconfiguration
priority
productlicense
project
project_key
projectcategory
projectchangedtime
projectrole
projectroleactor
projectversion
propertydata
propertydate
propertydecimal
propertyentry
propertynumber
propertystring
propertytext
qrtz_calendars
qrtz_cron_triggers
qrtz_fired_triggers
qrtz_job_details
qrtz_job_listeners
qrtz_simple_triggers
qrtz_trigger_listeners
qrtz_triggers
reindex_component
reindex_request
remembermetoken
remotelink
replicatedindexoperation
resolution
rundetails
schemeissuesecurities
schemeissuesecuritylevels
schemepermissions
searchrequest
securityproperty
serviceconfig
sharepermissions
tempattachmentsmonitor
trackback_ping
trustedapp
upgradehistory
upgradetaskhistory
upgradetaskhistoryauditlog
upgradeversionhistory
userassociation
userbase
userhistoryitem
userpickerfilter
userpickerfiltergroup
userpickerfilterrole
versioncontrol
votehistory
workflowscheme
workflowschemeentity
worklog
worklog_version
mjira@edu-vlovev-cn-jira01:~/liumin$
mjira@edu-vlovev-cn-jira01:~/liumin$
mjira@edu-vlovev-cn-jira01:~/liumin$ vim sql_gen.sh
mjira@edu-vlovev-cn-jira01:~/liumin$
mjira@edu-vlovev-cn-jira01:~/liumin$ cat sql_gen.sh
#!/bin/bash
# 读取文件并赋值给变量
while read line
do
table_name=$line
# 替换文本中的 "table_name"
sql="SELECT CONCAT('ALTER TABLE \`', $table_name, '\` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.\`COLLATION_CHARACTER_SET_APPLICABILITY\` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');"
echo $sql
done < table.txt
echo "Done."
mjira@edu-vlovev-cn-jira01:~/liumin$ ll
total 28
drwxrwxr-x 2 mjira mjira 4096 Apr 13 09:30 ./
drwxr-x--- 6 mjira mjira 4096 Apr 13 09:30 ../
-rw-rw-r-- 1 mjira mjira 530 Apr 13 09:30 sql_gen.sh
-rw-rw-r-- 1 mjira mjira 13017 Apr 13 09:28 table.txt
mjira@edu-vlovev-cn-jira01:~/liumin$ chmod a+x sql_gen.sh
mjira@edu-vlovev-cn-jira01:~/liumin$ ll
total 28
drwxrwxr-x 2 mjira mjira 4096 Apr 13 09:30 ./
drwxr-x--- 6 mjira mjira 4096 Apr 13 09:30 ../
-rwxrwxr-x 1 mjira mjira 530 Apr 13 09:30 sql_gen.sh*
-rw-rw-r-- 1 mjira mjira 13017 Apr 13 09:28 table.txt
mjira@edu-vlovev-cn-jira01:~/liumin$ sh sql_gen.sh
SELECT CONCAT('ALTER TABLE `', AO_0A5972_NOTIFICATION_SETTING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_0A5972_PUSH_REGISTRATION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_0AC321_RECOMMENDATION_AO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_21D670_WHITELIST_RULES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_21F425_MESSAGE_AO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_21F425_MESSAGE_MAPPING_AO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_21F425_USER_PROPERTY_AO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_38321B_CUSTOM_CONTENT_LINK, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_3B1893_LOOP_DETECTION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4789DD_DISABLED_CHECKS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4789DD_HEALTH_CHECK_STATUS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4789DD_HEALTH_CHECK_WATCHER, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4789DD_PROPERTIES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4789DD_READ_NOTIFICATIONS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4789DD_SHORTENED_KEY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4789DD_TASK_MONITOR, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_4AEACD_WEBHOOK_DAO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_550953_SHORTCUT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_563AEE_ACTIVITY_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_563AEE_ACTOR_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_563AEE_MEDIA_LINK_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_563AEE_OBJECT_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_563AEE_TARGET_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_575BF5_DEV_SUMMARY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_575BF5_PROCESSED_COMMITS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_575BF5_PROVIDER_ISSUE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_575BF5_PROVIDER_SEQ_NO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_AUDIT_ITEM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_AUDIT_ITEM_ASC_ITEM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_AUDIT_ITEM_CGE_ITEM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_AUDIT_ITEM_COMP_CGE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_AUDIT_ITEM_PROJECT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_AUTOMATION_QUEUE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_COUNTERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_LEGACY_RULE_LINK, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_CFG_COMPONENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_CFG_PROJ_ASSOC, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_CONFIG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_LABEL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_SCHEDULE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_STAT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_STATE_LATEST, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_STAT_ROLLUP_DAY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_STAT_ROLLUP_HR, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_STAT_ROLLUP_MIN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_TAG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_589059_RULE_TO_LABEL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_AUDITENTRY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_BOARDADMINS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_CARDCOLOR, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_CARDLAYOUT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_COLUMN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_COLUMNSTATUS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_DETAILVIEWFIELD, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_ESTIMATESTATISTIC, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_ISSUERANKING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_ISSUERANKINGLOG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_LEXORANK, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_LEXORANKBALANCER, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_NONWORKINGDAY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_QUICKFILTER, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_RANKABLEOBJECT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_RAPIDVIEW, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_SPRINT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_STATSFIELD, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_SUBQUERY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_SWIMLANE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_TRACKINGSTATISTIC, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_VERSION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_60DB71_WORKINGDAYS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_ACTUAL_MIG_COUNTS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_ANALYTICS_EVENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_APP_ASSESSMENT_INFO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_CLOUD_SITE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_CONFIG_ITEMS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_CORRECTED_EMAIL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_EXPECTED_MIG_COUNTS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_EXPELLED_USER, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_GBL_EXPORT_CONTEXT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_INCORRECT_EMAIL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_LINKED_MEDIA, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_MIGRATED_AVATAR, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_MIGRATED_FILE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_MIGRATION_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_MIGRATION_INCREMENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_MIGRATION_SCOPE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_MIG_REPORT_STATUS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_PLAN_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_TOMBSTONE_ACCOUNT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_UNSUPPORTED_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_USERS_GROUPS_EXTRACT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_6FF49D_USER_EMAIL_EVENT_LOG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_723324_CLIENT_CONFIG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_723324_CLIENT_TOKEN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_733371_EVENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_733371_EVENT_PARAMETER, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_733371_EVENT_RECIPIENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_81F455_PERSONAL_TOKEN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_ABILITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_ABSENCE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_AVAILABILITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_INIT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_PERSON, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_RESOURCE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_SKILL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_82B313_TEAM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_8752F1_DATA_PIPELINE_CONFIG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_8752F1_DATA_PIPELINE_EOO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_8752F1_DATA_PIPELINE_JOB, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_97EDAB_USERINVITATION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A0B856_WEB_HOOK_LISTENER_AO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOABILITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOABSENCE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOAVAILABILITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOCONFIGURATION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOCUSTOM_WORDING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AODEPENDENCY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AODOOR_STOP, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOESTIMATE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOEXTENSION_LINK, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AONON_WORKING_DAYS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOPERMISSION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOPERSON, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOPLAN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOPLAN_CONFIGURATION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOPRESENCE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AORELEASE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOREPLANNING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AORESOURCE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOSKILL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOSOLUTION_STORE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOSPRINT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOSTAGE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOSTREAM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOSTREAM_TO_TEAM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOTEAM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOTHEME, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOWORK_ITEM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_A415DF_AOWORK_ITEM_TO_RES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_AC3877_RL_USER_COUNTER, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_AC3877_SETTINGS_VERSION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_AC3877_SYSTEM_RL_SETTINGS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_AC3877_USER_RL_SETTINGS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_B9A0F0_APPLIED_TEMPLATE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_C16815_ALERT_AO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_C77861_AUDIT_DENY_LISTED, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_C77861_AUDIT_ENTITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_CFF990_AOTRANSITION_FAILURE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_ASSIGNMENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_ASSIGNMENT_EXT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_CONFIGURATION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_DEP_ISSUE_LINK_TYPES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_DISTRIBUTION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_EXCLUDED_ISSUE_TYPES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_EXCLUDED_STATUSCATS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_EXCLUDED_STATUSES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_EXCLUDED_VERSIONS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_GENERICREPORT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_HIERARCHY_CONFIG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_INIT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_ISSUE_SOURCE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_NONWORKINGDAYS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PERMISSIONS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLAN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLANNED_CAPACITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLANSKILL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLANTEAM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLANTHEME, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLANVERSION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLAN_CUSTOM_FIELD, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLAN_USER_PROPERTY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PLAN_US_PR_MAPPING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PROGRAM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_PROGRAM_CUSTOM_FIELD, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_RANK_ITEM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SAVED_VIEW, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SAVED_VIEW2, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_ABILITY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_AVLBLTY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_CHANGES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_ISSUES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_ISSUE_CMPNT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_ISSUE_LABEL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_ISSUE_LINKS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_ISSUE_RES, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_PERSON, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_PLAN_CAP, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_RESOURCE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_SKILL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_STAGE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_TEAM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_THEME, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_VERSION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCENARIO_XPVERSION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCEN_CSTM_FLD_MVAL, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCEN_CUSTOM_FIELD, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SCEN_TEAM_EX_SPRINT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SHARED_REPORT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_SOLUTION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_STAGE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_TEAM_EX_SPRINT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_THEME, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_VERSION_ENRICHMENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_D9132D_X_PROJECT_VERSION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_BRANCH, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_BRANCH_HEAD_MAPPING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_CHANGESET_MAPPING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_COMMIT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_GIT_HUB_EVENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_ISSUE_MAPPING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_ISSUE_MAPPING_V2, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_ISSUE_TO_BRANCH, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_ISSUE_TO_CHANGESET, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_MESSAGE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_MESSAGE_QUEUE_ITEM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_MESSAGE_TAG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_ORGANIZATION_MAPPING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_ORG_TO_PROJECT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_PROJECT_MAPPING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_PROJECT_MAPPING_V2, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_PR_ISSUE_KEY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_PR_PARTICIPANT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_PR_TO_COMMIT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_PULL_REQUEST, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_REPOSITORY_MAPPING, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_REPO_TO_CHANGESET, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_REPO_TO_PROJECT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_SYNC_AUDIT_LOG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_E8B6CC_SYNC_EVENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_ED669C_IDP_CONFIG, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_ED669C_SEEN_ASSERTIONS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_FE1BC5_ACCESS_TOKEN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_FE1BC5_AUTHORIZATION, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_FE1BC5_CLIENT, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_FE1BC5_REDIRECT_URI, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', AO_FE1BC5_REFRESH_TOKEN, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_BLOB_TRIGGERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_CALENDARS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_CRON_TRIGGERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_FIRED_TRIGGERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_JOB_DETAILS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_JOB_LISTENERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_LOCKS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_PAUSED_TRIGGER_GRPS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_SCHEDULER_STATE, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_SIMPLE_TRIGGERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_SIMPROP_TRIGGERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_TRIGGERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', JQUARTZ_TRIGGER_LISTENERS, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', OS_CURRENTSTEP, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', OS_CURRENTSTEP_PREV, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', OS_HISTORYSTEP, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', OS_HISTORYSTEP_PREV, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', OS_WFENTRY, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', SEQUENCE_VALUE_ITEM, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', app_user, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', audit_changed_value, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', audit_item, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', audit_log, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', avatar, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', board, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', boardproject, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', changegroup, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', changeitem, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', clusteredjob, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', clusterlockstatus, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', clustermessage, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', clusternode, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', clusternodeheartbeat, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', clusterupgradestate, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', columnlayout, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', columnlayoutitem, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', comment_reaction, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', comment_version, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', component, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', configurationcontext, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', customfield, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', customfieldoption, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', customfieldvalue, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_application, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_application_address, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_directory, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_directory_attribute, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_directory_operation, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_group, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_group_attributes, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_membership, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_synchronisation_status, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_synchronisation_token, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_user, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', cwd_user_attributes, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', deadletter, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', draftworkflowscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', draftworkflowschemeentity, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', entity_property, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', entity_property_index_document, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', entity_translation, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', external_entities, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', externalgadget, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', favouriteassociations, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', feature, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldconfigscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldconfigschemeissuetype, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldconfiguration, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldlayout, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldlayoutitem, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldlayoutscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldlayoutschemeassociation, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldlayoutschemeentity, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldscreen, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldscreenlayoutitem, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldscreenscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldscreenschemeitem, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fieldscreentab, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', fileattachment, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', filtersubscription, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', gadgetuserpreference, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', genericconfiguration, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', globalpermissionentry, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', groupbase, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issue_field_option, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issue_field_option_scope, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issue_version, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issuelink, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issuelinktype, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issuesecurityscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issuestatus, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issuetype, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issuetypescreenscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', issuetypescreenschemeentity, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', jiraaction, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', jiradraftworkflows, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', jiraeventtype, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', jiraissue, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', jiraperms, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', jiraworkflows, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', jiraworkflowstatuses, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', label, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', licenserolesdefault, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', licenserolesgroup, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', listenerconfig, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', mailserver, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', managedconfigurationitem, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', membershipbase, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', moved_issue_key, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', nodeassociation, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', nodeindexcounter, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', nomenclature_entries, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', notification, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', notificationinstance, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', notificationscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', oauthconsumer, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', oauthconsumertoken, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', oauthspconsumer, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', oauthsptoken, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', optionconfiguration, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', permissionscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', permissionschemeattribute, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', pluginstate, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', pluginversion, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', portalpage, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', portletconfiguration, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', priority, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', productlicense, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', project, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', project_key, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', projectcategory, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', projectchangedtime, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', projectrole, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', projectroleactor, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', projectversion, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', propertydata, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', propertydate, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', propertydecimal, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', propertyentry, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', propertynumber, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', propertystring, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', propertytext, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_calendars, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_cron_triggers, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_fired_triggers, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_job_details, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_job_listeners, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_simple_triggers, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_trigger_listeners, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', qrtz_triggers, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', reindex_component, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', reindex_request, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', remembermetoken, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', remotelink, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', replicatedindexoperation, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', resolution, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', rundetails, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', schemeissuesecurities, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', schemeissuesecuritylevels, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', schemepermissions, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', searchrequest, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', securityproperty, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', serviceconfig, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', sharepermissions, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', tempattachmentsmonitor, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', trackback_ping, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', trustedapp, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', upgradehistory, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', upgradetaskhistory, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', upgradetaskhistoryauditlog, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', upgradeversionhistory, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', userassociation, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', userbase, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', userhistoryitem, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', userpickerfilter, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', userpickerfiltergroup, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', userpickerfilterrole, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', versioncontrol, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', votehistory, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', workflowscheme, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', workflowschemeentity, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', worklog, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
SELECT CONCAT('ALTER TABLE `', worklog_version, '` CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');
Done.最后的优化
mjira@edu-vlovev-cn-jira01:~/liumin$ cat sql_gen.sh
#!/bin/bash
# 读取文件并赋值给变量
while read line
do
table_name=$line
# 替换文本中的 "table_name"
sql="SELECT CONCAT('ALTER TABLE $table_name CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM information_schema.TABLES AS T, information_schema.\`COLLATION_CHARACTER_SET_APPLICABILITY\` AS C WHERE C.collation_name = T.table_collation AND T.table_schema = 'jiradb' AND ( C.CHARACTER_SET_NAME != 'utf8mb4' OR C.COLLATION_NAME != 'utf8mb4_bin');"
echo $sql
echo "\n\n"
done < table.txt
echo "Done."