Sha256: 993b26962e096cb51dbbbf3dfa2515b1b9bbb07f8957aae3dfde861dd68833e3

Contents?: true

Size: 1.04 KB

Versions: 172

Compression:

Stored size: 1.04 KB

Contents

# frozen_string_literal: true

class InstallAudited < ActiveRecord::Migration[7.1]
  def self.up
    create_table :audits, :force => true do |t|
      t.column :auditable_id, :integer
      t.column :auditable_type, :string
      t.column :associated_id, :integer
      t.column :associated_type, :string
      t.column :user_id, :integer
      t.column :user_type, :string
      t.column :username, :string
      t.column :action, :string
      t.column :audited_changes, :jsonb
      t.column :version, :integer, :default => 0
      t.column :comment, :string
      t.column :remote_address, :string
      t.column :request_uuid, :string
      t.column :created_at, :datetime
    end

    add_index :audits, [:auditable_type, :auditable_id, :version], :name => 'auditable_index'
    add_index :audits, [:associated_type, :associated_id], :name => 'associated_index'
    add_index :audits, [:user_id, :user_type], :name => 'user_index'
    add_index :audits, :request_uuid
    add_index :audits, :created_at
  end

  def self.down
    drop_table :audits
  end
end

Version data entries

172 entries across 172 versions & 1 rubygems

Version Path
pg_rails-7.6.30 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.29 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.28 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.27 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.26 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.25 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.24 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.24.pre.5 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.24.pre.4 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.24.pre.3 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.23 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.22 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.22.pre.3 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.22.pre.2 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.22.pre.1 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.21 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.21.pre.11 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.21.pre.10 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.21.pre.9 pg_engine/db/migrate/20240208234901_install_audited.rb
pg_rails-7.6.21.pre.8 pg_engine/db/migrate/20240208234901_install_audited.rb