--
-- swap SetYawSpeed and SetFrameTime
-- SetYawspeed to BOGUS
UPDATE undo_log
SET action = CAST(x'6969' || substr(action, 3) as BLOB)
WHERE substr(action, 0, 3) == x'000d'; -- SetYawSpeed
-- SetFrameTime to old SetYawspeed
UPDATE undo_log
SET action = CAST(x'000d' || substr(action, 3) as BLOB)
WHERE substr(action, 0, 3) == x'000f'; -- SetFrameTime
-- BOGUS to old SetFrameTime
UPDATE undo_log
SET action = CAST(x'000f' || substr(action, 3) as BLOB)
WHERE substr(action, 0, 3) == x'6969';
--
-- swap SetAdjacentYawspeed and SetCommands
-- SetAdjacentYawspeed to BOGUS
UPDATE undo_log
SET action = CAST(x'6969' || substr(action, 3) as BLOB)
WHERE substr(action, 0, 3) == x'000e'; -- SetAdjacentYawspeed
-- SetCommands to old SetAdjacentYawspeed
UPDATE undo_log
SET action = CAST(x'000e' || substr(action, 3) as BLOB)
WHERE substr(action, 0, 3) == x'0010'; -- SetCommands
-- BOGUS to old SetCommands
UPDATE undo_log
SET action = CAST(x'0010' || substr(action, 3) as BLOB)
WHERE substr(action, 0, 3) == x'6969';
Nevermind. I think I have been memory holed. The setframetime and setcommands are added after the set yawspeed. I thought they were there since forever.
Here is the SQL for migration