Authorization Tables

account

This table contains all the information for a users account.

Columns

• id
  This is the primary key

• email
  The email address associated with the account

• username
  The users chosen username when registering

• password
  A hashed value

• salt
  Unique to each user

• level
  An accounts access level.

• last_ip Last ip address client connected from

• last_server_id
  Last server ID the player connected to.

• last_login
  Last date when the user logged in

• join_date
  What account was created

• locked
  Whether the users has been locked out of the account aka hit by the ban hammer

• validated
  User has validated their account via email

• validation_token
  Token sent to the users email for validation

Notes

Lock outs will be expanded to note reasons.

Level is still being worked on, but will use a number -> level. 1 => User, 2=> GameMaster, 3 => Admin