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

Close relationships within degrees of separation