class CreatePhcscriptcdnproFriendlyIdSlugs < ActiveRecord::Migration[7.0]
  def change

    create_table :phcscriptcdnpro_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 :phcscriptcdnpro_friendly_id_slugs, :sluggable_id
    add_index :phcscriptcdnpro_friendly_id_slugs, [:slug, :sluggable_type], name: 'scriptcdnpro_fri_id_slugable_type', length: { slug: 140, sluggable_type: 50 }
    add_index :phcscriptcdnpro_friendly_id_slugs, [:slug, :sluggable_type, :scope], name: 'scriptcdnpro_fri_id_slugable_scope_type', length: { slug: 70, sluggable_type: 50, scope: 70 }, unique: true
    add_index :phcscriptcdnpro_friendly_id_slugs, :sluggable_type

  end
end