[WIP] Create tables [incomplete]

seuros · seuros · commit 5ee27a9421b3 · 2014-07-19T23:57:38.000Z
diff --git a/Gemfile b/Gemfile
@@ -162,6 +162,7 @@ group :development, :test do
   gem 'quiet_assets'
   gem 'syntax'
   gem 'annotate'
+  gem 'rspec-rails'
 end
 
 group :test do
@@ -171,11 +172,11 @@ group :test do
   gem 'database_cleaner'
   gem 'fuubar' , '2.0.0.rc1'
   gem 'resque_spec'
-  gem 'rspec-rails'
   gem 'simplecov'
   gem 'timecop'
   gem 'vcr'
   gem 'webmock', '<1.16'
+  gem 'shoulda-matchers'
 end
 
 group :production do
diff --git a/Gemfile.lock b/Gemfile.lock
@@ -606,6 +606,8 @@ GEM
     sax-machine (0.2.1)
       nokogiri (~> 1.6.0)
     sexp_processor (4.4.3)
+    shoulda-matchers (2.6.1)
+      activesupport (>= 3.0.0)
     sidekiq (3.2.1)
       celluloid (>= 0.15.2)
       connection_pool (>= 2.0.0)
@@ -805,6 +807,7 @@ DEPENDENCIES
   sanitize
   sass (~> 3.2.9)
   sass-rails (~> 3.2.6)
+  shoulda-matchers
   sidekiq
   simple_form
   simplecov
diff --git a/db/migrate/20140718083741_create_teams_accounts.rb b/db/migrate/20140718083741_create_teams_accounts.rb
@@ -0,0 +1,8 @@
+class CreateTeamsAccounts < ActiveRecord::Migration
+  def change
+    create_table :teams_accounts do |t|
+      t.integer :team_id, null: false
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140718083912_create_teams_links.rb b/db/migrate/20140718083912_create_teams_links.rb
@@ -0,0 +1,10 @@
+class CreateTeamsLinks < ActiveRecord::Migration
+  def change
+    create_table :teams_links do |t|
+      t.string :name
+      t.string :url
+      t.integer :team_id, null: false
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140718083928_create_teams_locations.rb b/db/migrate/20140718083928_create_teams_locations.rb
@@ -0,0 +1,16 @@
+class CreateTeamsLocations < ActiveRecord::Migration
+  def change
+    create_table :teams_locations do |t|
+      t.string :name
+      t.string :description
+      t.string :address
+      t.string :city, default: nil
+      t.string :state_code, default: nil
+      t.string :country, default: nil
+      t.integer :team_id, null: false
+      t.timestamps
+    end
+    # field :points_of_interest, type: Array, default: []
+    # field :coordinates, type: Array
+  end
+end
diff --git a/db/migrate/20140718083944_create_teams_members.rb b/db/migrate/20140718083944_create_teams_members.rb
@@ -0,0 +1,9 @@
+class CreateTeamsMembers < ActiveRecord::Migration
+  def change
+    create_table :teams_members do |t|
+      t.integer :team_id, null: false
+      t.integer :user_id, null: false
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140718084025_create_pg_teams.rb b/db/migrate/20140718084025_create_pg_teams.rb
@@ -0,0 +1,8 @@
+class CreatePgTeams < ActiveRecord::Migration
+  def change
+    create_table :pg_teams do |t|
+
+      t.timestamps
+    end
+  end
+end
