Welcome

Please register for Total War Access to use the forums. If you're an existing user, your forum details will be merged with Total War Access if you register with the same email or username. For more information please read our FAQ’s here.

Categories

Thrones of Britannia - Modding info/Schema changes

CA_EricCA_Eric Posts: 207Registered Users, CA Staff
A Total War Saga: Thrones of Britannia
database modification changelog


==============================================================
New Tables
==============================================================
audio_vo_actors
audio_vo_factions
cai_task_management_system_task_generator_group_overrides
campaign_group_faction_leader_gravitas_effects
rebel_settlement_occupation_options
start_pos_character_estates
start_pos_character_skills
start_pos_governors

==============================================================
Tables with modified records
==============================================================
TExc_ImplementedTables
TExc_LocalisableFields
_kv_fire_values
_kv_morale
_kv_naval_rules
_kv_rules
achievements
advice_info_texts
advice_levels
advice_threads
advice_trigger_to_advice_thread
advice_triggers
advisors
agent_actions
agent_culture_details
agent_localisations
agent_to_agent_attributes
agent_uniforms
aide_de_camp_speeches
ancillaries
ancillary_included_subcultures
ancillary_info
ancillary_to_included_agents
ancillary_trigger_effects
ancillary_triggers
armed_citizenry_unit_groups
armed_citizenry_units_to_unit_groups_junctions
audio_campaign_building_enums
audio_projectiles
audio_vo_selected_switches
audio_voiceover_cultures
battle_animations_table
battle_cameras
battle_entities
battle_personalities
battle_skeletons
battle_types
battlefield_buildings
battlefield_civilian_amounts
battlefield_civilian_group_variations
battlefield_civilian_type_civilian_group_junctions
battlefield_deployable_siege_items
battlefield_engines
battlefield_siege_vehicles
battlefield_siege_vehicles_custom_battles
battles
building_chain_availabilities
building_chain_availability_set_ids
building_chain_availability_sets
building_chains
building_culture_variants
building_description_texts
building_downgrade_junctions
building_effects_junction
building_flavour_texts
building_instances
building_level_armed_citizenry_junctions
building_level_required_technology_junctions
building_levels
building_requirement_group_junctions
building_requirement_groups
building_set_to_building_junctions
building_sets
building_short_description_texts
building_superchains
building_units_allowed
building_upgrades_junction
cai_construction_system_building_values
cai_construction_system_categories
cai_construction_system_category_groups
cai_construction_system_province_template_assignment_policies
cai_construction_system_strategic_context_template_policies
cai_construction_system_strategic_context_template_policy_junctions
cai_construction_system_synergies
cai_construction_system_synergy_levels
cai_construction_system_synergy_policies
cai_construction_system_template_assignment_schemes
cai_construction_system_templates
cai_construction_system_templates_junctions
cai_diplomacy_complex_treacheries
cai_military_aggressiveness_policies
cai_personalities
cai_personalities_budget_allocation_policy_junctions
cai_personalities_budget_allocations
cai_personalities_budget_policies
cai_personalities_construction_system_policies
cai_personalities_income_allocation_policies
cai_personalities_income_allocation_policy_strategic_context_junctions
cai_personalities_income_allocations
cai_personalities_reliability_policies
cai_personalities_task_management_system_task_generator_profiles
cai_personalities_tms_task_generator_profile_faction_statuses_junctions
cai_personality_cultural_components
cai_personality_cultural_relations_overrides
cai_personality_deal_evaluation_component_overrides
cai_personality_deal_evaluation_components
cai_personality_deal_evaluation_deal_component_values
cai_personality_deal_generation_components
cai_personality_deal_generation_generator_priorities
cai_personality_diplomatic_component_overrides
cai_personality_diplomatic_components
cai_personality_diplomatic_event_values
cai_personality_diplomatic_treaty_values
cai_personality_empire_rivalry_components
cai_personality_group_junctions
cai_personality_group_overrides
cai_personality_groups
cai_personality_negotiation_components
cai_personality_occupation_decision_components
cai_personality_occupation_decision_priorities
cai_personality_religious_components
cai_personality_strategic_components
cai_personality_strategic_desired_attitudes
cai_personality_strategic_resource_values
cai_task_management_system_task_generator_groups
cai_task_management_system_task_generator_groups_generators_junctions
cai_variables
cai_variables_overides
campaign_ai_character_skill_tree_manager_agent_junctions
campaign_ai_technology_manager_path_junctions
campaign_ai_technology_managers
campaign_ai_technology_path_junctions
campaign_ai_technology_paths
campaign_autoresolver_mod_group_modifier_values
campaign_battle_presets
campaign_bonus_value_battle_context_battle_type_junctions
campaign_bonus_value_battle_context_faction_junctions
campaign_bonus_value_battle_context_religion_junctions
campaign_bonus_value_battle_context_specifiers
campaign_bonus_value_ids_basic
campaign_bonus_value_ids_building_chain
campaign_bonus_value_ids_building_sets
campaign_bonus_value_ids_unit_sets
campaign_character_art_sets
campaign_character_art_sets_campaign_groups
campaign_character_art_sets_group_junctions
campaign_character_arts
campaign_character_attribute_effects
campaign_climate_change_phases
campaign_cultural_relations
campaign_difficulty_handicap_effects
campaign_effect_scope_to_category_junctions
campaign_effect_scopes
campaign_ground_types
campaign_group_member_criteria_campaigns
campaign_group_member_criteria_diplomatic_attitudes
campaign_group_member_criteria_diplomatic_stances
campaign_group_member_criteria_factions
campaign_group_member_criteria_subcultures
campaign_group_member_criteria_values
campaign_group_members
campaign_groups
campaign_localised_strings
campaign_map_attrition_damages
campaign_map_attrition_faction_immunities
campaign_map_attritions
campaign_map_playable_areas
campaign_map_regions
campaign_map_roads
campaign_map_settlements
campaign_map_tooltip_texts
campaign_map_tooltips
campaign_maps
campaign_mp_coop_groups
campaign_mp_coop_groups_to_factions
campaign_payload_ui_details
campaign_religious_relations
campaign_settlement_display_building_ids
campaign_settlement_display_building_model_ids
campaign_settlement_display_buildings
campaign_stance_effects_junctions
campaign_statistics_strings
campaign_unit_stat_bonuses
campaign_variables
campaigns
cdir_events_dilemma_choice_details
cdir_events_dilemma_followup_dilemmas
cdir_events_dilemma_followup_missions
cdir_events_dilemma_incidents
cdir_events_dilemma_option_junctions
cdir_events_dilemma_payloads
cdir_events_incident_followup_dilemmas
cdir_events_incident_followup_incidents
cdir_events_incident_option_junctions
cdir_events_incident_payloads
cdir_events_mission_incidents
cdir_events_mission_issuer_junctions
cdir_events_mission_option_junctions
cdir_events_mission_options
cdir_events_mission_payloads
cdir_events_options
cdir_events_payloads
cdir_military_generator_configs
cdir_military_generator_template_priorities
cdir_military_generator_template_ratios
cdir_military_generator_templates
cdir_military_generator_unit_qualities
character_experience_skill_tiers
character_skill_level_details
character_skill_level_to_effects_junctions
character_skill_node_links
character_skill_node_sets
character_skill_nodes
character_skills
character_trait_levels
character_traits
commander_unit_permissions
commodities
culture_settlement_occupation_options
cultures
cultures_subcultures
cursors
deployables
dilemmas
diplomacy_keys
diplomacy_negotiation_string_options
diplomacy_strings
diplomatic_action_subculture_restrictions
diplomatic_relations_religion
effect_bonus_value_agent_action_record_junctions
effect_bonus_value_agent_junction
effect_bonus_value_attrition_record_junctions
effect_bonus_value_basic_junction
effect_bonus_value_battle_context_junctions
effect_bonus_value_building_chain_junctions
effect_bonus_value_building_set_junctions
effect_bonus_value_ids_unit_sets
effect_bonus_value_religion_junction
effect_bonus_value_resource_junction
effect_bonus_value_siege_item_junctions
effect_bonus_value_subculture_junctions
effect_bonus_value_unit_category_junction
effect_bonus_value_unit_class_junction
effect_bundles
effect_bundles_to_effects_junctions
effects
encyclopedia_tutorial_video_subtitles
encyclopedia_tutorial_videos
event_feed_categories
event_feed_events
event_feed_message_events
event_feed_strings
event_feed_subcategories
event_feed_summary_events
event_feed_targeted_events
experience_triggers
faction_banners
faction_civil_war_setups
faction_groups
faction_political_parties_junctions
faction_rebellion_units_junctions
faction_to_faction_groups_junctions
faction_to_mercenary_set_junctions
faction_uniform_colours
factions
fame_levels
fertility_levels
fonts
formations
formations_to_subcultures
frontend_faction_leaders
general_command_star_level_effects
groupings_military
incidents
land_units
land_units_officers
land_units_to_unit_abilites_junctions
languages
loyalty_factors
main_units
melee_weapons
mercenary_pool_modifiers
mercenary_pool_to_groups_junctions
mercenary_pools
mercenary_unit_groups
military_force_legacy_emblems
military_force_legacy_names
ministerial_positions
ministerial_positions_culture_details
ministerial_positions_strings
ministerial_positions_to_character_effects
ministerial_positions_to_effects
missile_weapons
missile_weapons_to_projectiles
mission_text
mission_types
missions
models_building
mounts
movie_event_strings
mp_force_gen_template_junctions
mp_force_gen_templates
name_orders
names
names_groups
naval_units
political_actions
political_actions_dilemma_junctions
political_actions_incidents_junctions
political_parties
political_parties_power_effect_bundles
projectiles
provinces
provincial_initiative_records
provincial_initiatives_to_subculture_junctions
quotes
quotes_people
random_localisation_strings
region_to_province_junctions
region_unit_resources
regions
religions
resources
resources_to_campaign_junctions
settlement_occupation_options
ship_dbs
shortcut_localisation
slot_template_to_building_superchain_junctions
slot_templates
special_ability_groups
special_ability_groups_to_unit_abilities_junctions
special_ability_phase_stat_effects
special_ability_phases
special_ability_to_invalid_usage_flags
start_pos_calendars
start_pos_character_to_settlements
start_pos_character_traits
start_pos_characters
start_pos_diplomacy
start_pos_factions
start_pos_family_relationships
start_pos_land_units
start_pos_past_events
start_pos_region_religions
start_pos_region_slot_templates
start_pos_regions
start_pos_regions_to_unit_resources
start_pos_settlements
start_pos_victory_conditions
subculture_religion_voiceover_junctions
subtitle_timings
taxes_effects_jct
taxes_levels
technologies
technology_effects_junction
technology_node_links
technology_node_sets
technology_nodes
technology_required_building_levels_junctions
technology_unit_upgrades
trade_display_trade_models
trait_categories
trait_info
trait_level_effects
trait_to_antitraits
trait_to_included_agents
trait_triggers
translated_texts
trigger_effects
trigger_events
ui_component_localisation
ui_unit_groupings
ui_unit_stat_to_classes
ui_unit_stats
uied_component_addresses_to_texts
uied_component_texts
uied_text_layouts
unit_abilities
unit_armour_types
unit_attributes
unit_attributes_groups
unit_attributes_to_groups_junctions
unit_description_historical_texts
unit_description_short_texts
unit_experience_bonuses
unit_experience_thresholds
unit_required_technology_junctions
unit_set_to_unit_junctions
unit_sets
unit_shield_types
unit_spacings
unit_special_abilities
unit_variants
unit_variants_ships
unit_weights
units_custom_battle_permissions
units_to_exclusive_faction_permissions
units_to_groupings_military_permissions
variants
victory_type_links
victory_types
videos
vo_fmv_texts
vo_scripts
vo_speech_texts
vo_texts

