Sha256: dc30da1fea142fc1b23daeb6a807144feae8fcba7246b73fd8cefc0c8b521a48

Contents?: true

Size: 1.81 KB

Versions: 3

Compression:

Stored size: 1.81 KB

Contents

# This migration creates the `versions` table, the only schema PT requires.
# All other migrations PT provides are optional.
class CreateVersions < ActiveRecord::Migration<%= migration_version %>

  # The largest text column available in all supported RDBMS is
  # 1024^3 - 1 bytes, roughly one gibibyte.  We specify a size
  # so that MySQL will use `longtext` instead of `text`.  Otherwise,
  # when serializing very large objects, `text` might not be big enough.
  TEXT_BYTES = 1_073_741_823

  def change
    create_table :versions<%= versions_table_options %><%= version_table_primary_key_type %> do |t|
      # Consider using bigint type for performance if you are going to store only numeric ids.
      # t.bigint   :whodunnit
      t.string   :whodunnit

      # Known issue in MySQL: fractional second precision
      # -------------------------------------------------
      #
      # MySQL timestamp columns do not support fractional seconds unless
      # defined with "fractional seconds precision". MySQL users should manually
      # add fractional seconds precision to this migration, specifically, to
      # the `created_at` column.
      # (https://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html)
      #
      # MySQL users should also upgrade to at least rails 4.2, which is the first
      # version of ActiveRecord with support for fractional seconds in MySQL.
      # (https://github.com/rails/rails/pull/14359)
      #
      # MySQL users should use the following line for `created_at`
      # t.datetime :created_at, limit: 6
      t.datetime :created_at

      t.<%= item_id_type_options %>   :item_id,   null: false
      t.string   :item_type<%= item_type_options %>
      t.string   :event,     null: false
      t.text     :object, limit: TEXT_BYTES
    end
    add_index :versions, %i[item_type item_id]
  end
end

Version data entries

3 entries across 3 versions & 2 rubygems

Version Path
trusty-cms-7.0.9.1 vendor/bundle/ruby/3.3.0/gems/paper_trail-16.0.0/lib/generators/paper_trail/install/templates/create_versions.rb.erb
paper_trail-16.0.0 lib/generators/paper_trail/install/templates/create_versions.rb.erb
paper_trail-15.2.0 lib/generators/paper_trail/install/templates/create_versions.rb.erb