diff options
| author | Bryan Helmkamp <bryan@brynary.com> | 2009-05-17 17:53:40 -0400 |
|---|---|---|
| committer | Bryan Helmkamp <bryan@brynary.com> | 2009-05-17 17:53:40 -0400 |
| commit | d2988420fc6dd91ca751d96ed648fd1ed52ce342 (patch) | |
| tree | e817b2dcc2b8d018181fd676feb1648786d23de3 /spec/schemas | |
| parent | 7fc820501ce7b997da43c47ec189aaa0d40645e1 (diff) | |
| download | rails-d2988420fc6dd91ca751d96ed648fd1ed52ce342.tar.gz rails-d2988420fc6dd91ca751d96ed648fd1ed52ce342.tar.bz2 rails-d2988420fc6dd91ca751d96ed648fd1ed52ce342.zip | |
Added PostgreSQL to build
Diffstat (limited to 'spec/schemas')
| -rw-r--r-- | spec/schemas/postgresql_schema.rb | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/spec/schemas/postgresql_schema.rb b/spec/schemas/postgresql_schema.rb new file mode 100644 index 0000000000..30fa665902 --- /dev/null +++ b/spec/schemas/postgresql_schema.rb @@ -0,0 +1,18 @@ +sql = <<-SQL + DROP TABLE IF EXISTS users; + CREATE TABLE users ( + id SERIAL PRIMARY KEY NOT NULL, + name VARCHAR(255) NOT NULL + ); + + DROP TABLE IF EXISTS photos; + CREATE TABLE photos ( + id SERIAL PRIMARY KEY NOT NULL, + user_id INTEGER NOT NULL, + camera_id INTEGER NOT NULL + ); +SQL + +sql.split(/;/).select(&:present?).each do |sql_statement| + ActiveRecord::Base.connection.execute sql_statement +end |