land_units

**Magnar** · September 07, 2013, 06:42 PM

So i was trying to do a schema for land_units and here is as far as i've gotten.

Unfortunately it doesnt work with pfm

so if anyone can tell me what im doing wrong itd be much appreciated

I also couldnt find the battle_animation_table this refers to although jack provided it in the db he put up.

Code:

<table table_name='land_units_tables'
         table_version='0'
         guid='3da64ea8-f4d4-48f8-9e31-2197383841f1'>
    <field name='ability_global_recharge' type='boolean' />
    <field name='accuracy' type='int' />
    <field name='ammo' type='string_ascii' />
    <field fkey='unit_armour_types_tables.key' name='armour' type='string_ascii' />
    <field fkey='unit_attributes_groups_tables.group_name' name='attribute_group' type='string_ascii' />
    <field name='bonus_hit_points' type='int' />
    <field name='campaign_action_points' type='int' />
    <field fkey='unit_category_tables.key' name='category' type='string_ascii' />
    <field name='charge_bonus' type='int' />
    <field fkey='unit_class_tables.key' name='class' type='string_ascii' />
    <field name='dismounted_charge_bonus' type='int' />
    <field name='dismounted_melee_attack' type='int' />
    <field name='dismounted_melee_defence' type='int' />
    <field name='gameplay_description_text' type='string_ascii' />
    <field name='hiding_scalar' type='float' />
    <field name='historical_description_text' type='string_ascii' />
    <field name='is_male' type='boolean' />
    <field name='key' type='string_ascii' />
    <field name='loose_spacing' type='boolean' />
    <field fkey='batle_animations_table.key' name='man_animation' type='string_ascii' />
    <field fkey='battle_entities_tables.key' name='man_entity' type='string_ascii' />
    <field name='melee_attack' type='int' />
    <field name='melee_defence' type='int' />
    <field name='morale' type='int' />
    <field fkey='mounts_tables.key' name='mount' type='string_ascii' />
    <field name='num_animals' type='int' />
    <field name='num_chariots' type='int' />
    <field name='num_guns' type='int' />
    <field name='num_mounts' type='int' />
    <field fkey='land_units_officers_tables.key' name='officers' type='string_ascii' />
    <field name='onscreen_name' type='string_ascii' />
    <field fkey='melee_weapons_tables.key' name='primary_melee_weapon' type='string_ascii' />
    <field fkey='missile_weapons_tables.key' name='primary_missile_weapon' type='string_ascii' />
    <field name='rank_depth' type='int' />
    <field name='reload' type='int' />
    <field fkey='audio_vo_selected_switches_tables.key' name='selected_vo_secondary' type='string_ascii' />
    <field fkey='audio_vo_selected_switches_tables.key' name='selected_vo_tertiary' type='string_ascii' />
    <field fkey='audio_vo_selected_switches_tables.key' name='selection_vo' type='string_ascii' />
    <field fkey='unit_shield_types_tables.key' name='shield' type='string_ascii' />
    <field fkey='unit_description_sort_texts_tables.key' name='short_description_text' type='string_ascii' />
    <field fkey='unit_spacings_tables.key' name='spacing' type='string_ascii' />
    <field name='spot_dist_scrub' type='int' />
    <field name='spot_dist_tree' type='int' />
    <field fkey='spotting_and_hiding_values_tables.key' name='spotting_and_hiding' type='string_ascii' />
    <field fkey='unit_description_strengths_weaknesses_texts_tables.key' name='strengths_weaknesses_text' type='string_ascii' />
    <field name='supports_first_person' type='boolean' />
    <field fkey='unit_training_level_enum_tables.key'name='training_level' type='string_ascii' />
    <field name='visibility_spotting_range_max' type='int' />
    <field name='visibility_spotting_range_min' type='int' />
  </table>