Sha256: e12e7e3f0c094dee0ad8aec675faba17f90e5c970145c38a780f74b96f29fc64

Contents?: true

Size: 1.38 KB

Versions: 17

Compression:

Stored size: 1.38 KB

Contents

# Migration responsible for creating a table with notifications
class CreateActivityNotificationTables < ActiveRecord::Migration[5.2]
  # Create tables
  def change
    create_table :notifications do |t|
      t.belongs_to :target,     polymorphic: true, index: true, null: false
      t.belongs_to :notifiable, polymorphic: true, index: true, null: false
      t.string     :key,                                        null: false
      t.belongs_to :group,      polymorphic: true, index: true
      t.integer    :group_owner_id,                index: true
      t.belongs_to :notifier,   polymorphic: true, index: true
      t.text       :parameters
      t.datetime   :opened_at

      t.timestamps null: false
    end

    create_table :subscriptions do |t|
      t.belongs_to :target,     polymorphic: true, index: true, null: false
      t.string     :key,                           index: true, null: false
      t.boolean    :subscribing,                                null: false, default: true
      t.boolean    :subscribing_to_email,                       null: false, default: true
      t.datetime   :subscribed_at
      t.datetime   :unsubscribed_at
      t.datetime   :subscribed_to_email_at
      t.datetime   :unsubscribed_to_email_at
      t.text       :optional_targets

      t.timestamps null: false
    end
    add_index :subscriptions, [:target_type, :target_id, :key], unique: true
  end
end

Version data entries

17 entries across 17 versions & 1 rubygems

Version Path
activity_notification-2.3.3 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.3.2 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.3.1 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.3.0 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.2.4 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.2.3 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.2.2 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.2.1 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.2.0 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.1.4 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.1.3 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.1.2 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.1.1 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.1.0 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-2.0.0 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-1.7.1 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb
activity_notification-1.7.0 spec/rails_app/db/migrate/20181209000000_create_activity_notification_tables.rb