Tool Customlang Table Schema (tool_customlang)


Description

Contains the working checkout of all strings and their customization

tool_customlang table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
lang VARCHAR 20

The code of the language this string belongs to. Like en, cs or es

componentid BIGINT 19 null
tool_customlang_components.id toolcust_com2_fk R

The id of the component

stringid VARCHAR 255

The identifier of the string

original LONGTEXT 2147483647 null

English original of the string

master LONGTEXT 2147483647 null

Master translation of the string as is distributed in the official lang pack, null if not translated

local LONGTEXT 2147483647 null

Local customization of the string, null if not customized

timemodified BIGINT 19 null

The timestamp of when the original or master was recently modified

timecustomized BIGINT 19 null

The timestamp of when the value of the local translation was recently modified, null if not customized yet

outdated SMALLINT 5 0

Either the English original or the master translation changed and the customization may be outdated

modified SMALLINT 5 0

Has the string been modified via the translator?

Table contained -1 rows

tool_customlang table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolcust_com_ix Performance Asc componentid
toolcust_lancomstr_uix Must be unique Asc/Asc/Asc lang + componentid + stringid

tool_customlang table relationships