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