==============================================================
Tables with modified schema
==============================================================
audio_vo_actors
audio_vo_factions
building_chains
cai_task_management_system_task_generator_group_overrides
campaign_group_faction_leader_gravitas_effects
culture_settlement_occupation_options
cultures_subcultures
effects
factions
frontend_faction_leaders
ministerial_positions_to_character_effects
ministerial_positions_to_effects
political_actions
rebel_settlement_occupation_options
start_pos_character_estates
start_pos_character_skills
start_pos_characters
start_pos_governors
technologies

==============================================================
Modified schemas:
==============================================================

<!-- modified table (only the modification is shown) -->
<table table_name='ministerial_positions_to_character_effects' >
  <field name='regent' type='int' />
</table>

<!-- new table -->
<table table_name='start_pos_character_skills' >
  <field fkey='start_pos_characters.ID' name='id' type='int' pk='true' /> <!-- character id -->
  <field fkey='character_skills.key' name='skill' type='string_ascii' pk='true' /> <!-- skill id -->
  <field name='level' type='int' /> <!-- level
 -->
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='ministerial_positions_to_effects' >
  <field name='regent' type='int' />
</table>

<!-- new table -->
<table table_name='audio_vo_factions' >
  <field name='key' type='string_ascii' pk='true' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='start_pos_characters' >
  <field name='xp' type='int' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='political_actions' >
  <field name='maximum_cost' type='float' />
