PFM Schema Update Thread

[q12]

Attila
'unknown3' column contains event picture filename (without png)
so I named it 'eventpic filename'

  <table table_name='event_feed_message_events_tables'
         table_version='2' >
    <field name='unknown0' type='string_ascii' />
    <field name='unknown1' type='string_ascii' />
    <field name='unknown2' type='string_ascii' />
    <field name='eventpic filename' type='string_ascii' />
    <field name='unknown4' type='string_ascii' />
    <field name='unknown5' type='string_ascii' />
    <field name='unknown6' type='string_ascii' />
    <field name='unknown7' type='string_ascii' />
    <field name='unknown8' type='optstring_ascii' />
    <field name='unknown9' type='string_ascii' />
  </table>

[Genreless]

Changes to Rome 2 schemas: (part one because I hit the post length limit...)

New Schemas:

  <table table_name='land_units_tables'
         table_version='44' >
    <field name='accuracy' type='int' />
    <field name='ammo' type='int' />
    <field fkey='unit_armour_types_tables.key' name='armour' type='string_ascii' />
    <field name='campaign_action_points' type='int' />
    <field fkey='unit_category_tables.key' name='category' type='string_ascii' />
    <field name='charge_bonus' type='int' />
    <field fkey='unit_class_tables.key' name='class' type='string_ascii' />
    <field name='dismounted_charge_bonus' type='int' />
    <field name='dismounted_melee_attack' type='int' />
    <field name='dismounted_melee_defence' type='int' />
    <field fkey='unit_description_historical_texts_tables.key' name='historical_description_text' type='string_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='battle_animations_tables.key' name='man_animation' type='optstring_ascii' />
    <field fkey='battle_entities_tables.key' name='man_entity' type='string_ascii' />
    <field name='melee_attack' type='int' />
    <field name='melee_defence' type='int' />
    <field name='morale' type='int' />
    <field name='bonus_hit_points' type='int' />
    <field fkey='mounts_tables.key' name='mount' type='optstring_ascii' />
    <field name='num_animals' type='int' />
    <field fkey='animals_tables.key' name='animal' type='optstring_ascii' />
    <field name='num_mounts' type='int' />
    <field fkey='melee_weapons_tables.key' name='primary_melee_weapon' type='string_ascii' />
    <field fkey='missile_weapons_tables.key' name='primary_missile_weapon' type='optstring_ascii' />
    <field name='rank_depth' type='int' />
    <field fkey='unit_shield_types_tables.key' name='shield' type='string_ascii' />
    <field fkey='unit_description_short_texts_tables.key' name='short_description_text' type='string_ascii' />
    <field fkey='unit_spacings_tables.key' name='spacing' type='string_ascii' />
    <field fkey='unit_description_strengths_weaknesses_texts_tables.key' name='strengths_weaknesses_text' type='string_ascii' />
    <field name='supports_first_person' type='boolean' />
    <field name='training_level' type='string_ascii' />
    <field name='num_guns' type='int' />
    <field fkey='land_units_officers_tables.key' name='officers' type='string_ascii' />
    <field fkey='land_unit_articulated_vehicles_tables.key' name='articulated_record' type='optstring_ascii' />
    <field fkey='battlefield_engines_tables.key' name='engine' type='optstring_ascii' />
    <field name='is_male' type='boolean' />
    <field name='visibility_spotting_range_min' type='float' />
    <field name='visibility_spotting_range_max' type='float' />
    <field name='ability_global_recharge' type='float' />
    <field fkey='unit_attributes_groups_tables.group_name' name='attribute_group' type='optstring_ascii' />
    <field name='spot_dist_tree' type='float' />
    <field name='spot_dist_scrub' type='float' />
    <field fkey='battlefield_chariots_tables.key' name='chariot' type='optstring_ascii' />
    <field name='num_chariots' type='int' />
    <field name='reload' type='int' />
    <field name='loose_spacing' type='boolean' />
    <field fkey='spotting_and_hiding_values_tables.key' name='spotting_and_hiding' type='optstring_ascii' />
    <field name='selection_vo' type='string_ascii' />
    <field name='selected_vo_secondary' type='string_ascii' />
    <field name='selected_vo_tertiary' type='string_ascii' />
    <field name='hiding_scalar' type='float' />
  </table>
  <table table_name='unit_shield_types_tables'
         table_version='7' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='shield_defence_value' type='int' />
    <field name='shield_armour_value' type='int' />
    <field name='audio_material' type='string_ascii' />
    <field name='missile_block_chance' type='int' />
  </table>
  <table table_name='naval_units_tables'
         table_version='21' >
    <field name='campaign_action_points' type='int' />
    <field fkey='unit_category_tables.key' name='category' type='string_ascii' />
    <field fkey='unit_class_tables.key' name='class' type='string_ascii' />
    <field fkey='unit_description_historical_texts_tables.key' name='historical_description_text' type='string_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='ship_dbs_tables.key' name='ship' type='string_ascii' />
    <field fkey='unit_description_short_texts_tables.key' name='short_description_text' type='string_ascii' />
    <field fkey='unit_description_strengths_weaknesses_texts_tables.key' name='strengths_weaknesses_text' type='string_ascii' />
    <field name='unit_type_icon' type='optstring_ascii' />
    <field fkey='unit_attributes_groups_tables.group_name' name='attribute_groups' type='optstring_ascii' />
    <field fkey='naval_weapons_tables.key' name='primary_naval_weapon' type='optstring_ascii' />
    <field fkey='naval_weapons_tables.key' name='secondary_naval_weapon' type='optstring_ascii' />
    <field name='rank_depth' type='int' />
    <field name='supports_first_person' type='boolean' />
    <field name='can_board' type='boolean' />
    <field name='unit_card' type='string_ascii' />
    <field name='is_composite' type='boolean' />
    <field name='ignition_threshold' type='int' />
    <field name='can_ram' type='boolean' />
  </table>
  <table table_name='agents_tables'
         table_version='10' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='move_points' type='int' />
    <field name='line_of_sight' type='int' />
    <field name='playable' type='boolean' />
    <field name='porttrait_override' type='optstring_ascii' />
    <field fkey='agent_attributes_tables.key' name='primary_attribute' type='string_ascii' />
    <field fkey='religions_tables.religion_key' name='religion' type='optstring_ascii' />
    <field name='faction_total_cap' type='int' />
    <field name='cost' type='int' />
    <field name='in_encyclopedia' type='boolean' />
  </table>
  <table table_name='ancillaries_tables'
         table_version='17' >
    <field fkey='ancillary_info_tables.ancillary' name='key' type='string_ascii' pk='true' />
    <field fkey='ancillary_type_tables.type' name='type' type='string_ascii' />
    <field name='applies_to' type='string_ascii' />
    <field name='transferrable' type='boolean' />
    <field name='unique_to_world' type='boolean' />
    <field name='unique_to_faction' type='boolean' />
    <field name='precedence' type='int' />
    <field name='start_date' type='int' />
    <field name='end_date' type='int' />
    <field name='avatar_skill' type='optstring_ascii' />
    <field name='avatar_special_ability' type='optstring_ascii' />
    <field name='legendary_item' type='boolean' />
    <field name='mp_exclusive' type='boolean' />
    <field name='wife_ancillary' type='boolean' />
    <field name='husband_ancillary' type='boolean' />
    <field name='diplomatic_ancillary' type='boolean' />
    <field name='dynastic_ancillary' type='boolean' />
    <field fkey='cultures_subcultures_tables.subculture' name='spouse_subculture' type='optstring_ascii' />
  </table>
  <table table_name='audio_vo_actor_groups_tables'
         table_version='3' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='actor_1' type='string_ascii' />
    <field name='actor_2' type='optstring_ascii' />
    <field name='actor_3' type='optstring_ascii' />
    <field name='actor_4' type='optstring_ascii' />
    <field name='actor_5' type='optstring_ascii' />
    <field name='actor_6' type='optstring_ascii' />
    <field name='actor_7' type='optstring_ascii' />
    <field name='actor_8' type='optstring_ascii' />
    <field name='actor_9' type='optstring_ascii' />
    <field name='actor_10' type='optstring_ascii' />
    <field name='actor_11' type='optstring_ascii' />
    <field name='actor_12' type='optstring_ascii' />
    <field name='actor_13' type='optstring_ascii' />
    <field name='actor_14' type='optstring_ascii' />
    <field name='actor_15' type='optstring_ascii' />
  </table>
  <table table_name='banditry_events_tables'
         table_version='1' >
    <field name='maximum_banditry' type='int' />
    <field fkey='message_events_tables.event' name='message_event' type='string_ascii' />
    <field name='minimum_banditry' type='int' />
    <field name='name' type='string_ascii' pk='true' />
    <field fkey='effect_bundles.key' name='province_effect_bundle' type='string_ascii' />
    <field name='weight' type='int' />
  </table>
  <table table_name='banditry_events_tables'
         table_version='2' >
    <field name='maximum_banditry' type='int' />
    <field fkey='message_events_tables.event' name='message_event' type='string_ascii' />
    <field name='minimum_banditry' type='int' />
    <field name='name' type='string_ascii' pk='true' />
    <field fkey='effect_bundles.key' name='province_effect_bundle' type='string_ascii' />
    <field name='weight' type='int' />
    <field name='duration' type='int' />
  </table>
  <table table_name='battle_autoresolver_balances_tables'
         table_version='1' >
    <field name='melee_potential_multiplier' type='float' />
    <field name='missile_potential_multiplier' type='float' />
    <field fkey='unit_class_tables.key' name='source_unit_class' type='string_ascii' pk='true' />
    <field fkey='unit_class_tables.key' name='target_unit_class' type='string_ascii' pk='true' />
  </table>
  <table table_name='building_levels_tables'
         table_version='17' >
    <field name='level_name' type='string_ascii' pk='true' />
    <field fkey='building_chains_tables.key' name='chain' type='string_ascii' />
    <field name='level' type='int' />
    <field name='condition' type='optstring_ascii' />
    <field name='only_in_capital' type='boolean' />
    <field name='create_time' type='int' />
    <field name='create_cost' type='int' />
    <field name='upkeep_cost' type='int' />
    <field name='demolition_cost' type='int' />
    <field name='zoc' type='float' />
    <field name='lower_happiness' type='int' />
    <field name='upper_happiness' type='int' />
    <field name='repression' type='int' />
    <field name='gdp' type='int' />
    <field name='town_wealth_growth' type='int' />
    <field name='pop_change' type='float' />
    <field name='maxpop_change' type='float' />
    <field fkey='commodities_tables.key' name='commodity' type='optstring_ascii' />
    <field name='commodity_vol' type='int' />
    <field name='building_category' type='optstring_ascii' />
    <field fkey='government_types_tables.government_type' name='gov_type_key' type='optstring_ascii' />
    <field name='unknown_22' type='boolean' />
    <field name='military_prestige' type='int' />
    <field name='naval_prestige' type='int' />
    <field name='economic_prestige' type='int' />
    <field name='enlightenment_prestige' type='int' />
    <field name='unknown_27' type='optstring_ascii' />
    <field name='destruction_terminator' type='boolean' />
    <field name='faction_unique' type='boolean' />
    <field fkey='religions_tables.religion_key' name='religion_requirement' type='optstring_ascii' />
    <field fkey='effect_bundles_tables.key' name='first_in_world_bundle' type='optstring_ascii' />
    <field fkey='resources_tables.key' name='resource_requirement' type='optstring_ascii' />
    <field fkey='warscape_rigid_tables.key' name='working_model' type='string_ascii' />
    <field name='unique_index' type='int' />
    <field name='can_convert' type='boolean' />
    <field fkey='building_instances_tables.key' name='building_instance_key' type='optstring_ascii' />
    <field fkey='audio_campaign_building_enums_tables.key' name='audio_building_type' type='string_ascii' />
    <field name='should_show_building_level_in_ui_for_technology' type='boolean' />
    <field name='is_new' type='boolean' />
  </table>
  <table table_name='building_to_unit_abilities_junctions_tables'
         table_version='1' >
    <field fkey='unit_abilities_tables.key' name='ability' type='string' pk='true' />
    <field fkey='battlefield_buildings_tables.key' name='building_name' type='string' pk='true' />
  </table>
  <table table_name='building_units_allowed_tables'
         table_version='5' >
    <field fkey='building_levels_tables.level_name' name='building' type='string_ascii' />
    <field fkey='main_units_tables.unit' name='unit' type='string_ascii' />
    <field name='xp' type='int' />
    <field name='conditions' type='optstring_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown5' type='int' />
    <field fkey='factions_tables.key' name='faction' type='optstring_ascii' />
    <field name='enabled' type='boolean' />
  </table>
  <table table_name='cai_agent_distribution_profiles_tables'
         table_version='1' >
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_agent_recruitment_profiles_tables'
         table_version='1' >
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_personalities_construction_preference_policies_tables'
         table_version='1' >
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_personalities_construction_preference_policy_building_junctions_tables'
         table_version='3' >
    <field name='bias_level' type='float' />
    <field fkey='building_levels_tables.level_name' name='building_key' type='string_ascii' pk='true' />
    <field fkey='cai_personalities_construction_prefence_policies_tables.key' name='policy_key' type='string_ascii' pk='true' />
    <field name='absolute_adjustment' type='float' />
    <field name='building_discount_limit_adjustment' type='int' />
  </table>
  <table table_name='cai_personalities_faction_junctions_tables'
         table_version='1' >
    <field fkey='campaigns_tables.campaign_name' name='campaign_key' type='string_ascii' pk='true' />
    <field fkey='cai_personalities_tables.key' name='default_personality' type='string_ascii' />
    <field fkey='factions_tables.key' name='faction_key' type='string_ascii' pk='true' />
    <field fkey='cai_personalities_random_groups_tables.random_personality_group_key' name='personality_group' type='string_ascii' />
    <field fkey='cai_personalities_randomisation_policies_tables.randomisation_policy_key' name='randomisation_policy_key' type='string_ascii' />
  </table>
  <table table_name='cai_personalities_income_allocation_policies_tables'
         table_version='3' >
    <field name='default_positive_net_income_survival_rounds' type='int' />
    <field name='default_proportion_of_net_income_to_spend' type='float' />
    <field name='defualt_zero_or_negative_net_income_survival_rounds' type='int' />
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='ancillary_to_excluded_ancillaries_tables'
         table_version='1' >
    <field fkey='ancillary_info_tables.ancillary' name='ancillary' type='string_ascii' pk='true' />
    <field fkey='ancillary_info_tables.ancillary' name='excluded_ancillary' type='string_ascii' pk='true' />
  </table>
  <table table_name='battle_bridge_subculture_jcts_tables'
         table_version='1' >
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='string' pk='true' />
    <field fkey='battlefield_buildings_tables.key' name='simple_bridge' type='string_ascii' />
    <field fkey='battlefield_buildings_tables.key' name='refined_bridge' type='string_ascii' />
  </table>
  <table table_name='battle_city_subculture_jct_tables'
         table_version='1' >
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='string_ascii' pk='true' />
    <field fkey='battle_cities_tables.city' name='city' type='string_ascii' />
  </table>
  <table table_name='battle_sequences_tables'
         table_version='1' >
    <field fkey='battles_tables.key' name='battle' type='string_ascii' pk='true' />
    <field name='unlock_order' type='int' />
  </table>
  <table table_name='battles_tables'
         table_version='12' >
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='battle_types_tables.type' name='type' type='string_ascii' />
    <field name='is_naval' type='boolean' />
    <field name='specification' type='string_ascii' />
    <field name='screenshot_path' type='optstring_ascii' />
    <field name='map_path' type='optstring_ascii' />
    <field name='team_size_1' type='int' />
    <field name='team_size_2' type='int' />
    <field name='release' type='boolean' />
    <field name='multiplayer' type='boolean' />
    <field name='singleplayer' type='boolean' />
    <field name='intro_movie' type='optstring_ascii' />
    <field name='year' type='int' />
    <field name='defender_funds_ratio' type='float' />
    <field name='has_key_buildings' type='boolean' />
    <field name='matchmaking' type='boolean' />
    <field name='playable_area_width' type='float' />
    <field name='playable_area_height' type='float' />
    <field name='is_large_settlement' type='boolean' />
    <field name='has_15m_walls' type='boolean' />
  </table>
  <table table_name='battle_type_faction_presets_tables'
         table_version='2' >
    <field fkey='factions_tables.key' name='faction' type='string_ascii' pk='true' />
    <field fkey='battle_type_setup_limits_tables.id' name='weighting_type' type='int' pk='true' />
    <field name='id' type='int' />
    <field name='unknown4' type='int' />
  </table>
  <table table_name='battle_unit_permission_junctions_tables'
         table_version='0' >
    <field fkey='battle_types_tables.type' name='battle_type' type='string_ascii' pk='true' />
    <field fkey='main_units_tables.unit' name='unit' type='string_ascii' pk='true' />
  </table>
  <table table_name='battlefield_snow_props_tables'
         table_version='1' >
    <field fkey='battlefield_buildings_tables.key' name='prop' type='string_ascii' pk='true' />
    <field name='enable_for_snow' type='boolean' pk='true' />
  </table>
  <table table_name='building_culture_gov_type_variants_tables'
         table_version='1' >
    <field fkey='building_levels_tables.level_name' name='building' type='string_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' pk='true' />
    <field fkey='government_types_tables.government_type' name='government_type' type='string_ascii' pk='true' />
    <field fkey='warscape_rigid_tables.key' name='artpiece' type='optstring_ascii' />
    <field fkey='warscape_animated_tables.key' name='artpiece_animated' type='optstring_ascii' />
    <field name='description' type='string_ascii' />
    <field name='icon' type='optstring_ascii' />
    <field name='short_description' type='string_ascii' />
  </table>
  <table table_name='building_faction_variants_tables'
         table_version='1' >
    <field fkey='building_levels_tables.level_name' name='building' type='string_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction' type='string_ascii' pk='true' />
    <field fkey='warscape_rigid_tables.key' name='artpiece' type='optstring_ascii' />
    <field fkey='building_description_texts_tables.key' name='description' type='string_ascii' />
    <field name='icon' type='optstring_ascii' />
    <field name='short_description' type='string_ascii' />
  </table>
  <table table_name='building_factionwide_effects_junctions_tables'
         table_version='1' >
    <field fkey='building_levels_tables.level_name' name='building' type='string_ascii' pk='true' />
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field name='effect_value' type='float' />
  </table>
  <table table_name='cai_construction_system_synergies_tables'
         table_version='2' >
    <field fkey='building_chains_tables.key' name='existing_building_chain_key' type='optstring_ascii' pk='true' />
    <field fkey='building_levels_tables.level_name' name='existing_building_level_inclusive_end' type='optstring_ascii' pk='true' />
    <field fkey='building_levels_tables.level_name' name='existing_building_level_inclusive_start' type='optstring_ascii' pk='true' />
    <field fkey='building_chains_tables.key' name='potential_buiding_chain_key' type='optstring_ascii' pk='true' />
    <field fkey='building_levels_tables.level_name' name='potential_building_level_inclusive_end' type='optstring_ascii' pk='true' />
    <field fkey='building_levels_tables.level_name' name='potential_building_level_inclusive_start' type='optstring_ascii' pk='true' />
    <field fkey='cai_construction_system_synergy_levels_tables.key' name='synergy_level_key' type='string_ascii' />
    <field fkey='cai_construction_system_synergy_policies_tables.key' name='synergy_policy_key' type='string_ascii' pk='true' />
    <field fkey='building_instances_tables.key' name='existing_building_instance' type='optstring_ascii' pk='true' />
    <field fkey='building_superchains_tables.key' name='existing_building_super_chain' type='string_ascii' pk='true' />
    <field fkey='building_instances_tables.key' name='potential_building_instance' type='optstring_ascii' pk='true' />
    <field fkey='building_superchains_tables.key' name='potential_building_super_chain' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_personalities_random_groups_tables'
         table_version='1' >
    <field name='random_personality_group_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_personalities_reliability_policies_tables'
         table_version='6' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='join_ally_bias' type='float' />
  </table>
  <table table_name='cai_personalities_tms_task_generator_profiles_strategic_contexts_junctions_tables'
         table_version='1' >
    <field name='for_use_when_the_faction_has_regions' type='boolean' pk='true' />
    <field fkey='cai_task_management_system_task_generator_groups_tables.key' name='generator_group_key' type='string_ascii' />
    <field fkey='cai_strategic_context_types_tables.key' name='strategic_context_key' type='string_ascii' pk='true' />
    <field fkey='cai_personalities_task_management_system_task_generator_profiles_tables.key' name='task_generator_profile_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_personality_occupation_decision_components_tables'
         table_version='3' >
    <field name='food_excess_cap' type='int' />
    <field name='food_shortage_cap' type='int' />
    <field name='id' type='string_ascii' pk='true' />
    <field name='min_attitude' type='int' />
    <field name='squalor_cap' type='int' />
  </table>
  <table table_name='cai_personality_occupation_decision_priorities_tables'
         table_version='3' >
    <field fkey='cai_personality_occupation_decision_components_tables.id' name='component_id' type='string_ascii' pk='true' />
    <field name='last_stand_priority' type='float' />
    <field name='option' type='string_ascii' pk='true' />
    <field name='peace_priority' type='float' />
    <field name='tension_priority' type='float' />
    <field name='total_war_priority' type='float' />
    <field name='war_priority' type='float' />
  </table>
  <table table_name='cai_siege_strength_modifiers_tables'
         table_version='1' >
    <field name='assault_strength_modifier' type='float' />
    <field name='defence_strength_modifier' type='float' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_task_management_system_task_generator_groups_generators_junctions_tables'
         table_version='1' >
    <field name='priority' type='float' />
    <field fkey='cai_task_management_system_task_generator_groups_tables.key' name='task_generator_group_key' type='string_ascii' pk='true' />
    <field fkey='cai_task_management_system_task_generators_tables.key' name='task_generator_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_task_management_system_task_generators_tables'
         table_version='1' >
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cai_variables_overides_tables'
         table_version='1' >
    <field fkey='cai_variables_tables.key' name='cai_variable_key' type='string_ascii' pk='true' />
    <field fkey='campaigns_tables.key' name='campaign_key' type='string_ascii' pk='true' />
    <field name='optional_campaign_type' type='optstring_ascii' pk='true'/>
    <field name='optional_difficulty_level' type='optstring_ascii' pk='true' />
    <field name='value' type='float' />
  </table>
  <table table_name='cai_variables_tables'
         table_version='1' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='value' type='float' />
    <field name='description' type='string_ascii' />
  </table>
  <table table_name='campaign_ai_managers_tables'
         table_version='1' >
    <field name='manager' type='string_ascii' pk='true' />
  </table>
  <table table_name='campaign_character_art_set_campaign_junctions_tables'
         table_version='0' >
    <field fkey='campaign_character_art_sets_tables.art_set_id' name='art_set_id' type='string_ascii' />
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown3' type='int' />
  </table>
  <table table_name='campaign_character_art_sets_campaign_groups_tables'
         table_version='1' >
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='campaign_character_art_sets_group_junctions_tables'
         table_version='1' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' pk='true' />
    <field fkey='campaign_character_art_sets_campaign_groups_tables.key' name='group' type='string_ascii' pk='true' />
  </table>
  <table table_name='campaign_character_art_sets_tables'
         table_version='7' >
    <field fkey='agents_tables.key' name='agent_type' type='optstring_ascii' />
    <field name='art_set_id' type='string_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='optstring_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='optstring_ascii' />
    <field fkey='factions_tables.key' name='faction' type='optstring_ascii' />
    <field name='is_custom' type='boolean' />
    <field name='is_male' type='boolean' />
    <field fkey='campaign_character_art_sets_campaign_groups_tables.key' name='group' type='optstring_ascii' />
  </table>
  <table table_name='campaign_clan_level_infos_tables'
         table_version='1' >
    <field name='clan_level' type='int' pk='true' />
    <field fkey='effect_bundles_tables.key' name='effect_bundle' type='string_ascii' />
    <field name='modernisation_threshold' type='int' />
    <field fkey='factions_tables.key' name='optional_faction_key' type='optstring_ascii' pk='true' />
    <field name='technology_unlock_level' type='int' />
    <field name='optional_difficulty_level' type='optstring_ascii' pk='true' />
  </table>
  <table table_name='campaign_effect_scope_character_unit_relationship_junctions_tables'
         table_version='0' >
    <field fkey='campaign_effect_scopes_tables.key' name='campaign_effect_scope_key' type='string_ascii' pk='true' />
    <field name='unit_relationship_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='campaign_map_slots_tables'
         table_version='1' >
    <field name='slot_id' type='string_ascii' pk='true' />
    <field fkey='regions_tables.key' name='region' type='string_ascii' />
    <field fkey='slots_tables.slot' name='slot_type' type='string_ascii' />
    <field fkey='campaign_map_slots_templates_tables.template_name' name='template' type='string_ascii' />
    <field name='rotation' type='int' />
    <field fkey='warscape_underlay_textures_tables.underlay_key' name='underlay' type='optstring_ascii' />
  </table>
  <table table_name='campaign_map_towns_and_ports_tables'
         table_version='1' >
    <field name='town_id' type='string_ascii' pk='true' />
    <field fkey='slots_tables.slot' name='slot_type' type='string_ascii' />
    <field name='onscreen_name' type='string_ascii' />
    <field fkey='campaign_map_slots_templates_tables.template_name' name='template' type='string_ascii' />
  </table>
  <table table_name='campaign_subject_evolution_links_tables'
         table_version='0' >
    <field fkey='campaign_subject_evolutions_tables.key' name='child' type='string_ascii' pk='true' />
    <field fkey='campaign_subject_evolutions_tables.key' name='parent' type='string_ascii' pk='true' />
  </table>
  <table table_name='campaign_walk_anim_sets_tables'
         table_version='2' >
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='anim_reference_poses_tables.key' name='reference_pose' type='string_ascii' />
    <field name='pre_step_to' type='string_ascii' />
    <field name='step_to' type='string_ascii' />
    <field name='post_step_to' type='string_ascii' />
    <field name='pre_stand_to_walk' type='string_ascii' />
    <field name='stand_to_walk' type='string_ascii' />
    <field name='stand_to_walk_distance' type='float' />
    <field name='walk' type='string_ascii' />
    <field name='walk_distance' type='float' />
    <field name='walk_to_stand' type='string_ascii' />
    <field name='mid_walk_to_stand' type='string_ascii' />
    <field name='walk_to_stand_distance' type='float' />
    <field name='post_walk_to_stand' type='string_ascii' />
    <field name='post_mid_walk_to_stand' type='string_ascii' />
  </table>
  <table table_name='cdir_events_dilemma_followup_dilemmas_tables'
         table_version='1' >
    <field fkey='cdir_events_dilemma_choices_tables.choice_key' name='choice_key' type='string_ascii' pk='true' />
    <field fkey='dilemmas_tables.key' name='dilemma_key' type='string_ascii' pk='true' />
    <field fkey='dilemmas_tables.key' name='followup_dilemma_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cdir_events_incident_followup_incidents_tables'
         table_version='1' >
    <field fkey='incidents_tables.key' name='incident_key' type='string_ascii' pk='true' />
    <field fkey='incidents_tables.key' name='followup_incident_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cdir_events_incident_followup_missions_tables'
         table_version='1' >
    <field fkey='incidents_tables.key' name='incident_key' type='string_ascii' pk='true' />
    <field fkey='missions_tables.key' name='followup_mission_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cdir_events_mission_followup_dilemmas_tables'
         table_version='1' >
    <field fkey='missions_tables.key' name='mission_key' type='string_ascii' pk='true' />
    <field fkey='cdir_events_mission_statuses_tables.status_key' name='status_key' type='string_ascii' pk='true' />
    <field fkey='dilemmas_tables.key' name='followup_dilemma_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cdir_events_mission_followup_missions_tables'
         table_version='1' >
    <field fkey='mission_tables.key' name='mission_key' type='string_ascii' pk='true' />
    <field fkey='cdir_events_mission_statuses_tables.status_key' name='status_key' type='string_ascii' pk='true' />
    <field fkey='missions_tables.key' name='followup_mission_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cdir_events_mission_incidents_tables'
         table_version='1' >
    <field fkey='incidents_tables.key' name='incident_key' type='string_ascii' pk='true' />
    <field fkey='missions_tables.key' name='mission_key' type='string_ascii' pk='true' />
    <field fkey='cdir_events_mission_statuses_tables.status_key' name='status_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='character_skill_nodes_tables'
         table_version='6' >
    <field fkey='campaigns_tables.campaign_name' name='campaign_key' type='optstring_ascii' />
    <field fkey='character_skills_tables.key' name='character_skill_key' type='string_ascii' />
    <field fkey='character_skill_node_sets_tables.key' name='character_skill_node_set_key' type='string_ascii' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' />
    <field name='indent' type='int' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='tier' type='int' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='optstring_ascii' />
  </table>
  <table table_name='culture_subculture_politics_government_types_tables'
         table_version='5' >
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' pk='true' />
    <field fkey='politics_government_types_tables.government_type' name='government_type' type='string_ascii' pk='true' />
    <field name='on_screen_name_faction_leader' type='optstring_ascii' />
    <field name='on_screen_name_government_type' type='string_ascii' />
    <field fkey='factions_tables.key' name='faction' type='optstring_ascii' pk='true' />
    <field fkey='effect_bundles_tables.key' name='effect_bundle' type='optstring_ascii' />
    <field name='is_default' type='boolean' />
    <field fkey='trait_info_tables.trait' name='faction_leader_trait' type='string_ascii' />
    <field name='on_screen_name_faction_leader_female' type='optstring_ascii' />
    <field fkey='trait_info_tables.trait' name='faction_leader_trait_female' type='string_ascii' />
  </table>
  <table table_name='deployables_tables'
         table_version='15' >
    <field name='hitpoints' type='int' />
    <field name='how' type='optstring_ascii' />
    <field name='icon_name' type='string_ascii' />
    <field name='in_encyclopaedia' type='boolean' />
    <field name='info_pic' type='string_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='kill_chance' type='float' />
    <field name='min_columns' type='int' />
    <field name='min_rows' type='int' />
    <field fkey='models_deployables_tables.key' name='model' type='string_ascii' />
    <field name='number' type='int' />
    <field name='random_offset' type='float' />
    <field name='spacing_x' type='float' />
    <field name='spacing_y' type='float' />
    <field fkey='ui_unit_stats_tables.key' name='stat_mod' type='optstring_ascii' />
    <field name='value' type='float' />
    <field name='recruitment_cap' type='int' />
    <field name='max_rows' type='int' />
    <field fkey='models_deployables_tables.key' name='model_2' type='optstring_ascii' />
    <field name='ignition_threshold' type='int' />
  </table>
  <table table_name='effect_bonus_value_building_chain_junctions_tables'
         table_version='1' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_bonus_value_ids_building_chain_tables.key' name='bonus_value_id' type='string_ascii' pk='true' />
    <field fkey='building_chains_tables.key' name='building_chain' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_commodity_junction_tables'
         table_version='1' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_bonus_value_ids_commodity_tables.key' name='bonus_value_id' type='string_ascii' pk='true' />
    <field fkey='commodities_tables.key' name='commodity' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_population_class_and_religion_junction_tables'
         table_version='1' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_bonus_value_ids_population_class_and_religion_tables.key' name='bonus_value_id' type='string_ascii' pk='true' />
    <field fkey='population_classes_tables.population_class' name='population_class' type='string_ascii' pk='true' />
    <field fkey='religions_tables.religion_key' name='religion' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_population_class_junction_tables'
         table_version='1' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_bonus_value_ids_population_class_tables.key' name='bonus_value_id' type='string_ascii' pk='true' />
    <field fkey='population_classes_tables.population_class' name='population_class' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_shot_type_junctions_tables'
         table_version='1' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_bonus_value_ids_projectile_shot_type_enum_tables.key' name='bonus_value_id' type='string_ascii' pk='true' />
    <field fkey='projectile_shot_type_enum_tables.key' name='shot_type' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_unit_caste_stat_modifiers_junctions_tables'
         table_version='0' >
    <field fkey='effects_tables.effect' name='caste' type='string_ascii' pk='true' />
    <field fkey='unit_castes_tables.caste' name='effect' type='string_ascii' pk='true' />
    <field fkey='unit_stat_modifiers_tables.key' name='stat_modifier' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_unit_category_stat_modifiers_junctions_tables'
         table_version='0' >
    <field fkey='unit_category_tables.key' name='category' type='string_ascii' pk='true' />
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='unit_stat_modifiers_tables.key' name='stat_modifier' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_unit_class_stat_modifiers_junctions_tables'
         table_version='0' >
    <field fkey='unit_class_tables.key' name='class' type='string_ascii' pk='true' />
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='unit_stat_modifiers_tables.key' name='stat_modifier' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_unit_record_stat_modifiers_junctions_tables'
         table_version='0' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='unit_stat_modifiers_tables.key' name='stat_modifier' type='string_ascii' pk='true' />
    <field fkey='units_tables.key' name='unit' type='string_ascii' pk='true' />
  </table>
  <table table_name='effect_bonus_value_unit_stat_modifiers_junctions_tables'
         table_version='0' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='unit_stat_modifiers_tables.key' name='stat_modifier' type='string_ascii' pk='true' />
  </table>
  <table table_name='events_tables'
         table_version='2' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='picture_category' type='string_ascii' />
    <field name='dynamic' type='boolean' />
    <field name='historical_date' type='int' />
    <field fkey='seasons_tables.season' name='season' type='string_ascii' />
    <field name='conditions' type='optstring_ascii' />
    <field name='picture' type='string' />
    <field name='turn_in_year' type='int' />
  </table>
  <table table_name='faction_variables_optional_overrides_tables'
         table_version='1' >
    <field fkey='campaigns_tables.campaign_name' name='campaign_key' type='optstring_ascii' pk='true' />
    <field name='campaign_type' type='optstring_ascii' pk='true' />
    <field name='difficulty_level' type='optstring_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' pk='true' />
    <field fkey='faction_variables_tables.faction_variable_key' name='faction_variable_key' type='string_ascii' pk='true' />
    <field name='value' type='string_ascii' />
  </table>
  <table table_name='female_character_culture_details_tables'
         table_version='2' >
    <field name='chance_to_spawn' type='int' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' pk='true' />
    <field name='general' type='string_ascii' />
    <field name='missions' type='string_ascii' />
    <field name='public_office' type='string_ascii' />
    <field fkey='trait_info_tables.trait' name='trait' type='optstring_ascii' />
  </table>
  <table table_name='female_character_faction_details_tables'
         table_version='1' >
    <field name='chance_to_spawn' type='int' />
    <field fkey='factions_tables.key' name='faction' type='string_ascii' pk='true' />
    <field name='general' type='optstring_ascii' />
    <field name='missions' type='optstring_ascii' />
    <field name='public_office' type='optstring_ascii' />
    <field fkey='trait_info_tables.trait' name='trait' type='optstring_ascii' />
  </table>
  <table table_name='female_character_subculture_details_tables'
         table_version='2' >
    <field name='chance_to_spawn' type='int' />
    <field name='general' type='optstring_ascii' />
    <field name='missions' type='optstring_ascii' />
    <field name='public_office' type='optstring_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='string_ascii' pk='true' />
    <field fkey='trait_info_tables.trait' name='trait' type='optstring_ascii' />
  </table>
  <table table_name='general_command_star_level_effects_tables'
         table_version='1' >
    <field name='alive_morale_bonus' type='int' />
    <field name='command_star_level' type='int' pk='true' />
    <field name='melee_attack_bonus' type='int' />
    <field name='melee_defence_bonus' type='int' />
    <field name='nearby_morale_bonus' type='int' />
  </table>
  <table table_name='government_types_to_effects_tables'
         table_version='1' >
    <field fkey='government_types_tables.government_type' name='gov_type' type='string_ascii' pk='true' />
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_effect_scopes_tables.key' name='effect_scope' type='string_ascii' />
    <field name='value' type='float' />
  </table>
  <table table_name='gun_type_to_projectiles_tables'
         table_version='2' >
    <field fkey='gun_types_tables.gun_type' name='gun_type' type='string_ascii' pk='true' />
    <field fkey='projectiles_tables.key' name='shot_type' type='string_ascii' pk='true' />
    <field fkey='gun_type_muzzle_flash_enum_tables.key' name='muzzle_flash' type='string_ascii' />
  </table>
  <table table_name='gun_types_tables'
         table_version='3' >
    <field name='gun_type' type='string_ascii' pk='true' />
    <field fkey='battle_entitites_tables.key' name='battle_entity' type='string_ascii' />
    <field fkey='warscape_animated_tables.key' name='model' type='string_ascii' />
    <field fkey='battle_animations_table_tables.key' name='gun_animations_table' type='string_ascii' />
    <field name='equipment_table' type='string_ascii' />
    <field fkey='warscape_rigid_tables.key' name='destroyed_model' type='optstring_ascii' />
    <field fkey='warscape_animated_tables.key' name='destruction_animation' type='optstring_ascii' />
    <field fkey='gun_types_enum_tables.key' name='engine_type' type='string_ascii' />
    <field fkey='battle_entities_tables.key' name='gun_mount_entity' type='optstring_ascii' />
  </table>
  <table table_name='historical_character_traits_tables'
         table_version='1' >
    <field fkey='historical_characters_tables.key' name='character' type='string_ascii' pk='true' />
    <field fkey='character_trait_levels_tables.key' name='trait' type='string_ascii' pk='true' />
  </table>
  <table table_name='historical_characters_tables'
         table_version='8' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='nobility' type='boolean' />
    <field name='gender' type='string_ascii' />
    <field fkey='agents_tables.key' name='agent_type' type='string_ascii' />
    <field fkey='factions_tables.key' name='faction' type='string_ascii' />
    <field name='spawning_window_start' type='int' />
    <field name='spawning_window_end' type='int' />
    <field name='spawn_conditions' type='string_ascii' />
    <field fkey='names_tables.id' name='name_key' type='string_ascii' />
    <field fkey='names_tables.id' name='surname_key' type='optstring_ascii' />
    <field fkey='campaign_character_art_sets_tables.art_set_id' name='art_set_id' type='optstring_ascii' />
    <field fkey='names_tables.id' name='clan_name_key' type='optstring_ascii' />
    <field fkey='names_tables.id' name='other_name_key' type='optstring_ascii' />
    <field fkey='political_parties_tables.key' name='political_party' type='optstring_ascii' />
    <field name='age_start' type='int' />
  </table>
  <table table_name='land_unit_articulated_vehicles_tables'
         table_version='5' >
    <field fkey='warscape_rigid_tables.key' name='ammo_caisson_destroyed_model' type='optstring_ascii' />
    <field fkey='warscape_animated_tables.key' name='ammo_caisson_destruction' type='string_ascii' />
    <field fkey='battle_entities_tables.key' name='ammo_caisson_entity' type='optstring_ascii' />
    <field fkey='warscape_animated_tables.key' name='ammo_caisson_model' type='optstring_ascii' />
    <field fkey='battle_entities_tables.key' name='articulated_entity' type='optstring_ascii' />
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='message_event_strings_tables'
         table_version='4' >
    <field fkey='message_events_tables.event' name='event' type='string_ascii' pk='true' />
    <field fkey='campaigns_tables.campaign_name' name='optional_campaign_key' type='optstring_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' pk='true' />
    <field fkey='message_event_text_tables.key' name='text' type='string_ascii' />
    <field name='image' type='string_ascii' />
    <field name='icon' type='string_ascii' />
    <field name='sound_event' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='optional_subculture' type='optstring_ascii' pk='true' />
  </table>
  <table table_name='military_force_legacy_emblems_tables'
         table_version='4' >
    <field fkey='cultures_tables.key' name='culure_key' type='optstring_ascii' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' />
    <field name='is_army' type='boolean' />
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture_key' type='optstring_ascii' />
    <field name='icon' type='string_ascii' />
    <field name='banner_decorator' type='string_ascii' />
  </table>
  <table table_name='military_force_legacy_names_tables'
         table_version='3' >
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='optstring_ascii' pk='true' />
    <field name='for_army' type='boolean' />
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='optstring_ascii' />
  </table>
  <table table_name='ministerial_position_default_names_tables'
         table_version='1' >
    <field fkey='ministerial_positions_tables.minister_key' name='ministerial_position' type='string_ascii' pk='true' />
    <field fkey='government_types_tables.government_type' name='gov_type' type='string_ascii' pk='true' />
  </table>
  <table table_name='ministerial_positions_by_gov_types_tables'
         table_version='3' >
    <field fkey='factions_tables.key' name='faction' type='string_ascii' pk='true' />
    <field fkey='ministerial_positions_tables.minister_key' name='minister_key' type='string_ascii' pk='true' />
    <field fkey='government_types_tables.government_type' name='government_type' type='string_ascii' pk='true' />
    <field fkey='genders_tables.gender' name='gender' type='string_ascii' pk='true' />
    <field fkey='ministerial_positions_strings_tables.key' name='string' type='optstring_ascii' />
    <field name='loyalty_gained' type='int' />
    <field name='loyalty_on_loss' type='int' />
  </table>
  <table table_name='ministerial_positions_switching_loyalty_effects_tables'
         table_version='1' >
    <field name='loyalty_gained' type='int' />
    <field fkey='ministerial_positions_tables.minister_key' name='position_from' type='string_ascii' pk='true' />
    <field fkey='ministerial_positions_tables.minister_key' name='position_to' type='string_ascii' pk='true' />
  </table>
  <table table_name='ministerial_positions_to_character_effects_tables'
         table_version='1' >
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_effect_scopes_tables.key' name='effect_scope' type='string_ascii' />
    <field name='minister_level' type='int' pk='true' />
    <field name='position' type='string_ascii' pk='true' />
    <field name='ui_id' type='int' />
    <field name='value' type='int' />
  </table>
  <table table_name='ministerial_positions_to_effects_tables'
         table_version='1' >
    <field fkey='ministerial_positions_tables.minister_key' name='position' type='string_ascii' pk='true' />
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='campaign_effect_scopes_tables.key' name='effect_scope' type='string_ascii' />
    <field name='value' type='int' />
    <field name='minister_level' type='int' pk='true' />
    <field name='ui_id' type='int' />
  </table>
  <table table_name='ministerial_positions_to_governorships_tables'
         table_version='1' >
    <field fkey='ministerial_positions_tables.minister_key' name='ministerial_position' type='string_ascii' pk='true' />
    <field fkey='governorships_tables.governorship' name='governorship' type='string_ascii' pk='true' />
  </table>
  <table table_name='models_building_tables'
         table_version='9' >
    <field name='display_path' type='optstring_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='model_file' type='string_ascii' />
    <field name='unknown4' type='int' />
    <field name='unknown5' type='list' >
      <field name='unknown6' type='string' />
      <field name='unknown7' type='int' />
      <field name='x1' type='float' />
      <field name='y1' type='float' />
      <field name='z1' type='float' />
      <field name='x2' type='float' />
      <field name='y2' type='float' />
      <field name='z2' type='float' />
      <field name='x3' type='float' />
      <field name='y3' type='float' />
      <field name='z3' type='float' />
    </field>
    <field name='unknown17' type='list' >
      <field name='unknown18' type='string' />
      <field name='unknown19' type='float' />
      <field name='unknown20' type='float' />
      <field name='unknown21' type='float' />
      <field name='unknown22' type='float' />
      <field name='unknown23' type='float' />
      <field name='unknown24' type='float' />
    </field>
  </table>
  <table table_name='models_sieges_tables'
         table_version='5' >
    <field name='display_path' type='optstring_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='model_file' type='string_ascii' />
    <field name='unknown3' type='list' >
      <field name='name' type='string' />
      <field name='unknown5' type='int' />
      <field name='x1' type='float' />
      <field name='y1' type='float' />
      <field name='z1' type='float' />
      <field name='x2' type='float' />
      <field name='y2' type='float' />
      <field name='z2' type='float' />
      <field name='x3' type='float' />
      <field name='y3' type='float' />
      <field name='z3' type='float' />
    </field>
  </table>
  <table table_name='name_order_overrides_tables'
         table_version='0' >
    <field fkey='factions_tables.key' name='faction' type='string_ascii' pk='true' />
    <field name='order' type='int' pk='true' />
    <field fkey='name_types_tables.key' name='type' type='string_ascii' pk='true' />
  </table>
  <table table_name='political_actions_effect_bundles_tables'
         table_version='3' >
    <field name='action' type='string_ascii' pk='true' />
    <field fkey='effect_bundles_tables.key' name='effect_bundle' type='string_ascii' />
    <field name='duration' type='int' />
  </table>
  <table table_name='political_actions_tables'
         table_version='4' >
    <field name='political_action_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='political_parties_power_effect_bundles_tables'
         table_version='1' >
    <field fkey='effect_bundles_tables.key' name='effect_bundle' type='string_ascii' pk='true' />
    <field fkey='political_parties_tables.key' name='political_party_key' type='string_ascii' pk='true' />
    <field name='power_level' type='int' />
  </table>
  <table table_name='political_traits_tables'
         table_version='1' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='onscreen_name' type='string_ascii' />
    <field name='description' type='optstring_ascii' />
  </table>
  <table table_name='politics_government_type_political_action_junctions_tables'
         table_version='1' >
    <field fkey='politics_government_types_tables.government_type' name='government_type' type='string_ascii' pk='true' />
    <field name='is_available_for_faction_leader' type='boolean' />
    <field name='is_available_for_non_ruling_party_leaders' type='boolean' />
    <field name='is_available_for_non_ruling_party_members' type='boolean' />
    <field name='is_available_for_ruling_party_members' type='boolean' />
    <field fkey='political_actions_tables.political_action_key' name='political_action' type='string_ascii' pk='true' />
  </table>
  <table table_name='politics_government_types_tables'
         table_version='1' >
    <field name='government_type' type='string_ascii' pk='true' />
  </table>
  <table table_name='region_campaign_overrides_tables'
         table_version='1' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' pk='true' />
    <field fkey='regions_tables.key' name='region' type='string_ascii' pk='true' />
    <field fkey='religions_tables.religion_key' name='religion' type='optstring_ascii' />
    <field name='religion_zeal' type='int' />
  </table>
  <table table_name='region_religions_tables'
         table_version='1' >
    <field fkey='regions_tables.key' name='region' type='string_ascii' pk='true' />
    <field fkey='religions_tables.religion_key' name='religion' type='string_ascii' />
    <field name='religion_zeal' type='int' />
  </table>
  <table table_name='sea_climate_details_tables'
         table_version='1' >
    <field fkey='climates_tables.climate_type' name='key' type='string_ascii' pk='true' />
    <field name='sea_deep_colour_r' type='float' />
    <field name='sea_deep_colour_g' type='float' />
    <field name='sea_deep_colour_b' type='float' />
    <field name='sea_shallow_colour_r' type='float' />
    <field name='sea_shallow_colour_g' type='float' />
    <field name='sea_shallow_colour_b' type='float' />
    <field name='sun_colour_r' type='float' />
    <field name='sun_colour_g' type='float' />
    <field name='sun_colour_b' type='float' />
    <field name='sky_colour_r' type='float' />
    <field name='sky_colour_g' type='float' />
    <field name='sky_colour_b' type='float' />
  </table>
  <table table_name='send_diplomat_incidents_tables'
         table_version='1' >
    <field fkey='incidents_tables.key' name='incident' type='string_ascii' pk='true' />
    <field fkey='send_diplomat_outcomes_tables.key' name='outcome' type='string_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' pk='true' />
    <field name='weight' type='int' />
  </table>
  <table table_name='ship_names_tables'
         table_version='1' >
    <field fkey='names_groups_tables.key' name='key' type='string_ascii' pk='true' />
    <field fkey='names_groups_tables.key' name='name_group' type='int' />
    <field fkey='factions_tables.key' name='exclusive_to_faction' type='optstring_ascii' />
  </table>
  <table table_name='slot_template_to_building_superchain_junctions_tables'
         table_version='1' >
    <field fkey='building_superchains_tables.key' name='building_superchain' type='string_ascii' />
    <field name='id' type='string_ascii' pk='true' />
    <field fkey='slot_templates_tables.key' name='slot_template' type='string_ascii' />
  </table>
  <table table_name='slot_types_tables'
         table_version='1' >
    <field name='can_convert' type='boolean' />
    <field name='can_destroy' type='boolean' />
    <field name='key' type='string_ascii' pk='true' />
  </table>
  <table table_name='slots_art_tables'
         table_version='1' >
    <field fkey='slots_tables.slot' name='slot' type='string_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' pk='true' />
    <field fkey='warscape_underlay_textures_tables.underlay_key' name='underlay_terrain_texture' type='optstring_ascii' />
    <field name='underlay_differs_with_building' type='boolean' />
    <field fkey='slots_templates_models_tables.template_name' name='template_model' type='optstring_ascii' />
    <field name='template_differs_at_quality_zero' type='boolean' />
    <field fkey='slots_templates_models_tables.template_name' name='template_model_art_quality_zero' type='optstring_ascii' />
    <field name='use_minibuildings' type='boolean' />
    <field name='minibuildings_differ_at_quality' type='boolean' />
    <field name='use_minibuildings_from_quality' type='int' />
    <field fkey='warscape_rigid_tables.key' name='empty_building_model' type='optstring_ascii' />
    <field fkey='warscape_animated_tables.key' name='empty_building_model_animated' type='optstring_ascii' />
    <field name='display_empty_building_from_quality' type='int' />
  </table>
  <table table_name='small_vegetation_climates_jct_tables'
         table_version='1' >
    <field fkey='climates_tables.climate_type' name='climate' type='string_ascii' pk='true' />
    <field fkey='warscape_rigid_tables.key' name='rigid_name' type='string_ascii' pk='true' />
  </table>
  <table table_name='special_ability_to_auto_deactivate_flags_tables'
         table_version='1' >
    <field fkey='special_ability_invalid_usage_flags_tables.flag_key' name='invalid_usage_flag' type='string_ascii' pk='true' />
    <field fkey='unit_special_abilities_tables.key' name='special_ability_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='start_pos_faction_effect_bundles_tables'
         table_version='1' >
    <field name='duration' type='int' />
    <field fkey='effect_bundles_table.key' name='effect_bundle' type='string_ascii' pk='true' />
    <field fkey='start_pos_factions_tables.ID' name='start_pos_faction' type='int' pk='true' />
  </table>
  <table table_name='start_pos_family_relationships_tables'
         table_version='2' >
    <field fkey='start_pos_characters_tables.ID' name='character' type='int' pk='true' />
    <field fkey='start_pos_characters_tables.ID' name='related_to' type='int' pk='true' />
    <field fkey='family_relationship_types_tables.relationship_type' name='relationship' type='string_ascii' />
  </table>
  <table table_name='taxes_classes_tables'
         table_version='1' >
    <field name='tax' type='string_ascii' pk='true' />
  </table>
  <table table_name='technology_faction_junctions_tables'
         table_version='1' >
    <field fkey='technologies_tables.key' name='technology_key' type='string_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='technology_required_building_levels_junctions_tables'
         table_version='1' >
    <field fkey='technologies_tables.key' name='technology' type='string_ascii' pk='true' />
    <field fkey='building_levels_tables.level_name' name='required_bulding_level' type='string_ascii' pk='true' />
  </table>
  <table table_name='technology_required_technology_junctions_tables'
         table_version='1' >
    <field fkey='technologies_tables.key' name='technology' type='string_ascii' pk='true' />
    <field fkey='technologies_tables.key' name='required_technology' type='string_ascii' pk='true' />
  </table>
  <table table_name='trade_display_campaign_originating_subculture_trade_model_options_tables'
         table_version='0' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='originating_subculture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_owning_faction_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='factions_tables.key' name='owning_faction' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_owning_faction_trade_model_options_tables'
         table_version='0' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='factions_tables.key' name='owning_faction' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_owning_subculture_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='key' />
    <field name='unknown2' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='owning_subculture' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_owning_subculture_trade_model_options_tables'
         table_version='0' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='owning_subculture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_trade_model_options_tables'
         table_version='1' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='string_ascii' />
  </table>
  <table table_name='trade_display_generic_trade_model_options_tables'
         table_version='1' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_originating_culture_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_tables.key' name='originating_culture' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_originating_culture_trade_model_options_tables'
         table_version='2' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_tables.key' name='originating_culture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_originating_subculture_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field name='key' type='int' pk='true'/>
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='originating_subculture' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_owning_culture_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_tables.key' name='owning_culture' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_owning_faction_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='factions_tables.key' name='owning_faction' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_owning_subculture_produced_resource_trade_model_options_tables'
         table_version='0' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='owning_subculture' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_table.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_owning_subculture_trade_model_options_tables'
         table_version='0' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='owning_subculture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_produced_resource_trade_model_options_tables'
         table_version='2' >
    <field name='key' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_nodes_tables'
         table_version='1' >
    <field name='id' type='string_ascii' pk='true' />
    <field fkey='commodities_tables.key' name='commodity' type='string_ascii' />
    <field name='base_quantity' type='int' />
    <field name='percentage_increase_per_agent' type='float' />
    <field name='maximum_percentage_increase' type='float' />
    <field fkey='trade_node_groups_tables.key' name='group' type='string_ascii' />
  </table>
  <table table_name='trait_to_included_agents_tables'
         table_version='1' >
    <field fkey='trait_info_tables.trait' name='trait' type='string_ascii' pk='true' />
    <field fkey='agents_tables.key' name='agent' type='string_ascii' pk='true' />
  </table>
  <table table_name='trigger_event_to_excluded_agent_types_tables'
         table_version='0' >
    <field fkey='trigger_events_tables.event' name='event' type='string_ascii' pk='true' />
    <field fkey='agents_tables.key' name='agent' type='string_ascii' pk='true' />
  </table>
  <table table_name='unit_ground_type_movement_modifiers_tables'
         table_version='1' >
    <field fkey='unit_category_tables.key' name='category' type='string_ascii' pk='true' />
    <field fkey='ground_types_tables.type' name='ground_type' type='string_ascii' pk='true' />
    <field name='speed_modifier' type='float' />
  </table>
  <table table_name='unit_regiment_names_tables'
         table_version='1' >
    <field fkey='names_groups_tables.key' name='name_group' type='int' pk='true' />
    <field fkey='unit_castes_tables.caste' name='unit_caste' type='string_ascii' pk='true' />
    <field fkey='unit_regiment_names_localisation_lookup_tables.key' name='unit_name' type='string_ascii' pk='true' />
    <field name='name_order' type='int' />
  </table>
  <table table_name='units_to_gov_type_permissions_tables'
         table_version='1' >
    <field fkey='main_units_tables.unit' name='key' type='string_ascii' pk='true' />
    <field fkey='government_types_tables.government_type' name='gov_type' type='string_ascii' pk='true' />
    <field name='unique_number' type='string_ascii' />
    <field fkey='units_to_gov_type_outcomes_enum_tables.key' name='outcome' type='string_ascii' />
  </table>
  <table table_name='units_to_gov_types_conversion_jcts_tables'
         table_version='1' >
    <field fkey='units_to_gov_type_permissions_tables.unique_number' name='key' type='string_ascii' pk='true' />
    <field fkey='main_units_tables.unit' name='unit' type='string_ascii' pk='true' />
  </table>
  <table table_name='unrest_cause_to_demands_tables'
         table_version='1' >
    <field name='cause' type='string_ascii' pk='true' />
    <field name='level_of_unrest' type='string_ascii' pk='true' />
    <field name='demand' type='string_ascii' />
  </table>
  <table table_name='advice_levels_tables'
         table_version='4' >
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='advice_threads_tables.thread' name='advice_thread' type='string_ascii' />
    <field name='advice_thread_level' type='int' />
    <field name='points_needed' type='int' />
    <field name='game_area' type='string_ascii' />
    <field name='category' type='string_ascii' />
    <field name='sub_category' type='string_ascii' />
    <field name='max_repeat_count' type='int' />
    <field name='repeat_interval' type='int' />
    <field name='pause_battle' type='boolean' />
    <field name='priority_level' type='int' />
    <field name='high_verbosity_only' type='boolean' />
    <field name='locatable' type='boolean' />
    <field name='parameter' type='string_ascii' />
    <field name='on_display_script' type='optstring_ascii' />
    <field name='on_click_script' type='optstring_ascii' />
    <field name='suppressible' type='boolean' />
    <field name='uninhibitable' type='boolean' />
    <field name='audio_clip' type='string_ascii' />
    <field fkey='advisors_tables.advisor_name' name='advisor_name' type='string_ascii' />
    <field name='for_loading_screen' type='boolean' />
    <field name='movie_link' type='optstring_ascii' />
  </table>
  <table table_name='agent_culture_details_tables'
         table_version='11' >
    <field fkey='agents_tables.key' name='agent' type='string_ascii' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' />
    <field fkey='main_units_tables.unit' name='associated_unit' type='optstring_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='season' type='optstring_ascii' />
    <field name='level' type='int' />
    <field name='equipment_theme' type='optstring_ascii' />
    <field fkey='movie_event_strings_tables.event' name='agent_recruited_movie' type='optstring_ascii' />
    <field fkey='genders_tables.gender' name='gender' type='optstring_ascii' />
  </table>
  <table table_name='animals_tables'
         table_version='1' >
    <field name='animation' type='string_ascii' />
    <field fkey='unit_armour_types_tables.key' name='armour' type='optstring_ascii' />
    <field name='charge_bonus' type='int' />
    <field fkey='battle_entities_tables.key' name='entity' type='string_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='melee_attack' type='int' />
    <field name='melee_defence' type='int' />
  </table>
  <table table_name='battle_entity_effects_tables'
         table_version='3' >
    <field fkey='particle_effects_tables.key' name='deep_water' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='forest' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='grass' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='mud' type='optstring_ascii' />
    <field name='name' type='string_ascii' pk='true' />
    <field fkey='particle_effects_tables.key' name='road' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='rock' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='sand' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='scrub' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='shallow_water' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='snow' type='optstring_ascii' />
    <field fkey='particle_effects_tables.key' name='wooden_floor' type='optstring_ascii' />
  </table>
  <table table_name='battle_personalities_tables'
         table_version='8' >
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='warscape_animated_tables.key' name='soldier_model' type='string_ascii' />
    <field name='man_animations_table' type='string_ascii' />
    <field name='type' type='string_ascii' />
    <field fkey='projectiles_tables.key' name='missile_type' type='optstring_ascii' />
    <field fkey='variants_tables.variant_name' name='variant' type='string_ascii' />
  </table>
  <table table_name='battlefield_buildings_tables'
         table_version='21' >
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='battlefield_building_categories_tables.category' name='category' type='string_ascii' />
    <field fkey='models_building_tables.key' name='model' type='string_ascii' />
    <field name='audio_material' type='string_ascii' />
    <field name='hit_points' type='int' />
    <field fkey='missile_weapons_tables.key' name='gun_type' type='optstring_ascii' />
    <field fkey='battlefield_buildings_names_tables.key' name='onscreen_name' type='optstring_ascii' />
    <field name='ignition_threshold' type='int' />
    <field name='radar_icon' type='optstring_ascii' />
    <field name='visible_in_public_ted' type='boolean' />
    <field name='fortwall_penetration_chance' type='int' />
    <field name='collision_3d' type='boolean' />
    <field name='destruct_thresholds' type='optstring_ascii' />
    <field name='joiner' type='boolean' />
    <field name='auxiliary' type='boolean' />
    <field name='burn_rate' type='float' />
  </table>
  <table table_name='battlefield_engines_autonomous_tables'
         table_version='2' >
    <field fkey='battlefield_engines_tables.key' name='autonomous_engine_type' type='string_ascii' />
    <field name='engine_crew_anims' type='string_ascii' />
    <field fkey='battle_entities_tables.key' name='engine_crew_entity' type='string_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='num_ammo' type='int' />
  </table>
  <table table_name='battlefield_siege_vehicles_tables'
         table_version='19' >
    <field name='hit_points' type='int' />
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='models_sieges_tables.key' name='model' type='string_ascii' />
    <field fkey='battle_entities_tables.key' name='battle_entity' type='string_ascii' />
    <field name='gun_type' type='optstring_ascii' />
    <field name='docking_clearance' type='float' />
    <field fkey='battlefield_engines_autonomous_tables.key' name='engine' type='optstring_ascii' />
    <field name='image_path' type='string_ascii' />
    <field name='recruitment_cap' type='int' />
    <field name='uses_8m_wall' type='boolean' />
    <field name='uses_15m_wall' type='boolean' />
    <field name='cost' type='int' />
    <field name='category_image_path' type='string_ascii' />
    <field name='special_edition_mask' type='int' />
    <field name='ignition_threshold' type='int' />
    <field name='attack_damage' type='float' />
    <field name='selection_priority' type='float' />
  </table>
  <table table_name='building_level_armed_citizenry_junctions_tables'
         table_version='2' >
    <field fkey='building_levels_tables.level_name' name='building_level' type='string_ascii' />
    <field name='id' type='int' pk='true' />
    <field name='unknown3' type='int' />
    <field fkey='armed_citizenry_unit_groups_tables.unit_group' name='unit_group' type='string_ascii' />
  </table>
  <table table_name='cai_construction_system_building_values_tables'
         table_version='1' >
    <field fkey='building_chains_tables.key' name='building_chain' type='optstring_ascii' pk='true' />
    <field fkey='building_instances_tables.level_name' name='building_instance' type='optstring_ascii' pk='true' />
    <field fkey='building_levels_tables.level_name' name='building_or_building_range_start_inclusive' type='optstring_ascii' pk='true' />
    <field fkey='building_levels_tables.level_name' name='building_range_end_inclusive' type='optstring_ascii' pk='true' />
    <field fkey='building_superchains_tables.key' name='building_super_chain' type='optstring_ascii' pk='true' />
    <field fkey='cai_construction_system_categories_tables.key' name='cai_construction_system_category' type='optstring_ascii' pk='true' />
    <field fkey='cai_construction_system_category_groups_tables.key' name='cai_construction_system_category_group' type='optstring_ascii' pk='true' />
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='optstring_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='optstring_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction' type='optstring_ascii' pk='true' />
    <field name='per_faction_building_limit_end' type='int' />
    <field name='per_faction_building_limit_start' type='int' />
    <field name='per_faction_building_maximum_discount_when_exceeding_limit_end' type='int' />
    <field name='per_faction_building_maximum__discount_when_exceeding_limit_start' type='int' />
    <field name='per_faction_building_minimum_discount_when_exceeding_limit_end' type='int' />
    <field name='per_faction_building_minimum_discount_when_exceeding_limit_start' type='int' />
    <field name='per_faction_per_building_discount_increment_when_exceeding_limit_end' type='int' />
    <field name='per_faction_per_building_discount_increment_when_exceeding_limit_start' type='int' />
    <field name='per_province_building_limit_end' type='int' />
    <field name='per_province_building_limit_start' type='int' />
    <field name='per_province_building_maximum_discount_when_exceeding_limit_end' type='int' />
    <field name='per_province_building_maximum_discount_when_exceeding_limit_start' type='int' />
    <field name='per_province_building_minimum_discount_when_exceeding_limit_end' type='int' />
    <field name='per_province_building_minimum_discount_when_exceeding_limit_start' type='int' />
    <field name='per_province_per_building_discount_increment_when_exceeding_limit_end' type='int' />
    <field name='per_province_per_building_discount_increment_when_exceeding_limit_start' type='int' />
    <field name='score_end_inclusive' type='int' />
    <field name='score_or_score_start_inclusive' type='int' />
    <field fkey='cultures_subcultures_tables.subculture' name='sub_culture' type='optstring_ascii' pk='true' />
  </table>
  <table table_name='cai_personality_diplomatic_treaty_values_tables'
         table_version='4' >
    <field name='defensive_alliance' type='float' />
    <field fkey='cai_personality_diplomatic_components_tables.id' name='component_id' type='string_ascii' pk='true' />
    <field name='trade_agreement' type='float' />
    <field name='military_alliance' type='float' />
    <field name='non_aggression_pact' type='float' />
    <field name='vassalage_master' type='float' />
    <field name='vassalage_vassal' type='float' />
    <field name='client_state_protector' type='float' />
    <field name='client_state_client' type='float' />
    <field name='war' type='float' />
    <field name='military_access' type='float' />
  </table>
  <table table_name='cai_personality_strategic_desired_attitudes_tables'
         table_version='2' >
    <field name='best_friends_attitude' type='float' />
    <field name='best_friends_positive_factor' type='float' />
    <field name='bitter_enemies_attitude' type='float' />
    <field name='bitter_enemies_positive_factor' type='float' />
    <field name='friendly_attitude' type='float' />
    <field name='friendly_positive_factor' type='float' />
    <field name='neutral_attitude' type='float' />
    <field name='neutral_positive_factor' type='float' />
    <field fkey='cai_personality_strategic_components_tables.id' name='strategic_component' type='string_ascii' pk='true' />
    <field name='unfriendly_attitude' type='float' />
    <field name='unfriendly_positive_factor' type='float' />
    <field name='very_friendly_attitude' type='float' />
    <field name='very_friendly_positive_factor' type='float' />
    <field name='very_unfriendly_attitude' type='float' />
    <field name='very_unfriendly_positive_factor' type='float' />
    <field name='best_friends_negative_factor' type='float' />
    <field name='very_friendly_negative_factor' type='float' />
    <field name='friendly_negative_factor' type='float' />
    <field name='neutral_negative_factor' type='float' />
    <field name='unfriendly_negative_factor' type='float' />
    <field name='very_unfriendly_negative_factor' type='float' />
    <field name='bitter_enemies_negative_factor' type='float' />
  </table>
  <table table_name='campaign_battle_presets_tables'
         table_version='7' >
    <field name='battle_type' type='string_ascii' />
    <field name='coord_x' type='float' />
    <field name='coord_y' type='float' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='tile_upgrade' type='optstring_ascii' />
    <field name='is_unique_settlement' type='boolean' />
    <field fkey='campaign_map_playable_areas_tables.index' name='campaign_map' type='int' />
  </table>
  <table table_name='campaign_character_attribute_effects_tables'
         table_version='2' >
    <field fkey='agents_tables.key' name='agent_record' type='string_ascii' pk='true' />
    <field name='attribute_level' type='int' pk='true' />
    <field fkey='agent_attributes_tables.key' name='attribute_record' type='string_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture_record' type='optstring_ascii' pk='true' />
    <field fkey='effects_tables.effect' name='effect_record' type='string_ascii' pk='true' />
    <field fkey='campaign_effect_scopes_tables.key' name='effect_scope' type='string_ascii' pk='true' />
    <field name='effect_value' type='float' />
    <field fkey='factions_tables.key' name='faction_record' type='optstring_ascii' pk='true' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture_record' type='optstring_ascii' pk='true' />
    <field fkey='campaigns_tables.campaign_name' name='campaign_record' type='optstring_ascii' pk='true' />
  </table>
  <table table_name='campaign_map_playable_areas_tables'
         table_version='10' >
    <field name='index' type='string_ascii' pk='true' />
    <field name='sea_trade' type='boolean' />
    <field name='map_file' type='optstring_ascii' />
    <field name='overlay_file' type='optstring_ascii' />
    <field name='radar_file' type='optstring_ascii' />
    <field name='meaningful_id' type='string_ascii' />
    <field name='preview_width' type='int' />
    <field name='preview_height' type='int' />
    <field name='preview_border' type='int' />
    <field name='minx' type='float' />
    <field name='maxx' type='float' />
    <field name='miny' type='float' />
    <field name='maxy' type='float' />
    <field fkey='campaign_maps_tables.mapname' name='mapname' type='string_ascii' />
    <field name='minimap_lookup_file' type='optstring_ascii' />
    <field name='is_available_in_custom_battle' type='boolean' />
  </table>
  <table table_name='campaign_map_roads_tables'
         table_version='1' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='movement_cost' type='int' />
    <field name='threshold' type='float' />
    <field name='turns_required_to_downgrade_from' type='int' />
    <field name='turns_required_to_upgrade_to' type='int' />
  </table>
  <table table_name='campaign_settlement_display_building_ids_tables'
         table_version='4' >
    <field fkey='building_levels_tables.level_name' name='building_level_key' type='optstring_ascii' />
    <field fkey='cultures_tables.key' name='culture' type='optstring_ascii' />
    <field fkey='factions_tables.key' name='faction' type='optstring_ascii' />
    <field name='key' type='string_ascii' pk='true' />
    <field name='sprawl_piece_level' type='int' />
    <field fkey='campaign_settlement_display_sprawl_pieces_tables.key' name='sprawl_piece_type' type='optstring_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='sub_culture' type='optstring_ascii' />
  </table>
  <table table_name='campaign_settlement_display_building_trees_tables'
         table_version='1' >
    <field name='rigid_lookup_key' type='optstring_ascii' />
    <field name='building_path' type='optstring_ascii' />
    <field fkey='climates_tables.climate_type' name='climate_type' type='string_ascii' />
    <field name='id' type='int' pk='true' />
    <field name='unknown0' type='int' />
  </table>
  <table table_name='campaign_settlement_display_buildings_tables'
         table_version='7' >
    <field name='building_path' type='optstring_ascii' />
    <field fkey='campaign_settlement_display_building_ids_tables.key' name='display_building_key' type='string_ascii' />
    <field name='is_blockaded' type='boolean' />
    <field name='is_sieged' type='boolean' />
    <field name='is_slum' type='boolean' />
    <field name='key' type='int' pk='true' />
    <field name='unknown6' type='int' />
    <field name='state' type='optstring_ascii' />
    <field name='destruction_additional_model' type='optstring_ascii' />
    <field name='destruction_override_model' type='optstring_ascii' />
    <field name='construction_additional_model' type='optstring_ascii' />
    <field name='construction_override_model' type='optstring_ascii' />
  </table>
  <table table_name='campaign_vfx_descriptions_tables'
         table_version='2' >
    <field name='key' type='string_ascii' pk='true' />
    <field fkey='particle_effects_tables.key' name='vfx' type='string_ascii' />
    <field name='x_offset' type='float' />
    <field name='y_offset' type='float' />
    <field name='z_offset' type='float' />
  </table>
  <table table_name='campaign_vfx_lookups_tables'
         table_version='1' >
    <field fkey='agents_tables.key' name='agent_filter' type='optstring_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='culture_filter' type='optstring_ascii' />
    <field fkey='factions_tables.key' name='faction_filter' type='optstring_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown5' type='int' />
    <field fkey='campaign_vfx_descriptions_tables.key' name='vfx_description' type='string_ascii' />
    <field name='vfx_event' type='string_ascii' />
  </table>
  <table table_name='campaigns_campaign_variables_junctions_tables'
         table_version='3' >
    <field fkey='campaign_variables_tables.variable_key' name='variable_key' type='string_ascii' pk='true' />
    <field fkey='campaigns_tables.campaign_name' name='campaign_name' type='string_ascii' pk='true' />
    <field name='value' type='float' />
    <field name='optional_difficulty_level' type='optstring_ascii' pk='true' />
    <field name='optional_campaign_type' type='optstring_ascii' pk='true' />
  </table>
  <table table_name='cdir_configs_tables'
         table_version='1' >
    <field fkey='cdir_campaign_junctions_tables.key' name='campaign_key' type='string_ascii' pk='true' />
    <field fkey='cdir_faction_junctions_tables.key' name='faction key' type='optstring_ascii' pk='true' />
    <field name='cdir_config_key' type='string_ascii' pk='true' />
    <field name='value' type='optstring_ascii' />
  </table>
  <table table_name='cdir_events_dilemma_followup_missions_tables'
         table_version='1' >
    <field fkey='dilemmas_tables.key' name='dilemma_key' type='string_ascii' pk='true' />
    <field fkey='cdir_events_dilemma_choices_tables.choice_key' name='choice_key' type='string_ascii' pk='true' />
    <field fkey='missions_tables.key' name='followup_mission_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cdir_events_dilemma_option_junctions_tables'
         table_version='2' >
    <field fkey='dilemmas_tables.key' name='dilemma_key' type='string_ascii' />
    <field name='id' type='int' pk='true' />
    <field name='unknown3' type='int' />
    <field fkey='cdir_events_dilemma_options_tables.option_key' name='option_key' type='string_ascii' />
    <field name='value' type='optstring_ascii' />
  </table>
  <table table_name='cdir_events_dilemma_payloads_tables'
         table_version='3' >
    <field fkey='cdir_events_dilemma_choices_tables.choice_key' name='choice_key' type='string_ascii' />
    <field fkey='dilemmas_tables.key' name='dilemma_key' type='string_ascii' />
    <field name='id' type='int' pk='true' />
    <field name='unknown4' type='int' />
    <field fkey='cdir_events_payloads_tables.payload_key' name='payload_key' type='string_ascii' />
    <field name='value' type='optstring_ascii' />
  </table>
  <table table_name='cdir_events_incident_option_junctions_tables'
         table_version='2' >
    <field name='id' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='incidents_tables.key' name='incident_key' type='string_ascii' />
    <field name='option_key' type='string_ascii' />
    <field name='value' type='optstring_ascii' />
  </table>
  <table table_name='cdir_events_incident_payloads_tables'
         table_version='3' >
    <field name='id' type='int' pk='true' />
    <field name='unknown1' type='int' />
    <field fkey='incidents_tables.key' name='incident_key' type='string_ascii' />
    <field fkey='cdir_events_payloads_tables.payload_key' name='payload_key' type='string_ascii' />
    <field name='value' type='optstring_ascii' />
  </table>
  <table table_name='cdir_events_mission_option_junctions_tables'
         table_version='2' >
    <field name='id' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='missions_tables.key' name='mission_key' type='string_ascii' />
    <field name='option_key' type='string_ascii' />
    <field name='value' type='optstring_ascii' />
  </table>
  <table table_name='cdir_events_mission_payloads_tables'
         table_version='2' >
    <field name='id' type='int' pk='true' />
    <field name='unknown2' type='int' />
    <field fkey='missions_tables.key' name='mission_key' type='string_ascii' />
    <field fkey='cdir_events_payloads_tables.payload_key' name='payload_key' type='string_ascii' />
    <field name='status_key' type='string_ascii' />
    <field name='value' type='string_ascii' />
  </table>
  <table table_name='character_experience_skill_tiers_tables'
         table_version='3' >
    <field fkey='agents_tables.key' name='agent_key' type='optstring_ascii' pk='true' />
    <field name='experience_threshold' type='int' />
    <field name='skill_points' type='int' />
    <field name='skill_rank' type='int' pk='true' />
    <field fkey='campaigns_tables.campaign_name' name='optional_campaign_key' type='optstring_ascii' pk='true' />
    <field name='for_army' type='boolean' pk='true' />
    <field name='for_navy' type='boolean' pk='true' />
  </table>
  <table table_name='character_skill_level_details_tables'
         table_version='1' >
    <field fkey='campaigns_tables.campaign_name' name='campaign_key' type='optstring_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' pk='true' />
    <field name='image_path' type='string_ascii' />
    <field name='level' type='int' pk='true' />
    <field fkey='character_skills_tables.key' name='skill_key' type='string_ascii' pk='true' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture_key' type='optstring_ascii' pk='true' />
    <field name='unlocked_at_rank' type='int' />
  </table>
  <table table_name='commander_unit_permissions_tables'
         table_version='1' >
    <field fkey='cultures_tables.key' name='culture_key' type='optstring_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' pk='true' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture_key' type='optstring_ascii' pk='true' />
    <field fkey='main_units_tables.unit' name='unit_key' type='string_ascii' pk='true' />
  </table>
  <table table_name='cursors_tables'
         table_version='7' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='image' type='string' />
    <field name='frames' type='int' />
    <field name='framerate' type='int' />
    <field name='hotspotX' type='int' />
    <field name='hotspotY' type='int' />
    <field name='loop' type='boolean' />
    <field name='width' type='int' />
    <field name='height' type='int' />
  </table>
  <table table_name='cursus_honorum_trait_junctions_tables'
         table_version='3' >
    <field fkey='cultures_subcultures_tables.subculture' name='subculture_key' type='string_ascii' pk='true' />
    <field fkey='trait_info_tables.trait' name='trait_info_key' type='string_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' pk='true' />
    <field fkey='trait_info_tables.trait' name='trait_info_key_female' type='optstring_ascii' pk='true' />
  </table>
  <table table_name='cursus_honorum_trait_junctions_tables'
         table_version='3' >
    <field fkey='cultures_subcultures_tables.subculture' name='subculture_key' type='string_ascii' pk='true' />
    <field fkey='trait_info_tables.trait' name='trait_info_key' type='string_ascii' pk='true' />
    <field fkey='factions_tables.key' name='faction_key' type='optstring_ascii' pk='true' />
    <field fkey='trait_info_tables.trait' name='trait_info_key_female' type='optstring_ascii' pk='true' />
  </table>

