summaryrefslogtreecommitdiff
path: root/db/schema.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb57
1 files changed, 47 insertions, 10 deletions
diff --git a/db/schema.rb b/db/schema.rb
index b0d0766..eadf24e 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 20140306024744) do
+ActiveRecord::Schema.define(version: 20140306222447) do
create_table "alerts", force: true do |t|
t.integer "author_id"
@@ -22,22 +22,22 @@ ActiveRecord::Schema.define(version: 20140306024744) do
add_index "alerts", ["author_id"], name: "index_alerts_on_author_id"
- create_table "game_attributes", force: true do |t|
- t.integer "game_id"
- t.text "key"
- t.integer "type"
+ create_table "game_options", force: true do |t|
+ t.integer "vartype"
+ t.string "name"
+ t.text "default"
t.datetime "created_at"
t.datetime "updated_at"
end
- add_index "game_attributes", ["game_id"], name: "index_game_attributes_on_game_id"
-
create_table "games", force: true do |t|
t.text "name"
- t.integer "players_per_team"
- t.integer "teams_per_match"
+ 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.integer "set_rounds"
- t.integer "randomized_teams"
+ t.boolean "randomized_teams"
t.datetime "created_at"
t.datetime "updated_at"
end
@@ -62,6 +62,17 @@ ActiveRecord::Schema.define(version: 20140306024744) do
add_index "pms", ["author_id"], name: "index_pms_on_author_id"
add_index "pms", ["recipient_id"], name: "index_pms_on_recipient_id"
+ create_table "scores", force: true do |t|
+ t.integer "user_id"
+ t.integer "match_id"
+ t.integer "value"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ add_index "scores", ["match_id"], name: "index_scores_on_match_id"
+ add_index "scores", ["user_id"], name: "index_scores_on_user_id"
+
create_table "server_settings", force: true do |t|
t.datetime "created_at"
t.datetime "updated_at"
@@ -91,17 +102,43 @@ ActiveRecord::Schema.define(version: 20140306024744) do
add_index "team_match_pairs", ["team_id"], name: "index_team_match_pairs_on_team_id"
create_table "teams", force: true do |t|
+ t.integer "match_id"
t.datetime "created_at"
t.datetime "updated_at"
end
+ add_index "teams", ["match_id"], name: "index_teams_on_match_id"
+
create_table "tournament_options", force: true do |t|
+ t.integer "tournament_id"
+ t.integer "vartype"
+ t.string "name"
+ t.text "value"
t.datetime "created_at"
t.datetime "updated_at"
end
+ add_index "tournament_options", ["tournament_id"], name: "index_tournament_options_on_tournament_id"
+
+ create_table "tournament_user_pairs", force: true do |t|
+ t.integer "tournament_id"
+ t.integer "user_id"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ add_index "tournament_user_pairs", ["tournament_id"], name: "index_tournament_user_pairs_on_tournament_id"
+ add_index "tournament_user_pairs", ["user_id"], name: "index_tournament_user_pairs_on_user_id"
+
create_table "tournaments", force: true do |t|
t.integer "game_id"
+ 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.integer "set_rounds"
+ t.boolean "randomized_teams"
+ t.integer "status"
t.datetime "created_at"
t.datetime "updated_at"
end