Rework database structure

[TheDoctor0]

0. Database manager plugin:

• initial database schema creator
• migrations support
• handles cod_players table
• executes all ignore_handle queries to database

1. cod_players (Primary key: player_id)

• player_id
• player_admin
• player_steamid
• player_name
• player_password (encrypted)
• player_honor (replace separate cod_honor tasble)
• player_knife (replace nvault in cod_knife plugin)
• player_bonus (replace nvault in cod_free_honor plugin)
• player_exchange (enable/disable exchange offers)

2. cod_classes (Primary key: player_id, class_id)

• player_id (foreign key from cod_players table)
• class_id (unique
• class_name
• class_experience
• class_level
• class_intelligence
• class_health
• class_stamina
• class_condition
• class_strength

3. cod_stats (Primary key: player_id)

• player_id (foreign key from cod_players table)
• stats_kills
• stats_time
• stats_first_visit
• stats_last_visit
• stats_medals_bronze
• stats_medals_silver
• stats_medals_gold
• stats_best_kills
• stats_best_hs
• stats_best_deaths

4. cod_missions (Primary key: player_id, class_id)

• player_id (foreign key from cod_player table)
• class_id (foreign key from cod_classes table)
• mission_id
• mission_type
• mission_additional
• mission_progress
• mission_chapter

5. cod_clans (Primary key: clan_id)

• clan_id
• clan_name
• clan_honor
• clan_kills
• clan_level
• clan_wins
• clan_health
• clan_gravity
• clan_damage
• clan_experience

6. cod_clans_members (Primary key: player_id)

• player_id (foreign key from cod_player table)
• member_clan_id (foreign key from cod_clans table)
• member_flag
• member_donations

7. cod_clans_applications (Primary key: player_id, clan_id)

• player_id (foreign key from cod_player table)
• clan_id (foreign key from cod_clans table)
• text

8. cod_clans_wars (Primary key: war_id)

• war_id
• war_attacker_clan_id (foreign key from cod_clans table)
• war_defender_clan_id (foreign key from cod_clans table)
• war_attacker_progress
• war_defender_progress
• war_duration
• war_reward
• war_started