Contents

class CreateMartyNotificationsDeliveries < ActiveRecord::Migration[4.2]
  def change
    create_table :marty_notifications_deliveries do |t|
      t.integer :notification_id, null: false
      t.integer :recipient_id
      t.string :delivery_type, null: false
      t.string :state, null: false
      t.text :text, null: false, default: ''
      t.string :error_text, null: false, default: ''

      t.timestamps null: false
    end

    add_foreign_key :marty_notifications_deliveries, :marty_notifications,
                    column: :notification_id, on_delete: :cascade
    add_foreign_key :marty_notifications_deliveries, :marty_users,
                    column: :recipient_id, on_delete: :nullify

    add_index :marty_notifications_deliveries, [:notification_id, :recipient_id, :delivery_type],
              unique: true, name: :index_marty_notifications_deliveries_on_n_id_r_id_and_type
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
marty-14.3.0	db/migrate/521_create_marty_notifications_deliveries.rb
marty-14.0.0	db/migrate/521_create_marty_notifications_deliveries.rb
marty-13.0.2	db/migrate/521_create_marty_notifications_deliveries.rb
marty-11.0.0	db/migrate/521_create_marty_notifications_deliveries.rb
marty-10.0.3	db/migrate/521_create_marty_notifications_deliveries.rb
marty-10.0.2	db/migrate/521_create_marty_notifications_deliveries.rb
marty-10.0.0	db/migrate/521_create_marty_notifications_deliveries.rb
marty-9.5.1	db/migrate/521_create_marty_notifications_deliveries.rb
marty-9.5.0	db/migrate/521_create_marty_notifications_deliveries.rb
marty-9.3.3	db/migrate/521_create_marty_notifications_deliveries.rb
marty-9.3.2	db/migrate/521_create_marty_notifications_deliveries.rb
marty-9.3.0	db/migrate/521_create_marty_notifications_deliveries.rb
marty-8.5.0	db/migrate/521_create_marty_notifications_deliveries.rb
marty-8.4.1	db/migrate/521_create_marty_notifications_deliveries.rb
marty-8.3.1	db/migrate/521_create_marty_notifications_deliveries.rb
marty-8.2.0	db/migrate/521_create_marty_notifications_deliveries.rb