Contents

class ActsAsTaggableMigration < ActiveRecord::Migration[5.2]
  def up
    create_table ActsAsTaggableOn.tags_table do |t|
      t.string :name, index: { unique: true }
      t.integer :taggings_count, default: 0
      t.timestamps
    end

    create_table ActsAsTaggableOn.taggings_table do |t|
      t.references :tag, foreign_key: { to_table: ActsAsTaggableOn.tags_table }, index: false

      # You should make sure that the column created is
      # long enough to store the required class names.
      t.references :taggable, polymorphic: true
      t.references :tagger, polymorphic: true

      # Limit is created to prevent MySQL error on index
      # length for MyISAM table type: http://bit.ly/vgW2Ql
      t.string :context, limit: 128

      t.datetime :created_at

      t.index %i[tag_id taggable_id taggable_type context tagger_id tagger_type], unique: true, name: 'ataggings_idx'
      t.index %i[taggable_id taggable_type context], name: 'ataggings_taggable_context_idx'
      t.index :taggable_type
      t.index :context
      t.index %i[tagger_id tagger_type]
      t.index %i[taggable_id taggable_type tagger_id context], name: 'ataggings_idy'
    end

    return unless ActsAsTaggableOn::Utils.using_mysql?

    execute("ALTER TABLE #{ActsAsTaggableOn.tags_table} MODIFY name varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;")
  end

  def down
    drop_table ActsAsTaggableOn.taggings_table
    drop_table ActsAsTaggableOn.tags_table
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
additional_tags-1.0.1	db/migrate/20201116145429_acts_as_taggable_migration.rb
additional_tags-1.0.0	db/migrate/20201116145429_acts_as_taggable_migration.rb