17.08.2013, 15:02
1. Add field to users table, called banID, with NULL allowed values
2. Create table bans
3. Create relation between banID in users table, with id in bans table
4. Store all bans history in bans table, but keep only most recent in banID field for specific user (or NULL if user isn't banned)
5. You can also add userID field in bans table, with relation to users.id field, so your bans history track can be more useful
2. Create table bans
3. Create relation between banID in users table, with id in bans table
4. Store all bans history in bans table, but keep only most recent in banID field for specific user (or NULL if user isn't banned)
5. You can also add userID field in bans table, with relation to users.id field, so your bans history track can be more useful