START TRANSACTION;

ALTER TABLE `accounts_operations` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `active_sessions` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `counter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_accounts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_avg_cost` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_cash_operations_types` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_colors` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_comps` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_countries` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_cross_codes_items` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_cross_codes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_currency` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_customers` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_discount_cards_types` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_discount_cards` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_goods_additional_prop` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `operations` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `doc_sales` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `programms_starts` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `sms_center` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `sys_info` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `users_rights` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `users_settings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `ver` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `w_license_types` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_prices_types` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_prices` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_scans` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `dir_series` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `earned_money` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `gridsettings` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `itm_inventory` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `itm_revaluation` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `log_currency_rate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `log_notify` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `log_price_changes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

UPDATE sys_info SET si_version = "1.506" WHERE sys_info.si_id = 1;
COMMIT; 