summaryrefslogtreecommitdiff
path: root/db/schema.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb42
1 files changed, 41 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 3f39538..a160f22 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: 20140422195211) do
+ActiveRecord::Schema.define(version: 20140422212727) do
create_table "alerts", force: true do |t|
t.integer "author_id"
@@ -51,6 +51,12 @@ ActiveRecord::Schema.define(version: 20140422195211) do
add_index "brackets", ["tournament_id"], name: "index_brackets_on_tournament_id"
add_index "brackets", ["user_id"], name: "index_brackets_on_user_id"
+ create_table "conversations", force: true do |t|
+ t.string "subject", default: ""
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "delayed_jobs", force: true do |t|
t.integer "priority", default: 0, null: false
t.integer "attempts", default: 0, null: false
@@ -119,6 +125,26 @@ ActiveRecord::Schema.define(version: 20140422195211) do
t.integer "team_id", null: false
end
+ create_table "notifications", force: true do |t|
+ t.string "type"
+ t.text "body"
+ t.string "subject", default: ""
+ t.integer "sender_id"
+ t.string "sender_type"
+ t.integer "conversation_id"
+ t.boolean "draft", default: false
+ t.datetime "updated_at", null: false
+ t.datetime "created_at", null: false
+ t.integer "notified_object_id"
+ t.string "notified_object_type"
+ t.string "notification_code"
+ t.string "attachment"
+ t.boolean "global", default: false
+ t.datetime "expires"
+ end
+
+ add_index "notifications", ["conversation_id"], name: "index_notifications_on_conversation_id"
+
create_table "players_tournaments", id: false, force: true do |t|
t.integer "player_id", null: false
t.integer "tournament_id", null: false
@@ -135,6 +161,20 @@ ActiveRecord::Schema.define(version: 20140422195211) 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 "receipts", force: true do |t|
+ t.integer "receiver_id"
+ t.string "receiver_type"
+ t.integer "notification_id", null: false
+ t.boolean "is_read", default: false
+ t.boolean "trashed", default: false
+ t.boolean "deleted", default: false
+ t.string "mailbox_type", limit: 25
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
+ add_index "receipts", ["notification_id"], name: "index_receipts_on_notification_id"
+
create_table "remote_usernames", force: true do |t|
t.integer "game_id"
t.integer "user_id"