class CreatePhcmembersproFriendlyIdSlugs < ActiveRecord::Migration[5.1]
  def change

  create_table :phcmemberspro_friendly_id_slugs do |t|
    t.string   :slug,           :null => false
    t.integer  :sluggable_id,   :null => false
    t.string   :sluggable_type, :limit => 50
    t.string   :scope
    t.datetime :created_at
  end

  add_index :phcmemberspro_friendly_id_slugs, :sluggable_id, name: 'phcmp_slugable_id'
  add_index :phcmemberspro_friendly_id_slugs, [:slug, :sluggable_type], name: 'phcmp_slug_slugable_type', length: { slug: 140, sluggable_type: 50 }
  add_index :phcmemberspro_friendly_id_slugs, [:slug, :sluggable_type, :scope], name: 'phcmp_slugable_type_scope', length: { slug: 70, sluggable_type: 50, scope: 70 }, unique: true
  add_index :phcmemberspro_friendly_id_slugs, :sluggable_type, name: 'phcmp_slugable_type'

  end
end