summaryrefslogtreecommitdiff
path: root/db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb
diff options
context:
space:
mode:
authorLuke Shumaker <shumakl@purdue.edu>2014-04-29 03:49:54 -0400
committerLuke Shumaker <shumakl@purdue.edu>2014-04-29 03:49:54 -0400
commit4f523f424cb41733c19754c5d4b538053d86ab74 (patch)
tree55736af3a1ffe6494eb978be17f348b7e899630f /db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb
parenta3a72a54cc5742ffe82611fb87b3445c251d0676 (diff)
parent4c5c8b978d6bc70811e95e6da5afd06ec7a2e27e (diff)
Merge branch 'clean2'
Conflicts: app/controllers/matches_controller.rb app/views/matches/index.html.erb app/views/matches/show.html.erb
Diffstat (limited to 'db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb')
-rw-r--r--db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb62
1 files changed, 62 insertions, 0 deletions
diff --git a/db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb b/db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb
new file mode 100644
index 0000000..690cec2
--- /dev/null
+++ b/db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb
@@ -0,0 +1,62 @@
+# This migration comes from mailboxer_engine (originally 20110511145103)
+class CreateMailboxer < ActiveRecord::Migration
+ def self.up
+ #Tables
+ #Conversations
+ create_table :conversations do |t|
+ t.column :subject, :string, :default => ""
+ t.column :created_at, :datetime, :null => false
+ t.column :updated_at, :datetime, :null => false
+ end
+ #Receipts
+ create_table :receipts do |t|
+ t.references :receiver, :polymorphic => true
+ t.column :notification_id, :integer, :null => false
+ t.column :read, :boolean, :default => false
+ t.column :trashed, :boolean, :default => false
+ t.column :deleted, :boolean, :default => false
+ t.column :mailbox_type, :string, :limit => 25
+ t.column :created_at, :datetime, :null => false
+ t.column :updated_at, :datetime, :null => false
+ end
+ #Notifications and Messages
+ create_table :notifications do |t|
+ t.column :type, :string
+ t.column :body, :text
+ t.column :subject, :string, :default => ""
+ t.references :sender, :polymorphic => true
+ t.references :object, :polymorphic => true
+ t.column :conversation_id, :integer
+ t.column :draft, :boolean, :default => false
+ t.column :updated_at, :datetime, :null => false
+ t.column :created_at, :datetime, :null => false
+ end
+
+
+ #Indexes
+ #Conversations
+ #Receipts
+ add_index "receipts","notification_id"
+
+ #Messages
+ add_index "notifications","conversation_id"
+
+ #Foreign keys
+ #Conversations
+ #Receipts
+ add_foreign_key "receipts", "notifications", :name => "receipts_on_notification_id"
+ #Messages
+ add_foreign_key "notifications", "conversations", :name => "notifications_on_conversation_id"
+ end
+
+ def self.down
+ #Tables
+ remove_foreign_key "receipts", :name => "receipts_on_notification_id"
+ remove_foreign_key "notifications", :name => "notifications_on_conversation_id"
+
+ #Indexes
+ drop_table :receipts
+ drop_table :conversations
+ drop_table :notifications
+ end
+end