diff options
author | Luke Shumaker <shumakl@purdue.edu> | 2014-04-29 03:49:54 -0400 |
---|---|---|
committer | Luke Shumaker <shumakl@purdue.edu> | 2014-04-29 03:49:54 -0400 |
commit | 4f523f424cb41733c19754c5d4b538053d86ab74 (patch) | |
tree | 55736af3a1ffe6494eb978be17f348b7e899630f /db/migrate/20140429074419_create_mailboxer.mailboxer_engine.rb | |
parent | a3a72a54cc5742ffe82611fb87b3445c251d0676 (diff) | |
parent | 4c5c8b978d6bc70811e95e6da5afd06ec7a2e27e (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.rb | 62 |
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 |