PFM Schema Update Thread

**Larynja** · January 13, 2018, 06:52 AM

Originally Posted by Aexrael

If you get a chance, could you correct the following tables for the next schema update for TWW2 please.

Added to my to-do list

Originally Posted by Vandy

Hey Larynja! Been working on something in the battle_set_pieces tables, and noticed every column was labeled as "unknown". 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.

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.

**Aexrael** · January 16, 2018, 07:43 AM

Originally Posted by Larynja

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.

**Funktasticmo** · January 25, 2018, 08:57 PM

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** · January 26, 2018, 08:05 AM

Originally Posted by 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.

Tomb Kings update now available as schema_108.

**Funktasticmo** · January 26, 2018, 04:46 PM

Originally Posted by Larynja

Tomb Kings update now available as schema_108.

cheers

**Aexrael** · February 14, 2018, 08:00 AM

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

**Morticia Iunia Bruti** · March 07, 2018, 10:28 AM

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

Updated Schemata. Can someone update them for PFM please?

**Dresden** · March 08, 2018, 04:18 PM

New Rome 2 schema files

Code:

 <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** · March 16, 2018, 09:57 AM

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

**BLuBMuZ** · March 26, 2018, 08:19 AM

Click image for larger version.

Name: 2018-03-26.png
Views: 23
Size: 8.2 KB
ID: 351875

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!

**SpardaSon21** · March 26, 2018, 07:26 PM

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** · April 03, 2018, 08:05 AM

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** · April 06, 2018, 11:50 AM

Originally Posted by 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.

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.

Originally Posted by 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.

I'll look into it.

**Bogdanov89** · April 07, 2018, 12:48 AM

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** · April 07, 2018, 11:13 AM

Originally Posted by 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?

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.

**agnes69** · April 23, 2018, 03:33 AM

Originally Posted by Larynja

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!

**HebridesH2O** · April 25, 2018, 02:15 AM

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.

**Dresden** · May 06, 2018, 03:44 PM

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

Code:

<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>