PFM Main_Units_table containing Auxiliary column

[GrudgeNL]

A column that appeared to be missing in the PFM master_schema. All I did was adding the auxilia entries through TWeak, convert the table by using BOB and importing + decoding it in PFM. Here's the result for the master_schema to make main_units_tables have the auxiliary column in PFM.

<table table_name='main_units_tables'         table_version='17' >
    <field name='additional_building_required' 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='unknown15' type='optstring_ascii' />
    <field name='religion_required' type='optstring_ascii' />
    <field name='unit' type='string_ascii' />
    <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 name='unknown21' type='boolean' />
    <field name='unknown22' type='boolean' />
    <field name='unknown23' type='boolean' />
    <field name='unknown24' type='boolean' />
    <field name='unknown25' type='boolean' />
    <field name='unknown26' type='boolean' />
    <field name='unknown27' type='boolean' />
    <field name='unknown28' type='boolean' />
    <field name='unknown29' type='boolean' />
    <field name='unique_index' type='int' />
    <field name='special_edition_mask' type='int' />
    <field name='in_encyclopedia' type='boolean' />
    <field name='region_unit_resource_requirement' type='optstring_ascii' />
    <field name='voiceover' type='string_ascii' />
    <field name='ui_unit_group_land' type='string_ascii' />
    <field name='ui_unit_group_naval' type='string_ascii' />
    <field name='tier_level' type='int' />   
</table>

<field name='region_unit_resource_requirement' type='optstring_ascii' /> is the Auxilia column.

[Swiss Halberdier]

Thanks a lot GrudgeNL! This is very helpful for all modders to create an AOR.

[GrudgeNL]

Thanks a lot GrudgeNL! This is very helpful for all modders to create an AOR.

No problem Not mentioned in the thread, the schema entry for main_units also has a religion_required and additional_building_required column, previously only known through the AK. I don't know if these two work, as I haven't tested it, but I am sure others will.

[Swiss Halberdier]

No problem Not mentioned in the thread, the schema entry for main_units also has a religion_required and additional_building_required column, previously only known through the AK. I don't know if these two work, as I haven't tested it, but I am sure others will.

Yes these two columns look like they work similar to the older TW games. But I didn't tried it yet.

I checked this addition to your new code for the main_units table:

<field name='unit' type='string_ascii' pk='true' />

If we add this pk='true' then the PFM can handle the Primary Key again and we can sort the table with the button "move and freeze key" again.