db/migrate/20200725071818_create_status_domain_permissions.rb


1
2
3
4
5
6
7
8
9
10
11
12
13

class CreateStatusDomainPermissions < ActiveRecord::Migration[5.2]
  disable_ddl_transaction!

  def change
    create_table :status_domain_permissions do |t|
      t.references :status, null: false, index: { algorithm: :concurrently }, foreign_key: { on_delete: :cascade }
      t.string :domain, null: false, default: '', index: { algorithm: :concurrently }
      t.integer :visibility, null: false, default: 0, index: { algorithm: :concurrently }
    end

    add_index :status_domain_permissions, [:status_id, :domain], unique: true, algorithm: :concurrently
  end
end