Table languages

• Introduction
• Resources | Standards

• Database
• Schema

• Developers API
• Resources | Overrides |
• Tutorials

• Modules
• Overview | Payment |
• Shipping | Order Total

• Miscellaneous
• Security | XML Schemas |
• Porting modules from osC | Manually entering products

Database Version

1.3.5

Description

Stores all the configured settings for the languages which are set up, thus enabling multi-language support. Details are used to determine which language-file directory is used to provide defined text content on each page, and to provide information needed to build language-selection menus, etc.

Table Details

Primary Key

languages_id

Indexed Fields

name

Columns

languages_id

A unique, auto incremented value, to identify each languages record.

Type:	int(11)
Null:	No
Default:
Extra:	auto_increment

name

The name of the language.

Type:	varchar(32)
Null:	No
Default:

code

The two character code of the language, used mostly in matching with server/browser-related responses to language-support checks, as well as for building the sideboxes which allow the customer to select their preferred language. Typically an ISO code for the language.

Type:	char(2)
Null:	No
Default:

image

The name of the language icon image.

Type:	varchar(64)
Null:	Yes
Default:	NULL

directory

The default directory for the specific language files.

Type:	varchar(32)
Null:	Yes
Default:	NULL

sort_order

The sort order of the language.

Type:	int(3)
Null:	Yes
Default:	NULL

Default Entries

languages_id:	1
name:	English
code:	en
image:	icon.gif
directory:	english
sort_order:	1