Originally Posted by
steelblade
I must be missing something =S
the line: <field name='onscreen_name_override' type='optstring_ascii' /> is missing,
The column you're looking for is in the .loc files, in local_en.pack. There are multiple tooltip columns which are shown by dave as belonging to a specific table, but they are exported into a .loc file, not into the db file.
And a little update to the main_units schema. Columns unknown44-47 are an integer, column name is "food_cost". The other new names are includes below.
Code:
<table table_name='main_units_tables'
table_version='33' >
<field name='additional_building_requirement' 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='recruitment_movie' type='optstring_ascii' />
<field name='religion_requirement' type='optstring_ascii' />
<field name='unit' type='string_ascii' pk='true' />
<field name='upkeep_cost' type='int' />
<field fkey='unit_weights_tables.key' name='weight' type='optstring_ascii' />
<field name='resource_requirement' type='optstring_ascii' />
<field name='world_leader_only' type='boolean' />
<field name='can_trade' type='boolean' />
<field name='special_edition_mask' type='int' />
<field name='unique_index' type='int' />
<field name='unknown25' type='int' />
<field name='in_encyclopedia' type='boolean' />
<field name='region_unit_resource_requirement' type='optstring_ascii' />
<field name='audio_voiceover_culture' type='string_ascii' />
<field name='ui_unit_group_land' type='string_ascii' />
<field name='ui_unit_group_naval' type='string_ascii' />
<field name='tier' type='int' />
<field name='is_high_threat' type='boolean' />
<field name='porthole_camera' type='string_ascii' />
<field name='mount' type='optstring_ascii' />
<field name='use_hitpoints_in_campaign' type='boolean' />
<field name='unit_scaling' type='boolean' />
<field name='prthole_composite_scene' type='optstring_ascii' />
<field name='melee_cp' type='float' />
<field name='missile_cp' type='float' />
<field name='can_siege' type='boolean' />
<field name='audio_voiceover_culture_override' type='string_ascii' />
<field name='restrict_xp_gain_in_campaign' type='boolean' />
<field name='audio_voiceover_actor_group' type='string_ascii' />
<field name='unknown44' type='boolean' />
<field name='unknown45' type='boolean' />
<field name='unknown46' type='boolean' />
<field name='unknown47' type='boolean' />
<field name='has_spoken_vo' type='boolean' />
<field name='is_monstrous' type='boolean' />
</table>