title: Github projects with databases
body: <p>Hi (sorry if this has been asked before but I couldn't find the answer)</p>
  
  <p>I am looking at using Git (probably Github) for a project coming up that I will be working on. The project will be using Yii framework which needs a set of database tables etc. While we're working in development, we'll need to add/edit/delete tables, but the Production area will not have these tables.  How do we address the differences between environments?</p>
  
  <p>The only thought I have now is to somehow get the Schema of the SQL including the data into a .sql file and have use a script, which would automatically update our database, be a part of our project (which will be apart of Github). Is this the best idea? or is there something I am missing?</p>
  
  <p>Thanks for any help in advance</p>