Encoding fix

 alter table `pages` drop key `name_title`;
alter table `pages` drop key `page_title`;
alter table `pages` drop key `name_title_timestamp`;
alter table `pages` change `page_title` `page_title` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci ;
alter table `pages` change `page_title` `page_title` blob   NOT NULL ;
alter table `pages` change `page_title` `page_title` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci ;
alter table `pages` add unique `name_title` (`page_namespace`, `page_title`);
alter table `pages` add index `page_title` (`page_title`);
alter table `pages` add index `name_title_timestamp` (`page_namespace`,`page_title`,`page_inverse_timestamp`);

alter table `old` drop key `name_title_timestamp`;
alter table `old` change `old_title` `old_title` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `old` change `old_title` `old_title` blob   NOT NULL ;
alter table `old` change `old_title` `old_title` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `old` add index `name_title_timestamp` (`old_namespace`,`old_title`,`inverse_timestamp`);

alter table `archive` drop key `name_title_timestamp`;
alter table `archive` change `ar_title` `ar_title` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `archive` change `ar_title` `ar_title` blob   NOT NULL ;
alter table `archive` change `ar_title` `ar_title` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `archive` add index `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`);

alter table `attachments` drop key `name_ext_from`;
alter table `attachments` change `at_filename` `at_filename` varchar (128) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `attachments` change `at_name` `at_name` varchar (128) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `attachments` change `at_desc` `at_desc` mediumtext   NOT NULL  COLLATE latin1_swedish_ci;
alter table `attachments` change `at_filename` `at_filename` blob  DEFAULT '' NOT NULL;
alter table `attachments` change `at_name` `at_name` blob  DEFAULT '' NOT NULL;
alter table `attachments` change `at_desc` `at_desc` blob   NOT NULL ;
alter table `attachments` change `at_filename` `at_filename` varchar (128) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `attachments` change `at_name` `at_name` varchar (128) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `attachments` change `at_desc` `at_desc` mediumtext   NOT NULL  COLLATE utf8_general_ci;
alter table `attachments` change `at_removed_by_text` `at_removed_by_text` varchar (255)  NULL  COLLATE latin1_swedish_ci;
alter table `attachments` change `at_removed_by_text` `at_removed_by_text` blob   NULL;
alter table `attachments` change `at_removed_by_text` `at_removed_by_text` varchar (255)  NULL  COLLATE utf8_general_ci;
alter table `attachments` add index `name_ext_from` (`at_from`,`at_extension`,`at_name`);

alter table `users` drop key `user_real_name_service_id`;
alter table `users` drop key `user_name`;
alter table `users` change `user_name` `user_name` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `users` change `user_real_name` `user_real_name` varchar (255)  NULL  COLLATE latin1_swedish_ci;
alter table `users` change `user_name` `user_name` blob  DEFAULT '' NOT NULL;
alter table `users` change `user_real_name` `user_real_name` blob   NULL;
alter table `users` change `user_name` `user_name` varchar (255)  NOT NULL  COLLATE utf8_general_ci;
alter table `users` change `user_real_name` `user_real_name` varchar (255)  NULL  COLLATE utf8_general_ci;
alter table `users` add UNIQUE `user_real_name_service_id` (`user_external_name`,`user_service_id`);
alter table `users` add UNIQUE KEY `user_name` (`user_name`);

alter table `comments` change `cmnt_content` `cmnt_content` text   NOT NULL  COLLATE latin1_swedish_ci;
alter table `comments` change `cmnt_content` `cmnt_content` blob   NOT NULL;
alter table `comments` change `cmnt_content` `cmnt_content` text   NOT NULL  COLLATE utf8_general_ci;

alter table `brokenlinks` drop key `bl_from`;
alter table `brokenlinks` drop key `bl_to`;
alter table `brokenlinks` change `bl_to` `bl_to` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `brokenlinks` change `bl_to` `bl_to` blob  DEFAULT '' NOT NULL;
alter table `brokenlinks` change `bl_to` `bl_to` varchar (255)  NOT NULL  COLLATE utf8_general_ci;
alter table `brokenlinks` add UNIQUE `bl_from` (`bl_from`,`bl_to`);
alter table `brokenlinks` add KEY `bl_to` (`bl_to`);

alter table `logging` drop key `page_time`;
alter table `logging` change `log_title` `log_title` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci ;
alter table `logging` change `log_title` `log_title` blob  DEFAULT '' NOT NULL ;
alter table `logging` change `log_title` `log_title` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `logging` add KEY `page_time` (`log_namespace`,`log_title`,`log_timestamp`);

alter table `recentchanges` drop key `rc_namespace_title`;
alter table `recentchanges` change `rc_title` `rc_title` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `recentchanges` change `rc_comment` `rc_comment` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `recentchanges` change `rc_title` `rc_title` blob  DEFAULT '' NOT NULL;
alter table `recentchanges` change `rc_comment` `rc_comment` blob  DEFAULT '' NOT NULL;
alter table `recentchanges` change `rc_title` `rc_title` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `recentchanges` change `rc_comment` `rc_comment` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `recentchanges` change `rc_user_text` `rc_user_text` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `recentchanges` change `rc_user_text` `rc_user_text` blob  DEFAULT '' NOT NULL;
alter table `recentchanges` change `rc_user_text` `rc_user_text` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `recentchanges` add KEY `rc_namespace_title` (`rc_namespace`,`rc_title`);

alter table `tags` drop key `tag_name`;
alter table `tags` change `tag_name` `tag_name` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci;
alter table `tags` change `tag_name` `tag_name` blob  DEFAULT '' NOT NULL ;
alter table `tags` change `tag_name` `tag_name` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `tags` add KEY `tag_name` (`tag_name`);

alter table `watchlist` drop key `wl_user`;
alter table `watchlist` drop key `namespace_title`;
alter table `watchlist` change `wl_title` `wl_title` varchar (255) DEFAULT '' NOT NULL  COLLATE latin1_swedish_ci ;
alter table `watchlist` change `wl_title` `wl_title` blob   NOT NULL ;
alter table `watchlist` change `wl_title` `wl_title` varchar (255) DEFAULT '' NOT NULL  COLLATE utf8_general_ci;
alter table `watchlist` add UNIQUE KEY `wl_user` (`wl_user`,`wl_namespace`,`wl_title`);
alter table `watchlist` add KEY `namespace_title` (`wl_namespace`,`wl_title`);