https://bugzilla.wikimedia.org/show_bug.cgi?id=58792

       Web browser: ---
            Bug ID: 58792
           Summary: Provide toolserver.language table
           Product: Wikimedia Labs
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: tools
          Assignee: m...@uberbox.org
          Reporter: valhall...@arctus.nl
                CC: benap...@gmail.com, t...@tim-landscheidt.de
    Classification: Unclassified
   Mobile Platform: ---

The toolserver provides the following table:

mysql> describe language;
+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| lang         | varchar(16)  | NO   | PRI | NULL    |       |
| english_name | varchar(255) | YES  |     | NULL    |       |
| native_name  | varchar(255) | YES  |     | NULL    |       |
+--------------+--------------+------+-----+---------+-------+

mysql> select * from language order by rand() limit 10;
+------+--------------+------------------+
| lang | english_name | native_name      |
+------+--------------+------------------+
| cjp  | Cabécar     | NULL             |
| kks  | Giiwo        | NULL             |
| mqc  | Mangole      | NULL             |
| gby  | Gbari        | NULL             |
| kw   | Cornish      | Kernewek         |
| na   | Nauruan      | Ekakairũ Naoero |
| ymd  | Muda         | NULL             |
| npa  | Nar Phu      | NULL             |
| waa  | Walla Walla  | NULL             |
| hss  | Harsusi      | NULL             |
+------+--------------+------------------+
10 rows in set (0.00 sec)



This could also be integrated with meta_p.wiki, by providing a 'language' and
'native_language' column.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to