added sample database.yml files for sqlite3, postgresql, mysql

3 files changed, 118 insertions, 0 deletions

diff --git a/config/database.yml-mysql-sample.yml b/config/database.yml-mysql-sample.yml
new file mode 100644
index 0000000..bdb5311
--- /dev/null
+++ b/config/database.yml-mysql-sample.yml
@@ -0,0 +1,45 @@
+# MySQL.  Versions 4.1 and 5.0 are recommended.
+#
+# Install the MySQL driver:
+#   gem install mysql
+# On Mac OS X:
+#   sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql
+# On Mac OS X Leopard:
+#   sudo env ARCHFLAGS="-arch i386" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
+#       This sets the ARCHFLAGS environment variable to your native architecture
+# On Windows:
+#   gem install mysql
+#       Choose the win32 build.
+#       Install MySQL and put its /bin directory on your path.
+#
+# And be sure to use new-style password hashing:
+#   http://dev.mysql.com/doc/refman/5.0/en/old-client.html
+development:
+  adapter: mysql
+  encoding: utf8
+  database: mysql_development
+  pool: 5
+  username: root
+  password:
+  socket: /opt/local/var/run/mysql5/mysqld.sock
+
+# 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: mysql
+  encoding: utf8
+  database: mysql_test
+  pool: 5
+  username: root
+  password:
+  socket: /opt/local/var/run/mysql5/mysqld.sock
+
+production:
+  adapter: mysql
+  encoding: utf8
+  database: mysql_production
+  pool: 5
+  username: root
+  password: 
+  socket: /opt/local/var/run/mysql5/mysqld.sock
diff --git a/config/database.yml-psql-sample.yml b/config/database.yml-psql-sample.yml
new file mode 100644
index 0000000..db7276e
--- /dev/null
+++ b/config/database.yml-psql-sample.yml
@@ -0,0 +1,51 @@
+# PostgreSQL. Versions 7.4 and 8.x are supported.
+#
+# Install the ruby-postgres driver:
+#   gem install ruby-postgres
+# On Mac OS X:
+#   gem install ruby-postgres -- --include=/usr/local/pgsql
+# On Windows:
+#   gem install ruby-postgres
+#       Choose the win32 build.
+#       Install PostgreSQL and put its /bin directory on your path.
+development:
+  adapter: postgresql
+  encoding: unicode
+  database: psql_development
+  pool: 5
+  username: psql
+  password:
+
+  # Connect on a TCP socket. Omitted by default since the client uses a
+  # domain socket that doesn't need configuration. Windows does not have
+  # domain sockets, so uncomment these lines.
+  #host: localhost
+  #port: 5432
+
+  # Schema search path. The server defaults to $user,public
+  #schema_search_path: myapp,sharedapp,public
+
+  # Minimum log levels, in increasing order:
+  #   debug5, debug4, debug3, debug2, debug1,
+  #   log, notice, warning, error, fatal, and panic
+  # The server defaults to notice.
+  #min_messages: warning
+
+# 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: postgresql
+  encoding: unicode
+  database: psql_test
+  pool: 5
+  username: psql
+  password:
+
+production:
+  adapter: postgresql
+  encoding: unicode
+  database: psql_production
+  pool: 5
+  username: psql
+  password:
diff --git a/config/database.yml-sqlite3-sample.yml b/config/database.yml-sqlite3-sample.yml
new file mode 100644
index 0000000..025d62a
--- /dev/null
+++ b/config/database.yml-sqlite3-sample.yml
@@ -0,0 +1,22 @@
+# SQLite version 3.x
+#   gem install sqlite3-ruby (not necessary on OS X Leopard)
+development:
+  adapter: sqlite3
+  database: db/development.sqlite3
+  pool: 5
+  timeout: 5000
+
+# 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.sqlite3
+  pool: 5
+  timeout: 5000
+
+production:
+  adapter: sqlite3
+  database: db/production.sqlite3
+  pool: 5
+  timeout: 5000