OSSEZ

 找回密码
 新用户

QQ登录

只需一步,快速开始

扫一扫,访问微社区

查看: 104|回复: 3

[Confluence] Confluence 提示数据库字符集错误

[复制链接]
 楼主| 发表于 2017-4-8 03:03:25 | 显示全部楼层 |阅读模式
Collation and Character Set of a MySQL Database



请参考 https://confluence.atlassian.com ... base-744326173.html 中的内容。

首先修改数据库的字符集:
  1. ALTER DATABASE yourDB CHARACTER SET utf8 COLLATE utf8_bin
复制代码


修改表的字符集:
  1. SELECT CONCAT('ALTER TABLE ',  table_name, ' CHARACTER SET utf8 COLLATE utf8_bin;')
  2. FROM information_schema.TABLES AS T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` AS C
  3. WHERE C.collation_name = T.table_collation
  4. AND T.table_schema = 'yourDB'
  5. AND
  6. (
  7.     C.CHARACTER_SET_NAME != 'utf8'
  8.     OR
  9.     C.COLLATION_NAME != 'utf8_bin'
  10. );
复制代码


在上面的SQL 执行后,会从数据库中返回需要执行的 SQL,将这个 SQL 拷贝到 SQL 编辑器中直接运行。

修改列字符集:

  1. SELECT CONCAT('ALTER TABLE `', table_name, '` MODIFY `', column_name, '` ', DATA_TYPE, '(', CHARACTER_MAXIMUM_LENGTH, ') CHARACTER SET UTF8 COLLATE utf8_bin', (CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE '' END), ';')
  2. FROM information_schema.COLUMNS
  3. WHERE TABLE_SCHEMA = 'yourDB'
  4. AND DATA_TYPE = 'varchar'
  5. AND
  6. (
  7.     CHARACTER_SET_NAME != 'utf8'
  8.     OR
  9.     COLLATION_NAME != 'utf8_bin'
  10. );
复制代码

  1. SELECT CONCAT('ALTER TABLE `', table_name, '` MODIFY `', column_name, '` ', DATA_TYPE, ' CHARACTER SET UTF8 COLLATE utf8_bin', (CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE '' END), ';')
  2. FROM information_schema.COLUMNS
  3. WHERE TABLE_SCHEMA = 'yourDB'
  4. AND DATA_TYPE != 'varchar'
  5. AND
  6. (
  7.     CHARACTER_SET_NAME != 'utf8'
  8.     OR
  9.     COLLATION_NAME != 'utf8_bin'
  10. );
复制代码


将返回的 SQL 直接再执行就可以了。

在执行的时候可能会有约束错误,

运行下面的 SQL 禁用约束:
  1. SET FOREIGN_KEY_CHECKS=0;
复制代码


重新启用约束:
  1. SET FOREIGN_KEY_CHECKS=1;
复制代码

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?新用户

x
 楼主| 发表于 2017-4-8 03:04:06 | 显示全部楼层
我们数据库执行的几个 SQL:
  1. ALTER TABLE AO_7CB12A_OPTION_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  2. ALTER TABLE AO_7CB12A_POLL_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  3. ALTER TABLE AO_7CB12A_VOTE_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  4. ALTER TABLE AO_9412A1_AOREGISTRATION CHARACTER SET utf8 COLLATE utf8_bin;
  5. ALTER TABLE AO_9412A1_AOUSER CHARACTER SET utf8 COLLATE utf8_bin;
  6. ALTER TABLE AO_950DC3_TC_CUSTOM_EV_TYPES CHARACTER SET utf8 COLLATE utf8_bin;
  7. ALTER TABLE AO_950DC3_TC_REMINDER_SETTINGS CHARACTER SET utf8 COLLATE utf8_bin;
  8. ALTER TABLE AO_950DC3_TC_SUBCALS CHARACTER SET utf8 COLLATE utf8_bin;
  9. ALTER TABLE AO_950DC3_TC_SUBCALS_IN_SPACE CHARACTER SET utf8 COLLATE utf8_bin;
  10. ALTER TABLE BANDANA CHARACTER SET utf8 COLLATE utf8_bin;
  11. ALTER TABLE CONTENT CHARACTER SET utf8 COLLATE utf8_bin;
  12. ALTER TABLE CONTENT_LABEL CHARACTER SET utf8 COLLATE utf8_bin;
  13. ALTER TABLE CONTENT_PERM CHARACTER SET utf8 COLLATE utf8_bin;
  14. ALTER TABLE CONTENT_RELATION CHARACTER SET utf8 COLLATE utf8_bin;
  15. ALTER TABLE EVENTS CHARACTER SET utf8 COLLATE utf8_bin;
  16. ALTER TABLE EXTRNLNKS CHARACTER SET utf8 COLLATE utf8_bin;
  17. ALTER TABLE FOLLOW_CONNECTIONS CHARACTER SET utf8 COLLATE utf8_bin;
  18. ALTER TABLE LABEL CHARACTER SET utf8 COLLATE utf8_bin;
  19. ALTER TABLE LIKES CHARACTER SET utf8 COLLATE utf8_bin;
  20. ALTER TABLE LINKS CHARACTER SET utf8 COLLATE utf8_bin;
  21. ALTER TABLE NOTIFICATIONS CHARACTER SET utf8 COLLATE utf8_bin;
  22. ALTER TABLE OS_PROPERTYENTRY CHARACTER SET utf8 COLLATE utf8_bin;
  23. ALTER TABLE PAGETEMPLATES CHARACTER SET utf8 COLLATE utf8_bin;
  24. ALTER TABLE PLUGINDATA CHARACTER SET utf8 COLLATE utf8_bin;
  25. ALTER TABLE SECRETS CHARACTER SET utf8 COLLATE utf8_bin;
  26. ALTER TABLE SNAPSHOTS CHARACTER SET utf8 COLLATE utf8_bin;
  27. ALTER TABLE SPACEPERMISSIONS CHARACTER SET utf8 COLLATE utf8_bin;
  28. ALTER TABLE SPACES CHARACTER SET utf8 COLLATE utf8_bin;
  29. ALTER TABLE TRACKBACKLINKS CHARACTER SET utf8 COLLATE utf8_bin;
  30. ALTER TABLE TRUSTEDAPP CHARACTER SET utf8 COLLATE utf8_bin;
  31. ALTER TABLE USERCONTENT_RELATION CHARACTER SET utf8 COLLATE utf8_bin;
  32. ALTER TABLE USER_RELATION CHARACTER SET utf8 COLLATE utf8_bin;
  33. ALTER TABLE cwd_application CHARACTER SET utf8 COLLATE utf8_bin;
  34. ALTER TABLE cwd_application_address CHARACTER SET utf8 COLLATE utf8_bin;
  35. ALTER TABLE cwd_application_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  36. ALTER TABLE cwd_directory CHARACTER SET utf8 COLLATE utf8_bin;
  37. ALTER TABLE cwd_directory_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  38. ALTER TABLE cwd_group CHARACTER SET utf8 COLLATE utf8_bin;
  39. ALTER TABLE cwd_group_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  40. ALTER TABLE cwd_user CHARACTER SET utf8 COLLATE utf8_bin;
  41. ALTER TABLE cwd_user_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  42. ALTER TABLE groups CHARACTER SET utf8 COLLATE utf8_bin;
  43. ALTER TABLE logininfo CHARACTER SET utf8 COLLATE utf8_bin;
  44. ALTER TABLE os_group CHARACTER SET utf8 COLLATE utf8_bin;
  45. ALTER TABLE os_user CHARACTER SET utf8 COLLATE utf8_bin;
  46. ALTER TABLE scheduler_clustered_jobs CHARACTER SET utf8 COLLATE utf8_bin;
  47. ALTER TABLE user_mapping CHARACTER SET utf8 COLLATE utf8_bin;
  48. ALTER TABLE users CHARACTER SET utf8 COLLATE utf8_bin;
复制代码
 楼主| 发表于 2017-4-8 03:04:22 | 显示全部楼层
修改列:
  1. CONCAT('ALTER TABLE `', table_name, '` MODIFY `', column_name, '` ', DATA_TYPE, '(', CHARACTER_MAXIMUM_LENGTH, ') CHARACTER SET UTF8 COLLATE utf8_bin', (CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' ELSE '' END), ';')
  2. ALTER TABLE `AO_187CCC_SIDEBAR_LINK` MODIFY `CATEGORY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  3. ALTER TABLE `AO_187CCC_SIDEBAR_LINK` MODIFY `CUSTOM_ICON_CLASS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  4. ALTER TABLE `AO_187CCC_SIDEBAR_LINK` MODIFY `CUSTOM_TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  5. ALTER TABLE `AO_187CCC_SIDEBAR_LINK` MODIFY `HARDCODED_URL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  6. ALTER TABLE `AO_187CCC_SIDEBAR_LINK` MODIFY `SPACE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  7. ALTER TABLE `AO_187CCC_SIDEBAR_LINK` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  8. ALTER TABLE `AO_187CCC_SIDEBAR_LINK` MODIFY `WEB_ITEM_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  9. ALTER TABLE `AO_21D670_WHITELIST_RULES` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  10. ALTER TABLE `AO_26DB7F_ENTITIES_TO_ROOMS` MODIFY `ENTITY_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  11. ALTER TABLE `AO_26DB7F_ENTITIES_TO_ROOMS` MODIFY `MESSAGE_TYPE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  12. ALTER TABLE `AO_26DB7F_ENTITIES_TO_ROOMS` MODIFY `ROOM_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  13. ALTER TABLE `AO_26DB7F_ENTITIES_TO_ROOM_CFG` MODIFY `ENTITY_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  14. ALTER TABLE `AO_26DB7F_ENTITIES_TO_ROOM_CFG` MODIFY `ROOM_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  15. ALTER TABLE `AO_38321B_CUSTOM_CONTENT_LINK` MODIFY `CONTENT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  16. ALTER TABLE `AO_38321B_CUSTOM_CONTENT_LINK` MODIFY `LINK_LABEL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  17. ALTER TABLE `AO_38321B_CUSTOM_CONTENT_LINK` MODIFY `LINK_URL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  18. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `CREATE_RESULT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  19. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `HOW_TO_USE_TEMPLATE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  20. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `INDEX_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  21. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `INDEX_TITLE_I18N_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  22. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  23. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `PLUGIN_MODULE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  24. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `SPACE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  25. ALTER TABLE `AO_54C900_CONTENT_BLUEPRINT_AO` MODIFY `UUID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  26. ALTER TABLE `AO_54C900_C_TEMPLATE_REF` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  27. ALTER TABLE `AO_54C900_C_TEMPLATE_REF` MODIFY `PLUGIN_MODULE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  28. ALTER TABLE `AO_54C900_C_TEMPLATE_REF` MODIFY `UUID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  29. ALTER TABLE `AO_54C900_SPACE_BLUEPRINT_AO` MODIFY `CATEGORY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  30. ALTER TABLE `AO_54C900_SPACE_BLUEPRINT_AO` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  31. ALTER TABLE `AO_54C900_SPACE_BLUEPRINT_AO` MODIFY `PLUGIN_MODULE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  32. ALTER TABLE `AO_54C900_SPACE_BLUEPRINT_AO` MODIFY `UUID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  33. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `GENERATOR_DISPLAY_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  34. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `GENERATOR_ID` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  35. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `ID` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  36. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `ISSUE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  37. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `POSTER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  38. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `PROJECT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  39. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  40. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `URL` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  41. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  42. ALTER TABLE `AO_563AEE_ACTIVITY_ENTITY` MODIFY `VERB` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  43. ALTER TABLE `AO_563AEE_ACTOR_ENTITY` MODIFY `FULL_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  44. ALTER TABLE `AO_563AEE_ACTOR_ENTITY` MODIFY `PROFILE_PAGE_URI` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  45. ALTER TABLE `AO_563AEE_ACTOR_ENTITY` MODIFY `PROFILE_PICTURE_URI` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  46. ALTER TABLE `AO_563AEE_ACTOR_ENTITY` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  47. ALTER TABLE `AO_563AEE_MEDIA_LINK_ENTITY` MODIFY `URL` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  48. ALTER TABLE `AO_563AEE_OBJECT_ENTITY` MODIFY `CONTENT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  49. ALTER TABLE `AO_563AEE_OBJECT_ENTITY` MODIFY `DISPLAY_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  50. ALTER TABLE `AO_563AEE_OBJECT_ENTITY` MODIFY `OBJECT_ID` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  51. ALTER TABLE `AO_563AEE_OBJECT_ENTITY` MODIFY `OBJECT_TYPE` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  52. ALTER TABLE `AO_563AEE_OBJECT_ENTITY` MODIFY `SUMMARY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  53. ALTER TABLE `AO_563AEE_OBJECT_ENTITY` MODIFY `URL` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  54. ALTER TABLE `AO_563AEE_TARGET_ENTITY` MODIFY `CONTENT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  55. ALTER TABLE `AO_563AEE_TARGET_ENTITY` MODIFY `DISPLAY_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  56. ALTER TABLE `AO_563AEE_TARGET_ENTITY` MODIFY `OBJECT_ID` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  57. ALTER TABLE `AO_563AEE_TARGET_ENTITY` MODIFY `OBJECT_TYPE` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  58. ALTER TABLE `AO_563AEE_TARGET_ENTITY` MODIFY `SUMMARY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  59. ALTER TABLE `AO_563AEE_TARGET_ENTITY` MODIFY `URL` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  60. ALTER TABLE `AO_5F3884_FEATURE_DISCOVERY` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  61. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `API_URL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  62. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `GROUP_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  63. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `OAUTH_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  64. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `SECRET_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  65. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `SYSTEM_PASSWORD` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  66. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `SYSTEM_USER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  67. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `SYSTEM_USER_TOKEN` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  68. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_LINK` MODIFY `TOKEN` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  69. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_USER` MODIFY `HIP_CHAT_USER_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  70. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_USER` MODIFY `REFRESH_CODE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  71. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_USER` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  72. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_USER` MODIFY `USER_TOKEN` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  73. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_USER` MODIFY `USER_SCOPES` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  74. ALTER TABLE `AO_5FB9D7_AOHIP_CHAT_USER` MODIFY `HIP_CHAT_USER_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  75. ALTER TABLE `AO_6384AB_DISCOVERED` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  76. ALTER TABLE `AO_6384AB_DISCOVERED` MODIFY `PLUGIN_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  77. ALTER TABLE `AO_6384AB_DISCOVERED` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  78. ALTER TABLE `AO_6384AB_FEATURE_METADATA_AO` MODIFY `CONTEXT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  79. ALTER TABLE `AO_6384AB_FEATURE_METADATA_AO` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  80. ALTER TABLE `AO_6D345F_CUSTOM_LIBRARY` MODIFY `NAME` varchar(127) CHARACTER SET UTF8 COLLATE utf8_bin;
  81. ALTER TABLE `AO_6D345F_CUSTOM_LIBRARY` MODIFY `PERMISSIONS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  82. ALTER TABLE `AO_6D345F_CUSTOM_LIBRARY` MODIFY `UID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  83. ALTER TABLE `AO_6D345F_CUSTOM_SHAPE` MODIFY `HASH` varchar(64) CHARACTER SET UTF8 COLLATE utf8_bin;
  84. ALTER TABLE `AO_6D345F_CUSTOM_SHAPE` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  85. ALTER TABLE `AO_6D345F_CUSTOM_SHAPE` MODIFY `UID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  86. ALTER TABLE `AO_6D345F_USER_ENTITY` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  87. ALTER TABLE `AO_6D345F_USER_ENTITY` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  88. ALTER TABLE `AO_7CB12A_OPTION_ENTITY` MODIFY `CREATED_BY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  89. ALTER TABLE `AO_7CB12A_OPTION_ENTITY` MODIFY `GUID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  90. ALTER TABLE `AO_7CB12A_OPTION_ENTITY` MODIFY `STRING_VALUE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  91. ALTER TABLE `AO_7CB12A_POLL_ENTITY` MODIFY `CREATED_BY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  92. ALTER TABLE `AO_7CB12A_POLL_ENTITY` MODIFY `GUID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  93. ALTER TABLE `AO_7CB12A_POLL_ENTITY` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  94. ALTER TABLE `AO_7CB12A_VOTE_ENTITY` MODIFY `CREATED_BY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  95. ALTER TABLE `AO_7CB12A_VOTE_ENTITY` MODIFY `GUID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  96. ALTER TABLE `AO_7CDE43_EVENT` MODIFY `EVENT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  97. ALTER TABLE `AO_7CDE43_FILTER_PARAM` MODIFY `PARAM_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  98. ALTER TABLE `AO_7CDE43_NOTIFICATION_SCHEME` MODIFY `SCHEME_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  99. ALTER TABLE `AO_7CDE43_RECIPIENT` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  100. ALTER TABLE `AO_7CDE43_SERVER_CONFIG` MODIFY `DEFAULT_USER_ID_TEMPLATE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  101. ALTER TABLE `AO_7CDE43_SERVER_CONFIG` MODIFY `NOTIFICATION_MEDIUM_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  102. ALTER TABLE `AO_7CDE43_SERVER_CONFIG` MODIFY `SERVER_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  103. ALTER TABLE `AO_7CDE43_SERVER_PARAM` MODIFY `PARAM_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  104. ALTER TABLE `AO_88263F_HEALTH_CHECK_STATUS` MODIFY `APPLICATION_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  105. ALTER TABLE `AO_88263F_HEALTH_CHECK_STATUS` MODIFY `COMPLETE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  106. ALTER TABLE `AO_88263F_HEALTH_CHECK_STATUS` MODIFY `DESCRIPTION` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  107. ALTER TABLE `AO_88263F_HEALTH_CHECK_STATUS` MODIFY `FAILURE_REASON` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  108. ALTER TABLE `AO_88263F_HEALTH_CHECK_STATUS` MODIFY `SEVERITY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  109. ALTER TABLE `AO_88263F_HEALTH_CHECK_STATUS` MODIFY `STATUS_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  110. ALTER TABLE `AO_88263F_PROPERTIES` MODIFY `PROPERTY_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  111. ALTER TABLE `AO_88263F_PROPERTIES` MODIFY `PROPERTY_VALUE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  112. ALTER TABLE `AO_88263F_READ_NOTIFICATIONS` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  113. ALTER TABLE `AO_88BB94_BATCH_NOTIFICATION` MODIFY `BATCHING_COLUMN` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  114. ALTER TABLE `AO_88BB94_BATCH_NOTIFICATION` MODIFY `CONTENT_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  115. ALTER TABLE `AO_88BB94_BATCH_NOTIFICATION` MODIFY `NOTIFICATION_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  116. ALTER TABLE `AO_92296B_AORECENTLY_VIEWED` MODIFY `SPACE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  117. ALTER TABLE `AO_92296B_AORECENTLY_VIEWED` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  118. ALTER TABLE `AO_92296B_AORECENTLY_VIEWED` MODIFY `CONTENT_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  119. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `ACTION` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  120. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `APPLICATION` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  121. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `APPLICATION_LINK_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  122. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `ENTITY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  123. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `GLOBAL_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  124. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `GROUPING_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  125. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `STATUS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  126. ALTER TABLE `AO_9412A1_AONOTIFICATION` MODIFY `USER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  127. ALTER TABLE `AO_9412A1_AOREGISTRATION` MODIFY `ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  128. ALTER TABLE `AO_9412A1_AOTASK` MODIFY `APPLICATION` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  129. ALTER TABLE `AO_9412A1_AOTASK` MODIFY `APPLICATION_LINK_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  130. ALTER TABLE `AO_9412A1_AOTASK` MODIFY `ENTITY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  131. ALTER TABLE `AO_9412A1_AOTASK` MODIFY `GLOBAL_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  132. ALTER TABLE `AO_9412A1_AOTASK` MODIFY `STATUS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  133. ALTER TABLE `AO_9412A1_AOTASK` MODIFY `USER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  134. ALTER TABLE `AO_9412A1_AOUSER` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  135. ALTER TABLE `AO_9412A1_USER_APP_LINK` MODIFY `APPLICATION_LINK_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  136. ALTER TABLE `AO_950DC3_TC_CUSTOM_EV_TYPES` MODIFY `BELONG_SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  137. ALTER TABLE `AO_950DC3_TC_CUSTOM_EV_TYPES` MODIFY `CREATED` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  138. ALTER TABLE `AO_950DC3_TC_CUSTOM_EV_TYPES` MODIFY `ICON` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  139. ALTER TABLE `AO_950DC3_TC_CUSTOM_EV_TYPES` MODIFY `ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  140. ALTER TABLE `AO_950DC3_TC_CUSTOM_EV_TYPES` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  141. ALTER TABLE `AO_950DC3_TC_DISABLE_EV_TYPES` MODIFY `EVENT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  142. ALTER TABLE `AO_950DC3_TC_DISABLE_EV_TYPES` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  143. ALTER TABLE `AO_950DC3_TC_EVENTS` MODIFY `ORGANISER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  144. ALTER TABLE `AO_950DC3_TC_EVENTS` MODIFY `RECURRENCE_RULE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  145. ALTER TABLE `AO_950DC3_TC_EVENTS` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  146. ALTER TABLE `AO_950DC3_TC_EVENTS` MODIFY `VEVENT_UID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  147. ALTER TABLE `AO_950DC3_TC_EVENTS` MODIFY `REMINDER_SETTING_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  148. ALTER TABLE `AO_950DC3_TC_EVENTS_INVITEES` MODIFY `INVITEE_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  149. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `ASSIGNEE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  150. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `EVENT_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  151. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `ISSUE_ICON_URL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  152. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `ISSUE_LINK` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  153. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `JQL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  154. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `KEY_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  155. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `STATUS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  156. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  157. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `TICKET_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  158. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  159. ALTER TABLE `AO_950DC3_TC_JIRA_REMI_EVENTS` MODIFY `USER_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  160. ALTER TABLE `AO_950DC3_TC_REMINDER_SETTINGS` MODIFY `CUSTOM_EVENT_TYPE_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  161. ALTER TABLE `AO_950DC3_TC_REMINDER_SETTINGS` MODIFY `ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  162. ALTER TABLE `AO_950DC3_TC_REMINDER_SETTINGS` MODIFY `LAST_MODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  163. ALTER TABLE `AO_950DC3_TC_REMINDER_SETTINGS` MODIFY `STORE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  164. ALTER TABLE `AO_950DC3_TC_REMINDER_SETTINGS` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  165. ALTER TABLE `AO_950DC3_TC_REMINDER_USERS` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  166. ALTER TABLE `AO_950DC3_TC_REMINDER_USERS` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  167. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `COLOUR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  168. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  169. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  170. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `PARENT_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  171. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `SPACE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  172. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `STORE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  173. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `SUBSCRIPTION_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  174. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `TIME_ZONE_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  175. ALTER TABLE `AO_950DC3_TC_SUBCALS` MODIFY `USING_CUSTOM_EVENT_TYPE_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  176. ALTER TABLE `AO_950DC3_TC_SUBCALS_IN_SPACE` MODIFY `SPACE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  177. ALTER TABLE `AO_950DC3_TC_SUBCALS_IN_SPACE` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  178. ALTER TABLE `AO_950DC3_TC_SUBCALS_PRIV_GRP` MODIFY `GROUP_NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  179. ALTER TABLE `AO_950DC3_TC_SUBCALS_PRIV_GRP` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  180. ALTER TABLE `AO_950DC3_TC_SUBCALS_PRIV_GRP` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  181. ALTER TABLE `AO_950DC3_TC_SUBCALS_PRIV_USR` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  182. ALTER TABLE `AO_950DC3_TC_SUBCALS_PRIV_USR` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  183. ALTER TABLE `AO_950DC3_TC_SUBCALS_PRIV_USR` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  184. ALTER TABLE `AO_950DC3_TC_SUBCALS_PROPS` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  185. ALTER TABLE `AO_950DC3_TC_SUBCALS_PROPS` MODIFY `SUB_CALENDAR_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  186. ALTER TABLE `AO_A0B856_WEB_HOOK_LISTENER_AO` MODIFY `LAST_UPDATED_USER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  187. ALTER TABLE `AO_A0B856_WEB_HOOK_LISTENER_AO` MODIFY `REGISTRATION_METHOD` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  188. ALTER TABLE `AO_A3F2EF_ADMIN_MESSAGES` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  189. ALTER TABLE `AO_A3F2EF_ADMIN_MESSAGES` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  190. ALTER TABLE `AO_A3F2EF_BLOGS` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  191. ALTER TABLE `AO_A3F2EF_BLOG_COLUMNS` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  192. ALTER TABLE `AO_A3F2EF_BLOG_COLUMNS` MODIFY `SELECTED_MODE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  193. ALTER TABLE `AO_A3F2EF_BLOG_COLUMNS` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  194. ALTER TABLE `AO_A3F2EF_BLOG_COLUMNS` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  195. ALTER TABLE `AO_A3F2EF_CACHE_SETTINGS` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  196. ALTER TABLE `AO_A3F2EF_CATEGORIES` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  197. ALTER TABLE `AO_A3F2EF_CATEGORIES` MODIFY `PARENT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  198. ALTER TABLE `AO_A3F2EF_CATEGORIES` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  199. ALTER TABLE `AO_A3F2EF_CATEGORYCACHE` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  200. ALTER TABLE `AO_A3F2EF_CATEGORY_CHILDREN` MODIFY `CATEGORY_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  201. ALTER TABLE `AO_A3F2EF_CATEGORY_CHILDREN` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  202. ALTER TABLE `AO_A3F2EF_CATEGORY_CHILDREN` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  203. ALTER TABLE `AO_A3F2EF_CUSTOM_COLUMNS` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  204. ALTER TABLE `AO_A3F2EF_CUSTOM_COLUMNS` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  205. ALTER TABLE `AO_A3F2EF_CUSTOM_COLUMNS` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  206. ALTER TABLE `AO_A3F2EF_FOOTER` MODIFY `THEME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  207. ALTER TABLE `AO_A3F2EF_LAYOUT_BOARD` MODIFY `CONTENT_KEY` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  208. ALTER TABLE `AO_A3F2EF_LAYOUT_BOARD` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  209. ALTER TABLE `AO_A3F2EF_LAYOUT_BOARD` MODIFY `NAME` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  210. ALTER TABLE `AO_A3F2EF_LAYOUT_ITEM` MODIFY `ITEM_ID` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  211. ALTER TABLE `AO_A3F2EF_LAYOUT_KEY` MODIFY `SPACE_KEY` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  212. ALTER TABLE `AO_A3F2EF_LAYOUT_SECTION` MODIFY `SECTION_ID` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  213. ALTER TABLE `AO_A3F2EF_LAYOUT_VERSION` MODIFY `CONTENT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  214. ALTER TABLE `AO_A3F2EF_LAYOUT_VERSION` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  215. ALTER TABLE `AO_A3F2EF_LINKS` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  216. ALTER TABLE `AO_A3F2EF_LINKS` MODIFY `OBJECT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  217. ALTER TABLE `AO_A3F2EF_LINKS` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  218. ALTER TABLE `AO_A3F2EF_LINK_COLUMNS` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  219. ALTER TABLE `AO_A3F2EF_LINK_COLUMNS` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  220. ALTER TABLE `AO_A3F2EF_LOGO_COLUMNS` MODIFY `LOGO` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  221. ALTER TABLE `AO_A3F2EF_LOGO_COLUMNS` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  222. ALTER TABLE `AO_A3F2EF_LOGO_COLUMNS` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  223. ALTER TABLE `AO_A3F2EF_LOGO_COLUMNS` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  224. ALTER TABLE `AO_A3F2EF_PERMISSION` MODIFY `OBJECT_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  225. ALTER TABLE `AO_A3F2EF_PERMISSION` MODIFY `OBJECT_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  226. ALTER TABLE `AO_A3F2EF_PERMISSION` MODIFY `PERMISSION_LEVEL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  227. ALTER TABLE `AO_A3F2EF_PERMISSION` MODIFY `PERMISSION_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  228. ALTER TABLE `AO_A3F2EF_QUESTIONS_COLUMNS` MODIFY `FILTER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  229. ALTER TABLE `AO_A3F2EF_QUESTIONS_COLUMNS` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  230. ALTER TABLE `AO_A3F2EF_QUESTIONS_COLUMNS` MODIFY `TOPIC` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  231. ALTER TABLE `AO_A3F2EF_QUESTIONS_COLUMNS` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  232. ALTER TABLE `AO_A3F2EF_SPACE_SETTINGS` MODIFY `MENU_LAYOUT_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  233. ALTER TABLE `AO_A3F2EF_SPACE_SETTINGS` MODIFY `SPACE_KEY` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  234. ALTER TABLE `AO_A3F2EF_SPACE_SETTINGS` MODIFY `TYPE` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  235. ALTER TABLE `AO_A3F2EF_SPACE_TYPES` MODIFY `SPACE_KEY` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  236. ALTER TABLE `AO_A3F2EF_SPACE_TYPES` MODIFY `SPACE_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  237. ALTER TABLE `AO_A3F2EF_SPACE_TYPES` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  238. ALTER TABLE `AO_A3F2EF_THEME` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  239. ALTER TABLE `AO_A3F2EF_THEME` MODIFY `SYSTEM_TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  240. ALTER TABLE `AO_A3F2EF_THEME` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  241. ALTER TABLE `AO_A3F2EF_THEME_VERSION` MODIFY `AUTHOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  242. ALTER TABLE `AO_A3F2EF_UNMIGRATED_BLOGS` MODIFY `NAME_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  243. ALTER TABLE `AO_A3F2EF_USER_CATEGORIES` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  244. ALTER TABLE `AO_A3F2EF_USER_CATEGORIES` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  245. ALTER TABLE `AO_A3F2EF_USER_CATEGORIES` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  246. ALTER TABLE `AO_A3F2EF_USER_ROLES` MODIFY `KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  247. ALTER TABLE `AO_A3F2EF_USER_ROLES` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  248. ALTER TABLE `AO_A3F2EF_USER_ROLES` MODIFY `ROLE_ID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  249. ALTER TABLE `AO_A3F2EF_USER_ROLES` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  250. ALTER TABLE `AO_A3F2EF_USER_ROLES` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  251. ALTER TABLE `AO_A3F2EF_VIEWDESIGNS` MODIFY `CATEGORY_KEY` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  252. ALTER TABLE `AO_A3F2EF_VIEWDESIGNS` MODIFY `DESIGN_KEY` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  253. ALTER TABLE `AO_A3F2EF_VIEWDESIGNS` MODIFY `TYPE` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  254. ALTER TABLE `AO_A3F2EF_VIEWDESIGNS` MODIFY `VARIATION_NAME_KEY` varchar(450) CHARACTER SET UTF8 COLLATE utf8_bin;
  255. ALTER TABLE `AO_B1DBB9_ACCEPTANCE` MODIFY `ACCEPTOR_USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  256. ALTER TABLE `AO_B1DBB9_ACCEPTANCE` MODIFY `ANSWER_USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  257. ALTER TABLE `AO_B1DBB9_BOUNTY` MODIFY `AWARDEE_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  258. ALTER TABLE `AO_B1DBB9_BOUNTY` MODIFY `AWARDER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  259. ALTER TABLE `AO_B1DBB9_BOUNTY` MODIFY `CREATOR_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  260. ALTER TABLE `AO_B1DBB9_BOUNTY` MODIFY `CREATOR_KEY_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  261. ALTER TABLE `AO_B1DBB9_VOTE` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  262. ALTER TABLE `AO_BAF3AA_AOINLINE_TASK` MODIFY `ASSIGNEE_USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  263. ALTER TABLE `AO_BAF3AA_AOINLINE_TASK` MODIFY `COMPLETE_USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  264. ALTER TABLE `AO_BAF3AA_AOINLINE_TASK` MODIFY `CREATOR_USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  265. ALTER TABLE `AO_BAF3AA_AOINLINE_TASK` MODIFY `TASK_STATUS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  266. ALTER TABLE `AO_DC98AE_AOHELP_TIP` MODIFY `DISMISSED_HELP_TIP` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  267. ALTER TABLE `AO_DC98AE_AOHELP_TIP` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  268. ALTER TABLE `AO_EF9604_FEATURE_DISCOVERY` MODIFY `USER_KEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  269. ALTER TABLE `ATTACHMENTS_BACKUP` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  270. ALTER TABLE `ATTACHMENTS_BACKUP` MODIFY `CONTENTTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  271. ALTER TABLE `ATTACHMENTS_BACKUP` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  272. ALTER TABLE `ATTACHMENTS_BACKUP` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  273. ALTER TABLE `ATTACHMENTS_BACKUP` MODIFY `ATTACHMENT_COMMENT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  274. ALTER TABLE `AUDITRECORD` MODIFY `SUMMARY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  275. ALTER TABLE `AUDITRECORD` MODIFY `DESCRIPTION` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  276. ALTER TABLE `AUDITRECORD` MODIFY `CATEGORY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  277. ALTER TABLE `AUDITRECORD` MODIFY `ADDRESS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  278. ALTER TABLE `AUDITRECORD` MODIFY `AUTHORNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  279. ALTER TABLE `AUDITRECORD` MODIFY `AUTHORFULLNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  280. ALTER TABLE `AUDITRECORD` MODIFY `AUTHORKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  281. ALTER TABLE `AUDITRECORD` MODIFY `OBJECTNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  282. ALTER TABLE `AUDITRECORD` MODIFY `OBJECTTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  283. ALTER TABLE `AUDIT_AFFECTED_OBJECT` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  284. ALTER TABLE `AUDIT_AFFECTED_OBJECT` MODIFY `TYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  285. ALTER TABLE `AUDIT_CHANGED_VALUE` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  286. ALTER TABLE `AUDIT_CHANGED_VALUE` MODIFY `OLDVALUE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  287. ALTER TABLE `AUDIT_CHANGED_VALUE` MODIFY `NEWVALUE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  288. ALTER TABLE `BANDANA` MODIFY `BANDANACONTEXT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  289. ALTER TABLE `BANDANA` MODIFY `BANDANAKEY` varchar(100) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  290. ALTER TABLE `CONFVERSION` MODIFY `VERSIONTAG` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  291. ALTER TABLE `CONTENT` MODIFY `CONTENTTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  292. ALTER TABLE `CONTENT` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  293. ALTER TABLE `CONTENT` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  294. ALTER TABLE `CONTENT` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  295. ALTER TABLE `CONTENT` MODIFY `CONTENT_STATUS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  296. ALTER TABLE `CONTENT` MODIFY `MESSAGEID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  297. ALTER TABLE `CONTENT` MODIFY `PLUGINKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  298. ALTER TABLE `CONTENT` MODIFY `PLUGINVER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  299. ALTER TABLE `CONTENT` MODIFY `DRAFTPAGEID` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  300. ALTER TABLE `CONTENT` MODIFY `DRAFTSPACEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  301. ALTER TABLE `CONTENT` MODIFY `DRAFTTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  302. ALTER TABLE `CONTENT` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  303. ALTER TABLE `CONTENT` MODIFY `LOWERTITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  304. ALTER TABLE `CONTENTPROPERTIES` MODIFY `PROPERTYNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  305. ALTER TABLE `CONTENTPROPERTIES` MODIFY `STRINGVAL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  306. ALTER TABLE `CONTENT_LABEL` MODIFY `OWNER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  307. ALTER TABLE `CONTENT_LABEL` MODIFY `LABELABLETYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  308. ALTER TABLE `CONTENT_PERM` MODIFY `CP_TYPE` varchar(10) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  309. ALTER TABLE `CONTENT_PERM` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  310. ALTER TABLE `CONTENT_PERM` MODIFY `GROUPNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  311. ALTER TABLE `CONTENT_PERM` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  312. ALTER TABLE `CONTENT_PERM` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  313. ALTER TABLE `CONTENT_PERM_SET` MODIFY `CONT_PERM_TYPE` varchar(10) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  314. ALTER TABLE `CONTENT_RELATION` MODIFY `TARGETTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  315. ALTER TABLE `CONTENT_RELATION` MODIFY `SOURCETYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  316. ALTER TABLE `CONTENT_RELATION` MODIFY `RELATIONNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  317. ALTER TABLE `CONTENT_RELATION` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  318. ALTER TABLE `CONTENT_RELATION` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  319. ALTER TABLE `DECORATOR` MODIFY `SPACEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  320. ALTER TABLE `DECORATOR` MODIFY `DECORATORNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  321. ALTER TABLE `EVENTS` MODIFY `rev` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  322. ALTER TABLE `EVENTS` MODIFY `history` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  323. ALTER TABLE `EXTRNLNKS` MODIFY `CONTENTTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  324. ALTER TABLE `EXTRNLNKS` MODIFY `URL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  325. ALTER TABLE `EXTRNLNKS` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  326. ALTER TABLE `EXTRNLNKS` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  327. ALTER TABLE `EXTRNLNKS` MODIFY `LOWERURL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  328. ALTER TABLE `FOLLOW_CONNECTIONS` MODIFY `FOLLOWER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  329. ALTER TABLE `FOLLOW_CONNECTIONS` MODIFY `FOLLOWEE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  330. ALTER TABLE `IMAGEDETAILS` MODIFY `MIMETYPE` varchar(30) CHARACTER SET UTF8 COLLATE utf8_bin;
  331. ALTER TABLE `INDEXQUEUEENTRIES` MODIFY `HANDLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  332. ALTER TABLE `KEYSTORE` MODIFY `ALIAS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  333. ALTER TABLE `KEYSTORE` MODIFY `TYPE` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  334. ALTER TABLE `KEYSTORE` MODIFY `ALGORITHM` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  335. ALTER TABLE `LABEL` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  336. ALTER TABLE `LABEL` MODIFY `OWNER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  337. ALTER TABLE `LABEL` MODIFY `NAMESPACE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  338. ALTER TABLE `LIKES` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  339. ALTER TABLE `LINKS` MODIFY `DESTPAGETITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  340. ALTER TABLE `LINKS` MODIFY `DESTSPACEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  341. ALTER TABLE `LINKS` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  342. ALTER TABLE `LINKS` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  343. ALTER TABLE `LINKS` MODIFY `LOWERDESTPAGETITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  344. ALTER TABLE `LINKS` MODIFY `LOWERDESTSPACEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  345. ALTER TABLE `NOTIFICATIONS` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  346. ALTER TABLE `NOTIFICATIONS` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  347. ALTER TABLE `NOTIFICATIONS` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  348. ALTER TABLE `NOTIFICATIONS` MODIFY `CONTENTTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  349. ALTER TABLE `OS_PROPERTYENTRY` MODIFY `entity_name` varchar(125) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  350. ALTER TABLE `OS_PROPERTYENTRY` MODIFY `entity_key` varchar(200) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  351. ALTER TABLE `OS_PROPERTYENTRY` MODIFY `string_val` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  352. ALTER TABLE `PAGETEMPLATES` MODIFY `TEMPLATENAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  353. ALTER TABLE `PAGETEMPLATES` MODIFY `TEMPLATEDESC` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  354. ALTER TABLE `PAGETEMPLATES` MODIFY `PLUGINKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  355. ALTER TABLE `PAGETEMPLATES` MODIFY `MODULEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  356. ALTER TABLE `PAGETEMPLATES` MODIFY `REFPLUGINKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  357. ALTER TABLE `PAGETEMPLATES` MODIFY `REFMODULEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  358. ALTER TABLE `PAGETEMPLATES` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  359. ALTER TABLE `PAGETEMPLATES` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  360. ALTER TABLE `PLUGINDATA` MODIFY `PLUGINKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  361. ALTER TABLE `PLUGINDATA` MODIFY `FILENAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  362. ALTER TABLE `SECRETS` MODIFY `key` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  363. ALTER TABLE `SNAPSHOTS` MODIFY `key` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  364. ALTER TABLE `SPACEPERMISSIONS` MODIFY `PERMTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  365. ALTER TABLE `SPACEPERMISSIONS` MODIFY `PERMGROUPNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  366. ALTER TABLE `SPACEPERMISSIONS` MODIFY `PERMUSERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  367. ALTER TABLE `SPACEPERMISSIONS` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  368. ALTER TABLE `SPACEPERMISSIONS` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  369. ALTER TABLE `SPACEPERMISSIONS` MODIFY `PERMALLUSERSSUBJECT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  370. ALTER TABLE `SPACES` MODIFY `SPACENAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  371. ALTER TABLE `SPACES` MODIFY `SPACEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  372. ALTER TABLE `SPACES` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  373. ALTER TABLE `SPACES` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  374. ALTER TABLE `SPACES` MODIFY `SPACETYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  375. ALTER TABLE `SPACES` MODIFY `SPACESTATUS` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  376. ALTER TABLE `SPACES` MODIFY `LOWERSPACEKEY` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  377. ALTER TABLE `TRACKBACKLINKS` MODIFY `CONTENTTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  378. ALTER TABLE `TRACKBACKLINKS` MODIFY `URL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  379. ALTER TABLE `TRACKBACKLINKS` MODIFY `TITLE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  380. ALTER TABLE `TRACKBACKLINKS` MODIFY `BLOGNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  381. ALTER TABLE `TRACKBACKLINKS` MODIFY `EXCERPT` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  382. ALTER TABLE `TRACKBACKLINKS` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  383. ALTER TABLE `TRACKBACKLINKS` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  384. ALTER TABLE `TRACKBACKLINKS` MODIFY `LOWERURL` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  385. ALTER TABLE `TRUSTEDAPP` MODIFY `NAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  386. ALTER TABLE `TRUSTEDAPPRESTRICTION` MODIFY `TYPE` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  387. ALTER TABLE `TRUSTEDAPPRESTRICTION` MODIFY `restriction` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  388. ALTER TABLE `USERCONTENT_RELATION` MODIFY `SOURCEUSER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  389. ALTER TABLE `USERCONTENT_RELATION` MODIFY `TARGETTYPE` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  390. ALTER TABLE `USERCONTENT_RELATION` MODIFY `RELATIONNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  391. ALTER TABLE `USERCONTENT_RELATION` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  392. ALTER TABLE `USERCONTENT_RELATION` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  393. ALTER TABLE `USER_RELATION` MODIFY `SOURCEUSER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  394. ALTER TABLE `USER_RELATION` MODIFY `TARGETUSER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  395. ALTER TABLE `USER_RELATION` MODIFY `RELATIONNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  396. ALTER TABLE `USER_RELATION` MODIFY `CREATOR` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  397. ALTER TABLE `USER_RELATION` MODIFY `LASTMODIFIER` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  398. ALTER TABLE `cwd_app_dir_group_mapping` MODIFY `group_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  399. ALTER TABLE `cwd_app_dir_operation` MODIFY `operation_type` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  400. ALTER TABLE `cwd_application` MODIFY `application_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  401. ALTER TABLE `cwd_application` MODIFY `lower_application_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  402. ALTER TABLE `cwd_application` MODIFY `description` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  403. ALTER TABLE `cwd_application` MODIFY `application_type` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  404. ALTER TABLE `cwd_application` MODIFY `credential` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  405. ALTER TABLE `cwd_application_address` MODIFY `remote_address` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  406. ALTER TABLE `cwd_application_attribute` MODIFY `attribute_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  407. ALTER TABLE `cwd_directory` MODIFY `directory_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  408. ALTER TABLE `cwd_directory` MODIFY `lower_directory_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  409. ALTER TABLE `cwd_directory` MODIFY `description` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  410. ALTER TABLE `cwd_directory` MODIFY `impl_class` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  411. ALTER TABLE `cwd_directory` MODIFY `lower_impl_class` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  412. ALTER TABLE `cwd_directory` MODIFY `directory_type` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  413. ALTER TABLE `cwd_directory_attribute` MODIFY `attribute_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  414. ALTER TABLE `cwd_directory_operation` MODIFY `operation_type` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  415. ALTER TABLE `cwd_group` MODIFY `group_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  416. ALTER TABLE `cwd_group` MODIFY `lower_group_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  417. ALTER TABLE `cwd_group` MODIFY `description` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  418. ALTER TABLE `cwd_group` MODIFY `group_type` varchar(32) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  419. ALTER TABLE `cwd_group_attribute` MODIFY `attribute_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  420. ALTER TABLE `cwd_group_attribute` MODIFY `attribute_value` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  421. ALTER TABLE `cwd_group_attribute` MODIFY `attribute_lower_value` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  422. ALTER TABLE `cwd_user` MODIFY `user_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  423. ALTER TABLE `cwd_user` MODIFY `lower_user_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  424. ALTER TABLE `cwd_user` MODIFY `first_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  425. ALTER TABLE `cwd_user` MODIFY `lower_first_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  426. ALTER TABLE `cwd_user` MODIFY `last_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  427. ALTER TABLE `cwd_user` MODIFY `lower_last_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  428. ALTER TABLE `cwd_user` MODIFY `display_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  429. ALTER TABLE `cwd_user` MODIFY `lower_display_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  430. ALTER TABLE `cwd_user` MODIFY `email_address` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  431. ALTER TABLE `cwd_user` MODIFY `lower_email_address` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  432. ALTER TABLE `cwd_user` MODIFY `external_id` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  433. ALTER TABLE `cwd_user` MODIFY `credential` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  434. ALTER TABLE `cwd_user_attribute` MODIFY `attribute_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  435. ALTER TABLE `cwd_user_attribute` MODIFY `attribute_value` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  436. ALTER TABLE `cwd_user_attribute` MODIFY `attribute_lower_value` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  437. ALTER TABLE `cwd_user_credential_record` MODIFY `password_hash` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  438. ALTER TABLE `external_entities` MODIFY `name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  439. ALTER TABLE `external_entities` MODIFY `type` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  440. ALTER TABLE `groups` MODIFY `groupname` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  441. ALTER TABLE `journalentry` MODIFY `journal_name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  442. ALTER TABLE `journalentry` MODIFY `type` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  443. ALTER TABLE `logininfo` MODIFY `USERNAME` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  444. ALTER TABLE `os_group` MODIFY `groupname` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  445. ALTER TABLE `os_user` MODIFY `username` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  446. ALTER TABLE `os_user` MODIFY `passwd` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  447. ALTER TABLE `remembermetoken` MODIFY `username` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  448. ALTER TABLE `remembermetoken` MODIFY `token` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  449. ALTER TABLE `scheduler_clustered_jobs` MODIFY `job_id` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  450. ALTER TABLE `scheduler_clustered_jobs` MODIFY `job_runner_key` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  451. ALTER TABLE `scheduler_clustered_jobs` MODIFY `cron_expression` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  452. ALTER TABLE `scheduler_clustered_jobs` MODIFY `cron_time_zone` varchar(60) CHARACTER SET UTF8 COLLATE utf8_bin;
  453. ALTER TABLE `scheduler_run_details` MODIFY `job_id` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  454. ALTER TABLE `scheduler_run_details` MODIFY `message` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  455. ALTER TABLE `storageenginetest` MODIFY `id` varchar(45) CHARACTER SET UTF8 COLLATE utf8_bin;
  456. ALTER TABLE `user_mapping` MODIFY `user_key` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  457. ALTER TABLE `user_mapping` MODIFY `username` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  458. ALTER TABLE `user_mapping` MODIFY `lower_username` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  459. ALTER TABLE `users` MODIFY `name` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin NOT NULL;
  460. ALTER TABLE `users` MODIFY `password` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  461. ALTER TABLE `users` MODIFY `email` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
  462. ALTER TABLE `users` MODIFY `fullname` varchar(255) CHARACTER SET UTF8 COLLATE utf8_bin;
复制代码
 楼主| 发表于 2017-4-8 03:04:43 | 显示全部楼层
修改列:
  1. ALTER TABLE AO_187CCC_SIDEBAR_LINK CHARACTER SET utf8 COLLATE utf8_bin;
  2. ALTER TABLE AO_21D670_WHITELIST_RULES CHARACTER SET utf8 COLLATE utf8_bin;
  3. ALTER TABLE AO_26DB7F_ENTITIES_TO_ROOMS CHARACTER SET utf8 COLLATE utf8_bin;
  4. ALTER TABLE AO_26DB7F_ENTITIES_TO_ROOM_CFG CHARACTER SET utf8 COLLATE utf8_bin;
  5. ALTER TABLE AO_38321B_CUSTOM_CONTENT_LINK CHARACTER SET utf8 COLLATE utf8_bin;
  6. ALTER TABLE AO_42E351_HEALTH_CHECK_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  7. ALTER TABLE AO_54C900_CONTENT_BLUEPRINT_AO CHARACTER SET utf8 COLLATE utf8_bin;
  8. ALTER TABLE AO_54C900_C_TEMPLATE_REF CHARACTER SET utf8 COLLATE utf8_bin;
  9. ALTER TABLE AO_54C900_SPACE_BLUEPRINT_AO CHARACTER SET utf8 COLLATE utf8_bin;
  10. ALTER TABLE AO_563AEE_ACTIVITY_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  11. ALTER TABLE AO_563AEE_ACTOR_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  12. ALTER TABLE AO_563AEE_MEDIA_LINK_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  13. ALTER TABLE AO_563AEE_OBJECT_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  14. ALTER TABLE AO_563AEE_TARGET_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  15. ALTER TABLE AO_5F3884_FEATURE_DISCOVERY CHARACTER SET utf8 COLLATE utf8_bin;
  16. ALTER TABLE AO_5FB9D7_AOHIP_CHAT_LINK CHARACTER SET utf8 COLLATE utf8_bin;
  17. ALTER TABLE AO_5FB9D7_AOHIP_CHAT_USER CHARACTER SET utf8 COLLATE utf8_bin;
  18. ALTER TABLE AO_6384AB_DISCOVERED CHARACTER SET utf8 COLLATE utf8_bin;
  19. ALTER TABLE AO_6384AB_FEATURE_METADATA_AO CHARACTER SET utf8 COLLATE utf8_bin;
  20. ALTER TABLE AO_6D345F_CUSTOM_LIBRARY CHARACTER SET utf8 COLLATE utf8_bin;
  21. ALTER TABLE AO_6D345F_CUSTOM_SHAPE CHARACTER SET utf8 COLLATE utf8_bin;
  22. ALTER TABLE AO_6D345F_USER_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  23. ALTER TABLE AO_6D345F_USER_TO_LIBRARY CHARACTER SET utf8 COLLATE utf8_bin;
  24. ALTER TABLE AO_7CB12A_OPTION_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  25. ALTER TABLE AO_7CB12A_POLL_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  26. ALTER TABLE AO_7CB12A_VOTE_ENTITY CHARACTER SET utf8 COLLATE utf8_bin;
  27. ALTER TABLE AO_7CDE43_EVENT CHARACTER SET utf8 COLLATE utf8_bin;
  28. ALTER TABLE AO_7CDE43_FILTER_PARAM CHARACTER SET utf8 COLLATE utf8_bin;
  29. ALTER TABLE AO_7CDE43_NOTIFICATION CHARACTER SET utf8 COLLATE utf8_bin;
  30. ALTER TABLE AO_7CDE43_NOTIFICATION_SCHEME CHARACTER SET utf8 COLLATE utf8_bin;
  31. ALTER TABLE AO_7CDE43_RECIPIENT CHARACTER SET utf8 COLLATE utf8_bin;
  32. ALTER TABLE AO_7CDE43_SERVER_CONFIG CHARACTER SET utf8 COLLATE utf8_bin;
  33. ALTER TABLE AO_7CDE43_SERVER_PARAM CHARACTER SET utf8 COLLATE utf8_bin;
  34. ALTER TABLE AO_88263F_HEALTH_CHECK_STATUS CHARACTER SET utf8 COLLATE utf8_bin;
  35. ALTER TABLE AO_88263F_PROPERTIES CHARACTER SET utf8 COLLATE utf8_bin;
  36. ALTER TABLE AO_88263F_READ_NOTIFICATIONS CHARACTER SET utf8 COLLATE utf8_bin;
  37. ALTER TABLE AO_88BB94_BATCH_NOTIFICATION CHARACTER SET utf8 COLLATE utf8_bin;
  38. ALTER TABLE AO_92296B_AORECENTLY_VIEWED CHARACTER SET utf8 COLLATE utf8_bin;
  39. ALTER TABLE AO_9412A1_AONOTIFICATION CHARACTER SET utf8 COLLATE utf8_bin;
  40. ALTER TABLE AO_9412A1_AOREGISTRATION CHARACTER SET utf8 COLLATE utf8_bin;
  41. ALTER TABLE AO_9412A1_AOTASK CHARACTER SET utf8 COLLATE utf8_bin;
  42. ALTER TABLE AO_9412A1_AOUSER CHARACTER SET utf8 COLLATE utf8_bin;
  43. ALTER TABLE AO_9412A1_USER_APP_LINK CHARACTER SET utf8 COLLATE utf8_bin;
  44. ALTER TABLE AO_950DC3_TC_CUSTOM_EV_TYPES CHARACTER SET utf8 COLLATE utf8_bin;
  45. ALTER TABLE AO_950DC3_TC_DISABLE_EV_TYPES CHARACTER SET utf8 COLLATE utf8_bin;
  46. ALTER TABLE AO_950DC3_TC_EVENTS CHARACTER SET utf8 COLLATE utf8_bin;
  47. ALTER TABLE AO_950DC3_TC_EVENTS_EXCL CHARACTER SET utf8 COLLATE utf8_bin;
  48. ALTER TABLE AO_950DC3_TC_EVENTS_INVITEES CHARACTER SET utf8 COLLATE utf8_bin;
  49. ALTER TABLE AO_950DC3_TC_JIRA_REMI_EVENTS CHARACTER SET utf8 COLLATE utf8_bin;
  50. ALTER TABLE AO_950DC3_TC_REMINDER_SETTINGS CHARACTER SET utf8 COLLATE utf8_bin;
  51. ALTER TABLE AO_950DC3_TC_REMINDER_USERS CHARACTER SET utf8 COLLATE utf8_bin;
  52. ALTER TABLE AO_950DC3_TC_SUBCALS CHARACTER SET utf8 COLLATE utf8_bin;
  53. ALTER TABLE AO_950DC3_TC_SUBCALS_IN_SPACE CHARACTER SET utf8 COLLATE utf8_bin;
  54. ALTER TABLE AO_950DC3_TC_SUBCALS_PRIV_GRP CHARACTER SET utf8 COLLATE utf8_bin;
  55. ALTER TABLE AO_950DC3_TC_SUBCALS_PRIV_USR CHARACTER SET utf8 COLLATE utf8_bin;
  56. ALTER TABLE AO_950DC3_TC_SUBCALS_PROPS CHARACTER SET utf8 COLLATE utf8_bin;
  57. ALTER TABLE AO_A0B856_WEB_HOOK_LISTENER_AO CHARACTER SET utf8 COLLATE utf8_bin;
  58. ALTER TABLE AO_A3F2EF_ADMIN_MESSAGES CHARACTER SET utf8 COLLATE utf8_bin;
  59. ALTER TABLE AO_A3F2EF_BLOGS CHARACTER SET utf8 COLLATE utf8_bin;
  60. ALTER TABLE AO_A3F2EF_BLOG_COLUMNS CHARACTER SET utf8 COLLATE utf8_bin;
  61. ALTER TABLE AO_A3F2EF_BLOG_THEME CHARACTER SET utf8 COLLATE utf8_bin;
  62. ALTER TABLE AO_A3F2EF_CACHE_SETTINGS CHARACTER SET utf8 COLLATE utf8_bin;
  63. ALTER TABLE AO_A3F2EF_CATEGORIES CHARACTER SET utf8 COLLATE utf8_bin;
  64. ALTER TABLE AO_A3F2EF_CATEGORYCACHE CHARACTER SET utf8 COLLATE utf8_bin;
  65. ALTER TABLE AO_A3F2EF_CATEGORY_CHILDREN CHARACTER SET utf8 COLLATE utf8_bin;
  66. ALTER TABLE AO_A3F2EF_CONTENT_THEME CHARACTER SET utf8 COLLATE utf8_bin;
  67. ALTER TABLE AO_A3F2EF_CUSTOM_COLUMNS CHARACTER SET utf8 COLLATE utf8_bin;
  68. ALTER TABLE AO_A3F2EF_FOOTER CHARACTER SET utf8 COLLATE utf8_bin;
  69. ALTER TABLE AO_A3F2EF_LAYOUT_BOARD CHARACTER SET utf8 COLLATE utf8_bin;
  70. ALTER TABLE AO_A3F2EF_LAYOUT_ITEM CHARACTER SET utf8 COLLATE utf8_bin;
  71. ALTER TABLE AO_A3F2EF_LAYOUT_KEY CHARACTER SET utf8 COLLATE utf8_bin;
  72. ALTER TABLE AO_A3F2EF_LAYOUT_SECTION CHARACTER SET utf8 COLLATE utf8_bin;
  73. ALTER TABLE AO_A3F2EF_LAYOUT_VERSION CHARACTER SET utf8 COLLATE utf8_bin;
  74. ALTER TABLE AO_A3F2EF_LINKS CHARACTER SET utf8 COLLATE utf8_bin;
  75. ALTER TABLE AO_A3F2EF_LINK_COLUMNS CHARACTER SET utf8 COLLATE utf8_bin;
  76. ALTER TABLE AO_A3F2EF_LOGO_COLUMNS CHARACTER SET utf8 COLLATE utf8_bin;
  77. ALTER TABLE AO_A3F2EF_PERMISSION CHARACTER SET utf8 COLLATE utf8_bin;
  78. ALTER TABLE AO_A3F2EF_QUESTIONS_COLUMNS CHARACTER SET utf8 COLLATE utf8_bin;
  79. ALTER TABLE AO_A3F2EF_SPACE_SETTINGS CHARACTER SET utf8 COLLATE utf8_bin;
  80. ALTER TABLE AO_A3F2EF_SPACE_TYPES CHARACTER SET utf8 COLLATE utf8_bin;
  81. ALTER TABLE AO_A3F2EF_THEME CHARACTER SET utf8 COLLATE utf8_bin;
  82. ALTER TABLE AO_A3F2EF_THEME_VERSION CHARACTER SET utf8 COLLATE utf8_bin;
  83. ALTER TABLE AO_A3F2EF_UNMIGRATED_BLOGS CHARACTER SET utf8 COLLATE utf8_bin;
  84. ALTER TABLE AO_A3F2EF_USER_CATEGORIES CHARACTER SET utf8 COLLATE utf8_bin;
  85. ALTER TABLE AO_A3F2EF_USER_ROLES CHARACTER SET utf8 COLLATE utf8_bin;
  86. ALTER TABLE AO_A3F2EF_VIEWDESIGNS CHARACTER SET utf8 COLLATE utf8_bin;
  87. ALTER TABLE AO_B1DBB9_ACCEPTANCE CHARACTER SET utf8 COLLATE utf8_bin;
  88. ALTER TABLE AO_B1DBB9_BOUNTY CHARACTER SET utf8 COLLATE utf8_bin;
  89. ALTER TABLE AO_B1DBB9_VOTE CHARACTER SET utf8 COLLATE utf8_bin;
  90. ALTER TABLE AO_BAF3AA_AOINLINE_TASK CHARACTER SET utf8 COLLATE utf8_bin;
  91. ALTER TABLE AO_DC98AE_AOHELP_TIP CHARACTER SET utf8 COLLATE utf8_bin;
  92. ALTER TABLE AO_EF9604_FEATURE_DISCOVERY CHARACTER SET utf8 COLLATE utf8_bin;
  93. ALTER TABLE ATTACHMENTDATA CHARACTER SET utf8 COLLATE utf8_bin;
  94. ALTER TABLE ATTACHMENTS_BACKUP CHARACTER SET utf8 COLLATE utf8_bin;
  95. ALTER TABLE AUDITRECORD CHARACTER SET utf8 COLLATE utf8_bin;
  96. ALTER TABLE AUDIT_AFFECTED_OBJECT CHARACTER SET utf8 COLLATE utf8_bin;
  97. ALTER TABLE AUDIT_CHANGED_VALUE CHARACTER SET utf8 COLLATE utf8_bin;
  98. ALTER TABLE BANDANA CHARACTER SET utf8 COLLATE utf8_bin;
  99. ALTER TABLE BODYCONTENT CHARACTER SET utf8 COLLATE utf8_bin;
  100. ALTER TABLE CLUSTERSAFETY CHARACTER SET utf8 COLLATE utf8_bin;
  101. ALTER TABLE CONFANCESTORS CHARACTER SET utf8 COLLATE utf8_bin;
  102. ALTER TABLE CONFVERSION CHARACTER SET utf8 COLLATE utf8_bin;
  103. ALTER TABLE CONTENT CHARACTER SET utf8 COLLATE utf8_bin;
  104. ALTER TABLE CONTENTPROPERTIES CHARACTER SET utf8 COLLATE utf8_bin;
  105. ALTER TABLE CONTENT_LABEL CHARACTER SET utf8 COLLATE utf8_bin;
  106. ALTER TABLE CONTENT_PERM CHARACTER SET utf8 COLLATE utf8_bin;
  107. ALTER TABLE CONTENT_PERM_SET CHARACTER SET utf8 COLLATE utf8_bin;
  108. ALTER TABLE CONTENT_RELATION CHARACTER SET utf8 COLLATE utf8_bin;
  109. ALTER TABLE DECORATOR CHARACTER SET utf8 COLLATE utf8_bin;
  110. ALTER TABLE EVENTS CHARACTER SET utf8 COLLATE utf8_bin;
  111. ALTER TABLE EXTRNLNKS CHARACTER SET utf8 COLLATE utf8_bin;
  112. ALTER TABLE FOLLOW_CONNECTIONS CHARACTER SET utf8 COLLATE utf8_bin;
  113. ALTER TABLE IMAGEDETAILS CHARACTER SET utf8 COLLATE utf8_bin;
  114. ALTER TABLE INDEXQUEUEENTRIES CHARACTER SET utf8 COLLATE utf8_bin;
  115. ALTER TABLE KEYSTORE CHARACTER SET utf8 COLLATE utf8_bin;
  116. ALTER TABLE LABEL CHARACTER SET utf8 COLLATE utf8_bin;
  117. ALTER TABLE LIKES CHARACTER SET utf8 COLLATE utf8_bin;
  118. ALTER TABLE LINKS CHARACTER SET utf8 COLLATE utf8_bin;
  119. ALTER TABLE NOTIFICATIONS CHARACTER SET utf8 COLLATE utf8_bin;
  120. ALTER TABLE OS_PROPERTYENTRY CHARACTER SET utf8 COLLATE utf8_bin;
  121. ALTER TABLE PAGETEMPLATES CHARACTER SET utf8 COLLATE utf8_bin;
  122. ALTER TABLE PLUGINDATA CHARACTER SET utf8 COLLATE utf8_bin;
  123. ALTER TABLE SECRETS CHARACTER SET utf8 COLLATE utf8_bin;
  124. ALTER TABLE SNAPSHOTS CHARACTER SET utf8 COLLATE utf8_bin;
  125. ALTER TABLE SPACEPERMISSIONS CHARACTER SET utf8 COLLATE utf8_bin;
  126. ALTER TABLE SPACES CHARACTER SET utf8 COLLATE utf8_bin;
  127. ALTER TABLE TRACKBACKLINKS CHARACTER SET utf8 COLLATE utf8_bin;
  128. ALTER TABLE TRUSTEDAPP CHARACTER SET utf8 COLLATE utf8_bin;
  129. ALTER TABLE TRUSTEDAPPRESTRICTION CHARACTER SET utf8 COLLATE utf8_bin;
  130. ALTER TABLE USERCONTENT_RELATION CHARACTER SET utf8 COLLATE utf8_bin;
  131. ALTER TABLE USER_RELATION CHARACTER SET utf8 COLLATE utf8_bin;
  132. ALTER TABLE cwd_app_dir_group_mapping CHARACTER SET utf8 COLLATE utf8_bin;
  133. ALTER TABLE cwd_app_dir_mapping CHARACTER SET utf8 COLLATE utf8_bin;
  134. ALTER TABLE cwd_app_dir_operation CHARACTER SET utf8 COLLATE utf8_bin;
  135. ALTER TABLE cwd_application CHARACTER SET utf8 COLLATE utf8_bin;
  136. ALTER TABLE cwd_application_address CHARACTER SET utf8 COLLATE utf8_bin;
  137. ALTER TABLE cwd_application_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  138. ALTER TABLE cwd_directory CHARACTER SET utf8 COLLATE utf8_bin;
  139. ALTER TABLE cwd_directory_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  140. ALTER TABLE cwd_directory_operation CHARACTER SET utf8 COLLATE utf8_bin;
  141. ALTER TABLE cwd_group CHARACTER SET utf8 COLLATE utf8_bin;
  142. ALTER TABLE cwd_group_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  143. ALTER TABLE cwd_membership CHARACTER SET utf8 COLLATE utf8_bin;
  144. ALTER TABLE cwd_user CHARACTER SET utf8 COLLATE utf8_bin;
  145. ALTER TABLE cwd_user_attribute CHARACTER SET utf8 COLLATE utf8_bin;
  146. ALTER TABLE cwd_user_credential_record CHARACTER SET utf8 COLLATE utf8_bin;
  147. ALTER TABLE external_entities CHARACTER SET utf8 COLLATE utf8_bin;
  148. ALTER TABLE external_members CHARACTER SET utf8 COLLATE utf8_bin;
  149. ALTER TABLE groups CHARACTER SET utf8 COLLATE utf8_bin;
  150. ALTER TABLE hibernate_unique_key CHARACTER SET utf8 COLLATE utf8_bin;
  151. ALTER TABLE journalentry CHARACTER SET utf8 COLLATE utf8_bin;
  152. ALTER TABLE local_members CHARACTER SET utf8 COLLATE utf8_bin;
  153. ALTER TABLE logininfo CHARACTER SET utf8 COLLATE utf8_bin;
  154. ALTER TABLE os_group CHARACTER SET utf8 COLLATE utf8_bin;
  155. ALTER TABLE os_user CHARACTER SET utf8 COLLATE utf8_bin;
  156. ALTER TABLE os_user_group CHARACTER SET utf8 COLLATE utf8_bin;
  157. ALTER TABLE remembermetoken CHARACTER SET utf8 COLLATE utf8_bin;
  158. ALTER TABLE scheduler_clustered_jobs CHARACTER SET utf8 COLLATE utf8_bin;
  159. ALTER TABLE scheduler_run_details CHARACTER SET utf8 COLLATE utf8_bin;
  160. ALTER TABLE storageenginetest CHARACTER SET utf8 COLLATE utf8_bin;
  161. ALTER TABLE user_mapping CHARACTER SET utf8 COLLATE utf8_bin;
  162. ALTER TABLE users CHARACTER SET utf8 COLLATE utf8_bin;
复制代码
您需要登录后才可以回帖 登录 | 新用户

本版积分规则

关闭

站长推荐上一条 /1 下一条

QQ|手机版|小黑屋|Archiver|帮助|OSSEZ (North Tecom)  

GMT+8, 2017-5-27 23:39

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表