Sha256: b412fda84654941bc33412d7c51c770ca0d30c997f8e8e61fe45bcea13eb9492

Contents?: true

Size: 638 Bytes

Versions: 17

Compression:

Stored size: 638 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: :<%= table_prefix %>_audit_<%= table_prefix %>_at_idx
  index :at, name: :<%= table_prefix %>_audit_at_idx
end

Version data entries

17 entries across 17 versions & 1 rubygems

Version Path
plutonium-0.12.14 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.13 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.12 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.11 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.10 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.9 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.8 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.7 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.5 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.4 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.3 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.2 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.1 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.12.0 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.11.2 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.11.1 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb
plutonium-0.11.0 lib/generators/pu/rodauth/migration/sequel/audit_logging.erb