</table>

<!-- new table -->
<table table_name='rebel_settlement_occupation_options' >
  <field fkey='campaign_groups.id' name='group' type='string_ascii' pk='true' />
  <field fkey='settlement_occupation_options.key' name='option' type='string_ascii' pk='true' />
  <field fkey='effect_bundles.key' name='target_settlement_faction_effect_bundle' type='string_ascii' />
  <field name='target_settlement_faction_effect_bundle_turns' type='int' />
  <field name='action_points' type='int' />
  <field name='region_squalor_modifier' type='int' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='building_chains' >
  <field name='colour_b' type='int' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='cultures_subcultures' >
  <field name='voiceover' type='string_ascii' />
</table>

<!-- new table -->
<table table_name='campaign_group_faction_leader_gravitas_effects' >
  <field fkey='campaign_groups.id' name='campaign_group' type='string_ascii' pk='true' />
  <field fkey='effect_bundles.key' name='effect_bundle' type='string_ascii' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='culture_settlement_occupation_options' >
  <field name='region_squalor_modifier' type='int' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='effects' >
  <field name='tooltip' type='optstring_ascii' />
</table>

<!-- new table -->
<table table_name='start_pos_character_estates' >
  <field fkey='start_pos_characters.ID' name='character' type='string_ascii' pk='true' />
  <field fkey='regions.key' name='region' type='string_ascii' pk='true' />
  <field name='number' type='int' />
