As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page.

Help:Language Names table

From OmegaWiki
Jump to: navigation, search
Help:Index Database layout Language Names table



The Language Names table contains the names of the languages in several languages. A script contained in a special page takes data from OmegaWiki itself to fill this table.

+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| language_id      | int(10)      | NO   | PRI | 0       |       | 
| name_language_id | int(10)      | NO   | PRI | 0       |       | 
| language_name    | varchar(255) | YES  |     | NULL    |       | 
+------------------+--------------+------+-----+---------+-------+

Fields[edit]

language_id 
The id of the language that is translated (cf. Help:Language table)
name_language_id 
The id of the language in which the language_id language is translated.
language_name 
The name of the language language_id translated in name_language_id. If language_id is 85 (English) and name_language_id is 86 (French), then language_name is "anglais".

Sample MySQL queries[edit]

Retrieving all the language names in English[edit]

select language_id, language_name from language_names where name_language_id = 85 ;