Contents

# frozen_string_literal: true

require 'thredded/base_migration'

class UpgradeV09ToV010 < Thredded::BaseMigration
  def up
    remove_foreign_key :thredded_messageboard_users, :thredded_messageboards
    add_foreign_key :thredded_messageboard_users, :thredded_messageboards, on_delete: :cascade
    remove_foreign_key :thredded_messageboard_users, :thredded_user_details
    add_foreign_key :thredded_messageboard_users, :thredded_user_details, on_delete: :cascade

    create_table :thredded_user_post_notifications do |t|
      t.references :user, null: false, index: false, type: user_id_type
      t.references :post, null: false, index: false, type: column_type(:thredded_posts, :id)
      t.datetime :notified_at, null: false
      t.index :post_id, name: :index_thredded_user_post_notifications_on_post_id
      t.index %i[user_id post_id], name: :index_thredded_user_post_notifications_on_user_id_and_post_id, unique: true
    end

    add_foreign_key :thredded_user_post_notifications,
                    Thredded.user_class.table_name, column: :user_id, on_delete: :cascade
    add_foreign_key :thredded_user_post_notifications,
                    :thredded_posts, column: :post_id, on_delete: :cascade
  end

  def down
    drop_table :thredded_user_post_notifications

    remove_foreign_key :thredded_messageboard_users, :thredded_user_details
    add_foreign_key :thredded_messageboard_users, :thredded_user_details
    remove_foreign_key :thredded_messageboard_users, :thredded_messageboards
    add_foreign_key :thredded_messageboard_users, :thredded_messageboards
  end
end

Version data entries

14 entries across 14 versions & 1 rubygems

Version	Path
thredded-0.14.1	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.14.0	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.8	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.7	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.6	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.5	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.4	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.3	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.2	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.1	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.13.0	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.12.4	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.12.3	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb
thredded-0.12.2	db/upgrade_migrations/20170125033319_upgrade_v0_9_to_v0_10.rb