Файл: database/migrations/v50_8_runtime_hotfix.sql
Строк: 34
-- Игра v50.8 runtime compatibility migration.
-- Import only into the
already selected game database. No CREATE DATABASE/USE statements.
ALTER
TABLE `boiarena` MODIFY `hp` BIGINT UNSIGNED NOT NULL DEFAULT 1;
ALTER
TABLE `boiarena` MODIFY `hp_max` BIGINT UNSIGNED NOT NULL DEFAULT 1;
ALTER
TABLE `boiarena` MODIFY `hp_vrag` BIGINT UNSIGNED NOT NULL DEFAULT 1;
ALTER
TABLE `boiarena` MODIFY `hp_vrag_max` BIGINT UNSIGNED NOT NULL DEFAULT
1;
ALTER TABLE `boiarena` MODIFY `att` BIGINT UNSIGNED NOT NULL DEFAULT
1;
ALTER TABLE `boiarena` MODIFY `deff` BIGINT UNSIGNED NOT NULL DEFAULT
0;
ALTER TABLE `boiarena` MODIFY `user_att` BIGINT UNSIGNED NOT NULL
DEFAULT 1;
ALTER TABLE `boiarena` MODIFY `user_deff` BIGINT UNSIGNED NOT
NULL DEFAULT 0;
ALTER TABLE `boiarena` MODIFY `login` VARCHAR(80) NOT NULL
DEFAULT 'Гладиатор';
ALTER TABLE `ticket` MODIFY `title`
VARCHAR(120) NOT NULL;
-- v50.8: stale automatic applications from legacy
Valley/Altars builds.
-- Finished history is preserved; only current
waiting human registrations are reset once.
DELETE m FROM
`undying_v51_member` m
JOIN `undying_v51_event` e ON
e.`id`=m.`event_id`
WHERE e.`state`='waiting' AND m.`is_bot`=0;
DELETE m
FROM `altar_v51_member` m
JOIN `altar_v51_event` e ON
e.`id`=m.`event_id`
WHERE e.`state`='waiting' AND m.`is_bot`=0;
INSERT INTO
`game_meta` (`meta_key`,`meta_value`) VALUES ('v51_schema','10')
ON
DUPLICATE KEY UPDATE `meta_value`='10';