Find Jobs
Hire Freelancers

MySQL DB Design

$30-250 USD

キャンセル
投稿日: 15年以上前

$30-250 USD

完了時にお支払い
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.
プロジェクト ID: 323644

プロジェクトについて

7個の提案
リモートプロジェクト
アクティブ 16年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です

クライアントについて

UNITED STATESのフラグ
Ocoee, United States
5.0
8
お支払い方法確認済み
メンバー登録日:3月 25, 2008

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。