title: How do you version your database schema?
body: <p>How do you prepare your SQL deltas? do you manually save each schema-changing SQL to a delta folder, or do you have some kind of an automated diffing process?</p>
  
  <p>I am interested in conventions for versioning database schema along with the source code. Perhaps a pre-commit hook that diffs the schema?</p>
  
  <p>Also, what options for diffing deltas exist aside from <a href="http://dbdeploy.com/" rel="noreferrer">DbDeploy</a>?</p>
  
  <p><strong>EDIT:</strong> seeing the answers I would like to clarify that I am familiar with the standard scheme for running a database migration using deltas. My question is about creating the deltas themselves, preferably automatically.</p>
  
  <p>Also, the versioning is for PHP and MySQL if it makes a difference. (No Ruby solutions please).</p>