</table>

<!-- new table -->
<table table_name='audio_vo_actors' >
  <field name='key' type='string_ascii' pk='true' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='technologies' >
  <field name='locked_tooltip_progress_key' type='optstring_ascii' /> <!-- Uses this key as a progress in locked tooltips from 
 -->
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='factions' >
  <field name='voiceover_leader_actor' type='string_ascii' />
</table>

<!-- new table -->
<table table_name='start_pos_governors' >
  <field fkey='start_pos_characters.ID' name='character' type='string_ascii' pk='true' />
  <field fkey='provinces.key' name='province' type='string_ascii' />
</table>

<!-- modified table (only the modification is shown) -->
<table table_name='frontend_faction_leaders' >
  <field name='name' type='unknown' />
</table>

<!-- new table -->
<table table_name='cai_task_management_system_task_generator_group_overrides' >
  <field fkey='cai_task_management_system_task_generator_groups.key' name='task_generator_group' type='string_ascii' pk='true' />
  <field fkey='cai_task_management_system_task_generator_groups.key' name='parent_task_generator_group' type='optstring_ascii' />
</table>
==============================================================
Additional schema changes:
==============================================================
start_pos_character_skills.id.field_type: 2 -> 7
frontend_faction_leaders.name.field_type: 8 -> 2
Project Development Director

FORMAL DISCLAIMER: Any views or opinions expressed here are those of the poster and do not necessarily represent the views or opinions of The Creative Assembly or SEGA.

Comments

Sign In or Register to comment.