# MySQL (default setup).  Versions 4.1 and 5.0 are recommended.
#
# Install the MySQL driver:
#   gem install mysql
# On MacOS X:
#   gem install mysql -- --include=/usr/local/lib
# On Windows:
#   There is no gem for Windows.  Install mysql.so from RubyForApache.
#   http://rubyforge.org/projects/rubyforapache
#
# And be sure to use new-style password hashing:
#   http://dev.mysql.com/doc/refman/5.0/en/old-client.html
development:
  adapter: sqlite3
  database: db/dev.db
#  username: root
#  password:
#  host: localhost

# Warning: The database defined as 'test' will be erased and
# re-generated from your development database when you run 'rake'.
# Do not set this db to the same as development or production.
test:
  adapter: sqlite3
  database: db/test.db
#  username: root
#  password:
#  host: localhost

production:
  adapter: sqlite3
  database: db/prod.db
#  username: root
#  password:
#  host: localhost

--------------------------
MIGRATION:

class ContactDb < ActiveRecord::Migration
  def self.up
    create table "people" do |t|
      t.column "id", :integer
      t.column "name", :string
      t.column "address", :string
      t.column "city", :string
      t.column "state", :string
      t.column "zipcode", :string
    end
  end

  def self.down
    drop_table :people
  end
end