-- --------------------------------------------------------
-- Guild Point Rewards - RoV Adjustment
-- --------------------------------------------------------
-- Dividing Max Values by 3 due to guild points being tripled in 11/08/2016.
-- Patch Notes: The maximum number of points that may be earned from delivering guild point items has been increased.
-- Patch Notes Link: https://forum.square-enix.com/ffxi/threads/51624
-- --------------------------------------------------------

-- Divide all max_points by 3 for LSB adjustment
UPDATE `guild_item_points`
SET `max_points` = `max_points` / 3;