Project background: Creating a mutli user strategy flash game for use on a website. I am weak when it comes to designing the serverside DB. The DB will be done in MYSQL, right now im using the innoDB structure, but you as the professional in this field can use whatever works best.
Needed: I need several tables for example:
Users table that stores the login information for each registered player.
Empires table that stores information for each User who after registering has created their empire.
Units table that stores information for the user/empires army. Note: Each unit can gain experience and increase in rank.
Possibly a Squad table that stores what 'units' are grouped together. Note: Squads can be deployed at different locations on map, and move, attack, and defend as 'one'.
Possibly a Squad_movement table that stores the squads that have been ordered to move to a new location on map at the next turn.
Buildings_completed table that stores what buildings, and what locations the user/empire has finished making.
Buildings_in_progress table that stores buildings that are being created by the user/empire, along with when they were started and when they will be finished.
Research_completed same as above, but stores research instead of buildings.
Research_in_progress same as above, but stores research instead of buildings.
These are the basics of what im looking for. Keep in mind im looking for a design template that I can expand. I know enough about MySQL to add more to the research and buildings tree as needed. So hopefuly this wouldnt take more than a few hours at the most. Also im looking for data integrity, so when a player is banned or quits, units should be removed (foreign key) while buildings should remain.
Also there may be a few more features that I need to be integreted, but failed to mention because im not sure if they would be included in another table, or would need their own table.
Misc: I will run a cron job at set intervals to progress the game to the next turn. It will check what the user has and update things like resources, building process, player movement etc.
If you have any questions, drop me a line.
I require a document plan so as to give a brief overview of how you plan to accomplish this task. The ideal canidate has experience directly related to online games and server side development. He/She will speak clear english, and be readily available preferrably via MSN untill project is completed. Please don't submit bid holders w/o giving an estimate.