DB/TerrainType

0.5.3.3368, 1.12.1.5875

struct TerrainTypeRec {
  uint32_t m_TerrainID;
  stringrefⁱ m_TerrainDesc;
  uint32_t m_FootstepSprayRun;
  uint32_t m_FootstepSprayWalk;
  uint32_t m_SoundID;
  uint32_t m_Flags;        // &:1 Show footprints UnitFootprintNewSplat
};

Structure

Column 	Field 		Type 		Notes 
1 	ID 		Integer 	
2 	TerrainDesc 	String 		Type of ground 
3 	FootstepSprayRun 	Integer 	
4 	FootstepSprayWalk 	Integer 	
5 	Sound 		Integer 	Sound. Yes, this IS used. 
6 	Flags	 	Bool 		I guess, its footsteps or something as Sand and Snow have it.

6.0.1.18179

struct TerrainTypeRec {
  uint8_t padding_0[4];
  uint32_t m_TerrainID;
  stringrefⁱ m_TerrainDesc;
  foreign_keyⁱ<uint32_t, &SpellVisualEffectNameRec::m_ID> m_FootstepSprayRun;
  foreign_keyⁱ<uint32_t, &SpellVisualEffectNameRec::m_ID> m_FootstepSprayWalk;
  foreign_keyⁱ<uint32_t, &TerrainTypeSoundsRec::m_ID> m_SoundID;
  enum
  {
    flag_have_footsteps = 1,
    flag_show_footprint_spray = 2,    // ?
  };
  uint32_t m_Flags;
};