[Genreless]

Rome 2 schema updates part 2:

  <table table_name='diplomatic_action_faction_restrictions_tables'
         table_version='1' >
    <field name='can_make_client_states' type='boolean' />
    <field name='can_make_confederations' type='boolean' />
    <field name='can_make_vassals' type='boolean' />
    <field fkey='factions_tables.key' name='faction' type='string_ascii' pk='true' />
  </table>
  <table table_name='faction_civil_war_setups_tables'
         table_version='2' >
    <field fkey='factions_tables.key' name='primary_faction' type='string_ascii' pk='true' />
    <field fkey='factions_tables.key' name='secondary_faction' type='string_ascii' />
    <field fkey='factions_tables.key' name='secessionist_faction' type='string_ascii' />
  </table>
  <table table_name='factions_tables'
         table_version='35' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='index' type='int' />
    <field name='unknown2' type='int' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='string_ascii' />
    <field name='category' type='string_ascii' />
    <field name='screen_name' type='string_ascii' />
    <field name='screen_adjective' type='string_ascii' />
    <field fkey='names_groups_tables.key' name='name_group' type='int' />
    <field name='skin' type='string_ascii' />
    <field name='ui_skin' type='optstring_ascii' />
    <field name='is_rebel' type='boolean' />
    <field name='mp_available' type='boolean' />
    <field name='mp_available_naval' type='boolean' />
    <field name='icons_path_units' type='string_ascii' />
    <field name='flags_path' type='string_ascii' />
    <field name='republican_flag_path' type='optstring_ascii' />
    <field name='same_gov_type_revolution_flag_path' type='optstring_ascii' />
    <field name='primary_colour_r' type='float' />
    <field name='primary_colour_g' type='float' />
    <field name='primary_colour_b' type='float' />
    <field name='alt_primary_colour_r' type='float' />
    <field name='alt_primary_colour_g' type='float' />
    <field name='alt_primary_colour_b' type='float' />
    <field name='secondary_colour_r' type='float' />
    <field name='secondary_colour_g' type='float' />
    <field name='secondary_colour_b' type='float' />
    <field name='alt_secondary_colour_r' type='float' />
    <field name='alt_secondary_colour_g' type='float' />
    <field name='alt_secondary_colour_b' type='float' />
    <field name='uniform_colour_r' type='float' />
    <field name='uniform_colour_g' type='float' />
    <field name='uniform_colour_b' type='float' />
    <field name='alt_uniform_colour_r' type='float' />
    <field name='alt_uniform_colour_g' type='float' />
    <field name='alt_uniform_colour_b' type='float' />
    <field fkey='groupings_military_tables.military_group' name='military_group' type='string_ascii' />
    <field fkey='factions_tables.key' name='settler_rebellion_faction' type='optstring_ascii' />
    <field name='rebel_colour_r' type='float' />
    <field name='rebel_colour_g' type='float' />
    <field name='rebel_colour_b' type='float' />
    <field fkey='movie_event_strings_tables.id' name='movie_death_event' type='optstring_ascii' />
    <field name='mp_use_republic_early' type='boolean' />
    <field name='mp_use_republic_late' type='boolean' />
    <field fkey='names_groups_tables.key' name='unit_regiment_name_group' type='int' />
    <field fkey='names_groups_tables.key' name='ship_name_group' type='int' />
    <field name='attack_desc' type='string_ascii' />
    <field name='defend_desc' type='string_ascii' />
    <field name='mp_stats_name' type='optstring_ascii' />
    <field name='pre_battle_speech_parameter' type='string_ascii' />
    <field name='can_be_regionless' type='boolean' />
    <field name='card_colour_r' type='float' />
    <field name='card_colour_g' type='float' />
    <field name='card_colour_b' type='float' />
    <field fkey='cultures_tables.key' name='diplomacy_culture' type='string_ascii' />
    <field name='senator_total' type='int' />
    <field name='uses_legion_names' type='boolean' />
  </table>
  <table table_name='main_units_tables'
         table_version='36' >
    <field fkey='building_levels_tables.level_name' name='additional_building_requirement' type='optstring_ascii' />
    <field name='campaign_cap' type='int' />
    <field fkey='unit_castes_tables.caste' name='caste' type='string_ascii' />
    <field name='create_time' type='int' />
    <field name='is_naval' type='boolean' />
    <field fkey='land_units_tables.key' name='land_unit' type='string_ascii' />
    <field name='num_men' type='int' />
    <field name='multiplayer_cap' type='int' />
    <field name='multiplayer_cost' type='int' />
    <field fkey='naval_units_tables.key' name='naval_unit' type='optstring_ascii' />
    <field name='num_ships' type='int' />
    <field name='min_men_per_ship' type='int' />
    <field name='max_men_per_ship' type='int' />
    <field name='prestige' type='int' />
    <field name='recruitment_cost' type='int' />
    <field name='recruitement_movie' type='optstring_ascii' />
    <field fkey='religions_tables.religion_key' name='religion_requirement' type='optstring_ascii' />
    <field name='unit' type='string_ascii' pk='true' />
    <field name='upkeep_cost' type='int' />
    <field fkey='unit_weights_tables.key' name='weight' type='optstring_ascii' />
    <field name='campaign_total_cap' type='int' />
    <field fkey='resources_tables.key' name='resource_requirement' type='optstring_ascii' />
    <field name='world_leader_only' type='boolean' />
    <field name='can_trade' type='boolean' />
    <field name='special_edition_mask' type='int' />
    <field name='unique_index' type='int' />
    <field name='unknown26' type='int' />
    <field name='in_encyclopedia' type='boolean' />
    <field fkey='region_unit_resources_tables.key' name='region_unit_requirement' type='optstring_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='audio_language' type='string_ascii' />
    <field fkey='audio_vo_actor_groups_tables.key' name='audio_vo_actor_group' type='optstring_ascii' />
  </table>
  <table table_name='message_events_tables'
         table_version='2' >
    <field name='event' type='string_ascii' pk='true' />
    <field name='instant_open' type='boolean' />
    <field name='layout' type='string_ascii' />
    <field name='requires_response' type='boolean' />
    <field name='priority' type='int' />
  </table>
  <table table_name='political_parties_tables'
         table_version='7' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='playable' type='boolean' />
    <field name='ui_icon' type='string_ascii' />
    <field fkey='effect_bundles_tables.key' name='effect_bundle' type='string_ascii' />
    <field name='initial_power' type='int' />
    <field name='r' type='float' />
    <field name='g' type='float' />
    <field name='b' type='float' />
    <field fkey='political_traits_tables.key' name='trait1' type='optstring_ascii' />
    <field fkey='political_traits_tables.key' name='trait2' type='optstring_ascii' />
  </table>
  <table table_name='province_to_mercenary_set_junctions_tables'
         table_version='2' >
    <field fkey='mercenary_pools_tables.key' name='mercenary_set' type='string_ascii' pk='true' />
    <field fkey='provinces_tables.key' name='province' type='string_ascii' pk='true' />
    <field fkey='campaigns_tables.campaign_name' name='optional_campaign_key' type='optstring_ascii' />
  </table>
  <table table_name='sea_surfaces_tables'
         table_version='3' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='sea_wind_speed' type='float' />
    <field name='sea_phillips_constant' type='float' />
    <field name='sea_choppiness' type='float' />
    <field name='swell_wind_speed' type='float' />
    <field name='swell_phillips_constant' type='float' />
    <field name='foam_enabled' type='boolean' />
    <field name='foam_decay_rate' type='float' />
    <field name='foam_fade_in_time' type='float' />
    <field name='foam_cut_off_value' type='float' />
    <field name='froth_value' type='float' />
    <field name='froth_distortion_speed' type='float' />
    <field name='froth_distortion_amount' type='float' />
    <field name='spray_cut_off_value' type='float' />
    <field name='spray_speed' type='float' />
    <field name='spray_duration' type='float' />
    <field name='sea_shininess' type='float' />
    <field name='sea_decay' type='float' />
    <field name='reflection_flattening_factor' type='float' />
    <field name='wave_trough_y_value' type='float' />
    <field name='detail_normal_uv_speed1' type='float' />
    <field name='detail_normal_uv_speed2' type='float' />
    <field name='detail_normal_uv_scale1' type='float' />
    <field name='detail_normal_uv_scale2' type='float' />
  </table>
  <table table_name='season_attritions_tables'
         table_version='2' >
    <field fkey='campaign_map_attritions_tables.key' name='attrition_type' type='string_ascii' pk='true' />
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='optstring_ascii' pk='true' />
    <field name='enable' type='boolean' pk='true' />
    <field fkey='seasons_tables.season' name='season' type='string_ascii' pk='true' />
  </table>
  <table table_name='season_province_effect_bundles_tables'
         table_version='2' >
    <field name='default' type='boolean' />
    <field fkey='effect_bundles_tables.key' name='effect_bundle' type='string_ascii' pk='true' />
    <field fkey='provinces_tables.key' name='province' type='string_ascii' pk='true' />
    <field fkey='seasons_tables.season' name='season' type='string_ascii' pk='true' />
    <field name='weighting' type='int' />
  </table>
  <table table_name='special_ability_groups_tables'
         table_version='9' >
    <field name='ability_group' type='string_ascii' pk='true' />
    <field name='icon_path' type='string_ascii' />
    <field name='special_edition_mask' type='int' />
  </table>
  <table table_name='trade_display_campaign_originating_culture_trade_model_options_tables'
         table_version='2' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_tables.key' name='originating_culture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_owning_culture_produced_resource_trade_model_options_tables'
         table_version='2' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown0' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_tables.key' name='owning_culture' type='string_ascii' />
    <field name='priority' type='float' />
    <field fkey='resources_tables.key' name='produced_resource' type='string_ascii' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_campaign_owning_culture_trade_model_options_tables'
         table_version='2' >
    <field fkey='campaigns_tables.campaign_name' name='campaign' type='string_ascii' />
    <field name='key' type='int' pk='true' />
    <field name='unknown' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_tables.key' name='owning_culture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_originating_subculture_trade_model_options_tables'
         table_version='2' >
    <field name='key' type='int' pk='true' />
    <field name='unknown' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_subcultures_tables.subculture' name='originating_subculture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_owning_culture_trade_model_options_tables'
         table_version='1' >
    <field name='key' type='int' pk='true' />
    <field name='key2' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='cultures_tables.key' name='owning_culture' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='trade_display_owning_faction_trade_model_options_tables'
         table_version='2' >
    <field name='key' type='int' pk='true' />
    <field name='unknown' type='int' />
    <field fkey='trade_display_trade_models_tables.key' name='model' type='string_ascii' />
    <field fkey='factions_tables.key' name='owning_faction' type='string_ascii' />
    <field name='priority' type='float' />
    <field name='relative_frequency' type='float' />
  </table>
  <table table_name='warscape_animated_lod_tables'
         table_version='3' >
    <field name='key' type='string_ascii' pk='true' />
    <field name='filename' type='string_ascii' />
    <field name='range' type='float' />
    <field fkey='warscape_animated_tables.key' name='animated' type='string_ascii' />
  </table>
  <table table_name='agent_subculture_gender_overrides_tables'
         table_version='1' >
    <field fkey='agents_tables.key' name='agent' type='string_ascii' pk='true' />
    <field fkey='genders_tables.gender' name='gender' type='string_ascii' pk='true' />
    <field fkey='cultures_subcultures_tables.subculture' name='subculture' type='string_ascii' pk='true' />
  </table>
  <table table_name='building_chain_availability_sets_tables'
         table_version='1' >
    <field fkey='building_chains_tables.key' name='building_chain' type='string_ascii' pk='true' />
    <field fkey='building_chain_availability_set_ids_tables.id' name='id' type='string_ascii' pk='true' />
  </table>

