PFM Schema Update Thread

[Genreless]

Thanks, I missed that when I went through the schemas because Empire's 'agents_tables' uses a different version in its main.pack and one of its patch packs. TWC does let you edit posts but you have to have 25 posts and your account has to be at least a week old before it lets you.

[Swiss Halberdier]

@Genreless
Huge thanks again to you for all your hard work on the PFM updates!

[Tukog]

Thanks, I missed that when I went through the schemas because Empire's 'agents_tables' uses a different version in its main.pack and one of its patch packs. TWC does let you edit posts but you have to have 25 posts and your account has to be at least a week old before it lets you.

Ah, well I am missing the 25 posts. Usually only post when I have info to share. Thanks for your work.

[Genreless]

Schema 123 is out now; The following has changed: a new version of "agents_tables" for Empire that was missed in the last check has been added, a correction to the keys in "cdir_events_mission_option_junctions_tables" for pre-Rome 2 was made, a column in "missions_tables" for pre-Shogun 2 has been temporarily identified, and the max version number for "avatar_ranks_tables" for Shogun 2 has been corrected. Thanks to Tukog for identifying the missing table version and sorry for the delay in uploading corrections.

[Genreless]

Schema 124 is out now. It corrects all the obvious errors in the Warhammer 2 schemas. There are also corrections to the max_versions files and a few typo corrections for other games. You can either manually download it from the SourceForge page or the autoupdater should work if you have it enabled. I am now going to start confirming the completeness of the Thrones of Britannia schemas which should take me about a week based on how long the Warhammer 2 schemas took.

[Genreless]

