character_set_conversion.sql.tmp

PHP 知识管理系统（基于树结构的知识管理系统）, 英文原版的PHP源码。

ALTER TABLE help MODIFY help_info text CHARACTER SET utf8;
ALTER TABLE help_replacement MODIFY name varbinary(255);
ALTER TABLE help_replacement MODIFY name varchar(255) CHARACTER SET utf8;
ALTER TABLE help_replacement MODIFY description blob;
ALTER TABLE help_replacement MODIFY description text CHARACTER SET utf8;
ALTER TABLE help_replacement MODIFY title varbinary(255);
ALTER TABLE help_replacement MODIFY title varchar(255) CHARACTER SET utf8;
ALTER TABLE links MODIFY name varbinary(100);
ALTER TABLE links MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE links MODIFY url varbinary(100);
ALTER TABLE links MODIFY url char(100) CHARACTER SET utf8;
ALTER TABLE metadata_lookup MODIFY name varbinary(255);
ALTER TABLE metadata_lookup MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE metadata_lookup_tree MODIFY name varbinary(255);
ALTER TABLE metadata_lookup_tree MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE mime_types MODIFY filetypes varbinary(100);
ALTER TABLE mime_types MODIFY filetypes char(100) CHARACTER SET utf8;
ALTER TABLE mime_types MODIFY mimetypes varbinary(100);
ALTER TABLE mime_types MODIFY mimetypes char(100) CHARACTER SET utf8;
ALTER TABLE mime_types MODIFY icon_path varbinary(255);
ALTER TABLE mime_types MODIFY icon_path char(255) CHARACTER SET utf8;
ALTER TABLE mime_types MODIFY friendly_name varbinary(255);
ALTER TABLE mime_types MODIFY friendly_name char(255) CHARACTER SET utf8;
ALTER TABLE news MODIFY synopsis varbinary(255);
ALTER TABLE news MODIFY synopsis varchar(255) CHARACTER SET utf8;
ALTER TABLE news MODIFY body blob;
ALTER TABLE news MODIFY body text CHARACTER SET utf8;
ALTER TABLE news MODIFY image blob;
ALTER TABLE news MODIFY image text CHARACTER SET utf8;
ALTER TABLE notifications MODIFY label varbinary(255);
ALTER TABLE notifications MODIFY label varchar(255) CHARACTER SET utf8;
ALTER TABLE notifications MODIFY type varbinary(255);
ALTER TABLE notifications MODIFY type varchar(255) CHARACTER SET utf8;
ALTER TABLE notifications MODIFY data_str_1 varbinary(255);
ALTER TABLE notifications MODIFY data_str_1 varchar(255) CHARACTER SET utf8;
ALTER TABLE notifications MODIFY data_str_2 varbinary(255);
ALTER TABLE notifications MODIFY data_str_2 varchar(255) CHARACTER SET utf8;
ALTER TABLE organisations_lookup MODIFY name varbinary(100);
ALTER TABLE organisations_lookup MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE permission_descriptors MODIFY descriptor varbinary(32);
ALTER TABLE permission_descriptors MODIFY descriptor varchar(32) CHARACTER SET utf8;
ALTER TABLE permission_descriptors MODIFY descriptor_text blob;
ALTER TABLE permission_descriptors MODIFY descriptor_text text CHARACTER SET utf8;
ALTER TABLE permissions MODIFY name varbinary(100);
ALTER TABLE permissions MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE permissions MODIFY human_name varbinary(100);
ALTER TABLE permissions MODIFY human_name char(100) CHARACTER SET utf8;
ALTER TABLE plugins MODIFY namespace varbinary(255);
ALTER TABLE plugins MODIFY namespace varchar(255) CHARACTER SET utf8;
ALTER TABLE plugins MODIFY path varbinary(255);
ALTER TABLE plugins MODIFY path varchar(255) CHARACTER SET utf8;
ALTER TABLE plugins MODIFY data blob;
ALTER TABLE plugins MODIFY data text CHARACTER SET utf8;
ALTER TABLE plugins MODIFY friendly_name varbinary(255);
ALTER TABLE plugins MODIFY friendly_name varchar(255) CHARACTER SET utf8;
ALTER TABLE roles MODIFY name varbinary(255);
ALTER TABLE roles MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE saved_searches MODIFY name varbinary(50);
ALTER TABLE saved_searches MODIFY name varchar(50) CHARACTER SET utf8;
ALTER TABLE saved_searches MODIFY namespace varbinary(250);
ALTER TABLE saved_searches MODIFY namespace varchar(250) CHARACTER SET utf8;
ALTER TABLE saved_searches MODIFY search blob;
ALTER TABLE saved_searches MODIFY search text CHARACTER SET utf8;
ALTER TABLE status_lookup MODIFY name varbinary(255);
ALTER TABLE status_lookup MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE system_settings MODIFY name varbinary(255);
ALTER TABLE system_settings MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE system_settings MODIFY value varbinary(255);
ALTER TABLE system_settings MODIFY value char(255) CHARACTER SET utf8;
ALTER TABLE time_unit_lookup MODIFY name varbinary(100);
ALTER TABLE time_unit_lookup MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE trigger_selection MODIFY event_ns varbinary(255);
ALTER TABLE trigger_selection MODIFY event_ns varchar(255) CHARACTER SET utf8;
ALTER TABLE trigger_selection MODIFY selection_ns varbinary(255);
ALTER TABLE trigger_selection MODIFY selection_ns varchar(255) CHARACTER SET utf8;
ALTER TABLE units_lookup MODIFY name varbinary(100);
ALTER TABLE units_lookup MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE upgrades MODIFY descriptor varbinary(100);
ALTER TABLE upgrades MODIFY descriptor char(100) CHARACTER SET utf8;
ALTER TABLE upgrades MODIFY description varbinary(255);
ALTER TABLE upgrades MODIFY description char(255) CHARACTER SET utf8;
ALTER TABLE upgrades MODIFY parent varbinary(40);
ALTER TABLE upgrades MODIFY parent char(40) CHARACTER SET utf8;
ALTER TABLE user_history MODIFY action_namespace varbinary(255);
ALTER TABLE user_history MODIFY action_namespace varchar(255) CHARACTER SET utf8;
ALTER TABLE user_history MODIFY comments blob;
ALTER TABLE user_history MODIFY comments text CHARACTER SET utf8;
ALTER TABLE users MODIFY username varbinary(255);
ALTER TABLE users MODIFY username varchar(255) CHARACTER SET utf8;
ALTER TABLE users MODIFY name varbinary(255);
ALTER TABLE users MODIFY name varchar(255) CHARACTER SET utf8;
ALTER TABLE users MODIFY password varbinary(255);
ALTER TABLE users MODIFY password varchar(255) CHARACTER SET utf8;
ALTER TABLE users MODIFY email varbinary(255);
ALTER TABLE users MODIFY email varchar(255) CHARACTER SET utf8;
ALTER TABLE users MODIFY mobile varbinary(255);
ALTER TABLE users MODIFY mobile varchar(255) CHARACTER SET utf8;
ALTER TABLE users MODIFY authentication_details_s1 varbinary(255);
ALTER TABLE users MODIFY authentication_details_s1 varchar(255) CHARACTER SET utf8;
ALTER TABLE users MODIFY authentication_details_s2 varbinary(255);
ALTER TABLE users MODIFY authentication_details_s2 varchar(255) CHARACTER SET utf8;
ALTER TABLE workflow_actions MODIFY action_name varbinary(255);
ALTER TABLE workflow_actions MODIFY action_name char(255) CHARACTER SET utf8;
ALTER TABLE workflow_state_actions MODIFY action_name varbinary(255);
ALTER TABLE workflow_state_actions MODIFY action_name char(255) CHARACTER SET utf8;
ALTER TABLE workflow_states MODIFY name varbinary(255);
ALTER TABLE workflow_states MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE workflow_states MODIFY human_name varbinary(100);
ALTER TABLE workflow_states MODIFY human_name char(100) CHARACTER SET utf8;
ALTER TABLE workflow_transitions MODIFY name varbinary(255);
ALTER TABLE workflow_transitions MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE workflow_transitions MODIFY human_name varbinary(100);
ALTER TABLE workflow_transitions MODIFY human_name char(100) CHARACTER SET utf8;
ALTER TABLE workflows MODIFY name varbinary(250);
ALTER TABLE workflows MODIFY name char(250) CHARACTER SET utf8;
ALTER TABLE workflows MODIFY human_name varbinary(100);
ALTER TABLE workflows MODIFY human_name char(100) CHARACTER SET utf8;