Help:Language Names table

↑ 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

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

Retrieving all the language names in English

select language_id, language_name from language_names where name_language_id = 85 ;