[Vince]

Please normalize. If I had to design this data structure it would look somewhat like this (see attachment). There's still too many columns in the User table to my liking but I've managed to relocate at least 22 columns to other tables.



The added benefits:

• A user can be a member of unlimited factions.
• Player can own unlimited toys.(*)
• Player can own unlimited weapons.(*)
• You can store unlimited types of drugs.
• Player can own unlimited types of drugs.

(*) yes I know there are only 10 attachment slots and 13 weapon slots, but that doesn't mean that you should create new columns. If new attachment slots get added later you don't need to change your database at all.