Mark’s stream of verbiage: Versioning your schema:
There are quite a lot of different options. On some very small / trivial applications developed by just one person, it might be acceptable to use ad-hoc queries (maybe with a GUI) to manage the schema – but this runs the risk of development and production schemas becoming out of sync (or rather, out of sync with their respective versions of code).