====== Режим работы БД в UTF8 ======
===== Описание =====
Данный режим предназначен для отображения и записи данных в UTF8 когда символов требуемой локали нет в KOI8-r/KOI8-u.
^Таблицы которые поддерживают режим UTF8:^
|lanes|
|lanes_houses|
|lanes_houses_blocks|
|lanes_housings|
|lanes_neighborhoods|
|lanes_settlements|
|users|
|usersblok|
|usersdel|
|usersfreeze|
|usersadress|
===== Настройка =====
1. Для активации режима необходимо включить опцию "partialUTF8" добавлением секции "partialUTF8"(если не было) с параметром true
true
https://wiki.mikbill.ru/billing/config_file
{{:mikbill:services:img_26112015_033724.png?direct&200|}}
^Пути к файлам конфигурации^^
|Админка|/var/mikbill/prod/config/admin.xml|
|Личный Кабинет|/var/mikbill/prod/config/stat.xml|
2. Переводим/конвертируем таблицы БД выполнив в БД mikbill следующий запрос:
--
-- Изменить таблицу "lanes"
--
ALTER TABLE lanes
CHANGE COLUMN lane lane CHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
--
-- Изменить таблицу "lanes_houses"
--
ALTER TABLE lanes_houses
CHANGE COLUMN house house CHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
--
-- Изменить таблицу "lanes_houses_blocks"
--
ALTER TABLE lanes_houses_blocks
CHANGE COLUMN houseblockname houseblockname VARCHAR(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
--
-- Изменить таблицу "lanes_housings"
--
ALTER TABLE lanes_housings
CHANGE COLUMN housingname housingname VARCHAR(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
--
-- Изменить таблицу "lanes_neighborhoods"
--
ALTER TABLE lanes_neighborhoods
CHANGE COLUMN neighborhoodname neighborhoodname VARCHAR(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
--
-- Изменить таблицу "lanes_settlements"
--
ALTER TABLE lanes_settlements
CHANGE COLUMN settlementname settlementname VARCHAR(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
--
-- Изменить таблицу "users"
--
ALTER TABLE users
CHANGE COLUMN fio fio CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN address address CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN prim prim CHAR(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
ROW_FORMAT = DYNAMIC;
--
-- Изменить таблицу "usersblok"
--
ALTER TABLE usersblok
CHANGE COLUMN fio fio CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN address address CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN prim prim CHAR(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
--
-- Изменить таблицу "usersdel"
--
ALTER TABLE usersdel
CHANGE COLUMN fio fio CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN address address CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN prim prim CHAR(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
--
-- Изменить таблицу "usersfreeze"
--
ALTER TABLE usersfreeze
CHANGE COLUMN fio fio CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN address address CHAR(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
CHANGE COLUMN prim prim CHAR(254) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
--
-- Изменить представление "usersadress"
--
CREATE OR REPLACE
VIEW usersadress
AS
select concat(`lanes`.`lane`,' ',`lanes_houses`.`house`,'-',convert(`users`.`app` using utf8)) AS `address`,`lanes`.`lane` AS `lane`,`lanes_houses`.`house` AS `house`,`users`.`app` AS `app`,`lanes_houses`.`porches` AS `porches`,`lanes_houses`.`floors` AS `floors`,`users`.`uid` AS `uid`,`users`.`user` AS `user`,`users`.`fio` AS `fio` from ((`lanes_houses` join `lanes` on((`lanes`.`laneid` = `lanes_houses`.`laneid`))) join `users` on((`lanes_houses`.`houseid` = `users`.`houseid`)));
--