20150721132025_create_notification_table.rb 983 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 
class CreateNotificationTable < ActiveRecord::Migration
  def up
    create_table :environment_notifications do |t|
      t.text :message
      t.integer :environment_id
      t.string :type
      t.string :title
      t.boolean :active
      t.boolean :display_only_in_homepage, :default => false
      t.boolean :display_to_all_users,     :default => false
      t.boolean :display_popup,            :default => false
      t.column :created_at,                :datetime
      t.column :updated_at,                :datetime
    end

    create_table :environment_notifications_users, id: false do |t|
      t.belongs_to :environment_notification
      t.belongs_to :user
    end
    add_index :environment_notifications_users, [:environment_notification_id], name: :index_Zaem6uuw
    add_index :environment_notifications_users, [:user_id], name: :index_ap3nohR9
  end

  def down
    drop_table :environment_notifications
    drop_table :environment_notifications_users
  end
end