PFM Schema Update Thread

[Aexrael]

Added to my to-do list



Thanks, I'll integrate it into the next update.
The columns are shown in the order the data is read out. I don't think there is an easy way to adjust that in PFM as of now.

The tables I posted above may not be in the correct order then, I wrote it down in the order they appeared in DAVE, worth keeping in mind if or when you correct their names!

Can you also please have a look at the table mp_force_gen_templates, seems to be missing entirely when reading the data.pack with PFM. Thanks.

[Vandy]

Hey Larynja! Been working on something in the battle_set_pieces tables, and noticed every column was labeled as "unknown". So I took it upon myself to rename them, using data_core in PFM and DaVE to make sure everything matched perfectly. I have my updated master_schema here: https://drive.google.com/open?id=1OL...qvgaahWxj6UdSw ; Column 4032 - 4208 field names have been adjusted to their DaVE equivalent

Most of the columns are also in a weird order compared to their placement in DaVE. Notably, battle_set_pieces_tables, battle_set_piece_armies_tables, and battle_set_piece_armies_characters_tables.

[Funktasticmo]

Tomb Kings DLC Update broke a few tables in the DB. specifically one i use is technologies_nodes_tables hope you can get the schemata all tidied up soon.

[Larynja]

Tomb Kings DLC Update broke a few tables in the DB. specifically one i use is technologies_nodes_tables hope you can get the schemata all tidied up soon.

Tomb Kings update now available as schema_108.

[Funktasticmo]

Tomb Kings update now available as schema_108.

cheers

[Aexrael]

cdir_events_dilemma_payloads_tables seems to trigger an error when trying to view it in PFM.

[Morticia Iunia Bruti]

https://forums.totalwar.com/discussi...rmation#latest

Updated Schemata. Can someone update them for PFM please?

[Dresden]

New Rome 2 schema files

 <table table_name='political_parties_tables'         
           table_version='5' >
    <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='red' type='float' />
    <field name='green' type='float' />
    <field name='blue' type='float' />
    <field name='unknown8' type='optstring_ascii' />
    <field name='unknown9' type='optstring_ascii' />
  </table>
  <table table_name='culture_subculture_politics_government_types_tables'
         table_version='4' >
    <field name='unknown0' type='string_ascii' />
    <field name='unknown1' type='string_ascii' />
    <field name='unknown2' type='boolean' />
    <field name='unknown3' type='string_ascii' />
    <field name='unknown4' type='string_ascii' />
    <field name='unknown5' type='optstring_ascii' />
    <field name='unknown6' type='optstring_ascii' />
    <field name='unknown7' type='boolean' />
    <field name='unknown8' type='string_ascii' />
    <field name='unknown9' type='optstring_ascii' />
    <field name='unknown10' type='string_ascii' />
  </table>
  <table table_name='cursus_honorum_trait_junctions_tables'
         table_version='2' >
    <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 name='unknown3' type='optstring_ascii' />
  </table>
  <table table_name='female_character_culture_details_tables'
         table_version='1' >
    <field name='spawn_chance' type='int' />
    <field name='culture' type='string_ascii' />
    <field name='general' type='string_ascii' />
    <field name='public_office' type='string_ascii' />
    <field name='missions' type='string_ascii' />
    <field name='trait' type='optstring_ascii' />
  </table>
  <table table_name='female_character_faction_details_tables'
         table_version='0' >
    <field name='spawn_chance' type='int' />
    <field name='faction' type='string_ascii' />
    <field name='general' type='optstring_ascii' />
    <field name='public_office' type='optstring_ascii' />
    <field name='missions' type='optstring_ascii' />
    <field name='trait' type='optstring_ascii' />
  </table>
  <table table_name='female_character_subculture_details_tables'
         table_version='1' >
    <field name='spawn_chance' type='int' />
    <field name='general' type='optstring_ascii' />
    <field name='public_office' type='optstring_ascii' />
    <field name='missions' type='optstring_ascii' />
    <field name='subculture' type='string_ascii' />
    <field name='trait' type='optstring_ascii' />
  </table>
  <table table_name='ancillaries_tables'
         table_version='10' >
    <field name='key' type='string_ascii' />
    <field 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='unknown9' type='optstring_ascii' />
    <field name='unknown10' type='optstring_ascii' />
    <field name='unknown11' type='optstring_ascii' />
    <field name='unknown12' type='optstring_ascii' />
    <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 name='spouse_subculture' type='optstring_ascii' />
  </table>
  <table table_name='historical_characters_tables'
         table_version='7' >
    <field name='key' type='string_ascii' />
    <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 name='surname' type='optstring_ascii' />
    <field name='art_set' type='optstring_ascii' />
    <field name='clan_name' type='optstring_ascii' />
    <field name='other_name' type='optstring_ascii' />
    <field name='political_party' type='optstring_ascii' />
    <field name='age_start' type='int' />
  </table>

[Larynja]

Thanks Dresden. Have been ill for the past two weeks, so I really appreciate your help

[BLuBMuZ]

Hi all, my PFM gives errors looking for schemas. Here a screenie.
In Rome 2, after the last patch, some tables are red.
Thanks for your efforts!

[HebridesH2O]

Uninstalled, reinstalled, redownloaded, etc etc a dozen times, get this error every time. My changes appear to be saved in PFM, but don't appear in game. I am using Schema version 109.

[SpardaSon21]

If schema are still being developed for Shogun 2, can the misc_hits and misc_armor column entries be added for unit_stats_naval? Those entries reflect the armor thickness and durability of the turrets on the Roanoke model.

