If you're maintaining an existing production database, and a dev version - you're going to have to track those changes and if you're using version control, I'd put the update scripts in there. Otherwise, you've got to keep track of the changes manually. Either way, you're going to have to use a sql tool to make the changes in production - like phpmyadmin or Workbench.