character_set_conversion.sql.2.tmp

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

ALTER TABLE active_sessions MODIFY session_id varbinary(255);
ALTER TABLE active_sessions MODIFY session_id char(255) CHARACTER SET utf8;
ALTER TABLE active_sessions MODIFY ip varbinary(30);
ALTER TABLE active_sessions MODIFY ip char(30) CHARACTER SET utf8;
ALTER TABLE archiving_type_lookup MODIFY name varbinary(100);
ALTER TABLE archiving_type_lookup MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE authentication_sources MODIFY name varbinary(50);
ALTER TABLE authentication_sources MODIFY name varchar(50) CHARACTER SET utf8;
ALTER TABLE authentication_sources MODIFY namespace varbinary(255);
ALTER TABLE authentication_sources MODIFY namespace varchar(255) CHARACTER SET utf8;
ALTER TABLE authentication_sources MODIFY authentication_provider varbinary(255);
ALTER TABLE authentication_sources MODIFY authentication_provider varchar(255) CHARACTER SET utf8;
ALTER TABLE authentication_sources MODIFY config blob;
ALTER TABLE authentication_sources MODIFY config text CHARACTER SET utf8;
ALTER TABLE `comment_searchable_text` DROP INDEX `comment_search_text`;
ALTER TABLE comment_searchable_text MODIFY body blob;
ALTER TABLE comment_searchable_text MODIFY body text CHARACTER SET utf8;
ALTER TABLE `comment_searchable_text` ADD FULLTEXT `comment_search_text` (`body`);
ALTER TABLE dashlet_disables MODIFY dashlet_namespace varbinary(255);
ALTER TABLE dashlet_disables MODIFY dashlet_namespace varchar(255) CHARACTER SET utf8;
ALTER TABLE data_types MODIFY name varbinary(255);
ALTER TABLE data_types MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE discussion_comments MODIFY subject blob;
ALTER TABLE discussion_comments MODIFY subject text CHARACTER SET utf8;
ALTER TABLE discussion_comments MODIFY body blob;
ALTER TABLE discussion_comments MODIFY body text CHARACTER SET utf8;
ALTER TABLE discussion_threads MODIFY close_reason blob;
ALTER TABLE discussion_threads MODIFY close_reason text CHARACTER SET utf8;
ALTER TABLE document_content_version MODIFY filename blob;
ALTER TABLE document_content_version MODIFY filename text CHARACTER SET utf8;
ALTER TABLE document_content_version MODIFY storage_path varbinary(250);
ALTER TABLE document_content_version MODIFY storage_path varchar(250) CHARACTER SET utf8;
ALTER TABLE document_fields MODIFY name varbinary(255);
ALTER TABLE document_fields MODIFY name varchar(255) CHARACTER SET utf8;
ALTER TABLE document_fields MODIFY data_type varbinary(100);
ALTER TABLE document_fields MODIFY data_type varchar(100) CHARACTER SET utf8;
ALTER TABLE document_fields MODIFY description blob;
ALTER TABLE document_fields MODIFY description text CHARACTER SET utf8;
ALTER TABLE document_fields_link MODIFY value varbinary(255);
ALTER TABLE document_fields_link MODIFY value char(255) CHARACTER SET utf8;
ALTER TABLE document_link_types MODIFY name varbinary(100);
ALTER TABLE document_link_types MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE document_link_types MODIFY reverse_name varbinary(100);
ALTER TABLE document_link_types MODIFY reverse_name char(100) CHARACTER SET utf8;
ALTER TABLE document_link_types MODIFY description varbinary(255);
ALTER TABLE document_link_types MODIFY description char(255) CHARACTER SET utf8;
ALTER TABLE document_metadata_version MODIFY name blob;
ALTER TABLE document_metadata_version MODIFY name text CHARACTER SET utf8;
ALTER TABLE document_metadata_version MODIFY description varbinary(200);
ALTER TABLE document_metadata_version MODIFY description varchar(200) CHARACTER SET utf8;
ALTER TABLE document_searchable_text DROP INDEX document_text;
ALTER TABLE document_searchable_text MODIFY document_text blob;
ALTER TABLE document_searchable_text MODIFY document_text text CHARACTER SET utf8;
ALTER TABLE document_searchable_text ADD FULLTEXT document_text (document_text);
ALTER TABLE document_text DROP INDEX document_text;
ALTER TABLE document_text MODIFY document_text blob;
ALTER TABLE document_text MODIFY document_text text CHARACTER SET utf8;
ALTER TABLE document_text ADD FULLTEXT document_text (document_text);
ALTER TABLE document_transaction_text DROP INDEX document_text;
ALTER TABLE document_transaction_text MODIFY document_text blob;
ALTER TABLE document_transaction_text MODIFY document_text text CHARACTER SET utf8;
ALTER TABLE document_transaction_text ADD FULLTEXT document_text (document_text);
ALTER TABLE document_transaction_types_lookup MODIFY name varbinary(100);
ALTER TABLE document_transaction_types_lookup MODIFY name varchar(100) CHARACTER SET utf8;
ALTER TABLE document_transaction_types_lookup MODIFY namespace varbinary(250);
ALTER TABLE document_transaction_types_lookup MODIFY namespace varchar(250) CHARACTER SET utf8;
ALTER TABLE document_transactions MODIFY version varbinary(50);
ALTER TABLE document_transactions MODIFY version char(50) CHARACTER SET utf8;
ALTER TABLE document_transactions MODIFY ip varbinary(30);
ALTER TABLE document_transactions MODIFY ip char(30) CHARACTER SET utf8;
ALTER TABLE document_transactions MODIFY filename varbinary(255);
ALTER TABLE document_transactions MODIFY filename char(255) CHARACTER SET utf8;
ALTER TABLE document_transactions MODIFY comment varbinary(255);
ALTER TABLE document_transactions MODIFY comment char(255) CHARACTER SET utf8;
ALTER TABLE document_transactions MODIFY transaction_namespace varbinary(255);
ALTER TABLE document_transactions MODIFY transaction_namespace char(255) CHARACTER SET utf8;
ALTER TABLE document_types_lookup MODIFY name varbinary(100);
ALTER TABLE document_types_lookup MODIFY name char(100) CHARACTER SET utf8;
ALTER TABLE documents MODIFY parent_folder_ids blob;
ALTER TABLE documents MODIFY parent_folder_ids text CHARACTER SET utf8;
ALTER TABLE documents MODIFY full_path blob;
ALTER TABLE documents MODIFY full_path text CHARACTER SET utf8;
ALTER TABLE field_behaviours MODIFY name varbinary(255);
ALTER TABLE field_behaviours MODIFY name char(255) CHARACTER SET utf8;
ALTER TABLE field_behaviours MODIFY human_name varbinary(100);
ALTER TABLE field_behaviours MODIFY human_name char(100) CHARACTER SET utf8;
ALTER TABLE fieldsets MODIFY name varbinary(255);
ALTER TABLE fieldsets MODIFY name varchar(255) CHARACTER SET utf8;
ALTER TABLE fieldsets MODIFY namespace varbinary(255);
ALTER TABLE fieldsets MODIFY namespace varchar(255) CHARACTER SET utf8;
ALTER TABLE fieldsets MODIFY description blob;
ALTER TABLE fieldsets MODIFY description text CHARACTER SET utf8;
ALTER TABLE folder_searchable_text DROP INDEX folder_text;
ALTER TABLE folder_searchable_text MODIFY folder_text blob;
ALTER TABLE folder_searchable_text MODIFY folder_text text CHARACTER SET utf8;
ALTER TABLE folder_searchable_text ADD FULLTEXT folder_text (folder_text);
ALTER TABLE folder_transactions MODIFY ip varbinary(30);
ALTER TABLE folder_transactions MODIFY ip char(30) CHARACTER SET utf8;
ALTER TABLE folder_transactions MODIFY comment varbinary(255);
ALTER TABLE folder_transactions MODIFY comment char(255) CHARACTER SET utf8;
ALTER TABLE folder_transactions MODIFY transaction_namespace varbinary(255);
ALTER TABLE folder_transactions MODIFY transaction_namespace char(255) CHARACTER SET utf8;
ALTER TABLE folders MODIFY name varbinary(255);
ALTER TABLE folders MODIFY name varchar(255) CHARACTER SET utf8;
ALTER TABLE folders MODIFY description varbinary(255);
ALTER TABLE folders MODIFY description varchar(255) CHARACTER SET utf8;
ALTER TABLE folders MODIFY parent_folder_ids blob;
ALTER TABLE folders MODIFY parent_folder_ids text CHARACTER SET utf8;
ALTER TABLE folders MODIFY full_path blob;
ALTER TABLE folders MODIFY full_path text CHARACTER SET utf8;
ALTER TABLE groups_lookup MODIFY name varbinary(100);
ALTER TABLE groups_lookup MODIFY name varchar(100) CHARACTER SET utf8;
ALTER TABLE groups_lookup MODIFY authentication_details_s2 varbinary(255);
ALTER TABLE groups_lookup MODIFY authentication_details_s2 varchar(255) CHARACTER SET utf8;
ALTER TABLE groups_lookup MODIFY authentication_details_s1 varbinary(255);
ALTER TABLE groups_lookup MODIFY authentication_details_s1 varchar(255) CHARACTER SET utf8;
ALTER TABLE help MODIFY fSection varbinary(100);
ALTER TABLE help MODIFY fSection varchar(100) CHARACTER SET utf8;
ALTER TABLE help MODIFY help_info blob;