Things I can't fix myself:
Bad schema entries that crash PFM via memory leak because they have no fields (These need to be removed from the Master Schema. I believe I've provided proper versions of most of these. If I haven't it's because Rome 2's Assembly kit can't output the table.):

Spoiler Alert, click show to read: 

trade_display_campaign_originating_culture_produced_resource_trade_model_options_tables
trade_display_campaign_originating_subculture_produced_resource_trade_model_options_tables
trade_display_campaign_originating_subculture_trade_model_options_tables
trade_display_campaign_owning_faction_produced_resource_trade_model_options_tables
trade_display_campaign_owning_faction_trade_model_options_tables
trade_display_campaign_owning_subculture_produced_resource_trade_model_options_tables
trade_display_campaign_owning_subculture_trade_model_options_tables
trade_display_campaign_produced_resource_trade_model_options_tables
trade_display_originating_culture_produced_resource_trade_model_options_tables
trade_display_originating_subculture_produced_resource_trade_model_options_tables
trade_display_owning_culture_produced_resource_trade_model_options_tables
trade_display_owning_faction_produced_resource_trade_model_options_tables
trade_display_owning_subculture_produced_resource_trade_model_options_tables
trade_display_owning_subculture_trade_model_options_tables
trigger_event_to_excluded_agent_types_tables
unit_special_ability_effects_tables

Duplicate version numbers in the master schema file (I didn't do an exhaustive search, these are just what I found while making the schema changes listed above):

Spoiler Alert, click show to read: 

there are 2 naval_units_tables version 16's in the master schema table the difference is the can_ram boolean, there is no version 17 the version 16 with can_ram should probably be version 17
there are a lot of versions of agents_tables with the same version numbers
there are 2 ancillaries_tables version 0's and version 10 is not grouped with the rest of the versions
there are two identical ancillaries_subcategories_tables version 0's
there are two version 0's of cai_variables_overides_tables
there are two version 0's and version 4's of campaign_character_art_sets_tables. One version 0 is identical to version 1 and one version 4 is identical to version 5.
there are three version 0's of campaign_map_slots_tables
there are two version 0's of campaign_map_towns_and_ports_tables
there are two version 0's of campaign_walk_anim_sets_tables
there are three version 1's of character_skill_nodes_tables. two are identical
there are two version 3's of culture_subculture_politics_government_type_tables
there are two version 6's of deployables_tables, I renumbered the second because it is the proper rome 2 version
there are two version 0's of effect_bonus_value_building_chain_junctions_tables: a complete non-ascii version and an incomplete ascii version
there are two version 0's, 2's, 4's, 9's, 13's of units_tables
there are two version 0's of events_tables
there are two version 0's of gun_type_to_projectiles_tables
there are two version 0's of historical_character_traits_tables
there are two version 0's of historical_characters_tables
there are three version 0's of message_event_strings_tables
there are two version 2's of military_force_legacy_emblems_tables
there are two version 0's of ministerial_positions_by_gov_types_tables
there are two version 0's of ministerial_positions_to_character_effects_tables
there are two version 0's of ministerial_positions_to_effects_tables
there are two version 0's of projectile_trails_tables
there are two version 0's of projectiles_missile_type_enum_tables
there are two identical version 0's of region_campaign_overrides_tables
there are two version 0's of slot_template_to_building_superchain_junctions_tables
there are two version 0's of slot_type_tables
there are two version 0's of taxes_classes_tables
there are two version 0's of technology_required_building_levels_junctions_tables
there are two version 0's of trait_to_included_agents_tables
there are two version 0's of unrest_cause_to_demands_tables
there are two version 0's, 3's of advice_levels_tables
there are two version 0's, 5's, 8's of agent_culture_details_tables
there are two version 0's and three version 3's of battle_personalities_tables
there are two version 0's and three version 1's of battlefield_buildings_tables
there are two version 0's of campaign_settlement_display_building_trees_tables (I increment the version number of the first one) (the second looks like a misinterpreted autonumber (autonumbers are wierd, sometimes they are strings, sometimes they are two ints), but I don't know if a non-Rome 2 game uses that)
versions 1 and 2 of campaign_settlement_display_buildings_tables are functionally identical
there are two version 0's and three 2'scampaigns_campaign_variables_junctions_tables (the 2nd version 0 and 1st version 2 are identical)
there are two version 0's of cdir_configs_tables
cdir_events_dilemmma_option_junctions_tables version 1 and 2 are identical. I have thus numbered the new table version 2 to replace the old version 2.
cdir_events_incident_option_junctions_tables version 1 and 2 are identical. I have thus numbered the new table version 2 to replace the old version 2.
cdir_events_mission_option_junctions_tables version 1 and 2 are identical. I have thus numbered the new table version 2 to replace the old version 2.
there are two version 0's and three version 2's of character_experience_skill_tiers_tables
there are two version 0's of commander_unit_permissions_tables. I have incremented the version number of the first and marked all its fields as keys.
there are two version 0's of cultures_tables. the second version 0 and version 1 are functionally identical.
there are two version 1's of faction_civil_war_setups_tables. They are identical.
there are two version 0's of factions_tables
there are two version 3's of political_parties_tables
there are two version 6's of special_ability_groups_tables
there are two version 0's of warscape_animated_lod_tables. the second version 0 and version 2 are identical
there are two version 0's of cai_agent_type_distribution_profile_junctions; an ascii version and a non-ascii version
there are two version 0's of cai_agent_type_recruitment_profile_junctions; an ascii version and a non-ascii version
there are two version 0's of building_level_required_technology_junctions; an ascii version and a non-ascii version
there are two version 0's of battle_type_faction_presets_tables. the second version 0 is identical to version 1.
there are multiple different version 0's, 3's, 11's of building_levels_tables
there are multiple version 0's, 3's of building_units_allowed_tables
there are two version 0's of cai_personalities_contruction_preference_policy_building_junctions_tables; they are duplicates of versions 1 and 2 of the table
cai_personalities_random_groups_tables:
there are two version 0's of cai_personalities_random_groups_tables, a string version and an ascii_string version

If you want a list of the details of each change to the schema, I have that saved and can post it, but I'll refrain from posting that now because it has about half the line count of the schema change that put my first post over the character limit.

[snakescrin]

after the latest queen and crone dlc of TW warhammer2, the "data.pack-->db-->main_unit_tables-->data__" can no longer be decoded in the pfm, just fyi.

[Larynja]

Uploaded schema version 110 which works with the latest The Queen & the Crown DLC.
The auto-update feature still isn't working. Please download it manually here.


@Genreless: Thanks for your information, I'll include them into the schema.

[Genreless]

Here, have one more Rome 2 schema because I found it while merging version 110 with my changes.

  <table table_name='effect_bonus_value_unit_record_junctions_tables'
         table_version='1' >
    <field name='bonus_value_id' type='string_ascii' pk='true' />
    <field fkey='effects_tables.effect' name='effect' type='string_ascii' pk='true' />
    <field fkey='main_units_tables.unit' name='unit_record_key' type='string_ascii' pk='true' />
  </table>

[Larynja]

Updated schema 111 is now available for download. Names some of the new columns and adds a few additional tables I oversaw in the last update.

[Genreless]

While merging schema 111's changes with mine, I found the following errors.

building_chains_tables has two version 0's and two version 1's. the second version 1 is identical to version 2

Removed schema still used by TW Rome 2

  <table table_name='cdir_military_generator_template_priorities_tables'
         table_version='0' >
    <field fkey='cdir_military_generator_configs_tables.key' name='config_key' type='string_ascii' pk='true' />
    <field name='priority' type='int' />
    <field fkey='cdir_military_generator_templates_tables.key' name='template_key' type='string_ascii' pk='true' />
  </table>

Removed schema still used by TW Warhammer:

Spoiler Alert, click show to read: 

  <table table_name='campaign_group_member_criteria_culture_settlement_occupation_options_tables'
         table_version='0' >
    <field name='unknown0' type='int' />
    <field name='-' type='int' />
    <field name='unknown2' type='string_ascii' />
  </table>
  <table table_name='cultures_subcultures_tables'
         table_version='1' >
    <field name='subculture' type='string_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' />
    <field name='unknown2' type='int' />
    <field name='unknown3' type='optstring_ascii' />
  </table>

The above, but with field names and keys updated where appropriate:

  <table table_name='campaign_group_member_criteria_culture_settlement_occupation_options_tables'
         table_version='2' >
    <field fkey='culture_settlement_occupation_options_tables.id'  name='culture_settlement_occupation_option' type='int' />
    <field name='-' type='int' />
    <field fkey='campaign_group_members_tables.id' name='member' type='string_ascii' pk='true' />
  </table>
  <table table_name='cultures_subcultures_tables'
         table_version='3' >
    <field name='subculture' type='string_ascii' pk='true' />
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' />
    <field name='index' type='int' />
    <field name='audio_state' type='optstring_ascii' />
  </table>

Removed schema still used by Empire Total War and Napoleon Total War

  <table table_name='models_artilleries_tables'
         table_version='0' >
    <field name='artillery_id' type='string' pk='true' />
    <field name='model_file' type='string' />
    <field name='unknown3' type='float' />
    <field name='unknown4' type='int' />
    <field name='unknown5' type='float' />
    <field name='unknown6' type='float' />
    <field name='unknown7' type='boolean' />
    <field name='unknown8' type='float' />
    <field name='unknown9' type='float' />
    <field name='unknown10' type='float' />
    <field name='unknown11' type='float' />
    <field name='unknown12' type='float' />
    <field name='unknown13' type='float' />
    <field name='unknown14' type='float' />
    <field name='unknown15' type='float' />
    <field name='unknown16' type='float' />
    <field name='unknown17' type='float' />
    <field name='unknown18' type='int' />
    <field name='unknown19' type='boolean' />
    <field name='unknown20' type='float' />
    <field name='unknown21' type='float' />
    <field name='unknown22' type='float' />
    <field name='unknown23' type='float' />
    <field name='unknown24' type='float' />
    <field name='unknown25' type='float' />
    <field name='unknown26' type='float' />
    <field name='unknown27' type='float' />
    <field name='unknown28' type='float' />
    <field name='unknown29' type='int' />
    <field name='unknown30' type='int' />
    <field name='unknown31' type='boolean' />
    <field name='unknown32' type='float' />
    <field name='unknown33' type='float' />
    <field name='unknown34' type='float' />
    <field name='unknown35' type='float' />
    <field name='unknown36' type='float' />
    <field name='unknown37' type='float' />
    <field name='unknown38' type='float' />
    <field name='unknown39' type='float' />
    <field name='unknown40' type='float' />
    <field name='unknown41' type='int' />
    <field name='unknown42' type='int' />
    <field name='unknown43' type='boolean' />
    <field name='unknown44' type='float' />
    <field name='unknown45' type='float' />
    <field name='unknown46' type='float' />
    <field name='unknown47' type='float' />
    <field name='unknown48' type='float' />
    <field name='unknown49' type='float' />
    <field name='unknown50' type='float' />
    <field name='unknown51' type='float' />
    <field name='unknown52' type='float' />
    <field name='unknown53' type='int' />
    <field name='unknown54' type='int' />
    <field name='unknown55' type='boolean' />
    <field name='unknown56' type='float' />
    <field name='unknown57' type='float' />
    <field name='unknown58' type='float' />
    <field name='unknown59' type='float' />
    <field name='unknown60' type='float' />
    <field name='unknown61' type='float' />
    <field name='unknown62' type='float' />
    <field name='unknown63' type='float' />
    <field name='unknown64' type='float' />
    <field name='unknown65' type='int' />
    <field name='unknown66' type='int' />
    <field name='unknown67' type='boolean' />
    <field name='unknown68' type='float' />
    <field name='unknown69' type='float' />
    <field name='unknown70' type='float' />
    <field name='unknown71' type='float' />
    <field name='unknown72' type='float' />
    <field name='unknown73' type='float' />
    <field name='unknown74' type='float' />
    <field name='unknown75' type='float' />
    <field name='unknown76' type='float' />
    <field name='unknown77' type='int' />
    <field name='unknown78' type='int' />
    <field name='unknown79' type='boolean' />
    <field name='unknown80' type='float' />
    <field name='unknown81' type='float' />
    <field name='unknown82' type='float' />
    <field name='unknown83' type='float' />
    <field name='unknown84' type='float' />
    <field name='unknown85' type='float' />
    <field name='unknown86' type='float' />
    <field name='unknown87' type='float' />
    <field name='unknown88' type='float' />
    <field name='unknown89' type='int' />
    <field name='unknown90' type='int' />
    <field name='unknown91' type='boolean' />
    <field name='unknown92' type='float' />
    <field name='unknown93' type='float' />
    <field name='unknown94' type='float' />
    <field name='unknown95' type='float' />
    <field name='unknown96' type='float' />
    <field name='unknown97' type='float' />
    <field name='unknown98' type='float' />
    <field name='unknown99' type='float' />
    <field name='unknown100' type='float' />
    <field name='unknown101' type='int' />
    <field name='unknown102' type='int' />
    <field name='unknown103' type='boolean' />
    <field name='unknown104' type='float' />
    <field name='unknown105' type='float' />
    <field name='unknown106' type='float' />
    <field name='unknown107' type='float' />
    <field name='unknown108' type='float' />
    <field name='unknown109' type='float' />
    <field name='unknown110' type='float' />
    <field name='unknown111' type='float' />
    <field name='unknown112' type='float' />
    <field name='unknown113' type='int' />
    <field name='unknown114' type='int' />
    <field name='unknown115' type='boolean' />
    <field name='unknown116' type='float' />
    <field name='unknown117' type='float' />
    <field name='unknown118' type='float' />
    <field name='unknown119' type='float' />
    <field name='unknown120' type='float' />
    <field name='unknown121' type='float' />
    <field name='unknown122' type='float' />
    <field name='unknown123' type='float' />
    <field name='unknown124' type='float' />
    <field name='unknown125' type='int' />
    <field name='unknown126' type='int' />
    <field name='unknown127' type='boolean' />
    <field name='unknown128' type='float' />
    <field name='unknown129' type='float' />
    <field name='unknown130' type='float' />
    <field name='unknown131' type='float' />
    <field name='unknown132' type='float' />
    <field name='unknown133' type='float' />
    <field name='unknown134' type='float' />
    <field name='unknown135' type='float' />
    <field name='unknown136' type='float' />
    <field name='unknown137' type='int' />
    <field name='unknown138' type='int' />
    <field name='unknown139' type='boolean' />
    <field name='unknown140' type='float' />
    <field name='unknown141' type='float' />
    <field name='unknown142' type='float' />
    <field name='unknown143' type='float' />
    <field name='unknown144' type='float' />
    <field name='unknown145' type='float' />
    <field name='unknown146' type='float' />
    <field name='unknown147' type='float' />
    <field name='unknown148' type='float' />
    <field name='unknown149' type='int' />
    <field name='unknown150' type='int' />
    <field name='unknown151' type='boolean' />
    <field name='unknown152' type='float' />
    <field name='unknown153' type='float' />
    <field name='unknown154' type='float' />
    <field name='unknown155' type='float' />
    <field name='unknown156' type='float' />
    <field name='unknown157' type='float' />
    <field name='unknown158' type='float' />
    <field name='unknown159' type='float' />
    <field name='unknown160' type='float' />
    <field name='unknown161' type='int' />
    <field name='unknown162' type='int' />
    <field name='unknown163' type='boolean' />
    <field name='unknown164' type='float' />
    <field name='unknown165' type='float' />
    <field name='unknown166' type='float' />
    <field name='unknown167' type='float' />
    <field name='unknown168' type='float' />
    <field name='unknown169' type='float' />
    <field name='unknown170' type='float' />
    <field name='unknown171' type='float' />
    <field name='unknown172' type='float' />
    <field name='unknown173' type='int' />
    <field name='unknown174' type='int' />
    <field name='unknown175' type='boolean' />
    <field name='unknown176' type='float' />
    <field name='unknown177' type='float' />
    <field name='unknown178' type='float' />
    <field name='unknown179' type='float' />
    <field name='unknown180' type='float' />
    <field name='unknown181' type='float' />
    <field name='unknown182' type='float' />
    <field name='unknown183' type='float' />
    <field name='unknown184' type='float' />
  </table>

Removed schema still used by Empire Total War and Total War Shogun 2

  <table table_name='models_artillery_tables'
         table_version='0' >
    <field name='artillery_id' type='string' pk='true' />
    <field name='model_file' type='string' />
    <field name='unknown3' type='float' />
    <field name='unknown4' type='int' />
    <field name='unknown5' type='float' />
    <field name='unknown6' type='float' />
    <field name='unknown7' type='boolean' />
    <field name='unknown8' type='float' />
    <field name='unknown9' type='float' />
    <field name='unknown10' type='float' />
    <field name='unknown11' type='float' />
    <field name='unknown12' type='float' />
    <field name='unknown13' type='float' />
    <field name='unknown14' type='float' />
    <field name='unknown15' type='float' />
    <field name='unknown16' type='float' />
    <field name='unknown17' type='float' />
    <field name='unknown18' type='int' />
    <field name='unknown19' type='boolean' />
    <field name='unknown20' type='float' />
    <field name='unknown21' type='float' />
    <field name='unknown22' type='float' />
    <field name='unknown23' type='float' />
    <field name='unknown24' type='float' />
    <field name='unknown25' type='float' />
    <field name='unknown26' type='float' />
    <field name='unknown27' type='float' />
    <field name='unknown28' type='float' />
    <field name='unknown29' type='int' />
    <field name='unknown30' type='int' />
    <field name='unknown31' type='boolean' />
    <field name='unknown32' type='float' />
    <field name='unknown33' type='float' />
    <field name='unknown34' type='float' />
    <field name='unknown35' type='float' />
    <field name='unknown36' type='float' />
    <field name='unknown37' type='float' />
    <field name='unknown38' type='float' />
    <field name='unknown39' type='float' />
    <field name='unknown40' type='float' />
    <field name='unknown41' type='int' />
    <field name='unknown42' type='int' />
    <field name='unknown43' type='boolean' />
    <field name='unknown44' type='float' />
    <field name='unknown45' type='float' />
    <field name='unknown46' type='float' />
    <field name='unknown47' type='float' />
    <field name='unknown48' type='float' />
    <field name='unknown49' type='float' />
    <field name='unknown50' type='float' />
    <field name='unknown51' type='float' />
    <field name='unknown52' type='float' />
    <field name='unknown53' type='int' />
    <field name='unknown54' type='int' />
    <field name='unknown55' type='boolean' />
    <field name='unknown56' type='float' />
    <field name='unknown57' type='float' />
    <field name='unknown58' type='float' />
    <field name='unknown59' type='float' />
    <field name='unknown60' type='float' />
    <field name='unknown61' type='float' />
    <field name='unknown62' type='float' />
    <field name='unknown63' type='float' />
    <field name='unknown64' type='float' />
    <field name='unknown65' type='int' />
    <field name='unknown66' type='int' />
    <field name='unknown67' type='boolean' />
    <field name='unknown68' type='float' />
    <field name='unknown69' type='float' />
    <field name='unknown70' type='float' />
    <field name='unknown71' type='float' />
    <field name='unknown72' type='float' />
    <field name='unknown73' type='float' />
    <field name='unknown74' type='float' />
    <field name='unknown75' type='float' />
    <field name='unknown76' type='float' />
    <field name='unknown77' type='int' />
    <field name='unknown78' type='int' />
    <field name='unknown79' type='boolean' />
    <field name='unknown80' type='float' />
    <field name='unknown81' type='float' />
    <field name='unknown82' type='float' />
    <field name='unknown83' type='float' />
    <field name='unknown84' type='float' />
    <field name='unknown85' type='float' />
    <field name='unknown86' type='float' />
    <field name='unknown87' type='float' />
    <field name='unknown88' type='float' />
    <field name='unknown89' type='int' />
    <field name='unknown90' type='int' />
    <field name='unknown91' type='boolean' />
    <field name='unknown92' type='float' />
    <field name='unknown93' type='float' />
    <field name='unknown94' type='float' />
    <field name='unknown95' type='float' />
    <field name='unknown96' type='float' />
    <field name='unknown97' type='float' />
    <field name='unknown98' type='float' />
    <field name='unknown99' type='float' />
    <field name='unknown100' type='float' />
    <field name='unknown101' type='int' />
    <field name='unknown102' type='int' />
    <field name='unknown103' type='boolean' />
    <field name='unknown104' type='float' />
    <field name='unknown105' type='float' />
    <field name='unknown106' type='float' />
    <field name='unknown107' type='float' />
    <field name='unknown108' type='float' />
    <field name='unknown109' type='float' />
    <field name='unknown110' type='float' />
    <field name='unknown111' type='float' />
    <field name='unknown112' type='float' />
    <field name='unknown113' type='int' />
    <field name='unknown114' type='int' />
    <field name='unknown115' type='boolean' />
    <field name='unknown116' type='float' />
    <field name='unknown117' type='float' />
    <field name='unknown118' type='float' />
    <field name='unknown119' type='float' />
    <field name='unknown120' type='float' />
    <field name='unknown121' type='float' />
    <field name='unknown122' type='float' />
    <field name='unknown123' type='float' />
    <field name='unknown124' type='float' />
    <field name='unknown125' type='int' />
    <field name='unknown126' type='int' />
    <field name='unknown127' type='boolean' />
    <field name='unknown128' type='float' />
    <field name='unknown129' type='float' />
    <field name='unknown130' type='float' />
    <field name='unknown131' type='float' />
    <field name='unknown132' type='float' />
    <field name='unknown133' type='float' />
    <field name='unknown134' type='float' />
    <field name='unknown135' type='float' />
    <field name='unknown136' type='float' />
    <field name='unknown137' type='int' />
    <field name='unknown138' type='int' />
    <field name='unknown139' type='boolean' />
    <field name='unknown140' type='float' />
    <field name='unknown141' type='float' />
    <field name='unknown142' type='float' />
    <field name='unknown143' type='float' />
    <field name='unknown144' type='float' />
    <field name='unknown145' type='float' />
    <field name='unknown146' type='float' />
    <field name='unknown147' type='float' />
    <field name='unknown148' type='float' />
    <field name='unknown149' type='int' />
    <field name='unknown150' type='int' />
    <field name='unknown151' type='boolean' />
    <field name='unknown152' type='float' />
    <field name='unknown153' type='float' />
    <field name='unknown154' type='float' />
    <field name='unknown155' type='float' />
    <field name='unknown156' type='float' />
    <field name='unknown157' type='float' />
    <field name='unknown158' type='float' />
    <field name='unknown159' type='float' />
    <field name='unknown160' type='float' />
    <field name='unknown161' type='int' />
    <field name='unknown162' type='int' />
    <field name='unknown163' type='boolean' />
    <field name='unknown164' type='float' />
    <field name='unknown165' type='float' />
    <field name='unknown166' type='float' />
    <field name='unknown167' type='float' />
    <field name='unknown168' type='float' />
    <field name='unknown169' type='float' />
    <field name='unknown170' type='float' />
    <field name='unknown171' type='float' />
    <field name='unknown172' type='float' />
    <field name='unknown173' type='int' />
    <field name='unknown174' type='int' />
    <field name='unknown175' type='boolean' />
    <field name='unknown176' type='float' />
    <field name='unknown177' type='float' />
    <field name='unknown178' type='float' />
    <field name='unknown179' type='float' />
    <field name='unknown180' type='float' />
    <field name='unknown181' type='float' />
    <field name='unknown182' type='float' />
    <field name='unknown183' type='float' />
    <field name='unknown184' type='float' />
  </table>

[Larynja]

Just released version 112 which fixes some entries for older games that got overwritten accidentally by the latest update.

While merging schema 111's changes with mine, I found the following errors.

Thanks. That only happens, if more than one game uses the same table version. If I update it for the latest game, and that didn't get a new table version, than it will replace that entry.

Removed schema still used by TW Warhammer:
<table table_name='campaign_group_member_criteria_culture_settlement_occupation_options_tables'
table_version='2' >
<table table_name='cultures_subcultures_tables'
table_version='3' >

Where did you get the table numbers for that? TW1 only uses version number 0 for the first and 1 for the second table.

Removed schema still used by Empire Total War and Napoleon Total War

<table table_name='models_artillery_tables'
table_version='0' >

It's still in there.

[Genreless]

Where did you get the table numbers for that? TW1 only uses version number 0 for the first and 1 for the second table.

I'm in the habit of incrementing version numbers and leaving the old version when I change table schema in case the old schema is still used by a different game or for backward compatibility with old mods. I got into this habit back when I first learned to decode schema by watching Magnar's tutorials and was under the impression that was standard practice, though looking back at his video the statement he made may have been a bit ambiguous about whether that was typical.

It's still in there.

If you're referring to models_artilleries_tables, and not models_artillery_tables, I also missed that difference in the middle of the table name initially. If you're referring to models_artillery_tables, then there were two version 0's of that table, one started with a string_ascii, which remained, and the other starting with a string, which was removed.

[Larynja]

I'm in the habit of incrementing version numbers and leaving the old version when I change table schema in case the old schema is still used by a different game or for backward compatibility with old mods.

If that would work that way, it would be really great to prevent the errors that occured through my latest update. But the table version for a table is fix. You can see which is the highest version a game supports in the maxversion file for the specific game. If a new table is released with a higher table version than the one in the maxversion file pfm will display the table in yellow. If you then use the decode tool to update the schema it will create a new entry with the updated table number. PFM can create the maxversion files automatically from the game files.
And because that is the case, if two games use the same schema with the same table number, when one of them gets updated without a change in the table number, the schema for both games get replaced.

If you're referring to models_artilleries_tables, and not models_artillery_tables, I also missed that difference in the middle of the table name initially. If you're referring to models_artillery_tables, then there were two version 0's of that table, one started with a string_ascii, which remained, and the other starting with a string, which was removed.

Hmm, I didn't notice the difference. I'll check that. Thanks.

[minininja2121]

-Warhammer 2
Does anyone have an updated main_units Schema? I can't seem to get it to open up at all in PFM. Any help would be amazing, thanx.

[Larynja]

-Warhammer 2
Does anyone have an updated main_units Schema? I can't seem to get it to open up at all in PFM. Any help would be amazing, thanx.

Main units table works without problems with any of the new schemas.

[minininja2121]

Main units table works without problems with any of the new schemas.

OK I see where I went wrong, I downloaded the most current and it just downloaded PFM 5.0 again not the updated schema. Thank you, sorry for the confusion.

[Matmannen]

I got a bit frustraded by the display tables for phases and special abilities weren't completed, so I went ahead and fixed them. Now, you can see all manner of cool things that can be done with special ability displays in battle.

<table table_name='special_ability_phase_displays_tables'
         table_version='0' >
    <field name='active_vfx' type='boolean' />
    <field name='banner_vfx' type='optstring_ascii' />
    <field name='entity_vfx' type='optstring_ascii' />
    <field name='key' type='string_ascii' pk='true' />
  </table>

<table table_name='special_ability_displays_tables'
         table_version='0' >
    <field name='sa_display_key' type='string_ascii' pk='true' />
    <field name='wind_up_aura_vfx' type='optstring_ascii' />
    <field name='wind_up_weapon_vfx' type='optstring_ascii' />
  </table>

[gdwitt]

Is anyone else getting this error:
Everytime I try to run PFM for an Attila mod, I get this popup:

"Update failed:
Could not determine latest versions: got ,
at PackFileManager.SourceforgeVersionRetriever..ctor(Boolean
findBeta)
at PackFileManager.DBFileTypesUpdate..ctor(Boolean
findBetaSchema)
at PackFileManager.PackFileManagerFrom.TryUpdate(Boolean
showSuccess, String currentPackFile)"

[Aexrael]

agent_culture_details from TWW2 cannot be opened in PFM.

[DarkPhoenixx]

Table "ancillaries_tables" does not contain fields for name and description of the ancillaries. Is there a way to edit them?

[Steph]

It's in the localization file probably

[DarkPhoenixx]

It's in the localization file probably

Ah, yea its int the "text" catalogue. I wrongfully assumed that table have same structure as "ancillaries". Thanks!