Skip to content

User table column cleanup 🧹  #3209

@tadhgboyle

Description

@tadhgboyle

Cleanup:

  • delete reputation
  • delete warning_points
  • delete avatar_updated (we can pass the current epoch in the one place we use it)
  • delete tfa_type (we planned to add email tfa support, but this is strongly regarded as a terrible tfa method)
  • rename lastip to last_ip
  • rename is_banned to banned
  • rename theme_id to template_id
  • rename night_mode to dark_mode
  • rename pass_method to password_method

Bonus:

  • create nl2_users_meta key/value table so modules can attach specific information to users without cluttering the nl2_users table more, or creating their own table for the purpose
    • reputation and topic_updates could be moved here (to make the table not include column from Forum module)
    • instead of setting password_method to 'enjin-import' to determine if a user has been imported from Enjin, we could attach some meta like enjin-imported to true
  • (maybe) create nl2_users_tfa to cleanup the nl2_users table more, since tfa accounts for 4 columns

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions