1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/20140429074449_create_tournaments.rb b/db/migrate/20140429074449_create_tournaments.rb
new file mode 100644
index 0000000..f3715bb
--- /dev/null
+++ b/db/migrate/20140429074449_create_tournaments.rb
@@ -0,0 +1,17 @@
+class CreateTournaments < ActiveRecord::Migration
+  def change
+    create_table :tournaments do |t|
+      t.references :game, index: true
+      t.integer :status
+      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 :scoring_method
+
+      t.timestamps
+    end
+    add_index :tournaments, :name, unique: true
+  end
+end