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