1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/20140427171556_create_games.rb b/db/migrate/20140427171556_create_games.rb
new file mode 100644
index 0000000..d1b9511
--- /dev/null
+++ b/db/migrate/20140427171556_create_games.rb
@@ -0,0 +1,17 @@
+class CreateGames < ActiveRecord::Migration
+  def change
+    create_table :games do |t|
+      t.references :parent, index: true
+      t.string :name
+      t.integer :min_players_per_team
+      t.integer :max_players_per_team
+      t.integer :min_teams_per_match
+      t.integer :max_teams_per_match
+      t.string :sampling_method
+      t.string :scoring_method
+
+      t.timestamps
+    end
+    add_index :games, :name, unique: true
+  end
+end