Updated script based on alter_methods_table.sql inside central/common-update
no ticket
Reviewer: Aldrin