Hey everyone. I am currently in the process of designing a browser based PHP game. I was wondering if anyone had some advice on the databse design. Currently I have 5 tables within one database. They are very basic, used for user monitoring i.e. user, active_users, banned_users, active_guests. THe other table I have is a "family" or clan database that lets people join groups of others in a sort of gang.
Now I'm kind of stuck. I would like to implement features like exploring the map, visiting stores, buying/selling, global market, attacking other players, and each player should have their own inventory. One other idea I have is for people to have their own territories where they can mine, farm, cut down wood, etc. Any acvice on how I should design this database would be more than apprecieated.