Skip to content

locales_item Table

Localized item names and descriptions.


Schema Summary

Field Type Key Null Default Extra
entry mediumint(8) unsigned PRI NO 0
name_loc1 varchar(100) NO ''
name_loc2 varchar(100) NO ''
name_loc3 varchar(100) NO ''
name_loc4 varchar(100) NO ''
name_loc5 varchar(100) NO ''
name_loc6 varchar(100) NO ''
name_loc7 varchar(100) NO ''
name_loc8 varchar(100) NO ''
description_loc1 varchar(255) YES
description_loc2 varchar(255) YES
description_loc3 varchar(255) YES
description_loc4 varchar(255) YES
description_loc5 varchar(255) YES
description_loc6 varchar(255) YES
description_loc7 varchar(255) YES
description_loc8 varchar(255) YES

Field Breakdown

  • entry - Primary Key. Item template entry. (see item_template.entry)
  • name_loc1 - Locale 1 text; empty falls back to the base column.
  • name_loc2 - Locale 2 text; empty falls back to the base column.
  • name_loc3 - Locale 3 text; empty falls back to the base column.
  • name_loc4 - Locale 4 text; empty falls back to the base column.
  • name_loc5 - Locale 5 text; empty falls back to the base column.
  • name_loc6 - Locale 6 text; empty falls back to the base column.
  • name_loc7 - Locale 7 text; empty falls back to the base column.
  • name_loc8 - Locale 8 text; empty falls back to the base column.
  • description_loc1 - Locale 1 text; empty falls back to the base column.
  • description_loc2 - Locale 2 text; empty falls back to the base column.
  • description_loc3 - Locale 3 text; empty falls back to the base column.
  • description_loc4 - Locale 4 text; empty falls back to the base column.
  • description_loc5 - Locale 5 text; empty falls back to the base column.
  • description_loc6 - Locale 6 text; empty falls back to the base column.
  • description_loc7 - Locale 7 text; empty falls back to the base column.
  • description_loc8 - Locale 8 text; empty falls back to the base column.