Storage module for players and related data

[urt30plus]

Need to save player info such as guid, auth and names, including aliases and ip address info. Also need to store group level and stats.

[urt30plus]

Some table ideas, should auth be required in order to track a player? We could use guid in place of auth, GUID:<guid> as the format in the auth field?

players

• id
• auth
• group
• xp
• guid
• name
• ip_address (is needed??)
• created_at
• updated_at

connections

• pid
• created_at

aliases If name doesn't match name on players table

addresses If IP doesn't match up on players table Do we really need to track ip address?

guids If guid doesn't match guid on players table

penalties

• pid
• kind
• duration
• reason
• created_by
• created_at
• expires_at

hall_of_fame (hof)

• map_name
• pid
• kind
• score

kv_store (could be used instead of hof table)

• key
• value