Sha256: a9406c5a515cfcfdf0f072c4beaa90ff5de34013b9ab6c11192ffcb0f47b77b1

Contents?: true

Size: 598 Bytes

Versions: 12

Compression:

Stored size: 598 Bytes

Contents

# Used by the audit logging feature
create_table :<%= table_prefix %>_authentication_audit_logs do
  primary_key :id, type: :Bignum
  foreign_key :<%= table_prefix %>_id, :<%= table_prefix.pluralize %>, null: false, type: :Bignum
  DateTime :at, null: false, default: Sequel::CURRENT_TIMESTAMP
  String :message, null: false
<% case db.database_type -%>
<% when :postgres -%>
  jsonb :metadata
<% when :sqlite, :mysql -%>
  json :metadata
<% else -%>
  String :metadata
<% end -%>
  index [:<%= table_prefix %>_id, :at], name: :audit_<%= table_prefix %>_at_idx
  index :at, name: :audit_at_idx
end

Version data entries

12 entries across 12 versions & 2 rubygems

Version Path
plutonium-0.8.0 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
rodauth-rails-1.14.0 lib/generators/rodauth/migration/sequel/audit_logging.erb
plutonium-0.6.2 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.6.1 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.6.0 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.5.0 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
rodauth-rails-1.13.0 lib/generators/rodauth/migration/sequel/audit_logging.erb
rodauth-rails-1.12.0 lib/generators/rodauth/migration/sequel/audit_logging.erb
rodauth-rails-1.11.0 lib/generators/rodauth/migration/sequel/audit_logging.erb
rodauth-rails-1.10.0 lib/generators/rodauth/migration/sequel/audit_logging.erb
rodauth-rails-1.9.0 lib/generators/rodauth/migration/sequel/audit_logging.erb
rodauth-rails-1.8.0 lib/generators/rodauth/migration/sequel/audit_logging.erb