[BLuBMuZ]

Again on tables: all the ones related to female characters are red or blue.
Playing as Seleucids i have some women in my families, but i cannot recruit them as generals, while i see female generals in eastern and Egypt factions.

[Larynja]

Again on tables: all the ones related to female characters are red or blue.
Playing as Seleucids i have some women in my families, but i cannot recruit them as generals, while i see female generals in eastern and Egypt factions.

Dresden had already provided an update for that some time ago. I released it as Schema Version 109 today.
Regarding the auto-update feature, so far I have no idea why it's not working. Please download the schema manually.

If schema are still being developed for Shogun 2, can the misc_hits and misc_armor column entries be added for unit_stats_naval? Those entries reflect the armor thickness and durability of the turrets on the Roanoke model.

I'll look into it.

[agnes69]

Dresden had already provided an update for that some time ago. I released it as Schema Version 109 today.
Regarding the auto-update feature, so far I have no idea why it's not working. Please download the schema manually.

Thanks!

[Bogdanov89]

Thank you for working on this.

But could you please make a VERY simple explanation for us noobs on how to actually "install" (folder structure) the latest schema into Pack File Manager?

[Larynja]

Thank you for working on this.

But could you please make a VERY simple explanation for us noobs on how to actually "install" (folder structure) the latest schema into Pack File Manager?

Easiest way to do it, is to put the downloaded schema.zip in the main PFM folder, and extract it (with 7-Zip for example) directly into that folder. It will overwrite the necessary files.

[Dresden]

New Thrones schema - some of these are from Magnar so thanks to him!

<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='index' type='int' />
    <field fkey='battle_terrain_farms_tables.farm' name='farm' type='string_ascii' />
    <field name='unknown4' type='string_ascii' />
  </table>
   <table table_name='culture_settlement_occupation_options_tables'
         table_version='7' >
    <field fkey='cultures_tables.key' name='culture' type='string_ascii' pk='true' />
    <field name='unknown1' type='optstring_ascii' />
    <field name='unknown2' type='int' />
    <field name='unknown3' type='optstring_ascii' />
    <field name='unknown4' type='int' />
    <field name='unknown5' type='string_ascii' />
    <field name='unknown6' type='optstring_ascii' />
    <field name='unknown7' type='int' />
    <field name='unknown8' type='int' />
    <field name='unknown9' type='int' />
  </table>
    <table table_name='building_chains_tables'
         table_version='3' >
    <field name='unknown0' type='string_ascii' />
    <field name='unknown1' type='optstring_ascii' />
    <field name='unknown2' type='optstring_ascii' />
    <field name='unknown3' type='optstring_ascii' />
    <field name='unknown4' type='boolean' />
    <field name='unknown5' type='optstring_ascii' />
    <field name='unknown6' type='int' />
    <field name='unknown7' type='int' />
    <field name='unknown8' type='int' />
  </table>
<table table_name='campaign_group_faction_leader_gravitas_effects_tables'
         table_version='0' >
    <field name='unknown0' type='string_ascii' />
    <field name='unknown1' type='string_ascii' />
  </table>




  <table table_name='rebel_settlement_occupation_options_tables'
         table_version='0' >
    <field name='unknown0' type='int' />
    <field name='unknown1' type='string_ascii' />
    <field name='unknown2' type='string_ascii' />
    <field name='unknown3' type='int' />
    <field name='unknown4' type='boolean' />
    <field name='unknown5' type='boolean' />
    <field name='unknown6' type='boolean' />
    <field name='unknown7' type='int' />
  </table>




  <table table_name='technologies_tables'
         table_version='6' >
    <field name='unknown0' type='string_ascii' />
    <field name='unknown1' type='string_ascii' />
    <field name='unknown2' type='int' />
    <field name='unknown3' type='int' />
    <field name='unknown4' type='string_ascii' />
    <field name='unknown5' type='int' />
    <field name='unknown6' type='int' />
    <field name='unknown7' type='int' />
    <field name='unknown8' type='int' />
    <field name='unknown9' type='boolean' />
    <field name='unknown10' type='boolean' />
    <field name='unknown11' type='string_ascii' />
    <field name='unknown12' type='boolean' />
    <field name='unknown13' type='boolean' />
    <field name='unknown14' type='boolean' />
    <field name='unknown15' type='boolean' />
    <field name='unknown16' type='int' />
    <field name='unknown17' type='boolean' />
    <field name='unknown18' type='boolean' />
    <field name='unknown19' type='boolean' />
    <field name='unknown20' type='boolean' />
    <field name='unknown21' type='boolean' />
    <field name='unknown22' type='boolean' />
    <field name='unknown23' type='boolean' />
    <field name='unknown24' type='boolean' />
    <field name='unknown25' type='string_ascii' />
  </table>
    <table table_name='effects_tables'
         table_version='3' >
    <field name='unknown0' type='string_ascii' />
    <field name='unknown1' type='optstring_ascii' />
    <field name='unknown2' type='int' />
    <field name='unknown3' type='optstring_ascii' />
    <field name='unknown4' type='boolean' />
  </table>

[Swiss Halberdier]

New Thrones schema - some of these are from Magnar so thanks to him!

Thanks a lot to Dresden and Magnar!

Recently I saw this official post by CA on their forums. Maybe this could also be helpful.

https://forums.totalwar.com/discussi...schema-changes

[Dresden]

I made a post for ToB schema here http://www.twcenter.net/forums/showthread.php?782244