diff options
| author | Treeston <treeston.mmoc@gmail.com> | 2020-08-20 17:56:10 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-02-04 00:27:11 +0100 |
| commit | 15d75dea10c058364a2577b73a627b4701d4ce01 (patch) | |
| tree | 65f7202eeb793b019c090dd157800c0ed2e4fa92 /sql | |
| parent | 317bb198b1152aafe8a48137e3748423eca02448 (diff) | |
Core/Warden: More refactors lifted from #25286.
(cherry picked from commit a3971ca4b05e2913850b6d4fe7d40884fa645fa0)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_02_03_22_world_2020_08_20_00_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_03_22_world_2020_08_20_00_world.sql b/sql/updates/world/master/2022_02_03_22_world_2020_08_20_00_world.sql new file mode 100644 index 00000000000..e599ed191d1 --- /dev/null +++ b/sql/updates/world/master/2022_02_03_22_world_2020_08_20_00_world.sql @@ -0,0 +1,16 @@ +-- +ALTER TABLE `warden_checks` + MODIFY COLUMN `str` VARCHAR(170) DEFAULT NULL, + MODIFY COLUMN `result` VARBINARY(24) DEFAULT NULL; + +-- shift all warden checks down by 1 so we no longer have a gap at id 0 +-- (left join is for reapply safety) +UPDATE `warden_checks` wc1 + LEFT JOIN `warden_checks` wc2 ON `wc2`.`id` = 0 + SET `wc1`.`id` = `wc1`.`id`-1 + WHERE `wc2`.`id` IS NULL; + +DELETE FROM `warden_checks` WHERE `id` IN (786,787); +INSERT INTO `warden_checks` (`id`,`type`,`str`,`address`,`length`,`result`, `comment`) VALUES +(786, 243, NULL, 0x819210, 16, UNHEX('558BEC518305A013D40001A19C13D400'), 'FrameScript::Execute'), +(787, 243, NULL, 0x84F860, 15, UNHEX('558BEC8B4D108B450C83EC0883F903'), 'FrameScript::lua_loadbuffer'); |