Schema 125 is now out. It corrects all obvious schema errors in Thrones of Britannia and a few columns that had their names reversed in Warhammer 2. With this I have checked the schemas for all Total War games supported by PFM and fixed probably 98% of the flawed schemas. The remaining flawed schemas I either can't obtain a reference table for, require manual verification of the tables (Empire and Napoleon only), were accidentally mislabeled, or lack the signs of an obvious flawed schema that I tend to look for. The next schema I release the majority of the contents of will come when I eventually get a copy of Three Kingdoms' Assembly Kit or when I write a script to check table references in the existing schemas (which is a lower priority than fixing bugs so it won't happen for a long time). Other than that, the next schema will probably be community contributed corrections to existing schemas or dependent on the community contributing schemas for Three Kingdoms since I probably won't be picking it up immediately.

[Genreless]

Schema 126 is now out. It addresses all red tables from the newest Warhammer 2 patch along with all the schema that CA listed as changed. I'll do a more thorough pass to make sure nothing was missed soon but hopefully that was everything.

[Genreless]

Schema 127 is out now. It features some schemas contributed by the community for Three Kingdoms and revised by me where possible to label the columns. It should automatically download for those who have the auto-updater enabled. I will also continue working on more schema updates for Three Kingdoms since a community member gave me a decent reference for many of the most critical Three Kingdoms tables. I will try to get out at least one schema update a day until all the tables at least open but I don't think I will get much done Saturday since my family already had plans. As always, further community schema contributions are greatly appreciated and thanks to those who have already contributed.

[Genreless]

Schema 128 is out now. It's a bit sloppier than usual since I copied in a lot of community contributions at the end without time to verify them, but it shouldn't be noticeable to most users (other than more unknown columns). Thanks to Guinden and WakelessREX who have been doing a lot to contribute to getting the Three Kingdoms schemas decoded!

[Genreless]

Schema 129 is out. It is a fairly minor update compared to 128. It decodes a few more tables and names columns in some, but not all, tables from 128.

[Genreless]

Schema 130 is out now. It features another ~350 lines of community contributed schemas, all the tables I've had specifically requested, and more labeled columns.

[Genreless]

Schema 131 is out now. The changes are as follows:

New Table Schemas:

Spoiler Alert, click show to read: 

• battlefield_buildings_tables
• custom_battle_characters_to_loadouts_tables
• custom_battle_loadouts_tables
• custom_battle_loadout_challenge_levels_tables
• ceo_sets_tables
• custom_battle_loadouts_to_ceos_tables
• ceos_to_equipment_variants_tables
• ceo_to_ui_display_junctions_tables
• custom_battle_loadouts_to_skills_tables
• campaign_character_arts_tables
• campaign_character_animation_sets_tables
• campaign_character_animation_set_overrides_to_ceos_junctions_tables
• campaign_character_animation_set_overrides_tables
• names_tables
• frontend_faction_leaders_tables
• videos_tables
• frontend_faction_leader_unique_characters_tables

Revised Table Schemas:
special_ability_phases_tables (Three Kingdoms and Warhammer 2)

Relabeled Table Schemas:

Spoiler Alert, click show to read: 

• custom_battle_characters_tables
• ceo_set_items_tables

[Genreless]

Schema 132 is out now. The changes are as follows:

New Table Schemas:

Spoiler Alert, click show to read: 

• custom_battle_loadouts_to_unit_sets_tables
• custom_battle_unit_sets_tables
• cdir_events_incident_option_junctions_tables
• cdir_events_options_tables
• cdir_events_targets_tables
• cdir_events_incident_payloads_tables
• cdir_events_incident_post_generation_condition_junctions_tables
• cdir_events_option_sets_tables
• cdir_events_post_generation_conditions_tables
• custom_battle_settings_tables
• custom_battle_settlement_building_groups_tables
• custom_battle_settlement_building_groups_to_buildings_tables
• custom_battle_unit_sets_to_units_tables
• character_assignments_tables
• character_assignment_constraint_sets_tables
• character_assignment_constraint_set_required_ceos_tables
• character_assignment_constraint_set_required_skill_levels_tables
• technologies_tables
• character_assignment_constraint_set_required_technologies_tables
• character_assignment_effects_tables

Re-labeled Tables:

• building_slot_groups_tables

[Drai]

Hi all. For 3Kingdoms is anyone able to add an AP cost to march stance? I did it for in Warhammer2 using the table effect_bundles_to_effects_junctions_tables, and adding an ap cost of 100. That worked fine in that game but when I do something similar in 3K it is not working at all. It doesn't even realize I added the AP cost at all.

Is the table messed up or is there something else I will have to do to make it work in this one?

[Genreless]

The campaign_stances tables look fine. Effect_bundles_to_effects_junctions_tables also looks fine. It's possible that CA changed the variables you can use but I don't have the time to look into that since I need to spend time decoding tables rather than helping people figure out the data needed to make their own mods right now.

[TWBenedict]

<table table_name='cdir_events_dilemma_option_junctions_tables'
table_version='0' >
<field fkey='dilemmas_tables.key' name='dilemma_key' type='string_ascii' />
<field name='id' type='int' pk='true' />
<field name='-' type='int' />
<field fkey='cdir_events_dilemma_options_tables.option_key' name='option_key' type='string_ascii' />
<field name='value' type='optstring_ascii' />
<field name='unknown5' type='string_ascii' />
</table>

[Swiss Halberdier]

@Genreless
I got a small column-label addition suggestion for Three Kingdoms which I found out from my in-game-testing.

DB table: main_units_tables
column: unknown47

It could be probably called "campaign_unit_recruitment_strength".

The vanilla base value for Generals and Heroes is 1, which means 100% unit recruitment strength in the campaign.
The vanilla base value for all other units is 0.2, which means 20% unit recruitment strength in the campaign.

[TWBenedict]

<table table_name='cdir_events_dilemma_post_generation_condition_juntions_tables'
table_version='1' >
<field name='unknown0' type='string_ascii' />
<field name='unknown1' type='string_ascii' />
<field name='unknown2' type='float' />
<field name='unknown3' type='int' />
<field name='unknown4' type='string_ascii' />
<field name='unknown5' type='string_ascii' />
<field name='unknown6' type='string_ascii' />
<field name='unknown7' type='string_ascii' />
</table>




<table table_name='cdir_events_dilemma_choice_details_tables'
table_version='1' >
<field name='unknown0' type='string_ascii' />
<field name='unknown1' type='string_ascii' />
<field name='unknown2' type='boolean' />
<field name='unknown3' type='optstring_ascii' />
</table>


<table table_name='campaign_progression_levels_tables'
table_version='0' >
<field name='unknown0' type='string_ascii' />
<field name='unknown1' type='string_ascii' />
</table>


<table table_name='campaign_rounds_tables'
table_version='4' >
<field name='unknown0' type='string_ascii' />
<field name='unknown1' type='int' />
<field name='unknown2' type='string_ascii' />
<field name='unknown3' type='string_ascii' />
</table>


<table table_name='campaign_progression_level_group_progression_levels_tables'
table_version='0' >
<field name='unknown0' type='int' />
<field name='unknown1' type='int' />
<field name='unknown2' type='string_ascii' />
<field name='unknown3' type='string_ascii' />
</table>


<table table_name='ccp_benchmark_units_tables'
table_version='0' >
<field name='unknown0' type='string_ascii' />
<field name='unknown1' type='string_ascii' />
</table>


<table table_name='cdir_configs_tables'
table_version='0' >
<field name='unknown0' type='string_ascii' />
<field name='unknown1' type='string_ascii' />
<field name='unknown2' type='int' />
</table>


<table table_name='cdir_events_mission_post_generation_condition_junctions_tables'
table_version='2' >
<field name='unknown0' type='string_ascii' />
<field name='unknown1' type='int' />
<field name='unknown2' type='int' />
<field name='unknown3' 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' />
</table>

[Genreless]

Schema 133 is out now! Thanks to TWBenedict and Swiss Halberdier for their contributions to the schemas! The changes are as follows:

Community Contributed Schemas:

Spoiler Alert, click show to read: 

• cdir_events_mission_post_generation_condition_junctions_tables
• cdir_configs_tables
• ccp_benchmark_units_tables
• campaign_progression_level_group_progression_levels_tables
• campaign_rounds_tables
• campaign_progression_levels_tables
• cdir_events_dilemma_choice_details_tables
• cdir_events_dilemma_post_generation_condition_juntions_tables
• cdir_events_dilemma_option_junctions_tables

New Tables:

Spoiler Alert, click show to read: 

• campaign_post_battle_effects_tables
• campaign_post_battle_captive_options_tables
• campaign_group_post_battle_casualty_resources_tables
• campaign_group_post_battle_result_resources_tables
• pooled_resources_tables
• campaign_group_pooled_resources_tables
• cdir_events_mission_payloads_tables
• retinue_slot_initial_units_tables
• cdir_events_mission_option_junctions_tables
• campaign_group_character_actions_tables
• campaign_payloads_tables
• character_attribute_sets_tables
• character_attribute_types_tables

Re-Labeled Tables:

Spoiler Alert, click show to read: 

• retinue_templates_tables
• retinue_types_tables
• retinues_tables
• main_units_tables
• effect_bundles_tables
• character_attributes_tables

[Havie]

First decode,
easy one.
Gonna get at it tmrw

<table table_name='effect_bonus_value_campaign_territory_type_record_junctions_tables'
table_version='0' >
<field name='effect' type='string_ascii' />
<field name='unknown1' type='string_ascii' />
<field name='unknown2' type='string_ascii' />
</table>